Lakshay Jain
Summary
Analytical Associate Consultant with 3+ years of experience specializing in Data engineering problems and providing effective solutions.
Overview
3
3
years of professional experience
Work History
Business Technology Solutions Associate Consultant
ZS Associates India Pvt. Ltd
01.2024 - Current
- Delivered MDB and EDA for 7 country KNOTs in a short span of 1.5 months with no QC errors
- Spearheaded offshore support for three critical projects for Pfizer i.e
- PanInI, Cvent and Pulse, significantly enhancing service efficiency
- Achieved a remarkable 20% increase in efficiency and an impressive 30% reduction in operational time
- Implemented automation strategies, resulting in substantial overall time reductions by 50%
- Developed comprehensive Statements of Work (SOW) to ensure projectclarity and alignment
- Designed tailored Tableau dashboard views for Pfizer, enabling in-depth financial data analysis
- These views effectively showcased competitor and proprietary drug growth trends
- Provided extensive support to the Pfizer team throughout all phases of a product launch in the US market, from pre-launch preparations to successful product introduction
- Supported Pfizer during the post-launch phase, driving a significant 20% increase in sales through rigorous competitor analysis and strategic insights
- Generated detailed Root Cause Analysis (RCA) documents and implemented automated Quality
- Assurance/Quality Control (QA-QC) processes, resulting in an outstanding 90% reduction in issues
- Led a team of four in developing DSS pipelines and Tableau reports and establishing efficient data pipelines., PanInI Project (Developed and operationalized project for catering end to end needs for I&I business unit which led to reduction incost for Pfizer by $0.7 million)
- Automated the operations of project leading to reduction in ZS cost and reduction inmanual manpower effort
- Thereby decreasing the manual effort by 50%
- Incorporated snowflake practices in the project and revamped it thus reducing the overall consumption of resources by 50%
- Helped in launching various I&I related products across markets (U.S, China, Japan etc.) for brands (Velsipity, Litfulo and Cibinqo)
- Received 5 start rating from Tinoco Ana Paola for 6 months in a row
- New KNOTs Project (Developed DSS Dataiku pipelines, MDB and EDA for 7 different Ex-US markets for promotions analysis) o Helped in establishing 20+ KNOTs in 1.5 months
- Established robust QA-QC checklist ensuring error free work.
Business Technology Solutions Associate
ZS Associates India Pvt. Ltd
08.2021 - 12.2023
- Automated the workflows and operational flows through leveragability of Dataiku DSS tool thus reducingthe operational time by 50%
- Implemented automated QA/QC which helped in identifying the outliers which helped Pfizer with positive insights
- Delivered and developed the performance insight reports of focused brands like Cibinqo, Litfulo, Velsipity
- Interacted with BAI to gain insights into the requirements and developed Tableau and DSS pipelines based on same
- Developed the pipelines with help of SQL and Dataiku DSS for data cleansing and architecture.
Education
B.COM Hons -
Delhi University (Shaheed Bhagat Singh College)
01.0001
Skills
- Skills & Interests
- Technical:
- SQL, Tableau, Snowflake, Excel, and PowerPoint
Timeline
Business Technology Solutions Associate Consultant
ZS Associates India Pvt. Ltd
01.2024 - Current
Business Technology Solutions Associate
ZS Associates India Pvt. Ltd
08.2021 - 12.2023
B.COM Hons -
Delhi University (Shaheed Bhagat Singh College)
Similar Profiles
Aishwary PeshaveAishwary Peshave
Senior Finance Associate at ZS Associates India Pvt. LtdSenior Finance Associate at ZS Associates India Pvt. Ltd
Nikita GautamNikita Gautam
Consultant at ZS Associates India Pvt. Ltd.Consultant at ZS Associates India Pvt. Ltd.
Vivek PandeyVivek Pandey
Senior Lead - Business Development/Go-To-Market at ZS Associates India Pvt. Ltd.Senior Lead - Business Development/Go-To-Market at ZS Associates India Pvt. Ltd.
Ritu SharmaRitu Sharma
Business Technology Solutions Consultant at ZS Associates India Pvt. Ltd.Business Technology Solutions Consultant at ZS Associates India Pvt. Ltd.
Rakshit RanjanRakshit Ranjan
Business Technology Solutions Associate Consultant at ZS AssociatesBusiness Technology Solutions Associate Consultant at ZS Associates