Peoplesoft Consultant Resume
Professional Summary:
- Over 15 years of of IT experience.
- Over 14 years of PeopleSoft HRMS development experience.
- Over 4 years of PeopleSoft Application Administrator experience.
- Detailed experience includes implementation, customization, providing extensive support, design, development, Testing and documentation.
- Applied bundles, patches and fixes in people soft tools and application.
- Excellent experience in People tools, Datamover, Nvision, SQR, Configuration Manager and crystals.
- Migrated projects from test to production, implemented change control.
- Excellent experience on full life cycle of the project.
- Sound knowledge of PeopleSoft technical and functional attributes including export and importation of PeopleSoft objects, data conversion, training of end users and installation of client on personal computer for end users.
- Worked with client/server, 3-tier and 2-tier architectures.
Education Qualifications:
MBA in Business Administration
BS in Business Administration
PeopleSoft web/HTML Client Development, PeopleCode, PeopleSoft Query, Relational Databases, Application Engine, Component Interface, Business Process, Process Scheduler, SQR, Advance SQR, PeopleSoft HRMS, Base Benefits, Payroll, Position Management, Application Designer, Configuration Manager, Business, Process Designer, Process Scheduler, Process Monitor, Security Administrator, Import Manager, Data Mover, SQL Loader, PeopleTools I, PeopleTools II, Microsoft Office, Microsoft Visio, Oracle, Informix, SQL Server, PL/SQL, RPG, COBOL, BASIC, SQL (Informix Oracle and PeopleSoft), UNIX, MSDOS, Windows 95/98, WinNT, Windows 2000, Windows XP, PC PENTIUM, RISC, Mainframe
Projects Summary:
Confidential, Manhattan, New York 7/2006 - Present
PeopleSoft Consultant - Senior Analytical Tester - Technical / Functional
Hardware/Software:
PeopleSoft 8.8 (HRMS/HCM), Windows XP, NT/2000, STAT 5, Microsoft Word, Microsoft Excel and Application Designer
- Planned, created, and managed the testing strategy, testing plan and schedule with Technical Lead, Functional Lead and Project Manager.
- Preparation:
- Setup required test scenarios/cases in appropriate environments.
- Developed test conditions for each test scenarios/case.
- Developed test scripts to match test conditions.
- Execution - Execute and document test scripts:
- Performed specific task/s and logging results, defects and resolutions.
- Analyzed modifications and subsystems for PeopleSoft look and feel in term of appearance and end user operation.
- Analyzed developers' codes to determine if there are any defects that can cause functional errors (That is using SQL plus technical knowledge to carry out the same process or function).
- Verified the content of tables (new control tables and updated tables) using SQL
- Coordination - Provided a primary point of contact for the coordination of all testing activities with regard to stakeholders' objectives.
- Monitored and trained junior testers.
Confidential, Brooklyn, New York Jan 2006 - Jun 2006
PeopleSoft Consultant - Business Analyst - Technical / Functional
Hardware/Software:
PeopleSoft 8.8 (HRMS/HCM), Windows XP, NT/2000, STAT 5, Microsoft Word, Microsoft Excel and Application Designer
- Gathered information from users and company policy documents to determine the business requirement for each design and development.
- Developed functional and technical design documents from user requirements.
- Developed Analysis documents for business processes such as :
- Pre-employment screening
- Leave of Absence - online
- Online W4 and IT 2104
- Designed and developed on-line pages, PeopleCode, SQL, PeopleTools and Application Designer.
- This includes work done on the following business processes:
- Applicant Existence Check
- Pre-employment screening
- Fingerprint results detail
- Drug test and Medical forms
Confidential, Glen Allen, VA 8/2005 - 12/2005
PeopleSoft Functional Consultant HRMS/HCM
Hardware/Software:
PeopleSoft 8.8 (HRMS/HCM), People Code, People Tools, Seagate Crystals for PeopleSoft. Windows XP, NT/2000, SQL, Oracle, UNIX, Exodus, Toad, Entrust, VPN, Microsoft Word, Microsoft Excel and Application Designer
Responsibilities:
- Provided functional support for PeopleSoft HRMS/HCM applications including Employee Self Services, Manager Self Services, ePerformance, eDevelopment HR, PeopleSoft Security, Payroll, HR Workflow and Benefit.
This required the following processes / tasks:
- Issued range from 'how to' to customization of the system.
- Performed knowledge transfer
- Used People Tools and SQL, to analyses and resolved issues
- Determined and designed system specifications for the integration of business processes.
- Possessed knowledge of multiple business areas in order to determine how to resolve or who is responsible to provide solution for, a given issue.
- Tested customized releases before they go into production
- Maintained URLs, message and text catalogs
- Maintained users' profile with respect to their roles, permissions and access level.
- Created and run queries against security tables in order resolved issues and also to generate security reports.
- Used issue monitor system (Peregrine) to record the process life cycle of an issue.
- Communicated with of staffs at various levels regularly
Confidential, Troy, MI 4/2005 - 7/2005
PeopleSoft Technical Consultant
Hardware/Software:
PeopleSoft 8.8 (CRM), People Code, People Tools, Seagate Crystals for PeopleSoft. Windows XP, NT/2000, SQL, Oracle, Microsoft Word, Microsoft Excel and Application Designer
Responsibilities:
- Designed and developed on-line pages using SQL, HTML, People Tools, People Codes and Application Designer.
This required the following processes / tasks:
- Gathered information from users and company policy documents to determine the business requirement for each design and development.
- Developed Technical Design document
- Used application designer to build all objects required by pages and batch programs (field, record, page, component and menu).
- Used People Code and HTML script to support the functionalities of each page.
- Created pages in 2-tier and test them on-line in 3-tier.
- Developed user instruction manual for on-line pages.
- Provided a list of possible errors and warnings that can occurs during processing and how to recover from them.
Note:
Design include functionalities such as email address book, sent box for email, sending of email, previewing of email and the integration with PeopleSoft CRM.
Confidential, Auburn Hills, MI Jan 2005 - Apr 2005
PeopleSoft Consultant - Business Analyst - Technical / Functional
Hardware/Software:
PeopleSoft 8.8 (HRMS, Payroll), Seagate Crystals for PeopleSoft. Windows XP, NT/2000, SQR, DB2, Microsoft Word, Microsoft Excel and Application Designer
- Gathered information from users and company policy documents to determine the business/user requirement for each design and development.
- Developed functional and technical design documents from user requirements.
- Designed and developed on-line pages and script for batch programs using SQR, PeopleCode, PeopleTools and Application Designer.
This includes the complete design documents for processes such as:
- Bonus Payment.
- Weeks worked per payment type.
- Profit Sharing payment
Confidential, Newark, NJ 9/2004 - 1/2005
PeopleSoft Consultant - PeopleSoft Security Administrator
Hardware/Software:
PeopleSoft 8.x (HRMS, Payroll), Seagate Crystals for PeopleSoft, Windows NT/2000, Oracle 8.x
- Developed security procedures for database instances with regards to refreshing each difference instances with production, and maintaining data integrity and user access level.
- Performed PeopleSoft security audit of users' actions on the system.
- Maintained users' profile with respect to their roles and permissions
Confidential, Kingston, Jamaica, WI 9/2000 - 10/2004
PeopleSoft Application Administrator & Senior Developer
Hardware/Software:
PeopleSoft 7.51, Windows 2000, PeopleSoft 7.51(HR, Payroll), People Tools 7.51, PeopleCode, SQR, Oracle 8.x (SQL) and SQL Server Window NT, Unix, Microsoft Word, Microsoft Excel, Application Designer, Process Scheduler and Security Administrator
Responsibilities:
- Granted and evoked user access at the application level (PeopleSoft Payroll).
- Granted and evoked user access of users and passwords at both operating system (Unix) level and application level (Tips2000 Payroll)
- Developed technical specification for reports, customizations and interfaces by gathering business requirements from end-users and policy documents.
- Performed in-depth problem troubleshooting, resolution and root cause analysis for application issues.
- Worked closely with PeopleSoft Administrators and DBAs to resolve several system wide issues like Performance Tuning, Report Repository, Process Scheduler and PeopleSoft Security.
- Designed and developed payroll interfaces using SQR, PeopleCode, PeopleTools:
- General Ledger Interface, which transfer payroll, charges from PeopleSoft to Oracle General Ledger.
- Deduction Interface that receives employees deductions from any given system in the form of a text file and loads it into the Payroll system.
- Cash Management Interface, which transfers information on all cheques, issued by the payroll system for the purpose of bank reconciliation.
- Direct Deposit Interface, which transfers employees\' salaries electronically to their respective bank accounts.
- Developed reports using SQR, PeopleCode and PeopleTools:
- Control (Audit) reports to monitor the actions of users on the system
- Change reports to monitor changes in employees records
- Deduction Change
- Allowance Change
- Department Change
- Payroll Cheque Requisition
- Employee Status
- Deduction Register
- Net Pay Listing
- General Ledger
- Statutory (tax) Reports
- General Ledger setup for payroll system
- G/L flag reset
- Reset ok-to-pay
- Reset Auto Pay sheet Update
- Cheque printing report
- Advice printing report
- Panels were customize to satisfy company's business processes
- Specification of the design requirements for the distributed front-end system to PeopleSoft Payroll that allows online daily input, employee inquiry and accompanying batch reports (replaces the Time and Labor module)
- Specified and developed local tax module to deduct the required statutory deductions:
- Income Tax
- Superannuation (Pension)
- National Housing Trust
- National Insurance Scheme
- Education Tax
- Modified SQL, SQR and PeopleCode developed by other developers in-house and vendors.
- Provided functional support to application users, as it relates to the function of the application and the company\'s business processes.
Confidential, Jamaica, W. I. 6/1990 - 8/2000
PeopleSoft - Functional and Technical
Hardware/Software:
PeopleSoft 7.51, Windows 2000, PeopleSoft 7.51(HR, Payroll), PeopleTools 7.51, PeopleCode, SQR, Oracle 8.x (SQL), Informix (SQL), Window NT, Unix, Microsoft Word, Microsoft Excel, Application Designer, Process Scheduler, Security Administrator
Responsibilities:
- Provided analytical skills for the installation and maintenance of Tips2000 payroll systems.
- Provided analytical skills for the installation and maintenance of PeopleSoft payroll systems
- Installed PeopleSoft on-site training software to support on-site training.
- Provided customer service for over one hundred users.
- Maintained user\'s password at the operating system (UNIX) and application levels.
- Startup and shutdown application system or database on request (or when required)
- Monitored system performance with respect to disk space and printer availability
- Analyzed and define user problems, and provide technical specifications for in-house or external solution providers
- Designed and developed new subsystems from users' requirements.
- Used SQL to create AD_HOC reports and /or data files
- Provided requirement specifications for vendor modifications.
- Designed the Time Entry System front ended to replace PeopleSoft Time and Labor, due to the different union requirements, tax rules, contract rules, time management and benefits administration.
- Involved in the setting up of Position Management, unions' rules, tax rules, and unions' contract rules and benefits administration.
- Involved in data conversion to load the data in to PeopleSoft system.
- Involved in customizing the Self-service pages i.e., Direct Deposit, Voluntary deductions, Weekly overtime and Pay Slip.
- Involved in customization of Additional Pay page, Pension Scheme page, statutory Details as per the end user specifications.
- Involved in complete customization of Direct Deposit and Pay slip as per the user requirements.
- Involved in customization Voluntary Deductions and weekly over time by hiding and unhidden the fields as per the end user requirements.
- Created new records, panels using Application Designer and wrote PeopleCode to support application.
- Involved in design and development of customized SQR process to extract the necessary paycheck information from other systems and import data file into People Soft payroll for payment.
- Involved in running the Import manager to load all the necessary tables as a part of the data conversion process to set up the Payroll interface.
- Involved in set up core tables along with the People Soft Payroll interface expert.
- Involved in development of SQR process to test the data synchronization.
- Involved in complete testing of Payroll interface along with the end user.
- Involved in designing the security for the different users based on their roles.
- Involved in running the Payroll interface process as a part of Payroll Admin
- Involved in designing the customized Data mover Scripts to import and export data from one instance to another as part of the conversion process.
- Involved in documentation for the each customization to maintain history and time stamping.
- Involved in Unit testing and system testing as per the user test scripts
- Involved in implementing the Global Payroll Rules Configuration and absence calculations
- Modified the system to allow components of pay to be segmented based on changes in compensation, employee's status or job changes during a pay period.
- Involved in building the calculation rules for attributes such as earnings, deductions, absences and accumulators in terms of payroll policies.
- Created trigger process that causes the system to perform an action automatically when certain change in data takes place.
- Excellent knowledge of Global Payroll rules definitions such as Calculation rule, Arrears Processing, Rounding and Prorate rules.
- Involved in setup and testing of the Retroactivity process (that is, going back in time and recalculating prior earnings due to changes being made after the original calculation is run).
Confidential, Jamaica, W I 4/1988 - 5/1990
Programmer/Analyst
Member of application support group that maintains all applications used by the company.
Hardware/Software:
IBM - Mainframe, RPG, COBOL, JCL and Recital (DBASE)
Responsibilities:
- Resolved users software problems - procedural problems
- Coded and installed software modifications to fit company business policies
- Analyzed user\'s requests and provide solutions in the form of new programs or modification to existing programs.
- Designed and coded subsystems
- Responsibilities extended to the following systems Payroll (IBM), Budget, Accounts Payable and Bank Reconciliation.
Confidential, 9/1987 - 4/1988
Programmer Analyst
Hardware/Software:
IBM - Mainframe, RPG, COBOL, JCL and DBASE
Responsibilities:
- Modified application software to fit company business policies
- Code programs to satisfied users requests
- Responsibilities extended to the following systems Payroll (IBM), Inventory, Accounts Payable and Accounts Receivable.