SUMMARY:

• More than 17 + years of experience as a PeopleSoft Consultant.
• Worked on PeopleSoft Projects which includes gathering user requirements, Analysis, Design, Development, Implementation, Upgrade, Customizations, Maintenance, Data Conversion, Testing and Production Support.
• Extensively worked with People Tools such as Application Designer, Application Engine, Process Scheduler, Data Mover, Maintain security, People code, Workflow, Component Interface, File Layout, XL to CI, Approval Workflow Engine, Application Packages, Integration Broker, PeopleSoft security, HTML, project migrations, Update Manager and Unix Scripts.
• PeopleSoft HR Modules - Core HR, Workforce Administration, Employee Self Service (ESS), Manager Self Service (MSS), Position Management, Base Benefits, Ben Admin, North American Payroll, Compensation and Time & Labor.
• Worked on PeopleSoft GL, AP, AR, Project costing, Travel and Expense.
• Worked on PeopleSoft to Workday Design, Data Mapping and Conversion documentation, Data extraction, validation and correction.
• Worked in PeopleSoft 8.8, PeopleSoft 8.9, PeopleSoft 9.0, PeopleSoft 9.1, PeopleSoft 9.2 Upgrade projects.
• Worked on inbound and out bound Interfaces like importing data from flat files (CSV, TXT, Excel) to PeopleSoft tables and exporting data from PeopleSoft tables to files using SQR, Application Engine, Component Interface and File Layout.
• Worked on Tax updates for Confidential and COX clients.
• Project migration done using Application designer and STAT, Phire tools and applied patches/fixes using Update Manager.
• Worked with reporting and analyzing tools such as SQR, BI Publisher /XML Publisher, PS/Query, Crystal.
• Worked on setting up PeopleSoft Fluid Pages, Work Centers / Dashboards / Navigation Collections.
• Collaborating with Business users, PMO and/or scrum masters to understand the business requirements, estimate work efforts, come up with story breakdown and task allocations, manage the project plan and ensure timely completion of tasks, Incident management and change management processes.
• Worked on different projects using SDLC, Agile methodologies, using with HP quality center and Jira.
• Involved in analysis, creation and updating the Functional Design Document (FDD), Technical Design Document (TDD), Process Flow, Processing Logic, Unit Test Plan Document (UTP), Migration Check List, Coding Standards Document, End User Documents.
• Have strong communication skills, well organized, and able to work individually as well as a team.
• Mentoring junior developers by providing technical guidance, conducting sessions and motivating them to meet the tight guidelines & allocating tasks and reviewing them. Ability to handle multiple tasks and work independently as well as in a team.

SKILL:

ERP: PeopleSoft 9.2/9.1/9.0/8.9/8.8/8.3/8. x

PeopleSoft Technical Skills: Application Designer, People code, Application Engine, Data mover, Process Scheduler, PS Query, Security, Workflow, Component Interface, File Layout, SQR, Crystal Reports, Tree Manager, BI Publisher / XML Publisher, Integration Broker, Approval workflow engine, Process Scheduler, Data Mover, STAT and Phire.

PeopleSoft HRMS Skills: Core HR, NA Payroll, Base Benefits, Benefits Administration, Time & Labor and E-Applications.

Reporting Tools: SQR, Crystal Reports, XML publisher, MS Word, Excel, Power point.

Integration Tools: File Layout, Component Interface, Integration Broker, Approval workflow engine.

Databases: Oracle, Toad, SQL Server, DB2, MS Access.

Languages: SQL, PL/SQL, C, C++, Java.

Operating Systems: Windows 95/98/2K/NT/XP, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Responsibilities:

• Working closely with the PeopleSoft Functional leads and end users to understand business needs and solicit detailed data conversion requirements through interviews, research, meetings, and/or existing systems documentation or procedures.
• Working on Analyze, validate and translate business requirements into detailed SQL for extraction of data from PS/Oracle database. Responsible for creating the conversion design and mapping documentation from Peoplesoft to Workday.
• Created Design, mapping documents and developed AE programs for Pay Check StateLocality Tax Balances for Locality, School District, County, State and SUI.
• Developed AE programs for Payroll Earnings, Deductions and Retirement Deduction Balances.
• Developed AE programs for Employee Garnishment, Tax Balances and Tax1042 Balances.
• Worked on Workers Work/City/State/School district withholdings, Employee Compensation, Garnishment Vendors and Period Activity Pay.
• Designed, documented and converted Dependents, Beneficiaries, Employee ABBR(Med/Life/Disb and Retiree Life), Health Care enrollment, Retirement Plans enrollment, Retirement Savings(403 b,457,RCP,415m), Flexible Spending enrollment, Insurance&Disability enrollment, Employee Wellness and Disability data.
• Responsible for basic validation of converted data in the target Workday Environment.
• Assist functional business teams with comparison of data between PS and WD and with debugging of data conversion errors.
• Provide analysis and approach for cleanup of specific data sets in Peoplesoft.
• Conduct requirements analysis and verification, provide technical estimates, ensure that requirements statements are complete, consistent, unambiguous, feasible and verifiable.
• Participate with team members in prioritization of identified requirements.
• Participate in peer reviews and inspections of requirements documents. Provide & update Statuses for the work units in the collaboration tool. Provide overall support to ensure the successful design, testing and implementation of the Conversion programs.

Environment: PeopleSoft 9.2 HCM (Core HR, Base Benefits, NA Payroll, Time & Labor, Compensation, Employee self-service, Manager self-service, Absence, Position Management), Workday (Human Resource Management, Compensation, Benefits, Payroll Management, Time and Absence, Core Connectors, EIB, Reports and Studio), People Tools 8.55, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 11g, UNIX, Phire,Jira.

Confidential, Columbus, OH

PeopleSoft Senior consultant

Responsibilities:

• Involved in PeopleSoft to Workday conversion mapping sessions and prepared mapping documentation.
• Worked on Hire, Prehire, Supervisory organizations, Terminate Employees, Manage Medicare, Dependent Benefits, Workers Work/City/State/School district withholdings, Edit Career interests, Manage develop items etc conversion.
• Worked on complex conversion programs like Health Care, Life insurance, Base Pay compensation, Dependent Benefits, History Payments etc
• Created around 20 plus csv files using application engine programs for Workday conversion.
• Prepared technical documentation like GL interface, Deductions, Earnings, Deferred compensation for associates and agents based on existing documentation, meetings and programs.
• Written complex SQLs to extract PeopleSoft data.
• Created data mover scripts to move cross-walk data between DEV to UAT environments along with Phire migration.
• Created cross-walk records and loaded data for mapping between PeopleSoft and Workday.
• Worked on Workday Reports, EIBs.
• Migrated project objects to environments using Phire.

Environment: PeopleSoft 9.1 HCM (Core HR, Base Benefits, NA Payroll, Time & Labor, Compensation, Employee self-service, Manager self-service, Absence, Position Management), Workday (Human Resource Management, Compensation, Benefits, Payroll Management, Time and Absence, Core Connectors, EIB, Reports and Studio), People Tools 8.55, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 11g, UNIX, Phire.

Confidential, Irving, TX

PeopleSoft Senior consultant

Responsibilities:

• Worked on STD automation process, which involves developing custom interfaces with SQR, Application Engine to load T&L time into Payroll.
• Developed programs to calculate commission, auto, bilingual, state disability amounts.
• Gathered requirements for custom changes related to wireless and wireline MMRP (Mid Atlantic Medically Restricted Plan) Absence System.
• Worked on technical design of MMRP wireless Absence system.
• Created records, pages, Component and user security.
• Created links using related content services.
• Migrated project objects to test environments using STAT.
• Involved in the Post-Production support.

Environment: PeopleSoft 9.1 HCM (Core HR, Base Benefits, NA Payroll, Time & Labor, Compensation, Employee self-service, Manager self-service, Absence, Position Management), People Tools 8.55, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 11g, UNIX, STAT 5.5,Agile.

Confidential, Cheyenne, WY

PeopleSoft Senior consultant

Responsibilities:

• Worked on upgrade PeopleSoft 8.8 to 9.2, as part of this prepared technical specks.
• Retrofitted Records, Pages and Components and tested smart HR tranctions.
• Involved in the Post-Production support.
• Configured Approval Workflow Engine and done unit testing.
• Fixed defects from SIT and UAT, which involves design issues and/or missing code changes and suggestions on requirement changes during the development.
• Worked on work requests from business, which involves developing custom interfaces with SQR, Application Engine.
• Developed Fluid pages and configured Dash boards, Work centers.
• Created Pivot Grid for Head Count based on Department and Company.
• Migrated SQL objects and custom objects to UAT and Parallel test environment.

Environment: PeopleSoft 9.2 HCM (Core HR, Base Benefits, NA Payroll, Time & Labor, Compensation, Employee self-service, Manager self-service, Position Management), GL, AP, AR, People Tools 8.54, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 11g, UNIX.

Confidential, Alpharetta, GA

PeopleSoft Lead Consultant

Responsibilities:

• As part of PeopleSoft 9.0 to 9.2 HCM upgrade, worked on retrofits, customizations and Data Conversions.
• Assisted the team with technical issues.
• Configured Approval workflow engine setup and solved critical issues.
• Worked on component performance issues.
• Done Compare report analysis and documentation activities.
• Worked on project migration issues in various phases of migrations.
• Involved in the object security and resolved issues.
• Developed Fluid pages and configured Dash boards, Work centers.
• Involved in the system integration testing and resolved UAT issues.
• Reviewed the deliverables at different phases of testing.

Environment: PeopleSoft 9.2 HCM (Core HR, Base Benefits, NA Payroll, Employee self-service, Manager self-service, Position Management), GL, AP, AR, Project Costing, Travel and Expenses, People Tools 8.54 Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 11g, UNIX.

Confidential, Atlanta, GA

PeopleSoft Senior Lead Consultant

Responsibilities:

• This is an Annual Maintenance Support project, as part of this performed tasks like Issue Analysis, preparing technical specs, working on enhancements, QA, preparing QA documents and assisting team members.
• Stream lined Tax Update applying procedure and prepared sequence of steps document.
• Responsible for applying tax updates which includes initial analysis, retrofitting and customizations.
• Worked on STAT migrations.
• Developed complex rules including overtime based on shifts and shift allowances.
• Customized Approval Workflow Engine (AWE) to send notifications of an inactive delegate from day prior to inactive/termination date of the proxy.
• Developed complex rules including overtime based on shifts and shift allowances.
• Created new application engine program to update TL/TR Status for offset employees.
• Worked extensively on Rules Prioritization in a Rule Program, besides resolving issues using Customized SQL Objects, User Exits and Actions & Conditions.
• Developed and Customized Time and Labor Rules which included Daily Threshold, Missing Punch, Specific Day, Premium zone and Shift Premium
• Done impact analysis as part of customizations.
• Worked on Benefits related issues.
• Worked on issues related to Job Data Integration Broker messages.
• Worked on Compensation reports.
• Worked on compilation of Cobol programs after migration.
• Prepared tax update production Migration document and involved in the production migration.
• Reviewed development items and unit test documents.

Environment: PeopleSoft 9.1 HCM (Core HR, Base Benefits, NA Payroll, Employee self-service, Manager self-service), Time and Labor, People Tools 8.53, Application Engine, BI Publisher/XML Publisher, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 9.x, UNIX, STAT.

Confidential

PeopleSoft Senior Consultant

Responsibilities:

• Worked on upgrade from PeopleSoft HCM 8.9 to 9.1.
• Worked closely with the functional team to understand upgrade requirements and the customizations required.
• Analyzed the Compare reports.
• Retrofitted online objects, PeopleCode, SQR’s and Application Engine Processes.
• Witten multiple data conversion application engine programs as part of upgrade.
• Developed an XMLP report for generating PDF file output to get data of all transfers for a particular or group of departments.
• Worked on Benefits admiration customizations.
• Developed an restartable Application engine program to run all conversion programs sequentially.
• Developed technical specification documents and reviewed other team member work items.
• Involved in the migration activities throughout the project.

