SUMMARY:

• 15 years of experience in PeopleSoft HRMS Implementation, Customization, Interfaces, Reporting, Production Support, Upgrades and maintenance.
• Technical expert in using Application Designer, PeopleCode, Application Engine, SQR, Component Interface, Crystal Reports, and nVision, Process Scheduler, PS Query, Process Monitor, Data Mover, Application Messaging, Application Packages, File Layout, Integration Broker, XML Publisher.
• Functional Expert in Base Benefits, Benefits Administration, Payroll Interface Export.
• Sound experience in developing, customizing, debugging and performance tuning Custom Applications built with People Tools for new Functionality in PeopleSoft HRMS modules.
• Functional experience in HR, NA Payroll, Benefits, Benefits Administration, Payroll Interface Global Payroll, and e - Modules (eRecruit, eBenefits, ePerformance, TAM, CG), ESS, MSS.
• Knowledge in Time & Labor Module.
• Knowledge in HTML 5, CSS 3, JavaScript
• Knowledge in PeopleSoft FLUID technology.
• Functional experience in Finance (eProcurement and eSettlements).
• Experience with setting up Application Messaging and writing Publish/Subscribe People Code.
• Experience in creating and modifying the Application Packages.
• Expert in writing & troubleshooting Application Engine Programs. Built application engine programs to ensure data integrity and third-party interfaces.
• Technically proficient in report writing using SQR, XML Publisher, Crystal Reports, PS/Query and nVision.
• Developed new SQR programs to create Inbound/Outbound interfaces. Expertise in developing SQR Programs and Application Engine processes, interfaces (Inbound and outbound) and reports.
• Worked as Technical Lead for a team of 4 to 8 members in different projects. Performed peer review of the development and testing done by the team before submitting them to user reviews and PROD.
• Helped the team members in mentoring/teaching the technical skills for newly joined team members
• Helped the team members in solving the technical doubts they have during their development.
• Strong working knowledge in RDBMS (ORACLE, SQL Server and DB2)
• Very good analytical thinking and team player with excellent communication and inter-personal skills with the ability to work under pressure and with General Direction to meet deadlines with exceptional results.
• Expert in Analyzing Business requirements, creating Functional specifications and Technical Design documentation.
• Responsible for gathering information from client, customers, core users regarding data and business processes and make proper documentation

TECHNICAL SKILLS:

PeopleSoft: PeopleSoft v 9.2/9.1/9.0/8.9/8.8/8.3/8.0

Modules: HR, NA Payroll, Benefits, Benefits Administration, Payroll Interface, Global Payroll, Time & Labor, Candidate Gateway, Talent Acquisition Management, Time & Labor, eBenefits, eSettlements, eProcurement.

People Tools: Application Designer, FLUID, PS/Query, Application Packages, Application Engine, Process Scheduler, People Code, Component Interface, File Layout, XML Publisher, SQR, Data Mover, HTML 5, CSS 3, JavaScript, Process Scheduler, Import Manager, Integration Broker,Maintain Security.

Other Tools: Mainframes OS390 environment and JCL, MQC, STAT,TOAD, WINSCP

Languages: RDBMS

Operating System: PeopleCode, C, SQL, C++, Java,Oracle, DB2, MS SQL Server,Windows 98/NT/2000/XP

PROFESSIONAL EXPERIENCE:\

Confidential, Washington D.C

Senior PeopleSoft Technical Consultant

Responsibilities

