Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

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
Noida
06-2015

Diploma in Electronics And Communication -

HSBTE
Faridabad
07-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
Ayushi Gupta