SUMMARY:

• Over all 8 years of and having 6 years of IT experience and 2 years of experience in Oracle Fusion HCM (Core HR, payroll, Talent Management).
• Having the strong experience in Oracle HRMS/Order to Cash/Procure to Pay (HRMS/PO/AP/AR/GL/CM/OM/Inv) .
• Extensive experience in RICEW components, TAR support, UNIX, Oracle SQL/PLSQL, Workflow, Forms and Reports 6i and SQL Loader, Project assignments include Implementation, upgrade, conversion and support of Oracle Apps systems.
• Extensive experience in creating Discoverer Reports/ XML Publisher(BI Publisher) reports and OBIEE/OBIA using various templates to publish the reports as per user requirements
• Good experience in requirements gathering, Design, Development of custom applications in Oracle application framework (OAF).
• Extensive experience in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development. and Alert Manager and invoking them from the different applications.
• Having the good experience in all the Conversion/Interfacing activities using the API’s and open interfaces in R12 with the core subject of Trading Community Architecture (TCA).
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs) and developing the EDI & WebADI’s to import the data from flat files.
• 5 years of experience in Oracle Application Technical Consultant in implementation, upgrade and customization of Oracle e - Business Suite Applications (Release 12.1.3, 11.5.10.2).
• Proficient in development of interfaces to integrate Oracle Applications modules to import data from various sources into Oracle Applications using SQL*LOADER.
• Expertise on Application Object Library (AOL) and System Administration Responsibilities such as registration of concurrent programs, Request groups, Request sets, Value sets and Flex fields in Oracle Applications.
• Having Good Experience on Preparation of DS140 (Technical Design Specification), TE020 (Unit Test Scenarios), and IM090 (Installation Instructions), CM050 Documents by using the OUM Methodology.
• Experience with Oracle and Other Utilities - TOAD, SQL*Plus, SQL *Loader Packages.
• Proficient in writing SQL Queries, stored procedures, functions, packages, using PL/SQL, SQL.
• Extensive experience in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, parameters and standard request submissions in the process of development. and Alert Manager and invoking them from the different applications.
• Having the good experience in all the Conversion/Interfacing activities using the API’s and open interfaces in R12 with the core subject of Trading Community Architecture (TCA).
• Expertise in inbound and outbound interfaces and creation of automated process using Application Program Interfaces (APIs) and developing the EDI & WebADI’s to import the data from flat files.
• Good Experience in Develop the EIT, DFF and KFF.
• Good Knowledge on Configure Core HR, Payroll, Talent Management, Compensation management
• Skilled on Fusion HCM utilities like FBL Loader, HCM Data Loader (HDL), Spreadsheet Loader,
• Payroll Batch Loader, BI reports and HCM Extract Tool. Good Experience in OIM (creates Users, assign roles to users).
• Having strong experience in HCM Data Loader File Generation/file preparation and Fusion Security, Good knowledge on identify the mandatory columns for HCM data loader Objects, Good Experience in HCM Data Loader Automation/FBL Automation.
• Extensive experience in implementation, Migration, Customization, and support of various in Oracle Applications with major focus in Core HRMS, Talent Management, OTL, SSHR.

TECHNICAL SKILLS:

Oracle Applications: Core HR, Payroll,OTL,SSHR.

RDBMS: SQL, PL/SQL

ERP: Oracle Apps 11i / R12, Oracle Fusion Application(HCM)

Development Tools: Oracle Reports 10g, Oracle BI Publisher

Database and Tools: Oracle 10g and 11g, SQL Loader, SQL Developer, Toad, Putty and Winscp,SVN

PROFESSIONAL EXPERIENCE:

Oracle Fusion Developer

Confidential, Santa Clara, CA

Technologies: Oracle Fusion Application (Core HR, Payroll)

Module: Oracle Fin/HR/Payroll

Responsibilities:

• Gathering and analysis of client requirements.
• Worked on Spread Sheet Loader, FBL Loader & HDL Loader.
• Worked on HCM Data Loader File Generation process via PL/SQL.
• Worked on Person Extra information, Assignment EIT Information.
• Worked on configure Value sets, KFF and DFF.
• Worked on Functional Configurations for Core HR, Payroll.
• Worked on terminate employee via Web services.
• Worked on Schedule jobs for Interfaces/ BI Reports.
• Hire Employees (Worker, Non Worker, Pending Worker), terminate employee.
• Delete Duplicate records for Person EIT, Secondary Org.
• Disable DFF column (Payment type) and remove legal employer spaces in fusion.
• Decrease size for Person EIT Information(bank account, Visa, Additional GRE, Service Dates etc)
• Worked on OIM(oracle identity manager)
• Working Worked on BI Reports.
• Worked on support Issues.

Oracle Fusion Developer

Confidential, Brea, CA

Technologies: Oracle Fusion Application (Core HR, Payroll)

Responsibilities:

• Gathering and analysis of client requirements.
• Worked on FBL Automation.
• Worked on Custom Data Security for Profiles.
• Design and Develop the Transformation code for Core HR objects like (Supervisor Hierarchy).
• Validate the EBS data and migrating into Oracle Fusion Applications Release 8.
• Generating the Core HR related objects data files using the UNIX scripts and generating the Data files.
• Preparing the table scripts for holding the valid the after completion of transformations.
• Preparing the Synonyms, Sequences and Indexes.
• After generating the data file in server location, loading them in Fusion UI through FBL Data loader.
• Monitoring the errors at the time of data files loading into Fusion Applications.
• Developed the BI reports to analysing the errors and in convenient manner(xl outputs/pdf outputs)

Oracle Fusion Developer

Confidential

Technologies: Oracle Fusion Application (Core HR, Payroll)

Responsibilities:

• Gathering and analysis of client requirements.
• Worked on FBL Automation.
• Worked on Custom Data Security for Profiles.
• Design and Develop the Transformation code for Core HR objects like (Supervisor Hierarchy).
• Validate the EBS data and migrating into Oracle Fusion Applications Release 8.
• Generating the Core HR related objects data files using the UNIX scripts and generating the Data files.
• Preparing the table scripts for holding the valid the after completion of transformations.
• Preparing the Synonyms, Sequences and Indexes.
• After generating the data file in server location, loading them in Fusion UI through FBL Data loader.
• Monitoring the errors at the time of data files loading into Fusion Applications.
• Developed the BI reports to analyzing the errors and in convenient manner(xl outputs/pdf outputs)

Confidential, Beloite, WI

Sr. Oracle Apps Techno functional Consultant

Responsibilities:

• Providing the Oracle application support for PO, AR, AP, and Custom Interfaces
• Playing an active role in resolving the major issues at the time of period/quarter and year closing
• Working on the issues to find out the root cause and providing the resolutions/workarounds based on the ticket priority.
• Monitoring the tickets and assigning them to concerned persons in the team
• Attending the calls and review/status meetings to update the status on open issues.
• Interacting with the users to resolve the issues.
• Managing the team members and guiding them when stuck and motivating them

Confidential, SA

Oracle Apps Techno functional Consultant

Responsibilities:

• Major contribution is in development of reports and workflows.
• Developed Automation of Pick Release and Ship confirm process
• Developed the customer import API’s to successfully import the customer’s from customer master file.
• Involved in importing the Install base item instance import.
• Completed the provided tasks in very less time and appreciated by the client.
• Requirements gathering, Functional gap analysis, Solution Designing
• Preparation of BRD’s, MD 50’s, BR 100’s & User Manuals as guidelines for Support & Business teams by providing overall process adherence
• Working on designing, programming, unit/integration testing of components as per the business requirement.