Rodrigo Lopez

Engineered and optimized core PL/SQL execution engines for the Cotiviti Policy Management platform, accelerating real-time processing of millions of healthcare claims and improving fraud detection accuracy. Refactored legacy regex engines and architected ETL metadata frameworks to ensure data integrity.

Led technical development of Data Transfer Utility for Government Business Division, enhancing provider data synchronization between SAPI and FACETS systems. Redesigned multi-tenant query systems, automated ETL workflows, and stabilized production infrastructure.

Delivered PL/SQL development support for Anthem's provider data management systems during a high-volume migration period, contributing to seamless integration between legacy and modernized platforms. Maintained 99%+ data accuracy across multi-state provider enrollment workflows.

Architected ETL pipeline processing 12+ million prescriber records from HMS-Lexis Nexis data feeds, achieving 70% performance improvement. Optimized query performance using TKPROF and Explain Plan, reducing execution time for critical reporting queries.

Developed and maintained Oracle PL/SQL solutions for enterprise insurance platform managing 3,500+ tables and 4,200+ packages. Led offshore development team of 20 engineers and designed ETL processes using PL/SQL, SQL*Loader, and Java.

Developed Oracle Forms/Reports applications and PL/SQL database objects for banking, telecommunications, and retail clients, building foundational expertise in full-stack Oracle development and SDLC best practices.

Bachelor of Science in Computer Science from the National University of Colombia.

Oracle Certified Associate (OCA) certification.

Microsoft Azure Solutions Development certification.

Foreign Exchange Market (FOREX) certification.