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