Summary
Overview
Work History
Education
Skills
Timeline
Generic

William Burns

Dayton,OH

Summary

Dependable ETL Developer with 3 years creating reliable and accurate data transformation tools. Well-versed in technologies such as Java and SQL. Designs ETL tools to scale overwhelming data transition tasks into manageable projects with realistic timeframes and achievable budgets.

Overview

7
7
years of professional experience

Work History

ETL Developer

Avance Consulting Services
2023.08 - Current
  • Worked for client Tech Mahindra, Ltd. and GE Aerospace
  • Designed Talend jobs to ingest data into GE Datalake
  • Created HVR Channels to ingest data into GE Datalake
  • Worked closely with client to diagnose issues with ingestion processes
  • Wrote and optimized in-application SQL statements.

Data Pipeline Engineer

Inceed, LLC
2022.02 - 2023.01
  • Maintained and upgraded existing Talend 7.3 codebase for client Tallgrass Energy.
  • Redesigned data ingestion process, including implementing new standards for Talend jobs.
  • Implemented new ingestions using REST API, as well as integrating with UIPath.
  • Assisted with transition to Talend 8 cloud environment.

BLADE Data Pipeline Engineer

DDC IT Services
2021.05 - 2022.02
  • Created NiFi flows to consume data into Hill Enterprise Data Center (HEDC) data store.
  • Modified metadata to support data pipeline activities.
  • Helped to prioritize data ingestion targets. Created, modified, and tracked user stories in DI2E Jira instance.
  • Trained using Advana software to support shift to Advana team.
  • Facilitated meetings between data owners and Advana teams to support Data Pipeline activities.
  • Maintain Secret clearance in order to work with DoD sensitive data.

BLADE Data Pipeline Engineer

Insight Global, LLC
2020.08 - 2021.05
  • Created NiFi flows to consume data into Hill Enterprise Data Center (HEDC) data store.
  • Modified metadata to support data pipeline activities. Helped to prioritize data ingestion targets.
  • Created, modified, and tracked user stories in DI2E Jira instance.
  • Acquired Secret clearance in order to work with DoD data pipeline

ETL Developer

GE 1FLEET TEAM Via Tech Mahindra, Ltd
2019.09 - 2020.04
  • I was hired by my client, Tech Mahindra, and remained in the same role as before
  • Maintained existing ETL infrastructure, using Talend for automation, DBeaver for testing/verification as well as PGAdmin III for DDLs
  • Added enhancements to existing ETL process, using Postgresql to create/modify views in source schema, as well as target tables in AWS target, and metadata in Oracle metadata schema
  • Coordinated closely with 1Fleet development team and Product Owners to determine and fulfill client's ETL needs, including participation in team's scrum ceremonies
  • Successfully automated Talend jobs in the production environment by going through established QA processes and coordinating with the Operations Team

ETL Developer

GE 1FLEET TEAM Via Revature, LLC
2019.05 - 2019.09
  • I moved to the GE 1Fleet team to serve as ETL support to the development team.
  • I maintained the existing Talend ETL process, performing necessary operations tasks, such as diagnosing and fixing data problems using DBeaver and PGAdmin III for SQL queries and data problems, and reforming the processes and programs associated with them.
  • I coordinated closely with 1Fleet development team and Product Owners to determine and fulfill client's ETL needs, including participation in team's scrum ceremonies.
  • I added improvements to the ETL process such as adding metrics tracking data to the ingestion process in the Postgresql target schema, streamlining the code of the ingestion programs, and modifying the ingestion metadata in the Oracle metadata instance as necessary to accommodate new tables and columns for the development team.
  • I successfully automated Talend jobs in the production environment by going through established QA processes and coordinating with the Operations Team.

ETL Developer and Squad Leader

