Experience

  • Database and Business Intelligence Developer

    at Bell Canada

    November 2018 - at Present

    Ontario

    Database and Business Intelligence Developer • Microsoft SQL Server Reporting Services (SSRS) report development to support of a Network Services Portal. • Developed advanced and dynamic SQL queries and stored procedures using SQL Server Management Studio, Visual Studio and TFS • Produced dashboard type information to provide clients with a visual aid for daily business requirements. • Created prototypes and use case examples for validation of reports and User Acceptance Testing (UAT).

  • Database and Application Developer

    at National Resources Canada

    April 2016 - at Present

    Ontario

    Database and Application Developer Part of a team of nine that developed change requests from clients and enhancements for applications used by internal and external clients. • Developed web applications for all client work using Cold Fusion, Oracle 12 ,HTML, JavaScript/AJAX and CSS and SVN version control software. • Created, altered, designed, tested, integrated and updated databases as needed to maintain and support applications. Wrote SQL queries to provide information to clients. • Formulated system reports for management analysis. • {M4}{R4}{R5} • Implemented code changes for integration of several applications based on client's change requests. • {M3}{R3} • Met with clients to gather requirements, and provide demonstrations of GUI prototypes.

  • Database and Application Developer

    at Canadian Nuclear Safety Commission

    September 2014 - at Present

    Ontario

    Database and Application Developer • Provided support and integrated several existing systems through release management using ColdFusion 10 and IIS, Adobe ColdFusion Builder 2, Adobe Dreamweaver CS 5.5, created and updated Sybase and SQL Server RDBMS using DDL (SQL data definition language) and DML data manipulation language. • Created, altered and updated databases using SQL statements, stored procedures and triggers. Created reports using SQL and MS Excel. • Tested, repaired and confirmed successful implementation of the web-based applications through 4 distinct environments, Development, QA, Staging and Production using Beyond Compare and Team Foundation Server. • Met clients to gather requirements to provide development support for the purposes of conversion to new versions of Cold Fusion and migration from Sybase to SQL Server. • Maintained standard Look & Feel as defined by Application Services Division, WCAG 2.0 and WET.

  • Database and Business Intelligence Developer

    at Environment and Climate Control Canada

    May 2016 - May 2018

    Ontario

    Database and Business Intelligence Developer • Microsoft SQL Server Reporting Services (SSRS) report development for customized Microsoft Dynamics CRM (Gavia) application based on client requirements. • Prepared complex SQL queries using SQL Server Management Studio. • Trained team members in SQL query writing and Microsoft SQL Server Reporting Services (SSRS) report development. • Acted as consulting member for best practices and SQL expert. • Analyzed and manipulated customized Microsoft Dynamics CRM database to provide meaningful reports for the client in MS Excel and MS Report Builder. • Met with clients to gather requirements and provided use case examples for validation of reports and User Acceptance Testing (UAT).

  • Application Developer – Web Publisher

    at Public Works and Government Services Canada

    May 2014 - March 2015

    Ontario

    Application Developer – Web Publisher Created online forms for the Receiver General to allow clients, in Canada and abroad, to enroll for direct deposit. Converted PDF and MS Word documents to HTML and WET. • Provided support and maintenance of existing web sites using Adobe ColdFusion, HTML, Javascript and Adobe Dreamweaver CS 5.5. • Met with clients to gather requirements to develop and maintain static and dynamic websites in accordance with current Treasury Board and PWGSC Common Look and Feel Standards and Web Content Accessibility Guidelines.

  • Database and Application Developer / Reporting Specialist

    at Environment Canada

    February 2010 - June 2013

    Ontario

    • Designed, developed, tested, implemented and maintained a new Canadian Electronic Permitting System (CEPS) for the Species at Risk department using ColdFusion and SQL Server DDL and DML. • Developed, updated and integrated CEPS, SARA, IRF and CITES web applications using Adobe ColdFusion 9/10, Fusebox 5.5 with MVC, JavaScript/AJAX, XHTML, XML, XSLT, POI and Mercurial. • Designed web applications, using XML code files, that followed CLF 2.0 best practices, and tracked all revisions in the Subversion code version control system Developed prototypes and Graphical User Interfaces • Created SQL statements to provide ad-hoc reporting to Permit Officers, altered, designed and updated query statements, stored procedures. • Performed query statements and stored procedures using ColdFusion. • Implement role-based security within applications using HTTPS. • Gathered and analyzed internal staff requirements and system requirement documents for CEPS application.

Education

  • Computer Science

    at Heritage College

    1995 - 1996 (1 year) Québec

Languages

  • English Native

Hives