Analyst - Remote

Vanessa L. Cantwell

**** ****** ******** ****, # ****

McKinney, TX

Home 972-***-****

*********@*****.***

OBJECTIVE

• Seeking a challenging position that will allow for growth and a chance to use and contribute my education and related experience.

EDUCATION

Northcentral University Graduate School June 2021

Master’s degree in Industrial/Organizational Psychology Cumulative GPA 3.8

University of Texas at Austin May 2000

Bachelor of Liberal Arts in Psychology with a minor in education of Psychology. Cumulative GPA 3.9

COMPUTER SKILLS

• IBM and Apple Mac Compatible

• Proficient in Microsoft Excel, Microsoft Access, Microsoft Word, Microsoft Teams, and Microsoft PowerPoint

• Lotus Notes, Microsoft Outlook, Microsoft Express Compatible

• Moderate knowledge in Marketing Funds, National Accounts CSS, Impromptu, MapInfo, Nitro, ACNielsen, Arev Dos Database, Map Point, AR, AP

• Windows 9x

• IRI

• Retail Link

• CRM (Oracle) Database Analyst.

• QC Database Analyst

• Oracle Database Analyst

• SQL (RDSMS) Analyst

• STAR2, CETS, FSR, ERT, MasterFiles, PCC

• Smartsheet

• Visio

• Salesforce

• SAP

• Callidus

• Intelagree

• Qlik

• Vendavo

• Profit Analyzer

• Tableau

WORK HISTORY

IDR/Lennox Richardson, TX 5/2021 - 3/2022

Sales Operations Analyst III

• Responsible for the creation, production and delivery of sales forecasts, analysis and reporting in support of the sales planning process and sales of the company’s products.

• Assists in preparing sales forecasts, developing sales quotas, and collecting and analyzing data to evaluate current sales goals.

• Works with sales, marketing and distribution for the purpose of improving operational efficiency.

• Assists in researching and evaluating economic conditions that may affect the organization’s ability to sell products, protect/increase market share, penetrate new markets, and maintain/ improve operating margins.

• Recommends changes to current sales techniques, procedures or promotional efforts based on market research and new trends.

• Runs standard reports and assists in developing new reports. May Assist in monitoring forecast accuracy.

PepsiCo Plano, TX 3/21/2016 – 11/01/2019

Sales Analyst

• Drive Volume and Revenue growth by ensuring proper account setup

• Track volume for assigned accounts each period and provide reports to National Account Sales Managers &/or customers

• Create Ad hoc reporting and provide data to NASM customer reviews and/or internal presentations

• Develop, Design, Implement customized reporting, score-carding, projection tools

• Analyze Sales reports for source accuracy & significant results; advise NASMs and Director as appropriate

• Work with NASMs, Operations, Equipment, Field, Contractors, and Customer on equipment orders

• Work with NASM, Information Systems, and Customer to update and maintain accurate customer information

• Ensure updated and accurate pricing in the system

• Handle service, rebate, credit, and billing issues from Customer

• Provide analytical and presentation support to customer meetings

• Look for selling opportunities by providing and analyzing distribution void reports

• Point of contact for equipment installs for new, remodel & outlet closures

• Work with National Customer Service, Database System in notifying of account status and maintaining customer wiring (outlets closing, change of ownership, missing volume)

• Address questions/issues raised by customer or bottlers (handle service, rebate, credit, and billing issues from customer)

Operations Support & Field Integration:

• Active participation in Division Key AOP Initiatives

• Develop Customer Contacts and foster direct customer relationships at all levels 24seven – PepsiCo Plano, TX 7/14/2015 – 3/20/2016

Sales Associate Analyst - Contractor

• Ran reports out of FSR, SAP, and ERT in which I manipulated in Excel using pivot tables, v- lookups, macros, conditional formatting, and formulas to provide support to the Rec & Retail side of National Foodservice.

• Automated reports using macros and conditional formatting that are used daily to submit equipment requests, and track service orders.

