Hector Gonzalez-Barron
Peoria,IL
Summary
Results-oriented Software Engineer (Data Science) with a Master's degree and Industrial Engineering foundation. Proven ability to build and deploy full-stack data solutions, from data extraction and warehousing to advanced analytics and visualization. Successfully architected and implemented Snowflake infrastructure, optimizing data ingestion and warehousing for a manufacturing plant. Expertise in Python, Django, Angular, and data engineering tools (Selenium, Prefect) to deliver impactful insights and drive business value.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Data Analytics Engineer
Caterpillar
Pontiac, IL
01.2021 - Current
- Developed web application using Django and Angular frameworks
- Developed data pipelines using Python (Selenium) to extract data from legacy web applications for analysis and data migration
- Analyzed complex datasets using Power BI dataflows and DAX to identify trends and solve problems
- As a Database Administrator, I established the Snowflake database infrastructure for the factory
- Collaborating with cross-functional teams, I designed and implemented data ingestion pipelines using Prefect for orchestration
- Skilled in SQL and Python, I developed ETL processes to populate data warehouses and marts
- I actively contribute to a larger initiative involving large-scale data management and manipulation within the Snowflake ecosystem, working alongside other database teams to optimize data architectures.
Senior Industrial Engineer
Neeltran Inc
New Milford, CT
01.2018 - 01.2021
- Implemented data mining for production process using Python
- Design and improve tooling and fixtures, redesigned and executed factory layout, improving existing processes
- Oversaw team of 3 quality inspectors and 2 engineers.
Factory Leader
General Electric Prolec
Monterrey, MX
01.2017 - 01.2018
- Establishing metrics and administrative controls for quality and production
- Establishing tracking of line down time and implementing corrective actions
- Developing process changes to reduce cycle time
- Establishing supervisors' daily routines
- Team: 100 assemblers, 6 supervisors, and 4 instructors.
Quality Supervisor IV
Caterpillar
Monterrey, MX
01.2015 - 01.2017
- Scope: QA & QC, Incoming/In-process/Pre-Delivery Inspection, Quality System, Customer Service
- Develop ETL / Data warehousing for Production Scheduling in MS Access & SQL
- Led team of 14 QEs, 3 Q
- Area Supervisors, and 40 inspectors
- Tasks: Design roles, determine headcount, recruit, define inspection plans, maintain quality level, responsible for QA/QC and CAPA system
- Led definition of inspection plans based on process capacity to assure inspection efficiency and maintain quality level
- Responsible for quality system, APQP (PPAPs, FMEA, MSA, etc.), and corrective actions system.
Quality Leader
General Electric Prolec
Monterrey, MX
01.2012 - 01.2015
- Led a cross-functional team to diagnose and perform root cause analysis of transformer failures
- Managed the corrective action system for improvement by validating the analysis and implementation
- Supported field services and oversaw a team of four quality engineers and 12 inspectors.
Quality Leader
Frisa Forgings
Monterrey, MX
01.2012 - 01.2015
- Analysis of large amount of process data, worked with IT to extract large volumes of data using SQL queries for analysis by writing the SQL queries
- Improved a complex quality system by implementing a cross-functional team to analyze problems and prioritize limited resources
- Proposed and obtained approval to redefine cross-functional team goals for increased collaboration
- Implemented an accountability system to improve quality assurance inspection capability
- Achieved a 50% reduction in nonconformance requests and rejected parts, equivalent to USD 360K yearly.
Operations Management Leadership Program
Mexico - Colombia
01.2007 - 01.2009
- Completed four semester projects in diverse roles
- Project (4) - Reduced welding lead time by 30% with Lean Manufacturing
- Project (3) - Reduced finished product inventory requirement by 40%
- Project (2) - Achieved USD$300K annual savings in transportation cost
- Develop Call Center Application with SQL and VBA
- Project (1) - Reduced customer complaints by 27% through risk evaluation and process controls in shipping preparation for power transformers.
Education
Data Analytics -
Bradley University
01.2025
M.S. Software Engineering + Data Science - Emphasis in Data Science and Data Analytics
Fairfield University
01.2022
B.S. Industrial And Systems Engineering - Emphasis in Quality and Statistics
Universidad de Monterrey
01.2002
Software Development Fundamentals -
University of Pennsylvania (PennX)- EDX
Data Structures and Software Design -
Bradley University
Python II -
Bradley University
Skills
- Python Programming
- Data and Analytics
- BI dashboards
- Data Warehousing
- Data Acquisition
- Data Mining
- Business Analysis
- Advanced computer programming
- Testing and debugging
- Database Management
- Front-End Development
- Web applications
- Data extraction
- API Development
- Process Automation
- Time-series analysis
- Computational design
- Database Maintenance
Languages
- Python
- Angular
- Django
- SQL
- Java
- PowerBi
- PowerApps
References
- Robert Patterson, 815-579-9107, robert.patterson@farmteamllc.com
- Prabakar Mathiyalagan, 630-819-9054, mprabakar@gmail.com
Certification
- Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
- Intermediate Python Certificate
- Software Development Fundamentals
- Data Structures and Software Design
Languages
English
Full Professional
Spanish
Native/ Bilingual
Timeline
Data Analytics Engineer
Caterpillar
01.2021 - Current
Senior Industrial Engineer
Neeltran Inc
01.2018 - 01.2021
Factory Leader
General Electric Prolec
01.2017 - 01.2018
Quality Supervisor IV
Caterpillar
01.2015 - 01.2017
Quality Leader
General Electric Prolec
01.2012 - 01.2015
Quality Leader
Frisa Forgings
01.2012 - 01.2015
Operations Management Leadership Program
Mexico - Colombia
01.2007 - 01.2009
Data Analytics -
Bradley University
M.S. Software Engineering + Data Science - Emphasis in Data Science and Data Analytics
Fairfield University
B.S. Industrial And Systems Engineering - Emphasis in Quality and Statistics
Universidad de Monterrey
Software Development Fundamentals -
University of Pennsylvania (PennX)- EDX
Data Structures and Software Design -
Bradley University
Python II -
Bradley University
Similar Profiles
Gloria PuckettGloria Puckett
Machine Operator at CaterpillarMachine Operator at Caterpillar
Rebecca DezitoRebecca Dezito
Warehouse Associate at CaterpillarWarehouse Associate at Caterpillar
Lewis CorfieldLewis Corfield
Fabricator welder at CaterpillarFabricator welder at Caterpillar
Suraj PSuraj P
CRM Order Specialist at CaterpillarCRM Order Specialist at Caterpillar
John GayJohn Gay
Sales & Delivery at ABarr SimpsonSales & Delivery at ABarr Simpson