C# .Net Core

NEIL RAMRATTAN *************@*****.***

416-***-**** linkedin.com/in/neil-ramrattan-04861b29

QUALIFICATIONS SUMMARY

I have over 20 years of experience within the private and public sector, in application development with both Scrum/Agile and SDLC software development methodologies and working in Azure DevOps, CI/CD environments. I also have strong programming experience in C#, VB.NET, SOA, JavaScript, Angular 5, HTML, T-SQL, PL/SQL. I have extensive experience in OOP, Entity Framework, ADO.NET, LINQ, TDD, Design Patterns etc. In addition, I have experience in services technologies such as SOAP, REST, XML, WPF, WCF, JSON and Web API.

TECHINCAL SKILLS

Languages: C#, VB.NET, Angular 5/12, Typescript, JavaScript, JQuery, VB Scripting, PL/SQL

Databases: SQL Server, Oracle 10g/11g

Source Control: TFS, Github

Web: ASP.NET, MVC, Webforms, MVP, .NET Core, Razor views, Angular 5/12, XML, XAML, HMTL5, Bootstrap, CSS

Desktop: WPF, MVVM, Winforms

Applications: SSMS, MS Excel, MS Word, MS Powerpoint, MS Access, MS Visio, Adobe Lightroom

IDEs: Visual Studio, VS Code, Eclipse, PL SQL Developer, Azure DevOps, CI/CD

EDUCATION

Diploma in Computer Programming, Database and Internet Solutions Developer May 2000

The Institute for Computer Studies, Toronto

SECURITY CLEARANCE: Level III (Top Secret). File# 96313972-0003041184

RELATED WORK EXPERIENCE

.NET Developer (contract) Global Affairs Canada, Ottawa, Ontario March 2024 – Feb 2025

Global Affairs Canada (GAC) manages Canada's diplomatic and consular relations, promotes Canadian international trade, and leads Canada's international development and humanitarian assistance. It is also responsible for maintaining Canadian government offices abroad with diplomatic and consular status.

Tools and technologies: Visual Studio 2019, .NET 4.8.2, C#, .NET Core 6.0, JQuery, AJAX, Razor views, Entity Framework, MSTest, Moq, SQL Server 2019, T-SQL, OOP, ASP.NET MVC, Git, Onion Architecture application design, Azure DevOps, Agile development

Primary Project: Maintain, enhance and provide application support to GAC’s online information management tools (SIMS), that administers global resource management, procurement, personnel, emergency management protocols and special resources.

Responsibilities:

Created/updated Razor views (.cshtml) responsive web application, as per user story requirements

Created/updated LINQ queries in the application Repository and Service layers

Created/updated C# code in Viewmodels, models, UnitOfWork, Repository; Service layer design patterns, Dependency Injection; Test Driven Development using MSTest, Moq.

Created/updated SQL Server tables and data; C# code in models of domain objects with Entity Framework

Created/updated Jquery or Javascript functions to enable a consistent user experience.

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, daily standups and sprint retrospectives

Provided support during testing and QA phases for new features and fixes

Utilize Azure Dev Ops to create tasks for user stories/bug tickets to plan daily work activities

Secondary Project: NEICS and NEXCOL web applications are critical to administering and maintaining Canada’s import and export of goods and adhering to trade agreements with other countries.

Responsibilities:

Backfilled the role of Software Solutions Architect and produce a report for management that would recommend a series of enhancements for NEICS and NEXCOL applications

Conducted interviews with stakeholders (and other research), and assessed new features that would form the basis of development work for the next 18 months

Documented and presented enhancements to the director which included: Use of online payments with Moneris; Creation of a document management feature; Use of Artificial Intelligence for document scanning to produce easily searchable content to expedite import and export permits for industry; Integration with the CRA in order to facilitate communication with the CBSA

.NET Developer (contract) NexGenRx, Toronto, Ontario Nov 2022 – Feb 2024

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.

Tools and technologies: Agile Development, Visual Studio 2017/2022, Internet Information Services (IIS) 8 and 10 .NET 4.0/4.8.1, VB.NET, C#, .NET Core 6.0, OOP, Bootstrap, Javascript, Razor views, ADO.NET, Entity Framework Core, TDD, MSTest, SQL Server 2019, T-SQL, ASP.NET Webforms, Web API, SOAP, Web Services, REST, MVC, Bitbucket, Git

Project: Built 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:

Converted ASP.NET Web Forms to a more responsive web application with Razor views: Rewrite existing Web Forms (.aspx) pages and user controls (.ascx) using Razor syntax (.cshtml files)