• Set up vendors in order to get invoices paid.

• Worked closely with a few NASMs, FSRs, Ops Management, bottlers, and customers in order to get equipment requests submitted and processed for Marriott, Avendra, Hyatt, Compass, ClubCorp, and Aramark.

• Worked with customers and NASM’s to get invoices submitted, processed and paid for Marriott, Avendra, Hyatt, and ClubCorp.

• Helped my teammates automate some of their reports that they use weekly and by period.

• Provided help in Excel with all of my teammates. McAfee – Plano, TX

CRM Analyst – Sales Operations 09/15/2010 – 06/28012

• CRM database trainer for the sales team in Cork, Ireland

• CRM database trainer for the sales team in Melbourne, Australia

• CRM database trainer for the sales team in Sydney, Australia

• CRM database trainer for the sales team in USA

• Tested, trained, documented, and implemented enhancements to the (Oracle) CRM databases

• Documented and made enhancements for the (Oracle) CRM databases in the QC database

• Global on line, on call, and reporting (using advanced Microsoft Excel formulas and dashboards) for sales reps, directors, and company vice-presidents and presidents. Manpower – McAfee Plano, TX

COE Analyst – Sales Department 03/09/2009 – 09/14/2010

• Working in the merge queue to eliminate duplicate accounts, using MAX, SAP, and Hoovers.

• Created Secure and Solidcore opportunities using MAX and Salesforce.

• Help clean-up BEMFAB accounts in MAX using both Siebel and MAX.

• Help with any ad-hoc reports that were asked of me.

• Help clean up account types and segmentation using MAX, SAP, and Hoovers.

• Trained several co-workers, both temps and permanent employees on different formulas and manipulations that can be performed in Excel in order to speed up processes. Truco Enterprises, LP Dallas, TX

Category Analyst - Marketing Department 10/05/2007 – 07/17/2008

• Created, formatted, and distributed reports to the sales team using IRI, Excel, Microsoft PowerPoint, and Map Point. I also pulled Ad-hoc reports for the Executives when requested.

• Created and formatted reports using Retail Link and Excel for the Sam’s/Wal-Mart account. I distributed sales reports, replenishment reports, verified and reconciled orders for the Sam’s customers. Used internal programs to facilitate the AP, AR, and CRM departments.

• Performed any Ad-hoc reports using Retail Link for the Executives of the Company for the #1 account, Sam’s.

Dr Pepper/Seven Up, Inc. Plano, TX 05/02/2003 – 06/04/2004 Associate Manager

• Generated and analyzed promotional, geographical, marketing and financial ACNielsen data for the three major competitors in the non-alcoholic beverage industry for the departments of National Accounts, Pepsi Bottlers, Coke Bottlers, Independent Bottlers, Fountain and Foodservice and all special requests from upper management within the company. Dr Pepper/Seven Up, Inc. Plano, TX 03/26/2001 – 05/01/2003 Information Specialist

• Received promotional announcements from NAE’s and Directors of the Convenience and Grocery teams, processed the promotional announcements using multiple computer applications and company created systems and executed the promotional announcements by becoming the liaison between the NAE or Director who created the promotional announcement to the appropriate bottlers and field personnel.

Spherion-Dr Pepper/Seven Up, Inc. Plano, TX

Division Focus Coordinator 04/2000 – 03/26/2001

• Maintain and update an Access database that contains tracking information for the sales associates.

• Create queries, pivot tables, and macros in both Excel and Access.

• Produce Biweekly and ad hoc reports in Excel for the sales field, VP’s, and management of fountain and food services.

• Track and monitor franchisee contractual agreements with DPSU.

• Track brand availability by conducting surveys.

• Manipulate data by creating formulas in Excel.

• Reconcile data using Marketing Funds and SAP

AWARDS RECEIVED

• University Honors

• Collegiate Dean's list

• Toastmasters Member

Contact this candidate