Developed a comprehensive Data Engineering solution for genomic sequencing data, managing over 6 billion documents to identify biomarkers and predict patient outcomes.Reduced ETL processing time by 65% through the orchestration of complex Databricks, Snowflake, and Azure Data Factory pipelines.Designed and deployed robust ETL workflows and mappings using Informatica IICS.Conducted heavy data transformations using PySpark and Spark SQL on Databricks, leveraging Apache… Show more Developed a comprehensive Data Engineering solution for genomic sequencing data, managing over 6 billion documents to identify biomarkers and predict patient outcomes.Reduced ETL processing time by 65% through the orchestration of complex Databricks, Snowflake, and Azure Data Factory pipelines.Designed and deployed robust ETL workflows and mappings using Informatica IICS.Conducted heavy data transformations using PySpark and Spark SQL on Databricks, leveraging Apache Spark.Employed Scroll Elasticsearch REST APIs to migrate 370 million documents from OpenSearch.Optimized Databricks cluster management and implemented advanced logging and monitoring with Databricks CLI and Azure Monitor.Designed and optimized data models using Snowflake’s multi-cluster architecture, including features like Time Travel, Zero-Copy Cloning, and Data Sharing.Enhanced query performance and secure data sharing using Snowflake’s advanced features and integration with Python for custom data transformations.Performed performance tuning, cost optimization, and capacity planning for efficient resource utilization.Ensured comprehensive security with Azure Active Directory for RBAC and Purview for data governance and compliance. Show less

Owned the Care Coordination Population Health module for 3500+ US hospitals, building it from scratch.Led an 8-member team in conceptualizing and architecting an end-to-end Population Health Data Engineering solution.Managed the development of EHR Analytics modules, 500+ reports/dashboards, and robust metadata for US healthcare professionals.Increased data processing efficiency by 60% through robust pipelines for structured EHR, IoT devices, and public health data using… Show more Owned the Care Coordination Population Health module for 3500+ US hospitals, building it from scratch.Led an 8-member team in conceptualizing and architecting an end-to-end Population Health Data Engineering solution.Managed the development of EHR Analytics modules, 500+ reports/dashboards, and robust metadata for US healthcare professionals.Increased data processing efficiency by 60% through robust pipelines for structured EHR, IoT devices, and public health data using ADF, Databricks, Apache Airflow, and HDInsight.Architected scalable and compliant storage solutions with Azure Data Lake Storage (ADLS) Gen2, Cosmos DB, Azure Synapse, Snowflake, AWS S3, Delta Lake, and OpenSearch.Managed complex data models with 700+ tables, 150+ dimensions, and 45+ star and snowflake schemas using Power BI and IBM Cognos Framework Manager.Leveraged HDInsight and Apache technologies to achieve a 30% increase in data throughput.Designed ELT pipelines for 7+ TB of health records, reducing processing time by 60%.Developed real-time analytics with Azure Stream Analytics, integrating IoT Hub and Event Hubs.Utilized advanced T-SQL, PySpark, Spark SQL, and Python for data preprocessing and exploratory data analysis.Implemented Databricks optimizations, reducing resource usage by 35%.Designed serverless architectures using Azure Functions and Logic Apps.Engineered and optimized Kafka for real-time ingestion and integration of health data.Achieved 100% HIPAA compliance with advanced data security measures using Azure Purview and AAD.Set up comprehensive monitoring, logging, and cost optimization using Azure Monitor, Log Analytics, Datadog, and New Relic.Led and mentored an 8-member team, using JIRA for Agile execution and client meetings. Show less

Reengineered RCM analytical solution for detailed CPT and ICD level analysis in claims processing.Delivered DRG BI using Tableau for healthcare resource utilization and cost analysis based on DRG classification.Onboarded 80+ clients, with 65+ clients migrating from Excel to a Power BI IMSBI solution for hospital inventory management within 6 months.Revamped RCM ETL (SSIS) pipeline, reducing package size from 320 MB to 110 MB and increasing speed by 45%.Reduced RCM… Show more Reengineered RCM analytical solution for detailed CPT and ICD level analysis in claims processing.Delivered DRG BI using Tableau for healthcare resource utilization and cost analysis based on DRG classification.Onboarded 80+ clients, with 65+ clients migrating from Excel to a Power BI IMSBI solution for hospital inventory management within 6 months.Revamped RCM ETL (SSIS) pipeline, reducing package size from 320 MB to 110 MB and increasing speed by 45%.Reduced RCM client tickets by 55% through ETL and data model schema optimization.Designed data models with complex star-snowflake schemas and optimized queries for performance.Built data marts and advanced stored procedures, functions, triggers, and Python data transformation jobs.Conducted extensive data validation for namespaces, query subjects, joins, and summary tables.Collaborated with healthcare providers, finance, and operations teams to understand requirements and maintain project pace.Leveraged Tableau for interactive dashboarding and analysis of 5 years of DRG data, achieving 35% improved healthcare outcomes and cost savings. Show less

• Developed a BI solution for CxOs for pivotal Financial, Operations, Sales, Customers and Sales KPIs.• Implemented Analytics solution for CLP India. CLP is the largest foreign investor in the Indian Energy & Power sector. The BI solution is implemented to analyze numerous power generation metrics.• Represented DGSL at the IBM Universe 2012