Refactored code-behind files (.aspx.cs files), to use the appropriate models, controllers, and views in the .NET Core project. Remove dependencies on ASP.NET Web Forms-specific features and controls

Replaced ASP.NET Web Forms server controls with their equivalent Razor-based counterparts/HTML helper tags

Updated ASP.NET Web Forms with ADO.NET to their respective .NET Core version of Entity Framework Core for database access

Updated XML Web Services to expose new functionality and data contracts to client consuming applications

Practiced Test Driven Development using MSTest, NUnit, Moq tools

Utilize .NET Core endpoint routing system, dependency injection, middleware pipeline

Created SQL Server stored procedures/functions

Collaborated with Business Systems Analyst and Product Owner to carefully understand user stories and requirements

Supported testing and QA efforts and provided immediate feedback and bug fixes when needed

Documented application technical design changes and conducted knowledge transfer sessions with the junior developer

I.T Consultant This Great City, Hamilton, Ontario Jan 2022 – Nov 2022

This Great City is Canada’s business networking engine.

Tools and technologies: Visual Studio 2019, Internet Information Services (IIS) 7 or 8, .NET 4.7, VB.NET, C#, .NET Core 2.0/3.0, Razor, ADO.NET, MS SQL Server 2017, Excel, Power BI, WinForms, ASP.NET, Django, Web API, SOAP, MVC, MVP, Angular 5, Python, Adobe Lightroom

Responsibilities:

Updated ASP.NET MVC, Webforms, WinForms, Angular 5 in B2B and B2C type applications

Advise small businesses on their software requirement needs

Data analysis for small business intelligence reporting

Application Support for small business (desktop, web, MS Access, Excel)

Write/update technical and user documentation

.NET Developer (contract) Axis Capital, Halifax, Nova Scotia April 2021 – Aug 2021

Axis Capital underwrites special risks Property & Casualty reinsurance products worldwide

Tools and technologies: Visual Studio Code, Angular 12, Typescript, Visual Studio 2019, .NET Core 3.1, Azure dev ops, C#, CI/CD pipelines

Responsibilities:

Code Angular components as per user story requirements

Create/update .NET Core REST api services consumed by client Angular application

Publish .NET Core api to Docker container registry in Azure

.NET Developer (contract) Canada Life, Toronto, Ontario June 2019 – Dec 2020

Canada Life Financial Corporation offers life, health, and disability insurance for groups and individuals.

Tools and technologies: Visual Studio 2017, TFS, .NET 4.7, .NET 5, VB.NET, C#, .NET Core 2.0/3.0, Razor, ADO.NET, Oracle 10g, PL/SQL, MS SQL Server 2017, Agile Development, OOP, WinForms, XSLT, XML, ASP.NET, Web API, SOAP, MVC, MVP, Angular 5, ETL, PL SQL Developer, SSIS

Project: Compliance needed a way to identify possible terrorist financing to comply with OSFI rules. Given an excel file of suspected names to be compared with existing policy holder names, to produce an actionable report.

Responsibilities:

Created ASP.NET MVC Web applications, Webforms, WinForms,

Created Oracle functions, stored procedures or triggers as per business requirements

Coded XSLT and XML to create html report documents

Coded ETL pensions applications to extract data from flat files; cleanse data, map elements, apply business rules and load into data warehouse

Ad hoc SQL scripting and data analysis using PL SQL Developer tool

Application Support (desktop, web, MS Access, Excel), used by multiple internal and B2B clients

Wrote technical and user documentation for supported applications

Participate in daily team standups in an agile development environment

.NET Developer (contract) Laborie Medical Technologies, Mississauga, Ontario Jan 2018 – May 2019

LABORIE is an industry-leading manufacturer and supplier of pelvic health and gastrointestinal equipment and consumables.

Tools and technologies: Visual Studio 2017, Azure DevOps, CI/CD, .NET 4.7, C#, WPF, MVVM, MS SQL Server 2017, Entity Framework 6.0, LINQ, T-SQL, Scrum/Agile, UML, ReSharper, Moq, VSTS, Design Patterns, TDD, Concurrency, Multi-threading, SignalR, Rx.NET

Project: Synergy is Laborie’s next generation desktop Urology suite that will enable doctors to perform urology diagnostic procedures with their medical devices to record, review results and report.

Responsibilities:

Coded/updated Xaml files and corresponding ViewModels, and Models to satisfy user story requirements

