Oracle Manager

Name: STEWART A. EPSTEIN Phone: 561-***-****

Mr. Epstein has over 20 years of experience implementing Oracle EBS software, including over 5 years’ experience using Oracle Financials Release 12. He has been involved in both functional and technical leadership for the development of multiple Oracle financial applications. His experience includes leading projects using Oracle’s AIM project management methodologies. He was a key member of the corporate procurement department of an international fortune 500 corporation. He has broad functional experience with Purchasing, Government Purchasing, iProcurement, Receiving, System Administration and integrating with other Oracle modules such as HR, AP, INV, PA and GL. He has experience with Oracle architecture, Help Desk, System Administration, Flexfields, SQL*PLUS, query tools, legacy conversions and interfaces. His experience is related to all phases of a project life cycle, including the setting up, and integration with a client’s existing functionality. He has strong communication, analytical, organizational, and documentation skills and is able to balance multiple priorities and prioritize tasks in a fast paced environment. He has an excellent work ethic and drive to get the job done, driving applications and completing projects on time and within budgets. His background enables him to approach consulting with an open-minded perspective, and is eager to setup applications, and make recommendations to a client’s requests. Mr. Epstein can work independently, or as a member and contributor on a team of IT professionals. He has worked closely alongside both subject matter experts (SME’s), and program developers. He has also worked for clients within the aerospace, military, energy, health, engineering, manufacturing, and service industries as well as State, Local and US Federal Government.

Current Location: Palm Beach Gardens, FL

Availability for Interview: 1 Days’ Notice

Availability to Start: 1 Week – if needed immediately

Education:

BS (Business Management), New York Institute of Technology-Old Westbury NY

Certifications & Training:

Oracle eBusiness Procurement Awareness Certification

Oracle eBusiness Procurement Proficiency Certification

Oracle Stage Hand of the Year

Consultant of the Quarter

Oracle QOOL

Oracle Project Management Lifecycle

Relational Database Manager

Technical Skills:

Oracle E-business Applications: Version 10, 11, 12.1 to 12.1.3

Microsoft: Word, Excel, PowerPoint, Visio, Projects

Languages: SQL*PLUS

Databases: Oracle

Operating Systems: Windows 10

Oracle Functional and Toolset Expertise:

Oracle Applications

Purchasing

System Administration

Sourcing

Form Personalization

PO to HR

PO to GL

iProcurement

Payables

Help Desk Support

Self-Service Personalization

PO to AP

PO to INV

Discoverer

Encumbrance Accounting

Pricing

OracleMetalink Support

eTax

iSupplier

PO to PA

Engagement Experience:

Oracle Metalink Support

T2 Help Desk Support

Encumbrance Accounting

JFMIP Certifications

Framework Personalization

Fit/Gap Analysis

SQL Analysis and Reporting

Requirements Analysis

Form Personalization

Post Production Support

API Mapping

Folder Technology

Data Mapping

Interface Design

Business Requirements

Data Reconciliation

Forensic Analysis

Approval Tracking

Test Scripting

Quality Assurance Testing

RICE Item Design

Functional Setups

Trouble Shooting

Flexfield Design and Creation

Prototyping

Testing & Debugging

Query Tools

Process Flows (As-Is/To Be)

Interfaces and Extensions

SQL Scripting and Reporting

Independent Consultant Apr 2017 -Present

In conjunction with Oracle support provided functional and technical advice to Oracle consultants relative to previous Oracle related projects which I had been associated with.

Wright Aero Industries, Inc. Sunrise, FL Jan 2014 – Mar 2017

Oracle EBS Functional Consultant

This was a review to determine whether it was feasible for Wright Aero to implement Oracle Financials Release 12.1.

Responsibilities:

Review and analysis of their current purchasing methodology and process flows, and then map it to Oracle Purchasing Release 12.1. Provided advice and functional guidance in support of the following Oracle modules Purchasing, iProcurement, Payables, General Ledger, Inventory (partial), Human Resources (shared). The system needed to incorporate Wright Aero Industries unique business rules and is to be used for the solicitation, requisitioning, purchasing, payments and reporting of aircraft parts and components.

CIBER Inc., Honolulu HI Feb 2009 – Jul 2013

Principal Consultant Federal Financials for Procure to Pay (P2P)

Hawaii Department of Transportation-Highways (DOTH)

Responsibilities:

Responsible for providing Oracle Purchasing, iProcurement and Payables definition and guidance to subject matter experts (SME’s) in support of the implementation of a full-cycle financial application using encumbrance accounting.

