PROFESSIONAL SUMMARY:

• Over 10 Years of rich and diverse experience in the IT Domain and its business. This includes Functional and Technical consulting Experience in Oracle Fusion, PeopleSoft HCM and related PeopleSoft technologies. 
• Sound knowledge of PS HCM PeopleSoft modules like Core HR, Administer Workforce, Base Benefits, Benefit Administration, Time & Labor, ESS and MSS, Profile Management, Security Administration, Payroll Interface, PeopleSoft Global and NA Payroll .
• Hand - on experience in PeopleSoft 8.X. 9.0, 9.1, 9.2. Worked on PeopleTools up to 8.55. SQR, PeopleCode, Application Engine, Component Interface, PSQUERY, XMLP Reports. 
• Extensively worked on customizing and enhancing PeopleSoft HR application in various functional areas.
• Focused teams on deliverables and tracked progress to ensure project milestones were completed on time and with the desired results. Managed all phases of the software development lifecycle (SDLC) for HCM Customizations and Interfaces.
• Has worked on PeopleSoft to Fusion coexistence, PeopleSoft Implementations, Upgrades and various Maintenance projects. 
• Customized PeopleSoft delivered interfaces for fusion coexistence to fit to customer needs.
• Acquired on the job knowledge of oracle fusion performance management module.
• Diverse roles played in the past include: Project Lead, Functional Lead, Business Systems Analyst, technical lead doing hands on development all throughout. 
• Excellent Communication Skills - verbal & written; Documentation skills - technical & functional; Deep Customer Interaction & Relationship Management Skills 

AREAS OF COMPETENCY/TECHNICAL SKILLS:

PeopleSoft Modules: Core HR, NA Payroll, Payroll Interface, Base Benefits, ESS/MSS, Time & Labor, Absence Management, Profile management, Position Management & Global Payroll

Oracle Modules: Fusion Performance Management and Core HR

People Tools: 8.5X Development Tools: People Code, SQR, Application Engines, Component Interfaces, AWE, Java Script, PL/SQL, Excel to Cis, Integration Broker 

Reporting Tools: SQR, PS Query, XML Publisher and OBIEE

Database: Oracle 11G, 10G and 9i, SQL Server 2005, IBM DB2 

PeopleSoft Upgrades: HCM 8.9 to 9.1 and HCM 9.1 to 9.2

Other Tools: ITSM (Information technology service management) and STAT

Scheduling Tools: Control M, Autosys

PROFESSIONAL EXPERIENCE:

PeopleSoft 9.1Maintenance and Enhancement

Confidential

Modules: PeopleSoft HRMS 9.1 - PeopleSoft 9.1- NA Payroll, Core HR, Position Management, ESS/MSS,Base Benefits.

Tools: PeopleSoft 8.53

Responsibilities:

• Created components and pages for HR users and HR admins to submit and maintain severance event. Developed the end to end process to select employees, gather information and initiate severance event. Also designed a workflow for the process using AWE with one level of approval. Provided submit/approve/deny abilities.
• Created XMLP reports generating output on word documents to be handed out to the employees processed in the event after the event is finalized.
• Modified existing SQR to create new outbound files going from PeopleSoft to 3rd party learning management system.
• Created shell scripts to send files from PeopleSoft server to servers on the vendor’s side.
• Wrote multiple PSQUERY reports/SQL for business to tally performance evaluations for business.
• Review and Design ADP interface for international countries. Studied the delivered payroll interface to re-use the setup pages used in the delivered module while designing the custom interface for ADP.
• Created an SQR program to populate all the open positions with their respective statuses as they progress through various stages of the hiring process. The resulted table was then used on manager dash boards.
• Created custom SQR to load earning, deductions, one time deductions to paysheets for hourly employees.
• Created excel to CI for PERSONAL DATA component for one time email address uploads from PeopleSoft HRMS to CRM for employees missing a business email address in CRM.
• Modified sqr and run control page to send offcycle direct deposit data to vendor.
• Wrote custom SQRs for sending benefit information like 401K, ISP, ROTH etc when client signed up for a new benefits vendor.
• Applied multiple tax updates starting with downloading the patch from oracle support, applying it in demo, running compares, analyzing compare reports and thus retrofitting and testing the process end to end.
• Modified payroll and tax sqrs for various on call P1/year end processing.
• Managed a team of 11 members (3onsite-8offshore) ensure quality delivery on time with minimal escalations.

PeopleSoft HRMS 9.1 Maintenance and Enhancement

Modules:PeopleSoft 9.1- NA Payroll, Core HR, Position Management, ESS/MSS, Base benefit, Oracle Fusion - PeopleSoft coexistence

