SUMMARY

• Over 10 years of Technical and functional experience on PeopleSoft applications that includes HR, Payroll, Benefits, Compensation, Time and Labor and Absence management .
• Hands on with various HCM modules: Administrator workforce, Payroll, Benefits, Time & labor and Self Service (ESS & MSS).
• Converted over 150K+ employees from Albertson systems to Safeway system. It includes PeopleSoft to PeopleSoft and non - PeopleSoft to PeopleSoft.
• Good Exposure to ADP, Ultipro applications.
• Have experience in Cognos reporting.
• Strong Expertise in People tools such as Application Designer, Application Engine, Component Interfaces, People Code, Process Scheduler, and DMS. Working knowledge of Integration Broker, Application Messaging
• Worked closely with Developers, IT and UAT Testers to make sure work is progressing as expected.
• Documented all new changes in requirements and maintained up-to-date specifications for developers and testers.
• Have good exposure to Software quality processes and PeopleSoft Standards.
• Experienced in all testing types: Regression, Smoke, System integration, Data conversion testing.
• Experienced in writing the test plans, cases and scripts based on system specifications and expertise in regression system integration functional and performance testing.
• Extensively used JIRA and HP ALM for defect tracking purposes.
• Expertise in PeopleSoft new person model and HRMS applications HR, Benefits, Ben-Admin and Time and Labor.
• Worked very closely with Business users in capturing requirements and creating Functional Design documents (BRD & FRD or FDD) and designing Technical Documents based on FR
• Worked Extensively on file layouts, PS Query and SQR.
• Hands on Experience on PeopleSoft Internet Architecture PIA such as app server configuration, PIA, Process Scheduler.
• Extensive knowledge of full Software Development Life Cycle (SDLC).
• Worked on setting upTime/ Labor module. Extensively worked on Time administration, set-up of Time periods, Shifts, Reason Codes, Task Profile Templates,Task Entity Codes, Task Groups and Work Groups
• Experienced in regression testing, functional testing, back-end testing and interface testing, Operational and Load & Performance testing.
• Extensively worked on testing interfaces between PeopleSoft to Lawson (GL), inbound and outbound interfaces.
• W orked on Pub-Sub interface, according to client requirements. This was one of the most important interfaces for the client, which was scheduled to run every night. This interface used to collect data from HR & payroll tables and put that on Pub-Sub repository, which is the separate DB. Data was picked up by all the vendors.
• Worked on interfaces between ADP RM and Peoplesoft.
• Extensively worked with interfaces between Peoplesoft and work brain, where payable time is reported from work brain to Peoplesoft.
• Extensive experience in testing Interfaces where messages come into PeopleSoft using Integration Broker and Component Interfaces.
• Experience in HP Quality Center 11/ 9.2/9.0, Quick Test Professional (QTP) 11/9.0/8.2/8/6.5 , Business Process Testing.
• Proven Experience in all phases of ERP lifecycle Conversion, Production support and troubleshooting of PeopleSoft applications release 7.x/8.x/9.0.x/9.2
• Involved in development and customization of interfaces and reports using Application Designer, Integration Tools, and Reporting Tools like PS Query, SQR's.
• Well versed with Debugging tools like SQL trace, and AEtrace for troubleshooting and Performance Tuning.
• Proficient in all phases of the systems development life cycle including requirements definition, data conversion, system implementation, system testing & acceptance testing.
• Excellent communication skills, good team player and quick learner.

TECHNICAL SKILLS

ERP /PS Applications: HRMS/HCM 9.2/9.1/9.0/8.9/8.0 (Core HR/ NA Payroll/Time and labor/Compensation /Benefits/Benefits Admin/MSS/ESS)/ Absence management People Tools 8.57/8.54/ 8.53/8.52/8.51/8.50/8.49/8.48

Testing Tools: OTM/HPALM/Quality Center 1/9.2/9.0, QTP 11.00/9.0/8.2/8/6.5 , Quick Test Pro, SQA Robot, Win Runner and Load Runner BPT, PeopleSoft Test Framework (PTF), Win Runner 8/7.6/, TSL, and Test Director 8.2/8/7.6/7/5.

