SUMMARY:

• 23 years of 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 CMMS and MRO systems including Oracle cMRO
• R12 Oracle SCM, Account Payables, eAM, cMRO & Inventory and IBM Maximo 7.5 and 7.6 CMMS 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 and Oracle Procurement Cloud
• 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.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle cMRO and EAM Techno Functional Consultant

Responsibilities:

• Configured and Enabled Oracle Service Procurement. Created Jobs to use and link to PO Categories.
• Customized POR CUSTOM package to add business rules and validations on PO line types based on GOODS, Services Quantity and Amount methods.
• Developed custom package to auto receive POs upon approval of OTL Time for that contingent employees.
• Created new PO AME approval process

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 CMMS 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 CMMS 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:

• 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, Greensboro, 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.

Sr. Analyst

Confidential

Responsibilities:

• Supply Chain role with the overall objective of improving manufacturing effectiveness and delivery performance
• Using the base data for calculation called ADOM data, which stands, 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, Order Entry, 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 ( ) i2 Supply Chain Planning, INV, WIP, PL/SQL
• Implemented i2 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.

Analyst & Programmer

Confidential

Responsibilities:

• HP-UX 11.0, Oracle Manufacturing 11.03 (OE, INV), Oracle 7.3, Forms 4.5
• Customized INV Module and developed custom Pack Release Order system
• Developed Pack Release customized program to drive the entire Material Handling and Packing Process for aftermarket operations
• Customized system will releases the Sales Order Line for packing after checking the availability of components
• Running this program at specific time every day to release lines according to schedule date and prints Green sheets with quantities and line and order details in Barcodes; these Green sheets are used to issue work orders and print labels; this is very crucial development, which is essential for day-to-day business of this plant
• Using the Dana Stealth Pack Release in case of forced release conditions, whereby user can release any quantity or total available to release quantity without bothering about inventory availability of end components
• Printing the Green Sheets with line, order numbers and quantity details in Barcodes after releasing the line
• Using Unrelease Released Lines replenish forced released cases by unreleasing released order lines; after selecting order line for unrelease, this program unreleases the given quantity and adds the same quantity to the available to release quantity of that line; it will not print any cancellation report or Green Sheet Cancellation
• Designed and developed Shipment Summary sales report and Monthly Sales History report sort by Customer and Models
• Defined value sets, parameters and performed extensive SQL, PL/SQL tuning using various Oracle Tools such as TK-PROF, Explain Plan

Programmer / Analyst

Confidential

Responsibilities:

• HP-UX 11.0, Oracle Manufacturing 10.7 (INV, PUR, WIP), Oracle 7.3, Forms 4.5
• Customized and Implemented PUR and WIP Modules
• Developed Springs vendor interface custom program, which feeds a Sony Tokyo based mainframe system that requires 3 basic types of information such as Vendor, Actual Purchase amount and Purchase price (by part and vendor)
• Developed SQL Scripts to execute this job as Extract Vendor Information for upload to Springs system
• Created a program to Extract Quotations (Part/Vendor/Price) information for upload springs
• Designed and Developed a report in WIP to provide better visibility to production details of each production line, Good, Defect and Repair transaction quantities and percentages for each operation sequence
• Developing Quality reports, Quality Results Report and Quality Specification Report

Programmer / Analyst

Confidential

Responsibilities:

• HP-UX, Oracle Manufacturing 10.7 (INV, BOM, WIP), Oracle 7.3, Forms 4.5
• Implemented Oracle Manufacturing Applications Inventory, BOM and WIP modules
• Carrying out data conversion of System Items, Bills, Routings and Transactions in Direct and Conventional Path methods with SQL*Loader
• Worked on various methods to improve efficiency of standard Import Concurrent programs
• Defined user defined transaction types, source types in addition to pre-defined transaction types for movement of items
• Converted successfully all historical and current day to day transactions
• Customized Bills Import request submission form for auto submission of request

Programmer / Analyst

Confidential

Responsibilities:

• Implemented Oracle Inventory, BOM and WIP Modules
• Developed data conversion in Direct and Conventional Path methods using SQL
• Created sub-inventories, defined Items by using Predefined and User defined Templates, Categories, Catalogs and to control item activities with Status Controls
• Created and converted Bills, Alternative bills, Routings and resources
• Defined Assembly Production Lines
• Customized the existing reports as per user requirement specifications
• Developed the Purchase Accounting System that is primarily concerned with the transaction between production, purchase departments and suppliers
• Previously, it was controlled by maintaining different registers for each transaction
• Developed the system to process the requisition received from production department to purchase department through stores
• Developed various database triggers and procedures thus ensuring data integrity involved in coding and decoding.