HBITS-08-15024-Systems Analyst-Expert

Responsibilities

• Requirements Gathering & Stakeholder Communication: Collaborate with Department of Public Service (DPS) program staff, business stakeholders, and external entities to gather, analyze, and document business requirements for key initiatives (including Assessment Management, Pipeline Audit, and 753 Enforcement). Lead business process reengineering sessions and deliver presentations on "As-Is" and "To-Be" system states.
• Technical Analysis & System Modeling: Perform end-to-end technical analysis and design for complex enterprise systems. Author highly detailed technical specifications, system architecture maps, and advanced system models including Unified Modeling Language (UML) diagrams, Data Flow Diagrams (DFDs), and Entity-Relationship Diagrams (ERDs).
• Legacy Database Reverse-Engineering & Normalization: Reverse engineer legacy MS Access databases by analyzing tables, relationships, queries, forms, macros, and VBA modules. Identify data integrity issues and design normalized (up to 3NF) relational database schemas for target platforms like SQL Server and Oracle.