Summary
Overview
Work History
Education
Skills
Accomplishments
Selected Projects
Personal Information
Core Competencies
Professional Development
Timeline
Generic

GAJANAN UNDALKAR

Pune

Summary

Dynamic DataOps Advisor with a proven track record at MRO, enhancing healthcare operations through SQL and BigQuery expertise. Achieved a 20% reduction in incident volume by developing automated monitoring scripts. Adept at stakeholder management and process automation, driving efficiency and data quality across healthcare practices.

Overview

8
8
years of professional experience

Work History

DataOps Advisor

MRO
Pune
04.2023 - Current
  • Design and optimize SQL and BigQuery solutions supporting Healthcare Data Operations and operational analytics.
  • Developed SQL and BigQuery-based monitoring scripts for 40+ critical daily configuration parameters, enabling proactive issue detection, preventive maintenance, and automated data validation, resulting in a 20% reduction in Incident and Service Request (IRSR) volume.
  • Developed 5+ operational dashboards with Jira Native Dashboards and Looker Studio to monitor incidents, service requests, SLA compliance, operational KPIs, and practice lifecycle metrics, enhancing visibility across operations.
  • Built a Healthcare Practice Lifecycle Analytics Dashboard providing visibility into onboarding, implementation, maintenance, and inactivation activities across healthcare practices.
  • Manage the end-to-end lifecycle of 500+ healthcare practices, including onboarding, implementation, configuration, maintenance, provider lifecycle management, and practice inactivation.
  • Support 12,000+ healthcare providers by ensuring accurate onboarding, configuration, maintenance, and data quality across healthcare platforms.
  • Established standardized Root Cause Analysis (RCA) framework by defining business rules, creating SQL-based RCA analysis scripts, and documenting Standard Operating Procedures (SOPs) for Incident and Service Request investigations, resulting in 10% faster IRSR delivery.
  • Defined business requirements, validated automation outcomes, and collaborated with the RPA team to automate manual operational workflows, significantly reducing manual effort and improving process efficiency.

Team Lead

FIGmd
Pune
06.2018 - 04.2023
  • Led a 12-member engineering team supporting Healthcare Data Operations and production support.
  • Mentored junior engineers, coordinated sprint planning, workload management, and knowledge-sharing initiatives.
  • Designed, developed, and optimized ETL pipelines for healthcare data integration and reporting.
  • Integrated healthcare data from multiple EHR systems, including Allscripts, eClinicalWorks, IntelleChart, Medflow, and SRS.
  • Performed advanced SQL and BigQuery analysis for reporting, troubleshooting, and data validation.
  • Managed production incidents and service requests, achieving consistent SLA compliance.
  • Conducted root cause analysis and implemented preventive solutions, enhancing application stability.
  • Collaborated with US healthcare clients to gather business requirements and deliver data-driven analytics solutions.

Education

PG-DAC - Computer Software Engineering

Centre For Development of Advanced Computing (C-DAC)
Pune
03.2018

Bachelor of Engineering - Mechanical Engineering

MIT Aurangabad
Chhatrapati Sambhajinagar
06.2017

Skills

  • DataOps
  • SQL
  • BigQuery
  • ETL Development
  • Data Integration
  • Data Validation
  • Data Analytics
  • Data Analysis
  • Data Stewardship
  • Data Pipelines
  • Visualization & Reporting
  • Dashboard Development
  • Looker Studio
  • Jira Native Dashboards
  • KPI Reporting
  • Root cause analysis
  • Issue Resolution
  • Healthcare Operations
  • US Healthcare Analytics
  • EHR Integration
  • Practice onboarding
  • Provider Onboarding
  • Practice Configuration
  • Practice upkeep
  • Practice Inactivation
  • Registry Management
  • Microsoft Excel
  • Google Sheets
  • Google Cloud Platform (GCP)
  • Jira
  • Confluence
  • Git
  • Agile Methodology
  • Stakeholder Management
  • EHR Integration

Accomplishments

  • Managed the end-to-end lifecycle of 500+ healthcare practices.
  • Supported 12,000+ healthcare providers across onboarding, implementation, maintenance, and inactivation.
  • Developed 5+ executive dashboards for KPI monitoring, SLA reporting, and operational analytics.
  • Developed monitoring scripts for 40+ daily configuration parameters, reducing Incident and Service Request (IRSR) volume by 20%.
  • Built a standardized Root Cause Analysis (RCA) framework with SQL scripts and SOPs, reducing IRSR delivery time by 10%.
  • Authored 10+ SOPs to standardize healthcare implementation and Data Operations processes.
  • Collaborated with the RPA team to automate manual operational workflows, improving efficiency and reducing repetitive effort.
  • Led a 12-member engineering team delivering healthcare data solutions and production support.

Selected Projects

  • Healthcare Practice Lifecycle Analytics Dashboard, SQL, BigQuery, Looker Studio, Developed dashboards monitoring 40+ daily operational and configuration parameters. Automated configuration validation and exception reporting. Improved operational visibility throughout the practice lifecycle.
  • Enterprise Incident & Service Request Dashboard, Jira Native Dashboards, Built dashboards for Incidents, Service Requests, Tasks, SLA compliance, and operational KPIs. Enabled leadership teams to monitor workload, service performance, and operational trends.
  • Provider Data Quality Analytics, SQL, BigQuery, Investigated provider enrollment and maintenance discrepancies. Improved reporting accuracy through data validation and root cause analysis.
  • Data Operations Process Standardization, Confluence, Authored 10+ SOPs covering onboarding, implementation, maintenance, incident management, and Data Operations. Standardized operational processes and improved knowledge sharing.

Personal Information

Title: Senior Data Analyst | Healthcare DataOps & Implementation Specialist

Core Competencies

SQL, BigQuery, Data Analysis, Dashboard Development, KPI Reporting, Data Validation, Root Cause Analysis (RCA), Data Quality Management, Healthcare Practice Lifecycle Management, Practice Onboarding & Implementation, Provider Onboarding, Practice Configuration, Practice Maintenance, Practice Inactivation, Registry Management, US Healthcare Analytics, ETL Development, Data Pipelines, Looker Studio, Jira Native Dashboards, Microsoft Excel, Google Sheets, Google Cloud Platform (GCP), Jira, Confluence, Git, Team Leadership, Stakeholder Management, Agile Methodology, Incident Management, Business Process Improvement

Professional Development

  • Python for Data Analysis (Pandas, NumPy) - Currently Learning
  • Power BI - Currently Learning
  • Dbt (Data Build Tool) - Currently Learning
  • Advanced Looker Studio - Upskilling
  • Apache Airflow - Learning Fundamentals

Timeline

DataOps Advisor

MRO
04.2023 - Current

Team Lead

FIGmd
06.2018 - 04.2023

PG-DAC - Computer Software Engineering

Centre For Development of Advanced Computing (C-DAC)

Bachelor of Engineering - Mechanical Engineering

MIT Aurangabad

Similar Profiles

CREATE PROFILE
GAJANAN UNDALKAR