Coded/updated interfaces/classes; utilized inheritance and override base methods where appropriate

Add/updated objects within Entity Data Models (Entity Framework)

Coded/updated LINQ queries

Created .sql files and update .wxs files to inject CRUD operations into application install process

Build release code and check in to TFS main branch; branching and merging; Continuous Integration/Continuous Delivery.

Coordinate with Test Automation team on automated smoke tests and resolve problems

Perform user story refinement, finalize and create tasks using Azure DevOps boards

Update Software Design Documents before and after completion of user stories

Perform feature demonstrations to BA’s, Product Owners and Verification team

Test Driven Development, utilizing the Moq framework, maintaining coverage at 80%+

Update hardware emulator service that connects to the desktop application

Perform code reviews of other developers’ work

Collaborate with software architects on application design best practices and optimization

Utilize design patterns such as MVVM, Dependency Injection (IoC), Repository, Unit of work, Factory

Work with the Break Fix team to resolve bugs

Familiarity with Lightning Charts (Arction) for graphical display of studies’ channel data

Familiarity with GDPR, HIPAA act and FDA rules as they pertain to software development practices

Participate in sprint planning, daily standups

Data Strategist Consultant Pax Cultura Studios, Toronto, Ontario July 2017 – Oct 2017

Pax Cultura Studios consulting helps clients to create their own data science solutions.

Tools and technologies: Linux, Spark SQL, Scala, Python 2.7, PySpark, Java 7, JSON, Django, micro services

Responsibilities:

Documenting client requirements and creating user stories

Update Spark SQL and Scala scripts for Dataframe manipulation and filtering

Update Python scripts to train machine learning models and test accuracies

.NET Programmer Analyst (contract) Scotiabank, Toronto, Ontario Jan 2016 – Sept 2016

Scotiabank is Canada’s international bank and a leading financial services provider in North America, Latin America, the Caribbean and Central America, and parts of Asia.

Tools and technologies: Visual Studio 2010/2015, TFS 2008/2015, IIS 7, .NET 3.5/4.0/4.5.2, C#, ASP.NET, .NET Core 1.0, REST, OOP, Web API, MVC, MVP, MVVM, MS SQL Server 2012, ORM/Entity Data Model, LINQ to SQL, RBAC, NuGet, SOAP, WCF, SOA, T-SQL, Agile, Web Services, WSDL, XML

Project: Enhanced Due Diligence Unit Case Management (EDDU). The EDDU application allows case officers to assess new/existing business client profiles with respect to Anti-Money Laundering and other potential risks. Mitigating such risks allows the bank to be compliant with regulators and auditors. The development team was tasked to upgrade the application to accept and process new streams of account data.

Responsibilities:

Created/updated SQL Server database tables with entity relationships, within the existing data warehouse

Coded/modified SQL Server stored procedures to read/insert/update

Coded in C#, an ASP.NET web service to receive SOAP messages, validate incoming data using business rules to create/update records and provide JSON/XML responses. SOAPUI for testing calls.

Developed/modified Model View Controller, Model View Presenter pages to enhance the existing application to conform to new business rules

OOP in C# with ORM to implement LINQ to SQL queries, as well as insert and update records

Utilized .NET Sequential Workflow and Rulesets to implement a client Risk Rank Model to help case officers determine the risk level of client profiles

Prepared software release packages for change management process to production environment

Prepared/updated application documentation and upload to SharePoint portal

Provided technical support for internal applications used by various departments from the branch to accounting and periodically updated Role-Based Access Control (RBAC) in applications using the Azman utility.

Participated in daily scrums, product backlog grooming sessions, sprint reviews and code walkthroughs

Understanding of AODA / ADA (Accessibility) based on WCAG 2.0 Standards for web

Migrated application code from TFS 2008 to TFS 2015 with Visual Studio 2010/2015

.NET Developer (contract) EZ-Results, Toronto, Ontario Oct 2015 – Dec 2015

EZ Results is an internet marketing firm focused on inbound digital marketing, website development, SEO, SEM and CRM applications.

Tools and technologies: Visual Studio 2013/2015, C#, ASP.NET, Webforms, MVC, REST, Web API, Entity Framework/LINQ, AJAX, XML, JSON, CSS, HTML5, Bootstrap, SQL Server 2008 R2, IIS 6/7 on Windows Server 2008, T-SQL

Responsibilities:

Troubleshoot code defects; analyze application vulnerabilities and fix

Coded/updated website as per client requirements

Manage database tables for incoming syndicated data and maintain data integrity

