OntarioTECK VBA Developers

Developed in ASP.NET Core 6 Razor MVC - 2025/26

Client Image

Gustavo Miller

Updated on: 2022-11-26 8:37:53 PM

OntarioTECK VBA Developers
System Analyst - Developer
gustavo.miller@miller-hs.com
Telephone: (613) 600-2661

Developing and Designing a Website or Desktop Application

Using ASP.NET and as a practical example -hover your mouse over top of the word SQL Server, a 'timed' popover will display giving the user additional information.

Building a new website or desktop application involves several key steps and considerations. The process typically begins with defining the project scope and identifying the target audience to ensure the solution meets user needs. From there:

  • Design Phase: Create wireframes and mockups to visualize layout and user experience.
  • Front-End Development: Use HTML, CSS, and JavaScript to build the user interface.
  • Database Design: Develop a schema that organizes data efficiently and supports scalability.
  • Maintenance: Regular updates and monitoring are essential to ensure long-term performance and reliability.

Design Patterns: Unit of Work and Repository

To ensure clean architecture and maintainable code, I implemented:

  • Unit of Work: Manages transactions and maintains data consistency across operations.
  • Repository Pattern: Abstracts the data access layer, providing a structured and testable interface for interacting with the database.

These patterns promote separation of concerns and make the application easier to extend and maintain.

My Web-Resume Application: A Real-World Example

This site represents hundreds of hours of development and showcases my capabilities in full-stack web design. I used ASP.NET 6 MVC, part of the ASP.NET Core suite, which is a cross-platform, high-performance framework built around the Model-View-Controller (MVC) design pattern. For data management, I integrated SQL Server, focusing on schema design, indexing, and query optimization.

The application includes two interfaces:

  • This Web Application, was built with ASP.NET 6 MVC
  • A second version developed in ASP.NET 7 MVC

This dual-interface approach demonstrates my adaptability and commitment to continuous improvement.

Read More…

Share Services Canada (SSC)

Current project since 01-Apr-2025

In early 2020, a new Branch was created within Shared Services Canada, merging Communications Branch and Strategy Branch to form the Strategic Engagement Branch. A core objective of Strategic Engagement Branch is to lead the transformation of Shared Services Canada to align with the SSC 3.0 vision, priorities, and objectives while promoting service design and delivery innovation and the associated change management that accompanies transformation and manages the people side of digital and IT enablement.

Within the Branch, the Enterprise Transformation Office and Strategic Communications Office are championing a people-first work culture, improving and optimizing design and delivery (in partnership with CIO branch), and delivering SSC’s digital government mandate. Strategic Engagement Branch supports the people in the organization in making the necessary changes to adopt new ways of working, including a new departmental culture that embraces change management, communications, employee engagement, and training to support the transformation agenda, continuous improvement, and agile ways of delivering.

While some branches within SSC have their own change management function, establishing a consistent, department-wide practice is key to implementing the transformation agenda, and a significant amount of change management, service design, and communications support is required to successfully implement the SSC 3.0 transformation agenda and ensure its success. Similarly, an enterprise-wide user experience design strategy function is required to enable the department to effectively meet the requirements of the GC Policy on Service and Digital while embedding an empathy-based foundation to design and deliver user-centered services that meet user needs, reduces complexity of services, and measures their successful uptake over time.

Read More…

Services

In today's fast-paced and ever-evolving technological landscape, offering a diverse range of services is crucial to meet the varied needs of clients. By providing a comprehensive suite of services, from software development and database management to DevOps and version control, I ensure that clients receive tailored solutions that address their unique challenges. This holistic approach not only enhances efficiency and productivity but also fosters long-term partnerships built on trust and reliability. My commitment to delivering high-quality services is underscored by my extensive experience and proficiency in utilizing cutting-edge technologies and best practices.

SQL Server

For this Web-Resume I have used the Database-first aproach and let Entity Framework create the POCO objects using Scaffold-dbContext methods.

Bootstrap CSS

All pages and forms have been designed using Bootstrap CSS 5.2 version

Repository Patterns

We use this method to mediate between the domain and data mapping layers, in this case using Entity Framework.

Entity Framework

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects