PROFESSIONAL SUMMARY

• Over 8 years of extensive experience as PeopleSoft HCM Techno Functional Consultant in full life cycle implementations and upgrade of PeopleSoft applications.
• Extensive experience in PeopleSoft HR, NA Payroll, Base Benefits, Time and Labor, Benefits Administration.
• Expert level experience in PeopleTools, Application Designer, PeopleCode, Application Engine, Security Administrator.
• Process scheduler, Component Interface, PS Query, Workflow, Data Mover, and Integration Tools.
• Hands - on experience in Upgrade, Implementation, Customization, Production support and Maintenance of PeopleSoft HRMS modules.
• Extensively worked with Reporting tools used in PeopleSoft such as SQR, XML Publisher, and PS Query.
• Experienced in Data conversions, and developing interfaces using SQR and Application engine.
• Experienced in developing complex PeopleCode and custom PeopleCode functions.
• Technical expertise in the configuration of Message Nodes, Message Channels,

TECHNICAL SKILLS

• PeopleSoft HRMS (9.1, 9.0, 8.x)
• Application DesignerwPeopleToolswPeopleCode
• Application EnginewFile LayoutwComponent Interface
• SecuritywPortalwProcess Scheduler
• PC Debugger wApplication Engine Trace wTrouble Shooting
• SQRw SQLwPS Query
• Tree Manager wPL/SQLwData Mover
• Windows 2000, NT, XP w UNIX
• Oracle 11g/10g/9i w MS SQL Server w DB2

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

PeopleSoft HRMS Techno/Functional Consultant

Responsibilities:

• Involved in the Analysis, and Design of different phases of implementation.
• Involved in Requirement Gathering, Prepared Technical Specifications.
• 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
• Modified HR DR ADDL INFO and JPM JP SEL PRF EMP as per the client requirements
• Modified EG SSTRAINING L component to add the brief description of the course
• Modified Delivered Manage hire process to transfer custom fields data on job opening and job offer pages in TAM module to JOB DATA EMP on HR .
• Customized HRS APPLSRCH TIPS page on basic job search and advanced job search on careers page and TAM search posting pages
• Customize PeopleSoft HRS JO APP ACT SBP within the job opening on the Manage Applicants grid to add columns to include company, business unit, department and employee ID.
• Customized HRS JO TEAM SBP page to default the hiring manager in the hiring manager field as primary hiring manager
• Developed inbound file upload process using add attachment and view attachment functions
• Created new Pages, Components, and PeopleCode and migrated them to different environments using STAT.
• Customized existing Pages, PeopleCode 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
• Created process definitions and new run control pages, components to run different reports and processes PeopleCode 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.
• Modified delivered XML Publisher templates PYCHKUSA and PYADVUSA for check printing/ advice from printing specific to client requirements
• Created various inbound/outbound interfaces to send the benefit information to various third party vendors using integration broker.

Environment: PeopleSoft 9.1 HRMS (HR, Benefits, Payroll, T&L, TAM, eDevelopment), People Tools 8.50, SQR, XML Publisher, Windows NT and Oracle 11g, STAT 5.5.2

Confidential, Milipitas, CA

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 during payroll process when the Lock time sheet was activated.
• 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).
• Developed Custom Time and Labor rule for MBC work group to take care of employeesStraight 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 PeopleCode to correct the negative retro amounts for overtime earning codes.
• Configure troubleshoot and support all the tables involved in Payroll processing like Pay Calendar, Pay Earnings, Pay Other Earnings, Pay Special Earnings, Pay Check, Deductions, Taxes, Balances and Processes such as Pay sheet Creation, Pay Calc, Pay Confirm etc .
• Thorough Understanding of Time Admin and all the Sections in it. Good 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 migrating projects from one environment to other using change control request.

Environment: PeopleSoft 8.9 HRMS (HR, Payroll, T&L, eCompensation), PeopleTools 8.49, SQR, Windows XP,PeopleCode,App engine and Oracle 11g, ITSM 5.5.2, Halogen

Confidential, Detroit, MI

PeopleSoft HRMS Technical Consultant

Roles & 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, Component Interface.

Confidential, Iowa

PeopleSoft 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 Troubleshooted the HR issues.
• Involved in Pay Calculation, pay sheet creation process.
• Setting up one time deductions, and Time and Labor dynamic security.
• 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: PeopleTools 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.

Confidential, NJ

PeopleSoft 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, LA, CA

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, 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 there 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

Confidential, NY

PeopleSoft Technical Consultant

Responsibilities:

• Designed new Records, Pages, Components and Menus for the Human Resources Department (HR, Payroll, Benefits) using the various PeopleTools.
• Excellent SQR programming background involving gathering requirements, designing, developing and testing of Interfaces and Reports
• Provided analysis and programming support for Human Resources Information System (HRIS).
• Coded programs with PeopleCode for the validations of the fields for the given records and panels.
• Created number of security Views through PeopleSoft on the Database fields in the secured Pages.
• Made Process Scheduler enabled by creating the Process and Job definitions.
• Job was involved in running the Batch Processes and Night batch Cycles and fix all the errors in the Process scheduler and see that the reports are generated.
• Altered various Records and Panels for the current requirements and done changes accordingly in the database.
• Created various SQRs required for generating the reports according to the requirements and specifications of the client.
• Modified various existing SQRs for generating required output as per the client.
• Designed Shell Scripts in UNIX for the FTP of the output generated by the SQR reports to various servers of the client.
• Done Migration of the Projects from one Database to another.
• Designed, Tested, debugged the projects in Development, and moved them to Production successfully
• Job also includes in maintaining all the Server files in the Production and sees the reports run successfully and generate the required output
• Rigorous work in PeopleTools, PeopleCode and SQR Report Writer.
• Developed and customized several complex SQR reports and interface programs in the Human Resources, Benefits Administration and Payroll modules.
• Developed new and customized existing PeopleSoft panels
• Provided technical support during open enrollment process and benefits administration
• Strong Oracle and SQL Plus skills
• Assisted in the analysis of SQR code for upgrade to PeopleSoft 8.01 and modified SQR has to be 8.01 compatible.
• Customized Job function table, Department code table and Educational sponsorship (new pages)

Environment: PeopleSoft 8.8 HRMS (HR, Payroll, Benefits), PeopleTools 8.42, SQR, Windows NT, Oracle 8i