SUMMARY:

• PeopleSoft Certified Consultant with around 8 years of IT experience, predominantly in PeopleSoft HR, Payroll and e - modules (ePerformance, eLearning, etc).
• Predominant working experience in PeopleSoft Upgrades (from PS HCM 7.x, Mainframes, PS 8.x systems) & Implementations (8.8, 8.9 & 9.0 HCM) and Production Support.
• Hands on experience
• XML Publisher, Integration Broker, App Messaging, Component Interface, SQR & App Engines.
• Maintenance Packs, Bundles, Patches, MS Project Plan, Tax & 401K Updates for NA Payroll
• Adept knowledge in Crystal reports, Business objects & nVision reports.
• Vast international working experience with good business consulting skills.
• Proficient analytical and problem solving skills with a high forbearance in critical situations.
• Extremely motivated team leader with solid organizational and time management skills.

TECHNICAL SKILLS:

PeopleSoft: PeopleTools (7.x/ 8.13/8.2/8.45/8.47/8.49 ) - App Designer, Data Mover, Process Scheduler, Workflow, Component Interface, Application Engine, Change Assistant, PeopleCode, App Messaging, Integration Broker, XML Publisher, Excel to CI, Report Manager, Tree Manager

Reporting: Business Objects, SQR, PS Query, Crystal Reports, XML Publisher, nVision.

Misc Tools: MS Project, Visio, MS Office, MS VSS

Programming: SQL, PL/SQL, C, C++, Core Java, JSP, UNIX Shell Script, HTML, XML

Methodologies: UML, SDLC, WADS, Six-Sigma.

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

PeopleSoft Functional Consultant

Responsibilities:

• Participated in analysing/amassing Functional Requirements and creation of Technical Specification documents for Salary Processing groups, Pay Update letters, Bonus Processing groups, capturing IM(Indiv Measure), FM (Financial Measure), VD (Value Driver), Weighing Plan etc.
• Gathered business rules for Bonus Calculations involving ratings from “Performance management” tables, and incorporating values from IM, VDM and FM rules specific to each country and currency.
• Created FSD’s for generation of Workflow (Employee - Managers) in self service pages for Absence Tracking.
• Created process flow diagrams for Performance approval process along with HR admin exception approvals.
• Involved in designing customizations for Performance Admin panels where HR can directly approve, reallocate or disqualify employees from the yearly Performance Appraisal process.
• Created Functional specs for generation of Workflow between Employee - Managers in self service pages for Salary/Bonus Review
• Created Functional specs for self service pages to display Salary, Bonus and other Benefit related information from ESS, MSS and for general HR Admins.
• Worked on creation of security matrix, roles, permission lists, department security tree and Position Hierarchy Tree.
• Designed RTF templates for Pay Update letters (XML Publisher) using Oracle BI Publisher.
• Performed communications with HR from Italy, Romania, Belgium & Spain for translating Pay Update templates and Bonus data reports.
• Involved in creating rules for workflows to generate e-mails directed to HR’s, managers and employees involved in various phases of SRB cycle.
• Generated System, Integration and User acceptance test cases in HP Quality Center.
• Worked in association with the clients in generating UPK (User Productivity Kit) for User .

Confidential, Atlanta, GA

PeopleSoft Functional Consultant

Responsibilities:

• Involved in amassing requirements for ePerformance module and also capturing various HR transactions for generating Functional & Technical specification documents.
• Involved in configuring setup tables along with the client and designing templates for Employee Performance entry.
• Configured Self Service Workflow’s for HR transactions and email generation in Performance Submission, Denial and Approval processes.
• Involved in creating document roles(Employee,Manager,Admin,Setup Admin) for ePerformance.
• Provided detailed analysis of online pages, interfaces & report customizations and a feasibility study for performance improvement, enhancing user interface and new workflow business processes.
• Designed custom pages for all HR transactions namely Hires, Re-Hires, Payrate changes, Benefit changes etc.
• Created flowcharts using Visio depicting ePDP data flow i.e from initiation of Perf Appraisal process by HRIS, to triggering mails to employees and managers of the begin of ePDP process till the end, i.e approvals,denials and discussions and exception handling.
• Created flowcharts using Visio depicting the various stages of the HROLT process (HR initiation, submission to HRIS, review of data entered, final approval and triggering of CI’s for trx’s to be entered into the core HR tables).
• Spec’d rules, layouts, display formats, etc for Audit reports & HRIS reports involving Business Objects, App Engines, CI’s and SQR’s.
• Gathered, analyzed and created FSD’s for workflows involving auto-email notifications between HR and HRIS when transactions are Approved, Saved, Held for Discussion, Rejected and returned for resubmission for custom HROLT module.
• Created SQL security views, designed & delivered Security matrix, roles, Query Security trees, Permission lists and finally assigning them to the respective HR & HRIS users.
• Created test cases for testing interfaces, reports and online customizations.
• Participated in System testing and System Integration Testing.
• Generated UPK (User Productivity Kit) documents for User Manuals and for .
• Analyzed and customized Business Object reports pertaining to HR and Payroll information.

