Arpit Agrawal

Application owner for Various Market Risk flag ship system responsible for calculating and reporting VaR, Back testing, Limits management and Incremental risk charge, this are indicator of risk for any investment bank. Trading data is passed from across the world to the system, after processing the data, VaR is calculated.

Current role and responsibility:

• Product owner for various Market risk application and Technical delivery lead for Market risk regulatory program. Joined RBS as Software engineer and Grown into Technical delivery lead (Solution architect with dev management) in 5 years.
• Driving strategy and migration from on premises infrastructure to cloud (GCP ) and setting up CI/CD pipelines.
• Orchestrated multi-year strategic roadmap for modernising and upgrading applications in Market Risk IT on big data platform to handle increased volumes and FRTB Regulatory requirements.
• Converted monolithic application into micro services driver application.

Key deliveries over last couple of years:

• Delivered key EWMA VAR Model change
• Delivered IRC model remediation
• Delivered key program of VAR model remediation for CREDIT ASSEST class for corporate (Bonds, CDS and Index) and Sovereign bonds.
• Delivered key program for IMA wavier by implementing CAT checks and proving trade completeness.
• Delivered key framework to ingest data with low latency from various source system representing trading platform for various asset classes.
• Delivered PNL Approx. calculation from Risk data for STRESS testing.
• Implemented key capabilities for Risk divisions to have near real time VAR for 7 years building PNL store using Thrift, Zookeeper, Caching and HDFS.
• Query API implemented for downstream systems to query VAR and Sensitivities with zero downtime deployment.
• Key initiatives include sourcing reference data from golden sources, automation of workflows, trade error handling & front to back streaming APIs for low latency.
• Established architecture blue-print and delivered key capabilities in Market Risk (Risk data store, Limits Management, Stress Testing, Market Data, trade level sensitivities & VAR) using Java, Distributed computing frameworks (DataSynapse & Coherence), Hibernate, JPA, Spring, Sybase.
• Setup a new team from scratch and led them through the development and deployment phases of Methodology tool to predict VAR for ERROR data.
• Remediated a legacy Limits Management solution using Spring Boot, Micro-services, JPA & Hibernate after driving a proposal to modernise & aligning it with relevant business and technology stakeholders.

Collaboration and Governance:

• Providing technological solutions through joint planning sessions, evaluation of infrastructure trends and change management strategies.
• Managing teams across geographies (Chennai, LN, Bulgaria, Gurgaon) in delivering key capabilities to drive technology transformation & operating cost reduction.
• Mentored team in adopting the DevOps culture, training Scrum Masters, guiding developers through various pillars of agile software development.
• Simultaneous execution & technical oversight of several delivery projects while managing a team of over 20 permanent and consultants with technical and business-facing responsibilities.
• Set up and managed a governance process for software delivery, conducted workshops on DevOps, Pair programming, Continuous integration, Continuous Deployment.
• Automated several reconciliation processes within the bank through the use of a combination of commercial off the shelf products and in house products and projects.

Working on HP Open view and Performance management database (May Jun 2005 to Jun 2010: A Data warehouse for BSM Reporting solution for Enterprises.

• Product getting developed from scratch.
• Design and Development of Graphical User Interface of administration console. 
• Content development kit. Automating complete process of content pack development by model driven development. Automated complete process for content development to just writing a simple xml.
• Collector frame work to collect data from multiple sources (Extracting data from source) a multi threaded application.
• System health monitoring module which allows user to monitor data warehouse and critical component such as system on which product is running monitor and database health status check.
• Metadata management for PMDB, Designed and Implemented a metadata repository to allow model drive driven development.