SUMMARY

• Strong PeopleSoft Functional consultant with 7+ years of Extensive experience in PeopleSoft HCM Applications.
• Hands on experience with various HCM modules: NA Payroll, Self Service (ESS & MSS), Time and Labor, Administrator workforce.
• Expertise in analyzing complex business process of various enterprise and design solutions in PeopleSoft.
• Worked closely with Developers, IT and UAT Testers to make sure work is progressing as expected.
• Analyzing and developing strategic imperatives for organization/business units using various strategic management methodologies.
• Strong experience in formulating PeopleSoft interfaces viaSQR, File Layout and Component Interfaces.
• Documented all new changes in requirements and maintained up - to-date specifications for developers and testers.
• Worked very closely with Business users in capturing requirements and creating Functional documents (BRD & FD) and technical team.
• Have good exposure to Software quality processes and PeopleSoft Standards.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Strong Expertise in documenting the As-Is Process and performing Complete Fit-Gap Analysis
• Worked on various projects that include PeopleSoft Upgrade, Implementation, Development and Application Maintenance.
• Good understanding ofPIAand the inner workings of the tools like Process Scheduler, PS Query, Crystal reports.
• In depth knowledge of risk management, business analysis and change management processes.
• A motivated team player with solid organizational and time management skills.
• Great analytical, presentation and communication skills.

TECHNICAL SKILLS

ERP Applications: PeopleSoft 8.8/9.0/9.1 HRMS, Benefits Payroll, Time and LaborPeoplesoft technologies Application designer, Application Engine, Process scheduler, Process monitor, Peoplecode, People tools, SQR, PS Query

Administrative Tools: Data Mover, Security Administration, Import Manager

RDBMS: Oracle11g, Oracle 12cLanguages People code, SQL, PL/SQL

Packages: MS Office, MS Word, MS Excel

Reporting Tools: SQR, Crystal reports

PROFESSIONAL EXPERIENCE

Confidential, IL

PeopleSoft Consultant

Responsibilities:

• Created design specifications / functional specifications for additional fields that were needed for the Process.
• Created various new Interfaces for the Data Transfer towards JDE/Pega/ISO Train, decommissioning the FTP process.
• Involved in coordinating between the testing team and functional team regarding the testing, creating data and logging defects.
• Providing production Support for daily run.
• Processing multi-state, expatriates, payrolls for management and executives and union payrolls for non-management employees.
• Assisted in establishing new pay scales and job descriptions for the organization.
• Strong understanding of payroll procedures, compliance/SOX & accounting systems.
• Critically reviewed and analyzed payroll and tax procedures in order to recommend and implement changes leading to best practice operations.
• Providedproduction supportforHR, BenefitsandPayrollapplications
• Involved in performance testing and fine-tuning of the SQR programs.
• Use of PeopleSoft “Best Practices” procedures and processes from the planning stages to the deployment phase.
• Customized pages for e Benefits to deliver Benefit Enrolment pages, Health Plan pages, Managing Insurance Plans an employee can access.
• Developed test Paygroup’s, Benefit Plans, Pay Run ID, hired test employees in HRMS, performed Paysheet, Pay Calculation and Confirm Pay processes.
• Interface with GL

Environment: HR, Base Benefits, NA Payroll, PeopleSoft, People Tools, Oracle, People Code, Process Scheduler, PS-Query, SQL plus, Toad, Data Mover, Component Interface, Application Engine, SQR, Crystal Reports.

Confidential, VA

PeopleSoft Consultant

Responsibilities:

• Communicated with other institutions to ensure a precise processing of deductions in payroll.
• Created and maintained month end, quarter end and annual reporting for various agencies.
• Responsible for all direct deposits going to the bank for all companies.
• Ensuring a smooth and time-bound transition of client’s business processes to new application landscape from legacy system or manual processes.
• Worked on eProfile module in ESS and MSS customizations. Wrote specifcations and coders used PeopleCode to meet the requirements.
• Worked on PeopleSoft Workflow for ESS module. Worked on escalation of authorization in Workflow.
• Developed and modified the production control reports which help in identifying the data integrity in the PeopleSoft tables.
• Advised management proactively of any steps required to mitigate project/delivery risks during the execution phase.
• Involved in developing ad fine-tuning conversion programs and moved historical data from legacy to PS system.
• Involved inUnit, SystemandUser Acceptance& Regression Testing.

Environment: ESS, MSS, Core HR, NA Payroll, AR/AP, Time and Labor People tools, SQR, Application Engine, CI, PS Query, PS Security, Application Messaging, IB, Work flow, Oracle, Toad, SQL.

Confidential, FL

PeopleSoft Consultant

Responsibilities:

• To understand the existing business processes of client across the varied functional areas and map those on PeopleSoft HRMS landscape.
• Responsible for payroll tax and garnishment accounting, auditing, and all reconciliations.
• Oversaw and managed all year-end tax analysis/ reporting, reconciliations, and distributions for federal and state.
• Effectively supervised, developed, and coached staff on new processes and performed several KT sessions
• Extensively worked on finetunning People code with object orientation (Row set, Row, Record, and Field) Familiar with stand-alone row sets in people code.
• Post implementation support of PeopleSoft order to cash process.
• Application requirements and testing objectives were carried out using Mercury Quality Center to track changes in requirements.
• DevelopedCustom Application Engine program - Security Script process, developed format for converting existing customized SQRs to new Application Engine process
• Providing any and all reports from the payroll database using reports smith to create scheduled and ad hoc reports.
• Articulated in the development and maintain a repository of regression test cases in Quality Centre.
• Involved in the development of test cases for custom defined Info types.
• Identifying payroll process of the client to elaborate GAP analysis.

Environment: Core HR, PeopleSoft HRMS 8.8, PeopleSoft HRMS 9.0, UNIX, Work flow, Base Benefits, Base Compensation, Oracle, SQL.

Confidential, IL

PeopleSoft Consultant

Responsibilities:

• Audit employee pay records. Processing all request affecting compensations, terminations, LOA’s, bonuses, vacation, commissions.
• Created functional specifications forEmployee Mass Update Enhancement where the user should be able to import and export the bulk employee information.
• Maintained change control register and done fit gap analysis and on approval design and document the changes and validate before moved into Production environment.
• Developed SQL Queries from simple to complex scenarios in Unix environment, to validate the test data, if not found, generated the test data using queries and also inserted data using online application process.
• Involved in creating PeopleSoft Security-User profiles, Roles, Permission lists.
• Deep understanding of Software development life cycle and procedure in regards to PeopleSoft implementation.
• Developed Planning and scheduling of Fit Gap and UAT.
• Coordinating software bug fixes with the product Development teams.
• Payroll process creation of paysheets & Paycalc.

Environment: Core HRMS, UNIX, Admin Training, Base Benefits, Oracle, SQL. Base Compensation.

Confidential, OH

PeopleSoft Consultant

Responsibilities:

• Established internal audits, schedules of garnishment payments and procedures for more effective response to the appropriate agencies.
• Assisted in establishing new pay scales and job descriptions for the organization.
• Responsible for payroll systems technical training and soft-skills training delivered by both instructor led and virtual led classes.
• Communicate with technical team to develop and conceptualize the bespoke requirements of client across varied functional areas
• Facilitate meetings between business owners and analysts during requirement gathering phase.
• Training of end users on PeopleSoft business processes.
• Take care of backlog, customer satisfaction surveys (rating for the group), team appraisal etc.
• Involved in the UAT and dress rehearsals testing.

Environment: PeopleSoft HRMS, People Tools, People Code, Oracle, AIX, UNIX, Win NT SQL.