Peoplesoft Techno functional

Issac Mathews Ph/Email :314-***-**** / hdka40@r.postjobfree.com

Profile:

Over 10 years in IT industry which include 8 years of experience as Techno-Functional and Technical consultant in PeopleSoft HRMS And Financials Modules .

Summary:

• 6 years of experience in Implementation, Upgrade and Development of PeopleSoft HRMS 9.0/8.9/8.8/8.3 modules HR, Payroll, Benefits, Time and Labor and Self Service modules.

• 2 years of experience in Implementation, Upgrade and Development of PeopleSoft Financials and SCM 7.5/8.0 modules (AP, AR, AM, GL) modules.

• Good understanding of the functional modules of PeopleSoft HCM (Payroll, Benefits, eRecruit, eCompensation, eProfile, ePay).

• Extensive Experience in Application Designer, PeopelCode, Application Engine, Maintain Security( Row Level Security ), PS Query, File Layout, Process scheduler, Workflow, Role Query , Data Mover, Component Interface ,Integration Broker and Reporting tools (SQR and Crystal Reports).

• Extensive experience in data analysis, data mapping and data conversion from legacy system to PeopleSoft application database tables using SQR, Application Engine, File layout and Component Interface and Excel to CI.

• Significant PeopleSoft implementation experience from project conception through roll-out which includes requirement analysis ,fit gap analysis, Technical design, conversion strategies, data mapping ,development, major customization, issue resolution, performance tuning, testing, and training.

• Very strong SQR coding skills with expertise in design and development of complex SQRs for complicated interfaces, data conversion and reports using SQR best features like Break Logic, Load-Lookup, Arrays and Multiple reports.

• In-Depth understanding of PeopleSoft Internet Architecture (PIA), Data models and client server applications.

• Good in PeopleSoft Enterprise Portals setup & development, Application Messaging, Component Interfaces and its customizations.

• Very good debugging skills in PeopleCode, Application Engines and SQR using trace file and conventional debugging techniques.

• Expertise in Unit testing (Test plans and test cases) System testing, Integration testing and Functional testing.

Experience:

Correctional Medical Services, Inc. (CMS), St.louis , MO Feb 2008 to Present

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Involved as functional consultant in the Reimplementation from version 8.0 to version 9.0.

• Verified the impact analysis, User sessions, prepared functional and technical design, and functional/technical specs for the reimplementation of HR, Payroll and Benefit.

• Performed the Fit –Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.

• Interacted with Business Analysts to figure out the Process flow in various Business processes.

• Detail analysis done on implementing Person model in 9.0, discussed with SMEs regarding management view regarding new model, Created data conversion scripts for person model.

• In depth analysis done on position management, mapped all existing Job codes in Version 8.0 to new positions.

• Analyzed the Compare reports and reapplied the customizations of SQR’s, Crystal reports, Pages, Records, People code and Application Engine Programs.

• Converted data from PeopleSoft 8.0 to the PeopleSoft 9.0 database using Application Engines with File layouts, Component Interfaces and SQRs.

• Design and developed the applications with Application Designer, Application Engine, People Code, Component Interface ,Integration Broker and Workflow.

• Upgraded queries, Crystal and security from 8.0 to 9.0

• Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the client, implemented People Code for online validations.

• Developed complex SQR reports and SQC’s to as per the business requirement.

• Extensively used People Tools for creation or modification of Process Definitions, Records, Pages, and Menus to run Custom SQR’s through PeopleSoft environment.

• Developed number of inbound and outbound interfaces with third party software using Application Engine programs, Application Messaging, Component Interfaces and SQR’s.

• Prepared unit test plans , system test plans and carried out the unit testing , integration testing and documented the results.

• Worked as functional QA for the new features in 9.0

• Worked as technical QA for the upgrades and customizations.

• Created detailed Test Scripts for HR, Benefits and Payroll.

• Participated in User Acceptance testing, provide advice on various scenarios during UAT testing.

• Worked with SMEs on parallel testing, assure parallel test results are matching with production results.

Environment: PeopleSoft HRMS 9.0, PeopleTools 8.49, Oracle 10g, PL/SQL, Windows-NT/2000/XP and Unix,Weblogic6.1, Tuxedo6.5, Jolt, SQL*plus, SQL Tools, TOAD, Crystal Reports 9.

Washington University, MO Aug 2006 to Feb 2008

PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Analyzed the existing applications and involved in Fit/Gap Analysis, design and evaluation customization, functional/technical specs development for the Implementation of Benefits and Time and Labor.

• Involved in the upgrade from HRMS 8.3 to 8.9 (HR and Payroll), analyzed the Compare reports and reapplied the customizations of SQR’s, Crystal reports, Pages, Records, Peoplecode and Application Engine Programs.

• Converted data from the legacy system to the PeopleSoft database using Application Engines with File layouts, Component Interfaces and SQRs.

• Design and developed the applications with Application Designer, Application Engine, PeopleCode, Component Interface, Integration Broker and Workflow.

• Worked on Benefits Administration in resolving BenAdmin issues.

