SUMMARY

• Oracle Certified Order Management Implementation Specialist.
• Over 12 years of professional experience, which includes 7 years of Functional Consulting experience in providing solutions for support, maintenance, upgrade and implementation of Oracle Applications E - Business Suite Releases 11i, Release 12, R12.2.6, Oracle Cloud
• Knowledge on Oracle Cloud SCM, Procurement & Financial Modules.
• Hands-on involvement on all phases including Definition, Operations Analysis, gathering business requirements, GAP analysis, process mapping, solution design, configuration, Customization, Build, Transition, /Production cut over, user training, support and maintenance experience ofOracle applications
• Well versed with AIM Methodology. Created of Standard Documents like BR100, MD050, TE040, BP040, BP080.
• Involved in R12 SCM Implementation of the Procure to Pay(P2P) and Order to Cash(O2C).
• Expertise in all new features & functionalities on R12 me.e. Sub ledger Accounting Method and Multi Org Access Control (MOAC) and multi-Currency Environment
• Functionalwork experience onOracleSCMModules (OM, PO, Inventory, Configurator,me procurement, me-Supplier, Discrete Manufacturing(BOM, WIP), MRP,Process Manufacturing, Advance Pricing, WMS), ASCP, AP, AR, GL, FA.
• Setting up process for Drop Shipments, Back to Back Orders, Internal orders
• Worked in Production support and involved in activities like Monitoring, trouble shooting, documenting.
• Involved in setup of GL,AP, AR, FA modules and Production support.
• Experience inEDI transactions andEDImappings..
• Involved in testing of differenceoraclemodules functionality as and required during the roll outs.
• Worked withoraclesupport, using metalink, to resolve issues using noledge base, SR/TAR..
• Proficient in Developing, Customizing, and Implementation of reports 10g and XML Publisher reports.
• Extensively worked on RICE and Forms Customization/Personalization.
• Experience in coding Interface Programs for importing data from Legacy Systems
• Experience in doing reverse engineering of legacy systems and mapping it with Oracle ERP application
• Extensive experience in PL/SQL Procedures, Functions, Packages and Database Triggers
• Good PL/SQL skills with the ability to write efficient, complex queries against very large data sets good noledge of tuning of queries.
• Good experience in creating Unit Test documents
• Ability to quickly learn business applications and demonstrated analytical and problem solving skills
• Extensive experience in utilizing Oracle Utility tools like SQL*Loader.
• Part of 3 End-to-End Implementations and 1 Upgrades( R12.1.3 - R12.2.6)
• Ability to facilitate system review, data analysis and involved in various SIT, UAT and Go-Live phases of different implementation and upgrade projects

TECHNICAL SKILLS

Primary Skills: P2P, O2C, Configurator, Inventory, AP, AR, GL, BOM, WIP, MRP,WMS,Advance Pricing, me Procurement, me Supplier.

Secondary Skills: Project Accounting, Fixed Assets, Process Manufacturing, ASCP, Oracle Cloud

Languages: PL/SQL, Sql

Unix Tools: Toad, Reports 6i,10g, SQL*Plus, SQL Developer, PL/SQL Developer

Databases: 9i/10g, 12C

PROFESSIONAL EXPERIENCE

Confidential, Cherry Hill, NJ

Oracle Functional Consultant

Responsibilities:

• As a functional Consultant, Understanding the existing functionalities and Implementing the new features and exclude the existing custom functionalities.
• Gathering the requirements from Business users and preparing the MD050 document.
• Implemented the Business Events for IRISO/Drop Ship process inorder to notify the Ports for On-hand Qty increased on items.
• Enhancements in Advance Pricing.
• Prepared R12.2 - R12.2.6 features PPT in SCM (Order Management, Purchasing, Inventory), MFG (BOM, WIP,WMS)& Finance modules(AP, AR, GL, Projects, Advance Collections, Cash Management, Fixed Assets) and presented to business users for approval to implement in PROD.
• Implementing the new functionalities of R12.2, to R12.2.6.
• Set up theWMSsystem underOracleto comply with the new warehouse facility.
• Has set up rules/Strategies withinWMSsystem to meet to the new business requirements for the new facility.
• Interacted with Business in deciding on the locator and strategies for material movement along with complexWMSdesign and layout.
• Handling the functional tasks on vehicles/Parts system.
• Implementing the new functionality of Freight charge calculation for the order placed in Parts System.
• Implemented the User Defined Attributes in Vehicles/Parts system and work closely with ADF team for development.
• Implemented the Credit Hold functionality based on Bill to Customer & also implemented the Line Level Credit Hold.
• Developing the test scripts and working closely with QA team for automation of the test scripts.
• Preparing the MD 50's for the new enhancements.
• Working closely with Business managers and Business users for new features implementation.
• Working on Production issues.
• New feature: Enhanced Gross Margin Calculations
• Modified and configured 850 POO EDI program according to R12 instance.
• Modified and configured 850 POCO EDI program according to R12.
• Modified and configured 810 Invoice out bound EDI according to R12.

Environment: Oracle ERP R12.2.6(Oracle Inventory, Oracle Supply Chain, Advance Pricing, BOM, WIP, WMS,Financial Modules like AP, AR, GL)

Confidential, Winston Salem, NC .

Oracle Functional Consultant( Business Analyst)

Responsibilities:

• Involved in Order Management and Inventory Modules.
• Interacted with Business Users for gathering the requirement and Presented the BRD’s to users.
• Developed the Business Requirement Document and explaining to Development team, to meet the requirements and to deliver in Right time.
• Handled more than 4 projects with Functional Design and delivered in right time.
• Involved in Unit testing, Regression Testing and in UAT for all the Projects handled.
• Developed test cases and presented the same to Business users.
• Involved in Custom components development and Interacted with ADF and Pl/Sql developed team.
• Involved in various custom components like GOC, GDO, HMS, HDMS and CC FRAUD Management design and testing the functionality.
• Production support on OM, Advance Pricing, Inventory.
• Testing the New functionality related to OM, Advance Pricing, Inventory, Process Manufacturing.
• Configuring the Setups for MRP,Forecast, MDS,MPS.
• Configuring the Routing(Resources).
• Defining the Shop floor status, Schedule Groups, Move transactions.
• Setup for Forecast, Demand Schedule, Resource Planning.
• Worked on Price Lists, Qualifiers, Modifiers, Pricing Attributes in Advanced Pricing.
• Worked on Long pending Tickets and Production Support tickets.
• Used to HP QC application for test case tracker.

Environment: Oracle ERP 11.5.10(Oracle Inventory, Oracle Supply Chain, Advance Pricing, BOM, WIP, Process Manufacturing)

Confidential, Cincinnati, OH

Oracle ERP Functional Lead

Responsibilities:

• Involved in initial implementation phase and in preparation of BR100, BP040, BP080 documents.
• Holding workshop sessions to drive into the key requirements, enhancements and impact analysis for all SCM Modules, Manufacturing Modules, Project Accounting.
• Integration testing with Business users to move the changed or developed code to Stage Instances and Production instances.
• Designed and Developed the Project Accounting Outbound & inbound Interfaces.
• Develop and Design the RICE Components.
• Involved in Unit testing, Integration testing for different PO/INV process.
• Involved in interfaces, conversions and customizations.
• Involved in the conversion of master data and transaction data.
• Design in Gateway & Right Fax.
• Done integration testing with Business on Legacy systems like Right Fax & Gateway.
• Defined operating unit, Inventory organization.
• Gathering Business Requirements for upgrade considerations and documenting them.
• Trained the users and explained the basic flows of the Purchasing and Inventory modules.
• Configuring Working session exercises for the key processes.
• Implemented Fixed Asset module in different locations.
• Converted Fixed Asset data into Oracle through web ADI.
• Creation Fiscal Year, Depreciation Calendar, Books, Asset Categories.
• Assist in configuringOracleProcurement andiSuppliermodules to support global design processes
• Involved in daily and weekly meeting with the users and took necessary action in order to enhance the user participation in the implementation activities.
• Involved in UAT and SIT with preparation of test scripts TE040 for all the financial modules
• Involved in the development and design of customer weekly statements and daily open/paid invoice extract
• Involved in design of the Standard PO Print Report.