Programming Languages: Java Scripts, SQR, People Code, SQL, PL/SQL

People soft Tools: Application Designer, Application Engine, Query Manager, File Layout, Application Upgrade Asst/ Change Assistant, Process Scheduler, Component interface, Maintain Security, Approval Workflow Engine (AWE), Integration Broker, Web Services

Development Tools: SQL Developer, SQL Navigator, TOAD

Reporting Tools: SQR, Crystal Reports 9.x/8.x, XML Publisher, n-Vision and PS Query

Operating Systems: Windows 2000/XP/Windows 7, Unix

Database Environments: Oracle 12c/11g/10g/9.x/ 8.x, SQL Server 2012/2008 R2/2000 and MS Access

Tools: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, STAT

PROFESSIONAL EXPERIENCE

Confidential, Dublin, CA

Peoplesoft payroll techno-Functional consultant

Responsibilities:

• PeopleSoft 8.0 to 9.2 Upgrade of HR modules and North American Payroll. Handles the d designed & Reviewed the Test scenarios and Test Scripts as per business requisites and Functional Design Documents (FDD’s).
• Extensively worked on paygl01 issues and account setups regarding earnings, deductions and taxes.
• Worked on Rimini tax updates from 8.0 and sync the tax rates after tax update 19D in 9.2 environment.
• Good knowledge in payroll setups and guided different teams by helping them to solve the issues that came across during payroll cycles.
• Worked on inbound and outbound interfaces(some of interfaces like SEDGWICK Employee Data, Mercer Service hours, Extract Voluntary Deductions, Coupa Interface, T&E Payroll Data,BOFA Check Reconciliation, KRONOS Workforce Central - on cycle payroll data, PEOPLEWORKS - on cycle payroll data,Taleo Requisitions and Full hourly Matrix Load).
• Worked on the Conversion Templates for data mapping from Legacy system to PeopleSoft. Identified the Key and Required fields for conversion and conducted meetings with both the functional and technical folks to review and explain the conversion approach.
• Modified the generic templates of advance and post notification emails.
• Creating System Test scripts in Oracle test manager .
• Test case creation, execution, analysis, and defect identification.
• Analyzing test data needs.
• Strong written skills for report creation and QA plan creation.
• Extensively worked on benefit proration process.
• Created custom PSHUP load for terminated employees.
• Created Excel to CI templates for one-time deductions, taxes and garnishments.
• Worked with the Functional Team to identify gaps (for both distributed and custom functionality) that had not been identified in either the design, fit/gap or development phases of the project.

Environment: PeopleSoft HCM 8.0&9.2, People Tools 8.57, OTM, ServiceNow, MS Access, SQL Developer Oracle 11g, Win 2000/XP, UNIX, STAT

Confidential, Phoenix, AZ

Peoplesoft Payroll SME

Responsibilities:

