SUMMARY

• 13+ years of extensive experience working as Sr. Oracle Application Supply Chain and Value Chain Planning consultant with multiple projects experience in Upgrade and Implementation.
• Extensive experience in migrating solutions from Legacy to Oracle Applications both 11i and R12.Experience with Project Life Cycle from business requirement gathering to solution implementation.
• Extensive experience in Legacy System Integration. Expert in devising strategy for integration between heterogeneous and homogenous systems. Worked on vanilla Oracle apps implementation of various sites across Europe, Asia and Mexico.
• Extensive work experience in setting up ASCP collection and plans, sourcing rules, assignment sets, items simulation sets and planners in distributed and centralized environment. Very well experienced in forecasting, analysis of demand - supply, importing forecast from legacy and Oracle systems.
• Experienced in Application Support, Issue Management and Impact Analysis. Experienced in creating step-by-step user guide and very experienced in user training. Very strong in documentation.
• Expert in identifying the gaps and finding out creative solutions hence saving time and money for business users and data entry operators.
• Working with Confidential &T as Supply Chain Functional Consultant collaborated with users to analyze the current processes then partnered with developers to design and implement new features that increased efficiency by 70% within the supply chain group.
• Extensive experience in R12 Advance Supply Chain Planning (ASCP) and Inventory Planning methods MIX-MAX, Re-Order Point. Experienced in Global Order Promising (GOP), Material Requirement Planning (MRP), Master Production Schedule (MPS).
• Involved in Order Management and Advance Pricing Setups (Price Lists, Modifiers, Qualifiers, Pricing Attributes and Contexts) & maintaining BR100. Extremely proficient with Order To Cash, Procure To Pay and Make to Stock processes and modules. Very well versed with oracle application Release12 (R12) TCA Architecture, customer, receivables and advance pricing. Strong conceptual and technical knowledge about R12 Customer and advance pricing and Order Management (Picking and Shipping), BOM, WIP, OSFM, Purchasing, Account Receivable and Oracle Quality.
• Experience in writing functional specification for Data Conversions, Interfaces and Reports customizations, Forms development, Form Personalization.

TECHNICAL SKILLS

Operating Systems: Window 98/Millennium/XP/Vista/7, UNIX, Linux

ERP Modules: Order Management (OM), Inventory (INV), Advance Pricing, Sys Admin, Picking and Shipping, Oracle quality, Advanced Supply Chain Planning (ASCP), Purchasing, WIP, OSFM

Version Control Tool: VSS, CVS, PVCS, Quicker, SharePoint.

Migration Tools: Kintana, STAT’s, LDT’s

Scheduling Tools: ORSYP

Other Tools: Cemili ( Performance Measurement Tool), HPQC ( Defect Logging Tool), MCASE (Error Logging and Correction Tool ), Service Central Help Desk

Quality Management Tool: HP Quality Center

Documentation: Oracle Unified Methodology (OUM), Application Integration Methodology (AIM)

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Oracle EBS SCM Functional Consultant

Responsibilities:

• Performed all setups for Order Management (OM) and Inventory (INV).
• Worked with the Business Team to baseline ‘As Is’ process and derive ‘To Be’ Flow.
• Created sourcing rules, assignment sets, planners, price lists.
• Analyzed the existing process and worked with the business users to gather business requirements and document them as System Requirements Package 270938e - Iconic OM Phase 1 - Oracle SCM SR.
• Written the functional specification for DL VAN Device Register API. This API is used to register a newly installed device for a customer. Also, used to reactive an already installed device for a customer. This API can be called by multiple systems (DLITE, XANBOO) to ADD/DELETE/SWAP devices in install base.
• Written functional test scenarios and integration test scenarios for DL VAN Device Register API. Tested the API on during functional testing and integration testing. Logged the results in HP Quality Central. Also logged the defects and assigned to the development team. Follow up on the defects and closure after re-testing.
• Involved in functional testing, performance testing, integration testing, user acceptance testing and GO-Live.
• Created Responsibilities, Value Sets, Menus, Functions, Lookups and Users, Receivable transaction Source, Transaction Type and Auto-Accounting Rules.
• Maintained BR100 with the latest changes in the setups.
• Document all processes and work instructions by utilizing MS Visio and PowerPoint to create work flows and charts in a desirable and user friendly format.
• Exceptional knowledge with MS Excel functions such as: pivot tables, subtotals, if functions, and vlookups across multiple worksheets and files.
• Involved in GO-LIVE Support, Post Production activities, user manual and user trainings.

Confidential, Alpharetta, GA

Oracle SCM Functional Consultant

Responsibilities:

• Involved in Business Requirement Review sessions with client to figure out the AS-IS and TO-BE and fit-gas requirement.
• Involved in writing Business Requirement Documents by meeting multiple teams working on different tracks.
• Assisted Material Review Board (MRB) to process and expedite vendor returns through return material authorizations (RMAs).
• Worked on the functional specification for New DF Custom Pre-Order Form and interfaces Order Track Outbound Yoda to Oracle and Custom DF Release Pre Order Line Level Hold. Developed the functional test scenarios and integration test scenarios for the same.
• Created Responsibilities, Value Sets, Menus, Functions, Lookups and Users.
• Maintained BR100 with the latest changes in the setups.
• Used Form Personalization to freeze (Read Only) the Schedule Ship Date field on Order Lines window.
• Document all processes and work instructions by utilizing MS Visio and PowerPoint to create work flows and charts in a desirable and user friendly format.
• Involved in GO-LIVE Support and Post Production activities.

Confidential, Alpharetta, GA

Oracle SCM Functional Consultant

Responsibilities:

• Responsible for analyzing the Business Requirement Documents and develop High Level Design documents. Involved in reviewing the technical design delivered offshore team. Functional testing of the delivered objects.
• Identified the need of an interface between GENCO & ATT to bring the Auction Orders into Confidential &T ERP System and their by reducing the cost and time.
• Working as Test Lead, prepared the system integration test cases, collected testing results and loaded the results in HP Quality Centre.
• Responsible for defect logging and tracking. Generated weekly report of defects and worked on the completion of those with offshore team.
• Responsible for Order Management and Customer setups in various instances, analyzing the Business Requirement Design and wrote High Level Designs. Involved in reviewing technical design and helping developers in developing the code, functional testing of Custom OMS-Order Import Interface, system integration testing (SIT) and user acceptance testing (UAT).
• Conducted and monitored Go-Live and responsible for post-production support.
• Documented the new system and were Confidential onsite to train users about how to use the newly installed system effectively.
• Extensively worked on the identifying the gaps in the existing system and designed new processes required to import Auction Orders, export them to WMS, get the delivery notification from WMS, Shipping and Invoicing.
• Worked on setting up request sets, responsibilities, menus, functions and request groups in various environments.
• Responsible for setups related to Customer import (e.g. Profiles, Customer Class, Sales Rep, Sales Territory), Order import (e.g. Transaction Types, Document Sequence, Order Import Sources, Hold Reason Code). Registered new description flexfield (DFF) OMS and defined attributes and value sets respective to these attributes.
• Designed the project end to end functional and technical flow including the data structure and processes affecting the data structure. Presented the technical flow in client meeting. Designed the error handling strategy.
• Used form personalization for the automatic population of receipt method, receipt number and description flexfield on Receipts form.
• Impact analysis of existing interface Custom Orders Outbound from Oracle to WMS and Ship Confirm Interface Parallel Scheduler interface in the context of Auction Orders and designed High Level Document to implement changes required to pass Auction Orders from Oracle to WMS.
• Functional Architect in the whole design of Auction interface. Designed the Application Interface Design (AID) document which involved the structure of staging and error tables, scheduling the interface, data flow among the various systems, error handling/correction strategies, responsibilities, menus and functions.
• Worked on the functional specification of Customer Import Interface Program. This interface picks up customer data from staging table and validates if the customer already exists in system. If not, it creates customer, customer sites and site uses (BILL TO/SHIP TO).
• Written functional specification for Order Import Interface Program. This interface picks up Auction Sales Orders data from staging table and creates Sales Orders. While creating Sales Orders, it verifies whether the inventory is sufficient to fulfill the Order.
• Maintained BR100 which had setups for customer class, profile class, document sequencing, payment types, transaction types, value sets and various profile options.

Confidential, Greenville, SC

Oracle SCM Functional Consultant

Responsibilities:

• Responsible for design and implementation of Manufacturing Execution System and globalsupplychainprocesses to support manufacturing operations in the capacitors, semiconductors and batteries.
• Coordinated the timely procurement of materials based on material requirement planning (ASCP) while maintaining the lowest possible level of inventory and hence enhancing the Manufacturing Execution System.
• Setup Order Management including setting up locations, inventory orgs, responsibilities, various profiles, transaction types, document type & document sequencing in development & test instances for Knoxville (US), EVORA (Portugal) & Italy implementation.
• Identified the need of an interface to import shipments from legacy systems MES(KMS and ETBF) to Oracle ASCP Instance. Worked on deducing the requirements from user stories. Framed the functional requirement specification document and actively involved in development and functional testing of the interface.
• Reduce paperwork in the Manufacturing Execution System by implementing Oracle Quality. Shop Floor users can directly enter test results into Oracle Quality Plans and compare with the standards. Worked on Oracle Quality conversions to import Operations & Item data from external system to Oracle for Monterey (Mexico), Suzhou (China) and Simpsonville (USA) plants.
• Setting up Sourcing Rules, Supplier Lists, Assignment Set and Collection Plans for the implementation of ASCP and updating sales orders with the fulfillment date.
• Developed and implemented new technologies and processed to streamline manufacturing operations in Manufacturing Execution System (KMS - KEMET Manufacturing System) and ETBF.
• Involved in implementing long range strategic plan for Key Manufacturing Systems including Manufacturing Execution System (KMS - KEMET Manufacturing System) and ETBF.
• Utilize creativity and innovation to enhance productivity in the Manufacturing Execution System by designing and presenting effective and tactical reports to executive management which detail KEMET Sales Order Confidential Risk Report, KEMET Firm Planned Order Today, KEMET MTY Pegging Detail Report, KEMET Material Scrap Report, KEMET Discrete Order Policy Report and KEMET Idle Consignment Report.
• Implemented Smart Items, Common Bill Of Material, Common Routing strategies to streamline Manufacturing Execution System (KMS - KEMET Manufacturing System) and ETBF, hence reduce re-work, decreased setup time.
• Enhanced the Manufacturing execution system by implementing KEMET Copy Master Data program. Specified high level design and was actively involved in the development and testing for the same.
• Identified the need of a common program for all the reports to send bulky attachment of reports to users email. Worked on the high level design and was actively involved in development of the same KEMET Send Mail Attachment program.
• Collected requirement for the need of various forms KEMET Material Requirement Form, KEMET MTY PORS Form/Form personalization and KEMET ETBF - OM Error Correction Form for the convenience of users to view more detailed information.
• Interaction with client person to understand the requirements and developing functional design document (MD050) of KEMET ETBF Order Interface.
• Maintained BR100 for the setups and the ongoing changes in the setups. Responsible for Order Management setups.
• Developed object movement document (MD120) for all the above mentioned objects.
• Used Quicker to maintain project related documents.

Confidential, Redwood, CA

Oracle SCM Functional Consultant

Responsibilities:

• Responsible for the fit-gap analysis and designing requirement specification documents.
• Responsible for creating and maintain BR100 in gold environment.
• Interaction with functional person to understand the client’s requirements and functional design document (MD050) of PO to FA extension.
• Estimation of objects using Estimation guidelines document.
• Prototyping for Sales Order and Customer import. Did functional testing and integration testing and User Acceptance Testing (UAT).
• Preparing functional design (MD050), code development, functional test plans (TE.020) of Order to Cash Cycle using AIM methodology.
• Executed Data Loader Script to load Asset Categories and Locations.
• Created users, security profile, menus, DFF, custom responsibilities, request groups, assigned responsibilities to the users in System Administration.
• Used Performance Measurement tool Cemli to measure the performance of custom objects Environment:

Confidential, Cleveland, OH

Lead Oracle SCM Functional Consultant

Responsibilities:

• Responsible to gather requirements of RIC objects (Customer Relationship conversion, Price List Conversion, Enhanced Customer Flexfields interface, Modified Pick Ticket Report etc.) by understanding the client business and discussing it with client and functional consultants.
• Responsible for the functional and user documentation of customizations, conversions and reports. Application-Integration Methodology (AIM 3.0) has been used to develop functional design document, functional test case document.
• Responsible to design and develop functional designs for Customer Relationship conversion, Price List Conversion, Sales Order Conversion, Inventory Items and On-Hand quantities conversion, AR Invoice Conversion from legacy system to R12.
• Designed functional specification of Enhanced Customer Flex fields interface to automatically update the party, customer, customer sites, customer profile and site profiles flexfields. Developed interface to update the price lists.

Confidential, Duluth, GA

Oracle SCM Functional Consultant

Responsibilities:

• Responsible for gap analysis and understanding the structure of existing customer data. Devised the translations and mapping required to convert data from legacy system to R12 database. Also inculcated the new features and functionalities available in R12 to be used in the Customer, Price List, Sales Order and Project Expenditure Conversion.
• Responsible to travel to different client locations (Duluth, Gainesville, Athens) for business meeting to correctly understand the data to be converted and client’s requirements. Suggesting changes in the data and processes for the smooth migration of data from legacy to new system (R12).
• Involved in Preparation of BR100, MD50, TE20 and Cut over and Production Migration plan.
• Gather requirements and worked on the functional specification and functional test scenarios for Customer Conversion, Price List Conversion, Sales Order Conversion, Receivable Invoice Conversion using Interface tables and Project Expenditure Conversion.
• Incorporated error reporting and correction strategy using MCASE (Error reporting and correction tool) tool to log the errors occurred during various conversions execution.
• Participated in Functional Testing of converted data using Mercury Tool and used HP Quality Central tool to log defects.