AKASH V

• Senior Oracle PL/SQL Developer with 4.5+ years of experience in Banking, Financial Services, and Insurance domains.

• Currently working as a Senior PL/SQL Developer on the FSS RECON platform, delivering reconciliation solutions for leading banks and financial institutions across India and global markets.

• Expertise in developing and optimizing PL/SQL Procedures, Functions, Packages, Triggers, Cursors, Collections, BULK COLLECT, FORALL, and complex SQL queries.

• Strong experience in Oracle 12c/19c, ETL workflows, data extraction, performance tuning, AWR analysis, query optimization, and production support activities.

• Hands-on experience in database maintenance, partitioning, indexing, purging, CTAS methodology, rollback strategies, and scheduler jobs using DBMS_SCHEDULER.

• Proficient in troubleshooting production issues, performing root cause analysis (RCA), and implementing scalable solutions for high-volume transactional systems.

• Experience in designing error-handling frameworks, logging mechanisms, audit-tracking solutions, and data validation processes.

• Worked extensively with reconciliation processes, transaction matching, exception handling, and financial data processing for banking clients.

• Collaborated with business analysts, QA teams, and global stakeholders in Agile/Scrum environments to deliver high-quality solutions aligned with business requirements.

• Strong understanding of SDLC, SIT, UAT support, release management, and application support processes.

FSS RECON | FSS – Mumbai

• Developed and maintained PL/SQL procedures, packages, functions, triggers, and database objects to support financial transaction reconciliation for banking clients.

• Worked extensively on data extraction, transaction matching, reconciliation processing, exception handling, and settlement validation across multiple payment channels.

• Performed SQL and PL/SQL performance tuning using AWR reports, indexing, partitioning, query optimization, and execution plan analysis to improve processing efficiency.

• Provided production support, troubleshooting reconciliation breaks, batch failures, and data discrepancies while collaborating with business and support teams to deliver timely resolutions.

Digital Marketing Automation | LibertyOne Banking Solutions – USA

• Developed PL/SQL procedures, functions, packages, and triggers to automate digital marketing workflows and customer activity tracking for the banking platform.

• Designed complex SQL queries, views, and ETL processes to support customer segmentation, lead scoring, campaign analytics, and centralized reporting requirements.

• Created materialized views and optimized database performance through indexing, partitioning, BULK COLLECT, and FORALL operations for large-volume datasets.

• Collaborated with client and QA teams to gather requirements, implement business logic, support SIT/UAT activities, and deliver enhancements within project timelines.

Unified Claims Processing & Automation Platform | Zenith Claim Operations – USA

• Designed and implemented PL/SQL procedures, packages, functions, and triggers to support end-to-end insurance claims processing workflows.

• Built and maintained ETL processes to extract, transform, and load claims, member, provider, and policy data from multiple source systems into Oracle databases.

• Created complex SQL queries, analytical reports, and database views to support claim status tracking, fraud detection, payment analytics, and operational reporting.

• Performed query optimization, scheduler job management, production support, and data quality validations to ensure efficient claim processing and system reliability.