Experience

Wallace & Carey Inc.

• Canada
• Wholesale
• 100 - 200 Employee

• Applications Analyst / Database Administrator

  • Jan 2017 - Present

  First and Second level technical support for all software applications throughout the company, including OpenVMS-based ERP system, web-based customer portal, and SQL Server integration environments * Developed and implemented ETL solutions for SQL Server .2017 data integration environment * Developed and implemented integration database environment to run adjacent to current ERP system * Developed and implemented automated Sales reporting dashboards using MS Excel (front-end) * Developed and implemented automated Sales reports (monthly/quarterly) integrating 3rd-party data * Developed and implemented corporate database standards * Developed and implemented database backup schedule * Developed and implemented database Disaster Recovery Plan Show less



Siemens

• Germany
• Automation Machinery Manufacturing
• 700 & Above Employee

• Contractor

  • May 2016 - Sep 2016

  Developed all aspects of new automated report generator component for commercial application. * Developed stored procedures in SQL Server * Collaborated on standardized XML format for report requests * Developed reports using Crystal Reports * Developed serializer API for use in all other components of commercial software (C#) * Developed deserializer for XML report requests created from within commercial software (C#) Developed all aspects of new automated report generator component for commercial application. * Developed stored procedures in SQL Server * Collaborated on standardized XML format for report requests * Developed reports using Crystal Reports * Developed serializer API for use in all other components of commercial software (C#) * Developed deserializer for XML report requests created from within commercial software (C#)



Government of Alberta

• Canada
• Government Administration
• 700 & Above Employee

• Systems Analyst II

  • Jan 1999 - Jan 2016

  Responsible for attending to the technical needs of the Compliance and Assurance division of the Department of Energy - Technical Lead for implementation of electronic Audit Management system - Team Lead for implementation of new employee time entry system, including data conversion from previous time tracking system - Developed integrated time reporting system for new employee time entry system, using C#, Crystal Reports, and SQL Server stored procedures Responsible for Database Administration, in accordance with Departmental standards - Upgraded Microsoft SQL Server through multiple versions (from SQL Server 6.5 through to SQL Server 2014) - Developed several automated data loading systems to load externally-sourced data into SQL Server - Performed scheduled maintenance and service pack application, when applicable Responsible for general health of Calgary Applications Windows-based servers - Performed server hardening routines so that servers met with Departmental standards Create and maintain documentation - Authored internal white paper outlining procedures for monitoring various network resources using third-party applications - Developed documentation for Calgary-based application support, including Disaster Recovery Plans, Disaster Recovery Tests, application-specific end-user documentation, and application-specific technical documentation Show less



NTI Newspaper Technologies Incorporated

• Calgary, Canada Area

• Database Migration Specialist

  • Jul 1998 - Dec 1998

  Responsible for converting pre-existing customer databases to in-house database schema. - Assisted in developing automated database conversion routines using SQL Server - Developed user-specific documentation describing the result of database conversion Responsible for converting pre-existing customer databases to in-house database schema. - Assisted in developing automated database conversion routines using SQL Server - Developed user-specific documentation describing the result of database conversion



Shaw Communications

• Canada
• Telecommunications
• 700 & Above Employee

• Database Developer

  • Jan 1997 - Jun 1998



PowerTel Communications

• Calgary, Alberta

• IT Manager

  • Jun 1995 - Nov 1996