PeopleSoft Technical Consultant Resume
|Desired Industry: Information Technology
|Desired Job Location: Toronto, Ontario
||Date Posted: 12/3/2012
|Type of Position: Contractor
||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
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.
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
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:
|JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.