Navpreet Samra

613-***-****

adgx5b@r.postjobfree.com

Summary:

Strong PeopleSoft Functional and Technical consultant with 15+ years of Extensive experience in PeopleSoft ERP Applications.

Worked very closely with Business users in capturing requirements and creating Functional documents (BRD & FD).

Utilize Functional expertise to lead fit-gap sessions with primary stakeholders to setup and configure the system.

Designed technical solutions for the functional specifications

Have good exposure to Software quality processes and PeopleSoft Standards.

Strong Expertise in documenting the As-Is Process and performing Complete Fit-Gap Analysis.

Expertise in analysing complex business process of various enterprise and design solutions in PeopleSoft.

Worked closely with Developers, IT and UAT Testers to make sure work is progressing as expected.

Documented all new changes in requirements and maintained up-to-date specifications for developers and testers.

Have good exposure to Software quality processes and PeopleSoft Standards.

Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance.

Experienced in all testing types: Regression, Smoke, System integration, Data conversion testing.

Experienced in writing the test plans, cases and scripts based on system specifications and expertise in regression system integration functional and performance testing.

Have worked in three PeopleSoft HCM upgrade (PeopleSoft HCM 7.5 to 9.1) engagements.

Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.

Working Experiences in Databases like Oracle, SQL Server and DB2.

Involved in documentation of technical specifications and developing test cases.

Involved in full length Life-Cycle implementation of PeopleSoft modules.

Worked individually, as well as in team environment, to achieve project goals.

Good Conceptual understanding of various PeopleSoft Applications.

Good communication, interpersonal, analytical and problem solving skills.

Effective Team Player and an individual contributor with steep learning curve.

Professional Experience:

Consulting

PeopleSoft HCM Developer

April 2019 – till date

Human resource reporting system provides extracts using data from PeopleSoft systems. As HRRS is decommissioned, the technical solution is to interface directly with the systems of records.

Responsibilities:

Lead in creating functional documents for integration from 7.5 to 9.1.

Lead in creating functional documents template which will used across other functional analyst.

Created functional documents for transaction data.

Created functional documents for technical team

Utilize Functional expertise to lead fit-gap sessions with primary stakeholders to setup and configure the system.

Performed Production Support, enhancements and customizations of PeopleSoft HRMS.

Resolved issues with HR and benefits reports and interfaces, by correcting the logic and making necessary modifications as required to the SQR programs.

Expertise in analysing complex business process of various enterprise and design solutions in PeopleSoft.

Worked closely with Developers, IT and UAT Testers to make sure work is progressing as expected.

Documented all new changes in requirements and maintained up-to-date specifications for developers and testers.

Created PeopleSoft SQR reports for different departments as per requirements

Experienced in writing the test plans

Lead in PeopleSoft releases.

Assign Jira tickets to self-resolve them and send results to clients

Give status update of tickets to managers

Optimized large complicated SQL statements

Environment: PeopleSoft HCM 9.1, 8.9,7.5, JIRA, Oracle, Windows XP.

Rexel

PeopleSoft HCM and payroll consultant

October 2016 – March 2019

Responsibilities:

Created PeopleSoft SQR reports for different departments as per requirements

Query different PeopleSoft tables like PS_PAY_CHECK, PS_PAY_EARNINGS, PS_PAY_OTH_EARNS, PS_EMPLOYEE to get information for different clients

Assign Jira tickets to self-resolve them and send results to clients

Give status update of tickets to managers

Optimized long running reports using plan b approach

Environment: PeopleSoft HCM -Payroll 9.1, DB2, Windows XP.

Agriculture Canada

PeopleSoft HCM functional consultant

Aug 2015 – August 2016

Responsibilities:

Created functional documents for upgrade from 8.9 to 9.0.

Designed technical solutions for the functional specifications

Have good exposure to Software quality processes and PeopleSoft Standards.

Expertise in analysing complex business process of various enterprise and design solutions in PeopleSoft.

Worked closely with Developers, IT and UAT Testers to make sure work is progressing as expected.

Documented all new changes in requirements and maintained up-to-date specifications for developers and testers.

Have good exposure to Software quality processes and PeopleSoft Standards

Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance

Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance.

Experienced in all testing types: Regression, System integration, Data conversion testing.

Experienced in writing the test plans

Environment: PeopleSoft HCM 9.0/8.8, PeopleTools 8.49/8.42, TOAD, Oracle 10g/11i, SQL, PL/SQL, STAT 5.2, UNIX, Windows XP.

Cognos

Jan 2008–August 2015

SAP/PeopleSoft functional consultant

Responsibilities:

Performed Production Support, enhancements and customizations of PeopleSoft HRMS 8.9.

Prepared gap analysis and business requirements documents and developed functional design documents.