Tools: PeopleSoft 8.53, PeopleSoft HRMS 9.1

Responsibilities:

• Created custom application engine, CI and Excel to Cis to port employees’ data from 3rd party system to PeopleSoft when client acquired 3 new companies.
• Created landing pages for employees and managers using Navigation collection
• Created audit triggers using the delivered utility.
• Played an instrumental role in Oracle fusion Performance management Implementation.Single handedly customized multiple complex application engines delivered by PeopleSoft to send data files from PeopleSoft to fusion.
• Gathered on the job understanding of fusion functionality and provide functional solutions for data issues on Oracle fusion.
• Setup SFTP connection to receive inbound file from fusion to PeopleSoft.
• Created program to read the final ratings file coming from fusion to PeopleSoft and load it to EMPLOYEE REVIEW table.
• Acquired on the job knowledge on data issues and functionality gaps between Fusion and PeopleSoft
• Expert in PS - fusion interface. FBL/HDL.
• Worked with Oracle on numerous high priority issues/product gaps with oracle.
• Developed customization to allow back dated changes in position data to flow to JOB.
• Created application engine programs calling CI for JOB DATA component to hire employees/CWR in the system after the requisition is completed and sent from Taleo to PeopleSoft.
• Created multiple custom objects for contingent worker processing. This included one-time programs to load contingent workers to PeopleSoft. Component and pages to show contingent worker information related to billing/vendor details etc.
• Ensured quality delivery adhering to timelines with minimal to no escalations.
• Requirement gathering, fit-gap analysis for Fusion–PS co-existence.
• Did 9.2 upgrade assessment for the client
• Worked on numerous on call/ P1 and BAU works.
• Worker as a project manager leading a team of 11 people(3onsite-8offshore)

PeopleSoft 9.1 Maintenance and Enhancement

Modules: HR, Base benefits, Na payroll, Position management

Tools: PeopleSoft 8.53, PeopleSoft HRMS 9.1

Responsibilities:

• Designed and developed Approval WorkflowEngine(AWE) for Absence management and time and labor transactions.
• Implemented delegation for multiple transactions like reported time, approve time, and approve absences.
• Wrote custom time and labor rules involving complex processing logic.
• Modified the TL TIME ADMIN to auto approve the time that is not approved by manager after AWE for Tnl transactions was implemented.
• Modified custom table storing hierarchy to move employees one level up in case they were reporting to terminated manager.
• Designed custom functionality to edit/cancel certain type of leaves even after they have been approved. Thus making updates to the Confidential table.
• Customized POSITION DATA component to add Paygroup field.
• Actively participated in requirement gathering and designing technical design documents
• Review the design documents for interfaces before proceeding with development
• Assist the lead at onshore to co-ordinate development activities from off-shore.
• Wrote/modified multiple time and labor rules for various countries based on their business scenarios.
• Worked on multiple custom/customization requirements around ESS/MSS
• Worked on GP/Time and labor/ absence management rollouts and their BAU support.
• Assist conversion team with performance tuning of conversion programs.
• Assist and train the team members in various technical areas.
• Plan resources for the various phases of SDLC by liaising with the management.
• Lead team of 10 members as onsite coordinator

PeopleSoft 8.9 -9.1 Upgrade

Modules: HR, Base benefits, Na payroll, Position management

Tools: PeopleSoft 5.52/8.53, PeopleSoft HRMS 8.9/PeopleSoft HRMS 9.1

Responsibilities:

• Created custom component and page to define exclusions and inclusion of Company, Paygroup, jobcodeetc after client disintegrated to smaller sister companies. These exclusion/inclusion were then used by the sqr/interface programs using an sqc rather than hardcoding the exclusions in each program.
• Created custom table to derive the hierarchy using position number.
• Created SQR to read input file and load gross up data into PAY EARNINGS, PAY OTH EARNINGS, PAY DEDUCTIONS etc.
• Modified existing program used to populate hierarchy to use REPORTS TO instead of SUPERVISOR ID.
• Performed retrofitting on AE,SQRs, custom views for person model and other delivered changes.
• Understanding and analyzing the delivered changes in the 9.1 version of PeopleSoft HRMS.
• Reading and analyzing compare reports.
• Meeting with client to do fit gap analysis.
• Designing and formulating retrofitting techniques
• Plan resources for the various phases of SDLC by liaising with the management.
• Actively participated in requirement gathering and writing technical design documents
• Review the design documents for interfaces before proceeding with development
• Peer test the various interface deliverables before delivering the product to QA. 
• Assist the lead at onshore to co-ordinate development activities from off-shore
• Assist conversion team with performance tuning of conversion programs
• Assist and train the team members in various technical areas

PS HRMS 8.9 PeopleSoft Maintenance

