Scott Mapes Email and Phone Number

2012 – current IT Administrator Lone Star Circuits 2010 – 2012 ERP Analyst Global Innovation Corp Primary Duties: Administration of Computer Data Center (Servers, switches, peripheral devices). Acquisition and implementation of hardware (to capitalize on recent technologies and accommodate escalating data storage needs). Maintain all Desktop PC’s, peripherals, and other network–connected devices (both S/W & H/W). Administrate ERP system. Administrate Active Directory. Hardware and software maintenance. Data extraction and report creation activities.Major accomplishments: • Updated aging PC and File Server infrastructure and external telephone and data transmission connections. Results:higher reliability, increased thruput, and more efficient use of existing resources.2010 – 2012 Global Innovation CorpPRODUCTION CONTROL ANALYST / ERP Primary Duties: Analysis of Production Requirements vs. available resources, creation and implementation of methods and procedures that capitalize on capabilities of ERP system. Implementation, customization and daily administration of specialized ERP software system. • Identify and integrate Business functions into ERP software workflow and procedures. • Creation of automated Business Intelligence reports and procedures.• Create system-generated reports and procedures that replace existing manually generated reports.(EX: Daily Manufacturing Status, Status Alert report, “Hot List” report)• Train departments & individual personnel to maximize operational efficiency by using ERP Software capabilities.• Extract historical data and create related Business reports. (EX: Shipments, Bookings, Product Performance, Yields)Major accomplishments: • Recreated existing manual reports to use automated reporting features of existing ERP system. • Substantially increased manufacturing visibilities as a result of additional reports and procedures.

Increased usage of Support Issues system from zero to 16 domestic and 2 International clients. Created written documentation detailing the processing and procedures necessary to create critical reports.Train local and remote staff on extraction of system data and subsequent processing using readily available reporting and presentation tools, enabling personnel to instantly respond to customer requirements, (without requiring assistance from the Corporate IT function).Only non-IT staff member allowed access to the Corporate Database.Duties: Manage Support Issues function (web-based). Determined necessary actions and orchestrated IT, Finance, Payroll, Project Managers and other functional groups towards issue resolution and achievement of 100% Customer Satisfaction. Perform data extraction from corporate SQL Server database, create and document custom reports using SQL server, M/S Excel and other tools Design, create and issue daily, weekly, and monthly reports to Executive and District Management teams. Create documentation detailing the creation and content of scheduled reports.Conduct Internet and on-site training of Remote office personnel in: Techniques for data extractionCreation of reports and presentations using available reporting and presentation S/W toolsTeam member that performed pre-release QA testing and functionality review of system changes.

> Managed Support Issues function (web-based user interface). Determined necessary actions, then orchestrated IT, Finance, Payroll, Project Managers and other functional groups towards efforts necessary to resolve inquiry and achieve 100% Customer Satisfaction.> Perform data extraction from 40 GB SQL Server database (appx 1,200 tables), create and document custom reports using SQL server, M/S Excel and other tools.> Using various Microsoft products, design, create and issue daily, weekly, and monthly reports revealing various business performance aspects (EX: Revenue, Product Mix, SLA compliance). > Create documentation detailing the creation and content of scheduled reports.> Conduct Internet and on-site training of Remote office personnel in how to effectively extract data, then process that information using reporting and presentation tools to create a desired finished product.> Perform pre-release QA testing and functionality review of system changes.

 Managed all aspects of a 100+ W/S network, including S/W & H/W selection, purchasing and installation, premise cabling, security arrangements, backup, disaster recovery, and traffic analysis. Selected the equipment and performed necessary admin functions for 80+ extension PBX and Voice Mail systems. Included LD carrier analysis & selection and system programming. Implementation & maintenance of networking arrangements facilitating shared Voice & Data communication between several remote locations . Additional activities included equipment selection, selection & admin. of paging units (appx 40) and selection & admin. of cellular communications equipment & contracts. Migrated multi-server S/W & H/W environment from Novell 3.X to Windows NT