Nirav Nandu
Mobile: +919********* / Email: *****.*****@*****.***
Team Lead-PeopleSoft Techno-functional Consultant
EXPERIENCE SUMMARY:
●5 + years of experience as PeopleSoft Techno-functional Consultant (Team Lead).
●7 + Years of Total experience
●Have worked on PeopleSoft HCM with key module viz. Core HR, ePerformance (Performance Management System), Position Management, Benefits, Workforce Administration, Workforce Development, Employee Self Service & Manager Self Service, Events & Notification Framework and Security Admin with good technical and functional knowledge in PeopleSoft 8.9, 9.0 and 9.1. Some Technical aspects of Global Payroll for Reports & upload processes.
●Proficient in PeopleTools - Application Designer, PeopleCode, Application Engine, Application Package, AWE, Component Interface (CI), SQR, File Layout, PSQuery, XML Publisher, File Layouts, Legacy Workflows. Also worked on Integration Broker on Consuming Web Services and Exposing CI based Web Services.
●Actively involved in Production Support.
●Proficient in writing complex database reports and customizations.
●Involved in Fit/Gap analysis, Retrofitting, Unit Testing and Systems Integration Testing during Upgrade of PeopleSoft Version 8.9 to 9.1 and identified the customizations that needed to be carried forward.
●Worked on mapping functional requirements to technical requirements.
●Involved in documentation of technical specifications, developing test cases and technical design.
●Developed 3rd party integration interface projects Like ADP (Automatic Data Processing), Kronos, Evolv, iRoz etc.
WORK EXPERIENCE:
●Currently working at Cyber Managers Software Services Pvt. Ltd. (CMSS) as Team Lead (PeopleSoft Techno-functional Consultant) - (Dec 2007-till date )~7+ years
EDUCATIONAL QUALIFICATIONS:
B. E. (Computers);
TECHNICAL SKILLS:
ERP package : PeopleSoft HRMS 9.1 / 9.0 / 8.9
People Tools : Tools v 8.51 / 8.50 / 8.49 /8.46
Development Tools : Application Designer, PeopleCode, Application Engine
Component Interface, Approval Workflow
Reporting Tools : PSQuery, SQR, XML Publisher, Process Scheduler
Administrative Tools : Data Mover
RDBMS : Oracle 10i/11g, MS SQL Server 2008/2012, Toad
Languages : SQL, PL/SQL
Other Languages known : C#, VBScript, JavaScript
Web Designing : HTML, ASP/AJAX and ASP.NET
Operating Systems : Windows 7 Enterprise/XP Professional/2003 Server Edition
PERSONAL DETAILS:
Address : B/35 Amizara, Mamletdarwadi Main Road,
Opp. Gariba Hospital, Malad (W), Mumbai-400064,
Maharashtra, India.
Mobile : +919*********
Email : *****.*****@*****.***
Marital Status : Married
Project Experience Summary
Project:1
Sutherland Global Services
Team Size
2
Client
Sutherland Global Services Pvt. Ltd.
Platform
Back-End
PeopleSoft HCM 9.1, PeopleTools 8.51, MS SQL Server 2008
Summary
Sutherland requires a team to support the PeopleSoft 8.51 project and Bolton module (WFM). They also required the team to create new/rewrite old interface process (both internal and 3rd party).
Responsibilities
Extensively used PeopleTools to customize Pages, records and components as per business requirements.
Created interface processes to integrate PeopleSoft with the 3rd party Absence/Timesheet modules (like iRoz and Kronos), ADP, Evolv etc.
Created interface processes to which is a complete rewrite for the Benefits Rate Reporting Table and iRoz NT
Created custom workflows using AWE
Application Development:
Handled hands-on, major changes to keys, indexes and also table edits used as validations performed on critical record fields.
Modified entities like Fields, Records, Page, Components, Menus, etc. using Application Designer.
Applied preventive, detective & corrective controls using PeopleCode.
Brought to use Application Engine for various enhancements.
End-user requirements elicitation and analysis.
Development of reports using SQRs and App Engine Program
Development of run control records, pages and components and attaching the SQR to the Portal.
Actively involved in Production Support for processes like Recruitment Interface, Bolton Module WFM, ADP, Benefits etc.
Used 3rd party resources like GNUPG and WINSCP in App Engine Programs for Encryption and SFTP/FTP the files on client servers.
Project:1.A
SGS LDAP NT Integration
Summary
Sutherland wanted to do away with iRoz and use PeopleSoft to maintain Windows NT account for Employee, CWRs and POIs of SGS.
Responsibilities
Requirement gathering, Approach understanding & Unit Testing
Development of Setup Pages, Monitoring Pages, Application Packages, AE process
Getting the Audit Tables created and altered for some Tables with triggers required for the process
Combining WFM-WFA data into a single tables and integrating them as a part of the interface.
Project:1.B
ADP Integration
Summary
Sutherland acquires Apollo Health Street in December 2012, and begin hiring into PeopleSoft HCM as Sutherland Health Services (SHS). They were using ADP as their Enterprise portal.
Responsibilities
Requirement gathering, Approach understanding & Unit Testing
Development of new AE process
Getting the Audit Tables created and altered for some Tables with triggers required for the process
Combining WFM-WFA data into a single tables and integrating them as a part of the interface.
Encrypting and SFTP of file from PeopleSoft server to SHS server
Project:1.C
Benefits Reporting Table Refresh
Summary
In PeopleSoft 9.1, Sutherland will be storing benefit rates (employee rates and employer costs) in the delivered Base Benefits rate tables. There is a need to have a streamlined process available so that these rates can be made available for use in CTC calculations as well as payroll interfaces.
Responsibilities
Requirement gathering
Approach understanding. Also understanding the earlier process and reasons for Failure
Development of new AE process.
Getting the Audit Tables created and altered for some Tables with triggers required for the process
Resolve all the issues highlighted for the earlier process
Unit Testing
Project:2
Hong Kong Jockey Club
Team Size
3
Client
Ernst & Young Private Limited.
Platform
Back-End
PeopleSoft HCM 9.1, PeopleTools 8.52, Oracle 11g
Summary
Ernst & Young Private Limited had outsourced some of its requirements of its Upgrade for Hong Kong Jockey Club.
These involved
1.45+ PS Queries including Global Payroll/Absence based reports
2.5 XML Publisher Reports including Global Payroll based reports
3.Verification of Security in more than 60 Processes
4.1 App Engine Process to upload data from CSV file using File Layout with validations for all columns as per column type specified on Run Control Page.
Responsibilities
Used PeopleTools to customize Pages, Records and components as per business requirements.
Used PeopleCode to implement the business rules and customizations as per configuration document.
Application Development:
Modified entities like Fields, Records, Page, Components, Menus, etc. using Application Designer.
Applied preventive, detective and corrective controls using PeopleCode.
Brought to use Application Engine for various enhancements and XML Publisher based reports.
Development of run control records, pages and components and attaching the SQR to the Portal.
Project:3
FirstSource
Team Size
3
Client
Firstsource Solutions Ltd.
Platform
Back-End
PeopleSoft HCM 8.9, PeopleTools 8.46, MS SQL Server 2005
Summary
Firstsource required a team to support PeopleSoft HRMS modules and administration. The team is responsible to provide bug fixes, enhancements and customizations as and when requested.
Responsibilities
Extensively used PeopleTools to customize Pages, records and components as per business requirements.
Extensively used PeopleCode to implement the business rules and customizations as per fit-gap analysis and configuration document.
Application Development:
Handled hands-on, major changes to keys, indexes and also table edits used as validations performed on critical record fields.
Modified entities like Fields, Records, Page, Components, Menus, etc. using Application Designer.
Applied preventive, detective and corrective controls using PeopleCode.
Brought to use Application Engine for various enhancements.
End-user requirements elicitation and analysis.
Development of reports using SQR.
Development of run control records, pages and components and attaching the SQR to the Portal.
Was involved during the uncustomisation of Prior Work Experience
Project:4
WNS Global Services
Team Size
4
Client
WNS Global Services
Platform
Back-End
PeopleSoft HCM 8.9 and 9.1, PeopleSoft EPM 9.1
PeopleTools 8.49, 8.50 and 8.51
Oracle 10g
Summary
WNS required a team to support the PeopleSoft HRMS modules. The team is responsible to provide bug fixes, enhancements and customizations as and when requested. Also involved in Implementation & Customization for PeopleSoft EPM 9.1 (ePerformance Module)
Responsibilities
Extensively used PeopleTools to customize Pages, records and components as per business requirements.
Extensively used PeopleCode to implement the business rules and customizations as per fit-gap analysis and configuration document.
Application Development:
Handled hands-on, major changes to keys, indexes and also table edits used as validations performed on critical record fields.
Designed Advanced search functionality for customized page and including giving the user the ability to search for range of values
Modified entities like Fields, Records, Page, Components, Menus, etc. using Application Designer.
Integrated PeopleSoft with various internal micro-sites and portals using CI and App Engine
Applied preventive, detective and corrective controls using PeopleCode.
Brought to use Application Engine for various enhancements.
End-user requirements elicitation and analysis.
Development of reports using SQR
Development of run control records, pages and components and attaching the SQR to the Portal.
Was involved in retrofits post Payroll Bundle application
Was involved in the customization of ePerformance Module
Was involved in PeopleSoft Upgrade activities from HRMS 8.9 to HRMS 9.1
Responsibilities include:
oHelping DBA team with errors encountered during change assistant steps
oIdentifying customizations that need to be carried forward
oRetrofitting for customizations
oUnit testing
oAssisting DBA team during initial and final MTP
Project:4.A
WNS – PS HCM Upgrade from 8.9 to 9.1
Platform
Back-End
PeopleSoft HCM 8.9, PeopleSoft HCM 9.1
PeopleTools 8.49, PeopleTools 8.51, Oracle 10g
Summary
PeopleSoft Upgrade activities from HRMS 8.9 to HRMS 9.1
Responsibilities
Involved in planning and executing PeopleSoft HCM upgrade from 8.9 to 9.1
Involved in Fit/Gap Analysis of HCM
Detailed impact analysis was done to identify the objects, compared between old and new model to retro fit. All customized objects were identified, exported and migrated.
Retrofitting for customizations
Detailed testing was planned at various stages, executed and results were validated before releasing the system to users.
Studied the current business processes and recommended future businesses for the following PeopleSoft Modules: WFA, workforce development, position management, Benefits, Compensation, Company Property, Core HR/Payroll, Leave Administration, Tracking Reporting, ESS, MSS, Helpesk etc.
Developed Functional Designs, System Integration Testing scripts, User Acceptance Testing Scripts
Worked with the High and Middle level managements
Project:4.B
PS EPM 9.0 & Boltons
Summary
WNS implemented ePerformance in PeopleSoft using the PS EPM 9.0 for the first time. They required the CMSS team at WNS to customize the current module as per their requirement. This also included creating additional Bolton Components and Pages for Higher level approvals after manager level approvals for balancing the ratings as per the bell curve.
The other Bolton was a replica of the ePerformance Page where employee would provide comments on the Finalised yearly Ratings and Manager can review it.
Responsibilities
Gathered Business requirement to implement it into the PS EPM 9.0 module
Analyzed Fit and Gap of the current process to PeopleSoft ePerformance system and recommended solutions for Gaps
Customized ePerformance Documents for the requirement
Created custom reports for Preliminary Rating, Final Rating and Demographical data using XML Publisher
Developed Fit/Gap Documents
Customized application package PeopleCode to modify the ePerformance document functionality such as recalculating the weight and rating when the manager tries to submit without saving etc
Developed Technical Designs, System Testing documents and UAT Scripts
Worked very closely with the business managers, users and ePerformance management team sponsors
Created Bolton Module Pages for Higher Level Approvals (a total 4 more upper levels) for meeting the bell curve of the ratings
Setup Page to Map the Employees and their levels
Created Bolton Module Pages for the employees to provide Final Comments on the Finalized Rating.
Created custom Application Engines for Scheduled Reminders
Project:4.C
Bolton eCompensation
Summary
WNS implemented a Bolton eCompensation Module to provide annual hikes to employees via approvals and grid matrices setup at different Job Levels based upon their Horizontals and Verticals in terms of percentages.
Responsibilities
Gathered Business requirement to converted it into a technically working Module
Customized Setup Pages for Configurations and Approvals.
Customized Approval Pages for 3 level Manager Approvals
Created custom reports
Developed Technical Designs and System Testing documents
Developed UAT Scripts
Worked very closely with the business managers and users
Created custom Application Engines for Scheduled Reminders
Project:5
Poornata (Aditya birla Group Internal PeopleSoft HCM 8.9.)
Team Size
2
Client
Aditya Birla Group
Platform
Back-End
PeopleSoft 8.9, PeopleTools 8.46, Oracle 9i
Summary
After implementation of PeopleSoft 8.9 HCM Aditya Birla Group required a team to support the project called as Project Poornata.
The team is responsible to support PeopleSoft HRMS modules. The team is responsible to provide bug fixes, enhancements and customizations as and when requested.
Responsibilities
Modification/Troubleshooting of SQR’s related to all module in PeopleSoft.
Writing new application engine programs and maintaining the old ones to generate the discrepancy reports for the discrepancies in the JOB and POSITION records.
Development of fields, pages, components and customizations of existing.
Developing Functional / technical specifications based on the requirements stated by the client.
Understanding the interface requirement and creating technical document for the same.
Put role as well as row level security on Succession planning search page.