Senior Data Architect & SQL ETL Leader

RAMESH LAKSHMINARAYANA

Senior SQL Data Engineer PMP SQL PL/SQL ETL Data Modeling

203-***-**** ️ ********@*******.***

LinkedIn: www.linkedin.com/in/ramesh-lakshminarayana-3213b411 SUMMARY

PMP certified, Senior Oracle Data Engineer with 20+ years of experience designing and delivering large scale Oracle based data pipelines, historical backfills, and curated data models for enterprise platforms. Expert in advanced SQL, PL/SQL, Oracle performance tuning, ETL design, identifier normalization, and multi year historical data processing. Proven ability to extend Oracle data models, build extract driven datasets, and support downstream engineering teams in complex, multi team delivery environments. Strong background in regulated, high volume, compliance sensitive data domains including financial services, healthcare, and global operations. Adept at translating ambiguous business requirements into robust data models, high quality SQL, and production ready solutions that improve stability, speed, and maintainability Core skills (SQL, errors, performance)

● SQL & Query Design: Advanced SQL for complex joins, window functions, aggregations, and incremental loads across large, normalized and denormalized models.

● Performance Tuning: Query plan analysis, index strategy, partitioning, statistics management, and refactoring SQL to reduce I/O, CPU, and runtime.

● Error Detection & Debugging: Systematic root-cause analysis of data issues, constraint violations, and pipeline failures; strong in reproducing, isolating, and fixing defects.

● Code Quality & Standards: Enforcing SQL coding standards, peer reviews, reusable patterns, and consistent naming for long-term maintainability.

● Data Validation & Reconciliation: Building validation queries, row/column-level checks, and reconciliation logic between source, staging, and target systems.

● ETL/ELT & Pipelines: Designing and optimizing ingestion and transformation logic using stored procedures, DBT, DLT, and orchestration tools. PROFESSIONAL EXPERIENCE

IBM / Medtronic — Senior Oracle Data Engineer / Data Architect June 2021 – Present Minnesota, MN

Oracle Data Engineering & ETL Enhancements

● Designed and developed complex PL/SQL procedures, packages, and transformation logic to curate SAP transactional data into Oracle semantic layers for reporting (Inventory, Cycle Count, Adjustments, ETA, SCM, GSR, SPM).

● Designed and optimized Oracle tables, indexes, partitions, and materialized views to support high volume migration loads.

● Built robust XML parsing workflows using XMLTABLE, XMLTYPE, and XQuery to convert complex hierarchical XML into relational structures with optimized performance and error handling.

● Automated XML-to-database transformations using DBMS_XMLSTORE and PL/SQL procedures.

● Built Oracle based semantic data models, applying business rules, validations, and transformation logic to convert SAP structures into business friendly curated datasets.

● Performed extensive data profiling, cleansing, and mapping using PL/SQL, ensuring accurate migration of SAP fields into Oracle and Snowflake target structures.

● Built and extended Oracle curated tables, ensuring stability for downstream analytics and extract driven consumers.

● Performed normalization, cross reference mapping, and lineage analysis to ensure consistent downstream consumption.

● Developed PL/SQL driven reconciliation scripts to validate SAP Oracle/SQL Server Snowflake data consistency across mock loads and production cycles.

● Created and optimized Oracle tables, indexes, partitions, and materialized views to support high volume migration loads and downstream reporting.

● Created historical extraction and backfill processes (multi year), aligned with go forward incremental load strategies.

● Implemented incremental load logic using PL/SQL, leveraging timestamps, change flags, and SAP delta indicators to support near real time reporting.

● Collaborated with business analysts to translate SAP technical fields into curated Oracle attributes, ensuring traceability and auditability of all migrated data.

● Built PL/SQL driven reconciliation frameworks validating SAP Oracle/SQL Server Snowflake data consistency.

Extract Driven Delivery & Downstream Support

● Produced file based extracts, placeholder datasets, and interim artifacts for parallel development across multiple teams.

● Partnered with QA and downstream engineering teams to support integration testing, defect resolution, and production readiness.

● Delivered detailed documentation including mapping sheets, transformation logic, lineage diagrams, and reconciliation reports.