Environment: PeopleSoft 9.1 HCM (Core HR, Base Benefits, Ben admin, NA Payroll, Employee self-service, Manager self-service), Time and Labor, People Tools 8.48, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 9.x, UNIX.

Confidential

PeopleSoft Senior Consultant

Responsibilities:

• All ESS Objectives and comments added by employee during Review Self Evaluation should be available for manager’s real time when they access the document via Perform Manager Evaluation.
• Comments entered by employee should be available in all sections except “Employee Comments” section when manager access the document. (this is in to the section where employee comments on the manager’s appraisal).
• The Employee Comments box should be available only in following sections:
• Section 1 - Bus./Conservation Objectives (Multiple Comments boxes).
• Section 2 - Prof. Development Objectives (Multiple Comments boxes). Only Summary.
• Section 3 - Competencies (Competency summary).
• Section 4 - Overall Rating (Overall Rating Summary),View other authors link needs to be disabled for all the above sections.
• Prepared technical specification and unit test documents.
• Prepared user manual and taken sessions.
• Developed application engine program to report tree node level details.

Environment: PeopleSoft 9.1 HCM (Employee self-service, Manager self-service, Performance Management), People Tools 8.48, People Code, Oracle 9.x.

Confidential

PeopleSoft Senior Consultant

Responsibilities:

• Worked on upgrade from PeopleSoft 8.8 to 9.1.
• Involved in identifying the customization items and worked on the time estimates for the items.
• Participated in fit/gap sessions to understand the delta changes in the modules.
• Retrofitted online objects like records, pages and components.
• Developed new AE program for Kronos process.
• Retrofitted SQR interfaces.
• Tested multiple upgraded objects.
• Analyzed the new requirements and prepared technical design documents.
• Reviewed the QA documents.

Environment: PeopleSoft 9.1 HCM (Core HR, Base Benefits, NA Payroll, Employee self-service, Manager self-service), People Tools 8.48, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 9.x, UNIX.

Confidential

PeopleSoft Specialist

Responsibilities:

• My Pay Calendar template been developed for Confidential . As part of this created records, pages, Components and Component Interface. The main functionality is to load the pay calendar for multiple company and pay groups.
• My Pay Communication system has been developed for Confidential . As part of this created records, pages, Components and developed SQR. The main functionality is to improve the communication to their employees.
• Provided PeopleSoft Support and Upgrade services (8.3 to 9.1).
• Done impact analysis of tax updates.
• Applied tax updates.
• Ran ‘H’, ‘R’, ‘O’ and ‘X’ Payrolls as part of tax update testing.
• Involved in analyzing and resolving Production HR, Benefits, Payroll issues.
• Retrofitted SQRs and online objects as part of Upgrade.
• Worked on Unix scripts to which will be scheduled through Main frame system.
• Estimation of changes which are required as part of upgrade.
• Worked on multiple object customizations like online, SQR and cobol.

Environment: PeopleSoft 9.1 HCM (Core HR, Base Benefits, NA Payroll, Employee self-service, Manager self-service), People Tools 8.48, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 9.x, UNIX.

Confidential

PeopleSoft Specialist

Responsibilities:

• Worked on upgrade from PeopleSoft 8.0 to 9.0.
• Worked as part of requirement gathering team.
• Involved in identifying the customization items and worked on the time estimates for the items.
• Participated in fit/gap sessions to understand the delta changes in the modules.
• Worked on retrofitting queries.
• Analyzed compare reports.
• Reviewed technical design documents.
• Worked on online, sqr and cobol migrations.
• Worked on application engine performance issues.

Environment: PeopleSoft 9.0 HCM (Core HR, Base Benefits, NA Payroll), GL, AP, AR, Project costing, Travel and Expense, People Tools 8.42, Application Engine, Component Interface, People Code, SQR, SQL, PS/Query, Oracle 9.x, UNIX.