Peoplesoft Hcm Techno Functional

Ramkumar Jaganathan

Email: ***********@*****.***

Mobile: +1-510-***-****

LinkedIn:www.linkedin.com/in/ramkumarjaganathan

Total Experience: 22+ Years

Profile Summary

Highly experienced in Oracle PeopleSoft Techno Functional, in conducting Design activities from Requirements, Fit Gap Analysis till Go Live Phase. Equipped with DB skills, experience in conducting database validation, extensively involved in Banking/Financial and Healthcare, Automobile domain projects. Skilled in maintaining PeopleSoft Core HR Data, Employee Benefit details and running PS Query Manager, SQL Reports, Benefit Snapshot Report, BI Publisher Reports, Adhoc Reports, Custom Reports, Change Requests, Customizations, Set up &Configuration, Conference Calls with Business and Maintenance activities.

Core Skills

Top Skills (Technical/Non technical skills)

ERP - PeopleSoft HCM, Finance, EPM Functional

ERP - Oracle HCM Cloud Functional

ERP – Workday HCM Functional Validation

Database Validation SQL(Oracle&DB2),PL/SQL, Hive

Web Services Validation using SOAPUI & Ready API tool

ETL Source to Target Validation using Ascential DataStage Director

Report Generation using PeopleSoft Query Manager, BI Report, SQL

Extensively used MicroFocus ALM Tool to Manage the Requirement mapped to Test Scenarios

Key Roles Performed

Senior Techno Functional Lead

Database Validation in SQL (Oracle & DB2)

Automation Testing using PeopleSoft Test Framework (PTF)

TOSCA Automation Knowledge

Domain Experience

Banking / Financial, Product based – 5 years

Healthcare – 3 years

Automobile – 5 years

Certifications (Professional Activities, Certifications, and Training Attended)

PeopleSoft Certification

Oracle Cloud Infrastructure Certified (OCI)

Scrum Alliance Certified Scrum Master (CSM)

PeopleSoft Test Framework (PTF)

DXC Automation Testing (QTP)

PROMPT Certification (PMP Preparatory Training and Certified)

Professional Work Experience

Capgemini – Black & Veatch – Kansas, USA Jul’24 – Till Date

# Oracle PeopleSoft Project

Title: Oracle PeopleSoft Consultant

Project Description:

Oracle PeopleSoft Project which involves functional setup and configurations under Oracle PeopleSoft HCM & Finance Modules includes Core HRMS, Workforce Administration, Base Benefits, Ben-Admin and North American Payroll, PeopleSoft Accounts and General Ledger Interface

Roles & Responsibilities:

•Took Responsibility in Gathering Requirement and Set Up and Configuration of PeopleSoft HCM Workforce & Benefits, Payroll Pages including Pay Group, Pay run ID, Pay Calc, Pay Calendar, Pay sheet Audit, PeopleSoft Finance pages PS Account Number, GL Interface and custom pages based on the client requirement.

•Handled activities like Creating Test Plan, Test Cases based on scenarios and validated the HCM Workforce Admin, Benefits, Tax Pages, Payroll pages and custom-built pages.

•Handled Payroll issues whichever is run for Biweekly and Monthly and validated to ensure accuracy

•Validated the Minor Enhancement Implemented in Staging, Production Instances for UAT and Business validation.

•Extensively worked on PS Queries and created several PS Queries in Query Manager to provide Query Report based on Client requirement and their needs on Adhoc basis. Handled Data Migration from Time Data to Oracle.

•Verified and validated all the Tax Pages for PeopleSoft Quarterly Tax Updates and ensured expected results.

•Created several MS Power point slides and worked on share point, Visio diagrams and showcased to Client.

•Communicated effectively in Teams and Outlook with Clients and functional and technical teams and built a good rapport and gained their confidence. Attended regular team meetings and projected my suggestions on time.

•Conducted cross functional meetings and Defect Triage meetings with Functional and Technical team to make them understand the Defect Severity, Defect turnaround time and Test Completion activities.

•Documented the changes implemented, Defect Summary Report, Requirement Traceability Matrix (RTM) and provided post production support.

• Generated Report with HCM Extract, Complex SQL Query, Stored Procedures, BI Reports and having good knowledge on Finance Module includes PS Account Number and General Ledger Interface.

