Back to Jobs
Recently postedOperations & Project Management

Business Analyst

Universal Consulting Partners Inc.Leakesville, MS🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationLeakesville, MS, United States
Microsoft ExcelData Analysis

Job description

Business Analyst

The Business Analyst will play a crucial role in supporting the migration of the legacy Offender Management System to a new cloud-based platform. This role involves reviewing existing business rules, policies, standard operating procedures, reports, user stories, and Oracle SQL / PL/SQL code to ensure current functionality and business logic are accurately carried over. The analyst will work closely with internal stakeholders and a third-party vendor on core modules such as records, classification, and sentence computation.

Responsibilities

  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Analyze legacy functionality to identify underlying business rules and dependencies.
  • Review Oracle PL/SQL packages, procedures, functions, triggers, and views to support cloud migration.
  • Identify gaps, inconsistencies, and improvement opportunities in existing processes.
  • Review Crystal Reports and document report logic, calculations, and data sources for migration to an AWS-compatible reporting platform.
  • Analyze and document core modules: sentence computation, offender records, programs, alerts, movement, classification, disciplinary, grievances, and Community Corrections accounting and supervision.
  • Work with technical teams to validate source-to-target data mappings for accuracy and completeness.
  • Translate legacy functionality into functional requirements, user stories, acceptance criteria, and process documentation.
  • Confirm critical business rules are accurately represented in the redesigned application.
  • Support SIT and UAT; validate migrated functionality against legacy system and document defects.
  • Participate in requirements walkthroughs, design reviews, and modernization discussions.

Requirements

<>Required Skills:
  • Detailed analysis and documentation translating legacy business rules to a new cloud-based system.
  • Business Analyst experience reviewing code, business rules, end-user requirements, user stories, workflows, reports, SQL code, and documentation — 5+ years.
  • Working knowledge of SQL (queries, joins, data relationships, stored procedure logic).
  • Strong Microsoft Excel skills (PivotTables, Pivot Charts, data analysis, data validation).
<>Preferred Skills:
  • Programming: able to write and review SQL and PL/SQL code — 7+ years.
  • Oracle PL/SQL (procedures, functions, triggers, packages, views) — 5+ years.
  • Advanced SQL — 5+ years.
  • Experience with AWS database and reporting services.
  • Familiarity with BI / reporting platforms such as Microsoft Power BI or AWS QuickSight.
  • Experience with Offender Management or enterprise justice systems.
  • Familiarity with legacy web technologies, including DHTML-based applications.
  • Experience working with external vendor teams on modernization projects.

Similar jobs