PeopleSoft Technical Consultant - Information Technology Resume Search
PeopleSoft Technical Consultant - Information Technology Resume Search
My Spider Scam Awareness Contacting Us F. A. Q.
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
Search Resumes
Browse Resumes
Post a Job

PeopleSoft Technical Consultant Resume

Desired Industry: Information Technology SpiderID: 65697
Desired Job Location: Toronto, Ontario Date Posted: 12/3/2012
Type of Position: Contractor Availability Date:
Desired Wage:
U.S. Work Authorization:
Job Level: Experienced with over 2 years experience Willing to Travel: Yes, More Than 75%
Highest Degree Attained: Bachelors Willing to Relocate: Yes

 6 years of development experience that includes 4 years of PeopleSoft in HRMS/HCM and 2 years in system and Quality Testing
 Expert in different technologies of PeopleSoft ERP including PeopleTools, Application Designer, Application Engine, Component Interface and PS query
 Proficiency in applying business rules for process and validation using PeopleTools
 Expertise in Design, Development, Implementation, Customization, Reporting, Production support and testing of the PeopleSoft HCM/HRMS 9.0/8.9/8.8/8.3 Application (for HR, NA Payroll, Benefits, Employee Self Services, eBenefits, ePay)
 Experience in preparing technical specifications from functional/ business requirements.
 Extensively involved in performance tuning and troubleshooting of PeopleCode, SQR and Application Engine programs
 Proficient in Data Mapping and ETL(Extract Transform and Loading) from legacy systems to PeopleSoft systems
 Extensive knowledge of unit testing, integration testing and regression testing
 Experience of applying bundles & patches for the enhancements provided by PeopleSoft
 Worked on customization of delivered reports, development of Inbound and Outbound Interfaces and writing complex reports using SQR
 Knowledge in Fit/Gap analysis of the HRMS processes and identified the customizations that needed to be carried forward
 Expert level knowledge of designing and customize PS Queries
 Ability to work independently and also can be an integral part of small and large teams
 Excellent Analytical, written and verbal communication skills
 Possessing valuable insights, keen analysis and openness to learn to implement best practices. Adapt at working in high pressure environments with strict deadlines

Professional Experience:
Royal Bank of Canada, ON Jan 2011-Till Date
Role: PeopleSoft Technical Consultant
RBC has long been a leader in Banking and Financial institutions. This is a PeopleSoft HRMS HR, Benefits, NA Payroll modules support, enhancements and implementation of Enterprise Learning module.
 Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists
 Involved in online changes to the delivered pages, components, menus and translate values
 Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table
 Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS application modules
 Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
 Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process
 Active role in changing the SQRs as per the business requests from the users
 Developed number of inbound-outbound interfaces using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications
 Developed SQR programs to create Time Load to pay sheets, employee pension plan data.
 Involved in Data mapping for legacy data conversion
 Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees’ information after each day and load them into the people soft tables
 Involved in acquiring Specifications from the functional team and modifying the SQR’s as per the specifications
 Used process scheduler for scheduling recurring process, for conditional Scheduling of successive process, for setting up the reports to run at specific time and implementation of batch processing
 Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs in HR, Benefits and Payroll Modules
 Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements

Environment: PeopleSoft HRMS 9.0, People Tools 8.46, Application designer, People Code, Process
Scheduler, PS-Query, SQR, Application Engine, Oracle 10g, UNIX, Windows NT/2000

Canadian Imperial Bank of Commerce, ON Jan 2010-Dec 2010 Sep
Role: PeopleSoft Developer
CIBC is one of Canada's chartered banks, fifth largest by deposits and serves more than eleven million clients, and has over 40,000 employees
 Actively worked as a development team to provide PeopleSoft expertise towards applications
 Assisted in upgrading HRMS from version 8.3 to 8.9. and retrofit all custom pages to new version
 Handled upgrading application process by applying bundles & patches to resolve issues
 Worked with Production support team (24/7) during the Bi-weekly Payroll run process to fix any problems for the Paycalc process and nightly batch process
 Actively participated in the page development, adding people code, menu creations and creating new records, as per the client requirement
 Involved in the development of SQR reports related to the Employee benefits, their RRSP contributions and benefit related information to different banks and other institutions
 Loaded Pension Plan information from Spread Sheet to PeopleSoft Tables
 Created new SQR Programs that includes employee eligibility for ESPP, leave accrual information by leave plan and employee, plan year eligibility hours, carryover hours earned year-to-date, hours taken year-to-date, and remaining leave balances
 Worked with the Testing team and the users to helped them out in the testing process of different SQR’s

