Project Coordinator Data

MICOLE WESLEY

Skills/tools

MS Excel MS Outlook MS PowerPoint MS Access MS Project MS OneNote

MS OneDrive SharePoint SAP Salesforce Google Docs Smartsheet

ROLES

Project Coordinator Project Administrator Order Management Analyst

Data Validation specialist Administrative Analyst

SUMMARY

Project Coordinator, Data Validation Specialist. Experience in Project Coordination, timeline management and project reporting. Expert in organization and communicative collaborator.

Project Coordinator = 8 years

Excel = 12 yrs+

VLookup = 12yrs

Pivot Tables = 5 yrs

Data Tables = 5 y5s

Statistical Analysis = 3 yrs

EDUCATION

BS BUS STUDIES IN MARKETING • 2020 IN PROCESS • WGU

HEALTH COACH CERTIFICATION • 2020 • ACE

PROFESSIONAL EXPERIENCE

Project Coordinator / Data Validation Specialist-Contractor

Varsity Spirit, August 2019 – December 2019

Reviewed variety of detailed documents and data sources to ensure their accuracy

Performed data integrity checks, reconciliation, and reports anomalies in facilitates data or documentation corrections with analysts to ensure all records are complete and accurate

Ensured investigations were assigned, completed and referenced for data or documentation

Created SOP for information validation process, conducted data analysis, quality, and cleaning Identifying & resolving data anomalies using VLookups via Excel spreadsheet reports to ensure successful system migrations

Conducted human data validation, tracking errors and Data Mapping

Order Delivery Manager-Contractor

Ericsson, August 2018 – April 2019

Process orders and assist team members with processing orders in SAP

Log SO/network status within MS Excel to indicate orders are complete

Receive POS from customer and logging or uploading data into MS Excel report

Scan order form packets and Run customer PO status reports

Project Setup/Order Management and Delivery Management- responsible for Project Set-up within

SAP/ creating WBS and SO creation/changing sales orders, creating projects or changes, knowledge

Delivery call off transactions in SAP, Delivery management, and familiarity with finance revenue

Project Coordinator / Transaction Specialist

Vizient, August 2016 – July 2018

Effectively created and maintained quality relationships with providers and suppliers to ensure provider satisfaction.

Communicated with suppliers regarding purchase of supplies, equipment, and service in accordance with customer policies and procedures to ensure accuracy of product, price, and delivery terms

Used a proprietary eSourcing application to review normal and special purchase orders prior to transmittal to supplier, for possible product, unit of measure, minimum order quantities and executed corrective measures based on customers’ policies and procedures

Appropriately tracked special purchase order types and exceptions in Excel. Collecting purchase order acknowledgment information from suppliers on all unacknowledged purchase orders within predefined service level agreements

Managed problem order acknowledgement statuses (backorders, rejects, deletes, on hold) according to client specified rules. Investigating purchase order issues with providers and suppliers for resolution

Documented price discrepancies based on supplier-acknowledged price in Excel and Word

Contract Analyst-Contractor

Toyota Financial Services, June 2015 – January 2016

Ran queries to locate contracts in Excel to loan origination system and verifies terms and conditions have been submitted as approved

Reviewed contracts and credit applications for completeness, proper date/ signature, accuracy and compliance with all State and Federal requirements. Verifies contract rates/service charges are accurate in accordance to rate letters and special programs

Performed thorough evaluation of all documents within contract package, whether EC or paper, to ensure proper disclosure and adherence to current TFS internal policies and procedures.

Accurately and efficiently entered data required to completely book each contract and prepares held offering letters for contracts that do not meet guidelines.

Maintained working knowledge of FOPP, TT&R, Desk Guide, and the FSBs to ensure compliance and follows-up on and corresponds with DSSOs and dealers regarding held offerings, variances, reserves, challenges, etc.

Order Management Analyst-Contractor

Goodman Networks, July 2014 – December 2014

Updated and edited Excel spreadsheet, ran queries using VLOOKUP, performed equations and communicated with market contacts via email and phone. Inputting data for various markets for the ATT project into the CASPR system.

Project Coordinator / Administrator-Contractor

Ericsson, March 2013 – July 2013

Updated and edited Excel spreadsheets. Ran queries using VLOOKUP, and communicating with market contacts via email to handle other important tasks. Transferred large amounts of data from one system to the next

Updated multiple major network site milestones for Sprint projects via Siterra and Site Handler.

Helped close-out team review construction photos apply appropriate file name to upload & save into computer programs and contacted PM and CM to request missing photos and other documents

Project Coordinator-Contractor

Goodman Networks, October 2012 – February 2013

In charge of inputting large amounts of data for various markets for ATT project into CASPR system

Updated, edited Excel spreadsheet, ran queries using VLOOKUP, performed equations using SumIfs.

Communicated with market contacts via email and phone to handle other important tasks.

Used micro templates to run equations and VLOOKUP queries to pull data daily and input into internal systems

Project Coordinator-Contractor

Diebold, March 2012 – July 2012

Analyzed large amounts of data from the customer and entering and updating several systems

Replied to Project Managers via email and phone regarding the status of project approvals and denials and informed them of corrections needed for approval.

Tracked and updated data via Excel

Revenue Coordinator / Project Coordinator-Contractor

Hilton Corporate, September 2011 – March 2012

Updated and edited Excel spreadsheets. Ran queries using VLOOKUP, and communicating with market contacts via email to handle other important tasks.

Performed daily data entry of member data into internal computer systems, creating spreadsheets and tools via Access and Excel. Help to support multiple revenue managers by Coordinating the Revenue Management tools and procedures for multiple hotels. Data collection, data entry, tool maintenance, photo copying, filing, report distribution, composing emails and other special projects as needed

Processed multiple customer final installation orders on a daily basis, navigated through multiple internal company computer systems, created and maintained several spreadsheets, and heavy alpha and numeric data entry

Sr. Administrative Coordinator-Contractor

United Healthcare, October 2010 – January 2011

Made proper corrections, updates, and or changes to provider health insurance contracts via internal software programs called Emptoris, UNO and NDB

Created mailing labels to send out mail and made several outbound calls to providers to verify they received their contracts, created Excel spreadsheets and also edited Excel / Access templates

Administrative Analyst

CDM, March 2008 – July 2010

Filed paperwork, checked CDMU email box daily. Planned office social events and team fundraising events.

Used Excel spreadsheets to run "V-Lookups, create tables, mail merges, track projects and enter data onto existing table templates running reports for VP's, Executives and other personnel as requested.

Made numerous photocopies, preparing documents for upcoming training classes and conferences, creating FedEx labels online in order to ship class materials to proper locations.

Scheduled conference rooms, meetings, webinars and training classes

Contact this candidate