SUMMARY

• Over 9+ years’ experience as a HRMS technical consultent, with expertise in creating requirements based on client’s needs. And Maintenance and Production support of PeopleSoft HCM/HRMS modules ( Payroll interface,Benefits, Absence management, North American Payroll, Time and Labor,HR Core, Benefits, e - benefits, Self Services,Manager self services)
• Hands on experience in setting up the configurations for e-benefits,Benefits, N.A Payroll and Absence Management, Time and Labor
• Good understanding of the e-benfits,Benefits 9.2 business process.
• Completed tax updates for 12A to 12F, and 13A to 13F to get the tax rates into PeopleSoft system
• Completed 2 open enrollments full cycle for morethan 50K population
• Hands on experience in Benefits integration with N.A. Payroll
• Excellent management and problem solving skills with thorough knowledge in Application Designer, PeopleCode, SQR, PS Query / Crystal Reports, Application Engine, Component Interface, Security, Process Scheduler,UpgradeAssistant andPeopleSoftDevelopment Tools.
• Strong Knowledge on Performance Tuning of SQL, SQR and Application Engine Programs.
• Played various Roles within projects - Team Lead, Techno/Functional Consultant, Business Analyst, Version control Admin, PQA and Defect prevention analysis (DPA).
• Strong collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Thorough knowledge of installation ofPeoplesoftApplications, Webserver, Application Server, PIA.
• Experience in working with Onsite / offshore model.
• Excellent knowledge in the people tools like application designer, Peoplecode, SQR,component interface, file layouts and Application engine Etc.
• Hands on experience in Setting up entitlement elements/ formulas in Absence management
• Hands of experience on Setting up Absence Management brackets
• Expertise in doing excellent documentation on business requirements.
• Hands on experience in setting up the configurations for Absence Management, N.A.Payrol, Benefits.
• Proficient with full system development life cycle (requirements analysis through deployment, support, and ongoing technology refreshment). This encompasses conducting requirements analysis and design activities as well as hands-on deployment and integration.
• Has extensive knowledge in customization and maintenance of PeopleSoft HRMS 9.1 application including application of maintenance packs, service packs and patches.
• Good understanding of the PeopleSoft North American Payroll 9.1 business process.
• Experienced in designing and architecting custom bolt-on applications and process flows in PeopleSoft HCM 9.1
• Experienced in PeopleSoft security administration for PeopleSoft HRMS/HCM
• Extensive knowledge of PeopleTools including Application Designer, PeopleSoft Internet Architecture, Configuration Manager, Tree Manager, PS Query, Data Mover, Upgrade Assistant and Change Assistant.
• Extensive knowledge of People Code, Application Engine,Component Interface, SQR, XML Publisher,
• Extensive knowledge of Application Packages, Approval Workflow Engine (AWE), PeopleSoft Query and Oracle database.
• Good experience with pivot grids feature of peoplesoft hcm 9.2
• PeopleSoft SQRExperience in Data Conversion to facilitate the migration of data from legacy applications to PeopleSoft using SQR, File Layout, Application Engine and Component Interface.
• Experienced with Integration Broker for application messaging between PeopleSoft HRMS and PeopleSoft FSCM applications.
• Strong SQL development skills using multiple joins, multiple unions, and sub queries.
• Worked for clients in the telecommunications, retail, educational services, health care services, financial services, hospitality, technology services & manufacturing industries and provided services like database migration, enterprise technical upgrades, SQR upgrades and post production support.
• Provided training and assistance to team members on various enterprises upgrades and support assignments.
• An effective communicator with consistent academic record and good team player.
• Strong track record as HRMS 9.1 Implementation and production support lead in HRMS 9.1 Time and Labor, Absence management, North American Payroll modules with PHIRE and HPSM tools experience
• Have PeopleSoft certifications in Peopletools-I and PeopleSoft HRMS fundamentals (R9/IZO-218) with 81% percentile

TECHNICAL SKILLS

