OntarioTECK VBA Developers

Developed in ASP.NET Core 6 Razor MVC

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 a new web or desktop application involves several key steps and considerations, I am using using ASP.NET and SQL Server as an examaple. In the inirial steps, we need to define the need which will lead to defind the project requirements and scope to ensure a clear understanding of the application's purpose and features.

The process requires, the definition of the application architecture, keeping always in mind scalability, security, and performance. Once that is define, we need to decide the what and how of the implementation, meaning what are we using.

Taking this website as an example; I used ASP.Net 6 MVC, a framework for building web applications using the Model-View-Controller (MVC) design pattern. It is part of the ASP.NET Core suite, which is a cross-platform, high-performance framework for modern web development. As the back-engine I integrate SQL Server for robust data management, including database schema design, indexing, and query optimization.

Thank you for visiting my Web-Resume application. This application was developed a while back using two interfaces; the one you are seeing here -ASP.Net 6 MVC, and another one designed in ASP.Net 7 MVC. This application was designed to invite possible clients to see what I can do in web designing.

The application was designed as "code-first" approach, and still is. It is a methodology in software development where the primary focus is on writing code first before considering other aspects like database design or API specifications. Among some of it's benefits we have; I like the most is "Focus on Code". Code First may not be the best option, when we have many different environtments (Development, Staging and Production), which means different groups managing their operations. The changes to database need to go through their filtering process such as; Risk Analysis and Tests.

The concepts of Unit of Work and Repository are commonly used in software development, particularly in the context of data access and persistence. The Unit of Work pattern is used to manage transactions and ensure data consistency. Using this framework requires the use of Repository pattern, which is used to abstract the data access layer, providing a cleaner and more organized way to interact with the data source.

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