SUMMARY:

• Over 15 years of experience as a techno - functional consultant in Oracle-EBS (Cloud and On-Prem) implementation, development and support.
• Has strong business knowledge in multiple business areas with expertise in a wide range of Oracle Supply chain modules.
• Extensive experience in Oracle Value Chain Planning modules like Demantra DM /SOP and ASCP.
• Experience in all phases of design, development and implementation of Oracle Cloud SCM, Oracle on-prem SCM modules like Inventory, Order Management, Purchasing, WIP.
• Experience in design and development of integrations with other third-party system using Middleware like Oracle Integration Cloud and SOA.
• Expertise in design and development of RICE objects using SQL/PLSQL, Oracle Reports, Forms, XML/BI Publisher using OS level Windows and Unix
• Experience in EDI -gateway integration with Oracle.
• Experience in different development methodologies including Agile, Waterfall.
• Expertise in AIM Methodology, Documentation, Configuration of Applications, Testing, End-User .
• Adept at facilitating sessions, defining user requirements, delivering end-user, creating and maintaining project schedules.
• Worked extensively in team-oriented environment with strong Trouble-shooting, Analytical, interpersonal and communication skills.

TECHNICAL SKILLS:

Oracle EBusiness Suite: Oracle Cloud R13/R12, Oracle Applications (On-Prem) R12/11.5.X/10.7

Oracle ERP Modules: Oracle Cloud Order Management, Planning Central, Log-fire.

OnPrem: Oracle Demantra, ASCP, Order Management, InventoryManufacturing, Purchasing.

Middleware: Oracle SOA, Oracle ICS

Development Tools: Oracle Forms, Oracle Reports, J-developer, SQL Developer, TOAD

Programming Languages: SQL and PL/SQL

Application Server: WebLogic, Oracle Application Server

Operating System: Unix/Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Oracle Cloud Techno/Functional consultant

Responsibilities:

• Worked with business to gather integration requirements.
• Prepared the technical design document for all the interfaces.
• Validated and Tested various webservice APIs in Oracle to Load Data.
• Setup the Plan Options, Dimensions, Measures, Exceptions in Planning Central.
• Developed various Dashboards and reports in Oracle Planning Central.
• Developed Program in ICS to import and export data from Oracle Cloud.
• Conducted CRP Testing sessions.

Environment: Oracle Planning Central Cloud R13, Glovia Legacy System, Oracle Integration cloud, BI Publisher.

Confidential, Atlanta, GA

Oracle Cloud Techno-Functional consultant

Responsibilities:

• Worked as a Techno/Functional where responsibility was to deliver all the SCM integrations on time with utmost quality.
• Worked with functional team to analyze the integration requirement.
• Tested various webservice APIs in Oracle Supply chain Cloud for importing data to cloud.
• Designed and Developed Interfaces (Inbound/Outbound) between Oracle Cloud ERP and third-part application using Oracle ICS.
• Designed/Develop complex end to end integration of licensing of KIT Item in Oracle with SLK applications and Logfire.
• Prepared Unit Test cases for the integrations.
• Designed and Developed various BIP reports in Oracle cloud.
• Prepared various Test data in CPQ, Inventory and OM modules in Cloud.
• Worked on performance testing and load testing for Interfaces
• Worked with team in various phases of testing like CRP, UAT and Cutover activities.

Environment: Oracle ERP Cloud R13, Oracle Integration Cloud, SLK System, SalesForce.com, LOGFIRE, BI Publisher, Oracle CPQ.

Confidential, Orange County, CA

Oracle Cloud Techno-Functional consultant

Responsibilities:

• Worked as a Techno-Functional for this project and managed delivery of all technical components of this project.
• Designed and Developed Interfaces (Inbound/Outbound) between Oracle OM Cloud and Third-party EDI vendors like SPS Commerce and B2B Gateway for B2B Customers.
• Designed and Developed Interfaces between Magento - Oracle OM Cloud to capture Orders for B2C customers using Oracle order import web services.
• Designed outbound Interfaces from Oracle SCM Cloud to downstream WMS (Logfire) using Logfire REST APIs.
• Designed and Developed Interfaces from WMS to Oracle SCM Cloud using Oracle Shipping/Receiving web services.
• Designed various interfaces between Oracle and 3PLS like Walker-UK and Janco-HK.
• Designed and Developed Interface between Logfire and Carrier Services like USPS.
• Developed various Custom BIP Reports across modules.
• Worked on Unit Testing and Test data creation in various modules of Oracle Applications.
• Performed volume testing and load testing of various interfaces.

Environment: Oracle ERP Cloud R13, Oracle Integration Cloud, EDI Gateway, Magento E-Commerce, LOGFIRE, BI Publisher.

Confidential, Cupertino, CA

Demantra Consultant

Responsibilities:

