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.
- Clients: Wells Fargo, Barclays
- Project Name: CcaaS, Tech Refresh, BPFDWH
- Designed and developed new database schema objects such as tables, indexes, views, stored procedures, functions, triggers, jobs, etc.
- Altered, Created T-SQL complex queries involving multiple tables, Joins, Sub queries, Derived queries.
- Designed, developed, and optimize SQL queries, views, stored procedures, and functions and Table Variables.
- Created packages by testing and cleaning Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
- The packages and data mapping are extensively designed using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS
- Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
- Designed and implemented complex SSIS packages for extracting, transforming, and loading data from various sources such as relational databases (SQL Server, Oracle, DB2), flat files, and XML files.
- Developed ETL best practices, including error handling, logging, checkpoints, and data quality
- Written efficient SQL queries, stored procedures, functions, and triggers to support ETL processes.
- Optimize SSIS packages and SQL queries for maximum performance using techniques such as parallelization, lookup caching, and bulk loading.
- Enhanced and deploying the SSIS Packages from development server to production server.
- Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
- Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
- Granted the SSIS Catalog folder permissions of Active directory group, NT users, Shared Users.
- Used the SERVICE NOW application to maintain the Change Requests and C-Tasks for implementations.
- Created Credentials of proxy accounts, configured the references to run packages through proxy.
- Attend and meet with project managers regularly to review project deliverables and deadlines.
- Created SQL servers Agent jobs, scheduled, alerts, Notifications of Success/Failures/Completed.
- Project: Medical Group
- Involved in gathering requirements, functional requirements, and data specifications from onshore team.
- Maintained detailed tracker for each facility of medical group, updated with Onshore Teams regularly to review project deliverables and deadlines.
- Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed to track and improve customer units KPI by 12% within a month.
- Designed and developed Medical Group database with staging & master tables, Constraints, Functions, stored procedure, T-sql queries, Views, derived tables, temp tables, dynamic queries etc.,
- Automated the Medical Group Data from various sources to Database through SSIS Packages.
- Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Base using Attend and meets with project managers regularly to review project deliverables and deadlines.
- Experience in Error handling and debugging coding issues and troubleshooting production problems.
- Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, script component, union, merge, merge join etc.,
- Created Loggings, event handler, checkbox, breakpoints, error handling in SSIS packages.
- Worked closely with key stakeholders to complete a client requirement on time.
- Designed and developed the Provider & payer summaries on daily, weekly, monthly, yearly reports and Dashboard’s summaries through the SQL Server.
- Designed and developed Denials (Fresh & Non-Fresh) in SQL Server(T-SQL) for Daily basis for multiple projects.
- Coordinated and taken owner ship for day to deliverable to internal operational teams.
- Planed, designed, and executed standard Work order preparation on SQL Server and managing the day-to-day work orders inventory of multiple projects provided to the Operations team within TAT.
- Created Dashboard “AR Deep Drive Analysis” by using T-SQL, Functions, views, Stored procedures, Subqueries, CTE’s & Join’s for multiple reports mapping on monthly basis to the onshore team.
- Worked on SSIS Control Flow, Dataflow tasks, for each Loop, execute package/SQL tasks, connections of source and destinations, Row count, OLEDB command and lookup transformations, merge, merge join, data conversions & etc.
- Designed and developed stored procedures, queries, and views necessary to support SSRS reports.
- Worked on SSRS for Contract Analysis dashboard and CMM Inflow and Outflows Analysis report