DWC Modernization Technical SME Support

Name DWC Modernization Technical SME Support DOLIR--- Agency, State Department of Labor & Industrial Relations (DOLIR), MO Location Jefferson City, MO Contract Duration // - // Release Date // Q & A due Date // by : PM CT Budget Pursuant to paragraph ( b. ) of the contract, all SOWs with a total firm, fixed price for all deliverables that is over $, shall include a % holdback per deliverable, unless otherwise identified in the SOW. This holdback must be reflected in your SOW response's firm, fixed pricing, if applicable (SOW total price over $,). In order to address the holdback on any SOW bid over $,, your payment milestones should reflect % of the cost for each milestone and shall include the final payment milestone that represents % of the total price of your SOW bid.' Bid due Date // at : CT SOW The Missouri DOLIR Division of Workers' Compensation (DWC) is modernizing its legacy Workers' Compensation systems (AICS on AS/) into a new "Work Comp Connect” solution. To support this -month effort (// – //), DWC requires a Technical Subject Matter Expert (SME) with extensive AS//E/SQL expertise. The SME will function as the DWC's technical authority for all data-and-code aspects of legacy system analysis, back-bridging, migration, and integration. General Requirements: Services Only: All services and personnel must be provided in the United States; offshore resources are not permitted. Flexible Resource Replacement: Vendor may exchange assigned resource(s) upon State approval of replacement resumes. Security & Confidentiality: All deliverables, tools, code, and data are confidential. Vendor resource(s) must comply with DOLIR/ITSD security policies, mandatory trainings, and required development/test procedures. Vendor Minimum Experience Requirements: Overall Firm Experience (&Client; years): • Workers' Compensation data and processes • AS/ system development and/or support • E software development and/or support – Experience with Missouri's Workers' Compensation system is preferred. Vendor Resource(s) Experience Requirements: The SME resource must meet all of the following (each &Client; years): AS/ systems (RPG/CL) and E development Writing and executing SQL queries Analysis of Workers' Compensation data structures (Missouri experience preferred) Ability to collaborate with technical and business stakeholders and attend project meetings. Performance Requirements (Technical Responsibilities): Legacy System Support & Analysis: • Provide ongoing technical assistance for existing DOLIR AS/ environments (RPG via E, IBM CL, AS/ GUI Presto, SQL/IBM Query). • Analyze the legacy AICS AS/ data structures to inform modernized design. • Write efficient SQL queries and E code as needed to extract, transform, and load data. Back-Bridging & Data Integration: • Manage test environments to facilitate data back-bridging between Work Comp Connect (WCC) and the legacy AS/ solution. • Execute AS/ data extracts into a staging area; schedule extracts at predetermined intervals. • Develop scripts to automate data transfers between WCC and legacy systems, ensuring data integrity and exception handling. • Analyze data relationships to support ongoing integration between systems. Deliverable Production: • Produce monthly status reports consolidating weekly activities, task summaries, stakeholders, and outstanding issues. • Use the ITSD Project Deliverable Acceptance Form (PDAF) for formal acceptance of each monthly status report. Testing & Validation: • Oversee ETL and data migration testing, including incremental and full loads between legacy and modernized schemas. • Create data validation and exception reporting processes to ensure high-fidelity migration. • Document transformation logic and maintain a data dictionary. Technical Collaboration: • Partner with the DWC Modernization Project Director and ITSD Project Manager to review design, identify technical risks, and align on security/compliance (FERPA, HIPAA, PII/PHI safeguards). • Mentor and guide ITSD staff and junior data engineers on AS/ and modern database best practices. Compliance & Security: • All work must adhere to State security policies: use ITSD-provided VDI/remote desktops, maintain Active Directory credentials, and develop on approved infrastructure. • Guarantee all data and applications reside within boundaries. • Enable nightly incremental data extracts to feed the State Data Warehouse; support final end-of-contract extraction (-day window). Deliverables: Monthly Status Reports ( total): • Format: Consolidate weekly status updates (per ITSD Status Report template). • Approval: ITSD Project Manager and DOLIR/DWC management via PDAF. Data Architecture Artifacts: • Logical and physical data models for legacy AICS (AS/) and new Work Comp Connect schemas. • Data dictionaries, ER diagrams, and ETL transformation logic. ETL & Migration Scripts: • Well-tested SQL/ETL code, QA filters, and exception handling logic supporting data back-bridging. Master Data Governance Documentation: • Definitions, data steward guidelines, and remediation procedures for key entities. Performance Baseline Reports: • Database benchmark metrics (, query times, indexing strategies) with infrastructure recommendations. Final Data Extract Package: • Complete, validated end-of-contract data export for archival and hand-off within days post-//. Reporting Requirements: Weekly Status Reports: Use ITSD Status Report template; include task name, summary of work, requesting stakeholder, status, and items needing management attention. PDAF Process: Each monthly deliverable must be presented via PDAF for formal review/approval. Technical Environment Requirements: • Use State-owned Microsoft ADO or JIRA to track issues, bugs, and defects. • Vendor must procure and maintain all required development licenses (, Visio, DataIO) for AS/, E, SQL development. • ITSD will provide a VDI with project-specific software. Submittal Requirement Completed SOW Response Document (separate file ): Fill in all Vendor sections of this SOW. Vendor Signature Section: Authorized signature on the SOW. Deliverable Payment Milestone Table: Firm-fixed price per each Monthly Status Report ( lines), % holdback column, and invoiceable amount column. Contracting Resource(s) Price Calculations Table: Hourly rates × estimated hours (for internal cost validation; payment remains deliverable-based). Proposal Narrative (as concise as possible): Exhibit A – Approach & Methodology (≤ pages): Detailed plan addressing all tasks in Section (data migration, modeling, back-bridging, governance, testing). Describe tools, processes, and timelines. Exhibit B – Personnel Qualifications & Biographies: Resume for each proposed resource (SME). Must show &Client; years' AS/, E, and SQL experience; Missouri DWC or similar Workers' Compensation background preferred. Exhibit C – Relevant Company History & Experience: Three () case studies illustrating: AS/ → modernization (, legacy mainframe or iSeries to relational/columnar DB). Master data management and governance implementations. Complex ETL/SQL work and performance optimization on cloud platforms (preferably AWS). Exhibit D – Participation Commitment: MBE/WBE/SDVBE documentation or "None” if not applicable. Work Breakdown Structure (WBS): Gantt chart or equivalent showing tasks, milestones, dependencies, and timelines aligned with Section deliverables. Testing & Validation Plan: Describe processes for nightly incremental extracts, data validation, and final extraction QA (tools, frequency, stakeholders). Security & Compliance Approach: Outline how the SME will implement FERPA, HIPAA, PII/PHI safeguards, and use State-provided environments. Resumes for Proposed Resource(s): Provide one () resume for the Senior Technical SME (full-time allocation). Must demonstrate: • &Client; years' AS/ (RPG/CL/E) experience • &Client; years' SQL scripting and relational database design experience • Experience with Missouri DWC AICS or similar legacy Workers' Compensation systems • Demonstrated ability to mentor and communicate with technical/business teams. Licensing Confirmation: Evidence that Vendor will procure and maintain any required development tools and database licenses (, Visio, DataIO, AWS tools) for the SME. Submission Format & Requirements: Electronic Submission Only: Single PDF (signed SOW response, deliverable/payment milestones, resource price calculations, proposal narrative, WBS, exhibits, resumes) emailed to by // : PM CT. Page Limits & Formatting: • Narrative for Exhibit A limited to pages (exhibits B–D and WBS do not count toward this limit). • pt (or larger) font for body text; smaller fonts permitted in graphics/diagrams. • No embedded files, hyperlinks, or video clips; non-compliant content may be excluded from evaluation. Completeness: Vendors must provide all information requested; omissions may result in adverse evaluation. Confidential Materials: Any portion of the response claimed as proprietary or confidential must be clearly identified and justified under Missouri Revised Statutes §§ –.. Evaluation Criteria Cost – points Approach and Methodology for Scope of Work – points Personnel Qualifications and Biographies – points Company History and Experience – points Potential bonus points if Exhibit D is completed: MBE/WBE Participation – points Organization for the Blind/Sheltered Workshop Preference – points MO Service-Disabled Veteran Business Preference – points Total – points References three () company case studies under Exhibit C rather than client references. Resumes required? Yes – Resume for each proposed resource (SME). Rate card required No traditional rate card. Pricing must be firm-fixed per deliverable (Monthly Status Reports). Vendor must submit a "Contracting Resource(s) Price Calculations” table showing hourly rates × estimated hours purely for internal validation; State payment is milestone-based. Any specific requirement All resources must be for the entire contract term. Vendor must maintain confidentiality of all State Data per contract and applicable law (PII/PHI safeguards). SME must have &Client; years' experience in AS/, E, and SQL, with preference for Missouri Workers' Compensation system knowledge. Vendor must procure and maintain all necessary development tools/licenses (, Visio, DataIO, AWS tools) for SME. All work must occur on State-provided VDI/remote desktops and comply with DOLIR/ITSD security policies. No out-of-state travel required for State staff; any on-site presence should be limited to Jefferson City, MO. Hardcopy/Email/portal submission Email Link Via Email