Lance Lopez Email & Phone Number

Austin, Texas, United States

Implemented the next phase of the Program Data Repository system by developing robust ETL pipelines for ingesting operational data from the Raw Data Repository. Collaborated with trusted partners to ensure data availability in our data warehouses for users of the Self-Service Analytics Dashboard (SSAD) in Tableau.• Designed, developed, tested, and maintained multiple Apache NiFi and Google App Engine Python pipelines to extract data from Google BigQuery, MySQL, REST APIs, JSON files, and Google Cloud Storage, inserting data into PostgreSQL databases. • Conducted Python code reviews.• Developed 13 Google App Engine scheduled jobs in Python to call third-party APIs for ingesting and transforming medical data.• Worked with Jupyter notebooks to visualize data quality reports.• Utilized explain plans in PostgreSQL for high-performance updates, selects, and inserts.• Queried object metadata to assist in building data dictionaries.• Performed Linux administration and created shell scripts for use in Google Cloud Virtual Machines• Demonstrated a strong understanding of Agile methodologies by using Jira to estimate and track work progress in 2-week sprints

Austin, Texas, United States

Served as a lead ETL Developer with Texas Medicaid Healthcare Partnership, the claims administrator for Texas Medicaid under contract with the Texas Health and Human Services Commission. Utilized Visual C++, Informatica PowerCenter, Oracle and Business Objects to allow the State of Texas to develop policy and detect fraud using multiple Data Warehouses. • Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer and Visual C++ to extract the data from multiple source systems including flat files and legacy relational databases to Data Warehouses in Oracle.• Created 40 Business Objects Universes, Reports and Dashboards to help State users visualize the vast amounts of claims data.• Managed large data volumes, handling hundreds of millions of records.• Collaborated with the DevOps team on Maven and utilized Eclipse for building and managing source code repositories.• Converted a legacy batch processing system with 60 scheduled jobs into a more efficient ETL system using 5 Informatica Workflows and several C++ programs.• Designed and developed ETL processes using Informatica transformations such as Sorter, Aggregator, Router, Normalizer, Sequence, Union, Ranker, Update Strategy, Lookup, Stored Procedure, Source, Target, and Transaction Control.• Employed Informatica Data Validation Option for regression testing Informatica Workflows.• Designed databases using both star and snowflake schemas.• Developed PL/SQL procedures with looping for large data updates to the Production Oracle Database.• Implemented PL/SQL triggers to update specific dimension records based on inserts into a fact table.

Austin, Texas, United States

Developed the installation component for a complex database system. Used C++ to create several utilities designed to monitor the end user's computer for third-party processes, configure the database, test network connectivity and provide relational access to the database. Created toolkit and detailed documentation for embedding in OEM product. • Completely redesigned and re-authored (over 20,000 lines of code) the installation component of Pervasive's primary and most profitable product. Completed project in 8 months, a full 10 months ahead of the estimate, allowing for cost savings and increased efficiencies.• Utilized online customer feedback tool to reduce the number of end user-reporteddefects resulting in the lowest level of install-related bugs since company's inception.

Austin, Texas, United States

Designed and deployed clinical testing software as part of a large development team. Developed various parts of software, including low-level database interactions and wizard-style GUI’s using Visual C++, Visual Basic, and C#. Programmed and maintained a complex, robust SQL Server 7 database with 21 CFR Part 11 security features. Used third party controls to display detailed scientific data in a graphical format. • Increased product’s usability and streamlined software lifecycle by implementing internal bug tracking software for customer service.• Improved the throughput of the system 250 percent by doing low-level time profiling of the code, then reorganizing and refining software.• Fulfilled client’s need for data reports by gathering requirements and designing and developing multiple Crystal Reports.