Helping customers drive success by mastering their data.

Designed BI/Analytics delivery platform Created self managed BI team, identifying opportunities for growthIdentified database availability, security and scalability risksLed best practices for database, BI and analytics

Contract work in data architecture, data governance and databases.Performance assessment and tuning of production environments including query tuning and index creation preventing scale out investmentHADR planning for SQL Server environmentsETL design and implementationDashboard design

Led reporting initiative to create BI environment for exposing data to customers, including schema design, security, task scoping and documentation.Proposed RACI matrix to facilitate cross team communication via IT, dev-ops and Engineering teams.Led program to train developers in database design best practices to enable teams to self review database changes to reduce single points of failure.Proposed meeting facilitation standards to increase meeting productivity.Work with dev-ops to improve SQL Server best practices for performance and monitoring.Identification of performance bottle necks in existing server design and code base to increase scalability and reduce operating cost over the long term.Knowledge sharing of development best practices with developers.

Design BI strategy and database environment to support it.Introduce visualization tools to management to improve data exploration and improve insight into sales data.Lead development team on best practices for database design and security.Lead data migration for ERP system, identifying risks and strategies to senior management.

Responsible for security, scalability and stability of over 2000 databases of varying sizes from large BI reporting databases with billions of rows to small transactional databases and critical ERP systems over 175+ instances ranging from SQL Server 2000 to 2012, Oracle 11g and Sybase.Creation of database guiding principles and best practices and putting these into practice across the enterprise for large virtual database environments.Creation of three year technology road maps for database environment.Member of ARB (Architecture Review Board)Query Optimization and database performance

Responsible for security, scalability and stability of over 2000 databases of varying sizes from large BI reporting databases with billions of rows to small transactional databases and critical ERP systems over 175+ instances ranging from SQL Server 2000 to 2012, Oracle 11g and Sybase. Query Optimization and database performance tuning reducing query reads and CPU time by up to 99.9% and reducing overall server CPU usage by up to 20%. Reduce server IO load by proper indexing strategies.Responsible for creation of database guiding principles and best practices and putting these into practice across the enterprise.Work closely with Cognos, network, VMWare and SAN admins to ensure database servers perform properly. Review 3rd party vendor database applications to ensure they conform to our best practices and identify security risks.Leader and mentor for junior resources and interns helping them succeed and transition into more senior resources. Identify and track metrics to improve database environments and manage day to day allocations of senior and junior resources assigned to database group. Change domain lead for databases and member of the architecture review board.Organize and present training for non-DBA staff to facilitate growing the knowledge base of the company .

Performance testing and tuning of SQL Server databases including indexing overhaul and advising on better maintenance policies. Developed and presented a 5 part training course to developer/analysts on SQL Server 2008. Topics included advanced querying, indexing, transactions and blocking, database design, performance testing and defensive database programming. Data migration of current JD Edwards system on AS/400 into EnterpriseOne system on SQL ServerDevelopment of best practices, performance tuning of existing packages for large data sets and advising on proper strategies for data migration including proper index changing/removal for optimum transfer rates and proper run time testing early in development to meet strict downtime window on go live day.Development of SSIS 2008 packages for data migration from AS/400 to SQL Server 2008Mentoring junior SSIS developers on techniques for improving package flow.

Rewrite of the Integration department’s custom build utility in JAVA.Managing ClearCase streams including merging two projects contained in separate VOBs.General MQ Server, IBM WebSphere Message Broker, Rational ClearCase, JAVA programming, and DB2 databases work as required.

Responsible for a major case-insensitive conversion project on multiple production databases, including the design, custom scripting, testing, implementation and verification of the manual process, environment set up and 3rd party tools for verification. Special considerations included ensuring case-insensitive databases were able to continue interacting with case-sensitive databases and new servers were configured correctly.Identified poorly performing queries due to missing indexes which were tuned to execute in a third of the time.Introduced DBA team to 'ExamDiff' comparison software saving hundreds of man hours comparing version of scripts.Review and consolidation of custom integrity scripts into a central location to ensure business rules were correctly enforced. Advised on a system of comparing against a captured baseline of counters captured from Perfmon to pro-actively identify performance issues before they became problems.Investigate and resolve batch jobs that failed to run.Various routine data fixes, development environment refreshes, production db changes and normal database maintenance completed in off hours as required.

Query performance optimization with SQL Server 2005/2008 including optimizing indexes and stored procedures.Created a standard plan of action for others when trouble shooting database performance issues to avoid wasted time and effort by eliminating possibilities in a logical order.Consulted on best practices for database table design and how to achieve better data integrity through the use of keys and constraints.Designed and implemented a complete BI solution with SQL Server Analysis Services including a data warehouse from an existing OLTP system via ETL procedures with SSIS, multiple OLAP cubes, and various dashboard reports for management. Maintained development relational databases as well as the data warehouse previously referred to.Mentored other employees in data warehousing techniques and BI reporting. Consulted with an Oracle/Cognos BI team on a transition process to move to the MS SQL Server 2008 suite of BI tools.Maintained and enhanced large scale applications in both struts/J2EE and .NET.

Consulted with local entrepreneur and designed/programmed interface for online store to communicate product data with supplier via XML.

Graduate work in Computer Science. Advanced studies in algorithms, data structures, operating systems and intractable problems. Marker for 3rd/4th year undergrad classes.

Wrote and maintained complex stored procedures containing business logic for both reports and business/UI components. Business report writing and maintenance of existing reports with Crystal Reports.Simplified the class structure of a unit of the project, improving readability for future maintenance workers and coordinated other improvements with Functional Analyst based in Seattle.Continuation of previous work with Boeing, the project now in maintenance mode. Brought back to replace two junior developers.

Application/database development with .NET conversion project (ASP/VB to .NET using XML) for the Alberta Oil and Gas Registry. Responsibilities included analyzing existing application and converting to ASP.NET to interface with VB.NET middle tier layer and SQL Server backend.

Created various complex ETL processes with SQL Server 2000 DTS utilizing error checking, email, and FTP services.Identified the need for and architected new COM objects to facilitate easier creation of DTS components in SQL server saving developers hours of coding. Application/database development with Visual Basic, SQL Server, Cold Fusion, XML, J2EE.

Primary report writer on a major contract with Boeing, I architected the interfacing of Crystal Reports 8 with the main application written in VB6 to meet client constraints. Created complex reports which including designing all stored procedures to retrieve data from Oracle. Application development with Visual Basic designing front end screens, middle tier business object classes and additional stored procedures in PL/SQL. Received CMMI (then CMM) Level 3 training.

Continuation of previous contract. Designed and implemented additional relational databases along with ETL conversions of legacy flat-file databases. Developed XML-compliant web-based queries with ASP/ADO and data conversion programs with Visual Basic and Excel.

Designed and implemented relational databases in SQL Server and converted various legacy flat-file databases into these via ETL processes written in Visual Basic using ADO.Responsible for the design, coding and testing of a front-end program for data input and a web-based query page for the public using Visual Basic 6, ASP and ADO.