ANUPRIYA RAMAKRISHNAN
Singapore
Summary
Oracle PL/SQL Developer with 7 years of experience in the banking domain, specializing in high-performance database solutions, automation, and regulatory reporting. Proven expertise in optimizing complex systems and delivering scalable fintech applications.
Overview
8
8
years of professional experience
Work History
Senior Technical Consultant
Quess corp Pte Ltd(OCBC BANK)
08.2023 - 03.2025
- Worked on a regulatory reporting solution powered by Moody's Analytics, focused on generating Basel III compliance reports.
- Designed and developed robust PL/SQL components including triggers, packages, procedures, views, sequences, indexes, contexts, partition keys, cursors, and functions to support enterprise banking operations.
- Implemented table-level triggers and complex business logic to automate data validation and audit tracking.
- Utilized bulk collect and FORALL techniques to optimize data processing across large datasets, improving performance and reducing resource consumption.
- Applied table partitioning strategies to enhance query performance and manage large volumes of transactional data efficiently.
- Created advanced packages leveraging nested tables for array-type data structures, enabling modular and scalable design.
- Authored and maintained PL/SQL scripts for automation, data migration, and integration with upstream/downstream systems.
- Developed file generation scripts for structured output (CSV, TXT) and implemented file processing routines for ingestion and validation of external data feeds.
- Performed advanced query performance tuning using indexes, optimizer hints, and parallel queries to improve system throughput and responsiveness.
- Led table creation and schema alterations to accommodate evolving business logic and integration requirements.
- Developed and scheduled batch jobs using Control-M, ensuring timely execution, monitoring, and recovery of critical workflows.
- Authored shell scripts to automate database tasks, streamline operations, and support cross-platform integration.
- Conducted comprehensive unit testing to validate PL/SQL modules and ensure data integrity across banking applications.
- Resolved complex technical and logical issues, contributing to system stability and operational efficiency.
Senior Technical Consultant
Suisse Tech Partners Pte Ltd
01.2023 - 05.2023
- Developed PL/SQL triggers, packages, procedures, and functions to support complex business logic in banking applications.
- Designed packages utilizing nested tables to implement array-type structures for efficient data handling.
- Resolved both technical and logical issues with effective debugging and root cause analysis.
- Applied comprehensive PL/SQL concepts, including bulk operations, exception handling, and modular programming.
- Participated in table design, creation, and schema alterations to support evolving data requirements.
FCUBE Technical Consultant
Oracle Financial Services
09.2021 - 11.2022
- Worked on FLEXCUBE retail banking development, focusing on backend PL/SQL enhancements, performance tuning, and automation of daily banking operations.
- Developed PL/SQL triggers, packages, procedures, views, sequences, and functions to support FLEXCUBE banking modules.
- Built advanced packages using nested tables, associative arrays, and user-defined types for complex data handling.
- Applied BULK COLLECT and FORALL operations to optimize high-volume data processing.
- Tuned queries using indexes, optimizer hints, and parallel execution for enhanced performance.
- Designed and executed unit testing to validate business logic and ensure code reliability.
- Created and modified database tables, implemented table-level triggers, and maintained schema integrity.
- Automated daily operational tasks using PL/SQL scripts integrated with shell scripting.
- Resolved technical and logical issues through detailed analysis and effective debugging.
- Developed core logic for retail banking functionalities, ensuring compliance with business rules and regulatory standards.
Software Associate
BNP Paribas India Solutions
06.2017 - 08.2021
- Involved in requirement gathering and database design.
- Developed triggers, packages, procedures, and functions using PL/SQL.
- Created packages with nested tables to support array-type Java call logic.
- Performed query performance tuning using indexes, hints, and parallel queries.
- Resolved complex technical and logical issues effectively.
- Conducted unit testing to ensure functional accuracy.
- Participated in client interactions for requirement clarification and solution delivery.
- Designed and implemented the end-to-end Corporate Action Interface, integrating trade feeds, validation logic, and fund accounting updates.
Education
BACHELOR OF TECHNOLOGY -
Sri Sairam Institute of Technology
05.2017
12 TH STD -
St.Joseph's Hr.sec school
05.2013
Skills
- ORACLE 10g,11g,12c,19c
- Control M
- UNIX Shell scripting
- MULTIFONDS
- FLEXCUBE(RAD TOOL)
Awards
BRAVO, BNP PARIBAS India Solutions, Led the creation of a new interface for Corporate Actions and contributed to the design and development of the new project, CROSS ROADS.
Languages
Tamil
English
Timeline
Senior Technical Consultant
Quess corp Pte Ltd(OCBC BANK)
08.2023 - 03.2025
Senior Technical Consultant
Suisse Tech Partners Pte Ltd
01.2023 - 05.2023
FCUBE Technical Consultant
Oracle Financial Services
09.2021 - 11.2022
Software Associate
BNP Paribas India Solutions
06.2017 - 08.2021
12 TH STD -
St.Joseph's Hr.sec school
BACHELOR OF TECHNOLOGY -
Sri Sairam Institute of Technology
Similar Profiles
Aisakani Aisakani null
Infrastructure Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)Infrastructure Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)
Aisakani Aisakani null
Infrastructure Support Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)Infrastructure Support Engineer at Quess Corp Singapore Pte Ltd (OCBC Bank)
RAJESH YANIMILLARAJESH YANIMILLA
Senior Data Engineer at Quess Corp(OCBC)Senior Data Engineer at Quess Corp(OCBC)
Mohamad Isyanto Bin HasimMohamad Isyanto Bin Hasim
Policy Analyst(Model Policy) at TiktokPolicy Analyst(Model Policy) at Tiktok
Carson SngCarson Sng
International School Science Teacher (Primary) at Siam Singapore International SchoolInternational School Science Teacher (Primary) at Siam Singapore International School