Nitin Yadav

About

Data Analyst with 2.5+ years in banking (BFSI) analytics at Shivalik Small Finance Bank, promoted to Deputy Manager in 21 months. Own end-to-end reporting across departments: automated 200+ MIS and RBI regulatory reports (2–3 hours to 3–5 minutes), built 20+ dashboards used by senior management, and analyse lakhs of daily transactions with Oracle SQL, Python and Power BI. Backed by 5+ years in regulatory data management and two deployed ML apps.

Skills & Expertise (68)

Power BI Advanced

9.2/10

7

Years Exp

Data Visualization Advanced

8.6/10

7

Years Exp

Data Cleaning Advanced

8.5/10

7

Years Exp

ETL Advanced

8.4/10

7

Years Exp

DAX Advanced

8.2/10

7

Years Exp

Data Modelling Advanced

8.1/10

7

Years Exp

Data Governance Advanced

8.0/10

7

Years Exp

Data Validation Advanced

7.9/10

7

Years Exp

Root Cause Analysis Advanced

7.8/10

7

Years Exp

FastAPI HTML Web Scraping PySide6 CustomTkinter scikit-learn Flask Selenium OpenpyXL NumPy Pandas VS Code Jupyter CSS JS VBA XGBoost LightGBM SHAP Retail Banking Digital Payments UPI IMPS Transaction Reconciliation AML KYC Cyber Security audit support Data Quality MS Access Business Intelligence Data Storytelling KPI Tracking MIS Reporting Report Automation Ad-hoc Analysis Trend Analysis Campaign Analysis Customer Segmentation Hypothesis Testing Requirements Gathering Oracle SQL SQL Server MySql GitHub CTEs Window Functions Joins Indexing Query Optimisation Data Marts Power Query Row-Level Security Advanced Excel Pivot Tables EDA Plotly Streamlit Git

Work Experience

Deputy Manager (Data Analyst)

Shivalik Small Finance Bank

Jan 2026 - Present

Report automation: Automated 200+ recurring MIS and regulatory reports (daily to yearly) for Risk, Compliance, Operations, Recovery and Audit with Python, VBA and Oracle SQL, with built-in validation checks and alerts; ~80% fully automated, cutting 2–3 hours to 3–5 minutes. Dashboards: Built and maintain 20+ Power BI, Excel and Flask web dashboards on deposits, loans, digital transactions and customer activity, used by senior management and product leaders, refreshed via scheduled Finacle and Oracle extracts. Data modelling & SQL: Created reusable Oracle SQL views and data marts as a shared data layer for reports; analyse lakhs of daily transactions and cut query run time by ~40% on multi-million-row tables. Reconciliation tool: Built a Python desktop tool (PySide6, Selenium) that downloads NPCI settlement files, reconciles ~1 lakh daily UPI/IMPS transactions against Finacle and prepares TTUM files, reducing manual work by ~98%. Customer & campaign analytics: Identified accounts at risk of turning dormant through EDA on customer and transaction data, enabling reactivation that stopped a large number from going dormant; measured 15+ campaigns and presented results to business heads. Data quality & compliance: Performed root cause analysis on mismatches between Finacle, NPCI and MIS source data and fixed them at source; prepared RBI submissions (AML, KYC, Cyber Security), supplied data for internal, statutory and RBI audits, and handled urgent regulator and management requests. Ownership & leadership: Own departmental reporting end to end, review reports, mentor juniors, document report logic and SOPs, and automate manual processes taken over from other teams.

Assistant Manager (Data Analyst)

Shivalik Small Finance Bank

Apr 2024 - Dec 2025

Report automation: Automated 200+ recurring MIS and regulatory reports (daily to yearly) for Risk, Compliance, Operations, Recovery and Audit with Python, VBA and Oracle SQL, with built-in validation checks and alerts; ~80% fully automated, cutting 2–3 hours to 3–5 minutes. Dashboards: Built and maintain 20+ Power BI, Excel and Flask web dashboards on deposits, loans, digital transactions and customer activity, used by senior management and product leaders, refreshed via scheduled Finacle and Oracle extracts. Data modelling & SQL: Created reusable Oracle SQL views and data marts as a shared data layer for reports; analyse lakhs of daily transactions and cut query run time by ~40% on multi-million-row tables. Reconciliation tool: Built a Python desktop tool (PySide6, Selenium) that downloads NPCI settlement files, reconciles ~1 lakh daily UPI/IMPS transactions against Finacle and prepares TTUM files, reducing manual work by ~98%. Customer & campaign analytics: Identified accounts at risk of turning dormant through EDA on customer and transaction data, enabling reactivation that stopped a large number from going dormant; measured 15+ campaigns and presented results to business heads. Data quality & compliance: Performed root cause analysis on mismatches between Finacle, NPCI and MIS source data and fixed them at source; prepared RBI submissions (AML, KYC, Cyber Security), supplied data for internal, statutory and RBI audits, and handled urgent regulator and management requests. Ownership & leadership: Own departmental reporting end to end, review reports, mentor juniors, document report logic and SOPs, and automate manual processes taken over from other teams.

Executive Liaison

Planetcast Media Services Ltd

Apr 2022 - Apr 2024

Validated and submitted regulatory data to government portals (Saral Sanchar, Broadcast Seva) using MS Access and Excel; built standard templates that cut submission turnaround by ~35% and worked with IT teams on portal specifications.

Data Entry Operator (Contractual)

Ministry of Information & Broadcasting

Oct 2018 - Apr 2022

Maintained the national database of 900+ permitted TV channels in Excel and MS Access, ensuring accuracy for regulatory decisions, and processed satellite TV and teleport licences end to end, handling an Assistant Section Officer’s workload.