Oracle Supply Chain

Neethu Karunakaran Pillai

***.****@*****.***

Summary

• Over 6.5 years of experience as IT consultant

• Experience with Oracle E-Business Suite / Applications as a Functional Analyst

• Strong Functional (60%) and Technical Knowledge (40%) in modules like Order Management, Purchasing, Inventory, Manufacturing and Supply Chain modules

• Thorough knowledge in OTC, P2P, Inventory, Manufacturing and Planning Cycle. Overview of Oracle Payables and Oracle Receivables

• Implementation / Testing / Support experience in core modules like Oracle Order Management, Oracle Purchasing and Oracle Inventory, Oracle Bills of Material, Oracle WIP, Oracle Costing,Oracle Payables, OPM and Oracle Receivables

• Proficient in designing and collecting requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration and AOL

• Excellent professional experience of setting up and supporting Oracle R12, 11i SCM Modules (PO,INV,OM ) & Financial Modules (AR, AP, GL)

• Responsible for documentations, setups, bugs, enhancement requests, escalations

• Involved in Project Management Activities like Prioritizing system problems, enhancement requests, scope management and status reporting to management

• Hands-on experience with SQL, PL/SQL, UNIX Shell scripting, Oracle Forms and Reports

• Fair Understanding of System Administrator, Oracle Alert and Workflow

• Experience in Production support and related Business process improvements

• Gathering User Requirements

• Understanding in building interfaces in Oracle Applications ERP systems and external systems

• Fair idea on conversion strategy to convert data from lower version Legacy System (11.0.3 to R12) to higher version of Oracle Application and coding interface programs for importing data from Legacy Systems

• End-user Training and Documentation

• Testing of Applications

• Worked on NA,EU and APAC Business processes

• Month End Reconciliations

• OA Framework start ups and hands on

• R12 BPEL start ups and SOA training experience

• Clear understanding of all key ITIL processes

• Practical Experience of working in Real time Business critical applications

• Accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, managed multiple projects and cross trained sub-ordinates in functional areas

• Excellent Communication and Inter Personal skills

• Good analytical and problem solving skills and writing /documentation skills

CERTIFICATION

APICS CPIM (CERTIFIED IN PRODUCTION AND INVENTORY AND MANAGEMENT)

DSP – Detailed Scheduling and Planning

MPR – Master Planning of Resources

BSCM – Basics of Supply Chain Management

SKILLS / TOOLS

• Oracle RDBMS: (Oracle 10g/9i/8i), SQL Plus, PL/SQL, Oracle Forms & Reports, UNIX

• ERP Software: Oracle Application 11i & R12 e-Business Suite

• Supply Chain & Manufacturing: Oracle Purchasing, Order Management/Shipping, Oracle Inventory, Advance Pricing, Bill of Material, Work in Progress, Engineering, Material Requirements Planning & Supplier Scheduling

• Financials: Oracle Receivables, Oracle Payables and General Ledger

• AOL, System Administrator, Application Developer, Oracle Alerts, and Oracle Workflow

• Oracle Applications: Versions R12/11i (11.5.10/11.5.9/11.5.8)

• Utility tools: Toad, PLSQL Developer

• Hardware/OS: Linux, UNIX and Windows,Microsoft Tools

ORACLE TRAINING

R12 Extend Oracle Applications, Customizing OA Framework Applications Ed1 PRV (Oracle Instructor Led)

EDUCATION

Bachelors in Electronics and Communication Engineering, India

PROFESSIONAL EXPERIENCE

Client – Ansell – IBM Oracle Implementation Nov 2011 – Till Date

Role: Functional Consultant

Description of the project -

The project is aimed at business transformation from legacy environment to Oracle R12.Implementation is planned over US, Europe and Australia. Currently involved in post-production implementation of US region

Roles and Responsibilities:

• As a functional lead, studied the current business process. Prepared AS-IS understanding document for Order Management, Purchasing,INV and custom modules for implementation in EMEA region

• Enhancement, Testing and Production Support of Business Applications in US

• Close Involvement with Oracle – WMS interfaces

