RiskCheck

Project Information

RiskCheck is a Canadian environmental health and safety (EHS) risk management company that helps businesses mitigate risks, ensure compliance, and promote sustainability.
Established in 1999, it provides data-driven solutions for industries such as real estate, infrastructure, and government.

Website:

https://riskcheckinc.com/

Technologies:

ASP.NET Bootstrap JQuery Knockout Microsoft Enterprise Library Microsoft Entity Framework Microsoft SQL Telerik

My Role & Contributions

Solution Architect & Software Developer – RiskChek Project

In the RiskChek project, I played a pivotal role in designing and developing a scalable, high-performance system that efficiently manages over 120 database tables using ASP.NET, Microsoft Entity Framework, and Microsoft SQL Server. My primary contribution was building an automated application that generates DbContext models, enabling dynamic CRUD operations with enhanced features like pagination and ordering.   Key Responsibilities & Achievements 1. Automated DbContext Generation
  • Developed a system that automatically generates Entity Framework DbContext classes for every table in the database.
  • Simplified access to database entities by providing structured methods to:
    • Retrieve records by ID
    • Fetch paginated & ordered lists
    • Perform create, update, and delete operations
2. Backend Development with ASP.NET & Entity Framework
  • Architected a robust ASP.NET MVC application, ensuring a clean separation of concerns.
  • Optimized database interactions using Microsoft Entity Framework, enabling efficient data retrieval and updates.
  • Integrated Microsoft Enterprise Library for improved error handling and logging.
3. Frontend Development & UI Enhancements
  • Designed a responsive user interface using Bootstrap for intuitive navigation and seamless user experience.
  • Enhanced UI interactions with jQuery and Knockout.js, ensuring real-time data updates.
  • Leveraged Telerik controls for advanced grid views, filtering, and report generation.
4. Data Management & Performance Optimization
  • Implemented efficient pagination and ordering mechanisms to handle large datasets dynamically.
  • Optimized SQL queries and indexed key columns to improve database performance.
  • Developed a robust data validation system to prevent inconsistencies across the 120+ tables.