SUMMARY:

• Senior PeopleSoft consultant with 10+ years of experience, which includes ERP Implementation, Upgrade and Support, Analysis, Design, Development, Customizing & application software development in the area of PeopleSoft HCM Versions 9.2/9.1/9.0/8.9/8. 8 and Modules Core HR, North America Payroll, Time and Labor, Absence Management, ESS, MSS, Base Benefits, Benefits administration and ePerformance, Recruiting, ELM, GL and Campus Solutions.
• Worked Extensively on PeopleTools, Application Messaging, PeopleCode, Application Engine, Component Interface, File Layouts, Integration Broker, XML Publisher, PS Query, SQR, Crystal Reports, Workflow Processing and Approval Framework.
• Experienced in PeopleSoft Upgrade, Devising Implementation Methodology, Reporting, Interfaces, Conversion Strategy, Enhancing, Production Support and Troubleshooting.
• Extensively involved and worked with Security Administrator to implement security in various levels like Roles, Permission Lists, User Profiles, Portal Security, Query/Tree Security and Definition Security.
• Hands on Experience in Developing and Customizing of PeopleSoft objects using Application Designer, PIA/Online, Integration Tools, Reporting Tools, PeopleTools, Data Mover and SQL Scripts.
• Experienced in working with technical issues with SQR programs, Application Engine Programs, Migrating Objects and Projects between databases.
• Experienced in Performance tuning of processes. Well versed with Debugging tools like SQL trace, PC debugger, AE trace and SQR trace for troubleshooting.
• Understanding the functional design documents to develop Technical Design Document along with test strategy / test plan.
• Involved in validating the current issues in the system as reported in Rally and addressing the issues as per the Scheduled release plan in the Sprint.
• Extensive knowledge of IT software development life cycle methodologies and processes
• Involved in requirement gathering, fit - gap analysis, design, development, Testing and documented processes.in Agile/ SCRUM methodologies.
• Experience in planning and clearly documenting the business needs using techniques like use cases, in a To-Be, as-Is manner.
• Developed several DMS and UNIX scripts for the Integration Projects.
• Excellent Analytical and Communication Skills and ability to work independently with minimum supervision and perform as part of a team. Ability to work under competing deadlines in challenging and cross platform environment

TECHNICAL SKILLS:

ERP: PeopleSoft 8.8/8.9/9.0/9.1/9.2

People Tools: 8.x, Application Designer, XML Publisher, Application Engine, Application Package, PeopleCode, File Layout, Data Mover, Tree Manager, Mass Change, Process Scheduler, Application Package, Component Interface. Integration Broker.

Database: Oracle7.x/8.x/9.x/10g/11g, DB2, SQL Server.

Operating System: Unix, Windows NT, Windows 2000, Windows 98, Windows XP, Linux.

Reporting Tools: PS Query, SQR 4.x/6.x, XML Publisher, Crystal Reporting.

Programming Languages: PeopleCode, SQL, SQR, Java 2.0, PL/SQL, C, C++.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. PeopleSoft Technical Consultant

Environment: PeopleSoft: 9.2 and 9.1, Peopleools 8.55

Responsibilities:

• Involved in pre-analysis, fit-gap analysis, upgrade analysis decision making and coordinating upgrade team progress to the client.
• Involved in design and development of code related to retrofit objects while upgrading.
• Integration Broker, Formulating test strategy for the HCM and ELM product and testing using the PTF.
• Involved in Organizing and validating the current system and ensuring that all are traceable and measurable Prepared and consolidated functional requirements on PeopleSoft
• Prepared and reviewed test cases for requirements.
• Attended high level meetings and providing project plan updates and project status updates to project manager.
• Reviewing new versions of PeopleSoft and recommending how to use new functionality to solve complex business problems.
• Responsible for the analysis, design of Interface programs, documentation, testing of outbound interface and custom objects created as part of upgrade.
• Core HR, Benefits, Payroll, ELM (enterprise learning management) upgrade and HCM upgrade
• Assisted for unit system, UAT and parallel run testing phases. Worked with the test manager to ensure all testing was completed and documented issues raised, resolved and regression tested

