SUMMARY

• With 10 years of experience in Analysis, Implementation and Production Support of PeopleSoft Human Resource Management Applications (HCM/HRMS).
• Well acquainted with Software Development Life Cycle and Software Testing Life Cycle.
• Experience inPeopleSoft HRMS modules like Core HR, NA Payroll, Payroll Interface, Base Benefits, Benefits Administration, Time and Labor and ESS/MSS applications.
• Thorough knowledge and strong technical skills in PeopleSoft Tools like Application Designer, People Code, Application Engine, Component Interface, File Layout, Data Mover, Integration broker, Process Scheduler and Application packages.
• Expertise in Reporting Tools like SQR, PS Query, Crystal reports and XML publisher.
• Experience with STAT tool - PeopleSoft Change Management System.
• Involved in full lengthLife-Cycle implementation of PeopleSoft modules.
• Performed Production Support, enhancements and customizations in PeopleSoft HCM for NA Payroll, Core HR, benefits and Payroll Interface.
• Created reports, inbound and outbound interfaces using SQR and Application Engine depending on business requirements with feasible solutions.
• Configured and modified Payroll Interface setup tables.
• Worked with Meta SQLs to improve the performance and to avoid platform dependency.
• Expertise in applying Tax Updates and Year end processing.
• Worked with Toad for writing SQL queries.
• Created, modified and scheduled reports using PS Query.
• Strong skills in Unix Shell scripting.
• Involved inData Conversionfor payroll from external system using SQR and Application Engine.
• Worked onPeopleSoft Securityby creating and testing user roles and permission list.
• Good Conceptual understanding of variousPeopleSoft Applications.
• Excellent troubleshooting and problem-solving skills.
• Regularly interacted with different teams to discuss on the Business Requirement details.
• Team player with excellent interpersonal communication skills and technical documentation skills.

TECHNICAL SKILLS

ERP / People Tools versions: PeopleSoft HCM 9.2/9.1/9.0/8.8/8.3 & People Tools 8.53/8.52/8.50/ 8.49/8.22

Modules: Core HR, NA Payroll, Payroll Interface, Benefits, Base Benefits, Time and Labor, Absence Management and MSS/ESS applications.

People Tools: Application Designer, Application Engine, People Code, Component Interface, File Layout, Integration Broker and Application Packages.

Reporting Tools: SQR, PS Query, XML (BI) Publisher, Crystal reports

Database: Oracle, MS SQL Server

Programming Languages: People Code, Shell Scripting, SQR and SQL

IDE’s: TOAD, SQL Developer, WinSCP and STAT tool, AutoSys, Edit Plus

Operating Systems: Windows, UNIX.

PROFESSIONAL EXPERIENCE

Confidential - Fort Worth, TX

Senior PeopleSoft Techno-Functional consultant

Responsibilities:

• Worked on various Customizations for Human Resource Self-service application as per the business needs.
• Created a Mass Hire process for BeechCraft Acquisition using Application Engine, Component interface and File layout with staging tables.
• Worked on End-to-End Implementation of Payroll interface for Switzerland by creating a customized Application Engine.
• Configured setup tables for Payroll interfaces including System Table, PS Tables, Field Definitions, Definition table.
• Worked on creation of POC for 9.2 implementation to create a prototype to influence the leadership for Upgrade project.
• Loaded all the Configuration tables using Excel to CI and Application Engine processes.
• Gave presentation with real time data to Leadership team for Upgrade to 9.2.
• Created export and import DMS scripts for migration of Payroll Interface Data between environments.
• Suggested and fixed thePayroll Interfaceissues related to PI INRUN App Engine.
• Developed a customized ePay Advice for US and CANADA employees using XML Publisher.
• Developed a customized Approval Workflow Engine (AWE) for automating approval process in Confidential by Register Transaction, Configure Transaction, Setup Process definition and Maintain UserLists.
• Customized Job Data page with complete impact analysis to add an option “Do-not-rehire” for HR users.
• Worked on Delta processes using AE and File Layout to send information as CSV files to 3rd party Asset Management and Absence management systems.
• Created a run control page and an application engine process to create merit letters for employees. HR users run this on yearly basis to generate PDF merit letters to be sent to employees through email.
• Created Excel (.xls) reports using Application Engine to send information securely through FTP.
• Performed the data analysis and data mapping and designed, documented the conversion/interface /Report documents.
• Created Technical Design documents based on the business requirement documents.
• Performed the analysis on customizations, interfaces, and reports to identify the changes that needed to be made and documented the impact from the both technical and functional perspective.
• Created batch scripts in DOS commands specifically for FTP on Windows.
• Wrote SQL queries to support the test case results.
• Worked in analyzing the functional flow and do the impact analysis for new enhancements.
• Worked on inbound & outbound interfaces using Application Engine, Component Interface & SQRs.
• Reviewing the test activities through daily stand-up meetings.
• Leading the team to ensure that all the tasks are completed and tracked.

