Praveen Kumar Panchangam

  • Oracle Supply Chain Management / Techno functional consultant
  • New York City, NY
  • Member Since Apr 04, 2023

Candidates About

 

Praveen Kumar Panchangam

Summary                               

·         Around 14+ years of experience in Oracle Supply Chain Management domain modules as a Techno functional consultant in Implementation (R12), Re-Implementation, Upgrade (11i to R12), Customer Support & Maintenance, Development, Migration and Patch management type of project.

·         Expertise in modules like Order Management, Advance Pricing, Oracle Purchasing, I Procurement, Shipping, TCA (trading community Architecture), Oracle Inventory, Oracle Payable,Quotations

·         Basic knowledge on Oracle receivable, Oracle General ledger, AME(Approval Management Engine) WIP, Territory Management ,BOM,WMS, Oracle PIM(Product information Management) Modules.

·         Excellent knowledge of, AOL, Oracle Alerts.

·         Expertise in SQL, PL/Sql, Forms, Reports, Workflow, SCM API’s, Manufacturing API’s.

·         Worked on RICEFW components

·         Worked on Performance tuning

·         Expertise in Order to Cash and Procure to Pay Processes.

·         Expertise on Patch Management Project – Worked as Technical consultant on the Pull back of customization in upgrade project of the Upgraded components for SONY Electronics.

·         Competence in Customer Support and Maintenance Projects – Worked for 5 years for the Support and Maintenance project for the CISCO Client in providing the technical and functional Support for all the High – low priority issues.

·         Worked as a onsite coordinator for 2.5 years for the C3 support handling multiple tracks, critical priority incidents and as a tower lead for ITIL towers(Change Management, release management, Incident Management, Problem Management) at client location (USA, San Jose).

·         Worked at Onsite (Sweden, Norway) during the kick off and knowledge transition phases for the TELIA AMS project.

·         Aware of the Migration process.

·         Competency in Development Projects – Worked on development of the forms, reports, interfaces.

·         Perform setups for Order Management, Purchasing, and Inventory using BR100.

 

Domain expertise: Supply chain Management Modules.

Other expertise: Expertise in Cisco specific Release management process, Change Management processes, Problem Management Process.

Certification:

1 RAPID Bronze certified for the Oracle Configurations.

2 Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist: Oracle Purchasing

-          Certified by ORACLE

3 Oracle SCM Functional consultants - Certified by WIPRO,

4 Oracle Technical consultant – Certified by WIPRO

 

ERP:

Packages :

Oracle Apps (11.5.8,11.5.9,11.5.10,Release 12)

Modules:

Oracle Supply Chain Management, Order Management, Purchasing, Inventory,  CRM, Oracle Alerts, Oracle PIM, TCA, Advance Pricing, Payables, Receivables,WMS,WIP, BOM, MSCA

Language

Programming:

Internet Script Language

SQL, PL/Sql, Forms 6i, Reports 6i, Reports10g,Forms 10g ,XML,AOL, Apps Developer, sysadmin, Form Personalization, OAF Personalization , custom .pll, using LDT, using data loader, Workflow, XML Publisher.

Database:

Oracle 8i, 9i.

Operating System

Sun Solaris, Windows 98,2000,XP

Tools

Toad, SQL Plus, SQL Navigator.

Others

Metalink

 

Trainings Attended:

Course Name

Conducted By

Fundamentals of OAF, Java

Conducted by WIPRO(Internal)

Fundamentals of Oracle Inventory, BOM, WIP, Purchasing and Order Management, Advance Pricing, WMS, MSCA

Conducted by WIPRO(internal)

SCM Functional Modules

Conducted by WIPRO(internal)

Oracle Technical consultant

Conducted by WIPRO

Oracle Cloud Procurement

Conducted by Oracle

Oracle Cloud SCM foundation

Conducted by Oracle

 

Education

·         Master of Computer Application from Osmania University, India – 2002

·         Bachelor of Science from Osmania University, India – 1999

 