Tools: /Skills: People Tools 8.51/8.55, PeopleSoft HCM 9.1/9.2, HR, T&L, Payroll, ELM, ESS, SQLApplication Designer, Application Engine, ePerformance, Workforce Admin, PeopleCode, Component

Confidential

Sr. PeopleSoft Technical Consultant

Environment: PeopleSoft: 9.2 and 8.9, PeopleTools 8.55

Roles and Responsibilities:

• Involved in requirement gathering, fit-gap analysis, design, development, Testing and documented processes, Agile/ SCRUM methodologies (used Rally tool).
• Involved in validating the current issues in the system as reported in Rally and addressing the issues as per the Scheduled release plan in the Sprint.
• Reviewing new versions of PeopleSoft 9.2 and recommending how to use new functionality to solve Complex business problems.
• Executed the implementation of BOLT-ON objects to the delivered PeopleSoft 9.2 and Responsible for applying the HRMS version 8.9 changes to over 9.2customized SQR Programs.
• Completed the upgrade to PeopleSoft HCM version 9.2. Determined which customizations to apply to the upgrade database. Re-retrofitting the customization impacted after applying patches in 9.2.
• Involved in applying the Tax updates.
• Worked on Customization - Extract CA Non-Tax Deductions Application Engine -(PYAP XDEDNCA), and Extract US Federal Taxes/State Taxes Application Engine -(PYAP XTAX)
• Retrofitted and created new rules in Time and labour as per the client requirement.
• Worked on Setting up the core records for Benefit Administration. Records include Benefits Cost Setup, Eligibility Rules, Event Rules, Program Definitions, etc.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to People Soft HEALTH BENEFIT Table, LIFE ADD BEN Table, SAVINGS PLAN Table, LEAVE PLAN Table, and LEAVE ACCRUAL Table.
• Configured AWE Baseline Configuration in TL, Migrated Time and labor rules using DMS Scripts.
• Customized BAS Group on Demand - Reset Employee BAS group values according to functional requirements.
• Extensively worked on: complex Direct Deposit Files,pay check, Direct Deposit SQR’S and SQC’S ddp001, pay003,ddp003 as per the client requirement to print the paycheck information.
• Customized payroll Pay Period Reports - Payroll Summary (SQR:PAY018), Payroll Register (SQR:PAY002), Deduction Register(SQR:PAY001), Other Earnings Register (SQR:PAY006) according to Business requirements.
• Extensively worked on converting 8.9v crystal reports to BI Publisher 9.2v.
• Wrote Peoplecode to accomdate the various changes for the Self Service Pages required by the client.
• Created various Permission lists, Users Roles and assigned roles to Users.

Environment: PeopleSoft HRMS 9.2(HR, Payroll, Time & Labor, Benefits, Benefits Administration, e-Recruit, Self-Service Modules), PeopleTools 8.55 (SQR, App Engine, Integration Broker, PeopleCode, SQL, PS/Query, Query Manager)

Confidential

Sr. PeopleSoft Technical Consultant.

Environment: PeopleSoft: 9.2 and 8.9, PeopleTools 8.55

Roles and Responsibilities:

• Involved in requirement gathering, fit-gap analysis, design, development, Testing and documented processes.
• Involved in running Upgrade scripts using Change Assistant for the Upgrade process and analyzed Upgrade Compare reports to identify and document existing customizations.
• Involved in Data Conversion from the legacy System in to Oracle using SQL*Loader, DMS scripts and SQRS. Developed number of conversion scripts and uploaded data. Used Change Assistant tool to move the objects
• Used People Tools in carrying over the customizations from the existing version to new upgrade version. Extensively used Application Designer for creating new objects, modifying the existing customizations and bringing them over successfully to latest version.
• Resolved a security issue where row level security functionality was no longer available after the application was upgraded..
• Developed a batch Application Engine which uses Component Interface to load General Deductions and Garnishments for each employee to reflect the company changes.
• Customized the eBenefits module according to functional requirements so that the employee has the ability to review and update benefits information online
• Designed the new Run Control pages and attached to the Menus to run various SQR’s and AE’s.
• Developed an application engine process that builds Time and labor Dynamic Groups each pay period.
• Developed ad-hoc queries using Application engine and File Layout with CSV output to report activity information for a given pay period range.
• Developed ad-hoc queries reports using Application engine in Time and labor that select against the User Field1 and indicate whether a time reporter has confirmed their time or not.
• Restricted access to activity codes in Time and labor using row level security.
• Developed a component for department users to maintain their lists of available TRCs and Enforced row-level security access to restrict data access IN T&L.
• Created new SQR Programs to update Annual Base Salary, and to add new Benefit programs, Plan, Plan Types and automated Benefit Admin Process.
• Involved in creating of Task Groups and establishing Time Periods, Calendars, Shifts, work schedule templates and work groups.
• Worked on setting up HSA and FSA Retirement Benefits.
• Developed SQR Report to Calculate the Accumulated Contributions for all the Employees based on the Benefit Plan, Employee Contributions and year.
• Developed Application Engine Process to Evaluate Retirement Indicators based on Employees Birth & Service Dates.
• Modified 401K Interface to change the employee company.
• Retrofitted Integration Broker Service Operations including Routing configuration and Handler Peoplecode.
• Developed new queries using XML Publisher to replace some existing SQRs.
• Developed SQR Report to Calculate the Accumulated Contributions for all the Employees based on the Benefit Plan, Employee Contributions and year.
• Effectively utilized tools and utilities provided by PeopleSoft (Debugger, tracing etc.) for trouble shooting issues on PeopleCode, Application Engine, SQR’s.
• Customized the Benefit enrollment letter for terminated employees.
• Identified & written custom scripts to enable users to specify which ABBR to use for a Benefit Plan. (Multiple Annual Base Benefit Rates).
• Developed an Application Engine Program which fetches data from PS EMPLOYEES table based on paygroup criteria and send email.

Environment: PeopleSoft HRMS 9.2(HR, Payroll, Time & Labor, Benefits, Benefits Administration, e-Recruit, Self-Service Modules), PeopleTools 8.54 (SQR, App Engine, Integration Broker, PeopleCode, SQL, PS/Query, Query Manager)

Confidential

Sr.PeopleSoft Developer

Responsibilities:

• Ran and reviewed the Initial Audit reports against copy of production to ensure that database is clean and also checked performance.
• Applied pre and post upgrade fixes and customized the pages according to change requests.
• Developed Payroll Interface configuration and mappings. Worked with Confidential performing partner relation.
• Developed new reports using SQR and Crystal Reports for HR module.
• Created Application Packages to validate and move the applicant data from e-Recruit to HR Module.
• Successfully completed the performance evaluation for the ePerformance module wherein a manager can perform performance evaluation of his employees .
• Extensively worked on Process Scheduler, Tree Manager and Query Manager.
• Provided Security to various Menus, Components & Pages using Security Administrator and also Added Folders and Content references using Portal Administrator.
• Involved in debugging Application Engine programs and PeopleCode using PeopleCode Debugger.
• Worked with Integration Broker to Interact with 3rd Party Application.
• Designed and developed various Application Messages to publish data from PeopleSoft to other applications in an Asynchronous mode. The response messages were received using Subscription Messaging.
• Enhanced the Journal a pproval workflow, which includes the approval/deny journal activity and the journal entry approval Rule Set to meet the requirements of the company policy.
• Bug fixing and Trouble shooting of Application Engine and Batch programs using PeopleSoft Debugger.
• Used Integration Broker to publish the Employee information from PS HRMS to other Applications.
• Retrofitted PeopleCode, SQR to accommodate customizations to meet the business requirements.
• Customized the Pay check pdf document xml publisher report as per the business requirements.
• Implementation of Secured check printing and PDF pay check (XML Publisher) to E-Pay.
• Applied Patches and Bundles delivered by PeopleSoft during the upgrade and tested them before applying to the production database.
• Developed PeopleSoft Absence Management - Extended Absences Additional customizations to meet the business process.
• Developed Extended Absences eligibility validation criteria are based on the App Classes for each extended absence. As per client business policy the following plans configured in the system and developed the App Class to meet support the eligibility validation criteria.
• Family and Medical Leave Act (FMLA)( application package GP ABS FMLA with an app class FMLAElig), California Family Right Act (CFRA), Pregnancy Disability Leave (PDL), Family Care Leave (FCL), Paid Parental Leave (PPL)
• PeopleSoft Absence Management doesn’t deliver all the reports required by the business compliance and usability for extended absences. Developed reports which meet the business requirements of client to assist HR Professionals and other groups to track the leave usage and other activities using BI Publisher, App Engine And Filelayouts.
• Performed appropriate data mapping to process incoming XML Request via the Integration Broker.
• Involved in the process of Upgradation from PeopleSoft 8.8 HRMS to PeopleSoft 9.2 using Upgrade Assistant, Data Mover. Ran numerous *.dms scripts, *.sqr scripts using Data Mover.
• Reapplied all the customizations, which are effected by Upgradation process and Upgraded SQR’s from 8.8 to 9.2.

