• Completed setting-up of a cloud-based data warehouse for one of the Fortune 500 companies.• Prepared complete architecture and system design used for data warehouse set-up.• Managed the implementation of the physical design using cloud-based applications.• Used Azure Cloud, Azure Databricks, PySpark and Spark SQL to build the Lake House for client.• Managed data integration from 40+ different data vendors into Lake House. • Handled operation support for data ingestion… Show more • Completed setting-up of a cloud-based data warehouse for one of the Fortune 500 companies.• Prepared complete architecture and system design used for data warehouse set-up.• Managed the implementation of the physical design using cloud-based applications.• Used Azure Cloud, Azure Databricks, PySpark and Spark SQL to build the Lake House for client.• Managed data integration from 40+ different data vendors into Lake House. • Handled operation support for data ingestion pipelines on a regular basis.• Designed the system to capture the data observations, anomalies, health, and quality issues. • Build the templates to create knowledge repositories for new data sources onboarded in Lake House.• Ensured to build data understanding documents, validation rules, and quality reports for each data source.• Gained experience on how Benefit Programs work in Health Care space viz. Medical, Dental, Vision, EAP, Disability (Short Term, Long Term), etc.• Handled dashboard development and its maintenance using Power BI application for various Benefit Programs.• Designed and managed PHI, PII, and HIPPA-compliant data security and governance protocols.• Drive business meetings for requirement gathering and sharing progress updates on a weekly basis.• Got experience in stakeholder management, team management, project management, vendor management, etc.• Managed a team of 10-12 people for project delivery and operation support. Show less

• Handled data migration and reports/dashboard migration projects.• Completed report migration sourced from INVISION System to STAR System.• Handled report migration sourced from Lawson ERP to PeopleSoft ERP system.• Managed report/dashboard migration from INFOR BI to Qlik Sense platform.• Handled new dashboard development in Qlik Sense tool for a leading hospital system.• Helped client troubleshoot existing applications and add enhancements for better… Show more • Handled data migration and reports/dashboard migration projects.• Completed report migration sourced from INVISION System to STAR System.• Handled report migration sourced from Lawson ERP to PeopleSoft ERP system.• Managed report/dashboard migration from INFOR BI to Qlik Sense platform.• Handled new dashboard development in Qlik Sense tool for a leading hospital system.• Helped client troubleshoot existing applications and add enhancements for better performance.• Drive business meetings with client stakeholders for requirement gathering and sharing progress updates on a weekly basis. • Handled end-to-end project management including planning, execution, tracking, etc.• Managed the operation support for the solutions deployed in the production environment.• Managed a team of 8-10 people for project delivery. Show less

• Learned key business aspects of the Health Care domain.• Got exposure to work on EPIC, SurgiNet, Lawson, AllScripts, Invision and other Health Care Systems.• Developed ETL jobs using SQL Server Integration Services (SSIS) to keep the reporting database updated as per business needs.• Write complex Stored Procedures to be used in ETL pipelines for data extraction.• Created SQL Server Jobs for executing ETL pipelines, performed monitoring, and added the fixes in case of issues… Show more • Learned key business aspects of the Health Care domain.• Got exposure to work on EPIC, SurgiNet, Lawson, AllScripts, Invision and other Health Care Systems.• Developed ETL jobs using SQL Server Integration Services (SSIS) to keep the reporting database updated as per business needs.• Write complex Stored Procedures to be used in ETL pipelines for data extraction.• Created SQL Server Jobs for executing ETL pipelines, performed monitoring, and added the fixes in case of issues in those.• Development and tracking of the monitoring systems for their normal functioning.• Created data marts using Infor’s Business Performance Warehouse (BPW) for reporting needs.• Developed reports and dashboards using Infor Business Intelligence reporting module.• Presented key summaries, data observations, and questions to client stakeholders in business meetings.• Mentored and guided junior members of the team. Show less

• Engaged in building Business Intelligence Solutions for the Financial & Telecom domain. • Gathered data and reporting needs from key stakeholders on a regular basis.• Enriching the current Data Warehouse design by adding relevant data tables.• Development of ETL/ELT pipeline for data migration using SQL Server Integration Services (SSIS).• Troubleshooting of existing data ingestion pipelines and making necessary changes for improved functionality.• Monitoring and… Show more • Engaged in building Business Intelligence Solutions for the Financial & Telecom domain. • Gathered data and reporting needs from key stakeholders on a regular basis.• Enriching the current Data Warehouse design by adding relevant data tables.• Development of ETL/ELT pipeline for data migration using SQL Server Integration Services (SSIS).• Troubleshooting of existing data ingestion pipelines and making necessary changes for improved functionality.• Monitoring and rectification of SQL Server Jobs daily to keep the Data Warehouse healthy and updated.• Building new OLAP cubes using SQL Server Analysis Services (SSAS) to be used for data analysis and reporting.• Modification of existing OLAP cubes using MDX Queries for improved data consumption.• Created complex reports/dashboards from OLTP/OLAP databases using SQL Server Reporting Services (SSRS).• Delivered SSRS reports using report schedules to shared locations, emails, and FTP/sFTP folders. Show less

• Gathered business requirements by consulting key stakeholders.• Identified the key business KPIs and Metrics to be used in strategic decision-making.• Understood the current platform and underlying backend system.• Prepare the logical design of the Data Warehouse to be built.• Development of Data Warehouse using Star & Snowflake Schema using SQL Server 2008 R2 • Created end-to-end ETL pipeline using SQL Server Integration Services (SSIS)• Developed data marts for… Show more • Gathered business requirements by consulting key stakeholders.• Identified the key business KPIs and Metrics to be used in strategic decision-making.• Understood the current platform and underlying backend system.• Prepare the logical design of the Data Warehouse to be built.• Development of Data Warehouse using Star & Snowflake Schema using SQL Server 2008 R2 • Created end-to-end ETL pipeline using SQL Server Integration Services (SSIS)• Developed data marts for different business functions using SQL Server Analysis Services (SSAS)• Created reports/dashboards using SQL Server Reporting Services (SSRS) for various departments. Show less