Resume

Sign in

Data Analyst Microsoft Office

Location:
Valley Stream, New York, United States
Posted:
December 06, 2017

Contact this candidate

Kim Collins

(347) ***-****

ac3mg4@r.postjobfree.com

Oracle Data Analyst/Purchasing Buyer

Delivery Significant Contributions to the Oracle System

Dedicated professional offering a unique combination of Oracle, Peoplesoft, and Sci-Quests skills including 21 years of experience, which includes Purchasing Buyer and teaching the Oracle system to buyer’s as well as senior staff and clients. Creative and enthusiastic with proven success in building and managing relationships with peers, and customers and the general public; Committed to personal and professional growth and opportunity. Additional areas of expertise include:

Team Building & Leadership / Oral & Written Communications/Program Planning & Development/Banner System

Oracle Interpretation/System Script Writing/Interact with Managers & Directors/

Skills: Microsoft Office, PeopleSoft, Oracle Discoverer, MS Word, Excel Spreadsheet. Proficient in the following systems - Banner, Sci-Quest and Workday

PROFESSIONAL EXPERIENCE

International Rescue Committee - New York, NY Aug. 2017 - Present

Procurement Generalist

Contracts and negotiation

Drafting new contracts

Adding existing SOW’s as well as contracts with new vendors

Review all contracts and creating RFP’s for new vendors

Create and pull extract vital data to be reviewed for new contracts

Preform data exports from excel spreadsheet

Vlookup as well as pivot tables to extract specific data

The New School New York, NY

Data Analyst – (promoted from Senior Buyer to Data Analyst) April 2013 – Dec. 2016

Data Management, Cleansing Data as well as handling exceptions

Proactively identify data gaps and issues

Perform data exports from My New Source and combines multiple data sets to derive and create metrics

Scrub data by reviewing data fields and deriving inconsistencies from inaccurate processing

Utilizes advanced excel features such as vlookups, pivot tables

Sourcing supplies through both systems Sci-Quest and Workday systems. As well as contract management

Identify and resolve issues resulting from documents that fail to post from Sci-Quest to Banner. Knowledge of Java as Banner software.

Work with technical leads to assess the error and follow up with appropriate individual

Measure system performance by analyzing and reporting on university spend categorization, based on commodities and annual contract spend with suppliers

Work on multiple projects against deadlines in an extremely dynamic environment, where consistently producing deliverables within agreed upon timeline is expected.

Support security role maintenance, including role hierarchy, profiles and access permission

Senior Buyer (April 2013 – July 2014)

Obtaining (RFP’s) Request for Proposal through the Sci-Quest System

Sourcing vendors as well as products for each departmental needs.

Create RFP’s for solicitation as well as perform bids, and contracts for purchases.

Keep abreast of commodity codes for each item entered in the system

Monitor contact expiration dates via Sci-Quest system six month prior to end of contracts for renewal. This included Independent Contractors and licenses and construction and leases on equipment.

Draft new contracts as well as some red-lining

Supporting and keeping abreast of all requisitions and purchase orders received through the system as well as paper requisitions.

Broadlane Inc. New York, NY

Data Analyst – (promoted from Senior Buyer to Data Analyst Jan 2001 – Apr 2012

Evaluate user and department item master requests

Recommend best practices to the management to increase efficiency

Provide functional support and training for all Oracle apps to end-users

Create and utilize data loader scripts to update items in Oracle ERP

Compare vendor data with client date using Microsoft Excel

Create and run queries in Microsoft Access

Serves as the primary Data Team point or contact for Broadlane staff

Monitor EDI transactions using Broadlane’s Contract Management System

Oracle forms and reports toolset

Data Analysis

Microsoft Access and Excel and Peoplesoft

Discoverer Reporting

ERP Support, Modules, AP, AR, HR, GL.

Secure Banner request and updates to the system as requested

Senior Purchasing Buyer Jan 2000 – Dec 2001

Analyze data and develop strategies for vendors and purchasing functions

Responsible for Inventory management, forecasting and reporting

Negotiated Corporate volume discount contract with vendors

Negotiations with vendors on availability, product specs, distribution, delivery deadlines and price

Initiated and analyzed quotations, negotiated Corporate as well as facility contracts with key suppliers.

Analyzed and monitored pricing trends

Ordering of Medical, Office supplies and computers as well as printing and colligate books.

Visiting Nurse Service of New York

Management Assistant Dec 1995 – Dec 1999

Maintain preparation of budget estimate and monitoring departmental expenditures

Develop and manage, supply chain, cost saving initiatives

Oversight of all corporate contracts

Involvement with policy creation and vendor relationship

Review and file monthly and quarterly department of transportation report

Conducted inventory management, forecasting and reporting

Work with outside auditors, accounting, finance and treasury personnel

Developed vendor relationships and negotiated contracts with vendors

EDUCATION: Touro College: New York, NY

BA Business Management 1994, Deans List



Contact this candidate