Senior Consultant

Senior Consultant

Systems Analyst and Programmer with over 6 years experience, primarily in the Oracle environment Very strong in the design and development of business applications. Has extensive experience with:

· Oracle Applications 10.6/10.7 SC & Ver. 11i

· Modules: INV, BOM, WIP, AR, PO, OE, AOL, SYS ADM

· Commerce One – Buysite

· Developer/2000 (Reports 2.5)

· PL/SQL 2.x, C, C++, Visual Basic 4.0

· Oracle 7.x, 8.x

· SQL*LOADER 7.3

· SQL*PLUS 3.2

· PL/SQL

Education

· Bachelor's Degree in Information Science

· Commerce One Buysite Training

Major Assignments

As a full time consultant I was placed on the following assignments:

April 2002 – December 2002

As Technical Consultant on an Oracle 11i Implementation, for a Large Aerospace Firm, was responsible for the following:

· Designed and developed an XML Interface from Oracle Apps to ProPricer using PL/SQL packages and procedures

· Designed and developed PL/SQL packages to explode both Oracle Apps and Legacy Bills of Material

· Designed and developed PL/SQL package to automate the submission of Oracle API concurrent programs. This was used to automate the Inventory Item conversion process.

· Designed and developed PL/SQL packages to do WIP Issues and Returns via the Transactions Interface

· Developed packages to implement interface directory standards across database instances and servers

· Provided production support for the following interfaces:

Ø Oracle to ProPricer interface

Ø The PeopleSoft to Oracle GL interface

Ø The Autotime to Oracle GL interface

· Designed and developed PL/SQL package, report and audit report for Defense Priority Allocation System (DPAS) Rated items on Contracts and Sales Orders.

Ø Exploded Oracle Bills of Material for items on Contracts and Sales Orders to find purchased parts whose total lead time exceeds delivery date or whose costs exceeded $50,000.

Ø Audit report was created to show all PO’s that were made for DPAS Rated items.

October 2000 – April 2002

As Lead Technical Consultant on an Oracle 11i Implementation for Large Manufacturing Firm was responsible for the following:

· Managed technical team of five consultants

· Assigned technical deliverables to subordinate team members

· Estimated complexity and build time of technical deliverables

· Tracked expenses

· Monitored deliverable progress

· Assisted in resolution of HR issues

· Designed & built the data conversion of AR Invoices/Receipts between Oracle Applications 11.0.3 and 11i instance.

· Designed & built the Item and On-Hand Quantity conversion from 11.0.3 and Visibility (an Oracle based Legacy system) to 11i

· Designed Customer Interface between Oracle Applications 11.0.3 and 11i instance

· Migrated existing 11.0.3 AR Invoice to Internal Billing System (IBS) interface to 11i

· Designed Internal Billing System (IBS) Cash Receipt interface to Oracle 11i AR

As a full time consultant for a consulting firm, I was placed on the following assignments:

April 2000 –June 2000

As a Technical Consultant for a medium sized communications company, responsible for designing and Implementing the data conversion of orders between Clarify and Telecom Business Systems (TBS) using PL/SQL Packages and Procedures.

August 1999 – February 2000

As a Technical Consultant for I was responsible for the following activities:

· Designing data conversions for the following modules:

Ø Accounts Receivable – Invoices, Payments, & Customers

Ø Inventory – Items

Ø Accounts Payable – Supplier Invoices

Ø Purchasing – Purchase Orders

· Assisting in time estimates and project plan adjustments with regard to technical designs and development

· Educating client technical team members on various tasks of the new system

· Managing technical issue resolution

· Designing a custom interface to download data from Oracle Applications to 3^rd party package, NexGen. NexGen required data from INV, OE, AR, & PO

As a full time consultant for a consulting company, I was placed on the following assignments:

February 1999 – June 1999

As the Lead Technical Consultant for medium sized manufacturing company, responsible for the following activities:

· Supervising consultant and client technical resources

· Assisting in time estimates and project plan adjustments with regard to technical designs and development

· Facilitating technical issue resolution coordinating with technical team members the right functional/client resource

· Preparing the design documents and migration strategy for data conversions of Items, BOM’s, Routings, and Item Categories

· Coding PL/SQL Procedures and Packages for converting BOM’s, Routings, and Item Categories

· Designing a custom interface to download data from Oracle Applications to 3^rd party package, Taylor Executive Scheduling System (TESS). TESS required data from OE, WIP, MRP, BOM, and PO

June 1998 – February 1999

As the National Resource Manager for a consulting company, Enterprise Package Solutions Division, Oracle Practice responsible for the following activities:

· Understanding the technical and functional needs of requirements generated by the Account Managers

· Designing a system to maintain and track the skill sets of 270+ Oracle Applications consultants. The system also captured the business flow of a consultant from their start date at consulting company to their project roll-off. This system was then expanded to include all of the practices in the EPS division.

· Producing reports to track costs incurred by the practice for all consultants not currently on a project

· Assisting in Consultant selection and motivation

· Managing the 20 to 45 consultants who were not on a project at a given time. Decided on their course of training, work hours and days off

· Assisting Account Managers in doing Consultant paperwork

· Coordinating the project end dates between the Consultants and the Account Managers

· Insuring that all Consultant resumes were updated as soon as a roll-off date was determined

· Coordinating movement of Consultants to projects

May 1998 – June 1998

As the Technical Lead Consultant for heavy equipment manufacturer, participated in the Oracle Manufacturing migration teams’ analysis of business rules to identify Interfaces to Oracle Manufacturing’s Work in Process, Bill of Material, and Inventory modules.

April 1997 – April 1998

As a Technical Consultant for a major electronics manufacturer, participated as a member of the Oracle Manufacturing migration team in the analysis of business rules, customization of Oracle Manufacturing’s Work in Process, Bill of Material, and Inventory modules to conform to operational needs and to insure a reliable interface to the existing Oracle based Customer Order Maintenance (COM) and Bill of Materials (Configurator) systems to Oracle Manufacturing. Involved in the following activities:

· Designing and implementing an interface to generate shipping labels via EZLabel, a 3^rd party software package. Data was gathered from INV and WIP.

· Designing and implementing Customized Shop Paperwork Reports, gathering data from I2Rhythm, COM, Configurator, and Oracle Applications (INV & WIP)

· Designing and implementing Printing Tagout Slips. Tagout Slips were pegged to an individual WIP Discrete Job and printed when specific assembly types were in and out of sub-inventories during WIP moves

July 1995 – March 1997

As an Analyst for software developer, responsible for development and migration of a new version of the current software from a DOS environment to a Windows 95 environment. Provided telephone support to worldwide users of the software. Went to client sites in other cities and installed the hardware, network, and REBAR software on the premises. Involved in the following activities:

· Assisting in developing a small Work In Process database application to allow the user to assign orders of steel to a specific truck and to track the progression of the steel through the shop after its released for work

· Developing a print spooler to read specific binary and ASCII files

· Writing a program embedding functions from Sequiter Software’s Codebase product to insert, update, and delete records to Foxpro 2.6 for Windows tables from an MS-DOS program

· Writing a Visual Basic 4.0 front-end to an Access database. This program enables the users to track orders of steel on a job-by-job basis. It interfaced with Crystal ReportWriter 5.0 to generate printed reports from the database