SUMMARY

• Around 11 Years PeopleSoft Implementations, Upgrades, Migrations, Installations, Reports, Interfaces, Conversions, Extracts, Workflow (RICEW), Production Support, Integrations, etc of PeopleSoft Human Resource Management Applications (HCM/HRMS).
• Experience on software development, project design, customizations and Production Support for ERP and client/server applications.
• Working extensively on PeopleSoft Application Designer, Application Engine, PeopleCode, PS/nVision, PS Query, Integration Tools, Integration Broker, Component Interfaces, Business Interlinks, SQR, Crystal Reports, XML Publisher, Security etc.
• Good Exposure on db2, Oracle, SQL Server, Developments, data conversions.
• Well acquainted with Software Development Life Cycle and Software Testing Life Cycle.
• Experience inimplementation, upgrade, production Support of PeopleSoft HRMS modules like Core HR, NA Payroll, Payroll Interface, Time and Labor, Base Benefits, Ben Admin and ESS/MSS applications.
• Thorough knowledge and strong technical skills in People Tools like App Designer, People Code, Application Engine, Component Interface, File Layout, Data Mover, Integration broker, Process Scheduler and Application packages.
• Involved in full lengthLife - Cycle implementation of PeopleSoft modules.
• Created reports, inbound and outbound interfaces using SQR and Application Engine depending on business requirements with feasible solutions.
• Worked on enabling Approval Workflow Engine (AWE) for both delivered and custom transactions.
• Configured and modified setup tables for Core HR, Payroll Interface, NA Payroll and Time and Labor.
• Helped business with Data Analytics in PeopleSoft with Pivot grids, Dashboards and Workcenters.
• Expertise in Reporting Tools like SQR, PS Query, Crystal reports and XML publisher.
• Experience with STAT tool - PeopleSoft Change Management System.
• Expertise in applying Tax Updates and Year end processing.
• Worked with Meta SQLs to improve the performance and to avoid platform dependency.
• Created, modified and scheduled reports using PS Query.
• Worked with Toad for writing SQL queries.
• Strong skills in Unix Shell scripting.
• Have a good understanding onPeopleSoft Securityat application level and row level security.
• Tested,replicatedandresolvedvarious production issues with RCA and possible permanent solutions.
• 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: App Designer, App Engine, People Code, Component Interface, File Layout, Integration Broker AWE, 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, WinSCP and STAT tool, Autosys, Siebel, Serena, HPQC

Operating Systems: Windows, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior PeopleSoft Techno-Functional consultant

Environment: People tools 8.54, PS HRMS 9.2 (Core HR, Self Service applications, time and labor, Payroll Interface, Absence management, Fluid, AWE), Application Engine, Component Interface, File Layout, XMLP, People Code, SQR, Oracle 12c.

Responsibilities:

• Performed Fit Gap Analysis, provided Current System Business Process, Process Flows, Security, Issues, Defects, Reports information and mapped to Future system with Gap, Adequate/In Adequate details.
• Part of functional design team to review and write new specs for business on the basis of Business requirement document.
• Worked on analyzing the functional flow and do the impact analysis for new enhancements.
• Created a custom process to populate the NA Payroll's payslip with Payroll interface data from ADP.
• Worked on enabling Approval Workflow engine for both delivered transactions and custom transactions.
• Handled escalations and re-routings in AWE and created custom UserLists using PS Query.
• Worked on email approvals and created customized email templates as per business requirement.
• Created Time and Labor schedules and employee schedules.
• Designed and created a customized timesheet using Fluid for Employee Self Service with online edits and validations to support business requirements.
• Created a customized Fluid pages for mobile users of Employee Self Service like W4 form, Direct deposit form etc.
• Built or modified new time and labor rules to support various business requirements.
• Configured various time and labor components like TRC's, TRC programs, Workgroups, shifts and schedules, Comp leave plans, time reporting templates and rules.
• Ran TL processes like TL TIMEADMIN to calculate Payable time and validated the payable time to have corresponding TRCs as per the TL rules.
• Worked on creating and configuring the Pivot grids, Dashboards and Workcenters.
• Configured and Tested Absence Management module for self services for different countries.
• 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.
• Wrote SQL queries to reconcile data and support the test case results.
• Involved inUnit testing, SystemIntegration testing andUser AcceptanceTesting.
• Reviewing the test activities through daily stand-up meetings.

Confidential - Fort Worth, TX

Senior PeopleSoft Technical consultant

Environment: People tools 8.53/8.52, PS HRMS 9.2/8.8 (Core HR, Payroll Interface, Time and Labor and Self Services), Application Engine, Component Interface, File Layout, XMLP, People Code, SQR, Oracle.

Responsibilities:

• Worked on various customizations for Human Resource Self-service applications.
• Created a Mass Hire process for BeechCraft acquisition using Application Engine, Component interface and File layout with staging tables.
• Worked on creation of POC for 9.2 implementation to create a prototype to influence the leadership for an 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.
• Worked on creating and configuring the Pivot grids, Dashboards and Workcenters based on roles.
• 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.
• FixedPayroll Interfaceissues related to PI INRUN App Engine.
• Created export and import DMS scripts for migration of Payroll Interface Data between environments.
• Developed a customized ePay Advice for US and CANADA employees using XML Publisher.
• Worked with Meta SQLs in Application Engine programs to improve the performance and to avoid platform dependency.
• 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.
• Developed a customized Approval Workflow Engine (AWE) for automating approval process in Textron
• Configured AWE setups including Register Transaction, Configure Transaction, Setup Process definition, Maintain UserLists and Workflow notifications.
• Created Custom application package for AWE to handle all the approval events, user lists and display of approval status monitor as per the business needs.
• Implemented Adhoc approver process and Delegation framework as part of AWE.
• 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 Technical Design documents based on the business requirement documents.
• Created Excel (.xls) reports using Application Engine to send information securely through FTP.
• Created batch scripts in DOS commands specifically for FTP on Windows.
• Worked on inbound & outbound interfaces using Application Engine, Component Interface & SQRs.
• Leading the team to ensure that all the tasks are completed and tracked.

