Vanisri K

Senior Oracle PL/SQL Developer with 7+ years of experience in designing, developing, and optimizing database solutions using SQL and PL/SQL. Strong expertise in stored procedures, packages, query tuning, and high-volume data processing across Insurance, Finance, and Healthcare domains. Experienced in handling data migration, batch processing, and production support.

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.

Bachelor of Engineering (B.E.) - Electronics and Communication Engineering (ECE) - Mahendra Institute of Technology, Anna University (2017)