We provide IT Staff Augmentation Services!

Oracle Cmro And Eam Techno Functional Consultant Resume

3.00/5 (Submit Your Rating)

EXPERIENCE SUMMARY:

  • 22 years experience as a business functional and technical lead in analysis, design, development and implementation of business applications.
  • 15 years of extensive experience with implementation of different Confidential and MRO systems including Oracle cMRO
  • R12 Oracle SCM, Account Payables, eAM, cMRO & Inventory and IBM Maximo 7.5 and 7.6 Confidential current implementation experience.
  • Extensive experience with customizing, developing applications, implementing and production support of Oracle ERP/EBS Applications for Release 11i/12 in: Purchasing, iProcurement, Sourcing, Payables, Inventory, BOM, WIP, EAM, cMRO, ASCP, Quality, Costing, and Receivables.
  • Experience in Maximo 7.5 and 7.6 implementation and customization with Automation scripts, Escalations and Integrations
  • Trained in Oracle SOA 11g Build Composite Applications and Oracle R12 Advanced Supply chain Planning.
  • Strong knowledge in Industry best practices for Oil & Gas, LNG, High Tech, Food & Beverage, Metal, Automotive.
  • Experince in R12 EBS and Maximo Integrations with SOA.
  • Expereianced in OBIEE and KPI reports design and mapping.
  • Experianced with Logbooks applications and SCADA/PI Applications.
  • Installed and supported PRimavera and Analytics applications.
  • Trained in DSI Mobile client applications development and administration.
  • Experianced in requirement mapping for DOCUMENTUM integrations with ERP applications.

PRIOR EXPERIENCE:

Confidential

Oracle cMRO and EAM Techno Functional Consultant

Responsibilities:

  • Maintenance, Repair, and Overhaul initiative ( Confidential ) is a transformation and standardization of both the business processes and enabling materiel solution which provides Confidential with an integrated capability for planning, scheduling, and executing organic depot maintenance to support agile planning, optimized workload assignment, resource allocation, and integrated quality.
  • It implements a configured Oracle enterprise Business Suite (EBS) Commercial Off - The-Shelf (COTS) software product with 'complex MRO' being the core module for user interaction.
  • My role is to advise and evaluate release strategy also mapping the functional and technical requirements between existing Legacy systems to cMRO and Projects.
  • Also support the Program Office to make decisions and monitor the overall project progress as planned within the budget by involving with Solution Design and Configuration groups.

Lead Application Specialist

Confidential, Houston, TX

Responsibilities:

  • Successfully upgraded to Oracle R12 EBS from 11i version.
  • Designed and developed programs for meter readings integration between Logbooks and EBS.
  • Developed and supported DSI Mobile client applications integration.
  • Implemented IBM Maximo 7.5 for Sabine Pass Terminal
  • Created Integration with R12 EBS supply chain and supported
  • Configured Internal Sales order process to address critical accounting issue on sharing inventory between two different stores rooms belongs to two different bussiness entities and supported
  • Designed and completed development of Demand PR Creation/PO Creation Approvals and PO receipts/Invoicing of full Supply chain cycle integrations between R12 EBS/Maximo 7.5/7.6
  • Also designed and completed full development of External/Contract Labor charges integration by using Advanced Contract PO creation in EBS Supply chain.
  • Supported and enhanced Maximo 7.X with Automation scripts and Escalations,
  • Installed and supported Primavera and Analytics applications.
  • Supported monthend closing and accounts reconciliation process.
  • Participated and helped the Cheniere business in evaluate and choose suitable Confidential systems.
  • Presently working on Maximo and Oracle EBS integration process design and mapping.
  • Developed and reviewed business requirement mapping and design documents.
  • Performed unit and integrated tests to ensure standard functionality and custom items are working properly within the eAM module.

Lead Systems Specialist

Confidential, Houston, TX

Responsibilities:

  • Worked as Techno functional lead of the Enterprise Asset Management (eAM) & Inventory team to design and build an Oracle Enterprise Asset Management system that replaced legacy EMPAC system.
  • Facilitated requirement gathering discussions and owned design of functionality and processes to address gaps, including Operational Event Log and Callout Work Order process, MOC notification logic, Work Request notification logic, integration with external PODS system, integration with Enterprise Content Manager, and the Deviation Form extension
  • Authored functional design documents for each of these that specified the detailed functional requirements and worked with technical team to create solutions; continue to test and troubleshoot as technical items are developed and delivered.
  • Configured and maintained core eAM and INV Organizations, resources and profiles
  • As part of project supported as technical lead completed conversion Assets, Activities, PM Schedules and Inventory Items and Quantities
  • Performed unit and integrated tests to ensure standard functionality and custom items are working properly within the eAM module
  • Post production support and Month-end close activities and day to day user support issues.
  • Designed and mapped KPI reports requirements for OBIEE integration.
  • Gathered requirements and documented business requirements and mapped for Documentum integration with Oracle EBS.
  • Created and maintained BR100, MD50, CV40

