SHIVAM AGGARWAL
New Delhi
Summary
Dynamic Assistant Manager at State Bank of India, demonstrating expertise in SQL and data analytics. Achieved a 20% improvement in the branch credit portfolio through comprehensive financial data analysis. Proficient in compliance reporting and risk assessment, utilizing strong analytical skills to enhance operational efficiency and decision-making processes. Aiming to leverage this expertise to further drive strategic initiatives in financial management.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Assistant Manager
State Bank of India (SBI)
New Delhi
02.2021 - 11.2024
- Managed a credit portfolio of over 900 million and analyzed more than million financial and customer data to identify trends and optimize operational efficiency.
- During probation in rural assignment, analyzed income patterns based on customer's data in CBS and improved branch credit portfolio by 20%.
- Ensured RBI regulatory compliance by preparing internal reports related to data privacy and financial transactions.
- Extracted useful insights from Excel-based reports for growth in deposits and finding potential leads for different B2C products of the bank.
- Identified fraud patterns, helping the risk team mitigate potential financial losses and assisted in audits by providing relevant data and documents.
- Used branch's data to analyze customer behavior, loan repayments, and deposits trend and achieved growth in deposits by 15%.
Education
B.Tech - Electrical and Electronics Engineering
Guru Gobind Singh Indraprastha University
New Delhi01.2019
Skills
- SQL
- Python
- Pandas
- NumPy
- Matplotlib
- Seaborn
- Power BI
- Tableau
- MySQL
- PostgreSQL
- Pivot Tables
- VLOOKUP
- Dashboarding
- Data Cleaning
- Transformation
- Warehousing
- Risk Assessment
- Credit & Fraud Analytics
- Compliance Reporting
Certification
- Google Data Analytics Professional Certificate, In Progress
- SQL for Data Science, Coursera
- Python for Data Analysis, Udemy
Projects
Banking Fraud Detection(SQL, Python): Designed an SQL-based system to detect suspicious transactions in real time. Used Python (Pandas, Matplotlib) to visualize fraudulent transaction patterns.
Hobbies and Interests
- Financial Data Analysis
- AI in Banking
- Business Intelligence
Timeline
Assistant Manager
State Bank of India (SBI)
02.2021 - 11.2024
B.Tech - Electrical and Electronics Engineering
Guru Gobind Singh Indraprastha University
Similar Profiles
Somnath AdhyaSomnath Adhya
General Manager at State Bank of India (SBI)General Manager at State Bank of India (SBI)
MOHAN KRISHNA SAI ADUSUMALLIMOHAN KRISHNA SAI ADUSUMALLI
Relationship Manager at State Bank of India, SBIRelationship Manager at State Bank of India, SBI
Damini TadghareDamini Tadghare
Customer Support Executive at State Bank of India, SBICustomer Support Executive at State Bank of India, SBI