Data Analytics Analyst

Nishant Garg

Senior Data Analyst

Norristown, PA 19403, USA

***********.****@*******.*** 484-***-**** https://www.linkedin.com/in/nishantgarg-/ EXECUTIVE PROFILE

Dynamic and innovative Data Analytics/Engineering professional with 13.5 years of experience in the design, development, and implementation of end-to-end Data Analytics, and Data Engineering, Data Warehousing solutions, specializing in SQL, Python, data visualization, and cloud integration. Proven track record in leading cross-functional teams, translating complex data strategies into actionable insights, and driving operational excellence. Highly skilled in engaging with business stakeholders, gathering and analyzing requirements, and delivering scalable, value-driven data solutions for top-tier clients such as UnitedHealth Group, CITI Bank, and Union Bank of Switzerland. Strong background in healthcare analytics, process automation, and enterprise reporting, with a consistent focus on data quality, governance, and security. TECHNICAL LEADERSHIP & CORE COMPETENCIES

Cross-Functional Leadership: Proven ability to lead diverse, high-performing teams (engineering, analytics), mentor emerging talent, and drive adoption of data-driven cultures.

Cloud Computing & Big Data Platforms: Proficient in Microsoft Azure(Azure Data Factory), Databricks, Hadoop, and Spark for enterprise-scale analytics.

Business Impact & ROI: Track record of leveraging analytics to reduce costs, mitigate risk, and capitalize on new market opportunities, delivering hard and soft savings.

Data Visualization & Storytelling: Proficient in Tableau, Power BI, and Microsoft Excel, crafting executive dashboards that communicate clear, actionable insights.

Strategic Road mapping & Communication: Adept at translating complex analytics initiatives into concise proposals aligning stakeholders around common goals.

EXPERIENCE

UnitedHealth Group (Optum) India

Senior Data Analyst, Enterprise Analytics & Automation March 2015 – January 2025

Early Warning System (EWS) for Optumcare: Led requirements gathering sessions with business stakeholders to identify key metrics and pain points in the claims denial process. Designed a system using statistical deviance to detect spikes in provider denial rates, enabling timely interventions. Collaborated closely with cross-functional teams to develop and optimize SQL & Hive queries and created interactive Tableau and Power BI dashboards for provider performance tracking. Implemented a targeted provider flagging mechanism, resulting in $500K in annual savings through denial and rework avoidance.

Cloud Migration from On-Prem to Microsoft Azure: Oversaw the migration of reporting and ETL systems to Microsoft Azure, managing stakeholder expectations, technical documentation, and cross-team collaboration to ensure a smooth transition with minimal business impact and optimizing SQL, Databricks pipelines, and ADF workflows. Successfully transitioned 95% of systems, enhancing scalability and reducing costs.

Analytics Dashboarding & Innovation: Developed and presented interactive Power BI and Tableau dashboards for executive leadership, supporting decisions in claims processing, provider performance, member quality metrics and compliance, leading to a 20% increase in member eligibility accuracy. Achieved a 10 % increase in first-pass claims accuracy, reducing manual intervention and errors.

Team Management & Culture: Built and managed a high-performing team of 6+ data analysts and developers, driving project planning, mentoring, performance tracking, and resource allocation in Agile sprints.

Enterprise ETL Architecture & Data Pipeline Optimization: Designed and implemented high-performance ETL solutions using SQL, Informatica, and Spark, optimizing data migration, streamlining data ingestion, cleansing, and integration from Data Lake to downstream systems, and enhancing automation and operational efficiency for feature engineering and real-time analytics.

HTC Global Services India

ETL Developer, US Healthcare May 2014 – February 2015

Data Warehouse Development for Healthcare Analytics: Built a Unified Data Warehouse using DataStage and SQL, streamlining healthcare data integration for advanced analytics. Created technical documentation and managed project scope to align with business goals. Enabled improved decision-making through centralized, high-quality data architecture.

ETL Implementation & Data Migration for System Upgrade: Led ETL development for NextGen system upgrades and health record migration. Ensured data integrity, minimal downtime, and seamless transition from legacy systems. Enhanced disease prediction and care management through improved data accessibility. Wipro Technologies India

Software Engineer, Banking, Securities October 2011 – May 2014

ETL Development and Data Analysis for Financial, Securities Domains: Led end-to-end ETL development and SQL- based data validation for key clients like CITI Bank and Union Bank of Switzerland. Delivered consistent, integrated data pipelines for reporting and compliance, while closely collaborating with stakeholders to convert business needs into technical solutions. Focused on regulatory alignment and quality assurance, reducing data errors by 30% and enhancing reporting capabilities.

Performance Optimization: Engineered high-performance ETL pipelines and accelerated consumer data matching by up to 50x, significantly boosting data processing for financial systems. Automated job scheduling and monitoring using IBM Tivoli, cutting manual effort and improving execution reliability. Leveraged IBM DataStage to build scalable solutions that improved overall operational efficiency by 40% and reduced query times by 80%. SKILLS: COMPREHENSIVE DATA INFRASTRUCTURE

Programming & Query Languages: SQL (T-SQL, PL/SQL), Python (Pandas, NumPy, Matplotlib, Seaborn, Plotly), Unix Shell Scripting, Excel, VBA

Cloud Platforms: Microsoft Azure(Azure Data Factory), Databricks, Snowflake.

Visualization & BI: Tableau, Power BI, Excel (Power Query, Power Pivot).

Big Data Tools: Sqoop, Hive, Apache Spark (PySpark, Spark SQL), Hadoop (HDFS, MapReduce), DataLake.

Databases: SQL Server Management Studio, Teradata, Oracle, Sybase, Facets

Healthcare Experience: Medicaid/Medicare systems processing, including Claims, Provider, and Member Eligibility.

Data Engineering: ETL/ELT, Data Pipelines, Data Warehousing, Data Lakes, Batch Processing, Parquet, JSON, SAS, Informatica, Datastage, CI/CD (Jenkins), GitHub, Docker, Kubernetes, Airflow. CERTIFICATION

Microsoft Certified Power BI Data Analyst Associate

Microsoft Certified Azure Data Engineer Associate

Microsoft Certified Azure Fundamentals (AZ-900)

Microsoft Certified Azure Data Fundamentals (DP-900)

IBM Certified for Infosphere Datastage.

Healthcare Management (AHM 250)

EDUCATION

Kalinga Institute of Industrial Technology India

Master of Computer Application July 2008 - May 2011 TMIMT India

Bachelor of Computer Application August 2005 - May 2008

Contact this candidate