Confidential, Green Bay, WI

Sr. Applications eAM Functional Consultant

Responsibilities:

  • Given Assement among leading Confidential systems by focusing on Oracle eAM like Maximo and Infor systems.
  • Developed diployment stategy, created GBS standards and Implemented eAM in main WI production unit.
  • Gathered and mapped business requirements sitting with maintenamce Sr. managers and planners.
  • Created Data mapping and conversion strategy and diployed succesfully by getting approvals after testing among multiple instances like CRP and UAT.

Confidential, Huntington, WV

Oracle SCM and Manufacturing Functional Consultant

Responsibilities:

  • A leader in Metal alloys manufacturing is upgrading their systems to 11i.
  • As a SCM Manufacturing Functional specialist my role is to map the business requirements and guide the team deliver the fine solution for Oracle INV, WIP and PUR Modules.
  • Performed basic setups for CRP’s and making ready multiple instances configuration.
  • Configured INV and PUR basic setups and made MD50 and guided them approval process with business users.
  • More Data challenges resolved mainly one of their BU which is replacing Mainframe system.
  • Involved and guided to make the decisions on required data like Categories, Catalogs, Item Attributes, Templates and Vendor sites, locations and workflow required approval hierarchy setups.
  • Also my responsibility is to test and get approvals for extensions of these modules from business users and schedule to move process between instances.

Confidential, Richmond, VA

Oracle ASCP and EAM Functional Consultant

Responsibilities:

  • Implemented Oracle ASCP and EAM in Reynolds Packaging and separated from existing Confidential GBS systems.
  • In the process of transitioning systems from Confidential to Reynolds I am responsible and owned these two ASCP, EAM modules, Asset Tracking and EIB-(Enterprise Install Base).
  • By doing this Reynolds Packaging got benefited by having less maintenance and part of takeover of this Business unit by Rank group of companies.
  • My responsibility is to develop Test Cases and Test plans to make sure Data accuracy and Business functionality work same in pre and Post clone instances.
  • Also will responsible for setup Profiles, Parameters and functional Setups in Pre and Post Clone Instances and assign testing activities during CRP, UAT and Go-live for Oracle ASCP and Oracle EAM modules. In ASCP Created new constraints plans and optimization plans.
  • Also trained users and doing post go-live support successfully.

Confidential

Oracle ASCP and EAM Techno Functional Consultant

Responsibilities:

  • Oracle Applications R12 (SCM, IFS MRO, ASCP)
  • Confidential is world’s biggest ERP implementation which is replacing nearly 400 legacy systems which are supporting US Air force Logistics and MRO services.
  • My role is mapping the functional and technical requirements between existing Legacy systems to OPS and IFS.
  • Also support the Program Office to make decisions and monitor the overall project progress as planned within the budget by involving with Solution
  • Design and Configuration groups.

Confidential, Pittsburgh, PA

Oracle EAM Techno Functional Consultant

Responsibilities:

  • Oracle Applications 11.5.9 and 11i10 (EAM, INV, BOM, Procurement) SQL, PL/SQL
  • Implemented Oracle EAM 11i10 in Confidential Technical Center and replaced Maximo system.
  • After CRP extracted the data in to Excel templates, validated and prepared the data in to Oracle EAM name standards. Completed Organizations, Org Parameters, Areas, WIP Classes, Departments and Resources, Employee Instances and Shifts setups.
  • Then converted the validated Maximo data in to Oracle EAM by using API’s and Interfaces.
  • Trained specific users and got approval from users in UAT and gone live successful.
  • Trained all users and resolved some issues in post go-live support. Implemented as a functional consultant Oracle EAM in four different Confidential Global locations and replaced EAMPACK, Maximo Confidential systems. Analyzed and modified Discoverer Reports.

Confidential, Denver, CO

Sr. Analyst & Techno Functional Consultant

Responsibilities:

  • INV, BOM, WIP, PO, OM, APS) PL/SQL
  • Setup MRO Organizations and Locations
  • Mapped and Converted Items, BOM and WIP Jobs from .5.9
  • Mapped and Converted PO Requisitions from .5.9
  • Mapped and Converted Standard and Blanket Purchase Orders from .5.9
  • Developed a Custom API to Convert Material Transactions History data
  • Converted Serial Numbers from .5.9
  • By using the Purchasing Documents Open Interfaces imported Quotations
  • Imported ASL’s, Sourcing rules and Assignments by Custom API programs
  • Converted Releases and Receipts including one year Transaction History Data
  • Converted all Open Sales Orders and Shipments from i

