Ramesh Kumar M V S

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.

Lead PLSQL Developer - LPL Finance - Chicago, IL

(2025-10)

• 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.

Lead PLSQL /Etl Developer - Bank of America - Chicago, IL

(2024-06 - 2025-09)

• 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.

B.V.SC & A.H - Acharya N.G Ranga Agricultural University (2002)