Deepak Gupta
Senior Data Analyst/BI Analyst/MIS & Reporting Lead
New Delhi,DL
Summary
BI & SQL Developer with 5+ years of experience in designing data models, writing optimized SQL queries, and developing interactive dashboards for financial and operational analytics. Experienced in Power BI, advanced SQL querying, ETL processes, and reporting automation. Proven ability to transform large datasets into actionable insights that improve business performance and compliance efficiency.
Overview
6
6
years of professional experience
2
2
Certifications
2
2
Languages
Work History
Deputy Manager – Analytics
Sitara Housing Finance
03.2023 - Current
- Developed Power BI dashboards for portfolio monitoring and revenue analysis.
- Wrote optimized SQL queries for extracting and aggregating financial datasets.
- Automated NHB regulatory reporting, saving 30+ hours/month.
- Improved forecasting accuracy by 20% using trend analysis models.
- Reduced manual data handling through ETL automation.
Data Analyst
SOFT-Tech Software Solutions
05.2020 - 03.2023
- Processed and validated 500K+ records using SQL and Excel.
- Reduced reporting time by 40% through SQL automation and VBA scripting.
- Built interactive dashboards to track KPIs and operational performance.
- Developed scalable data pipelines for reporting workflows.
Education
Master of Science - Mathematics
Asian International University
Imphal, India 04.2001 -
B.Tech - IT And Mathematical Innovation
Cluster Innovation Centre, DU
Delhi, India 04.2001 -
Intermediate Certificate - Science
Vishwa Bharati Public School, CBSE
Delhi, India 04.2001 -
High School Diploma -
Holy Heart Public School, CBSE
Delhi, India 04.2001 -
Skills
Databases & Querying:SQL (Advanced Queries, Performance Optimization, Data Extraction, Aggregations)
Excel & Automation:Advanced Excel, VBA, Macros, Power Query, Pivot Tables
Programming:Python (Pandas, NumPy), R
Data Processing:ETL, Data Cleaning, Data Transformation
BI & Visualization:Power BI (DAX, Data Modeling, Relationships, Drill-through Reports), Tableau
Additional Information
Project 1: NBFC Portfolio Performance & Risk Dashboard
Tools: SQL, Power BI, Excel
Domain: Financial Analytics
- Designed and developed an interactive Power BI dashboard to monitor loan disbursement, portfolio health, NPA trends, and revenue performance.
- Built SQL-based data extraction pipelines integrating 100K+ loan records.
- Implemented KPI tracking for collection efficiency, overdue accounts, and region-wise performance.
- Enabled leadership to identify high-risk segments, supporting proactive decision-making.
- Reduced manual portfolio tracking effort by 40%.
Tools: SQL, Excel VBA, Power Query
- Developed automated reporting solution for NHB and internal compliance submissions.
- Created parameter-driven SQL queries for monthly financial summaries.
- Built Excel VBA macros to auto-generate formatted compliance reports.
- Reduced reporting turnaround time from 2 days to same-day submission.
- Improved reporting accuracy and minimized manual intervention.
Certification
Data Visualization with PowerBI
Timeline
Data Visualization with PowerBI
02-2026
Introduction to Analytics & Excel
12-2025
Deputy Manager – Analytics
Sitara Housing Finance
03.2023 - Current
Data Analyst
SOFT-Tech Software Solutions
05.2020 - 03.2023
Master of Science - Mathematics
Asian International University
04.2001 -
B.Tech - IT And Mathematical Innovation
Cluster Innovation Centre, DU
04.2001 -
Intermediate Certificate - Science
Vishwa Bharati Public School, CBSE
04.2001 -
High School Diploma -
Holy Heart Public School, CBSE
04.2001 -