GAGANJIT HANS
Canton,MI
Summary
Data & Analytics Leader with 20 years of experience delivering enterprise-scale data warehousing, business intelligence, and healthcare analytics solutions. Strong expertise in SQL, data modeling, ETL pipelines, and BI reporting, with experience analyzing healthcare claims and EMR data. Proven ability to translate complex data into actionable insights, influence senior stakeholders, and drive measurable business outcomes. Experienced in KPI development, performance optimization, and scalable analytics solutions, with exposure to cloud-based data platforms (Azure/Snowflake).
Overview
19
19
years of professional experience
1
1
Certification
Work History
Data Analytics Manager
Optum
09.2022 - Current
- Lead enterprise analytics strategy supporting clinical operations, quality improvement, and financial performance.
- Manage and mentor a team of 10 analysts, data scientists, and BI developers.
- Partner with executives, physicians, and operational leaders to define KPIs and data-driven initiatives.
- Implement predictive models that improved patient outcomes by ~ 20-40% (e.g., readmission reduction, risk stratification).
- Oversee development of dashboards and reporting tools using Tableau/Power BI, improving decision-making speed by ~ 10 - 20 %.
- Establish data governance frameworks ensuring compliance with PHIPA/HIPAA and improving data quality by ~ 40 - 50%.
- Collaborate with IT to optimize data pipelines, warehouse architecture, and interoperability
Senior Reporting Analyst
Optum
08.2018 - 08.2022
- Lead development of enterprise reporting and analytics solutions using advanced SQL and BI tools across large-scale healthcare datasets.
- Designed and optimized complex SQL queries and reporting processes, improving report performance by ~25–40% and reducing data latency.
- Developed executive dashboards and KPI frameworks, enabling leadership to track performance and drive data-informed decisions.
- Performed trend analysis, variance analysis, and root cause analysis to identify inefficiencies and support operational improvements.
- Partnered with cross-functional teams to define analytics requirements and deliver solutions aligned with business and Payment Integrity goals.
- Improved reporting automation and workflows, reducing manual effort by ~20–30% and increasing team productivity.
- Supported analysis of claims and healthcare data aligned with CMS reporting and regulatory expectations.
- Contributed to modernization efforts with exposure to cloud-based data environments (Azure/Snowflake) for scalable analytics.
- Mentored team members and managed multiple concurrent analytics initiatives.
Systems Analyst
General Motors
Detroit
07.2014 - 08.2018
- Developed and enhanced data-driven applications and reporting systems, improving audit and risk analytics capabilities for GMAS (General Motors Audit Services) department.
- Optimized SQL queries and backend processes, improving data processing efficiency by ~20%.
- Collaborated with business stakeholders to define requirements and deliver scalable analytics solutions.
- Improved data accuracy and reporting reliability, supporting better decision-making across teams.
Systems / Programmer Analyst (Team Lead)
Community Mental Health Authorities
Lansing
04.2012 - 07.2014
- Led development of data-intensive healthcare applications and reporting systems, integrating multiple data sources.
- Designed and implemented 837 healthcare claims processing system, improving claims data processing efficiency by ~30%.
- Developed complex SQL scripts, ETL pipelines, and data transformations, enabling accurate and timely reporting.
- Built reporting solutions leveraging data aggregation and statistical analysis, improving visibility into operational metrics.
- Conducted data validation and reconciliation, reducing data inconsistencies and improving reporting accuracy.
- Worked with healthcare datasets aligned to CPT, ICD-9/ICD-10 coding structures and Medicaid reporting requirements.
- Managed team delivery, timelines, and stakeholder communication across multiple projects.
Software Developer / Analyst
Reliance Software Systems Inc.
Detroit
01.2009 - 03.2012
- Contributed to the development of the Care Plus Next Generation EMR as part of the Software Development team.
- Designed and implemented the CPOE module UI for a web-based EMR/EHR system using front-end technologies, enabling users to enter orders, procedures, and medications.
- Developed real-time clinical decision support features, including dosage guidance, alternative medication suggestions, duplicate therapy alerts, and drug interaction checks.
- Built medication search functionality using C# with FirstDataBank (FDB) API integration.
- Implemented database solutions using SQL Server (stored procedures, functions, triggers) and followed Agile, test-driven development, and automated build practices.
- Developed backend data solutions using SQL and database design principles.
- Improved system performance and query efficiency through optimized database logic.
Technical Support Analyst
Sutherland Global Services
Canada
01.2007 - 12.2008
- Provided technical support to Hewlett Packard products having problems with photo smart printers, LaserJet printers and photo smart cameras.
Education
MS - Computer Engineering & Computer Science
Wayne State University
Detroit 12-2008
B.Tech - Computer Science & Engineering
Guru Nanak Dev Engg. College
India07-2006
Skills
- Advanced SQL & Data Analysis (T-SQL, query optimization)
- Data Warehousing & Data Modeling (dimensional modeling, star schema)
- ETL Pipelines & Data Integration (SSIS, Data Stage)
- Cloud Data Platforms (Azure, Snowflake )
- Business Intelligence (Power BI, Tableau, SSRS, Cognos)
- Statistical & Exploratory Data Analysis (trend, variance, root cause)
- KPI Development & Performance Measurement
- Healthcare Analytics (claims, EMR/EHR, Payment Integrity)
- CPT / ICD-10 / HCPCS / DRG (data exposure)
- CMS, Medicaid / Medicare (regulatory awareness)
- Stakeholder Influence & Executive Communication
- Languages & Analytics: SQL (T-SQL), Python , PL/SQL, C#, Java
Certification
Agile Certification
Timeline
Data Analytics Manager
Optum
09.2022 - Current
Senior Reporting Analyst
Optum
08.2018 - 08.2022
Systems Analyst
General Motors
07.2014 - 08.2018
Systems / Programmer Analyst (Team Lead)
Community Mental Health Authorities
04.2012 - 07.2014
Software Developer / Analyst
Reliance Software Systems Inc.
01.2009 - 03.2012
Technical Support Analyst
Sutherland Global Services
01.2007 - 12.2008
MS - Computer Engineering & Computer Science
Wayne State University
B.Tech - Computer Science & Engineering
Guru Nanak Dev Engg. College
AI & Advanced Analtics Tools
- ChatGPT, Microsoft Copilot, Code Vertex AI
- Generative AI - Prompt Engineering & AI-Assisted Development