Ayan Bhaskar
Pune
Summary
Data Analyst with proven expertise in SQL, data pipelines, and dashboard development, gained through experience at Mercedes Benz India Limited and BNP Paribas. Successfully built automated Power BI solutions that enhanced reporting accuracy and supported data-driven decision-making. Proficient in CRM analytics and financial data analysis, with a focus on customer retention insights. Strong communicator skilled in stakeholder engagement and optimizing business processes across various functions.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analyst
Merecedes Benz India Limited
PUNE
05.2025 - Current
- Engineered comprehensive Power BI dashboards for Sales, After-Sales, and VOC insights utilizing intricate DAX formulas and automated data pipelines.
- Achieved significant efficiency gains by automating reporting processes with Salesforce, UiPath, and Power Automate to lessen manual Excel tasks and errors.
- Partnered closely with Franchise Partners to discern business needs, accelerate sales growth, and produce analytics focused on customer experiences.
- Directed two critical projects: Customer Retention involving Azure Databricks analysis of financial service data and Customer Survey Analytics for assessing VOC survey responses to improve customer satisfaction throughout ownership journeys.
- Enhanced data quality standards and CRM processes across various sales channels through collaborative efforts with cross-functional teams.
Intern
BNP Paribas
Mumbai
02.2025 - 04.2025
- Streamlined workflow processes to improve team productivity.
- Supported liquidity forecasting, asset allocation, and financial risk reviews in Asset Management, Liability & Treasury department.
- Assisted in preparation of treasury reports, daily P&L summaries, and reconciliation files.
- Conducted data analysis using Excel and SQL for informed cash flow planning and investment decisions.
- Acquired knowledge in global banking operations and treasury control frameworks.
Intern
Mercedes Benz India Limited
PUNE
06.2024 - 12.2024
- Executed DAX codes and developed charts to clarify sales data during internship at Mercedes Benz India Limited.
- Conducted data cleaning and preparation as part of pre-processing tasks.
- Demonstrated proficiency in Power BI, Azure, SQL, and MS Excel for data analysis.
Education
Integrated B.Tech - CSE Core
Dr. Vishwanath Karad MIT WORLD PEACE
Pune, IN06.2025
High School Diploma -
Army Public School
Pune06-2021
Skills
- Data analysis and interpretation
- SQL and data pipeline management
- Dashboard development
- CRM analytics and automation
- Stakeholder communication
- Data modeling and ETL
- Interactive reporting
- Process documentation
Certification
• Power Bi, Udemy
• Artificial Intelligence, Udemy
• Python Analysis, Hacker Rank
• Artificial Intelligence, Udemy
• Python Analysis, Hacker Rank
Leaderships And Involvements
- Bankers Connect Day and Product Experience: Assisted in organizing a professional networking event where senior executives from leading banks were invited to engage with our team, explore product capabilities, and build future business relationships
- BNP Hackathon: Collaborated with a diverse team of participants in a 24-hour hackathon to design and develop a fully functional finance dashboard using PHP, MySQL, Python, Flask, and MongoDB
Timeline
Data Analyst
Merecedes Benz India Limited
05.2025 - Current
Intern
BNP Paribas
02.2025 - 04.2025
Intern
Mercedes Benz India Limited
06.2024 - 12.2024
Integrated B.Tech - CSE Core
Dr. Vishwanath Karad MIT WORLD PEACE
High School Diploma -
Army Public School