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
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
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