Confidential, NC

Sr. Analyst & Techno Functional Consultant

Responsibilities:

  • INV, BOM, Costing, WIP, AP, AR, PO, FA), PL/SQL
  • Developed a Custom API to import Vendors and Vendor sites
  • Converted Standard and Blanket Purchase Orders from 10.7 to 11i
  • By using the Purchasing Documents Open Interfaces imported Quotations
  • Imported ASL’s, Sourcing rules and Assignments by Custom API programs
  • Converted one year Transaction History Data including Receipts and Supplier Returns
  • Customized Work Flow Debit Memo Notification to send notification if Debit Memo successfully created
  • Developed Custom Create Item Process that included Forms, PL/SQL packages and Triggers
  • Customized Cash Management Bank Statement Load and Import Processes
  • Programmed and implemented the complicated logic of splitting the Bank File based on the check number in to number of Statements for corresponding Operating Unit
  • Converted Fixed Assets from 10.7 to 11i by handling Amortization issue

Confidential

Sr. Analyst & Techno Functional Consultant

Responsibilities:

  • INV, BOM, Costing, WIP, PUR, Project Management), PL/SQL
  • Merged and Converted Items from Legacy System.
  • Merged the items by removing the one to one relation between order and Item (Item Versions) after importing in to Excel sheets then validated by Macros.
  • This validated Item information inserted into interface table by using UTL FILE and converted back in to system as new items.
  • Purified the BOM and Routing information and importing back into 11i Applications
  • Developed PL/SQL Procedures and standard Item import and BOM/Routing import programs
  • Converted Developed Crystal Reports in to Oracle Developer Reports
  • Developed a Custom PL/SQL program to convert Vendors and Vendor Sites
  • Imported all Quotations, ASL’s, Sourcing rules and Assignments from 10.7 to 11i
  • Developed Finished Goods Reserve Schedule Report and Aging Report, which will calculate an over aged and lower cost or market reserves for finished goods.
  • Using the base data for calculation called ADOM data, which stands for Alloy, Department, Operation, and Machine (in Oracle speak, Alloy, Department Class, Standard Operation, and Department). In the WIP and BOM modules the yield and usage rate time information shall be stored in its descriptive flex-field locations; this rate, if present, shall be used by SMC scheduling processes as well as other SMC job demand planning and control functions, including ADOM processes. When it is not present, processes should default to the usage rate or amount and basis for the routing step resources
  • This ADOM custom table is holding different formula codes and alloy code relations
  • The custom function will calculate yields and usage rates based on this table data, that which is providing what alloy to use what formula relation. Designed and Developed forms and reports to maintain and monitor this ADOM custom table data
  • Implemented and customized Oracle Manufacturing 10.07 NCA in INV, BOM, Costing and WIP Modules. Developed and implemented interim cost solution to use the custom average cost by "User Defined" costing option that is available through standard functionality.
  • Designed and developed a Customized Routing Copying system to create new routing for daily basis for new customer based items. This system will import existing routings into Excel sheet and modified by adding or removing some operations then export this routing information back in to custom tables from where the scheduled custom program will create new Routing for new customer based items by using Routing Import Open Interface

Sr. Analyst

Confidential

Responsibilities:

  • Implemented and customized Oracle Manufacturing 10.7 SC in INV, BOM, WIP, Quality Modules
  • Designed and developed customized Shop Floor Control System by taking advantage of number of built-in capabilities of the Oracle Manufacturing Applications in order to make shop floor and Lab tracking systems which are more flexible and complete
  • Designed and developed a real time department-based dispatching screen, custom form in Forms 5.0.6 to collect and process data
  • Developed a customization to track and manage manufacturing process yields for individual operations by using Operation level Descriptive Flex fields for collecting in-out weights and Yields
  • Developed database triggers to calculate yields in Reports 2.5
  • Developed an Operation Yield Report in Reports 2.5

Technical Lead

Confidential

Responsibilities:

  • Implemented Confidential Supply Chain Planning and Designed and Developed Open Interfaces from Oracle Applications to Active Data Warehouse (ADW)
  • Designed, mapped and developed all open interfaces from Oracle Manufacturing to Active Data Warehouse (ADW), from where SCP engine will import the data to generate the plan. Scheduling interfaces and error-handling is successfully done.

We'd love your feedback!