Environment: People tools 8.53/8.52, PS HRMS 9.2/8.8, Application Engine, Component Interface, File Layout, XMLP, People Code, SQR, Oracle and Windows

Confidential, Tempe, AZ

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in various Customizations for North American payroll in HCM 9.1 as per the business needs.
• Participated in fit/gap analysis meetingsand system configuration.
• Extensively worked on Analysis of the Business requirement document and derived requirements.
• Worked on many inbound and outbound interfaces using Application Engine and File layouts.
• Implemented Application Engine programs with Meta SQLs.
• Configured and maintained all the payroll tables involved inPayrollprocessing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Payconfirm, Tax Tables etc.
• Involved in running theCompare reportsafter the Tax Updates to reconcile the data between the production and test environment.
• Applied and retrofitted customizations for Tax Updates including Online and Batch changes like SQR, COBOL for both US and CANADA.
• Applied ADP patches to PeopleSoft.
• Worked on End-to-End implementation of Aon Hewitt benefits interface including Design, Analysis, Implementation and Testing to send Deductions data .
• Analyzed Payroll COBOL processes like PSPPYBLD, PSPPYRUN and PSPCNFRM.
• Compiled and executed COBOL processes.
• Involved in Quarter End and Year End processing.
• Addressed various production issues with Pay Sheet creation, Pay Calculation and Pay Confirmation processes.
• Worked on Data conversions for Payroll Tables for both US and Canada from 8.3 to 9.1.
• Worked on Data Cleansing and handing of Historical Data as part of conversion process.
• Created Conversion programs using Application Engine and Staging tables.
• UpgradedSQRs,PeopleCodeto9.1based on8.3customizations.
• Clean up all objects from DDDAUDIT, SYSAUDIT and performing analysis on the upgrade compare report for objects such as menu, menu groups, panel groups, panels, records and fields, PeopleCode and reviewing all custom batch processes such as SQR, AE and prepare document for all re-mapping.
• Created all the Paychecks in 8.3 using DDP003.SQR and PAY003.SQR as PDFs and migrated them as files to 9.1 environment as part of Paycheck Data conversion process.
• Used ExcelToCI to load the data into PeopleSoft configuration tables.
• RetrofittedHRandPayrollcomponents based on new requirements and customizations.
• WrotePeopleCodeto customize the delivered objects for HR records.
• Worked on several customs TableAuditsand created Test scripts for functional test.
• Active member of Hyper care support of CANADA Payroll in New 9.1 system after go-live and addressed several production issues effectively.
• Extensively worked on Shell Scripting, good understanding about UNIX.
• Ran weekly and biweekly payroll with functional team and error solving.
• Supported Acquisitions and Divestitures from Payroll perspective.
• Involved in adding new pay groups to all the customizations.
• Developed Run Control Pages to run the process like Application Engines, SQRs.
• Worked with STAT tool for all the enhancements and change requests.
• Reported bugs and tracked defects using HP Quality Center (HPQC).
• Involved in performance fine-tuning of the SQR programs.
• Provided Technical details of existing programs for Design analysis for Implementation of US Payroll.
• Involved in various meetings with leaders to provide status updates on timely basis.
• Part of testing team for US implementation and worked on several defects identified during the VCCT testing and parallel testing.

Environment: People tools 8.50, PS HRMS 9.1, Application Engine, Component Interface, People Code, Unix Shell Scripting, SQR, STAT Oracle and NT

Confidential, Portland, OR

PeopleSoft Conversion Specialist

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users, technical developers.
• Gone thru the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Position Management: Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End), Compatibility, Backend (Database), User Acceptance Testing (UAT).
• Lead the Position Management reporting team as part of the implementation.
• Worked with DBA and System administrator to resolve all the technical issues.
• Worked on all phases of project like Development, Testing, Go-Live and configure Data to ensure successful upgrade jobs.
• Retrofitted several views to carry forward 8.8 customizations to 9.0.
• Worked on Data conversions for Core HR Tables from 8.8 to 9.0.
• Worked on Data Mapping and Data Cleansing.
• Handing of Historical Data as part of conversion process.
• Created Conversion programs using Application Engine and Staging tables.
• UpgradedSQRs,PeopleCodeto9.1based on8.3customizations.
• Cleaned up all objects from DDDAUDIT, SYSAUDIT and performing analysis on the upgrade compare report for objects such as menu, menu groups, panel groups, panels, records and fields, PeopleCode and reviewing all custom batch processes such as SQR, AE and prepare document for all re-mapping.
• Monitored and tuned scripts to achieve optimum performance levels.
• Provide support by troubleshooting and fine tuning performance issues related to peoplesoft batch programs.
• Validated and log all technical upgrade steps.
• Tested various Payroll process which mainly include Payroll Taxes, Payroll Interfaces, Setting up Employee Payroll Data, Calculating Pay, Taxes and Customizing Payroll and Tax Reports
• Designed, developed and tested customized SQR reports in Position Management, T&L, Benefits and Payroll.
• Developed and executed test cases and test scripts. Report completed tasks, issues and risks to Project Manager on timely basis.
• Involved in execute, manage and document delivered upgrade scripts.
• Reapplied SQLs, Peoplecode and security customizations to upgraded environment.

