SUMMARY

• Over 15 years in the Information Technology industry and more than 13 years as a PeopleSoft Consultant performing analysis, design, implementation and testing of PeopleSoft HCM/HRMS, Benefit Administration, eBenefits, Benefits Billing, Payroll, Manager Desktop and Payroll projects.
• Exceptional functional knowledge of HCM/HRMS, Benefit Administration, eBenefits Base Benefit, Payroll, Payroll interface.
• Carrying out activities related to requirements gathering as well as system and fit/gap analysis, system design, core table set ups, testing and training support of PeopleSoft applications.
• Advanced knowledge of PeopleSoft Internet Architecture and web logic.
• Highly skilled in RDBMS concepts and data extraction, manipulation and reporting tools with excellent knowledge of Software Development Life Cycle (SDLC)
• Ability to work independently and successfully as part of a team
• Excellent analytical and problem solving skills
• Excellent documentation skills and communication skills
• Ability to learn and adapt to new programming environments.
• Talented at solving problems quickly with strong research, investigative and troubleshooting skills.
• Proven ability to manage and motivate functional teams in Peoplesoft HRMS implementations including Revitalization skills during the implementation.
• Setting core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Setting employee pay data that include personal data, job data, benefits data, federal, state/provincial, and local tax information, general and benefit deductions
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Testing expertise includes:
• Test Plan and Test Cases Formulation
• Planning and tracking projects using various automated testing tool. E.g. QC/ALM and SharePoint.
• Regression Testing and Performance Testing using Mercury’s automated tools like WinRunner, LoadRunner
• Working knowledge of Bug Reporting Tools like Test Director.
• Experience in Backend Testing using SQL queries and PL/SQL blocks.
• Expertise in writing Test plan, test cases for various kinds of testing methodologies.

COMPUTER SKILLS

Programming Language SQL, C,, Java, VHDL,ASM: Database MS SQL 7.0, MS Access, Oracle 7.x/8.0/9.i

Operating System Windows (XP/ 2000/ 98/ NT), Linux, Unix,: Mac

Web Technologies XML and HTML, XSL: GUI Visual Basic, Visual Age for Java 4.0

Testing tools Win Runner 6.x/7.x, Load Runner, Test Director(Quality Centre QC ALM ), Sharepoint: Packages Macromedia Flash 6.0, Adobe PhotoShop 6.0, SPSS, Tornado and VxWorks

Hardware Competent in hardware installation and networking: Miscellaneous System, Tomcat, VM Ware, Microsoft Office, Visio, Project.

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Benefits Lead

Responsibilities:

• Conducted full Base Benefits & Benefits Administration Audit and reconfigured set - up tables as necessary.
• Responsible for setting up Permission Lists, Roles and User Profiles
• Configuration, executing Open enrolment process, customizing enrollment form and confirmation statement
• Implemented Benefits Billing
• Gathered requirements from End users for required customizations.
• Document resolution document for steering committee for customization approval and business process changes.
• Conducted several design sessions for Base Benefits, Benefit Administration and eBenefits modules based a documented Fit/Gap solutions.
• Worked with team to conduct user requirement analysis and business process re-engineering for HR functions and workflows.
• Responsible for doing the Impact and Fit - Gap analysis of modification and changes
• Defining the rules for Training Enrollment
• Setup Eligibility Rules and worked with custom Eligibility Configuration fields
• Created general and detailed Functional and Technical specifications document based on the requirements.
• Worked on ACA reporting and Eligibility
• Developed Project Plan, Test Scripts, and Test Cases, ensuring timely completion of technical & functional deliverables, configuration of set-up tables, auditing of data and interfaces produced.
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Analyzed user and system requirements together with specification documents and develop cases for test plan
• Performed manual testing and reported defects to developers
• Tested HR Benefits Administration and Payroll module for accuracy
• Involved in developing Test Incident Report for defects on daily, weekly and Monthly basis.
• Implement Changes to defective script throughout the testing life cycle
• Conducted database testing by executing PS queries for Database verification to ensure that the server was being updated as expected after user activity on the front end of the application
• Conducted Integration Testing of Reports, Interfaces and Components to ensure that it meets client’s requirements.
• Developed Test Scripts and Test Cases for Open Enrollment, Benefits and Payroll
• Examined Documentation on different environment to further assist in testing and attaining appropriate results.
• Design the customization of fields in reference to user requirements.
• Modified fields, pages and menus by using people code as per user requirements.
• Setting eBenefits and enrolling employees in benefit Plans Confidential, Insurance, Savings, FSA, dependents/ Beneficiaries and life events like marriage, personal information, and Tax information.
• Implement Retro Benefits and deductions.
• Setting up and maintaining Employee self service page
• Granted access to users and worked on security tree.
• Set up table for Base Benefit that includes provider table, coverage group code, rate table, calculation rule table, and deduction code.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment.
• Set up the health benefit plan, Life insurance and accidental death plan, and disability benefit plan.
• Ran pay calculations, review corrected identified errors in pay calculations and review the final pay calculations and ran final pay calc.
• Building base benefit program that includes setting the plans, plan types, plan options and calculation rules
• Assisted dependent & beneficiary information entry and participant enrollment
• Defining eligibility for automatic enrollment of employees, assigning deductions to programs, plan types and plan options.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment and Event maintenance
• Designed page layouts of employee hiring page, job code page, employee personal information page, job record page, benefit record
• Development and execution of test scripts and ensured the desired results for the end-user.
• Benefits administration activities included terminations, rehires, leave of absence, short-term disability and retirements of employees and calculations to Payroll.
• Developed plans, test scripts, test cases for base benefit and benefit administration
• Performed back end testing using SQL statements.

