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

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

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