• PeopleSoft 9.2 Upgrade of HR modules and North American Payroll. Accumulated business requisites, documented current business process and requisites for Payroll, HR Modules.
• Extensively worked on Payroll earnings, deductions and taxes for parallel compare.
• Good knowledge in payroll setups and guided different teams by helping them to solve the issues that came across during payroll cycles.
• Extensively worked and given support to Payroll, ESS, MSS, HR users.
• Worked on various Customizations for Human Resource application as per the business needs and provide solutions.
• Extensive knowledge in conversion redesign process and developed good number of objects in North America Payroll.
• Involved in all safeway deployments and solved critical issues during conversion.
• Created new SQR, Application Engine Programs (also ExceltoCIs) to update Annual Base Salary, and to add new Benefit programs, Plan, Plan Types .
• Loaded all the Configuration tables using Excel to CI and Application Engine processes.
• Worked in analyzing the functional flow and do the impact analysis for new enhancements.
• Extensively worked on new Absence management customized rules creation.
• Worked on defining proration rules and Rounding Rule elements.
• Worked on Pub-Sub interface, according to client requirements. This was one of the most important interfaces for the client, which was scheduled to run every night. This interface used to collect data from HR & payroll tables and put that on Pub-Sub repository, which is the separate DB. Data was picked up by all the vendors.
• Troubleshoot payroll processing issues to determine source of issue and the best approach for a resolution. Write SQL queries to research intermittent issues.
• Worked on interfaces between ADP RM and Peoplesoft
• Worked on XML Publisher reports, scheduling, distribution security etc.
• Implemented Donation of Sick leave from one employee to another employee to meet Fiscal Year end requirements
• Modified the Time Admin Rule to accommodate Hourly employees and to catch up their annual and sick leave accruals who are not eligible for Holiday or who directly goes to Leave of Absence.
• Extensively worked with interfaces between Peoplesoft and work brain where payable time is reported from work brain to Peoplesoft
• Worked on benefits to Peoplesoft interfaces
• Extensively Worked on Peoplesoft to Confidential interfaces that sends data from Peoplesoft to Confidential (outbound Interface)
• Extensively worked with Vanguard Interface that transmits 401K data from Peoplesoft to third party vendor.
• Extensively tested the Navia Interface that sends Benefits from Peoplesoft to third party vendor
• Technical programming experience and upgrade knowledge in the Analysis phase of the Upgrade project, researching and documenting many of the numerous client-specific customizations. PeopleSoft 9.2 Upgrade of HCM modules Benefits, and North American Payroll. Accumulated business requisites, documented current business process and requisites for Benefits, Payroll and HR Module
• Working with team to develop the vision and scenarios for system test scripts to assure test coverage.
• Worked on the Conversion Templates for data mapping from Legacy system to PeopleSoft. Identified the Key and Required fields for conversion and conducted meetings with both the functional and technical folks to review and explain the conversion approach.
• Setup and Configured the core tables such as Job Data, Benefit Program, Benefits Plan (Plan Types 1x - 6x), Vendor, Deduction codes, Earning Codes, Pay Groups and Pay Calendars.
• Setup and validated the various Eligibility Rules and Event Rules and worked on the Eligibility Configuration fields.
• Creating System Test scripts.
• Test case creation, execution, analysis, and defect identification.
• Analyzing test data needs.
• Worked on PeopleSoft HCM workforce development and compensation
• Strong written skills for report creation and QA plan creation.
• Analyzing critical Production Issues and proposing solutions
• Designed & Reviewed the Test scenarios and Test Scripts as per business requisites and Functional Design Documents (FDD’s).
• Worked with the Functional Team to identify gaps (for both distributed and custom functionality) that had not been identified in either the design, fit/gap or development phases of the project.
• Prepared the Design Document and Configuration Designations for the Ecumenical Payroll Implementation Individually Performed the Functional setups of the entire Payroll module.
• Involved in the reviewing, composing & execution of Test cases pertaining to Time and Labor, Core HR and Payroll.
• Verification of configurations for Pay groups, Earning Elements, Deductions Elements and other fortifying elements.
• Engendered automated test scripts utilizing Expeditious Test Pro for testing N/A Payroll, Benefits Administration, HR and Time and Labor modules. Migration of projects and their pertinent objects from development to testing.
• Tested performance of interface. Did regressive testing and user acceptance testing.
• As a Functional analyst, interacted and set up meetings with all Super user’s, and Dev team, providing all compulsory information to QA team and prepared daily status reports, weekly status reports, defect tracker reports and communicated to entire project team. Used Quality Center 10.0 for Test Management

Environment: PeopleSoft HCM 9.2, People Tools 8.53, ALM, ServiceNow, MS Access, SQL Developer Oracle 11g, Win 2000/XP, UNIX.

