Randy Light Email & Phone Number

Portage, Indiana, United States

Demonstrated exceptional performance as a top performer in the master data group, ensuring accuracy, integrity, and completeness of critical data elements. Leveraged Tableau to create reports and dashboards that identified missing unpaid invoices, resulting in the recovery of over $70,000 in previously uncollected revenue. Proficiently utilized Python and SQL to extract and clean large volumes of data from diverse sources, ensuring data consistency and preparing it for analysis. Successfully integrated various systems using middleware programs like Power Automate and Workato, automating data workflows and generating significant cost savings. Exercised a meticulous approach to cleaning and validating data in reports, ensuring that the presented data accurately reflected the organization's true information. Leveraged APIs to retrieve data from web applications and write back to Snowflake and Redshift, facilitating seamless data integration and enhancing data accessibility

Portage, Indiana, United States

Portage, Indiana

Introduced and designed data visualizations in Tableau to help investigate the leading downtime causes. Consult with key engineering stakeholders to understand business requirements for parts and material needed to construct new and maintain existing production lines so process improvements and news lines of business can occur. Engage requirements effectively to suppliers to receive to overachieve the timelines of the business. Optimized 10%-15% cost savings on numerous components, and 25% savings on select components. Eliminated labor costs on several production lines by 10%-15% by using technological advancements for process improvement. Design Excel workbooks with advanced computational and VBA techniques to streamline the importation and validation of thousands of assets and preventative maintenance instruction condes from the old CMMS into the new.

Duncanville, Texas

Design structural roof and floor trusses in the truss design software to match the architect’s blueprint. Analyze floor plans and roof layouts to determine point-loads and load transfers to mitigate the use of metal beams. Optimized truss web designs to meet load and deflection requirements while maintaining a 5%-7% reduction in material overall. Determine sufficient LVL size and thickness for the specific application

Duncanville, Texas

I would receive an order for different lengths, widths, and heights of lumber products and would combine them in to the most efficient bundle as possible

Work closely with engineering to make sure BOMs accurately reflected the components that assemblers were using. Properly auditing BOMs, saving $2k-$3k a month in stainless steel fittings and eliminating countless obsolete parts. Organize parts area to minimize time spent finding customer ordered parts. Communicate any large inventory discrepancies with purchasing to ensure adequate quantities are on hand at all times.

Receiving incoming parts and supplies into inventory.

La Porte, Indiana

Overlooks OperationsCreates Marketing Materials Generates Sales Leads

La Porte, Indiana

Inspecting incoming metal castings before they go out to the customer. It is the last step before it becomes a finished product.This job included looking over parts to see if they were up to standards, using precise measuring tools and metal files.