Technical Business Analyst – Application Modernization (Oracle SQL/PLSQL)
Title: Technical Business Analyst – Application Modernization (Oracle SQL/PLSQL)
Location: Jackson, MS(Onsite)
Duration: 24+ MonthsJob Summary
We are seeking experienced and detail-oriented Technical Business Analyst to support a major legacy application modernization initiative. The successful candidates will play a key role in migrating an existing Offender Management System to a modern, cloud-based platform. This role requires strong business analysis skills combined with the ability to understand legacy application functionality, review SQL/PLSQL code, analyze business rules, and translate complex workflows into clear functional requirements. The analysts will work closely with business stakeholders, technical teams, and a third-party vendor to ensure that existing system functionality, business processes, and reporting requirements are accurately understood, documented, and represented in the new platform.
Key Responsibilities:
Analyze existing application architecture, data models, workflows, and system dependencies.
Review legacy application functionality to identify and document underlying business rules and processes.
Review Oracle SQL/PLSQL code, including packages, procedures, functions, triggers, and views, to understand existing application logic.
Identify gaps, inconsistencies, dependencies, and opportunities for improvement in existing business processes and application functionality.
Review existing business requirements, policies, Standard Operating Procedures (SOPs), user stories, and technical documentation.
Analyze existing Crystal Reports and document report logic, calculations, data sources, and business rules to support migration to a modern AWS-compatible reporting platform.
Document core application functionality, including offender records, classification, sentence computation, offender programs, alerts, movement, disciplinary actions, grievances, and community corrections accounting and supervision.
Collaborate with technical teams to validate source-to-target data mappings and ensure data accuracy and completeness.
Translate business processes and existing system functionality into functional requirements, user stories, acceptance criteria, and process documentation.
Ensure critical business rules and functionality 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 identify, document, and track defects through resolution.
Participate in requirements walkthroughs, design reviews, and application modernization discussions.
Collaborate with internal stakeholders and third-party vendor teams to support successful project delivery.
Required Qualifications:
Bachelor's degree in Information Technology, Computer Science, Business Information Systems, or a related field, or equivalent experience.
Proven experience as a Business Analyst, Technical Business Analyst, Business Systems Analyst, or Systems Analyst.
Experience gathering, analyzing, validating, and documenting complex business and technical requirements.
Strong ability to analyze legacy applications, workflows, business rules, and system functionality.
Working knowledge of SQL, including queries, joins, data relationships, and database structures.
Ability to read and understand Oracle PL/SQL code and stored procedure logic.
Experience supporting UAT and/or SIT, including test case validation, defect identification, and functional testing.
Strong Microsoft Excel skills, including PivotTables, Pivot Charts, data analysis, and data validation.
Excellent analytical, problem-solving, documentation, and communication skills.
Ability to collaborate effectively with business users, technical teams, and external vendors.
Preferred Qualifications:
Experience working with Oracle databases and PL/SQL, including procedures, functions, triggers, packages, and views.
Experience with Crystal Reports, including reviewing report logic, calculations, and data sources.
Experience supporting legacy application modernization, system migration, or cloud transformation projects.
Familiarity with AWS database and reporting services.
Experience with business intelligence and reporting tools such as Microsoft Power BI or AWS QuickSight.
Experience with Offender Management Systems, correctional systems, or enterprise justice applications.
Familiarity with legacy web technologies, including DHTML-based applications.
Experience working with third-party vendors on enterprise application modernization initiatives.