Courtney Merewether
Henrico, VA 23294
Mobile: 804-***-****
Email: *******@*****.***
Professional Experience
Performance Fibers, Inc. March 2006 – Present
IT Asset & Budget Administrator
* Procurement and management of IT Assets utilizing eCommerce tools, SharePoint, and Symantec Asset Management Suite.
* Development and administration of policies, procedures and processes for IT Asset Administration.
* Ensure accuracy and payment of monthly invoices for IT assets and services.
* Development of weekly IT cash forecast, monthly IT forecast and annual IT budget for 7 IT cost centers.
* Prepare monthly financial analysis for forecast versus actual spend for 7 IT cost centers.
* Prepare annual year over year budget analysis for 7 IT cost centers.
* Report on financial status of IT assets and services to IT management.
* Utilization of SAP, Access, and Excel to create and deliver financial reporting.
* Liaison and focal point for PF employees and vendors for equipment, software and services.
* Maintain contracts for IT support, maintenance, licenses and services.
* Work closely with other IT staff, Finance, Tax, Accounts Payable and Procurement departments.
* With guidance from the Senior Sourcing Leader, worked through the RFP process for global telecommunications services – sent out RFP’s to select vendors, evaluated bids, negotiated pricing and services, awarded bid and worked through contract details; resulted in $18K savings from previous contract.
* Analysis of options for Microsoft Enterprise Agreement, negotiated pricing for selected option resulting in total savings of $75K for the 3 year agreement.
* Participated in acquisition activities of four new facilities including transferring services and obtaining services for telecommunications, setting up leasing for computer equipment.
* Applications / systems used: SAP R/3, MS Access, MS Excel, MS Word, MS PowerPoint, MS Outlook, MS SharePoint, Cisco WebEx Connect, Symantec ServiceDesk, Symantec Asset Management Suite, eCommerce tools, Adobe Pro, Internet Explorer, Verizon e-meetings, AT&T Teleconference, SpiceWorks.
Performance Fibers, Inc. December 2004-March 2006
Business Intelligence Analyst
Performance Fibers division of Honeywell International acquired by Sun Capital Partners and renamed Performance Fibers, Inc. in December 2004.
* Supported Richmond office employees for hardware/software issues and installation.
* Trained a coworker in the development and maintenance of BIW queries and reporting.
* SAP BIW Point of Contact for issues, reporting requirements and development, training, new logon accounts, password resets, etc.
* Participated in SAP project to incorporate newly acquired plants in Alabama into BIW reporting.
* Participated in a Lean Sigma event to redesign the Demand Forecasting and Production Planning processes.
* Provided SAP BIW training for users, including: Navigating Business Explorer (BEx) Analyzer, running reports, report functionality, drill down and across, calculations, filtering, saving, etc.
* Participated in the development and implementation of SAP Business Information Warehouse (BIW), which also included data validation and ensuring reporting was functional on a global basis.
* Continued development of BIW to maintain and enhance existing queries, add data, create new queries, etc.
* BIW Functional Lead for the SAP Project in migrating off Honeywell’s SAP system
* Participated in several activities surrounding the divestiture of the Performance Fibers business
* Applications / systems used: SAP R/3, SAP BW, MS Access, MS Excel, MS Word, MS PowerPoint, MS Outlook, Symantec ServiceDesk, eCommerce tools, Adobe Reader, Internet Explorer, Verizon e-meetings, AT&T Teleconference.
Honeywell International June 2001 – December 2004
Database Administrator, Information Management / Performance Products
* Provided various sales, inventory and finance reports for Sales Team, Product Managers, Marketing Managers, Production Managers, Customer Service Representatives, Finance Managers, and Business Analysts.
* Utilized Cognos Impromptu, SAP, Microsoft Access, and Microsoft Excel for extracting data, running queries, creating tables, manipulation, enhancement, and automation of data for various daily, weekly, monthly, quarterly, and ad hoc reports.
* Participated in the development and data verification of the Chemical Industries Data Warehouse (CIDW), which fed the Cognos applications.
* Designed, built and implemented a database for a new manufacturing process, which ultimately eliminated various other processes and databases.
* Developed and maintained numerous Access databases that supported data analysis and reporting for a number of manufacturing process lines.
* Assisted in the planning, testing, and version upgrade of 19 Access databases from 2.0 to 2000.
* Applications / systems used: SAP R/3, Cognos Impromptu and PowerPlay, MS Access, MS Excel, MS Word, MS PowerPoint, MS Outlook, Symantec ServiceDesk, eCommerce tools, Adobe Reader, Internet Explorer, Net Meeting, AT&T Teleconference
Experience - Other
Honeywell International, Colonial Heights, VA, December 2000 – May 2001
VCU Co-Op Student: Assistant to Database Administrator / Performance Fibers – Inventory & Operations Planning – Sales and inventory reporting utilizing SAP, Access, and Excel
Chesterfield County Public Schools, November 1999 – November 2000
Co-op Student: Assistant to DBA / Office of Accountability – Utilized Oracle SQL and PL/SQL to query information from student databases, provided reporting to school board staff and school faculty
Yellow Jacket Security, Inc., Richmond, VA, March 2010-Present
Logo creation and artwork, Creation of accounting documents, Administrative tasks including review and update of legal documents and web page information
Gear Inspection Services, Inc., Richmond, VA, August 2005-March 2010
Database and report writing management
NeighborCare Pharmacy, Richmond, VA, August 1995-November 1999 - Pharmacy / Computer Technician
Ricketts Drug Store, Orange, VA, June 1989-August 1995 - Pharmacy / Computer Technician
Education
Virginia Commonwealth University
* Bachelor of Science in Management Information Systems, May 2001
* Overall GPA: 3.23 / Major GPA: 3.31
Continuing Education / Professional Training
* Fred Pryor Seminars, Writing Clear & Concise Policies & Procedures, October 2007
* SAP BW Training: SAP Component Extraction (BW350), June 2005
* SAP BW Training: Data Staging (BW340), May 2005
* SAP BW Training: Data Warehousing (BW310) & Reporting & Analysis (BW305), April 2005
* D&KM (Data & Knowledge Management) Training, August 2003
* SMART (Specialty Materials Analysis & Reporting Tool) Training, June 2003
* Design For Six Sigma (DFSS) Training, June 2003
* OLAP Modeling and Cognos Impromptu Advanced Reporting, January 2002
* Six Sigma Growth GreenBelt Training, November 2001 and December 2001
* Cognos Impromptu Report Building and Cognos PowerPlay Exploration & Reporter, January 2001