Oracle PL/SQL Developer & SQL Performance Tuner

Mary Sweta Kerketta

Oracle PL/SQL Developer

Boston, MA 857-***-**** ************@*****.***

LinkedIn GitHub Tableau

SUMMARY

Oracle PL/SQL developer specializing in SQL performance tuning and enterprise data migration, with 12+ years across banking and financial services. Migrated 10M+ customer records across Oracle environments and cut a critical reporting pipeline from 8 hours to roughly 3 hours through query tuning and restructuring. Fluent in PL/SQL procedures, SQL optimization, data modeling, data validation, and production root-cause troubleshooting within large, regulated enterprise systems. Comfortable coordinating releases through Git/Bitbucket and collaborating with UI, ETL, QA, and support teams. MPS in Informatics (Analytics), Northeastern University, 2026.

SKILLS

Oracle & Databases: Oracle Database, PL/SQL, SQL, SQL Performance Tuning, Query Optimization, Oracle Data Pump, DB Links, SQL Server, PostgreSQL, MySQL

Database Development: PL/SQL Packages, Procedures, Functions, Triggers, Views, Indexes, Materialized Views, Data Modeling, Database Design, Data Migration, Data Validation & Integrity, Rollback Design

Version Control & Release: Git, Bitbucket, Jenkins, CI/CD, Code Promotion, Change Management, Production Support & RCA

Programming & Scripting: Python, Java, Shell Scripting, R

Data Engineering & ETL: Apache Spark, Hadoop/HDFS, Hive, Kafka, Apache Airflow, Control-M, Pentaho ETL, ETL/ELT, Data Warehousing

Cloud & BI: AWS (S3, EKS, EMR, Glue, Athena, Redshift), Tableau

EXPERIENCE

JP Morgan Chase & Co., Bangalore, India December 2017 – August 2024

Senior Associate

•Reduced a critical enterprise reporting pipeline from 8 hours to approximately 3 hours (over 60%) through SQL query tuning and pipeline restructuring, protecting on-time regulatory reporting for FX trading.

•Built ingestion pipelines pulling data from Oracle databases into enterprise data platforms, enforcing data integrity across upstream and downstream systems.

•Improved reporting performance by 50% by diagnosing data-layer bottlenecks and deploying scheduled optimization jobs against large datasets.

•Led war-room production support for mission-critical data pipelines supporting trading operations, driving root-cause analysis and resolving failures within defined SLAs.

•Developed REST APIs for an internal workflow-management platform, enabling programmatic execution and cross-team integration across services.

EdgeVerve Systems Limited, Hyderabad, India August 2015 – December 2017

Technology Analyst

•Designed and implemented database migration frameworks for corporate and taxation banking systems during core architecture upgrades for ICICI Bank.

•Developed and optimized PL/SQL packages, procedures, functions, and triggers to implement migration and validation logic and improve throughput across large banking datasets.

•Built validation scripts enforcing data integrity across every migration phase, preventing data loss between legacy and modern Oracle platforms.

•Partnered with client stakeholders onsite and offshore to gather requirements, validate migration logic, and resolve post-migration production issues.

•Mentored junior engineers onboarding to the migration program.

Infosys Limited, Hyderabad, India June 2011 – July 2015

Senior Software Engineer

•Migrated 10M+ customer records and banking datasets from Oracle 6.x to Oracle 11.x using PL/SQL scripts, DB Links, and Oracle Data Pump during core retail-banking modernization for ICICI Bank.

•Developed phase-wise PL/SQL migration scripts enabling incremental migration of customer data and modules with no disruption to live users.

•Engineered rollback mechanisms to safely revert users when target features were not yet available, protecting production stability during phased cutovers.

•Applied SQL performance tuning, indexes, and materialized views to cut execution time on large migration queries, and built data-validation frameworks verifying accuracy at each phase.

•Supported critical deployment windows and resolved post-migration production issues; facilitated knowledge transfer across team transitions.

TechElevate, Remote July 2026 – Present

Business Analyst Intern

•Built an interactive HTML/JavaScript dashboard reading directly from CSV and Excel sources, converting manual analysis into an explorable self-service tool for the team.

•Consolidated and de-duplicated student records from multiple sources into a structured master dataset supporting demographic and impact reporting.

EDUCATION

Northeastern University, Boston, MA September 2024 – April 2026

Master of Professional Studies in Informatics (Analytics)

Anil Neerukonda Institute of Technology & Sciences, Andhra University, India September 2007 – April 2011

Bachelor of Engineering in Electronics and Communication Engineering

CERTIFICATIONS

•AWS Certified Cloud Practitioner (March 2023 – February 2029)

•Astronomer Certification for Apache Airflow 3 Fundamentals (January 2026)

•SnowPro Associate: Platform Certification (April 2026 – April 2028)

Contact this candidate