Designed and developed a method for capturing PCard project related requisition transactions within iProcurement. User would only need to enter the project related attributes on the iProcurement web page. When saving the requisition, GL attributes would be automatically generated. Upon final approval, of the requisition, the Purchase Order would be automatically created and a ‘Pay on Receipt’ process was invoked. Existing Oracle Summary forms would be used to aid in the reconciliation process. OA Framework was used to provide default values, adding supplementary fields, mandatory data inputs, and adding of hyperlinks to zoom to customer related forms.

DOTH maintained contracts which required to have separate encumbrances and disbursements for state (20%) and federal (80%).

Developed a method to capture oil and gas prices and history using Oracle Pricing functionality. Developed an alternative method for creating credit card transactions which used project accounting.

Actively involved throughout the entire project implementation life-cycle. My responsibilities were to meet with subject matter experts (SME's) to review to their current (as-is) process flows, prepare new (to-be) process flows, reviewed their requirements document, prepared a gap analysis where Oracle did meet their requirement, discussed optional remedies to help resolve the gaps, prepared detailed functional specifications for any required new reports, interfaces, conversions, and extensions (BR050), prepared a configuration (setup) document (BR100), setup each individual modules, setup descriptive flexfields, and form personalization’s, functional tested the modules, prepared unit and system test scripts (TE020).

Assisted the SME's to help test all of their requirements. Retested functionality when required.

Resolved any remaining open issues. In addition, I worked with the developers to review, debug and retest their programs.

Worked with Oracle Support to resolve any Oracle software issues.

Trained end users to navigate and process Requisitions, Purchase Orders, Receipts and Invoices. (Oracle Release 12.1.3)

SRA International Inc. Falls Church VA Sep 2005 – Jun 2008

Manager/Member of Professional Staff/Principal Consultant

Clients worked for:

Accenture (USAF) - Wright Paterson AFB, OH

Federal Aviation Administration (FAA) – Oklahoma City OK and Fair Lakes VA

Responsibilities:

Responsible for providing Oracle Financials Purchasing, iProcurement and Payables application guidance and assistance to subject matter experts (SME’s) in support of the implementation of a global supply chain system for the USAF. Received commendation from USAF Logistics Transformation Office. (Oracle Applications Release 12.1)

Responsible for Procure to Payment (P2P) Support (Tier 2), Provided functional point of contact to help end users resolve problems related to business processes and policies, used ASSYST software to evaluate the assigned tickets based upon severity, contacted the user directly for more information, performed research/analysis into related systems (DELPHI, PRISM, etc.), ran web reports extracts and ran SQL scripts using DISCOVERER, entered detailed descriptions of findings and provided a ultimate solution to help resolve the issue. (Oracle Applications Release 11i)

Supported proposal efforts regarding Oracle iProcurement functionality. Helped prepare Fit/Gap analysis. Prepared and conducted user demonstrations of eCatalog content, attachment of item images and use of Oracle Smart Forms. (Oracle Applications Release 11i).

ORACLE Corporation, Reston VA and Denver CO Jan 1995 to Jul 2005

Clients worked for:

National Institute of Health (NIH) Reston VA

Department of Transportation (DOT) – Washington DC

Federal Aviation Administration (FAA) – Oklahoma City OK

Department of Energy (DOE) - Los Alamos National Laboratory – Los Alamos NM

Sandia National Laboratory (SNL) - National Laboratory- Albuquerque NM

Department of Defense (DOD) – Kelly AFB San Antonio TX

Defense Logistical Agency (DLA) – Ft Belvoir VA

Social Security Administration (SSA) - Baltimore MD

Western Area Power Administration (WAPA) – Denver CO

Data General- Westborough MA

Woodward Clyde Engineering - Greenwood Village CO

Ralston Purina –St Louis MI

Responsibilities:

Responsible for coordination of project’s Service Requests (SR’s) with Oracle Support. Monitored the SR’s using Oracle Metalink. Worked with project team to resolve and help test the open issues. Provided bi-weekly status to project management. Escalated SR’s to Oracle Duty Manager when required. (Release 11i).

iProcurement (iPO): loading of items and item categories using Oracle Smart Forms, bulk loader, mapped iPO categories to PO categories, built category hierarchy, and loaded item images. Prepared Oracle AIM: BP080- future process model, BR100-iPO setups and TE040 test plan. Tested application to conform to user requirements. (Oracle Applications Release 11)

Purchasing (PO): Provided functional leadership of the purchasing team in support of resolving production issues related to the Requisition to Payment, Procure to Pay and Requisition to Receipt process flow for direct and indirect material. Reconciled differences between General Ledger (GL), Accounts Payable (AP), and Purchasing (PO). Utilized USSGL transaction code functionality to generate Encumbrance Accounting GL budgetary debits and credits. Worked with Oracle Support to resolve issues and provided detailed instructions and explanations regarding Oracle 11 functionality. Used Oracle workflow functionality to drill-down and locate lost or misplaced documents. Performed SQL queries against Oracle tables using SQL*PLUS, DISCOVERER and QUERY BUILDER. Received commendation letter from DOT Director, Office of Budgets and Finance (Oracle Applications Release 11i).

Purchasing (PO): Functional leadership for the conversion of client legacy data to Oracle Federal Financials Release 11 in support of the multi-org (MO) deployment of three different Federal agencies for the following data objects: Suppliers, Customers, Employees, Requisitions, Purchase Orders, Receipts and Matched and Unmatched Invoices. Recommended process changes to client Requisition to Payment flow. Additional tasks included the creation of financial reconciliation reports and ad-hoc query reports using QUERY BUILDER and SQL*PLUS. (Oracle Applications Release 11i)

Purchasing (PO): Provided functional leadership for the development for an Obligation-Interface (OI) system. The OI system provided a user-friendly capability to automate the interfacing of all types of Federal obligating documents from their external legacy systems into Oracle. This included both initial obligation and subsequent amendments/revisions to the obligation. This required the setting up of Purchasing (PO), Accounts Payable (AP), General Ledger (GL), and Project Accounting (PA) in a Rel11 multi-org (MO) environment, and the mapping of all legacy purchase order data attributes to the Oracle tables. My extensive knowledge of the Oracle tables and associated SQL table joins shortened the project life cycle for these required tasks. Additional tasks included the testing of federal legacy data conversions, interfacing of obligation changes and providing post implementation support. (Oracle Applications Release 11i).

iProcurement (iPO): Provided leadership for project management of three functional/technical consultants. Project was implemented using internet (iPO) requisitions and receiving, encumbrance accounting and utilized USSGL transaction codes functionality to generate General Ledger budgetary accounting debits and credits. (Oracle Applications Release 11i)

Purchasing (PO): Provided functional and technical expertise to the implementation team. Assisted on fit and gap analysis and mapping of EDI 850 and 860 interfaces.

(Oracle Applications Release 11).

Purchasing (PO): Completed full project life cycle using Oracle AIM methodology. Developed user questionnaire, conducted user interviews. Deliverables included quality plan, process flows, gap and fit analysis, system sizing, and set-up documentation (BR100). Conducted Conference Room Pilot (CRP), Proof of Concept (POC) demonstrations, prepared user test scripts, conducted user testing and training, production migration, and provided on-going production support. (Oracle Applications Release 11)

Pricing: Set-up and implemented Oracle Financials. Completed full project life cycle using Oracle AIM methodology. Implemented a price escalation methodology using Oracle Order Entry core functionality. Set-up pricing formulas and pricing attributes. Trained users to use functionality. Mapped Oracle data tables/attributes to legacy tables in support of conversion activities. Developed ad-hoc reports using SQL*PLUS. (Oracle Applications Release 11)

Technical: Provided technical support for the mapping of client items, categories, suppliers, requisitions, and purchase order data attributes to Oracle 11i tables. Assisted the technical team in support of the design and coded phases. Prepared test scripts and performed unit and system testing. (Oracle Applications Release 11).

Purchasing (PO): Setup and implemented Oracle Financials. Mapped client data attributes to Oracle tables to support conversion of purchasing, receiving and accounts payable data. Determined table/column joins, developed and prepared complex scripts using SQL*PLUS, performed unit tests and debugged programs. (Oracle Applications Release 10).

Purchasing (PO): Contract Consultant. Integrated Oracle Purchasing in conjunction with existing General Ledger and Accounts Payable modules. Prepared user requirement documents. Setup application, conducted user training, and provided on-going production support. Prepared complex reports using SQL*PLUS. (Oracle Applications Release 10)

Purchasing (PO): Designed interfaces with client MRP, accounting and supplier systems. Conducted user interviews, prepared user requirements specifications, developed conversion plan for legacy system. Performed full application set-up of Oracle Purchasing, which included: accounting rules, financial and purchasing options, key and descriptive flexfields, value-sets and segments. Setup user profiles, employees, jobs, positions and approval hierarchies. Prepared quality assurance test scripts, conducted user tests, and performed follow-up testing, acted as systems administrator. Conducted user training for requestors, buyers, purchasing manager and system administrators. Provided production support for end users. Prepared complex ad-hoc reports using SQL*PLUS. (Oracle Applications Release 10).

Purchasing (PO): Helped prepare original proposal in conjunction with the marketing and sales departments. Prepared written responses relative to clients RFQ and BAFO. We were awarded the contract. This was an important win for our practice. Assigned as administrative project manager under the direction of the project manager, in addition to my responsibilities as the purchasing lead for the implementation. Additional duties included preparation and maintenance of the project plan, status reporting, tracking of time and expenses for a project staff of ten consultants. (Oracle Applications Release 9).

Contact this candidate