Job ID: WA-2424-852
Hybrid/Local Acuity s Sage MAS 500 Developer with VB/Visual Basic, TFS, Azure DevOps, ACH, Workday, FDM, ASP.Net, C , VB.Net, SSRS, SSIS, Windows/Linux/macOS and accounting experience
Location: Olympia WA (DSHS)
Duration: 24 Months
4. Bidder Minimum Qualifications
1. Must have at least 10 years of experience in the development and maintenance of
enterprise financial systems.
2. Must have at least 8 years of experience with Visual Basic 6, Microsoft SQL Server
(2000, 2008, 2016),Team Foundation Server (TFS), and Azure DevOps.
3. Must have at least 8 years of experience with database design and development.
4. Must have at least 5 years of experience with the Acuity s Sage MAS 500 system, a
commercial off-the-shelf (COTS) accounts receivable system.
5. Must have at least 5 years of experience with accounting, payment, interest, cash
processing and invoicing processes within the government of Washington State
including experience with the Office of Financial Management (OFM) s Agency
Financial Reporting System (AFRS).
6. Must have at least 2 years of experience with electronic payments, specifically using
bank account debits with Automated Clearing House (ACH).
7. Must have deep knowledge and understanding of the new Workday s Enterprise
Resource Planning (ERP) Foundation Data Model (FDM) and be adept at cross referencing this data with the legacy Chart of Account (COA) format.
Bidders failing to demonstrate in their Bids that they meet these minimum qualifications
will be considered non responsive and will therefore be disqualified from further
consideration.
HIGHLY DESIRED EXPERIENCE AND QUALIFICATIONS
1. Working knowledge and experience with Microsoft ASP.Net, C , and VB.Net
development.
2. Working knowledge and experience with SQL Server Reporting Services (SSRS).
3. Working knowledge and experience with SQL Server Integration Services (SSIS).
4. Working knowledge and experience with DSHS specific business processes related
to collection, accounting, payment, cash processing, interest, and invoicing.
3. Project Scope
The procured Contractor shall be involved in the DSHS readiness for the OneWA
project, focusing on a comprehensive alignment of key financial and administrative
systems with the OneWA s Workday Financial Data Model (FDM) framework. This
the endeavor encompasses the Collections and Accounts Receivable (CARS), the Cash
Processing system, ProviderOne data interfaces, the Social Services Payment System
(SSPS), DCYF s Famlink system, and numerous associated financial processes. The
scope of this work is extensive to ensure the DSHS systems and data fit within the
OneWa Workday FDM, necessitating the remediation and updating of these systems
along with over 100 associated financial processes. This includes a wide array of
components such as computer programs, databases, user interfaces, data exchanges,
and reporting mechanisms, all of which are integral to supporting the new OneWA
Workday FDM structure. Such targeted remediation efforts are designed to ensure these
systems and processes are not only compliant but also optimized for functionality within
the overarching OneWA initiative, enhancing efficiency and interoperability across the
board.
The procured Contractor shall also be responsible for the development, maintenance,
and regulatory compliance of the CARS system, leveraging a Commercial Off-The-Shelf
(COTS) solution. The Contractor s responsibility encompasses all subsystems or
business lines within the CARS framework, including the critical data interfaces that
facilitate communication between CARS and both internal systems within various
administrations and external agencies. The Contractor s role also includes supporting
the Cash Processing System, a vital component for managing cash flow transactions
and ensuring seamless financial information exchange between DSHS internal systems
and its external counterparts. The Contractor s scope of work further entails
comprehensive software maintenance and enhancement efforts for the key DSHS
financial and administrative systems, where work is not limited to, error rectification,
adaptation to emerging hardware and software landscapes, performance optimization,
system upgrade testing, configuration and validation procedures, and rigorous database
maintenance.
The procured Contractor shall also spearhead consultation and knowledge transfer
initiatives aimed at empowering DSHS staff members. This role is critical for enabling
staff to autonomously support and manage the financial systems. The Contractor s
devised training sessions will encompass a broad spectrum of topics, from system
navigation and deep-dives into business knowledge to adept troubleshooting techniques.
Such a curriculum is vital for equipping DSHS staff members with the expertise required
to confidently navigate the intricacies of the CARS and Cash Processing ecosystems,
ensuring they are well-prepared to tackle challenges independently.
Acuitys Sage MAS 500 Developer