Rahul Thorat

Results-driven Oracle PL/SQL Developer with 11+ years of experience, including 8+ years in Regulatory Reporting across capital & liquidity (Basel III: LCR, NSFR, COREP, PRA110, ALMM), transaction reporting (EMIR, MiFID II, ESMA, SEC, CFTC), and AML/KYC compliance. Delivered production-grade Oracle PL/SQL and ETL solutions for large-volume data processing at tier-1 financial institutions including UBS, HSBC, Deutsche Bank, Credit Suisse, FAB Bank, and MUFG. Skilled in complex PL/SQL packages, procedures, functions and triggers, SQL performance tuning, and end-to-end regulatory data pipelines across platforms including Moody's RiskAuthority and ODI.

Available immediately; most recently focused on strengthening Oracle SQL/PLSQL expertise while exploring modern scripting and AI-driven technologies.

Principal Developer at Fusion Practices Technologies (2024-08 – 2025-09)

Project: Regulatory Reporting (Capital & Liquidity) – Moody's RiskAuthority (RAY) | Domain: Investment Banking – Regulatory Reporting | Team Size: 7

• Developed and maintained Oracle SQL/PLSQL-based data transformation and regulatory reporting logic for trade and security position data received from upstream systems such as Murex, Martini, InstrumentHub and SynEntity, supporting downstream processing in Moody's RiskAuthority (RAY) across LCR, NSFR, PRA110, COREP and ALMM frameworks.
• Developed and maintained Oracle PL/SQL packages, procedures, functions and SQL views supporting high-volume regulatory data processing, while implementing and maintaining transformation and regulatory mapping logic through the Moody's Mapping Tool.
• Implemented regulatory mapping changes for Positions Capital and Positions Liquidity, including Apex rollover trade requirements, using SQL views and transformation logic to support regulatory data treatment and downstream Moody's processing.
• Owned data reconciliation and validation between Murex and Moody's RiskAuthority to ensure the accuracy and audit-readiness of Capital and Liquidity regulatory submissions.
• Monitored and resolved Control-M batch job failures in the MD_UK_Batch overnight regulatory data-processing workflow, including investigation of file arrival, data-load and downstream processing issues.
• Performed SQL performance tuning, led code reviews and managed release deployments via TeamCity/SDA in coordination with business analysts and QA.

Lead – Technology at Synechron Technologies (2021-12 – 2024-07)

Project: CSTRB (Central Solution for Transaction Reporting Batch) | Domain: Investment Banking – Transaction Reporting | Team Size: 7

• Led design and development of Oracle PL/SQL solutions processing real-time XML (TESS) and batch CSV feeds from 15+ upstream deal-store systems (Murex, GMI, Sabre, Indigo, FXI, TOPAZ, and others) through Extract → Conformed → Canonical → Reportability → Reporting pipeline stages.
• Implemented transaction reportability and eligibility logic supporting EMIR, MiFID II, ESMA, ESMA Delegated Reporting, SEC, and CFTC frameworks across multiple regulatory jurisdictions.
• Delivered new ESMA and ESMA DR reporting flows for trade valuation and collateral reporting, ensuring accurate submission to Trade Repositories.
• Architected and tuned Oracle database objects (tables, views, procedures, packages) for high-volume transaction processing; built and executed FitNesse component test suites.
• Managed GitLab-based merge request/code review process and mentored the development team on coding standards and SDLC best practices; drove Agile ceremonies and cross-functional delivery with Business, QA, and Ops.

Senior Project Engineer at Wipro Limited (2019-09 – 2021-11)

Clients: FAB Bank (UAE), Credit Suisse, Outokumpu (Sweden)

• FIRCO Trust Compliance — FAB Bank | Team Size: 15 | Jun 2021 – Nov 2021: Built ODI 11g ETL pipelines and Oracle PL/SQL transformation logic for AML/KYC customer data processing, feeding the Alchemy data warehouse for FIRCO Trust screening against OFAC and UN sanctions watchlists.
• POETS GLI (General Ledger Interface) — Credit Suisse | Team Size: 7 | Sep 2020 – May 2021: Developed Oracle PL/SQL logic to transform trade and settlement data (via EPI standardization) into accounting debit/credit journal entries, including counterparty- and security-based reclassification, feeding downstream PeopleSoft GL and ARDM systems.
• MPS (Material Planning System) — Outokumpu | Team Size: 5 | Sep 2019 – Aug 2020: Delivered Oracle PL/SQL enhancements for AMSMPS/VBMPS production planning systems supporting slab, coil, and hot-rolled band manufacturing tracking, integrated with upstream Level 2/3 systems (Proflow, Quintiq).

Associate Consultant at Infosys Limited (2016-06 – 2019-08)

Clients: Deutsche Bank, HSBC Private Bank

• Trade Surveillance (Fixed Income Monitoring) — Deutsche Bank | Team Size: 4 | Feb 2019 – Aug 2019: Developed Oracle PL/SQL and SQL logic to load and transform fixed-income trade data (bonds, interest rate swaps, futures) from staging into fact tables, feeding Actimize's trade surveillance rules for detection of market abuse.
• ADF LRR (Local Regulatory Reporting) — HSBC Private Bank | Team Size: 4 | Jan 2018 – Dec 2018: Automated Balance Sheet and P&L regulatory report generation for Central Bank submission using PL/SQL and the FINARC ETL framework, implementing business rules for taxation and defaulter classification.
• ADFQ (Qualitative Regulatory Reporting) — HSBC Private Bank | Team Size: 4 | Jun 2016 – Dec 2017: Built a PL/SQL-based qualitative regulatory reporting solution for RBI submissions across daily, weekly, monthly, and yearly frequencies, eliminating manual data consolidation from multiple source systems and Excel templates.

Software Developer at JAWK Software (2013-08 – 2016-05)

Project: PRPLLR (Pragmatic Regulated Product Labeling Listing and Registration) | Domain: Healthcare | Team Size: 9

• Developed Oracle PL/SQL procedures and validation logic to parse, validate, and load FDA-mandated XML-based SPL (Structured Product Labeling) documents into Oracle database tables, supporting regulated product data exchange.
• Designed and maintained core database objects (tables, views, materialized views, sequences, constraints) and delivered query optimization for reporting and retrieval.

Bachelor of Engineering in Computer Engineering – North Maharashtra University (2012)