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
08.2023 - 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
02.2022 - 01.2023
- 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
05.2021 - 02.2022
- 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
08.2020 - 05.2021
- 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
09.2019 - 04.2020
- 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
05.2019 - 09.2019
- 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
03.2019 - 05.2019
- 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
10.2018 - 03.2019
- 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
01.2018 - 10.2018
- 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
09.2017 - 01.2018
- 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, GA07.2017
Skills
- Java
- MySQL
- DBeaver
- Hibernate
- RDBMS
- HVR
- Postgresql
- Talend
- Apache NiFi
- Advana
- GitHub
- SQL Programming
Timeline
ETL Developer
Avance Consulting Services
08.2023 - Current
Data Pipeline Engineer
Inceed, LLC
02.2022 - 01.2023
BLADE Data Pipeline Engineer
DDC IT Services
05.2021 - 02.2022
BLADE Data Pipeline Engineer
Insight Global, LLC
08.2020 - 05.2021
ETL Developer
GE 1FLEET TEAM Via Tech Mahindra, Ltd
09.2019 - 04.2020
ETL Developer
GE 1FLEET TEAM Via Revature, LLC
05.2019 - 09.2019
ETL Developer and Squad Leader
GE DATA INGESTION TEAM Via Revature, LLC
03.2019 - 05.2019
ETL Developer
GE MSO TEAM Via Revature, LLC
10.2018 - 03.2019
ETL Developer
GE DATA INGESTION TEAM Via Revature, LLC
01.2018 - 10.2018
Software Developer Trainee
SOFTWARE DEVELOPER/CONTRACTOR - Revature, LLC
09.2017 - 01.2018
BACHELOR OF SCIENCE - COMPUTER SCIENCE
Georgia College & State University
Similar Profiles
Zoha MastoorZoha Mastoor
Assistant Team Lead at Avance Consulting ServicesAssistant Team Lead at Avance Consulting Services
Salwa SamreenSalwa Samreen
Full Desk Business Development Manager at Avance Consulting ServicesFull Desk Business Development Manager at Avance Consulting Services
MOHAMMED AVEZ SIDDIQEMOHAMMED AVEZ SIDDIQE
Executive Leadership at Avance-Consulting ServicesExecutive Leadership at Avance-Consulting Services