SUMMARY

• Over 12+ years of work experience in PeopleSoft as a Senior Technical consultant. Worked on all kind of engagements like Implementation, Upgrade, Data conversion, Support and Maintenance projects.
• Expertise in Requirement gathering, Analysis, Solution Design, Development, Customization, and Testing.
• Good understanding of setup and configuration of PeopleSoft HR Modules - Position Management, Administer Workforce, Recruitment Workforce, Competency Management, Performance Management, Compensation Management, Absence Management, Base Benefits, Benefits Administration, Time and Labor, NA Payroll, Employee Self Service (ESS), Manager Self Service (MSS) and Commitment Accounting.
• Strong working noledge on People Tools - Application Designer, Application Engine, People Code, Application Packages, Process Scheduler, Change Assistant, PS Query, XMLP, File Layout, XL to CI, Component Interface (CI), Integration Broker, Application Package, AWE, SQL, Data Mover, PeopleSoft Test Framework(PTF) and SQR.
• Interfaces - Extensively worked on inbound and outbound Interfaces like importing data from flat files (CSV, TXT, Excel) to PeopleSoft tables and exporting data from PeopleSoft tables to files using Application Engine, File Layout, Component Interface (CI), XL to CI and SQR.
• Documentation - 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, Minutes of Meeting (MOM), Weekly Status Reports, Coding Standards Document, End User Training Documents.
• Worked on Data Conversions between PeopleSoft and legacy systems including conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits Data (Dependents Data, Health Benefits, Disability Benefits, Pension Plan and Savings Plan).
• Good experience in Applying Tax Updates, Testing and Deployment.
• Work Experience on UNIX, Windows Servers, Batch Scheduling Application Control-M, and Database Access Tools like TOAD, Query Analyzer, Quest, SQL Plus, Version Control Tool STAT, Phire and Defect Tracking Tools like HP Quality Center and Cherwell.
• Having good experience of Migrations Activities of application upgrade by using STAT and Phire migration tool.

TECHNICAL SKILLS

ERP: PeopleSoft 8.x and 9.x (HCM, CRM and FSCM).

PeopleTools: Application Designer, Process Scheduler, Application Engine, Application Packages, Component Interface People Code, Integration Broker, PeopleSoft (PTF), Change Assistant and AWE.

Reporting Tools: SQR, PS Query and BI Publisher.

Languages: C, C++, Java Script and VB Scripting.

RDBMS: Oracle10g,11g and 12c.

Other Tools: STAT, Siebel, HP Quality Center, Remedy,Cherwell and T.O.A.D.

Operating Systems: Windows XP Pro/2000/NT/7/8 and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

PeopleSoft Senior Technical Consultant

Responsibilities:

• Created Technical design documents and prepared unit test plans.
• Developed a custom process to create pay sheets for inactive employees.
• Involved in running weekly and bi-weekly payroll wif the functional team also assisted in fixing the issue.
• Created custom process to load data into the pshup table.
• Developed fluid pages for the employee self-service requirements.
• Migrated WorkCenters configuration into different environments.
• Retrofitted Actuals GL Interface process and created test cases as per the requirement.
• Worked on HCM to FIN integration to publish data from Payroll to GL.
• Create an interface to send payroll deduction information to 3rd party vendors.
• Converted multiple deduction load SQRs into an application program.
• Worked on commitment accounting fiscal year rollover process changes and fixed the issues.
• Developed custom encumbrance process for calculating encumbrance.
• Created new custom process to update Department budget table based on the custom setup.
• Developed forms for department budget entries (DBT) and implemented AWE for approvals.
• Worked on year-end processing and created scripts for retro funding.
• Created scripts to redistribute fringe and publishing the accounting lines to finance for running the GL process.
• Developed reconciliation reports to find discrepancies pre-distribution and post-distributions.
• Worked on fixing the issues in PSPPFUND process failure
• Worked retrofitting online, batch (SQR, AE) objects.
• Developed XMLP and SQR reports for data analysis.
• Worked on the work study interface changes.
• Customized the Smart HR templates based on the functional requirements and implemented AWE for Smart HR templates.
• Involved in Application Engine and SQR performance tuning activities.
• Migrated projects using Phire.
• Monitored and worked on budget data issue during post go-live support.
• Worked on accounting lines cleanup related to payroll expense transfers for year-end processing.

Confidential, Atlanta, GA

PeopleSoft Senior Technical Consultant

Responsibilities:

• Working wif the users to understand their business requirements and supporting in performing day to day activities.
• Involved in interacting wif end users in requirements gathering.
• Involved in providing estimations to the client.
• Created the technical and functional specification documents for various customizations, Bolt-on objects and reports.
• Involved in end-user training on various enhancements and bolt-on objects in T&L.
• Worked on the configuration of Time and Labor setup along wif the development of rules for calculation of employee payment.
• Developed rules including overtime, exception, allowance, regular payment and others.
• Recorded test scripts using PeopleSoft test framework (PTF).
• Edited test framework (PTF) scripts based on client requirement.
• Customized application engine program, SQL’s related to time and labor to remove some of trc’s(Exclude International Travel (TVL) from Shift Premium) which are not needed.
• Created new application engine program to update tl tr status for T&L offset employees.
• Worked on issues wif Absence Hours in Time & Labor.
• Developed process for Custom an Accruals in Absence Management.
• Worked on developing XML reports as per the user requirement.
• Customized Approval Workflow Engine (AWE) process as per the customer requirements.
• Prepared the UTD documents and performed the lead review.

Confidential, Morristown, NJ.

Senior PeopleSoft Technical Consultant

Responsibilities:

• Created technical design documents and prepared unit test plans.
• Developed custom vacation processes for Canadian employees
• Developed multiple job submission utility for running all payroll processes/jobs for selected run IDs.
• Developed new process for linking pay calendars wif the runid.
• Developed new custom process to transfer general deductions and garnishments.
• Modified the direct deposit reports for Canada and US.
• Applied tax updates, performed testing and deployment.
• Worked on debugging retro pay issues and provided a solution to the user.
• Supported various testing phases.
• Worked on debugging application messaging issues.
• Played a key role in go-live activities.
• Provided post go-live support for the smooth running of payroll.
• Involved in performance tuning activities.
• Worked on changes assistant to apply tax updates.
• Worked on Benefits Administration issues during open enrollment.
• Worked on multiple customizations in NA Payroll, Core-HR, Benefits and Absence Management.

Confidential, Atlanta, GA.

PeopleSoft Technical Consultant

Responsibilities:

• Scheduling and monitoring of jobs for various clients.
• Involved in debugging the process failure issues in the production environments.
• Monitored Application Messages for the smooth passing of messages between the different instances.
• Customized SQR and Application Engine programs according to the client business requirement.
• Developed new application engine program to perform initial verification testing using 3rd party tool.
• Developed various EXCEL to CI utilities to load the data into the PeopleSoft system.
• Performed project backups and migrating projects into various PeopleSoft instances.
• Developed DMS scripts for importing and exporting of data between various PeopleSoft instances.
• Participated in production maintenance activities.

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Prepared Technical Design Documents for components, SQR and Application Engine Programs.
• Prepared test plans for custom components by studying the functionality of the components.
• Involved in customizations, which included creating/ Modifying Fields, Records, Pages, Components and Menus based on the requirements of the client.
• Created queries using PeopleSoft Query and SQL editors.
• Created and Modified SQR Reports.
• Validations to the pages and records through People Code.
• Worked on Data Conversions between PeopleSoft and legacy systems including conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits Data (Dependents Data, Health Benefits, Disability Benefits, Pension Plan and Savings Plan).
• Extensively used Application Engine for data conversion.
• Created new Run Control Records and customized panels and attached it to the Process Scheduler to run SQR reports.
• Proficient in developing SQR's including interfaces and conversion reports using important SQR features like On-Break logic, Load-Lookup, Arrays and multiple reports.
• Created new process definitions using process scheduler manager, assign components to particular process groups (Business Users group) specified by the client.
• Developed new Application engine programs, File Layouts, Record definitions, pages, components, people code programs and Component Interfaces to meet client requirements.

Confidential

PeopleSoft Developer

Responsibilities:

• Prepared Technical Design Documents for Components, SQR and Application Engine Programs.
• Customized Sign-on functionality and implemented LDAP for HRMS and FSCM modules.
• Developed custom pages, components, and Application Engine program for excluding specified users from LDAP authentication.
• Created new Security sets and implemented row-level security.
• Customized the Security by permission list functionality to load supervisors under the given managers.
• Created new recurrences and process definitions for scheduling the processes/jobs.
• Prepared unit test plan for custom and retrofitted components by studying the functionality of the component.
• Prepared Impact analysis Document for Retired functionality object.
• Participated in Build Phase, Unit testing, System integration testing and User acceptance testing.

Confidential

PeopleSoft Developer

Responsibilities:

• Prepared Technical Design Documents for components, SQR and Application Engine Programs.
• Prepared Impact analysis Document for Retired functionality object.
• Prepared unit test plan for custom components based on the functionality of the component.
• Prepared unit test plan for retrofitted Code.
• Participated in Build Phase, Unit testing, System integration testing and User acceptance testing.

Confidential

PeopleSoft Developer

Responsibilities:

• Prepared Technical Design Documents for components, SQR and Application Engine Programs.
• Prepared Impact analysis Document for Retired functionality object.
• Prepared unit test plan for custom components based on the functionality of the component.
• Participated in Build Phase and Unit Testing for HRMS and CRM.
• Designed custom records, pages, components to run the SQRs through Process Scheduler for passing input parameters and also to give the Users option to run the program in Update/Non Update mode. Ran the COBOL and SQR programs in JCL.
• Involved in customizing and adding PeopleCode to the existing code as per business requirement. Debugging of PeopleCode using built-in PeopleCode debugger utility.
• Redesigned, engineered to convert the SQR program to Application Engine program for faster execution.
• Extensively involved in debugging of Application Engine and AE PeopleCode programs using Command line.
• Designed and created Inbound and Outbound Application Engine programs using File Layout.
• Wrote Application Engine program which sends an email notification whenever their is a failure or success of the batch process to specified recipients.
• Worked on case component customizations.
• Worked on customer 360-degree view changes.
• Developed integration between CRM and HCM.
• Created DMS script exporting AAF policies to different environments.

Confidential

PeopleSoft Developer

Responsibilities:

• Created the Datasets which suites for all reports of a particular application.
• Worked on Datasets designing and Dataset element properties.
• Created the user profiles and assigned the roles & permissions lists.
• Developed new record, pages and components.
• Developed queries and tuned the SQLs.
• Developed new records, pages, components, PeopleCode, application engine programs, SQRs as part of new development.
• Developed and modified complex People Code validations and to populate pages/components as per the client’s requirement.
• Developed and modified Application engine programs as per the requirement.
• Created custom Permission lists Roles and User Profiles to implement operator security
• Involved in troubleshooting and problem resolution for various problems during Unit, functional and System/Cycle Testing.
• Extensively worked on PeopleCode, Application Designer, Application Engine, Component Interface, and SQL.
• Developed queries and Role queries using PS-Query tool.