People Tools: 8.42/8.43/8.45/8.46/8.47/8.48/8.51/8.53 (Application Designer, PeopleSoft Internet Architecture, People Code, Upgrade Assistant, Change Assistant, Process Scheduler, Configuration Manager, Tree Manager).

Integration Tools: (Application Engine, File Layout, Component Interface, Application Messaging, Application package)

HCM/HRMS: 8.8/8.9/9.0/9.1/9.2

Reporting Tools: PS Query, SQR,XML Publisher

Data Management Tools: Data Mover

Workflow: Approval Workflow Engine

Database: Oracle 9i, Oracle 10g, SQL Server 2000, SQL Server 2005

Servers: BEA Web Logic

Operating Systems: Windows NT/2000, MAC OS X (Tiger, Leopard)

Programming Languages: PeopleCode, SQL, C/C++, Java

Migration tools: PHIRE,STAT

PROFESSIONAL EXPERIENCE

Confidential, San diego CA

PeopleSoft NA Payroll, Benefits, Time and Labor, self service,Manager self service, Core-HR, Performance management upgrade technical consultent

Responsibilities:

• Troubleshooter for issues that occurred during the upgrade
• Base Benefits Interface support to the Solar Turbine specific requirements
• Responsible for re-engineering, and programming over 60 HR, Payroll, benefits report programs
• Participated in end-to-end system testing and developing fixes for identified bugs
• Creating modification designs to both online and batch environments, developing modifications, system testing functionality
• Wrote SQR process to purge expired reports from report repository and to clean up the process request tables
• Troubleshooted and Tuned Time and Labor processing Issues
• Debugged and modified custom SQR reports and on-line PeopleSoft processes for HR, Payroll and benefits as part of issues cleanup after upgrade to version 8. Provided daily support for payroll and benefits problems Follow established Change Control Procedures as per SOX for implementing any objects into the Production Environment
• Retrofitting the custom process designed for COSD to get the hire information from Neo gov system
• Developed pivot grids for managers to analyze associate hire, termination, retiree information on managers dash board
• Worked on security for authorization errors on web librairies
• Developed announcements on pagelets for time sheet reminders in time and labor module
• Converted crystal reports into XML publisher
• Clean the DDD audit and sys audit reports for every 4 weeks to get the environment for more stable
• Analyze the compare reports with 9.2 demo and 9.0 production to get custom process
• Worked on setup to get default values for country name format in adding the person in job component
• Worked on full payroll cycle for COSD associates
• Developed custom process to get earnings/deductions into pshup table to load into paysheets
• Worked on performance tuning for custom process to enroll employees into leave accrual system for COSD associates
• Retrofitted permission list for benefits self service
• Involved in changing the benefits configurations setup to support e-benefits implementation
• Consolidated domestic partner medical/dental visions plans into health plans
• Developed reports for earning,deductions for each payroll
• Retrofitted work flows for hire/termination processes in core hr
• Prepared new custom page for benfits summary for each plan on self service
• Created new sqr for FSA deductions on paycheck based on Benfit enrollment changes
• Created XML Publisher templates for benefit reports

Environment: s: PeopleSoft HRMS/North American Payroll, Time and Labor, Benefits and Corehr9.2,self service, People Tools 8.53, Oracle 11g, Oracle Linux.

Confidential, Richmond, VA

PeopleSoft NAPayroll, Benefits, Time and Labor and Absence management Production support developer

Responsibilities:

• Actively involved in Configuration of Time and Labor, Benefits, Absence management and NA payroll setup for Confidential
• Designed a SQR program to populate the eligibility configuration fields with different values based on the service and average hours worked that was set to run every week.
• Involved in setting up the EOI configuration rules for the newly converted ING employees so that the rules will work as the existing employees.
• Set up the new companies, Action /Reasons, eligibility rules, Event classes, benefit programs for the newly converted ING associates and enrolled then in the respective benefit programs by running the snap event.
• Customized the benefits self service panels according to the clients requirement to show different custom text for different benefit programs for Open enrollment.
• Involved in setting up different flat rates and salary based rates for different plans for the payroll to calculate the deductions.
• Setup different Schedule Id’s and ran the Open Enrollment and Event Maintenance process based on Location.
• Worked with the payroll team on setting up the Pay Calendar Tables, Deduction tables and Pay group Tables for the year of 2013.
• Prepared and presented business cases addressing various gap issues for project management approval.
• Responsible for identifying the test conditions, writing the test scripts based on the system requirements and executing them as part of the Functional testing.
• Assisted the business users in User acceptance testing for the ING conversion and Open enrollment projects.
• Wrote on demand queries to validate the converted data and developed some PS queries to validate the data before and after the migration.
• Created Batch process application engine for Enrollment of Associates into Time and Labor
• Creates time and labor rules and sql objects
• Extensively worked on rule performance and compilation pf rules in Time and labor
• Created Notification process for remind the not submitting timesheet in Week
• Created custom pages to approvae the pending report time
• Worked on trc’s setup for defined usa holidays
• Resolved the daylight saving issues for all Confidential associates who worked throughout the USA
• Created the complex rules for time and labor based on client needs
• Worked in Setting up entitlement elements/ formulas in Absence management
• Worked on Setting up Absence Management brackets
• Created NA Payroll tax reports by using XML publisher
• Actively involved in Integration of Time and Labor with N.A Payroll.
• Actively involved in full life cycle of tax update 12A to 12F and 13A, 13B,13Cto get the tax rates and tax tables into Confidential global M-Systems
• Actively involved in designing or in certain cases redesigning functionality, whereby documenting the changes to the existing payroll interface processes to the North America Payroll Process.
• Gained a good understanding of Confidential business processes and helped configure the PeopleSoft North American Payroll Business Process to suit the requirements of COF as well.
• Took ownership for all online development that needed to be done to the existing COF payroll application to accommodate COF functionality. The consolidated application would run pay sheets, calculate payroll, and generate paychecks for all employees from COF. The system was made capable to handle payroll for combined employee strength of well over 40,000 individuals.
• Extensively worked on customizing existing PeopleCode and writing new PeopleCode, including Application Engine PeopleCode, Application Package PeopleCode, Application Message PeopleCode, Record/Record-Field PeopleCode, and Component PeopleCode.
• Created custom records, views, and SQL Objects to be used in SQRs and PeopleCode, to restrict pieces of functionality to COF only.
• Aided in fixing issues arising during payroll calculation because of some missing regulatory tax updates.
• Made customizations to COF existing payroll Interface and benefits interfaces.
• Incorporated the legally mandated California Compliance Policy to allow processing for California based COF employees, along with the existing process for payroll interface for California employees.
• Developed custom component to allow for custom paycheck messages that will show up on an employee’s paycheck. Messages can be setup for individual employees, or for employees based on a combination of criteria.
• Modified the Earnings and Deduction Code Setup components to allow multiple GL Expense and GL Liability accounts to be setup for the same earning or deduction code, based on the setID of the Business Entity. This was necessary because each of the three business entities would maintain their own GL Interface programs.
• Created custom logic to retrieve bank information for paychecks based on the work state of an employee and not based on the employee’s pay group.
• Developed a custom SQR to help debug PS HR ACCTG LINE balancing issues in the GL Interface process. This SQR would identify individual accounting lines, which might cause the Sum of Monetary Amount on the PS HR ACCTG LINE record to not be exactly zero or close to zero. Employed a complex SQL with outer joins, sub-queries, and multiple joins with over 6 different tables.
• Developed a custom SQR process to populate run control records for all delivered and custom payroll batch processes. This was done because COF decided to use a custom tool (Control-M) to schedule batch jobs via the Process Scheduler.
• Designed and developed a custom process to over-ride direct deposit fixed options for highly compensated management executives during an off-cycle payroll. This process gives the payroll administrator the ability to override the direct deposit options for employees at the pay sheet and pay line level, and move the amounts into a net pay distribution balance account.
• Developed application messages to send HR/Payroll specific information concerning employees on job data and direct deposit, from HRMS to FSCM using asynchronous messaging.
• Designed and developed an internal messaging application which would allow pay earning updates while an associate is terminated with a back-dated effective date. This was necessary to reduce the processing overload on the job data component.
• Actively working on closing open or new issues/defects reported on a day-by-day basis by formulating strategies and plans with other team members to work on a tight time-line.
• Aiding the QA team to test the different payroll and benefit interfaces by creating sample test files and validating the outputs.
• Actively working with the testing and migration teams for creating or modifying test cases/scenarios and formulating efficient migration and data conversion strategies to have the minimum down time for business users.
• Worked on W2 - form generation for the Confidential 37K population
• Customized the application engines for FSA, DCP, and suppression accumulator match for the N.A Payroll.
• Created Application engine for TALX and PAC vendors to send the every on cycle data to vendors
• Worked extensively on Go-live Activities like migration and setup implementation for N.A Payroll and time and labor modules
• Worked on year end test for N.A Payroll and time and labor like run the payroll in December end pay cycle and Jan 1st pay cycle to cross verify the file data for vendors like TALX and PAC
• Worked on leave of absents calculations and plan enrollments for PTO/Vacation in leave accrual module
• Worked on carry over leaves for corresponding year
• Worked on leave plan enrollments for who completed their probationary period.
• Created application engines from scratch for leave plan enrollment when job data changed like FLSA status and STD hours.
• Created reports In N.A Payroll for deductions and earning reports and time and labor reports for Aetna productive hours and time punches for every week

