Sign in

Peoplesoft Consultant

Moncton, NB, Canada
May 02, 2014

Contact this candidate


Madhu Aggarwal

Address: * ****** ******, *** #****, East York, Toronto, ON M4C5L4

Email:, Phone: +1-647-***-****


To seek a challenging role as a software professional in your organization, form part of an experienced and knowledgeable development team where I can contribute my skills. To continue exerting my passion for software testing and development while learning new software engineering practices.


• B.Tech. with 6+ years of software professional experience.

• Proficient in Test Plan creation, Test Case execution, Defect Management and documentation for supporting testing activities.

• Extensively used SQL for data base testing and tested on web based applications

• Oracle certified professional in PeopleSoft and SQL.

• Proficient in PeopleSoft V-9.1, 9.0, PeopleSoft HRMS9.0-Core HR Workforce Administration.

• Worked on PeopleSoft implementation & up-gradation projects, which deals with interfaces, Customizations, testing and reports.

• Good knowledge of the reporting tools such as SQR, PS Query and XML Publisher.

• Solid experience in GUI Testing, Functional/System Testing, Function Flow Testing, Integration Testing, Regression Testing, User Acceptance testing, Agile testing

• Experienced in using Oracle and SQL databases for testing and development activities.

• Experienced in preparing Test Scripts and Test Cases for Manual Testing in


• Thorough knowledge of all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC) and Bug Life Cycle.

• Highly motivated, self-starter, able to work independently as well as collaboratively within a diverse technical team.

• Good communication and interpersonal skills.

• Excellent team player, dedicated and goal oriented.

Technical Summary

People soft Applications : Application Engine, People code, Component Interface, XML Publisher, PS Query, File Layout, SQR,AWE(Approval Workflow Engine), STAT, Toad

PeopleSoft Functional : PeopleSoft HRMS9.0-Core,HR Workforce Administration

Languages : C, C++, SQL

Operating Systems : Windows-XP,Windows-9X

Databases : Oracle 9i, 10g, SQL Server 2000


• Bachelor of Technology (B.Tech.) in Electronics and Communication from Kurukshetra University, Kurukshetra, INDIA in 2005.


• Graduated with Honours.


• Oracle Certified Professional in SQL with 91%.

• Oracle Certified Professional in People soft Application Developer I People Tools & People Code with 98%.

Work Experience

QA Software Engineer

06/2012 – Till Date, Spielo International Canada

•Prepared functional test cases for Intelligen GUI system, various reports related to the warehouse, and on-demands reports

•Executed functional and regression test cases or conditioning with positive and negative scenarios for testing the test cases, and for the execution of batch process to see the expected results.

•Prepared regression test cases for end of day process, executed the scenario using test bed and for batch process to get the automatic renewal of the products purchase in the front end

•Used Test Plan, Test Lab, Requirements tab, Defects raised and followed up with the issues in the HP-QC

Environment: Oracle 9.1, HP-QC 10.0, Jira

Senior Peoplesoft Consultant

07/2011 –11/2011 Steria India Ltd.

Customization and problem resolution for Technical specification to meet the business requirements.

Part of integral team for providing the technical solution to client requirements.

Technical design, development, review, QA and documentation activities.

Mentoring new and junior team members.

This project involved the implementation of PeopleSoft HCM 9.1 across Steria offices in 16 countries. The modules which are being developed are:


• ePerformance

• Time & Labor

• Payroll

Peoplesoft Consultant

08/2009 –07/2011 CSC India

• Involved in the fit-gap analysis and design phase.

• Analyzed the existing Business rules of Position data and Job data for redesigning the existing functionality.

• Worked on Style Sheets to make the user interface look better.

• Implementation of AWE for the Change Job transaction of MSS in HRMS.

• Implementation of Offcycle Salary Change transaction of MSS from the scratch.

• Reviewing components that are to be delivered to the client.

• Writing new SQC’s and customizing existing SQR’s according to requirement.

• Interacting with the client and the onsite coordinator for issues and queries in the project.

• Preparation of technical design documents, code, test plans, test results to ensure standards are properly adhered during document or code preparation.

Peoplesoft Consultant

07/2006 – 05/2009, Oracle India Pvt Ltd

• Understanding the requirements & Design Specifications.

• Customizations of existing PeopleSoft pages.

• Coding and Designing pages.

• Developed Customization of existing components & creating new components in HCM 9.0.

• Developed Customization of Manager Self service applications.

• Involved in Peoplecode related to the customizations and development.

• Customised SQR as per user requirement.

• Project documentation.

• Preparation of technical design documents, code, test plans, test results to ensure standards are properly adhered during document or code preparation.


Standard/Degree Board/University Subject/Branch Percentage/Div.

Bachelor of Technology (B.Tech.) Kurukshetra University Electronics and Communication 71%

(Senior Secondary) 12th CBSE Science 71%

(Secondary)10th CBSE General 80%

References are available upon request.

Contact this candidate