Sign in

Project Manager Oracle

Wheat Ridge, Colorado, United States
April 22, 2012

Contact this candidate


*** ****** **

Colorado Springs, CO *****

Cell (719) ***-****


A highly skilled and innovative seasoned professional with significant experience in the areas of comprehensive/challenging complex endeavors, understanding and creating and implementing business processes experience in following Oracle applications OM, Pricing, Configurator, MFG (INV, BOM, WIP, MRP, ASCP, PO), Oracle Discoverer and OBI technical support management, project management, software application support, manufacturing and materials management, configuration management, system maintenance, database maintenance and development, tiered escalation process, critical situation management, and customer facing problem resolution within SLA. Key attributes include outstanding leadership, advanced technical expertise and proven analytical abilities. A successful and progressive technical career has contributed to a strong record of excellence and acknowledgment for “getting the job done.”


SafeNet INC. Belcamp, MD (01/12 to 04/12)

R12 E-Business Suite Functional Consultant (project will be complete 15/Apr/2012)

Migrated Government Souition to Oracle R12 E-Business Suite applications.

Business requirement review with business and complete GAP analysis for the system requirements and recommendations that will be implemented.

ICX/PO - Setup and Test Approval process for Requisitions and PO's

Update process to allow all purchasing requisitions line-level fields to flow over to PO upon auto-creation.

Enable tax eligibility on PO lines level and confirm total tax is calculating correctly on PO

Setup and test stocking and receiving process (including Return)

Setup supplier, items, vendors and customer data field Mapping

OM – Complete setup and test external drop ship process

Configure and test standard shipping process using bundled parts and standard parts

Setup and test pricing for KIV7M product line (price lists, qualifiers etc)

OM Processing changes based on review session with users (COMSEC/DODAC hold, customer primary indicators, ship to instructions, customer part number)

