SUMMARY:

• 10 years of experience in PeopleSoft 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.
• Implemented Time and Labor for Ireland Country.
• 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 Enterprise 9 HCM Human Resources Consultant Oracle Certified Expert.
• Implemented Peoplesoft to OSB - SOA Integration.
• 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, Fishers, IN

Technical Manager - Projects

• 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.
• Involved in integration of PeopleSoft Components as Web Services to third Party Applications.
• Worked Extensively with Component Interfaces, Application packages and App Engine.
• Scheduling and Re-ordering on Online Batch Jobs for efficient performance.
• Designed technical & functional specification for Benefits 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
• Supported reports and HR interfaces like Taleo, New Hire and Department Change report.
• Used Integration tool, Integration Broker to publish the Employee information from PS HRMS to other Applications.
• Developed new queries using BI publisher to replace some SQRs.

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

• 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.
• Worked Extensively with Component Interface, application messaging and App Engines.
• 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 Consultant

• 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.
• Developed New to SQR’s / Application Engines in order to meet the Business Requirements
• 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 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.
• Customized approval process to go to the managers though PeopleSoft has delivered to send the manager in a single mail for all the Direct Reportees.
• Creation of test data from DEV to test environment and migration for T &L as it was an implementation.
• Worked on Auto Unapproved time reporting batch job to include multiple selections of TRC, Group ID, and Workgroup.
• Developed process to send demographic and health benefits enrollment information of employees and their dependents information.
• Customized SQR to process Pay Incentive and Tuition Reimbursement data to paysheets.
• 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.
• Developed adhoc PS queries like Hours worked by location, Health Benefit Terminations report.
• Developed custom programs (SQRs, Application Engine programs, Component Interfaces) according to the business requirements.
• Participated in the fitgap sessions with the functional consultants and business users.
• Was responsible for creation of technical design documents from the business requirement & functional documents.

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

Confidential

PeopleSoft Technical Analyst

• 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

• 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

• 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 couple of app. engine and couple of CI for Hire/Rehire/Transfers 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.
• Fixing issues for any transaction through online for MSS, ESS, and Core HR.

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