David Hewitt

Experience

• 

  Pace American Trailers

  Jan 1998 - Jan 1999

  Parts/Service Dept. Mgr

  · Oversaw Part Sales department including all record keeping and shipment logistics. · Managed Service department including work scheduling and invoicing.

• 

  Haulmark Industries of AZ

  Jan 1999 - Jan 2004

  Purchasing Manager/IT

  · Responsible for ordering the raw and processed materials for this Cargo Trailer manufacturing plant. This included materials with lead times from a couple days to as long as 8 weeks. I also had to maintain accurate on hand stock levels and usage forecast in order to keep inventory low while fulfilling plant needs. · Performed Disaster Recovery in 2002. A power cross short from 220 volt line to office ground caused loss of almost all connected equipment including most of the workstations. I was able to assess the situation and setup a functional system within 2 ½ hours. Because of my actions there were no noticeable interruptions of Plant business processes. · Consolidated employee information from disparate spreadsheets into a secure database, providing easy data entry and dependable, accessible reports. · Created Piece-rate Payroll spreadsheet that combined a multitude of factors essential to the correct calculation of production pay. This system condensed a manual system that required four to six hours of time each week into less than an hour. · Produced a complete set of CAD prints and templates that allowed the sales and production departments to avoid miscommunication and the expensive errors of incorrectly built product. Show less

• 

  PetSmart

  Feb 2005 - Apr 2015

  • Responsible for building, deploying and maintaining all JDA Space Automation tool scripts which enable efficiency and data quality for JDA Space Planning and Floor Planning execution• Develops and executes test scripts for new/ upgraded systems (i.e. JDA, SAP Pricing, EMS)• Researches, analyzes, defines, and documents system requirements/functionality to support Merchandising objectives• Supports business users by building audits, layouts, reports and highlights within JDA Space Planning and Floor Planning software• Analyzes data in the promotion management system to ensure data integrity between critical systems to support in-store promotional activity Show less · Created and maintained a series of Floorplan tools that has increased the efficiency of our department. Some of these tools included a Floorplan Audit highlight that checked for nine different error conditions. Additional highlights displayed traffic flow, merchandise departments, planner dates, and duplicate planograms. Created several Data Manager reports that allowed us to organize specific information in order to fulfill business needs. An example of this would be the Floorplan Audit report that checked all floorplans for a series of errors. · Maintained and improved a series of schedules that controlled a succession of tasks necessary for the smooth completion of new and remodel stores. · Worked with Vendors and Store managers to resolve issues in a quick and efficient manor. Show less · Created a SAP Job Documentation spreadsheet that used hyperlinks for quick and easy access to all available documentation for jobs that Operations monitors. · Creation and update of both online and hard copy job schedules. · Creating Access database in order to improve metric data entry, storage, and analysis. · Wrote PingSmart, a VB program that automated IP pinging to store equipment. This program was in use by individuals in three SSG departments. · Responsible for activation and monitoring of SAP, AS400, and Unix processing jobs. Show less

  • Business System Analyst

    Feb 2012 - Apr 2015

  • System Support Specialist

    May 2009 - Feb 2012

  • Presentation Support Specialist

    Feb 2006 - May 2009

  • Computer Operator

    Feb 2005 - Feb 2006
• 

  IDR, Inc.

  Jun 2015 - Dec 2015

  System Analyst

  • Responsible for Intactix support and SmartSpace installation including configuration, integration to existing systems, testing, and documentation.• Created custom Access Database as bridge tool. This tool imported multiple spreadsheets and used complex algorithms to provide data audit between separate software systems.• Wrote custom SQL reports to support new software system.• Designed and performed unit testing for all new software elements.

• 

  Discount Tire

  Mar 2016 - May 2021

  Real Estate Information System Analyst

  Responsible for maintenance, improvements, documentation, and general support of Tririga software. Familiar with SQL and Tririga Data Query tool. Experienced with the following Tririga elements: Business Objects, Associations, Queries/Reports, State Transitions, Workflows, Forms, Navigation Builder, Document Manager, Object Migration, and the Administrator Console. Created and maintains BIRT reports for Tririga including contract form, Income Lease invoice, and data validation audit reports.