Designed and created new data warehouse to support new reporting application designed specifically for elementary and secondary schools in Ontario. Created SSAS cubes in SSAS 2012 to consume data from the data warehouse.Created SSRS reports using SSRS 2012 to extract data from SSAS cubes using MDX.Provide recommendations to management as required to maintain a healthy database environment. Provide ongoing support for all database activities within the organization using the various SQL Server versions.

Managed the IT team of 14 members during a transition period at EQAO. The team of 14 members included contracted staff and full-time union staff.Acted as the IT advisor to the senior management team. Ensured that IT projects adhered to existing project timelines and deliverables.Managed the IT budget and authorized necessary hardware and software purchases.Communicated with external vendors to ensure that outsourced IT projects were implemented correctly and in a timely manner.Created and reviewed each IT members yearly performance plan.Conducting weekly IT team meetings, bi-weekly one-on-one status meetings with direct reports.