Soumyabrata Chaudhury
Business Consultant
Mumbai
Summary
Risk, governance, and data analytics professional with approximately 14 years of experience across BFSI, insurance, and reinsurance industries. Background spans model risk governance, enterprise risk management, IT and process audit, regulatory compliance (RBI guidelines, Middle East regulations), and catastrophic risk modeling. Skilled in SQL, Python, VBA, and Power BI for data analytics and reporting automation. Experienced in leading risk transformation engagements and presenting to Risk Committees and senior stakeholders for clients across South Asia, Europe, the Middle East, and the Americas.
Overview
7
7
Certifications
15
15
years of professional experience
Work History
Business Consultant Manager
Ernst & Young LLP
10.2022 - Current
- Implemented risk and governance control policies and procedures for multiple clients across MENA and Indian geographies.
- Present model risk assessments at Risk Committee level, building and maintaining a comprehensive assessment of model risk including processes, models, assumptions, and calculations, with updates at least annually.
- Oversee the collection, tracking, and reporting of governance and model risk issues through remediation, including progress, timelines, and delivery expectations for model risk projects.
- Review and investigate risk occurrences to determine risk potential, and identify areas for improvement, recommending remediation solutions to business stakeholders.
- Lead Steerco and townhall interactions with peers, direct management, and key stakeholders within the risk department.
- Facilitate escalation of non-compliance and high-risk concerns to appropriate stakeholders and ensure completion of remediation activities with business management.
Assistant Vice President, Corporate Office
Axis Bank Limited
11.2021 - 10.2022
- Formulated data quality rules for banking data in accordance with RBI guidelines to enhance data quality.
- Liaised with the Business Intelligence Unit (BIU) to extract exception reports using SQL queries, facilitating root cause analysis of data discrepancies across banking systems that led to regulatory risk.
- Leveraged Power BI to perform data analytics and risk assessment, analyzing month-on-month reports to identify data exceptions impacting the bank's regulatory reporting.
- Automated MIS and reporting workflows using VBA and SQL, and performed risk and control assessments for banking processes in line with Reserve Bank of India requirements.
- Oversaw third-party data integrity and compliance efforts across multiple frameworks, coordinating with auditing firms, driving resolution of audit findings, and managing security assessments of third-party vendors.
Senior Consultant, India Practice / Manager, India Practice
Ernst & Young LLP / Deloitte Touche Tohmatsu
08.2018 - 11.2021
- Identified procedural improvement areas through SQL-based customer data analysis to improve underwriting profitability, and built Power BI dashboards for business KPIs that reduced manual reporting.
- Designed a new data storage and tracking methodology for live data and authored SOPs for the analyst team; collaborated with finance, sales, and operations teams to update SOPs and manuals.
- Developed customer segmentation models to improve insurance customer retention, achieving a 15% improvement in targeted segment retention.
- Managed and executed multiple governance risk, IT audit, and ITGC audit engagements, supervising process and control assessment, data analysis, control testing, and audit reporting for life and general insurance companies and insurance brokers across India and the Middle East.
- Advised on the design of business processes and application functionality, including end-to-end data mapping and system integration across platforms.
- Designed vendor management and process improvement tools for clients and internal use; performed quality assurance and risk and control assessments evaluating risks from insurance policy conditions.
- Collaborated with Internal Audit Services, Legal, and Compliance teams to evaluate enterprise risk and compliance activities, incorporating design and effectiveness testing results into risk and control policies.
- Prepared quarterly ERM reports covering key risk indicators and risk mitigation commentary for management, and lead audit automation projects.
- Drafted SOPs for insurance procurement, finance, and risk management functions, and led risk transformation projects for clients across South Asia, Europe, the Middle East, and the Americas.
- Partnered with technology teams to support enhancement of the residual risk model and automation of reporting and analysis.
Senior Risk Analyst, Catastrophic Modeling / Risk Analyst 2, Catastrophic Modeling
Exceedance Pvt Ltd / Verisk Analytics
04.2015 - 08.2018
- Performed catastrophic risk data analysis, applying exposure limits, sub-limits, participation, and layer conditions for catastrophic financial loss analysis.
- Tested various catastrophic risk models and prepared risk survey reports for insurance and reinsurance clients.
- Used SQL Server Management Studio to access databases and run complex, nested queries to retrieve, manipulate, and extract portfolio data for data analytics.
- Produced detailed exposure profiling using data analytics and catastrophic modeling tools, including RMS RiskLink and AIR Touchstone, to estimate potential catastrophic losses.
- Performed data analytics and data modeling to assess physical hazards for various customer exposures, delivering loss analysis reports to clients including Transatlantic Re, Hathaway Berkshire Re, Argenta, and Chubb Insurance.
Systems Engineer, BFSI and Retail
Tata Consultancy Services
10.2011 - 09.2014
- Served as subject matter expert and software developer on legacy systems, including IBM AS/400 and IBM Mainframe applications such as PASIA, RLS, and Fixtures, for clients including Hallmark US Retail, AXA Hong Kong, and Southeast Asia operations.
- Provided technical support through database management, retrieving, manipulating, and extracting data using SQL queries based on client requirements.
- Drove retrofitting and patch management engagements, and developed migration scripts in RPGLE, JCL, and CLLE to migrate data between systems.
- Designed automation tools and utilities to enhance system functioning and reduce time spent on routine jobs, using SQL queries and job scheduling.
- Developed, upgraded, and maintained advanced financial industry software, coordinating design and implementation of applications while mentoring junior developers.
Education
Post Graduate Diploma in Risk Management (PGDRM) -
Institute of Insurance and Risk Management (IIRM)
Hyderabad, India01-2015
Bachelor of Technology - Electronics and Communication Engineering
SRM University
01-2011
Class XII - Science (Mathematics and Biology)
Calcutta Boys' School
Kolkata, India01-2007
Skills
Risk & Governance: Model Risk Management, Enterprise Risk Management (ERM), Risk and Control Self-Assessment (RCSA), IT Audit, ITGC, SOX Compliance, Internal Audit, Regulatory Compliance (RBI, Middle East Regulations)
Risk Frameworks & Methodologies: FMEA, HACCP, FTA, ETA, PHA, LOPA, ERAM, SCRAM, COSO, ISO 31000
Catastrophic & Insurance Risk Modeling: RMS RiskLink, AIR Touchstone, Reinsurance Limits and Layer Analysis, Exposure Profiling, Catastrophic Loss Analysis
Data Analytics & Reporting: SQL, SQL Server Management Studio, Python, VBA, Power BI, Data Modeling, MIS Automation
Certification
Insurance and Risk Management Accreditation, Chartered Insurance Institute (CII), London
Timeline
Business Consultant Manager
Ernst & Young LLP
10.2022 - Current
Assistant Vice President, Corporate Office
Axis Bank Limited
11.2021 - 10.2022
Senior Consultant, India Practice / Manager, India Practice
Ernst & Young LLP / Deloitte Touche Tohmatsu
08.2018 - 11.2021
Senior Risk Analyst, Catastrophic Modeling / Risk Analyst 2, Catastrophic Modeling
Exceedance Pvt Ltd / Verisk Analytics
04.2015 - 08.2018
Systems Engineer, BFSI and Retail
Tata Consultancy Services
10.2011 - 09.2014
Class XII - Science (Mathematics and Biology)
Calcutta Boys' School
Bachelor of Technology - Electronics and Communication Engineering
SRM University
Post Graduate Diploma in Risk Management (PGDRM) -
Institute of Insurance and Risk Management (IIRM)