Sr. PeopleSoft Technical/Security/Upgrade Consultant

Over 8 years' experience in Information Technology gathering user requirements, systems analysis, design and development, deployment, integration, data conversion, training and support of a variety of Client Server and ERP applications. Strong PeopleSoft experience as a techno-functional consultant in design, development, implementation, conversion, up-gradation, and maintenance of PeopleSoft HRMS/HCM applications with expertise in modules such as Core HR, North American Payroll, Time and Labor Payroll Interface, Absence Management, Base Benefits, Benefits administration, eBenefits, ePay, and eCompensation.Strong PeopleSoft technical skills including People Tools People Code, Application Engine, Integration Broker, Component Interface, Workflow, Security, Operator Security, Data Mover, Upgrade Assistant, People Code, and PS/Query . Proficient in the creation of complex reports using SQR, Crystal Reports and PS/Query.

Technical Skills

Confidential

Sr. PeopleSoft Technical Consultant

Project Overview: Implementation of PeopleSoft Application/Upgrade from 9.0 to 9.2

• Developed custom Application Engine programs, Integration broker, file layouts.
• Developed custom SQR's for ADP Payroll, Benefits.
• Created custom online pages that involved huge People Code efforts on page and record level.
• Created Roles and permission lists as required.
• Involved in the upgrade of PeopleSoft Application from 9.0 to 9.2
• Supported the application in 9.2 after go live.
• Worked on customizations of Benefits module as per the new functionality in 9.2
• Modified Application Engine programs based on the client requirements in 9.2
• Helped in resolving the issues related to Performance Management and ELM in 9.2 and also helped the users understand the new functionality.
• Put huge efforts on comparing the custom code from 9.0 for the issues occurred in 9.2 and fixed the same by retrofitting.
• Gained experience in working with tools version 8.53
• Created various custom interfaces for department security tree.
• Setup workflow roles and updated route control profiles as required.
• Created the scripts to compare Security Tables.
• Involved in the design of the HCM existing security PeopleSoft system.
• Involved in setting up new users in the PeopleSoft Systems.
• Developed Outbound interfaces SQR's between CB I PeopleSoft and Taleo.
• Developed Inbound Interfaces Application Engines for New Hires/ Rehires/ Transfers between CB I and Taleo.

Confidential

Project Overview: - Re-Implementation of PeopleSoft Application.

• Worked on Performance tuning of Customized Application Engines.
• Designed and developed the bridging process when an employee transfers from hourly hourly population still on Legacy system to salaried, utilized Application Engine, Component Interface, File Layouts SQR's to transfer the employee tax balances, job details, personal details, earnings and deductions to current PeopleSoft system.
• Involved in the security administration of the PeopleSoft HCM FSCM systems.
• Created Roles and permission lists as required.
• Helped support and troubleshoot all end user security requests.
• Worked on assigning workflow roles as required.
• Worked on Configuring Query Security and Object security for the system.
• Configured and designed row level security system to segregate and secure data.
• Created end user documentation and provided training for IT security Staff.
• Worked with the functional coordinators to determine the right level of access for the accounting staff.
• Maintained security in all Development and Test instances.
• Involved in migration of project created for security roles and permission lists including query tree security with access group permissions.
• Built Custom Query trees and Access groups from scratch and added tables to appropriate Access groups so that the Functional users have no issues in accessing the tables in queries.
• Maintained security in all environments. Involved mostly in Query Security Access and Page access to the users.
• Used Oracle SQL developer to query all PeopleSoft security tables.
• Involved in setting up new users in the PeopleSoft Systems.
• Setup up workflow roles and updated route control profiles as required.
• Designed and developed customized Roles Standard Roles and Report Roles , Permission lists and User ids as per the Business process provided by client.
• Documented several security documents like Security audits, Security procedures and maintenance etc.
• Created the scripts to compare Security Tables.
• Modified User Profile document with all the roles and description of roles using Excel.
• Also involved in some of the issues related to the Data conversion and converted the data using data mover tool.
• Produced many ad-hoc reports using SQL, PS Query or Crystal reports to verify data within the system data tables. Produced reports to validate system user access were in compliant with Internal Audit request and access in compliance with SOX regulations.

Confidential

Sr. PeopleSoft Technical Consultant

Project Overview: Implementation of PeopleSoft HCM, Benefits, Payroll Application.

Involved in complete full-life cycle implementation of PeopleSoft HRMS, gathered business requirements and collaborated to prepare functional designs, developed Tech designs and obtained approval from functional team.