• Responsible to gathering of information from client, customers, core users regarding data and business processes and make proper documentation.
• Involved in preparation of Technical Specifications and Functional specs and Unit Test and Implementation plans.
• Customized Total Rewards Module to show company provided benefits, salary and leaves for all companies.
• Involved in analyzing, designing and developing TAM/eRecruit module.
• Customized TAM self service module for Staff, Consultants and Contractors to view job postings.
• Created some reports based on Staff, Consultant Recruitment status.
• Involved in creating workflows based on the status of recruitment process.
• Worked as Offshore team and code reviews of the development and testing done by the team before submitting them to user reviews and PROD.
• Responsible for moving the code to PROD after having UAT done with the users.
• Helped the team members in solving the technical doubts they have during their development.
• Involved in activities like running ad hoc processes as requested by the users.
• Created new Pay Calendar RUN ID’s for Biweekly and Monthly Payroll Export Processes as part of Year End Processes.
• Involved in IDB Annual Merit pay Processes.
• Customized the existing Post Allowances processes to split the earning codes into two earning codes and Post allowance pages.
• Involved in creating different processes as part of company reorganization.
• Involved in helping the users to solve the NA payroll and Global Payroll process errors that may arise during the payroll cycle.
• Design and development of T&L custom rules, rule program(s) and assigned the rule program to the workgroup changes.
• Involved in customizing/creating new processes for pay roll presheets SQR and Payroll SQR’s
• Involved in modifying the existing people code in methods, functions, classes of application packages to customize the changes.
• Involved in creating Application Engine to create reports using Xml publisher reports.
• Involved in applying data patches for employees in additional pay data panels as part of payroll processes.
• Worked on the Time Admin application engine program when it failed because of the errors caused from an individual employee / incorrect rule /batch issues / workgroup issues / clock issues.
• Involved in setting up of new earning codes/deduction codes as part of housing/travel, etc.
• Customized the existing workflows.
• Customized the existing workflows for employee termination notifications to be sent to particular groups.
• Worked on the integration of Time & Labor & Payroll. Supporting Payroll team for every pay period processing to ensure all the T&L data is loaded correctly by validating the information.
• Worked on Oracle and TOAD.
• Developed IDB customized STA Short Term assignment process.
• Worked on Custom SQRs, App Engines, People Code and other People Tool objects.
• Created online customizations using People Code and People Tools objects.
• Involved in customization of creating fields, record definitions, pages, views using application designer.
• Involved in testing cycles and creating test plans.
• Handing of assigned tickets using BMC Remedy.

Environment: PeopleSoft HRMS 9.1, People Tools 8.54, (HR, NA Payroll, Global Payroll, Base Benefits, Time & Labor, TAM, CG, Oracle 10i, Win NT).

Senior PeopleSoft Techno Functional Consultant

Responsibilities

• Responsible for gathering of information from users regarding data and business processes in the areas of Benefits Administration and Payroll Interface.
• Configured New York New Hire Dependent Eligibility criteria for Payroll Interface for ADP.
• Created several Mappings for Payroll Export Process.
• Created several Payroll Export views for use in Payroll Interface.
• Created new Pay Calendar RUN ID’s for Biweekly and Monthly Payroll Export Processes.
• Configured PSTables, Field Tables, Definition Tables, System Tables in Payroll Export Process.
• Actively involved in configuring the Yen Salary for Japanese Expats by creating a separate Benefit Program and configuring the Eligibility rules, Billing reports and modifying the Deduction calculation views.
• Created new Coverage formulas for the new Benefit Plans.
• Created new Medical plans, Dental plans, Life plans and Disability plans.
• Created new plan attributes for Life Plans and Disability plans using the newly configured Coverage Formulas.
• Created new Rate Plans (Flat Rate & Percent of Base) for use in some of the Medical and dental plan options.
• Configured new Eligibility rules with delivered eligibility criteria fields as well as Elig Config fields.
• Configured new Benefit Program for merging two different benefit programs with the current benefit plans and options.
• Involved in modifying the existing people code in methods, functions, classes of application packages to customize the changes.
• Actively participated in running the On Demand Event Maintainence Process.
• Configured Domestic Partner Setup with several DP options.
• Involved in System testing to ensure a proper configuration over databases in PeopleSoft.
• Preparing standard operating procedures, training, and job aide documents for the Base Benefits, Benefits Administration modules.
• Preparing functional specifications for the technical team to assist with project development tasks.
• Involved in preparation of Technical Specifications based on Functional specs and Unit Test and Implementation plans.
• Developed several queries and executed in Micro Soft Sql server.
• Smooth transition of project, interaction with client.
• Worked on Custom SQRs, XML Publisher Reports, App Engines, People Code and other People Tool objects.
• Involved in creation of record definitions, pages and views.
• Involved in testing cycles and creating test plans.