GE DATA INGESTION TEAM Via Revature, LLC
2019.03 - 2019.05
  • I moved back to the Data Ingestion Team when they moved from the Evendale facility to the Global Operations Center in downtown Cincinnati.
  • I worked with the other members of the ingestion team to refine and improve their Talend ingestions, performing the necessary pre-checks before promoting their ingestions to the production environment, and helping to select user stories for team members.
  • I coordinated closely with the Operations Team to automate Talend jobs in the production environment, as well as diagnose and fix problems arising with new ingestions.
  • I set up new ingestions from various source DBs into the GE Datalake. Sources included Oracle, Postgresql, MSSQL, and MySQL DBs, and the target was Postgresql.
  • Designed and implemented custom code as necessary to handle non-standard ingestions.

ETL Developer

GE MSO TEAM Via Revature, LLC
2018.10 - 2019.03
  • I moved to the GE MSO team to serve as the ETL liaison and maintain their ETL process.
  • I reformed the Talend Jobs supporting their ETL process, streamlining them and bringing them up to the latest Data Ingestion standards, including modifying the Oracle ingestion metadata.
  • I created custom ingestions for the MSO schemas, notably the RSAF and FFD Sikorsky schemas, which entailed writing custom Java code for the Talend jobs, as well as custom SQL queries and DDLs using DBeaver and PGAdmin III.
  • I coordinated closely with the MSO team to identify and meet their ingestion needs, including participating in their scrum ceremonies and taking requirements from the Product Owner.

ETL Developer

GE DATA INGESTION TEAM Via Revature, LLC
2018.01 - 2018.10
  • I worked with GE Aviation in Cincinnati on their Aviation Data Ingestion Team at the GE Aviation facility in Evendale, OH.
  • I set up and maintained data ingestions into the GE data lake, utilizing Talend Data Integration v.6.3 and later, 7.2.
  • I modified ingestion metadata to accommodate new source databases, tables, and columns and promoting the new or expanded ingestions to the production environment.
  • I wrote custom Java code to accommodate custom requests for Ingestion team clients, including custom SQL queries and code to call Python scripts.
  • I helped to refine the Quality Assurance process for automating Talend jobs in the production environment, helping to define standards, ensure quality, and reduce overhead for the Operations Team.
  • I utilized DBeaver and PGAdmin III for creating and executing DDLs and SQL queries against the Postgresql datalake environment, and Talend for writing and testing ingestions.

Software Developer Trainee

SOFTWARE DEVELOPER/CONTRACTOR - Revature, LLC
2017.09 - 2018.01
  • I trained intensively at Revature’s coding boot camp in Tampa, FL, at their facility on the USF Campus.
  • I utilized a range of technologies, with an emphasis on Spring Boot and Microservices, as well as Java Object Relational Mapping (ORM) to build functional web applications.
  • I graduated from the three-month program and was hired on to a project by Tech Mahindra for a two-year contract in January 2018.

Education

BACHELOR OF SCIENCE - COMPUTER SCIENCE

Georgia College & State University
Milledgeville, GA
07.2017

Skills

  • Java
  • MySQL
  • DBeaver
  • Hibernate
  • RDBMS
  • HVR
  • Postgresql
  • Talend
  • Apache NiFi
  • Advana
  • GitHub
  • SQL Programming

Timeline

ETL Developer

Avance Consulting Services
2023.08 - Current

Data Pipeline Engineer

Inceed, LLC
2022.02 - 2023.01

BLADE Data Pipeline Engineer

DDC IT Services
2021.05 - 2022.02

BLADE Data Pipeline Engineer

Insight Global, LLC
2020.08 - 2021.05

ETL Developer

GE 1FLEET TEAM Via Tech Mahindra, Ltd
2019.09 - 2020.04

ETL Developer

GE 1FLEET TEAM Via Revature, LLC
2019.05 - 2019.09

ETL Developer and Squad Leader

GE DATA INGESTION TEAM Via Revature, LLC
2019.03 - 2019.05

ETL Developer

GE MSO TEAM Via Revature, LLC
2018.10 - 2019.03

ETL Developer

GE DATA INGESTION TEAM Via Revature, LLC
2018.01 - 2018.10

Software Developer Trainee

SOFTWARE DEVELOPER/CONTRACTOR - Revature, LLC
2017.09 - 2018.01

BACHELOR OF SCIENCE - COMPUTER SCIENCE

Georgia College & State University
William Burns