Post Job Free

Resume

Sign in

Oracle Supply Chain

Location:
Rancho Santa Margarita, CA
Posted:
March 01, 2013

Contact this candidate

Resume:

Howard Moore

Email: abqmv7@r.postjobfree.com

Address: ** *******

City: Rancho Santa Margarita

State: CA

Zip: 92688

Country: USA

Phone: 949-***-****

Skill Level: Management

Salary Range: $110,000

Primary Skills/Experience:

See Resume

Educational Background:

See Resume

Job History / Details:

Howard L. Moore Jr.

36 Milagro * Rancho Santa Margarita, California 92688 * 949-***-**** * abqmv7@r.postjobfree.com

Technical Lead/Developer

Professional Profile

I am a seasoned professional with many years of IT experience in all phases of system design,

development and implementation. My experience with the Oracle eBusiness Suite of Applications

spans sixteen years and covers Oracle Applications EBS Suite versions 10.7 through 12.1.3.

I have worked for clients within the manufacturing and financial industries as well as County

Government and the US Federal Government (DoD). I have also worked on projects for many fortune 500 companies

I am a creative problem solver, effective crisis manager and a highly adaptable and motivated team

player.

I also have the following skills regarding Oracle EBS Suite Upgrades and new installations:

I have been involved with 6 Oracle Upgrades/new installations from 10.7 Through 12.1.3

Demonstrated experience as an application technical consultant on Oracle R12 Upgrades

and new installations

Solid Understanding of the EBS technical foundation and capable of facilitating workshops to

determine requirements

Solid technical knowledge in developing CEMLI components

Strong Leadership and ability to quickly document technical specification documents

Skills

ORACLE Applications Release R12.06/12.1.3

GL, INV, Payables, Purchase Orders, Purchasing Contracts, Grants, Cash Management(CE), Projects, Oracle Assets

ORACLE Application Release 11i

ORACLE Applications Release 10.7/11.03/11.5.9

11i Oracle Manufacturing Modules: INV, ENG, BOM, WIP, QUALITY, WORKFLOW, OM, ADVANCED PLANNING AND SUPPLY CHAIN

11i Oracle Financials Modules: AP/AR, GL, HR, PROCURE TO PAY (INV, SYSADMIN, PURCHASING, AP), PA (Project Accounting)

10.7 Oracle Manufacturing Modules: SYSADMIN, INV, ENG, BOM, WIP, MRP, COSTING, OE, QUALITY

SQL*PLUS, PL/SQL, SQL DEVELOPER, JDEVELOPER, XML, TORTISE SVN/Subversion

SQLLOADER, TOAD, Erwin, Crystal Reports, Discoverer 9iAS, Data Warehousing 9i

Oracle 8.6.1/7.3/6.0/10g/11g

Developer/2000 (Forms 4.5, Reports 2.5), Forms and Reports 6i

Windows XP, Window 7, Office, Word, Excel, PowerPoint, Access, Visio, Outlook, IBM PC,

MS Project, Windows 95, 98, NT, Windows 2000, HTML

UNIX (Sun Solaris, AIX, HPUX)

Career Accomplishments

Howard L. Moore, Jr. Page 2

CAREER HIGHLIGHTS

07/12 - 09/12

Oracle Corporation

Client Site - JP Morgan Chase Phoenix Arizona

Application Express Development

Oracle Apps tech Developer

Team member assigned to assist JPMC with resolving some major performance issues with their production system

Analyzed and performed Troubleshooting on their current production system

to determine the root cause of the performance issues.

Performed Code reviews on all new PL/SQL code prior to migration into production

Analyzed database triggers in the new code

Analyzed all the DB links currently in the system

Developed code in PL/SQL and SQL to convert and transform data for Testing

The following recommendations were made as a result of the analysis:

Run explain plans on all queries, Add indexes as needed based on the explain plans

Use either Hash indexes, Bit Map indexes or composite Indexes depending

on the data in the tables

