RQ09208 - Specialized IT Consultant - Senior

EDU Investigative Case Management System Modernization (ICMS) Application

The ICMS application is specifically built to enhance regulatory enforcement oversight concerning both licensed and unlicensed childcare providers. It accurately tracks and monitors every aspect of investigations such as intake, inspection, investigation, prosecution, and trial.

A modernization initiative was undertaken in line with the Governments Digital First Agenda to deliver simpler, faster and better services. This will significantly improve the administration of licensed and unlicensed childcares. This initiative will be a key step towards improving safety standards in childcare facilities, covering regulated and unregulated settings throughout Ontario.

The investigation details for both licensed and unlicensed care providers be stored in an electronic database, offering immediate visibility into ongoing cases. This will continue to facilitate proactive decision-making and enables quicker responses to critical issues encountered in the field.

The ICMS application undergoes regular enhancements & sustainment which includes sustaining the application, providing solutions for enhancements and remediating applications defects.

Deliverables to be provided by the Vendor include the following:

· Analysis

o Analyze Business Requirements to identify gaps along with recommended solution.

· Architecture Design

o Update/Create Architecture Artefacts (Business Architecture, Logical Architecture & Physical Architecture Artefacts)

o Update/Create Functional Design Documentation for the Solution

o Update/Create Technical Design Documentation for the Solution

· Infrastructure Services

o Configuration and Setup Cloud Based Environment(s) as required

· IT Solutions Enhancement / Sustainment

o Design, Configure and Implement Enhancement(s) / Remediate Defects for the Case Management System

o Design, Configure and Implement Enhancement(s) / Remediate Defects for the Mobile Inspection Tool developed based on MS Dynamics 365 Field Services App

o Design, Configure and Implement Enhancement(s) / Remediate Defects for the Reporting Tool based on MS Power BI

o Design, Configure and Implement Enhancement(s) / Remediate Defects for the Reusable Administrative Components

o Design, Configure and Implement Enhancement(s) / Remediate Defects for the Data Activity and Auditing Tool

· Data Migration

o Selecting, Preparing, Extracting, Transforming and Loading data from source to target

o Updating of Data Migration Documentation (Script Design & Data Mapping)

· Systems Integration

o Design, Configure and Implement Enhancement(s) / Remediate Defects for the Integration with OPS Service(s)

· Testing and Quality Assurance (QA)

o Contribute to the Quality Assurance Activities

· Implementation

o Collaborate and Coordinate with all Project Stakeholders involved to ensure smooth and timely completion of Activities & Deliverables

o Ensuring Compliance with

§ Accessibility for Ontarians with Disabilities Act (AODA)

§ Ontario Digital Service Design Guidelines

§ OPS Security Directive (GO-ITS 25.0 General Security Requirements)

· Systems Deployment Operations and Management

o Provide Packaging, Deployment and Migration Strategy for all Cloud Based Environment(s)

· Knowledge Management

o Conduct Knowledge Transfer Session(s) for the CSC Internal Project Team

· All Other Tasks as assigned by the Cluster Manager, Project Manager & Technical Lead.

Work Location is 3rd Floor, 777 Bay Street, Toronto, ON

SkillsExperience and Skill Set Requirements

The skills and competencies required for the assignment include:

70%

A. More than 8 years of experience with technical hands-on solutions development, configuration

B. Experience with the following Technologies on Microsoft Cloud (MS):

· MS Dynamics 365 CRM

· MS Power App Flows

· MS Power Automate

· MS Power Pages

· MS Azure Services

· MS Azure Attachment Storage

· MS Azure Active Directory

· MS Azure DevOps

· MS Azure KeyVault

· MS Azure API Management

· MS Logic Apps

· MS Power BI

C. Hands-on experience in architecting, designing and implementing case management system by using Microsoft dynamic CRM 365 on cloud, Azure, Azure AD, Power, Power App Flows and Power Platform technology.

D. Hands-on Experience in designing, developing, integrating and implementation of Azure Storage for Attachment Management with MS Dynamics 365 on cloud.

E. Hands-on Experience in Designing, Configuring and Implementation of Case Management System , Including experience with:

· User Access and Profile Management

· Role Based Data Access Control

· Authentication and Authorization Integration

· Document Management

F. Hands-on Experience in designing, developing Azure Logic Apps/Function Apps

G. Demonstrated experience with Kingsway Software for Data Migration from Oracle DB to MS Dynamics 365 Data Verse & Azure Blob Storage. Hands-on Experience with ETL

H. Hands-on Experience in designing, developing Power BI Dashboard and Reports.

I. Knowledge of and Experience with Accessibility for Ontarians with OPS Digital Accessibility Standard (ODAS) Testing compliance guidelines.

J. Experience with end-to-end integration of Third-Party / OPS Identity and Access Management (IAM) provider, security, authentication, and encryption tools / services.

30%

K. Strong knowledge of and experience with Testing and Quality Assurance Methodologies and best practices.

L. Strong ability to work under pressure, work with aggressive timelines and be adaptive to change.

M. Superior verbal and written communication skills.

N. Ability to develop and present new ideas and conceptualize new approaches and solutions.

O. Excellent interpersonal relations and demonstrated ability to work with others effectively in teams.

P. Demonstrated ability to work with functional and technical teams.

Q. Demonstrated experience with facilitating workshops and meetings.

R. Demonstrated ability to participate in a large team and work closely with other individual team members.

S. Demonstrated experience with OPS Quality Assurance Activities.

MUST HAVES:

8 yrs Experience:

B. Experience with the following Technologies on Microsoft Cloud (MS):

· MS Dynamics 365 CRM

· MS Power App Flows

· MS Power Automate

· MS Power Pages

· MS Azure Services

· MS Azure Attachment Storage

· MS Azure Active Directory

· MS Azure DevOps

· MS Azure KeyVault

· MS Azure API Management

· MS Logic Apps

· MS Power BI

C. Hands-on experience in architecting, designing and implementing case management system by using Microsoft dynamic CRM 365 on cloud, Azure, Azure AD, Power, Power App Flows and Power Platform technology.

G. Demonstrated experience with Kingsway Software for Data Migration from Oracle DB to MS Dynamics 365 Data Verse & Azure Blob Storage. Hands-on Experience with ETL

H. Hands-on Experience in designing, developing Power BI Dashboard and Reports