Migration & Cloud Integration

● Migrated curated Oracle datasets into Snowflake using Snowpipe, Streams, Tasks, and DBT based ELT pipelines.

● Automated incremental refresh and synchronization across SAP Oracle Snowflake. Environment: Oracle 10/11g, PL/SQL, SAP, SQL Server, Snowflake, DBT, Airflow, Shell Scripting, XML/JSON, Erwin, PowerDesigner

Health Fitness Corporation — Oracle Data Engineer / Developer July 2016 – Feb 2021 Lake County, IL

● Designed conceptual and logical Oracle data models supporting analytics and modernization initiatives.

● Enhanced Oracle schemas, indexing strategies, and partitioning to improve ETL performance.

● Automated nightly and near real time loads using SSIS, PowerShell, and Shell scripts.

● Migrated legacy systems into redesigned Oracle warehouse structures supporting compliance reporting.

● Conducted performance tuning using AWR, SQL optimization, and structural improvements.

● Delivered POCs validating Oracle enhancements and integration feasibility.

● Designed and optimized complex SQL queries (joins, window functions, CTEs) on multi billion row tables, reducing key report runtimes from X minutes to Y minutes.

● Analyzed execution plans and database statistics to identify bottlenecks, then refactored queries and indexing strategies to improve performance by X–Y%.

● Implemented systematic error checking in ETL/ELT pipelines, including validation queries, row counts, and reconciliation checks between source and target systems.

● Resolved critical production defects by tracing data issues back to SQL logic, incorrect joins, or missing filters, and deploying safe, well tested fixes.

● Standardized SQL coding practices across the team, introducing review checklists focused on correctness, performance, and readability.

● Partnered with application and reporting teams to rewrite inefficient queries used in dashboards and APIs, significantly improving responsiveness and concurrency.

● Introduced performance baselines and regression checks so that new SQL changes are measured against existing runtimes and resource usage.

● Mentored developers and analysts on writing efficient SQL, reading execution plans, and avoiding anti patterns that cause hidden performance issues.

● Perform Real time SQL monitoring and bottleneck detection using OEM Environment: Oracle 10/11g, SQL Server, SSIS, Linux/HP UX, Python, Cognos, Performance tuning, OEM,Erwin SWIFT — Oracle Developer DBA

Oct 2014 – July 2016 Manassas, VA

● Implemented and tested Oracle Data Guard, Logical Data Guard, and disaster recovery scenarios.

● Automated SQL Baselines, statistics copy, and migration testing using Shell scripts.

● Performed production troubleshooting and root cause analysis. Pearson Education — Sr. Oracle Developer / Architect Jan 2012 – Oct 2014 New York, NY

● Developed and maintained Oracle applications, PL/SQL code, and schema designs.

● Supported structured and schema less databases (Oracle + MongoDB).

● Designed SOLR search schemas and centralized logging pipelines.

● Managed data refreshes across QA, UAT, and development environments. AIG Investments — Data Architect (Oracle)

July 2010 – Jan 2012 Jersey City, NJ

● Modeled Oracle data warehouse structures for GAAP, STAT, TAX, and regulatory reporting.

● Designed logical and physical Oracle data models using Erwin.

● Tuned complex PL/SQL code and optimized large scale ETL workloads. UBS Investment Bank — Sr. Oracle Developer

2009 – 2010 Stamford, CT

● Developed PL/SQL packages for trade compliance and commission engines.

● Tuned high volume queries for sub second response times. Additional Oracle Focused Experience (2003–2009)

GE Capital, Alliance Bernstein, XL Reinsurance, Freelife International, Lincoln Financial, Sprint

● Oracle data modeling

● PL/SQL development

● ETL/ELT design

● Historical data migration

● Performance tuning

● Extract driven data pipelines

● Erwin modeling

EDUCATION

Pondicherry University – India

Post Graduate Diploma in Computer Applications

Dr. B.R. Ambedkar Open University – India

Bachelor of Science (Math, Physics, Chemistry)

Certifications

Project Management Professional (2026-2029)

Contact this candidate