Re-write some of the code to remove unnecessary Unions, Union-Alls

Built-in Functions like NVL, TO_CHAR, NUMBER, UPPER, LOWER

Gather statistics on a nightly basis to re-index all the tables

Remove all unnecessary DB links

Remove all unnecessary triggers in the code

Howard L. Moore, Jr. Page 3

CAREER HIGHLIGHTS

12/11 - 06/12

Oracle Corporation

Client Site - AEROJET Corporation Rancho Cordova, California

New Installation from Legacy to R12.1.3

Oracle E-Business Suite GSD Technical Lead/Solution Designer for Labor Costing

This project was for Aerojet corporation. Aerojet was founded in 1942 by a small group of scientists led by Dr. Theodore von Karman,

an internationally acclaimed professor from the California Institute of Technology.

The objective of this project was to bring all the subsidiary companies of Aerojet together using 1 common Oracle Enterprise system for all their operations.

The following 8 tracks show what all was involved in this project:

A2R - Accounting to Reporting

General Ledger, Payables, Receipts, Treasury, eBusiness Tax

P2I - Projects to Invoice

Projects, Project Contracts, Project Budgets

P2P - Procure to Pay

Purchasing, Receiving, iProcurement, iSupplier, P-Card

HCM - Human Capital Management

Employees, Advanced Benefits, Time and Labor

D2B - Demand to Build (D2B)

Inventory, Advanced Supply Chain, MSCA(Mobile Supply Chain), Quality

A2M - Asset to Maintain

Assets, Install Base

B2F - Budget to Forecast (Hyperion)

Budgeting and Forecasting

OBI - OBIEE

Interactive dashboards, full ad-hoc, enterprise and financial reporting, analytics

Originally responsible for managing all the development done by the Offshore GSD team which included all CEMLI's.

I was then switched to be responsible for the Functional/Technical design of the Custom Labor Costing effort which was originally written in COBOL

Responsibilities Included:

Managed development of Conversions, Interfaces, Extensions and Modifications for all tracks excluding B2F and OBI

Developed Labor Costing Solution Design

Created Functional and Technical Design Documents

This design made use of the Rules Engine in the HCM module

To keep track of all the permutations related to the Union employees, i.e. pay grade level, skill level, shift work, lead person

Modules Used:, AR, AP, PO, Advanced Supply Chain, Mobile Supply Chain, Projects, Oracle Assets, Hyperion, OBIEE

Environment: Oracle Financials, Oracle Advanced Supply Chain, HCM, Oracle Asset Management, GRC, Hyperion, OBIEE 12(version 12.1.3),

Oracle Database 10.2g Enterprise Edition Release 10.2.0.3.0 - 64bit, PL/SQL, SQL, LINUX

Howard L. Moore, Jr. Page 4

CAREER HIGHLIGHTS

06/10 - 12/11

Oracle Corporation

Client Site - County Administration Building - San Diego, California

Technical Upgrade from 11.5.7 to R12.1.3

Oracle E-Business Suite APPS Tech/Interface Lead

For E-Business Suite Financials Upgrade from R11.5.7 to R12.1.3.

I was a member of the RFP(Request For Proposal) team and I was responsible for the following areas in the proposal:

Oracle Fusion Middleware Technical Description

Conversions/Interfaces/Reports

Research of all Technical software and tools being used

We began the project on June 10, 2010 and during development we converted about 200 CEMLI's; consisting of 50 interfaces, approx 100 reports and 50 extensions

The interfaces communicated with many external Entities such as:

Dept of Education School Districts

Banks

Sheriff's Dept

HHSA Childcare Services

BRASS(Budgeting Software)

KRONOS(Timekeeping Software)

Peoplesoft(Payroll and HR)

Superior Courts of San Diego

Property Tax Department

BUYNET - Internet Inventory

QBIS Reporting (Financial Reporting)

Responsibilities Included:

Interface Lead/Developer Managing a team of 4 - 8 people

