SUMMARY:

• Total 6+ years of experience out of which 6+ years in Oracle PeopleSoft HCM and over 2 years of experience in Oracle Fusion HCM Cloud and over 2 year of experience in Informatica Cloud.
• Have experience working in Implementation, Solution Design and Delivery, Troubleshooting (Support) and Upgrade Project.
• Have worked in diverse areas of Oracle HCM Cloud Core HR, Security and Absence Module and Oracle PeopleSoft Core HR, Custom Payroll and Compensation Modules.
• Was involved in end to end implementation and supported environments which include Requirements definition, Solution design and Documentation.
• Development, Testing and coordinating UAT with the client, taking a sign - off and ensuring project deliverables are successfully implemented as per the timelines.
• Have excellent Communication, Analytical, Interpersonal and Presentation skills.

TECHNICAL SKILLS:

Platform: Oracle Fusion HCM Cloud, Informatica Cloud, Oracle PeopleSoft

Domain: Human Capital Management (HCM)

Project Management Tools: MS Office

Development Tools: Oracle Fusion HCM Cloud, Informatica Cloud, Application Designer, SQL Developer, TOAD, DB2

Reporting Tools: Oracle BI Publisher, SQR, PS Query, XML Publisher, Plateau Report Designer

Programming Languages: Fast Formula, PL/SQL, PeopleCode

Key Skills: Oracle Fusion HCM Cloud Release 10, 11, 12, 13,18, People Tools 8.49, People Tools 8.50, People Tools 8.51, People Tools 8.52

PROFESSIONAL EXPERIENCE:

Oracle Fusion HCM Cloud Consultant and Application Developer

Confidential, North Carolina

Environment: Release 18

Database: SQL Developer

Module(s): Core HR, Security, Absence

Tools: Used: HCM Data Extract, HCM Data Loader, HCM Spread Sheet Loader, Fast Formulas, OTBI, Informatica Cloud, Maestro

Responsibilities:

• As per Conversion activity, created Application Engine in PeopleSoft to create files in HDL format to load setup data in HCM Cloud for Absence, Payroll, Benefit, Time and Labor and Core HR.
• Designed and Supported Confidential to provide end to end solution for the Security Module in Oracle HCM Cloud. Wrote different SQL criteria in the Person Security Profile to handle the Security dynamically.
• Have worked on Area of Responsibilities in the Security Module to provide dynamic solution for the Security requirements.
• Migrated all the Security Profiles to the upper environment using HDL.
• Created HCM Data Extracts to fetch the Personal, Assignment, Location, and Department from Cloud system for the outer world.
• Created Data Models and Reports in OTBI and used them in HCM Data Extracts to produce outbound files.
• Have worked on HCM Data Loader tool to load the Non-Employee details in HCM Cloud System.
• Have worked on HCM Spread Sheet Loader tool to load several setup data and Non-Employee details in HCM Cloud System.
• Have worked on Web Services to load Non-Employee data in HCM Cloud System.
• Used PBL to Load User Defined Tables in Oracle HCM Cloud system.
• Have worked on different kind of Personalization tasks in Oracle HCM Cloud System.
• Prepared unit test cases after development, prepared SIT-test scripts during SIT-testing, Reviewed test results
• Documented all changes and enhancements.
• Fixing QC tickets.
• Designed and Implemented one of the most complex and critical Interface with end to end Integration solution for Non-Employee Management System in HCM Cloud using Informatica Cloud with BeeLine system.
• Worked on different Mapping, Mapping Configuration Task and Work Flow Tasks in Informatica Cloud to load external Data sources.
• Worked on different Mapping, Mapping Configuration Task and Work Flow Tasks in Informatica Cloud to create outbound files for 3 rd Party System

PeopleSoft HCM Consultant and Application Developer

Confidential, North Carolina

Environment: PeopleTools 8.52

Database: SQL Developer, TOAD

Module(s): HRMS: Employee Self Service (Customized), SOA(Customized), BeeLine Non-Employee Management System(Customized)

Tools: Application Designer, Plateau Report Designer

Responsibilities:

• Customizations of existing PeopleSoft pages through various PeopleCode Events in the Employee Self Service Module.
• Designed end to end solution for Non-Employee Management System.
• Wrote People Code programs for online validations and for functional processing.
• Extensively used Process scheduler for running the reports and used Process Monitor to monitor the status of reports
• Prepared unit test cases after development, prepared SIT-test scripts during SIT-testing, Reviewed test results
• Documented all changes and enhancements.
• Fixing QC tickets.
• Supporting Success Factor LMS Report using Plateau Report Designer.

Confidential

PeopleSoft Application Developer

Environment: PeopleTools 8.52

Database: Oracle 11g

Module(s): HRMS

Tools: Application Designer, SQL Developer

Tools: Toad, MS Office, Ultra Edit

Responsibilities:

• Prepared TDDs with all the relevant information, explained using various Flow Charts for processes, Data Flow Diagrams, developed PeopleSoft Screens through excel utility, Unit Test Scripts, Process Structure , Open and closed issues etc.,
• Worked on PeopleSoft pages, PeopleCode, Application Engines, SQRs, Component Interface.
• Worked on modification of various Application Engines to fulfil the client requirement.
• Created lots of run control pages .
• Worked on SQR modifications.

Confidential

System Engineer

Environment: PeopleTools 8.52

Database: Oracle 10g

Module(s): HRMS, Payroll, Compensation

Tools: Application Designer, SQL Developer

Responsibilities:

• Joined project during the Analysis & Design phase and completed till Go-Live .
• Prepared the Technical design documents for Lift and Shift of various application engines and SQRs.
• Prepared the technical design documents for programs that required re-design
• Worked on the Compensation module extensively. Prepared more than 10 TDDs, Build.
• Prepared TDDs with all the relevant information, explained using various Flow Charts for processes, Data Flow Diagrams, developed PeopleSoft Screens through excel utility, Unit Test Scripts, Process Structures , Open and closed issues etc.,
• Worked on PeopleSoft pages, PeopleCode, Application Engines, SQRs, Component Interface.
• Business was very much impressed with the design, UI and I also received couple of Appreciation Mails for the design.
• Worked on an app engine to load salary grades from EDSS to Custom tables and vice versa.
• Worked on Compensation Dashboard, one of the main pages in Compensation which would cover all the processes in various cycle statuses like Build, Approved, Loaded and Closed. This page had multiple push buttons which when clicked would trigger a custom process in Compensation.
• Worked on Loading Plan ID table with the Incentive Plan Eligibility Criteria using Application Engine Program.
• Created Components, Pages and Records, Fields, Process Definitions and registered Components in Portal, Menu and Permission Lists.
• According to the PeopleSoft 9.1 version we had to modify the Pay Run ID from 3 character to 8-10 character so that it become unique. So with the help of Application Engine Program I did the same thing.
• With the help of another Application Engine Program the newly created Pay Run Ids were loaded to Pay Calendar table.
• Created Run Controlled Pages for the Lift and Shift SQRs and did the necessary changes.
• Created One ExcelToCI to load Off cycle Payoff numbers.
• As part of Development Phase in EDSS Module - a. Worked on this module to get the Organizational Reporting Data.
• As part of Development Phase in E-Performance Module - a.Created One ExcelToCI so that user will be able to load Data, means it was, Automated Goal Loading Process.
• Worked with few items related to Security.
• Worked during SIT, UAT phases resolved more defects within short span of time, Used the tool ALM (Application Lifecycle Management)
• Also worked on Change requests.

Confidential

Associate System Engineer

Environment: PeopleTools 8.51

Database: Oracle 10g

Module(s): HRMS

Tools: Application Designer, SQL Developer

Responsibilities:

• Customizations of existing PeopleSoft pages through various PeopleCode Events
• Wrote People Code programs for online validations and for functional processing
• SQL tuning for the Search Record Views
• Modified existing Application Engine Programs and developed new Application Engine programs as per the client requirements
• Worked on the Report Changes through SQRs . Experience in retrofit of SQRs
• Extensively used Process scheduler for running the reports and used Process Monitor to monitor the status of reports
• Presented the work done to the Onsite team during Internal Walkthrough using Microsoft Word, Excel, PPT
• Prepared unit test cases after development, prepared SIT-test scripts during SIT-testing, Reviewed test results
• Created Checklist for Migration Request , added the object list to be migrated. Wrote DMS scripts
• Documented all changes and enhancements
• Assisted other team members.
• Prepared daily status report.