• Functional and Technical support for Post production L2, L3 Issues (Bug Fixes and Enhancements)

• Preparation and review of Technical and Functional specifications, also responsible for system integrity testing (SIT) and user acceptance testing (UAT) before final migration of changes

• Worked on detailed features of Oracle R12 Advanced Pricing including Qualifiers and Modifiers

• Close interaction with CSR’s to understand their hurdles

• Worked with business on show stopper issues like Shipment issues, Invoicing issues, ASN issues,Inventory Issues, UOM issues and Order Download Issues during post production

• Worked closely with Oracle Support through SR’s on Delivery detail split issues, Freight charging on wrong freight term,Partial Pick Release and UOM issues

• Developed Data Collection templates for Data gathering requirements

• Hands on with various EDI interface Integration with WMS and Knowledge of key EDI interfaces (945,940,944,943,947,860,865)

• Worked in inventory reconciliation between Oracle and WMS

• Handled various oracle shipping issues like Partial shipment, Over shipment,Fractional shipments due to UOM bugs, Exception handling and Missing delivery lines in ASN all which were business show stoppers

• Involved in an L3 fix to apply a custom hold whenever the warehouse shipped partial based on business requirement

• Frequent calls with Client/User and the Functional Consultants

• Handled different business processes that span over US, Canada, Europe and Australia using different warehouses

• Framed key questionnaires to understand the current state of process/sub process of the client’s supply chain

• Involved in configuration setup like setting up Inventory Picking rule, UOM class and conversion, Organization Parameters and Freight Carrier and Customer and Credit setup

• Hands on experience with BMC Remedy tool and also on Incident, Change and Problem Management

Environment:

Oracle Applications 12.1.2 (INV, PO, OM, AP, GL, AR, Planning,Trade Management,i-procurement,e-commerce)

Software: Oracle 10g and PL/SQL, Reports/Forms 10.1.2, SQL, PL/SQL Developer, TOAD

Client - Motorola Mobility, Libertyville, IL Aug 2009 – Oct 2011

Role: Functional Lead for 20 Member team

Description of the project -

The project included developing new projects for the Motorola Mobility IT. Changes required as part of new product introductions, implementations, customizations and existing legacy system changes were done. Also included the Production support of end to end ERP system of Motorola including EDI (for Advance shipment notification)

Roles and Responsibilities:

• Implementation and Configuration of Oracle SCM and Finance modules

• Analyzed the “AS-IS” processes by interviewing Branch SME’s and information requests, documenting site visits and discussing day-to-day operations with branch personnel and business leaders .Created a Requirements list, detailed scenarios document, fit-gap analysis, RICE lists and configuration document

• Led Team in a project involving copying inventory orgs to create multiple orgs, Discrete Manufacturing project involving BOM,WIP and Costing.

• Conversion, User Training and Analyzing Business requirements

• Delivered session on business process and created documents to make presentation to the client

• Designed the “TO-BE” process flows (Industry print) based on business transformation vision and got consensus among various stakeholders to approve the said design

• Performed GAP analysis and prepared solution presentation for review

• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces

• Prepared Mapping document BR.030 and setup document BR.100 for a customization in Purchasing module

• Mapping responses to questionnaires on varying levels of maturity model

• Testing of various test scenarios of Requisition to Purchase Order cycle in Oracle Purchasing

• Understood existing interfaces and provided AS-IS documents

• Performed CRP tests at client’s location

• Setting up the Oracle Order management, Purchasing and Inventory module

• Involved in some activities for Oracle System Administration module such as

Registering the Users and assigning responsibilities, printers in Oracle Apps

Creating new responsibilities and defining the required system profile options

Creating value set and assigning its values

• Prepared Test scripts and involved in Application Integration Testing and System Integration Testing at client’s place

• Prepared issue and risk tracker and submit to client weekly basis

• Performed functional assessment for GL, AP, PO, OE and custom modules

• Worked with technical team to resolve / provide technical issues

• Writing / executing scripts using SQL Navigator to perform various extracts from database

