SUMMARY

• 14+ years of experience in software analysis, design, development, and testing of People soft and Mainframe applications.
• 14 years of experience in complete PeopleSoft Implementations involving, Requirements analysis, Fit - Gap-Analysis, Specification, Design, Development, Conversions, Upgrade, Maintenance and Performance Tuning.
• Possess good Functional and Technical knowledge of various modules in PeopleSoft +such as Human Resource, Payroll, Benefits, Benefits Administration Time & Labor, Employee Self-service (ESS), Manager Self-service (MSS).
• Well conversant with documentation for specifications, developing test cases, technical de and writing training manual for end users.
• Involved in implementation, customization, upgrade and maintenance of HR, Benefits, Benefit Admin, Payroll, Time & Labor and Self Services modules (eRecruit, ePay, eProfile, ePerformance, eCompensation and eBenefits).
• Extensively worked on People Tools, People code, Application Designer, SQR, Maintain Security, Object security, Tree Manager, Process Scheduler, Component Interfaces, Data Mover, Application Messaging, Application Engine, Workflow, Component Interfaces, Integration Broker etc.
• Expert in PeopleSoft Internet Architecture (PIA) and Open Integration Technology tools Application Engine, Component Interface, Application Messaging. Good working knowledge in Configuration, Coding and Set up of Integration Broker and Experience in developing custom web services between PeopleSoft HCM and a third party applications.
• Extensively used reporting tools such as PS Query, SQR, XML Publisher, Crystal Reports and nVision to continually improve the reporting experience for the user base.
• Developed new SQR’s from scratch to meet the customer requirements and supported the customization. Developed and modified Outbound and Inbound SQR interfaces
• Extensively worked on implementing updates/fixes and upgrades for PeopleSoft applications and People Tools.
• Good working Knowledge in RDBMS systems Oracle 12c,9i/10g, DB2 v8, SQL Server 2005.
• Worked individually, as well as in team environment, to achieve project goals.
• Skilled at building a strong team environment and can acclimatize to new technologies and situations with ease.

TECHNICAL SKILLS

PeopleSoft: PeopleSoft v 9.1/9.0/8.9/8.8/8.3/8.0

Modules: HR, Payroll, Benefits, Benefits Admin, Time and Labor, Self-service (MSS&ESS)

People Tools: Application Designer, People code, App. Engine Program, Component Interfaces, Process Scheduler, Application Package, Workflow, Query, Activity Guide Composer, Page and Field Configurator, Related Content, Drop Zones, Event Mapping, Maintain/Object Security, Data Mover, Change Assistant, Application Messaging, Integration Broker, Web Services, etc.

Reporting: SQR, PS Query, XML Publisher, Crystal Report, nVision.

Languages: COBOL, C, C++, Java, HTML, XML, PERL, SQL & PL/SQL

Operating Systems: UNIX, AIX, HP-UX, Win 98/NT/2000/XP, IBM-Compatibles, MS-DOS

IBM: COBOL, DB2, JCL, MVS, TSO/ISPF, ENDEVOR, Changeman, CA-7, etc.

Database Systems: Oracle 9i/10g, DB2 v8/9, SQL Server 2005.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Sr. PeopleSoft Programmer Analyst

Responsibilities:

• Functional/Technical production support for 9.1 Time and Labor Implementation for hourly population in multiple divisions and multiple states.
• Involved in Requirements gathering, design function/technical specs for rewriting legacy Time Attendance reports into PeopleSoft TL Module. and testing
• Analyzed the mainframe legacy T&A reports and converted them to PeopleSoft system.
• Configure and customized the Open Enrollment fluid activity guide for open enrollment 2021 requirements.
• Designed and developed Health screening Fluid Custom Tile as per Business needs in Employee Self-service module.
• Reapplied customizations around PUM37 upgrade effort using PeopleSoft page field configurator, Event mapping, Drop Zones frame works concepts to isolate the customizations.
• Configured the Job data modernization Fluid tiles as per business needs.
• Worked on configuring Job data Activity Guide template, which involves configuring the page filed configurator set up for Action/action reason combinations as per business requirements.
• Designed & developed the CA pay Data Interface files as per the state requirements.
• Designed and developed TL leave accrual sync process to match the leave accrual balances with TL COMP LEAVE TBL data.
• Involved support for integrating from Cesium Time Clocks into Time and Labor via Integration Broker.
• Worked on PeopleSoft and TCD interface integration by configuring PeopleSoft Integration Broker.
• Defined an external Node for third party and enabled necessary routings for transactions.
• Configured Services, Service operations, Queues, Messages, Routings, Handlers, etc for T&L.
• Involved in setting up Batch Publish Rules for the necessary messages.
• Involved in testing of TIME DEVICE EMPL ATT FULLSYNC by using full data publish and Incremental sync (TIME DEVICE EMPL ATT SYNC) by changing Time reporter information.
• Developed custom rules to fully meet the business needs relating to Midnight Day Breakers, Work Shifts crossing over day breaker and workday schedules crossing day breakers.
• Setting up the configurations for PeopleSoft 9.1 Time and Labor, NA Payroll.
• Setting Time Reporting codes (TRCs), Compensatory time off plan, Work Groups & Task Groups.
• Developed complex custom Time and Labor rules to calculate Late In, Excess Meal & short break, where the associates work in cross over shift and consists multiple login and logout on same day.
• Performed design of reports for the HR, Time & Labor using SQR, PS/Query based on organizational needs.
• Created Batch process application engine for Enrollment of Associates into Time and Labor.
• Extensively worked on rule performance and compilation of rules in Time and labor.
• Created Test Scenarios/Cases for the different TL rules and Tl custom reports testing.
• Providing production support for TL module.

Environment: PeopleSoft v9.1 (HR, Benefits Admin, Payroll, TL), People Tools - 8.52, STAT, Win-NT/Linux, Oracle, PL/SQL Developer, Service Center.

Confidential, Portland, OR

Sr. PeopleSoft Programmer Analyst

Responsibilities:

• Involved in Requirements gathering, design function/technical specs for replatforming the legacy payroll system into payroll for north america and testing
• Analyzed the mainframe legacy system jobs to replatform and converted them to PeopleSoft system.
• Designed and developed several conversion processes to convert mainframe legacy system data into PeopleSoft system.
• Converted client legacy payroll processes which create pay sheets in legacy payroll system into PeopleSoft.
• Replatformed legacy programs into SQR’s and that involved in converting the DB2 version SQR’s into Oracle version SQR’s.
• Involved in replatforming the CA7 JCL’s to PeopleSoft process scheduling jobs.
• Designed and developed new custom pages, records, components as a part of replatforming project.
• Analyzed compare reports to determine objects to carry forward during the upgrade effort.
• Retrofitting of both online and batch objects, (i.e., pages, fields/records, modified People Code, App. Engines, SQR, SQL, Crystal reports etc.) through patch application and/or application development.
• Involved in enhancement for implementing new Retirement savings plan in current peoples soft 8.9 system and retrofitted that customization for 9.1.
• Modified the SQR processes which calculate the basic compensation and transition compensation percents that updates custom retirement savings plan table to support new retirement benefit plan.
• Designed and developed liability reports for newly introduced retirement benefit plan for users.
• Involved in several 8.9 product support defect fixes and retrofitted them into 9.1 environments.
• Created Test Scenarios/Cases for the different HR, Benefits, Payroll, Self Service and Interface requirements.
• Worked with Testers by going through the SharePoint defect tracking application for defects to fix them during System Integration testing, User acceptance testing and parallel testing phases.

Environment: PeopleSoft v8.9-9.1 (HR, Benefits Admin, Payroll), People Tools - 8.52, STAT, Win-NT/Linux, Oracle, DB2, OS390, JCL, TSO/ISPF, COBOL/EZT, WinSql/Command Editor and SQL Developer.

Confidential, Pleasanton, CA

Sr. PeopleSoft Programmer Analyst

Responsibilities:

• Involved in Requirements gathering, design technical spec for customization, build customization and testing for customizations.
• Created Test Scenarios/Cases for the different HR, Benefits, Payroll, Self Service and Interface requirements.
• Worked with functional analysts to determine what customizations were needed for the new release and reinstated the pertinent customizations.
• Analyzed existing customizations in 8.8 and documented the changes required for new release.
• Analyzed compare reports to determine objects to carry forward during the upgrade effort.
• Retrofitting of both online and batch objects, (i.e., pages, fields/records, modified People Code, App. Engines, SQR, SQL, Crystal reports etc.) through patch application and/or application development.
• Reconfigured and tested Integration Broker setup for HCM integrations to make it work In 9.1 environments.
• Worked on retrofitting both on line and batch objects for subsequent release changes.
• Involved in JCL’s, ParmLib’s, COBOL Validations b/w Dev, System, UAT, Prod environments
• Involved in analyzing the UPG BN88 & UPG BN89 conversion app. engines to fix the dependent data conversion issue in benefits module.
• Worked with Benefits Functional team to prepare scripts that would help them to compare data in tables between two environments.
• Worked on fixing the issues with Benefits Snapshot process, Enrollment process, and Confirmation processes during System integration testing.
• Developed data unscrambling programs for benefits interfaces data for vendors testing in UAT by submitting batch job JCL’s.
• Designed and Developed the Hewitt Inbound pension interface for HRA project.
• Designed and developed Health reimbursement account project which involves developing the custom page, component, menu as per business requirement.
• Designed and developed Ceridian Outbound interface as per business requirement.
• Worked on Custom PeopleSoft Leave accrual system project to support some business processes such as leave elections, Cash out process, etc.
• Designed and Developed several data conversion processes to support the customizations.
• Designed and Developed XML publisher reports as per business requirements.
• Worked on preparing CSR’s to migrate the code from Development to Test environments using Stat.
• Involved in preparing Implementation plan documents for the changes service requests that are prepared by using Remedy IT service management tool.
• Worked with Testers by going through the Quality Center defects to fix them during System Integration testing and User acceptance testing phases.

