Senior Oracle PL/SQL Data Engineer

Ramesh Kumar M V S

Mail: *******@*****.*****

Phone: 813-***-**** https://www.linkedin.com/in/mrameshkumar79/

PROFESSIONAL SUMMARY

Experienced PL/SQL Developer / Data Engineer with 18+ years of hands-on expertise in designing, developing, tuning, and maintaining complex database applications, ETL pipelines, and enterprise data integration solutions using Oracle, SQL Server, PostgreSQL, Informatica PowerCenter, ODI, SSIS, Python, and AWS.

Extensive experience with Oracle Database (19c/12c/11g), SQL Server (2008/2016/2018), and PostgreSQL (12.x/14.x) in client-server and enterprise application environments, delivering scalable, secure, and high-performing database solutions.

Proven success in ETL pipeline optimization and feed tuning, redesigning workflows, optimizing source-to-target mappings, implementing partitioning, parallel processing, incremental loads, and bulk processing techniques to reduce ETL runtimes by 40–60%, improve batch throughput, and consistently meet SLA requirements.

Deep expertise in advanced PL/SQL programming including stored procedures, functions, packages, triggers, cursors, exception handling, collections, MERGE statements, analytical functions, materialized views, dynamic SQL, external tables, object-oriented programming, table functions, and autonomous transactions.

Hands-on expertise with advanced PL/SQL performance features including Bulk Collect, FORALL, SAVE EXCEPTIONS, pipelined functions, SYS_REFCURSOR, DBMS_SQL, DBMS_SCHEDULER, UTL_FILE, DBMS_XMLDOM, DBMS_UTILITY, and DBMS_LOCK for large-scale data transformation and automation.

Strong background in SQL and database performance tuning using AWR/ASH reports, TKPROF, SQL Trace, SQL Profiles, EXPLAIN PLAN, SQL Tuning Advisor, indexing strategies, optimizer hints, partition pruning, and system parameter tuning, reducing long-running SQL queries from hours to minutes.

Implemented advanced Oracle partitioning strategies (RANGE, LIST, HASH) to optimize large-scale data loading, feed processing, and analytical query performance.

Extensive ETL experience with Informatica PowerCenter, Oracle Data Integrator (ODI), SSIS, SQL*Loader, external tables, Shell/Bash scripting, PowerShell, Unix/Linux scripting, and automation frameworks for high-volume data ingestion and transformation.

Hands-on experience developing Python solutions for data extraction, transformation, validation, automation, REST API integrations, data quality checks, and large-scale data processing using Python libraries and scripting frameworks.

Improved enterprise data feeds and file ingestion frameworks by implementing automated reconciliation, validation, audit logging, restart/recovery mechanisms, and parallel load strategies, reducing feed failures by 50%+ and improving data quality.

Strong experience in workflow orchestration and scheduling using Autosys, Control-M, Apache Airflow, cron jobs, and Jenkins CI/CD pipelines for automated batch processing, dependency management, SLA monitoring, alerting, and failure recovery.

Hands-on cloud experience with AWS EC2, AWS RDS (Oracle), and AWS S3 for cloud database migration, ETL workload deployment, monitoring, backup/recovery, secure connectivity, and scalable data storage.

Proficient in Python (Pandas, Requests) for API integration, data extraction, cleansing, parsing, and preprocessing of semi-structured datasets; additional development experience in Core Java and J2EE.

Strong expertise in data modeling, data migration, data conversion, data profiling, source-to-target mapping, BRD/FRD documentation, system architecture, ERD, process flow diagrams, and enterprise reporting using SSRS, Power BI, and Splash BI.

Experienced in Agile/Kanban methodologies, JIRA, GitHub, Azure DevOps, GitHub Copilot, and full SDLC including development, testing, deployment, release management, production support, and critical issue resolution.

EDUCATIONAL DETAILS:

B.V.SC & A.H from Acharya N.G Ranga Agricultural University 2002

TECHNICAL SKILLS

Oracle 19c Exa Data/12c/11g/10G/9i/8i/8, SQL, PL/SQL, SQL*PLUS,

Oracle Utilities SQL*Loader (SQLLDR), SQL Developer, TOAD

18

Performance Tuning and Optimization

6

AWS RDS, S3, Git, GitHub, DevOps pipelines, Jenkins, CI/CD

4

ETL Tools (Informatica 9x,10x, ODI)

10

UNIX Shell Scripting, Aix Cron Scheduling

4

Data Modeling using Erwin 8x,9x,10x

6

SQL Server 2005,2008,2016,2018,2019

6

Reporting Tools: Power BI, Splash BI

6

REST API, JSON, XML, Micro Services, SSIS Packages

4

VSS, DevOps, Git (Version Controlling Tools)

10

Database Testing, Unit Testing, Integration testing, User Acceptance Testing

6

Oracle Forms 6i/9i, Oracle Reports 6i/9i

6

PROFESSIONAL EXPERIENCE

LPL Finance, Fort Mill,SC Oct’2025– Till date

Lead PLSQL Developer

Responsibilities

Engineered and optimized high-performance PL/SQL packages, procedures, functions, and materialized views on Oracle 19c Exadata, leveraging partitioning, parallel execution, bulk processing, and AWR/ASH diagnostics to reduce ETL runtimes by 40–60% and improve batch throughput.

Led ETL pipeline performance tuning initiatives by redesigning workflows, optimizing source-to-target mappings, implementing incremental loads, and eliminating bottlenecks, reducing batch windows and consistently meeting production SLAs.

Designed and developed scalable ETL solutions using Informatica PowerCenter 10.x, including reusable mappings, mapplets, workflows, sessions, partitioning, and pushdown optimization, improving load efficiency by 35%+.

Optimized high-volume data feeds and file ingestion pipelines by parallelizing loads, tuning transformations, and implementing automated validation/reconciliation frameworks, reducing feed failures by 50% and improving delivery reliability.

Performed advanced SQL and PL/SQL tuning using AWR/ASH reports, TKPROF, execution plans, SQL Profiles, indexing strategies, partition pruning, and optimizer hints, reducing long-running queries from hours to minutes.

Developed enterprise-grade PL/SQL frameworks using BULK COLLECT, FORALL, pipelined functions, dynamic SQL, exception handling, and autonomous transactions to process multi-million record transformations efficiently.

Built and secured REST/SOAP APIs using Oracle technologies to support real-time integrations between enterprise applications, third-party systems, and reporting platforms.

Automated production batch workflows using Autosys, implementing dependency management, SLA monitoring, alerting, restart/recovery logic, and failure notifications to improve operational stability and reduce manual support efforts.

Executed enterprise data integration and migration across Oracle databases, flat files, APIs, AWS S3, and third-party systems, ensuring 99.9% data accuracy through reconciliation, auditing, and validation controls.

Developed Python-based data processing utilities using Python, Pandas, Requests, and custom parsers for API ingestion, data cleansing, standardization, and preprocessing of semi-structured datasets.

Improved BI/reporting performance by optimizing SQL queries, materialized views, indexing, and partitioning strategies, enabling faster analytics and dashboard refreshes in Power BI.

Managed cloud database and ETL infrastructure on AWS RDS (Oracle), EC2, and S3, supporting database migration, secure connectivity, backup/recovery, monitoring, and scalable ETL workloads.

Leveraged GitHub Copilot and version control tools including Git/GitHub to accelerate development, improve code quality, and reduce release cycles across PL/SQL, Python, and ETL projects.

Environment: Oracle 19c Exadata, AWS RDS, EC2, S3, Informatica 10x, Python, Toad 16, GitHub, Jira, AutoSys, Visio, Unix, Windows, XML, Excel, Visual studio 15/17,

Bank of America, Chicago,IL June’2024– Sept’2025

Lead PLSQL /Etl Developer

Responsibilities

Built scalable ETL workflows in Informatica PowerCenter 10.x using reusable mappings, mapplets, and optimized transformations to enhance data load efficiency and maintainability.

Engineered and optimized high-performance PL/SQL packages, functions, and materialized views on Oracle 19c Exadata, leveraging partitioning, parallel execution, and AWR/ASH diagnostics to improve throughput and significantly reduce ETL runtimes.

Performed advanced SQL and PL/SQL performance tuning using AWR/ASH reports, TKPROF, SQL Profiles, indexing strategies, partition pruning, and optimizer hints, resulting in reduced query execution times and improved overall system performance.

Developed advanced PL/SQL frameworks utilizing BULK COLLECT, FORALL, pipelined functions, dynamic SQL, and autonomous transactions to efficiently process high-volume data transformations.

Designed enterprise data models and optimized SQL queries to support analytics and BI dashboards delivered through Power BI.

Improved reporting performance by optimizing SQL queries, implementing partition strategies, and maintaining materialized views for high-performance analytical workloads.

Executed large-scale data migration and integration across Oracle databases, flat files, and third-party systems with robust error handling and reconciliation frameworks.

Ensured ETL accuracy and data integrity through validation rules, reconciliation processes, and comprehensive audit logging mechanisms.

Designed and secured REST and SOAP-based Oracle APIs to enable real-time data exchange across internal applications, third-party systems, and enterprise reporting platforms.

Utilized Python (Pandas, Requests, and custom parsing scripts) to extract, cleanse, and standardize data from APIs, flat files, and semi-structured sources for downstream ETL processing.

Automated enterprise batch workflows using Autosys, implementing job scheduling, dependency management, SLA monitoring, alerting, and failure recovery mechanisms.

Leveraged GitHub Copilot to accelerate PL/SQL, Python, and ETL development, improving code quality and reducing development cycles.

Configured and managed AWS RDS (Oracle), including database migration, performance tuning, backup and recovery, monitoring, and secure connectivity.

Documented enterprise architecture by developing business process flows, data lineage diagrams, and application architecture documentation using Microsoft Visio, supporting design reviews, audits, and compliance initiatives.

Environment: Oracle 19c Exadata, AWS RDS, EC2, S3, Informatica 10x, Python, Toad 16, GitHub, Jira, AutoSys, Visio, Unix, Windows, XML, Excel, Visual studio 15.

Abbvie INC, Chicago,IL March’2023 – May’2024

Lead PLSQL Developer

Responsibilities:

Designing, developing, and maintaining PL/SQL code and database objects such as tables, views, stored procedures, functions, triggers, and packages.

Identifying and resolving performance issues by analyzing and optimizing SQL queries, tuning database parameters, and optimizing PL/SQL code for efficient execution.

Collaborating with database administrators and stakeholders to design efficient and scalable database structures, including data modeling, normalization, denormalization, and partitioning strategies.

Built and optimized PL/pgSQL functions, procedures, triggers, and SQL queries using indexing, partitioning, CTEs, and EXPLAIN ANALYZE for high-volume data processing.

Written queries using Postgres 14 and written & implemented PL/PostgreSQL Procedures.

Partitioned the fact tables and materialized views to enhance the performance. Extensively used bulk collection in PL/SQL objects for improving performance.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problems in database triggers.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Supported Data Warehouse by developing Packaged Procedures to Loading data from Stage table to Fact table with Validations.

Create and manage JSON data structures within Oracle databases, including tables, columns, and indexes.

Develop PL/SQL procedures, functions, and packages to handle JSON data processing, validation, and transformation.

Write efficient SQL queries and optimize performance for JSON data retrieval and manipulation.

Provided production support by troubleshooting and resolving database-related issues, addressing user queries, and ensuring database availability and performance.

parsers written in python for extracting useful data from the design database. Used Airflow to schedule and monitor workflows.

Developed code fixes and enhancements for inclusion in future code releases and patches.

Environment: Oracle 19c/12c, PostgreSQL 14, Informatica 10x, Oracle LSH, Python, Toad 9/11, Git, DevOps, Jira, Airflow, Windows, XP, XML, Excel, Visual studio 15/17, Unix, AIX, Visio

Baker-Taylor Dec’2018– Feb’202023

Senior PLSQL Developer

Responsibilities:

Designing, developing, and maintaining PL/SQL code and database objects such as tables, views, stored procedures, functions, triggers, and packages.

Built and optimized PL/pgSQL functions, procedures, and SQL queries in PostgreSQL 12 using indexing, partitioning, and performance analysis tools.

Collaborating with database administrators and stakeholders to design efficient and scalable database structures, including data modeling, normalization, die-normalization, and partitioning strategies.

Attended CDMS and EDW Production support and bugs are fixed by applying hotfixes.

Monitoring of ETL feeds and fixing the production ETL Feeds failure by identifying the problem by checking the logs, source directories and any database space issues.

Identifying and resolving performance issues by analyzing and optimizing SQL queries, tuning database parameters, and optimizing PL/SQL code for efficient execution.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Working on SQL*Loader & Eternal tables to load data from flat files obtained from various facilities every day.

Developed and implemented reporting, analytics and data visualization solutions with Power BI.

Partitioned the fact tables and materialized views to enhance the performance. Extensively used bulk collection in PL/SQL objects for improving performance.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Supported Data Warehouse by developing Packaged Procedures to Loading data from Stage table to Fact table with Validations.

Developed, implemented and maintained SSIS/DTS Packages to Extract Data from SQL Servers.

Used version controlling applications like GitHub, DevOps.

Created interactive and visually appealing reports and dashboards in SSRS, Apache Airflow

Create and manage JSON data structures within Oracle databases, including tables, columns, and indexes.

Implement JSON parsing and serialization/deserialization techniques in Oracle applications.

parsers written in python for extracting useful data from the design database. Used Airflow to schedule and monitor workflows.

Developed code fixes and enhancements for inclusion in future code releases and patches.

Environment: Oracle 12c, PostgreSQL 12, Informatica 10x, AWS, SQL server (2004/2006/2016), SSIS, SSRS, JSON, REST API, Toad 9/11, Git, DevOps, Jira, Airflow, Windows, XP, XML, Excel, Visual studio 15/17, Unix, AIX, Visio.

Hospital Information System, Ministry of Health,Oman March’2012 –Nov 2018

Orac le Databaase Developer

Responsibilities:

Designing, developing, and maintaining Oracle databases using PL/SQL. This involves creating tables, views, indexes, and other database objects to store and manage hospital-related data.

Data transformation, conversion and interface, data loading, database modeling and performance tuning.

Designing, developing, and maintaining ETL (Extract, Transform, Load) processes using IBM Infosphere DataStage 9.x

Analyzing source system data structures, mapping data elements to target systems, and ensuring data consistency and integrity across multiple systems.

extracting data from different source systems (such as databases, flat files, or APIs) using Infosphere DataStage's connectors and stages. You perform necessary data transformations, including data cleansing, aggregation, data formatting, and implementing business rules.

creating data integration workflows, transforming data from various sources, and loading it into target using IBM Infosphere DataStage 9.x

Optimizing the performance of DataStage jobs is a critical responsibility. You identify performance bottlenecks, fine-tune data integration processes, optimize SQL queries, and enhance job performance through parallel processing, partitioning, or caching techniques.

Written complex queries using Postgres 9.x and written & implemented PL/ PostgreSQL Procedures.

Integration of Different Applications with XML and Web Services.

Development of complex reports to meet the user requirement by using oracle Reports 6i/9i

Creating Tables, Views, Materialized Views, Global temporary tables. Coding of Procedure and Packages in PL/SQL developer.

Migrated different Objects from SQL server database to oracle database.

Developed and maintained software components of the HRP platform. This involves writing code, designing and implementing new features, and enhancing existing functionalities.

Environment: Oracle 11g, PL/SQL, IBM Infosphere DataStage 9.x, SSIS, Visual studio 13, Control M, Forms 9i, Reports 9i, Windows XP, Windows 10 and MS Visio

Inter-tech, Muscat,Oman April’2009 –Feb2012

Orac le Databaase Developer

Responsibilities:

Designing, developing, and maintaining Oracle databases using PL/SQL. This involves creating tables, views, indexes, and other database objects to store and manage hospital-related data.

Performing code reviews with analysts and application architects.

Development of applications using the forms 6i/9i and reports 6i/9i on Oracle 11g.

Development of unit and system test plans.

Data transformation, conversion and interface, data loading, database modeling and performance tuning.

Development of complex reports to meet the user requirement by using oracle Reports 6i/9i

Creating Tables, Views, Materialized Views, Global temporary tables.

Coding of Procedure and Packages in PL/SQL developer.

Integrating Procedures with Cursors.

Created triggers as per the Client specification.

Created functions to meet the business logic.

Involving in integration of modules, unit testing and system testing

Environment: Oracle 11g, PL/SQL, IBM Infosphere DataStage 9.x, SSIS, Visual studio 13, Control M, Forms 9i, Reports 9i, Windows XP, Windows 10 and MS Visio

Fore C Soft, Chennai,India Nov’2006 –March’2009

Orac le Databaase Developer

Responsibilities:

Designing, developing, and maintaining Oracle databases using PL/SQL. This involves creating tables, views, indexes, and other database objects to store and manage hospital-related data.

Performing code reviews with analysts and application architects.

Development of applications using the forms 6i/9i and reports 6i/9i on Oracle 11g.

Data transformation, conversion and interface, data loading, database modeling and performance tuning.

Development of complex reports to meet the user requirement by using oracle Reports 6i/9i

Creating Tables, Views, Materialized Views, Global temporary tables.

Coding of Procedure and Packages in PL/SQL developer.Integrating Procedures with Cursors.

Created functions to meet the business logic.Involving in integration of modules, unit testing and system testing

Environment: Oracle 11g, PL/SQL, Forms 6i/9i, Reports 6i/9, Windows XP, Windows 10 and MS Visio

Contact this candidate