ACCOUNTING• AR transactions had increased exponentially. A method was needed to handle up to 10’s of 1,000’s of invoices on any one remittance. Wrote a program using customer’s remittance data, data from the ERP system, and Excel to automate the process. The job became a 20-30 hour per week job.• Created a program to properly allocate the 2018 tariffs. The outcome was a GAAP compliant process similar to a FIFO layering system.CUSTOMER SERVICE• Chose EDI communications software -… Show more ACCOUNTING• AR transactions had increased exponentially. A method was needed to handle up to 10’s of 1,000’s of invoices on any one remittance. Wrote a program using customer’s remittance data, data from the ERP system, and Excel to automate the process. The job became a 20-30 hour per week job.• Created a program to properly allocate the 2018 tariffs. The outcome was a GAAP compliant process similar to a FIFO layering system.CUSTOMER SERVICE• Chose EDI communications software - set up all customer connections. Automated order entry for thousands of daily orders.• Wrote EDI translations to integrate with the ERP system.• Wrote a program to handle non-EDI customers - data from customer portals was imported to the ERP system automatically populating it with new ordersWAREHOUSING• Designed a process and wrote a program to create efficiencies in the warehouse. Mistakes such as pulling wrong SKU’s were eliminated.• The program integrated with the ERP system, FedEx and UPS machines. Eliminated manual entry into those systems and manual closing of orders in the ERP systemPURCHASING• Wrote a program to manage and report on the status of 500 in process shipping containers.• The tool put all of the data in one place accessible to all EE’s with real time data and reporting.PE CO• Created program to manage a large portfolio within a complex structure of entities, holdings, and ownership.• Integrated what was a disparate, unwieldy assortment of spreadsheets and databases into a cohesive system to manage the business.COST ACCT• Created a system for a pharmaceutical manufacturer to log lab, QA, and manufacturing time by job. Enabled a better understanding of costs, improved management of WIP and COGs.PROJECT MANAGEMENT• Worked with PM’s to create a system whereby each department was held accountable to achieve milestones within a prescribed time.• The database helped improve the average turn-around time for deliverables from 3 months to 1 month. Show less