Timothy Compton Email & Phone Number

Lodi, California, United States

• Developed a SQL query with binned range joins to unify tens of millions of rows of data from multiple Ignition datasets into a performant Snowflake View with multiple drill through options such as 4M designation. Used Scrum tactics to deliver value early and often, creating an MVP after only weeks of development.• Frequently submit table requirements and complete SQL code to IT to publish Master Data Tables and Views in Snowflake. Perform UAT and hypercare evaluations before approving finished product.• Created a Master Data system of Tables and Views in Snowflake to transform multiple variable production schedules into a single Snowflake View with a schedule key, which can then be queried into Power BI and related to all applicable fact tables.• Cross-trained teammates so that they can support the Master Data system by submitting update requests to IT as needed.• Frequently collaborate with teammates to debug SQL code and data system issues.• Selected to represent my team at a global workshop to standardize data analysis and reporting practices. Responsible for global agreement of engineering metrics such as OEE.• Create PowerPoint decks to summarize proposals for my ideas and present them to director-level management to elicit deep conversation on challenging topics in order to drive innovation while maintaining best practices.• Work directly with director-level stakeholders to brainstorm new ideas and share my work.• Developed and use a micro-Scrum process to control the flow of small update requests from end-users to optimize a solution suite already in production. Intended to minimize distractions from my current active projects while still delivering value on a bi-weekly basis.• Currently developing a unique single visual in Power BI intended to show whether we "won or lost" for any number of machines/systems with any combination of metrics requested as the KPI for that machine.

Fresno, California, United States

• Designed, managed, and launched a group of new products which won the company an exclusive government contract to overtake 95% of sales in a regional market. Predicted to boost company sales by 8% annually. Process involved assembling a least viable product to ensure speedy market launch, followed by robust final product to ensure long-term success.• Managed integration and launch of a new product line that now accounts for 25% of the company’s category product sales, with an estimated growth to 30% in the next year• Manage 3-5 concurrent projects at any given time, each representing $50k-$1.5m in savings/revenue to company• Conduct engineering analysis and work related to projects• Collect technical data and information to share with global teams

Fresno, California, United States

• Developed an algorithm using data analysis which resulted in 75% reduction of time required to develop new products, improved product performance prediction error from 26% to 3%, and was presented to company President• Created database and custom serial numbers to categorize and store new designs and products• Observed, analyzed, and optimized various waste stream management issues in manufacturing using meticulous data collection and analysis

Modesto, California, United States

• Learned about high speed manufacturing in a fully informational part-time internship

Hanford, California

• Instigated optimization of pistachio flavoring procedure after observing inefficiencies• Reduced waste of water, flavoring, and salt by 50% using data collection and analysis• Lowered error in sodium content of final product by 20% using data collection and analysis

Postgraduate Degree, Data Science, Completed

• Created Toxicity Identifier using Python NLP and ML concepts in Jupyter Notebooks. Performed data cleaning, used TfidfVectorizer().

Bachelor Of Science (B.S.), Mechanical Engineering

Activities and Societies: Pi Tau Sigma