EXPERIENCE SUMMARY:

• Around 10 plus years of experience in Oracle Application, with an overall 12+ years of experience in software development.
• Done successfully 3 full life cycle implementations of Oracle Applications release 11i and R12 with exposure to AIM methodologies and preparing documents like MD050, MD070, and CV040.
• Strong experience in Implementation, Customization of several Oracle Application modules, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations and Creating SR/TAR and getting Fixes from Oracle Support.
• Technically proficient in development of RICEW components and worked on various customization in OAF Pages
• Experience in Procure to Pay (P2P), Order to cash (O2C) life cycles and Supply Chain business flows.
• Good knowledge and exposure to various Financial & Manufacturing modules (AP, AR, GL, PO, OM, INV, BOM & WIP)
• Excellent knowledge of Oracle SQL, PL/SQL, Forms, Reports, Oracle Workflow, BI Publisher and Discoverer.
• Good knowledge in OBIEE reporting with good understanding of ETL process (Knowledge on Informatica).
• Strong in Performance Tuning and UNIX shell scripting.
• Having the good understanding of fusion technologies (SOA) and having knowledge about BEPL, ADF
• Good Analytical and Problem solving skills.
• Have good communication and interpersonal skills with on - site experience in interacting with client in requirements gathering.

SKILL:

Oracle Applications: Version 11i/R12

Modules: GL, AP, AR, CM, OM, INV, BOM, WIP, PO, FA, ALERT, AOL

RDBMS: Oracle8i/9i/10g/11g/12c

GUI Tools: SQL, PL/SQL, Forms & Reports, Discoverer, Oracle BI Publisher, Workflow Builder

Operating Systems: WINDOWS 2003, Linux, UNIX (Sun Solaris, HP UX, IBM/AIX)

Languages: C/C++, JAVA

Web Technologies: J2EE, HTML, XML, JSP, Applets/Servlets, JavaScript

Others Tools: SQL*Loader TOAD/SQL Developer, JDeveloper

Middleware: Knowledge on SOA, BEPL, ADF.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Enhancement Oracle Application R12

Oracle Apps Technical Consultant

Responsibilities:

• Involved on the all enhancements in finance and manufacturing modules.
• Worked on the custom process for the sales order creation, which allows the user to review the order before shipping as part of the Internal Audit Requirements.
• Working on customizing the BI reports, workflows, forms and reports.
• Involved in requirements gathering, code building, unit testing and co-ordination with user for UAT.

Confidential

Environment: Enhancement & Support R12

Oracle Apps Technical Consultant

Responsibilities:

• Involved on the all enhancements in finance modules (AP, AR & GL).
• Worked on customer cleansing project and has developed an interface to update profiles and customer related sites and customer accounts.
• Worked on Auto-lockbox, Auto-invoice and Payables import.
• Working with oracle in case of bug in the standard process.
• Involved in requirements gathering, code building, unit testing and co-ordination with user for UAT.
• Responsible for all deliverables like MD50, MD70, MD120 & TE20 Documents.

Confidential

Environment: Enhancement & Support R12

Oracle Application Technical Consultant

Responsibilities:

• Involved on the enhancements in Manufacturing and HRMS modules.
• Involved in developing Item Conversion program to import Items from custom applications.
• Custom BOM interface written using APIs to load BOM from custom application.
• Involved in WIP Interface.
• Worked on the enhancement request on OAF pages (CO and VO extension)
• Creating rules for AME based approvals for Absence management and customized according to the business requirement
• Employee related information upload, timesheet upload and Mass absences adjustments upload using WEBADI.

Confidential

Environment: Implementation & Support Oracle Application R12

Oracle Application Support Analyst

Responsibilities:

• Involved in production support and activities in the Financial area of GL, AP, AR, CM and PA modules.
• Involved in month close activities and held responsible for smooth close of AP, AR & PA modules.
• Also supporting employee related issues (HRMS) during interface and reports.
• For enhancements, done the requirement gathering from end-user.
• Involved in RCA for bugs in custom objects.
• Worked on the enhancement request on OAF pages (CO and VO extension)

Confidential

Environment: Support & Enhancement Oracle Application R12

Oracle Application Support Analyst

Responsibilities:

• Involved in 24X7 production support, activities in the area of AP & AR modules.
• Coordinated with functional/DEV team and DBA Team.
• Responsible for leading Process Improvements, Enhancements and Customizations
• Performing Root Cause Analysis on critical issues and finding out the solutions/workarounds.
• Discuss the business requests for any changes / enhancements with the functional owners/business users.
• Had coordinated with Oracle Support to fix issues.

Confidential

Environment: Re-Implementation Oracle Application R12

Oracle Application Developer

Responsibilities:

• Involved in gathering and documenting the business requirements
• Gap Analysis
• Translating business requirement into system
• Involved in Preparation of Functional design documents
• Functional setups & configuration for check printing for integration testing.
• Developed reports for check printing, invoice printing and PO printing/email/fax using BI Publisher.
• Involved in customization of OAF Pages in iSupplier Portal. (CO Extension in PO Acknowledge & PO Summary)
• Involved in development and customization of MSCA pages (Misc. Receipt, Misc. Issue, and Org Transfer).
• Also involved in the development of new custom page for Org Transfer and Sub-Inventory Transfer.
• Involved in Conversions and Interfaces objects - R12 modules like GL, FA, AP, INV and PO involved.
• Involved in Preparation of UAT test cases
• Co-ordination while at UAT and fixing issues related to objects.
• Involved in Project Management activities as mentioned below
• Monitoring and controlling the Project work
• Resource management and status reporting
• Planning and executing Knowledge Transfer to Application Support team

Confidential

Environment: OBIEE & Informatica

ETL Developer

Responsibilities:

• Used Informatica (Power Center) tool as ETL tool for constantly moving the data from sources into staging area
• Involved in ETL design for the new requirements
• Helped the team in analyzing the data to be able to identify the data quality issues
• Coordinating with user to gather the new requirements and working with existing issues.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, lookup, and Router
• Troubleshoot and tune SQL using EXPLAIN PLAN
• Development of the Informatica Mappings, lookups, reusable components, Sessions, Work Flows etc. (on ETL side) as per the design documents/communication
• Fixed the Issues that come out of Integration Testing
• Handling the repository and making reports using Oracle Answers.
• Responsible for preparation documents for code migration.

Confidential

Environment: Oracle Application R12 Upgrade

Technical Consultant

Responsibilities:

• Developed different kinds of Reports (charts, tabular) using global and local Filters.
• Created connection pools, physical tables and defined joins in the physical layer of the repository.
• Working on development of reports in Oracle R12 modules like AP, AR, GL, CM and FA.
• Responsible for preparation of code migration documents and objects migrations.

Confidential

Environment: Oracle Application 11i

Technical Consultant

Responsibilities:

• Part of the implementation team and also had a role of onsite coordinator and handled the team from onsite.
• Interaction with Functional person to understand the gaps better.
• Responsible for designs of technical documents on various rice elements which involves interface, conversion and reports
• Responsible for preparation of code migration documents and objects migrations.
• Developed the conversions on fixed asset and supplier from legacy system.
• Worked on the GL interface and Invoice Interface
• Developed an extension in PA and PO for the Account Generator.
• Worked on Auto-invoice to import the invoice information form legacy.
• Worked on customer import using TCA API.
• Customized reports on PO to print in PDF Format using XML Publisher.