loader
Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Languages
Timeline

Sarthak Aggarwal

Business Technology Solutions Delivery Consultant
Gurugram
Summary

Experienced Business Technology Solution Delivery Consultant with almost 6 years of successful experience in building scalable and robust data intensive business intelligence solutions for healthcare clients enabling insight into commercial operations and reporting. Currently, leading a 15 member team on a 3 MN engagement with a Fortune 500 client in order to create a one stop datalake for Customer 360 global analytics and reporting. Skilled in SQL and Python programming and Cloud-based digital transformations. Data Science Enthusiast backed by professional degree from IBM.

Overview
3
3
Languages
2
2
Certifications
4
4
years of post-secondary education
5
5
years of professional experience
Work History

Solutions Delivery Consultant

ZS
2020-01 - Current
  • Gathered requirements, defined scopes, allocated resources and established schedules meeting or exceeding project demands.
  • Built and utilized reporting systems to keep customers and management in loop with latest information.
  • Operated under Agile frameworks to efficiently organize and carry out project tasks.
  • Managed and motivated project teams to promote collaboration and keep members on-task and productive.
  • Closely collaborated with project members to identify and quickly address problems.
  • Produced [Type] and [Type] reports each [Timeframe], updating customers and senior leaders on progress and roadblocks.
  • Handled day-to-day running of [project or department or task], ensuring high levels of productivity and progression.

Senior Business Analyst

ZS
2018-01 - 2019-12
  • Supported technology design, testing and execution by providing research-based product and process knowledge.
  • Conducted exploratory analysis on sales data, developing interactive Excel dashboards to monitor sales operations.
  • Studied business functions, collecting information and evaluating requirements to establish operational objectives.
  • Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
  • Directed business analysts in executing and delivering various tactical and strategic plans.
  • Streamlined techniques to support agile methodology implementations.
  • Effectively supervised team performance by implementing measurable metrics to assess delivery of [Type] requirements.
  • Built library of models and reusable knowledge-base assets to produce consistent and streamlined business intelligence results.
  • Evaluated consistency and importance of different business intelligence data against needs to determine optimal courses of action.
  • Analyzed performance metrics to identify opportunities to increase sales.
  • Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
  • Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
  • Lead a team of 8 Associates in a $2.5M partnership with a $25B Fortune500 pharma giant with 25% YoY growth; $3.2M projected revenue
  • Utilized dynamic feedback model with Business Unit leads, reducing data discrepancy queries from 800 to 500/quarter. Reduced annual HR investment by 40%, saving client $400,000 and improving morale of 3000-strong sales force
  • Collaborated with ZS incentive compensation space leads to streamline processes via automated customizable workbooks to analyze and setup validation checks for faster, defect-free deliverables. Profit margins increased 5%–45% in 3 months
  • Evaluated sales compensation for Global Commercial Operation VP to recalibrate strategies for 15 products in US & EU markets; Resulted in expansion of scope, working with the client's country heads for China & Australia
  • Conceptualized >20 incentive compensation contests across 5 business units, enhancing motivation of >3500 sales-force
  • Analyzed performance of Medical Reps, facilitating optimization of incentive payouts worth $200M across 18 sales teams
  • Facilitated Knowledge Transfer (KT) sessions for 12 Associates; these are now used to onboard people across ZS hierarchy
  • Spearheaded 5-member team to develop Data Science algorithm to analyze sales data and deliver insights to client's oncology leadership. Reduced inquiry resolution time from 6 to 2 weeks and inquiries per-quarter from 600 to 240, saving $1M annually
  • Engaged with India- and US-based ZS teams to create a 1-stop cloud-based commercial data lake using data from 20 external data vendors. With 50% faster generation of market-level insight reports, reduced client's analytics costs by 80% ($75M/yr)

Business Technology Analyst

ZS
2015-07 - 2017-12
  • Enabled ZS's entry into $150B Pharma R&D market, with projected annual revenue of $100M by Q4'2020
  • Designed data warehousing system for F500 client, supporting 25 analytical apps; simplified monitoring process by synthesizing 1200 KPIs to monitor clinical trials, presenting data trends and highlighting anomalies through automation
  • Created internal training modules on Clinical Trials domain which are now used in bootcamps at ZS
  • Developed 1st-of-its-kind Predictive Analytics tool for optimal distribution (speed & cost) of clinical trial sites across the US.
  • Led team of 4 to revamp the existing platform for Clinical Trial Operations in US through migration to an advanced Oracle-based platform. Reduced Operational run time from 34hrs to 18hrs (45% reduction) saving $2.5M on operational support
Education

Bachelor of Engineering Electrical, Electronics Engineering Technologies

Thapar University
2011-07 - 2015-08
Skills

SQL analytics

SQL development

Data Modeling Design

Agile Development

ETL development

Database development

Interpersonal Communication

Data profiling

Data validation

Relational Database Management

Python

Predictive modeling

MS Excel (Intermediate)

Spark SQL and query optimization

PySpark

Apache Airflow

Certification

IBM Data Science Specialization including Capstone Project on determining Accident Severity

2020-09

Machine Learning by Andrew NG

2020-08
Accomplishments
  • “Impact Recognition Award” (2019) by ZS Internal leadership for project stabilization improvements for client deliverables
  • Won the 1st “Purple Cow Award” (2019) for remarkable transformations enhancing business for a F500 pharma client
  • “Project Champions Award” (2018) for exceptional digital transformations made for F500 pharma giant
  • “ZS Citizenship Award” (2017 & 2018) for commendable contribution towards society via ZS Cares Program
  • “Special Recognition Award” (2016) for creating recognizable impact in R&D space for Pharmaceutical industry
Languages

English

Hindi

Punjabi

Timeline

IBM Data Science Specialization including Capstone Project on determining Accident Severity

2020-09

Machine Learning by Andrew NG

2020-08

Solutions Delivery Consultant

ZS
2020-01 - Current

Senior Business Analyst

ZS
2018-01 - 2019-12

Business Technology Analyst

ZS
2015-07 - 2017-12

Bachelor of Engineering Electrical, Electronics Engineering Technologies

Thapar University
2011-07 - 2015-08