Setup & test OM transaction types for Invoice-Only and Internal drop-shipments (including invoice # generation)

Address OM gaps (additional SO DFF's, compile list of standard reason codes, setup/test interdependencies on SO DFF's)

Update CRM process flow diagram with RMA and warrant include repair setup and test.

INV - Setup and process transactions using sub-inventory locations, cross refinance and substitute item receive and order. processing

Item setup and process transactions using sub-inventory locations

Setup and test serial number control setup with warrant and expand service

Setup and test pricing for KIV7M product line and able to test drop ship, return and tracking warrant and service.

Modified few FFD to fit business require.

BOM - Setup bundle, ATO, PTO and standard bills for testing business processes (including NSN#, CLIN# and ACR#)

Setup remaining data for end-to-end demo (price lists, Drop ship, RMA, PO and project with CLIN number)

Demo and user training - Conduct end-to-end demos with business users in Torrance CA

Provide user training and support UAT.

Integra LifeSciences. Plainsboro, NJ (12/11 to 12/11)

WMS/INV Functional Consultant

Migrated Ascension Orthopedics legacy system into the Integra LifeSciences Oracle 11i (11.5.10). ERP application.

Project was Ascension Orthopedics legacy part move to Integra LifeSciences Oracle ERP system. Legacy part number has long then Oracle part number (long then 12 characters).

Convert and mapping legacy part to Oracle ERP 11i application and make sure all the part able to process through Oracle ERP application such as OM, Pricing, PO, INV, AR, Shipping, Receiving, and WMS.

Complete GAP analysis for the system requirements and recommendations that will be implemented Ascension Orthopedics legacy part number.

Ingersoll Rand. Colorado Springs, CO (2005 to 2011)

Lead Oracle Application Functional Support

Primary respondsible for support Oracle 11i (11.5.10) application day to day business with CR (change request managerment), BI (Discoverer and report tools) and help desk ticket.

o CR review board member.

o Managed 6 member team responsible for delivering technical solutions to internal customers.

o Responsible for technical and functional issue and problems.

o Responsible for (Discoverer, MRP, WIP, WO, PO, BOM, OM, ASCP, Configurator, Discrete Manufacturing, Advance Pricing, Cost management, and INV help desk tickets and deliver resolutions/solutions within SLA (avg 95.5%).

o Responsible for Shipping (WMS) help desk tickets include Climate control sector deliver solutions within SLA.

Responsible for Oracle Discoverer report Administer and developer (180 users).

o Responsible for Help Desk Tickets and deliver solutions within SLA.

o Responsible for user training and training manual.

o Responsible for system admin with add and remove users.

o Responsible for develop, link and create new view for end user

o Responsible for develop report for business require.

Responsible for purge and archive production database.

o Responsible for all the production database purge and archive (4 different databases).

o Use Informatica applications.

Project Complete

Migrate legacy businsess system into the Oracle 10.7 application to security & Safety sector. Responsible for defining implementation strategy, training and communications to senior managements include develop data loader, data mapping and convert data into Oracle.

o Use Project Solution Methodology (PSM) to facilitate the conversion.

o Data mapping for legacy data (MAX System) invenotry, BOM, PO, OE and WIP module.

o Convert legacy master inventory item list and export to Oracle.

o Develop Orde Eentry export procedure and export data into Oracle.

o Develop user training manaual for BOM, WIP, ASCP and PO.

o Define BOM and implement ATO, ATP, and CTO,

o Develop data loader to upload legacy data.

Finished Lean 6 sigma Green belt and currently working black belt.

o Responsible for Lean Manufacturing, 5 day factory, and 40 turns.

o Responsible for reduce inventory down to 20%.

Migrated Oracle 10.7 to 11i upgrade project Include Canada and Mexico.

o Responsible for implement OM, Service Contracts and Installed base, BOM, WIP, Inventory and MRP.

o Responsible for data mapping for item master, supplier, and customer (MDM).

o Responsible for BOM conversion to 11i.

o Develop user training script for OM, BOM and Inventory.

Managed the Remedy help desk system software for all the sectors.

o Responsible for defining implementation strategy, training for Security & Safety sector wide.

o Developed daily, weekly and monthly status report for IT lead ship group.

Conduct SOD (Sarbanes-Oxley compliance) both 10.7 and 11i audit.

o Develop guide line and procedure for conflict with application and database access.

o Review User access with conflict problems and developed procedure.

o Review application none access user (user last access older than 90 days) and disabled user account or responsibility.

o Review database none access user (user last access older than 90 days) and disabled user account or database roll responsibility.

o Review system none access user (user last access older than 90 days) and disabled user account.

Conduct Informatica Application ILM data archive project.

o Archive oracle 10.7 to improve system performance and reduce MRP runtime.

o Reduced MRP run time by 4 hours daily.

ORACLE Corporation. Colorado Springs, CO (1997 to 2005)

Senior Technical Support Manager / Project Manager / Technical Team Lead

In depth understanding ORACLE Architecture and Functionality (Functional and technical) for following ERP modules Order Entry, Oracle Management and Configurator, Order Import (EDI), BOM, WIP, Inventory, MRP, Shipping Execution, Advanced Pricing, Purchasing, and AR.

In depth understanding ORACLE Architecture and Functionality (Functional and technical) for following CRM modules Sales, Service and Demand.

PLSQL to developed data fix script and troubleshooting scripts for customer’s need.

On-site customer Project

o Gates Rubber Company, Denver, CO

• Review Business Process or Product Lines that are applicable for Configure-to-Order process

• Configure and setup Oracle Configurator and Configurator Developer

• Configure and setup OM, INV, BOM, WIP, Advance Pricing, Shipping Execution, Supply Chain modules for Order-to-Cash processes validation and for Conference Room Pilot

• Design and restructure BOM’s, Routings, and Planning bills.

• Design Pricing structures base on Customers, Finished Goods, promotion, exceptions, etc. using Oracle Advance Pricing

• Build Configurator and multi-instantiation models, define rules/constrains, build various version of User interfaces used for configuring customer orders

• Execute ATO/PTO products fulfillment based on various business scenarios/processes

• Design and implement Functional Companions for capturing product specifications

• Define and execute change of sales orders (RMA) for ATO models

• Develop scenario/scripts for Conference Room Pilot and preparation for going live.

• Identify and Resolve TARS.

o Lucent Technologies Inc, Murray Hill, NJ

Help Order Management Application performance turning.

o Evans & Sutherland INC, Salt Lake, UT

Help install MFG applications (11.0.3) OE, INV, WIP, BOM, and MRP application.

Operational processes evaluation, process model development & simulation, performance analysis and consulting for process improvement

o GE Medical Systems (GEMS), Milwaukee, WI

Educated GEMS project leads of Oracle Configure-To-Order (CTO) solution including concept of Assemble-to-Order/Pick-to-Order (ATO/PTO) models, items, and Bills of Materials; process flow from taking sales order, configure product, production, shipping and invoice; Identified and mapped out business units in GEMS that are suitable for CTO pilot project (XRay business unit); Mapped out CTO/ATO/PTO solution with GEMS legacy ATO system in preparation to phase it out; Offered solutions to restructure GEMS’ marketing bills, production bills and their conversion process to conform to Oracle BOM structure and “CTO-able”; Provided alternate Order-to-Cash solutions in the degree of utilizing the Configurator (including creating some table and SQL codes for order importing from GEMS legacy OE); Prepared and data setup for Conference Room Pilot of the XRay product. Oracle applications modules utilized: Inventory, Bill of Materials, Order Management (Order Entry, Pricing, and Shipping), Work in Process (Discrete Manufacturing), Account Receivables, Supply Chain Planning, Purchasing, and Workflow.

ORACLE internal project

o Oracle HQ with the Development Teams:

Configure to Order (CTO R.11i): Worked closely with the Development team to QA/Testing CTO prior to software release. This role involved the integrated functionally of CTO such as: Enter and Configure Sales Order (Selling Point), Match and Reserve, ATP/Schedule Sales Order, AutoCreate Configuration, Forecast, load MDS, run MPS/MRP, AutoCreate FAS, Release Planned Order, WIP Complete to FGI, Pick & Pack, Ship Product. Various scenarios were tested, based on the combination of single/multiple of bill of material, single/multiple of sourcing organizations.

o Self-Service Web Applications:

Member of the Oracle team to test the Oracle Self-Service Web Applications (Common Modules, Web Requisition, Web Supplier) the role involved testing the functionality of each modules, integration functionality between the web applications and the core applications, and workflow.

o Conduct BUG RCA (root cause analyst) project.

o Develop WEB base application with ORACLE internal use tool.

o Discoverer 4.1 and WEB interface to publish report at internal WEB (real time).

o Conduct BUG review process and procedure project.

o Support engineer to provide all the require information for BUG and other information.

o This project improved BUG quality and reduced backlog.

Help customers custom reports and forms modification and development Using Developer 2000, PL/SQL, Sqlplus.

24x7 duty manager pager responsibilities.

Leadership to the team in tar resolution, tar quality and day to day operations.

Lockheed Martin, Inc. Colorado Springs, CO (1996 to 1997)

Lead Senior Software Development Engineer

Led the Satellite development team, substantial expertise across the full system life cycle development spectrum including software analysis, design, development, support, and testing. Significant experience managing and leading a team of technical professionals on the following projects and application support efforts: IMB/MVS base (JOVIAL/JCL) satellite communication control application and GPS.

Digital Equipment Corp. Colorado Springs, CO (1983 to 1996)

Senior Project Manager/Senior Principle System Specialist

Managed multiple projects coordinating simultaneous software and hardware development efforts such as, i2 (Intelligent Planning and Scheduling System) Project, Quantum System and Database Split Project, Penning Malaysia Project, and Database Clean-up Project. Responsibilities included: project planning, design/architecture, development, team coordination, and supervision of project staff.

Principle System Specialist

Coordinated and directed the efforts of a large cross functional group composed of the following: information systems, manufacturing, and production support teams. Responsibilities included requirements gathering for the MRP system, bill of materials creation, inventory controls, shop floor controls, field service logistics, label generation software, incoming quality control system and production cost accounting. Trained users in use of the system for increased job effectiveness. Designed and developed reports using SQL. Performed system support for manufacturing operations and information systems.

Failure Analysis Engineer II

Provided analysis services for products and partially processed materials to enable the identification of the root cause of yield and reliability issues. Responsible for schematics, diagrams, written and verbal fault descriptions, layout of defined test plans, and integrated circuits trouble shooting. In addition, performed operation and fault isolation on integrated circuits to determine the root cause of the failure. Developed a successful cookbook for FA technicians to utilize for root cause and failure analysis.


Applications • Oracle Applications System Administration

• Define Flexfields

• Define Flexbuilder Rules

• Oracle Workflow Release 11

• Oracle PL/SQL

• JAVA Programming

• Discoverer • Developer/2000

• Oracle Designer

• Developer/2000 Reports

• Oracle Manufacturing Technical Foundation

• Unix Administrator

• Oracle Order Management


MS application MS Office Pro

MS Project

Outlook Express MS Publisher


Microsoft FrontPage

Databases Oracle 7i, 8i, 9i and 10i

MS Access


TOAD Crarion,



Operating Systems MVS



NT3.5 and 4.0 WINDOWS (98, 2000

Windows XP

Window 7

Network TCP/IP DEC Pathwork Excursion DECnet

Others SQL


SQL*Loader FMS

Datatrieve DECform





Languages C


Pro*C Visual BASIC



FORTRAN 77 Turbo Pascal



Engagement Expertise Applications Implementation

Applications Development


Education • B.S. Computer Science Colorado Technical University Colorado Springs, CO

• Electronic Engineering Technology Pikes Peak Community College Colorado Springs, CO

Training • Oracle eBusiness Suite, release 11i & Distribution & Manufacturing Applications

• Oracle Workflow, Oracle Configurator

• Oracle Applications Implementation Methodology

• Oracle Self-Service Web Applications

• Oracle Advance Planning and Scheduling


• Oracle Report

• APICS Certification Program

• Security Clearance (in active)

Contact this candidate