With over 30 years of experience developing software primarily for the Government of Canada, my background reflects both expertise and dedication. Recognizing the importance of staying current in the ever-evolving tech industry, I pursued a Bootcamp Certification at Carleton University last year, graduating with a remarkable 99%. This accomplishment highlights my commitment to continuous learning and adaptability, considering that I am an older man -I am willing to continue learning.
My main purpose in undertaking this course was to demonstrate my desire and ability to acquire new skills and remain productive, ensuring that I can effectively contribute to modern projects and meet contemporary challenges.
The program was rigorous and fast-paced, covering both the theory and practical application of web development. I successfully completed it, expanding my professional portfolio with a range of new tools and skills that strengthen my capacity to deliver impactful solutions.
I have been a developer-contractor for most of my live, starting on a Commodore 64/Basic connected to my black and white TV. I started working with xBase databases such Clipper, Dbase III/IV, Foxpro and finally to SQL Server.
The main reason why I created this Web-Resume is to demonstrate what I can do. This page was developed using the following technology:
ASP.Net Core Web (Model-View-Controller) in Visual Studio 2022, using .NET 6.0 framework and later updated to .NET 8.0
Entity Framework Database-first approach (Scaffolding) and EF migrations.
Microsoft Identity Authentication and Authorization. Authentication and Role base access with ASP.Net Core Identity.
Database access via Repository Pattern and Units of Work.
C# language, CSS Bootstrap 5.2, Font Awesome, dialog boxes via Sweet Alert.
New! Recently learned TypeScript and successfully migrated this website to TS.
Microsoft SQL Server 2019.
This Web-Resume has been designed to host multiple Resume profiles, but I will not make it available to other users. Perhaps this could change in the future, but for now the main focus is to develop a page that clients can see what I can do.
I am a Computer Programmer and Database Modeler with extensive experience in designing and developing business solutions and databases.
Designed and developed new Windows applications, as well as custom Office solutions across multiple Microsoft Office Suites.
Reverse-engineered, documented, and migrated legacy applications to modern platforms.
Built desktop applications primarily in Visual Basic and C# using various versions of the .NET Framework.
Developed web-based applications with C#, ASP.NET Razor Pages (MVC), and Microsoft Identity for authentication and role-based access.
Leveraged open-source frameworks such as CakePHP (MVC), alongside HTML, CSS (Bootstrap 4/5.2), JavaScript/JScript, Typescript and JSON/XML.
Modeled and designed databases using Microsoft Access, SQL Server (SSMS), and MySQL (Oracle), including tables, relationships, triggers, and T-SQL scripts.
Generated Data Definition Language (DDL) scripts to create, alter, and drop data structures.
Produced business and technical specifications, database models, UML diagrams, use cases, and other documentation.
Collaborated effectively as both a team member and independent contributor, working on-site or remotely.
Developer Note: This website is hosted on my own Windows Server 2016 and IIS 10.
Alternative Popover Control
On my website, you may have noticed some nifty controls such as Popover elements. I consider them one of the most effective visual tools for displaying additional information. A popover is a small overlay that appears when a user hovers over an element, providing context without disrupting the browsing experience.
This example is an Custom HTML Popover, this approach offers a convenient alternative method to display information. You can even have hyperlinks without navigating away from the current page.
OntarioTECK VBA Developers is a small organization incorporated to offer services to the government. My wife and business partners and I are the only ones in this company.
I am always learning something new, not because I like to, but because I have to in order to offer my skills effectively. The digital revolution has transformed virtually every area of human activity, making it essential to acquire new skills to stay at the heart of today’s dynamic workforce.
Carleton University Boot Camp is an intensive 24-week program that prepares you to build end-to-end web applications and become a full stack web developer. It features online classes and hands-on projects, all designed to fit within your busy schedule.
Here is a small list of Departments and Organizations I've worked with:
During my long career, I have worked for many government departments as well as in the private sector. I definitely enjoy working for the government, where projects, needs, and ideas are usually well-grounded. In other words, I jump right into the fast lane, learning their needs and developing their projects.
I have been a developer-contractor for most of my live, starting on a Commodore 64/Basic connected to my black and white TV. I started working with xBase databases such Clipper, Dbase III/IV, Foxpro and finally to SQL Server.
The main reason why I created this Web-Resume is to demonstrate what I can do. This page was developed using the following technology:
ASP.Net Core Web (Model-View-Controller) in Visual Studio 2022, using .NET 6.0 framework and later updated to .NET 8.0
Entity Framework Database-first approach (Scaffolding) and EF migrations.
Microsoft Identity Authentication and Authorization. Authentication and Role base access with ASP.Net Core Identity.
Database access via Repository Pattern and Units of Work.
C# language, CSS Bootstrap 5.2, Font Awesome, dialog boxes via Sweet Alert.
New! Recently learned TypeScript and successfully migrated this website to TS.
Microsoft SQL Server 2019.
This Web-Resume has been designed to host multiple Resume profiles, but I will not make it available to other users. Perhaps this could change in the future, but for now the main focus is to develop a page that clients can see what I can do.
With over 30 years of experience developing software primarily for the Government of Canada, my background reflects both expertise and dedication. Recognizing the importance of staying current in the ever-evolving tech industry, I pursued a Bootcamp Certification at Carleton University last year, graduating with a remarkable 99%. This accomplishment highlights my commitment to continuous learning and adaptability, considering that I am an older man -I am willing to continue learning.
My main purpose in undertaking this course was to demonstrate my desire and ability to acquire new skills and remain productive, ensuring that I can effectively contribute to modern projects and meet contemporary challenges.
The program was rigorous and fast-paced, covering both the theory and practical application of web development. I successfully completed it, expanding my professional portfolio with a range of new tools and skills that strengthen my capacity to deliver impactful solutions.
I am a Computer Programmer and Database Modeler with extensive experience in designing and developing business solutions and databases.
Designed and developed new Windows applications, as well as custom Office solutions across multiple Microsoft Office Suites.
Reverse-engineered, documented, and migrated legacy applications to modern platforms.
Built desktop applications primarily in Visual Basic and C# using various versions of the .NET Framework.
Developed web-based applications with C#, ASP.NET Razor Pages (MVC), and Microsoft Identity for authentication and role-based access.
Leveraged open-source frameworks such as CakePHP (MVC), alongside HTML, CSS (Bootstrap 4/5.2), JavaScript/JScript, Typescript and JSON/XML.
Modeled and designed databases using Microsoft Access, SQL Server (SSMS), and MySQL (Oracle), including tables, relationships, triggers, and T-SQL scripts.
Generated Data Definition Language (DDL) scripts to create, alter, and drop data structures.
Produced business and technical specifications, database models, UML diagrams, use cases, and other documentation.
Collaborated effectively as both a team member and independent contributor, working on-site or remotely.
Developer Note: This website is hosted on my own Windows Server 2016 and IIS 10.
OntarioTECK VBA Developers is a small organization incorporated to offer services to the government. My wife and business partners and I are the only ones in this company.
I am always learning something new, not because I like to, but because I have to in order to offer my skills effectively. The digital revolution has transformed virtually every area of human activity, making it essential to acquire new skills to stay at the heart of today’s dynamic workforce.
Carleton University Boot Camp is an intensive 24-week program that prepares you to build end-to-end web applications and become a full stack web developer. It features online classes and hands-on projects, all designed to fit within your busy schedule.
Here is a small list of Departments and Organizations I've worked with:
During my long career, I have worked for many government departments as well as in the private sector. I definitely enjoy working for the government, where projects, needs, and ideas are usually well-grounded. In other words, I jump right into the fast lane, learning their needs and developing their projects.
Database designing SQL Server 2016
This website's database was designed using SQL Server and managed through SQL Server Management Studio (SSMS). The development approach utilized is Code First, which allows us to focus on writing code and seamlessly deploy database changes. This method ensures that the database schema is derived from the application code, promoting a more agile and iterative development process.
A database is a structured collection of data that is stored electronically. Think of it as a digital filing system where information is organized in a way that makes it easy to retrieve, manage, and update. Databases are used to store various types of data, such as customer information, product details, transaction records, and much more.
We are all familiar with the concept: Garbage in garbage out!
Normalization is a process in database design that organizes data to reduce redundancy and improve data integrity. The goal is to ensure that each piece of data is stored only once, which helps maintain consistency and makes the database more efficient.
Here are some aspects that should be taken into consideration;
,
,
,
,
,
, and
.
Understanding these fundamentals will help you appreciate the role databases play in various applications and why they are crucial for managing data effectively.
Understanding these fundamentals will help you appreciate the role databases play in various applications and why they are crucial for managing data effectively.