PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

PeopleSoft HCM Analyst/Programmer

Responsibilities:

• Designed and coded enhancements to PeopleSoft Human Resource Management System (HRMS), Employee Self Service (ESS), and Enterprise Learning Environment (ELM).
• Completed application upgrades HCM 9.1/8.52 to 9.2/8.55.
• Ran compare reports, analyzed custom functionality for upgrade.
• Converted existing crystal reports to BI Publisher reports.
• Created Customized WorkCenters and Pagelets.
• Currently working on ELM Upgrade 9.1/8.52 to 9.2/8.55.
• Developed and Customized Time and Labor rules which included Holiday, Weekly Threshold, Daily Threshold, Day Breaker Rules.
• Developed Fluid Pages using HMTL5, CSS3 in 8.55 tools for Talent Profiles & Learning Dashboards.
• Designed and created Interface between PeopleSoft and third party using RESTful Web services.

Environment: PeopleSoft 9.1/9.2 Tools 8.55, Oracle 12c, UNIX

Confidential, Madison, WI

PeopleSoft Campus Solutions Analyst/Programmer

Responsibilities:

• Created Dynamic Security Roles, Permission lists, Row level security and attached them as applicable to maintain data security for the components.
• Did Unit Testing, Functional and Integration testing for custom/customized objects in 9.0. Also helped the users in the functional and UAT testing.
• Configure and Tested Integration broker HCM and Campus Solutions.
• Integrate PeopleSoft Student Admin & Campus solutions with 3rd party AVOW system by providing Web services for Student check & Transcript ordering using Soap xml messages.
• Supported Campus Solutions Student Records and Student Financials technical needs including developing SQR’s and BI Reports. Converted several custom Student Financials crystal reports to BI Publisher reports

Environment: Campus Solutions 9.0 Student Records, Admissions, Campus Community, Student Financials, 9.2 Upgrade, PT 8.53.08, Oracle 12g, Stat 5.7.4Confidential, Minneapolis, MN

Senior PeopleSoft HCM Analyst/Programmer

Responsibilities:

• Performed upgrade and customization of HR, NA Payroll, Benefits and Self - Service Modules using PeopleSoft 9.2 PeopleTools 8.52/8.54
• Retrofitting and customizing Peoplecode and Application Designer objects to implement business logic, validations and GUI for PeopleSoft HCM v9.2 application.
• Involved in setting up Integration between PeopleSoft and Taleo Recruiting using Integration Broker and WebServices.
• Implemented Manager Dashboard and Company Directory.
• Regular Open enrollment support and year-end support to payroll.
• Developed new interfaces for Benefits for 401K, Pension Plans and BCBS interfaces.
• Created several reports using XML Publisher, Application Engine, PS Query and SQRs.
• Modified Employee Self-Service and Manager Self-Service in PeopleSoft to add new pages to allow employees to enter and maintain Prior Work Experience, Education, Honors and Awards, Languages, Licenses and Certificates, and Memberships.
• Developed a new custom page to allow HRIS and HR Business partners access to manager notes in ePerformance for an employee.
• Used BI Publisher to generate multiple reports using the same template and distributed to respective department liaisons.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked during the development phase of the project to make customizations using PeopleTools, Peoplecode SQR, Hyperion and other tools
• Worked on component interface and Peoplecode relating to HR and Campus solution Personal and bio demographic data.
• Involved in design and development of new program relating to Federal Work Study Program for Campus Solution students who are paid through the HR system.
• Create test data for campus solutions and use of such data for interfaces and reports used by the HR systems.
• Personal Audit program and Position Data Information interfaces.
• Developed sqr program to auto load new hire data for the purpose of testing of interfaces, reports and online functionality.
• Worked on ELM Training and Course Reports, Result tracking etc.
• Used application upgrade to compare the code in different environments and use of data mover to move table data.
• Worked on applying the customizations and migration of projects between different environments. Involved in the testing of Campus community, Student Admissions and HR areas. Worked on Hyperion reports.

Technical Environment: PeopleSoft HCM and Campus Solutions 9.00.00, HRMS, Base Benefits, Payroll and Benefits, Campus Community, ELM, Student Admissions, SQR for 8.4 6.16, Oracle 9.x, UNIX, People Tools 8.49Confidential, Arkansas

PeopleSoft Analyst Programmer

Responsibilities:

• Created Component Interface/App engine to load employee data of newly acquired companies.
• Using Peoplecode, Application Engine, and SQL Objects, completed numerous complex customizations and modifications related to the Time & Labor module. Adding new Time Reporting Code functionality to the delivered Punch Time and Schedule Shift Pages/Panels.
• Conducted detailed design sessions with the Functional team to clearly define requirements and deliverables related to all Customizations and Modifications.
• Worked extensively with the Employee Self Service as well as the Manager Self Service pieces of PeopleSoft as part of the Customization/Modification work.
• Implemented the Garnishments to AP interface form HCM to PS Financials Accounts Payables.
• Worked on reports relating to employee benefit plan changes, HMO terminations.
• Customized various Reports related Payroll and Benefits. Customized existing workflow for New Hire and Termination and setup the roles to receive email notifications and worklists from these events. Developed new workflow activities and events to notify events. Worked on Application Engine, used Component Interface programs to load data from legacy system to the PeopleSoft system.
• Created new reports using BI publisher. Created PS query and XML data sources.
• Setup Integration broker between Finance and HR modules to send Department updates.
• Detailed impact analysis was done to identify the objects, compared between old and new model to retro fit. All customized objects were identified, exported and migrated.
• Detailed testing was planned at various stages, executed and results were validated before releasing the system to users.
• Responsible for daily batch jobs related to loading and processing of Payroll and third party Journals which are scheduled through Autosys.
• Responsible for production issues related to Payroll processes.
• Setup Payroll tables and to setup new pay groups and pay calendar and pay run ID etc.
• Daily interaction with customer for issues related to journals and Deal/Cash management.
• Assisted users in GL year end close process and IRS 1099 processes.
• Customized and supported SQR reports for GL, AP and TR. Setup up new Autosys boxes.
• Wrote Chartfield validation routines for non-PS applications which send accounting transactions to GL. Assisted users with month end close and Journal related issues.
• Used Informatica ETL process to load PeopleSoft data into Data warehousing

Environment: PS HCM 9.1 /Financials 9.1, Tools 8.51/8.52, and Oracle Unix/NT, Informatica

Confidential, Atlanta, GA

PeopleSoft HRMS Techno functional Consultant

Responsibilities:

• Customized ePerformance, this project involved different performance and development documents to support annual performance appraisal.
• Worked on new SQR reports like vacation advance, end of year leave pay out reports and adjust or separate workers compensation to update the Paysheets.
• Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Created ad-hoc reports, queries, Run Control Pages as per. Tuned long running PS queries.
• Developed an application engine program to create security interface file with all terminated employees information after each pay period and sent to the information security department
• Developed SQR reports that displays leave accrual information by leave plan and employee. It includes information such as plan year eligibility hours, carryover hours earned year-to-date, hours taken year-to-date, and remaining leave balances.
• Worked on self service module, also worked on customizing pages related to the Incident data of the Health and Safety module. Worked to create new pages, views and Peoplecode to calculate the override rate for employees working out of class.
• Multilanguage Support Conversion: This Project is converting entire PeopleSoft Financials Applications to support Multilanguage. All customized PeopleSoft Objects including SQRs and Crystal Reports are converted using Message Catalogs and String Tables. Working as team lead guided developers in Converting, testing and migration.

Environment: PeopleSoft 8.8 (HRMS, Payroll, Time and Labor) 8.8 PeopleTools 8.44 SQR, Oracle 9.2Confidential, Michigan

PeopleSoft Technical Consultant

Responsibilities:

• Definition Security: Implemented Definition security for all PS Queries.
• Wrote Audit Reports using SQR which generates pipe-delimited outputs for audit purpose.
• Modified Component interface to update Expense tables from HRMS.

Environment: PeopleSoft HRMS 8.8, SQL server

Confidential, NYC

PeopleSoft Technical Consultant

Responsibilities:

• Created new SQR’s and Crystal Reports and PS queries to enhance user’s functions.
• Developed and prepared test plan/scripts for manual testing.
• Conducted System tests for release to production.
• Execute the test scripts, logging defects. Resolved issues and problems for the Customers.
• Primary responsibilities were the analysis, documentation, modification and unit testing of SQR programs that are critical to daily payroll and benefit processes. The project also involved extensive testing in terms of ensuring the functionality for HR and Payroll Modules. Used SQR to customize and develop new programs according to the client requirement. Generated various reports using SQR and Crystal Reports.
• Created complex revenue reports for GL and Projects. Troubleshooted issues in AR, Billing, Projects and Contract modules. Provided production support for AR and GL. Support involved daily monitoring AR batch processes and data flow through GL, responsible for lockbox deposits and bank file loads.
• Interaction with business community related pending Items, applying payments and various reports. Wrote custom adhoc queries related to customer and Items. Issued related to AR UPDATE and accounting line entries.
• Configured Journal Gen Template and AP Definition to summarize to Chartfield level for specific accounts. Created custom pages like Mark Journals for deletion page
• Definition Security: Implemented Definition security for all PS Queries. Wrote Audit Reports using SQR, which generates pipe-delimited outputs for audit purpose.
• Confidential implemented custom CRM application using PeopleSoft CRM, for commercial clients for credit approval process. Working as PeopleSoft Developer wrote custom Peoplecode and reports.

Environment: PeopleSoft Financials/HCM 8.4, and DB2

Confidential, Ann Arbor, Michigan

PeopleSoft Developer

Responsibilities:

• Created process definitions and new Run Control Pages, Components to run different processes and nVision Reports, to create GL reports using Matrix and Tabular layouts.
• Created the SQL Queries using PS/Query tool and used the Queries to generate Reports using Crystal Report tool. Created new reports using SQR and Crystal for GL.
• Performed Unit Testing for PeopleSoft Financial Modules AP, AR, BI and GL.
• Customized the modules using People Code and various People Tools, which included creating panels, records and menus. Created end-user training documentation,