×
Gilbert Hopkins

Gilbert Hopkins

Data Engineer @ Hexagon ALI

Houston, Texas, US

Background


About

About

I’m a

Work Experience

Work Experience

  • Data Engineer Lead, Hexagon - ALI Division

    Jan, 2021 - Present

    Hexagon’s Asset Lifecycle Intelligence division helps clients design, construct, and operate more profitable, safe, and sustainable industrial facilities. We empower customers to unlock data, accelerate industrial project modernization and digital maturity, increase productivity, and move the sustainability needle.

    • Automated and managed batch data pipelines from various internal & external business systems using Azure DevOps, Azure Data Factory, and Databricks.

  • System Developer Specialist, Accenture Federal Services

    Dec, 2015 - Jan, 20204 years 1 month

    Blockbid is an Australian crypto currency exchange. I started off on the frontend but eventually became lead tech and worked on every moving piece of the exchange. I really enjoyed working with liquidity providers and connecting their platforms to help us achieve liquid markets.

    • Supported frequent ad-hoc client requests, extracting data, coordinating validation, and creating client-ready material to provide ongoing reporting and analysis.

    • Identified tends and patterns in large data sets and translated them into marketing and financial insights.

    • Developed, maintained, and coordinated testing of large complex EDA datasets (~1500 fields) used in training predictive models utilizing SAS, SQL, and Python.

    • Automated measurement/monitoring and data management tasks using R, SAS and Python, greatly reducing report and dataset development time.

    • Introduced novel process improvements, including additional model monitoring metrics and modeling variables to enhance predictive model tracking and performance.

  • System Developer Senior Analyst, Accenture Federal Services

    Dec, 2014 - Dec, 20151 year

    Worked with the sales organization of a federal client to address the goal to grow revenue by improving closed sale rates and average revenue per sale. Implemented a solution to assist the client’s sales organization by providing a tool that allows for more effective management of the sales funnel by optimizing the time spent pursuing individual sales opportunities using predictive analytics.

    • Collaborated with Analytics team to design and build various automation pipelines that translated predictive statistical models into production applications with procedural processing. This reduced overall deployment time by streamlining operations for data collection, model deployment, and model monitoring.

    • Identified tends and patterns in large data sets and translated them into marketing and financial insights.

    • Developed, maintained, and coordinated testing of large complex EDA datasets (~1500 fields) used in training predictive models utilizing SAS, SQL, and Python.

    • Automated measurement/monitoring and data management tasks using R, SAS and Python, greatly reducing report and dataset development time.

    • Introduced novel process improvements, including additional model monitoring metrics and modeling variables to enhance predictive model tracking and performance.

  • System Developer Analyst, Accenture Federal Services

    Oct, 2012 - Dec, 20142 years 2 months

    Worked with a federal client to establish a technology reporting solution built on accurate customer information that will help drive more effective business decisions across their organization. The ability to know who their customers are and what they are doing across multiple service channels is essential to support current and future Marketing, Sales, and Service initiatives.

    • Translated complex business requirements into technical design documentation in order to modify existing ETL processes that integrated several additional external data sources into the customers data mart.

    • Composed design documentation detailing how the new data sources would affect component functionality, integration mappings, and database infrastructure across Reporting and Analytics teams.

    • Prepared test cases, test data, and PL/SQL test queries to validate new system integration and functionality.

    • Identified defects across multiple DB environments (DEV, SIT, and CAT) and collaborated with the development team to ensure minimal post-implementation bugs.

Skills

Skills

  • Programming Languages

    SQL

    Python

    R

    SAS

    Scala

  • Databases

    SQL Server

    Oracle

    PostgreSQL

    MySQL

  • ETL

    Azure Datafactory

    Informatica

    Apache Airflow

    Databricks

  • Devops

    Azure DevOps CI/CD

    Git

  • BI Tools

    MicroStrategy

    PowerBI

    Tableau CRM (Analytics Studio)

    Qlik Sense

Education

Education

  • Computer Engineering, Bachelors, Howard University

    Aug, 2008 - May, 2012

Interests

Interests

  • History

  • Music

  • Reading / Writing

  • Open Source