PROFESSIONAL SUMMARY:

• Over 11 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.5.
• Oracle Certified Order Management Implementation Specialist.
• Ability to facilitate system review, data analysis and involved in various SIT, UAT and Go-Live phases of different implementation and upgrade projects
• Extensive experience using Toad tools
• Extensive experience in utilizing Oracle Utility tools like SQL*Loader.
• Ability to quickly learn business applications and demonstrated analytical and problem solving skills
• Good experience in creating Unit Test documents
• Good PL/SQL skills with the ability to write efficient, complex queries against very large data sets good knowledge of tuning of queries.
• Extensive experience in PL/SQL Procedures, Functions, Packages and Database Triggers
• Experience in doing reverse engineering of legacy systems and mapping it with Oracle EBS application
• Experience in coding Interface Programs for importing data from Legacy Systems
• Extensively worked on RICE and Forms Customization/Personalization.
• Proficient in Developing, Customizing, and Implementation of reports 10g and XML Publisher reports.
• Worked with oracle support, using metalink, to resolve issues using knowledge base, SR/TAR..
• Involved in testing of difference oracle modules functionality as and required during the roll outs.
• Experienced in Month end closing activities. 
• Involved in setup of GL,AP, AR, FA modules and Production support. 
• Worked in Production support and involved in activities like Monitoring, trouble shooting, documenting.
• Setting up process for Drop Shipments, Back to Back Orders, Internal orders
• Functional work experience on Oracle SCM Modules (OM, PO, Inventory, Configurator,i procurement, Discrete Manufacturing(BOM, WIP), MRP,Process Manufacturing, Advance Pricing, WMS), ASCP, AP, AR, GL, FA.
• Expertise in all new features & functionalities on R12 i.e. Sub ledger Accounting Method and Multi Org Access Control (MOAC) and multi-Currency Environment
• Involved in R12 SCM Implementation of the Procure to Pay and Order to Cash.
• Well versed with AIM Methodology. Created of Standard Documents like BR100, MD050, TE040, BP040, BP080.
• 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 of Oracle applications

FUNCTIONAL/ TECHNICAL SKILLS:

Primary Skills: PO, OM, Configurator, Inventory, BOM, WIP, MRP, Advance Pricing, I Procurement.

Secondary Skills: AP, AR, GL, Project Accounting, ASCP, Fixed Assets, Process Manufacturing

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.
• New feature: Enhanced Gross Margin Calculations
• Implemented the new functionality Service Item as Promotional Get Item.
• Working on Production issues.
• Working closely with Business managers and Business users for new features implementation.
• Preparing the MD 50's for the new enhancements.
• In process of Implementing the New API for Item Orderability.
• Developing the test scripts and working closely with QA team for automation of the test scripts.
• Implemented the Audit History Purge Program.
• Implemented the Credit Hold functionality based on Bill to Customer & also implemented the Line Level Credit Hold.
• Implemented the User Defined Attributes in Vehicles/Parts system and work closely with ADF team for development.
• Part of new module planning of Oracle yard Management & Oracle Landed Cost Management (In Analysis).
• Implementing the new functionality of Freight charge calculation for the order placed in Parts System.
• Handling the functional tasks on vehicles/Parts system.
• Fixed the Service fulfillment manager in R12.2.6.
• Fixed the Recurring Billing in R12.2.6.
• Implementing the new functionalities of R12.2, R12.2.3, R12.2.4, R12.2.5 & R12.2.6 features for go-live of R12.2.6.
• Prepared R12.2 - R12.2.6 features PPT in SCM (Order Management, Purchasing, Inventory), MFG (BOM, WIP) & Finance modules (AP, AR, GL, Projects, Advance Collections, Cash Management, Fixed Assets) and presented to business users for approval to implement in PROD.
• Implemented the Business Events for IRISO/Drop Ship process in order to notify the Ports for On-hand Qty increased on items.

Environment: Oracle EBS R12.2.6(Oracle Inventory, Oracle Supply Chain, Advance Pricing, BOM, WIP, Financial Modules)

Confidential, Winston Salem, NC

Oracle Functional Consultant

Responsibilities:

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

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

Confidential, Cincinnati, OH

Oracle EBS Functional Lead

Responsibilities:

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

