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
12.2023 - 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
06.2023 - 11.2025
- 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 08.2022 - 06.2024
Bachelor of Commerce - Accounting
Dayalbagh Education Institute
Agra, Uttar Pradesh 08.2018 - 06.2021
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
12.2023 - Current
eCommerce Analyst Intern
mFilterit
06.2023 - 11.2025
Master of Business Administration - Marketing
Dayalbagh Education Institute
08.2022 - 06.2024
Bachelor of Commerce - Accounting
Dayalbagh Education Institute
08.2018 - 06.2021
Similar Profiles
Dimple ShahDimple Shah
AVP | Anti-Ad Fraud Expert at mFilterItAVP | Anti-Ad Fraud Expert at mFilterIt
Manish PhalwariaManish Phalwaria
Senior Manager at International Shared Support CentreSenior Manager at International Shared Support Centre
Chandra Jeet SinghChandra Jeet Singh
Network Architect (Offboard Connectivity) and Project Management at TATA Consultancy Services (JLR UK)Network Architect (Offboard Connectivity) and Project Management at TATA Consultancy Services (JLR UK)
Gaurav Kumar PanchalGaurav Kumar Panchal
Consultant at ZS AssociatesConsultant at ZS Associates
Durgesh ChoudharyDurgesh Choudhary
Head of Sales ,Marketing, Strategy and IT at Jay Switches India Pvt LimitedHead of Sales ,Marketing, Strategy and IT at Jay Switches India Pvt Limited