Confidential

PeopleSoft Subject Matter Expert/ UAT Coordinator

Responsibilities:

• Conducted full Base Benefits & Benefits Administration Audit and reconfigured set-up tables as necessary.
• Responsible for setting up Permission Lists, Roles and User Profiles
• Configuration, executing Open enrolment process, customizing enrolment form and confirmation statement
• Gathered requirements from End users for required customizations.
• Set up foundation tables for HR such as business unit table, location table, department table
• Worked with team to conduct user requirement analysis and business process re-engineering for HR functions and workflows.
• Set up the apply for job transaction
• Responsible for doing the Impact and Fit - Gap analysis of the modification,
• Defining the rules for Training Enrollment
• Setup Eligibility Rules and worked with custom Eligibility Configuration fields
• Created general and detailed Functional and Technical specifications document based on the requirements.
• Developed Project Plan, Test Scripts, and Test Cases, ensuring timely completion of technical & functional deliverables, configuration of set-up tables, auditing of data and interfaces produced.
• Participated in documentation including (SetIDs, Business Units, Department ID and Locations ID).
• Setting core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Setting employee pay data that include personal data, job data, benefits data, federal, state/provincial, and local tax information, general and benefit deductions
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Analyzed user and system requirements together with specification documents and develop cases for test plan
• Setting up of employee pay data that include personal data, job data and benefits data, as well as federal, state/provincial, and local tax information, general and benefit deductions.
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Performed manual testing and reported defects to developers through test director
• Tested HR Benefits Administration and Payroll module for accuracy
• Involved in developing Test Incident Report for defects on daily, weekly and Monthly basis.
• Implement Changes to defective script throughout the testing life cycle
• Conducted database testing by executing PS queries for Database verification to ensure that the server was being updated as expected after user activity on the front end of the application
• Conducted Integration Testing of Reports, Interfaces and Components to ensure that it meets client’s requirements.
• Developed Test Scripts and Test Cases for Open Enrollment, Benefits and Payroll
• Examined Documentation on different environment to further assist in testing and attaining appropriate results.
• Involved in customization of fields in reference to user requirements.
• Modified fields, pages and menus by using people code as per user requirements.
• Used Application designer to modify fields, pages, menus and records according to user requirements..
• Setting eBenefits, Providing Merchant Integration, enrolling employees in benefit Plans include Health, Insurance, Savings, FSA, dependents/ Beneficiaries and life events like marriage, personal information, and Tax information.
• Implemented Tableset sharing.
• Setting up and maintaining Employee self service page
• Granted access to users and worked on security tree.
• Set up table for Base Benefit that includes provider table, coverage group code, rate table, calculation rule table, and deduction code.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment.
• Set up the health benefit plan, Life insurance and accidental death plan, and disability benefit plan.
• Ran pay calculations, review corrected identified errors in pay calculations and review the final pay calculations and ran final pay calc.
• Building base benefit program that includes setting the plans, plan types, plan options and calculation rules
• Assisted dependent & beneficiary information entry and participant enrollment
• Defining eligibility for automatic enrollment of employees, assigning deductions to programs, plan types and plan options.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment and Event maintenance
• Setting core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Responsible for setting up Permission Lists, Roles and User Profiles
• Designed page layouts of employee hiring page, job code page, employee personal information page, job record page, benefit record
• Development and execution of test scripts and ensured the desired results for the end-user.
• Benefits administration activities included terminations, rehires, leave of absence, short-term disability and retirements of employees and calculations to Payroll.
• Developed plans, test scripts, test cases for base benefit and benefit administration
• Performed back end testing using SQL statements.

Confidential, MN

Configuration and Open Enrollment Analyst

Responsibilities:

• Conducted full Base Benefits & Benefits Administration Audit and reconfigured set-up tables as necessary.
• Responsible for setting up Permission Lists, Roles and User Profiles
• Configuration, executing Open enrolment process, customizing enrolment form and confirmation statement
• Gathered requirements from End users for required customizations.
• Set up foundation tables for HR such as business unit table, location table, department table
• Worked with team to conduct user requirement analysis and business process re-engineering for HR functions and workflows.
• Set up the apply for job transaction
• Responsible for doing the Impact and Fit - Gap analysis of the modification,
• Defining the rules for Training Enrollment
• Setup Eligibility Rules and worked with custom Eligibility Configuration fields
• Created general and detailed Functional and Technical specifications document based on the requirements.
• Developed Project Plan, Test Scripts, and Test Cases, ensuring timely completion of technical & functional deliverables, configuration of set-up tables, auditing of data and interfaces produced.
• Participated in documentation including (SetIDs, Business Units, Department ID and Locations ID).
• Setting core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Setting employee pay data that include personal data, job data, benefits data, federal, state/provincial, and local tax information, general and benefit deductions
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Analyzed user and system requirements together with specification documents and develop cases for test plan
• Setting up of employee pay data that include personal data, job data and benefits data, as well as federal, state/provincial, and local tax information, general and benefit deductions.
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Performed manual testing and reported defects to developers through test director
• Tested HR Benefits Administration and Payroll module for accuracy
• Involved in developing Test Incident Report for defects on daily, weekly and Monthly basis.
• Implement Changes to defective script throughout the testing life cycle
• Conducted database testing by executing PS queries for Database verification to ensure that the server was being updated as expected after user activity on the front end of the application
• Conducted Integration Testing of Reports, Interfaces and Components to ensure that it meets client’s requirements.
• Developed Test Scripts and Test Cases for Open Enrollment, Benefits and Payroll
• Examined Documentation on different environment to further assist in testing and attaining appropriate results.
• Involved in customization of fields in reference to user requirements.
• Modified fields, pages and menus by using people code as per user requirements.
• Used Application designer to modify fields, pages, menus and records according to user requirements..
• Setting eBenefits, Providing Merchant Integration, enrolling employees in benefit Plans include Health, Insurance, Savings, FSA, dependents/ Beneficiaries and life events like marriage, personal information, and Tax information.
• Implemented Tableset sharing.
• Setting up and maintaining Employee self service page
• Granted access to users and worked on security tree.
• Set up table for Base Benefit that includes provider table, coverage group code, rate table, calculation rule table, and deduction code.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment.
• Set up the health benefit plan, Life insurance and accidental death plan, and disability benefit plan.
• Ran pay calculations, review corrected identified errors in pay calculations and review the final pay calculations and ran final pay calc.
• Building base benefit program that includes setting the plans, plan types, plan options and calculation rules
• Assisted dependent & beneficiary information entry and participant enrollment
• Defining eligibility for automatic enrollment of employees, assigning deductions to programs, plan types and plan options.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment and Event maintenance
• Setting core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Responsible for setting up Permission Lists, Roles and User Profiles
• Designed page layouts of employee hiring page, job code page, employee personal information page, job record page, benefit record
• Development and execution of test scripts and ensured the desired results for the end-user.
• Benefits administration activities included terminations, rehires, leave of absence, short-term disability and retirements of employees and calculations to Payroll.
• Developed plans, test scripts, test cases for base benefit and benefit administration
• Performed back end testing using SQL statements.
• Setting up of employee pay data that include personal data, job data and benefits data, as well as federal, state/provincial, and local tax information, general and benefit deductions
• Performed back end testing using SQL statements.

