Business Analyst/Tester (ERP/ HCM)

Job description

Job Description:

This position is for a Business Analyst/Tester role that requires meticulous data validation experience and skills to join our project team, with a specific focus on supporting the rigorous testing of our new payroll system.

This is a unique opportunity to play a crucial role in safeguarding payroll data and ensuring a seamless transition.

Key Responsibilities:

Collaborate with the Project Manager and business stakeholders to understand payroll

system requirements and design testing strategies for the new release.

· Conduct data validation to ensure accuracy and integrity of payroll data throughout the system.

· Provide regular status updates and progress reports on testing activities for the Project Manager and relevant stakeholders.

· Support the development of training materials and user documentation related to the new payroll system functionalities.

· Participate in post-implementation review and provide recommendations for continuous improvement

· Understand and analyze business processes and requirements related to financial management, accounting, procurement, and other finance-related functions.

· Understand PeopleSoft and oracle Fusion Financials modules to align with business requirements, such as payroll operations, general ledger, accounts payable, accounts receivable, asset management, cash management, and other finance-related configurations.

· Analyze processes and workflows to identify opportunities for improvement through software support.

· Document requirements in user stories/use cases and epics.

· Document test requirements in test cases.

· Analyze and document system interfaces, database structures, and data flows.

· Coordinate and lead analytic activities with stakeholders.

· Use software tools as required to document requirements, analyze needs, identify risk, propose designs, and write documentation

· Conduct peer reviews.

Qualifications:

· Data Analysis & Reconciliation:

o Conduct in-depth analysis of legacy payroll data to understand structures, transformations, and potential discrepancies for migration to the Oracle Fusion Cloud.

o Develop and execute complex SQL queries against source and target databases (Oracle

· Fusion and legacy systems) to extract, compare, and validate payroll data.

o Perform comprehensive reconciliation of payroll data elements, including employee demographics, pay rates, deductions, benefits, taxes, gross-to-net calculations, and accruals.

o Identify and document data anomalies, inconsistencies, and errors, flagging them for investigation and resolution by development and data migration teams.

· Test Data Management:

o Assist in the creation and preparation of accurate and representative test data sets for various payroll testing scenarios.

· Ensure test data adequately covers edge cases, complex scenarios (e.g., retro-pay, multiple garnishments, union rules), and high-volume transactions.

o Maintain the integrity and confidentiality of sensitive payroll test data.

· Validation of Payroll Calculations:

o Independently validate complex payroll calculations (gross pay, tax withholding, deductions, net pay) within the new Oracle Fusion system against expected results.

o Develop validation rules and metrics to verify the accuracy of automated payroll processes.

o Work with payroll subject matter experts to understand and validate specific business rules related to client's unique payroll requirements (e.g., specific union contracts, shift differentials).

· Reporting & Documentation:

o Document detailed data validation plans, methodologies, and findings.

o Generate clear and concise reports on data quality issues, reconciliation results, and validation progress.

o Track and manage data-related defects within the project's defect tracking system (e.g., JIRA, Azure DevOps).

o Provide regular updates to the MetroSync Project Manager and testing lead on data validation status and critical findings.

· Collaboration:

o Collaborate closely with data migration teams to ensure data transformation rules are correctly applied and validated.

o Partner with functional testers and business analysts to align data validation efforts with overall testing strategies.

o Communicate effectively with payroll business users to clarify data requirements and validate specific scenarios.

· Demonstrable experience with Enterprise Resource Planning (ERP) systems, particularly Oracle

· Fusion Cloud applications (HCM, Financials, Procurement) are required, given MetroSync is powered by Oracle Fusion.

· Experience in IT project management and business analysis roles, with a strong emphasis on system implementation and testing.

· Extensive experience with payroll systems and operations is a mandatory requirement.

· Candidates must understand payroll processes, tax implications, union rules, timekeeping, and associated integrations.

Experience with specific payroll context (e.g., PeopleSoft, Kronos history) is a significant plus.

· Strong background in data validation.

· Experience in the public sector or large government organizations is highly desirable, demonstrating an understanding of complex stakeholder environments and regulatory requirements.

· Skill in process analysis methods and techniques.

· Experience in analyzing processes and identifying opportunities for improvements through software support.

· Experience establishing successful relationships with business stakeholders.

· Experience in analyzing data structures and data flows.

· Experience documenting test cases.

· Experience as a Scrum Master/Product Owner in an Agile software development environment.

· Excellent communication skills, both oral and written; and

· Proficiency with JIRA, Confluence, MS Excel, Word, Visio, or a similar tool, and PowerPoint.

· Experience in working with third-party systems.

· Experience in cloud-based PeopleSoft deployments.

Preferred Requirements:

· Master's degree in computer science or a related field.

· PeopleSoft certified

Required Skill Profession

Other General