Feb 2015 – Present · 11 yrs 3 mos

• I teach the following Tableau courses in person or virtually: Desktop I (Fundamentals), Desktop II (Intermediate), Desktop III (Advanced) and Tableau Prep.
• http://www.tableau.com/learn/classroom
• QueryWorks Solutions is a Tableau Learning and Alliance partner. We are the first Tableau Learning partner in Western Canada.

Jan 2014 – Present · 12 yrs 4 mos

• http://www.bcit.ca/cea/faculty.shtml
• Proposes, designs, develops curriculums and materials, and delivers lectures on data visualization and visual analytics

Apr 2013 – Mar 2018 · 4 yrs 11 mos

• http://www.bcit.ca/files/pdf/policies/5404.pdf
• "Program Advisory Committees (PACs) give strategic advice and assistance to their related BCIT programs. They provide feedback on industry changes, overall trends that may affect the curriculum and employability of graduates, and the general health of the subject industry. In addition, PACs review proposals for major curriculum changes or new programs, and endorse or make recommendations on such proposals."

Jul 2012 – Nov 2012 · 4 mos

• The MVP Student Mentor Program pairs MVPs with students in the Microsoft Student Partner (MSP) Program to share their knowledge and experience as influential technical leaders in the community. The MSP Program is a worldwide educational program that sponsors students majoring in disciplines related to technology who then share their knowledge with the academic community.

Oct 2011 – Oct 2012 · 1 yr

• http://www.packtpub.com/sql-server-2012-with-powershell-v3-cookbook/book
• "SQL Server 2012 with PowerShell V3 Cookbook" is an example-focused book that provides step-by-step instructions on how to accomplish specific SQL Server tasks using PowerShell. Each recipe is followed by an analysis of the steps or design decisions taken, and additional information about the task at hand. Working scripts are provided for all examples so that you can dive in right away. You can read this book sequentially by chapter, or you can pick and choose which topics you need right away.

Jun 2011 – Present · 14 yrs 11 mos · Vancouver, Canada

• Provides consulting and corporate training services on SQL Server (administration, development, business intelligence), automation with PowerShell and visual analytics reporting and dashboarding with Tableau
• QueryWorks Solutions is a Tableau Learning and Alliance Partner

Mar 2009 – Jun 2011 · 2 yrs 3 mos · North Vancouver, BC, Canada

• Installs, configures, administers, tunes and troubleshoots client databases
• Creates sales, inventory and project-related reports against relational db, data warehouse and cubes using SQL Server Reporting Services
• Creates BI solutions for small clients, including SSIS packages for ETL and general task automation
• Creates reports from SharePoint Lists and SSAS cubes using SQL Server Reporting Services
• Provides technical training to clients (basic administration, installation, development, SSRS)
• Develops custom SharePoint pages, web parts, features, Visual Studio workflows
• Projects in the following industries: Telecommunications Company, Food Services, Consulting Services, Manufacturing, Health Authority
• Technologies: Microsoft SQL Server 2000/2005/2008/2008 R2 (including SSIS/SSRS/SSAS), C#/ASP.NET, SharePoint 2007 (MOSS, WSS 3.0), SharePoint Foundation, XHTML, CSS, Javascript/jQuery, XML, PowerShell, MDX

Apr 2008 – Mar 2009 · 11 mos

• Created tools and scripts to administer, tune/optimize, document and audit production databases
• Participated in architecting XML-centric database for large scale web application
• Developed scripts for manipulating, importing and exporting legacy database, XML into SQL Server
• Participated in creation of database standards for development team
• Performed backups and restores
• Helped troubleshoot production stored procedures/scripts, replication, backup and recovery issues, XML performance
• Technologies: Microsoft SQL Server 2000/2005, SQL CLR, SQL XML, SSRS

Jan 2008 – Jan 2008 · 0 mo

• Analyzed existing databases that were organically grown and managed by developers, and provided recommendations for improving schemas, stored procedures, and views
• Performed database audits, and recommended tools to help developers be more proactive in auditing database events and security
• Created a migration plan for SQL Server 2000 to 2005 conversion, including hardware and features recommendations
• Optimized problematic and complex queries by rewriting the stored procedures, introducing indexes, adjusting isolation levels where appropriate
• Mentored developers on how to monitor performance metrics that affect database and web applications
• Technologies: Microsoft SQL Server 2000/2005

Jan 2007 – Jan 2007 · 0 mo

• - Developed an integrated notification system for stock brokers using SQL Server 2005, SQL Server Notification Services, SQLXML, .NET, C#, SharePoint 2007

Jan 2006 – Jan 2008 · 2 yrs

• Gathered user requirements and translated these to system specifications and technical design documents
• Architected and developed custom solutions for clients using Microsoft technologies
• Engaged in SQL Server projects including installation, migration, reporting and performance tuning
• Participated in large scale SharePoint projects to design, configure, implement and customize intranet and extranet solutions for clients
• Participated in project resource and schedule estimations
• Created functional and usability testing plans, training plans, technical and user documentations
• Mentored junior team members in project assignments
• Provided client support and training
• Projects in the following industries: Financial Services, Food Services, Multimedia, Vacations, Engineering Firm and Mining Firms, Health Authorities, Municipalities/Cities etc
• Technologies: Microsoft SQL Server 2000/2005 (including SSRS, SSNS), C#/ASP.NET, SharePoint 2007 (MOSS, WSS 3.0), VSTO, HTML, CSS, Javascript, XML/XSL

Jan 2003 – Jan 2006 · 3 yrs

• Managed IT projects, infrastructure and operations
• Performed DBA tasks, including designing, implementing and managing MySQL production databases, generating reports, archiving, replication
• Performed (Linux) network administrator tasks, including setting up, configuring and managing servers (file, email, FTP, database) and monitoring network security
• Performed developer tasks including designing and managing the company website, creating web and mobile applications for water monitoring
• Technologies: MySQL, Linux, PHP, Perl, C/C++, Visual Basic, XML, J2ME, Python

Jan 2002 – Present · 24 yrs 4 mos

• BCIT is one of BC's Top Employers (http://www.canadastop100.com/bc/)
• Proposes, designs and develops courses and materials for BCIT School of Computing Part Time Studies (http://www.bcit.ca/study/programs/6994acert#staff)
• Delivers lecture and hands on labs to in person and virtual classes of 10 to 30 students per course per semester
• Tutors students for Correspondence courses
• Helps students network with industry practitioners
• Technologies: Microsoft SQL Server (Administration, Development, SSIS), MySQL, HTML/CSS, Javascript, SharePoint, Tableau Desktop
• Courses:
• Visual Analytics with Tableau
• Data Warehouse Foundations (with focus on Dimensional Modeling and ETL considerations)
• SQL Server Administration
• SQL Server Development
• SQL Server Integration Services
• MySQL Development and Administration

May 2001 – May 2002 · 1 yr