Confidential, NY

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Modified the existing SQR reports, PS Queries as per the client and vendor requirements.
• Involved in retrofitting the Fields, Records, Record field People Code, Pages, Page People Code, Components, Component People Code, SQRs, Application Engine Programs and other objects.
• Had direct user interaction during UAT testing and made the customizations as needed
• Actively involved in processing Garnishments (on a weekly basis) to AP module and creating reconciliation reports to check the accuracy of the data extracted. Also on the EFT file generation .
• Worked on customizations to the delivered Paycheck (PAY003) and Payroll advice (DDP003) SQRs which also included changing the XML template to meet the client needs .
• Leading the 3rd party Interface track which takes care of all PeopleSoft Inbound and Outbound interfaces primarily using Application Engine, File Layout, ftp peoplecode etc
• Worked on gathering requirements for the implementation of HCM 9.2 Core HR (includes both the Person Model and SmartHire for employees and consultants), Base Benefits, Payroll Interface, Time & Labor and Front Office Staffing needs.
• Conducted Fit-Gap analysis with the Client and identified the Gaps based on the requirements gathered for HR, Benefits, Payroll Interface and Time & Labor.
• Worked on the options for the Gaps identified and recommended best practices for each of them. Sized the gaps based on the customization needs and created the Functional Design documents.
• Facilitated check point and status calls with the different business users and identified the bottlenecks and reviewed the milestones with both the onsite and offshore teams.
• Worked on the Conversion Templates for data mapping from Legacy system to PeopleSoft. Identified the Key and Required fields for conversion and conducted meetings with both the functional and technical folks to review and explain the conversion approach.
• Setup and Configured the core tables such as Job Data, Benefit Program, Benefits Plan (Plan Types 1x - 6x), Vendor, Deduction codes, Earning Codes, Time Reporting Codes, Task Groups, Pay Groups and Pay Calendars.
• Setup and validated the various Eligibility Rules and Event Rules and worked on the Eligibility Configuration fields.
• Implemented the Open Enrollment processes; Customization of enrollment forms and confirmation statements.
• Resolved the Ben Admin issues when the process fails, identified exceptions and addressed the eligibility criteria.
• Created Test Plan, Test Scripts and Cases for the Unit, System Integration and User Acceptance Testing for Core HR, Base Benefits, Benefits Administration, Payroll Interface (ADP mapping), and Time & Labor.
• Responsible for creating test scenarios for the data mapping from the various Legacy systems such as Analyzer & ADP to the corresponding PeopleSoft tables/fields.
• Prepared User Manuals and Training Guides for the end users to understand the various functionalities and processes in PeopleSoft and also setup WebEx/Live Meeting sessions to walk them through the different pages in PeopleSoft.

Environment: PeopleSoft HRMS 9.2, People Tools 8.54, Windows NT, UNIX, Oracle Database

Confidential, Detroit, MI

PeopleSoft Techno-Functional Lead

Responsibilities:

• Coordinated the business requirement gathering sessions for the Global Roll-out of HCM 9.1 for Core HR, Benefits, Profile Management, Payroll and Self Service.
• Analyzed the Gaps, prioritized them and recommended best practices for each of the line items in scope.
• Prepared the business requirement and functional specification documents and conducted review meetings with the various business, functional, technical and admin user groups for the sign-off.
• Setup and Configured the Core tables such as Department, Company, Location, Salary, Business Unit, Action Reason, Smart-Hire Templates, Benefit Plan, Program, Earnings, Deductions, Rate and Tax Tables.
• Created Test Scenarios/Cases for the different HR, Benefits, Payroll, Self Service and Interface requirements.
• Conducted End-to-End testing from Hire through Termination to validate the business process transactions for different countries.
• Validated and Tested the Self Service Work Flow configuration functionalities for both the Personal and Job Data transactions.
• Tested the Workflow Configurations and Validated access to the Workflow Rules pages, Transaction Category page, User List Setup page, System default and Status pages.
• Conducted workshops for the users to explain the new functionalities of HCM91 and what changes and new business process PeopleSoft included in HR, Benefits and Payroll modules.
• Acted as a Liaison between HR and IT to ensure the departments are n-sync on desired project requirements. Super User in report writing and extracting data through the use of PS Query.
• Provided functional assistance defining and documenting HR, Benefits and Payroll processes and procedures.
• Scheduled and supervised touch-point and status calls by managing resources both On-site and Off-shore.
• Monitored Remedy QA queue and resolved HR, Payroll and Benefit production issues as required.
• Developed training guides and job aides for the end users to identify the new functionalities and customizations.

