Amit Bansal

About Amit Bansal

Analyst with 2+ years of experience in automation, model monitoring, and process…

Experience

1. Analyst

   HSBC

   Jul 2023 — Present · Bengaluru, IN

   Pymon (Model Monitoring): Automated the static and repetitive tasks of the validation process for PD, EAD and LGD models using python. This initiative reduced manual efforts by over 70% and significantly improving operational efficiency and scalability. Migrated SAS codes to Python for metric calculations, optimized performance and reduced execution time.2. RDM Adoption (Data Transformation): Spearheaded a collaborative project to develop automation tools including the ‘Deck Automation Tool’ which seamlessly transfers Excel charts and tables into PowerPoint, and ‘LookML- to-Excel and back’ enabling faster code updates in LookML, These tools reduced time and effort by over 50%, minimizing error risk while ensuring accuracy and consistency. Streamlined data operations for RDM Adoption by analyzing variables logic across domains, resolving inconsistencies and enhancing data integrity and reliability, enabling better decision-making and smoother downstream processes. Developed BigQuery code for UK Mortgage RAS and Singapore Cards Strategy Monitoring to migrate processes from SAS to RDM. Steered initiatives like AIR flow design and a strategic approach for dimensions ranking in the new web app.3. Vector (Model Development): Ensured the global adaptability of Vector tool by identifying and resolving critical bugs, rigorously testing datasets across diverse regions (UK, Singapore) and guaranteeing seamless updates without introducing new defects. This proactive approach enhanced system robustness, scalability and overall user experience.