Oracle PL/SQL & APEX Developer

BHAVANI RAGIPHANI

************@*****.***

Oracle PL/SQL Developer Oracle APEX Developer Linux/Unix & Shell Scripting PROFESSIONAL SUMMARY

Results-driven Oracle PL/SQL Developer with 5+ years of professional, hands-on experience designing, developing, and optimizing high-performance PL/SQL (Oracle) components—stored procedures, packages, functions, triggers, and views—for mission-critical, high-volume transactional systems across Billing, Invoicing, Payment Processing, Supply Chain, and Insurance Claims platforms on Oracle 19c/12c/11g. Solid understanding of object-oriented programming and software design patterns, applied through Java/JDBC and Python integration layers. Strong experience with shell scripting (Bash, KornShell) and daily work in Linux/Unix environments supporting batch jobs, end-of-day (EOD) processing, and scheduled data flows within strict SLA windows. Skilled in execution plan analysis, indexing and partitioning strategies, and root cause analysis for production data issues, using TOAD and Oracle SQL Developer as primary development tools, with version control via GitHub/Git. Comfortable working in Agile/Scrum and Kanban as well as controlled Waterfall delivery models, following structured SDLC, change management, and audit/code-review standards. Excellent problem-solving skills and attention to detail, with a proven record collaborating across Business Analysts, QA, and upstream/downstream application and production support teams. CORE SKILLS MATCH

• PL/SQL (Oracle): Stored Procedures, Packages, Functions, Triggers, Views, Cursors, Ref Cursors, Bulk Collect, FORALL, Dynamic SQL, Collections, Exception Handling, Analytical Functions — Oracle 19c/12c/11g/10g

• Shell Scripting: Bash, KornShell (Korn Shell)-style Unix scripting for batch automation and job scheduling

• OOP & Design Patterns: Object-oriented programming principles applied via Java/JDBC and Python service layers; reusable, modular PL/SQL package design

• Version Control: GitHub / Git for source control, branching, and code review workflows

• Linux/Unix: Daily development and production support in Unix/Linux environments; Unix Cron, DBMS_SCHEDULER, Autosys

• Tools: Oracle SQL Developer, TOAD, PL/SQL Developer, Git, Jenkins

• Data Migration & Reconciliation: ETL Pipelines, Data Validation, Source-to-Target Reconciliation, SQL*Loader, Informatica PowerCenter

• Production Support: Incident Resolution, Root Cause Analysis, 24x7 On-Call Support, SLA-Driven Delivery

• Compliance & Controls: Regulated Environment Support (HIPAA, GDPR), Row-Level Security (VPD/RLS), Session-Level Access Control, Audit Logging, Peer Code Review, Change Management

• Methodology: Agile / Scrum, Kanban, Waterfall, SDLC, Unit/Integration/UAT Testing, Technical Documentation ADDITIONAL TECHNICAL SKILLS

• Oracle APEX: APEX 20.x–23.x, Page Designer, Interactive Reports/Grids, Dynamic Actions, Shared Components

• ORDS & REST APIs: Oracle REST Data Services, JSON, Module/Template/Handler Configuration

• Programming: Python (Pandas, NumPy, Requests, cx_Oracle/python-oracledb), Java (JDBC), JavaScript (ES6)

• Other Databases: SQL Server 2008/2012, IBM DB2, MS Access

• Data Modeling: Star/Snowflake Schema, Data Warehousing (OLAP/OLTP), Erwin, Microsoft Visio

• Performance Tuning: Explain Plan, AWR Reports, ADDM, Execution Plan Analysis, Indexing, Partitioning, DBMS_STATS, TKPROF

PROFESSIONAL EXPERIENCE

Travelers, New York, NY Sep 2025 – Present

Oracle PL/SQL Developer

• Designed, developed, and maintained Oracle PL/SQL packages, procedures, functions, triggers, and views supporting insurance claims processing, policy management, and billing platforms handling high-volume transactional data.

• Wrote and optimized high-performance SQL and PL/SQL for near-real-time claims and policy data updates, tuning query time by up to 60% using Explain Plan, AWR reports, hints, and DBMS_STATS.

• Supported business-critical batch jobs and end-of-day (EOD) processing using Bulk Collect, FORALL, and ref cursors to move millions of records through nightly and scheduled runs within SLA, orchestrated with shell scripts in a Linux/Unix environment.

• Collaborated with Business Analysts, QA, and upstream/downstream application teams to interpret functional requirements and translate them into PL/SQL and APEX-based solutions.

• Provided production support, incident resolution, and root cause analysis for data-related issues under 24x7 on-call coverage, staying within SLA commitments.

• Set up LDAP-based SSO authentication and authorization, session state protection, and row-level VPD policies to satisfy HIPAA and internal audit and compliance requirements.

• Supported data migration and reconciliation efforts, validating claims data and JSON payloads exchanged with underwriting and partner systems via ORDS REST APIs.

• Developed Informatica mappings and workflows pulling from Oracle, DB2, SQL Server, XML, and flat files into the enterprise data warehouse, applying business rules along the way.

• Wrote Bash shell scripts and Python scripts and Autosys jobs to automate nightly loads, batch PL/SQL runs, and reporting exports, reducing manual production steps.

• Maintained source code in GitHub and supported controlled release deployments across DEV, QA, and PROD.

• Participated in peer code reviews, maintained coding standards, and prepared technical documentation and release artifacts in an Agile/Scrum delivery model.

Environment: Oracle 11g/12c, PL/SQL, SQL, Oracle APEX 22.x/23.x, ORDS, Python, Java, SQL*Plus, Informatica, SQL*Loader, TOAD, GitHub, UNIX/Linux, Bash Shell Scripting, Autosys, ServiceNow Allegion, Indiana Sep 2024 – March 2025

Oracle PL/SQL / Database Developer

• Developed and maintained Oracle PL/SQL packages, procedures, functions, and triggers for order management, inventory reconciliation, and pricing logic supporting high-volume supply chain transactions.

• Wrote SQL with analytical functions, correlated subqueries, partitioned queries, and complex joins to support reporting with drill-down, export, and scheduled distribution.

• Tuned PL/SQL and SQL performance using Explain Plan, hints, AWR, DBMS_STATS, and bulk collections, cutting report response time by about 45% on large datasets.

• Moved batch jobs from manual to scheduled runs using Unix Cron and DBMS_SCHEDULER, with error alerting and rerun handling for end-of-day style processing, scripted in Bash/KornShell.

• Supported data migration and reconciliation between Oracle, DB2, and legacy systems, including bulk loads from EDI sources with bad-file handling.

• Managed Informatica mappings loading cleansed, reconciled data from multiple source systems into the enterprise warehouse.

• Set up authentication and role-based access control, applying object-oriented design principles in the Java service layer so users only accessed data and screens relevant to their role, supporting internal data governance requirements.

• Ran unit, integration, and UAT testing, and handled controlled deployments across DEV, QA, and PROD using ClearCase and Git for version control and change tracking. Environment: Oracle 12c/11g, PL/SQL, SQL, SQL Developer, Oracle APEX 21.x, ORDS, Python, Java, Informatica 9.6, SQL Server 2008, Autosys, TOAD, Microsoft Visio, Unix Shell Scripting Sunace Technologies Pvt Limited, India March 2020 – February 2023 Oracle PL/SQL Developer

• Developed PL/SQL packages, procedures, and functions implementing call-detail-record (CDR) rating, tax calculation, proration, and invoice-generation logic for a high-volume billing platform, with zero tolerance for calculation errors.

• Built automated ETL pipelines (Python, cx_Oracle) to ingest daily transaction files, validate records, and reconcile billed amounts against payment gateway settlement files — core data reconciliation work.

• Used Bulk Collect and FORALL to process millions of transactional records per cycle, keeping nightly rating and invoicing batch/EOD windows within SLA.

• Tuned long-running batch queries using Explain Plan, TKPROF, and AWR reports, reducing monthly processing time by roughly 40%.

• Implemented VPD/RLS row-level security so users only accessed transactional data within their assigned scope, supporting data control and audit requirements.

• Wrote reconciliation scripts in PL/SQL and Python to match transaction revenue against the general ledger, flagging mismatches for finance review before month-end close.

• Automated invoice generation, payment-file processing, and report distribution using DBMS_SCHEDULER, Autosys, and Unix shell scripting.

• Provided production support for the billing platform, troubleshooting failed batch jobs and data discrepancies under tight monthly close deadlines.

Environment: Oracle 12c/11g, PL/SQL, SQL, Oracle APEX 20.x/21.x, ORDS, Python, SQL Developer, TOAD, Autosys, Unix Shell Scripting, SQL*Loader

Appzwork Software Services, India Dec 2018 – Feb 2020 Oracle PL/SQL Developer

• Gathered requirements from engineering and business end-users and translated them into database designs and technical design documents.

• Wrote PL/SQL packages, procedures, functions, pipeline functions, cursors, and triggers driving data entry, calculations, and status updates.

• Created tables, views, materialized views, synonyms, indexes (B-tree and function-based), and sequences to support the data model — including schema and data modeling work using Erwin and Visio.

• Tuned SQL and PL/SQL with hints, Explain Plans, TKPROF traces, and materialized view refresh strategies, cutting average query time by about 40%.

• Applied exception handling, purging, and normalization to maintain data integrity across a multi-schema database.

• Built authentication and session management with row-level VPD policies restricting access by project, region, and user role.

• Used shell scripts, Python, and Autosys to automate intraday and end-of-day batch jobs, file merges, and PL/SQL runs across the UNIX environment.

Environment: Oracle 10g, PL/SQL, SQL, Oracle APEX 20.x, ORDS, Python, SQL Developer, TOAD, Unix Shell Scripts, SQL*Loader, Autosys

EDUCATION

Master of Science in Technology Management (MSTM) — Lindsey Wilson University, 2023–2025 Bachelor of Science in Computer Science — Keshav Memorial Institute of Commerce and Science, 2015–2018

Contact this candidate