SUMMARY

• 11 years of experience in Oracle Supply Chain Management
• Good exposure to Manufacturing, Order to Cash (O2C) and Procure to Pay (P2P) business areas
• Extensive experience in Design, Development and Production Support of Interfaces (Inbound/Outbound) Open Interfaces, APIs, web services, Business events, SQL, PL/SQL, forms personalization and tools like Forms, Reports, XML Publisher Reports, Workflows
• Technical and Functional expertise in Oracle modules like Order Management (OM), Purchasing (PO), Advance Pricing (QP), Inventory (INV), Work in Process (WIP), Bills and Routes, Trading Community Architecture (TCA), Account Receivables (AR), Account Payables (AP), Human Resources (HRMS)
• Basic understanding on Oracle APEX, ASCP module and Demantra
• In - depth knowledge on AOL (Application Object Library), AME (Approvals Management), Oracle Public APIs (Applications Program Interfaces), and Oracle Integrated SOA gateway
• Implemented Oracle Integration SOA Gateway for R12 release
• Skilled in Designing Business Process, customizing and developing new workflow as per the business requirement using Workflow Builder
• Good understanding on Oracle Application Framework
• Excellent communication and presentation skills
• Strong proficiency in problem solving, initiative taking, time management and Continuous Skill enhancement
• Self-motivated, proactive in completing the assigned tasks with more efficient manner
• Excellent communication and presentation skills
• Gained knowledge on Oracle cloud by attending Oracle University trainings on Procurement, Supply Chain Management, Integration cloud services and Human Capital Management

PROFESSIONAL EXPERIENCE

Oracle Techno Functional Consultant

Confidential

Responsibilities:

• Gather requirements to integrate Oracle Supply chain planning modules with SAP Request (Time Series) and Response (Order Series) modules
• Understand NetApp existing supply chain management business processes
• Understand the Requirements from the Business and suggest the Best Possible solution from Best Practices to integrate Oracle and SAP applications
• Design the data extraction process in Oracle in order to send the data to SAP cloud for forecast planning
• Create Data models and data sets and develop end to end integration between Oracle and SAP
• Design and develop UI’s to users for data maintenance
• Develop exception reports for the data that has not flown into SAP system to help business to correct the data if required
• Prepare high level Integration Strategy
• Participate in Sprint planning meeting to provide the inputs for Design and development effort estimations for the upcoming features
• Design and develop various complex views and database Packages, stored Procedures, Functions, Triggers, PL/SQL Collections, materialized Views, Oracle Text to process very complex structure of data in the Oracle application
• Independently prepare the data mockups to visualize how the data should be sent to SAP system
• Facilitate root cause analysis of any system/data issues
• Co-ordinate with offshore team to complete the development activities assigned to the team and provide the technical guidance in accomplishing the task
• Perform code review to ensure the code developed meets the business user requirement and is as per the NetApp standards
• Organize periodical meetings with offshore team to prioritize the enhancements or change requests, estimating the deadlines for the projects and quality deliverables
• Perform Unit testing, integration testing, performance testing
• Attend daily stand-up and update the development status along with the ongoing issues in the current Sprint

Oracle Technical Consultant

Confidential

Responsibilities:

• Fit Gap analysis between HTPG division and existing Oracle business processes
• Prepare design & unit testing documents
• Enhance the existing code to meet legacy system business processes
• Develop RICE components for the Gaps identified
• Perform End-to-end business testing which included OTM (Oracle Transport Management), iWarranty (Custom application) & High-jump (Warehouse Management) systems
• End user training to perform the transactions in Oracle e-Business Suite
• Plan cutover activities for data conversion before Go-Live
• Conduct Go-Live
• Post production Support

Oracle Data Conversion Consultant

Confidential

Responsibilities:

• Understand the business processes around manufacturing, Finance, Order management (Including Configurator) & Planning
• Convert the data from AS400 to Oracle EBS
• Prepare the conversion data definition templates
• Gather the data in the required format
• Design the conversions using Oracle Data Integrator
• Guide offshore team in building the conversions
• Master Data cleansing for Items, Customers and Suppliers
• Validating the data before converting into Oracle
• Define to-be processes and migrating models for Order Management Configurator
• Data validation with business to ensure the data has converted correctly to perform business transactions in Oracle
• Participate in CRP sessions across the modules to demonstrate the existing business processes in Oracle

Oracle Data Integrator Consultant

Confidential

Responsibilities:

• Coordinate with business users to collect the user defined attribute information from multiple departments
• Logical grouping of attributes, setup ICC & attribute groups
• Design the conversion using Oracle Data Integrator to transform the product information from existing systems to Oracle PDH
• Provide web-services for customers to consume the product details from PDH for Sales & Marketing
• Gathering the requirements from user for the XML reports across the oracle modules like OM, AR, AP, GL, INV, BOM, WIP and iWarranty
• Prepare functional design and technical design document
• Co-ordinate with offshore team for the development & enhancements of the reports
• Conduct unit testing, user acceptance testing
• Maintain code version in PVCS for version control, create PPM packages for code migration between multiple environments