SUMMARY:

• Over Nine (9) years of IT experience in application development, enhancement and production support on PeopleSoft HCM and Financials suite. Worked on PeopleSoft HCM 9.2/9.1/ 8.52 9.0/8.49, 8.9/8.47, 8.8/8.46,8.3/8.12, 8.0/8.19 and 7.5 that include various modules like HR, Payroll(NA), Benefits, e - Recruit, Talent Acquisition Manager, e-Benefits,, ESS and MSS. Implementation of various People Soft modules and upgrades from 8.8 to 8.9 and 8.9 to 9.1. Proficient in PeopleSoft technologies and developed PeopleSoft Applications using People Tools (Releases ) technologies and tool sets - App Designer. He has excellent working knowledge in People Tools (Application Designer, Application Engine, Security Administrator, Process Scheduler, SQR, Integration Broker, XML Publisher, Approval Workflow Engine, Component Interface, Data Mover, Security Administration, Operator Security, Object Security, Workflow, SQL Programming and Crystal Reports). Expertise in designing, configuring and implementing of PeopleSoft Financials. He also has experience in writing Project scope document, functional and technical design Documents, Documents, Requirement and Analysis Documents, Test cases & scripts and Involved in different types of testing lifecycles unit, system, and integration testing based on system specifications. He Involved in Interfaces Development,Upgrade retrofitting and Reporting. Expertise to various stages of life cycle development and have gained extensive knowledge in quality management, project management, and communication and presentation skills. He used the Test Director to exclusively make the Test Cases suiting to different functional scenarios.
• Over 9 years’ experience on PeopleSoft
• Strong experience working as PeopleSoft Techno-Functional Consultant on HR, Payroll(NA), Benefits, e-Recruit, Talent Acquisition Manager, e-Benefits,, ESS and MSS.
• He has worked as a Coordinator between onsite and offshore Teams, understanding requirements and getting the requirements developed by the offshore team and make sure that they adhere to the standards.
• He has experience working on PeopleSoft 8.9 to 9.2 and PeopleTools 8.53.11

TECHNICAL SKILLS:

ERP Packages: PeopleSoft Human Capital Management (HCM) 9.2, 9.1. 9.0, 8.9, 8.8, 8.3

PeopleSoft Tools: PeopleTools 8.52, 8.49, 8.48.

PeopleSoft Advanced Technical: Application Designer, PeopleCodeApplication Engine, Component Interface, People Code, Excel to CI, Data

Mover, SQR, XML Publisher, Integration Broker

External Tools: HPOV, HP Quality Center

Reporting Tools: SQR, PS Query, XML Publisher

Front End Tools: Subversion, Clear case, PVCS

Language: PeopleCode, COBOL

Mainframe Technologies: JCL, CICS

Database: Oracle 9i, 10g, 11g, SQL Server, DB2

Operating System: WINDOWS 98/NT/2000/XP/CE, UNIX

Domain Knowledge: HRMS

PROFESSIONAL EXPERIENCE:

Confidential - Minneapolis, MN

PeopleSoft HRMS Techno-Functional Consultant

Responsibilities:

• Involved in Gathering requirement, fit-gap analysis, designed gap strategies, Design, data analysis, data mapping for conversion, data cleaning, preparing technical documentation, Table set up & interface design for PeopleSoft 9.2 Time & Labor and Payroll for NA Implementation.
• Rewriting existing App Engine for performance improvement
• Created process definitions and new run control pages, components to run different reports and processes People Code have been developed for on line validations and Application Engine programs. Also created Job definitions and scheduled jobs.
• Setting up Users, Roles, Permission lists to maintain Security.
• Implementing new changes to track Service Center team member enrolling Employee Benefits on their behalf.
• Developed proxy access to Call center teammates to help the employees with the benefit enrollments
• Customizations in E-Recruitment per user requirements.

