Oracle Data Analyst and Purchasing Leader with 21 Years Experience
Resume:
Kim Collins
**************@*****.***
Oracle Data Analyst/Purchasing Buyer
Delivery Significant Contributions to the Oracle System Dedicated professional offering a unique combination Purchasing Management skills, as well as 1.5 million dollar budget. including 21 years of experience, which includes daily operations of the company’s purchasing department in all aspects which includes furniture, desktops, office supplies, cell phones, printers etc. Implemented the purchasing oracle system and taught the system to the buyers as well as senior staff and clients. Maintain the purchasing policy and procedure and cost savings, enforcing bids and RFP’s. Creative 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 & 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 Workday as well as Infor (CSI) PROFESSIONAL EXPERIENCE
Consolidated Edison- New York, NY December 2023 – March 2025 Procurement Specialist
Overseeing procurement and vendor payment activities for Transmission Operations (including both Underground Transmission and Transmission Line Maintenance), O&M, and capital material and services.
Manage areas of the vegetation management program and line maintenance operation. and/or direct reports along with S&TO's EH&S Manager.
Overseeing procurement and vendor payment activities for Transmission Operations (including both Underground Transmission and Transmission Line Maintenance) including O&M and capital material and services.
Manage the areas of the vegetation management program and line maintenance operation. 2
Performs functions for Transmission Operations and provides support and assistance for Transmission Operations.
Ensure implementation of Company safety, health and environmental programs for employees whose work is directed.
Ensure that safe work practices are followed, and the environment is fully protected in accordance with Company policy and governmental regulations.
Handle and review and update of operating procedures. As well as the procurement of required equipment, services, and supplies for Transmission Operations in accordance with all current policies and procedures.
The above includes requisitions, purchase orders, order releases and the procurement of material through Oracle EBS and other procurement systems.
Overseeing procurement and vendor payment activities for Transmission Operations (TLM & UG) O&M, and capital material and services.
Work with Project Managers on matters associated with the contractor services as well as participate in the planning process.
Purchase of new services and materials as well as the preparation of bids and evaluating the terms and conditions of purchase orders. Core Responsibilities
Review licenses software and hardware for the finance department, as well as renewing license for internet, domain and subscription.
Build strategic relationships with the Transmission Operations management team as well as other organizations to ensure the needs of Transmission Operations are addressed.
Compare invoice pricing to Purchase order for any discrepancies.
Work with A/P for payment status on orders.
Negotiate pricing with vendor for office supplies, furniture, etc.
Price forecasting
Perform cost analyses on a regular basis to ensure the Company is making solid economic decisions with its current vendors versus new vendor relationships Jacques Chocolate Manufacturer-Brooklyn, NY September 2021 – August 2023 Purchasing Manager
Negotiate all purchases to obtain better pricing and structure better purchasing arrangements 3
Create and manage a calendar of purchasing deadlines for items with long lead times (like packaging from overseas)
Responsible for keeping the packaging/ raw material area organized, perform regular inventory counts, and pull items needed for production and packaging for that day.
Participate in weekly planning meetings with production team to ensure raw materials and packaging needed for each holiday season are always procured in a timely manner.
Forecast future production needs based on historical and planned usage.
Determine the quantity, quality and timing of deliveries and communicate with production team
Monitor ongoing inventory usage to anticipate changes in purchasing demand.
Source new vendors when new raw materials are needed or changes to a product package are made
Perform cost analyses on a regular basis to ensure the Company is making solid economic decisions with its current vendors versus new vendor relationships.
Prepare regular raw material and packaging reports for management Maintain accurate inventory counts for raw materials and packaging quantities on hand
NYC Pumps - Brooklyn, NY November 2018 – October 2019 Purchasing Agent/Contract Administrators
Prepare and issue purchase orders in accordance with company procurement policies.
Prepare RFQs
Identify appropriate suppliers.
Negotiate prices and terms with suppliers.
Obtain and apply confirm dates for all purchasing contracts.
Prioritize purchasing activities and coordinate work flow
Maintain records and electronic files pertaining to purchasing.
Coordinate with AR to resolve any invoice/PO variances
Additional responsibilities will include assistance with production planning and generating status reports.
Contract Drafting
Contract negotiation
Frener- Reifer America Inc. - New York, NY November 2017 - September 2018 4
Contract Administrator/Procurement Analysts
Negotiate construction contracts.
Drafting contracts
Analyst A/P Tracker and input data in system
Analyze data in the ERP system, Navigation.
Create Metric
Enter vendors as well as contracts into the Navigation System (ERP)
Posting invoices in the system for payment
Create POs in the system
Sourcing Vendors
Create RFP's as well as negotiate savings within the purchasing environment.
Create PO's and review requisitions.
Contract savings as well as draft contracts to specifications
Create contracts for new vendors as well as bids.
Work within the Workday (ERP) systems not only with creating PO's, updating and extending contract that are expiring.
Uploading/Creating vendors that a not in the system
Analyze data in the system.
Sourcing vendors
Priced contracts as well as allocating fixed amounts to amount-based contracts.
Associating rates to rate-based contract lines, and allocate any fixed amount that is defined for a contract.
Create change orders, outside of the contract
Evaluating proposed pricing
Drafting and amending contracts
International Rescue Committee - New York, NY August. 2017 – October 2017 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
5
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
Identify, document and report Application defects to the development team. 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.
Preparation of functional specifications and system requirement 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
6
ERP Support, Modules, AP, AR, HR, GL.
Secure Banner request and updates to the system as requested
Review licenses software and hardware for the finance department, as well as renewing license for internet, domain and subscription as well as download software on laptops and desktop. 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