Upgrade of 50+ Interfaces from 11.5.7 to R12.1.3

Created new design/upgrade documents for reports, extensions and interfaces

Performed testing of all interfaces on the 11.5.7 system then on the new R12.1.3 system and

Compared the results to make sure they matched and made changes as necessary

Developed a new Cash Management Process to convert client accounts from a single bank account to

Individual bank accounts for each client. This new process affected 6 of the interfaces

Re-Wrote Interfacing Claims Interface to accommodate the new TCA architecture and

Processing for Projects, Organization, Expenditure Type, Task, Award(POETA)

Team Member for the overall Technical Upgrade which included 3 Conference Room Pilot(CRP) sessions

Modules Used: GL, AR, AP, Grants, CE(Cash Management), PO, Fusion Middleware/BPEL, BI Publisher, Data Warehouse

Environment: Oracle Financials R12(version 12.1.3) Oracle Database 10.2g Enterprise Edition Release 10.2.0.3.0 - 64bit, PL/SQL, SQL

Howard L. Moore, Jr. Page 5

CAREER HIGHLIGHTS

06/09 - 09/09

Oracle Corporation

Client Site - FAA(Federal Aviation Administration)Oklahoma City, Oklahoma

Oracle E-Business Suite APPS Tech Developer

President Obama signed into law on June 24, 2009 a program NHTSA (National Highway Traffic Safety Administration) called the

Car Allowance Rebate System (CARS) "Cash for Clunkers". This was a government program that helped consumers purchase a

new, more fuel-efficient vehicle when they traded in a less fuel-efficient vehicle.

Responsibilities Included:

Designed, mapped, coded and tested the views for the suppliers and Invoices

These views were used by the SOA/BPEL programs to process the invoices for payment

Created all of the EBS code migration scripts for production

Developed a modification of the custom Funds Checking Code enhancement process which

determined if there was sufficient funds left when an invoice was being created

Selected as a Team member that worked 24 x 7 support after go-live

Modules Used: Oracle Isupplier Portal, SOA Suite/BPEL

Environment: Oracle Financials 12(version 12.06),

Oracle Database 10.2g Enterprise Edition Release 10.2.0.3.0 - 64bit, PL/SQL, SQL, LINUX,Oracle -On-Demand

09/08 - 06/09

Oracle Corporation

Client Site - AAFES (Army Air Force Exchange Services) Dallas, Texas

Oracle E-Business Suite APPS Tech Developer

The company is known as AAFES(Army Air Force and Exchange Services) and it operates an on-line store which allows members of the

active and retired military to purchase items at large discounts.

The Oracle E-Business R12 Suite was chosen for this project. Even though only the purchasing module was implemented initially, there were additional conversions

and interfaces that needed to be created because the legacy system will be operational for quite some time in the future.

Responsibilities Included the following:

Designed, developed and tested the following conversions and interfaces:

CONVERSIONS

Items and Categories

Purchase Orders

Contract Purchase Orders

Receipts

Purchasing Contract Clauses

INTERFACES

PO to EDI Interface

Oracle Debit Memo to Legacy Accounts Payable

Modules Used: Oracle Purchasing, Purchasing Contracts, XML GATEWAY, BPEL

Environment: Oracle Financials/Purchasing 12(version 12.06),

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit,PL/SQL, SQL, IBM(AIX)

Howard L. Moore, Jr. Page 6

CAREER HIGHLIGHTS

12/06 - 8/08

Oracle Corporation

Client Site - UNITED STATES MARINE CORPS USMC GCSS-MC Quantico, Virginia

Oracle E-Business Suite APPS Tech Developer

The GCSS-MC is the enterprise-wide portfolio of Marine Corps logistics and Combat Service Support(CSS) information technology capabilities.

Responsibilities Included:

Designed and Developed a new process which Synchronized the Service Contracts Module using the existing API's

Developed a new XML Schema model which defined the 10 major pieces of a Service Contract and was used to

migrate the contract from 1 instance to other instances via SOA/BPEL

