We provide IT Staff Augmentation Services!

Qa It Analyst Iii Resume Profile

2.00/5 (Submit Your Rating)

Baltimore, MD

Skills

Experience with EDI, Interfacing with insurance carriers, Open Enrollment

7 Years

2012

3-Expert

Experience with PeopleSoft Base benefits / Benefits Administration

15 Years

2012

3-Expert

Experience with PeopleSoft HCM

8 Years

2012

3-Expert

Experience with PeopleSoft HCM 9.0 or higher

5 Years

2012

3-Expert

Experience with PeopleSoft HR and Payroll

12 Years

2012

2 - Proficient

Experience with People Tools 8.49 or higher

4 Years

2012

3-Expert

Experience with SQL, PS Query

3 Years

2012

2 - Proficient

Experience with Oracle 10G and/or 11G

5 Years

2012

2 - Proficient

Employment History:

QA IT Analyst III

Confidential

Responsibilities:

  • Develop business requirement documents for Change Management Requirements
  • Expertise in PeopleSoft Implementation, Customization, Maintenance, Interfacing/ Reporting, Data Conversion for PeopleSoft HRMS.
  • Sr. PeopleSoft HCM Consultant for client's 2012 Open Enrollment Project.
  • Developed Setup EDI transactions between PeopleSoft Biz Manager using Integration broker, Created custom handlers for inbound / outbound transactions.
  • Created Project Plan and Specifications for implementation of new enhanced Benefit Plans
  • Wrote Full life cycle Test Plan, Test Scenarios and Test Scripts for testing for system upgrade
  • Configured core HR, Payroll and Benefit Tables for Open Enrollment 2012.
  • Responsible for training End Users on PS Benefit Administration, v 9.1
  • Re-evaluated Benefit Interface files and updated file specifications to accommodate changes.
  • Developed Business Requirements for client's FSA and H SA Benefit Plans
  • Ran On/Off cycle Payrolls to test modified Date Rules for Medical, Dental, Vision and H SA deductions.
  • Created and executed SQL scripts/queries to perform database checks.
  • Handled data cleanup for Benefit Administration and Base Benefits.
  • On-line Customizations using various People Tools like App. designer, Process scheduler, workflow Administrator, Business process designer and PeopleSoft Query.
  • Updated text catalog table for major changes to client's self-service pages.
  • Worked with HR Team with client's transition of benefit plans due to Acquisition.
  • Developing fit/gap analysis for system conversion integration for multiple conversion interface files.
  • Developed Ad Hoc queries for utilization in Access Database for development of Benefits Conversion file.

Environment: PeopleSoft HCM 9.1, People Tools 8.51, , SQR, Oracle 11g, Toad, Application Designer, People Code, SQR, SQL, PS/Query, CORE HR, NA PAYROLL, BASE BENEFITS, BENEFIT ADMINISTRATION, eBENEFITS

Confidential

HCM Solutions, HCM Consultant, Benefits Administration, v8.9 upgrade to v9.1

Responsibilities:

  • QA Lead Tester for Open Enrollment Project - Developed Test Plan, Test Scenarios and Test Scripts
  • Created Open Enrollment Specifications for plan configuration for 2012 OE Benefits
  • PeopleSoft HCM Consultant for Open Enrollment Project for 2012
  • Configured core HR, Payroll and Benefit Tables for Open Enrollment 2012.
  • Performed Fit Gap Analysis for client's Leave Plan Configuration and modified leave plan rules, and corrected leave balances to correct inaccuracies on the leave plan reports.
  • Modified client's 401k Plan Configurations and added new 401a Executive Savings Plan
  • Modified Benefit and Savings Plan Interface Files and worked with Vendors to test new file layouts.
  • Trained End Users on PS Query and developed reference documents for future use.
  • Reviewed clients interface file and created ad-hoc reports for new file submission.
  • Ran Payroll Deduction for multiple pay periods to sync FSA pay period totals.
  • Handled data cleanup for Benefit Administration and Base Benefits and trained end-user how to manage Automated Benefit Administration.
  • Updated text catalog table for major changes to client's self-service pages.
  • Updated clients ebenefits message catalog pages.

