Brenda W. Spence
Hendersonville, TN 37075
Phone: 615-***-**** Email: firstname.lastname@example.org
I am a professional with a diverse base of experience ranging from technical expertise to managing office operations. I have a great background in project leadership, web design and procedure development. I am also a creative person with the ability to work across multiple disciplines, build collaborative relationships, improve processes and execute strategic direction. I am a “results driven” leader with a commitment to customer service and implementing operating efficiencies.
Software Applications (Autosys, Stratix, SAP, Oracle)
Accounts Payable/Accounts Receivable
Hornet Corporation Present - December 2017
Front-Desk Administrative Assistant
Answer and Direct incoming phone calls
Gather, distribute, and prepare packets of information regarding the oil prospectus
Prepare FedEx packages for outgoing mail
Enter Booking information into Excel
Create Marketing profiles using Word
Print and collate mass mailings
Invoicing for customers
Constellium-UACJ, Bowling Green KY April 2017 – July 2017
Coordinate EDI transactions 856, 810, 863 for Inbound and Outbound for 20 customers and vendors.
Edit work processes and work flow for Stratix Supply Chain users.
Invoicing and assist financial group researching EDI invoices.
Create SOPs for IATF.
COMMUNITY HEALTH SYSTEMS, Antioch, TN October 2015– December 2016
Master Data/EDI Analyst
Master Data Management for Lawson (Infor) Integration Team for 100+ hospitals.
Uploaded vetted files/information using Excel.
Research, verify inventory items from hospital records to Lawson to insure correct attributes.
Query and upload data from Excel to Lawson via Add-in.
EDI Analyst for 100+ locations. (810,850)
Invoicing internal customers
Wrote documentation using Word for setting up complex EDI supplier information.
Setup users for PunchOut service for multiple vendors (GHX, Staples).
Create documentation for EDI processes.
Process user/requestor for “Go-Live” facilities transition to Lawson software
Set up ED40 for facilities “Go-Live” facilities transition to Lawson software. Set up SDQ03 for desktop “Go-Live” facilities transition to Lawson software.
CARDINAL HEALTH, Laverne, TN March 2015 – July 2016
Write EDI Documentation for tasks for the Oracle system.
Write SOPs for EDI team.
Analyze, researche and correct EDI errors.
Creates Test documents for 810 and 856 for the Elite System.
Creates Service Now tickets for reporting and tracking using SmartData.
B2B with manufacturing and customers.
Order entry as needed.
JOHNSON ELECTRIC, Springfield, TN. August 2012 – October 2014
Analyze raw data from the Sterling Van, GenTran Intergration, and customers.
Create Envelopes and mapping for the GenTran Intergrator to allow data to migrate to Oracle 12 Shipping Schedule using X12 ANSI & EDIFACT.
Research and correct any errors from the GenTran and Oracle migration.
Follow process from user creating order to the flow into Sterling Van; to Gentran Intergrator; to Order creation in Oracle.
Set up trading partners via Sterling.
Upload files via Sterling Gateway.
Research mapping errors in testing.
Research errors Customer Service Representatives encounter.
Maintain library for EDI customers.
Maintain timeliness of daily and weekly processes.
Maintain PIPELINE in Excel for customer issues and resolutions including potential customers.
Test all new documents and research failures or incompatibilities.
Assist other IT personnel as needed.
Provide data entry support for annual inventory as needed.
B2B setting up trading partners.
ANSII and GXS mapping.
Set up Trading Partners and maintained relationship.
INGERSOLL RAND, Nashville, TN August 2012 – September 2014
Electronic Data Interface Coordinator
Managed 36,000 electronic interface data (EDI) orders per year.
Documented processes, verified and entered orders for tools, fluid and air products.
Answered customer requests for internal orders.
Tracked and documented error failures for electronic orders, reprocess credits and invoices for failed electronic notices.
Created statistical information for leadership management for error percentage
Used Pivot tables for error results
Invoicing for external customers and vendors
LP BUILDING SUPPLIES, Nashville, TN May 2009 – March 2007
Reviewed and completed rebates for residential and commercial customers.
Alphabetized, created file folders and filed over 3,000 rebates that had been processed but not filed.
Entered rebate information into the company’s Lawson financial database.
Created vendor master data. Revised filing systems for 23,000 customer contacts.
Set up and sold goods from the marketing closet.
PHILIPS HEALTHCARE, Nashville, TN May 2009 – March 2007
Cleared invoicing arrears for payment $3 million dollars SAP.
Worked with the 3rd party vendor for accounts payable group in India.
Developed accounts payable and general ledger procedures for accounting staff.
Reconciled vendor statements and resolved invoices that contained invalid purchase orders,
pricing or quantities.
Created new purchase orders, contacted vendors, and assured timely and accurate payments.
Maintained correspondence, invoice files and coded office invoices for financial department.
OAK RIDGE NATIONAL LAB, Oak Ridge, TN October 2005 – May 2000
Division Secretary for Procurement
Webmaster for 30 million dollar project – created and maintained changes to construction according to Federal requirements.
Lead contact for 30 million dollar project- legal documents, environmental standards, building footage, etc.
Researched and edited compliance documents to standardize over 200 publications.
Responsible for requesting vendors for office equipment maintenance.
Assisted with the planning and organizing the moving of 200 employees to new location.
Videographer for two documentaries that aired nationwide.
Performed the roles of Story-boarder, scriptwriter, director, videographer for advertising for cable television.
Wrote, edited, and researched information for internal and external news events for company.
TDS TELECOM, Knoxville, TN December 1998 - July 1980
Assistant to the Accounting Manager
Maintain files for 26 independent telephone companies and 3 cable companies in compliance with the Public Utility Commission for companies in Tennessee and Kentucky.
Secretary to the Board of Directors for 26 telephone companies and 3 cable companies.
Responsible for yearly Income Statement/Profit & Loss statements for above companies.
Invoicing for 20 telecom and 6 cable companies.
Word, Excel, Outlook, PowerPoint, SAP, Lawson, ORACLE 11 & 12, GenTran Integration, Sterling Map Editor, Elite, GXS, Lawson, Stratix, SQL queries, and Shaw databases.
Associate of Science in Video Production Technology, Pellissippi Community College, Pellissippi, TN
Working toward a BS in Marketing (Three years completed) University of Phoenix, Phoenix, AZ
Certification of completion for IBM STERLING GENTRAN: SERVER FOR MICROSOFT WINDOWS MAPPING AND TRANSLATION – ILO 6L530