Employment History 

• Technical Professional / Field Engineer

  US Well Services | San Angelo, Texas

  March 2019 - Present

  • Helped generate $6+ million/year revenue by providing mechanical, software, and logging services on Frac SITE.
  • SSRS services to extract and migrate information to determine client system limitations for capacity and load for oil and energy data processing projects.
  • Mentored 10+ field engineers/year to operate Frac equipment and data measurement tools to ensure safety and optimal efficiency.
  • Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
  • Specified user access levels for each database segment to protect database integrity and company information.
  • Administered, supported, and strictly monitored databases to quickly resolve problems with Microsoft Visual Studio and SQL servers.

• SQL Server BI/SSIS/SSRS Developer

  Pact international. – Kigali, Rwanda

  June 2008 - May 2012

  • Analyzed source system data to determine the data model and ETL solution that will meet business requirements.
  • Formulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.
  • Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and ForEach Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
  • Write Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse.
  • Created, Process, Partitioned the cubes using SSAS.
  • Created various Stored Procedures to validate the data from the source and update/insert the records into target tables.
  • Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans.
  • Work closely with Report analysts and operation staff for support in problem resolution and root cause analysis.
  • Created/monitored scheduled data warehouse jobs using SQL Server Agent jobs.
  • Worked with users and business analysts to design and develop tabular, matrix, gauges, Charts, drill down interactive reports.

• Field Engineer

  CUDD Energy services | Odessa, Texas

  December 2016 - February 2019

  • Analyzed seven wells for H2S pipe corrosion to determine field trend and used results to recommend surface casing pipe selections for future wells, resulting in cost savings of $40,000 per well.
  • Diagnosed well problems and provided recommendation to improve oil well performance by stimulating the well, optimizing electrical submersible pump, and artificial lift to improve the well performance.
  • Contributed to a 35% reporting decrease for all health, safety, and environmental incidents by implementing behavior-based safety practices.