Senior Oracle PL/SQL Developer - Tata Consultancy Services
(2025-01)
Project: MetLife – Financial Data Processing & Reconciliation Platform
- Designed end-to-end data processing workflows handling high-volume transactional data, including complex joins, aggregations, and validation logic for financial reports.
- Optimized complex SQL and PL/SQL logic using indexing and execution plan analysis, achieving up to 60% reduction in query execution time.
- Designed data flow between upstream source systems and downstream reporting layers, ensuring consistency, validation, and timely data availability.
- Developed PL/SQL batch processing using Bulk Collect and FORALL, handling large datasets efficiently and reducing context switching overhead.
- Collaborated with business stakeholders to convert financial requirements into efficient backend solutions.
- Provided production support, resolving critical issues within SLA and maintaining system stability.
Senior Oracle PL/SQL Developer - Tata Consultancy Services
(2022-03 - 2024-12)
Project: Ultimatix R12 Finance – Oracle Financial Systems
- Enhanced and supported Oracle Apps R12 Finance modules, focusing on backend data processing for financial transactions and reporting.
- Developed optimized SQL queries for Account Receivables and financial reporting, improving report generation performance.
- Worked extensively with Oracle Apps data model and interfaces, ensuring smooth data flow between integrated modules.
- Identified and resolved data inconsistencies in financial transactions, improving data reliability for business users.
- Implemented validation checks to ensure accuracy of records during processing.
- Provided application support for finance users, troubleshooting issues related to reports, data mismatches, and system behavior.
- Developed reusable PL/SQL components (packages and procedures) to standardize data processing and reduce code redundancy.
Oracle PL/SQL Developer - Cognizant Technology Solutions
(2018-12 - 2022-03)
Project: Facets Healthcare – Claims Data Processing System
- Developed and maintained ETL processes for healthcare membership enrollment and claims data processing using PL/SQL.
- Built scalable data workflows to handle high-volume transactions, ensuring system performance and stability.
- Optimized SQL queries and processing logic, achieving up to 40% improvement in batch processing time.
- Supported data integration across multiple healthcare systems, ensuring consistency of claims and billing data.
- Used database objects such as tables, views, indexes, and constraints to design efficient data structures.
- Analyzed and resolved production issues impacting claims adjudication and billing workflows.
- Worked with cross-functional teams to ensure accurate data flow across upstream and downstream systems.
- Implemented complex joins, subqueries, and analytical functions for large-scale data processing.
- Utilized exception handling and debugging techniques to identify and resolve PL/SQL runtime issues.