• Actively involved with giving the Estimates for the Development work to be done for the Tech designs prepared.
• Developed outbound / inbound interface which generates / reads flat files to and from third party vendors, including HBSI, Fidelity, Ceridian COBRA and others.
• Designed batch processes for union seniority and MSI requirements. Created SQR process for paying loading pay sheets with One Time Deductions and One Time Pay.
• Designed and developed the bridging process when an employee transfers from hourly hourly population still on Legacy system to salaried, utilized Application Engine, Component Interface, File Layouts SQR's to transfer the employee tax balances, job details, personal details, earnings and deductions to current PeopleSoft system.
• Participated in scheduling / running the jobs in mainframes environment using JCL.
• Involved in several customizations for Benefits and HR to meet business needs for clients of different regions.
• Created employee self-service customizations for eBenefits online enrollment , eCompensation MSI , and payroll.
• Involved in setting up of Integration Broker on HR side from Time and Labor to Projects.
• Involved in Integrating PeopleSoft with Profits, Ceridian and Symmetry using PeopleSoft Payroll Interface.
• Designed SQR Interface From Ceridian Payroll to General Ledger
• Developed a custom version of PER099, HIPAA App engine program.
• Developed client specific reports in SQR and Crystal Reports.
• Produced multiple reports for Benefits, HR, and Payroll, including customization of several BASxxx reports, leave accrual reports, and compensation reports.
• Played a major role in applying the Tax updates / Patches / Bundles. Ran compare reports for tax updates, analyzed compare reports, retrofit customizations, and assisted DBAs in applying tax updates.
• Conducted unit testing and user acceptance testing.
• Experience in offshore-onsite model and Performed Team Lead role at onsite and co-ordination with offshore team.
• Responsible for doing the Migrations to the other Environments like Testing and Production using STAT for all the Interface migrations and creating versions controls.
• Using the Data Mover, loaded the demo data from the tables into development environment database.

Developed and created quarterly reports of access for system owners to ensure compliance with SOX and Internal Audit guidelines. Created new Roles and Permission list.

• Created the scripts to compare Security Tables.
• Setup up workflow roles and updated route control profiles as required.
• Created various custom interfaces for department security tree.
• Implemented Row level Security by creating the department trees from scratch.
• Created Roles and permission lists as required.
• Involved in setting up new users in the PeopleSoft Systems.
• Involved in the design of the HCM existing security PeopleSoft system.
• Modified User Profile document with all the roles and description of roles using Excel

First Group, Cincinnati, OH Mar'08-Feb'10

Sr. PeopleSoft Technical Consultant

Project Overview: Implementation of PeopleSoft HCM, Benefits, Payroll, GL, AP, PO Application. First Group Formerly Laidlaw Educational Services and Laidlaw Transit Services is worlds Leading Transport Company in U.K and North America and Transport more than 2.5 billion Passengers a Year. First Group Implemented PeopleSoft HCM/FSCM Application.

• Designed and developed custom Paycheck summary page which displays Contractor's earnings, deduction, taxes and flex credits as per client's requirement. Also implemented security for this page, the data is displayed based on the company, paygroup and grade band of the user.
• Designed and developed many inbound and outbound interfaces to and from PeopleSoft payroll system.
• Key technical team member in an effort to upgrade the existing PeopleSoft HRMS/FSCM system to 8.8, which included requirements gathering, fit-gap analysis, technical planning deadlines, unit testing and customer acceptance testing.
• Met with end-users to gather requirements and wrote technical specifications for developing a batch process for SWW Short Work Week .
• Was part of the Application Support team, helped end-users in debugging several production related issues.
• Worked on Performance tuning of Customized Application Engines.
• Involved in documenting functional and technical designs. Also involved in assisting in creating training manuals.
• Extensively used data mover tool to migrate setup table data from testing to production databases.
• Set up the new plan type, benefit plan and benefit program for 401k catch-up plan and performed various other setup procedures to facilitate the new 401K process implementation.
• Created screens that will allow the user to elect what part of the Settlement and Incentives will be deducted for 'Service Account Deduction' as well as 'HR-10'.
• Was part of critical production support process, resolving various database issues and helping the business users during critical process runs.
• Developed custom workflow to send the work list to the benefits team to assign benefits when a new HIRE or Rehire transactions happens.
• Developed Custom Workflow for HR/FSCM modules using custom Business Process Maps.
• Developed SQR to achieve all the work list to the custom created achieve table which are not processed for more than 30 days.
• Developing custom reports for End Users using Crystal in both HRMS/FSCM.
• Configured and maintained security for HRMS/FSCM modules. Including permission lists, roles, user profiles and route controls using Security Administration, Tree Manager and Access groups.
• Created new permission list and assign the permission lists to the roles and assigns the role the user as per the business requirements.

Confidential

• TSYS Total System Services, Inc. makes it possible for millions of people to make paperless payments safely and securely. Recognized as the market leader, provides electronic payment services to financial institutions and companies around the globe. TSYS offer unmatched flexibility, control and service quality to customers through a broad range of innovative issuing and acquiring payment technologies, including consumer finance, credit, debit, healthcare, loyalty, prepaid, chip and mobile payments. TSYS HCM Re-engineering was aimed at implementing PeopleSoft 8.8 for all US populations and locations.

Project Overview: - Implementation of PeopleSoft HCM, Benefits, Payroll Interface Application.

• Set up Task Templates, Task Profiles, Task groups and Workgroups.
• Defined Time and Labor Static and Dynamic work groups for specific group of time reporters.
• Set up Row security permission list to grant/limit the access of records and fields for time reporters based on the group membership.
• 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.
• 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.
• 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.