Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Sarthak Aggarwal

Business Technology Solutions Delivery Consultant
Gurugram,Haryana

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
Gurugram, Haryana
01.2020 - 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
Gurugram, Haryana
01.2018 - 12.2019
  • 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
Gurugram, Haryana
07.2015 - 12.2017
  • 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
Patiala, Punjab
07.2011 - 08.2015

Skills

SQL analytics

undefined

Certification

IBM Data Science Specialization including Capstone Project on determining Accident Severity

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

Timeline

IBM Data Science Specialization including Capstone Project on determining Accident Severity

09-2020

Machine Learning by Andrew NG

08-2020

Solutions Delivery Consultant

ZS
01.2020 - Current

Senior Business Analyst

ZS
01.2018 - 12.2019

Business Technology Analyst

ZS
07.2015 - 12.2017

Bachelor of Engineering - Electrical, Electronics Engineering Technologies

Thapar University
07.2011 - 08.2015

Similar Profiles

CREATE PROFILE
Sarthak AggarwalBusiness Technology Solutions Delivery Consultant