SUMMARY

• Having an IT experience around 8 years in PeopleSoft as Techno Functional Consultant with knowledge in HRMS Module
• Have good understanding of Functional and Technical aspects of various modules in PeopleSoft HRMS - Core HR, NA Payroll, Base Benefits
• Have worked on different People Tools objects like Application Designer, Application Engine, Process Scheduler, SQR, People Code, File Layout, Component Interface, Work Flow,, Security Administration.
• Proficient in user requirement, gathering, analysis and providing on job support to users.
• Demonstrated excellent Technical Leader skills on numerous projects by coordinating onsite and offshore resources, creating documentation, developing solutions and design, performing technical control and testing of delivered work, keeping track on project progress, leading meetings and conference calls.
• Strong documentation and written presentation skills, and developed various functional and technical specifications with Test Plans and Procedures.
• Extensive experience in the analysis of business processes, setups, and report customization, upgrades, data conversion from Legacy Systems to PeopleSoft application databases, writing interface programs, testing, trouble shooting and providing online support.
• Excellent in problem solving and self-learning attitude Strong analytical skills to convert Functional design specifications into Technical Design specifications.
• An organized, hard working, and highly motivated professional, with strong communication and interpersonal skills, and the ability to perform individually or as a dedicated team member.

TECHNICAL SKILLS

ERP package: PeopleSoft HRMS 8.8/8.9/9.0/9.1

People Tools: Tools v 8.49/8.52/8.53

Development Tools: Application Designer, People Code, Application Engine, Component Interface, File Layout, WorkFlow

Reporting Tools: PS/Query, SQR, Process Scheduler

Administrative Tools: Security Administration

RDBMS: Oracle 9i,10i,11g, SQL Server, SQL Developer, TOAD

Languages: SQL

Operating System: Windows 2000/NT,XP

PROFESSIONAL EXPERIENCE

Confidential

Environment: HRMS9.1, PeopleTools8.52, SQL Developer, TOAD

Responsibilities:

• Involved in Support & Enhancements of PeopleSoft HRMS Applications using PeopleSoft 9.1 and Oracle 9i based on client requirements.
• Developed PS Queries depending on the end user requirements
• Modified/Created SQR reports/interfaces and Modified custom PS objects.
• Used tools to upload data from third party tools to the PS system.
• Upgrading, Support and Troubleshooting Technical & Functional issues.
• Developed new reports using SQR, and PS-Query.
• Writing and running Test cases/scripts.
• Involved in Vanilla compare to find out level of customization for bundle testing in SQR s and Crystal Reports.
• Involved in running Upgrade Compare Reports between Demo database and Copy of production before we do the upgrade copy.
• Involved in Fine Tuning of Database Tables, which are used in Data Conversion.
• Involved in Resolvingday-to-day production ticketsin HR and Payroll
• Involved infit-gapanalysis, compare reports between Third Party System and Enterprise HR and payroll modules.
• Configured and maintained all the tables involved inPayrollprocessing, such as Pay calendar, Job Code, Deductions and Processes such as PaySheet creation, PayCalc, PayConfirm, Tax Tables etc.
• Involved in running weekly and biweekly payroll with functional team and error solving.
• Involved in sending payroll deduction information to 3rd party vendors.
• Applied tax updates and Retrofitted customizations after each tax update.
• Applied ADP patches to PeopleSoft.
• Involved in adding new pay groups to all the customizations.
• Involved and identified Uni-code problem in data, which crashes the COBOL procedure called by the Payroll Interface.

Confidential

Environment: HRMS 9.1, People Tools 8.52, Oracle 9i

Responsibilities:

• Extensively involved in PeopleSoft HRMS upgrade from V 8.9 to 9.1
• This project involved testing various batch jobs and online components which were upgraded from 8.9 to 9.1.
• Played role as ONC Tech Lead at Onsite in parallel testing for all NA Payroll batch programs.
• Tested around 300 batch programs and fixed 8.9 coding issues whenever required.
• Verified run control navigation and data setup for batch programs.
• Verified that the NA Payroll batch programs are functioning as desired in 9.1 environment.
• Transmitted 9.1 interface files to external Vendors and ensured it gets processed at their end without any issue.
• Tested using traces files and debugging for the customized Application Engine and People Code
• Raised various defects at database and program level and worked with Technical team for issue resolution

Confidential

Environment: HRMS9.1,People Tools 8.52, SQL server

Responsibilities:

• Involved in analysis, customization and support of HRMS modules using PeopleSoft 9.1 and SQL Server.
• Maintaining PeopleSoft user security using user profiles, roles & permission lists.
• Customizing and support for the workflow and changing the approval workflow as per the organizational hierarchy
• Developing new Queries as per the end user requirements for the data extract from the PeopleSoft Tables.
• Part of the team providing 24/7 Application maintenance support to the client under SLA guidelines.
• Involved in customization of Records, Pages and Components
• Extensively used Application Designer and people code during customization.
• Involved in enhancements of PeopleSoft objects to cater the client requirement.
• Customization and fine-tuning of SQR Reports.
• Maintaining Vantive System to keep track of the issues (Tickets) raised by the end users.
• Involved in testing and debugging the customized Objects.
• Delivery documentation for the resolved tickets.
• QA reviews and walkthrough’s and GL Interfaces.
• Preparation of test plans and test data
• Provided intensive hand hold training to users in using PeopleSoft application
• Created a security matrix to restrict the access of pages in PeopleSoft based upon roles.

Confidential

Environment: HRMS 8.9, People Tools 8.51, SQL server

Responsibilities:

• Involved in analysis, customization and implementation of HR/Benefits/Payroll modules using PeopleSoft 8.9 and SQL Developer.
• Involved in the design, development and testing of all HR, Payroll, Benefits
• Involved in Data mapping between the two systems.
• Customized HR, Employee detail menus, enquiry pages as per the user requirement so that user can view more information.
• Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Involved in setup of Set ID table, Company Information, Establishments, Location, Department, Salary plan, Job Code and Pay Group tables for HRMS System.
• Generated SQR reports to create Time Load to pay sheets, master employee listing, employee pension plan data, new hires and terminations.
• Created customized Application Engineprograms based on user requirements and wrotePeople Codeto customize the delivered objects for HR records.
• Worked on several customs Table Auditsand created Test scripts for functional test.
• Suggested and fixed thePayroll InterfaceCOBOL time-out issues related to PI INRUN App Engine.

Confidential

Environment: HRMS 8.9, People Tools 8.51, SQL server

Responsibilities:

• Involved in Support and Customization of PeopleSoft HRMS module Workforce Administration and Base Benefits using PeopleSoft 8.9 and SQL Server
• Done a setup to display identity card as identity proof and added necessary People Code validations
• Based on business rules, submitted processes to the Process Scheduler to task at a specific time or run processes recursively at a specific interval.
• Created queries to generate reports like audit reports, sales man report etc.
• Worked on security like adding roles, permission lists and password reset
• Created record definitions and pages to enter medicines purchased by the employees.
• Developing customized tables and panels to run SQR Reports, Interfaces and Processes from Process Scheduler.
• Used PeopleCode to control the program flow and logic and for validation to meet the current business requirement.
• Writing and modifying PeopleCode for validations and manipulations
• Developed and customized the SQR reports based on the client requirements.
• Created Process definitions for SQR’s and Application engine to run through the Process Scheduler.
• Resolved Production support tickets as part of production support.