Programmer Analyst - Sentence Computation - MS - MSDOC

Job Title : Programmer Analyst Summary

We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL / Oracle programming, and cloud-based modernization initiatives. The ideal candidate will review, refactor, and migrate legacy application logic including PL / SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture. This role involves understanding existing business logic, documenting current workflows, and collaborating with both internal teams and a third- party vendor. They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system.

Key Responsibilities

• Review and document existing application architecture, data models, workflows, and stored procedures.
• Rewrite and optimize Oracle PL / SQL packages, functions, triggers, and views for migration to a cloud environment.
• Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS.
• Extract, map, validate, and transform data to support ETL and database conversion activities.
• Analyze, document, and refactor core logic modules such as sentence computation.
• Convert legacy DHTML-based UI forms to modern formats as part of system redesign.
• Understand and document scheduled jobs and backend automation processes.
• Collaborate with a third-party vendor to clarify requirements and support modernization efforts.

Required Technical Skills

Preferred Qualifications

Skill

Required / Desired

Skill Level / Amount of Experience

Candidate Experience

Notes

SQL / ORACLE Programmer

Required

SME (7+ years)

Able to write and review SQL and PL / SQL code

Business Analyst

Required

Advanced (5-7 years)

Able to review SQL / PLSQL code, business rules, and MS Code for sentencing rules

ORACLE

Required

Advanced (5-7 years)

SQL

Preferred

Advanced (5-7 years)