Marrapu Aparna

Lead Software Engineer with 10+ years of experience in Oracle Database development, specialising in SQL, PL/SQL, Oracle 19c, backend application development and enterprise database solutions across banking, financial services, Insurance, and Telecom domains. Strong experience across the complete Software Development Life Cycle (SDLC) including requirement analysis, solution design, development, testing, deployment, production support, and maintenance using Agile methodologies. Strong expertise in designing and developing complex Oracle database objects including Packages, Procedures, Functions, Triggers, Views, Indexes, Materialised Views, and performance-optimised SQL queries.

Hands-on experience in SQL performance tuning, query optimisation, execution plans, indexing, partition maintenance, compression, dynamic SQL, collections, exception handling, Ref Cursors, bulk processing, ForAll and Oracle JSON. Experienced in owning end-to-end backend database solutions, from requirement analysis and solution design through development, testing, production deployment and support with expertise in Oracle JSON processing, workflow automation, batch processing, data integration for enterprise applications and Kafka-based downstream integration. Hands-on experience in Sybase to Oracle migration, data migration, GoldenGate, Pentaho, Liquibase based deployments, Git/GitLab, production monitoring and enterprise application support.

Google Cloud Associate Cloud

Engineer (GCP ACE) certified professional with experience using AI-assisted development tools and strong analytical, problem-solving, and cross functional collaboration skills.

Lead Software Engineer - Virtusa Consulting Services Private Limited - Hyderabad

(2021-11)

• Designed and developed complex oracle database objects including Packages, procedures, Functions, Triggers, Views, and indexes for enterprise banking applications.
• Executed the Conversion of database objects from Sybase to Oracle as part of database migration initiative ensuring functional accuracy and optimised performance.
• Executed data mapping and migration activities using Pentaho and GoldenGate across multiple environments.
• Designed and automated monthly Partition Maintenance and Compression reducing database size from 12TB to 4TB and enabling data restoration within the 4-hour RTO.
• Optimised PL/SQL code to reduce the execution time from 4+ hours to under 1 hour which helped in decreasing our production deployment time.
• Owned the end-to-end design and development of the backend database solution from scratch for the newly introduced Tax Contacts module in the Bank of New York Mellon Universal Tax Hub application, from requirement analysis and solution design through development, testing, deployment and production support.
• Designed and implemented business validations, workflow processing, and database logic supporting the Tax Contacts functionality.
• Designed and developed Oracle PL/SQL integration logic to generate JSON payloads and publish Kafka messages to two downstream applications XTH & CR5, enabling real-time integration across enterprise systems.
• Optimised complex SQL queries and PL/SQL programs to improve application performance and support high-volume transaction processing.
• Leveraged Oracle 19c JSON capabilities for application integration and data processing.
• Reviewed SQL/ PLSQL code and provided technical guidance to ensure adherence to coding standards, performance, maintainability and application requirements.
• Managed database deployments and release activities using Jules/ Liquibase pipelines including deployment monitoring, production validation and issue resolutions using Splunk.
• Owned production support activities investigating database/ application issues performing root cause analysis and implementing fixes to maintain application stability.
• Collaborated with Business Analysts, UI developers, QA teams, and cross-functional stakeholders throughout the Agile software development lifecycle.

Senior Consultant - Virtusa Consulting Services Private Limited - Hyderabad

(2021-11)

JP Morgan Chase Bank - RTO (Recovery Time Objective)

Senior Consultant - Virtusa Consulting Services Private Limited - Hyderabad

(2021-11)

JP Morgan Chase Bank - Sybase to GOS DB Migration

Technology Analyst - Infosys Limited - Hyderabad

(2019-09 - 2021-11)

Bank of America (Sep 2019 – Nov 2021)

• Analysed business requirements and designed, developed, and maintained Oracle database objects including Packages, Procedures, Functions, Triggers, Views, and SQL scripts for the MDR (Meta Data Repository) application.
• Designed and implemented database logic to load and validate data from staging tables into ODS tables through scheduled batch jobs ensuring data accuracy and integrity.
• Optimised long-running SQL queries and batch jobs through SQL performance tuning, gone through AWR reports for improving overall application performance.
• Automated database operations using Unix shell scripting.
• Performed Unit testing, defect analysis, production deployments, and post-release validation to ensure successful application releases.
• Investigated and resolved production issues through root cause analysis while ensuring system stability and adherence to SLA commitments.
• Served as Scrum master, facilitating sprint planning, daily stand-ups, sprint reviews, and retrospectives to ensure timely delivery of business requirements.

Associate System Engineer - IBM - Gurgaon / Hyderabad

(2016-06 - 2019-08)

Project 1: Bharti Airtel (Jun 2016 – Jun 2018) - Gurgaon. Project 2: Standard Insurance Company (Jun 2018 – Aug 2019) - Hyderabad

• Configured, customised and enhanced Kenan FX billing modules supporting recurring/ non-recurring charges, payment processing, billing adjustments, customer account management and invoice processing.
• Performed impact analysis, effort estimation, and implemented business change requests.
• Designed and developed custom SQL reports from scratch for the Fiduciary Benchmark Index project by analysing business requirements, writing complex SQL queries, aggregations, validating report data, and delivering accurate reporting solutions.
• Designed and developed SQL and PL/SQL programs for data extraction, validation, reporting and business process automation across telecom and insurance applications.
• Automated operational reports using Oracle SQL for daily, weekly, and monthly business reporting.
• Contributed to the successful rollout of GST by implementing required billing and taxation changes.
• Investigated and resolved production issues ensuring minimal impact to business operations.
• Optimised slow running queries through SQL performance tuning to improve application performance.
• Worked with SQL*Loader, Oracle Import/Export, and Excel based data processing for data import, export operational activities.
• Provided production support through root cause analysis, including Monitoring Oracle Tuxedo services, resolving connectivity issues between upstream/ downstream applications and implementing application fixes.