PRANSHU GAUTAM
Jhansi
Summary
Results-driven Data Analyst at Optum, adept at leveraging Spark and SQL to enhance data quality for over 100 clients. Spearheaded a 50% reduction in processing time through an innovative analytics engine and improved workflow efficiency with Airflow. Known for critical thinking and cross-functional collaboration, delivering impactful insights for strategic decision-making.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Analyst
Optum (UnitedHealth Group)
Noida
07.2021 - Current
- Analyzed large-scale medical claims and membership data, enhancing data quality for 100+ clients.
- Developed high-performance analytics engine with Apache Spark, reducing processing time by 50%.
- Managed historical data to produce month-on-month patient health assessments with risk scoring.
- Implemented cryptography hashing for secure disease profile outputs, ensuring strict data privacy compliance.
- Executed comprehensive data quality checks on client deliverables, guaranteeing high reliability.
- Produced detailed statistical reports for product teams, supporting data-driven strategy decisions.
- Spearheaded migration of analytics processes to Azure HDInsight, cutting costs by 50%.
- Transitioned data orchestration from Oozie to Apache Airflow, boosting workflow efficiency.
Education
B.Tech - Mechanical Engineering
IIT (BHU)
Varanasi06-2021
CBSE (XII) -
Jai Academy
Jhansi06-2016
CBSE (X) -
Kendriya Vidyalaya No.3
Jhansi06-2014
Skills
- Spark and SQL
- Airflow and Azure
- Python and MS Excel
- Data preprocessing and statistical analysis
- Risk analytics and machine learning
- Data quality assurance
- Cross-functional collaboration
- Process optimization
- Reporting
- Critical thinking
Certification
SQL + MySQL for Data Analytics and Business Intelligence (Udemy)
Projects
Enhancing Sales Strategy of E-learning Platforms using ML — Built predictive scoring models to identify promising leads, using regression and classification algorithms. Achieved ~93% accuracy., Robotic Assembly Line Balancing — Modeled and optimized workstation layouts to minimize cycle time and energy consumption using Gurobi Optimizer., Battery Pack Cooling — Designed and fabricated a liquid-based cooling system for EV battery modules; familiar with cooling systems and phase change materials.
Extracurricular Activities
Attended Model UN Conference, acted as a delegate from Kazakhstan. Fabricated and calibrated a robot plane for Trajectory event at Technex, IIT (BHU). Participated in Shuttle Cup’18, badminton tournament at IIT (BHU).
POSITIONS OF RESPONSIBILITY
- Core Team | MES, IIT (BHU): Conducted CAD workshops, managed events for 1st & 2nd-year students.
- Structural Engineer | Clean Electric: Designed battery pack structural components and optimized weight and cost.
- Coordinator | COMET’19, IIT (BHU): Coordinated an online education initiative, reaching 1500+ students.
Timeline
Data Analyst
Optum (UnitedHealth Group)
07.2021 - Current
B.Tech - Mechanical Engineering
IIT (BHU)
CBSE (XII) -
Jai Academy
CBSE (X) -
Kendriya Vidyalaya No.3
Similar Profiles
Lisa PorterfieldLisa Porterfield
Executive Assistant at Optum, UnitedHealth GroupExecutive Assistant at Optum, UnitedHealth Group
Briana MakuzaBriana Makuza
Senior Customer Service Representative at Optum, UnitedHealth GroupSenior Customer Service Representative at Optum, UnitedHealth Group
ANGEL J. RIVERAANGEL J. RIVERA
Customer Care Representative at Optum, UnitedHealth GroupCustomer Care Representative at Optum, UnitedHealth Group
Dana AttarDana Attar
Vice President, Product & Commercial Strategy, Innovation & New Ventures at Optum – UnitedHealth GroupVice President, Product & Commercial Strategy, Innovation & New Ventures at Optum – UnitedHealth Group
Ramashankar KhareRamashankar Khare
Operation Executive at Om Logistics Supply Chain Pvt LtdOperation Executive at Om Logistics Supply Chain Pvt Ltd