Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
32
32
years of professional experience
Work History
BOM SPECIALIST
Created Bills of Material for Production and Engineering used to manufacture product for customer with a 24-hour turn-around time using a system of Excel Spreadsheets which would accommodate the unending array of production combinations
Administered the Oracle system of over 10,000 skus including the creation of new purchase parts and outside processing parts
My duties included but weren’t limited to modifying nomenclature, lead times and component parameters which affected costing features
Facilitated the ECO program which made changes to the BOMs including Mass Changes, PIPO and New Part Creation
Worked closely with multiple departments to coordinate the creation of new parts as well as resolving challenges that were related to BOMs and ECOs
Have high level of knowledge of ORCY, Agile and Microsoft Programs.
staff accountant
Performed month-end, quarter-end and year-end closing activities including general journal entries and reconciling of cash, AR and sales accounts
Worked with other companies under the Acuity umbrella to stock product and to bring in the needed components to construct a comprehensive daylighting system for our customers
Provide ad-hoc analysis and report on inventory valuations
Determine root causes and establish counter-measures to help improve accuracy and value of the inventory
Prepared the data and forms for the quarterly sales tax returns
Responsible for preparation and posting of daily bank deposits
Participated in special projects as needed.
customer support
Sunoptics skylights / AES Industries
12.2022 - 09.2023
Provide pricing to our customers based on different levels of pricing with same-day turnaround time
Created Bills of Material for Production and Engineering used to manufacture product for customer with a 24-hour turn-around time using a system of Excel Spreadsheets which would accommodate the unending array of production combinations
Answer customer service line and assist customers as needed including product specification and pricing.
product support
Sunoptics skylights / acuity brands Company
01.2009 - 01.2022
Created pricing program utilizing Oracle and Bill of Materials Spreadsheet to update the current pricing within the system based on current costs
Worked in Product Data Management to establish new items and their key components
Quoted out customized product utilizing a system of spreadsheets created by myself incorporating current cost from the system
Red-lined and updated Product Specification Sheets to incorporate current information including drawings
Lead Data Entry Team at annual physical inventory and analyzed inventory discrepancies.
DATA ANALYST
Simpson Strong Tie Co. / Simpson Manufacturing
01.1992 - 01.2008
Prepared monthly sales analysis for the Vice President based on numerous factors including by region, by country, by product and by sales dollars
Worked with other branches to transfer inventory and components to and from the facility
Developed 12 month sales forecast for Strong-Wall products
Analysis included factors such as past and present sales, seasonal periods, market conditions and other outside stimuli
Created and monitored Capital Expenditures for heavy machinery in the construction of new facility Stockton
Worked on Capital Improvement Projects for Manteca Facility
As lead auditor, planned and managed Sarbanes Oxley internal audits at facilities in the Western U.S
Procured raw materials and finished goods necessary for manufacturing production while working with overseas suppliers
Participated in Sarbanes Oxley as lead auditor in internal audits and quarterly inventories
Prepared payroll and administered personnel records for over 300 employees