Modules: Core HRMS, Base Benefits, Self Service and NA Payroll

Tools: Application Designer, People Code, Component Interface, Application Engines, SQR on Mainframes 

Responsibilities:

• Performed a business analyst role. Was involved in extensive client communication for gathering requirements and designing functional design documents.
• She was also involved in providing people soft solutions to customized requirements.
• Involved in reviewing and unit testing developments done by team members.

PeopleSoft HRMS 8.9 Maintenance

Modules: HR, Base benefits, Na payroll, Position management

Tools: Application Designer, People Code, Component Interface,  Application Engines, SQR on Mainframes 

Responsibilities:

• Lead a team for 4 people.
• Was involved in requirement gathering, creating functional and technical design. This involved mapping and using the delivered functionality to obtain the desired information in the form of reports and interfaces.
• Worked on designing Application engines, SQR and Component Interface.
• Worked on testing the developments and providing fixes and solution during UAT phase.
• Was involved in Knowledge transfer for new team members.
• Was involved in extensive client and onsite communication.

PeopleSoft HRMS 8.9 Maintenance

Modules: HR, Base benefits, Na payroll, Position management

Tools: Application Designer, People Code, Component Interface,  Application Engines, SQR on Mainframes

 Responsibilities:

• Was involved in requirement gathering, creating functional and technical design. This involved mapping and using the delivered functionality to obtain the desired information in the form of reports and interfaces.
• Worked on developing/customizing Application engines, SQR and Component Interface.
• Worked on testing the developments and providing fixes and solution during UAT phase.
• Was involved in Knowledge transfer for new team members.
• Was involved in extensive client and onsite communication.

PeopleSoft HRMS Upgrade 8.8 to 9.0 

Modules: HR, Base benefits, Na payroll, Employee and Manager Self Service

Tools: Application Designer, People Code, Component Interface,  Application Engines, SQR on Mainframes

 Responsibilities:

• Review and understand the Compare Reports to determine the differences in object definitions between the Production Database and the Demo Database, and documented the customizations made to the Production database.
• Understanding PeopleSoft delivered changes during upgrade and mapping the same to the customer’s system.
• Conducted upgrade training and Knowledge transition sessions for new team members.
• Lead the retrofitting team involving 3 people. Retrofitted SQRs Application engine, Component Interface and PS Queries.
• Retrofitting customizations. Reapplied customization for a Hires/Rehires and job data processing customization implemented by client. 
• Underwent classroom training for Payroll for North America.
• Involved in review and testing of retrofitted objects.
• Preparation of Test scripts and Test scenarios.
• End to End testing of retrofitting (Online objects and batch program)
• Adhered to SEI CMM-Level 5 quality standard for coding and reviewing.
• Performing support during UAT.
• Clarify and fix retrofitting issues during UAT phase.

PeopleSoft HRMS 8.9Maintenance

Modules: HR, Base benefits, Na payroll

Tools: Application Designer, People Code, Component Interface,  Application Engines, SQR on Mainframes 

Responsibilities:

• Acquired hands on experience in functional modules like Payroll, benefits and core HR. 
• Provided solutions to PeopleSoft functional P2 (priority 2) tickets.
• Designed a number of custom SQRs and PS Query for reporting and interfacing.
• Working as the Primary resource for Batch Support at offshore.
• Involved in development and conducting peer reviews for team members.
• Conducted various technical and functional trainings. Also inducted the team for using Autosys.
• Analyzed and read compare reports for tax updates.
• Acquired good experience on UNIX including scheduling and maintaining UNIX jobs (Autosys) 
• Handling issues and tickets through on Third Party tools ITSM (IT Service Management) and Quest STAT(tools used by client to resolve their issues) 
• Support offshore for PS-ADMIN related tasks including Process Scheduler, Application Server and Web Server.
• Applied  Tax Updates (08A—8D) 
• Worked on implementing customization on 
• 1) PAF (Personal Action Form) – Automation for manual data entry forms including
• Taking job data changes from the user in the form of an inbound interface and load it to a temporary (staging table)
• Performing validations using CI and loading data to PeopleSoft.
• Generating error report for unsuccessful.
• Scheduling the process to run on daily basis on UNIX through Autosys.
• 2) Pay Card – The basic design of the customization involves accepting Pay card as an option for Direct Deposits, sending it to bank for acceptance and processing the approved forms and loading data to PeopleSoft, involving people code, sqrs, passing data across servers (Bank and client system) and scheduling automated process for the same. The enhancement involved
• Code level changes on page and other objects.
• Scheduling the process to run on regular basis and fetching various files generated and finally processing the files and loading data to PeopleSoft and generating a report for the successful uploads.