SUMMARY

• 10 years of experience in PeopleSoft HCM & ELM technology / Workday Conversions this includes Implementation, Customization, Upgrade, Maintenance, Support and Testing.
• Lead Workday Conversion project in multiple phases with 95% data loaded successfully in Phase 1 and rest of data in the subsequent phases.
• Business / Technical Analyst for SOA implementation with Integration to PS.
• Predominantly focused on design, customization and implementation of PeopleSoft HCM Modules (Core HR, Time and Labor, Security, NA Payroll, Profile Management, Workforce Administration, Absence Management), PeopleSoft ELM.
• PeopleSoft Enterprise 9 HCM Human Resources Consultant Oracle Certified Expert.
• Worked on PeopleSoft ELM - Catalog Management, Learner Groups, and Learning Environments.
• Responsible for leading and Executing of Data Conversion and migration of legacy training systems into ELM including validation and reconciliation.
• Experience in 2 complete Life Cycle Development Projects, including PeopleSoft HCM 9.0 & 9.1 Implementations. (Modules: Workforce Administration, NA Payroll, Base Benefits, Profile Management, performance and Time and Labor) and 2 upgrade projects 8.9 to 9.1 HCM & 8.8 to 9.0.
• Worked extensively o People Tools People Code, Application Engine, Component Interface, File layouts, Integration Broker, PS Query, SQR and BI Publisher.
• Hands on Experience on PeopleSoft Internet Architecture PIA such as app server, PIA, Process Scheduler, web server.
• Fit-gap analysis, design, development and enhancement of PeopleSoft applications.
• Extensive knowledge of full Software Development Life Cycle (SDLC) & methodologies.
• Experienced in regression testing, functional testing, back-end testing and interface testing, Operational and Load & Performance testing.
• Proven Experience in all phases of ERP lifecycle Upgrade, Implementation, Conversion, Interfaces, Production support and troubleshooting of PeopleSoft applications release 9.x /8.x.
• Involved in development and customization of interfaces and reports using Application Designer, Integration Tools, and Reporting Tools like PS Query, SQR’s, BI Publisher.
• Well versed with Debugging tools like SQL trace, PC debugger and AE trace for troubleshooting and Performance Tuning.
• Trained fresher’s on HCM technical and Functional Concepts.
• Received STAR, EGDE, ACE awards.
• Proficient in all phases of the systems development life cycle including requirements definition, data conversion, system implementation, system testing & acceptance testing.
• Experience in preparation and execution of test plans, technical and functional specifications and review of deliverables.
• Excellent team player with strong analytical skills, good interpersonal, communicational skills and quick learner.

TECHNICAL SKILLS

PeopleSoft Applications: PeopleSoft HCM 9.1/9.0/8.9/8.8/8.3/8.0

Operating System: Win2K, Win2K3, Win2K7, UNIX

PeopleSoft Tools: 8.x, Application Designer, Configuration Manager, Tree Manager, Query Access Manager, Process Scheduler, Process Monitor, Application Engine, PeopleCode, Component Interface, File Layout, Application Messaging, Data Mover, Security Administration, Pagelets, Integration Broker and Approval Workflow Engine

Reporting Tools: SQR, PSQuery, BI Publisher

Knowledge Domain: HCM

Database: ORACLE, MS SQL Server

Migration Tool: STAT

Web Development Tools: HTML5

PROFESSIONAL EXPERIENCE

Confidential

Manager

Responsibilities:

• Lead the functional team during discussions for company Acquisition and Benefits implementation using PeopleSoft.
• Involved in meetings with users to understand the business requirements and documented technical Specifications for development team.
• Involved in Setting up Core HR Set ups (Company, Location, Departments, Jobcodes, Positions, Bargaining Units, Unions, Sal Admin Plans, Grades ..) during the Acquisition process.
• Gathered the requirements & designed and developed interfaces with Third Party Vendor applications.
• Extensively worked on Modifying and Creating App Packages. Validated and moved applicant data from PeopleSoft Core HR modules using App Packages.
• Trouble shooting HR and Payroll issues as part of N/A payroll support for Semi-Monthly, Bi-Weekly and T&E payrolls in order to confirm the checks in the timely manner.
• Extensive experience in testing of NA payroll issues while running pay calc and confirm payroll, ability to diagnose an issue, and execute driving towards a resolution and fixing issues on time to meet clients SLA.
• Maintained and Modified ADP interfaces Quarterly (PBZQTR.sqr) which runs every quarterly and Periodic extract (PBZPER.sqr) which runs after every pay confirm based on Run ID to send tax related information.
• Involved in the functional aspects of NA Payroll Testing.
• Worked on North America Payroll while testing Tax Updates to ensure the integration of the system with the new delivered patches and bundles.
• Worked on testing Tax updates and Patches.
• Developed SOAP Based integrations for integration of PeopleSoft Components as Web Services to third Party Applications.
• Developed New SQR’s / Application Engines in order to meet the Business Requirements.
• Modifying & Developing the Peoplecode according to the required customizations & Standards.
• Worked Extensively on ExceltoCI’s for loading the data into Setup and transaction tables.
• Worked Extensively with Component Interfaces, Application packages and App Engine for data loads into PS.
• Scheduling and Re-ordering on Online Batch Jobs for efficient performance.
• Designed technical & functional specification for Benifits implementation.
• Involved in Setting up Benefit Plans, Programs and other required information for Benefits Implementation.
• Extensively worked on Modifying and Creating App Packages. Validated and moved applicant data from PeopleSoft Core HR modules using App Packages.
• Created DMS scripts to move the setup data between environments.
• Used Integration tool, Integration Broker to publish the Employee information from PS HRMS to other Applications.