Environment: PeopleSoft HRMS 9.0, People Tools 8.50, (HR, Payroll Interface, Benefits, Benefits Administration), Microsoft SQL Server, Win XP.

Sr. Technical Developer

Responsibilities

• Responsible to gathering of information from client, customers, core users regarding data and business processes and make proper documentation.
• Analyzing and re-applied the customizations when patches applied.
• Tested, analyzed and retro fitted all Custom SQRs, App Engines programs in v9.1.
• Worked on PeopleCode and fixed tickets on Benefits Depends designations.
• Involved in the PeopleSoft Upgrade Project for Core HR, Payroll, Base Benefits
• Involved in fit-gap analysis between 8.8 and 9.1 and creating requirement documents for all the changes to the interfaces.
• Support and Maintain PeopleSoft HCM v 8.8 system.
• Developed few new interfaces using SQR and Application Engine(with File layout and Component interface)
• Prepared TSD’s (Technical specification Documents) for new interfaces.
• Worked as a supporting team member for Benefit Administration and NA Payroll.
• Tested, analyzed and retro fitted all SQR in v9.1
• Worked on NA Payroll Year-End Processing and generating W-2’s.
• Resolved technical requests raised by Client with a quick turnaround.
• Analyzed SQR programs, People Code, and Application Engine and fixed the issues
• Creation of customized panel to replicate customization of AMEX in 9.1.
• Prepared Technical Specification Document for the issues.
• Worked on functional testing of several interfaces using MQC.
• Created Several Test cases and test scripts.
• Compared output files and input files for 8.8v and 9.1v using beyond compare.
• Used WINSCP for posting the input files and retrieving output files from UNIX.

Environment: Peoplesoft 9.1, People tools 8.50, Oracle 11G, MQC (Mercury quality center), Win XP.

Senior PeopleSoft Techno Functional Consultant 

Responsibilities

• Responsible for gathering information from client, customers, core users regarding data and business processes and make proper documentation.
• Worked as Technical Lead for a team of 8 members. Performed peer review of the development and testing done by the team before submitting them to user reviews and PROD.
• Helped the team members in mentoring/teaching the technical skills for newly joined team members.
• Helped the team members in solving the technical doubts they have during their development.
• Actively involved in running nightly jobs for BenAdmin jobs (PSPBARUN, PSPCOBRA).
• Responsible for running nightly jobs for the Payroll Interface Export and Import Jobs (PI INRUN) and ADP processes the payroll.
• Resolution proposed for several tickets pertaining to Benefits and Payroll modules.
• Worked on several outbound and inbound interfaces to third party payroll system.
• Designing eBenefits end-user training aids for completing Open Enrollment and Life Events.
• System and parallel testing to ensure a seamless transition from legacy system to PeopleSoft.
• Preparing standard operating procedures, training, and job aide documents for the Base Benefits, Benefits Administration and eBenefits modules.
• Preparing functional specifications for the technical team to assist with performance testing and project development tasks.
• Involved in preparation of Technical Specifications based on Functional specs and Unit Test and Implementation plans.
• Involved in closing the events during PSPBARUN.
• Involved in Manual Run of PSPDCRUN before Payroll Processes.
• Responsible for running Payroll Import and Payroll Export Processes.
• Responsible for configuration of Pay Calendars.
• Responsible for manual execution of FIDELITY Inbound and Outbound files before and after PI
• Worked on Oracle and TOAD.
• Smooth transition of project, interaction with client.
• Worked on Custom SQRs, App Engines, PeopleCode and other People Tools objects.
• Developed Queries using PS Query and export the results with Microsoft Excel to perform further calculations and develop reports.
• Created online customizations using PeopleCode and People Tools objects.
• Involved in customization of creating fields, record definitions, pages, views, creating search records using application designer. Worked with People Tools and PeopleCode.
• Involved in testing cycles and creating test plans.

Environment: PeopleSoft HRMS 9.0, People Tools 8.49, (HR, Payroll Interface, Benefits, Benefits Administration, eBenefits), Oracle 10g, Win XP.

Senior PeopleSoft Techno Functional Consultant

Responsibilities

