Job Description :
Task-Based I&IT Consultant - Level 2 Toronto, ON Start Date Next week End Date 2021-06-30 Description MSP Intake Notes *Note that the start date is ASAP, start date is backdated for budge reasons The resource will be working on a modernization project. Two .NET applications will be merged into one application. This resource will need to have lots of experience with data mapping and experience mapping data from one application to another. Must Haves (Please read full requirements) Exceptional data mapping PowerDesigner Strong experience developing complex SQL Queries Data model design VB.NET Oracle Maximum number of Submissions per vendor: 1 Shortlisting deadline: Friday January 8th at 10:00am EST A note on Assignment Type: This position is currently listed as "Onsite"; however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well. Responsibilities: Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organziation's I&IT Systems. The Task-based I&IT Consultant may be used to provide strategic guidance to organizations with regard to IM and Task-based IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. they can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance. Required Knowledge / Skills: Key deliverables to be performed include, but are not limited to, the following: Document and analyze the current Business Process and identify gaps; Identify opportunities of IT integration and propose approach to business transformation by IT enablement; Gather, document and analyse Business and System Requirements; Design and document business process flows meeting the requirements; Create data dictionary and data mappings of applications using Power Designer; Develop deployment plans for the production environment; and Create Operation Manual documents; and develop and/or update other technical documentation as required. Other Experience and Skills: The candidate must have a minimum of 7+ years of the following skills and experience: In-depth understanding of the entire Data Dictionary , data mapping; In-depth understanding of the Business Process Design Reengineering for applications; Proficient with technology solutions and use of Power Designer; Proficient in gathering requirements, analysis and design and methodologies to gather requirements; Knowledge of Zachman framework; Gathering business requirements for web-based solutions preferably very familiar with .NET web applications; Analysing requirements and identifying gaps; Experience in integration of business initiatives and IT solution; Business Process analysis and reengineering to help Business transformation; Experience in analyzing requirements in order to determine functional requirements for reports and other enhancements to the web based systems; Experience in writing specifications for development of reports and other enhancements to systems using Crystal Reports, VB.NET, ASP.NET, Oracle, C#, Entity Framework, jQuery, LINQ; Demonstrated analytical problem solving and decision making capabilities; Demonstrated risk and compliance analysis skills; Experience in documenting detailed design models; and Experience in dealing with multiple teams representing various areas in delivering the project; Demonstrated very strong SQL skills Proficiency with Microsoft desktop tools (Visio, MS Office, MS Project and Outlook) Experience working with learning ministries datbase 1. Transfer From Solution Development / Task-based I&IT Consultant / Level 2 to Project Manager When Knowledge Will Be Transferred: Knowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministry. What Knowledge Will Be Transferred: All deliverables and supporting documents produced, in progress, or received from other sources, including by not limited to: Business requirements, training material and system overviews, strategy and status updates, data sets, data profiling, data dictionaries, test plans, test materials (e.g. scripts, data, results), risks, issues, etc. How Knowledge Will Be Transferred: Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team. Skills Experience and Skill Set Requirements Price - 30% No Details Provided Core Skills - 35% Experience with Business and IT integration process In-depth understanding and experience of the entire Data Dictionary , data mapping In-depth understanding and experience of the Business Process Design Reengineering for applications Experience in gathering requirements, analysis and design and methodologies to gather requirements Experience analyzing requirements and identifying gaps Experience in integration of business initiatives and IT solution Experience with Business Process analysis and reengineering to help Business transformation Experience in analyzing requirements in order to determine functional requirements for reports and other enhancements to the web based systems Demonstrated experience with risk and compliance analysis skills Experience in dealing with multiple teams representing various areas in delivering the project Technical Skills - 25% Demonstrates experience with SQL and SQL querying Working knowledge of Zachman frameworK Demonstrates experience in working with technology, data, databases, and applications Experience gathering business requirements for web-based solutions Very familiar with .NET web applications and database structures Experience with technology solutions and use of Power Designer Experience in writing specifications for development of reports which uses Crystal reports and SSRS Experience writing specifications for web applications and systems using VB.NET, ASP.NET, Oracle, C#, Entity Framework, jQuery, LINQ Experience in documenting detailed design models Experience with Microsoft desktop tools (Visio, MS Office, MS Project and Outlook) Experience documenting data flow, data mapping and data translation requirements Ability to translate business requirements to pseudo code Communication Skills - 5% Excellent verbal and written communication and presentation skills Demonstrated analytical problem solving and decision making capabilities Experience in dealing with multiple teams representing various areas in delivering the project Experience working closely with the development team translating business requirements to functional specifications. Organization Experience - 5% Previous public sector experience in an organization of equivalent size and complexity to the Ontario Public Service