Aurangzeb Alam
Okhla
Summary
Analyst with extensive experience in the banking sector, leading strategic analytics initiatives and managing high-impact projects. Expert in credit cost prediction, settlement strategies, and executive reporting. Skilled in Advanced Excel, Power BI, and Python, with a strong track record of partnering with senior leadership to drive data-driven business transformation.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Sr. Manager – Data Analyst
HDFC Bank
08.2019 - Current
- Led development of sophisticated credit cost prediction models using Python and Excel, significantly improving forecast precision for strategic planning.
- Managed inventory prediction frameworks to optimize collections resource allocation and enhance operational efficiency.
- Managed FY target roll-outs and budget processes, aligning analytical insights with business objectives and resource allocation.
- Spearheaded design and execution of settlement strategies, leveraging analytics to optimize recovery performance.
- Designed and implemented a focus segment strategy in recovery collections, resulting in a significant uplift in recovery rates.
- Developed and monitored scorecard-based risk segmentation, incorporating parameters like vintage, utilization, repayment behavior, bureau scores, product type, legal status, and contactability to enhance prioritization in collections strategies.
- Delivered executive-level insights through advanced Power BI dashboards and PowerPoint presentations, supporting senior management decision-making.
- Mentored and guided junior analysts, fostering a culture of analytical excellence and continuous learning.
- Led cross-functional collaborations to translate business challenges into analytics solutions, influencing key strategic decisions.
- Established standardized processes for data governance, ensuring data accuracy and integrity across analytics projects.
- Performed data validation, cleansing, and quality checks, ensuring high accuracy in reporting and analysis.
- Integrated external data sources (e.g. bureau data, alternate data) into recovery analytics for enhanced customer profiling and segmentation.
- Conducted benchmarking of internal recovery metrics against industry peers, identifying gaps and opportunities for improvement.
Sr. Officer – Data Analytics
HDB Financial Services
04.2017 - 07.2019
- Analyzed large datasets using Excel and Power BI to identify trends, resulting in a 15% improvement in business decision-making speed.
- Designed and automated interactive dashboards in Power BI to track key performance metrics for senior management.
- Cleaned and transformed raw data from multiple sources, improving data quality and reducing reporting errors by 20%.
Education
Bachelor of Commerce (B. Com) -
Indira Gandhi National Open University
01.2016
Skills
- Expertise in Power Query and complex formulas
- Data modeling in Power BI
- Python (Pandas, Spyder)
- Data Visualization
- Predictive modeling expertise
- Data governance & quality assurance
Certification
Advanced Excel Specialist, Oxford Institute, 2012
Timeline
Sr. Manager – Data Analyst
HDFC Bank
08.2019 - Current
Sr. Officer – Data Analytics
HDB Financial Services
04.2017 - 07.2019
Bachelor of Commerce (B. Com) -
Indira Gandhi National Open University
Similar Profiles
KAMALA SUBRAMANIANKAMALA SUBRAMANIAN
Senior Vice President and Unit Head at HDFC Bank Limited, HDFC BankSenior Vice President and Unit Head at HDFC Bank Limited, HDFC Bank
Jignesh PatelJignesh Patel
Relationship Manager at HDFC Sales Pvt. Ltd. (Group Company Of HDFC Bank)Relationship Manager at HDFC Sales Pvt. Ltd. (Group Company Of HDFC Bank)
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
Rajan GargRajan Garg
Assistant Manager at HDFC Bank LTD (HDFC Sales Pvt Ltd)Assistant Manager at HDFC Bank LTD (HDFC Sales Pvt Ltd)
ISHTEYAQUE AZHARISHTEYAQUE AZHAR
Senior Sales Executive at Edha care pvt ltdSenior Sales Executive at Edha care pvt ltd