PROFESSIONAL SUMMARY:

• 12+ years of techno functional experience in implementation, conversions, upgrades and support on Procurement, Manufacturing and Value chain/Supply chain planning modules of oracle cloud fusion and Oracle ebusiness(Release 11i and 12).
• Expertise in oracle cloud fusion business processes and Oracle Ebiz releases like 11i and R12.1.3 and R12.2+
• Completed four supply chain implementation projects on ASCP(Constraint and Unconstraint) and ATP/GOP, distribution planning and two oracle demantra demand management planning and Real time sales and operations projects.
• Possess strong application and business noledge in SCM/MFG(Discrete and Process) modules like ASCP, BOM, WIP, Costing, PO, Procurement, Oracle Demantra Demand Planning, Sales and Operations, Shop Flor Management, AP, OM, Shipping, Advanced Pricing, MSCA, Quality and configurator Modules.
• Expertise in gathering user requirements, preparing functional and technical specification documents and detailed design documents and GAP documents.
• Expertise in conducting business reviews and walk through key decisions to finalize TO BE business processes based on requirement gathering.
• Expertise in identifying teh gaps and provide custom solutions and develop custom modules to meet teh business requirement.
• Expertise in documenting AS IS and TO BE business process flows.
• Experience in designing teh business processes and mapped wif oracle, prepared GAP documents, BR100, MD50, CV55, TE40 documents and conducting CRP’s, UAT, Cut Overs.
• Implemented various business models like Build to Order, Outside Processing, Vendor Consignment, Min - Max Planning, Drop Ship, VMI, OEM, MTO, Reship, Build Ahead, DIST Models, Cycle Counting and other Stock replenishment planning methods.
• Expertise in conducting business user trainings and documenting SOP’s.
• Defined various configuration setups in ASCP, Demantra, Supplier Scheduling, GOP, iProcurement, iSupplier, Purchasing, Inventory, BOM, WIP, Costing, OM, Shipping, Shop Flor Management, AP and GL.
• Expertise in Oracle AIM Methodologies.
• Worked wif oracle support to resolve issues including severity 1type of issues and through OWC. Actively participated in multiple oracle webinars to gain /upgrade noledge
• Having global exposure worked wif business users from US, Mexico, Canada, Philippines, UK, China, Brazil and wif onsite/offshore model.
• Ability to perform under pressure wif technical problems, excellent communication, inter-personal, technical, project management and team management skills. Has performed roles of hands on Application Developer, Support, and Team/Module lead heading 2-4 team members.
• Demonstrated ability to work independently, and teh flexibility to adapt in an ever-changing business environment, extremely quick learner wif very less ramp up time for a new technology.

TECHNICAL SKILLS:

ERP: Oracle Cloud Fusion R11 and Oracle R12, Oracle 11i,R12.1.3 and R12.2+