Environment: People Soft HRMS 8.3/8.9, PeopleTools 8.40/8.46, HRMS (HR, NA Payroll, Benefits) PeopleCode, Application Designer, Crystal Report, Oracle 9.x and UNIX.

University of Western Ontario, ON 2007-Dec 2009
Role: PeopleSoft Technical Consultant
The university has over 23,000 undergraduate and over 5,000 graduate students and administers its programs through 12 different faculties and schools. This was a support and enhancement to PeopleSoft HRMS applications.
 Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR and NA Payroll modules.
 Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
 Attended client meetings and gave presentations of the work done and resolve any critical production support issues. Identified the functional Gaps, Customization lists, Impact analysis of customizations
 Used Process Scheduler for setting up the reports to run in batch process and Process Monitor to supervise the status of processes and reports.
 Worked in developing and customizing complicated Portal Pages using multiple level scrolls and derived records.
 Tuned SQL/SQRs to improve performance using advance features like Load lookup and Arrays.
 Worked on Application Designer to customize Run Control Pages and Menus, developed new process definitions and attached to PeopleSoft system.
 Involved in Implementation and Customization of employee self-service (ESS) modules such as eRecruit and ePay.
 Using eRecruit enabled all the employees to view all the jobs, submit referrals and to submit their resumes online.
 Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans.
 Tested the end-user desired output and application functionality.
 Developed various PS queries in order to help the client day-to-day activity.

Environment: PeopleSoft HRMS (HR, NA Payroll, Benefits, eRecruit, ePay, eBenefits) 8.9, PeopleTools 8.46, Application designer, People Code, Process Scheduler, PS-Query, SQR, Application Engine, Oracle 9i, Windows NT/2000

DSS Business Solutions, ON June 2006-Aug 2007
Role: QA/QC Analyst

Customization, development and maintenance of the web enabled integrated financial and supply chain management solutions with EDI fulfillment.
 Requirement gathering, Specification designing, website designing, coding, testing and ongoing maintenance.
 Furnished QA/test and supporting skills to functionality, compatibility, reliability, security and related testing of a wide variety of web-based and client to server software products on windows and UNIX operating systems.
 Creation and execution of test plans and test suites; exploratory and ad hoc testing; bug documentation and regression; team and individual work.
 Benefited from comprehensive internal training program in software testing theories, procedures and methods.
 Assessment of data system and help in UML document design and DFD design.
 Hands on all aspects of software quality assurance: development of test plans and test cases, unit, integration, acceptance testing.
 Managed and coordinated various testing projects of varying complexities.

Environment: HTML, CSS, Macromedia Dreamweaver, Windows9x.

Education Qualification:
 Post Graduate Diploma in Bioinformatics Seneca College, Toronto, Canada
 Bachelors of Science Gujarat University, Gujarat, India
 Trained in PeopleSoft-PeopleTools I & II
 SQL Fundamentals, Database Admin I & II (Oracle 11g) Seneca College Toronto
 Trained in Microsoft Office tools
 Trained in Software Testing

Technical Skills:
ERP package : PeopleSoft HRMS 9.0/8.9/8.8/8.3 (HR, NA Payroll, Benefits, Employee self services, eBenefits, ePay)
Development Tools : Application Designer, PeopleCode, Application Engine
Component Interface, Integration Broker
Methodology : Project Management, Business Analysis, Requirement gathering, BRD, RFP, Dataflow diagram, ER diagrams, Integration Testing, Cost-Benefit Analysis
Reporting Tools : PS Query, SQR, Crystal Reports, XML Publisher
Administrative Tools : Data Mover, Process Scheduler, PS Admin
RDBMS : Oracle 11g/10g/9i, MS SQL Server, Toad
Languages : Java, SQL, C, Perl
Operating Systems : Windows 95/98/2000/NT/Vista/7, UNIX, MS DOS

Candidate Contact Information: has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


© 2019 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links