Summary

--------------------------------------------------------------------------------------------------------------------------------------------------

• Over 5.8 years experience as a PeopleSoft Business Analyst, with expertise in Creating requirement based on client needs,Implementation, Maintenance and Upgrade of PeopleSoft HCM/HRMS modules Time and Labor, Absence management,HR Core, Benefits, Self Service, North American Payroll, Monitor Absences, Benefits Administration, Campus solutions, Enterprise learning management, Ecompensation, Eperformance management
• Completed 3 full Open enrollment cycles at different clients using Peoplesoft Benefits and Benefits Administration system.
• Hands on experience in setting up the configurations for Time and Labor and N.A Payroll.
• Hands on Experience in Time Labor, Time Administration, interfacing with TCDs, configuration for complex rules.
• Completed taxupdate 12A to 12F and 13A to get the tax rates into peoplesoft system
• Worked as Functional analyst in PeopleSoft HCM module which include from requirement gathering, fit gap analysis and preparing the functional specifications.
• Expertise in doing excellent documentation on business requirements.
• Hands on experience in setting up the configurations for Base Benefits, Benefit Administration and Payroll.
• 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 HCM/HRMS 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 Application and Process Flows in PeopleSoft HCM 9.1
• Experienced in PeopleSoft Security Administration for PeopleSoft HRMS/HCM
• Extensive knowledge of People Tools including Application Designer, PeopleSoft Internet Architecture, Configuration Manager, Tree Manager, PS Query, Data Mover, Upgrade Assistant and Change Assistant.
• Experience 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 Enterprise Upgrade and Support assignments.
• An effective communicator with consistent academic record and good team player.
• Strong track record as production support team lead in all HCM modules with PHIRE and HPSM tools Experience
• Having peoplesoft Certications 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 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
• HCM/HRMS 8.8/8.9/9.0/9.1
• Reporting Tools - PS Query, SQR
• Data Management Tools - Data Mover
• 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 People Code, SQL, C/C , Java
• Migration tools: PHIRE,STAT

PROFESSIONAL EXPERIENCE

Confidential

Role: PeopleSoft Payroll Techno functional Consultant

Description: Implementation of PeopleSoft Confidential Payroll and Time and Labor 9.1 applications for Confidential , involving phases starting with requirements gathering, technical/functional design, development, and testing.

Responsibilities:

• Actively involved in Configuration of Time and Labor setup for capitalone
• Created Batch process application engine for Enrollment of Associates into Time and Labor
• Created Notification process for remind the not submitting timesheet in Week
• Resolved the Daylight saving issues for capitalone associates worked throught USA
• Creted the complex rules for time and labor based on client needs
• Actively involved in Integration of Time and Labor with N.A Payroll.
• Actively involved in full life cycle of taxupdate 12A to 12F and 13A to get the tax rates and tax tables into capone global msysytem
• Actively involved in designing or in certain cases redesigning functionality, whereby documenting the changes to the existing Payroll Interface processes to North America Payroll process.
• Gained a good understanding of Capitalone business processes and helped configure the PeopleSoft North American Payroll business process to suite 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 paysheets, 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 California employees.
• Developed a 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 3 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 Paygroup.
• 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 Paysheet/Payline 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 capitalone 37K population
• Customized The Application engines for FSA,DCP,Suppression acuumulator match for the N.A Payroll.
• Created Application engine for TALX and PAC vendors to send the every oncycle 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 paycycle and Jan 1st payccycle to cross verify the file data for vendors like TALX and PAC
• Worked on Leaves calculation and plan enrollments for PTO/Vacation in leave accrual Module
• Worked on Carry over leaves for Corresponding year
• Worked on Leave plan enrollments for whom completed their probationary period.
• Created application engines from scratch for Leave plan enrollment when job data eas changed like FLSA status and STD hours Change.
• 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

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

Confidential

Role: PeopleSoft Functional Analyst / Tester

Responsibilities:

• Gathered requirements from users and administrators for Open enrollment window for 2 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.

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

Role: PeopleSoft Technical Consultant

Description: PeopleSoft HCM/Confidential Payroll 8.9 post-production support involving HR Core, Confidential Payroll, Self Service Applications and Monitor Absences modules.

Responsibilities:

• Technical lead supporting HR consulting on Confidential 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 Hewitt 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 Hewitt 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 Hewitt North American Payroll application, to include negative 999 checks.
• Customized Hewitt 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 Hewitt custom added fields.
• Provided break-fix solutions and enhancements to Hewitt 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 Hewitt functional consultants to understand their functional needs and customized the system to incorporate the same.

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

Role: PeopleSoft Technical Consultant/Upgrade Specialist

Description: Upgrade of PeopleSoft HRMS system from version 8.3 to 8.8 involving modules HR Core Work Force Administration , Recruitment, Payroll for Confidential, ESS and Monitor Absences

Responsibilities:

• Involved in the running and analysis of Vanilla Compare report wherein a comparison of the 8.3 SP1 vanilla demo environment was done with Tech-M 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 People Tools upgrade on Tech-M 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 Tech-M 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 Tech-M customizations.
• Extensively involved in reapplying customizations to records, pages, People Code, 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 Tech-M 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 go live. Thereby providing Tech-M with an optimum and stable working PeopleSoft Application.
• 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 Tech-M
• Involved in customizing the PeopleSoft delivered business process for resume processing to suit Tech-M requirements.
• Supported and maintained Tech-M outbound and inbound 3rd party interfaces for Payroll processing.
• Environments: 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.