• Responsible for gathering information from client, customers, core users regarding data and business processes and make proper documentation.
• Involved in the preparation of Technical Specifications based on Functional specs and Unit Test and Implementation plans.
• Worked as Technical Lead for a team of 4 members. Performed peer review of the development and testing done by the team before submitting them to user reviews and PROD.
• Helped the team members in solving the technical doubts they have during their development.
• Developed a custom Application Message in HR side which is used to post the modified, added or deleted data both in Finance and OASIS databases when ever changes are made on the HR Page.
• Worked exclusively on Integration Broker. Configured Messages, Queues, Services, Service operations, Routings in all three databases.
• Developed Crystal Report for Finance module.
• Modified existing PSQuery reports.
• Worked on nVision for developing finance reports.
• Worked on Oracle and TOAD.
• Smooth transition of project, interaction with client.
• Worked on Custom SQRs, App Engines, PeopleCode and other People Tools objects.
• Developed Queries using PS Query and export the results with Microsoft Excel to perform further calculations and develop reports.
• Created online customizations using PeopleCode and People Tools objects.
• Involved in customization of creating fields, record definitions, pages, views, creating search records using application designer. Worked with People Tools and PeopleCode.
• Involved in testing cycles and creating test plans.
• Handing of assigned tickets using SharePoint and creating of TrackIds using Tracker.

Environment: PeopleSoft HRMS 9.0, People Tools 8.49, (HR, Payroll, Benefits, ESS, MSS), Oracle 10g, Win XP.

Senior PeopleSoft Technical Consultant

Responsibilities

• Developed a Challenging custom Application Engine Program LWSAP038 which triggers escalation emails to requestor, supervisor and so on up to VP level if the vouchers have exceptions and not corrected during the stipulated time.
• Development of SQRs LWSPV001 to LWSPV012 based on Business Requirements specific to eProcurement, and eSettlements modules.
• Developed a custom Application Engine Program with CI for loading requisitions from FS89 to FS84.
• Developed report links for 12 custom reports in a single page there by when a user clicks on the report link it will open up the search page and the required parameters that are essential for that report only.
• Worked on SQR to create Outbound, Inbound Files.
• Involved in preparation of test and Implementation plans.
• Modified existing PSQuery reports.
• Worked on DB2, Mainframes OS390 environment and JCL.
• Acquired knowledge of Lowes Standards like CRQ Process, Endeavor and BMC Utility.
• Supported Production issues related to delivered and customized SQRs.
• Smooth transition of project, interaction with client.
• Provided technical and process guidance to other team members in reaching project milestones.
• Developed reports using nvision.

Environment: PeopleSoft FSCM 8.4,8.9, People Tools 8.46, (AP, eprocurement and esettlements), DB2,WINNT.

PeopleSoft Global Payroll Technical Consultant

Responsibilities

• Involved in setting up several payroll elements and rules in the existing payroll.
• Worked on SQR to create Outbound Files.
• Unit testing for all the developed objects.
• Uploading Positive Input and Earning Deductions inputs as requested by the user during the pay period.
• Involved in preparation of test and Implementation plans.
• Supported Production issues related to delivered and customized SQRs.
• Smooth transition of project, interaction with client.

Environment: PeopleSoft HR Global Payroll 8.9, People Tools 8.46, DB2.

Confidential, Minneapolis, MN

PeopleSoft Technical Consultant

Responsibilities

• Developed 3 custom application engine programs to offer team members a Health Care Discount Card which generates an Eligibility file, Inbound Payroll Deduction file and Outbound Deduction Reconciliation File.
• Developed TGTBN116 and TGTBN117 inbound and outbound deductions interface programs which are used to get the data on the file to populate the team member’s general deductions and actual payroll deductions taken.
• Customized the Enrollment Summary Page (W3EB ENR SUMMARY) by hiding all plan types except plan type “61” in DFSA Open Enrollment.
• Developed an SQR TGTBN112 which will update deduction begin date in Bas Partic Plan Table for plan type 61.
• Involved in Bug fixing for SQR reports, code and enhancements to the existing system.
• Interacted with clients and overseas Team
• Worked on DB2, Mainframes OS390 environment and JCL.
• Worked on Stat for creating CSR’s and locking of objects.
• Performed PeopleSoft Testing using Test Director.
• Compared SQRs in production environment and Development environment before and after actual changes are made to them.

