www.jameslapierre.com
(813) 220-2323
Oracle Applications Client List
§ ADT Security Services
§ Angelica
§ ConMed Linvatec
§ Cox Communications
§ Danka Business Systems
§ DRS Training & Control Systems
§ General Dynamics Land Systems
§ Southwestern Bell Telephone
§ Thompson NETg
§ ThyssenKrupp
Industry Experience
§ Biotechnology
§ Healthcare
o Medical Appliances and Equipment
§ Industrial Goods (Manufacturing)
o Aerospace and Defense Products and Services
o Diversified Machinery
§ Services
o Broadcasting and Cable Television
o Business
o Security and Protection
§ Technology
o Information Technology Services
o Internet Information Providers
o Multimedia and Graphics Software
o Office Equipment
o Telecommunication Services
Oracle Module Experience
§ Customer Relationship Management (CRM)
o Contracts Core (OKC)
o Contracts for Service (OKS)
o CRM Foundation (JTF)
o Depot Repair (CSD)
o Install Base (CSI)
o Service (CS)
§ Enterprise Resource Planning (ERP)
o Bills of Material (BOM)
o Capacity Planning (CPP)
o Cost Management (CST)
o Engineering (ENG)
o General Ledger (GL)
o Human Resources (PER)
o Master Production Scheduling (MPS)
o Material Requirements Planning (MRP)
o Order Management (ONT)
o Payables (AP)
o Payroll (PAY)
o Project Manufacturing (PJM)
o Projects (PA)
o Receivables (AR)
o Work in Process (WIP)
§ Supply Chain Planning (SCM)
o Advanced Supply Chain Planning (MSC)
o Demand Planning (MSD)
o Inventory (INV)
o Purchasing (PO)
Functional Experience
§ Customer Relationship Management (CRM)
§ Enterprise Resource Planning (ERP)
§ Supply Chain Management (SCM)
§ Applications & Database Design
§ Oracle AIM Methodology
§ Software Development Life Cycle
§ Systems Integration Architecture
§ Technical Writing
Technical Experience
§ Oracle E-Business Suite: Releases 11i, 12
§ Oracle RDMS: 10g, 9i, 8i
§ Oracle Forms: 9i, 6i, 6
§ Oracle Reports: 9i, 6i, 6
§ Oracle BI (XML) Publisher
§ PL/SQL
§ SQL
§ SQL Developer
§ SQL Navigator
§ Toad
Project Roles
§ Manager
§ Business Analyst
§ Developer
§ Development Lead
§ System Analyst
§ Trainer / James LaPierre
James is an Oracle Applications techno-functional consultant with over ten years of Oracle Applications specific experience based upon implementations, third party application integrations, and custom application development within the Oracle E-Business Suite (EBS).
His knowledge spans many of the Oracle EBS customer relationship management (CRM), enterprise resource planning (ERP), and supply chain management (SCM) modules along with non-module specific architectures including Oracle’s Trading Community Architecture (TCA).
James knows how to engage personnel at all levels to learn where process adjustments can be helpful or disruptive while ably communicating anticipated outcomes and building consensus around recommendations.
Management responsibilities are familiar to James as he has consulted independently and worked for small companies where assuming operational roles were necessary. Additionally, his duties have included contract bid proposals and project management.
Prior to his consulting career, James served four years in the United States Marine Corps and earned his master of business administration during his military service.
Functional Experience Summary
Oracle Applications Administration and Configuration:
· Configured descriptive flexfields (DFFs) and key flexfields (KFFs).
· Created “master” applications data:
o In manufacturing for example, bills of materials (BOMs), departments, resources, and routings represent of this type of data.
· Registered concurrent programs, forms, menus, request groups, request sets, value sets, etc.
· Set profile options for various modules.
Documentation and Methodologies:
· Authored and maintained several types of Oracle Application Implementation Methodology (AIM) (or equivalent client or third party methodology) documents for end-users, functional, and technical personnel.
Requirements Gathering:
· Conducted current state and future state analysis whose tasks included:
o Business processes diagramming and documentation.
o Determining software gaps:
§ Designed customizations to fill gaps using APIs, interfaces, and utilities provided by Oracle to minimize customization footprints and maintain upgradability.
§ Analyzed impacts where customizations could not leverage seeded logic and determined whether the cost of such solutions was worthwhile.
o Identifying business process inefficiencies while recognizing improvement opportunities for existing, well functioning business processes.
Research, Troubleshooting, and Issue Resolution:
· Analyzed Patches:
o Determined current patch levels and whether scheduled “minipacks”, “family packs”, or “maintenance packs” contained the “one-offs” needed to correct bugs or add desired functionality.
o Documented system issues and potential impacts of patch applications.
· Managed Oracle Support Service Requests (SRs):
o Coordinated SR research and fact finding tasks with project team members so that information requests from Oracle Support were answered in a timely manner and issues were resolved quickly.
· Troubleshooting:
o Articulated system issues and utilized MetaLink, forums, and any other available resources to resolve issues.
Solution Implementation:
· Coordinated with business users, database administrators (DBAs), developers, external system personnel, production support, and project leadership to build consensus toward proposed solutions.
· Determined solution owners and transferred knowledge accordingly.
· Educated business users to a practical level about business process fundamentals yielding more polished requirement definitions.
· Translated user requests into system design requirements.
· Wrote end-user manuals and conducted training sessions.
System Integration Testing:
· Developed test scenarios and documented test results.
· Transacted data through the applications modules and performed reconciliations to verify that new and updated configurations and customizations preserve data integrity.
· Worked with business users to perform user acceptance testing (UAT).
Technical Experience Summary
Conversions and Interfaces:
· Oracle Applications modules: AP, AR, BOM, ENG, GL, INV, JTF, PA, PAY, PER, PO, and WIP.
· Loading utilities: SQL*Loader, DataLoad, and SmartDB Workbench.
· Database objects: Seeded application programmer interfaces (APIs), external tables, and seeded open interface tables.
Forms:
· Oracle Forms:
o Developed custom, logic intensive, dynamic, multiple block, multiple form applications using the TEMPLATE.fmb, CUSTOM.pll, and built-ins from the Applications Object Library (AOL).
o Extended seeded form functionality through forms personalization, LogicalApps, and cloning and modification.
o Versions: 9i, 6i.
Languages:
· PL/SQL:
o Developed efficient, standardized, modular, well organized, and reusable program units that interfaced external systems, processed data per business rules, submitted concurrent programs, and wrote data to files.
o Understand advanced concepts including autonomous transactions, collections, dynamic SQL, invoker’s rights, overloading, purity, ref cursors, etc.
· SQL:
o Developed efficient DML statements.
o Understand advanced concepts including analytic functions, case statements, external table DDL, inline functions and views, and sub-queries.
Reporting:
· Oracle BI (XML) Publisher:
o Created highly formatted PDF reports using Microsoft Word templates and XML output (generated by Oracle Reports).
o Version: 5.6.3.
· Oracle Reports:
o Developed custom, logic intensive, dynamic, multiple group reports, and used built-ins from Oracle Reports.
o Cloned and modified seeded reports.
o Versions: 9i, 6i.
Project Experience
ThyssenKrupp
Sector: Industrial Goods, Industry: Diversified Machinery
July 2010 – Present
Business analyst and technical architect for CRM Foundation (JTF), General Ledger (GL), Human Resources (PER), and Payroll (PAY) participating in an integration effort to centralize U.S. operations on the Oracle EBS platform.· Functional lead responsible for completing design and development of a series interfaces that languished prior to my assumption of this role. These interfaces synchronize R12 and 11i Oracle EBS platforms for the following data:
o Employees and related assignment, costing, and special information types (SITs).
o Time and expense payroll data.
o GL transactions.
o Supporting configuration data for bargaining units, account segments, job titles, locations, and organizations.
· Built responsibilities and forms personalizations to secure human resource data.
· Developed logic to bulk load users, associate responsibilities, create CRM resources (personnel) and groups as well as assign groups and roles.
· Streamlined requirements gathering process:
o Presented documentation creation strategies.
o Implemented “red text” templates that simplified the AIM methodology enabling business analysts and non-technical personnel to define requirements for technical teams:
§ Elaborated on template sections using real world explanations and examples.
§ Simplified document creation resulting in reduced discussion time between functional teams and technical teams.
· Wrote design, technical, testing, and training presentations and documentation.
Transaction Network Services
Sector: Technology, Industry: Communication Equipment
February 2010 – July 2010
Business analyst and technical architect participating in an integration effort of a recently acquired company resulting in significant reductions in order processing and maintenance efforts while preserving core business approaches still valuable by the organization.· Worked with cross-functional teams to create new and refine existing processes in conjunction with the development of supporting business specific logic.
· Developed logic to bulk load CRM resources (personnel).
· Wrote design, technical, testing, training, and transition documentation.
ADT Security Services
Sector: Services, Industry: Security and Protection
June 2009 – November 2009
Business analyst and technical architect for the General Ledger (GL), Human Resources (PER), and Inventory (INV) Oracle EBS modules. Responsible for business process analysis, requirements gathering, design, development, testing, deployment, and cutover support during our engagement to bring a foreign entity under U.S. operations.· Developed GL conversion logic using the seeded open interface tables and import programs. The business required two years of conversion data to be summarized by account and period, and one year of details for the prior fiscal year. Data cleansing and client-specific validation required the development of custom logic.
· Imported item onhand quantities using the seeded open interface and import programs. Data cleansing requirements meant that additional custom logic was needed. Previously developed logic was leveraged as a starting point to meet this need and reduce delivery time; modifications to this logic included making it reusable for expected near-future item onhand quantity conversions.
· Developed logic to mimic the Approvals Management Engine (AME) Workbench functionality by allowing multiple rules to be tested in batches instead of one at a time. A core component of this business need was to derive approval limits based on AME scores.
· Created DataLoad script for a mass credit card import as a part of the client’s move to American Express.
· Wrote design, technical, training, and transition documentation.
ConMed Linvatec
Sector: Healthcare, Industry: Medical Appliances and Equipment
January 2009 – June 2009
Business analyst and technical architect for the Bills of Material (BOM), Engineering (ENG), Human Resources (PER), Install Base (CSI), Inventory (INV), Order Management (ONT), Payables (AP), Payroll (PAY), Purchasing (PO), Receivables (AR), Service (CS), and Work in Process (WIP) Oracle EBS modules. Responsible for business process analysis, requirements gathering, design, development, testing, deployment, and cutover support for an international implementation of the Oracle EBS.· Developed key reports for actual and standard manufacturing costs, bid tracking, BOMs, ECOs, item sterilization verification and release, payables, quality, receivables, salaries and shift differentials, and shop floor.
· Programmed CAD drawing logic to explode indented BOMs using seeded APIs; component attributes dictated how plotter print jobs for external systems were routed.
· Created logic that would allow “minor” routings to be rolled up into “major” routing groups to simplify shop floor routers and reduce page counts.
· Coded materialized views and accompanying logic to consolidate data warehouse data.
Republican Party of Florida
Public Sector
October 2008 – December 2008
Analyst responsible for pre and post election research and support.· Compiled and analyzed data to identify technology trends and impacts on state elections.
· Reported findings and recommendations necessary for making well informed decisions.
Cox Communications
Sector: Services, Industry: Broadcasting and Cable Television
December 2007 – September 2008
Business analyst and technical architect for the GL (General Ledger), Payables (AP), and Projects (PA) Oracle EBS modules. Responsible for business process analysis, requirements gathering, design, development, testing, deployment, and cutover support during our effort to provide custom application and a Projects (PA) interface.· Development lead responsible for requirements gathering, technical designs, and patch analysis.
· Developed tax application that integrated seamlessly with the Oracle EBS to enable non-corporate personnel to manage fee agreements with various municipalities and taxing authorities. Calculating revenues, payments, and adjustments along with generating monthly GL accruals and periodic payments for franchise fees (taxes) were financial requirements addressed by this application. Additional requirements included GL account management and the preservation of historical records by coding complex conditional logic allowing historical records to be updated without compromising audit requirements.
· Built PA interface using APIs and open interface table.
· Analyzed patches to weigh benefits to system stability, impacts on existing functionality, and potential gains in new functionality.
Sector: Technology, Industry: Internet Information Providers
June 2007 – November 2007
Business analyst and technical architect for the Bills of Material (BOM), Inventory (INV), and Project Manufacturing (PJM) Oracle EBS modules. Responsible for requirements, gathering, design, documentation, and development of custom Oracle forms and reports for a custom supplier integration application.· Designed and developed supplier integration application that made possible the import of differing supplier defined file formats. Accommodating small suppliers without sophisticated business systems was a major objective of this approach along with taking daily snapshots of uploaded supplier item data to determine variances and highlight tolerances between organizations, locations, and sub-inventories for comparison against internal data. Validating components from suppliers via program based on seeded BOM explosion logic and project manufacturing data was a core requirement. Additional functionality included maintaining manager data for commodity codes, planner codes, and locations, determining unmatched material receipts and transfers, and showing supplier inventory transactions at various stages during their processing into Oracle Applications.
General Dynamics Land Systems
Sector: Industrial Goods (Manufacturing), Industry: Aerospace and Defense Products and Services
July 2006 – May 2007
Business analyst and technical architect for Oracle Bills of Material (BOM), Inventory (INV), and Work in Process (WIP) Oracle EBS modules. Responsible for business process analysis, requirements gathering, design, development, and testing a custom conversion application.· Designed and developed conversion program to convert current and historical transactions for discrete job headers and details, material transactions, move transactions, and labor and resource usage utilizing standard Oracle APIs and interface tables where available per business and Oracle Applications requirements. Created simplified concurrent programs to facilitate ease of use for end-users carrying out the conversion activities.
· Develop custom Oracle Report and XML Publisher report utilizing Noetix views.
DRS Training & Control Systems