ZACH REBSTOCK
Godley,TX
Summary
IT Professional with combined experience in software development, databases, data analysis, and system administration. Experienced in a range of industries including Health Insurance, oil/gas, Electric Delivery, Automated Metering, and IoT sensors. Certified Python Developer (PCAP), and currently hold an AWS Developer Associate certification.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Principal Data Engineer
Exelon
05.2023 - Current
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Designed and implemented effective database solutions and models to store and retrieve data.
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.
- Developed complex PySpark queries to retrieve data from multiple sources on-premise, and on ADLS.
- Migrated multiple analytical projects code repositories from on-premise PySpark to Azure Synapse, and created multiple data-testing pipelines to verify data outputs matched between on-prem and Azure.
- Collaborated with Data Scientists to provide data sets for their machine learning models.
- Developed Azure Data Factory ETL/ELT pipeline automation on Synapse Spark.
AWS Big Data Engineer
Duke Energy
06.2022 - 05.2023
- Developed ETLs for Distributed Energy Resources/Distributed Generation data sets to AWS using Python, Kafka, S3, DynamoDB.
- Used a Terraform-first approach for all AWS cloud deployments.
- Worked with proprietary data sets (Pi Data) using Python Pandas.
- Assisted Principal Engineers with Python code development for on-premise Kafka producer tasks.
- Converted on-premise Python/Pandas energy-curtailment code to AWS Lambda/DynamoDB.
- Managed Informatica/UAC ETL processes for internal government/regulatory geographic web application backend.
Data Engineer
Sentient Energy
05.2021 - 06.2022
- Automated data flow from IoT devices, MySQL and MSSQL sources to Data Analytics ingestion destinations.
- Managed Git repos for Data Science team. Automated on premise to AWS S3 data flows via bash scripts and AWS CLI.
- Developed Python data parsing scripts for ingesting IoT/DB data into destination databases (MySQL).
- Performed data cleaning on source and destination data sets using Python/SQL.
- Developed a scalable, Dockerized, multi-threaded IoT data collection ecosytem around internal Python DNP3 libraries to poll thousands of IoT devices for device data.
Senior Data Analyst
Sentient Energy
05.2021 - 02.2022
- Implemented ETL processes to facilitate data flow from customer data sources, to Data Analytics team.
- Developed multithreaded data retrieval automation in Python for Sentient Energy's flagship fault detection IoT devices.
- Automated multi-terabytes of MySQL/MSSQL data dumps from customer sites to Data Analytics teams through bash scripts.
- Assisted Data Analytics teams with MySQL database schema design.
Development Tech Lead
SmartLift
04.2020 - 05.2021
- Lead Developer for Oil/Gas Automation startup.
- Successful in bringing prototype IoT well controllers and set point automation to commerciality.
- Managed development of new and current IoT and BI technology products and platforms.
- Developed on Digi embedded IoT devices using Dynamic C.
- Reduced data loss on well head automation controls by 90% by improving existing IoT code.
- Developed on Beaglebone Black Linux controllers using Python.
- Improved Dynamic C IoT code by implementing business requirements, identifying bugs/defects and adding new features.
- Developed gas well plunger lift monitoring and gas well pressure optimization in MSSQL through stored procedures, triggers and jobs.
- Led multiple contract developers in platform development and code conversions.
- Developed test scripts in SQL for automating tests on new business logic for triggers, stored procedures and jobs.
- Developed set point optimization logic in SQL stored procedures, triggers and jobs to increase gas well production by 20% on plunger lift gas wells.
- Designed reliable database architecture using indexes, keys, constraints using SSDT T-SQL.
- Ensure SQL schema consistency between environments and databases using SSDT/Git.
Programmer Analyst
USHEALTH Group
04.2019 - 04.2020
- Developed a PDF billing invoice application in .NET that saved the company ~$1M per year in paper/mail costs.
- Used ABCPDF 10/WebSupergoo .NET API to develop PDF transformations.
- Developed and managed VB.NET/C# .NET Web applications
- Improved upon existing applications in VB .NET/C# .NET
- Worked with software QA teams to improve applications, fix bugs, and add new functionality
- Developed using Agile methodology
- Collaborated with over 30 developers, IT Pros, QA Analysts, for software improvements and new projects
- Utilized Sourcetree/Team Foundation Server for software version control
- Performed SQL development for new stored procedures, queries and CRUD scripts
- Developed on and managed legacy applications
- Responded to software bugs and issues, deploying hot fixes quickly
- Tested newly developed programs and applications to validate functionality
- Developed applications using SOLID programming methodology
- Performed SQL query tuning on poorly performing queries
- Recreated legacy apps in C# using modern development techniques (SOLID, parallel computing, asynchronous programming)
- Provided production support after software deployments with hotfixes, patches, debugging, etc.
- Lead developer for several production applications.
AMI Systems Administrator
City of Fort Worth
10.2017 - 04.2019
- Managed the Sensus FlexNet, Sensus RNI, and Harris MDMS for 250,000 smart water meters
- Supervised a team of AMI (Automated Metering Infrastructure) Data Analysts in support of the AMI infrastructure, which included performance evaluations every 6 months
- Provided data analytics extensions to the reporting capabilities of the Meter Data Management (MDMS) systems, through SQL queries, reports, stored procedures, and Python scripts
- Developed ETL automation for moving cloud-based SQL data to local databases, utilizing .NET Core, Python (pyodbc), and SSIS.
- Maintained software support contracts with AMI vendors
- Performed Meter Data Analytics in SQL for GIS, Water Conservation, Auditing, Troubleshooting, and System Performance
- Submitted design recommendations for initial AMI discovery period
- Ensured AMI infrastructure performance with scripted reports and alerts.
- Coordinated hosted system upgrades with hosting providers to ensure minimal impact on live systems
- Performed annual D/R tests with hosted providers to ensure seamless fail over and recovery of AMI servers
- Managed, designed, and created relational databases in SQL for business analytics needs
- Designed business processes for future state systems
AMI Systems Analyst
United Cooperative Services
01.2009 - 10.2017
- Managed the software-side of the Automated Metering Infrastructure (AMI)
- Performed Business Analytics on kW/kWH load forecasting and power outage analysis
- Designed a SQL to GIS (ESRI) power outage prediction database, that saved the company millions per year in power outage restoration costs
- Provided meter data plotting to mapping systems using SQL
- Coordinated pilot projects for new technology and equipment
- Automated tasks via SQL queries and scheduled jobs
- Improved guidelines and procedures to make tasks more efficient
- Assisted in the supervision of over 80,000 electrical meters, and ensured data integrity from the AMI system
- Aided in software upgrades/maintenance on Landis & Gyr Command Center in cooperation with IT departments
- Provided training and documentation to other departments on use of AMI technology
- Created billing variance reports for Commercial Metering accounts in SQL and Excel
- Designed SQL scripts and queries to provide automated metering data to other software applications (mapping, outage management, billing)
- Maintained a 98% meter reading average per day for billing standards and department benchmarks
- Assisted in completing Planning Department yearly objectives
- Assisted an Electrical Cooperative in Paillaco, Chile, with AMI Systems Management on a volunteer project with NRECA, in January 2014
Education
Bachelor of Science - Information Technology/Software Development Concentration
Southern New Hampshire University
Manchester, NH2020
Skills
- Certified AWS Developer
- Certified Python developer
- Relational Database Development/Management (MSSQL/MySQL)
- ETL development
- Git
- Systems Administration
- Linux
- AWS/Azure
- Terraform
- Regex
- Pandas
Certification
PCEP Certified Entry-Level Python Programmer
PCAP – Certified Associate in Python Programming
https://www.credly.com/badges/c8f99e6d-f27f-4ba6-8a35-45c6f89cc423/public_url
AWS Developer Associate - Expires Sep 30, 2024
https://www.credly.com/badges/9c92cd97-3c0f-4af9-8360-22468c78efbe/public_url
Timeline
Principal Data Engineer
Exelon
05.2023 - Current
AWS Big Data Engineer
Duke Energy
06.2022 - 05.2023
Data Engineer
Sentient Energy
05.2021 - 06.2022
Senior Data Analyst
Sentient Energy
05.2021 - 02.2022
Development Tech Lead
SmartLift
04.2020 - 05.2021
Programmer Analyst
USHEALTH Group
04.2019 - 04.2020
AMI Systems Administrator
City of Fort Worth
10.2017 - 04.2019
AMI Systems Analyst
United Cooperative Services
01.2009 - 10.2017
Bachelor of Science - Information Technology/Software Development Concentration
Southern New Hampshire University
PCEP Certified Entry-Level Python Programmer
PCAP – Certified Associate in Python Programming
https://www.credly.com/badges/c8f99e6d-f27f-4ba6-8a35-45c6f89cc423/public_url
AWS Developer Associate - Expires Sep 30, 2024
https://www.credly.com/badges/9c92cd97-3c0f-4af9-8360-22468c78efbe/public_url
Similar Profiles
ROSINE KAYITESIROSINE KAYITESI
Senior Project Manager at ExelonSenior Project Manager at Exelon
Mark TetkoskieMark Tetkoskie
Senior Engineering Designer/ Engineering Analyst at ExelonSenior Engineering Designer/ Engineering Analyst at Exelon
Tolulope WaynsTolulope Wayns
Project Manager at EXELONProject Manager at EXELON