SUMMARY

• 7+ years of extensive PeopleSoft Techno - Functional experience in PeopleSoft HRMS 8.X, HCM 9.0, 9.1 & 9.2 in different roles as part of Implementation/ Upgrade/ Conversion/ Development/Re Implementation/Production Support teams.
• Strong PeopleSoft technical skills including People Tools (Application Designer, People Code, Application Engine, Component Interface, Process Scheduler, Application Messaging, Integration Broker, Workflow, Data Mover, Security Administrator and Security), XML Publisher, SQR and Crystal Reports.
• Well versed with project development life cycle, System Business Process Analysis, Requirements Study, Fit-Gap Analysis and Post-Implementation support.
• Experience and expertise in developing Application Engine Programs and performance tuning of Application Engine Programs using traces.
• Experience in developing interfaces, reports, and processes using Component Interface, File Layout, Application Engine, SQR and People Code development.
• Expertise in the development of Interface applications by creating PeopleSoft objects such as fields, records, page, component, grids and menus
• Experience in testing and issue resolution during the parallel test and the postproduction support
• Organizational PeopleSoft Support to end-users as well as development team during and after the implementation of the project.
• Sound experience in Debugging and Tracing PeopleCode, SQL, Application Engine and SQRs.
• Proficient with PeopleSoft HCM database and PIA. Very sound RDBMS concepts and good database programming experience using Oracle 9.x, 10.x, 11g SQL Server, SQL, PL/SQL and SQL Loader.
• Good Analytical & Communication skills, Team player, Leadership, Analytical, Problem solving skills and highly self-motivated.

TECHNICAL SKILLS

PeopleSoft Applications: PeopleSoft HCM

PeopleSoft Version: 8.9, 9.0, 9.1 and 9.2

People Tools: Application Designer, People Code, Application EngineComponent Interface, File Layout, Workflow, Process Scheduler, Tree Manager, Data Mover, People Code Debugger, Integration Broker

Reporting Tools: SQR, XML Publisher, Crystal Reports, PS Query

RDBMS: Oracle 9.x, 10.x, 11g SQL Server

Languages: People Code, Java 2.0, Perl, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, NYC

Sr. PeopleSoft Techno/Functional Consultant

Responsibilities:

• Involved in HCM Upgrade from 9.0 to 9.2
• Participated and assisted in the Payroll Fit Gap analysis
• Compared and reviewed both Functional Design and Technical Design documentation as and when required. Making necessary changes to the Work products and keeping it up to date.
• Retrofitted about 250 Custom template built rules used by different Agencies of Confidential
• Involved in retrofitting the Fields, Records, Record field People Code, Pages, Page People Code, Components, Component People Code, SQRs, Application Engine Programs and other objects.
• Coordinate with Business Analysts to understand business requirements and prepare technical specifications documentation. Tracked documentation through various stages of Software Development Lifecycle (SDLC).
• Extensively used Application Designer and other People tools of version 8.54 to modify existing tables and create some new tables and views to suffice the application needs.
• Developed a Custom Report for Union Dues Exception Using XML Publisher
• Worked at Confidential as Integration Broker Specialist, Configuration of Integration Broker to Interface between Different modules, like, Payroll and General Ledger, Time and Labor and Project Costing. Setting up the EIPs, Enterprise Integration Points for these Environments. (Configuring Gateways, creating Nodes, Messages, Routings, and XML schemas)
• Worked on retrofitting various SQR reports and processes in HR, Payroll, and Benefits, includes reports like, Position status report, Incumbent history report, Active position history, Employee compensation change, Leave of absence, Cable benefit for employee accounts etc.
• Worked on retrofitting Total Rewards interface in Benefits. Due to project deadline limitations, the vendor was unable to accept all the changes in benefit health plans, so I have created the Benefit plan translations table, to map the new benefit plans to old benefit plans.
• Involved in number of technical defect fixes related to Payroll and Time & Labor modules after System integration test and User Acceptance test.
• Created Queries to users for reporting purposes using PeopleSoft (PS) Query tool.
• Re-wrote few inbound & outbound interfaces as a part of upgrade using Application Engine, File layout & Component Interfaces in Payroll and Time & Labor.
• Customized pages using online edits on the record time page for validating the reported time.
• Resolved payroll issues during post live and production support phases. Analyze payroll error messages, trace files, and write SQL scripts to identify cause for errors, recreate issue in test environment, create and manage tickets with Oracle support to resolve issues related to patches.
• Created newpermission listandrolesfor granting the access to the custom process and custom components as a part of PeopleSoft Security.

Environment: PeopleSoft HCM 9.2/9.0, People Tools 8.49/8.54, Workflow, XML Publisher, Integration Broker, Application Classes, People Code, Data Mover, Application Engine, SQR, Query manager

