Nov 2021 – Jan 2023 · 1 yr 2 mos · Cybercity, Gurgaon, India · Hybrid

• Team: Conduct Risk - MIS & Analytics
• Though titled Developer, my role focused on leading analytics initiatives within the Conduct Risk team. I collaborated with leadership to deliver data-driven insights, automate reporting, and improve risk monitoring efficiency.
• Key Highlights:
• Led a team of analysts to meet organizational and compliance goals.
• Designed and optimized SQL/HQL queries across multiple data sources (IDN, Cornerstone, etc.).
• Built logic to detect anomalies and exceptions in conduct risk data.
• Developed interactive dashboards in Tableau to visualize key insights.
• Partnered with cross-functional stakeholders to translate data into actionable intelligence.

Jul 2019 – Nov 2021 · 2 yrs 4 mos · Unitech Infospace Gurgaon

• Team - Global Risk Management
• Key Responsibilities:
• Performed data extraction, scripting, sampling, and analysis from multiple data sources to support compliance reviews.
• Developed standardized procedures and methodologies for test owners and sample developers using SQL, SAS, and MS Office tools.
• Conducted testing and monitoring of internal controls to ensure data accuracy and compliance consistency.
• Partnered with EIT testing and data leads to evaluate sampling practices and identify deviations from enterprise standards.
• Supported the Sampling Control Forum by reviewing design requests and validating non-independent data sources.
• Tools & Technologies: SQL | SAS | Data Analysis | Compliance Testing | Risk Analytics | MS Excel

Oct 2018 – Jun 2019 · 8 mos · Unitech Infospace, Gurugram

• NatWest Group (Part of Royal Bank of Scotland)
• Risk & Control
• Support the development and implementation of NatWest Market wide control framework to mitigate market, conduct, operational, credit, and regulatory risks.
• Define and deliver an effective and sustainable control environment across NatWest Markets in collaboration with other control teams and end-to-end functions.
• Comply with our code, all RBS, and NatWest Market policies.
• Own, manage and supervise risks within the business area, ensuring mechanisms are in place to identify, report, manage and mitigate risk within defined risk.
• Control testing for NatWest Front Office Controls, SOX controls and Risk & Control Assurance.
• Risk Identification, Remediation, Implementation of Controls and Follow Up.
• Desk Level Analysis, Baselines, Heat Maps creation in tableau to report the performance of controls.

Oct 2016 – Sep 2018 · 1 yr 11 mos

• Responsible for preparing /updating UK MI’s eg.UK work log tracker, FCA report, UK Exception log etc.
• Responsible for preparing several internal reports e.g., Quality report, Refund analysis report etc.
• Preparation of OPD (Online Process Diagram) and SOP (Standard Operating Procedure) and flow charts for the teams.
• Risk management and control testing for the processes under the corporate and personal banking operations team.
• Recommend Fraud write-off wherever appropriate in consultation with stakeholders.
• Monitor fraud risk budgets and keep them under control.

Oct 2014 – Sep 2016 · 1 yr 11 mos

• Pro-active Risk Management by way of reviewing cardholder, outsourced agency activities.
• Adherence to group Fraud Risk management guidelines.
• Reporting of any suspicious activity including Terrorist financing and AML.
• Analysis of the data, creation of reports, finding loopholes in the process and implementing changes.
• Preparation of audit reports for the corporate customers.
• Co-ordinate with RM for further clarification on loan sanctions if suspected fraud.
• Call back to customers for amounts above threshold limits for S/O’s.
• Engage appropriate stakeholders to ensure timely remedial actions and escalation of situations that pose significant risk.
• Adhere to policies and procedures issued in relation to money laundering prevention.
• Ensure compliance with these policies and procedures on an ongoing basis.