Tools: /Skills: People Tools 8.51/8.54, PeopleSoft HCM 8.8/9.2, HR, T&L, Payroll, Absence Management, ESS, ePerformance, Workforce Admin, SQL, Application Designer, Application Engine, PeopleCode, Application Packages, Component Interface, Oracle 10G/11G, PS Query, HTML

Confidential, Alpharetta, GA

PeopleSoft technical Consultant

Roles and Responsibilities:

• Involved in design and development of code fixes reported by clients/ Support of Hot fixes needed for the HCM product and testing the fix.
• Involved in validating the current issues in the system as reported in Rally and addressing the issues as per the Scheduled release plan in the Sprint.
• Peer reviews and test cases for defects assigned.
• Attended high level meetings and providing project status updates to project manager.
• Dealt with Core HR, Personal Information, Tax withholding, Checks and Direct Deposit, Job Information, Liens and Garnishments and HR setup related issues.

Environment: E builder, E- Code, SQR, PS Query, Data mover. SQL server, SQL developer.

Confidential, Chicago IL

PeopleSoft Technical Consultant

Roles and Responsibilities:

• Involved in pre-analysis, fit-gap and upgrade analysis decision making, coordinating with upgrade team and progress to the client.
• Involved in design and development of code related to retrofit objects while upgrading.
• Involved in Organizing and validating the current system and ensuring that all are traceable and measurable Prepared and consolidated functional requirements on PeopleSoft
• Prepared and reviewed test cases for requirements.
• Attended high level meetings and providing project plan updates and project status updates to project manager.
• Reviewing new versions of PeopleSoft and recommending how to use new functionality to solve complex business problems.
• Responsible for the analysis, design of Interface programs, documentation, testing of outbound interface and custom objects created as part of upgrade.
• Developed new People Code and customizing existing People Code based on specific client functional requirements.
• Extensively customized PeopleSoft Absence Management Application Package for Family and Medical Leave Act (FMLA) eligibility validation criteria to meet the business process.
• Involved in the development of Pages, Components and Menus using PeopleSoft Internet Architecture.
• Developed custom Time and Labor rules to take care of Rounding Rules, Meal over Times and Scheduled Day off.
• Designed & developed various inbound & outbound interfaces using SQR’s & Application Engine.
• Designed, developed various XML Publisher reports across various modules for specific client requirements.
• Interfaced PS/Query with XML Publisher Reports for ad-hoc reports
• Developed BI-Interface Using File Layout, Application Engine, PeopleCode and Component Interface which loads data from legacy systems into PeopleSoft while doing various data validations.
• Assisted for unit system, UAT and parallel run testing phases. Worked with the test manager to ensure all testing was completed and documented issues raised, resolved and regression tested.

Environment: PeopleSoft HCM 9.0/8.4, People Tools 8.48/8.42, Oracle 9 i, Windows XP, Application Engine, File Layout, Component Interface, Integration Broker, PeopleCode, SQR, PS Query.

Confidential - Charlotte, North Carolina

Senior PeopleSoft Technical Consultant

Roles and Responsibilities:

• Developed synchronous request/response type of integration in Same Day Termination Tool with work brain system (third party) using web services for worked hours.
• Developed Promotion Interface using File Layout, Application Engine, and Component Interface, which loads data from CSV into staging tables while doing various data validations using AE Peoplecode and finally loads into PeopleSoft tables through Component Interface.
• Worked on Separation Customized module, developed online pages and custom records to store Employee Separation Process and developed Approval Workflow Engine for Approval Process as per the Client Requirement.
• Created new Application Package for sending request and getting response from the work brain system to PS system using web services.
• Worked on XML publisher to generate employee promotion letter as per the client requirement.
• Cloned and modified complex SQRs DDP003 and PAY003 as per the client requirement to print the paycheck information to the My HR system (third party).
• Worked on Payroll deductions, Pay calendars, running of the Payroll process (from Pay calendar, Pay sheet/ unsheet, Pay calculation to Pay confirm/ unconfirmed).
• Created the custom processes to track the employee’s shares and dividends in PeopleSoft Payroll system and offset the net pay and calculated the taxes.
• Developed SQR reports that displayed Leave Accrual information by leave plan and employee. It included information such as plan year eligibility hours, carryover hours earned year-to-date, hours taken year-to-date and remaining leave balances.
• Developed the new SQR for the employee suspension Process to stop the restoration bonus Deductions for employees on suspension.
• Designed and developed the new Workers Compensation Code report using SQR.
• Created the Year end SQR process for enrolling the new Deductions who are employees turning AGE50.
• Customized the delivered Application Engine (HR PER502) for Change ID and Delete ID Process as per the client requirement.
• Extensively used Process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.
• Designed technical approach for data conversion using Application Engine and Component Interface.
• Developed SQR Processes, SQR Reports, Crystal Reports, Dashboards, Pagelets and XML Publisher Reports.
• Developed queries using PS queries to get the employee status and head count of each business unit integrate it to the Crystal Report Writer.
• Created new and customized existing PeopleSoft objects (Panels, Panel Groups, Menus, People Code, and Process Definition) and applied Security.
• Trouble shooting HR and Payroll issues as part of daily production support.
• Creating the Queries for the reports as per the user requirement using PS Query Tool
• Worked extensively on People Code to implement the new required business rules of the client and also modified the Delivered People Code as per Business requirements.
• Was involved in coding, unit testing and peer reviews of the requests in the project which includes People Code, App Engine Programs, and File Layout.

Environment: PeopleSoft 9.0 HCM, People Tools 8.50, Application Engine, File Layout, Component Interface, People Code, SQR, PS Query, AWE, XML Publisher Oracle.

Confidential, Dallas, TX

PeopleSoft Technical Consultant

Roles and Responsibilities:

• Designed Technical specifications and Developed new objects, Reports and Customization of vanilla Reports, Objects as per the Business process requirements and End User / Client requirements.
• Involved in writing Interface programs, Data Conversion programs and Key reports for HR and Benefits modules. Setup Workflow rules and roles, wrote queries. Also modified pages and panels according to the user’s requirements.
• Worked with functional analysts and collected data requirements for Conversion and Interface programs.
• Executed test plans to cover from the initial acceptance of employee time from the third party to pay sheet creation by the custom modules. Modification and Customization using Application Designer and PeopleTool.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to People Soft HEALTH BENEFIT Table, LIFE ADD BEN Table, SAVINGS PLAN Table, LEAVE PLAN Table, and LEAVE ACCRUAL Table.
• Customized various components/pages in the areas of Job Data, Job Entry application engine programs and other SQR programs in HR and Payroll Modules.
• Devised, Documented, Implemented Security features (Page, Processes, Definition Security, and Data security) for all modules.
• Developed Application Messaging to poll Job data from legacy system.
• Wrote validation SQL for Payroll interfaces to provide new organization structured Payroll related data to the ProBusiness such as Deduction data, Direct Deposit data, Earnings data etc.
• Extensively worked on Approval Workflow Engine in transfer, Overtime and Regularization Process.
• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Created Interfaces using Application Engine, Component Interface and File Layout to create User profiles depending on the employee information in a flat file.
• Implemented Sign-on security, Row-level security, Field-level security, Object-level security to control application security using Administrator and Object Security.
• Developed an Application Engine program in Time & Labor, which loads employee data for multiple Business Units from flat file via Component Interface. Various data validations are performed using Application Engine PeopleCode.
• Developed Custom Workflow to notify Managers, Leave Administrators after running time admin where an employee’s reporting time has leave TRCs.

