Programmer Analyst (Local to MI)

American business solutions inc

Lansing (MI)

On-site

USD 60,000 - 100,000

Full time

24 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

American business solutions inc in Jackson, SC is seeking a Business Analyst (Local to MS) to review and document the existing application architecture, data models, workflows, and stored procedures, and to support migration to the cloud environment.

You will translate legacy system functionality into clear requirements, collaborate with technical teams on data mappings, and assist in SIT/UAT to ensure accurate representation of business rules in the modern solution.

Qualifications

  • Translate and document business rules from legacy system to new cloud-based system.
  • Review technical docs, business rules, workflows, reports, and SQL code.
  • Read and understand SQL queries, joins, data relationships and stored procedure logic.
  • Strong Excel skills with PivotTables, Pivot Charts, data analysis and validation.

Responsibilities

  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Analyze legacy functionality and identify business rules and dependencies.
  • Review Oracle PL/SQL to understand logic for cloud migration.
  • Identify gaps and improvements in business processes and app functionality.
  • Document report logic and data sources for migration to a modern reporting platform (AWS).
  • Analyze core logic modules (e.g., sentence computation, offender records, alerts, classifications).
  • Validate source-to-target data mappings for accuracy and completeness.
  • Translate system functionality into functional requirements, user stories, acceptance criteria, and process docs.
  • Ensure legacy critical rules are represented in the redesigned app.
  • Support SIT and UAT and validate migrated functionality vs legacy.
  • Participate in requirements walkthroughs and design reviews.

Skills

SQL
Excel
Requirements Documentation
Data Analysis

Tools

AWS
Power BI
Oracle PL/SQL

Job description

Business Analyst (Local to MS)

Job Id : A 8453

Posted Date : 11/18/2026

Experience : -

Job Type : Contractual

Location : Jackson, SC

Overview :

Key Responsibilities
  • Review and document existing application architecture, data models, workflows, and stored procedures.
  • Analyze legacy application functionality and identify the underlying business rules and dependencies.
  • Review Oracle PL/SQL packages, procedures, functions, triggers, and views to understand existing application logic and support migration to the cloud environment.
  • Identify gaps, inconsistencies, and potential improvements in existing business processes and application functionality.
  • Review existing Crystal Reports and document report logic, calculations, data sources, and business rules to support migration to a modern reporting platform compatible with AWS.
  • Analyze and document core logic modules such as sentence computation, offender records, offender programs, alerts, movement, classification, offender disciplinary, offender grievances, Community Corrections accounting and supervision.
  • Work with technical teams to validate source-to-target data mappings and ensure data accuracy and completeness.
  • Translate existing system functionality into clear functional requirements, user stories, acceptance criteria, and process documentation.
  • Ensure that critical business rules and functionality from the legacy system are accurately represented in the redesigned application.
  • Support System Integration Testing (SIT) and User Acceptance Testing (UAT).
  • Validate migrated functionality against the legacy system and assist in identifying and documenting defects.
  • Participate in requirements walkthroughs, design reviews, and modernization discussions.
Required Technical Skills
  • Experience in performing detailed analysis and preparing documentation that translates and supports business rules from the legacy system to the new cloud-based system.
  • Experience reviewing technical documentation, business rules, workflows, reports, and SQL code.
  • Working knowledge of SQL, with the ability to read and understand queries, joins, data relationships, and stored procedure logic.
  • Strong Microsoft Excel skills, including PivotTables, Pivot Charts, data analysis, and data validation.
Preferred Qualifications
  • Experience with AWS database and reporting services.
  • Familiarity with business intelligence and reporting platforms such as Microsoft Power BI or AWS QuickSight.
  • Knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
  • 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Business Analyst
Sr. Business Analyst

American business solutions inc • Harrisburg

On-site
USD 55,000 - 96,000
Business Analyst
Business Analyst

Lancesoft • Jackson (MS)

On-site
USD 76,000 - 90,000
Business Analyst (OnSite Jackson, MS)
Business Analyst (OnSite Jackson, MS)

Da Vinci Software, LLC. • Jackson (MS)

On-site
USD 65,000 - 90,000
Business Analyst - Legacy Application Modernization - Need Locals to MS
Business Analyst - Legacy Application Modernization - Need Locals to MS

Brilliant Infotech Inc. • Jackson (MS)

On-site
USD 70,000 - 95,000
Business Analyst
Business Analyst

COGENT DATA SOLUTIONS LLC • Mississippi

On-site
USD 85,000 - 105,000
Senior Business Analyst
Senior Business Analyst

Accord Technologies Inc • Jackson (MS)

On-site
USD 80,000 - 100,000
Technical Business Analyst - 26-01358
Technical Business Analyst - 26-01358

Datasoft Technologies, Inc. • Jackson (MS)

On-site
USD 65,000 - 95,000
Business Data Analyst
Business Data Analyst

Resolve Tech Solutions • Jackson (MS)

On-site
USD 60,000 - 80,000
Business Analyst
Business Analyst

VIVA • Jackson (MS)

On-site
USD 70,000 - 90,000
Business Analyst
Business Analyst

Ethereum Technologies • Jackson (MS)

On-site
USD 70,000 - 110,000