SUMMARY:

• About 9+ years of exposure in Oracle Applications Release 12 & 11i System Solution Design, Implementation & Support with three Implementation in R12 and 11i.
• Currently working in Europe Implementation Project to implement Oracle R12.2.5 in various countries for Sherwin - Williams Company.
• Worked as Track Lead, Module Lead and Functional Consultant of Discrete & Process Manufacturing, Supply Chain & Planning Modules in various projects with different clients and countries.
• Experience in five full life cycles Oracle R12 and 11i Oracle implementations.
• Practical Exposure of working in industries such as Paints, Automobile, Telecommunications and Electrical and understanding their Business processes.
• Implemented the Oracle Applications R12.1.4 Implementation Project in Sherwin-Williams for Brazil.
• Implemented the Oracle Applications R12.2.5 Implementation Project in Sherwin-Williams for United Kingdom (UK).
• Implemented the Oracle Applications 11.5.10.2. Implementation Project in Eaton Corporation and worked in Manufacturing and Distributions Modules INV, PO, BOM and WIP.
• Implemented the Oracle Applications R12.1.1 Implementation Project in Unitech-Wireless India Pvt. Ltd and worked in Manufacturing and Distributions Modules INV, OM, PO, iProcurement, WIP and BOM Modules.
• Implemented the Oracle Applications R12.1.1 Implementation Project in Action Construction Equipment Ltd and worked in INV, OM and PO Modules.
• Excellent proven Functional knowledge in Oracle various Application such as Inventory, Purchasing, Order Management, Work in Progress, Bill of Materials, MPS/MRP/SCP (Material Requirements Planning), Product Development, Process Execution, Average & Standard Costing and Advance Procurement.
• Expertise in Oracle Business Process like Drop Shipment, Back-to-Back Order, Internal Sales Order, Order-to-Cash, Procure-to-Pay, Supplier Consignment and Outside Processing.
• Proficient in providing end-to-end delivery from requirement analysis to system study, project co-ordination, documentation and implementation. Involved in Analysis, Design, Business Process mappings for integration project.
• Proficient with new and existing projects implementation/enhancement/support using AIM/OUM methodology, SDLC, pre-implementation gap analysis, Documents such as BR-30, BR-100 and MD-50.
• Skilled in Identifying and Analyzing business requirement and providing wide range of Support which include Requirement gathering, Process Mapping, Gap Analyzing, Functional design and configuration, Assist in CRP, SIT and User Acceptance Test (UAT), End User Training & Implementation in Multi-Org Environment.
• Strong knowledge of Oracle table structures, API’s, Schemas, Oracle open interfaces.
• Experience ranges from the Solution Design, Implementation to Postproduction support for Oracle Applications. Interacted with Oracle Support to resolve application issues. Lead team and the support for a module/technology/process area. SLA adherence as per project norms.
• Excellent communication & documentation skills.

TECHNICAL SKILLS:

ERP Packaege: Oracle Applications R12 and 11i.

Modules: INV, PO, OM, WIP, BOM, COSTING, PD, PE, ASCP and iProcurement.

R.D.B.M.S: Oracle 11g, Oracle 10g, Oracle 9i.

Languages: SQL, PL/SQL.

Tools: TOAD, PL/SQL Developer, Professional Data Loader/ Data Loader

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, USA

Functional Consultant

Responsibilities:

• Gather requirements, analyzes, creates design documents, and performs impact analysis for application changes.
• Plan and organize tasks, reports progress, manages and coordinates with OBIT and Supply Chain Consultants for implementations.
• Develop solutions to leverage Oracle ERP application functionality and suggest process improvements.
• Work with business teams and external systems.
• Guides technical team in the development reports, conversions, interfaces and extensions for Oracle Applications.
• Conducted Global Workshop, CRP, System Integration Testing (SIT) and User Acceptance Test (UAT) schedules of the Business-Functional flows. Design of test plans and test cases for testing the system.
• Actively engaged business team to understand vision and ensure business needs are met.

Confidential, Cleveland, USA

Track Lead

Responsibilities:

• Gather requirements, analyzes, creates design documents, and performs impact analysis for application changes.
• Plan and organize tasks, reports progress, manages and coordinates with OBIT and Supply Chain Consultants for implementations.
• Develop solutions to leverage Oracle ERP application functionality and suggest process improvements.
• Work with business teams and external systems.
• Guides technical team in the development reports, conversions, interfaces and extensions for Oracle Applications.
• Conducted CRP, System Integration Testing (SIT), User Acceptance Test (UAT) and Core User/End User Training schedules of the Business-Functional flows. Design of test plans and test cases for testing the system.
• Create test plans, test cases, test scripts and performs functional testing. Create and maintain system Plan and organize tasks, reports progress, manages and coordinates with consultants for implementations.
• Ensured that applications meet business requirements and systems needs, fulfill end-user requirements, and identify and resolve systems issues.
• Actively engaged business team to understand vision and ensure business needs are met.
• Work with existing systems to track and manage requests and issues.

Confidential, Pittsburgh, USA

Lead Functional Consultant

Responsibilities:

• As a Lead Functional Consultant, Responsible for the Following: Functional Support - For Inventory, Purchasing, Order Management, Bills of Material, Work In Process, MRP and Costing. Functional Lead (Onsite) of Manufacturing, Supply Chain and Planning Modules.
• Enhancement Process improvement/Gap Analysis and deliver solutions based on requirement. Worked as Site Lead/SPOC for any issues reported for different Sites. Assisting Business in Month End Closure Activities. Providing Training Guides/Sessions to the Key users for major day to day activities.
• Providing Root Cause and fixing bugs for the recurring issues. Understanding, reviewing and implementing new requirements/requests made by the Users. Writing/Reviewing FDDs, RDDs and TDDs for new Enhancements and fixing existing Bugs.
• Helped Technical team on preparing custom interfaces/reports to provide / resolve technical issues. Worked with Oracle team on various SRs.
• Involved in the Unit and System Testing with the teams handling other interfaces. Training Key Users to help them get acquainted with the application. Perform Post-Patch functional testing and perform system validation after database/application Patching. Support business applications through Remedy tool.

Confidential,

Functional Analyst

Responsibilities:

• As a Functional Analyst, Responsible for the Following.
• Functional Consultant -- For INV, OM, PO, BOM and WIP for Implementation, Solution Design and Development. Creation of Implementation documents like BR30, BR100 for setting up the instance. Understanding AS-IS through detailed discussion and questionnaires. Create Functional design document for Reports/Customization/Personalization.
• Data migration - Data migrate of Items, Cost, Inventory Stock, Open Purchase Orders, Open Sales Order, Suppliers, Customers and Stock locators.
• Testing of the customized component (Testing Methodology).This is done by running the business case scenario in Production clone instances so that there are no issues faced by the business users in the production instance. Helped Technical team on preparing custom interfaces/reports to provide / resolve technical issues.
• Implemented Min-Max Planning/Re-Order Point planning method in Inventory. Implemented→ Back to Back/Assemble to Order/Pick to Order and Automatic Sourcing based on Quotation/Blanket Purchase Agreement in Supply Chain Areas.
• Implemented Outside Processing and Serialized Manufacturing in Discrete Manufacturing. Cross Cultural interaction with the Client. Created User Manuals for programs, user procedures and conduct core-team and end user training. Training Key Users to help them get acquainted with the application.

Confidential,

Functional Consultant

Responsibilities:

• As a Techno-Functional Consultant, Responsible for the Following. Understanding the SCM and Manufacturing process of business & map them into Oracle. Cross Cultural interaction with the Client. Resolving production functional issue. Assigning technical team for new enhancement.
• Error-analysis in Inventory Transactions & WIP Transactions. Transaction Open Interface, Pending Transactions errors. Interacted with Oracle Customer Support to resolve application issues. SLA Adherence as per the project norm. Track and publish the productivity and SLA matrices.
• Profile tickets based on complexity and problem resource. Writing / executing scripts using TOAD to perform various extracts from database. Helped Technical team on preparing custom interfaces/reports to provide / resolve technical issues. Proactive issue identification and resolution. Tracking issue until closure.
• Mentors juniors in the team. Timely reporting issue to PM.

Confidential,

Functional Consultant

Responsibilities:

• As a Functional Consultant, Responsible for the Following. Identifying and analyzing business requirement and providing wide range of Support in Process cycle testing of SCM and Manufacturing process & map them into Oracle.
• Functional Consultant for INV, OM and PO for implementation and development. Understanding AS-IS through detailed discussion and questionnaires.
• Actively involved in Conference Room Pilot (CRP), Core User/End User Training and User Acceptance Test (UAT) schedules of the Business-Functional flows. Design of test plans and test cases for testing the system. Prepared User-Manuals for programs and User procedures.
• Interacted with Oracle Customer Support to resolve application issues. Involved in some activities for Oracle System Administration module such as Registering the Users, Responsibilities and Menu’s and assigning Responsibilities to Users.
• Writing / executing scripts using TOAD to perform various extracts from database.

Confidential,

Techno Functional Consultant

Responsibilities:

• As a Techno-Functional Consultant, Responsible for the Following. Creating and Handling Master Items, Organizations, Sub Inventories, Stock Locators, Shipping Networks, Locations, Item Template’s, Cost-Manager, Pending transaction Errors and Physical Inventory.
• Involved in Process cycle testing in PO, INV, OM, BOM and WIP.
• Involved in Period end closing Process for Inventory and Purchasing and resolve all the pending transactions in Inventory and WIP.
• All necessary Setups of PO, INV, OM, BOM and WIP.
• Training & Post Production Support to Users.

Confidential,

Techno Functional Consultant

Responsibilities:

• As a Techno-Functional Consultant, Responsible for the Following. Developing Reports and Customization of Reports (PO, INV. WIP, BOM).
• Involved in Period end closing Process for Inventory and Purchasing and resolve all the pending transactions in Inventory and WIP. Day to Day various types of Support Activities, as per requirement of the Users in Apps. Report Requirement Analysis / Documentations.
• Resolving Cost-Manager, Transaction Open Interface, Pending Transactions and Reservations Transactions errors. Error-analysis in Inventory Transactions & WIP Transactions.
• Creating and Maintenance of Master Items, Organizations, Sub Inventories, Shipping Networks, Locations, Categories, Stock Locators, User Transaction Type’s, Item Type’s, Physical Inventory, PO Taxes & Item Categories.