SUMMARY:

• Over Ten (10+) years of extensive and progressive experience in Implementation, Customization, Upgrade and Development of PeopleSoft HRMS 9.1/8.9/8.8/8.3/7.
• Proficient in PeopleTools - Application Designer, Application Engine, Upgrade Assistant, Change Assistant, Component Interface, ExceltoCI, Process Scheduler, Security Administrator, Object Security, Query, Tree Manager, Form Builder, PTF.
• Extensive experience in the areas of Design, Fit-Gap analysis, Development, Implementation and Unit Testing.
• Proficient in using PeopleSoft Internet Architecture (PIA) and People Tools.
• Possess strong Technical knowledge of various modules in PeopleSoft such as Human Resource, North American Payroll, Payroll Interface, Benefits, Benefits Administration, Employee Self-service (ESS), Accounts Receivable, Asset Management, General Ledger, ELM, Travel & Expenses, ePerformance.
• Proficient in the creation of complex reports using SQR, Application Engine, Crystal reports and XML Publisher.
• Strong exposure to RDBMS and Client/Server architecture concepts.
• Extensively involved in troubleshooting and fixing problems at development, system testing and post-production stages for various HRMS modules.
• Good understanding of Peoplesoft Security and 8.48 Integration tools.
• At ease in high stress environments requiring superior ability to effectively handle multi-task levels of responsibility.
• Excellent communicative, interpersonal, fast learning, intuitive, analysis and leadership skills.
• Proven ability to work efficiently in both independent and teamwork environments.
• Energetic and perseverant self-starter who is known for exceeding goals and objectives.

TECHNICAL SKILLS:

ERP: PeopleSoft Versions 8.x/7.5, Confidential Versions EHRMSV3, EHRMSV4, Kronos 6.0/6.2

PS Tools: Application Designer, Application Engine, PeopleCode Debugger, Application Messaging, PS Query, Crystal Reports, SQR, Process Monitor, Change Assistant, Process Scheduler, Data Mover, Component Interface, Integration Broker, Object security, Workflow, EDI Manager, Integration Broker and XML Publisher.

Confidential Tools: EBuilder, Ecode, ReportSmith, SQR, Confidential Process Scheduler, Confidential Process Monitor

Kronos: Kronos Advanced Reporting tools, Kronos Interface, WTK 6.0 managing Timecards & Preparing Payroll.

PS Modules: HR, Base Benefits, Benefits Admin, Payroll, Time & Labor, Pension Health and Safety, Employee Self Service, ELM, Manager Self Service, GL, AR, Workflow.

Languages: PeopleCode, SQR, SQL, COBOL, Java, Java Script, TCL,JCL.

RDBMS: Oracle 9i/8i/7.x, MS SQL Server 2000/7.0, DB2, MS Access.

Operating Systems: UNIX, Windows 98/NT/2000/XP, MS-DOS 6.22, Linux.

Tools: CVS, Visual Source Safe, STAT 4.1.6, Citrix, Ultra Edit.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Systems Analyst

Responsibilities:

• Played a key role in running the conversion scripts using Change Assistant to upgrade the People Tools from 8.44 to 8.49 on multiple environments successfully.
• Involved in full life cycle of PeopleSoft Finance application upgrade from 8.19 to 9.0 .
• Involved in retrofitting custom SQRs, PeopleCode, Application engines.
• Involved in system testing, integration testing and parallel testing.
• Extensively worked on PeopleCode, SQR, Application Engine, Component Interfaces, ExceltoCI utility, Linux scripting, Data Mover and SQL developer.
• Played vital role in PeopleSoft HCM application from 8.8 to 9.1 upgrade and involved in full life cycle of upgrade.
• Organized the Fit-Gap sessions and identified customizations those need to be retrofitted.
• Implemented Person model by converting holding employees (legacy system is Confidential ) as contingent workers into PeopleSoft.
• Extensively used ExceltoCI utility in loading contingent, persons of interest, converting pay periods of SNA paygroup, loading Content Items, Security User Profiles and non-person profiles.
• Extensively involved in system testing, integration testing and parallel testing the HCM upgraded application.
• Played a key role in full life cycle ePerformance Implementation in PeopleSoft HCM 9.1.
• Played a key role in requirements gathering, designing the ePerformance system, implementation and testing.
• Customized the Nomination process of participants as per the business needs.
• Implemented AutoSave functionality in ePerformance using JavaScript.
• Extensively worked on Application Engine file layouts to upload the employee addresses into personal data, upload Retro Pay for various pay groups and uniform allowances for 1199 employees.
• Created the Managers Performance Evaluations training material and actively participated in training the managers.
• Modified Direct Reports API to meet the business requirements.
• Updated the position management ‘Report To’ to build the Org Charts and to identify the Direct Reports Manager for Self Services.
• Implemented the Profile Management and created the custom program that creates the Non-Person profiles by jobcode, position and with Responsibilities.
• Created a custom Application Engine that generates the account and department combination codes in HCM 9.1 to support Payroll to GL interface invoking CI.
• Defined new ExceltoCI templates to load the Content Items and non-person profiles as a part of ePerformance implementation.
• Created HR, Benefits, Payroll interfaces to multiple third party systems(Kronos, Vac Seen, COBRA Vendor, Net Learn, Benefits Vendors)
• Configured and set up the system to generate HIPAA EDI 834 files for multiple benefit vendors.
• Created a custom program to generate Org Charts calling Visio tool.
• Created custom security roles, permission list and implemented row level security for ePerformance users.
• Played a key role in converting the pay frequency for SNA employees from 52.2 to 52 weeks.
• Implemented various pay components to track the amount paid when physian assistants worked moonlight shifts.
• Created payroll (inbound), employee (outbound), leave accrual (inbound) interfaces between PeopleSoft and Kronos.
• Timely apply bundles as and when released by Oracle and Tax Updates for Payroll.
• Played a key role in converting physian assistants from MX to MP Paygroup.
• Support Kronos timekeepers helping them in editing their employee’s timecard as per schedule, creating user accounts and providing access to hyperlinks.
• Works with DBA and Sysadmin in Performance Tuning and Process Scheduler issues.
• Created a custom interface in Kronos using workforce connect 6.0.7 to upload the agency and traveler file into Kronos.
• Actively participates in user groups, Presented “ePerfromance Implementation” at 2013 HIUG Interact.
• Attends the conference/summit to gain knowledge on advanced technologies and share the information with the team and Senior Management.
• Implemented A-Form using Form builder.
• Implemented dynamic user profiles creation using LDAP.

Environment: PeopleSoft HCM 8.8/9.1, PeopleSoft Finance 8.9, SQR, PeopleTools 8.44/8.49/8.50, Oracle 8i/9i/11g, Windows 2000/NT 4.0, UNIX, Linux.

Confidential, NJ

Sr. PeopleSoft Technical Consultant

Responsibilities:

• Involved in customization and implementation of PeopleSoft 8.9 (Compensation, Payroll)
• Extensively worked on PeopleCode, SQR, Application Engine, PeopleTools, Application Designer, UNIX, Data Mover and SQL Loader.
• Involved in upgrading PeopleTools from 8.44 versions to 8.49 versions.
• Involved in implementing the Field level security (which is basically PeopleSoft 9 version feature) in PeopleSoft 8.9 version for compensation.
• Works closely with the Business Analyst in understanding the Functional requirements.
• Presents the high level design to the Users as per the requirements.
• Developed SRA Update page with the staging tables for the system administrators.
• Written night batch process SR408 (using SQR, UNIX Shell Script) to refresh base tables with the staging tables, initializes the staging tables with base tables and generates the outbound report of the processed records.
• Developed Assign Special Role Reviewer page for SRR/PL to define criteria for their set of people.
• Written night batch process SR404 (Security process), which builds the dynamic clause based on the criteria defined by SRR/PL on Assign Special Role Reviewer page and generates population for SRR/PL.
• Developed Auto Role Assignment (Application Engine), which assigns security roles to users in PS Security tables based on the customized SR security tables.
• Worked closely with DBA as part of performance tuning to cut down salary plan refresh process time by creating the Indexes on the rollup tables and base tables.
• Implemented Ad-hoc Load of the CSD Market Data Input Files to their respective tables following the parent child relationship among the tables and validating the input data.
• Implemented Secondary HRM concept in the compensation module.
• Developed Merit and VC Guidelines run control page for the users to upload Bonus amount, percent to PS PM Salary plan table by meeting different criteria.
• Developed SQR program to upload Merit and VC Guidelines input data.
• Developed various run scripts to FTP the Input/Output files from/to shared drive; to Archive the files; Email the log/lis files to users; to cleanup the sensitive data files from shared drive.
• Provided technical support to testers and team members. Extensively provided technical support for the on-line Batch processes during Conversion.
• Audited & documented changes made to the PeopleSoft HRMS - Salary Review systems.
• Involved in preparing Design document and Technical Specifications
• Created test cases and worked closely with Dallas QA Team and Users for QA, Pre-UAT and UAT.
• Provided technical support to resolve production issues reported by End-Users.

