SUMMARY

• Having 10+ years of experience in Fusion Applications, Oracle Applications 11i/R12 including Designing, Developing, Customizing, Testing and Implementation of Oracle SCM, Finance and Project Accounting Modules.
• Strong development skills with Oracle SQL, PLSQL, UNIX Programming, Oracle Reports, Oracle Forms, Oracle Application Framework(OAF), Application Development Framework(ADF), Oracle Web ADI, BI Publisher (XML Publisher), Java, J2EE, JSF and Oracle workflow.
• Extensive experience in working with Fusion Applications, Oracle Applications 11i/R12 Finance modules such as Oracle Payables (AP), oracle Receivables(AR), General Ledger(GL), Sub ledger Accounting(SLA), Trading Community Architecture (TCA) and working experience in SCM modules such as Purchasing (PO), Order Management (OM), Inventory (INV), iProcurement and Project Accounting (PA).
• Contributed for various types of oracle Apps projects (Implementations, Support/Maintenance and Upgrade).
• Expertise in Procure to Pay (P2P) and Order to Cash (O2C) flows.
• Expertise in developing RICEF components (Reports, Interfaces, API’s, Conversions & Extensions, OAF) in Oracle Applications E - Business suite 11i and R12.
• Profound Experience in development of Application Object Library (AOL) like registration of Concurrent Programs and Reports, defining Profile values, Value Sets and Descriptive Flex Fields (DFF).
• Proficient in using SQL*Loader, PL/SQL and APIs for data Conversions and Validations worked on Stored Procedures, Functions, Packages, Database Triggers.
• Expertise in the Customization, Extensions and Personalization of OAF Components.
• Good work experience on Application Development Framework (ADF).
• Worked on the Implementation of Fusion Applications Project.
• Knowledge on Big Data.
• Involved In Data migration activities and migrated large volume of assets from External systems into Oracle Applications.
• Good Experience in creating, maintaining and managing SR’s with Oracle Support via Metalink.
• Experience in Performance Tuning (OAF, SQL and PL/SQL) using Bulk Collect/Bind, Apply Index and Hints in queries after Analyze, Explain Plan, interpret trace files with TKPROF.
• Proven ability to deliver the task on time with excellent quality and customer satisfaction.
• A good team player and leadership skills, capable of quickly adapting to new challenges and environments. Ability to work independently and lead teams.
• Insightful experience in all phases of the system development /implementation life cycle (SDLC).
• Prepare & Review Test plan,Test scope Documents and Test cases,Key resource in successful execution of - UT(Unit Testing),FIT(Functional Integration Test),SIT(Systems Integration Test) and CAT(Client Acceptance Test)
• Good working knowledge of all the stages of Applications Implementation Methodology (AIM) and Oracle Unified Method (OUM).
• Having Fair knowledge on Oracle Fusion Application Cloud Products (SaaS, PaaS and IaaS).
• Exposure on Oracle Service Oriented Architecture (Oracle SOA), ODI and Informatica.

TECHNICAL SKILLS

ERP: Fusion Applications, Oracle Applications 11i, R12

Databases: Oracle 9i/10g/11g

Operating Systems: UNIX, Linux, Windows NT/ XP, 2003, 2007

Languages: Oracle SQL, PL/SQL, Core Java, J2EE, JSF, UNIX shell scripting

Oracle Tools: Oracle D2K Reports 10g, XML Publisher, SQL*Plus, Jdeveloper 9i/10g/11g

Other Tools: SQL*Loader, TOAD, WinSCP, Putty, HP PPM, Clear Quest, Harvest, Kintana CVS, SVN, HP Quality Center, FTP, SFTP.

Middleware: Oracle SOA

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale

Senior Oracle Apps Technical OAF Consultant

Environment: Oracle Applications R12 (12.2.5)

Responsibilities:

• Developed many complex OAF pages like Custom Payment Reconciliation Screens in Receivables.
• Worked on Extension and Personalization of OAF pages.
• Developed PLSQL packages which will be called from OAF pages.
• Solved the Performance Issues in OAF pages by generating the Trace Files and interpret with TKPROF Files.
• Used PL/SQL Bulk Bind & Bulk Collect concepts in PLSQL packages.
• Prepared MD050 for RICE development.
• Worked closely with FA team and help/assist them in doing Depreciation of the Assets, Retiring and Unplanned Depreciations and useful life change Whenever needed.
• Having Good knowledge on FA and AP Setups.
• Created users and assigned Responsibilities.
• Supported during month end period closure.
• Worked on the system Administration module, created users based on request basis and assigned the requested Responsibilities.
• Support day to day issues in AP, FA and GL Modules.
• Developed Value Additions Reports as per client requirement using FA Module.
• Building the test case scenarios for General Ledger, Account Payables, Account Receivables and various Polycom customizations.
• Tested all scenarios in FA including Assets, Retirement, Useful life, Cost adjustment, Unplanned Depreciation.
• Preparing technical document and installation documents for developed components.
• Provide timely status to Client on the components.
• Interact, analyze and understand the requirements thoroughly with the Client.
• Involved in discussion with the Client for the Requirements gathering.
• Involved in fixing the Defects and enhancements.
• Assisted the Functional Team in preparing the Test Case Scenarios.
• Ensure that the team thoroughly understands the requirements during FD transition and raise all the necessary clarifications.