Environment: s: PeopleSoft HRMS/North American Payroll, Time and Labor, Benefits and Corehr9.1, People Tools 8.51, Oracle 11g, Oracle Linux.

Confidential

PeopleSoft Techno Functional Analyst / Tester

Responsibilities:

• Gathered requirements from users and administrators for open enrollment window for two different groups and set up the configurations as per the requirement.
• Responsible for fixing production issues and migration of the fixes to production environment and monitoring them after the go live.
• Setup the brand new benefit programs and benefit plans for the retiree employees based on the eligible year.
• Gathered the requirements for the new interfaces written for the new vendors and written the functional specification document based on the vendor’s requirement.
• Analyzed the existing interfaces and customized them as per the new requirement.
• Worked with offshore and on site development team get the development work done as per the schedule.
• Designed a SQR program to populate the eligibility configuration fields with different values based on the service and average hours worked that was set to run every week.
• Involved in setting up the EOI configuration rules for the newly converted ING employees so that the rules will work as the existing employees.
• Set up the new companies, action /reasons, eligibility rules, event classes, benefit programs for the newly converted ING associates and enrolled then in the respective benefit programs by running the snap event.
• Customized the benefits self service panels according to the clients requirement to show different custom text for different benefit programs for open enrollment.
• Involved in setting up different flat rates and salary based rates for different plans for the payroll to calculate the deductions.
• Setup different schedule id’s and ran the open enrollment and event maintenance process based on location.
• Worked with the payroll team on setting up the pay calendar tables, deduction tables and pay group tables for the year of 2013.
• Prepared and presented business cases addressing various gap issues for project management approval.
• Responsible for identifying the test conditions, writing the test scripts based on the system requirements and executing them as part of the Functional testing.
• Assisted the business users in User acceptance testing for the ING conversion and Open enrollment projects.
• Wrote on demand queries to validate the converted data and developed some PS queries to validate the data before and after the migration.

