SUMMARY

• Over 14 years of Technical and Functional 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.
• Good Hands on Experience of FBDI, ADFDI in Oracle Cloud to load data from Spreadsheet to Oracle Cloud.
• 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 onOracle applications
• Well versed with AIM Methodology. Created of Standard Documents like BR100, MD050, MD070, TE040, BP040, BP080.
• Strong Functional experience onOracleSCMModules (OM, PO, Inventory, Configurator, me-procurement, Discrete Manufacturing (BOM, WIP), MRP/MDS, Process Manufacturing, Advance Pricing, WMS.
• Hands of Experience on Oracle Cloud SCM, Procurement & Financial Modules.
• Expertise in all new features & functionalities on R12 me.e. Sub ledger Accounting Method and Multi Org Access Control (MOAC) and multi-Currency Environment
• 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, PA, FA modules and Production support.
• Involved in testing of differenceoraclemodules functionality as and required during the roll outs.
• Worked withoraclesupport, using metal link, 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 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 noledge on Oracle Cloud OIC.
• 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 4 End-to-End Implementations, 2 Upgrades( R12.1.3 - R12.2.6) and 2 Re-Implementation Experience.
• Ability to facilitate system review, data analysis and involved in various SIT, UAT and Go-Live phases of different implementation and upgrade projects

PROFESSIONAL EXPERIENCE

Confidential, Cherry Hill, NJ

Oracle Consultant

Responsibilities:

• Implemented the (Re-Manufacturing) OSP Process included defining new routings, resources, Departments, Operating, Bills.
• Design and Implemented new Inventory Organization as part of new Port Facility.
• Defining New Locations, Sub-Inventories, Item Extension, Organization Parameters Definition, Intercompany Transaction Flows.
• Defining New Release Rules, Order Types, Defaulting Rules.
• Implemented the Discrete Job Scheduling based on Re-Manufacturing items demand.
• Part of the Implementing the Oracle WMS from Legacy System Redpriarie.
• Implemented the Order Lines restrictions for High Value Items based on Customers Order History.
• Implemented the New Inventory Organization for all Re-Manufacturing Items(OSP Items) in to single system.
• Implemented the Advance pricing for OSP Items to default the Item Cost.
• Defined new Item cost structure for all OSP Items to get the Value of Material, Material Overhead Cost.
• Designed the warehouse processes to support complex inbound and outbound processes including picking with multiple staging steps. Also, setup the complex WMS strategies and rules logic to support the complex warehouse environment.
• In process of design the major warehouse related business processes including all inbound materials including Purchase Orders, Advanced Ship Notices and Returns and the outbound processes including Pick Release, Picking Staging and shipping of orders. Also worked on the Cross-Docking functionality for quick turnaround of ship Receipt material.
• Working on the design of WMS Implementation. Setting up WMS Organizations, Warehouse Rules, Item Level Setup (Serial Control, Lot Control Attributes).
• Working on implementing new enhancements on Order Management, Inventory and Purchasing.
• Implemented Double Drop Ship Process.
• Re-design the Pricing for items based on Modifiers and Qualifiers to get additional discount based on Price and Discount.
• Implemented the SNT Battery setup.
• Preparing the Functional and Technical design Documents like MD050, MD070 and BR100 documents for new implementations.
• Implemented functional spec to Cancel the Back ordered Sales and part of development.
• Developed XML Report for PDI, AUDIT, Process Monthly and Daily reports based on collection plan data.
• Prepared the Daily and monthly reports based on the user entered data and sends email to the distribution list automatically used the Excel spreadsheets to display the data.
• Developed new report to read all the images from the collection plan and displayed in the PDF. Depending on the image properties rotated the landscape image to print properly on the report.
• Users can take the Defect as Video and it will be loaded as attachment in the collection plan. Developed new report to download all the videos and send to the distribution list as required.
• Designing the Quality Collection Plan based on Existing MS Access Application
• Working on New Oracle forms to display the Child Plan based on VIN On-Hold and Off-Hold records process.
• Modified the Existing forms for User Interface for the Quality Module.
• Developed a new process dat creates AR invoice for all Canada VINs.

Environment: Oracle ERP R12.2.6(Inventory, Order Management, Advance Pricing, Purchasing, WIP, Bills of Material, WMS, Oracle Quality, BI Reports)

Confidential, Rock hill, SC

Oracle Cloud Consultant

Responsibilities:

• Implementing the Oracle CLOUD Release 12 for Order Management, Inventory, Procurement, Financial Modules (AP, AR, GL).
• Developing new Bi reports in Cloud.
• Setup of new Item Class, New Items, Attributes Setup and Organization Setup.
• Setup of Oracle Order Global Promising, Cost Management, Order Management setups.
• Part of Data Integration of Customers from Sales Force to Oracle Cloud.
• Defining new Inventory Planning methods in Oracle Cloud.
• Imported Items, Customers, Open/Incomplete Purchase Orders using FBDI, ADFDI Templates for Data Loading into Oracle Cloud System.
• Setup of Order Management, Procurement, Inventory related tasks in Oracle Cloud.
• Analyze the Business Enhancement Requirements.
• Identification of GAPs & proposal of Solution.
• Implemented the RMA, Drop Ship, Ship only Orders.
• Defining the New Cost Organization, Creating Custom Data Roles, Manage Cost Organization Relationships.
• Defining Valuation Structure, Cost Elements, Cost Components.
• Defining the Item Cost, Material Cost, Material Overhead Cost.
• Defining SLA Account setups (Debit and Credit Accounts) for Cost Organization.
• Implemented the Intercompany Transaction Flows.
• Defined the new Inventory Organizations for Lot/ Serial Controlled Items.
• Configure the all Inventory Organizations to Locator Control at Sub-Inventory Level.
• Implemented the Cycle Counting for all inventory Organizations.
• Defining the Pricing Segments, Custom Pricing Profiles, Pricing Strategy and Pricing Strategy Segments.
• Defined Shipping Document Sequence, Shipping Documents, Release Sequence rules, Pick Slip Grouping rules, Shipping Parameters.
• Defined New Item Structures for Phantom Items.
• Worked on the setups of the GL Ledgers (Primary and Secondary), defining Ledger Sets, Data Access Sets, Translation, Revaluation, Designing of the Chart of Accounts, setting up cross validation rules and security rules, etc.
• Worked on the setups and configurations for of the Sub Ledger Accounting module - Accounting Method Builder, Line Types, Account Derivation rules, Journal Line Types, Sub Ledger Accounting methods, Application Accounting Definitions, etc.

Environment: Oracle Cloud (Order Management, Inventory, Procurement, Costing, Advance Pricing)

Confidential, Cherry Hill, NJ

Oracle Functional Consultant

Responsibilities:

• Having daily status meetings for go-live activities & also PROD support issues.
• Worked in the configuration ofAR, AP, Project costing, Fixed Assets, cash management, Sub Ledger and GLmodules.
• Conducted User Sessions and CRP Session.
• Performed Requirement and GAP analysis.
• PreparingBR100, MD050CRP execution, User training and coordinating with technical teams onOracleApps related Custom design validation for integration betweenOracleApps and legacy applications.
• Worked on mapping of Future 3 System toOracleto process the AR Invoices.
• Worked on Auto Accounting in the AR module
• Worked on the Auto Invoice Process in AR Module.
• Worked on setting up the Invoice Line Grouping and Line Ordering Rules in AR for Auto Invoice module. Also worked on setting up the Line and Header transaction flex field in AR for Auto Invoice to work.
• Gathering the requirements from Business users and preparing the MD050 document.
• Implemented the Business Events for IRISO/Drop Ship process in order to notify the Ports for On-hand Qty increased on items.
• Enhancements in Advance Pricing.
• Implementing the new functionalities of R12.2, to R12.2.6.
• Handling the functional tasks on vehicles/Parts system.
• Guided the Automation team for process test for Configurator new setup.
• Implemented the User Defined Attributes in Vehicles/Parts system.
• Implemented the Credit Hold functionality based on Bill to Customer & also implemented the Line Level Credit Hold.

Environment: Oracle ERP R12.2.6(SCM Modules, Costing, Advance Pricing, AP, AR, GL)

Confidential, Winston Salem, NC .

Oracle Functional Consultant (Business Analyst)

Responsibilities:

• Involved in Custom components development and Interacted with ADF and Pl/Sql development team.
• Involved in various custom components like GOC, GDO, HMS, HDMS and CC FRAUD Management design and testing the functionality.
• Involved in Unit testing, Integration testing for different PO/INV process.
• Configure the Oracle systems for Order types for different application.
• Re-design the Advance pricing based on the new ehancements.
• Production support on OM, Inventory.
• Used to HP QC application for test case tracker.
• Coordinated with Off shore for the status tracking for the Enhancements.

Environment: Oracle ERP 11.5.10(Oracle Inventory, SCM, Advance Pricing)

Confidential, Cincinnati, OH

Oracle ERP Techno Functional Consultant

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, AP,GL, 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.
• Involved in gather requirements from Business users and preparing the MD070 document.

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

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.
• Developed Custom FAS .rdf Reports
• Modified Oracle Sales orders forms as per Business needs to display additional fields on Oracle Configuration and trigger WIP Jobs.
• Developed new forms to show LPN Details, Serial details to Integrate with Clear Orbit Applications( MSCA).
• 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(MD050 & MD070) 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.
• 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
• 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.
• Performed all Set ups for Purchasing (PO), Inventory (INV), Order Management (OM), and Warehouse Management System (WMS) modules.

Environment: 11i Support of SCM modules (Order Management, Purchasing, Inventory), Configure to Order, MFG Modules ( BOM & WIP), Advance Pricing, ASCP, Oracle Financials ( AP, GL,AR, Fixed Assets),Reports & Forms 6i.

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, Forms 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
• Involved in designing MD070 Document.

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:

• Gathered 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.