Ayushi Gupta
Faridabad
Summary
Experienced Data Analyst with over 6 years in banking and financial services, skilled in SQL, Power BI, Python, Tableau, and Excel. Proven track record in automating reporting processes and developing impactful dashboards. Certified in Data Science and Business Management, with deep expertise in BFSI domain analytics.
Overview
8
8
years of professional experience
Work History
Deputy Manager
HDFC Bank Ltd
Mumbai
08.2022 - 09.2023
- Designed MIS dashboards & reports in Excel/Power BI to track KPIs.
- Automated data integration from CRM and Core Banking systems to streamline reporting and improve operational efficiency.
- Conducted trend analysis of customer transactions, supporting strategic decisions.
- Collaborated with cross-functional teams to integrate data from multiple sources (CRM, Core Banking, Sales).
Deputy Manager
ICICI Bank Ltd
Mumbai
04.2021 - 08.2022
- Developed and optimized Excel/Power BI dashboards to enhance KPI tracking and facilitate strategic decision-making.
- Conducted thorough trend analysis of customer transactions, providing actionable insights for strategic planning.
- Monitored sales productivity and KPIs, ensuring data accuracy in reports.
- Built branch-level scorecards, enabling senior management to compare performance across 50+ branches.
- Partnered with IT to refine SQL queries, significantly reducing data retrieval time and improving report accuracy.
Assistant Manager
IndusInd Bank Ltd
Mumbai
09.2019 - 04.2021
- Generated advanced MIS reports to analyze client portfolios.
- Enhanced reporting processes, improving operational efficiency by 15%.
Finance Research Executive
Money Honey Financial Services Pvt. Ltd.
Mumbai
04.2019 - 09.2019
- Conducted financial data analysis for 50+ clients.
- Developed Excel-based financial reports to support investment decisions.
- Supported investment decisions, contributing to ₹1 crore in revenue growth.
Consultant | Freelance
Supertech Project (UK) Ltd.
Mumbai
07.2018 - 01.2019
- Responsible for analyse the document complex business data issues and provide clear problem statements and
recommendations - Responsible for data gathering, data enrichment and data maintenance through client or in-house databases
- Responsible for maintaining lead database in Excel and collect the report from team on daily basics
- Using Advance excel tools and systems to ensure timely delivery
Business Intelligence and Research Executive
BlueTown (India) Pvt. Ltd
New Delhi
01.2017 - 04.2018
- Planning and overseeing new marketing initiatives
- Prepared Business plans for ongoing projects
- Managed research and market needs on a global basis (mainly Asia Pacific)
- Supported in Site desk Surveys on google earth software
- Closely worked with top management on the market research of other countries.
- Worked closely with the project management team to analyze and consolidate request requirements to improve
the decision planning process and meeting project deadlines.
Research Assistant
SAAM Corp Advisors Pvt. Ltd.
New Delhi
07.2015 - 12.2016
- Prepared analysis & comparison reports on responses of various stakeholders to TRAI's Consultation Paper
- Preparing analysis reports on Telecom Policies and Regulations.
- Worked on the project of Voice Regulations Development in APAC
Education
Data Science Certification Course -
Internshala
01-2025
Executive Program in Business Management -
Institute of Management Technology , Ghaziabad
10-2024
Bachelor of Technology in Electronics and Communication -
JSS Academy of Technical Education, Noida
Noida06-2015
Diploma in Electronics And Communication -
HSBTE
Faridabad07-2012
Skills
- Advanced SQL Techniques
- Python Data Visualization
- BI Dashboard Optimization
- KPI Development
- Data Quality Assurance
Projects
- Instagram User Analytics Using SQL - Analyzed engagement data to derive insights for marketing & growth.
- Sales Performance Analysis of Walmart Stores Using Advanced MySQL Techniques-· Used advanced SQL queries to uncover customer behavior & sales trends.
- Airline Performance Analysis using Power BI - · Built dashboards to analyze flight schedules, passenger management & booking trends.
- Electric vehicles market size analysis using Python - Performed EDA, outlier detection & recommendations using Python (Pandas/Matplotlib).
Timeline
Deputy Manager
HDFC Bank Ltd
08.2022 - 09.2023
Deputy Manager
ICICI Bank Ltd
04.2021 - 08.2022
Assistant Manager
IndusInd Bank Ltd
09.2019 - 04.2021
Finance Research Executive
Money Honey Financial Services Pvt. Ltd.
04.2019 - 09.2019
Consultant | Freelance
Supertech Project (UK) Ltd.
07.2018 - 01.2019
Business Intelligence and Research Executive
BlueTown (India) Pvt. Ltd
01.2017 - 04.2018
Research Assistant
SAAM Corp Advisors Pvt. Ltd.
07.2015 - 12.2016
Data Science Certification Course -
Internshala
Executive Program in Business Management -
Institute of Management Technology , Ghaziabad
Bachelor of Technology in Electronics and Communication -
JSS Academy of Technical Education, Noida
Diploma in Electronics And Communication -
HSBTE
Similar Profiles
KAMALA SUBRAMANIANKAMALA SUBRAMANIAN
Senior Vice President and Unit Head at HDFC Bank Limited, HDFC BankSenior Vice President and Unit Head at HDFC Bank Limited, HDFC Bank
Jignesh PatelJignesh Patel
Relationship Manager at HDFC Sales Pvt. Ltd. (Group Company Of HDFC Bank)Relationship Manager at HDFC Sales Pvt. Ltd. (Group Company Of HDFC Bank)
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
YOGESH ASHOK KALEKARYOGESH ASHOK KALEKAR
Preferred Relationship Manager(Hybrid Portfolio) at HDFC BANK LTDPreferred Relationship Manager(Hybrid Portfolio) at HDFC BANK LTD
MANDIRA THAKURMANDIRA THAKUR
Cluster Head at Derma Arts ClinicCluster Head at Derma Arts Clinic