Environment: PeopleSoft HRMS upgrade 9.2 HRMS (HR, Benefits, NA Payroll, Time and Labor), People Tools 8.53, SQR, Application Engine, Component Interface DB2 and MVS.

Confidential - Green Bay, WI

PeopleSoft HRMS Techno-Functional Consultant

Responsibilities:

• Involved in Gathering requirement, fit-gap analysis, designed gap strategies, Design, data analysis, data mapping for conversion, data cleaning, preparing technical documentation, Table set up & interface design for PeopleSoft 9.1 Time & Labor and Payroll for NA Implementation.
• Gathered business process requirements and participated in fit-gap analysis, and Identified RICE Object & Proposed solution for the gaps.
• Involved in the Analysis, and Design of different phases of implementation
• Set up and configured Time Collection Devices (TCD) which includes Local Node Setup, Gateway Configuration and Routing Rules while implementing the requirement where in employees would use Time Clocks to report time into the PeopleSoft Time and Labor system.
• Wrote conversion SQR’s to transfer existing Time and labor, Benefits and Payroll data from legacy system to PeopleSoft application database tables. .
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed custom Time and Labor rules to take care of Rounding Rules, Meal over Times and Scheduled Day off. Also, created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Involved in creating task groups and establishing Time Periods, Calendars, Shifts, Work schedule templates and work groups
• Perform all PeopleSoft Time & Labor, Benefits and North American Payroll configuration to meet new business requirements. Performs functional testing
• Responsible for Person profile management configuration, page-let configuration and done manual updates to the page-lets.
• Responsible for writing Test Cases
• Retrofit the HR, Payroll and Time and Labor customizations from 8.9 to 9.1 upgrade environments.
• Have done bug fixes in the T&L-Time Admin and Loader processes.
• Worked on setting up base HR tables, writing interfaces from HR to a third party Database as well to a third party Time Collection device called ACTIVE.
• Setting up of the module control tables in Benefits such as benefit plan table, coverage group table, leave plan table, salary rate table, retirement plan table, include field for employee deduction and company contributions. Load employee data from the existing Legacy system to PeopleSoft tables.
• Customized existing Pages, People Code to meet company’s business requirements
• Developed a series of workflow to send an email and work list to appropriate roles on the event of Hire/Rehire/ terminate, promotions, Demotions, Change of personal data, Address, Name…etc to employees using Approval Workflow Engine to notify the changes to them so that they continue with their respective tasks.
• Created process definitions and new run control pages, components to run different reports and processes People Code have been developed for on line validations and Application Engine programs. Also created Job definitions and scheduled jobs.
• Setting up Users, Roles, Permission lists to maintain Security.
• Customization of Health, Disability, and Savings plan, Life Panel. Etc in Benefits Module.

Environment: PeopleSoft HRMS upgrade 9.1 HRMS (HR, Benefits, NA Payroll, eDevelopment), People Tools 8.52, SQR, Application Engine, Component Interface, Integration Broker, XML Publisher, Windows NT and Oracle 11g.

Confidential - Milwaukee, WI

PeopleSoft HRMS Technical Consultant

Responsibilities:

• Involved in Requirement Gathering, Prepared Technical Specifications.
• Performed analysis on various business requirements to prepare SOW’s.
• Developed the Lock Time sheet functionality, and restricted the end users to enter the time when the Lock time sheet was activated. This would mean that employees, supervisors and timekeepers would not be able to report (enter) any payroll time after the lock has been activate (City and Park Board wide) for the current payroll cycle.
• Customized Pay003.sqr pay check program and added new column as rate used both on paper paycheck and online paycheck for all the city employees to display the type of earnings as (H, F, NP, A, U).
• Applied Tax updates and bundles, and performed unit and system testing.
• Developed Custom Time and Labor rule for MBC work group to take care of employees
• Straight time or compensatory time whenever they worked more than 4 hours per day or more or less than 40 hours per week.
• Customized USER SELF SERVICE page to display only email group and password group, and validated the email entered by the end user and restricted them not to enter any other email id except city’s validated email id. If the email Id is validated it also automatically updates the email id on the PERSONAL DATA component.
• Developed custom Time and Labor Queries to enable Functional users to identify specific employees.
• Fixed the issues with the retro pay and made the custom process to work correctly when the employee has a pay rate change or when he is eligible for retro, And wrote custom SQL and People Code to correct the negative retro amounts for overtime earning codes.
• Developed Custom application engine process to archive data from TL PAYABLE TIME for every payroll cycle in time and labor so that it increases the efficiency in report generation
• Configure troubleshoot and support all the tables involved in Payroll processing like Pay Calendar, Job Code, Deductions and Processes such as Pay sheet Creation, Pay Calc, Pay Confirm, Tax tables etc.
• Thorough Understanding of Time Admin and all the Sections in it. Deep understanding of how the setup data is loaded and processed by Time Admin. Trouble shooted Time admin for various errors as part of production support.
• Created Query reports to list the exceptions by each time reporter and to get the sum of payable time by TRC’s.
• Worked on synchronizing the data between the City HRIS system and the Halogens Talent management suite of applications and involved in pulling the data from HRIS to HALOGEN software for Employee Appraisal Purpose.
• Actively involved in the unit testing and issue resolution. And also involved in moving the code from one environment to other using change control request.

Environment: PeopleSoft 9.1 HRMS (HR, Benefits and NA Payroll), PeopleTools 8.50, SQR, Windows NT, PeopleCode, SQR, Component Interface, Integration Broker, App engine and Oracle 11g

Confidential

PeopleSoft HRMS Technical Consultant

Responsibilities:

• Customized Daily Time Calendar, Weekly Elapsed Time Entry, and Punch Time Entry and Manager Time Approval pages as per the requirements. Extensively used PeopleCode and PeopleTools during the customization.
• Involved in creating of Task Groups and establishing Time Periods, Calendars, Shifts, work schedule templates and work groups.
• Developed interfaces to capture time from Kronos Management System into PeopleSoft Time and Labor System.
• Developed an interface for reporting time from a flat file using File Layout, Component Interface, and Application Engine into the PeopleSoft Time and Labor system.
• Defined and built Work Schedules by creating Shifts, Workdays, and Template Definitions for Weekly, Biweekly employees.
• Developed Template/Custom Built Rules using Daily Threshold, Holiday and Guaranteed Hours and customized the rules using SQL objects, actions and conditions as well as user exits.
• Generated a process to create interface between Benefits and Time and Labor which compares employee's leaves recorded in Time and Labor against the allowed leaves; this process is used as an alternative to the existing Payroll feature, which calculates the Leave Accruals.
• Involved in design, development and testing of Employee self-service (ESS) and Manager self-service (MSS) customized Absence planning Application pages
• Involved in the debugging of errors and modifications to various objects related to HR, Payroll, Benefits, Time and Labor including case management and resolution documentation
• Worked extensively on Application engine by adding new fields to the State records and modified the AE Sections and steps (SQL Objects and PeopleCode) appropriately to use the new fields on the state record, Set processing techniques, parallel processing, Meta SQL, and using temp tables and managing temp table instances
• Developed an interface for reporting time from a flat file using File Layout, Component Interface, and Application Engine into the PeopleSoft Time and Labor system.
• Designed, developed various XML Publisher reports across various modules for specific client requirements.
• Modified existing report formats and developed XML Publisher reports using PS query.
• Developed programs to call the Application Messages and Component Interfaces from the Application Engine programs.
• Developed Interfaces for Payroll, such as Deduction Calculation: this SQR generates deduction codes for each employee’s benefit plans elected for that particular year; these deduction codes are used by the payroll department to process (Benefits Billing Process) the pay of employees.