Professional Experience

 

Project: INTEGRA Life science                                                                           May 2017 – Till date

 

Description:

Integra LifeSciences Holdings Corporation (Nasdaq:IART), a leading global medical technology company, today announced that it has launched in Europe Integra® Dermal Regeneration Template (IDRT) Single Layer "Thin" for dermal repair defects reconstruction in "one-step" procedure.

Integra® Dermal Regeneration Template Single Layer "Thin" is the latest extension of Integra's collagen range of dermal repair products. Since the introduction of IDRT in 1996, the brand portfolio has expanded to include single layer, bilayer and flowable versions. This latest addition reinforces the company's proven advanced collagen technology for more than 20 years in a variety of indications, including life-threatening burns, scar revisions and diabetic foot ulcers.

"The European clinical community has been looking forward to the market release of Integra Single Layer Thin, the thinnest dermal substitute available," said Stéphane Corp, vice president of Tissue Technologies in Europe.  "We will now be able to provide plastic and reconstructive surgeons a thinner matrix for dermal repair they can use in a single-stage procedure, while maintaining the same aesthetic and functional benefits of a two-stage procedure, which will ultimately reduce overall hospital stays for patients."

Integra® Dermal Regeneration Template Single Layer "Thin" will be marketed by Integra's European Tissue Technologies sales organization in Europe, the Middle East and Africa and by Integra's Canada and Latin America Sales organization later this year.

 

Responsibilities:

 

  • Understand the requirements and provide the technical/Functional design solution.
  • Work with Offshore team to get the development status
  • Part of AMS provide Functional and technical support to O2C and P2P module tickets.
  • Participate in the Monthly release cycle to provide the development task status.
  • Participate in the Change management review meeting in getting the changes approval for the Monthly release.
  • Presenting the highlights and monthly status report of support and development metrics to WIPRO Management.
  • Participate the code review of changes done by developer to review the standards.
  • Mentor/Guide the developer on the required skills.
  • Work on Complex performance tuning.
  • Manage overall development tasks.
  • Provide the Technical support on the AMS priority issues.

 

Project: Fruit of the Loom                                                                             Jun-2016 – May 2017

 

Description:   

Fruit of the loom is one of the largest manufacturers and marketers of men's and boy's underwear, women's and girl's underwear, printable t-shirts and fleece for the active wear industry, casualwear, women's jeans wear and children’s wear. The company employs more than 32,000 people worldwide.

 

Fruit of the loom also controls another long-known underwear brand, B.V.D. (Bradley, Voorhees, and Day). Other brands also manufactured and sold by the company are Funpals/Fungals, screen stars and Underoos.

 

This is a R12 oracle application roll-out project. Fruit of the loom has implemented Oracle application in two of their divisions Vanity Fair and FOTL, now the roll-out is for Spalding division. Project involves Oracle applications R12 roll-out of financials, Procure to Pay, Order to Cash and Planning. Project scope includes oracle application integration with multiple third party systems

 

Responsibility:

handling 2 projects part around the AMS EBS enhancements

 

EBS enhancements: This project is the enhancements related to any business requests.

I am working on understanding, development of the business requirements for few of the change request

BTP 3.0: Rollout for the Order to cash and Procure to pay modules part of HUFFY and SPALDING.

 

I am part EBS enhancements we are responsible

  • Requirement gathering for the Spalding and Huffy.
  • Provide technical and functional design.
  • Participate in the Change management review meeting in getting the changes approval for the Monthly release.
  • Presenting the highlights and monthly status report of support and development metrics to WIPRO Management.
  • Participate the code review of changes done by developer.
  • We are responsible for all the conversions data from legacy to Oracle.
  • Retro fitments of the existing components to accommodate the Huffy/Spalding data.
  • Technical design for any new customization part of the implementation.
  • Provide the support for any user testing issues in the cycles.

 

DentaQuest, Boston, MA

Techno functional Consultant                                                                                                            Nov 2015 – Jun 2016

 

Description:

DentaQuest is the third largest dental benefits administrator in the United States, but they are one-of-a-kind in the

approach they take to improving oral health. The innovative dental benefits solutions they offer to their clients are

delivering better outcomes at a lower cost to approximately 20 million members across the United States DentaQuest

has chosen Wipro as its strategic partner to implement a stable and agile platform leveraging Oracle E-Business Suite to

help enable and implement procurement functionality. This program will allow DentaQuest in benefiting by migrating to

E-Business Suite based automated solution which provide the required controls, compliance and savings that achieve

The IT and Business Charter.

 

Responsibility:

  • As part of this implementation project working with business in understanding the current business process.
  • Participate in the CRP to demonstrating the procure to pay end to end process including the I procurement module.
  • Perform fit gap analysis to conclude the customization requirements.
  • Participate in the design phase to design custom requirement.
  • Build the conversion program for the ADP employee load for the requisition approval hierarchy, FND user load for Iproc access, Customize the PO XML template, Create PO custom report as per the requirement.
  • Perform the OAF personalization.
  • Participate in SIT, UAT, prepare the cut over document.
  • Participate the GO-Live and provide the post go-live support.

 

COBHAM, Prescott, AZ                                                                                                        Jul 2015 – Nov 2015

Business analyst: SCM

Cobham offers an innovative range of technologies and services to solve challenging problems across commercial, defense and security markets, from deep space to the depths of the ocean. It has market leading positions in air-to-air refueling; aviation services; audio, video and data communications, including satellite communications; defense electronics; life support and mission equipment. Cobham is upgrading its ERP from Syspro to Oracle EBS R12. Current project is to rollout for Prescott Site.

 

Responsibilities:

  • As part of this implementation project working with business users understanding the current business process and demonstrating the ERP end to end process for the legacy business processes to user through CRP.
  • Understanding the legacy objects and mapping it with Oracle ERP RICEFW component perform the fit gap analysis for the RICEFW components and create a change requests for the gaps.
  • Participate in the Change management, release management activities.
  • Perform the ERP application Sysadmin activities (Responsibilities creation, assigning MOAC, Security profile)
  • DBA activities coordination.
  • Work on the Install base conversion program.
  • Perform the application configurations based on the config snapshot, prepare the BR100.
  • Perform the setups using the BR100.
  • Perform end to end testing after the setups.
  • Guide users through the ERP end to end business process.

 

Emerson, OH                                                                                                                               Jul 2013 – Jun-2015

Lead Engineer

Team Size:10

Project: Emerson Therm- O- Disc implementation(TOD) project

Description: Therm-O-Disc, Inc. is the world's largest producer of bi-metal disc controls. Founded 1947 in Mansfield, Ohio, USA, Therm-O-Disc is a subsidiary of Emerson Electric Company and a part of Emerson Appliance Solutions and Emerson Climate Technologies. The company is recognized by itself as a world leader in the design and manufacturing of temperature sensors and controls for the HVAC, appliance, automotive, and electronics industries.

Emerson TOD R12 Re-implementation is one of the projects of Emerson Electricals company and need their application to be implemented R12 from their current version of oracle 11i to support their SCM business of Bi-metal disc controls across China, Hong Kong, Japan, Netherland, United Kingdom and United states.

As part of this project we are re implementing the SCM modules in oracle Application R12 from current oracle 11i instance, perform the setups based on BR100, identify the impacted objects, participate in the CRP’s with the customer, perform the retro fitment of the custom objects, test the functionality after retro fitment, support during the SIT, UAT, participate during the cutover and provide the Functional/technical support to the customer post production go live.

 

Responsibilities:

 

My roles and responsibility as a lead engineer in application maintenance Project.

  • Currently we are managing the ERP application support for the SCM and Finance

 

My roles and responsibility as a lead engineer in Re implementation Project.

·         Perform the functional setups in OM, advance pricing, Purchasing.

·         Manage the onsite and offshore Technical team and plan the delivery of the retro fitment, migration of the components as per project time lines.