Confidential, Sanjose

Senior Fusion Apps Technical ADF Consultant

Environment: Oracle Applications 11i, R12 and Fusion Application (11.1.7)

Responsibilities:

• Worked on ADF Customization in the Fusion PPM Module (Project Accounting).
• Developed Custom AP Invoice Import Program in Oracle Payables.
• Created new custom ADF pages from scratch in Inventory Module.
• Worked on Oracle SOA to integrate third party web services to Oracle Staging tables.
• Developed BI Publisher Reports in Fusion Apps which earlier developed in Oracle 11i.
• Developed PO interface for loading third party purchasing information to the R12 system
• Developed supplier conversion for loading legacy data to the R12 system
• Understanding the Changes between the Oracle Applications and Fusion Applications.
• Sharing the knowledge on Fusion Apps with the new team members.
• Involved in discussion with the Client for the Requirements gathering.
• Assisting web logic/admin Team in creating the custom Schema’s in Fusion Apps.
• Assisting web logic/admin team in the deciding the approach of Code Migration.
• Interact, analyze and understand the requirements thoroughly with the Client.
• Assisted Middleware team in understanding the Interfaces architecture and gained good knowledge on Oracle SOA.

Confidential, Austin

Senior Oracle Apps Technical OAF Consultant

Environment: Oracle Applications R12 (12.1.3)

Responsibilities:

• Extensively worked on Inbound and Outbound Interfaces.
• Involved in the Customization of PO, OM, INV and PLN custom RICEF components.
• Developed custom OAF pages.
• Worked on Extension and Personalization of OAF pages.
• Extensive use of Shell scripting for outbound and inbound interfaces.
• Developed XML/BI Publisher Reports.
• Developed Customer conversion
• Developed GL Balances conversion
• Developed Purchase order outbound interface.
• Involved in fixing the Sustainment Defects and enhancements.
• Preparing technical document and installation documents for developed components.
• Provide timely status to Client team on the components.
• Ensure that the team thoroughly understands the requirements during FD transition and raise all the necessary clarifications.
• Ensure that the team thoroughly performs the Unit Testing by Cyclometric Complexity.
• Ensuring I and team are delivering all the components with high code quality and minimal defects.
• Contributing for Team Staffing activities.
• Published White Paper on Export and Import Web ADI.
• Prepared multiple trackers for TD, Build, Unit testing and CR’s progress to follow-up with team members.

Confidential

Senior Oracle Apps Technical Consultant

Environment: Oracle Applications R12 (12.1.2)

Responsibilities:

• Worked on Enhancement and new requests in R12 Instance
• Worked on Regulatory support issues
• Developed oracle consignment transfer confirmation interface to WMS.
• Developed oracle consignment pending interface from WMS
• Developed oracle consignment and no consignment Report
• Developed XML Publisher Report for the customization of Print PO Report.
• Worked on XML Publisher Report for the customization of Invoice Report.
• Developed Export and Import Web ADI for multiple components.
• Involved in the customization of PO Approval Workflow.
• Mentor team members involved in the development and testing of solutions, including programming, technical, and functional assistance.
• Daily status reporting to onshore team.
• Preparing technical document and installation documents for developed components.
• Raised SR with oracle to resolve standard report issues.
• Doing reviews for all my team members.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications R12

Responsibilities:

• Customized FA and AP Reports as per R12 Compliance.
• Involved in migration of custom objects from 11i to r12.
• Developed and customized various Reports for analysis purpose as per the business requirements using Report Builder 6i.
• Developed Inbound Interfaces to load data into base tables using SQL*LOADER.
• Developed Outbound Interfaces to load from base tables to flat files using UTL FILE package.
• Development and Customization of new and existing Reports.
• Extensively used SQL*LOADER and UTL FILE package for developing Inbound/Outbound Interfaces to load data from/to legacy systems to/from apps base tables.
• Registered concurrent programs with AOL.
• Analyzing Functional/Technical specifications
• Proposed and Implemented improvements to work products, services or processes.
• Analyzing the Prod issues and providing the fix in less span of time.
• Assisting Support Team in resolving Production issues.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11i, R12

Responsibilities:

• Contribution to Project Enhancements - Participated in Design, Construction, Testing, Pre -Implementation and Post -Implementation Activities.
• Involved in Retrofitting activity 11i to R12
• Responsible for up gradation activity
• Understanding client’s current business process and application
• Developed client specific reports.
• Created Procedures and Packages and registered them as concurrent Programs.
• Created tables and registered them with AOL.
• Created technical specifications and the test cases as per the functionality
• Defined Concurrent Programs, Executable and Request Sets.
• Created Value Sets in various modules of the application.
• Testing the Reports after Up gradation Activity.
• Creating New GUI login users from oracle application and providing them the necessary roles and responsibilities.
• Loaded data into staging tables using SQL Loader.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle Applications 11i, R12

Responsibilities:

• Interaction with onsite people and understanding the requirements.
• Preparation of AIM documents for implementation Project
• Creation of value sets in various modules of the application.
• Developed XML publisher Reports
• Developed GL inbound and out bound interface.
• Fixed Discoverer reports.
• Worked on ticketing tools Rational Portfolio manager for resolving tickets or defects