Environment: PeopleSoft 8.9 (Compensation, Payroll), SQR, PeopleTools 8.49, PeopleCode, Component Interface, Application Engine, PS Query, Oracle 8i/9i, Windows 2000/NT 4.0, UNIX.

Confidential

Technical Consultant

Responsibilities:

• Involved in standardizing SQRs and SQCs from HRizon version 8 (V8) to Confidential Enterprise HRMS Version 4 (EV4).
• Involved in standardizing and upgrading of more than 100 SQRs to EV4.
• Developed new SQRs and upgraded existing SQRs with respect to the upgraded version.
• Developed payroll inbound Interfaces and outbound interfaces.
• Implemented parent/child relationships; normalization to the upgraded version (EV4).
• Created Run Control records and Run Control panels using Ebuilder to run SQRs through Process Scheduler and used Process Monitor to view the status of the process.
• Added new fields or renamed existing fields to the existing records.
• Involved in creating new Panels through Ebuilder and written Ecode to implement business rules.
• Involved in adding or renaming the tables.
• Involved in preparing Design document and Technical Specifications
• Involved in Unit Testing and providing support to the QA team for System Integration Testing.
• Provided training to the new joiners on Confidential proprietary tools.

Environment: Confidential Enterprise HRMS Version 4(HR, Payroll, Benefits), SQR, Ecode, Ebulider, Oracle 10i, Unix/Solaris, UltraEdit.

Confidential

PeopleSoft Developer

Responsibilities:

• Involved in analysis, design, complete conversion, several development areas, interface, and upgrade for PeopleSoft HRMS implementation.
• Involved in customization of several application Pages and Components and People Code to run the PeopleSoft online application using People Tools and Application Engine.
• Wrote Conversion SQR Programs to convert data from legacy to the PeopleSoft tables.
• Designed and developed SQR inbound and outbound interfaces batch applications and report programs to enable them to run from PeopleSoft on-line panels.
• Developed several new conversion programs for flat file creation by mapping between the PeopleSoft systems during the conversion process.
• Worked on Component Interfaces to integrate with the third party systems.
• Migrated PeopleSoft Objects between different Databases using Application Upgrade and also migrated pre-calculated payroll data from testing to production database using Data Mover Scripts.
• Successfully executed interface SQR’S related to upgrade changes by creating test scripts to validate data results.
• Extensively involved in the Data conversion of the HRMS tables from the legacy system to the PeopleSoft database using File Layout and Application Engine combination and some of the tables with Component Interface and Application Engine.
• Used Mercury testing tools to test developed applications.
• Provided technical support to testers and team members. Extensively provided technical support for the on-line Batch processes during Conversion.

Environment: PeopleSoft 8.8/8.9 (HR, Payroll, Base Benefits, Ben Admin, Time&Labor), SQR, PeopleTools 8.43/8.47, PeopleCode, SQL Server 8.0, Windows 2000/NT 4.0, MS Access.