·         Perform the Retro fitment of all the impacted objects during the design phase and move them to the Release 12 instance.

·         Test all the functional flows after re implementation in release 12.

·         Provide the support for all the functional flows during SIT.

·         Plan the production release, participate in the cutover phase, and provide the Post production support for any issue.

My roles and responsibilities as a Lead engineer in JAPAN rollout project.

·         Perform the INV, OM, Advance pricing setups for the new Japan Operating unit.

·         Work on developing the Conversion for Master Item, Organization items, item categories, customer, Supplier data, ASL, GL code combination.

·         Perform Item master, item categories, parties, party sites, Supplier and Supplier sites data load into R12.

·         Test all the functional flows after retro fitment in release 12.

·         Provide the support for all the functional flows during SIT.

·         Develop the custom XML publisher report.

·         Plan the production release, participate in the cutover phase, and provide the Post production support for any issue.

 

Environment: Oracle Apps release12, Oracle SCM Modules, Kintana, PVCS, Data loader, metalink

Operating System: Sun Solaris

 

Emerson, India                                                                                                                           Sep 2012 – Jun 2013

Techno functional consultant

Team Size:15

Project: Emerson TS-R12-Upgrade

Description: Emerson Electric Company is an American multinational corporation headquartered in Ferguson, Missouri, United States. This Fortune 500 Company manufactures products and provides engineering services for a wide range of industrial, commercial, and consumer markets. Emerson is one of the largest power equipment

Manufacturers in the USA.

Emerson R12-TS-Upgrade is one of the projects of Emerson Electricals company for the is the Emerson commercials and Residential Solutions business unit which is implemented on Oracle Application 11i instance to support their SCM (Supply chain Management) business of electrical products across the world and Customer would like to Upgrade this Project to oracle application Release 12 instance.

As part of this Project we are upgrading the oracle Application 11i to release 12, identify the impacted objects, perform the CRP with the customer, perform the retro fitment of the custom objects, test the functionality after retro fitment, support during the SIT, UAT, participate during the cutover and provide the Functional/technical support to the customer.

 

Responsibilities:

My roles and responsibility as a lead engineer in Upgrade Project.

·         Perform assessment to identify the impacted Objects due to upgrade.

·         Manage the onsite and offshore Technical team and plan the delivery of the retro fitment of the components as per project time lines.

·         Perform the Retro fitment of all the impacted objects during the design phase and move them to the Release 12 instance.

·         Test all the functional flows after retro fitment in release 12.

·         Provide the support for all the functional flows during SIT.

·         Plan the production release, participate in the cutover phase, and provide the Post production support for any issue.

 

My roles and responsibility as a lead Engineer in Production support/change requests 11i instance

·         Understand the customer requirement, perform the technical/setup change and perform the UIT.

·         Investigate on the current production issue and provide the resolution.

·         Create a Purchasing approval hierarchy as per customer need.

·         Create item category structure, category set, modifier setups for the customer requirement of introduction of new product line.

 

Environment: Oracle Apps release12, Oracle SCM Modules, kintana, PVCS, Easy U, Data loader

Operating System: Sun Solaris

 

Cisco, India                                                                                                                                 Apr 2012 – Sep 2012

Lead Consultant - Offshore

Team Size: 10

Project: CISCO MDM - IH

Description: Cisco's Business Intelligence and Data Systems (BIDS) Item  Foundation (IF) organization is dedicated to improving

Item Hub - an enterprise data management system that centralizes all product information from heterogeneous systems.

Item Hub and the eGenie user interface(UI) creates a single view of product information that can be leveraged across all relevant functional departments.

Moreover, Item Hub provides a unified access control-based workflow process for the creation, enrichment, and maintenance of Cisco commercial items.

The eGenie is application provided to customer to Create/Update the Item/Products and use the user defined attributes.

This Project is based on the Oracle Standard PIM(Product Information Management)

 

Responsibilities:

·         Interact with the Client in requirement gathering and understand the BRD for the changes on the custom components of application eGeine.

