- Developed and Implemented an automation process for 35 insurance carrier export files.
- Lead the testing of a retiree coverage amount reduction based on age process for top tier client.
- Structured and developed a custom SQL Monthly Headcount Comparison report.
- Managed the development process of a custom table and process for daily data loads of system activity.
- Lead the implementation of the Plex ERP system in seven facilities in the United States and two international facilities.
- Manage role based security within the Plex ERP System and the Prophix Financial Consolidation system.
- Developed a change control process for application development and new enhancements to the various departmental systems.
- Transitioned manual reporting requirements into a fully automated process from SQL server.
- Coordinated with various business units to define new project requirements and develop project charters and timeline documentation for each project.
- Implemented a full barcoding solution for multiple warehouse locations for inventory control.
- Developed a monthly application development summary for upper management.
- Integrated an online Transportation Management system with our ERP.
- Developed application policies and procedures for process champions in various departments.
- Evaluated and implemented a MDM solution for our mobile workforce.
- Participated in weekly review of user support requests with 3rd party vendor to assure all policies and procedures were being followed accordingly.
- Developed a RFQ workflow to allow the Sales and Engineering departments to communicate more efficiently when new business opportunities became available from existing or new customers.
- Developed and maintained a number of automate business processes within the Cognos suite for our Budgeting and Rolling Forecast cycles.
- Coordinated the rollout of an upgraded Citrix environment for our 7 production facilities with our end users and our outsourced IT provider.
- Managed various consultants for specific projects during a transition of our BI developer going into retirement.
- Participated in the rollout of Sage Sales Logix CRM for our Sales, Marketing and Engineering department replacing a manual Excel based methodology.
- Elected as an Extended Core Team Member for the rollout and implementation of Plex Online ERP System to replace our current AS400 Mainframe system which is currently supported by our prior parent company.
- Participated in the rollout of a new financial consolidation package in coordination with our new ERP.
- Created and maintained a number of online workflows to move towards a paperless environment and have better controls over company policies.
- Administrator over security for all local Intranet users.
- Created a process flow to allow the tracking of new projects developed in the company and to gain all the proper approvals.
- Structured a document management process for the Sales and Marketing group.
- Administrated the Infor 7i application for the Purchasing and Maintenance groups to create purchase orders, maintain stock inventories, and schedule work orders.
- Created Cognos Models and generate processes to allow data to be transferred between models during Month End closing, a Rolling Forecast cycle or the Annual Plan. Developed packages and reports based on the above data in Cognos Report Net for end users.
- Coordinated meetings and timetables with support group in rolling out new version of our Citrix environment to utilize improved processing tools and capacity constraints.
SKILLS Shopfloor Online, Plex Online, Sales Logix, Prophix, Citrix