Developed a similar type process for the Counters and Counter groups which were used by the service contracts module

Tested the Installed Base Module which was also used by the Service Contracts Module

Modules Used: Oracle OM, INV, BOM, SCM, PO, AP,AR, INSTALLED BASE, CRM,/SERVICE DELIVERY/SERVICE CONTRACTS, Depot Level Maintenance,

SOA Suite /BPEL, Mobile Field Service(MFS), Spares Management, Isupport

Environment: Oracle Manufacturing/Financials 11i(version 11.5.10), Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit, PL/SQL, SQL, LINUX

12/03 - 11/05

Computer Sciences Corporation(CSC), Sterling, Virginia

Senior Systems Analyst/Developer

Client Site - General Dynamics Burlington, Vermont

Oracle E-Business Suite APPS Tech Developer

General dynamics is a major defense contractor who supplies parts and equipment to the US military as well as many Fortune 500 companies.

Client was upgrading their current Financial/Manufacturing systems from legacy to Oracle Financial/Manufacturing 11i (version 11.5.9).

They were installing all the modules related to the E-Business Manufacturing & Supply Chain Management module plus Project Contracts.

Sites included; Lincoln, NE, Camden, AK, Marion, VA, SACO, ME, Deland, FL and Burlington, VT.

Responsibilities Included:

Conversions and interfaces for all 6 sites that were all currently on some type of legacy system

Developed the code and tested the conversion and interface for BOM's (Bill of Materials)

Developed the code and tested the Oracle Quality conversion for a Tool Tracking system

This included the creation of 1 Master and 5 Child Quality plans

Also included a custom Workflow for issuing notifications for receipts of Government property

Designed and Developed a new Oracle Time and Labor(OTL) custom program to allow for remote timecard entry

In a batch mode

Modules Used: Oracle AP, AR, GL, FA, PA, PO, WIP, BOM, INV, ENG, SCM, QUALITY, PROJECT CONTRACTS

Environment: Oracle Manufacturing/Financials 11i(version 11.5.9), Oracle 8i(version 8.1.7.3.0), PL/SQL, SQL, UNIX(Sun Solaris)

Howard L. Moore, Jr. Page 7

CAREER HIGHLIGHTS

Education

Education & Training

BS Information Systems Management - San Diego State University

AS Business Administration - Mesa Junior College San Diego

FUSION

Fusion Applications: Extend Applications with ADF

Fusion Middleware/BPEL

ORACLE 11i Manufacturing/Financials Training

Workflow, Order Management (OM), Procure to Pay

Advanced Planning and Supply Chain, Data Warehousing Fundamentals 9i,

Data Warehouse Database Design, Discoverer 9iAS

ORACLE 11i Projects Training

Projects Foundations Fundamentals

Projects Billing Fundamentals

Project Management Fundamentals

ORACLE 11.03 Financials Foundation

Oracle 11.03 Installing and Maintaining Oracle Applications Release 11

Oracle 10.7 Manufacturing Master's Certificate

This included 18 different classes

Master Communication Training Program - CADVISORS

Continuous Improvement Training - CIP/TQM

Structured Design, Structured Methodology - YOURDON

Full Life Cycle Software Development(SDLC)

Erwin-Data Modeling Tool

Engagement Experience

Design/Documentation

Application Development

Data Conversion

Oracle open Interfaces and API's

Database Design/Database Modeling

Test plans/Testing

Oracle AIM/OUM Methodology

End User Training

Project Management

Technical Lead

Sarbanes - Oxley

International Project Experience

Oracle Application Testing Suite(OATS)

Labor Costing Design

Professional Certifications / Classes

Level 2 Tech Lead (Oracle internal PMO Training)

Oracle OCA in PL/SQL Certification(Oracle)

Oracle 10.7 Manufacturing Master's Certificate

Completion of over 30 Functional and Technical Classes at Oracle University

Page PAGE 8 of NUMPAGES 8



Contact this candidate