Data Analyst Administrative Assistant

MARILYNN Davis

**** ********* **. *******, ** ***88

469-***-**** mobile

adtfua@r.postjobfree.com

Professional Summary and Skills

Technical Writer, Analyst/Contract Analyst/Procurement Analyst/SAP SD Specialist/SAP Master Data Coordinator/Master Data Specialist/Data Analyst/ Material Master Data Specialist/Customer Master Data and SAP Purchasing and Requisitions, Group Purchasing Organization (GPO).

Inside Sales, Procurement/Supply Chain, Purchasing, World Wide Sourcing and Requisitions, Executive/Administrative Assistant

Strong computer, analytical, verbal, writing, people skills and strong VP and Upper-Level Management support; BPCS, AutoDesk Vault, Vault Legacy, TAS, BPCS Stragegi, ExpressOS, MetalTrace Online Site. Quickbase, SharePoint, RailForceOne & Smartsheet.

Super User - Basic SQL, Ariba. Emptoris, CA Agile Central-(Rally SaaS), Remedy Force IT help Desk, SAP Vistex, SAP, SAP eSourcing, SAP Netweaver, Business Warehouse (BW), Business Objects, Windows 13/16 MS Office: 13/16

(MS Word/Excel/PowerPoint/Outlook/MS Access. Oracle Purchasing, Esker Delivery Ware Document Manager, Novation Forms Manager.

Professional Experience

Trinity Industries Contract Assignment (Actalent Services) March 2018 to October 2022

Technical Writer/Engineering Administrator

Worked with Engineering creating MDE4 for TTX.

Creating and maintaining all technical documentation used in a regulated design and manufacturing environment

Pulled Specifications and Certificates of Constructions & R1’s from SharePoint.

Pulled drawings from Vault and Vault Legacy to fill Close-out Request.

Responsible for creating close-out packages for multiple customers

Working closely with the engineering design team to pull drawings and Bill of Materials to create close-out packages

Pulled photos, mechanical records and for Freight and Tank cars.

Updated and creating data files, utilizing Excel and transferring data to a PRN file format

Performed document formatting to meet the standards of each customer

Crossing training on updates to TAS Engineering Files and drawing information for the various plants; for both Tank and Freight Cars.

Crossing training on BPCS and Auto Desk Vault; Vault Legacy, to verify information on drawings received from the Engineers, matches the information that was loaded to Quickbase and Auto Vault (where drawings are keep).

Cross-trained on Releasing of Drawings.

Alliance Data Systems (ADS) Contract Assignment (Robert Half) July 2016 to March 2018

Paralegal/ Legal Assistant-JR

Execution included New Contracts, Language Modifications, Contract Extensions, Item Pricing, NDA’s, BBA, Addendums and Amendments as well as uploading new contracts/agreements into Emptoris, then executing or sending through DocuSign.

Data Enhancement/Clean-Up & Updating Emptoris End Dates

Running various Reports via LOB Contracts

Verifying and comparing Emptoris and PeopleSoft Data in order to update Emptoris

Identifying employees that are no longer ADS employees for Corporate

Contacting Business Owners to Identify their Contracts

Prepared and supported LOB’s with migrate of TPSA and Consulting Contracts to GRI System

Goal is to work with Active Presenter to build Emptoris Manual

Working with MainSpring to create mass upload for Emptoris

Enterprise End User Follow-Ups, Training Development, and ADS business Support

Working with Spend Report found in Emptoris for Procurement, IT, Facilities, Print and Marketing

Updating Corporate Leases End Dates in Emptoris, after verifying using PeopleSoft Access Management Tool

Vizient/Novation - Contract Assignment (The Insource Group) October 2015 to July 2016

Data Analyst

Provided on-going support to customers, suppliers, and partner teams by responding to and resolving all processes and contract related inquiries (Remedy Force IT Helpdesk).

Provideds operational support to a team where needed.

Resolved pricing, process and contract related inquiries made by all customers

Acts as liaison between the member and supplier and provides on-going support and issue resolution by understanding the problem statement, conducting deeper analysis for issues to identify root cause and provides optimum solution to the internal and external customers

Data Audits to New Tiers request (SAP Vistex)

Keep track of production using CA Agile Central (Rally SaaS)

Processed Contracts, update/create Tier requests in Novation Forms Manager, also process Contracts with large member list into Esker

Work Staging Table to clear forms stuck in the system for various reasons.

Identifies opportunity and solutions for improving operational efficiency

Provided counseling, guidance, and training to all parties

Performed Audit and Quality Controls on a daily basis Core Skills

Strong organizational, communication and interpersonal skills

Ability to meet short deadlines and achieve high levels of productivity and accuracy with minimal supervision

Strong verbal and written communication skills

Strong customer focus that is always looking to serve and constantly thinking of new ways to better support and enable members, suppliers, and Alliance teams

Plan, organize and manage time across multiple tasks working individually and performing cross-functional duties within the team.

Med Synergies – Short-term Contract (TEKsystems) July 2015 to September 2015

Strategies Sourcing Specialist

Self-taught the use of Ariba Software

Loaded PDF contracts into Ariba for both Contract Procurement Vendor/Supplier and Contract Sales, also upload contract via Excel templates.

Set up New Vendors/Suppliers Procurement Vendors and Sales

Researched and would troubleshoot PDF’s that need to be loaded to Ariba.

Execution includes New Contracts, NDA, BBA, Addendums, and Amendments

Super User - Microsoft Excel and Word.

Began the second phase to write the Ariba process for training.

Demonstrated teamwork and collaboration with Vendor/Suppliers etc…

Highly organized individual with exceptional attention to detail

Professional image with exceptional (both verbal and written) communication skills

Action-oriented, high initiative, good problem-solving skills, and independent thinking

Worked independently with minimum supervision, conferring with the team as needed.

Novation - Contract Assignment (The Insource Group) April 2013 to May 2015

Contract Analyst

Verified and loaded contracts into NFM (Novation Forms Manager) and/or Esker Document Manager.

Uploaded PDF and contracts into Esker for processing.

Trained in Quality Control (QC) duties, which included auditing forms that have been loaded into the system correctly.

Researched and troubleshooting problems in SAP

New Member Implementation/Conversions Process

Daily Staging Table Maintenance

Department is currently working on other phases of QC that I will be handling

Used Emptoris Contract Management System to execute amends and extend Health Care, Pharmacy and Supply Chain Contracts, and Audits.

Execution included New Contracts, Language Modifications, Contract Extensions, Addendums and Item Pricing.

Super User - Microsoft Excel and Word, Intermediate user - Access

Wrote the Emptoris processes for publications throughout the company.

Highly organized individual with exceptional attention to detail

Professional image with exceptional (both verbal and written) communication skills

Action-oriented, high initiative, good problem-solving skills, and independent thinking

Demonstrated teamwork and collaboration with customer service orientation

Worked independently with minimum supervision, conferring with the team as needed.

Assignment broadens in nature, sometimes-requiring originality, ingenuity, and initiative.

Performing additional projects/duties as needed by the departments.

Lennox Industries - Contract Assignment May 2012 to April 2013

Procurement Analyst -Worldwide Sourcing

Responsibilities included; Creating and Publishing Agreements for Approved Price List (APL) received from Strategic Sourcing Managers (SSM). Achieved using several methods; manually changing eSourcing Agreement Line Items, Extending current Agreements, Importing/Exporting SAP Sourcing Agreement Line Items and/or using the SharePoint APL Template Database.

Writing and developing process and procedures for user training.

Cancelling of eSourcing Master Contract Agreement when needed

Utilized Access APL Template Database to import data from Excel, which translated the APL to the correct format and price precision, which allowed creation of Agreements in

e-Sourcing and Publishing to SAP

Updating/Back Dating SAP Sourcing Line Item for Effective Start Dates by maintaining Header Creating a Supplier Contact in SAP Sourcing, and transferring Non-Existing Supplier and Non-Existing Material from SAP Sourcing.

Knowledge of running Compliance Reports to validate pricing via SAP

Running and correcting Agreement Data Overlaps based on SAP Overlap Report.

Analyzing and identifying missing Approved Price List and updating SharePoint with Approved Price List Analyzing BW Spend data to identify what send is not in APL

Analyzing, identifying Material assignment to IT for updating the assigned SSM.

Identifying and notifying SSM’s of expiring contracts

Updating and ensuring Price Compliance Reports status via the emails responses received from the SSM, which included pushing prices.

Analyzing SAP Sourcing Materials on Agreement against BW Materials and Combining APL DB PIR, DB Vendor, Source list and SAP Sourcing Agreement.

Megger (AVO International) November 2009 to October 2011

SAP SD Specialist (Inside Sales Department)

Performed SAP Super User functions

Performed SAP SD Master Data maintenance

Updated/maintained Material and Customer Master, Price lists, and Customer discounts.

Ran SAP reports for analyzing external reports. Occasionally ran SAP customer specific reports and programs. Company Budget Performance Report, Daily Sales Register, MTD, and YTD Financial report, TSR Field Sales report, weekly Inside Sales Call Log.

Logged and tracked VP, Managers, and Field Sales expenses reports.

Worked with the offshore employees in Chiswick and London England

Tracked monthly production, production time for Inside Sales Team, using excel template.

Writing and developing process and procedures

Purchased and ordered office supplies and special literature when requested.

Coordinated monthly birthday and anniversary breakfast and/or lunches.

Ordered and picked up lunches for business meetings when requested.

Researched various data; depending on the requested project.

Verified and requested tax exemption certifications for Accounting Department.

Lennox Industries - Contract Assignment August 2009 to November 2009

Data Analyst -Marketing and Procurement Department

Ran Daily Parts Plus Metrics Reports using SAP queries, uploaded to Access/Excel output reports and Daily Pricing Reports for Vendor to Field Vendor requested pricing changes.

Uploaded SAP the Weekly Inventory sales to run the Inventory Reports for various Zones.

Ran monthly Promotion Reports and VP requested Bowler/Counter Measure Report.

Created SAP Queries, PowerPoint graphics presentations and creating Pivot Charts.

Trained to update and run TM Bonus and Steering Committee Reports.

Dr. Pepper Snapple Group - Contract Assignment October 2008 to August 2009

Material Master Data Coordinator (Supply Chain Procurement)

Provided Administrative SAP Master Data support to Supply Chain PBS Packaging & Ingredient Category Manager(s) & Supply Chain Planners and Co-Packers.

Generated new SAP Contracts, Scheduling Agreements, Info Records, Purchasing views, and Pricing conditions for both MSSI and Probe.

Created new and updating existing material numbers for SAP Contracts, Scheduling Agreements, Info Records, Purchasing views and Pricing conditions. Performed functions to prevent defects.

Updated and maintained pricing for vendor price change, volumes per Planners

Integrity processes for improvement as identified by management

Required judgment within various practices and policies, methods and techniques

Created New Annual Contracts and Info Records for the upcoming year.

Created Purchase Requisitions and Created and updated Vendor Information

Created and updated Source List for MSSI, Probe, and Material Groups.

Invoiced pricing, discrepancies, PV Parked, Blocked, and obtaining Approvals.

Researched Invoice payments and submitted for approval or corrections.

Master Data Specialist - (DPS Customer Solutions)

Provided businesses with master data objects support to enable master data maintenance activities and ensure a secure the route to market.

Updated existing closed and blocked accounts and entered Days/Stops, DEX accounts, setup of new accounts, full-service accounts, Bill-To accounts, Payer accounts, Ship-To accounts, Sold-To accounts, Checker and Driver accounts.

Inputted delivery types. Attached Driver accounts to correct Sales Routes.

Identified improvements to various processes.

Cadbury Schweppes - Contract Assignment March 2008 to May 2008

Material Master Data Coordinator - (Supply Chain Procurement)

Texas Instruments/TwinStar Semiconductor September 1994 - August 2007

Executive/Administrative Assistant

Office Administrator/Financial Analyst for Dynamic Sources (Sales Marketing Department)

Purchasing Assistant & Small Order Buyer (One (1) Direct Report)

(Purchasing/Procurement Department)

EDUCATION

Liberty University - Major Human Service/Executive Leadership

Master’s Degree (Graduation Date 12/2017)

Liberty University - Major Psychology - Bachelor’s Degree (Graduation Date 12/2014)

Liberty University - Continuing Education - Basic SQL training

Westwood College of Technology -- Computer Engineering - Dallas, Texas

Richland College -- Computer Courses - Richardson, Texas

Rockwell International - Human Resources Training & Development

Texas Instruments – Computer, SQL and Self-Initiative Classes

Neighborhood Youth Corp - GED - General Office Administrator - Accounting

Contact this candidate