Prepared and executed test scripts and sign off on changes to production environment.

Prepared and delivered training materials used by both SIT and UAT testers during and post implementation.

Mentored new team members.

Prepared test conditions for business Signoff.

Documented all new changes in requirements and maintained up-to-date specifications for developers and testers.

Have good exposure to Software quality processes and PeopleSoft Standards

Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance

Designed technical solutions for the functional specifications

Have good exposure to Software quality processes and PeopleSoft Standards.

Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance.

Experienced in writing the test plans

Experienced in all testing types: Regression, System integration, Data conversion testing.

Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.

Environment: PeopleSoft HCM 8.9, PeopleTools 8.49, TOAD, Oracle 10g, SQL, PL/SQL, STAT 5.2, UNIX, Windows XP.

Cognos

Sep 2006 – Dec 2007

SAP/PeopleSoft HCM Consultant

The objective of this project is to Upgrade PeopleSoft HRMS from v8.3 to v8.9 and production support.

Responsibilities:

Involved in running the PS Delivered Application Engine process for data conversion from our current version to the newer version.

Involved in developing the Test strategy, planning, estimate, risk, assessment, mitigation and test cases for QA Evaluations.

Participated in group meetings for building the testing schedules.

Tested Payroll Interfaces

Worked on Payroll work Requests and Reports.

Worked closely with creating pay calendars, creating Pay Sheets and running through the final payroll process.

Ran On-Cycle and Off-Cycle Payroll for Employees

I have run North America payroll while testing Tax Updates to ensure the integration of the system with the new delivered patches and bundles.

Involved in the System Integration testing of PeopleSoft to Pay Planner Interfaces.

Involved in the System Integration testing Pay Planner to PeopleSoft Interfaces.

Involved in the System Integration testing of PeopleSoft to Talent central interfaces.

Developed PS Queries as per the user requirement.

Modified Application Engine programs and processes (SQL and Application Engine PeopleCode) based upon business requirements.

Environment: PeopleSoft HRMS 8.3/8.9, PeopleTools 8.42/8.48, SQR, TOAD, ORACLE 10g,STAT 5.3, SQL PLUS 9.0.1.

Cognos

Oct 2003 – Aug 2006

PeopleSoft HRMS Consultant

Responsibilities:

Provided production support and maintenance for various PeopleSoft applications.

Analysis and technical feasibility discussions to incorporate new business requirements within existing application.

Developed an SQR to print the employee’s personal information, benefit plan type, and the deductions amount for the plan type using HR, Benefits and Payroll tables.

Created new Application Engine & Component Interface program to upload employee’s new Compensation rates from input file to Job component.

Developed various Outbound and Inbound Interfaces for transmitting employee Data to Benefits vendors and process the receiving data to insert into various PeopleSoft Tables

Created custom Component Interfaces to allow Managers to Hire Applicants from Manager Self-Service pages.

Added Zip Code match customization so that user’s don’t make errors when entering the Zip Codes in the personal information pages or recruiting pages.

Worked on the development of ePay module to develop reports and application engine programs to load into the PeopleSoft tables.

Created a Component Interface between Payroll and Time & Labor System to report employees who have exceptional time reporting codes.

Worked on Paycheck page Customizations to change the search keys for better page performance and comma formatting of the amount fields on the Pay_Check_Summary page.

Developed new SQR programs to pull the Payroll related data from PeopleSoft HRMS Database and to generate Flat files.

Involved in security for all the custom components and pages.

Retrofitted customizations after each tax update.

Customization of Application as per the Business requirement and developing new functionality flow.

Developing new Synchronous and Asynchronous Interfaces to the external systems using Integration broker tool.

Created various weekly, monthly status reports using starteam and pvcs.

Developing App Engine Programs and scheduling them using Process Scheduler to run in the background.

Involved in Unit Testing for all upgraded SQR programs and tuned them to resolve performance base issues related to them.

Working on Enhancement Requests from Design to deployment phase and migrating in to Training and Production Environments based on Business confirmations.

Environment: PeopleSoft 8.8, PeopleTools 8.46, SQL Plus, Multi-Edit, Textpad, WebSphere, TOAD, STAT 5.2.1 and UNIX.

Technical Skills:

ERP:

PeopleSoft 9.1/8.9/8.8/8.3/8.0/7.5.

Modules:

HR, Payroll, Benefits, Benefits Administration.

Development Tools:

Application Designer, Application Engine, PeopleCode, Process Scheduler, Data Mover, Component Interface, Application Messaging, Integration Broker, STAT.

Reporting Tools:

PS/query, SQR, Crystal reports.

RDBMS:

Oracle 9i, 10g, Ms SQL Server, DB2.

Contact this candidate