Environment: PeopleSoft HRMS 8.9 & People Tools 8.49, Oracle 10g,11i. Operating Systems Windows 2003,2007, Unix, STAT, VSS

Confidential, Hoboken NJ

Workday Conversion Lead / Peoplesoft HCM Consultant

Responsibilities:

• Managed Workday Conversion project from WIPRO and successfully completed the project.
• Created Staging tables as per the Workday Design Templates.
• Developed SQR Programs / SQL Scripts which select, transform and load data into Workday Staging tables.
• Generated Scripts which dumps data from Workday Staging tables to CSV file then imported into XLS template provided by Workday.
• Reviewed Staged worksheets from Staging tables and Transmitted to Incoming folder at Workday SFTP.
• Developed SQR Programs / SQL Scripts for Data Reconciliation Which Compares data between Workday Staging tables and PeopleSoft Data in current Production system.
• Created Workday Reports which extracts data from Workday.
• Developed SQR Programs / SQL Scripts for Data Reconciliation Which Compares data between Workday Staging tables and Workday Reports.
• Reviewed differences in counts and Account for errors found in the DCX/iLoad Reports.
• Lead the functional team during discussions for SOA Implementation, position management (key and non-key positions) using PeopleSoft v9.1 as the source data.
• Involved in meetings with users to understand the business requirements and documented technical Specifications for developer team.
• Gathered the requirements & designed and developed interfaces with Third Party Vendor applications.
• Involved in integration of PeopleSoft Components as Web Services to third Party Applications.
• Involved in Implementation of PS to OSB-SOA Integration.
• Scheduling and Re-ordering on Online Batch Jobs for efficient performance.
• Designed technical & functional specification for SOA integration implementation, and Time and Absence for employees to submit Time and Absences.
• Extensively worked on Modifying and Creating App Packages. Validated and moved applicant data from PeopleSoft Core HR modules using App Packages
• Supported reports and HR interfaces like Taleo, New Hire and Department Change reports.
• Developed new queries using BI publisher to replace some SQRs.
• Developed New to SQR’s / Application Engines in order to meet the Business Requirements.
• Worked Extensively with Component Interface, application messaging and App Engines.
• Creating header records, cross-reference records, approval event handler classes, adhoc packages, thread classes; user lists generic templates (e-mail temp).
• Worked with the functional resource in setting up the process definitions in Approval Workflow Engine for address change, location change transactions.
• Created Dynamic Security Roles, Permission lists, Row level security and attached them as applicable to maintain data security for the components.
• Developed Outbound Interfaces for sending the paid data to the III Party vendor for further verification.

Environment: PeopleSoft HRMS 9.1 & People Tools 8.52, Oracle 10g,11i. Operating Systems Windows 2003,2007, Unix, STAT, VSS

Confidential, MN

Peoplesoft HCM / ELM Consultant

Responsibilities:

• Preparing functional and technical design documentation as part of 9.1 Upgrade, T&L Implementation for Ireland for Version 9.1.
• Involved in Analysis Phase and Estimation during the time of Upgrade and T&L Implementation projects.
• Used Application Engine / Component Interface to load the data into Job record for Acquisitions.
• Development of interfaces and reports using Application Engines.
• Customizations to SQR’s / Application Engines which should be brought forward / Retired during the Upgrade.
• Modifying & Developing the Peoplecode according to the required customizations & Standards.
• Development of New Component Interfaces / Using the Existing CI’s for loading the data into PS tables.
• Conducted internal sessions on the Complex Work Units which helped the team in understanding the functionality.
• Developed XMLP reports for generating the compensation and Performance reports.
• Involved in Implementation of PeopleSoft Time and Labor application for version 9.1.
• Customized Time Reporting Pages and Functionality based on the Client requirement.
• Implemented Web clock, Punch and Elapsed Timesheets for ESS and MSS. (Client needs all three timesheets).
• Customized Punch Timesheets and implemented color coding for Manager and Employee Edits on Punch Times.
• Customized Manager Report Time, Approval Time, Payable Time Summary Pages.
• Created a batch process using Application Engine and CI for the automation of the following tasks:
• Creates and Maintain Time Reporters data.
• Detects changes in Job data and Assigns/Changes Work Groups
• Creates Dynamic Groups.
• Creates Row Security Permission lists.
• Provides Lateral Security for Supervisors reporting to same Manager.
• Developed Interfaces using Application Engines to load the Employee Schedules from a third party System every fortnight.
• Created a custom approval component for Employee Self Service to Plan and request change in their work Schedule.
• Configured AWE for Time Sheet Approvals and Schedule Change Requests by Managers as well as Admins.
• Translated Business Rules in to following technical rules and did the technical development for the Providing employees Holiday time based on certain conditions, comp time, Holiday Over Time, Call in Services, Regular Hour capping, Shift Differential etc. for both Elapsed and Punch Employees.
• Created Various BI publisher reports for MSS to keep track of the Employee Time and Timesheets and their approvals.
• Interacting with Business in Requirements gathering for TDU to ULearn(ELM) - conversion of legacy Training system to PeopleSoft ELM
• Responsible for creating Functional and Technical documentation as per Client interactions and Requirement gathering sessions.
• Mapping, Design and Development of data migration strategy and code to migrate data from SQL Server databases to PeopleSoft ELM single instance.
• Design and development of customizations of PeopleSoft ELM using Application Engine, SQR as per new requirements
• Design and development of new PS Queries for Reporting in ELM .
• Developed adhoc PS queries like Hours worked by location, Health Benefit Terminations report.

Environment: PeopleSoft HRMS 8.9, 9.1, ELM 9.1 & People Tools 8.49, 8.51, Oracle 10g, Windows Server 2003.

Confidential

PeopleSoft Technical Analyst

Responsibilities:

• Preparing functional and technical design documentation on customizations and enhancements
• Handled a small Team and helped them in resolving the technical issues.
• Development of interfaces and reports using Application Engines.
• Modifying & Developing the Peoplecode according to the required customizations.
• Resolving Production issues.
• Suggested changes in the system such that manual effort is minimized.
• Conducted Technical sessions for the team which helped the team in improving the technical skills.
• Provided Security to the pages for specified Roles and Permission lists.
• Developed custom pages and components so as to enable the administrators to enter the paths for inbound and outbound files. Developed validations on these pages using PeopleCode.
• Developed number of SQR Reports, PS Queries and other application customizations for fixing issues and new enhancements.
• Implemented Core Row Level and Department Security.
• Provided post-production support for HCM 9.0

Environment: PeopleSoft HCM 9.0, People Tools8.49, Quality Center, Windows XP.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Used Application Engine / Component Interface to load the data into Job record for Contractors.
• Customization as well as new enhancement in existing.
• Fixing issues for any transaction through online for MSS, ESS, and Core HR.
• Used ExceltoCI for loading data into JobCode set up tables.
• Modifying the Peoplecode according to the required customizations.
• Resolving tickets related to Incidents and Requests.
• Used Maintain Security to give access to the customized Menu and created Permission Lists, Users, Roles and assigned roles to users.

Environment: PeopleSoft HRMS 8.9, People Tools8.48, SQL Server 2005, Windows XP.

Confidential

PeopleSoft Techno Functional Consultant

Responsibilities:

• Resolved technical requests raised by Client with a quick turnaround.
• Analyzed SQR programs, PeopleCode and Application Engine and fixed the issues.
• Execution of modified programs in UNIX environment through UNIX shell scripts to get the required outputs.
• Prepared Technical Specification Document for the issues.
• Customization as well as new enhancement in existing system.
• Wrote couple of interfaces for third party vendor.
• Wrote SQR of max. Lines of code of 15000.
• Wrote High complexity Application Engine of around 10000 lines.
• Handled switch of Deploy to New Taleo(Vendor) enhancement implementation, it had app. engines and CI for HIR/REH/XFR’s to feed into PS and couple of interfaces which we designed through SQR, to send files to Taleo.
• Implemented Hire/Rehire module interface in Aon Hewitt-Prudential.
• Have estimated enhancement projects.
• Have been in couple of critical enhancement projects till design phase to freeze design.
• Have fixed critical issues during SIT and UAT with a quick turnaround.
• Used Application Engine / Component Interface to load the data into Job record for Contractors.
• Created DMS scripts to move the setup data from the UAT environment to production. Handled the file transmission using ftp and sftp, to and from Taleo, Health Con, Fidelity.

Environment: PeopleSoft HRMS 8.8, People Tools 8.48, Oracle, Windows XP. Serena VM web client 8.1.3.2 en US (Build 362), Maestro