• Solution Design and implementation for New Order Import systems both Ecommerce and EDI as part of Order management projects

• Testing of Inbound and Outbound Purchase order interface with WMS system

• End User Training

• Involved in reviewing technical design and code review for the peers and to ensure that the quality process is maintained at all stages

• Planning of Go-live data conversion activities for each phase

• Responsible for supporting entire SCM Flow of the multi-million Dollar Company. From Forecasting, Planning, Order Importing until Invoicing and Reporting

• Hands on experience on VMI Concepts

• Well experienced in customer specific EDI ASN

• Hands on experience in using KINTANA

• Resolved technical / functional issues at client place and communicating/coordinating on the issues with the team

• Provided POC for a BPEL Processes integration with legacy systems to Oracle using BPEL Process Manager and Oracle JDeveloper 9i

• Forms Personalization in iExpense and iProcurement using Oracle Application Framework Personalization

• Worked on various business processes of NA and EU instances

• Reviewed the Instance comparison analysis documents of NA and EU

• Overall Status Reporting, Issue Resolution and handling of escalations and onsite communication

Environment:

Oracle Applications 12i Modules (INV, PO, OM, BOM, WIP, AP, GL, AR, Alerts)

Software Oracle 10g and PL/SQL, Reports/Forms 6i, SQL, PL/SQL Developer, TOAD and Kintana

Client: Electronic Arts Relationship, CA Mar 2008 – Jul 2009

Role: Techno Functional Lead for 7 Member team

Description of the project -

The project involved L3 Enhancements and legacy customizations for Electronic Arts. Also included an upgrade from existing system to R12. Supplier Conversion, Open PO conversion, Sourcing Rule & ASL conversions, Item Catalogs Creation, Supplier Management, Supplier registrations, Supplier Merges, Period Closing activities and Reconciliation activities

Roles and Responsibilities:

• Understanding the Customer business Process and gathering client requirements

• Developed Functional (Setup) Specifications for RICEW objects

• Participate in CRP meetings for gap analysis

• Preparation of functional specification, technical specifications and testing scenarios

• Technical analysis of existing RICE components

• Design, code, Test and code reviews

• Basic knowledge on development of interface and conversion programs using PL/SQL and Oracle Standard APIs related to Purchasing

• Configured Buyer hierarchy in Oracle Purchasing including Approvals and Assignments

• Configured ASL, Sourcing Rules, and Assignment Set

• Configuration for UAT and registration of all custom components during UAT in Test instance

• Designed process to load all related lookups in one shot

• Involved in technical and functional gap analysis and customization process

• Involved in Functional and integration Testing

• Enabling Key Flexfield and Descriptive Flexfield

• Co-ordination with off-shore technical team and ensure the quality in deliverables

• Worked on customization of various Report, Forms and Interface

• Development/Customization of Shell scripts, Interfaces, Forms, Reports, Workflow and Discoverer report

• Involved in the development of stored procedures, Functions and Triggers

• Knowledge of underlying table structure of oracle applications modules for development of enhanced functionalities

• Hands on experience in SQL*Loader, SQL*PLUS and Data Loader

• Worked extensively on Multi-Org concepts, Flex fields and Workflow.

• Writing/executing the scripts using SQL to perform various extracts from the database. Well conversant with table structure and Flow

• Defined the period closing activities

• Comfortable in setting up debug level and profile options and running debug scripts to troubleshoot issues

• Trained junior engineers

• Troubleshooting of various Finance report causing issues in accounting

• Handled sub ledger GL posting issues, majorly after month close

• Performed AP and PO functional setups such as Banks, Bank Accounts, Supplier, Supplier Sites, Payment Terms, Financial & Payables Options, Profile Options, signing limits, approval groups, and approval assignments

Environment:

Oracle Applications 11.5.10 (INV, PO, OM, BOM, WIP, AP, GL, AR,Planning,Alerts,iProcurement)

Software Oracle 10g and PL/SQL, Reports/Forms 6i, SQL, PL/SQL Developer and TOAD

Client: Motorola Inc. Relationship, Schaumberg, IL Dec 2005 –Feb 2008