Modules: INV, BOM, WIP, Costing, ASCP(Constraint and Unconstraint plans, Distribution Plan, ATP/GOP, Oracle Demantra(DP&RSOP), Colloborative Planning, Supplier Scheduling, Production Scheduling, Shop Flor Management, PO, EAM, Procurement, AME(Approval Management Engine), iSupplier, AP, RLM, OM,Shipping,MSCA,GL, Configurator, SLA and WMS.

Tools & Framework: Discoverer and OAF

Oracle: Oracle Forms &Reports, SQL/PL&SQL, Toad, Workflow SQL Loader

DBMS/RDBMS: Oracle 10g/9i/8i, MS ACCESS 2000.

Defect/Bug Tracking: JIRA, HP Quality Center, Wincvs

Infrastructure Software: MS Projects 2000, Dream weaver and other office

PROFESSIONAL EXPERIENCE

Confidential, Wisconsin

Oracle Functional Consultant

Environment: 11.0.3, 11i, R12.1.0.3

Responsibilities:

• Responsible for gathering teh business requirements and documenting teh AS IS/TO BE business processes and GAP documents.
• Responsible for conducting key decisions meeting wif business to recommend teh best possible options which matches wif business processes.
• Responsible for end to end implementation for Oracle ASCP, GOP/ATP, Demantra demand management, Supplier Scheduling, Purchasing, Inventory, BOM, WIP, Costing.
• Responsible for providing criteria/logic to convert data from third party systems to Oracle database.
• Work closely wif key business users in data validation, which plays major role in constraint and unconstraint planning and provide complete details on oracle attributes.
• Conducted Scoping, Dry Run’s, CRP’s, UAT, Production Cut Over activities and Go Live
• Responsible for user training on Master scheduling and Production scheduling and inline to production line rates.
• Responsible for training material planners and schedulers in using teh plans and use of various time fences, Item attributes and other planning constraints. Make understand of safety stock calculation(Manual and MRP planned), Pegging etc.
• Responsible for Configuring demantra data model and setup teh forecast hierarchy, levels, series and trained users on worksheet analysis.
• Responsible for loading teh data into demantra T SRC tables and run EP LOAD process every month and run analytical engine to generate forecast and coordinate wif business to get forecast approval and publish to ASCP.
• Responsible for training demand planners on worksheet analysis and forecast analysis.
• Responsible for completing key customer setups, sales and brand forecasting data review and tuning, and RLM forecasting consumption process design, and preparation of teh test scripts, SOP(Standard Oracle Procedures)CV55, MD50 design documentation and TE40 testing specifications.
• Responsible for pushing plan information for raw material and generating forecast to communicate to suppliers.
• Potential to understand teh each function-process issues and demonstrate teh solution design to IT and business teams and pull teh team on same thought lines
• Responsible for designing teh distribution planning process across USA and Mexico warehouse, main plants and feeder plants which covers teh Century, Hermetic motors, generators business
• Responsible for training super users and end users on various business processes.
• Updated Requirement Specification Document based on time to time Change Request as well as modifying teh related functional design document and processing those changes into teh development team for incorporation of such changes.

Confidential

SCM Techno Functional Consultant

Environment: 11i Oracle E-Business Suite

Responsibilities:

• Involved in gathering teh business requirements from teh users.
• Developed Business Process design documents.
• Developed AS-IS and To- BE diagrams.
• Prepared BR100 configuration documents and requirement traceability matrix.
• Involved in configuration setups of procurement and purchasing module.
• Prepared MD 50 & MD 70 document for various functional and technical customizations by looking into teh specified requirement document keeping in mind teh impact analysis.
• Updated Requirement Specification Document based on time to time Change Request as well as modifying teh related functional design document and processing those changes into teh development team for incorporation of such changes.
• Customized PO Requisition and PO Workflows.
• Developed various business flows for user training sessions.
• Involved in Functional test script development and SIT and UAT testing
• Prepared training materials for iProc and PO and trained end users.
• Involved in resolving issues related to JCI business processes.

Confidential, Warrenville, Illinois

SCM Techno Functional Consultant

Environment: Oracle R12

Responsibilities:

• Involved in gathering teh business requirements from teh users.
• Prepared BR100 configuration documents, MD 50 & MD 70 document for various functional and technical customizations and requirement traceability matrix.
• Involved in configuration setups of purchasing, procurement and inventory modules.
• Developed various business flows for user training sessions.
• Customized teh Purchase Requisition and PO Approval workflow.
• Involved in developing teh Oracle Alerts, XML reports.
• Customized teh Purchase order print order report.
• Involved in updating teh vendor details using Standard API’s.
• Involved in resolving issues related to NEC business processes.
• Identification of bugs and implementation of any changes/enhancements made to application.

Oracle

Confidential

Responsibilities:

• Involved in noledge transition from teh implementation team about teh celgene business processes.
• Worked wif Business Users on a daily basis, providing functional support to ensure successful flow of Business processes.
• Involved in preparing teh MD50 and MD70 documents for customizations and enhancements.
• Tracking all issues logged by end user and provided functional solutions.
• Escalate and assisted wif any problem resolution activities related to these environments.
• Troubleshooting and solving issues related to BOM, WIP, Costing, PO, INV, Iproc, OM and ASCP.
• Customized teh Invoices print report.
• Developed teh interfaces to import items and sales orders from legacy systems.
• Writing Test cases and Executing Test cases.
• All new functionality has been delivered on schedule wif excellent quality and performance.
• Identification of bugs and implementation of any changes/enhancements made to application.
• Attending weekly status meeting wif teh team and updating status of teh issues.

Confidential, New Jersey

SCM&MFG Techno Functional Consultant

Responsibilities:

• Responsible for implementing Manufacturing and Planning modules.
• Responsible for gathering teh business requirements and map to teh oracle processes.
• Involved in noledge transition from teh current business processes and support configuring teh oracle BOM, WIP, ASCP, Costing, PO, Procurement, OM, Pricing, AP, GL and isupplier.
• Responsible for conduction CRP’s, SIT, UAT and Go Live activities.
• Worked wif Business Users on a daily basis, providing functional support to ensure successful flow of Business processes.
• Responsible for documenting BR100, GAP Analysis, MD50 and MD70 documents for customizations and enhancements.
• Responsible for training end users and documenting SOP’s.
• Tracking all issues logged by end user and provided functional solutions.
• Escalate and assisted wif any problem resolution activities related to these environments.
• Responsible for gathering teh custom business requirement and design teh solution to map business process
• Responsible for coordinating wif technical team to design teh interfaces, conversion programs and RICE components .
• Writing Test cases and Executing Test cases.
• Identification of bugs and implementation of any changes/enhancements made to application.
• Attending weekly status meeting wif teh team and updating status of teh issues.

Confidential

Oracle Techno Functional Consultant

Responsibilities:

• Team member as Functional Consultant for Oracle apps Purchasing,Procurement and Inventory modules
• Handling PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, Granting and Revoking Schema Object Privileges and Roles, Responding to System Events through Triggers.
• Performing teh setups as per teh BR100 documents
• Understanding MD50 documents
• Preparing Test documents
• Perform teh testing as per teh test scripts in teh Test documents
• Guiding teh technical resources while developing teh interfaces and batches.