SUMMARY

• Having around Nine (9+) Years of Experience in Oracle Apps / EBS including Developing, Customizing, and Designing, Testing and Implementation of Core HRMS, Self Service Human Resource (SSHR), Compensation, Payroll, Absence Management, OTL, Advance Benefits and Financial modules like AP, AR, GL, SLA, IBY, EBTax, PA, FA, CM, PO, INV, OM, BOM and WIP
• Proficient Experience in Core HR, Compensation, Payroll, Account Payables, Account Receivables, General Ledger, Payment, Purchasing, iProcurement, iSupplier, Sourcing, iExpense, PA, AOL and System Administration.
• Worked on Oracle Application Security using MOAC for creating or updating User, Responsibility, Request Group, Profile, Custom Security Profile, Form Function, Menu etc.
• Trained by Oracle for Fusion HCM Cloud (Core HR and Talent Management).
• Having hands on experience in BI and OTBI Report, HCM extracts, HCM data loading using FBL and Spreadsheet Loader, Managing user using Identity Manager, Creation and assignment of different types of role like (Duty Role, Job Role, Data Role), HCM workflow and Approval Management.
• Proficient in functional knowledge of Core HR, Compensation, Benefits, Payroll and Financial business processes with Procure - to-Pay (P2P) and Order-to-Cash (O2C).
• Worked as a Technical and Techno functional role for HR modules like Core HR, Payroll, Compensation and Benefits and P2P cycle.
• Having good experience on Trading Community Architecture (TCA).
• Having good experience on Sub Ledger Accounting (SLA).
• Having experience of different type of projects like Implementation, Upgrade, Retrofit and Support for HCM and Financial modules.
• Having good experience in Interface, Conversion, Data Loader and Web Adi for HCM and Financial modules.
• Having experience in working with Fast Formula in Payroll.
• Having experience in Setting up AME User and creation and customization of Approval Management Engine (AME) rules.
• Having experience in creation and customization of Workflow.
• Having experience in OAF page personalization and VO, EO extension.
• Having experience in working with Oracle for Service Request (SR)/TAR.
• Having experience of JAVA and JDeveloper, OBIEE, ETL using Informatica.
• Having experience of Web Services and XML
• Expertise in SQL* Plus, PL/SQL, Forms, Reports, XML Publisher and Discoverer.
• Experienced in data Conversions and Migrations using Interface tables and APIs from Feeder and Legacy systems to Oracle Application 11i suite.
• Involved in development of RICEW components using SQL, PL/SQL, Forms, Reports, XML/BI Publisher, JDeveloper, Workflow Builder and Discoverer as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Applications.
• Expertise in System Administration and AOL.
• System Administration activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, and printers, providing support to apps users for any technical issues.
• Good experience in using Application Implementation Methodology (AIM) and Agile methodology.
• Good experience in working with documents like MD50, MD70, MD120, CV40, TE20 and BR100
• Involved in all phases of Software Development Life Cycle (SDLC).
• Having good experience in working with Unix Shell Scripting.
• Having good experience in SQL and PL/SQL, Advance PL/SQL, Performance Tuning using various types of Indexes, Explain plan, Trace utility & TK Prof and Partition Table.
• Expertise in supporting Mission Critical Production systems.
• Excellent interpersonal, communication skills and understanding of Business applications.
• Willing to take up challenging assignments and interested to work in different kinds of modules and emerging technologies.

TECHNICAL SKILLS

ERP: Oracle EBS R12 and 11i e-Business Suite Releases 11.5.9

Modules: Core HR, SSHR, Payroll, Compensation, Benefits,, Account Payables (AP), Account Receivables, General Ledger (GL), Sub Ledger Accounting (SLA), Cash Management(CM), Purchasing (PO), Project Accounting (PA), iProcurement, iSupplier, Sourcing, iExpense, Fixed Assets (FA), Order Management(OM), Inventory (INV).

Languages: SQL, PL SQL, Shell Scripting, Core Java

