SUMMARY:

• Twenty plus years of experience in IT with more than 15 years of experience with Oracle EBS as a Technical / Functional analyst working with versions 10.7 NCA, 11.0.3, 11i and R121.1 through R12.2.6. Technical expertise includes INV, BOM, WIP, PO, SCP and full working Knowledge of AP, AR, GL, OM, SLA methods and Oracle Project Management. I have Functional expertise to gather requirements, make recommendations and design/build the desired customization.
• I have vast experience with projects ranging from implementations, migrations, upgrades, plant level roll - outs and support projects.
• I am experienced with full project life cycle. I can lead teams of developers to deliver solutions on time. My vast experience shows my versatility and ability to deliver solutions within the Oracle EBS suite of software.
• Proficient in SQL, PL/SQL, Forms 4.5, 6i and 10g, Reports 2.5 and 6i (Developer 6i), interfaces, and customization through Extensions (Including Custom PLL, Sql Loader, Using API’s, procedures, functions and triggers with deep experience with Manufacturing APIs (Items, BOMs, Routings, Categories).
• Strong knowledge using XML publisher, Bi Publisher (Discoverer). OBIEE, BI Analytics for Financial and Supply chain Order management V7.9.6.1, V7.9.6.2, v7.9.6.3

TECHNICAL SKILLS:

RDBMS: V7.1, 7.2, 7.3, 8.0, 8i, 9i, 10g and 11g

Application: Server 9iAS, 10GAS

Oracle Applications: 10.7NCA, 11.0, 11i, R12.04 and R12.2.6 PL/SQL, SQL*Loader, SQL*Plus, Forms 4.5, Forms 6i, Reports 2.5, Reports 6i, TOAD, UNIX Scripting, XML Publisher, BI Discover

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• I am the Technical lead on this project, leading a team of 3 - 5 off shore developers. We are implementing Oracle R12.2.6, full suite (procure to pay, order to cash, supply chain, Inventory, Shipping, GL and configurator. I am responsible for design and build of all RICE object including data conversion, interface process and reporting including XML Publisher reports for all customer facing documents (Sales Order Acknowledgment, PO Print documents and Shipping documents). I also am the Techno/Fuctional lead responsible for building a Warranty and Service application for the client. This process will include utilizing APEX development tool, custom tables and XML Publisher to generate tracking reports for Senior Management.

Confidential

CO lead Functional Lead

Responsibilities:

• I also, was the technical Lead on the project, managing CEML (RICEW) development. I lead a team of 4 off shore developers. The development effort was across all modules with the main focus on Shipping, Purchasing and Inventory. There was some effort in modifying XML Publisher customer and Vendor facing documents, PO Print, Sales Order and Acknowledgements and Invoices. All these reports were developed with XML publisher using either SQL queries or PL/SQL to build the xml data source.

Confidential

Responsibilities:

• Praxair provides surface coating of various parts. They are an outside process vendor for both military and commercial aviation as well many other general industries. My role here is to back fill current staff in the development of custom reports and forms to aid the manufacturing facilities interfacing with Oracle. Currently they are on 11i, this is prep work for a move to R12. I developed multiple reports using XML publisher. These reports were complex layouts with multiple sub templates. I used XML publisher logic to select the correct sub template to apply based on data conditions in the XML file.

Confidential

Responsibilities:

• Veritiv is a manufacturer of packaging materials. My role on this project is to maintain interfaces between their legacy payroll and financial systems and Oracle EBS R12.3. Veritiv had multiple systems that were used for recording financial information and time and attendance. The interface program had to import data into GL and also extract data and format data from GL tables to import into legacy systems. This is purely a PL/SQL opportunity in the financial space utilizing GL financial interfaces and tables.

Confidential

Responsibilities:

• Confidential is a repair company of railroad cars. The project consisted of modifying the GL reports to include vendor and inventory data on the report in R12.3. The client was moving from Oracle 11.i to R12.3 and wanted to have the R12 GL balances report contain the detail that they use to get out of the R11.i report. The problem was in R12 the detail was moved from the General Ledger to Sub Ledger accounting. The GL balances detail report did not capture any Inventory or Purchasing information. I had to modify the report linking the GL (General Ledger) tables to the XLA (Sub-ledger Accounting) tables in order to pull in the required purchasing and Inventory information including Supplier number and Name, Receipt number and line numbers.

Confidential

Responsibilities:

• Derco is a manufacturer of aircraft components for the C130 and F16 military aircraft. My role is to support IT department in cleaning up a backlog of change requests. This roll is strictly SQL and PL\SQL data base work. The software package they are using is called IFS.

Confidential

Responsibilities:

• Confidential Inc. is a manufacture of brake components. Confidential is in the process of converting from 3 legacy systems to Oracle R12. My roll on this project is data conversion of the inventory stream data including (Items, Bills of Material, Routings, UOM conversion factors, Inventory Locations, Customer cross s, Item Cross s, Item Costs, Primary Inventory Locations). This task also, involves advising and guiding the client developer in developing extract SQL code from the legacy systems. As part of the data conversion process I designed and created multiple Inventory reports to help with validation of data. The most critical of these were the on hand balance and Cost reports since we were pulling data from 2 distinct and separate systems.
• I designed 3 forms that were used by the receiving department to return brake part cores from auto part stores. The first was a check in form that allowed for multiple entries into a custom Oracle table as the first step of the return process. This form allowed the receiving clerk to quickly get the data into a database for further evaluation prior to doing a receiving transaction into Oracle EBS. The second screen was a validation form that allowed the user to validate the added records in the custom table against Oracle EBS data. This form the marked the valid records to be process into Oracle EBS and marked all invalid records so that a report could be generated. The third form allowed the receiving clerk the ability to batch process the valid records into Oracle EBS using miscellaneous receipts interface, this was used instead or receiving transaction due to the fact that there was nothing to actually receive against, the inventory just needed to reflect the returns. This was using Forms 10g which functions similarly to form 6i.

Confidential

Responsibilities:

• Confidential is in the process of bringing there Aftermarket business onto Oracle 11.5.10. I have been assigned to automate the PO Quotation load process, Creation of ASL in the purchasing module. The PO quotation process was used for all new PO quotations, the buyer would submit an excel spreadsheet with the new PO quotes and run an import process into a custom staging table. Once there a PL\SQL Package was run to validate the records inserting the valid records into the interface table and marking the invalid records to be reported back to the Buyer responsible. Once the PO Quotes where loaded a PL\Sql package was run to create missing ASL records using the ASL API or to update data with the new PO quote number.
• I have been assigned to interface an external order entry system to Oracle Order Entry using Oracle Order Import Interface. This package took an external Sales Order system data and validated it against Oracle. If the items where valid then the Order Import interface table was loaded and sales order interface was run. If there were any errors that resulted from the import. I trained the users to use the Oracle Interface errors screen to correct and reprocess any data that failed to Import.
• Working on a procedure to update data loaded into the Auto invoice interface table, to add external freight charges and updated certain data elements prior to auto invoice running.

Confidential

Consultant

Responsibilities:

• Project Management package: CAP has an initiative to replace their current Project Management system with Oracle Project Management. This was not Oracle Projects but Project management. The package worked similar to Microsoft Projects. I am building a process to automate the creation of new projects on a daily basis utilizing external data, project templates and past projects. We are using the Project APIs to create the Project, assign roles, assign people to the roles and approve.

Confidential

Techno-Functional Support

Responsibilities:

• Wrote multiple PL/SQL procedures to expedite data loading/updating for, Price Lists, Item lead times, Routing structural changes.
• Price list changes where done using the Price list API to add the new pricing to the price list table.
• Item Lead time updates where done using the inventory item interface program.
• Any changes required for Routings where done using the Routing interface.
• Working with users, in the Auburn Hills, Michigan facility, to improve manufacturing processes, with the goal of improving plant efficiency and on time delivery specifically around planning and scheduling.
• I helped planners to switch from using Min Max planning to utilize Supply Chain Planning from both a functional and Technical perspective. This saved the planners several hours of time managing the work load.
• Created document on how to create Return to Vendor and Rework processes.

Confidential

Technical lead

Responsibilities:

• I created the functional design of OBIEE reporting project for supply chain. Vectren supply chain has a 3 - 5 year goal to reduce Non Po spend to virtually zero. We designed a reporting process around AP invoices PO and Projects to help the Director of Supply Chain analyze his spend and react accordingly. There is a requirement to control spend with multiple vendors, so we designed a system that would allow Purchasing to source vendors using the OBIEE functionality.
• This project was a total custom, creates several views to mimic a Star schema in order to allow drill down reporting within Oracle OBIEE. The client would now allow us to actually create a data warehouse so we needed to create a faux data warehouse using the views. These views were incorporated into Informatica mapping and then we were able to create the necessary reports using OBIEE. By doing this we were able to create dashboards for the Purchasing Director to help him manage Purchasing spend especially where there a PO was not created.

Confidential

Senior Consultant

Responsibilities:

• Implementation of BI Financial and Supply Chain Order management Analytics 7.9.6.3.
• Implementation of BI Procure and Spend and Supply Chain/Order management analytics 7.9.6.3
• Data conversions for BOM, Routing On-hand inventory, Purchase Order, Sourcing Rules, Assignment Set, Approved Supplier List and Budgets.
• Created a real time Sales order summary screen that Senior Management will use to monitor Sales on an on demand basis. This was both the Functional and Technical design phases of this screen. This screen was designed to provide sales analytics to the Owners of Handi-foil. Handi-foil had a requirement to have this screen refreshed every 30 seconds. We were not able to do this requirement but we were able to performance tune the form to return data within 15 seconds when a refresh button was pressed.
• Responsible for setup of BI Analytics 7.9.6.2 for Financial and Supply Chain / Order Management.

Confidential - Oshkosh, Wi

Responsibilities:

• Onsite help desk for EBS 11.5.10 in all functional areas of the business including Finance, Purchasing, Engineering, Manufacturing, Order Management and Shipping.Liaison between Oshkosh office staff and the offshore development teams in India and China.

Confidential

Oracle EBS Administrator

Responsibilities:

• Confidential is a light manufacturing company that makes custom watering solutions for Research Laboratory Animals. This including automatic purified watering systems that delivered water on demand to the animals. The system included piping and Reverse Osmosis water purification.
• As Oracle EBS Administrator I was responsible for EBS full suite of modules including
• Order to Cash, Procure to Pay Manufacturing Supply Chain and Financial (GL and SLA). This role was 100 percent Functional and Technical supporting 200 users. These duties including supporting the Finance Department, Order Management Department, Purchasing Department, Manufacturing Department, Shipping and Receiving Department and Quality Department.
• Financial duties included running the SLA interface including (AR, AP, WIP, Inventory modules to GL) and troubleshooting any interface error including corrections, so of which were done on the Backend using PL/SQL procedures. Also helped and trained the accounting department on how to use SLA helping them reduce month end close from 2 weeks down to several days.

Confidential - Cincinnati Oh

Responsibilities:

• Phased implementation of R12 Second phase consists of Order Management, Quoting, Inventory Purchasing, Manufacturing, Engineering and Quality Control.
• Technical lead on the implementation to include all RICEW (Reports, InterfacesCustomizations, Enhancements and Workflows), also known as CEMLI (ConfigurationExtension, Modification, Localization, and Integration).
• Technical lead, responsible for correcting a failed Financials implementation from a
• Previous consulting company. There were requirements to adjust cost accounting and work with EBS tax solution.

Confidential - Cincinnati Oh

Consultant

Responsibilities:

• Phased implementation of R12 OPM. First phase consists of Demantra, ASCP, Financials, OTM (G-Log). Conversion of Item Information, Planning interfaces.Assisted with Item and BOM Conversions.
• Converted Categories and Category Assignments.
• Converted Routings.
• Converted UOM Conversions.
• Developed On-Hand Quantity interface into Planning Tools
• (MSC Schema) using flat file interface capabilities.
• Developed Production Schedule interface from MSC as fed by Production Scheduling.
• Responsible for providing Item Master to Confidential personnel.

Confidential - Grafton Wi

Responsibilities:

• Migration from a legacy system to 11.5.10, migration from ASI to 11.03, upgrade from .5.10. Production support of the manufacturing modules.
• Order to Cash Team, information primarily responsible for loading Item Information including: Bills of Distribution, Assignment Sets, Routings, and Inventory Locations.
• Member of Procure-to-Pay implementation team. The team is charged with installing two acquisitions from GE on to Oracle Purchasing 11i. Both functional and technical team responsibilities.
• Chair a manufacturing problems focus group. The group works toward solving/heading off problems with the manufacturing systems from planning to work order completion. This was a functional advisory role to Planners, buyers, inventory control and Manufacturing leads.
• Part of a team converting 6 manufacturing plants from ASI to Oracle Apps 11.03. Assisted in converting data including Item Master, Revisions, Bill of Materials, Routings, Suppliers, and Purchase Orders (Standard and Blanket).
• Functional lead of converting from running MRP 6 times a night to a single Supply Chain Planning run cutting the run time from 6.5 hrs to 2 hrs.
• Developed an Expected Receipts interface Between WILMA, a homegrown warehouse management system and Oracle 11.03.

Confidential - Racine Wi

Responsibilities:

• Responsible for mapping Purchasing data from ASK MANMAN manufacturing system to Oracle Apps 11.03. Including Suppliers, Open Purchase Orders (Standard and Blanket), Quotations, Approved Supplier Lists, Sourcing Rules.Responsible for loading the extracted data from the legacy system into Oracle.

Confidential -New Berlin Wi

Responsibilities:

• Responsible for all Data conversions from ASK to Oracle Apps 10.7. This included Item Masters, On hand inventory, Bill of Materials, Routings, Purchase Orders, Sales Orders, Work Orders and Open accounts receivable invoices.
• Assisted in maintaining the ASK manufacturing system. Trouble shooting various problems in Sales, Manufacturing and Accounting departments.

Confidential- Brookfield WI

Consultant

Responsibilities:

• Developed a serial number tracking system to work with AMAPS/3000 software.

Confidential - Waukesha Wi

Responsibilities:

• Assisted in maintaining MRPII manufacturing system and provided various reports to user community.
• Created an ECO system saving the company about $15,000 in ECO maintenance per year.

Confidential - Milwaukee, WI

Health Insurance Provider

Responsibilities:

• Maintained current system for managed health care using JBI software package.
• Organized and supervised a group which modified provider payment process reducing processing time from 24 to 15 hours.
• Created a Voice Response System providing providers with Confidential t information.
• Maintained programs on IBM mainframe using TSO, IDMS, and Cobol.

Confidential- Milwaukee Wi

Manufacturer of Chemicals for Research

Responsibilities:

• Assisted in implementing a new Confidential series 52 mini computer and AMAPS/3000 software package.

Confidential -Hawthorne, CA

Manufacturer of defense systems/Aircraft electronics

Responsibilities:

• Programmed Custom reports for various departments including Inventory Control, Purchasing, Receiving, Shipping and Production Control.
• Assisted in maintaining production batch processing.