PROFESSIONAL SUMMARY:

• Having 10+ years of experience in Oracle Applications ERP R12.X/11i.X with excellent communication skills as Oracle Applications Techno Functional Consultant. Key responsibilities include business requirements gathering, designing, developing, mapping, Configuring, Testing and Support Financial (AP, AR, GL and CM) and SCM (Supply Chain Management) Including WMS, Oracle Process Manufacturing (OPM), Planning (ASCP) and Demantra (Demand)
• Guided and supported business teams through the redesign of various legacy processes and translated the new processes into Oracle applications during multiple projects.
• Contributed and provided solutions at different phases of implementation, including requirement gathering, gap analysis, configuration of the modules, developing test case scenarios, test scripts and leading the UAT.
• Co - ordinated various teams (Design, Development & Testing and Configuration) in various Oracle Application Implementation projects.
• Ability to learn new technologies and new modules related Oracle EBS quick around time since I am passion to learn new modules and technology
• Experience in working following Quote To Cash ( OTC), Procure to Pay ( P2P/PTP) including following modules Oracle Process Manufacturing ( OPM), Oracle Advanced Supply Chain Planning ( ASCP), Demantra as a Techno Functional Consultant
• Exceptional ability to apply Oracle Applications product knowledge in Oracle Applications 11i, R12.X following Modules GL, AP, PO, FA, CM, AR and Supply Chain modules Purchase Order, Order Management, Shipping (WSH), Order Management, Inventory, Warehouse Management Services ( WMS), Oracle Process Manufacturing ( OPM), ASCP ( Advanced Supply Chain Planning), Demantra and also experienced in Customer Data Hub Module ( CDH) .
• Expertise in implementing/Configuring/Integrating/Conversion Organization into WMS Enabled Organization and Experience in working with MSCA and its integration with WMS.
• Expertise in Developing/Extending MWA/MCWA UI interface for Warehouse Management Applications (WMS).
• Implementation and hands on experience with Demantra (Forecast) Application.
• Implementing and working experience integration of Demantra with ASCP, EBS, EDW Sales System, Trade Suite systems for monthly/ Weekly Cycles.
• Thorough knowledge and experience on basic and advanced WMS functionalities like advanced task management, pick and put away rules, strategies, label formatting, cost group assignments, LPN generations, picking, packing, cartonization, shipping etc.
• Expertise in designing/configuring complex WMS inbound and outbound rules to address business requirements.
• Has been part of configuring and printing label formats to customers and its integration with external vendors.
• Experience in handling data conversions, interfaces and custom integrations with oracle EBS to external applications.
• Expertise in Translating functional specifications into technical specifications for development of Oracle Applications R12 extensions, modifications and integrations including system interfaces, reports, data conversions and custom extensions.
• Expertise in developing Oracle Self Services Pages (OAF)/ Customizing/Extending/Personalizing in Oracle applications R12 Suite.
• Expertise in Developing/Customize Workflow using Workflow Builder 2.6
• Expertise in developing/customize UI interface using Oracle Forms10g.
• Proficient in working with Oracle Public API’s and Module level interfaces.
• Expertise in developing packages, procedures, functions, database triggers, interfaces and data Conversion using PL/ SQL, SQL * Plus and SQL* Loader tools.
• Designed and developed Oracle Web ADI integrator for the legacy system data loading and day to day business needs.
• Hands on experience on Systems Integration using XML Gateway, Interfaces (Inbound/Outbound) and Conversions between Oracle Applications and legacy systems, Customizations of Oracle modules and Development of Custom Oracle modules/applications
• Experience in Oracle Workflow, Approval Management Engine (AME), System Admin, Alerts and Form Personalization.
• Good Understanding & hands on experience of Multi org & TCA.
• Having knowledge OTM (Oracle Transport Management) and integration with E-Business Suite Having knowledge on Integrated SOA Gateway Process.
• Having Knowledge on ADF11g and SOA11g
• Expertise in documentation using AIM/OUM methodology like MD050, MD070, CV040, CV60 and TE020, TE040 documents.
• Manage offshore/onsite teams to make sure client requirements/issues understanding correct and to deliver the requirements as expected.
• Excellent communications, Interpersonal and leadership skills, Target oriented and Team oriented.

TECHNICAL SKILLS:

EBiz Suite: Oracle E-Business Suite 11i, R12

