Involve in short term BI Development projects

Technologies/Servers/Languages used: MS SQL Server 2017 Relational and DWH, T-SQL, SSIS, SSRS, SSAS, VBA, Power BI, Powershell, MS Excel, MS Access, JIRA, TFS, Citrix, Azure, Sharepoint 365, Sybelesoft->Thinfinity VirtualUI

​Data Sources: MySQL, MS Access, MS Excel, MS Active Directory, and Oracle.

Technologies/Servers/Languages used: MS SQL Server (2012, 2016, 2017), Relational and DWH, T-SQL, SSIS, SSRS, SSAS, VBA, Power BI, Powershell, MS Excel, MS Access, MS Infopath, Dynamic CRM, JIRA, TFS, XML, Citrix, Azure.

Data Sources: BasePlan (ERP), MS Dynamic CRM, MS Active Directory, and Oracle.

CURLS site (social bookmarking) opens the door to new ways of organising bookmarks and categorising online teaching and learning resources.

Customized look and feel of the website ( MySQL and PHP), modified login to use department's portal.  Integrated with .Net applications by developing REST and SOAP web services.

The Learning Management and Business Reform (LMBR) program is delivering modern, integrated IT systems to provide schools with a set of tools designed to help principals, teachers and school staff deliver the best possible outcomes for the students and communities they serve.

Modifyed existing SSRS reports.  Data source is Oracle 11g database.  Modifyed/Tuned/Re-factored report queries.

Mystery Matters is a series of learning games for students in years 4 to 10.

Created a variety of BI reports using MS SSRS and Excel Services.

SAM is core Open Training and Education Network application for which enables OTEN to efficiently manage its 60,000 distance students and 850 teachers, including 550 off-site teachers. It provides a comprehensive, auditable event and contact history for every student. SAM manages the dispatch of almost 325,000 learning resource items each year.

Involved in all SDLC stages.  Data conversion, migration from Clipper to Oracle database.  Creating client server and web based subsystems using Oracle Designer, Developer tools and PL/SQL cartriges.

The Learncast presents video resources to support units in the Community Services Training Packages.

Created Teamsite content entry templates.  Integrated Teamsite generated form with .Net, PHP, CGI and Adoby Flash applications.  Created a variety of BI SSRS and Excel services Reports as well as OLAP datamart using SSAS and SSIS. 

Created a set of BI OLTP and OLAP based SSRS and Excel Services reports as well as Sharepoint 2012 visualisation using Perfomance Point.