Jai Singh Yadav

BI Analyst

Gurugram, Haryana, India 2+ yrs exp 85 · Excellent

About

2.5 years of experience specializing in BI Analyst, operational reporting, and automation. Proficient in leveraging SQL, Python, and Advanced Excel to extract, manipulate, and analysed complex datasets. Proven track record in updating and publishing critical business reports, building dashboards, and delivering actionable insights that drive business strategy

Skills & Expertise (16)

Automation Advanced

8.0/10

2.5

Years Exp

SQL Intermediate

7.5/10

2.5

Years Exp

Basic Python Beginner

5.5/10

Years Exp

Python Beginner

5.5/10

Years Exp

Azure Databricks Intermediate

5.0/10

Years Exp

Basic Power BI Beginner

5.0/10

Years Exp

Pandas Beginner

5.0/10

Years Exp

NumPy Beginner

4.5/10

0.5

Years Exp

Natural Language Processing Beginner

4.0/10

0.5

Years Exp

Speech-to-Text Beginner

4.0/10

0.5

Years Exp

ChatGPT Beginner

4.0/10

0.5

Years Exp

FastAPI Beginner

3.5/10

0.5

Years Exp

React Beginner

3.0/10

0.5

Years Exp

Advance MS Excel Google sheet MS Power Point

Work Experience

BI Analyst

RBL Bank

Feb 2025 - Present

Prepared monthly P&L reports and performed MoM/YoY variance analysis for the Corporate Credit Card portfolio, analyzing revenue streams, cost drivers, and profitability while automating reporting processes to reduce manual effort by 30% and processing time by 25%. Developed and automated KPI dashboards to monitor portfolio performance, approval rates, card growth, spend, retention, and key financial metrics, reducing manual reporting effort by 40% and improving decision-making speed by 15%. Income Reversal Fee reports: Built automated reports to analyze system vs. manual fee reversals, departmental accountability, and revenue impact, enabling Finance, Operations, and Risk teams to reduce manual effort by 45% and cut report turnaround time by 50%. Designed automated product suitability reports to identify upsell opportunities and evaluate customer eligibility based on usage, fees, and charges, reducing manual workload by 75%. Created executive Acquisition and MD performance decks by consolidating cross-functional business insights, analyzing key portfolio metrics, and delivering strategic presentations to senior leadership with improved reporting quality and efficiency.

MIS Executive

Quick Clean Pvt Ltd

Mar 2024 - Feb 2025

Reporting and Analysis: Developed and maintained reports on a monthly, weekly with insights, and yearly basis to track revenue performance. Salary Reports: Prepared salary reports to ensure accuracy, including detailed breakdowns of employment salaries. Cost Management: Monitored and reported on repair and maintenance costs, as well as chemical expenditures. Engineer Visit Tracking: Managed and documented engineer visit data, including associated costs.