Rajani

Senior Oracle PL/SQL Developer with 10+ years of experience designing, developing, optimizing, and modernizing enterprise database applications across Banking, Financial Services, Healthcare, Insurance, Retail, and Government domains. Expertise spans Oracle SQL, PL/SQL, PostgreSQL, Oracle 19c, SQL performance tuning, query optimization, Oracle Fusion Reporting (BI Publisher/OTBI), ETL, data warehousing, Azure, AWS RDS, REST APIs, JSON/XML, UNIX shell scripting, and CI/CD pipelines. Skilled at migrating Oracle databases to PostgreSQL, improving application performance, automating database processes, and delivering scalable cloud-based data solutions.

Strong background in Agile delivery, production support, and database modernization, with a proven record of improving batch performance by up to 60% and leading Oracle-to-PostgreSQL migrations.

Senior Oracle PL/SQL Developer (AU Connects) - Vitech Systems Group (Majesco) - USA

(2025-11)

• Developed and optimized 100+ PL/SQL packages, procedures, and functions supporting large-scale benefits administration systems.
• Processed high-volume benefits data for thousands of members, maintaining 99.9% data accuracy and system reliability.
• Programmed advanced SQL concepts including joins, analytic functions, constraints, indexes, and sequences.
• Improved batch processing performance by 30–50% through SQL tuning, AWR/ASH analysis, and execution-plan optimization.
• Built and maintained batch jobs and data-validation routines for large-scale data integration across multiple systems.
• Collaborated with business analysts and functional teams to translate requirements into scalable database solutions.
• Led end-to-end database solution design discussions and provided technical guidance to development and QA teams.
• Ensured data accuracy, integrity, and compliance through robust exception handling, auditing, and validation frameworks.
• Supported production deployments, defect analysis, root-cause investigation, and on-call issue resolution for mission-critical applications.
• Owned release-validation activities and ensured successful deployment of database changes across environments.
• Migrated Oracle database objects and PL/SQL logic to PostgreSQL, improving platform scalability and reducing maintenance costs.
• Created and maintained technical documentation including design specifications, data-flow diagrams, and release notes.
• Designed, implemented, and tuned interfaces and batch jobs using PL/SQL.
• Developed Oracle BI Publisher (BIP) reports and data extracts for Oracle Fusion ERP/HCM environments.
• Built OTBI reports and dashboards to support business reporting requirements.
• Configured scheduled BIP jobs and automated data-export pipelines, and supported Fusion Analytics integrations and enterprise reporting solutions.

Senior Oracle PL/SQL Developer - Al Ansari Financial Services - UAE

(2024-08 - 2025-06)

• Served as Senior Database Lead, analyzing business requirements and converting them into technical specifications and high-level design documents.
• Led database development across multiple payment-processing modules, reducing production defects and improving release stability.
• Reviewed database code changes, enforced development standards, and provided technical mentoring to junior developers.
• Coordinated with vendor teams to resolve issues, gather requirements, and support application enhancements.
• Developed PL/SQL packages, procedures, triggers, functions, indexes, and collections to implement business logic.
• Generated server-side PL/SQL scripts for data manipulation, validation, and materialized views.
• Improved query performance by up to 40% through SQL tuning, optimizer hints, and execution-plan analysis.
• Created Oracle database objects including tables, views, indexes, and sequences.
• Collaborated with data architects and business analysts to align transformation logic with financial reporting requirements.
• Applied advanced PL/SQL collections, BULK COLLECT, and FORALL processing techniques.
• Supported production enhancements, data fixes, and application implementation activities.

Senior PL/SQL Developer - Bank of America (Accenture/TeamLease Client)

(2023-05 - 2024-08)

• Served as Senior Database Developer supporting enterprise financial applications.
• Designed, developed, and maintained applications using Oracle SQL, PL/SQL, PostgreSQL, and UNIX.
• Diagnosed and resolved complex technical issues in Pro*C applications, including SQL errors and performance bottlenecks.
• Created and modified PL/SQL scripts based on changing business requirements.
• Developed PostgreSQL schemas, functions, triggers, and procedures for data-mart processing.
• Performed SQL and PL/SQL performance tuning and query optimization.
• Reduced batch processing time by 30% through PL/SQL optimization, query tuning, and ETL enhancements.
• Implemented Oracle stored procedures, functions, triggers, and packages.
• Built ETL processes involving data cleansing, integration, and transformation from multiple source systems.
• Processed and integrated data from multiple enterprise source systems, improving financial reporting accuracy and reconciliation efficiency.
• Supported critical financial accounting and expense-recovery processes for enterprise banking operations.
• Partnered with business stakeholders, analysts, and support teams to prioritize enhancements and resolve production issues.
• Analyzed and resolved production issues across development and production environments.
• Scheduled and monitored batch jobs using Autosys.

Senior Oracle PL/SQL Developer (Enhops Solutions) - CNSI

(2022-02 - 2023-05)

Developed PL/SQL packages