Ayush Pandey
Noida
Summary
Data Analyst with experience in management, reporting and analysis. Skilled in SQL, Python(Pandas, Numpy, Matplotlib) and Power BI, with expertise in data processing, visualization and automation. Proven ability to analyze large datasets to drive business insights and streamline workflows
Overview
3
3
years of professional experience
Work History
Data Analyst
Evolance Plus
Noida
08.2025 - Current
- Enhanced data handling and analysis for weekly reporting by implementing advanced data transformation techniques in python, improving data accuracy and reducing manual intervention by 4 hours per week.
- Engineered custom SQL scripts to automate data pulls and analysis, achieving a 75% reduction in weekly report generation time, saving approximately 6 hours per cycle.
- Developed and maintained Power BI dashboards, delivering real-time insights into business performance from processed data.
Sales Associate
Oremon
Noida
02.2023 - 10.2024
- Managed leads, conducted product demonstrations or counselling calls, and supported the sales funnel from enquiry to enrolment.
- Engaged prospective students and parents to assess learning needs and recommend tailored educational products or programs.
- Mentored new teammates and developed SOPs that streamlined reporting process.
Education
PG Certification - Data Analytics
IIT
Guwahati08-2025
Bachelor of Arts - Economics
Amity University
Noida12-2021
Skills
- Data analysis
- SQL scripting
- Power BI dashboards
- Data visualization
- Data transformation
- Data management
- Python programming
- Excel and PowerPoint
- Problem solving
- Attention to detail
- Team collaboration
- GenAI
Personal Information
- Address - GC Centrum, Indirapuram,
Ghaziabad, Uttar Pradesh
201014
- Date of Birth - 25/11/2000
Projects
PhonePe Data Analysis | Python | July 2025
• Conducted a comprehensive analysis of transaction trends using Python libraries (Pandas, NumPy, Matplotlib, Seaborn, OS), uncovering key market behaviors and informing business strategy
• Identified peak transaction hours and top-performing states, aiding targeted marketing efforts.
• Automated data extraction and visualization workflows, reducing manual effort by 60%.
E-Commerce Analysis | SQL | April 2025
• Leveraged SQL to perform customer segmentation, sales trend analysis, and inventory optimization, resulting in reduction in stockouts and a 15% increase in sales forecasting accuracy.
• Built complex queries to analyze repeat customer behavior and high-margin product categories.
• Findings informed email retention campaigns that led to a 12% boost in returning customers within 3 months.
Retail Insights Dashboard | Power BI | Feb 2025
• Designed a Power BI dashboard analyzing 50 stores and 300+ SKUs, enabling leadership to view KPIs by category and region.
• Used DAX for profit margin analysis, stock turnover, and YoY trends, highlighting a 15% drop in specific product lines.
• Enabled stakeholders to identify slow-moving items and reduce excess stock by 22% within two quarters.
Sales Dashboard & Forecasting | Advanced Excel | Feb 2025
• Built a dynamic Excel dashboard to analyze 15K+ monthly sales records across 4 regions and 12 products.
• Used pivot tables, VLOOKUP, conditional formatting, and charts to visualize revenue, units sold, and growth trends.
• Applied linear regression to forecast next-quarter sales with 93% accuracy, helping reduce inventory gaps by 18%.
Languages
English
Proficient (C2)
C2
Hindi
Native
Native
German
Upper Intermediate (B2)
B2
Japanese
Upper Intermediate (B2)
B2
Hobbies
- Photography
- Reading
- Football Analysis
- Guitar
Timeline
Data Analyst
Evolance Plus
08.2025 - Current
Sales Associate
Oremon
02.2023 - 10.2024
PG Certification - Data Analytics
IIT
Bachelor of Arts - Economics
Amity University