Environment: Oracle EBS 12.1.3(Oracle Inventory, Oracle Purchasing, I-Procurement, Oracle Financials ( AP, GL), Project Accounting, Fixed Asset.

Confidential, Maumee, OH

Oracle EBS 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 that will benefit the client in terms of cost rationalization and management control.
• Involved in the data migration of the master data and transaction data of all the Purchasing and Order Management modules.
• Interacting with the development team and providing them the necessary documentation(MD50) for the development of the custom programs and interfaces
• Primary Contact for Priority Incident tickets (P1 & P2).
• Involvement on Weekly status call meetings with Client along with Team members.
• Worked on Mobile Application Clear Orbit.
• Guide the Technical team on the New business and Provided the Technical Design Document.
• Implemented new functionality FIFO Process in one of the Business Unit.
• Implemented Existing functionality to the New Organization and Designed Functional document and New reports.
• 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.
• Maintained proactive interaction with clients to understand business practices for rendering assistance in system configuration; analyzed various business functions to derive benefits that will benefit the client in terms of cost rationalization and management control.
• Asset categories, calendar periods, System Controls, Book Controls (corporate books), Prorate Convention and Fiscal years and calendar.
• Key Flex field Structures: Key, Category, and Location  
• Involved in the identification of present gaps and work with business owners/users in the design sessions of the respective 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.
• Perform internal analysis and implementation of R12 EBS. Develop Business process flows for the respective Manufacturing modules.
• 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.
• Creation of Corporate Book and Tax Book 
• Create Journal Entries , ADI (excel) template to create mass additions 
• Run Periodic Mass copy to copy into Tax Book from Corporate Book 
• Extract Asset Categories from Old Book and Load into New Books.
• Develop project documentation including BR100 and Project Functional Design Documentation such as BP040, BP080 documents.
• Providing Functional support in various Oracle EBS modules like Inventory, Bill of Materials, WIP, Order Management, Purchase Order,Advance Pricing, Account Receivables.
• Assisting the users and making them familiar with oracle environment.
• Prepared detailed test scripts on various developed reports to users for testing.
• Involved in the conversion of master data and transaction data.
• Involved in the preparation of various MD50 for various conversions/interfaces.
• Performed role of primary support analyst providing production support of Oracle P2P & O2C modules.
• Perform develop and document systems analysis, validation testing, and development of training documentation, training of internal staff of enhanced business system functionality.
• Led the test sessions Performed unit, End-to-End tests and assisted in UAT sessions with preparation of test scripts TE40.
• Assisted in developing and testing of data from third party systems
• Define system options, Lookups, Define suppliers, Payment Terms, customers, transaction source, transaction types and other necessary system setups of all the Manufacturing modules.
• Worked with the technical team for developing custom interfaces, transaction conversion from other systems.

Environment: R12.2.2 Implementation & 11i Support of SCM modules (Order Management, Purchasing, Inventory), Configure to Order, MFG Modules ( BOM & WIP), Advance Pricing, I-Procurement, I-Supplier, ASCP, 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.
• Gathering the necessary information for the transactional data conversion
• Developed data migration scripts of the master data and transaction data of the Purchasing Module.
• Helping the users in resolving their issues.
• Preparing the issue chart and updating the client manager regularly.
• Extensively worked with interfaces, conversions and customizations.
• Involved in the working sessions for the key processes.
• Trained the Team members and explained the basic flows of the Manufacturing modules.
• Prepared design documents and test case scenarios for new modifications.
• Resolved any month end related issues involving and data fixes or configuration changes
• Various test scripts have been prepared for all the modules such as Purchasing, Inventory, Order Management.
• Provided post production support for SCM modules.

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

Confidential

Senior Oracle EBS Techno Functional Consultant

Responsibilities:

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

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

Confidential

Oracle Developer (Oracle EBS)

Responsibilities:

• Gathered data conversion requirements from BA mapped the legacy data with oracle EBS tables and did the Gap Analysis
• Providing technical support in various Oracle EBS modules like Inventory, Order Management, Purchase Order.
• Worked on custom.pll changes
• Created Custom new form for user data entry
• Mostly involved with business users for Integration testing for movement of Developed code and changed codes.
• Creating new reports and modifying existing reports in BI Publisher(XML Publisher) and Oracle Reports 6i.
• 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
• Providing estimation for technical deliverables in different phases of implementation of the project
• Reconciling of data in legacy system with oracle EBS once the integration is completed
• Created Inbound Interfaces using PL/SQL packages in Oracle Manufacturing and Order to Cash Cycle to import legacy system data into Oracle EBS

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