.NET Developer (contract) The Source, Barrie, Ontario Jan 2015 – July 2015

The Source is one of Canada’s leading Consumer Electronics and Wireless retailers.

Tools and technologies: Visual Studio 2010, TFS 2008, VB.NET, C#, Console applications, MS SQL Server 2008 R2, T-SQL, ETL, SSIS, SSRS, BIDS, TDD, NUnit, Agile development.

Project: Habitant (Associate Commission Automated Payroll). Habitant was designed to automate the process of reconciling commissions of The Source associates who sell Bell products and services. It also included enhanced business intelligence and improved accuracy of commission payouts.

Responsibilities:

Worked with the Business Systems Analyst and stakeholders to translate business rules into code

Created SQL Server database tables with entity relationships within the existing data warehouse

Designed and developed console applications using principles of OOP in C# / VB.NET that load data into the data warehouse from flat files, reconcile, manipulate data and apply business rules

Coded T-SQL queries to read/write to the data warehouse

Test Driven Development with NUnit - Created unit tests to ensure high quality, modular code

Coded automatic reporting on any data inconsistencies to business users

Ensured data integrity by applying boundary rules and having peer reviews

Deployed application updates under corporate change management procedures and maintained source control with Team Foundation Server 2008

Prepared application documentation with Visio and MS Word

Troubleshoot SQL when required, Server Integration Services packages and SQL Server Reporting Services packages using MS Business Intelligence Development Studio (BIDS)

.NET Developer Kubra Data Transfer, Mississauga, Ontario Nov 2013 – Nov 2014

KUBRA builds, and maintains a suite of B2B and B2C applications that provides customer interaction management solutions to some of the largest utility, insurance, financial services, health care, and communication companies across North America.

Tools and technologies: Visual Studio 2010/2013, C#, ASP.NET, VB.NET, MVC, WPF, WCF, WinForms, Entity Framework/LINQ, AJAX, XML, JSON, CSS, Scrum/Agile, Bitbucket, Sourcetree, Jira, SQL Server 2008, IIS 6, T-SQL, VBVoice 6, HTML5, Bootstrap CSS, Git

Project: Interactive Voice Response (IVR) Business Intelligence Dashboard (BID). Kubra’s IVR allows their business clients to have their end customers make payments. The goal of BID is to enable real time call flow analysis to enable the business to enhance call completion/reduce call drops.

Responsibilities:

Modified the IVR call flow using VBVoice 6 API to create specific data points for call flow analysis

Implemented Fusion Charts with JQuery and AJAX calls (JSON/XML) to create a client dashboard for business intelligence

Troubleshoot/update ASP.NET, MVC web applications written in C#, VB.NET with Entity Framework/LINQ as the data access layer(O.R.M.)

Troubleshoot/update Windows Presentation Foundation (WPF) and WinForms applications

Enhanced web pages with unobtrusive JavaScript using the Document Object Model

Used Bitbucket (formerly Stash) as primary code repository for latest code and new branching

Created test websites using existing application pools with IIS 6 and Windows Server 2008

.NET Developer Business Information Group, Toronto, Ontario Sep 2000 – Oct 2013

Business Information Group is the premier name for B2B and trade news among Canadian publishers. Their magazines (print and online) and directories cover more than 30 industries.

Tools and technologies: Visual Studio 2008/2012, C#, ASP.NET, VB.NET, ADO.NET, IIS 5/6, Oracle 11g, XML, XSL, CSS, Agile, Jira, MS SQL Server 2005/2008, T-SQL, WinServer 2000/2003, HTML5, Bootstrap CSS, VB Scripting

Project: E-newsletter and lead generator (E-news). Editors and publishers wanted to engage their online readers with current new content and create a stream of hot leads for their advertising clients in the process.

Responsibilities:

Coded the web interface using Web Forms, Web Server Controls and Telerik controls that consumed RSS 2.0/Atom/XML feeds

Coded JavaScript and used JQuery to maintain a smooth UI and minimize page post backs

Coded in C#, event handlers and logic to process XML data; Web services that returned JSON/XML

Coded XSLT and XML to create e-newsletter html document

Created and maintained SQL Server and Oracle 11g databases utilizing database design best practices for entity relationships, Indices, Constraints, Stored Procedures, Functions and Triggers

Coded enterprise wide web applications using ASP.NET (VB.NET and C#) Web Forms with Master Pages, HTML/HTML5, JavaScript, JQuery, CSS, Classic ASP; accessing SQL Server and Oracle databases

Contact this candidate