Environment: PeopleSoft HRMS 8.9, PeopleTools 8.46, Oracle 9 i, AWE, Windows XP.

Confidential, Ewing Township, NJ

PeopleSoft Developer

Roles and Responsibilities:

• Involved in setting up the rules and roles and routings for the various Workflow E-Mail notifications such as marital status change, reporting change, Benefits enrollment notification, dependent benefits info change in collaborative applications.
• Created Interfaces using Application Engine, Component Interface and File Layout to create User profiles depending on the employee information in a flat file.
• Involved in User Security Setup like creating new roles, permission lists, assigning authorizations for users etc.
• Update the Job Data component using Application Engine program and Component Interface whose employee’s jobcode change, company change and paygroup change.
• Used File Layout Definition to get data from the legacy system to PeopleSoft tables using Application Engine Program.
• Worked with Prompt tables, Dynamic prompt tables and also worked in SQL Views and Dynamic Views to optimize the Query performance and used views as search records.
• Developed Dashboards using pagelets for Manager which shows his/her employee’s time approval needs to be done when they login on to PS.
• Created technical design, unit test plan and test case documents for the development.
• Worked extensively on People Code to implement the new required business rules of the client and also modified the Delivered People Code as Business requirements
• Prepared technical specifications for Payroll, HR, Time & Labor and Benefits Modules.
• Involved in Field Mapping for the tables.
• Developed Workgroups, TRC’S. TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Responsible for generating the Standard Reports in various forms by using SQR and Queries formatting in XML Publisher Reports for different requirements of the organization.
• Developed Custom Time and Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time and Labor.
• Developed a custom report to get employee status and head count for each department.
• Developed Technical Design Documents and Test Case Documents.

Confidential

Junior PeopleSoft Developer (Trainee)

Environment: PeopleSoft: 9.0, PeopleTools 8.45

Responsibilities:

• Main responsibility is to work as a developer handling end-to- end development of critical business requirements.
• Involved in all the stages of Software Development Lifecycle (SDLC) - analysis, design, development, testing.
• Developed online Pages, Components, Search Records, Menus, Folders, and online People Code to Update and deleted error interface data from OMS.
• Modified the Accounts Receivable Dunning Application Engine extract (AR DUNNING), and the Crystal Reports layout, Involved in data mapping between legacy and PeopleSoft Receivables
• Developed conversion programs using AE, Implemented and customized workflow.
• Customized Journal Entry Detail Report, FIN2001 to show correct chart field values.
• Developed custom Application Engine that uses Component Interface to load data into tables and workflow to notify the managers to take proper action in specified time line in Accounts Payable.
• Developed Interface Application Engine program to load Billing Invoice information from a flat file that validates and loads data in to Interface tables.
• Implemented Voucher Upload and Journal upload templates.
• Design and Development of Interface programs for Vendor portal
• Created custom interface to load voucher data in to voucher staging tables from Flat files in Accounts Payable using application engine Preparation of the technical specifications (TS). This involves analysis and design of the system for enhancement or customization.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance.
• Responsible for working with testing team and drive this by providing required technical assistance.
• Worked on PS/Query tool to generate Ad-hoc queries, analyze the query results and to generate SQR reports.
• Developed Reports and interfaces for Benefits Providers using SQR.
• Worked on the Depreciation calculation and accounting entry calculation using SQR.
• Automated the business processes using workflow by creating roles, rules and routings thereby sending the right information to the right person at the right time.
• Reapplied People Code, application engines, sections, actions, People Code, SQL's, Queries, Pages, Components, SQRs and Crystal Reports.
• Developed an Application engine to interface Asset management and General Ledger Module.
• Used Process Scheduler for creating SQR reports for General Ledger reports.
• Involved in developing nVision, Crystal reports for the first time in organization.

Environment: PeopleSoft HRMS 8.8, People Tools 8.44, Windows NT and Oracle 8i, Application Engine, SQR, XML Publisher, Oracle, WindowsNT.