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 decisionmaking 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 (GOITS 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 handson 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. Handson 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. Handson Experience in designing developing integrating and implementation of Azure Storage for Attachment Management with MS Dynamics 365 on cloud.

E. Handson 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. Handson 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. Handson Experience with ETL

H. Handson 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 endtoend integration of ThirdParty / 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. Handson 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. Handson Experience with ETL

H. Handson Experience in designing developing Power BI Dashboard and Reports