Environments: CORE HR, NA PAYROLL, BASE BENEFITS, BENEFIT ADMINISTRATION, eBENEFITS, People Tools 8.50/8.49 ,Crystal Reports 9, SQR, Oracle 11g/10g, , Windows NT/2000,Query Analyzer, Application Designer, People Code, SQR, SQL, PS/Query.

Confidential

Responsibilities:

  • PeopleSoft HCM for Open Enrollment period. Administered Benefit Administration process for Event Maintenance and managed team roles and assignments. Provided functional leadership to the team for Business Process changes.
  • Reviewed business policies and process to enhance end-user usage of the system and recommended best practice polices to maintain the quality and data integrity of the system applications.
  • Create and execute complex SQL and PS Queries to validate data
  • Developed and executed UAT system test plan and test scripts.
  • Responsibilities included development and management of project plan table setup and configuration of Base Benefit, Ben Admin and Payroll system tables.
  • Developed and Maintained Microsoft Project Plan for Open Enrollment project.
  • Analyzed client's business process for Self-Billing and made recommendation to automate processes that are currently being handled manually.
  • Provided clients with step-by-step instructions on how to administer Benefit Administration, v 8.9.
  • Trained end-users on usage of the system for Ben Admin, Payroll, Base Benefit and how to develop ad-hoc queries.
  • Acted as Compensation Analyst and created verification and proposal letters.
  • Redeveloped clients health and benefits interface files and forms.

Confidential

QA IT Analyst III/Payroll Consultant Production Support, V 8.9

Responsibilities:

  • Served as a PeopleSoft HCM Lead Analyst for UAT Testing development and planning.
  • Involved in PeopleSoft 8.9 to 9.1 Upgrade Utilized Production Support. Modules Like EDI, HCM,
  • Developed Comprehensive Test Plan and Test scripts with Excel ''Hyperlink capability for clients new 401K Plan Enhancement Project.
  • Expertise in PeopleSoft Implementation, Customization, Maintenance, Interfacing/ Reporting, Data Conversion for PeopleSoft HRMS.
  • Provided hands-on support of PeopleSoft HR/Payroll configuration, gathered business requirements, researched solutions, created detailed functional specifications, and transitioning specification to developers.
  • Provided PeopleSoft HR/Payroll functional expertise to End-Users / Business Owners on design issues and provide guidance on problem resolution.
  • Assisted in HR/Payroll planning, analysis, design, and testing activities during PeopleSoft upgrades and provide input on tools, standards, templates, and methodology.
  • Process On and Off-Cycle Payrolls and created and updated multiple pay group pay sheets.
  • Created queries to capture Payroll data to analyze and validate data integrity and confirmed that all Payroll processes were performing accurately.
  • Ran PS Paycheck program for multiple pay groups and validated the checks to confirm deductions and tax information was accurate. Made recommendation to client to remove excessive information and make modifications to the paycheck program so that it printed only the pertinent information that employee's were required to see.
  • Developed and created new Supplemental Retirement Plan SRSP Benefit Plan Requirement document to include configuration and setup for new 401k Retirement Plan.

Environment: CORE HR, NA PAYROLL, BASE BENEFITS, BENEFIT ADMINISTRATION, eBENEFITS, People Tools 8.49/8.48/8.47, Crystal Reports , SQR, Oracle

Confidential

Responsibilities:

  • Provided PeopleSoft HCM consulting for client's configuration issues with, Benefit Administration, Savings Plan Limits, 401k Accumulators, General Deduction codes and regular Deduction Codes.
  • Analyzed and troubleshoot issues around Qualified and Non-Qualified 401k Savings Plan Contributions.
  • Provided client with resolutions to 401k issues and gathered information on current 401k business processes and made recommendation for change so that enrollment into the 401k Contribution Plans were automatic and no longer a manual process. This change corrected many 401k-deduction mistakes that were being made on employee paychecks.
  • Reviewed client's system capabilities for automatic processing for 401k Savings Plan contribution and recommend enhancements and changes. This functionality required restructuring of Benefit Plan Deduction codes and General Deduction Codes.
  • Developed UAT Test Plan and Test Scripts for testing new 401k Configuration/Setup changes.
  • Created Payroll Business Requirement documents for end-users defining the correct methods in using PeopleSoft delivered Payroll functionalities. This information enabled the client to cease creating custom excel reports and cease manual corrections to various 401k Payroll processes.

