SUMMARY:

• Expertise in Oracle Fusion Applications, Oracle Application R12 EBS & the complete Oracle Systems Development Life Cycle including Reports, Interfaces, Conversions, Extensions, Forms and Workflow (RICEFW), ORACLE BPEL, Oracle BPM, OEM . Oracle EDI, Oracle XML Gateway,3PL Integration to EBS,Oracle configurations/customization, extension, modification, internationalization and localization, and integration framework (CEMLI), and in all types of testing and debugging processes (UT, SIT, CRP and BST) as well as creating test results and test cases on Oracle EBS R12 and EBS R 11i E - Business Suite.
• Hands on experience on Oracle Fusion middleware technology, SOA suite and BPEL, ESB, OSB, WSM, WSDL, and JMS.
• Extensive experience in Oracle SCM,OPM,Oracle Financials, Oracle CRM, Oracle HRMS & OIC Modules in Oracle Application EBS Suite .
• Highly knowledgeable in Oracle BI Discoverer, BI Publisher, Oracle Business Intelligence Tools, Oracle Fusion Middleware, ADF, Flex Fields, workflow, AOL, API,SOA, Oracle Open Interfaces, Concurrent Manager, Oracle Developer Suit 11g, Oracle Forms 12c,11g, 10g, 9i,and 6i, Oracle Reports 12c,11g,10g, 9i, and 6i, Oracle PL/SQL, Database Triggers, Stored Procedures/Functions, Packages, batch programs, Oracle Tuning using Stats pack, DBMS PROFILER, EXPLAIN PLAN, TKPROF, Oracle Hints Oracle Toad, OAF Framework Architecture, J2EE and BC4J, JDeveloper Studio 11.1.1.6 , Java Servlets, form personalization, Page Personalization & Extensions.

TECHNICAL SKILLS:

Languages & Tools: Oracle PL/SQL, Oracle SQL, Pro* Confidential, VC++, HTML, DHTML, Java, XML / BI Publisher,VB script Crystal reports, Toad and Oracle Forms and Reports

Web/Middleware: Apache Web Server, IIS,TOMCAT

Operating Systems: Linux, Sun Solaris, HP - UX, Novell Netware, Windows XP/Vista/NT/2003/windows7 Windows

Databases: Oracle 11g, Oracle10G & Oracle 9i, SQL Server

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Consultant

Responsibilities:

• Support and maintenance of the day to day activities in Confidential applications through the Confidential Service Request System (Service Now Ticketing system).
• Design and development of BI(Business Intelligence) Data Extract from R12 for Inventory, Sales Orders CM/DM,O2C, PO and receipt, ETL to Informatica, Hyperion & OBIEE Reporting system.
• Supporting regular fetch and sync from Oracle DRM, The Confidential Master Data Management system to EBS systems.
• Design and development of Price List Import & Massive Sales Order Import Program for Creation and Updating of high Volume of Sales Order & Price List, QP Price List PUB api used to create /update Price list after validation .
• Assisted in upgrade to Enterprise Standard EBS to 12.2.4 thru Rapid Install and Auto Patch, specially helped in preparing and validating Pre/Post Upgrade Tasks Lists.
• Design and development of Order info customer info and other user info /legacy custom form and migrating them in Oracle form 12c.
• Design, development and support of business process automation by automating process using Oracle OTM, shipment management, booking and tendering,feight payments, billing and claims . automatic re-plan shipments based on related order changes .
• Design and development of AR Dropship DJC and AR Dropship Invoice Pre-printed Format for Chile & Argentina Customers and Enterprise Standard accounting using US GAAP principles and exchange rates .
• Design and development & Solution of specific requirement for Chile lighting business. The requirement is sending e-Waybill and e-Invoice documents to local authority (before sending the actual shipment to the customer). E-Waybill and e-Invoice data is extracted from CCL system and it is send to 3rd party vendor, who is responsible for sending the documents to local authority. Transaction Type DFF (Additional Order Type Information) needed to be define to Cross dock/Non-Cross dock shipments, new document set “CCL Chile Lighting Documents” were setup with “CCL Delivery and Invoice Grouping” program added in the document set.
• Design and development of the Funding Billing Biller Interface CCL Accounts receivables can allow automated creation of AR transactions through inbound feed through FAH, and DXL(Data Exchange Layer).CCL AR,CIS will accept files in CCL format and dimensionality. This extension is built to receive and process automated feeds into CCL Account Receivables module.
• Design and development in SLA for automations in source distribution types, xla events Unplanned Depreciation Transaction to be sourced from asset category and NOT from Expense Account entered during Unplanned Depreciation Transaction.
• Design and development of the AR aging report for Argentina users the requirement was to publish the transactional data in Functional currency as well (apart from the Entered currency), conversion rate between the entered and functional currency (in case they are different) and certain Chart of Account segment values from the Receivable account on the transaction. Additionally they require the report to be published in an excel format.
• Design and development of the AR Collection Report this is a custom report to pull payments with its respective invoices, the credit memos with the invoices that they are cancelling and/or the credit memos with the debit memos. The report should be able to open in Excel format which is further customized with VBA VB script
• Development & Implementation of AP Invoice Form Personalization for Set requester as mandatory and Set Invoice liability account for invoices with PO.
• Worked on Provisioning system/user access and assign responsibility using OIM, OIP, OAP and Policy manager .
• Involved in Support & Interfacing the Oracle Fusion Financials/SOA Implementation for Confidential Business.
• Plan and manage Data Migration in EBS, SQL/Data Loader conversions, testing, Multi country roll out, support, enhancements and SDLC (Analysis, Design and Development) of Confidential ’ Confidential CCL(Central Corporate Ledger) Multi Country Project rollouts.
• Creating Technical Design document & test cases MD70, TE025, MD120 for RICEW Components (Reports, Interfaces, Conversions Extensions as per the Apps standards for the enhancement to the existing application .
• Design review sessions with Business Analyst and Setting up the development and Test environment for the new enhancements, gathering requirements like scheduling and performance requirements of application.
• Data validation of the application with Data validation test cases, defining developer and Test Methodology to carry out the development schedule. Ensuring that Oracle PL/SQL coding is done as per the business requirements and Apps standards.
• Performance tuning and optimization, Peer Code review and Technical Support, resolving deployment issues and coordination with DBA team for deploying services in production.
• Provide knowledge transition and educate application users on the new enhancement done to the existing application.
• Attending review meeting and Change Control Board (CCB) meetings related to the project work.
• Control and track project performance, manage communication on the project through meetings, as needed to resolve project issues and timely reporting project status on a weekly basis to management and the project team preparing and sending out the weekly status report to the client managers.
• Coordinate with other departments to identify and monitor issues, impacts and dependencies.

Confidential, CA

Lead Consultant

Responsibilities:

• Extensive Design & Development of the Inbound and outbound events in OTM, Oracle Revenue Recognition, Oracle Financials AP/AR .
• Design and Development of Oracle SOA, FUSION middleware Interfacing to Send & receive Data from Confidential (Client) Applications
• Development of the Workflow business events and subscription of the events for the specific action to be automated to send the XML messages to the 3PL .& automation and management of Oracle database events in message Oriented middleware, Oracle Advance Queuing (AQ) .
• Extensive Oracle EBS, B2B design and development using XML gateway message Designer to create Data Source DTD designs, Create Data Target, Define Document levels, Perform Hierarchy mapping, Perform Element Mapping and create XML Maps (XGM) for inbound and outbound XML messages.
• Design and development of XML gateway services and message Setup, this task include defining the Trading partner /Hub, Define Code Conversion values, Define transactions, identify DTD directory, Ensure well-formed and valid message transfer, identify proper execution of the XML gateway services -execution engine .Reporting in BI Publisher & OBIEE.
• Claims Inbound, Claims Outbound, Claims Settlement, OTM, Credit MEMO, CHARGEBACK, WRITE-OFF Interfacing & Settlements in OZF Schema Objects, Order Import, inter org transfer by field service technical Portal, Pick Release, Pick Confirm, WMS interfacing & Ship Confirm Process as per Confidential & Oracle Apps R12 Process .
• Inbound /outbound design and development for SOA interfaces from Confidential in house systems to Oracle Apps R12 system.
• Design and Development of Common Application Utility objects to be used for implementation common message Queuing & common utility package for Error Handling, Issue Logging and reprocessing of the concurrent.
• Worked on very tight timelines using AGILE development (SCUM) process to meet the challenging timelines .
• Prepared the functional & design documents like MD50, MD70,TE20 Unit testing, System Integration testing, estimates for the development and customizations as per FWRICE, & AIM methodologies and Oracle Apps R12 Process .

Confidential, OH

Lead Consultant

Responsibilities:

• Development of the Workflow business events and subscription of the events for the specific action to be automated to send the XML messages to the 3PL(3rd Party Logistic Company) .
• Extensive development of the Inbound and outbound events in Oracle Workflow & automation and management of Oracle database events in message Oriented middleware, Oracle Advance Queuing (AQ) .
• Extensive Oracle EBS, B2B design and development using XML gateway message Designer to create Data Source DTD designs, Create Data Target, Define Document levels, Perform Hierarchy mapping, Perform Element Mapping and create XML Maps (XGM) for inbound and outbound XML messages.
• Design and development of XML gateway services and message Setup, this task include defining the Trading partner /Hub, Define Code Conversion values, Define transactions, identify DTD directory, Ensure well-formed and valid message transfer, identify proper execution of the XML gateway services -execution engine .Reporting in BI Publisher & OBIEE.
• Design and development of custom customer Order form in using form 11.1.
• Order Import, inter org transfer by field service technical Portal, Pick Release, Pick Confirm, WMS interfacing & Ship Confirm Process as per Confidential & Oracle Apps R12 Process .
• Worked on Interfaces from Confidential to map the 3PL(3rd party Logistics- Flextronics & UPS ) interfaces and build interface for the automation of the to and fro interfacing of information .
• Inbound /outbound design and development for SOA interfaces from Confidential in house systems to Oracle Apps R12 system on Linux platform .
• Design and Development of Common Application Utility objects to be used for implementation common message Queuing & common utility package for Error Handling, Issue Logging and reprocessing of the concurrent.
• Worked on very tight timelines using AGILE development (SCUM) process to meet the challenging timelines
• Prepared the functional & design documents like MD50, MD70, Unit testing, Integration testing, estimates for the development and customizations as per FWRICE, & AIM methodologies and Oracle Apps R12 Process .

Confidential, NH

Lead Consultant

Responsibilities:

• Design and development for R12 EBS Financials AP,AR,General Ledger,SLA customizations, Personalization and setting up transaction types in AME rules Required for Confidential & Confidential Business process .
• Design and development of the Up charge Correction and rebilling Process as per Confidential & Confidential business process .It has many complex process like Price Correction, Weight Corrections and Fixed Price Corrections after the Order has been invoiced mapping Confidential & Confidential process & Oracle Apps R12 Process.
• Worked on Order Scheduling Process, WMS, OTM interfacing, custom pick slips, Standard credit rates, SOA and EDI customer mapping for Confidential & Confidential business requirements.
• Worked on Interfaces to Confidential and Ad Hub Database for Oracle MDM- PIM Information Reporting in BI Publisher and data extracts for OBIEE reporting.
• Inbound /outbound design and development for SOA interfaces from Mainframe Systems to Oracle Apps R12 system.
• Design and Development of Common Application Utility objects to be used for implementation of the common framework for Error Handling, Issue Logging and reprocessing of the concurrent Programs in P2P and O2C tracks.
• Worked for development of the functions and packages required for the ADF screens required for the Order Edits, Rush Orders and RMA entry screens for Confidential & Confidential Business.
• Worked on OEM for executing BPEL Process Step by step testing and worked on Oracle BPM for Workflow in approval process and exception handling.
• Worked on very tight timelines using AGILE development (SCUM) process to meet the challenging timelines and used the Special feature On/Off Code feature of a particular customization to facilitate Dual development /Implementation scenario.
• Prepared the functional & design documents like MD50, MD70, Unit testing, Integration testing, estimates for the development and customizations as per FWRICE, & AIM methodologies and Oracle Apps R12 Process .
• Provided support using auto task for support ticketing system, Performed user training, project review meeting, created process/program Logic flow documentation which cater to technical & non-technical audience, Code review, solved user queries, and maintained clear explanations of problems and resolution logs.

Confidential, NJ

Lead Consultant

Responsibilities:

• Production Support and Customization in Oracle Apps EBS & EDI Issues, regular checkups on 850 Customer Order, Ship Request, out bound EDI files 856 - Ship Confirmation, 810 - Invoice.
• Production Support, Solutions on Order-to-cash(O2C),OM,RMA Process,OPM, WMS,integration with 3PL,Inventory, Receivables, Procure-to-pay (P2P), Record to report(R2R),TCA process, R12 EBS Financials AP,AR,General Ledger,AME, Advance Pricing Module BOM, Oracle Configurator, PTO,ATO,CTO Promotional Modifier, in Oracle Apps .
• Worked on OEM for executing BPEL Process Step by step Testing and worked on Oracle BPM for Workflow in approval process and exception handling.
• Mapping of customer requirements to 1EDI mapper then to Oracle EDI tables, EDI Process Log table, Soda EDI Deliveries Table.
• HSN Orders Status Clarification on Mapping Errors Generated Issue, Worked on Attention *** Invoice Failure Report, Provided solution for Ship Confirm File without BOL for Macy' Confidential, Worked on MISSING ASN - SODACLUB issue, Worked on Open JCP orders: issue solved /worked on Attention *** Invoice Failure Report .Worked on workflow for Wal-Mart Pallet testing /Worked on Sam' Confidential /Boscov Issue Lines not closed/ Worked on *UPDATE* Unfilled Lines on Independent Orders/ worked on Sysaid, WO - 46425-SODA CLUB USA .
• Worked on creating MIS reports using Oracle BI Publisher, Oracle BI Discoverer 10g Admin and Desktop, Purchase Turns Report, EDI backlog report, Open Orders Report, various reports in Account Payable, Account Receivables, 820 remittance report .supported SAS and TM1, COGNOS reporting systems.
• Worked for development of the for the ADF screens required for the Order Entry, Scheduling and shipping.
• Prepared the functional & design documents like MD50, MD70 for the development and customizations as per AIM methodologies.
• Provided support using Sysaid for support ticketing system, Performed user training, project review meeting, created process/program Logic flow documentation, Code review, solved user queries, and maintained clear explanations of problems and resolution logs.

Confidential, IN

Sr. Oracle Apps Consultant

Responsibilities:

• Executed various reports in Oracle AP/AR module, Sales Analysis, Sales by Item, Sales by Transaction type, worked in BOM, WIP, INV Inventory,OM,PO module, worked on Reports using R12 Discoverer reports,EULADMIN,EUL,Business area, XML Publisher & BI publisher using RTF template, XML data, XSL elements & SQL expressions, Oracle Developer R12.
• Implemented discounting, Oracle Advance Pricing,Modifiers,Qualifiers and Royalties.
• Performed data extracts interface/conversion mapping, pre-production testing, and related documentation and deliverable in Oracle Financials, Oracle CRM/Service Contract, OLM/service contract billing, Oracle Project Accounting and used ODI to integrate with Legacy and OIC module
• Executed upgrade to Oracle Apps release 12(R12) from Oracle application R11i using optimum Project team /time and resources .
• Worked for collecting Customization Percent information for RICEFW components for R12 Upgrade and strategically migrating them to the new version.
• Planning on the sequence of migration with correct DB/Application versions, assisted in testing of the pre existing and new functionality in R12 .
• Designed and Developed Interfaces and integration to Order Management from In-house systems Using Order Import Open interfaces and API, developed the Overnight batch process to substitute the Order line items, Pick release, pick confirmation, ship confirmation and auto invoice.
• Good Implementation Concept of Order-to-cash(O2C),OM,OPM,Shipping,Inventory Receivables, Procure-to-pay (P2P), Record to report(R2R),TCA process and Designed solutions for Financial Reporting, General Ledger,SLA, Oracle Agile PLM, Advance Pricing.
• Implemented Multiorg, MOAC- Multi Org Access Control, ADI, SOB, Cross Validation rules using AIM methodology documentation and standards.
• Utilized advanced PL/SQL scripts (Retcode, Errbuff) to customize applications, Used Optimization & Diagnostics,Oracle TKProf,Explain Plan,ILM Archiving& Purging, Oracle hints used UNIX shell scripting and crontab to automate EDI/Data Interchange, Modified and used Oracle API, created Oracle Packages, Procedures, Functions, Triggers and Oracle Workflow to handle interfaces and customization in Oracle Application.
• Custom Interface to Integrated in-house developed system in Oracle Forms 6i on 9iAS and Linux server with Oracle Application standards.
• Worked for development for the ADF screens required for the Custom Order Entry & EDI Screens for Sunrise And UPS Business.
• Entity Objects EO, View Objects VO, AM, OC4J,.dbc,.jpr,.xml page, regions business component and extensions on JDeveloper using Oracle Framework OAF in OIC module.
• Executed migration to Oracle Apps release 12(R12) from Oracle application R11i.
• Provided support using Numra Track IT for support ticketing system, deployed and maintained the complete subversion edge tools (Subversion Server, Apache Web Server, data repository ), created production repository for the customized codes in applications tier (forms /reports/Shell scripts/SQL/PLL), and customized codes in database schemas.
• Performed user training, Code Review, project reviews, created process/program flow documentation, Prepared MD50, MD70 documents, solved user queries, maintained clear explanations of problems and resolution logs, and maintained the code change version and reviews on the version control system.

Confidential, NH

Consultant

Responsibilities:

• Participated in the creation, administration and design of end user layer for participation, confirmation & payout statements, compensation committee reports, and salesperson commission report, executive reports, and OIC sales statements using Oracle BI Discoverer Work Books and Oracle Portal.
• Worked with resource sync, plan migration, target upload and payment interfaces processes to integrate Oracle HRMS with the Oracle Incentive and compensation OIC module.
• Worked on extract, transform and loading (ETL) process for loading data into STAR data warehouse schema, defined dimensions and fact table for Oracle Portal schema using SSO (Single Sign On).
• Utilized PL/SQL scripting using Oracle API to develop workflow to handle interfaces from Oracle HRMS, Oracle Payroll, Oracle Incentive and compensation, and Oracle Portal systems.
• Extensive usage of analytical functions
• Developed SQL scripts for analysis of data.

Confidential, NJ

Consultant

Responsibilities:

• Consulted with users to identify current operating procedures in order to support the existing system and undertake enhancements including registration to Oracle Apps standard.
• Clarified program objectives for all applications and used SQL Loader and Data Loader for loading/porting data.
• Used PL/SQL to call Oracle API and worked on Oracle workflow business events for payload in Oracle HRMS and Oracle Payroll System.

Confidential

Technical Consultant

Responsibilities:

• Performed setup, customization, development, testing and implementation of Oracle HRMS, Oracle Payroll, iRecruitment, SSHR, OTA, Time and Labor (OTL), Oracle Advance benefits(OAB), SSP(Statutory Sick Pay) module for the Oracle 11i E-Business Suite Installation (iHRMS), customization and implementation for Malaysian Airlines.
• Utilized Oracle Toad and Oracle Reports. Also developed XML publisher report for BI reporting. Utilized PL/SQL for data migration, analysis, and reporting purposes.
• Ensured technical compliance to the requirements, developed program flow documents, Entity Relation Diagram (ERD), program development/logic flow documentation, and ensured timely deliveries and adherence to the quality plan drafted for the project.