• Worked closely with Benefits team for requirements gathering and converting functional requirements into technical requirements and developed the functionality.

• Used Data Mover to move data from development database to testing database and from testing database to production database.

• Setting up of process scheduler to enable end user to do multi- process jobs to run at client or at server.

• Developed new Records, Online Pages, and Run Control Pages using PeopleTools for the specific needs of the client, implemented People Code for online validations.

• Developed complex SQR reports and SQC’s to as per the business requirement.

• Extensively used PeopleTools for creation or modification of Process Definitions, Records, Pages, and Menus to run Custom SQR’s through PeopleSoft environment.

• Developed number of inbound and outbound interfaces with third party software using Application Engine programs, Application Messaging, Component Interfaces and SQR’s.

• Prepared unit test plans and carried out the unit testing and documented the results.

• Query Profiles, Opening, modifying and building queries, Query Tree and transferring to Crystal using PeopleSoft Query to Crystal Interface.

• Worked on enhancements, customizations based on Service Requests by business users for PeopleSoft online objects and Non-PeopleSoft objects like SQRs.

• Involved in resolving the trouble tickets and issues related to custom reports and processes.

• Co-coordinated with HR staff for business capability testing and acceptance testing.

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.46, Oracle 10g, PL/SQL, Informix9.4/7.3, Windows-NT/2000/XP and Unix,Weblogic6.1, Tuxedo6.5, Jolt, SQL*plus, SQL Tools, TOAD, Crystal Reports 9.

Kraft Foods, ON Oct 2004 to Aug ’06

PeopleSoft HRMS Techno Functional Consultant

• Performed the Fit –Gap analysis and the Upgrade lab sessions to sort out the new functionalities to be added to the existing system.

• Interacted with Business Analysts to figure out the Process flow in various Business processes.

• Involved in analysis, design, data mapping and data conversions using SQR.

• Involved in the Application upgrade from version 8.3 SP1 to version 8.8 SP1 by using upgrade Assistant to prepare Upgrade for comparison Reports, Upgrade Statistics for Oracle to run the Benefit Reports and configured options to run unattended processes for error notification by Email.

• Involved in system testing and bug fixing during the initial and move to production phases of the Application upgrade.

• Involved in upgrade of people tools objects and primarily responsible for loading base data, fields compare reports and converting, reviewing Application Engine Reports.

• Prepared the database for the upgrade, applied required patches and fixes for the upgrade, ran DDDAUDIT, SYSAUDIT reports and cleaned the database before the upgrade process.

• Involved in transferring DAT, DMS, and SQL script files using Data Mover.

• Responsible to run various Initial Audit Reports, Application Audit reports, compare Reports, Script modifications, involved in the upgrade process.

• Created run controls record pages and attached to the process scheduler, to run the process.

• Executed job for the initial pass of upgrade using Upgrade Assistant, documented issues related to upgrade steps, worked with PeopleSoft and resolved issues.

• Developed an application engine program to generate random passwords for the existing users and email them after the cut over process.

• Involved in migrating the projects from with in various development environments and to production environment.

• Responsible for modifying & upgrading several customized SQR reports from PeopleSoft version 8.3 to 8.8.

• Identified in-efficient SQR programs and tuned them to improve performance.

• Performed system testing on the customized reports and pages.

Environment: PeopleSoft HRMS v 8.3/8.8, (HR, Payroll, Benefits), PeopleTools 8.4x, SQR, Crystal Reports 9.0, Data Mover, Oracle 9i, Windows 2000/NT, HP-Unix.

Abitibi-Consolidated Ltd., QC Feb 02 to Oct ’04

PeopleSoft Technical Consultant

This project is aimed to upgrade the Integrated PeopleSoft Financials and Supply chain management Modules (AP, AR, AM, GL, Purchasing and Inventory) to their Business operations from version 7.5 to 8.0.

Responsibilities:

• Involved in People Tools, Financials Application and Customization Upgrades from PeopleSoft 7.5/ 8.0(SP2).

• Functionality Testing and Feasibility test done for most of the applications and features introduced in Version 8.0 relevant to company.

• Responsible for delivering the AR customization reports and Functionality testing of AR processes in PS 8.0.

• Worked closely with End Users to understand current systems and define requirements for development of Reports, Interfaces and Customizations within PeopleSoft AR, AP and GL Modules.

• Involved in the High level & Detailed Gap/Fit analysis of the existing PeopleSoft Financials 7.5 to PeopleSoft Financials 8.0

• Involved in the Compare & Upgrade report analysis and documented all the upgrade procedures.

• Modified Custom SQRs and Developed Enhancement SQRs for as required for 8.0.

• Involved in Business requirements gathering to design technical AR, AP & GL documents.

• Designed Outbound Interface document and analysis for PS Data to Mainframe systems and Inbound Design Document for Voucher entries and Vendor Details.

• Applied the relevant fixes and tested the new functionality, like the Job Creation and Worker Assistance Act of 2002 related to Asset Management

• Created the Security user roles, profiles and permissions lists for the users and granting them the required access.

• Created Unit Test Plans templates for Upgrade SQR Testing Documentation.

