Data Architecture and Data Integration

Azure Data Specialist - Azure Synapse, Azure Data Factory, Azure Logic Apps, Azure Analysis Services, Azure Functions, Azure Power shell and Power BI

Worked as a consultant to build BI/Data Warehouse Solutions in both cloud and on-premise environment.3 Years of Experience in Azure technologies including Azure Data Factory, Power BI, Azure SQL Server, Azure SQL Data Warehouse. Managing all the database activities including design and development to Administration.Designing and developing various database objects including relational database tables and NO-SQL collections and documents. Expertise level knowledge in fine-tuning the SQL Server queries.Design and Develop operational and Analytical reports/dashboards using SSAS, SSRS, Power BI, Tableau and other reporting toolsExpertise in ETL using the SQL Server Integration Services. Managed various ETL packages to extract data from various sources and Load into the database/ data warehouse.Sound Knowledge in Master Data services and Data Quality services.Extensively worked using MongoDB, Neo4j, PostgreSQL and MySQL

Designed and developed the database /data warehouse objects using SQL server and MSBI tools.Optimization of SQL server objects performance and suggested best practices to implement the same.Mentored the team to develop and deliver the work on time with quality.Extensively worked on US Healthcare data's including claim, payer information, ICD 9 & 10, HCPCS, CPT, HL7, Co-Pay and Clinical data

Played the role of a BI/Data warehouse consultant.Create and manage SQL objects to streamline the data flow from various sources to the Enterprise Data warehouse system.Developed maintained, and managed all analytical and operational mission critical business reports based on the SOARIAN Financial Tool.Generated dashboards and scorecards using tableau based on soarian financial data to take better business decisionsWritten and executed complex T-SQL queries to extract and manipulate data based on the end user and business requirements.Developed and deployed multi dimensional OLAP cube database using SSAS and MDX.Create and maintain Soarian Financial reports and cubes for US Hospital finance departments by utilizing Crystal Report, SSAS, SSRS and SQL Server.Developed various SSIS packages to transfer and transform data based on the customer requirement.Extensive working knowledge in Soarian Financial modules such as Revenue Cycle, Contact Management, Claims , Patient Access and Master FilesWorking knowledge of CPC/HCPCS/ICD9/ICD10Experience and Understanding of EDI(837/835/824),HL7 and EHR enterprisesGood knowledge in US healthcare insurance payment process including claims data,co-pay etc.,Lead/Mentored team members to gain and improve knowledge in database/datawarehouse and US healthcare system

Suggested and implemented various Query optimization methods. Managed the Maintenance of Database objects,Statistics and IndexesWorked on database side to maintain the integrity of the database and written various scripts to extract reports for analysis purposeCreated objects using SQL Server 2000/05/08Generated various Operational and Analytical Reports using Crystal Report and Excel Generated and scheduled batch files to generate the necessary files and load data

Responsible for troubleshooting and problem solving of SQL development.To proactively monitor the database systems to ensure secure services with minimum downtime.Written and Reviewed VB6 and C# CodesPerformed different DBA activities like replication, mirroring, Performance Tuning, Log Shipping, Trouble shooting bottleneck, Providing server level security AND monitoringWorked on various databases such as Oracle, MS-Access, My-Sql and Sql ServerDeveloped and deployed the project individually and completed the same within time and quality