Skills: PeopleSoft HCM 9.2, People Tools, SQR/SQL, PS-Query Manager, Business Intelligence(BI) Report, Excel Report, Power Point Presentation.

Societe Generale GroupAug’23–Jun’24

# Oracle PeopleSoft HCM, Finance Project, CA, USA

Title: Oracle PeopleSoft Techno Functional Consultant

Project Description:

Oracle PeopleSoft Project which involves functional setup and configurations under Oracle PeopleSoft HCM Modules includes Core HRMS, Workforce Administration, Base Benefits, Ben-Admin and North American Payroll

Roles & Responsibilities:

Gathering Requirement and Analyze Fit Gap, Document, share it to Development & Testing Team

Analyzed Business Rules Mapping, Setup and Configuration of PeopleSoft HRMS Pages, Earnings, Deduction etc

Set up and Configure Benefits, Payroll Pages and relevant Tables, along with Pay Calendar Set up, Pay Calculations

Running Payroll, Analyzing the Paycalc errors, Reviewing Pay run errors and rectifying the Pay Message Errors

Rerun the Payroll after troubleshooting and generating PayChecks and Advices

Understand the table structure and create SQL Queries and generate BI Report and share it

Worked in PUM Updates, Change Assistant & Impact Analyzer and providing PS Admin Support

Documenting the changes implemented and providing post production support

Generating Report with HCM Extract, BI Reports and Financial Reports and having good knowledge on ELM Module.

Skills: PeopleSoft HCM 9.2, People Tools, People Code,SQR/SQL,Data Mover,Application Engine,Component Interface,Application Messaging,Web-services, PS Query Manager, Business Intelligence(BI) Report.

Societe GeneraleNov’22– Jul’23

# CFTHR DATA Project, India

Title: PeopleSoft/Oracle HCM Cloud Functional Consultant

Project Description:

PeopleSoft HRDATA Projects involve SG Bank related PeopleSoft HR data flow from upstream and processed in Big Data platform and transformed to downstream applications during data migration which involves various Verifications and Data Conversion and Validation to generate Report and test Web Services.

Performed Functional setup and configurations under Oracle HCM Modules includes Core HRMS, Workforce Administration, Base Benefits, Ben-Admin and Data Analysis during PeopleSoft HCM to Oracle HCM Cloud Migration.

Roles & Responsibilities:

Understand Business Requirement and Analyze Data from the source system based on data structure

Analyzed Data based on mapping rules, Data Structure and extract Data from the Source System

Validated Retrieved Data and csv file from OIC using HCM Adaptor and OIC using SOAP Adaptor

Validated HCM API integrations using Postman, and Swagger

Bridge the gap between source and target system to validate the designed DFF field

Setup and Configure HCM Core HR, Benefits, Workforce Administration modules

Verify extraction program fetches the source data in target extraction format and data conversion validations

Validated and updated YAML scripts based on Swagger

Analyze Fast Formulas, HCM Extracts the HRIS data that are not loaded based on Load Error

Validate HDL and HSDL Data loader and generate OTBI Reporting

Generated split wise custom reports in HCM & ELM Module using BI Publisher bursting feature

Validate the Report from HCM modules in Cloud & On-Premises along with Benefit Snapshot Reports

Execute Query to generate ad-hoc reports & share it to Management in time for their analysis

Skills: PeopleSoft HCM 9.2, Oracle HCM Cloud 23C, JIRA, AWX, SOAP UI, Ready API, RTC Tool, Agile, People Tools, People Code,SQR/SQL,Data Mover, Application Engine, Component Interface, Application Messaging, Web-services

CSC & DXC Technology Apr’2012– Jun’2022

#Kaiser Permanente Client May’21– Jun’22

CASA,RADA, BCS/MBI,RFS2.0Projects

Title: PeopleSoft HCM Functional Consultant

Project Description:

CASA, RADA, BCS/MBI, MMM, RFS2.0 Projects involve Kaiser Healthcare related test data processed in PeopleSoft HCM Modules under Core HRMS, Benefits& NA Payroll modules were functionally validated and generated Report of Patients Healthcare Details.

Roles & Responsibilities:

•Analyzed Business Requirements, prepared Design Document based on Business Mapping

•Reviewed Test Scenarios based on the Requirement and overviewed Sprint Demo and System Testing

•Set up and configured and Core HR, Ben-Admin, T&L, and NA Payroll based on Requirements and CR’s

•Extensively worked Ben-Admin to automate the Dependent Enrollment process based on Employees Life Event.

•Reviewed BI Reports along with Defect Summary Report and involved in Defect triage calls to provide resolution

•Coordinated with Testing team to fine tune the Groovy Scripts and Managed KP specific Web services using SOAP UI and Ready API tool to improve the process and share the report as per Business need.

•Installed PTF tool and modified the test scripts for PeopleSoft custom pages& executed the scripts and validated.

Skills: PeopleSoft HCM9.2,Peoplesoft Test Framework (PTF),SOAP UI, Ready API, RTC Tool, Agile, People Tools, People Code,SQR/SQL,Data Mover, Application Engine, Component Interface, Application Messaging, Web-services

#Fiat Chrysler Automobile ClientFeb’15 – Apr’21

VCPS( Agile Project), PeopleSoft DB2 Upgrade, PS Modernization, PS Enterprise Performance Management (EPM) Project

Title: PeopleSoft EPM, HCM Consultant

Project Description:

PeopleSoft DB2 upgrade Project involves upgrade Database Upgrade from DB2 to Oracle.

PS HRMS Modernization Project includes Fluid pages for PeopleSoft HCM EPM (Enterprise Performance Management) Module and end to functional set up configuration and post implementation support

Roles & Responsibilities:

•Understand the Requirement n PeopleSoft HCM DB2 upgrade Project, based on the requirement reviewed Regression testing and ensured the existing functionalities are not affected post the upgrade

•Performed various role level and ensure third party time entry system integrated and Time & Labor system

•Created PS Query and generated BI Publisher Reports based various Business Requirements under ELM Module

•Implemented &Performed Quality Testing includes SOX Compliance& DAN(Disciplinary Action) under Labor Admin for Letter Code Customization and action taken for Absenteeism in HCM and triggered Letter to Employees

•Coordinate with Performance Tester and analyzed Results in Micro Focus Performance Centre.

•Validated PS EPM Module and Employee Performance Appraisal Submission and Approval Workflow.

Skills: PeopleSoft HCM Version 9, PeopleSoft Test Framework (PTF), HP ALM, HP PC, Agile, People Tools, People Code,SQR/SQL,Data Mover, Application Engine, Component Interface, Application Messaging, Web-services

#Pfizer Client/ UK&Ireland Neo Integration Workday Project, Zoetis TSA Divestiture Project Jan’14–Jan’15

Title: PeopleSoft Techno Functiona/ Workdayl Consultant

Project Description:

The project goal is to Divestiture & Support the Transitional Services Agreement (TSA) between Pfizer andZoetis.PfizerwillcontinuetomaintainZoetiscolleaguesandcontractors’datainPeopleSoftHCM as active colleagues and contractors through the automated process so as to support the HRIS data requirements of the downstream systems and applications through the full TSA period.

Roles & Responsibilities:

•In Zoetis TSA Project, Created Functional design document and validated the test cases and logged defects. Interacted with Onsite team and Client via mail, Chat & Conference calls till the Project Go Live.

•Validated Test Data prepared by testing team based on the requirement shared and sent Functional Questionnaires to business &Validated Interfaces across EMEA, APAC and CALA markets.

•In Neo Integration Workday Project, Performed validation, Workday Report generation and based on the new enhancement and third party integration to verify all the HR Transactions like Hire, Rehire, Location Change, Position Change and Promotional Transfer Scenarios are executed and met the expectation.

•Analyzed and provided the resolution by analyzing/troubleshoot People code in Menu, Component, Page, Row, Record and Field Events, and security issues with Roles and Permission accordingly.

Skills: PeopleSoft HCM 9.2, Workday,Report, HP ALM

#Aon Hewitt Client/ ServiceMasterProjectApr’12–Apr‘13

Title: PeopleSoft Techno Functional Consultant

Project Description:

Aon Hewitt Service Master Client decided to migrate from JD Edwards to PeopleSoft HCM 9.1. The application scope covers core modules of PeopleSoft that includes Core HR, Base Benefits, Ben-Admin, Pension Administration, North AmericanPayroll, LeaveAccruals(Interfaces,Extensions,Customizations,&Reports).

Roles& Responsibilities:

•Gathered the Requirement and performed a fit gap analysis with PeopleSoft HCM delivered functionality and JDE

•Documented the FDD and shared to both Development team and Testing team

•Analyzed client's existing business processes and ensured alignment with legacy PeopleSoft HCM functionalities

•Set up and configured the PeopleSoft HCM Benefit Module &NA Payroll set up configuration and run the Payroll.

•Configured Employees based on Benefit Eligibility, Event Rules, Pay Calc, Pay Calendar, Tax updates.

•Reviewed the Requirement Traceability Matrix by coordinating with Testing Teamto highlight Requirements Vs TS

•Coordinate with Development team in resolving the Payroll Errors for Salaried, Monthly and Hourly Employees

•Performedhigh level end-to-end functional validation and involved in the Defect Triage Call with Onsite coordinator & discussed with Testers & Developers and monitored the scheduled processes and Time & Labor.

•Ensured smooth implementation and support UAT Phase with Clients and provided Post Production Support.

Skills: PeopleSoft HCM/HRMS 9.1, HP ALM, UPK (User Productivity Kit), PeopleSoft Test Framework (PTF)People Tools, People Code,SQR/SQL,Data Mover,Application Engine,Component Interface,Application Messaging,Web-services

Countrywide & Bank of America Nov’2006–Apr’2012

Title: Analyst

Roles & Responsibilities

•In SMART Project worked on PeopleSoft HCM Core HR & Benefits Modules, NA Payroll Modules Analyzed ETL Jobs, Analyzed the source &target Database with required validations.

•Performed Analysis on changes based on the latest PeopleSoft releases and implemented in current environment

•Validated HRIS pages and Employee data and generated reports to Management

•PeopleSoft Tax Updates Validations are carried based on the releases and patch updates.

•Validated PeopleSoft Finance Accpunt Payable(AP), Accounts Receivable (AR), GL & PeopleSoft N-Vision Reports layouts in the Testing Environments & verifying for any garbage values, incorrect headers & labels, developing test cases for N-Vision Reports & executing the test cases manually.

•Updating in STAT (A tool for migrating PeopleSoft Objects in to different environment) with QA Result documents & Test Scripts.

•Monitored the Scheduled Jobs in Control-M and generated reports.

•Analyzed ETL Jobs & verified the Log outputs in Ascential DataStage Director.

•Skills: PeopleSoft HRMS 8.9, PeopleSoft Financials 8.4, Quality Centre, PS N-Vision Reports, AscentialDatastage Director

Hexaware Technologies & OracleJan’2004–Oct’2006

Title: PeopleSoft Developer

Roles & Responsibilities

•Understand the PeopleSoft HCM Functionalities and analyzedand developed/fixed the Incidents/Tickets under ICE (Incident Changes & Enhancement)in PeopleSoft HCM Modules specifically inBase Benefits, Benefits Administration and e-Benefits and North American Payroll modules in the entire environment. e.g., BOT (Build Operate and Transfer) environment, Oracle, DB2/OS390, MSS, & Sybase and notified Release Engineering Team once test completed.

•Skills: PeopleSoft HRMS 8.3,8.4,8.8,8.9, People Tools, People Code,SQR/SQL,Data Mover,Application Engine,Component Interface,Application Messaging,Web-services, PS Query,XML.

Work Rewards/Recognition

•Received appreciation from Black & Veatch client in resolving Payroll issues

•Received appreciation mail from Paris onsite Team @ Societe Generale

•Received several Accolades Rewards and Kudos, Spot Awards in CSC/DXC

•Received Global Recognition Awards in Bank of America

•Received Appreciation in Chandler Infrastructure Migration Project @ CFC International

•Received Applause and got a chance to travel to Onsite during my tenure with Oracle

•Acquired PeopleSoft Certification from Hexaware ISC (PeopleSoft India Services Centre)

Education

B.E., MBA., University of Madras, India

Contact this candidate