Yanick Viel
Gatineau, Quebec--
Summary
I am a Canadian Senior Software Developer and I possess more than 15 years of experience in Information Technology.
My main achievements are Microsoft oriented solution architecture, project management, team management, software
development (VB.NET, C#, SQL Server), web application development (ASP.NET, Javascript) and reporting. I worked in
various industry sectors ranging from manufacturing and high technologies to Government and administration. I am a
highly skilled computer professional with strong management and leadership capabilities.
Education
Graduated January 2000
Collège de l'Outaouais
College Diploma (D.E.C.)
D.E.C. in Information technologies at Collège de l'Outaouais in 2000. COBOL, VB6, SQL.
Languages
French
English
Spanish
Native
Fluent
Proficient
Employment History
Velixo Inc
Full stack developer - *REMOTE*
Montreal, Quebec
October 2018 - March 2019
Development of new features in an Excel Add-in that integrates with Acumatica cloud ERP. Also, some other related or
unrelated projects including Acumatica integration and development and VB6/C#.NET modifications to other in-house
software.
Development of new feature of Velixo
Unit Testing
VISUAL STUDIO.NET 2017, C#, GIT HUB, VB6, SQL SERVER 2018, ACUMATICA
Business Development
Business owner
Santiago De Los Caballeros, Santiago Province
March 2013 - September 2018
Took a professional pause from the IT industry and got myself traveling and creating, developing and improving
various private businesses, mostly in the Dominican Republic, ranging from restaurants to call centers as well as
technical support and small development projects.
Alithya
Full stack developer
Ottawa, Ontario
August 2001 - March 2013
(Company named C.I.A. Inc. back then) Consulting position; performed multiple projects over the years in various
industry sectors such as manufacturing, high technologies, energy, banking, finance and government. Learned and
mastered various technologies over the years, mostly from Microsoft, starting from VB6 and Access up to C#, .NET, SQL
Server, SSRS, Servers, ASP.NET, MVC etc.. . Responsibilities evolved over the years ranging from software development,
Server, SSRS, Servers, ASP.NET, MVC etc.. . Responsibilities evolved over the years ranging from software development,
architecture, team leadership, project management and business development.
SEE PROJECTS DETAILS BELOW
Alithya: House of Commons of Canada
Full stack developer
Ottawa, Ontario
January 2013 - March 2013
Development of a tool that allows to process different file types allowing to develop loosely coupled DLL for each file
type with a web interface.
VISUAL STUDIO.NET 2012, C#, WPF, TFS, ASP.NET, SQL SERVER 2012
Alithya: In-House Development Center
Full stack developer
Gatineau, Quebec
January 2012 - December 2012
Develop Business opportunities for the development center where multiple contracts where performed, partially for the
firm, partially for clients.
Perform every steps of the software development life cycle (SDLC) ;
Business analysis;
Software development using Agile prototyping;
Database design ;
Test driven development and deployment ;
Management and supervision of developers;
Agile / SCRUM;
VISUAL STUDIO .NET 2012, ASP.NET, C#.NET, MVC, LINQ, ENTITY FRAMEWORK, AJAX, MS SQL SERVER 2008 /
2012, SSRS, MS TEAM FOUNDATION SERVER 2010, NUNIT, DYNAMICA DATA, ENTITY FRAMEWORK, LINQ
Alithya: Papier Masson Ltée
Full stack developer
Gatineau, Quebec
October 2011 - December 2011
This project consisted of migrating a series of old Crystal reports 7.0 to Crustal Report 2011 (14.0). They required a
developer that new their environment and business rules to perform the contract quickly.
Migration of all reports from crystal 7 to Business Objects Crystal Reports 2011
SAP CRYSTAL REPORT 2011, SQL SERVER 2005, T-SQL
Alithya: Ville de Gatineau
Full stack developer
Gatineau, Québec
May 2011 - September 2011
The callback and affectation of the city blue collars allows to generate callback lists that complies to the clauses of the
collective convention of the blue collars’ union with the city.
VISUAL STUDIO .NET 2010 (ASP.NET, C#.NET), MS SQL SERVER 2008, REPORTING SERVICES, MS TEAM
FOUNDATION SERVER 2010. DYNAMICA DATA, ENTITY FRAMEWORK, LINQ
Alithya: Canadian Electricity Association
Full stack developer
Ottawa, Ontario
April 2011 - May 2011
Equipment Reliability Information System (ERIS) bug fixing.
VISUAL STUDIO .NET 2010 (ASP.NET, C#.NET), MS SQL SERVER 2005, SSRS, NUNIT, MS TEAM FOUNDATION
SERVER 2010, WCF SERVICES, MS DYNAMIC DATA, OPENXML SDK, MS WORD 2007 CONTENT CONTROLS, XML,
LINQ
Alithya: Commissioner for the Federal Judicial Affairs
Full stack developer
Ottawa, Ontario
February 2011 - March 2011
The Reports Finder application is a small application designed to be a replacement for Business Object Report Manager,
The Reports Finder application is a small application designed to be a replacement for Business Object Report Manager,
similar to SSRS. Smaller but effective report management features, a comprehensive search functionality, favorites, along
with report scheduling (using Windows Task Scheduler). Also, the client required the documentation of a new
architecture and best practices, plus an interface to automate data synchronization with a 3rd party data (PWGSC).
Application architecture, design and development of a data driven web application.
Documentation of the architecture and development best practices.
Design and development of an enterprise class relational database in SQL Server 2005.
Conversion of reports to Crystal Report 2008 and integration in the web application.
Conception of a data synchronization interface with PWGSC's MER data.
Team lead and resource training for .NET.
Created various LINQ queries to customize the data retrieval.
Server configurations, deployment and bug fixes.
Agile / SCRUM
VISUAL STUDIO .NET 2008 (ASP.NET, C#.NET), MS SQL SERVER 2005, CRYSTAL REPORT XI - 2008, VISUAL
SOURCE SAFE, LINQ
Alithya: Canadian Electricity Association
Full stack developer
Ottawa, Ontario
May 2010 - January 2011
ERIS Web Application: a data driven web application for the Canadian Electricity Association (CEA) for generating annual
performance reports for different hydro facilities. Files conforming to a predefined well-known standard in the electricity
industry are submitted by various participating utilities, those files are parsed by a parser that is part of an ASP.Net web
application, where the information is inserted into various tables in the database. The information in the database is
made available to the end user through the web application, using Microsoft’s SQL Server Reporting Services.
Prepared various mock-up screens that were presented to the client to demonstrate the features, functionality
and look and feel of the web application.
Application architecture and design.
Creating various stored procedures, inline tabular functions and scalar function, to support complex
computations and mathematical formulas to produce various statistics.
Data archiving development for the design and development of this data driven web application.
Team and project management tasks.
Design and development of an enterprise class relational database in SQL Server 2005.
Created various LINQ queries to customize the data retrieval.
Created various Microsoft Reporting Servers reports to query the information in the database and generate the
required reports.
Word 2007 OpenXML document creation and assembly using OpenXML SDK, content controls, XML and LINQ
queries.
Server configurations, deployment and bug fixes.
VISUAL STUDIO .NET 2010 (ASP.NET, C#.NET), MS SQL SERVER 2005, SSRS, MS TEAM FOUNDATION SERVER
2010, NUNIT, WCF SERVICES, MS DYNAMIC DATA, OPENXML SDK, MS WORD 2007 CONTENT CONTROLS, XML,
LINQ
Alithya: City of Gatineau
Full stack developer
Gatineau, Quebec
April 2010 - May 2010
The Debt application was a VB6 & MS Access database used for managing the city’s various loans with different financial
institutions. The goal of the conversion is to migrate the application to Visual Studio 2008 and SQL Server 2005 database,
using their own proprietary application Framework.
Prepared the project plan and other various project coordination tasks.
Application architecture, design, and development as a data driven windows application.
Extracted city’s framework from an existing application.
Unit and integration testing.
VISUAL STUDIO .NET 2008 (WPF, C#.NET), MS SQL SERVER 2005, REPORTING SERVICES, MS TEAM
FOUNDATION SERVER 2010
Alithya: Department of Justice of Canada
Full stack developer
Ottawa, Ontario
January 2009 - March 2010
The Family Orders and Agreements Enforcement Assistance (FOAEA) system helps the Provincial and Federal
government to enforce the Family Orders and Agreements Enforcement Assistance Act. The system is presently
comprised of three main parts: Tracing Service, Interception Service (for garnishment) and Licence Denial. This project
was the conversion of an SQL server back-end that contained all the business logic in triggers and Stored Procedure, to a
new service oriented middle tier (SOA). The database was migrated from SQL Server 2000 to 2008 and the applications
developed with Visual Studio 2008.
Defined and analyzed architectural requirements for the various modules related to the FOAEA back-end;
Analyzed, designed and developed a middle layer tier using ASP.NET, VB.NET, JavaScript, SQL Server, WCF Services,
XML, Workflow Foundation;
Developed the middle layer as a data driven web application;
Created architecture documentation and schema for the project;
Development of a security model using Membership Provider for WCF services;
Design and development of an enterprise class relational database in SQL Server 2008;
Developed Transact-SQL queries and stored procedures in a Microsoft SQL Server 2000/2008 environment;
Supervision of the task assigned to developers and technical guidance;
TDD using NUnit framework.
VISUAL STUDIO .NET 2005 & 2008 C#, ASP.NET, JAVASCRIPT, MS SQL SERVER 2000/2008 (ANSI & STORED
PROCEDURES/TRANSACT-SQL), NUNIT, MS TEAM FOUNDATION SERVER, VSS, XML, WCF SERVICES,
WORKFLOW FOUNDATION (WF)
Alithya: City of Gatineau
Full stack developer
Gatineau, Quebec
April 2008 - December 2008
This project consisted of defining standards and conceiving an application framework using Visual Studio 2008 and test it
with a small web project that allows citizens to inventory the trees on their property.
Gathered, defined, analyzed and documented technical requirements.
Determined and executed the development standards.
Reviewed an existing application and made recommendations for improvements.
Performed architecture design for the web application framework.
Participated in the development of the data driven web application framework components including a module
to generate custom ad hoc reports.
Developed queries and coded stored procedures using Transact-SQL in an MS SQL Server 2005 environment.
Made recommendations about technologies related to application development including Reporting Services.
Development a SharePoint Portal in VS Team Server 2005.
Supported and guided the development team.
SQL SERVER 2005, VISUAL STUDIO 2008, C#, TFS, XAML, LINQ, SHAREPOINT SERVICES 2.0, SHAREPOINT
DESIGNER 2007, SSRS 2005, MS PROJECT, ENTITY FRAMEWORK, JAVASCRIPT, HTML
Department of Justice of Canada
Full stack developer
Ottawa, Ontario
April 2007 - March 2008
This project is a migration of a web application from HAHT Site 3.1 to Visual Studio.NET 2005. The FOAEA system supports
legislated operations. Under the FOAEA Act, the Department is responsible for aiding provincial and territorial
governments in the enforcement of family financial support orders and agreements.
Reviewed, defined and analyzed business and technical requirements.
Proposed, developed and implemented the object-oriented architecture framework required for the project using
ASP.NET
Participated and documented the project conversion approach and design guidelines;
Prepared programming standards & front-end look and feel guidelines for the programming team (CLF 1.0 and
then CLF 2.0 compliant);
Prepared ASP.NET framework training material and documentation for DOJ employees;
Provided design & coding guidance as well as extensive training with Visual Studio 2005 to project team.
Design and development of an enterprise class relational database in SQL Server 2005.
Developed queries and coded stored procedures using Transact-SQL in an MS SQL Server 7.0 environment.
Reviewed technical documentation produced by justice employees.
Defined and documented the testing strategy for the new application.
Guided DOJ employees with new version of MS Visual Studio 2005 tool / frameworks, ASP.NET and JavaScript
technology.
WINDOWS 2003, SQL SERVER 7.0, VISUAL STUDIO.NET 2005 (VB), ASP.NET 2.0, VISIO, HAHT SITE 3.1
Alithya: Department of Justice of Canada
Full stack developer
Ottawa, Ontario
April 2006 - March 2007
iCase is an existing ASP.NET 1.0 Web Application having huge performance problems. The project involved finding and
implementing solutions to correct the issues while doing maintenance and adding new functionalities.
Gathered, defined and analyzed technical requirements.
Analyzed the existing application to propose and recommend performance optimization enhancements;
Reviewed technical documentation produced by justice employees;
Analyzed business requirements and produced design documents for new functionalities to be added to the web
application;
Coded complex application modules;
Performed conversion from Visual Studio 2003 to Visual Studio 2005 and development.
Participated to the development of enhancements to the custom web ad hoc report module.
Performance improvement of the Crystal reporting solution, implementation of a RAS.
Developed queries and coded stored procedures using Transact-SQL in an MS SQL Server 2000 environment.
Guided DOJ employees with new version of Visual Studio 2005 tool and ASP.NET technology.
WINDOWS 2003, SQL SERVER 2000, VISUAL STUDIO.NET 2003, VISUAL STUDIO.NET 2005, (VB), ASP.NET 1.0,
ASP.NET 2.0, CRYSTAL REPORT SERVER XI, VISIO., JAVASCRIPT, HTML
Alithya: House of Commons of Canada
Full stack developer
Ottawa, Ontario
January 2006 - March 2006
Development of a web application used by the House of Commons’ client to author, manage and publish a web site
based on a paper publication, made of three main parts: the authoring environment based on Microsoft Word 2003 and
smart Tags, the SharePoint Services used as a document repository and the Publication Manager Web application.
Reviewed, analyzed and validated existing business and technical requirements with the business team and
update business documentation;
Reviewed and modified existing project architecture and framework implementation based on business
documentation (Multi-tier object-oriented web architecture);
Prepared design documentation for HOC programming team;
Analysis of application processes for performance tuning;
Participated in development and implementation of the data driven web application;
Developed queries and coded stored procedures using Transact-SQL in an MS SQL Server 2000 environment.
Updated existing Operational manual & User guide.
Prepared status & progress reports for the management team.
Trained HOC programming team with new technologies.
WINDOWS 2003, SQL SERVER 2000, VISUAL STUDIO.NET 2005 (VB), ASP.NET 2.0, WEB SERVICES, MICROSOFT
SMART TAGS, SHAREPOINT SERVICES, VISIO
Alithya: Office of the Ethics Commissioner
Full stack developer
Ottawa, Ontario
November 2005 - January 2006
Conversion of a web application developed in Java, running in a UNIX environment and using an Oracle database to
Visual Studio.NET 2005, Windows Server 2003 and SQL Server.
Visual Studio.NET 2005, Windows Server 2003 and SQL Server.
Reviewed, analyzed and validated business and technical requirements.
Proposed and implemented the architecture framework required for the migration of the application to a WEB
based object-oriented application using ASP.NET and JavaScript.
Prepared programming standards & front-end look and feel guidelines for the programming team (CLF compliant)
Prepared design documentation for programming team.
Participated in the development of this data driven web application.
Coded Transact-SQL queries and stored procedures in this Microsoft SQL Server environment
Prepared testing scenarios and testing results documentation.
Participated in the initial phase of the development.
Prepared status & progress reports for the management team.
WINDOWS SERVER 2003, SQL SERVER 2000, VISUAL STUDIO.NET 2005 (VB), ASP.NET 2.0, VISIO, ORACLE,
JAVASCRIPT, HTML
Alithya: Office of the Superintendent of Financial
Institutions
Full stack developer
Ottawa, Ontario
June 2005 - October 2005
Member of a “rescue team” in charge of redeveloping an incomplete web application designed to manage the
supervision of financial institutions.
Multi-tier architecture design using OO principles and design patterns;
Web development;
Interfaces designs;
Technical and functional documentation writing.
WINDOWS 2000, SQL SERVER 2000, VB.NET, ASP.NET
Alithya: Fortress Specialty Cellulose Inc
Full stack developer
Gatineau, Quebec
September 2004 - June 2005
Engineering of pulp production systems of the mill divided in 2 important modules, wood and wood chip provisioning
(CIAF) and quality control test performs on the chips (SIIT).
Objectives and requirements analysis;
Multi-tier architecture design using OO principles and design patterns;
Web development;
Interfaces designs;
Technical and functional documentation writing.
WINDOWS 2000, SQL SERVER 2000, SSRS, VB.NET, ASP.NET, JAVASCRIPT, HTML
Alithya: Brookfield Power Corp
Full stack developer / Integration specialist
Gatineau, Quebec
January 2004 - September 2004
Collaborate with an integration specialist firm of Microsoft Great Plains (Dynamics) to replace Maximo.
Reviewed, defined, analyzed and validated business and technical requirements
Software customizations realized using integrated tools and VBA.
Peripheral solution’s development for very specific needs using .NET and SQL Server.
Developed Transact-SQL queries and stored procedures in this Microsoft SQL Server 2000 environment.
Designed and developed a custom web add Hoch report module for MS Reporting Services.
WINDOWS 2000/XP, CITRIX, SQL SERVER 2000, VB.NET, SSRS, MAXIMO, VBA
Alithya: Papier Masson Ltée
Full stack developer
Gatineau, Quebec
August 2001 - December 2003
This project was for the complete reengineering of the original COBOL management systems used for the plant’s
production of newspaper.
Multi-tier architecture design using OO principles and design patterns;
Multi-tier architecture design using OO principles and design patterns;
Team Lead;
Software development using VB.NET;
Technical documentation writing;
Testing and deployment.
WINDOWS 2000, SQL SERVER 2000, CRYSTAL REPORTS 9, VB.NET, ASP.NET, WPF, WINDOWS NT, 2000, SQL
SERVER 7.0, CRYSTAL REPORTS 7.0, VISUAL BASIC 6.0 (VB6), INGRES 4GL, COBOL, PI, TRAQ MANAGER, CITRIX,
ACCESS
END OF PROJECTS COMPLETED FOR ALYTHIA
Alcatel
Full stack developer
Gatineau, Quebec
May 2000 - August 2001
Perform all software development task involving the of creation of various manufacturing and administrative software
for a high technology optical fiber company.
VB6, SQL SERVER, EXCEL, ACCESS
Bell
Technical support
Provide technical support to Bell Sympatico Internet services customers
Gatineau, Quebec
November 1998 - May 2000