OBJECTIVE:

• To use my manufacturing background and 20+ years experience, in an business intelligence analyst position to streamline business processes and give a North Carolina manufacturer better insights into their business.
• Strong problem solving abilities. Excellent oral, written, and interpersonal communication skills. Able to interface with all levels of management. Broad knowledge of MRP practices and manufacturing principals as well as general accounting practices.

TECHNICAL SKILLS:

Software: SQL, SSRS, Tableau, Infor Cloud Suite Industrial (Syteline ERP), Microsoft Exchange, Microsoft Access VBA, Microsoft Excel VBA, Microsoft Word VBA, Microsoft SharePoint, Microsoft Project, Fourth Shift ERP, VMware ESXi, Avamar

PROFESSIONAL EXPERIENCE

IT Manager

Confidential

Responsibilities:

• Solely responsible for IT support of 60+ employees in a manufacturing environment. Installed, configured and maintain vCenter and VMware servers with high availability vMotion. Maintain the operating systems for 30+ virtual servers, 11 physical servers as well as various desktops and laptops. Installed, configured and maintain Sonicwall firewall with integrated WiFi allowing corporate and guest access. Maintain EMC Avamar backup solution, EMC VNX NAS, Shoretel phone system, on premise Exchange server
• Sharepoint Foundation server and KeyScan building access control system. Upgraded and administer Syteline ERP to version 8.03.11 in a multi - site, multi-currency environment including the development of custom forms, event handlers, workflows, SSRS reports and UPS integration. Automated shipment notification emails, order acknowledgment emails and numerous reports and data extracts. Developed custom manufacturing execution system (shop floor data collection) programs which directly feed Syteline ERP
• Integrated a pick-to-light assembly program with Syteline ERP. Created an Microsoft Access database to enable users to manage End of Life products and the value of inventory for all related components and parent items.
• Created an Microsoft Access database to aid in BOM cleanup and cost roll processing. Created an Microsoft Access database to produce formatted price lists which include photos, accessories and a BOM list of package contents.

Process Control Manager

Confidential

Responsibilities:

• Developed custom Microsoft Access databases with switchboards to allow users to query the ERP system and run reports to supplement standard ERP reports for all functional areas. Developed processes to clean ERP master data nightly.
• Installed and customized FrontStep CRM to give outside sales team access to customer data, inventory details, and other KPIs using Crystal Reports. Added user defined fields and wrote custom triggers in Progress to customize Syteline 6.
• Created Microsoft Access databases to analyze general ledger accounts to facilitate the budgeting process. Installed and configured Cognos Business Intelligence for Syteline including the creation of several custom cubes.
• Responsible for maintaining ISO 9000 documentation, conducting internal ISO audits and coordination of compliance audits.

ERP Consultant

Confidential

Responsibilities:

• Consultant for Syteline 5 ERP implementation. Performed data extraction, transformation and conversion to facilitate imports into Syteline from prior ERP system.

MIS Specialist

Confidential

Responsibilities:

• Responsible for writing programs in MS Access and Crystal Reports that translate and convert ERP data into meaningful business management reports. Developed MS Access applications using macros, SQL and VBA to streamline manufacturing scrap reporting, physical inventories, and RMA processing.
• Developed pricing program for assembled to order products. Implemented and administered Fourth Shift ERP. Automated the nightly ERP process. Automated processes to import data into and export data from Fourth Shift ERP. Solely responsible for network and system administration of LAN, WAN, 4 servers, 70+ PC users and miscellaneous peripherals at 2 manufacturing sites. Installed, configured and administered Windows NT servers, Citrix servers, Lotus Notes, and Windows desktops and laptops. Responsible for all telecommunications, including
• T1, frame relay, and other dedicated voice and data lines. Routinely performed moves, adds and changes on Nortel Meridian Option 11 switch and Meridian Mail voice mail, including ACD and automated attendant configuration.

PC Specialist

Confidential

Responsibilities:

• Liaison between management and MIS staff for all information system projects. Selected, installed, and implemented a PC based time and attendance package. Solely responsible for all software and hardware installation, configuration, and help desk tasks.
• Maintained 80+ PC's, 25+ printers, and other miscellaneous peripherals. Developed special application macros using MS Word and Excel. Developed quote-tracking database in Paradox for Windows, and job tracking database in dBase IV.

Sr. Industrial Engineer

Confidential

Responsibilities:

• Supervised process writer. Responsible for the routing maintenance for sheet metal fabrication, robotic welding, and CNC milling, turning and chemical blending operations.
• Worked with both plant supervisors to increase shop floor efficiency. Integrated manufacturing of an acquired business into our existing manufacturing facility, including the installation of an automated stock room carousel.
• Coordinated, developed and maintained tracking of all correspondence for a product recall. Coordinated ergonomic office layout/renovation project.

Systems Engineer

Confidential

Responsibilities:

• Developed information tracking system in dBase III. Revised and composed technical manuals into a digital format. Produced brochures, in Ventura Publisher. Wrote technical manuals for optical alignment of antenna systems for 688 class submarines. Performed engineering analysis.