Rashi Gupta

Data Analyst

[email protected] +91 7976239713

Resume

Hello, I am

Rashi Gupta.

2

Excel
Projects

1

PowerBI
Project

1

SQL
Project

1

Python
Project

About Me

Hi, I’m Rashi — a data analyst in transition, with experience as a Technical Analyst in the finance industry. I’ve solved high-impact problems using SQL, Excel, and log analysis, acting as a bridge between dev teams and business needs.

In my current role, I don't just resolve incidents. I spot patterns, trace root causes, and turn technical noise into actionable insights. This made me realize I am already doing data-driven analysis.

Since then, I’ve been upskilling in Python, Power BI, and data storytelling by building hands-on projects that bring clarity to messy datasets.

And now I've finally become ready to grow into a full-fledged data analyst — combining my curiosity, analytical thinking, stakeholder management, and problem-solving skills — to help businesses make smarter, data-backed decisions.

Let’s connect if you’re hiring, collaborating, or just love talking data!

Key Skills

SQL

Python

Power BI

Excel

Data Storytelling

Stakeholder communication

Reporting Automation

Data Extraction

Data Visualisation

Data Analysis

Data Cleaning

ETL

My Projects

Business Insights 360

Domain/Function: B2B Tech – Sales, Finance, Marketing, & Supply Chain Analytics

AtliQ Hardware – SQL Reporting & Business Insights

Domain/Function: Computer Hardware Peripherals

Excel - Finance Analytics

Domain/Function: Finance Analytics

AtliQ Hardware - Sales Analytics

Domain/Function: Sales Analytics

Chennai Real Estate: Data to Price Predictions

Domain/Function: Real Estate

My Experience

TECHNICAL ANALYST II (Data Analytics Focused) - Bank of America, Gandhinagar

𝘈𝘶𝘨 2024 – 𝘗𝘳𝘦𝘴𝘦𝘯𝘵

 Investigated 66K+ IVR call records using SQL and Excel to uncover a 20%+ MoM spike in database failures; identified two recurring patterns causing ~60% of issues, leading to targeted fixes and reduced agent transfers – eCard.

 Engineered SQL queries to detect post-deployment issues in IVR before escalation by business teams or customers, pinpointed 2 critical defects in Fraud and Payments flow, preventing impact for 1,000+ customers – High-five Global Award.

 Analysed 180K+ IVR calls to identify drivers of high abandonment; delivered key insights such as geographic concentration in AZ DC, occurrence in Deposits IVR flow, linkage to a specific 800-TFN, supporting root cause resolution and achieving an 82% reduction in failed calls.

 Drove ad-hoc analysis of IVR call volumes by caller intent and business verticals, surfacing monthly 18K+ account opening enquiries and 19.94M+ Deposits IVR calls.

 Automated repetitive IVR server health checks using shell scripting, cutting validation time by 90%, streamlining data validation workflows and improving operational reliability.

TECHNICAL ANALYST - Bank of America, Gandhinagar

𝘑𝘶𝘭 2022 – 𝘑𝘶𝘭 2024

 Extracted data using SQL, Splunk queries and spearheaded root cause analysis for 50%+ IVR production issues by analysing operational data, identifying trends and insights and offering analytical solutions – Bronze Global Award.

 Diagnosed 404 error on 29 IVR voice prompts by writing ETL scripts, reduced errors by 900 daily, resulting in clearer and smoother IVR prompts for customers – Bronze Global Award.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Machine Learning

Microsoft Azure Cloud Fundamentals AZ-900

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/rashigupta111/

Call Me

+91 7976239713

GitHub

https://github.com/courageoustouch/

PowerBI Project

Business Insights 360

Domain/Function: B2B Tech – Sales, Finance, Marketing, & Supply Chain Analytics

An interactive Power BI dashboard that transforms raw data into powerful business stories—offering dynamic, visually engaging insights that help AtiQ Hardware's leadership make smarter, faster decisions across finance, sales, marketing and supply chain functions.

Other Tools

SQL

Excel

DAX Studio

Tracks Net Sales, Gross Margin, and Profit trends over time with dynamic filters, P&L breakdown, and top-region performance insights.

Visualizes product, segment, and regional performance using NP%, GM%, and NS\$ to identify marketing impact and profitability trends.