Functional Modules: GL,AP,AR,FA and OM, Shipping, Advance Pricing, Inventory, Customer Data Hub Module, Oracle Process Manufacturing (OPM), ASCP, Demantra

Technical Modules: Sys Admin, AOL, Web ADI, Workflow Builder, AME, Form Personalization

Frameworks: Oracle UI development Frameworks OAF, ADF

Database: Oracle 9i/10g/11g/12c

Languages: SQL, PL/SQL, JAVA and shell scripting

Development Tools: SQL Loader, Data Loader, Jdeveloper, BI Publisher Tool, Oracle Workflow BuilderOracle Forms and Reports, XML Gateway Messaging ToolOperating SystemWindows, Windows Server, Red Hat Linux, Oracle Linux, Unix

Tools: MS Office, TOAD, SQL Developer, SQL Navigator, Quality Center, QTP, RemedyIncident Tool, BMC Service Desk tool, Putty, Win SCP, FTP Server, Dataload, UPKMicrosoft Sharepoint, Lotus Notes, Tortoise SVN, Notepad++,Kintana

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Application Engineer

Responsibilities:

• Design, Analyze and develop business solutions for Supply Chain, Planning, Process Manufacturing and Demand Application.
• Design and Develop integration of TMS (Transport Management System) with Oracle EBS . Sending Details order details getting back with Ship method, Trip Information including Master BOL Number.
• Design and Develop Shipping Workbench to have all functionalities Pick Releasing, Assign/Un Assign Trip/ Create Deliveries, Assigning to Employee for fulfillment of order execution, Assigning Stage/ Dock Door
• Build and Designed Dispatch Form (Used for Pick Confirm) based on Trip.
• Build Custom Process to Run Ship Confirm and Trip Close Functionalities based Delivery Date maintained in one of DFF Attribute.
• Customized Order Workflow two integrated to populate auto schedule dates based on ship method and shipping calendar. Validating data based on booking event no of pallets.
• Added Additional Nodes for creating Broker information transferring to third party and as well integrating other complex functionalities in while order fulfillment process.
• Build Custom MWA Pages for Pick Reverse, Custom Inter-org Po Receipt, and Extended Standard PO Receipt Screen which included Bulk Packing Operations while receiving.
• Build Complete Custom Cycle Count Process Telnet Pages for Aggregate, Un Scheduled Counts, and Detail Cycle Count and Build monitor process to auto-generated cycle counts based on material movement in Warehouse.
• Developed Custom Cycle Count Process which includes MWA Pages Design and Custom Forms automation for Blank Locators.
• Build Global WMS Rules based on Order Type, Customer and Pull Date of Product generated in Process Organization.
• Custom Indented BOM explosion Process which will give all the batches and their receipe formula details.
• Custom Backflush process which includes packing and moving Completed Products into Shipping orgs since we are not shipping material from Process Org to Discrete Orgs.
• Build Custom MWA Screen for moving Raw Material / Returning remaining raw material back to other production sub inventory including custom process for sub inventory, Container pack, Container Un Pack and lot Translate functionalities.
• Build and Designed process after Master-Schedule ASCP inter Org Process based pulled information from EBS into VCP Planning instance, changing collected data accordingly based on business requirement.
• Build Custom Process for Sourcing Rule/ Category Synch Process/ BOM Shifting formation/ Forecast Redirection Process in ASCP.
• Build and Designed using various reporting Tools in VCP like XML/BI Publisher and VCP OBIEE like Planning Material Usage Reports, Planning Material Score Card, Inventory Material Report, RCCP (Resource Requirement) for 26 weeks horizontal window, DRP Analytical Cube data based on PDU Usage.
• Build Custom OAF Frame work pages for configuring parameters and inventory Accuracy execution form which has feasibility to execute some queries to populate based on rule definition show data in OBIEE Reports.
• Build Custom OAF Pages for Introducing new NPI ( New Product information) based on structure and build process to take source and target items and created items in Demantra and Copy history from likely source item given and categorized these items as NPI Items
• Build Process to Introduce New Adjustment Schedule (Customer) information into Demantra System.
• Build Custom PDQ RPD which will merged to VCP RPD to show master data consistency depend upon inventory item usage in Process Manufacturing Orgs (OPM)
• Technical design and development - Demand planning solution for Direct & DSD business of Confidential ’s Lance, Forecast Interface for Supply Planning Systems, Interface for Historical sales from EDW
• Integration with trade promotion systems
• Custom program design and development for reporting need and integration touch-points not supported by standard configurations.
• Design Solution for integration process of Third Party Software’s like TMS, TI and EDI Applications
• Participate in meetings for gathering requirements when any acquisition is happened ( Participated Big Acquisition Project merging Diamond into Confidential ’s lance in two phases )
• Gather Business Requirements and prepare technical and Functional solution uploading into sharepoint for business sign off
• Handle 3 PL Process using EDI Document Processing ( 947,850,944,943,944,940,945,846), we have complete third party warehouse managed products
• Attending Status Meetings for providing each Incident, Enhancement and On Going Project Status to the higher managements.
• Deploy Code changes as per SOX Compliance guide lines by following well defined ALM (Application Life Cycle Management Process.
• Doing Functional Setup for Order Management, Inventory and Planning based on rollout for each warehouse.
• Participate month end/ year end process in Supply Chain Applications, Clearing Pending transactions by providing functional inputs to business users.

Confidential, Charlotte, NC

Oracle Techno-Functional Consultant

Responsibilities:

• Involved in developing Replenishment Form for which will create Sales Order, Purchase Order and Requisition based on Source Type of Item.
• Developed Order and Order Fulfillment process utility package to utilize in Customized Receiving and Shipping Workbench forms.
• Developed AR Single Invoice, Recurring Invoice which will create AR Transaction if any loans it will create AP Invoices
• Developed Credit Rebuild Forms which will create AR Transactions, Credit memos, Debit Memo’s Applying Credit Memo to AR Transaction using API’s.
• Developed DSD Settlement Report and Statement Processing Report using BI Publisher with XML Bursting sending mail and print conditionally.
• Developed Material Transactions Adjustment form which will create Misc Transactions in Inventory.
• Developed Custom Attachment Configurations forms for attachment solution which will call from custom.pll as menu options for different entity types. Which includes custom attachment form of OAF
• Customized standard workflows (PO and Requisition Account Generator Workflows), CST Standard cost workflow. Order Management workflow.
• Developed various custom reports in AR, AP, OM, PO, INV, GL by using various DSD Customized Tables like. Warehouse Invoice Reports, Cycle Count Listing, history and variance, Open Replenishment details report using XML Publisher.
• Developed POD Claim Process Report using Bursting as well as Mail Utility to send summary details.
• Developed Inventory Synch Process using Cardex Tables.
• Participated in CRP-1, CRP-2 and CRP-3 Testing (UAT) and Production go Live

Confidential, NC

Oracle Sr.Technical Consultant -- Offshore

Responsibilities:

• Developing new XML Publisher reports and customizing existing Oracle standard RDF reports to meet the requirements using Reports 10g.
• Worked on developing Custom Item Search Page using OAF additional functionality having exporting data in CSV file.
• SOA/ Web methods interaction program enhancements/developments.
• Worked on implementing Payable invoices upload, AR Transactions imports, Customer/Customer Site Details Create/update using WEB ADI Custom Integrator process
• Creation Sales Order Interface and Order Fulfillment process up to Pick Release using OE ORDER PUB API.
• Creating Sales order transaction split process by customizing OEIL workflow to recognize margin sales process.
• Customizing XSL-FO PO Communication Report.
• Implemented AP Supplier Bank Create/Update Form with OAF and Workflow.
• Enhancements (Volumetric), Customizations & Change Request.
• Set up test data/scenario as required for testing the resolution of the issues
• Preparing MD50, MD70 and TE20 documents.
• Migration designing and strategy development of legacy data into Oracle Apps, testing the functionality for new enhancements.
• Creating General Ledger Interface for Reversing Cost of Sales and Customer Revenue Reversal Entries and margin sales reversal based on sales reorganization from multiple source based on FIFO.
• Worked on VO/CO Extension for adding additional details and custom behavior to standard oracle self service pages. Done the Unit Testing, TE20, MD120 preparation

Confidential, Atlanta, GA

Oracle Technical Consultant

Responsibilities:

• Work on environment of Supply Management Modules, Procure to Pay process modules.
• Managed day to day business issues for AP, PO, iProc, Workflow, GL modules, Customer Data Hub, Handle critical and show stopper PROD issues.
• Provided support for Customer Data hub complex Queuing design process using Oracle AQ and DQ Process and also monitored daily process of customer details.
• Worked with Quality Center (QC) help desk and Remedy Incident tools to resolve Level 2 and Level 3 issues.
• Worked on Man Import Transportation Invoices Interface and MAN Ariba Invoices Import Interfaces for integration of Transepta and Ariba Invoicing System.
• Created Manheim Contractors Payments internal self service page.
• Worked on Manheim Payment Register Report
• Created Custom Package to produce output in text, csv and excel out based on parameter Manheim Account Analysis Report (Text).
• Worked on Customizing Un-Assigned Employee Workflow and writing custom matching rule for i-Expenses module for Amex Card Processing.
• Worked on Man Invoice Register Report, Manheim Un Invoiced Receipts Report
• Supported the client’s R12 apps installation in Reports, PL/SQL Packages/ Procedures
• Assist end users directly, super users in resolving the issues through phone, Cisco or Oracle Stbeehive OWC and providing instructions to the users.
• Initiate Bridge/Critical calls and involved every team and managed the call until the show stopper issue got resolved.
• Performed in finding the Root Causes Analysis (RCA) issues and prepared documentation and provided precautionary instructions.
• Coordinate Offshore/Onsite team for the different issues, schedules, meetings, client requirements to get good understanding between teams and client requirements/issues.
• Prepare business process document, support document, user manuals, test cases for the enhancements and extensions.
• Prepare Whitepapers for the ongoing chronic issues to help other teams in the organization.
• Coordinate with client, DBA, functional and technical team for the helpdesk issues, performance issues, and CEMLI issues.

Confidential

Oracle Technical Consultant

Responsibilities:

• Worked on Building OAF Pages for Contracts Modules extension functionality fulfilling as per client requirements Celgene Contract Request Form it will work based on roles, Contract Request Configurations Page, Contract Request Search page which contains four regions for each status of request. This form will be dynamically changes the required fields based Agreement Type this configurations will be made in XXCL Configurations Page
• Developer XXCL Daily Contract requests details report using bursting methodology need to send mail to specific persons.
• Modification of custom components as per various requirements.
• Preparing Migration Script for all Custom OAF Pages and Other Business Components like EO, VO, CO and related DB Objects. Done the unit testing, TE20, MD120 preparation.
• Attend daily conference calls with on-site client IT team on support and prepare status reports.

Confidential

Oracle Technical Consultant

Responsibilities:

• Work in the Supply Chain Management Modules, Procure to Pay process modules.
• Developed Uganda Airtel Employee Conversion Program.
• Developed Customer(TCA) and Supplier(TCA) Conversions Program
• Developed Item Conversion Program with Categories, On hand Quantity Conversion.
• Developed Open Purchase Orders Conversion Program, Open PO Receipt Conversion Program.
• Developed AR Transactions Conversion Program.
• Developed Test Scripts and Audit Reports for the conversions.
• Developing Homisco Interface Program for Post Paid Customers for creating Customer Transactions.
• Developed / Customized seeded reports based on customer requirements.
• Designed Interfaces like GL Interface, AR Transactions Interfaces.
• Prepared Unit Testing, MD-070 and MD-120 Documents along with Test Scripts TE-020 Documents
• Created concurrent programs, values sets and created LDT files for migrating from one instance to other instances on each phase of processing
• Worked on creating Customer Outstanding Details and Summary report in XML Publishers.
• Designed Interfaces process for AR Receipts using Receipt API based on receiving payments file received from internal finance team.

Confidential

Oracle Technical Consultant

Responsibilities:

• Understanding MD-50 and CV-60 Documents for Extension and Conversion process.
• Preparing MD-70 technical design document and MD-120 Component deployment documents.
• Engaged in Unit testing and Peer reviews of team members Work requests.
• Creating all custom objects like Concurrent Programs, Value Sets
• Creating LDT Files for Concurrent program and migration scripts for other DB Objects.
• Developed CV060 C103 Contingent Rent Conversion
• Developed components and MD070 for PN E126 Contingent Rent Automation Extension
• Developed components and MD070 for DBI PN R058 Contingent Rent Calculation by PC Report
• Developed components and MD070 for DBI PN R059 Percent Rent Income-Six Months Trend Report
• Developed DBI AR I247 State Sales Tax ID Interface.
• Developed DBI AR I248 Populate State Reporting Table Program.
• Developed DBI AR I249 Generate File for State Reporting XML Publisher Bursting report.
• Developed DBI Stores with No State Tax ID Excel Output Report.
• Developed DBI Error Communication Interface process

Confidential

Oracle Technical Consultant

Responsibilities:

• Migration designing and strategy development of legacy data into Oracle Apps
• Developing/Customizing Discoverer and RDF reports by thoroughly understanding the requirement documents (MD-50).
• Developing Custom queries and folders in Custom Business Area using Discoverer 10g Administrator.
• Developing reports using the Custom folders in Custom Business Area using Discoverer 10g Desktop.
• Creating Custom packages/function and registering them with Discoverer business area using Discoverer Admin.
• Worked on Interfaces to import Receivables Transactions into the interface tables in Accounts Receivables (AR). Successfully designed and implemented the Auto Invoice Import Interface. Activities involved extraction, importing Transactions into interface tables, defining sources for import and then using Auto Invoice Import Interface to import the data into the base tables
• Performed Banks migration API to import External Banks, Bank Branches and Bank Accounts into Cash Management (CE) and assigning them to respective Supplier, Supplier Sites.
• Developed component for conversion Oracle Sales Orders using OE ORDER PUB API’s
• Extensively used AOL and System Administrator modules for Creation of various Concurrent programs, Request sets, Value-sets and Descriptive flex fields, request groups for reports and concurrent requests.
• Creating Item Classes and assigning Item classes to respective reports. Developing new XML Publisher reports and customizing existing Oracle standard RDF reports to meet the requirements using Reports 10g .Enhancements (Volumetric),Customizations & Change Request
• All necessary support related to QA (Quality Assurance) for new enhancements.
• Developed Item For casting Report based on demand of the items

Confidential

Oracle Technical Consultant

Responsibilities:

• Custom Integration process for Clipper Ship Application for Transportation
• Pack Slip Report Customization (RDF to XML Publisher and Barcode Report)
• Preparing MD-70 technical design document and MD-120 Component deployment documents.
• To study the requirement document provided by Client (MD 050) to develop new custom reports.
• Developing the new custom RDF, XML Publisher with barcode technology.
• Worked on Public API for Sales Order, Freight Cost update and ship Confirm API.
• Involved in Analysis, Designing, Development, Testing and Implementation of Interface and Public
• API’s and Reports development in Oracle Applications 11.5.10 environment.
• Registration of Concurrent Programs and Define The Value Sets and values, Preparing migration scripts using FNDLOAD.

Confidential

Oracle Technical Consultant

Responsibilities:

• Developing Honda Service Request Form using OAF which contains insert, update and integrated with XML publisher reports.
• Integrating XML Publishers Report to OAF
• Developing Manual Search Page by proving ANY Or ALL functionalities using OAF
• Preparing migration script for OAF BC4J components along with page and Region Definitions
• Creating Shared LOV regions and Inline LOVs for using in OAF Honda Service Request Form
• Creating Upload OAF Page to upload Image files into pre configured locations.
• Preparing MD-070, MD-120 documents.

Confidential

Oracle Technical Consultant

Responsibilities:

• Interface Mapping Form using OAF (which maps legacy columns to standard oracle columns/ for API programs it maps to staging tables).
• Usage Tracking OAF Form, Export/import Data Mapping Form
• Pl/SQL Programs which is used internally for validation and for other details.
• Collecting requirements, involved in creating the Functional Specifications.
• Worked on Interfaces to import Receivables Transactions into the interface tables in Accounts Receivables (AR). Successfully designed and implemented the Auto Invoice Import Interface. Activities involved extraction, importing Transactions into interface tables, defining sources for import and then using Auto Invoice Import Interface to import the data into the base tables
• Performed Banks migration API to import External Banks, Bank Branches and Bank Accounts into Cash Management (CE) and assigning them to respective Supplier, Supplier Sites.
• Developed a custom program in order to extract from R11 tables using DB Links, validate and load the data from staging tables into Interface tables which is a three step process in which the 1st phase is like extracting & loading all the vendors into staging tables and the 2nd phase is like validating extracted data, upload into Interface tables and 3rd phase is loading all the Supplier, Sites and Contacts with the help of using Public API’s
• Developed component for conversion Oracle Sales Orders using OE ORDER PUB API’s
• Deployment of Toolkit as per the requirements and Unit testing and peer reviews and developing ALL AIM Documents MD 70, MD 120 and TE40 Documents.