Position Description Technical Architect
Team Lead
Senior Programmer Analyst
DBA
System Administrator
Profile I am a fluently bilingual technical architect, team lead DBA and senior programmer analyst with over twenty-five years of experience in developing, converting, and enhancing application systems. I worked on several large-scale projects, where I applied the depth and breadth of my knowledge.
I am a consistent key contributor to the success of all team endeavors. My excellent communication and technical skills made me a valued advisor to co-workers and stakeholders on major projects. In my spare time, I familiarize and train myself with new technologies like Microsoft.Net development suite.
Overview
31
31
years of professional experience
Work History
Technical Architect
Department of, Defense
12.2017 - 07.2023
Design and implement device authorization and user authentication with Shared Services wireless engineering team using VMWare Workspace One to authorize devices and Aruba Networks Clearpass RADIUS system.
Deploy Asset Tracking application CMA-8 and integrate global GPS trackers, RFID and barcode scanners to track shipments between NATO partners across the globe.
Perform analysis of users in Active Directory to determine an approximate user count that could be eligible for portable devices across all military basses using Access, Excell, Powershell and C#. This information was used for budget planning purposes.
Remotely support the team of users attending NATO exercises using the CMA-8 application.
Create a lab environment in Amazon cloud to facilitate testing of new application versions.
Provide support and assistance to team members when troubleshooting issues with tablets, handheld devices, thermal label printers and using the various applications used by our group.
Senior Programmer Analyst
INAC, Indigenous Services Canada
08.2016 - 12.2017
Key deliverable: work on the EIS (Education Information System) as part of a multi-developer team to bring enhancements and fix defects
The users of this application use it to submit pre-filled PDF forms for such tasks as school enrollment nominal rolls, request for budgets for programs
There are approximately 40 different forms filled and submitted annually for both languages, and over 200 organizations submitting them
The solution was developed in VB.Net 4.5, MVC, CSLA, Windows Forms, Windows Enterprise Libraries, Visual Studio 2012, Team Foundation 2012
Update documentation for new team member developers
Analyze and fix defects for web site and desktop application used to synchronize the templates with the repository
Analyze, fix, optimize Unit Testing projects for solution
Implement continuous build with unit test execution on TFS 2015 Build server
Fix configuration profiles to allow automated multi-configuration builds.
Senior Programmer Analyst
Royal Canadian Mint
06.2016 - 02.2016
Key deliverable: development of the prototype Anti-Counterfeiting solution for the sale of bullion
This project would be deployed worldwide to dealers where clients purchasing bullion could authenticate their coins and receive an email certificate indicating its authenticity
The solution was developed using Visual Studio 2013, C#, WPF, ASP .Net Web API, SQL Server 2012, Windows Server 2012
Create the Functional Design document
Continue development of the prototype and convert it to the final commercial product
Create the SQL 2012 server database structure
Create the Database deployment scripts
Develop the WPF UI Client with C# code behind and MVVM
Customize automated TFS build process to package click once deployment for multiple configurations with digital code signing (Production, Development, QA, User acceptance).
Senior Programmer Analyst
Innovapost, Axio
09.2015 - 11.2015
Months
Key deliverable: development of a change request to Canada Post’s solution to manage Hold Mail requests
The change affected the Windows Form depot application, the internet ASP .Net Web site, the in-store WPF Client kiosk as well as web services to which other applications connect
In-depth unit testing was required to assert that the changes in the web services would function as required and not break as they are used by web sites available to the public across Canada
Create the Functional Design document
Create the Technical Design document
Implement the changes in the ASP .Net, C#, WCF Web Services with Visual Studio 2013
Create unit tests using C#
Update Oracle stored procedure
Create deployment scripts for Oracle.
Senior Programmer Analyst 2
Innovapost, Axio, Fund of Canada
09.2014 - 11.2014
Key deliverable: development of change request to Canada Post’s solution to manage mail redirection due to address changes, temporary mail forwards for both residential and commercial
This solution was created with ASP .Net, C# and uses complex business rules created as validation attributes to ensure that the data received from the residents was exact to not interfere with their mail delivery
This data also fed directly into the database / program that operates the automated mail sorters at Canada Post, so special care needed to be taken to ensure that nothing would interfere with that critical process
Develop change requests using ASP, C#, WCF, Oracle
Conservative
Team Lead
10.2011 - 08.2014
Application Development 3 years
Key deliverables: Building an in-house development team dedicated to the development of an in-house application that would replace the outdated version application which had been used for over 10 years
This team worked in conjunction with an established team of subcontractors hired to do the initial conceptualization and development of the application
Working together with the sub-contractor team lead, I oversaw the management of the development, testing and production environments which consisted of cloud hosted virtualized SQL and IIS servers
The product developed was a .Net Silverlight web application used to manage the donors and supporters of the party., with the following core modules:
Financial module for receiving and entering donations and membership purchases
Module for managing registrants for events such as the Conventions
Module for generating custom mailings and email blasts to supporters
A WPF application and WCF web services were also created to manage incoming transactions from third party sources (Telemarketing associates, donations web site) as well as transmission updates to constituent records
This application was used to first vet the transactions and then import them into the main database for processing with the Silverlight application
Responsible for the management of the TFS server and the migration from TFS 2010 to TFS 2013
The migration consisted of creating new instances of IIS and SQL server in the hosted cloud environment, installing and configuring TFS, SQL server and Sharepoint and then importing the data from the current environment
Setup and configuration of the build and deployment environment used by TFS to automatically compile the source code upon developer check-in to ensure that the quality of the code did not break other areas of the application
The database for the solution would house the entire electoral database of approximately 23 million records available to all political parties, as well as all the financial information for donations and contact details for reach out programs (e.g., phone and mail surveys)
The database and application would have to support a daily user base of approximately 300 users, and 1,500 -2,000 users during an election
Responsibilities:
Build, supervise and lead a team of 5 employees (1 DBA / Data Architect, 3 .Net developers, 1 report developer / backup DBA)
Manage Microsoft Team Foundation Server environment for the Development team
Manage the virtualized Development, Testing and Production environments
Automate the daily builds to the development and testing environments during the peak of the project development cycle
Synchronize changes to the Data Model to the Entity Framework model used in the project
Migration of TFS 2010 to TFS 2013
Management of TFS 2010 and TFS 2013
Take over and delegate responsibilities of outgoing subcontractors as team scaled down
Provide fit / gap analysis
Oversee and participate in the development of the principal Silverlight application
Oversee and participate in the development of a WPF transaction management application
Deployed two revisions of the main donations web site for the conservative party as well as the supporting database and server environments
Co-ordinate with the 3rd party web hosting service for configuration of the donations website
Manage and participate with the development of supporting applications developed with WPF, C#, SQL Server 2012
Technical Environment:
.Net 4.5; WPF; C#; Windows server 2008, 2012; IIS7; SSIS; Silverlight; ASP .Net; Windows Services; WCF; RIA; Visual Studio 2010, 2012, 2013; SQL Server 2000, 2008, 2012 R2; TFS2010
Senior Programmer Analyst
DND – ADM-IM
08.2010 - 10.2011
CFEMS Suite
I was brought back to DND to take the lead in the re-write efforts of the CFEMS Suite of applications from VB 6 to the modern .Net platform
For the application, the decision was made to use WPF, XAML and C#, for the middle layer, the Entity Framework 4.0 and SQL Server 2008 R2 for the database
Key deliverables: Learning and teaching the team of 3 developers the use of WPF, XAML, Entity Framework, SSIS
Redesign and architecture of the database, the middle layer and the interface
To assist the developers and reduce the time spent writing repetitive code, I created a code generator using Microsoft’s code template technology
This helped to reduce the amount of time required to write “boilerplate” code such as stored procedures, interfaces to business classes, apply basic validation such as data type and field length
Gave courses and seminars to the other developers of the team on the use of the Database Project type to manage large database structures, as well as the Entity Framework
I provided guidance and knowledge to all members of the group of 20 developers / DBAs on the use and configuration of the Microsoft technologies
The suite of applications was used across Canada by approximately 200 users
Provide leadership, guidance and knowledge to a team of developers as well as the entire group that the team belonged to
Provide analysis, design and programming for the development of CFEMS suite in Visual C#, XAML, Entity Framework, Dot Net 4.0 Framework, Enterprise Libraries
Prepare courses for other developers on the use of the new technologies
Lead demos to the end user / clients of the current state of the new application
Lead client requirement gathering sessions to clarify current processes and business rules
Develop the logical and physical models using Visio and SQL Server 2008 R2
Convert the database from the original CFEMS Suite (SQL 2000) to SQL Server 2008 R2 using SSIS
Create the front end of the application
Manage TFS 2008 environment
Lead and mentor a team of 3 developers
Provide analysis and estimates
Provide fit / gap
Create the Functional and Technical design documents
Designed data model using Visio, SQL Server and Visual Studio Database project
Designed and programmed Data layer using .Net C#
Designed and programmed Business Login Layer using .Net and C#
Designed and programmed Interface layer using WPF, C# and MVVM
Designed and programmed a code generator to assist with the repetitive code functions of the Business and Data layers, and the stored procedures
Assisted with the creation and writing of specifications
I was brought on to a team of 3 developers to convert legacy VB-6 applications to more modern Visual Basic .Net platform using the 3.5 .Net Framework and using a Sybase 15 database as the back end
This suite of applications consisted of a Windows Form client, as well as a group of 6 command line batch applications used to import financial transactions received from the National Bank, process and prepare export files to satellite regional centers, process and prepare export files or the corporate SAP financial system
Key deliverables: Converting legacy code to more modern methodologies, Extracting inline SQL statements from the application and converting them to database stored procedures
Streamlining the source code to remove repeated code modules from the individual applications and consolidate them into one shared DLL to facilitate future maintenance of the applications
Mr
Plamondon participated and provided analysis for new requirements as well as optimized the performance and business rules of existing processes
Mr
Plamondon provided analysis and re-engineering of the data model in 3NF (third normal form) using SQL Server to remove multi-key indexes and foreign joins between tables, as well as use SSIS to convert the data from Sybase to SQL Server
Reviewed existing application processes and re-engineered the structure of the application to comply with Object Oriented programming standards
Develop applications using Visual Basic.NET
Visual Basic .Net expertise and training / mentoring to the developer team
I was contracted by Canadian Facilities Security (CFS) to develop a prototype Asp.Net website to track and schedule the maintenance of the door for all LCBO locations across Ontario
This project was engineered to follow the nTier architecture, with a business layer to house all of the business rules, a data layer to handle all of the connections to the database and an interface layer for the presentation to the users
The data layer was structured around Microsoft’s Entity Framework to handle the core connections and operations, and using partial classes and inheritance, custom data objects were created to act as an interface to the business layer
The Database scripts were managed using Microsoft’s .Net Database project
Developed website using ASP.Net, HTML, CSS and C# for the business and data access logic
Used SQL Server and Visual Studio to develop database logical and physical models in 3NF
The database was created using SQL Server 2008
Although the web site was for a private company, some of the standards for CLF 2.0 were used to develop the interface
Technical Environment:
C#, Entity Framework, SQL Server 2008
Senior Programmer Analyst
DND – ADM-IM
04.2008 - 10.2009
CFEMS Suite
I was brought into DND to take over the maintenance and continued development efforts for the application suite that manages the work orders of approx 27 detachments in Canada, as well as cyclical maintenance scheduling, shop store inventory purchasing and dispensing
This suite is a large scale (300+ forms) composed of 3 separate client server applications written in VB6: (M1)
The three include: CFEMS, CMMS, and CESS with SQL Server 2000 (200+ stored procedures) as a backend
Key deliverables:
- Maintenance and continued development of a centralized .Net portal for the CFEMS application
Lead developer in the re-write efforts to centralize and modernize the suite of applications (CFEMS, CESS, CMMS) into a .Net platform using ASP.Net and VB.Net as well as their individual databases form SQL Server 2000 to SQL Server 2008
Develop web interface (CFEMS Web) along with the desktop applications
Provide analysis and documentation for new requirements, as well as implement changes using ASP.Net and SQL server 2000
Provide analysis, design and programming for the development of CFEMS suite in Visual Basic 6, and CFEMS Web in ASP.Net, HTML, CSS
The logical and physical models were maintained and optimized using ERWIN
Maintain the existing database in SQL Server 2000
The database was converted to SQL Server 2008
CFEMS Web was modified to conform to CLF 2.0 standards
Provide analysis as well as estimates to the client for all changes requested by the end user
Evaluated and re-architected the database structure of the 4 separate databases and merged them into one data model using SQL Server 2008
Documented functional specifications for release of CFEMS
Documented functional specifications for release of CESS
Documented functional specifications for release of CMMS
Evaluated and commenced re-writing efforts from VB6 to .Net for CFEMS
Evaluated and commenced re-writing efforts from VB6 to .Net for CESS
Evaluated and commenced re-writing efforts from VB6 to .Net for CMMS
Programmed maintenance release of the Web Portal CFEMS Web application in ASP .Net as VB.Net while adhering to CLF 2.0 standards and guidelines
Designed and programmed new functionality for CFEMS Web portal
Programmed the maintenance release of CFEMS in VB6
Programmed the maintenance release of CESS in VB6
Programmed the maintenance release of CMMS in VB6
Performed unit testing on all changes and new development
Implemented usage of the .Net test project to assist with the unit testing and code coverage of the development
Documented functional specifications for maintenance release of CFEMS Web
Evaluated and planned the data migration from the 27 detachments to the central database
Evaluated and fixed issues reported by the user base with the 3 applications comprised within CFEMS Suite
Evaluated and fixed issues reported by the user base with the central portal
ASP.Net, C#, SQL Server 2008, T-SQL, Team Foundation, Reporting Services, Visual Studio Database Projects, SSIS, ERWin, VB6, VB.Net, SQL Server 2000, Source Safe, DTS, Crystal Reports.
Senior Programmer Analyst
DND – ADM-IM
01.2007 - 03.2008
CAISS
Development lead for the redevelopment of the in-house issue tracking system CAISS from classic ASP to ASP.Net and C#
This project was engineered to follow the nTier architecture with a business layer to house all business rules, a data layer to handle all of the connections to the database and an interface layer for the presentation to the users
The data layer was structured around Microsoft’s Entity Framework to handle the core connections and operations, and using partial classes and inheritance, custom data objects were created to act as an interface to the business layer
I implemented the use of Microsoft’s new Database Project type to manage all of the scripts used to create the SQL 2008 database, stored procedures, keys and constraints as well as ensure that they were all protected by Team Foundation source control
Designed, developed website using ASP.Net and the Net Framework 3.5, HTML, CSS, XML
Developed logical and physical models using ERWIN and SQL Server 2008
Convert the database from the original BASS application to SQL Server 2008 using SSIS
Create the front end of the application adhering to the CLF 2.0 standard
Lead and mentor a team of 3 developers;
Provide analysis and estimates;
Designed data model using ERWin, SQL Server and Visual Studio Database project;
Designed and programmed Data layer using .Net C#;
Designed and programmed Business Login Layer using .Net and C#;
Designed and programmed Interface layer using ASP.Net and C#;
Designed and programmed a code generator to assist with the repetitive code functions of the Business and Data layers, and the stored procedures;
Assisted with the creation and writing of specifications
Provided fit /gap analysis
ASP.Net, C#, SQL Server 2008, T-SQL, Team Foundation, Reporting Services, Visual Studio Database Projects, SSIS, ERWin, VB6, VB.Net, SQL Server 2000, Source Safe, DTS, Crystal Reports.
Programmer Analyst
Lafarge North America
10.2004 - 07.2006
PIR - I was brought into Lafarge to automate various manual processes
These processes include the automated creation of Word and Excel documents based on statistical production information for the various cement manufacturing plants; the creation of Excel workbooks with Sales and Marketing data
All of these reports must be published to the corporate Cognos UpFront portal, and were developed with the Microsoft Visual Studio .Net, VB.Net and Aspose
Providing technical advice and estimates to clients on a wide variety of requirements
Provide technical advice on use of 3rd party tools (Aspose) for creation of Excel documents
Gathered requirements and developed detailed specifications;
Developed and designed VB.Net 2003 application to extract data from the Oracle database and populate the Aspose reports;
Wrote detailed user guide
VB.Net, Cognos UpFront, Aspose, Oracle.
Lead Senior Programmer Analyst
CGI
05.2004 - 09.2004
Promotional Item Tracking System
I was responsible for the development of a Visual Basic.Net application to assist the marketing department to manage the inventory of promotional items
This system would track both internal and external requests, orders with vendors, shipments received, requests filled, and inventory on hand
This system would have both a dedicated client as well as a web interface for the submission of requests
Gathered requirements and developed detailed specifications;
Created the PC client using VB.Net and Access 2002 for the database.
Lead Senior Programmer Analyst
Track And Trace
03.2004 - 04.2004
Track And Trace - I was brought into the team to assist with the delivery of change requests brought by the client for customizations that were to be done to the Track and Trace application
These changes included the development of a new interface to handle large volume receiverships (LVR), new Crystal Reports to print out the LVR’s as well as some performance issues with the XML generators when processing large quantities of receivers (10,000 +)
Optimized XML processing code in VB6;
Reduced processing time of 10,000+ records from 1 hour+ to approximately 2 minutes;
Developed 3 new Crystal List Reports;
Developed 10 SQL Server Stored Procedures;
Resolved a number of major technical issues that were discovered during testing;
Developed and translated Visual Basic 6 application to Visual Basic .Net
VB6, VB.Net, SQL Server 2000, T-SQL, Crystal Reports, XML., FINPER Construction Project
Worked in conjunction with the DBA to develop the logical and physical data models in 3NF using ERWIN
Converted database from flat file exports to SQL Server 2000
Evaluate and analyze the requirements gathered by the BA and provide estimates to the client
Developed the prototype and then lead a team of 4 developers in expanding on the prototype to develop the fully functional application for the client using nTier technology consisting of VB6, DCOM+ and SQL Server;
Analyzed the original legacy Powerhouse code and ensured that business rules which the end user May not have been aware of were not omitted from the final application;
Served as interim DBA and was responsible for the development and maintenance of the physical and logical data model using ERWin, migration scripts, 100 DTS conversion scripts, and over 200 stored procedures and functions;
Assisted the Project Manager in developing the project plan using Microsoft Project;
Led use case review sessions with the business owners at the client site for the individual components of the applications to further refine the business rules and behaviour of the application and gather any missing requirements;
Build manager of the application, responsible for compiling the application and deploying to the QA team as well as the milestone releases to the client site;
Chaired the bi-weekly meetings with the client to review the project progress
VB6, COM+, SQL Server 2000, DTS, T-SQL, ERWin.
Lead Senior Programmer Analyst, Commissioner
CCRA, Judicial Affairs, OCFJA
02.2004 - 02.2004
Public Opinion Research & Environment Analysis (POREA): Document Management System
Key deliverables: Responsible for the development of the Visual Basic application, as well as all stored procedures on the SQL Server to access the information stored in the database
Responsible for the development of the user guide, the deployment / installation package, and the installation at the client site as well as the training of the individual users
Developed the VB 6.0 application Interface;
Developed SQL Server Stored Procedures required for the interface and the reports;
Developed 6 Crystal List Reports;
Wrote the user guide for all CCRA users of the application;
Deployed the application at the client site;
Trained all of the CCRA users on the use of the new application
VB6, SQL Server 2000, T-SQL, Crystal Reports
Office of the, of Federal
support – Specialist
Conservative Fund of Canada
03.2002 - 01.2004
Key deliverables: Ongoing support for the development team as well as development and production infrastructure hosting web services
Assisted the finance group during the annual audit to provide analysis of the financial transactions and answer questions about special cases raise by the auditors
Migration of the Team Foundation server to repatriate it from a hosted service to an internal server
Post-mortem analysis of deployment issues that occurred during a failed deployment to production
Provide ongoing technical support for the production environment hosted by a third party
Provide guidance and assistance to the Windows development team
Decouple web service project written in C# from the decommissioned main project to an independent web service capable of receiving transactions generated by donations website
Provide analysis and technical expertise to the finance department during the annual audit
Assist with development of enhancements to the WPF transaction management application
Prototype MVC application.
Senior Programmer Analyst, Senior Developer
Saudi Arabian Oil Company, Saudi Aramco
02.2000 - 05.2001
User Interface Team
Reviewed and finalized in Visual Basic 6.0 over 100 forms from translated legacy ABF system;
Translated twenty some FORTRAN programs to VB 6.0;
Reviewed and debugged over 100 Active Reports;
Tested, debugged and optimized the proprietary controls generated by the conversion tool;
Trained 5 new developers;
Served as a key advisory resource for other developers to assist them with problems;
Selected as member of deployment team to install the new system in Dhahran, Saudi Arabia;
Coached the Saudi client’s development staff in maintaining the system
VB6, Active Reports.
Programmer Analyst
Viascan
07.1998 - 10.1999
Astral Automated Product Return System
Develop a VB 6 application to control a conveyor system where products being returned would be dropped on a feeder belt, pass through an omnidirectional scanning tunnel with seven scanners and then pass by a pneumatic ejection arm which would push rejected products to a secondary return conveyor
Respond to input from controller module communicating with a control card on the computer
Verify product scanned against list of products sold to customer
Reject any that were not shipped to client
Transfer results to server
Le Chateau Inventory Control
Develop an interface in VB6 that displays status of connected wireless devices out in the warehouse for taking inventory
When a device connected, a status screen with simulated LED indicators would indicate send and receive data transmissions
Maintain a C application for the wireless scanner devices that control the inventory of bolts of cloth destined for the sewing department.
Programmer Analyst
VB6, C, Socadis
01.1993 - 07.1998
Develop a VB 6 application for the sales team with the catalogue of products for sale on first generation pen tablets and Windows 3.1
Program a controller module that controls an automatic label applicator on a conveyor belt to apply price barcode labels to products
Manage and maintain the PC hardware
Manage and maintain the thermal ribbon label printers used for shipping labels as well as product items.
Administrative Assistant at Department of Defense - Defense Contract Management AgencyAdministrative Assistant at Department of Defense - Defense Contract Management Agency
Student Intern at Department of Defense - Defense Counterintelligence and Security AgencyStudent Intern at Department of Defense - Defense Counterintelligence and Security Agency