Responsibilities:
- Dive deep into the legacy systems to understand the HealthcareDomainSpecificDataPoints which are used to determine funding allocation in Ontario and provide inputs to the PBF and TPON projects on data model analysis and data model changes to accommodate the data requirements for MOH MLTC and MSAA;
- To extract the HealthcareDomainSpecificFundingAllocationBusinesslogics captured in the programming code in the legacy systems so they can be replicated in the TPON and PBF implementation;
- To extract historical data from the legacy systems to be feed into TPON and PBF and to build ETL scripts for data extraction and data loading;
- Provide technical expertise with technologies including IIS Web Server Microsoft SQL Server ASP.Net VB.Net Web Form MVC Crystal Reports DevExpress and ASP.Net Cloud Computing to design and develop sound solutions to business requirements;
- Install / configure / administer IIS web server and MS SQL server in distributed platform;
- Design and development develop and maintain system design models technical documentation and specification;
- R&D for solutions proposal to rewrite/migrate onto Azure Cloud provide research and development to assist Ministries to move onto our next strategic platform: a common business solution platform using Azure Cloud Azure DevOps Power Apps Power Automate Power BI and the integration with online Office 365 and SharePoint Online to orchestrate realtime government business workflow changes to ultimately automate government business processes through extensive integration;
- Maintenance support and provide operational warranty for the transition from the legacy systems onto PBF and TPON;
- Provide maintenance and support;
- Provide operational warranty.
- Provide documentation and knowledge transfer to FTE provide training to FTE as needed to improve team skills and knowledge.
Requirements
Experience and Skill Set Requirements:
Must Haves:
10 years Experience:
- Handson ASP.Net VB.Net Web Form MVC development experience install and configure MS IIS Dot Net Framework SQL Server environment;
- Handson experience with relational database design and development in MS SQL Server environment; Reverse engineering data models from existing applications and databases;
- Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python SQL stored procedure and SQL Server Integration Services (SSIS);
Skill Set Requirements:
Public Sector Experience:
- Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM architecture gating);
- Demonstrated understanding of Public Sector/ministries I&IT strategies plans policies directives best practices and standards to ensure compliance in the development coordination and implementation of projects.
Solution Design Experience:
10 years of experience in the following:
- Designing and developing large complex provincial level financial allocation and payment tracking system using Dot Net Framework ASP.Net VB.Net C# Web Form MVC and using DevExpress components;
- Reverse engineering data models from existing applications and databases;
- Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python SQL stored procedure and SQL Server Integration Services (SSIS);
- UI/UX Design to comply with WCAG 2.1 or AODA;
- Building enterprise level software automation process using CI/CD pipelines and tool chains on DevOps platform.
Hands on Technical Experience / Knowledge Areas:
10 years of experience in the following:
- Handson ASP.Net VB.Net Web Form MVC development experience install and configure MS IIS Dot Net Framework SQL Server environment;
- Handson experience with relational database design and development in MS SQL Server environment;
- Designing and developing RESTful web services JSON and XML;
- Project development experience with Azure Boards Azure Git and Azure DevOps;
- Designing and developing user authentication using MS Active Directory online or within corporate domain
- Experience with Cloud Platform using PaaS such as Azure Managed Application Services Docker and Kubernetes;
- Postimplementation support.
Project Experience Team Collaboration Communication and General Skills:
10 years of experience in the following:
- Continuous deployment methods and procedures;
- Agile methodologies for the analysis design development and implementation of applications in large complex environments;
- Knowledge and understanding of objectoriented analysis and design techniques;
- Experience leading a team of developers assigning tasks mentoring junior developers coordinating components for successful delivery;
- Excellent analytical troubleshooting problemsolving and decisionmaking skills;
- Conducting research and assessment of options for technical design issues;
- Contributing to design/development of project plans including work breakdown and resource plans;
- Good verbal and written communications skills;
- Interpersonal and negotiation skills;
- A good team player with a track record for meeting deadlines;
- Experience with the projects related to businesscritical environments and operations.
Experience and Skill Set Requirements: Must Haves: 10 years + Experience: Hands-on ASP.Net VB.Net Web Form, MVC development experience, install and configure MS IIS, Dot Net Framework, SQL Server environment; Hands-on experience with relational database design and development in MS SQL Server environment; Reverse engineering data models from existing applications and databases; Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python, SQL stored procedure, and SQL Server Integration Services (SSIS); Skill Set Requirements: Public Sector Experience: Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM, architecture gating); Demonstrated understanding of Public Sector/ministries I&IT strategies, plans, policies, directives, best practices, and standards to ensure compliance in the development, co-ordination and implementation of projects. Solution Design Experience: 10+ years of experience in the following: Designing and developing large, complex, provincial level financial allocation and payment tracking system using Dot Net Framework, ASP.Net, VB.Net, C#, Web Form, MVC, and using DevExpress components; Reverse engineering data models from existing applications and databases; Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python, SQL stored procedure, and SQL Server Integration Services (SSIS); UI/UX Design to comply with WCAG 2.1 or AODA; Building enterprise level software automation process using CI/CD pipelines and tool chains on DevOps platform. Hands on Technical Experience / Knowledge Areas: 10+ years of experience in the following: Hands-on ASP.Net VB.Net Web Form, MVC development experience, install and configure MS IIS, Dot Net Framework, SQL Server environment; Hands-on experience with relational database design and development in MS SQL Server environment; Designing and developing RESTful web services, JSON and XML; Project development experience with Azure Boards, Azure Git, and Azure DevOps; Designing and developing user authentication using MS Active Directory, online or within corporate domain Experience with Cloud Platform using PaaS, such as Azure Managed Application Services, Docker, and Kubernetes; Post-implementation support. Project Experience, Team Collaboration, Communication, and General Skills: 10+ years of experience in the following: Continuous deployment methods and procedures; Agile methodologies for the analysis, design, development and implementation of applications in large complex environments; Knowledge and understanding of object-oriented analysis and design techniques; Experience leading a team of developers, assigning tasks, mentoring junior developers, coordinating components for successful delivery; Excellent analytical, trouble-shooting, problem-solving and decision-making skills; Conducting research and assessment of options for technical design issues; Contributing to design/development of project plans, including work breakdown and resource plans; Good verbal and written communications skills; Interpersonal and negotiation skills; A good team player with a track record for meeting deadlines; Experience with the projects related to business-critical environments and operations.