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 and Designing a new Website or Desktop Application requires several key steps and considerations, I am using using ASP.NET and SQL Server as an examaple.

Designing a new website and database involves several key steps. First, define the project scope and identify the target audience to ensure the website meets user needs. Next, create wireframes and mockups to visualize the layout and design. Once the design is finalized, develop the front-end using HTML, CSS, and JavaScript. Simultaneously, design the database schema to organize data efficiently. Implement the back-end using server-side languages like PHP or Python, and connect it to the database. Finally, test the website for functionality, usability, and security before launching it. Regular maintenance and updates are essential to keep the website running smoothly.

Taking this website as an example (hundreds of hours invested in this site); I used ASP.Net 6 MVC, a framework for building web applications using the Model-View-Controller (MVC) design pattern. It the ASP.NET Core suite, which is a cross-platform, high-performance framework for modern web development. As the back-engine, I integrate 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