Deepannita Gupta
Gurugram
Summary
Data Analyst with 4 years of experience applying statistical analysis, SQL, Python, and Power BI to solve business problems in the banking sector. Skilled in exploratory data analysis, feature engineering, and trend modeling using Pandas, NumPy, and visualization libraries. Experienced in designing interactive Power BI dashboards and automated reporting workflows that optimize compliance tracking, risk scoring, and customer analytics. Adept at bridging technical expertise with business needs to deliver measurable improvements in efficiency and decision quality.
Technical-Python (Pandas, NumPy) SQL, Azure Cloud, Requirement handling in Azure Boards and IBM DOORS .Experience in creating Scrum and Kanban board on JIRA, Power Query, DAX,Data modeling and Cleaning, C++. Tool -Power BI, Sharepoint, Splunk,Advance Excel, Figma, MS Viso, ITSM, Genesys ,Jira,Service now. Risk Metrics: FOIR, PD/LGD, NII, EVE, IRRBB (Basel) Documentation Skills-BRD,FRD,SRS, Design Docs,Wireframing, SOW, Release Notes, Data Extraction.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Technical Analyst-II
Bank of America
Gurugram
11.2021 - Current
- Spearheaded requirements gathering efforts, collaborating closely with stakeholders to identify needs and potential solutions, implementing Gap Analysis
- Maintaining and tracking requirements on Azure Boards and DOORS for two different projects.
- Created dashboards to display sales performance against goals, marketing campaign effectiveness, and .20+ other key metrics, which enhanced executive visibility into business operations by 48%.
- Engineered binary outcome variables for credit rule violation tracking; used logistic regression and random forest models to predict loan default based on rule deviation patterns, improving default prediction recall 22%.
- Used Python (Pandas, Seaborn) to perform exploratory analysis of credit applicant profiles; visualized top rule violation trends and engineered features for risk scoring models.15%.
- Validated model accuracy across different cohorts using cross-validation and monitored false positive rates for operational integration.
- KPIs and report generation for data analysis and creation of dashboards in Power BI..
- Utilized Agile engineering principles to deliver innovative features to 4800+ users and incorporated them future development.
- Utilized tools such as Power BI, Bank of America proprietary systems to conduct financial data reconciliation and perform visual analytics tailored to audit requirements.
- Leveraged Python (Pandas, NumPy, Scikit-learn) to create advanced forecasting models and build interactive dashboards, enabling data-driven decision-making on KPIs related to user acquisition, retention, and monetization
Project Experience - Credit Rule Validation System
11.2021 - Current
- Collaborated with policy and product teams to translate 30+ credit rules (FOIR, DPD) into SQL-based validation logic. Created violation frequency score, DPD risk bands, and income staleness features; pipeline reduced manual underwriting by 30%.
- Utilized SQL to analyze data collected on the Responsys platform to generate insights on customer behavior patterns such as preferred products, peak purchase times, etc. resulting in a better understanding of customer needs, leading to a 15% increase in repeat customers.
- Developed Power BI dashboards to visualize credit rule pass/fail status and rejection reasons across customer segments; enabled dynamic filtering and drill-through for deeper RCA by credit teams.
- Created impactful data visualizations using Matplotlib and Seaborn for static plots for interactive, dynamic dashboards, helping to communicate complex insights clearly to stakeholders.
- Conducted RCA for top failing applications and implemented RCA workflow that decreased manual rework time by 30%.Designed Python-based pre-validation scripts (Pandas) to identify high-risk cases; reduced invalid applications by 21%
Project Experience - Mortgage Portfolio IRRBB Simulation - NII & EVE Sensitivity
11.2021 - Current
- Used NumPy and Pandas to simulate monthly cash flows and prepayments using customer behavioral overlays.
- Created an Interactive Power BI Dashboard using DAX and Visualized NII/EVE sensitivity in Power BI with waterfall charts Page Navigation, Drill through, and scenario toggles, enhancing ALCO-level decision making.
- Modeled monthly cashflows under parallel and steepening rate shocks using NumPy, simulating behavior-driven prepayment curves.
- Built a regulatory-grade IRRBB simulator using customer mortgage data (50K+ loans) to forecast NII & EVE sensitivity across 6 Basel stress scenarios.
- Created a repricing ladder by bucketing 50K+ mortgage contracts by reset dates, tenure, and interest type (fixed/variable).
Project Experience - Customer Banking Data Analysis
- Explore the data using Python (Pandas) to understand its distribution, missing values, and correlations.
- Visualize key metrics (e.g., churn rate, customer usual time) using Matplotlib or Seaborn.
- Choose an appropriate machine learning algorithm (e.g., logistic regression, random forest, or XGBoost).
- Expertly use Pandas and NumPy for transforming large datasets, handling missing data, and optimizing data preparation for analysis, ensuring accuracy and efficiency in data pipelines.
Education
Bachelor of Engineering - Electronics and Electronics Engineering
SRM Institute of Science and Technology
Chennai, India01.2021
Skills
- Data analysis
- SQL programming
- Power BI dashboards
- Stakeholder collaboration
- Requirement gathering
- Data visualization
- Statistical analysis
- Financial reconciliation
- Implementation strategies
Websites
Certification
- Microsoft AZURE-900
- Agile with Atlassian JIRA
- Data Visualization with Power BI
- Linux with Cisco
Phone
+91, 7355071163
Summary
Python (Pandas, NumPy), SQL, Azure Cloud, Requirement handling in Azure Boards and IBM DOORS, C++, Power BI, Sharepoint, Splunk, Advanced Excel, Figma, MS Visio, ITSM, Genesys, Jira, ServiceNow, FOIR, PD/LGD, NII, EVE, IRRBB (Basel), BRD, FRD, SRS, Design Docs, Wireframing, SOW, Release Notes, Data Extraction
Timeline
Technical Analyst-II
Bank of America
11.2021 - Current
Project Experience - Credit Rule Validation System
11.2021 - Current
Project Experience - Mortgage Portfolio IRRBB Simulation - NII & EVE Sensitivity
11.2021 - Current
Project Experience - Customer Banking Data Analysis
Bachelor of Engineering - Electronics and Electronics Engineering
SRM Institute of Science and Technology