neil ramrattan

Project: Maintain and enhance GAC’s online information management tools that administers global resource management, procurement, personnel and various other requirements. Responsibilities: • Update/Create code in Razor views (.cshtml) as per user story requirements • Update/Create C# code in models of domain objects with Entity Framework as the ORM • Update/Create LINQ queries in application Repository, Service layers • Update/Create C# code in Viewmodels, models; Dependency Injection, UnitOfWork, Repository, Service layer design patterns • Create Unit tests using MSTest • Alter/update SQL Server tables and data as required • Utilize the Web Experience Toolkit as the basis for consistent look and feel in UI development in order to comply with Web Content Accessibility Guidelines (WCAG 2.0) AA • Collaborate with Business Systems Analyst and Product Owner during sprint planning meetings to carefully understand user stories and requirements

NexGenRx is a Canadian claims adjudicator, serving plan sponsors, insurers and pharmaceutical companies to pioneer new paradigms for delivering group drug, dental and extended health plans, as well as pension plans. Project: Build a proof of concept website to modernize NexGenRx’s claims adjudication web application that serves thousands of plan members daily, from ASP.NET Webforms to ASP.NET Razor views with .NET Core 6.0 Responsibilities: • Convert Web Forms to Razor views: Rewrite existing Web Forms (.aspx) pages and user controls (.ascx) using Razor syntax (.cshtml files) • Refactor code-behind files (.aspx.cs files), to use the appropriate models, controllers, and views in the .NET Core project. Remove dependencies on Web Forms-specific features and controls • Replace the Web Forms server controls with their equivalent Razor-based counterparts/HTML helper tags • Update some data access in Web Forms like ADO.NET to their respective .NET Core version of Entity Framework Core for database access • Create Unit tests; utilize .NET Core endpoint routing system, dependency injection, middleware pipeline • Code/update SQL Server stored procedures/functions • Collaborate with Business Systems Analyst and Product Owner to carefully understand user stories and requirements

• Code/update SQL Server Integration Service packages for ETL of Oracle, SQL Server and MS Excel workbooks • Create/update SQL Server functions, stored procedures or triggers as per business requirements • Ad hoc SQL scripting and data analysis • Write/update technical and user documentation for supported applications