Environment: People tools 8.49, PS HRMS 9.0, Application Engine, Component Interface, People Code, SQR, Oracle and NT

Confidential, San Leandro, CA

PeopleSoft Consultant

Responsibilities:

• Designing of Applications using Application Designer.
• Involved with PeopleSoft MSS / ESS enhancement in PeopleSoft HRMS 9.0 for the client.
• Implementation and Customization according to new business rules of the client, which includes creating new fields, Records/Sub records, Pages/Secondary Pages and menus for new developments as per the client requirement usingApplication Designer & People Tools.
• Extensively worked in Coding and Unit testing.
• Interacted with end users on daily basis to understand more about the PeopleSoft customizations required by them. Also worked closely with the end users in resolving their issues
• Designed & customizedeBenefitsHome Pages (Benefits enrollment) Flexible spending Accounts pages & life Events (Marital status Change) Using Application Designer, People Tools, People Code
• Worked on Data conversions for Core HR Tables from 8.8 to 9.0.
• Worked on Data Cleansing and handing of Historical Data as part of conversion process.
• Created Conversion programs using Application Engine and Staging tables.
• Created Component Interfaces to populate data into Visa/Permit pages. Created customized pages based on Derived Records.
• Developed/tested/deployed complex application and batch programs using People code, Application Engine, Component Interface, People code and SQR.
• Involved in development of new modules like Job data Upload and Supervisor change upload as per Requirement.
• Extensively worked on online development and batch programs.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the required business process.
• Perform code review, test script/test result review before release of project.
• Analyzed the tickets and provided reliable solutions to the customer.
• Worked on inbound and outbound interfaces using Application Engine, Component Interface and SQR.
• Created new reports and customized the existing reports using SQR.
• Extensively worked on People code with object orientation (Row set, Row, Record, and Field) Familiar with stand-alone row sets in people code.
• Worked on performance related issues in AE programs using Managing Abends and application engine debugging, restarting ABEND programs.
• Involved in creating PeopleSoft Security-User profiles, Roles, Permission lists.
• Worked on setting up Data security usingTree manager, Department tree, and Query tree.
• Generated theSQRreports, Interfaces and Process from the scratch.
• Trouble shooting various testing, production and performance issues using Indexes & tuning SQL Scripts.
• Modification involved in changing search records to establish row level security. In order to accomplish row level security, Views were created.
• Performed debugging Analysis and provided online help to customers.
• Worked with Payroll Team to resolve various issues identified during Payroll Calc Process.
• Involved introubleshootingduring payroll process and on-line support to the end-users.
• Resolved customer issues related PeopleCode, SQR, Query, crystal Reports and Process Scheduler.
• Testedandreplicatedandresolvedvarious issues reported.
• Demonstrated good skills in writing/reviewing technical specifications.

Environment: People tools 8.49, PS HRMS 9.0, Application Engine, Component InterfacePeople Code, SQR, Oracle and NT

Confidential, Jacksonville, FL

Associate PeopleSoft Technical Consultant

Responsibilities:

• Worked on implementation of the My Employee Profile (ESS) components.
• Captured the production incidents/issues and addressed them on-time with quality.
• Involved in various enhancements and maintenance of existing programs.
• Active member of production support team,
• Wrote custom error messages on Benefits records and pages to hide beneficiary information based on different Plan Types.
• Worked onData Mover Scripts(DMS Scripts)on HR and Benefits tables to validate in different environments
• CreatedRun control Pages, ComponentsandRecordsand attached them to required menus through Application Designer and made them available to various operators throughMaintain Securityto have the reports run underProcess Scheduler.
• Created Unit testscripts to test the business functionality for the delivered code based on the requirements.
• Worked onPeopleSoft Securityby creating and testing user roles and permission list.
• Involved in the testing phase of the Application by setting up the test cases.
• Developed and automated new interfaces. Retrofitted existing programs.
• Addressing the production issues effectively.
• Perform coding, peer review and unit testing before delivering to business for UAT testing.
• Part of technical/functional design team to review and write new specs for business on the basis of Business requirement document.
• Involved inUnit, SystemandUser AcceptanceTesting.
• Automated Reports like New hires/ Terminations/Transfers to be sent as PDF reports using SQR and Shell scripting in UNIX environment.

Environment: People tools 8.22, PS HRMS 8.3, People Code, Unix Shell Scripting, SQR, Oracle and NT