Confidential, VA

Lead PeopleSoft Systems Analyst

Responsibilities:

• Conducted full Base Benefits & Benefits Administration Audit and reconfigured set-up tables as necessary.
• Gathered requirements from End users for required customizations.
• Set up foundation tables for HR such as business unit table, location table, department table
• Worked with team to conduct user requirement analysis and business process re-engineering for HR functions and workflows.
• Set up the apply for job transaction
• Responsible for doing the Impact and Fit - Gap analysis of the modification,
• Defining the rules for Training Enrollment
• Setup Eligibility Rules and worked with custom Eligibility Configuration fields
• Created general and detailed Functional and Technical specifications document based on the requirements.
• Developed Project Plan, Test Scripts, and Test Cases, ensuring timely completion of technical & functional deliverables, configuration of set-up tables, auditing of data and interfaces produced.
• Participated in documentation including (SetIDs, Business Units, Department ID and Locations ID).
• Analyzed user and system requirements together with specification documents and develop cases for test plan
• Performed manual testing and reported defects to developers through test director
• Tested HR Benefits Administration and Payroll module for accuracy
• Involved in developing Test Incident Report for defects on daily, weekly and Monthly basis.
• Implement Changes to defective script throughout the testing life cycle
• Conducted database testing by executing PS queries for Database verification to ensure that the server was being updated as expected after user activity on the front end of the application
• Conducted Integration Testing of Reports, Interfaces and Components to ensure that it meets client’s requirements.
• Developed Test Scripts and Test Cases for Open Enrollment, Benefits and Payroll
• Examined Documentation on different environment to further assist in testing and attaining appropriate results.
• Involved in customization of fields in reference to user requirements.
• Modified fields, pages and menus by using people code as per user requirements.
• Used Application designer to modify fields, pages, menus and records according to user requirements.
• Configuration, executing Open enrolment process, customizing enrolment form and confirmation statement.
• Setting eBenefits, Providing Merchant Integration, enrolling employees in benefit Plans include Health, Insurance, Savings, FSA, dependents/ Beneficiaries and life events like marriage, personal information, and Tax information.
• Setting up and maintaining Employee self service page
• Granted access to users and worked on security tree.
• Set up table for Base Benefit that includes provider table, coverage group code, rate table, calculation rule table, and deduction code.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment.
• Set up the health benefit plan, Life insurance and accidental death plan, and disability benefit plan.
• Ran pay calculations, review corrected identified errors in pay calculations and review the final pay calculations and ran final pay calc.
• Building base benefit program that includes setting the plans, plan types, plan options and calculation rules
• Implemented FMLA (Family Medical Leave Act) plan that involved leave request, determined its eligibility, leave schedule
• Defined FSA (Flexible Spending Account) plan
• Implemented COBRA
• Assisted dependent & beneficiary information entry and participant enrollment
• Defining eligibility for automatic enrollment of employees, assigning deductions to programs, plan types and plan options.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment and Event maintenance
• Setting core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Setting up of employee pay data that include personal data, job data and benefits data, as well as federal, state/provincial, and local tax information, general and benefit deductions.
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Responsible for setting up Permission Lists, Roles and User Profiles
• Designed page layouts of employee hiring page, job code page, employee personal information page, job record page, benefit record
• Development and execution of test scripts and ensured the desired results for the end-user.
• Benefits administration activities included terminations, rehires, leave of absence, short-term disability and retirements of employees and calculations to Payroll.
• Setting Up eligibility rules and geographic location eligibility rules for automation of open enrolment and even maintenance process.
• Developed plans, test scripts, test cases for base benefit and benefit administration
• Performed back end testing using SQL statements.

Confidential, Washington DC

Lead HRIS Analyst

Responsibilities:

• Gathered requirements from End users for required customizations.
• Set up foundation tables for HR such as business unit table, location table, department table
• Set up table for Base Benefit that includes provider table, coverage group code, rate table, calculation rule table, and deduction code.
• Worked with team to conduct user requirement analysis and business process re-engineering for HR functions and workflows.
• Responsible for doing the Impact and Fit - Gap analysis of the modification, enhancements and customizations of Base Benefits, Benefits Administration and Payroll Interface module
• Defining the rules for Training Enrollment and Training Enrollment
• Worked on interfaces with PeopleSoft HR recruit work force.
• Setup Eligibility Rules and worked with custom Eligibility Configuration fields
• Created general and detailed Functional and Technical specifications document based on the requirements.
• Developed Project Plan, Test Scripts, and Test Cases, ensuring timely completion of technical & functional deliverables, configuration of set-up tables, auditing of data and interfaces produced.
• Participated in documentation including (SetIDs, Business Units, Department ID and Locations ID).
• Setting up and maintaining Employee self service page
• Involved in customization of fields in reference to user requirements.
• Modified fields, pages and menus by using people code as per user requirements.
• Used Application designer to modify fields, pages, menus and records according to user requirements.
• Granted access to users and worked on security tree.
• Conducted full Base Benefits & Benefits Administration Audit and reconfigured set-up tables as necessary.
• Analyzed user and system requirements together with specification documents and develop cases for test plan
• Performed manual testing and reported defects to developers through test director
• Tested HR Benefits Administration and Payroll module for accuracy
• Involved in developing Test Incident Report for defects on daily, weekly and Monthly basis.
• Implement Changes to defective script throughout the testing life cycle
• Conducted database testing by executing PS queries for Database verification to ensure that the server was being updated as expected after user activity on the front end of the application
• Conducted Integration Testing of Reports, Interfaces and Components to ensure that it meets client’s requirements.
• Developed Test Scripts and Test Cases for Open Enrollment, Benefits and Payroll
• Examined Documentation on different environment to further assist in testing and attaining appropriate results.
• Setting up COBRA administration to identify COBRA-eligible plans to the COBRA participant by defining COBRA events for identifying qualified COBRA beneficiaries, sending timely communication, enrolling COBRA beneficiaries, and administering other COBRA actions like secondary qualifying events and plan terminations.
• Modified several PeopleSoft delivered Ben Admin and Payroll3h/ reports.
• Monitoring closely with functional and technical people to trouble-shoot systems issues in Benefits modules or other HRMS modules such as Payroll, which integrate with the benefits

Environment: Peoplesoft HRMS 8.9, Payroll, Base Benefits, Ben Admin, Java, Tuxedo, HTML, Oracle 9i, Unix, Windows 2000/XP,and Application Designer

PROFESSIONAL EXPERIENCE

Confidential, MD

PeopleSoft Functional analyst

Responsibilities:

• Performed requirements gathering
• Performed fit-gap analysis
• Set up foundation tables for HR such as business unit table, location table, department table
• Modified existing Payroll reports (PAY003, PAY039) to include data and headings as specified by user requirements
• Setting up core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Produced functional and technical specification
• Setup Payroll processes such as print forms, account codes, retroactive pay programs, pay adjustments, and payroll messages.
• Set up table for Base Benefit that includes provider table, coverage group code, rate table, calculation rule table, and deduction code.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment.
• Set up the health benefit plan, Life insurance and accidental death plan, and disability benefit plan.
• Ran pay calculations, review corrected identified errors in pay calculations and review the final pay calculations and ran final pay calc.
• Building base benefit program that includes setting the plans, plan types, plan options and calculation rules
• Implemented FMLA (Family Medical Leave Act) plan that involved leave request, determined its eligibility, leave schedule
• Defined FSA (Flexible Spending Account) plan
• Implemented COBRA
• Assisted dependent & beneficiary information entry and participant enrollment
• Defining eligibility for automatic enrollment of employees, assigning deductions to programs, plan types and plan options.
• Setting up of geographic eligibility rules as part of automation of benefits administration process for Open Enrollment and Event maintenance
• Setting core Payroll tables compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Setting up of employee pay data that include personal data, job data and benefits data, as well as federal, state/provincial, and local tax information, general and benefit deductions.
• Performed Payroll processing that include pay sheets creation, pay calculation, pay confirmation, generating checks and direct deposits
• Responsible for setting up Permission Lists, Roles and User Profiles
• Designed page layouts of employee hiring page, job code page, employee personal information page, job record page, benefit record
• Developed plans, test scripts, test cases for base benefit and benefit administration
• Performed back end testing using SQL statements.
• Setting up of employee pay data that include personal data, job data and benefits data, as well as federal, state/provincial, and local tax information, general and benefit deductions.