Project Details

Business Insights 360 (BI 360) is a comprehensive Power BI dashboard designed to revolutionize data-driven decision-making at AtliQ Hardware, a global B2B tech company. Facing losses from intuition-based expansion and rising competition, AtliQ launched BI 360 to gain clarity, transparency, and insight across five key domains—Finance, Sales, Marketing, Supply Chain, and Executive. This multi-view tool empowers teams with real-time metrics, trend analysis, and deep customer-product insights, helping optimize pricing, forecast demand, and track profitability. By turning complex data into actionable visuals, BI 360 transformed scattered data into strategic intelligence—ensuring smarter decisions, higher efficiency, and a stronger market presence.

Live Interactive Dashboard

SQL Project

AtliQ Hardware – SQL Reporting & Business Insights

Domain/Function: Computer Hardware Peripherals

SQL-powered case study simulating real analyst tasks for AtliQ Hardware. From JIRA tickets to business insights, it transforms raw data into clear, strategic decisions.

View Project
on

Other Tools

Excel

Croma India Sales Report for 2021

Stored Procedure for Market Badging based on Sales Volume

Project Details

This end-to-end SQL reporting project for AtliQ Hardware simulates a fast-growing B2B firm’s journey from Excel chaos to scalable SQL-based analytics. It mirrors real-world analyst workflows, where I translated JIRA tasks into performant SQL scripts, created business-critical reports, and validated data with Excel. Covering sales, forecasting, and performance insights, the project showcases stored procedures, CTEs, window functions, and business storytelling. Each deliverable solves a tangible business challenge—helping leadership benchmark performance, spot trends, and make confident, data-driven decisions.

Excel Project

Excel - Finance Analytics

Domain/Function: Finance Analytics

Interactive Excel-based financial analytics tool offering dynamic P&L reports by fiscal year, month, and market—empowering data-driven insights for better decision-making and strategic planning.

View Project
on

Finance Analytics - P&L by Fiscal Year

Finance Analytics - P&L by Months

Project Details

Excel-FinanceAnalytics is a comprehensive financial reporting solution that provides Profit & Loss (P&L) analysis across fiscal years, months, and market segments. Designed to support strategic decisions, it helps users evaluate performance trends, identify anomalies, and align financial plans with business goals. The reports are crafted using Power Query, Power Pivot, and DAX, enabling automated data transformation and analysis. Ideal for professionals seeking clear insights, it facilitates effective communication with stakeholders and supports budgeting, forecasting, and risk management efforts. Open the PDF reports to explore dynamic, user-friendly financial visuals that drive results.

Excel Project

AtliQ Hardware - Sales Analytics

Domain/Function: Sales Analytics

Excel-SalesAnalytics delivers powerful sales insights through dynamic Excel reports—analyzing customer, market, product, and regional performance from 2020–2021 to support strategic decisions and drive business growth.

View Project
on

Division Performance Report showing 2020 and 2021 sales across different divisions and their performance.

Product Performance Report showing 2020 and 2021 sales across different products and their performance.

Project Details

Excel-SalesAnalytics is a comprehensive Excel-based solution designed to uncover key sales insights from 2020 and 2021. It features dynamic reports analyzing customer contributions, market performance against targets, product trends, divisional growth, and top-performing countries. The dashboards empower businesses to track KPIs, identify sales patterns, and optimize pricing, inventory, and strategy. Built using Power Query, Power Pivot, and DAX, the project integrates ETL processes and data modeling to create interactive and insightful reports. Ideal for sales professionals, it enhances decision-making, supports negotiations, and reveals expansion opportunities—all through user-friendly, PDF-accessible visual reports.

Python Project

Chennai Real Estate: Data to Price Predictions

Domain/Function: Real Estate

Analyzed housing data to identify key factors influencing property prices in Chennai and built a predictive model to estimate house prices with improved accuracy.

View Project
on GitHUB

Exploring relationship between area of different types of house and their prices - observed positive correlation

Deployed LightGBM model, created feature importance plots to show top factors affecting house prices

Project Details

Cleaned and transformed 7000+ Chennai property listings and then performed univariate and bivariate analysis to uncover how different features of a property affect its price. Generated key insights and deployed LightGBM model (R-squared = 0.993) to accurately predict Chennai's house prices.