Functional Consultant - Oracle Applications

Summary:

• 18 years of overall experience with 10 years as an Oracle Functional expertin Discrete Manufacturing - Distribution and Supply Chain Management modules and 8 years in MIS and Logistics Operations.
• Experience with Upgrade and Full Life-Cycle Implementation (four) of Manufacturing and Supply Chain Distribution modules.
• Fluent in gap analysis, business requirement gathering, mapping, documentation and testing of Manufacturing and Supply Chain modules.
• Functional expertise in Order to Cash and Procure to Pay business flows.
• Vast past experience with technical teams to design various Oracle standard reports/ documentation / modification of existing reports and change requests.
• Provided Post production support in different projects that involved interaction with end users and provided them with effective solutions or workarounds.
• Proficient in Oracle AIM Methodology, preparing User training guides, documentation and conducting User training sessions.
• Excellent intrapersonal, communication, presentationandleadership skills
• Global experience in working with both small and big teams under tight schedules and a very good team player.
• Industries: Textile, Electronic, Service Industry, Retail, Consumer Products, Tyre Manufacturing, Telecom, HealthCare industries and Logistic.
• “Big five” consulting experience with IBM/Deloitte/Oracle Consulting.

Expertise:

Modules: Discrete Manufacturing - Distribution and Supply Chain Management modules. Inventory (INV), Order Management (OM), Shipping, Receiving, Engineering (ENG), Advanced Pricing (QP), Purchasing (PO), Configurator, iProcurement, Bills of Material (BOM), Account Receivables (AR), and Account Payables (AP)
Applications: Oracle Application 11.3/11i/R12
CASE Tools: Microsoft Visio
Testing / Profiler Tools: Load runner
RDBMS: Oracle, working knowledge of SQL, PL/SQL and Toad
Management Tools: MS Project
Operating Systems: UNIX, Windows NT, Windows 95/98,
Methodologies: AIM, BP.080 Develop Future Process Model, BR.010 Analyze High-Level Gaps and BR.100 Define Applications.
Utilities: Data Loader

Client: Confidential Houston, TX Dec 2008 - Till date
Oracle Applications - Support Project

Confidential is one of the world's leading logistics companies. It provides end-to-end design, implementation and operational capabilities in freight forwarding, contract logistics, transportation and distribution management.

Responsibilities:

• Handling production support in Purchasing, Inventory, Order Management and procurement Oracle modules.
• Working with stuck and pending transactions such as requisitions, purchase orders at different stages of the business process.
• Troubleshooting setup related tasks for OM, Shipping, Receiving, Purchasing and INV.
• Setup new Transaction Types, Document Sequences, Shipping Parameters, Grants and Roles.
• Administered the business process and the different transactions through workflows and suggested modifications in workflows.
• Set up purchasing and receiving options and payment terms.
• Setup Approval Groups and Assignments, employees, supplier and buyers.
• Prepared test scripts and conducted unit and integration testing.
• Prepared training documents for the users for future reference.
• Working with technical teams for the technical design and enhancement.

ENVIRONMENT: Oracle Applications 11.5.10 (INV, OM, Shipping, PO, iProcurement, AP, AR, DBI)

Client: Confidential Wauwatosa, WI Apr 2007 to Nov 2008
Oracle Applications -Implementation

Confidential provides transformational medical technologies and services all over the world. It has a broad range of products and services which enable healthcare providers to better diagnose and treat diseases.

The project dealt with Oracle e-business suite 11.5.10 and integration of existing custom components to a new Canadian operating unit and inventory org. GE healthcare division Canada Clinical Systems Datex-Ohmeda was utilizing a stand alone, MFGPRO /Adecco platform as the ERP system. The MFGPRO platform had system performance issues during high volume usage and was found not to be a compliant system based on a gas audit.
Responsibilities:

• New Implementation of OTC business process of Oracle 11.5.10. Modules implemented Order Management, Inventory and Bills of Material.
• Worked with other developers, designers and architects to make sure that the configuration and custom components met application requirements and performance goals.
• OM: Sales Order (Reservations, Scheduling, Pick Release, Pick Confirm, Receipt, Backordering, Return (RMA Process), Available to Promise (ATP) Setup Order Transaction Types, Document Sequences, Shipping Parameters, Grants and Roles, Defaulting Rules, Release, Release Sequence, Pick Slip Grouping Rules, Freight Charges and Carriers.
• INV: Setup Inventory orgs, Subinventories, Stock locators, Items, Item templates, Attribute Controls, Picking Rules, Min-MAX Planning and Shipping Networks.
• QP:Setup Price lists, Modifiers and Qualifiers.
• Performing the end-to-end testing for the distribution modules. Conducted CRP and UAT in Order Management and Inventory Modules.
• Formulate business test scripts, validate the deliverables.
• Prepared Documentation of Setups (BR100) and prepare the training manuals for the end users.

ENVIRONMENT: Oracle Applications 11.5.10 (INV, PO, OM, Shipping, Advance Pricing, BOM, AR)

Client: Confidential Subsidiary, UK Oct 2004 till Apr 2007
Oracle Applications - Implemenation/Prototype/Enchantement/ Support (EMEA)

Confidential is the major telecommunication player in Europe and provides a complete portfolio of end-to-end communication services in a pan-European network. This includes voice, data, bandwidth and high-speed hosting solutions connecting 32 cities in 13 countries around the world to increase its product base in UK by launching new telecom products.

• Wholesale Line Rental Project
• 11.5.9 to 11.5.10 upgrade Project
• Prototype - Oracle CRM Partner Manager
• Prototype COLT LAN Link Project.

Responsibilities:

• Evaluated chain business processes and wrote functional design documents for all business processes.
• Conducted user meeting to gather user requirements.
• Functional and solution architect of the INV, OM, PO and Configurator module applications.
• Involved in developing Item/BOM setup, Pricing related setup, developing Configurator models, developing Configurator Rules.
• Setup and maintenance of Item Master Organization and Price Lists.
• Setting up the ASCP instance to create internal requisitions for replenishing FIG warehouse.
• Mapping of requirements with Oracle Application R12 functionalities.
• Performed GAP analysis. Defined the business transformation rules and setup PO, OM and Inventory modules.
• Developed detailed functional design for Oracle solution components (BR100)
• Prepared the Test scripts based on the business scenarios collected from the key business users.
• Conducted the UAT with the business user community and Participants.
• Worked with technical teams for the technical design.
• Provided Post Production support and resolved key issues encountered.
• Setup and maintained of Item Master Organization.

ENVIRONMENT: Oracle Applications 11.0.3, 11.5.10, R12 (INV/ OM / Quoting/ Advance Pricing/BOM, Configurator, ASCP, Fund managementmodules)

Client: Confidential Indonesia Mar 2004 till Aug 2004
Oracle Applications Implemenation

Confidential is the largest integrated tire manufacturer in Southeast Asia. It produces and markets a full range of tires and inner tubes for motorcycles, passenger cars, commercial and heavy equipment vehicles.

Responsibilities:

• Project involved new Implementation of Oracle Manufacturing 11i Modules.
• Conducted user meetings to gather user requirements
• Worked with AIMS methodology
• Gathered business requirements and mapped them to Oracle Applications.
• Complete functional setups as required for implementation of Bills of Material (BOM) and Engineering (ENG).
• Created a BR100 setup document.
• Prepared the Test scripts based on the business scenarios collected from the key business users
• Conducted the CRP sessions with Key users and UAT with the business user community.
• Provided Post Production support and resolved key issues encountered

ENVIRONMENT: Oracle Applications 11i BOM, ENG, INV

Client: Confidential Santa Clara, CA Jan 2003 Till 2004
Oracle Applications Support Project

• Agilent Technologies Inc is the world's premier measurement company and a technology leader in communications, electronics, life sciences and chemical analysis.

Responsibilities:

• Handled Production Support issues related to Oracle Inventory, Purchasing and Order Management Modules.
• Involved in testing of Oracle Inventory and Order Management Modules in testing instance after completing setups.
• Resolved technical issues, if any, by coordinating with Oracle Support.
• Reviewed and delivered allfunctionaldocumentation and appendices for any additions/changes to existingOracle11i solutions, test scripts, and setup documentation.
• Solved production support issues according to SLA.

ENVIRONMENT: Oracle Applications 11i INV/ OM /PO

Client: Confidential San Jose, CA / Germany Feb 2002 till Dec 2002
Oracle Applications Rollout and Support Project

Confidential, the world's Original Equipment Manufacturers (OEMs), serves the fastest growing segments of the global EMS market. It is recognized as a technology leader, Confidential provides end-to-end manufacturing solutions.

Responsibilities:

• Worked on functional setups as required for implementation of Oracle 11.0.3 modules.
• Coordinated on data migration from legacy system into Oracle 11.0.3.
• Worked with the CRP team in Germany for project rollout.
• Worked on various Interfaces, inbound and outbound for transfer of Data from their legacy to Oracle and vice versa.
• Worked closely with the development team and assisted them with their business requirements.
• Worked with market users in various countries and Production Support team for knowledge Transition after the post implementation support.
• Prepared manuals for components and processes for production support team.
• Environment: Oracle Applications 11.0.3 INV, Order Entry, BOM and PO Modules.

Client: Confidential - India Jul 2001 till Jan 2002
Oracle Applications - OPM Implementions

• Winsome textile makes yarn and textile fabric. The objective of the project was to implement Oracle process manufacturing in different business functions of the company

Responsibility:

• As a team member I was responsible to configure the base solution for the envisioned process in a multi-org environment. I was also responsible to study the existing business activities, preparation of process study, fitment analysis and gap analysis.
• Prepared set up documents of OPM inventory, common purchasing and identified the areas of customizations needed. Customization of reports, testing, integration and documentation.

Environment: Oracle Applications 11.0.3 INV and PO Modules.

Confidential India Jan 1999 till Jul 2001
Oracle Applications - Implementions

National Panasonic ltd. is a subsidiary of Matsushita electric Ltd., Japan. It is a leading company engaged in distribution of CTV, washing machines and system products. National Panasonic India sells office equipments such as mobile phones, fax, cordless phones, kits, panaboard and music systems.

I worked as a distribution Module Leader and expert for Inventory at National Panasonic ltd for Oracle Purchase and Inventory modules. I defined setup and functional mapping of Purchase Order modules. Setting and planned up the instance to create internal requisitions for replenishing the master warehouse from Factory's. I also assisted in designing customized reports according to the company requirements. Tested CRP and coordinated with various module and project leaders of Oracle Consultancy India ltd. Imparted training to users.

• Environment: Oracle Applications 11.0.3 INV, Order Entry and PO Modules.

Confidential -Delhi
Position held: Office Associate Oct 1996 till Sep 1997

• The project involved developing a system for all warehouses of the company to take online status of stocks, finished goods as well as spares.

Responsibility:

• Designed MIS and Inventory discrepancy stock reports maintained store records of dispatched materials to different HCL Frontline branch offices. Dispatched cargo and invoices. Wrote month-end stock status reports. Environment: FoxBASE, Excel, MS Word.

Confidential Oct 1992 till Sep 1996

• The project involved streamlining of Purchase Orders which were pending, reconciling minimum/maximum stocks of all materials available in the warehouses from different vendors and established their payment terms.

Responsibility:

• System study, discussion with vendors and customization of reports.
• Month-end stock status report and maintenance of store records.
• Maintenance of store records and Discrepancy stock report.
• Strictly following turnover time in dispatching material.
• Updating the MIS manager and imparted end user training.
• Developed and tested of MIS reports. Unix, Unify, SQL, RPT

Confidential, India
Position held: Programmer Sep 1991 till Feb 1992

• Grasim Industries Ltd. is a manufacturing textile unit for weaving and spinning. It produces polyester, synthetic and acrylic yarn.

Responsibility:

• Analysis Discussion with shop floor manager.
• Design, Program specification and test plans.
• Unit, Module & System testing.
• Developing Dbase.

Employee Payroll Aug 1990 till Aug 1991
Position held: Programmer

• This project was developed for in-house use and included monthly pay of staff and generation of pay slips and recording leave an employee took in a month. Total deductions like Provident fund, Employee Insurance, loan if any and leave without pay, allowances, bonus and medical allowances.

Responsibility:

• Assisting time office department in understanding the functionality of the package.
• I worked on customization requirement specifications documents.

Education & training done

• Post graduate - Master of Arts
• Confidential, New Delhi
• Oracle Applications suite - Confidential India, New Delhi.
• IBM-AS/400 training from Confidential, Delhi.
• Attended Oracle Configurator Developer - organised by Confidential
• Attended PMP Training from Confidential New Delhi