Confidential, FL

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Set up Time Collection Devices (TCDs) for reporting time into PeopleSoft time and Labor
• Developed interfaces to capture time from Kronos Management System into PeopleSoft Time and Labor System.
• Developed an interface for reporting time from a flat file using File Layout, Component Interface, and Application Engine into the PeopleSoft Time and Labor system.
• Set up and customized Work Schedules by creating Shifts, Workdays, and Schedule Definitions as per user requirements.
• Customized Daily Time Calendar, Weekly Elapsed Time Entry, and Punch Time Entry and Manager Time Approval pages as per the requirements. Extensively used People Code and People Tools during the customization.
• Worked on different Census reports like Quarterly census report, Dependent census and Quarterly census by eligibility in Benefits, which keeps counts of dependents having major medical coverage, dispersed across different groupings and classifications. Reports modified to accommodate newly introduced RELATIONSHIP/MAR STATUS codes, JOBCODEs.
• Involved in Setup of Eligibility rules and Plans in Benefits Administration. Involved in the testing of the Benefits Administration process for Open Enrollment, Snap and Event maintenance. Complete understanding of the Benefits Administration process from scheduling to enrollment.
• Worked on Benefits processes/reports regarding Leave Plan Enrollment, which includes process Automatic Benefit Plan Assignments, and report Employee Benefit Plan Data Audit Report.
• Developed Benefits Interface for creating file with Vision Plan.
• Set up and build delivered / customized Time Period, Calendar, and Work Schedules
• Developed Template/Custom Built Rules using Daily Threshold, Holiday, and Guaranteed Hours and customized the rules using SQL objects, actions and conditions as well as user exits.
• Trouble shooting batch/online process of SQR and Application Engine in Payroll and Time & Labor modules.
• Involved in trouble shooting issues which arise due to transfer of employees from one workgroup to another during mid-period of interest calculation.
• Developed custom Time & Labor Queries to enable Functional Users to identify specific employees.
• Worked on enhancement of different PeopleSoft queries. As well as, created different PS queries as per the requirements from client.
• Provided Production Support for Integration Broker. Support includes manual operation of some processes, which were going fail, because of Database indexes problems. This includes, loading Vouchers from Payroll to Accounts Payable, using Data Mover Scripts.

Environment: PeopleSoft HCM 9.1 People Tools 8.50, Workflow, XML Publisher, Integration Broker, Application Classes, People Code, Data Mover, Application Engine, SQR, Query manager

Confidential, Long Island, NY

PeopleSoft Techno/Functional Consultant

Responsibilities:

• Involved in the PeopleSoft conversion from ADP to PeopleSoft 8.9 and developed Payroll Interfaces for Outbound Files
• Developed Design specification for all HR, JOB, Personal, Payroll and Benefits data from ADP to Confidential PS system.
• Developed new Application Engine & SQR process for Interfaces (Inbound)
• Developed & written DMS scripts for migrating data from one environment to another
• Involved in writing design specifications for developing custom interfaces
• Involved in unit testing, documentation & end-user training
• Developed new Application Engine & SQR process for Interfaces for benefits vendor files
• Developed an custom enquiry page for user for employee employment details
• Developed Data Conversion Programs for Dependent Data Component, Personal Data Component, Job History and other Benefits components using Application Engine, Component Interface and File Layout.
• Built new Component Interfaces and customized existing Component Interfaces as necessary for integrations payroll modules.
• Performed Interfacing, Conversions, data migration and report writing (using People Code, People Tools and SQR)
• Worked in Payroll Processing Pay Calendar, Pay Sheet Creation, Pay Calculation, and Pay Confirmation.
• Created different PS query reports, as per the client requirements. The reports include,
• Vendor Rates report: Provides latest effective-dated rates for the specified vendor.
• Billing History Report: Provides EEs details to different agencies, for which they are billed for.
• Family enroll with no Dependent Report: The report provided data for any employees who are enrolled in a health benefit plan as family coverage but do not have any dependents enrolled and vice-versa.
• Interacted with the client to implement setup issues related to Benefits and North American Payroll configuration.

Environment: PeopleSoft 8.9 HRMS People Tools 8.49, Application Engine, SQR, Windows NT, and Oracle

Confidential, NY

PeopleSoft Technical Consultant

Responsibilities:

• Developed and customized record definitions and views, using Application Designer, and writing interface reports
• Wrote and modified People Code for validations and manipulations
• Used Application Upgrade to move objects from Test environment to Production environment.
• Worked on customization of Payroll and Employee Self Service which included creating and modifying records, pages and Components.
• Wrote an SQR Batch program to alter the Vacation Accrual process to update employees’ accrual records by company and vacation benefit plan in order to in corporate the company’s Business logic.
• Created queries for Payroll reporting using PeopleSoft (PS) Query tool
• Involved in writing design specifications for developing custom interfaces
• Involved in unit testing, documentation & end-user training
• Created technical documents for already migrated projects in the past
• Modified the existing SQR reports as per the client and vendor requirements

Environment: PeopleSoft 9.0 HCM People Tools 8.48, Application Engine, SQR, Windows NT, and Oracle