Mayank Yadav
Gurugram,India
Summary
Detail-oriented professional with expertise in MS Excel, SQL, and Power BI data analysis. Demonstrates strong analytical thinking and statistical analysis skills to drive data-driven decision-making. Committed to leveraging skills to enhance business intelligence and support strategic objectives. Major experience includes working with leading FMCG brands, managing and analyzing their eCommerce data to drive performance insights and strategic decision-making.
Overview
2
2
years of professional experience
5
5
years of post-secondary education
Work history
Business analyst
mFilterit
GURUGRAM, India
2023.12 - Current
- Produced detailed reports to aid in key decision-making processes.
- Simplified complex data into understandable presentations, facilitating better communication amongst teams.
- Managed multiple stakeholders, ensuring clear communication throughout projects' lifespan.
- Improved client relationships by addressing and managing their needs effectively.
- Created tailored solutions by understanding and translating customer requirements into functional specifications.
eCommerce Analyst Intern
mFilterit
GURUGRAM, India
2023.06 - 2025.11
- Solved complex problems with effective teamwork and communication skills.
- Improved team communication by organising regular team meetings and discussions.
- Prepared comprehensive reports to facilitate informed decision-making process.
- Ensured timely project completion for customer satisfaction.
- Identified trends in data to help inform decision-making processes.
Education
Master of Business Administration - Marketing
Dayalbagh Education Institute
Agra, Uttar Pradesh 2022.08 - 2024.06
Bachelor of Commerce - Accounting
Dayalbagh Education Institute
Agra, Uttar Pradesh 2018.08 - 2021.06
Skills
- MS Excel
- SQL
- Power BI data analysis
- Analytical Thinking
- Statistical Analysis
Projects
Industrial Project: Disclosure Practices of Global Reporting Initiatives (GRI) for Sustainability Reporting in India: A Study of Selected Indian Companies, 2021
SQL Project – Movie Rental Database AnalysisDesigned and queried a movie rental database to extract key metrics like most rented movies, top customers, and popular genres. Wrote SQL queries using joins, group by, and date functions to provide actionable insights.
Advanced Excel Project – Sales DashboardDesigned an interactive Excel dashboard to track product sales across regions and sales reps. Used PivotTables, slicers, conditional formatting, and advanced formulas (XLOOKUP, SUMIFS) to generate actionable insights and enhance reporting efficiency.
Affiliations
- Bibliophile
- Sports
- Travelling
Timeline
Business analyst
mFilterit
2023.12 - Current
eCommerce Analyst Intern
mFilterit
2023.06 - 2025.11
Master of Business Administration - Marketing
Dayalbagh Education Institute
2022.08 - 2024.06
Bachelor of Commerce - Accounting
Dayalbagh Education Institute
2018.08 - 2021.06