Oracle Apps Manufacturing + ASCP

Sulipta Tripathy

Oracle Applications Supply Chain Management

Cell: 916-***-****

Summary

• Around six (6) years of experience in the IT industry with expertise in Business Analysis, Requirement Gathering, Development, Testing, Issue fixing, Documenting, User Training, Implementation of Oracle Applications and Post Production Support.

• Sound knowledge of key functionalities of manufacturing modules along with working experience on Supply Chain Management from one of world's largest FMCG Company.

• Expertise in design, development and customization of Oracle Process Manufacturing (OPM) with strong knowledge in Quality Management, Inventory, Production Batches, Formula, Routing, Recipe, Forecasting, Production panning, Master Production Scheduling (MPS) and Material Requirement Planning (MRP), Advanced Supply Chain Planning (ASCP).

• Expertise in Oracle Manufacturing’s OM, Shipping, BOM, WIP, OSFM, PO and INV Modules.

• Certified by APICS in Basics of Supply Chain Management, Master planning of Resources, Detailed Scheduling and planning and Execution and Control of Operations modules of CPIM.

• Certified and Trained by Oracle University in Oracle Advanced Supply Chain Planning – R12.

• Experience in Development, Issue Fixing and Testing using SQL & PL/SQL, Oracle Forms Developer, Oracle Reports Developer , Oracle Workflow and Oracle Approvals Management

• Experience in As Is process study and analysis during the pre-implementation stage and in conducting User Acceptance Tests (UAT).

• Experienced in managing development projects and sustaining activities to ensure 100% uptime of Oracle Application instance.

• Proven planning, organizational, analytical, communication, and presentation and team management skills. Successfully manage multiple tasks and projects simultaneously. Have got excellent customer relationship skills and an appetite to learn new skills. Able to work effectively as part of team or independently. Have worked in culturally diversified teams spread across different geographical locations.

• Interacted with Oracle Application Customers in pharmaceuticals, industrial chemicals, food & beverage, consumer packaged goods, metals, Semiconductors and High Tech industries to discuss about the issues and figuring out the cause and then solving it.

Education

Bachelor of Technology (Honors) from National Institute of Technology (NIT), Rourkela, India.

Skill Summary

• Experience in Business Process Analysis

• Requirements Analysis and Work Management

• Solution design, developing functional specifications, process flows, developing test plans for module testing and User Acceptance Testing. Key User training and manual preparation

• Implementation of Oracle Process Manufacturing (OPM), Quality Management (QM), OPM Process Planning, MRP, Advanced Supply Chain Planning (ASCP) ,OM, Shipping , BOM, WIP, INV, PO, OSFM and other manufacturing modules

• Embedded Languages : SQL , PL/SQL , Oracle Forms Developer, Oracle Reports Developer

• Tools : SQL Navigator, Toad, MS Office

Professional trainings and Certifications

• Certified by APICS in Basics of Supply Chain Management, Master Planning of Resources, Detailed Scheduling and Planning and Execution and Control of Operations modules of CPIM.

• Trained and Certified in Oracle Advanced Supply Chain Planning by Oracle University

Professional Work Experience

Oracle Application Consultant Nov 08 – till date

Blue Coat Systems, Sunnyvale, CA

Project: Looking Glass Phase II

Project Scope:

1. Implement system setups for a new Entity in Oracle eBusiness Suite to facilitate order management operations in Switzerland

2. Achieving tax and operational benefits

3. To implement various Oracle Apps manufacturing modules in the new Organization

Roles and Responsibilities:

• Handling the implementation of the above mentioned key requirements

• Leading Oracle MRP, WIP, BOM and PO Implementation to successfully implement Oracle Apps in the new operating units without any major issues

• Performing requirements gathering, solution design, automation and validation of setups.

• Working with Oracle development and support to resolve all issues identified.

• Maintaining the technical integrity of the system by ensuring that patches are managed, controlled and tested.

• Involved in writing Functional Design Document for various customization requests for this project.

• Involved in performing end to end reconciliation of MRP to test the effectiveness of the new changes