Environment: s: PeopleSoft HRMS 8.8 BOA, PeopleSoft HRMS 9.0, with Maintenance Pack 6, People Tools 8.48, Oracle 10g.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Technical lead supporting HR consulting on North American Payroll, Work Force Administration, Self Service Applications and Position Management on PeopleSoft HCM 8.9
• Involved extensively in Fit Gap analysis, design and development, and documentation of Confidential business model as part of enhancements to their eBenefits application.
• Involved in applying critical Patches, Bundles, Tax and Legislative Updates from Oracle-PeopleSoft
• Customer Connection.
• Involved in Configuring Self Service Applications (eProfile, eProfile Manager Desktop, ePay, eBenefits).
• Customized the PAY034 Pre Paysheet Audit report in Confidential North American Payroll application, to account for a group of employees who were assigned to a benefit plan they shouldn’t be, prior to the pay sheet generation.
• Customized the PAY015B Outstanding Check Register report in Confidential North American Payroll application, to include negative 999 checks.
• Customized Confidential internal process to transmit off-cycle checks via the bank interface upload on a daily basis.
• Set up Absence classes, types, codes and parameters to facilitate the absence tracking process.
• Set up Work schedules and Holiday schedules for employees.
• Involved in setting up vacation benefits plans and defined employee entitlement rules for the plans.
• Customized delivered reports for Absence listing, absence spells and time lost due to absences to take into account Confidential custom added fields.
• Provided break-fix solutions and enhancements to Confidential system based on the tickets raised by ANZ users using the HP Service Desk 4.0 ticketing tool.
• Re-configured PeopleSoft security 8.9 by creating a security matrix to identify desired access levels for users and mapping them out to permission lists, roles and user profiles.
• Redesigned the Department Security Tree to provide more flexibility in terms of row level security. Implemented Query Tree Security.
• Involved in developing and customizing various PeopleSoft objects such as fields, records, pages, components, menus, and performing data validation using People Code at different levels, and different events in the Component Buffer.
• Involved in Unit Testing and ad-hoc testing the developed functionality and customizations before signing off to the testing team.
• Interacted with Confidential functional consultants to understand their functional needs and customized the system to in corporate the same.

Environment: s: PeopleSoft HCM 8.9 with Maintenance Pack 3, People Tools 8.47.11, Oracle 10g.

Confidential

PeopleSoft Technical Consultant/Upgrade Specialist

Responsibilities:

• Involved in the running and analysis of the Vanilla Compare Report wherein a comparison of the 8.3 SP1 vanilla demo environment was done with Confidential 8.3 SP1 copy of production environment.
• Well versed in identifying under stamping and over stamping issues by analyzing the Vanilla Compare Report.
• Involved in running initial audit (DDDAUDIT and SYSAUDIT) reports and the subsequent cleanup of the Copy of Production Environment.
• Applied crucial Required for Install and Required for Upgrade fixes to the new release demo environment to ensure no errors or bottlenecks are encountered during the upgrade.
• Performed PeopleTools upgrade on Confidential Copy of Production Environment to upgrade its toolset from version 8.42 to version 8.46.
• Involved in running the Full Compare Report, which is the comparison between Confidential Copy of Production at 8.3 SP1 application release but new tools release with a 8.8 SP1 demo environment at a new tools release. On analysis of this Full Compare Report the customizations were identified.
• Modified data conversion application engine programs to account for Confidential customizations.
• Extensively involved in reapplying customizations to records, pages, PeopleCode, components, menus, permission lists, message channels, portal registry structures and various other PeopleSoft objects post upgrade.
• Involved in applying patches, tax updates and maintenance packs to Confidential now upgraded copy of production.
• Performed project and data migration from one environment to another using PeopleSoft data mover tool.
• Actively involved in unit testing, system testing and load testing of the application prior to going live. Thereby providing Confidential with an optimum and stable working PeopleSoft applications.
• Ran absence reports to identify absence listings, absence spells and time lost due to absence for analysis.
• Handled enhancement requests made by Caterpillar to their Work Force Admin, Recruiting and Self Service applications.
• Recommended a template based Smart Hire solution in recruitment for Confidential
• Involved in customizing the PeopleSoft delivered business process for resume processing to suit Confidential requirements.
• Supported and maintained Confidential outbound and inbound 3rd party interfaces for payroll processing.

Environment: s: PeopleSoft HRMS 8.3 SP1, PeopleSoft HCM 8.8 SP1 with Maintenance Pack 6, People Tools 8.42, People Tools 8.46.11, Oracle 9i.