PROFESSIONAL SUMMARY:

• 11+ Years of experience in Oracle Application implementations, upgrades, maintenance and support. Performed end to end implementation, post production support, end user and documentation. Expertise in filling the gaps using custom components based on the client’s requirements.
• Experience in Oracle Apps 11i/R12 and Modules like Financials, SCM and HRMS.
• Expertise in designing process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
• Functional responsibilities include: requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing guides, end users, and production support and Good understanding of Multi Org Architecture with the General Setup of Ledgers and Chart of Accounts and Profile Options.
• Technical responsibilities include: interfacing the Modules, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, scheduling, producing, documentation and providing production support.
• Experience in Custom Modules (Modules like Revenue Sharing Program (RSP), Global Distributor Accounting (GD), Commission, and End Customer Backlog Orders (ECB).
• Knowledge on Oracle Fusion Cloud Financials and Modules like GL, AP, AR, CM, FA, Fusion Expense, PO, Fusion Tax and Functional Setup Manager(FSM), Oracle Identity Manager(OIM/IDM), Authorization Policy Manager(APM), Business Process Management (BPM).
• Knowledge on Data Conversions, Xml publisher, BI publisher reports, OTBI Reports, FRS and Smart view reports in Fusion.
• Extensive experience in designing and implementation RICE Components in Oracle (Reports, Interfaces, Conversions & Extensions) and Data Migration.
• Extensively worked on various business flows such as Order to Cash (O2C), Procure to Pay (P2P) cycle, FA to GL and Account Generator Workflow.
• Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper environment.
• Performed fundamental administrative tasks including registering applications and reports, defining new users, responsibilities, profiles, menus, and setup value sets in the application.
• Prepared technical design documents for customizations and conversions using AIM documentation methodology (MD050, MD070, CV040, CV060).
• Proficient in writing stored procedures, Packages, Functions and Database Triggers using SQL and PL/SQL.
• Experience in creating SQL*Loader control programs and PL/SQL validation scripts for validating and pre - import processing legacy data from feeder systems to Oracle Applications.
• Experience in developing and customizing OBIEE reports.

TECHNICAL SKILLS:

ERP: Oracle Applications 11i/R12, Fusion R11/R12

Modules: Financials, SCM, HRMS

Tools: Toad, SQL * Loader, SQL Developer, Putty, WinSCP

Database: Oracle 9i/10g/11g, SQL Server, AS400.

GUI: Forms, Reports, XML Publisher, Discoverer, Workflow, OAF, ADF, BI Apps, BI Publisher, OBIEE, OBIA, DAC, Informatic, ODI.

Languages: SQL, PL/SQL, J2SE, HTML, XHTML, Java Script

Operating: WINDOWS XP/Visa/2003, UNIX

Others: FND FILE, UTL FILE, Shell Script, SVN, CVS, Quintana, AppWorks., JIRA, Service Now,CEMLI, Lean/AIM Methodilogy.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Technical Consultant

Environment: Oracle Applications R12.2.5, Developer 11g, Oracle 11g, ODI, OAF

Responsibilities:

• Development of Conversions (Bank and Branches, Customers, Suppliers data load using ODI tool from Legacy (AS400, JDE, Red Pharie) to EBS.
• Review CV040, MD050’s and development of CV060 and MD070’ s and Unit Test documents.
• Development of new change requests for rollouts and country specific.
• Developing and Customizing the RDF, XML Data Templates, BI Publisher, OBIEE Reports.
• Code migration activities by using SVN and JIRA.
• Interacted with users closely to get the requirements for Conversions.
• Involved in Defect resolutions for RICE objects.
• Developed new custom forms and customized oracle standard forms
• Developed new workflows and customized existing workflows
• Developed and Customized OAF Pages as per the requirement

Confidential

Technical Consultant

Environment: Oracle applications R12, SQL Developer, Oracle 11g, Developer 11g: XML Data Template, Discoverer, OAF.

Responsibilities:

• Took the requirement and proposed the solution to the business users.
• Involved in to Customize the Custom Forms.
• Developed procedure and functions as per client Requirements.
• Code Checkout and Check ins from Production.
• Registration of Concurrent Programs.
• Involved in customizing and developing the Reports and Forms.
• Involved in Interfaces and Conversions.
• Creation of Value sets in various Modules of the application.
• Preparation of Technical Documentation.
• Writing of SQL /PLSQL scripts for validation.
• Involved in AOL objects.
• Submission of concurrent program using PLSQL scripts.
• Imported/Exported different PG files using standard oracle import/export utility for modifications.
• Worked on different BC4J Components for customizations. Extended AM (Application Module), VO (View Objects) and modified the CO (Controllers).
• Worked on integrating newly created PG files with the existing PG files with handling back button.
• Worked on validation of extended EO of Address region to include additional field’s values in the address region attributes.
• Worked on integrating the Contact region with the existing Customer Create page which has only Organization and Address Region.

Confidential

Technical Consultant

Environment: Oracle applications R12, SQL Developer, Oracle 11g, Developer 11g, OAF, OBIEE

Confidential

Technical Consultant

Environment: Oracle applications R12.1.3, SQL Developer, Oracle 10g, Developer 10g, OBIEE.

Confidential

Technical Consultant

Environment: Oracle applications R12, SQL Developer, Oracle 10g, Developer 10g.