Confidential, Durham, NC

PeopleSoft Functional Consultant

Responsibilities:

• Analysed the impact of PS upgrade on GSK downstream IT and non-IT systems by providing Fit-gap analysis.
• Documented and communicated new functionality changes in PeopleSoft 9.0, HCM Person model with integrated POI and CWR functionality.
• Played a major role in providing fit-gap analysis for online panels, interfaces & reports.
• Worked with PS Admins in customizing PS delivered upgrade scripts to be used in Change Assistant
• Guided the technical team leveraging the system know-how and coordinated the deliverables in adherence to the project timelines.
• Created Excel spread sheets for mapping Old-PS Roles with new roles to cater to PS 9.0 functionality.
• Involved in creating security matrix & validating Roles, Permission lists and porting of Department tree.
• Involved in generating test cases for interfaces, reports and online customizations.
• Participated in System testing and System Integration Testing.
• Involved in business communications for resolving data issues like Name Types, multiple Employee records, Service Dates, Hire Dates, Last Hire date, etc.
• Leveraged vendor communications for various data feeds in and out of the PeopleSoft system and the usage of PER ORG field for differentiating CWR’s from EMP’s.
• Gathered Business requirements for Self service pages and availability of required information by using PeopleSoft portal technology and providing links to GSK intranet websites.
• Gathered techno-functional knowledge of PS NA Payroll products to identify specific regulations, processes, reports, self-service, and user-defined rules with configurable business rules and logic.

Confidential

Team Lead and Onsite Coordinator

Responsibilities:

• Worked on enhancement of Payroll Interfaces involving Integration Broker and XML messaging (also involved customizing Java based adaptors that processed information over to Middleware).
• Addressed issues from Mercury Performance Monitoring tool (Tool for monitoring Global PeopleSoft servers).
• Worked on creation/customization of PS pages, peoplecode programs, App Engines, Component Interfaces, PS Queries, PL/SQL procedures, SQL triggers, etc.
• Handled exceptions and customized existing logic for Performance appraisals and approvals by managers for new company mergers into GSK.
• Lead the team in applying Maintenance Packs, Bundles & patches following a scheduled chronological order. It involved sketching a streamlined approach for preserving existing GSK customizations, avoiding hindrance to parallel rollouts of GPS to new markets, coordination with payroll teams from various markets and providing impact analysis to the functional team.
• Configured and customized PS Vanilla workflows for ePerformance and AVT Self Service.
• Customized panels and process logic for Performance appraisal process along with the workflows.
• Improved visibility, reduced errors and standardized the PeopleSoft security process by creating Excel to CI spreadsheet and assigning them with Users & Roles that can be used for refreshing the System’s security after each instance refresh, creation of new instances for developers or for UAT & SIT.
• Work gamut also involved addressing remedy tickets (helpdesk tool used by GSK for tracking incidents) for all PS related incidents revolving around GSK global markets mainly (UK, US, Spain, France, Italy, Netherlands, Egypt, Singapore, Romania, etc).

Enhancement & Support PS HR & Payroll 8.3 System

Confidential

Team Lead and Onsite Coordinator

Responsibilities:

• Played a major role in creating, supporting & enhancing interfaces involving SQR’s and shells scripts.
• Provided on-call support for payroll processes and interfaces involving shell scripts, COBOL, SQR and AE pgms.
• Rolled out several Tax Updates after analyzing & customizing them to cater to GSK US business rules.
• Altered 401k calculation scripts, garnishment & direct deposit calculation scripts, additional pay and benefit calculation scripts.
• Involved in support and enhancement of PeopleSoft NA Payroll processing scripts.
• Customized PS panels, peoplecode programs, Application Engine programs, Component Interfaces, PS Queries and Crystal reports for PS HR systems.
• Coordinated work with the team comprising of 9 members (4 in India, 3 in UK and 2 in US).
• Improved visibility, reduced errors and standardized the PeopleSoft security process by creating Excel to CI spreadsheet and assigning them with Users & Roles that can be used for refreshing the System’s security after each instance refresh, creation of new instances for developers or for UAT & SIT.
• Work gamut also involved addressing Remedy tickets (helpdesk tool used by GSK for tracking incidents) for all PS related incidents involving UK, US & Belgium systems.
• Gathered techno-functional knowledge of PS Payroll products to identify specific regulations, processes, reports, self-service, and user-defined rules with configurable business rules.

Confidential

PeopleSoft Analyst

Responsibilities:

• Involved in the creation of highly complex SQR's for converting Job, Compensation, Payroll & personal data taking care the parent-child relationships as well as compensation calculations. As the data being converted was over a million Job rows alone, component interface performance became a major bottleneck and hence all the conversions, except for minor setup tables were performed using SQR’s
• Created technical and functional specification documents for Fringe Benefits, Car bid/ Purchase & Learning modules.
• Extensively involved in gathering functional requirements for T & L pages along with the complicated expense claim and approval process.
• Worked on customising, enhancing and improving performance of Payroll system’s daily, weekly and monthly batch processes.
• Participated in client communications involving requirement gathering customization pertaining to Learning module as well as interfaces and defining the Data conversion templates.
• Altered PS vanilla T&L self service pages to include comments, workflows, and “auto e-mail reminders” for employees as they approach the second week of the month. Here, the employees should submit their timesheets by the 20th of each month and also apply for leaves 1 month in advance, unless in exceptional cases.
• Enhanced Manager approval process for Timesheet approval to include dual approval i.e Approval by HR or Approval by Manager (incase of non-availability of managers). This required creation of new workflows and additional online pages and reports for the HR team.
• Developed Data Conversion programs using App. Engine, Component Interface & File layouts for uploading data from TXT file (obtained from legacy system i.e Persy Mainframe) into the 8.8 PS for the transaction & setup components like Department, Jobcode, Position, Hire Data, Personal Data, and other L&D Tables.
• Created of Department Security through Tree Manager.
• Worked on customizing FBT (Fringe Benefits Module) that involved creating complex online pages and Fringe Benefit calculations on data obtained from the PS Global Payroll system, and from a couple of inbound interfaces.
• Was greatly involved in customer communications for generating data templates, guiding them in extracting legacy data in the required formats, resolving discrepancies at each stage along with gathering requirements for FBT module to be developed in PeopleSoft.
• Involved in Setup of Eligibility rules and Plans in Benefits Administration

Confidential

PeopleSoft Techno-Func Consultant

Responsibilities:

• Involved in gathering requirements for Time & Labor, AWF, data conversion templates, Interfaces and reports.
• Self Service Time Entry and Manager Self Service Approve Time functionality and online pages were altered to cater to business specific rules.
• Additional functionality to online pages and approval process was added to allow separate approval process for overtime hours (week days as well as weekends) into the PS vanilla pages.
• Drafted rules for integrations of T&L with Compensation and inclusion into Payroll feeds.
• Worked on Excel to CI tools to develop setup table loads for data conversion.
• Worked on formatting templates for data conversion, analysing & extracting required information from legacy (PeopleSoft 7.5) system, converting and migrating the same to PS 8.8, and resolving issues with regards to data validity and interfaces.
• Developed data conversion scripts using App. Engines, Component Interfaces, File Layouts and SQR’s to convert, analyse & migrate data from the legacy (PS 7.5 HRMS) to the current PS HRMS 8.8 system.
• Worked on creation of basic setup, department security through Tree Manager, user profiles and Permission Lists & roles for the defined Security Matrix.
• Worked on Excel to CI tool to load data into setup tables (other than Jobcode and Department).

Confidential

PeopleSoft Analyst

Responsibilities:

• Developed Data Conversion programs using App. Engine,CI’s,FLs & SQR programs for uploading data obtained from legacy(PERSY in Mainframes) system that includes data in Multi Byte (Chinese) characters.
• Created Department Security through Tree Manager.
• Developed SQR reports like Hourly Merit increase listing, New hires roster, Salaried personnel listing, etc for both Confidential Regional (Taiwan) as well as Global level.
• Developed interface programs like Employee Master toPayroll, an outbound interface to provide HR related data to the third party Payroll system, Salary Increase to PeopleSoft, an inbound interface that updates PeopleSoft HR system with salary details along with calculations specific to Comprate codes.
• Scheduled & created shell scripts to transfer files generated/received to/from a remote server using SFTP.

Confidential

PeopleSoft Analyst

Responsibilities:

• Developed SQR programs to display reports in various formats (CSV, Word and PDF) .
• Worked on dynamic report generation (which involves more than one report to be generated at a single time based on business situations) to be sent over as attachments through workflows.
• Used dynamic SQL for providing the provision of several input parameters, which vary depending on the user who runs the report.
• Developed people code programs for run control pages & online customizations.
• Worked on App Engines & Workflows for the auto e-mail reminders that trigger e-mails to employees, driven by certain business rules without user intervention.
• Involved in Data mapping, Data conversion and Data loading from the external system into PS tables

Confidential

Team Member

Responsibilities:

• Studied various Telephony systems being used by Confidential in India.
• Analyzed Optical Fibre layout, performed error detection and signal strength study.
• Monitored telephone traffic, reported network performance peaks and troughs and reported the results.