• Functional Consultant role involving Business requirements, Business Process Design, Validation, and Deployment using Planning for maintaining Supply and Demand. This Involved creation of Sales Orders and Forecasts for Planning of Raw Materials through MRP Run followed by Procurement Process, Receiving with Inventory and managing discrete Jobs as per their Supply chain strategy

• Working on new/change alerts and reports for better data visibility

• Working on testing various custom programs to suite the business needs of the client.

• Working with on-site and off-site technical resources to implement custom solutions for identified gaps.

• End User Training and preparation of solution design document

Environment: Oracle Apps 11i, Forms 6i, Oracle 9i, SQL, PL/SQL, Windows 2000, SQL *Plus, TOAD

Oracle Application Consultant Mar 08 – Nov08

Applied Materials, Santa Clara, CA

Project: HUBCO

Applied Material Supply Chain Operations consist of third party suppliers and Manufacturing & Inventory locations spread across the World.

Project Scope:

1. Achieving tax benefits by procuring and selling items from the new organization

2. Ability to create Purchase Orders and email the same to external suppliers

3. Ability to create Sales Order programmatically in the existing Organization from Purchase Orders

4. To automate the process of inter organization buying and selling

5. To implement various Oracle Apps manufacturing modules in the new Organization

Roles and Responsibilities:

• Handled the implementation of MRP, PO, BOM, ENG, INV and WIP in the new Operating Unit’s Inventory Organization.

• Involved in writing Functional Design Document for various customization requests for this project.

• Involved in performing end to end reconciliation of MRP to test the effectiveness of the new changes

• Functional Consultant role involving Business requirements, Business Process Design, Validation, and Deployment using Planning for maintaining Supply and Demand. This Involved creation of Sales Orders and Forecasts for Planning of Raw Materials through MRP Run followed by Procurement Process, Receiving with Inventory as per their Supply chain strategy

• Working on implementing Auto release of planned orders from MRP workbench, creation of Purchase Orders for external procurement.

• Working on new/change alerts and reports for better data visibility

• Working on testing various custom program to suite the business needs of the client

• End User Training and preparation of solution design document

Environment: Oracle Apps 11i, Forms 6i, Oracle 9i, SQL, PL/SQL, Windows 2000, SQL *Plus, TOAD

Oracle Application Consultant Jul 07 – Feb 08

Silicon Image, Sunnyvale, CA

Project: Global Expansion Strategy II

Silicon Image Supply Chain Operations consist mostly of third party suppliers and inventory locations spread across the United States and Asia.

Project Scope:

1. Separation of distribution and manufacturing activities

2. ATP suggested promise date should reflect on hand, WIP and in-transit finished goods.

3. Ability to track in-transit time between manufacturing and distribution.

4. Freight cost saving

5. Ability to consume forecast

6. Complete automation of inventory transfers from manufacturing to distribution location while providing a means for manual intervention

Roles and Responsibilities:

• Handling the implementation of ASCP, INV, BOM, PO and OSFM.

• Involved in writing Functional Design Document for various customization requests for this project.

• Involved in performing end to end reconciliation of APS to test the effectiveness of the new changes

• Functional Consultant role involving Business requirements, Business Process Design, Validation, and Deployment using Planning for maintaining Supply and Demand. This Involved creation of Sales Orders and Forecasts for Planning of Raw Materials through ASCP Run followed by Procurement Process, Receiving with Inventory as per their Supply chain strategy

• Working on implementing Auto release of planned orders from ASCP workbench, creation of internal sales orders and setting up ATP.

• Designed and Implemented the Internal Sales Order creating process between various Inventory Organizations.

• Working on new/change alerts and reports for better data visibility at the manufacturing site.

• Working on testing various custom program to suite the business needs of the client

• End User Training and preparation of solution design document

Environment: Oracle Apps 11i, Forms 6i, Oracle 9i, SQL, PL/SQL, Windows 2000, SQL *Plus, TOAD

Systems Manager, Sep 06 – June 07

Unilever, India

The Supply planning team at Unilever was working towards achieving a centralized planning system & processes across Unilever with the following key objectives:

1. Forecast/ Demand Management

2. Production / Distribution Planning

3. Network Optimization

4. Collaboration with Factories

5. Production/Dispatch Compliance Measurement and Reporting

6. Visibility on Finished Goods In transit

7. Measurement and Reporting of Service Levels and Stock Freshness & Availability

Roles and Responsibilities:

• Involved in development of eB-staging system i.e., the system aimed at introducing a layer of Centralized MFG/PRO database, which will act as a feeder system to ADEXA (planning engine).

• The major outputs from the module were Daily Distribution Plans for Depots, Production

• Plans for factories, Materials Plans for Suppliers and develop various reports for Compliance measurement

• Involved in Database Design, prototyping and presenting to business community, managing the software development and supporting it there after.

• Prepared Test plans for Unit Testing, Functional Testing, Integration testing and User Acceptance testing.

• Responsible for Documentation of the whole system.

I managed a team of twelve members for achieving the target mentioned in the project above. My role also involved traveling to Unilever’s factory, Depot and Business sites to understand user’s requirement from the IT Department, do a feasibility study of the requirement, develop software and support the same.

Environment: MFG/PRO, Adexa Planning System, Oracle 9i, SQL, Windows 2000, SQL *Plus, TOAD

Senior Application Engineer Jun 04 – Aug 06

Oracle Corporation, India

My role in Manufacturing Module of Oracle Corporation required a deep and sound knowledge in the technology used in the product as well as functional aspect of the product.

Roles and Responsibilities:

• Supporting and fixing technical as well as functional issues for customers using and Implementing Oracle’s Manufacturing ERP Product.

• Doing Minor Enhancements and features addition to the existing functionality.

• Developing new Reports and approved features as requested by Customers.

• Creating and maintaining patches for Oracle Apps ERP Customers

• Interacting with Oracle support and product managers for various customer issues

• Involved in meeting and designing new feature addition / change as requested by Oracle Apps Customers.

• Testing the functionality of the newly developed Oracle products for missing functionalities or bugs and then resolving the same.

• Customer Interaction: Interacting with Customers in pharmaceuticals, industrial chemicals, food & beverage, consumer packaged goods, and metals industries to discuss about the issue they are facing and figuring out the cause and then solving it.

• Interacting with other Oracle Apps Module owners for establishing proper integration among various modules

• Attending trainings and learning new technologies for upcoming product development

• Training subordinates on Oracle Apps Manufacturing functionalities

Some of the Customer I have worked for: Teva Pharmaceuticals, Mehasana District co-operatiove, Biogen, ALCOA, Heritage, Valspar etc

I have worked in the modules: Oracle Process Manufacturing (OPM) with strong knowledge in Quality Management, Inventory, Production Batches, Formula, Routing, Recipe, Process Planning, Forecasting, Production panning, Master Production Scheduling (MPS) and Material Requirement Planning (MRP) and Advanced Supply Chain Planning (ASCP). I have also worked in OM, INV, PO, WIP, BOM, OSFM and Shipping.

Environment: Oracle Apps 11i and 12, Forms 6i, Reports6i, Oracle 9i, SQL, PL/SQL, Windows 2000, XP, SQL *Plus, TOAD

Software Engineer, Aug 03 – May 04

Satyam Computer Services Ltd

Technical Knowledge: Familiarization with Programming Fundamentals, Relational Data Base Management System, SSAD and Data Structures. AS/400 Technologies, general concepts related to DB2, CL Programming, RPG/400, ILE, and SQL/400.

Functional Knowledge: Banking and Finance:

Software for banking is basically, Financial Software. The software helps us to maintain the book of accounts electronically for ease of entry (creating customers, accounts, transactions journaling etc), to store and retrieve voluminous data, for preparing reports (statement of accounts, MIS, General Ledger and Profit & Loss accounts etc) and for future reference (data warehousing-storing past records for any future use).

Projects: I worked in a project for the Jacada Team, USA.

The aim of the project was to convert the text based screens of AS/400 to GUI screens and make it more user-friendly.

Tool Used: Jacada

Contact this candidate