• Worked on Requirement Gathering process and Fit/Gap Analysis.
• Worked on the Solution Design of Demand Planning process.
• Worked on Configuration of level hierarchy and dimensions in Demantra.
• Configured various series and measures in Demantra.
• Setup Forecast tree, system and engine parameters.
• Configured various Integration Interface profiles in Demantra.
• Configured Methods and workflows in Demantra.
• Designed and developed various Custom Programs in Demantra.
• Prepared Design document for Demantra collection programs.
• Configured various worksheets, Dashboards and KPIs in Demantra.
• Configuration of SSO and SSL.
• Performed end to end testing of application and custom programs.

Environment: Demantra 12.2.6, Weblogic, Linux, Oracle Database 10g

Confidential, Cupertino, CA

Demantra Consultant

Responsibilities:

• Worked on the Requirement Gathering Process for the enhancement and Analysis of the requirements.
• Prepared the Solution Design process.
• Developed custom Programs for new enhancements.
• Performed Unit Testing of the custom development.
• Created and modified Demantra Series.
• Configured Integration interfaces, Methods and Workflows.
• Worked on Upgrading Web-logic Upgrade from 10.3.5 to 10.3.6.
• Worked on Upgrading Demantra 7.3.1.4 to Demantra 12.2.5.1.
• Worked on Deployment of Demantra on Web-logic.
• Worked on Regression Testing of Application Post Upgrade.
• Worked with Oracle on bug fixing and applying application Patch.

Environment: Demantra 12.2.6, Weblogic, Linux, Oracle Database 10g

Confidential, Houston, TX

Technical Consultant

Responsibilities:

• Analyzed requirement with Functional consultant and Prepared Technical design for the customization.
• Worked in modifying oracle standard RPD (OBIEE) to add and modify fact and dimension entity.
• Designed and Developed Custom Archive program to populate additional data element in APCC.
• Developed program to extract pegging details from ASCP and create tree structure for Custom OAF form.
• Developed Procedures/Triggers to populate notes in PO Requisition and WIP.
• Created various views for Custom OAF Forms.
• Developed custom program to interface Changes in work order in APCC with ERP system.
• Performance Tuning of custom programs.
• Created reports, dashboards and KPIs in APCC
• Participated in all phases of Testing including CRP and Unit Testing.
• Conducted User of configuring reports.

Environment: Oracle VCP Suite R12, Oracle Database 10g, OBIEE, OAF, Linux.

Confidential, Hanover, MD

Demantra Consultant

Responsibilities:

• Worked on the requirement gathering process for Collaborative Planning and Forecast Replenishment. in the Solution Design process.
• Worked on Configuration of Level, series, integration Interface, Workflow and worksheets in Demantra.
• Configuration of Causal Factor.
• Configured Accuracy measure dashboards using MAPE, MAD, and WMAPE Series.
• Designed and developed various collection program like History, item Hierarchy, Location Hierarchy, Backlog, Demands, plan order, On-hand, Safety stock and Purchase order information to Demantra.
• Designed and developed programs to populate forecast adjustment series to match the supply plan Revenue.
• Performance Tuning of custom programs.

Environment: Demantra 12.2.3, Weblogic, Linux, Oracle Database 10g

Confidential, Seattle, WA

Oracle Cloud Demantra Consultant

Responsibilities:

• Part of requirement gathering process for Promotion and Settlement Management.
• Worked on Configuration/Set up in Demantra.
• Designed and developed various collection program like History, item Hierarchy, Location Hierarchy, Promotion, Deductions and Price list to Demantra.
• Designed and developed programs to interface settlement data from Demantra to CHRM using Oracle Standard API.
• Designed and developed programs to Interface Accrual data to Oracle GL.
• Designed and developed various reports.

Environment: Oracle ERP 11.5.9, Demantra 12.2.3, Weblogic, Linux, Oracle Database 10g, Oracle Developer Suite 10g

Confidential, Cleveland, OH

Technical Consultant

Responsibilities:

• Performed Requirement Analysis and Prepared Technical Design Document.
• Designed and developed Custom form for Master and Fill Rex batch creation, enable additional fields in Planners workbench.
• Designed and developed various reports using oracle xml publisher.
• Worked on Performance Tuning of custom programs
• Worked on Unit Testing of Customization.

Environment: Oracle ERP R12, Oracle Planning Suite R12, Demantra 12.2.3, Weblogic, Linux, Oracle Database 10g, Oracle Developer Suite 10g

Confidential

Demantra Consultant

Responsibilities:

• Worked with the Business team for business requirements gathering.
• Performed applications setup and configurations on Oracle Demantra Demand Management implementation.
• Designed & Developed interfaces for collection programs and publish the forecast to ASCP.
• Conducted Testing Session like CRP/UAT.
• Conducted User and Documentation.
• Worked on Post Go-Live Support.

Environment: Oracle ERP 11.5.10, Oracle ASCP, Demantra 7.3.1, Weblogic, Linux, Oracle Database 10g