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