Environment: PeopleSoft HRMS 8.8, People Tools 8.45, (HR, Payroll, Benefits,), DB2, Win XP.

PeopleSoft Technical Consultant

Responsibilities

• During this period I have provided Support in HR, Payroll and Benefits modules.
• I have modified/enhanced existing custom SQRs and Application Engine programs.
• Created Component Interface/App Engine/File Layout program to do company Reorganization.
• Involved in the modification of various Payroll and Benefits pages and validating the data fields using PeopleCode.
• Wrote Component Interface Programs for uploading HR data from an external legacy system into PeopleSoft.
• Developed new SQR programs to pull the Payroll related data from PeopleSoft HRMS Database and to generate Flat files for determining the total Earnings and Deductions and Taxes for the employees of a given pay group.
• Created SQRs for Inbound and Outbound interfaces to load and exclude the employees into record definitions. Resolved several Inbound/Outbound interface issues. .
• Developed and customized an Application Engine program using Component Interfaces to load changes in employee benefit plans into the BAS ACTIVITY table. This is a batch process which runs in sync with the Benefit Administration process.
• Designed and developed SQR outbound interfaces to generate Flat Files to be sent to the respective carriers.
• Involved in PS Query tools.
• Created online customizations using People Code and People Tools objects
• Involved in Configuration management, Testing cycles and Deployment.
• Interacted with clients and overseas Team using HIPATH Networks.

Environment: PeopleSoft HRMS 8.3, People Tools 8.18, (HR, Payroll, Benefits, Workflow), Oracle 10i, Win NT.

PeopleSoft Developer

Responsibilities

• Responsible for technical deliverables with estimated time line.
• Interacting with client team in analysis, design, development and delivery of work Request in form of ticket.
• Identified the areas of customization and estimated the man-day efforts involved in the design, development, unit testing & integration testing of CRs raised by the client.
• Coordinating with the Offshore Manager.
• Modification and Customization using Application Designer.
• Created new Views, Pages, Component, Menu, Portal Registry and Security Definition.
• Developed many new components, SQRs, Application Engine programs to meet the client requirement.
• Developed and customized PS Queries and Crystal Reports.
• Creating new Security Roles and Permissions for new objects.
• Involved in Impact Analysis and applying patches and fixes.
• Data upload using File Layouts and Component Interface.
• Data Migration using Data Mover.
• Production Migration of Online Objects.
• Performed Unit testing and prepared UTP.
• Prepared Detail Design documents.
• Performed Code Walk through and Design review for tickets which involves Application Engine, Component Interface and SQR.
• Preparation of Weekly status report for Client update, Issue log.

Environment: PeopleSoft HRMS 8.3, People Tools 8.18, (HR, Payroll) Oracle 10i, Win NT.

PeopleSoft Technical Consultant

Responsibilities

• As a team member of project involved in the development and customization of on-line panels, record definitions and menus using People Tools like Application Designer
• Defined Payroll Interface tables to export HR and Benefits data to our third party payroll vender.
• Extensively used People Tools for creation or modification of Process Definitions, Records, Panels, and Menus to run Custom SQRs through PeopleSoft environment.
• Used Application Engine to create applications and performed background SQL processing against the data.
• Involved in Setup of Eligibility rules and Plans in Benefits Administration.
• Used process Scheduler to run the processes & reports through PeopleSoft panels and used process monitor to view the status of the reports.
• Tuned SQL/SQRs to improve performance using advance SQR features like Load lookup and Arrays.
• Developed and customized PeopleSoft objects and created complex SQR reports and processes for HR, Benefits, and Payroll departments.
• Production support including PeopleSoft release upgrades, writing queries using PS Query tool and also created Crystal Reports.
• Used Process Scheduler to schedule processes at a specific time and/or run recursively at a specific interval. Used Process Monitor to view status of the process.
• Developed Queries using PS Query and exported the results into Microsoft Excel and Crystal Reports to perform further calculations and develop reports.

Environment: PeopleSoft HRMS 8.0, Oracle 9i, Windows NT.