GUI Tools: Forms 6i, Reports 6i, Forms 10g, Reports 10g, XML/BI Publisher, Discoverer 11g, Workflow Builder, Oracle SQL Data Modeler

Other Tools: SQL * Plus, SQL*Loader, Data Loader, Toad, SQL Developer, JDeveloper

Database: Oracle 8i, 9i, 10g, 11g, 12c

Methods: Oracle AIM for Documentation and Test Scripts preparation, Agile Methodology

PROFESSIONAL EXPERIENCE

Oracle Apps Sr. Consultant

Confidential, Billerica, MA

Responsibilities:

• Involved in requirement gathering from end user for new development and customization
• Designed and development of conversion code for AP Invoice, AR Invoice, AR receipt, Customers, Cost Rates Changes, GL Daily Rates, Create Project, Project Tasks, HR Employee, Assignments, HR Jobs, Contacts, Address, Element Entries
• Worked on creation of Materialize View and External Tables
• Worked on the customization and development of new objects
• Worked on AME for the creation and modification of AME rules for SSHR
• Worked on customization of Paystubs
• Worked on XML publisher for creation and modification reports
• Worked on OAF personalization to personalize OAF pages.
• Involved in weekly team meeting to discuss all open issue in development
• Worked with offshore team to guide and track the development of assigned tasks.
• Involved in preparation of migration patch which includes scripts of all database objects FNDLOAD script for AOL
• Preparation and execution of test cases for the developed objects
• Preparation of technical design document and testing documentation.

Environment: Oracle Apps Release 12.2.4. (R12), AP, AR, GL, PA, Core HR, Payroll, SSHR, XML/BI Publisher, Oracle 11g, Oracle 12c, PL/SQL, Unix, Java, Putty, Toad, WinScp

Oracle Apps Sr. Consultant

Confidential

Responsibilities:

• Involved in understating of knowledge transfer of the existing tool and requirement gathering from Business and End User
• Worked on data masking of critical data
• Validating and updating all the invalid database objects
• Worked on performance tuning for the process which takes time.
• Customization and Developing of Outbound Interfaces to move financial data to Oracle Apps
• Developed and worked on the customization of Reports
• Worked on preparation of technical documentation
• Worked on preparation of test plan and testing result documentation.

Environment: Oracle Applications R12.2, Oracle11g, Oracle 12c, PL/SQL, AP, AR.

Oracle Apps Sr. Consultant

Confidential

Responsibilities:

• Involved in requirement of new development and existing objects.
• Performed active role in analyzing, designing, building, testing, data extraction and implementing several interfaces/customizations in an effort to implement core HR, Payroll and Financials.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.
• Worked on fast formula for PTO leave calculation
• Worked on the XML Publisher for different financial reports requirements.
• Worked on customization of existing reports using Oracle Reports
• Developed packaged for printing the dunning letters for the customer and send the required details to the external system for printing.
• Worked on custom form development for loading third party invoices.
• Worked on workflow customization for expense invoice approval
• Worked on customization of payroll reports
• Worked on custom form development to import third party invoices.
• Worked on OAF extension to extend VO and EO.
• Worked on P2P and O2C cycle.
• Worked on Bank Statement and Reconciliation Open Interface for CM
• Worked on OBIEE Administration tool, BI Answers, Presentation Service for developing OBIEE reports
• Worked on creation of user, responsibility, request group, form function, menu as a part of oracle application security
• Worked with oracle on SR/TAR for bug fixing
• Worked with offshore team to guide and track the development of assigned tasks.
• UAT support related to migrated Data sanity checks.
• Implementation/Go-Live support & Knowledge Transfer.

Environment: Oracle Applications 11i and R12.2, Core HR, Payroll, Absence Management, Advance Benefits, PO, AP, AR, GL, IBY, CM, PA, FA, iProcurement, OM, XML/BI Publisher, Form 10g, Reports 10g, Workflow Builder, ORACLE 10g, PL/SQL, Java, CSV,Toad, Oracle SQL Data Modeler.

Oracle Apps Techno functional Consultant

Confidential

Responsibilities:

• Requirements gathering from business user for the enhancements in the application.
• Worked on Total Compensation Statement (TCS) set up and customization of compensation statement using XML Publisher.
• Worked on form configurator to create custom form for different business group based on the country specific requirements.
• Worked on Discoverer report to customize and development for new reports.
• Worked on AME rule customization
• Worked on Workflow customization for leave approval
• Worked on form personalization.
• Worked on creation of user, responsibility, custom security profile as a part oracle application security
• Coordination with users during UAT and getting signoff from them.

Environment: Oracle Applications R12, Core HR, SSHR, Payroll, Advance Benefits, i-Recruitment, Performance Management, ORACLE 9i, PL/SQL, Reports 6i, XML/BI Publisher, SQL Developer, SVN, WinScp, Putty

Oracle Apps Techno functional Consultant

Confidential

Responsibilities:

• Worked with the end user to get the requirement for the customization and new development
• Worked on the Interfaces for Customers and Auto invoice to import the invoices to AR Module.
• Involved in analyzing custom objects of existing system for database objects changes like tables, views, packages, functions and procedures.
• Involved in identifying new related objects and attribute to replace old object or attribute
• Involved in migration and compilation of all custom objects (Forms, Reports, Discoverer, XML and DB Objects) into new R12 instance
• Updated existing reports developed in Discoverer and Report Builder.
• Involved in migration of all AOL objects into new R12 instance.
• Migrated components from UAT to PROD using FNDLOAD utility
• Involved in customizing in various reports and interfaces analyze and work for the resolution of technical issues related to Financial and HR and Payroll modules.
• Worked on Bank Statement and Reconciliation Open Interface for CM
• Worked on Discoverer Administrator and Desktop to customize and development of reports.
• Identifying, prioritizing of root cause of problems and resolve break and bug fixes.
• Worked with Various Functional issues and Raising SR’s whenever it requires for Oracle Standard Functionality support from Oracle.
• Worked on User Define Table (UDT), User Function, Fast Formula for different types of leave calculation
• Involved in Oracle period closing process.
• Worked on custom form development and form customization
• Worked on Sub Ledger Accounting (SLA)
• Worked on O2C Cycle
• Worked on creation of custom security profile
• Worked on creation of secured report for specific responsibility.
• Worked with oracle on SR/TAR
• Worked on creation and customization of AME Rule
• Participated in meetings with Manager at Client Side about progress of ongoing developments and Distribute and monitoring work to consultants at offshore.
• Guided user to test new objects and given training to users for new development

Environment: Oracle Applications R12, Core HR, SSHR, Payroll, Absence Management, OTL, PO, AP, AR, GL, EBTax, CM, FA, OM, Manufacturing, ORACLE 9i, PL/SQL, Forms 6i, Reports 6i, Discoverer 10g, WinScp, Unix, Putty

Oracle Apps Technical Consultant

Confidential

Responsibilities:

• Involved in requirement gathering, data migration activity
• Responsible for AP, AR conversion activity
• Responsible for Core HR and Learning Management conversion activity
• Involved in financials report development
• Involved in direct client communication
• Involved in preparation of solution design documents and test documents
• Involved in requirement gathering for changes in any existing objects.
• Involved in analysis and development of the object
• Coordination with users during testing and getting signoff from them.

Environment: Oracle Applications R12, PO, AP, AR, GL, FA, Core HR, Learning Management, Oracle 10, PL/SQL, Toad, SQL Developer, Oracle XML/BI Publisher, Oracle Discoverer

Oracle Apps Techno Functional Consultant

Confidential

Responsibilities:

• Involved in creation of API for Jobs and grade and Valid grades
• Involved in creation of API for Salary elements and Link and Salary basis
• Involved in modification of existing discoverer reports as per the requirement
• Involved in personalization of forms pages as per the requirement
• Creation of the MD50, MD70 and TE20 documents
• Involved in user training
• Execution and support for CRP and UAT

Environment: Oracle Applications R12.1.1, Core HR, Compensation, Benefits, Toad, Oracle Discoverer, Oracle 10g, PL/SQL