Overall 9.6+ years of experience on MSBI role in the US Healthcare RCM (Hospitals, Insurance, and patient) worked with BI & Data Analytics teams on MS SQL Server 2014/2017/2019, ETL/SSIS, SSRS, Python and Tableau data visualizations. 7+ years of experience in MS SQL Server. 6+ years of experience in SSIS/ETL Expert in resolving the performance issue of SSIS packages. 2+ years of experience in Azure ETL stack (Blog Storage, Data Lake,Data Factory, Synapse). Collaboration: Work closely with .NET/API development teams to ensure seamless integration between application and database layers. Data Integrity: Developed and implemented strategies to maintain data consistency during modernization efforts and migrations. Agile Participation: Actively participated in Agile/Scrum ceremonies, including sprint planning, backlog grooming, and code reviews. Documentation: Maintained clear and comprehensive documentation of data pipelines, data models, and data integration processes. Maintenance of time allocation reports. ETL & Data Integration: Design and implement SSIS packages for data movement, transformations, and automation. Data Migration: Oversee database migration projects, including on premises to cloud transitions and cloud to cloud transitions, data conversion, and validation processes. Azure Data Factory (ADF): Build and manage data pipelines, integrating various data sources and orchestrating ETL workflows in cloud environments Reporting & Business Intelligence: Developed SSRS reports and leverage Tableau for creating interactive dashboards and data visualizations. In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL. Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility. Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using Tableau. Ensure data integrity, security, and compliance standards are maintained across all environments. Collaborated with business and technical teams to identify project needs, estimate tasks, and set intermediate milestones to achieve final outcomes Lead and contribute to the development of data pipelines, ETL processes, and data integration solutions, ensuring the smooth extraction, transformation, and loading of data from diverse sources Assisted in database design, normalization, and data modeling activities. Participated in code reviews, providing constructive feedback to ensure code quality.
Overall 9.6+ years of experience on MSBI role in the US Healthcare RCM (Hospitals, Insurance, and patient) worked with BI & Data Analytics teams on MS SQL Server 2014/2017/2019, ETL/SSIS, SSRS, Python and Tableau data visualizations. 7+ years of experience in MS SQL Server. 6+ years of experience in SSIS/ETL Expert in resolving the performance issue of SSIS packages. 2+ years of experience in Azure ETL stack (Blog Storage, Data Lake,Data Factory, Synapse). Collaboration: Work closely with .NET/API development teams to ensure seamless integration between application and database layers. Data Integrity: Developed and implemented strategies to maintain data consistency during modernization efforts and migrations. Agile Participation: Actively participated in Agile/Scrum ceremonies, including sprint planning, backlog grooming, and code reviews. Documentation: Maintained clear and comprehensive documentation of data pipelines, data models, and data integration processes. Maintenance of time allocation reports. ETL & Data Integration: Design and implement SSIS packages for data movement, transformations, and automation. Data Migration: Oversee database migration projects, including on premises to cloud transitions and cloud to cloud transitions, data conversion, and validation processes. Azure Data Factory (ADF): Build and manage data pipelines, integrating various data sources and orchestrating ETL workflows in cloud environments Reporting & Business Intelligence: Developed SSRS reports and leverage Tableau for creating interactive dashboards and data visualizations. In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL. Well versed in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using BCP, Bulk Insert & DTS utility. Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using Tableau. Ensure data integrity, security, and compliance standards are maintained across all environments. Collaborated with business and technical teams to identify project needs, estimate tasks, and set intermediate milestones to achieve final outcomes Lead and contribute to the development of data pipelines, ETL processes, and data integration solutions, ensuring the smooth extraction, transformation, and loading of data from diverse sources Assisted in database design, normalization, and data modeling activities. Participated in code reviews, providing constructive feedback to ensure code quality.