Ayush Pandey
Data Analyst
Noida,UP
Summary
Data Analytics professional with 6+ years of cross-domain experience in pharma analytics and mechanical engineering. Specialized in Power BI dashboards, timeseries forecasting, and workow automation, with a track record of reducing manual effort, improving forecast accuracy, and scaling analytics for global markets. Recognized with 2 Bravo Awards for automation and predictive modeling innovations.
Overview
6
6
years of professional experience
2
2
Certificate
Work History
Project Lead / Senior Associate
Axtria
Noida
01.2024 - Current
- Directed analytics for 3 global pharma markets; led a team of 5 analysts.
- Built forecasting models (Prophet, ARIMA) achieving
- Automated 27+ manual reports and integrated QC/trend logic into Power BI dashboards reduced review cycles by 33%.
- Developed patient behavior indicators from IQVIA claims data improved traceability by 40%.
- Mentored junior analysts in forecasting and automation best practices.
Associate / Analyst
Axtria
Noida
01.2022 - 01.2024
- Migrated fuzzy logic algorithms from R SQL, improving execution speed 7×.
- Built stakeholder-focused Power BI dashboards 50% higher adoption.
- Conducted deep-dive investigations influencing marketing and field strategies.
Intern
Intel
Hyderabad
01.2021 - 01.2022
- Developed Python wrapper for C++ internal systems 2× adoption.
- Optimized driver response times by 15%; received Letter of Excellence and PPO.
Mechanical Design Engineer
Ajax Fury
01.2016 - 01.2019
- Designed and optimized industrial components and assemblies.
- Collaborated with cross-functional teams, building early skills in project planning and stakeholder management.
Education
MTech - Computer Science
Thapar University
Patiala01.2022
B.E. - Mechanical Engineering
RV College of Engineering
Bengaluru01.2016
Skills
- Power BI and DAX
- Automation and Excel VBA
- Statistical modeling (ARIMA, Prophet)
- Machine learning (XGBoost)
- Python programming
- Data manipulation (Pandas, NumPy)
- SQL database management
- R programming
- Cloud data storage (Snowflake, S3)
- Forecasting models
- Data visualization
- Statistical analysis
Certification
- Snowflake Complete Course, Udemy
- Python Bootcamp, Udemy
Accomplishments
- 2× Bravo Awards - Forecasting accuracy improvement & reporting automation.
- Intel Letter of Excellence - System optimization and tool innovation.
Similar Profiles
Swati JainSwati Jain
Associate Director – HR at AxtriaAssociate Director – HR at Axtria
Swetha TammaliSwetha Tammali
Senior Manager at AxtriaSenior Manager at Axtria
Dhruv SobtiDhruv Sobti
Senior Associate at AxtriaSenior Associate at Axtria
Shreya SharmaShreya Sharma
Associate at AxtriaAssociate at Axtria
PALLAV DUBEYPALLAV DUBEY
Product Owner at E&Y Global Delivery Services (GDS)Product Owner at E&Y Global Delivery Services (GDS)