Environment: PeopleSoft HRMS 8.9 (HR, Benefits, Time & Labor, Payroll, Talent Acquisition, eRecruit, ePay), PeopleTools 8.48, PeopleCode, Application Engine, SQR, Component Interface.

Confidential - Chicago, IL

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• Extensively worked with the HCM Upgrade team and functional users in order to develop, support and resolve technical issues in Workforce Administration, Payroll, Benefits, Time and Labor during the upgrade from v8.8 to v9.0.
• Developed and updated technical design documents due to upgrade changes.
• Performed Migrations of projects in App Designer between various databases and also generated compare reports.
• Reviewed the compare reports, Map the gap between 8.8 and 9.0, tune the Data, load AE programs
• Extensively involved in data conversions and generated the flat files from tables then used Import Manager, SQR, and SQL Plus to insert the data into PeopleSoft
• Worked extensively on the set-up of Time Periods, Shifts, Reason Codes, Task Profile Templates, Task Entity Codes, Task Groups and Work Groups.
• Mapped Time Reporting Codes to Corresponding Earning Codes, Defined Rounding options and Day Breaker options on the Workgroup.
• Retrofitted all the Custom Template based rules in 9.0 by taking into consideration of all the Temp table changes in 9.0 Monitored the flow of work through the system and Trouble shooted the HR issues.
• Involved in Pay Calculation, pay sheet creation process.
• Identified a generic set of input data that is sent to the TCD systems and also determined a generic set of output data that is produced by various TCD systems.
• Involved in setting up Pay Calendars and Pay periods, Company General Deductions.
• Involve in the Conversion Programs and historical data conversion.
• Designed and created Component interfaces for Employee Job Change and Location Change.
• Developed several reports for Pension Administration which Provides summary information about a calculation and its benefit formulas. This SQR report showed each benefit formula processed during the specified calculation.
• Set up Time and Labor Security for Time reporters who were enrolled into Time and Labor in a phased manner by establishing Static and Dynamic workgroups and assigned employees to those groups.
• Actively involved in the testing and issue resolution during the parallel test and the postproduction support.
• Environment: People Tools 8.46/8.48, HRMS version 8.8/9.0, Time And Labor, Payroll, SQR, Application Engine, Workflow, Application Messaging SQL, PeopleCode, XML Publisher, STAT, Oracle 10g.

Environment: PeopleSoft HR 8.9 HRMS (HR, Payroll, Compensation, Benefits, Self-Service and Manager Self Service), PeopleTools 8.48, SQR, Application Engine, Component Interfaces, Mainframe and DB2

Confidential - Stamford, CT

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• Involved in Customization and Upgrade of PeopleSoft 8.3/8.9 (HR, Payroll, Payroll Interface, Base Benefits).
• Performed design, development and modifications to PeopleSoft Objects such as records, pages, components and menus to meet the requirements of the client.
• Using Payroll Interface Connector for ADP Connection linking PeopleSoft HRMS with ADP Pay Force.
• Involved in Integrating PeopleSoft with Profits, ADP and Symmetry using PeopleSoft Payroll Interface.
• Involved in implementing the Interface of PeopleSoft with external Payroll system, sending PeopleSoft HR data to ADP Payroll services
• Design new Records, Pages, Components and Menus for HR Department (HR/Payroll)
• Responsible for Implementation of Direct Report UI for manager self-service module
• Responsible for set-up of Direct Reports text catalog and notepad entries
• Provided security to various records and attached to different access groups
• Worked in setting up workflows, resolving problems related to workflows for existing setup and creating new business process/activities
• Modified predefined PeopleCode for HR, Self-Service and Payroll modules
• Create a number of custom fields, record definitions, pages, component and documented Interface programs and updates
• Created DMS Scripts that are used to migrate the Benefits Configuration to various environments.
• Created new Custom Folders in Portal to place all the Custom Reports, Processes and Interfaces that are used by Benefits department.
• Setup the Process Scheduler to enable end user to do multi- process jobs to run on a mainframe server and also used Process Monitor to keep track of status of the report.
• Used PeopleTools, PeopleCode extensively to meet the business requirements.
• Developed Conversion Programs to move data from the legacy system into PeopleSoft tables using SQR as the primary tool and generated status reports after performing validation.
• Created record groups and message catalogs entries.
• Conduct unit testing for new modifications.
• Created and customized SQL queries to meet business requirements.
• Work extensively on various table structures, record layouts of the output files generated by various Interfaces.
• Involved in Setting up Integration broker.
• Extensively worked on writing PeopleCode to send SOAP Messages to PROFIT.
• Done Testing to minimize the error and to meet the current version to previous version.