Confidential

Responsibilities:

  • Served as PeopleSoft Payroll Consultant and provided assistance for Production Support Issues and Business Requirement and Change Management requests.
  • Engagement included development and execution of project plan performing system analysis for design of custom functionality creation and execution of test scripts for user acceptance designed and delivered user reference guide for Payroll Business Processes development of custom queries and reports and post-implementation evaluation and support.
  • Responsibilities included monitoring work performed by subordinates in the Payroll Department and processing payroll transactions as assigned by payroll supervisor and analyst.
  • Reviewed and approved payroll transactions processed by assigned colleagues, handling most complex issues and gathering information and presenting to higher level of authority for decision making, and researched and resolved problems dealing with employee relations, benefits and compensation.
  • Developed and managed clients Business Requirement for PeopleSoft Tax Updates 07-A, 07-B and 07-C . Developed test plan and test scripts for all Tax Updates.
  • Responsible for resolving clients issues with State Locality Codes and Tax Distribution codes.
  • Assisted with the data cleanup for clients Tax Balances conversion process to assure balances from legacy system are converted accurately into Peoplesoft.
  • Worked with the Payroll Team to strategically design efforts to define and implement an interdepartmental work group for Human Resources and Payroll including identification of roles and responsibilities, definition of jobs and qualifications, design of workspace and business requirements, and training of service center division.
  • Provided client with an analysis of business and payroll processes that weren't being leveraged properly in the system. Based on recommendations to make changes to end-users access to the system and re-structure payroll processes, the client successfully decreased manual processes by 50 .

Confidential

Responsibilities:

  • Provided PeopleSoft HCM support for client's Interface Design Specifications.
  • Managed clients Benefits and 401 k Interfaces to include analyzing, modification and UAT testing.
  • Made recommendations to leverage interface design and changes to better meet the client's business needs.
  • Developed and executed UAT test plans and test scripts for interface required changes.
  • Provided Production Support for 3rd Party 401 k Administration. Responsibilities included acting as Liaison between the client and the Vendor.
  • Assisted with employee's account information and corrected system issues and errors.
  • Analyzed employee data and made recommendations to correct inaccuracies in vendor's database.
  • Assisted Application Support Personnel with Open Ticket Requests for system enhancement, changes and issues.
  • Responsible for troubleshooting data and system error messages and provided resolution.
  • Served as Project Manager for client's new Roth 401k After-Tax Plan Implementation.
  • Developed Project Plan, created benefit plan configuration outline and table definition scripts.
  • Created test cases and scenarios for new 401K plan enrollments.
  • Processed Payroll and Time Labor processes for participants to be enrolled in new 401k plan.
  • Created Business Process Documentation on new Plan to be utilized by End Users for administrative purposes for enrolling new participants.

Confidential

Responsibilities:

  • Provided leadership for the implementation of PeopleSoft Benefit Administration, Human Resources, and North American Payroll version 8.8.
  • Responsibilities included development and management of project plan table setup and configuration of Base Benefit, Ben Admin and Payroll system tables.
  • Managed Clients first Open Enrollment and provided User Training on Administration for Open Enrollment and Event Maintenance.
  • Developed and executed UAT system test plan and test scripts.
  • Reviewed business policies and process to enhance end-user usage of the system and recommended best practice polices to maintain the quality and data integrity of the system applications.

Confidential

Responsibilities:

  • PeopleSoft HCM Consultant supported clients first Implementation for North American Payroll, Base Benefits and Time Labor version 8.8.
  • Assisted Implementation Team with development of Conceptual Solutions Document, which outlines detailed information for SDLC implementation.
  • Completed Fit/Gap Analysis for Business Process areas for Base Benefit, North American Payroll and Time Labor.
  • Developed and executed User Reference Training Guides for NA Payroll, Base Benefits and Time Labor.
  • Developed system test plan and test scripts for system Integration, Unit and User Acceptance testing.
  • Managed complete Security Administration for client to insure all User Roles and Permission Lists where setup accurately and efficiently.
  • Provided User Training and Knowledge Transfer sessions for Divisional Managers and Supervisors.
  • Assisted client with Post Implementation support to finalize business requirements and processes to be utilized by the functional and technical users.

