PROFESSIONAL SUMMARY:

• 7+ years of experience as Oracle Applications consultant.
• 5 years of experience as Oracle Application Technical Consultant on implementation, support and upgrade projects.
• 2+ year of experience as Techno - functional consultant in Oracle Application Supply chain modules (INV, OM, BOM and WIP).
• Successfully completed full life cycle implementations using Oracle Applications R12 (12.1.3)
• Proficient in conducting requirements, GAP analysis, Technical Solution Design, Knowledge Transfer and Application Support.
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business suite P2P and O2C cycles.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Work in Process (WIP), Bill of Material (BOM), Accounts Receivable (AR).
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Expertise in System Administrator and AOL Objects like Menus, Request Groups, Responsibilities, Form Functions, Alerts and Concurrent Programs etc.
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Extensive experience in customization of Oracle Application modules, which involves Forms, Reports, Interfaces and OAF pages.
• Worked on AIM documents like MD050, MD070, and BR100.
• Worked on 11.5.10, R12.1.3 version of Oracle apps. (Worked for a shorter duration on R12.2.4)
• Good Understanding of Offshore-Onsite model.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Oracle Applications: Oracle Apps R12, 11i, Order Management (OM), Inventory (INV),Accounts Receivable (AR), Accounts Payable (AP), Purchasing (PO), General Ledger(GL), Bill of Material (BOM), Work in Process (WIP), Trading CommunityArchitecture (TCA), Application Object Library (AOL) and, System Administrator.

Database Tools: PL/SQL Developer, SQL*PLUS, SQL*LOADER, TOAD

Oracle Tools: Reports 6i/10g, Forms 6i/10g, Developer 10g,Workflow, XML/BI Publisher,Jdeveloper, FTP, WinScp.

Databases: Oracle 11g/10g.

Languages: SQL, PL/SQL, XML, Unix

Scripting Language: UNIX Shell Scripting

Management tool: HP QC

Migration Tool: CVS

WORK EXPERIENCE:

Associate Consultant

Confidential

Responsibilities:

• O2C Techno-Functional Consultant for a leading retail and consumer goods company in the USA.
• Order to cash roll-out project for moving customer’s existing business group from legacy system to Oracle Apps 12.1.3.
• Designed solutions for the new business units to fit in the existing Oracle Apps environment which includes configuring ATO/PTO items, scheduling, reservations and customer master configurations.
• Involved in designing new custom solution for Work Order creation and protecting inventory for future consumption.
• Involved in conversion activities like Sales Order and RMA conversions.
• Created PL/SQL functions, based on 4 bucket aging report for custom data points in credit management case folders.
• Involved in developing code for generating UPC/GTIN of manufactured items.
• Setup, create and configure concurrent programs & parameters, Request Sets, Lookups.
• Developed procedures to generate a file in the server using UTL FILE package.
• Worked on both Inbound and Outbound interfaces for transferring the data between Oracle and other systems.
• Designed and developed multiple reports using XML BI Publisher in OM modules.
• Currently working as onsite lead for AMS support, which includes daily monitoring of production tickets and new enhancements.
• Coordinating with the business stake holders to understand the daily pain areas and develop solutions for the same.
• Developed new integration programs with the legacy system.

Associate Consultant

Confidential

Responsibilities:

• Oracle apps lead for a transformation cum R12 upgrade project for a leading telecom networking company in the US.
• One of the major transformation involved migration of custom revenue recognition system from Hyperion to Oracle.
• Involved in understanding the current business scenario with business users and functional team at customer location in the US.
• Developing and designing of new OAF pages for custom Revenue Recognition Program.
• Developed custom program to extract Sales Order data and store in a staging table.
• Performed functional testing of the designed solution in Oracle Order Management and perform revenue recognition for the fulfilled orders.
• Involved in designing technical and functional design document for new CR's.
• Involved in business users on designed solution.
• Identify possible maps and gaps for R12 upgrade and involved in code retro fitment.
• Go-Live and post go-live support at onsite with knowledge transition to production support team.

Associate Consultant

Confidential

Responsibilities:

• Offshore technical lead for R12 upgrade project for a leading Insurance and Risk Management Company.
• Retro fitment/Development of Complex RICE components.
• Conversion of old RDF and discoverer reports to XML Publisher Reports.
• Designed 10+ templates and payment formats for country specific check printing (e.g. Canada, Taiwan, Australia etc.)
• Involved in creating basic functional data in Order Management; sales order, pick release, pick/ship confirm, delivery and invoicing.
• Basic set up of internal bank accounts and payment profiles in cash management for payments and creating functional data in PO and Payables.
• Prepared draft MD050 and MD070 for new change requests, mainly in areas of cash management and Payables.
• Post-upgrade roll outs which includes supplier conversion and interfaces in GL and AP.

Project Engineer

Confidential

Responsibilities:

• Oracle Apps end to end implementation for 3 manufacturing sites.
• Development of interfaces like material transaction with OPM in oracle apps.
• Creating test data for std. purchase order, BPA, sales order and AR Invoices.
• Development of Custom Reports in the areas of Manufacturing, Purchasing, AP, OM and AR using XML Publisher like PO Print report, Sales Order report.
• Form Personalization and Alerts in purchasing module.
• Performing POC's and proposed solutions for some complex requirements.
• Go-Live and Post Go-Live support at customer location

Project Engineer

Confidential

Responsibilities:

• Development of Retail - ORMS MOD's and BI Publisher Reports.
• Customizing Forms and development of Operational Reports using BI Publisher.
• Involved in understanding and analysis of functional and technical requirements from design documents.