Environment: PeopleSoft 8.3/8.9 HRMS (HR, Payroll, Compensation, Benefits, Self-Service and Manager Self Service) modules, PeopleTools 8.17/8.48, Mainframe and DB2

Confidential - Milwaukee, WI

PeopleSoft HRMS Technical consultant

Responsibilities:

• Participated and assisted in the HR & Benefits Fit Gap analysis.
• Create technical specifications for customizations using functional specifications as the source.
• Assisted the configuration team to meet their time lines by loading large configuration tables using Application Engine.
• Experience in working with workflows.
• Created the audit record for the Job record to track the changes made to the job record
• Customized complex pages by adding certain additional functionality.
• Developed several reports using PS Query and SQR.
• Successfully completed HR Data conversion for all the member country offices
• Worked in setting up workflow, resolving problems related to workflow for existing setup and creating new business process/activities.
• Involved in Implementation and Customization of employee self-service modules and manager self-service modules
• Created an SQR interface program, which captures all active employees and their dependents data to the Insurance Company
• Involved in the development and testing of multiple PeopleSoft Tax Updates. Retrofitted the customized versions of PAY003, PAY018, TAX920US, and TAX004 as part of Tax Updates.
• Worked on ADP Tax Updates. ADP maintained Countrywide’s periodic and quarterly tax programs. Updated delivered probiz.sqc according to Countrywide’s requirements.
• Customized the delivered Payroll Check Register PAY04P to suit the business requirements, for Payroll Accounting to be able to reconcile both on and off cycle checks printed by the Treasury Dept in a timely manner.
• Worked on Payroll year-end process to update the retirement plan checkbox on the W-2 tax form based on an input file provided by Benefits Department. This process uses File layout, Application Engine, DMS scripts, SQLS.
• Created a custom payroll Worklist process to pull the job/employment/personal changes based on the Audit table and create a report that would go to the respective analysts via E-mail.
• Created a custom meal time program that would pull the hourly Employees who did not take the required break time. Break rules differed from state to state.
• Modified delivered PAY018 to create a custom program that will accept multiple Run id’s as input parameters
• Designed and Customized eBenefits Home page Flexible spending account pages & life events (Martial Status Change) using App Designer, PeopleTools, PeopleCode
• Designed, developed and documented data mapping of all required HR records to the systems and this would be used as a guideline to develop code for conversion of legacy data to PeopleSoft
• Designed and created various Interfaces, which generate output files required for the Vendors.
• Extensively used Application Designer and other PeopleTools of version 8.45 to modify existing tables and create some new tables and views to suffice the application needs.
• Made the Process Scheduler enabled by creating the Process and Job definitions and giving the security to those process and jobs.
• Created and modified many panels and added to existing menus to reflect the customized panels and controlled the program flow with PeopleCode.
• Created Multiple Reports using SQR and provided security, so that respective departments get reports concerning to their departments instead of getting the reports of all the departments.

Environment: PeopleSoft 8.8 HRMS (HR, Benefits, Ben Admin, Payroll) self-service modules (eRecruit, eBenefits, eCompensation), PeopleTools 8.45, SQR 6.1.4, workflow, Windows NT and Oracle 8i