Role: Production Support Engineer

Description of the project –

The project included supporting the Motorola ERP end to end system. The system included support of EDI order import sources and core SCM modules like OM, PO, INV, WIP, BOM and Costing. The system also included AP, AR and GL for Finance. Shipping was handled through external systems. The project demanded working on time sensitive issues which required immediate resolution.

Roles and Responsibilities:

• Extensively used AOL to define value sets, parameters, concurrent programs and Request sets with Applications

• Functional support for Oracle Inventory, Oracle Purchasing, Oracle Order Management and Advance supply chain-planning.

• Setup of master items using item templates

• Developed and tuned various Reports query for client use in different module

• Used Workflow builder for PO approval workflow

• Handled system administration functions

• End to End knowledge on Drop Ship Business solution

• Completed Planning configurations for an MRP implementations.

• Responsible as a System Design analyst for Front-end application development

• Developing complex forms and reports and also wrote PL/SQL scripts, triggers and was involved in migration of data

• Converting business requirement to Functional specification design, implement and support application and systems integration

• Defined cross-validation rules and security rules required for integration

• Good Knowledge on Planning Manager

• Developed stored procedures, functions and packages to meet business requirements

• Performed data validation and data analysis

• Issue troubleshooting related to order processing system

• Worked on Debugging Business critical oracle standard reports

• Interacted with business units to understand their needs

• Fair knowledge on Change Management

• Provided an automation solution to speed up integration testing

• Worked with client and helped in resolving lot of the day-to-day software quality issues

• Did power point presentation to client and explained the system that was being integrated at the customer sites

• Involved in implementing testing specs and test plans to match user business requirements

• Worked alone and with team members on integrating functional and regression testing, creating, executing, maintaining test plans, and working with the development team to achieve a stable software solutions

• Test lead experience and strong development methodologies, ability to write reports and document testing procedures

• Ability to effectively communicate with managers, test team, and customers, ability to solve practical problems, and to interpret a variety of instructions

• Fluent in writing SQL scripts and worked extensively on Unix Platform

• Involved in the full Life cycle of the project

• Experience in opening, managing, and resolving Oracle SRs with Oracle Support

• Successfully created Approval Hierarchy for approving the POs. (Change from Job Based to Position Hierarchy)

• Handled issues related to Standard Purchase Order, Blanket PO,PO Releases and in Shipping- Setting Shipping Parameters, Pick Release Parameters, Shipping Transaction Parameters, Delivery Parameters, Bill of Lading, Packing Slip, Shipping Document Sets, Pick Slip Grouping Rules & Release Rules

• Performed setup for Routing, Routing Attachments, Bills, Item Cost, Cost Sub Elements, Different Costing Processes depending on item type, Employee Setup, Setup and Migration from 11.0.3 to 11.5.8, Defined Work in Process Parameters, Accounting Classes, Profile Options, Production Lines, Repetitive Assemblies, Schedule Groups, Labor Rates, Shop Floor Statuses, Planning Parameters, Demand Class, Planners, Forecast Sets, Forecast Rule, MDS, MPS, MPS Options, MRP, MRP Options

• Gathered requirement for Item templates by classifying items like Purchased Item, Reference Item and Supersede item accordingly created templates for them by enabling suitable attribute

• Setup Planners, Buyers, Categories, Unit of Measurement

• Setup new user responsibilities for different org based on the end user

• Setup suitable descriptive flex fields for the item based on the Inventory Organization

• Setup Assignment set, Sourcing Rules and the Approved Supplier list

• Setup of Purchasing options, Receiving Options, Financial Options, and Ship-To Location

• Setup PO vendors, vendor sites, and Descriptive flex fields to capture additional information

• Assist users in creating Standard Purchase order and Blanket agreement

Environment:

Oracle Applications 11.0.3 (INV, PO, OM, BOM, WIP, AP, GL, AR, Planning, Alerts)

Software Oracle 9i, OS Sun 5.8 and PL/SQL, Reports/Forms 6i, SQL, PL/SQL Developer,TOAD

Contact this candidate