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

Responsibilities:

• Maintenance, Repair, and Overhaul initiative (MROi) is a transformation and standardization of both the business processes and enabling materiel solution which provides Air Force Sustainment Center (AFSC) 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:

• Working as a techno functional consultant in O&M IT department of Confidential, which is leader in LNG business in USA. Here my duties are to design and build and support Oracle Enterprise Asset Management & Inventory system.
• 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.

Techno Functional Sr. 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

Sr. Applications eAM Functional Consultant

Confidential, Green Bay WI

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.

Oracle SCM and Manufacturing Functional Consultant

Confidential, Huntington WV

Responsibilities:

• 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, Pittsburgh, PA

Oracle EAM Techno Functional Consultant

Responsibilities:

• 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 CMMS systems. Analyzed and modified Discoverer Reports.

Sr. Analyst & Techno Functional Consultant

Confidential, Denver, CO

Responsibilities:

• Setup MRO Organizations and Locations
• Mapped and Converted Items, BOM and WIP Jobs from 11.03 to 11.5.9
• Mapped and Converted PO Requisitions from 11.03 to 11.5.9
• Mapped and Converted Standard and Blanket Purchase Orders from 11.03 to 11.5.9
• Developed a Custom API to Convert Material Transactions History data
• Converted Serial Numbers from 11.03 to 11.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 11.03 to 11i

Sr. Analyst & Techno Functional Consultant

Confidential

Responsibilities:

• 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

Sr. Analyst & Techno Functional Consultant

Confidential

Responsibilities:

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

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

Technical Lead

Confidential

Responsibilities:

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

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

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

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

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