Joel Killam Email & Phone Number

Fredericton, New Brunswick, Canada

Worked in the Digital Technology group (ELD/GIS team) as the primary IT resource behind NB Power's work order system.NB Power's work order system is centered around a third-party solution called WorkStudio (by GeoDigital). WorkStudio stores all work orders in a MS SQL Server 2014 database. Power line designers using WorkStudio client software on Panasonic Toughbooks can operate in a disconnected environment by temporarily storing work orders in local MS SQL Server 2014 Express databases. Business/finance users can view, track, approve work orders using the WorkStudio InfoCenter web front-end.My responsibilities fell into the following categories:- Database Administrator: Maintain WorkStudio's vendor database, as well as the NB Power custom database. Duties include: SQL Server updates, migrations, sharing of views.- Database Analyst/Developer: Support and enhance the large code base that drives virtually all work order automation, validation and interfaces with other corporate systems (Transact-SQL, SQL CLR). Duties include: bug fixes, enhancements, analysis, design and development on new modules in coordination with team and vendor.- Application Support & Config: Act as the front-line IT support for WorkStudio. Duties include: resolve user WorkStudio issues, escalate issues to vendor, install software updates, coordinate outages.

Fredericton, New Brunswick, Canada

Worked in Information Systems as the primary resource dedicated to developing and supporting applications for the NB Power Generation Bulk Marketing department (now a separate subsidiary, NB Energy Marketing). NB Energy Marketing operates a 24/7 marketing desk to handle millions of dollars worth of bulk energy trades each year.Worked primarily on the design, development and maintenance of client/server, database front-end applications using Visual Basic 6 and SQL Server 2005, 2008 R2. Worked with clients to determine user requirements.Responsibilities:Analysis, design & development of custom, front-end and batch applications.Create & maintain data models.Support custom applications.Support third party software.Manage infrastructure changes, coordinate outages.Maintain system and user documentation.

Marysville, Nb

Secondment to New Brunswick System Operator (at the Energy Control Center) to help with the opening of the electricity market.Supported and maintained existing ASP 3.0 Energy Scheduling web application.Developed and implemented new ASP.NET Energy Scheduling web application using Visual Studio .NET 2002 and SQL Server 7.0.

Fredericton, New Brunswick, Canada

Worked in Business Information Systems (Nuclear & Generation team), primarily on the design, development and maintenance of client/server, database front-end applications using Visual Basic 5 and SQL Server 6.5.Developed and implemented new applications: Performance Indicators, Plant Logs, Periodic Inspections and Tender Call. Supported existing production applications.Worked with clients and colleagues to determine user requirements. Prepared technical documentation, online help and training materials. Completed code reviews for colleagues.

Bachelor Of Computer Science

Activities and Societies: Co-op programUNB Computer Science Dean's List (for 6 of 8 study terms)

Education record

Governor General's Medal Canada Scholarship Sir George E. Foster Scholarship Norris Hayward Memorial Scholarship Class Salutatorian