Joseph Cerezo
Data Engineer @PACCAR
Signup · Get unlimited contacts
WORK HISTORY
Data Engineer @PACCAR
WA, US
Achievements: Designed and implemented data pipeline utilizing Linux Servers, AWS S3, Snowflake and Tableau. Leveraged automation with Python boto3 scripts and Lamda functions. Monitored and tracked performance and costs using Cloudwatch, and Snowflake information schema queries visualized with Tableau. Transformed.mat files into OLAP database design for analytics.Developed Data Pipeline Error dashboard for debugging.Discovered/analyzed and utilized existing data to augment Fleet management system via API integration. My integration was at zero-cost to the company (the data existed) but created tremendous business value (No longer considered costly Third Party solutions).Collaborated with numerous parties to remove bottlenecks in our primary data stream reducing delayed files from 3 days to less than 7 hours-Developed solutions to integrate data from an IBM Mainframe from the 1980s into modern technology stacks. One solution utilized optical character recognition but we ultimately went with an ActiveX integration into a MatLAB program for our purposes-Selected to compare and setup entire Data Logging Systems from configuration files, transporting off the fleet using UMTS transport configurations, to Post Processing-Development and maintenance of software solutions that support processes for data analysis, software release, software configuration management, hardware-in-the-loop simulation and rapid controls prototyping activities-One of 11 people out of 600 to be selected for Six Sigma Green Belt for Design and Operations training. Learned how to conduct statistical analysis with MiniTab to incorporate in continuous improvement. Currently completing first Green Belt Project projected to save~$2.5M within a year-Migrated data using Oracle SQL Developer to Snowflake-Capture user stories/requirements, writing both functional and test code, automating build and deployment, and/or performing unit integration, and end-to-end testing of software solutions.
EDUCATION
Naval Reactors
Nuclear Engineer
United States Naval Academy
Bachelor of Science (B.S.)
Rensselaer Polytechnic Institute - The Lally School of Management and Technology
M.S. Degree
Naval Reactors
Masters Level Education
ABOUT JOSEPH CEREZO
I am an engineering leader with 15+ years of experience managing nuclear propulsion…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.