SUMMARY:

• 11 years of extensive experience as a techno functional consultant in Implementation, Support and Upgrade projects of Oracle Applications E - Business Suite (EBS) in both 11i & R12 domains encompassing a wide range of skill set and roles
• Strong technical development skills in developing FRICEW components in Oracle Applications E-Business Suite (OAF, Reports, Interfaces, Conversions, Extensions, Workflow)
• Extensive functional experience in requirement analysis, design, development, testing and implementation of various Oracle application modules
• Excellent perspective on converting the functional specifications into technical design and development using SQL, PL/SQL and Developer 6i/10g, BI Publisher
• Tuning of customized application including reports and back end customization by using different application tuning techniques
• Hands-on experience in Workflows, Oracle Application Framework (OAF) and BI Publisher
• Expertise in Conversions and Interfaces
• All aspects of Application Object Library and setting up Oracle Alerts in Application
• Extensive knowledge of new forms development, reports, defining concurrent programs, defining value sets, defining form functions etc.
• Having strong functional knowledge on SCM and Finance modules
• Strong knowledge on TCA architecture
• Hands-on experience in Trade Management/Channel Revenue Management Module
• Good Knowledge on Procure to Pay and Order to Cash business cycles
• Good knowledge of various technical aspects of Oracle Applications including OM, Pricing, PO, INV, ASCP, GL, AP, HRMS, PA, OPM, WMS, System administrator and Application Object Library (AOL), EDI Gateway/e-Commerce Gateway modules
• Experience in Oracle Application Implementation Methodology (AIM)
• Experience in all stages of SDLC (Software Development Life Cycle)
• Post Production support, bug fixing and enhancement experience
• Preparation of POC (Proof of Concepts) to check with design feasibilities technically using the Oracle E-Business Suite of components
• Experience in ALM (Application Lifecycle Management) and UFT (Unified Functional Testing) for Testing upgrade
• Knowledge of ADF, Fusion, SOA Architecture, BPEL, OBIEE
• Planning and execution of Unit, Integration (SIT), and User Acceptance Testing (UAT) through the development of test scripts
• Exposure in devising a project plan for small scale implementation
• Ability to learn and adapt to new technologies, good team player in dynamic work group environments
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment
• Involved in preparing the functional specification (MD050), schema documents, test cases, flow charts, production support & user support documents
• Solid international experience with Multi lingual and Global implementations

TECHNICAL SKILLS:

ERP: Oracle Applications E-Business Suite 11i & R12

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

GUI: Developer 6i&10G, BI Publisher, OA Framework, Discoverer

Tools: and Utilities: SQL*Loader, UTL Packages, JDeveloper, Workflow, MKS, Kintana (ITG), TortoiseSVN, Clearcase, AventX, Appworx, HP ALM, HP UFT, HP QC, HPPM, Microsoft Office, Microsoft Visio

Languages:: SQL, PLSQL, Shell Script and BPEL

PROFESSIONAL EXPERIENCE:

Confidential, Iselin, NJ

Techno Functional Lead Analyst

Responsibilities include:

• Development of MD50 and MD70’s and also involved in the reviews
• Design and architect new solutions for business improvement
• Leading a project sweat to decouple an business line
• Leading a project lucia to roll out EBS to a new entity
• Leading data extraction, validation, data conversion and data migration which is important part of this project
• Closely working with Oracle team on the tickets raised on issues in oracle metalink
• Handling the Post Production Issues and month end closing issues in Purchasing and Order Management and working to close the issues at the earliest
• Understand requirements and preparation of functional design documents
• Peer reviews of the components developed by the team
• Providing solutions for critical custom business processes
• Clearing all the stuck EDI transactions in OTC and PTP areas on daily basis for the business to run as usual
• Extensively involved in upgrade from 12.1.2 to 12.2.5
• Involved in testing the functionality and custom programs for Trade Management module for upgrade project
• Designed and architect for MDM Oracle Item Automation Interface
• Involved in testing center of excellence team for testing the upgrade project with HP tools

Environment: Oracle Applications R12.1.3, R12.2.5 (OM, PO, AP, AR, INV, GL), Oracle 11g, Workflow, Forms 10g, Reports 10g, LINUX

Confidential, MI

Techno Functional Consultant

Responsibilities include:

• Development of new Reports, Interfaces and Extensions as per the business needs
• Enhancement of the current solutions as per the new requirements of the future rollouts
• Understand requirements and preparation of technical design documents
• Peer reviews of the components developed by the team
• Providing solutions for critical custom business processes
• Performance tuning of the existing solutions which are running beyond threshold limit
• Developed several reports like Ukraine Tax calculation of physical person income report, Ukraine Transfer pricing report, Account analysis report, COGS revenue mismatch report
• Worked on RMA receipts interface

Environment: Oracle Applications R12 (PO, AP, INV, OM, AR), Oracle 11g, Workflow, Forms 10g, Reports 10g, LINUX

Confidential

Technical Consultant

Responsibilities include:

• Working on the business documents and reports
• Supporting complex customer and supplier facing business documents
• Involved in the development of the various kind of BI Publisher reports like e-text, xsl and rtf templates
• Worked on regular production support issues to resolve the issues and to meet the SLA's
• Worked on HP QC's to fulfill the user requirements
• Migrating the report objects (files) from non-control instance to control instance using MKS tool
• Development of new reports as per the business needs
• Fully involved in Asia SIT, UAT and GO-LIVE
• Configuration of aventX for mailing/faxing
• Configuration of appworx scheduling
• Peer review the components developed by the team
• Developed ASN (Advance Ship Notice) business document
• Worked on order acknowledgement, customer quote, supplier quote, invoice print, packing slip business documents
• Developed several reports hot zone order priority report, trade invoices report, supplier returns packing slip report, to provide the invoice count for each operating unit, IPV ship and debit multi sheet report and Chinese packing slip report

Environment: Oracle Applications R12 (OM, PO, AR, AP, GL, SCP), Oracle 11g, Reports 10g, LINUX

Confidential, PA

Technical Consultant

Responsibilities include:

• Deliver the solutions for enhancements and bug fixes raised by the user
• Handling remedy tickets and providing solutions within SLA agreements
• Documentation of MD60, RD60 for the enhancements
• Remediating the objects for upgrade from 11i to R12
• Maintenance of Product Profitability Analysis solution
• Developed Shipment Reliability report, Freight cost program
• Maintenance of custom pricing solutions and views for ODP collections
• Developed a new Discoverer report Metal control premium forecasting report in advanced pricing
• Resolved performance issues on ODP views by fine tuning the queries
• Developed new form personalization’s on seeded PO form
• Developed a set of queries in purchasing which will help users for forecasting
• Developed a new anonymous block for priced unpriced report

Environment: Oracle Applications R12 (OM, Pricing, PO, Oracle Demand Planning), Oracle 11g, Reports 10g, LINUX

Confidential, NJ

Technical Consultant

Responsibilities include:

• Involved in Functional Specification Review documents
• Lead the conversion team during mock conversions
• Developed Extensions, Interfaces, OA Framework and Reports based on the client requirements
• Developed an Extension PO Requisition Charge Account Generator Workflow
• Developed an Extension WMS Inventory Balance Reconciliation Report
• Developed an Sales Order Acknowledgement XML Publisher Report
• Developed few Conversions and supported during mock conversions
• Suppliers and Supplier Sites Conversion
• Open Purchase Orders Conversion
• Open Sales Orders Conversion
• GL Balances Conversion
• Developed an Interface MLE Forecast Inbound Interface
• Developed an Interface TMS Inbound Interface
• Developed an OAF page to Create Expected Receipts

Environment: Oracle Applications R12.1.3 (P2P, O2O, O2C, H2R, R2DS), Oracle 10g, Forms 10g, Reports 10g, LINUX

Confidential, MO

Techno Functional QA Consultant

Responsibilities include:

• Involved in Functional and Technical Review documents
• Developed System and integration test design documents
• Supported Enterprise Test team for various stages in the application test
• Tested the functionality of the Change requests
• Prepared and checked the system performance metrics using HP Performance tool
• Uploading the System test cases in the HP Quality center
• Peer reviewing the objects before delivery
• Developed an E911 Batch File Interface
• Involved in different projects (PJ002160 and PJ002114) for system and integration testing
• Generated the system performance metrics on a daily basis
• Performed shakeout tests whenever an instance is refreshed
• Verified the setups in the refreshed environments using BR100
• Worked with development team to get an optimized solution for each CR

Environment: Oracle Applications 11i (OM, INV, Apex), Oracle 10g, Forms 6i, Reports 6i, LINUX

Confidential, CA

Technical Consultant

Responsibilities include:

• Involved in Functional Specification Review documents
• Develop Technical design documents
• Design and develop conversions, extensions, Interfaces and BI Reports as per the business requirements
• Write the UTP and perform the testing
• Peer reviewing the objects of the team
• Developed an Extension to cancel Backordered sales order lines
• Developed few BI Publisher Reports like Weight Sheet Report, LPN Pallet Report, Quality Control Batch Ticket Report, Filling Production Batch Ticket Report and Item Formula Technical Report
• Developed an Conversion Quality Specifications conversion
• Developed an Interface Sales Order interface

Environment: Oracle Applications R12 (OPM, WMS, OM, INV, PO, AR, GL, Quality & Formulator), Oracle 10g, Forms 10g, Reports 10g, LINUX

Confidential, TX

Technical Consultant

Responsibilities include:

• Responsible for requirement analysis, development of new programs and enhancements to existing system, testing & preparation of Technical specification documents
• Writing custom packages to develop conversion and interface programs
• Testing and migrating the objects into multiple instances
• Developed Vendor Load and User Responsibilities Load Conversions
• Developed HR-ADP Payroll interface
• Developed Employee Mass Termination interface

Environment: Oracle Applications R12 (HRMS, PO, AP, AR, FA & GL), Oracle 10g, Forms 10g, Reports 10g, LINUX

Confidential

Technical Consultant

Responsibilities include:

• Review Functional Spec docs and preparation of Understanding documents
• Create Technical design, UTP and developed the component based on the Functional design document
• Develop Extensions, Interfaces and Reports
• Involved in Custom security module and Currency Management activities
• Documenting all the project deliverables including unit test plans and test scripts
• Developed few extensions for security on withholding tax invoices, GL Translation
• Developed several reports like Aggregated transaction report, List of invoices pending approval, User access rights list report, List of purchase orders by project or by organization, Invoices on hold
• Developed an interface for international electronic fund transfers

Environment: Oracle Applications 11i (PO, PA, GL, AP, AR, AX, CM & HRMS), Oracle 9i, Forms 6i, Reports 6i, LINUX