W2 Role || Technical Business Analyst (Oracle SQL/PLSQL & Legacy System Migration)
Position: Technical Business Analyst (Oracle SQL/PLSQL & Legacy System Migration)
Location: Jackson, MS-Onsite
Description
Ideal candidate profile:
- 7–10 years of overall IT experience.
- At least 5 years of Business Analyst experience.
- Strong Oracle SQL and PL/SQL expertise.
- Experience with application modernization or legacy system migration.
- Strong documentation, Excel and data validation skills.
- Experience coordinating with technical teams and external vendors.
Three aspects are particularly important when identifying suitable candidates:
Strong SQL/PLSQL background: Candidates should be comfortable reading and understanding existing Oracle code, stored procedures and database logic. Merely having experience gathering business requirements may not be sufficient.
Legacy application migration experience: Experience in documenting existing functionality and translating it into requirements for a modern cloud-based application will be a significant advantage.
On-site availability: The Mississippi residency requirement and two-year on-site commitment
Key responsibilities: The selected Business Analysts will be responsible for:
- Reviewing existing application architecture, data models and workflows.
- Analyzing legacy application functionality and documenting business rules.
- Reviewing Oracle SQL and PL/SQL code, including procedures, functions, triggers and packages.
- Reviewing Crystal Reports and documenting report calculations and data sources.
- Documenting core application modules, including:
- Offender records.
- Sentence computation.
- Classification.
- Programs and alerts.
- Movement and disciplinary.
- Grievances.
- Community Corrections accounting and supervision.
- Validating source-to-target data mapping.
- Preparing functional requirements, user stories and acceptance criteria.
- Supporting System Integration Testing (SIT) and User Acceptance Testing (UAT).Identifying defects and validating migrated functionality against the legacy system.4.
Required skills and experience:
- This is a technically strong Business Analyst position, rather than a conventional functional BA role.
- Skill Experience / Requirement Years of Experience
- Business Analyst experience5+ yearsSQL knowledge
- Working knowledge
- Microsoft ExcelStrong skills, PivotTables, Pivot ChartsSQL/PLSQL programming and code review7+ years
- Oracle PL/SQL5+ years
- Advanced SQL5+ yearsAWS database and reporting services
- ExperiencePower BI / AWS QuickSightFamiliarityOffender Management / Justice systems
- ExperienceLegacy DHTML applications
- FamiliarityVendor-led modernization projects
Experience