PROFESSIONAL SUMMARY:

• Experienced professional with 9 years of experience in HR and Implementation of Oracle EBS HRMS and Cloud Fusion HCM Applications.
• Expertise in Fusion HCM Offerings - Workforce Deployment (Global HR, Payroll, Absence Management).
• Expert in defining and documenting Oracle and Non Oracle standard solutions.
• Worked on Requirements gathering, Configuration, Development, Trouble shooting and production support environment.
• Experience in customizing Cloud security components like Data Role, Job Role, Duty Role, Security Profiles, Abstract Roles and well versed with aggregate privileges and assigning duty roles.
• Experience in Data loading into Oracle Cloud HCM using FBL, HCM Data Loader and Payroll Batch Loader.
• Have worked on Implementation, Production Support, Ongoing support (trouble shooting) and enhancement activities on Oracle E-Business Suite Applications (R12.1.1, R12.1.3, R12.2.4), Oracle Cloud Release 19A (11.13.19.01.0 )
• Experience in all phases of implementation of Oracle Fusion HCM using offerings like Workforce Deployment ( Global HR, Payroll, Absence Management ), Workforce Development and Compensation Management.
• Interacted with the clients to collect the requirements and later drafted the documentation accordingly and did gap analysis.
• Experience in creating the payroll definitions and proficiency in payroll process.
• Experience in developing HCM Extracts/BI Reports for Global HR, Payroll .
• Solid Hands on experience in designing, developing RICE-W components (Reports, Interfaces, Conversions, Extensions, Workflow), Web-ADI, Discoverer and BI Publisher in Oracle R12 platforms.
• Strong expertise in XML Publisher Reports (BI Publisher) with Advance features - building custom D2k reports from scratch, reports conversion from Oracle D2k Reports to XML with advanced features like Bursting, XSL reports, PLSQL based XML generations etc.
• Proficiency in design, development and customizations of Oracle Forms, Custom.pll and Forms Personalization.
• Expertise in building Reports in Discoverer Administrator and Desktop Edition, including Business Areas and Work Books.
• Handling issues related to Oracle Expense reports providing solution to the users.
• Experience in Oracle Application Framework (OAF) extensions, Personalization in OAF pages.
• Hands on experience in Data Migration using tools SQL* Loader, UTL FILE.
• Supporting Month End closing process like Exception Reports for Oracle Finance.

TECHNICAL SKILLS:

Oracle E: business suite R12, Oracle Fusion Cloud HCM

Modules: OM, INV, PO, AP, AR, GL, HR, I-Expense, WIP, BOM, Global HCM modules

Languages: SQL, PL/SQL

Database: Oracle 12c,11g,10g/9i/8i/7.x

Software Tools: Toad, SQL Developer, Oracle workflow builder, Oracle Forms 10g/6i, Oracle D2K,Oracle Reports, Putty, Discover reports, XML Publisher, JDeveloper

PROFESSIONAL EXPERIENCE:

Confidential, Dover, NH

Oracle Fusion HCM Consultant

Environment: Oracle Cloud Release 19A (11.13.19.01.0 )

Responsibilities:

• Worked on Fusion Security model, Created Custom Job Roles and Data roles.
• Build Custom security to HCM Cloud which includes Create/ Modify roles and its Security Profiles, Job Roles, Application Roles and Duty Roles
• Creating Implementation Users, Service Accounts and assigning to roles to them.
• Worked on personalization’s for Global HR, Compensation, and Payroll.
• Worked on roles for security, involved in creating Flexfields.
• Used Functional Setup Manager to perform various tasks.
• Ensuring that the application meets the business requirements and system goals fulfill end user requirements, and identify and resolve system issues.
• Documenting the EBS Concurrent programs and uploading the document in Sharepoint directory.
• Developed HCM Extract for NSAA Buysmart Extract Report.
• Data Loading/Conversions using HCM Data Loader and Spread Sheet Loader.
• Extensively used security console to Oracle HCM which includes Create/ Modify data roles and its security profiles and role mappings for Auto provisioning.

Confidential, New York, NY

Oracle Fusion HCM Consultant

Environment: Oracle Cloud Release 19A (11.13.19.01.0 )

Responsibilities:

• Experience in developing HCM Extracts/BI Reports for Global HR, Payroll Interface.
• Developed OTBI Analysis for Global HR and Payroll.
• Developing project plan and deliver in line with Fusion Implementation Road map and Methodology.
• Loading the data from Legacy system using Payroll Batch Loader, HCM Data Loader.
• Expert understanding and configuring legal entities, TRU, PSU, Legal employers LDG, Business unit set assignments, job configurations, employment models and distinguish tree setups.
• Worked on Absence Integrations with Payroll and Workforce scheduling.
• Developed Functional and Technical Design document for HR, Payroll.

Confidential, Phoenix, AZ

Oracle EBS Technical Consultant

Environment: Oracle Applications Release12.2.4 (GL, AP, AR PO, INV, HR, OM), Oracle 11g, SQL, PL/SQL, SQL * Loader, TOAD, Forms Builder, Report Builder, Workflow builder, JDeveloper, D2k Reports/Forms.

Responsibilities:

• Working in the production support team designing and developing RICE components for enhancements (Change Requests and Service Requests) in supply chain and financial modules.
• Working closely with the functional team to know the requirements and work according to MD 50 Document and prepare Technical Design Documents.
• Hands on experience in creating XML/BI Publisher reports,D2k Reports, Discoverer, RDF reports as per the client requirements on AP, AR, OM, GL, PO, INV, Core HR modules.
• Hands on experience in customizing the Oracle Seeded Reports and migrating them in production environment.
• Hands on experience in Form Personalization’s and using Custom.pll.

Confidential

Oracle EBS Developer

Environment: R12.1.3 (GL, AP, AR PO, INV, HR), Oracle 11g, SQL, PL/SQL, SQL * Loader, TOAD, UNIX Shell Scripting, Forms Builder, Report Builder, JDeveloper.

Responsibilities:

• Developing BI Publisher reports, Discoverer and D2k reports as per the client requirements on Core HR, SCM and Finance modules.
• Design and development of custom POA Inbound Process to process the external sub ledgers accounting data in form of Pass-through/Event to Oracle GL using FAH and SLA Create Accounting Process.
• Experience in working on Oracle Alerts (Periodic and Event Based) and Email with Attachments using Alerts like (Cameon Alerts, Anniversary Alerts, Resignation Alerts, Birthday Alerts, Maternity Leave Alert, Consulting Employees Alerts, Employee Day1 Alert and Sabbatical Leave Alert).
• Experience in working on Email bursting for Payment Batch.
• Hands on experience in working on Oracle Discoverer reports.
• Hands on experience in working on XSL based XML reports.
• Experience in working on Web-Adi like (Employee Details)
• Experience in working on Forms Personalization.
• Experience in working on Interfaces and building Pl/ Sql Procedures for loading the data into EIT’s.
• Working closely with Functional team for closing the exceptions in Month End Closing and raising Oracle SR’s.
• Supporting end users regarding the issues related to Invoices, Payments and Expense report issues.
• Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open Order Report, Purchase Order Report.
• Hands on experience in adding Attachments, adding Notification region to Home Page in OAF page using OAF Personalization.
• Handling I-Expense related issues.

Confidential

Oracle EBS Developer

Environment: R12.1.3 (GL, AP, AR PO, INV, HR), Oracle 11g, SQL, PL/SQL, SQL * Loader, TOAD, UNIX Shell Scripting, Forms Builder, Report Builder, JDeveloper.

Responsibilities:

• Developed BI Publisher reports and D2k Reports as per the client requirements.
• Involved in developing the Service Request Page in OAF and OAF personalization’s.
• Involved in the Item Migration Process, Purchase Order Migrations, and AR Invoice Migrations.
• Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
• Developed Order Import Interface for business applications to load header and line details by creating Staging Tables and performing validations by writing PL-SQL package into the Order Import (OE) headers and line interface tables and then to OE base tables.
• Imported Items from legacy system into Oracle Inventory using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Worked on Form Personalization’s.
• Worked on Payroll and Core HR Reports.
• Developed Multi Layouts and Multiple layouts, Dynamic Images in BI Publisher.

Confidential

Oracle EBS Developer

Environment: R12.1.3 (GL, AP, AR PO, INV, HR), Oracle 11g, SQL, PL/SQL, SQL * Loader, TOAD, UNIX Shell Scripting, Forms Builder, Report Builder, JDeveloper.

Responsibilities:

• Resolving issues in Custom Reports and Development of D2k Reports as per the Client Requirements
• Preparation of Technical Documents like MD70 using AIM.
• Registration of reports in oracle applications.
• Customization of oracle standard reports as the client requirements.
• Worked on the Integration with Oracles EBS and pretups application.
• Developed XML bursting program for Employee Pay slip.
• Developed Multi Layouts and Multiple layouts, Dynamic Images in BI Publisher.
• Extensive usage of Data template reports in BI Publisher.
• Worked on Web-ADI for uploading of Employee Dependent Details.
• Worked on Forms Personalization like Restricting the User for entering the quantity as per the FLM and changing the Optional Fields as Mandatory Fields.
• Defining AOL objects like Executables, Concurrent programs and request group.
• Developing XML Reports as per client requirements.
• Deploying the Forms and Reports in Production Instance.
• Attending the weekly status calls and weekly reporting with Team Leader.
• Involved in the development of Stored Procedures and PL/SQL Packages.

Confidential

Oracle EBS Developer

Environment: R12.1.1 (GL, AP, AR PO, INV, HR), Oracle 11g, SQL, PL/SQL, SQL * Loader, TOAD, UNIX Shell Scripting, Forms Builder, Report Builder.

Responsibilities:

• Hands on experience in developing Procedures, Triggers, Functions and Packages.
• Perform Unit Testing.
• Involved in the table design.
• Hands on experience in customizing the Oracle Seeded D2k Reports using Report Builder.
• Experience in Web-adi for loading the data into system.
• Hands on experience in personalizing the oracle forms.
• Understanding the requirement and carrying out impact analysis.
• Implementation of the application on Production Server.
• Prepared root cause analysis for the problems occurred.
• Involved in resolving the production issues for the applications and ensure all support service tickets are closed.