What are the responsibilities and job description for the Technical Business Analyst – Application Modernization (Oracle SQL/PLSQL) position at Amtex Systems Inc?
Title: Technical Business Analyst – Application Modernization (Oracle SQL/PLSQL)
Location: Jackson, MS(Onsite)
Duration: 24 Months
Job 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.