• Worked extensively on upgrade tasks at the end of the project to meet the go-live date when the Go-Live date was difficult to meet.

• Actively Involved in production Support of ver.7.53 (AR, AP & GL) parallel to Upgrade

• Suggested the client to go with Out-Of-The-Box functionalities instead of customizations to reduce the project cost and timelines. This also increases the performance of the application.

Environment: PeopleSoft Financials 8 (SP2)/7.53, People Tools 8.17 / 7.53, Oracle 8.1.7/8.0.5, XML, .NET, Windows 2000/NT server, SQR 6.14, COBOL, SQL, SunOS 5.6 Unix, IBM Mainframes, Web logic, Tuxedo

3M Canada, ON Jan 2001 to Nov ‘01

PeopleSoft HRMS Consultant

• The project was to implement PeopleSoft HRMS modules HR and Payroll.

• Set up the company information, define establishments, location, department, salary grades, job codes and pay groups for the basic HRMS System.

• Worked on SQR to generate daily, weekly, and monthly reports of employees and non- employee work forces and scheduled them in process scheduler.

• Worked with Payroll SQR Reports to issue Payroll Register, Payroll Check Register, Other Earnings Register, Payroll Error messages and Payroll Summary Report. Customized the People Code for compensation rates and codes.

• Submitted processes to process scheduler to run daily tasks at a time or run recursively by creating a Recurrence definition to run at specific intervals.

• Set up single page and single sign-on for complete benefits.

• Used Maintain Security to give access to the customized menu and created permission lists, users, roles and assigned roles to users. Securities that were dealt with included Operator Security, Object Security, Query Security and Row Level Security

Environment: PeopleSoft HRMS 8.0, PeopleTools 8.17, Oracle 8i, PL/SQL, WindowsNT,

Sun Solaris 2.8, Weblogic5.1, Tuxedo6.5, Jolt, SQL*plus.

InfoTech Software Ltd India (Head Office: Malaysia) May’99 - Nov' 2000

System Analyst

I. FAS (Multi departmental Generalized Financial Accounting System): This is a general accounting system designed as a module for a multi departmental client and later on decides to generalize. FAS can meet all accounting needs of different departments in an organization. It can produce stand-alone accounting statements to department and consolidated statements to its parent organization. For non-multi departmental organizations it could work as a user-friendly accounting solution. Unique strength given to this package is its adaptability towards multi departmental organizations.

II. DAIKEN 2000 (Production Management System): This Project is a modification and enhancement of existing production management system done for DAIKEN KOGYO Ltd, Japan & DAIKEN SARAWAK Ltd, Malaysia.

III. POS (Point Of sale): Module developed to fit in the restaurant section of the parent hotel management system.

IV. PORITE (Material management system): Project is a material management system, developed for a pharmaceutical firms located in Malaysia and Japan.

• Participated in Analysis and design.

• Design system flow chart, Process Specification, functional specification, algorithms, pseudocode and normalized Database.

• Lead development team in all aspects of coding and reports.

• Participated in Component level testing, Regression Testing, Pressure Testing, Technical Documentation and implementation..

Environment: Visual Basic 6.0, COM (ActiveX server dll, EXE), IIS, MTS, ASP, Java Script, SQL Server 7.0 (Stored Procedures), Source Safe and Crystal report. (3-tire Architecture) Windows NT

Soft Systems Export Ltd Dec '98 to May’99 Programmer Analyst

I. Live Stock Management System (Scientific Animal Management System): A Major module in ERP Harvest it for scientific management of animal farm combined with integrated farming concept.

II. Fixed Asset (Fixed Asset Keep Tracking System): A Major module in ERP Harvest it, for Fixed Asset management in agricultural organizations.

• Participated in Analysis and design.

• Design system flow chart, Process Specification, functional specification, algorithms, pseudocode and normalized Database.

• Lead development team in all aspects of coding and reports.

• Participated in Component level testing, Regression Testing, Pressure Testing, Technical Documentation and implementation..

Environment: Visual Basic 6.0, COM (ActiveX server dll, EXE), IIS, MTS, ASP, Java Script, SQL Server 7.0 (Stored Procedures), Source Safe and Crystal report. (3-tire Architecture) Windows NT

Education:

• Masters in Computer Science (MCA)

• Bachelors In Commerce (B.Comm)

• Trained in PeopleSoft HRMS and PeopleTools

Technologies:

ERP : PeopleSoft HRMS (HR, Payroll, Benefits, Time and Labor)

Languages : PeopleCode, SQL, COBOL, Java, C, C++, Progress, FORTRAN, PASCAL, HTML, DHTML, XML

Tools /GUI : PeopleTools, SQR, DataMover, Crystal Reports, Power Designer, True DBGrid. Java Script and VB Script, Visual Basic and Visual Interdev

RDBMS : Oracle, SQL Server, DB2, MS-Access.

Operating Systems : Windows NT, MS-DOS, Unix

Web Technologies : ASP, MTS, IIS, PWS, JSP, Servlets

Data Base Models : ADO, RDO and DAO

Contact this candidate