• Oracle Applications Technical Consultant with 9 years of experience in various oracle application modules. Experienced in designing and developing PL/SQL, extensions, Reports, conversions and interfaces. Has good exposure to fusion middle-ware technologies like OBIEE, XML Publisher, Hyperion reporting tool FR-Studio, Oracle ADF.
• Worked on Oracle Applications versions 11.5.10, R12.1.3 and Fusion.
• A good team player with excellent communication skills.
• Includes 1-year onsite Germany experience.
• Good Exposure towards Fusion application FAH Fusion Accounting Hub , Hyperion reporting tool FR-Studio and OTBI Oracle Transactional Business Intelligence .
• Good exposure in Oracle application module Oracle Order Management SCM , Receivables AR , Inventory INV , Payables AP and Purchasing PO .
• Expertise in Order-to-cash OTC , Procure-to-Pay P2P cycles.
• Experience in design and development of RICE components. Worked on various aspects of Oracle Applications including development of PL/SQL, Reports, Interfaces, Conversions, Extensions
• Worked on AOL features like concurrent programs, request sets, value sets, and profiles.
• Extensive experience in PL/SQL programming, including creation of stored packages and procedures, functions, Apps Screen customizations utilizing Custom.pll, design and development of extensions.
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL Loader, SQL Plus, Data Loader, TOAD and UTL FILE.
• Worked in various projects involving migration, conversions and customization of Oracle Applications and also integration of Financials and Supply chain modules.
• Good problem solving and trouble shooting skills, highly motivated and ability to work as an individual or as a dynamic member in a team.
• Good team player with excellent communication, interpersonal and leadership and presentation skills
• Exposure to onsite-offshore model

Confidential

Role: Senior Technical Consultant

Environment: Oracle Applications R12.1.3

Software: Oracle10g, SQL, PL/SQL, XML Publishers, SVN, PUTTY, WINSCP, SQL DEVELOPER.

Modules Involved: Payables, Fixed Assets, General Ledger

Responsibilities:

• Support onsite team in solution design and process documentation.
• Worked closely with Business Analysts in gathering functional requirements MD50 and created technical documentation MD70
• Worked on Conversions and retrofit 11.5.10 objects into R12.1.3
• Worked on customization of payment process profile reports using XML Publisher
• Built unit test scripts and unit testing
• Defining Data Groups, Menus and Report Security Groups. Defining Responsibilities, attaching Menu and assigning it to end-users.
• Defining Parameterized Concurrent Programs and Executables.
• Track Daily status and attend Daily status call to provide update on behalf of the team.
• Responsible for created Installation documents MD120 with details specification on Installation steps, Pre-Requisites and Post-Requisites,
• Review Developed objects and take care of code migrations using SVN
• Conversions Developed:
• Fixed Assets Conversion
• COA Conversion
• Value Sets Conversion

Confidential

Role: Senior Technical Consultant

Environment: Oracle Applications R12.4.1

Software: Oracle10g SQL, PL/SQL, Reports 10g, EBS R12.4.1.1, CUSTOM.Pll, Oracle Workflow.

Modules: Order Management, Purchasing, Inventory

Responsibilities:

• Support onsite team in solution design and process documentation.
• Preparation of technical design documents.
• Worked on Extensions and retrofit 11.5.10 objects into R12
• Preparation of unit test scripts and unit testing
• Worked on Order Management TAX extension which involved customization of Sales Order Headers, Lines Screens and Oracle Sales order Workflow. Created PL/SQL Program to update the sales order information using API's
• Worked on CUSTOM.pll and PL/SQL program to default PO Price from source defaulting rules DFF
• Created PL/SQL packages for reporting available Inventory Onhand Data.
• Created SQL programs for Item's Float class auto classification reporting
• Defining Parameterized Concurrent Programs, Executables.
• Review Developed objects and take care of code migrations using KINTANA
• Support Onsite team in resolving issues identified during CRP1, CRP2 CRP3 and CAT cycle testing

Confidential

Role: Senior Technical Consultant

Environment: Oracle Agile PLM

Software: Software: Oracle10g, SQL, PL/SQL, HPQC, SQL Developer

Modules: Oracle Agile PLM

Responsibilities:

• Working with users on gathering requirements for data migration from Arthrex INC, ACI and GmbH legacy systems to Agile PLM
• Preparation of technical design documents.
• Designing SQL Scripts to test the correctness of the data migration from Legacy systems into Oracle Agile PLM.
• Preparation of unit test scripts
• Unit testing using HPQC tool
• Received Appreciation from Client on continuous help to Client-Technical Team and for being proactive in resolving issues.

Confidential

Role: Technology Lead

Environment: Fusion Applications

Software: PL/SQL, FR-Studio, WEB-ADI, Smart-View's

Modules: Oracle Fusion Accounting Hub

Responsibilities:

• Support onsite team in solution design and process documentation.
• Preparation of technical design documents.
• Integration of General Ledger with Fusion Accounting Hub using Oracle Golden Gateway
• Setting up of COA, Ledgers, Calendars and Currency in Fusion accounting hub
• Preparation of unit test scripts
• Developed around 25 Financial Reports using Hyperion reporting tool FR-Studio
• Unit testing
• Trained End users to develop Financial and analytical reports on FR-Studio and to work on software tool Smart View's

Confidential

Role: Technology Lead

Environment: Fusion Applications

Software: Fusion Application Setup Manager 11g ASM , Oracle Data Integrator ODI , Oracle Diagnostic Tests Framework 11g ODF

Modules: Fusion Financials

Responsibilities:

• Worked on Developing ODI interfaces to migrate data from R12 Financial base tables to Fusion Financial base tables
• Prepared Spreadsheets column Mapping for R12 Base tables to Fusion tables
• Worked on Orchestration of ODI interfaces
• Involved in CRP1 Data migration testing of all Financial modules and resolved the issues raised during cycle testing
• Track daily status of the interfaces developed by team and report it to Onsite coordinator on behalf of team.
• Prepared unit test scripts and Unit test the components
• Review interfaces developed by the team and enter code review comments in issue tracker
• Prepared row count validations for all Fusion Financial modules to check row count of the data migrated from R12 base tables to Fusion base tables.
• Worked closely with Oracle Financial Experts to identify table structure changes from R12 to Fusion

Confidential

Role: Technology Analyst

Environment: Oracle Applications 11.5.10

Software: PL/SQL, SQL LOADER, Reports 6i, Oracle Workflow, Putty, Toad, WINSCP

Modules: Order Management OM , Inventory INV , Receivables AR , Purchasing PO , Payables AP , General Ledger GL

Responsibilities:

• Worked with Users to gather functional requirements
• Analyze client requirements and prepared functional documents
• Conducted daily status calls with offshore team to track the service requests
• Coordinated with Offshore to get the development work done Interface between client and offshore .
• Interacting with the customer regarding the testing of the implemented solution and was responsible for the complete testing.
• Involved in end-to-end testing and testing support.
• Handled technical transition to client technical team and completing Knowledge Transition KT documents
• Resolve production support issues with in SLA
• Responsible to fix the Production Issues
• Took care of Month-End INV period closure activities and reconciliation activities
• Defining Data Groups, Menus and Report Security Groups. Defining Responsibilities, attaching Menu and assigning it to end-users.
• Defining Parameterized Concurrent Programs, Executables.
• Received Appreciation from Client on continuous help to Client-Technical Team and for being proactive in resolving issues.

Confidential

Role: Senior Software Developer

Environment: Oracle Applications 11.5.10

Software: PL/SQL, SQL LOADER, Reports 6i, Oracle Workflow, Putty, Toad, WINSCP

Modules: Order Management OM , Inventory INV , Receivables AR , Purchasing PO , Payables AP , General Ledger GL

Responsibilities:

• Preparation of Detailed designs, Software development, Code walkthrough, Resolving technical and design issues and performing independent unit testing.
• Worked extensively on conversions, extensions
• Items Conversion
• Open Payables Invoice Conversion
• PO Conversion
• Supplier Conversion
• Conversion Developed
• Request Group and attaching the request group to responsibilities
• Preparation of AOL tasks Creating Executables, Concurrent programs, creating
• Responsible for trouble shooting and helping team members in understanding requirement and fixing issues.
• Handled role of training campus hires.
• Mentor for junior resources in team.
• Involved in developing programs to meet the new system requirements of the client which were developed using the PL/SQL, Oracle Forms and Reports.
• SQL Tuning and troubleshooting, Trace file analysis
• It also involves supporting the client in the regular production issues and to work on the resolution of bugs encountered during production support, undertaking systems study and carrying out technical discussion for the purpose of new systems development.

Confidential

Role: Senior Software Developer

Environment: Oracle Applications 11.5.10

Software: PL/SQL, SQL LOADER, Reports 6i, Oracle Workflow, Putty, Toad, WINSCP

Modules: Order Management OM , Inventory INV , Receivables AR , Purchasing PO , Payables AP , General Ledger GL

Responsibilities:

• To Support TAIS in regular production support issues.
• To work on the resolution of bugs encountered during production process.
• To work on minor enhancements i.e make appropriate modifications /enhancements to the Reports, workflows, Forms, Extensions as required by TAIS
• Involved in working on enhancements tickets in Order Management, Inventory Modules.
• Mostly worked on Order-to-Cash OTC and Procure-to-Pay P2P cycles
• To work on major enhancements, as part of this I have developed new Reports, Interfaces, extensions, created Alerts, and written Shell Scripts.
• Out Bound Interfaces Developed as part of Enhancements were
• Item Master Information Interface
• Customer Master Information Interface
• Warehouse Master Information Interface
• Item Inventory Information
• Outgoing Shipment Information
• Intransit Information Interface
• Sales Information Interface
• Purchase Cost Information Interface
• Arrivals Information Interface
• Defining Data Groups, Menus and Report Security Groups. Defining Responsibilities, attaching Menu and assigning it to end-users.
• Defining Parameterized Concurrent Programs, Executables.
• Involved in Performance tuning of Custom Packages which were taking long time to execute in production instance
• Involved in supporting Month-End reconciliation activities.

Confidential

Role: Software Engineer

Environment: Oracle Applications 11.5.10

Software: PL/SQL, Reports 6i, Putty, Toad, WINSCP

Modules: Order Management OM , Inventory INV , Receivables AR , Purchasing PO , Payables AP , General Ledger GL

Responsibilities:

• Preparation of Detailed design documents, Software development, Code walkthrough, Resolving technical and design issues and performing independent unit testing.
• Worked Extensively on Oracle Reports.
• Developed Triggers, PL/SQL Procedures and Functions for these reports
• Developed below reports
• Credit Held Orders Reports
• Aged Debt Report
• Inventory Synchronization Report
• Bill Of Lading Report
• Pick Slip Report
• Order Shipping Labels
• Backorder Report
• Product Return Report
• Defining Data Groups, Menus and Report Security Groups. Defining Responsibilities, attaching Menu and assigning it to end-users.
• Defining Parameterized Concurrent Programs, Executables.