Environment: PeopleSoft HCM v9.1 (Core HR, Base Benefits, Payroll Interface, Profile Management, eBenefits, eProfile, eProfile Manager) MS Office, Oracle10g and UNIX.

Confidential, Irvine

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Performed fit gap analysis to come up with current business processes, enhancements and customizations for HR, Payroll, Benefits for the 9.1 upgrade.
• Ran compare reports and performed the retrofitting for different PeopleSoft objects.
• Involved in Production support in troubleshooting and fixing the post production issues.
• Designed and Developed Conversion Programs through Component Interfaces and Application Engine Programs to process the Data and load in to PeopleSoft tables.
• Created several pagelets to show summarized student information from Campus Solutions.
• Designed menu integration for HRMS and CS as they reside in different databases.
• Customized the delivered General Ledger process and the interface for the payroll accounting as per the client’s requirements.
• AWE customization.
• Customized and created records, panels, menus for the Student Records.
• Worked extensively with SQR, PeopleTools, PeopleCode, Application Designer and Application engine.
• Involved in implementation of the Student Financials module including, Cashiering, Tuition Calculation, Billing, General Ledger Interface, Quick Post, Group Post, Refunding, work study and Item Type design
• Designed various absence management reports to capture leave of absences used for payroll, benefits calculation purposes.
• Developed interfaces to capture time from Kronos Management System into PeopleSoft Time and Labor System.
• Worked on setting up the EIPs to run the sync between HCM and ELM for all the HR related data. The setup is done both for Full Sync and the daily Incremental Sync.
• Troubleshot the performance issues with the syncs running between HCM and ELM.
• Course completion information for all the employees will be sent back to HCM from ELM on a daily scheduled basis using Application Engine and DB Links.
• Developed and scheduled a daily interface between ELM and HCM to send course enrollment information for new hires from HCM to ELM.
• Converted historical data from third party systems like “SumTotal Systems” and “Moodle” which were used as legacy Learning Management systems at the State of Texas.
• Created lot of custom reports using XML publisher.
• BI/XML Publisher report was developed to generate the Course Completion certificate after the Employees finish the courses they are enrolled in.
• Employees can login as needed and can be able to regenerate the Course Completion certificate as needed.
• Modified the Learning History page by adding a link to launch a new window displaying the Course Completion Certificate for that course.
• Created custom reports using SQR in TAM Module.
• Involved in setting up the Integration Broker for Compensation, Payroll, HR and TAM related IB services.
• Requirement Gathering for TAM/Candidate Gateway and helping the development team in following the right technical solutions and appropriate tools to be used in completing a requirement
• Involved in design, development and testing of Employee self-service (ESS) and Manager self-service (MSS) customized Absence Planning Application pages.
• Customized the delivered workflow to accommodate multiple levels of approval for different Job Openings
• Designed a new workflow to in corporate multiple levels of approvals while offer making.
• Developed conversion and interface programs using SQR to convert data from legacy systems to the PeopleSoft Tables.
• Involved in the Upgrade of Core HR, Talent Acquisition Manager, Payroll, Base Benefits and Compensation Modules.
• Created custom reports and modified reports using XML publisher, SQR and Application Engine Programs.
• Worked extensively on customizations involving Application packages. Modified Application packages and methods to meet the custom requirements.

Environment: PeopleSoft HCM 9.1, (HR, Payroll, Benefits, Time and Labor), self-services (eRecruit, eBenefits), People Tools 8.50, Integration Broker, Application Packages, Oracle 10g.