Environment: PeopleSoft v8.8-9.1 (HR, Base Benefits, Benefits Admin, Payroll), People Tools - 8.45/8.50/8.52 , Remedy, STAT, Quality Center, Win-2008, DB2, OS390, JCL, TSO/ISPF, WinSql

Confidential, Cleveland, OH

Sr. PeopleSoft Consultant

Responsibilities:

• Conversion and implementation of PeopleSoft 8.9 (HR, Payroll, T&L, Benefits, Self Service).
• Involved in requirement analysis sessions for health & welfare, 401k, Total rewards projects.
• Worked with functional analysts in gathering the requirements for converting the third-party vendor interfaces according to requirements.
• Involved in Taleo data migration to load data from excel sheets to load it into oracle database.
• Designed & developed an SQR process to read the payroll instructions files for a third-party vendors called Hewitt & Travelers into PeopleSoft module.
• Designed & developed an SQR process to write a third-party vendor outbound interface as per Hewitt, Traveler & Mass Mutual vendors as per their file layout formats, which contains amounts that have been deducted from their salary towards their deductions as and when payroll runs.
• Designed & developed an SQR to generate salary & Incentive Database file from PeopleSoft for ecomp module.
• Involved with Functional Analysts to design & develop an SQR processes to process roll over plan in savings plan module when an employee hits their maximum contribution limit as per client business requirements.
• Involved with Functional Analysts to develop several data migration sqls to compare the before and after converted data between Tessreact legacy system and PeopleSoft system.
• Developed ecomp statement custom pages as per new business requirements.
• Modified custom eligible pay compensation app. engine to in corporate new business requirements.
• Responsible for converting interfaces into PeopleSoft from legacy Tesseract system using SQR’s.
• Involved in ExcelToCI process to load the rapid entry data into PeopleSoft environment.
• Involved in preparing the change control package, implementation log for production moves.
• Involved in preparing NDM Unix Scripts and Auto sys Jill scripts for newly developed batch interfaces.
• Involved in Preparing design document & technical specifications.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System testing.

Environment: PeopleSoft v8.9 (HR, Payroll, Benefits, T&L & Self Service), People Tools - 8.49.20, People code, SQR, UNIX, Oracle (TOAD, SQL*plus), Serena Change Control, Tesseract.

Confidential, Chicago, IL

Sr. PeopleSoft Consultant

Responsibilities:

• Worked with functional analysts to determine what customizations were needed for the new release and reinstated the pertinent customizations.
• Analyzed existing customizations in 8.8 and documented the changes required for new release.
• Analyzed compare reports to determine objects to carry forward during the upgrade effort.
• Retrofitting of both online and batch objects, (i.e., pages, fields/records, modified PeopleCode, SQR, AppEngines, Component Interface, Applicaton package etc.) through patch application and/or application development.
• Involved in verification of converted data in the test environments. Worked with conversion team in fixing the data defects found in the test environments.
• Retrofitted, recompiled & tested TL rules using Templates, SQL objects, User Exits during reapplying customizations phase.
• Retrofitted and Tested all TL related online and Batch objects
• Worked on ePay customization for check printing and Advice printing SQR process as per the new business enhancements to make it work as per new release by using XML Publisher.
• Involved in XML Publisher Setup, Modified the Paycheck Template as per new business requirements.
• Worked on MICR code customization for paycheck to apply TROY font by adding the encode parameters supplied by printer vendor and added the font XML Publisher Template to preview.
• Closely worked with DBA’s to rectify performance related issues by analyzing the explain plan results.
• Unit tested using JCL’s & defects fixed for several Batch processes in HR, Benefits, TL & Payroll.
• Involved in Preparing Test Plans & Executing the Test Cases for Unit, System, Parallel and UAT.

Environment: PeopleSoft v8.8-9.0 (HR, Payroll, Benefits Admin, T&L & Self Service), People Tools - 8.49.09/8.49.20 , People Click Recruitng Application, XML Publisher, Change Assistant, Win-XP, DB2, OS390, Unix, JCL, TSO/ISPF, QMF, DB2-Commad Center.0