Stephen Bruce Email and Phone Number

Managing the Systems Services team in many roles: leader, mentor, software architect, analyst, project manager, database administrator, systems administrator, systems security, troubleshooter and developer. Responsible for software and systems direction, design, construction and maintenance including net new projects, and major/minor enhancements to corporate systems and regulatory systems.

Software Architect / Senior Lead DeveloperDesigned, and led the development team in building, a dependency injection-based solution for Human Resources staff to capture roles, job families, competencies, assessments and analytics. The solution was successfully rolled out to production in 2016 and has been used steadily by the organization ever since to capture employee career development through competency progression.Dev tools: SQL Server 2014, Visual Studio 2015 (C#, .Net 4.6), Bootstrap, JavaScript (incl. libraries such as JQuery, Datatables), Team Foundation System (automated continuous integration - build/deploy/unit testing), Windows Server 2016, PowerShell scriptingSoftware Architect / Technical Lead on the eFiling System. This system was a complete re-write of the AUC's largest core systems (EAS, EPS, DDS, IAR) into one customized SharePoint / ASP.Net solution (eFiling).- Designed and implemented the MVC pattern that the dev team used for all data handling of the system.- Worked with both contractors and employees to set a number of core coding practices and standards.- With continuous input from both business analysts and business users, created technical specifications for and implemented many core features of the system.- Worked with team members to ensure that standards were being maintained and deadlines were being met.- Implemented a number of efficiencies to ensure the system remained performant under load.- The v1.0 release of the system was rolled out in January 2015, and has been extremely stable and highly regarded.Dev tools: SharePoint 2013, Visual Studio 2012 (C#, .Net FW4.5), SQL Server 2012, Windows Server 2012, JavaScript, JQuery, AJAX, TFS, PowerShell

Senior Developer (and currently Technical Lead) on the Field Inspection System (FIS.NET) conversion project - one of the largest software projects at the ERCB (> 200,000 lines of stored procedure code alone) requiring a complete re-write of the framework, all controls, client code and the business rule layer. Feedback during user acceptance testing to date has been overwhelmingly positive:o Wrote the most complicated and versatile controls for the system.o Tasked to mitigate the largest and riskiest pieces of the project [included forms, middle-tier components (both framework and business rule), controls and database scripts].o Managed the sandbox databases including refreshes of data, security, changes in structure and backups and restores.o Worked directly with the business to deliver solutions that were the best fit.o Continually streamlined, genericized and encapsulated code for more simplified re-use and maintenance.o Worked to ensure that completed code was well tested, accurate and robust. The majority of defects generated based on contributed code is of average or lesser severityDev Tools: Visual Studio 2010 (.Net4), SQL Server 2008 R2, Windows Server 2008 R2, DevExpress v11, SVN, TestComplete, Rational ClearQuest, ESRI Arc Mobile, Trac, CruiseControl

Senior Developer / Co-Design Lead on the Resources Application Spacing project - the Spacing system is a Windows-based, Web-Based, GIS-enabled n-tiered application/approval system, serving internal clients and the Oil & Gas industry, approx. 40,000 page views/day. System utilizes sub-system based, entity-class/controller class hierarchy:o Designed and implemented key components of the spacing system including the accept/overwrite functionality, deemed the highest project risk.o Designed and executed a massive data conversion (changing 100’s of millions of records), critical to the success of the initial implementation.o Created a test data generator for the test team, effectively increasing testing performance by a factor of 8.o Built and deployed components to all functional user environments (Dev/Test/Acceptance/Production).o Refactored a portion of the EAS registration code to handle the large spacing requests, adding a 20 – 30% increase in performance for non-spacing apps.Dev Tools: Visual Studio 2005, SQL Server 2005, Windows Server 2003, ASP.NET, AJAX, JavaScript, iBatis, nUnit, Rational ClearCase/ClearQuest, XML, CSS

Developer on the Electronic Application System (EAS) project – the EAS system is a Web-Based, n-tiered application/approval system, serving the Oil & Gas industry. System utilizes sub-system based, entity-class/controller class hierarchy:o Refactored the existing business logic layer to include an entity class data layer in order to better control and maintain CRUD functionality.o Re-wrote the external facing application query search engine, improving performance by a factor of 12.o Re-wrote the system used by external users to register applications, improving performance by a factor of 6.Dev Tools: Visual Studio 2003, SQL Server 2005, Windows Server 2003, ASP.NET, JavaScript, nUnit, Rational ClearCase/ClearQuest, eDocs, XML, CSS

Technical Lead on the Field Inspection System (FIS) team – a three tier enterprise level application serving approximately 200 internal clients (mainly field inspectors) as well as web access for industry:o Developed enhancements to the current system.o Attended change awareness meetings for the project.o Responsible for migration of code and objects through all environments (Sandbox/Dev/Test/Acceptance/Production).o Conducted code reviews.o Produced implementation and migration plans for project releases.o Mentored/trained junior developers.Dev Tools: Visual Studio 6 / 2003, SQL Server 2000, ASP, ASP.Net, Component One, VSS, ESRI Map Objects, XML, CSS

Developer on the Field Inspection System (FIS) team:o Completed key pieces of the application based on business specifications and worked closely with clients regularly to accommodate their requirements within allowable time constraints.o Wrote the necessary SQL Server database stored procedures and functions for data management and migration.o Wrote and maintained VB COM+ components for the business tier of the application including data access, validation and other business rules.o Wrote various portions of the user interface using VB 6 and maintained and enhanced existing portions including GPS and GIS modules, Grid and 'Smart Edit' controls, reports and a sophisticated Tablet Synchronization module written mostly in VB.NET.o Wrote and maintained sections of the external and internal Web interface in using ASP, ASP.NET, and XML.Dev Tools: Visual Studio 6 / 2003, SQL Server 2000, ASP, ASP.Net, Component One, VSS, ESRI Map Objects, XML, CSS

New Employee Orientation Program:o Spent time in the field at the Red Deer field office doing actual inspections with certified board inspectors.o Learned a lot about the process of drilling, reclamation and the Board’s role in field surveillance and enforcement.

o Designed and maintained web pages for Shell Canada's Intranet.o Designed the prototype for the Rapid Lube Commercial Website.o Responsible for researching many aspects of Shell Canada's first major extranet (the Retailer Web Site), including search engine techniques and discussion group technologies.o Created the templates, libraries and many of the initial forms for the Retailer Web Site.

o Responsible for solving user problems that the Help Desk could not solve (Tier 2 position); these problems included application, network and operating system issues.o Rotated on and off the ‘Code Red’ phone which was the direct line for members of the Help Desk to call in emergency situations.o Setup new PCs for employees; this included the setup of hardware and the NT based operating system, also spent time repairing and maintaining laptops.

o Helped the Y2K team to modify and create reports, forms and queries using MS Access to provide information on the Mobil’s current Y2K status.o Developed a method for users to create MS Word Mail Merge documents based on information extracted from an Oracle database.o Required to research all information on applications and projects in order to complete given tasks.

o Created custom web pages required for TransCanada’s Intranet.o Responsible for sorting through vast amounts information in order to find the appropriate data for each web page.o Coordinated with the project director to develop the best solutions possible.