Confidential

Responsibilities:

  • PeopleSoft HCM Lead Analyst for PeopleSoft 8.0 upgrade for HR, Benefits and Payroll Applications.
  • Responsible for providing foundation table definition and managed system setup tables for HR, Base Benefits, Benefit Administration, Payroll Interface, Recruitment, Event Maintenance and Open Enrollment.
  • Processed Payroll Interface for weekly and monthly pay groups.
  • Responsible for end-user skill development, training and documentation of business processes and provide subject matter expertise in all areas of the HRIS system.
  • Designed and developed ad-hoc reports from query and crystal.
  • Responsible for on-going System Maintenance and Production/Upgrade testing and developed system test plan and test scripts.
  • Managed and designed the development of reports to capture current trends, historical data for comparison analysis for all areas of the business.
  • Troubleshot and analysed system application daily for data integrity and consistency.
  • Managed system Security Object Administration and approve access and track user access to ensure integrity.
  • Maintained system tables and parameters associated with the HR database and application.
  • Created and managed Change Management Requests Form for end-users requesting system and programming changes.

Confidential

Responsibilities:

  • PeopleSoft HCM Consultant for PeopleSoft 8.15 Benefit Administration application and responsible for maintaining event maintenance and open enrollment processes.
  • Managed processes that included generating enrollment forms, confirmation forms, troubleshooting and resolving system errors and edits.
  • Maintained and updated Benefit Administration tables and conduct audits for system integrity.
  • Administered Health and Welfare eligibility changes for New Hires, Family Status, and COBRA events.
  • Handled Benefit Billing for Retirees, Surviving Spouses and Severed employees.
  • Conducted Benefit Orientation for new hires and rehires.
  • Responsible for Short term/Long term disability processing and follow through.
  • Acted as the liaison between the HRIS system and end users including HR and Payroll to resolve benefit/payroll problems.
  • Developed and distributed ad-hoc query reports.

Responsibilities:

  • Responsible for providing definition and managing setup of HR, Base Benefits, Benefit Administration Payroll Interface, Manage Human Resources, Recruitment, Event Maintenance and Open Enrollment tables.
  • Processed Payroll Interface to ADP, 2.5 for eight weekly and monthly pay groups.
  • Responsible for end-user skill development, training and documentation of business processes and provided subject matter expertise in all areas of the HRIS system.
  • Designed and developed ad-hoc reports from query and crystal.
  • Responsible for on-going System Maintenance and Production/Upgrade testing and developed system test scripts.
  • Managed and designed the development of reports to capture current trends, historical data for comparison analysis for all areas of the business.
  • Troubleshot and analyzed system application daily for data integrity and consistency.
  • Managed system Security Object Administration and approved access and track user access to ensure integrity.
  • Maintained system tables and parameters associated with the HR database and application.
  • Created and managed Change Management Requests Form for end-users requesting system and programming changes.

Confidential

Benefits/HR Administrator

Responsibilities:

  • Administered Health Welfare Benefit Plans to include Medical, Dental, COBRA, FMLA, ERISA, ADA, Life Insurance, STD and LTD.
  • Reviewed and audited monthly premium statements for integrity and approval.
  • Communicated benefit laws, compliance issues and regulations to employees, clients and managers.
  • Administered Pension Benefit Plans for active and terminated vastest employees.
  • Processed pension benefit calculations and statements.
  • Prepared Summary Annual Reports and Summary Plan Descriptions for Benefit and Pension Plans.
  • Managed 401 k Plan to include enrollments, changes, loans and distributions.
  • Officiated Open Enrollment meetings for 401 k and Health and Welfare plans.
  • Coordinated activities for Annual Open Enrollment Health Fair.
  • Prepared benefit plan financial and budget reports.

Confidential

Responsibilities:

  • Managed a support staff of three.
  • Executive Assistant to Director and Asst.
  • Director of Human Resources.
  • Recruiter for Administrative positions interviewed and hired non-exempt employees.
  • Administered new hire orientation.
  • Administered HR policies, practices and procedures to include employment law, benefits administration, worker's compensation, labor relations union negotiation.
  • Organized and spearheaded summer internship job fairs.
  • Prepared EEO-1 and government reports.

We'd love your feedback!