Environment: Oracle ERP 12.1.3(Oracle Inventory, Oracle Purchasing, me-Procurement, me-Supplier Oracle Financials ( AP, GL), Project Accounting, Fixed Asset.

Confidential, Maumee, OH

Oracle ERP Module Lead

Responsibilities:

• Maintained proactive interaction with clients to understand business practices for rendering assistance in system configuration; analyzed various business functions to derive benefits dat will benefit the client in terms of cost rationalization and management control.
• Implemented Existing functionality to the New Organization and Designed Functional document and New reports.
• Implemented new functionality FIFO Process in one of the Business Unit.
• Guide the Technical team on the New business and Provided the Technical Design Document.
• Worked on Mobile Application Clear Orbit.
• Involvement on Weekly status call meetings with Client along with Team members.
• Primary Contact for Priority Incident tickets (P1 & P2).
• Interacting with the development team and providing them the necessary documentation(MD50) for the development of the custom programs and interfaces
• Involved in the data migration of the master data and transaction data of all the Purchasing and Order Management modules.
• Designed Interfaces for creation of BOMs, Routings, Item Costs, WIP Jobs creation and Updates, Component and Resources Issue and return and execute Move Transactions.
• Scheduling collection group, Execution of plan, Analyzing and Debugging of horizontal plan
• Involved in designing and developing the new label for Customers using Bartender Software.
• Production support on OM, Purchasing, Advance Pricing, Inventory.
• Testing the New functionality related to OM, Purchasing, Advance Pricing, Inventory.
• Worked on Price Lists,Qualifiers, Modifiers, Pricing Attributes in Advanced Pricing.
• Developed customizedWMSsolution for ATO model product labeling.
• Maintained proactive interaction with clients to understand business practices for rendering assistance in system configuration; analyzed various business functions to derive benefits dat will benefit the client in terms of cost rationalization and management control.
• Conducted in depth analysis on the development of creative solutions delivering substantial results to clients; evaluated business needs, user requirements, and functional specifications; analyzed and understood client issues and project goals in order to deliver standard service to clients.
• Perform internal analysis and implementation of R12 ERP. Develop Business process flows for the respective Manufacturing modules.
• Designed for BOM and WIP Interfaces to Kit Jobs for a project. Includes using Interfaces for creation of BOMs, Routings, Item Costs, WIP Jobs creation and Updates, Component and Resources Issue and return and execute Move Transactions.
• Involved in the identification of present gaps and work with business owners/users in the design sessions of the respective modules.
• Key Flex field Structures: Key, Category, and Location
• Asset categories, calendar periods, System Controls, Book Controls ( corporate books), Prorate Convention and Fiscal years and calendar.
• Creation of Corporate Book and Tax Book
• Extract Asset Categories from Old Book and Load into New Books.
• Run Periodic Mass copy to copy into Tax Book from Corporate Book
• Create Journal Entries, ADI (excel) template to create mass additions
• Develop project documentation including BR100 and Project Functional Design Documentation such as BP040, BP080 documents.
• Worked with the technical team for developing custom interfaces, transaction conversion from other systems.
• Define system options, Lookups, Define suppliers, Payment Terms, customers, transaction source, transaction types and other necessary system setups of all the Manufacturing modules.
• Assisted in developing and testing of data from third party systems
• Led the test sessions Performed unit, End-to-End tests and assisted in UAT sessions with preparation of test scripts TE40.
• Perform develop and document systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Performed role of primary support analyst providing production support of Oracle P2P & O2C modules.
• Involved in the preparation of various MD50 for various conversions/interfaces.
• Involved in the conversion of master data and transaction data.
• Prepared detailed test scripts on various developed reports to users for testing.
• Assisting the users and making them familiar with oracle environment.
• Providing Functional support in various Oracle ERP modules like Inventory, Bill of Materials, WIP, Order Management, Purchase Order,Advance Pricing, Account Receivables.

Environment: R12.2.2 Implementation & 11i Support of SCM modules (Order Management, Purchasing, Inventory), Configure to Order, MFG Modules ( BOM & WIP), Advance Pricing, me-Procurement, me-Supplier, ASCP, WMS, Oracle Financials ( AP, GL,AR, Fixed Assets).

Confidential

Senior Oracle Techno Functional Consultant

Responsibilities:

• Supporting issues relating to various operating units in modules such as Purchasing and Order Management & Shipping.
• Provided post production support for SCM modules.
• Various test scripts has been prepared for all the modules such as Purchasing, Inventory, Order Management.
• Resolved any month end related issues involving and data fixes or configuration changes
• Prepared design documents and test case scenarios for new modifications.
• Trained the Team members and explained the basic flows of the Manufacturing modules.
• Involved in the working sessions for the key processes.
• Extensively worked with interfaces, conversions and customizations.
• Preparing the issue chart and updating the client manager regularly.
• Helping the users in resolving their issues.
• Developed data migration scripts of the master data and transaction data of the Purchasing Module.
• Gathering the necessary information for the transactional data conversion

Environment: Oracle ERP 11i (Oracle Order Management, Oracle Configurator, Purchase Order), Toad 9.7.2, Oracle PL/SQL, Oracle Reports 6i.

Confidential

Senior Oracle ERP Techno Functional Consultant

Responsibilities:

• Involved in Migration Process for Master Data and Transactional Data in Purchasing.
• Prepared Test scripts all the Purchasing modules for all Data fixes.
• Involved in preparation of BR100, BP040, BP080 and TE040 Documents for the Purchasing modules.
• Present the identified gaps and work with business owners/users in the design sessions, so dat it fills the identified gaps
• Involved in Designing and developing demo sessions for all the modules with the respective module users.
• Performed role of primary support analyst providing production support of PO & OM modules.
• Attending daily status calls and weekly call with client team to discuss the updates.
• Gathering necessary business requirements for any enhancements and documenting them.
• Making necessary setups required in the instance and testing the functionality along with Functional Consultant.
• Provided post go-live support for financial modules with month end closing related as well as regular issues.
• Tested various reports and worked with Functional team to modify the same according to Business needs
• Prepared detailed scripts for procure to pay cycle and for order to cash process.
• Involved in the preparation of data migration template for the master data conversion and transaction data conversion.
• Providing application support to Order Management, Oracle Configurator modules

Environment: Oracle ERP 11i (Oracle Order Management, Oracle Configurator, Purchase Order), Toad 9.7.2, Oracle PL/SQL, Oracle Reports 6i.

Confidential

Oracle Developer (Oracle ERP)

Responsibilities:

• Gatheird data conversion requirements from BA mapped the legacy data with oracle ERP tables and did the Gap Analysis
• Created Inbound Interfaces using PL/SQL packages in Oracle Manufacturing and Order to Cash Cycle to import legacy system data into Oracle ERP
• Reconciling of data in legacy system with oracle ERP once the integration is completed
• Providing estimation for technical deliverables in different phases of implementation of the project
• Worked closely with Business Analysts in gathering functional requirements(MD 50) and created technical documentation(MD 70) which included complex data flow diagrams, unit test plans and process diagrams
• Creating new reports and modifying existing reports in BI Publisher(XML Publisher) and Oracle Reports 6i.
• Mostly involved with business users for Integration testing for movement of Developed code and changed codes.
• Created Custom new form for user data entry
• Worked on custom.pll changes
• Providing technical support in various Oracle ERP modules like Inventory, Order Management, Purchase Order.

Environment: Oracle ERP 11i(Oracle Manufacturing (INV, Order Management, Purchase Order), TOAD, Oracle PL/SQL, Oracle Reports6i.