Confidential, Detroit, MI

Senior PeopleSoft Techno-Functional Consultant

Environment: People tools 8.50, PS HRMS 9.1 (Core HR, NA Payroll, Benefits, ESS/MSS and Bolt-on applications), Application Engine, Component Interface, People Code, Unix Shell Scripting, SQR, STAT Oracle and NT

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 delivered AWE transaction for HR Manager Service called Manager Direct.
• Configured and maintained all the payroll tables like Company, Paygroup, Earnings, Deductions, Tax data, Pay calendar and Pay Run IDs.
• Involved inPayrollprocessing: Paysheet creation, Pay Calculation, Pay confirmation.
• 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 for quarter-end and year-end processing.
• Worked on End-to-End implementation of Aon Hewitt benefits interface including Design, Analysis, Implementation and Testing to send Deductions data .
• Analyzed, Compiled and executed Payroll COBOL processes like PSPPYBLD, PSPPYRUN, PSPCNFRM.
• Addressed various production issues with Pay Sheet creation, Pay Calculation and Pay Confirmation.
• 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
• 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.
• Configured benefits plans and rate tables based on union policies
• Configured ben admin eligibility and event rules.
• Designed Benefits vendor interfaces for health, vision, COBRA and Life
• Worked in PeopleSoft Benefit Administration to bring in the benefits plans, custom build benefits interfaces and auto enrolment process.
• Active member of Hyper care support of US Payroll in New 9.1 system after go-live and addressed several production issues effectively.
• Worked on workflow and Implemented Integration broker in Enterprise Portal and HCM.
• Developed various Component Interfaces and Application messages to support web integration.
• 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.
• 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.
• Helped client understand PS HCM 9.1 changes with respect to Core HR, NA Payroll, Benefits and AWE.
• Part of testing team for US implementation and worked on several defects identified during the VCCT testing and parallel testing.

Confidential, Portland, OR

PeopleSoft Conversion Specialist

Environment: People tools 8.49, PS HRMS 9.0 (Core HR, NA Payroll and Benefits), Application Engine, Component Interface, People Code, SQR, Oracle and NT

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).
• Developed Run Control Pages to run the process like Application Engines, SQRs.
• Designed, developed and tested custom SQR reports in NA Payroll, T&L and Benefits.
• 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.
• 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.
• 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 fine-tuned PeopleSoft batch and scripts to achieve optimum performance levels.
• 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.

Confidential, Charlotte, NC

PeopleSoft Technical Consultant

Environment: People tools 8.49, PS HRMS 9.0 (Core HR, NA Payroll, Benefits, Time and Labor and ESS/MSS), Application Engine, Component Interface, People Code, SQR, Oracle and NT

Responsibilities:

• Implementation and Customization according to new business rules of the client usingApplication Designer and 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).
• Involved in setting up benefits eligibility and event rules. Defined Benefit Plans.
• Customize Benefit programs with the Benefit/Deduction Program Table Group, adopted Benefit programs for Health Plans, Life & AD/D plans, Dental Plans, Establishing Rates and Calculation Rules.
• Created Time and Labor schedules and employee schedules.
• Customized timesheet to have online edits and validations to support business requirements.
• Integration of Time & Labor TRC with NA Payroll.
• Configured and customized the delivered EIP using Application Messaging (by using nodes, messages, channels) to dispatch XML Format to the 3rd party vendors using Integration Broker.
• Created customized Application Engines to perform XSL transformations from PeopleSoft to 3rd party vendors.
• Involved in development of new modules like Job data Upload and Supervisor change upload as per Requirement.
• 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, stand-alone row sets in people code).
• Involved in creating PeopleSoft Security-User profiles, Roles, Permission lists.
• Worked on setting up Data security usingTree manager, Department tree, and Query tree.
• Troubleshot various testing, production and performance issues using Indexes & tuning SQL Scripts.
• Worked with Payroll Team to resolve various issues identified during Payroll Calc Process.
• Demonstrated good skills in writing/reviewing technical specifications.

Confidential, San Francisco, CA

PeopleSoft Technical Consultant

Environment: People tools 8.22, PS HRMS 8.3 (Core HR, Benefits and Self Services), People Code, Unix Shell Scripting, SQR, Oracle and NT

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 through Maintain Securityto have the reports run underProcess Scheduler.
• Created Unit testscripts to test the business functionality for the delivered code based on the requirements.
• Involved inUnit testing, SystemIntegration testing andUser AcceptanceTesting.
• Worked onPeopleSoft Securityby creating and testing user roles and permission list.
• Developed and automated new interfaces. Modified existing programs as per business rules.
• Addressing the production issues effectively.
• Performed 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.
• Tested,replicatedandresolvedvarious issues reported.
• Automated Reports like New hires/ Terminations/Transfers to be sent as PDF reports using SQR and Shell scripting in UNIX environment.