Sales Administrative Assistant

SUSAN K. MAYS

**** ******* ***, ******, ** *****

Phone: 832-***-**** Email: ************@*****.***

Career Overview

Business Analyst/Office & Accounting Manager

Dedicated and technically skilled business professional with a versatile administrative support skill developed through extensive training as a business analyst, office manager, bookkeeper and Human Resource Administrator. Strong work ethic, professional demeanor and great initiative.Excel in resolving employer challenges with innovative solutions, systems and process improvements proven to increase efficiency, customer satisfaction and the bottom line.Offer advanced computer skills in MS Office Suite and other applications/systems.

Skill Highlights

Vast experience providing administrative operations support to Executives in various industires.

Energetic and organized self-starter with professional manner and excellent communciaton skills.

Superior attention to detail; along with looking for more efficient ways to conduct daily business in the working enviroment.

Excel in all MS Office applications:

oSpreadsheet creation, entry and formulation, Pivot-tables, V-lookups, charts and graphs

oPower Point presentations

oDesign of media in Publisher

oSHAREPOINT/Oracle/Showcase Queries/SAP/JDEdwards Enterprise One 9.1/Powerdraw/Asset Management/LotusNotes/PeopleSoft/Salesforce

Professional Experience

SMG at NRG Stadium – Houston, TX – Contract Position through TPI Staffing 12/2016 to Present

Administrative Assistant - Director of Maintenance & Engineering

Maintain, monitor service contract pricing along with budget and expense records. Submit monthly event expense summaries to Finance. Generate purchase orders, reconcile invoices in addition to reconcile event utility billing with other departments.

Schedule and maintain temporary labor request and reconcile associate invoices.

Generate bid summaries after proposal are received.

Gather each department monthly hour totals and submit report to Director of Maintenance & Engineering.

Assist Director on special projects.

COLUMBIA PIPELINE GROUP – Houston, TX – Contract Position through Addison Group 4/2016 -7/2016

Business Analyst

Analyzed and reconciled Compressor Stations/Meter Stations equipment, cost and monthly fees for each site. Created a budget/forecast for these sites.

Created a database for all department’s outstanding RITs (contracts) with milestones for payments.

Standardized all equipment requirements for Compressor and Meter Stations.

Examined all of departments projects within the TSA Roadmap system, identified and separated data into the correct divisions with total charges expected and what had been billed.

WEATHERFORD – Houston, TX 2013 to 2015

Business Analyst/Data Steward

Daily production in creation and maintenance of master and reference datafor Product Line management

Ran variety of queries using Showcase, Excel, Access, etc. to extract data from various source systems to

Generate ad-hoc reports and analyses for both Sales, Product Line, and eCommerce Team

Actively monitor accuracy and quality of data in JDE, SAP, and cross-functional ERP system

Resolved data integrity with all stakeholders, so no potential data reconciliation issues/errors

Recommendations to identify and acquire data for the production of Product Line specific price book/E-Catalog for customers.

Inputting of all customer quotes into JD Edwards; along with assisting of drawings in Powerdraw.

Business Analyst 2011 - 2013

Oversaw the External Audit Department for U.S. (supervision of 2).

Set criteria in audit with customer per their Master Service Agreement.

Streamlined audit process to approximately 9 months from start to finish; while including upper management in all revenue decisions involving their product line throughout the audit process.

Deployed all audits to SharePoint.

Brought together product line managers and Sales for pricing and clarification issues with auditors.

Evaluate audit findings and communicate to upper management these findings with recommendations of settling audit.

Executed new audit language for all contracts, proposals and Master Service Agreements.

Effectively closed 15 out of 17 outstanding audits in the first year with company debt being approximately $1.5 million back to customers; of that $606K was applied to customer’s outstanding A/R account.

SUSAN K. MAYS

9603 Rannock Way, Spring, TX 77379

Phone: 832-***-**** Email: ************@*****.***

BEARING SOLUTIONS, INC. – Tomball, TX – Contract Position through Staffmark 2009 to 2011

Office& Accounting Manager/Executive Administrative Assistant

Accounts Payables and Receivables, Collections: Established client payment plan program to monitor payment compliance and progress, reducing uncontrolled payment activity by 40%.

Produced sales report in excel, so that it would be easily accessed and be used for forecasting coming year’s sales.

Organized billing cycle, prepared A/R report for CEO, along with Gross Margin and EBDA reports for all locations

Payroll for two separate payrolls entities.

Human Resources for 15 employees. Successfully opened second location in Odessa, Tx.

Purchasing, Receiving and logistics of inventory to customer.

Generated a Business Plan & Overview, training manual of accounting procedures and employee handbook and new hire packets.

A trusted assistant to the company CEO/President, executive staff and earned a reputation for maintaining a positive attitude and producing high-quality work.

WILSHIRE HOMES – Houston, TX 2007 to 2009

Administrative Assistant

Administered Houston location website: pricing, floor plans and description of homes for each community.

Completed all setting up/dismantling Sale trailers and model homes with necessary Marketing Collateral

Attended meetings with each community monthly to keep website current with happenings of community.

Coordinated meetings with Designers, President and Vice President of Sales when developing a new model home.

Designed PowerPoint presentation of each community’s model homes that was shown in model home.

Produced/maintained a 1500+ database containing Realtors citywide to help promote community promotions.

Generated automated monthly stats report showing Realtors sales/community for the Vice President of Sales and President

EARTHMAN FUNERAL HOME & CEMETARY – Houston, TX 2003 to 2005

Location Administrator

Executed Payroll, Human Resources and Benefits for Chapels.

Processed all sales contracts, cash and receipts into JD Edwards for 3 Houston chapels.

Prepared A/P and A/R; along with petty cash advances.Record keeping of all vendor certificates of insurance current.

Prepared office budget for office of 30 employees.

Coordinated and tracked the peripheral sales program relating to flowers, urns and caskets.Maintained inventory of material assets.

Managed three Houston chapels as well as supervised 5 Assistant Location Administrators in the Houston area.

IT Administrator in the capacity of fixing two servers in office, when there was a problem.

Past Experience upon Request

Education

CompUSA, Houston, TX - Microsoft Office – Word, Excel, PowerPoint and Access

North Harris County College, Houston, TX - Legal Secretary

Texas Lutheran University, Sequin, TX - Business Administration

Contact this candidate