SUMMARY

• Having 10+ Years of total IT experience in 11i/R12/Fusion.
• 8+ years of experience with specific exposure to Implementation, R12 Upgrade, enhancement, testing and support projects in Oracle Application(11i/R12).
• Around 2 years of experience with Oracle Fusion Financials as Techno - Fuctional consultant involving in the FBDI/ADF DI/BI reports/OTBI reports/OBIEE reports.
• Technical expertise in Conversions, Interfaces, Customization and Extensions in Oracle Financials & Supply Chain Management modules using Oracle’s AIM/OUM methodology.
• Good experience on Fusion Middle products APM, IDM, BPM and knowledge on SOA.
• Worked on ADF DI Integrations in Oracle Fusion Payables and General Ledger.
• Experience in Fusion Roles and user creation.
• Gathering requirements from business users and preparing Functional Design documents as per the Business requirement.
• Expertise in preparing a Technical Design documents and Unit Test Plan documents for RICE objects.
• Expertise in BI Publisher (XML Reports) with Barcoding and registered FONT in the application.
• Developed BI reports for Oracle Projects with XML Data definition file and template in the .xls file.
• Expertise in development of interfaces (Inbound and Outbound), Conversions, Reports Development and Customization and Alerts and I have good knowledge of Oracle SQL/PL-SQL.
• Expertise in generating outbound files in XML standard format with UTL Utilities.
• Expertise in creating Event Alert and Periodic Alert to send mails, submit programs and etc.
• Good knowledge of AOL (System Administrator, Application Developer) components and creating AOL components like value sets, lookups, concurrent programs and etc.
• Experience with Oracle Utilities: TOAD, SQL-Developer, SQL*Plus & SQL*Loader and other tracking tools like BMC Remedy, BMC, PPM, SNOW, WINSCR3, MAXIMO, RAT, RPM, PVCS and Service Now.
• Worked for R12 Implementation and 11i Support Project for Confidential, Confidential and Hertz.
• Created PO’s, Invoices, Payments and posted to GL (P2P Cycle) for testing the new reports and outbound interface data and Good knowledge on Order to Cash(O2C) Cycle.
• Download/Upload ldt files using fndload for Reports, Alerts, Interfaces programs & AOL components.
• Sales Order Lines import through the WEB ADI.
• Involved in the OAF personalization and Form personalization, Form Customization.
• Trained on BPEL process activities, Decision Service, Partner Links and Adapters (File Adapter, FTP Adapter, Database Adapter, AQ Adapter, JMS Adapter) for developing custom business processes to integrating with different systems.
• Excellent leader ship qualities, positive attitude, adhere to strict deadlines and flexible personality.

TECHNICAL SKILLS

ERP: Fusion Finance, Oracle Applications 11i, R12

Functional Modules: PO, GL, AP, AR, INV, OM and Project Accounting

Database: Oracle 9i, Oracle 10g, 11g and 12C

Programming Languages: SQL, PL/SQL and Shell Scripting

Development Tools: Oracle Reports Builder 6i/9i and 10g

Oracle Forms Builder 6i/9i and 10g, OAF: Oracle Alerts, Toad, SQL*Plus, IBM Maximo, IBM Rational Portfolio Manager,Alfresco,PPM,BMC Remedy, Reflections X, Relfections FTP, XML Publisher Reports, ALM, Service Now and Web ADI

Operating System: Windows XP and UNIX

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Fusion Techno-Functional Consultant

Environment: s: Oracle Applications R12 (12.2.1 and 12.2.2), PO, AP, AR, GL, INV, OM and PL/SQLReports XML publisher.

Responsibilities:

• Customized Purchase Order OTBI report which is going to migrate to the FUSION instance.
• Customized ACH File format to cater business needs for the Cloud Finance.
• Requirement gathering of this project and act as a technical and functional resource.
• Designing the Technical Spec and getting Sign off from the business team.
• Validate the processes and coding are as per the naming standards for the other projects.

Confidential

Oracle Fusion Techno-Functional Consultant

Environment: s: Oracle Fusion Finance, BI Reports, OTBI Reports and OBIEE Reports.

Responsibilities:

• Worked on BI publisher and OTBI reports.
• Developed data extracts in BI Publisher and setup FTP Connections with third party systems.
• Customized AP Check format to cater business requirement.
• Customized ACH File format to cater business needs.
• Worked on FBDI template Load for Suppliers and invoice data.
• Worked on ADF DI Spreadsheet loads for Journal, invoices, Daily rates.
• Custom DFF and Value Sets Creation.
• Worked on IDM and APM modules for creation of roles, user maintenance.
• Raising SR to Oracle to get support on specific issues.
• Configuring test and production environments using FSM.
• Production support on Fusion Financial Applications.
• Developed a custom form in SAAS environment using application composer.

Confidential

Oracle EBS Techno-Functional Consultant

Environment: s: Oracle Applications R12 (12.2.1 and 12.2.2), PO, AP, AR, GL, INV, OM and PL/SQLReports XML publisher.

Responsibilities:

• Prepared R12 GAP analysis doc for the RICE objects in the R12 upgradation projects.
• Discussion with the Client to understand there technical needs.
• Creating the PPM#request to migrating the RICE components from Dev instance to QA and QA to Prod environment.
• Checking the BMC Remedy(Incident Management) tool and manage to assign the support cases to the team members
• Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues.
• Validated the code as per the naming standards which is developed by the other team members.
• Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend.
• Developing New Conversions and Interfaces for upgradation of R12.
• Development of New Reports and Customization of Existing Reports and Peer code reviews.
• Developed in the Sales Order Lines WEB ADI.
• Creating Event Alert and Periodic Alert to send mails, submit programs and etc.
• Creation of Technical Specifications, Unit Test Plan Documents.
• Created various PL/SQL procedures/packages according to the Client requirements.
• Worked for enhancements and support cases/incidents for the RICE Objects.
• Preparing data fix scripts for data manipulation and delete the Orfhan records.
• Helping to the BI team to make them understand the apps data modeling and functionality.
• KT and training on BMC Remedy, PPM Migration tools and application to the new joiners.

Confidential

Oracle EBS Techno-Functional Consultant

Environment: s: Oracle Applications R12, PO, AP, AR, GL, INV, OM and PL/SQL, BI Publisher Reports.

Responsibilities:

• Review / Analysis / Creation of Technical Specifications, Unit Test Plan Documents.
• Discussion with the Client to understand there technical needs.
• Developing New Conversions & Interfaces.
• Developing Conversions and Interfaces for up gradation of R12.
• Development of New Reports and Customization of Existing Reports.
• Developing the BI Publisher (XML Reports) with Barcode and register corresponding FONT in Frontend.
• Creating Event Alert and Periodic Alert to send mails, submit programs and etc.
• Created various PL/SQL procedures/packages according to the Client requirements.
• Managing and delivering the Change Requests (CR) and Incident Records (IR) within the time of SLA.
• Create and manage SR's with the Oracle support organization as required in order to resolve Oracle functionality or data issues.
• Trained on BPEL process activities, Decision Service, Partner Links and Adapters (File Adapter, FTP Adapter, Database Adapter, AQ Adapter, JMS Adapter) for developing custom business processes to integrating with different systems using OSB
• Designed and developed an Payable Invoice Interfaces to the BPEL Process Manager utilizing the Oracle SOA.

Confidential

Oracle Apps Technical Consultant

Environment: s: Oracle Applications 11.5.10, R12, PO, AP, AR, GL, INV, OM and PL/SQL, XML Reports.

Responsibilities:

• Review / Analysis / Creation of Functional Specifications, Technical Specifications, Unit Test Plan Documents
• Discussion with the Client to understand there technical needs.
• Developing conversions for up gradation of R12.
• Developing, supporting and enhancing Inbound/Outbound interfaces, RDF reports, PL/SQL components of almost all modules implemented in the project.

Confidential

Oracle Apps Technical Consultant

Environment: s: Oracle Applications 11i, PO, AP, INV and PL/SQL, D2K Reports.

Responsibilities:

• Development of Technical Specifications.
• Interaction with Functional Specification owners on various functional issues during development.
• Developed Conversion, Interface, Report and Alerts.
• Design, Development and Testing of Database Packages and different Pl/SQL components.

Confidential

Oracle Developer

Environment: s: Oracle Applications 11i, PO, AP, GL and PL/SQL, D2K Reports.

Responsibilities:

• Developed Conversions and Interfaces to upload the various details into the apps base tables from legacy system.
• Developed outbound interface to extract the data from the Oracle tables into flat file.
• Writing Packages, Procedures and Functions for developing conversions and Interfaces.