·         Prepare the TCD for the changes and work with the teams to incorporate the changes.

·         Coordinate with the QA teams to perform the end to end testing.

·         Migrate the changes to the Production environment.

·         Provide the Post production support to stabilize the application.

·         Sharing the Knowledge through Knowledge Transition to the application support team (ITDS).

·         Provide the normalization support after Golive.

·         Assigning the development tasks to the team rainbow and guide them in completing the tasks.

 

Environment: Oracle Apps release12, CDB, Oracle PIM (Product information Management),kintana, PVCS

Operating System: Sun Solaris

 

Cisco, India                                                                                                                                Nov 2011 - Mar 2012

Tech lead- Offshore

Team Size: 25

Project Name: CISCO Systems ERP – Nile(RCDN Migration)

 

Project Description: Cisco is the Client which provides services to the almost all the customers over the world. Cisco C3 (Customer Care System) is Custom Centric Project dealing with the Support Organizational Concepts. This Project has various Modules starting in CRM, Order Management, B2B, Finance and Inventory. TAC is the technical Assistance Centre component of the whole system which involves the modules like CRM, SRM, TCA, Planning, OM, shipping. In this project I am dealing with the Migration of the oracle 11.5.10 instance from SJ to the RCDN environment with upgraded architecture.

 

Responsibilities:

My Responsibilities involve

·         Perform analysis on the Custom programs required changes in the custom code in the new environments.

·         Work with the team to perform the Load testing for the programs, work with the performance team to tune the required queries.

·         Provide the functional and technical support to the QA team.

·         Migrate the Customized components to the new environment

·         Perform End to end functional testing for the Bolt on applications.

·         Work on the QA TD’s to provide resolutions.

·         Sharing the Knowledge trough Knowledge Transition to the application support team..

 

Environment: Oracle Apps 11.5.10

Operating System: Sun Solaris

 

Cisco, CA                                                                                                                                     Mar 2009 - Oct 2011

Techno Functional Consultant – San Jose, California

Team size: 25

Project Name: CISCO Systems ERP solutions CISCO (US)

 

Project Description: Cisco is the Client which provides services to the almost all the customers over the world. Cisco C3 (Customer Care System) is Custom Centric Project dealing with the Support Organizational Concepts. This Project has various Modules starting in CRM, Order Management, B2B, Finance and Inventory. TAC is the technical Assistance Centre component of the whole system which involves the modules like CRM,SRM,TCA, Planning, OM, shipping. I work with the GPS (Global Product Support) Centric Module of C3 System I have acquired the knowledge transition on various components of OM, Workflow, TAC, ENT which involves setup forms, reports, interface programs, CPR interfaces, OMAR interfaces, SVO Alerts, Holds, Queues, Oracle Alerts in OM module of SSC and TAC Track and supporting those components which includes functional and technical support of the issues and enhancements. Well versed with the Order cycle of different types of orders.

 

Responsibilities:

My Responsibilities involve

·         Solving issues raised by user of OM track like SVO tool Issues, Address Search Issues, Queues, Holds, Workflow, Issues, Oracle Alerts, SVO Alerts, User upload Programs, geo Maps, Single Assignment.

·         TAR Management (interaction with oracle).

·         Working with Business on the Issues raised.

·         Performance issues management.

·         Change management, Release management, Incident Management.

·         Monitoring Jobs through Dollar U and taking actions on failures.

·         Analyzing the issue and raising the Project request with the Root cause details also the code fix for the Issue’s.

·         Involved in various test cycles for different components.

·         Workflow Issues and Monitoring.

·         Call up End user and Resolve the issues.

·         Resolve Contract issues, User profile issues.

·         Created reports using BO (Business Objects) for Business reporting purpose

·         Take the KT’s on Enhancements and bug fixes from the other team and support them in future.

·         Preparing the transition document for the components.

·         Sharing the Knowledge Using Knowledge Transition.

Environment: Oracle Apps 11.5.10