Vyacheslav Slav KOVALENKO

Work History

Senior Automation QA Developer

Ontario Health

12.2023 - Current

Provide different kind of automation testing for the Ontario FHIR eReferral – SERIS systems
Created automated Unit and Integration tests to validate eReferral and SERIS message bundle validation code for different bundle resources (VS 2022, .NET Core 6.0, C#, MS SQL Server 2019, Web API, Azure DevOps, Git and Postman)
Created automated Unit test cases, implement mocking of the existing services in the Unit tests framework using .NET Core dependency injection with the Ruleset interfaces
Created system’s documentation
Created Object Comparer to compare complicated objects of the same type or different types by the property name by creating of recursive function of high level of complexity
Implemented logging features and different parameters for the comparing process.

Senior Consultant

Ministry of

06.2022 - 03.2023

Enhancements and maintenance for the Ministry enterprise level Scope application
Provide system design and coding for Ministry enterprise level SCOPE application which supports the process for cases at the Superior Court of Justice
Add functionality according the user’s requirement
Created GUI for the application’s modules
(DevOps, VS 2019, ASP.NET 4.8 / .NET Core 5.0, VB.NET / C#, Entity Framework v6.0, LINQ to Entities, JavaScript, XML, Vue.js 2.0)
Created Web API services for consumption by newly designed modules, re-designed SOAP web services to accommodate business needs
(Azure application services, VS2019, .Net Core 5.0, MS SQL Server 2019, JSON serialization, Fiddler
Created tests for unit and integration testing
Provide performance analysis of LINQ queries on a backend (MS SQL Server) side
Provide code enhancements to increase performance for LINQ queries
Created SQL Ad-hoc queries for data clean-up and verification.

Senior Consultant

AKO Consulting LTD

02.2016 - 05.2022

Creation of Web API for medical patient's data application
Created Web API RESTful services (Azure application services, VS2019, .Net Core 3.1, MS SQL Server 2019, JSON serialization, Fiddler web debugger, DevOps development environment)
Created technical documentation, workflow diagrams
Provided unit and integration testing.

Senior Full Stack Developer

CCi Global Technologies

06.2021 - 12.2021

Development of the new Repair Order Information system for the auto claims industry
Create numerous Web API services to consume repair order’s data from different sources (VS2019, .Net Core 3.1, Docker, Kubernetes, Istio, Prometheus, Grafana, RabbitMQ, Serilog, Git, Bitbucket, JFrog)
Created unit and integration tests
Created Mock service application to produce mock data for QA testing (VS 2019, .NET, Web API, Docker, Kubernetes, XML and JSON serialization)
Implemented Blob storage container as a persistent volume in Kubernetes using Azure Blob storage CSI driver
Implemented Redis cache and Hashicorp Vault for application processing needs
Used sidecar agent to inject Vault secrets into Kubernetes pod’s environment.

Senior Backend Developer

Ceridian HCM

10.2019 - 06.2020

Development of the new Backoffice Wallet Payment, or CTS Wallet, application assists with the On-Demand Payment product by ensuring that the money provided to the employee is collected from the client and paid to the program manager
Working as a member of a development team of CTS Wallet corporate Financial application
Created Azure functions for performing data operations, Azure service applications (Web API)
Provided ongoing changes and fixes, created unit tests cases (VS 2019, .NET Core 2.2, C#, MS SQL Server 2017, Entity Framework Core Code First, Web API, Azure, Postman).

Senior Full Stack Developer

Autotrader

03.2019 - 09.2019

Enhancement and adding new features to the biggest Canadian vehicle (cars, boats, RV) sales website
Provided ongoing changes and fixes to Private Sell web application's front end (VS 2017, .NET Core 2.2, JavaScript, C#, MVC5, Web API, AngularJS, JavaScript, jQuery, LESS, Git, Jira, Bitbucket)
Modified data access tier (Web API, stored procedures, functions, triggers) according to changed business requirements (.NET Core 2.2, C#, Entity Framework Core, Autofac DI resolver, MS SQL 2017 server on a cloud).

Senior Software Developer

Treasury Board of Canada Secretariat

05.2018 - 02.2019

Development of the ONTrack application for the Government of Ontario using Azure cloud environment
Application keeps track of all cabinet initiatives and related information such as meeting schedules, press releases, financial information e tc
Worked with ONTrack application Web API using Azure Cosmos DB as a back end (Azure App services, VS 2017, .NET Core 2, JWT security, Azure Key Vault, VSTS, Git, Office 365 and Swagger)
Created application services libraries consumed by Web API service applications (.NET Core 2.0, C#, Dependency injection)
Created notification mechanism using Azure Event Grid and Service Bus, Azure functions triggered by Azure Storage Queue, Service Bus topics, database changes and timers
Developed UI for consuming Azure App services API (VS Code, Angular 5, JavaScript, HTML 5, SASS).

Senior Software Engineer

S-Line LTD

01.2018 - 04.2018

Creation of new front-end interface and modification of the existing back-end to complain with the new architecture for healthcare statistics web application
Created Web API Application services on Azure using VS 2017, .NET Core 2.0, MS SQL Server 2017 and Node.js
Provide migration from ASP.NET web form application to Azure application services using RESTful services and Angular 5
Created SPA user interface design for the Application (VS Code, Angular 5, HTML 5)
Created foundation classes’ library for the application.

Senior SharePoint Developer

Baffinland Iron Mines Corp

09.2017 - 12.2017

Implementation of SharePoint Server web portal for Mining industry corporation
Created Site Collections, Pages and Document Libraries for the corporate SharePoint portal (SharePoint 2016 / SharePoint 365 Online)
Created custom web parts, customized team calendars
Organized process of moving documents from shared drives to SharePoint environment
Implemented custom CSS styles for promoted links and team calendars
Created views for document libraries (SharePoint Designer, jQuery, Web API, Angular 2, JSON, CSS)
Created graphic design for the different department’s pages
Created custom help pages, InfoPath forms, different kind of workflows
Re-engineered MS Access 2013 application to SharePoint 2016 environment (InfoPath, MS Access 2013).

Senior Consultant

Knowledge First Financial

12.2016 - 09.2017

Working on re-engineering of the existing web and desktop corporate applications for Education savings plan
Participated in data migration related to transferring data from different financial systems and CRM to corporate application database (.NET, C#, MVC, MS SQL Server 2014, Visual Studio 2015, Entity framework 6.1, MS Access
Created SSIS packages for data export / transformation
Provided unit and integration testing, created technical documentation
Created numerous stored procedures, functions, views, triggers, database scripts to accommodate new business requirements (T-SQL, MS-SQL 2016, XML)
Provided changes to SSRS and Business Objects corporate reports
Provide statistical analysis in SSAS
Created web pages for corporate financial web application (MVC 5, MS SQL Server 2014, C#, Entity framework 6.1, Office 365)
Developed Web API middle tier prototype
Created graphic and layout design for UI (WinForms)
Manage defects logs in TFS.

Senior Back-End Software Engineer

Royal Bank of Canada

11.2015 - 10.2016

Enhancements to the existing Viewfinder financial application including data format changes (and all relative database changes in stored procedures, functions, triggers e tc.) according to SWIFT standard
Developed various supporting application for enterprise Viewfinder data feed portal, for implementation of different kind of ETL processing (data files split, transformation, encoding) for Investments & Treasury department (Visual Studio 2013, C#, .NET 4.5, WCF, XML/XSLT transformation, Agile) accommodating changes in business logic and new requirements to capture incoming information
Developed stored procedures for data manipulation, triggers, DDL/DML scripts (MS SQL Server 2008-2014)
Provided unit testing, created deployment packages, provided technical documentation, developed test cases for UAT
Worked with different data extraction and document formats
Developed application to produce generic PDF reports (Visual Studio 2013, C#, .NET 4.5, iTextSharp library, WinForms)
Re-designed existing corporate application for migration from .NET 2.0 to version 4.5
Maintain change packages in CA Harvest source control management tool.

Senior SharePoint Developer

Children’s Aid Society of Toronto

08.2015 - 10.2015

Implementation of SharePoint Server as a team collaboration and information portal for the non-profit organization
Implemented branding for corporate SharePoint portal
Provided SharePoint Server administration
Customized master pages and sub sites, create graphic design prototypes, custom themes and custom web parts
Worked in contact with stakeholders to ensure right direction to the final result (SharePoint Server 2010, Visual Studio 2013, SharePoint designer, JavaScript, jQuery, Bootstrap, Angular JS, HTML, CSS)
Created workflows for content approval.

Senior Software Developer

Trillium Health Partners

04.2015 - 08.2015

Development of Information system's middle tier for the Medical institution
Created web application’s middle-tier based on Web API RESTful services (.NET, C#, Visual Studio 2013, MS SQL 2012, Web API 2.0, MVC 4.5, Entity Framework, AutoMapper, Ninject, JSON), using Generic Repository and Unit of Work design patterns (Agile environment)
Implemented ASP.Net Identity authentication model (OWIN middleware) as a security feature
Crated front-end prototype for testing consuming middle-tier RESTful services (AngularJS)

Senior Consultant

Ontario Ministry of Health and Long-Term Care

09.2013 - 03.2015

Creation of enhancements for the existing Long-Term Care Homes rate reduction application
Participated in redesign of DQC application for Data Management for the Rate Reduction Information System Application (RRISA) (.NET, C#, Visual Studio 2012, MVC 4.5, MS SQL Server 2008, Entity framework 4.5, LINQ to Entities, jQuery, Knockout, AngularJS, Agile extreme programming)
Created User Interface and data access components
Re-designed Rate Reduction Parsing application (Visual Studio 2012, VB.NET, MS SQL Server 2008, MS Office automation)
Created stored procedures, data access modules
Re-designed application for Long-Term Care Homes Rate Reduction calculation (MS Office, Excel Macros, VBA)
Designed and developed complicated MS Excel forms, modules for data security, export, transferring and transformation
Created Subsidy Calculation system (Visual Studio 2012, C#, LINQ to Entities, Entity framework 6.0), PDF letters creation system for LTC homes residents.

Senior Software Developer

AmerisourceBergen Inc

07.2011 - 09.2013

Development of corporate e-commerce web site for pharmaceutical distributor, creation of generic report system and tablet iOS application's prototype
Created complicated User-Defined report generator using MS SQL Reporting services Report Definition Language and Back Office reports automation system for a large size (10k - 1mln records) reports using all available data criteria by user's choice in agile environment
Developed windows services and processing modules for the corporate reports back office automation (ASP.NET 4.0, Visual Studio 2012, MS SQL Server 2008, SSRS, MS SharePoint Server 2010, WCF, XML/XSLT) for Corporate e-commerce portal
Created generic user notification mechanism (JavaScript, Ajax, JQuery and AngularJS)
Created logical and physical data models for the Back Office report automation (Tableau desktop)
Developed Web User Interface for creation, processing and managing user-defined reports (ASP.NET 4.0, Telerik controls, MS SharePoint Server 2010)
Integrated 3-rd party web-services into the corporate web application in order to provide features for faxing report to the customers
Created class library for SSRS report’s objects generation by serializing them to XML Report Definition Language files
Created Windows services for scheduled reports processing
Created stored procedures library for back-end automation processing (MS SQL 2008)
Created Survey Management Application, containing Management and Export to Excel web parts and multiple surveys (containing up to a few hundred questions) for health care institutions
Provide the mechanism to store data in MS SQL external database, used by other corporate applications
Created custom web parts, master pages, data connection libraries, Client context objects (MS Server 2012, SharePoint Server 2013, SharePoint Designer 2013, Visual Studio 2012, C#, JavaScript, Business Connectivity Services)
Created forms to store patient’s data and reusable workflows (Nintex forms, Nintex workflow)
Provided administration job for SharePoint portal
Developed corporate IPad application prototype (iOS, Objective-C, XCode) based on usage of SOAP web services
Created mechanism to consume web services from mobile application, designed web services and logging features for the application (C#, .NET, MS SQL Server 2008)
Created web services to accommodate corporate web application needs (Visual Studio 2010, WCF, MS SQL Server 2008, MVC4, Moneris services and MS Access) in order to consume them by large corporate clients
Created applications for web services testing (WPF)
Developed web communication system for sending instant messages / surveys to users (ASP.NET 4.0, jQuery, Telerik controls).

Senior Software Developer

S-Line LTD

06.2006 - 01.2012

Description: iPhone and e-commerce application's development
Created “Calorie Abacus” iPhone application (available in Apple App Store) which allows users to calculate calories and nutrition consumption (Objective C, iPhone SDK, iOS)
Included in “50 awesome iPhone Apps for Runners” list
Development of e-commerce website for online auctions
Completed all stages of web software development from business analysis to user support (ASP.NET 2005, MS SQL Server 2005, Ajax, 3-rd party web controls)
Provided GUI design, created various custom web controls for image downloads, resizing, zooming etc
Provided database and stored procedures design and implementation
Created application’s graphic design
Created sophisticated image splitting and transformation in order to make it possible to zoom it and change a scale
Developed online real-time auction procedures using complicated features of web server.

Senior Consultant

Ontario Ministry of Health and Long-Term Care

09.2009 - 06.2011

Development of the new Rate Reduction application for the Long Term Care homes residents
Participated in analysis, design and development of High Intensity Fund web application (ASP.NET 3.5, Visual Studio 2008, LINQ, MS SQL Server 2005-2008, MS Reporting Services)
Created application’s logical and physical data model and application architecture based on business requirements and use cases
Created 3-tier web-based application based on numerous web forms using latest VS 2008 design and data access features
Created complicated LINQ queries
Created application for Long-Term home Rate Reduction calculation (MS Office, VBA)
Designed and developed complicated MS Excel forms, modules for data security, export, transferring and transformation.

Senior Software Developer

Hospitals of Ontario Pension Plan

07.2006 - 07.2009

Creation of the online information system for the contributors to Hospitals of Ontario Pension Plan
Provided development of corporate Online Member Data Collection web application - analysis and design for data, GUI and reporting components
Participated in data modelling for the application, created data dictionary (ASP.NET 3.5 / C#, Visual Studio 2008 / 2005, MS SQL Server 2005, MS SQL 2005 Reporting Services, SharePoint Server 2007, VSS, XSLT, MS Access)
Created complicated web pages using integrated and custom web controls
Created automation modules for batch processing (SSIS, WCF)
Developed SharePoint 2007 pages for member’s data presentation using SharePoint Excel services
Created custom web parts and business data reports (MOSS 2007, SharePoint Designer 2007, MOSS Excel services)
Prepared and presented documentation regarding best practices for using web parts and MOSS administration
Developed supporting components for the batch data processing (front-end Winforms), participated in data model design, created stored procedures, technical specs and documentation
Created numerous ad-hoc reports by user’s request
Developed complicated stored procedures (MS SQL Server 2005, T-SQL)
Created data transformation packages and utilities for data import and export into / from MS Excel (Excel Macros, VBA), MS Word and other documents format.

SharePoint Designer

SharePoint Foundation

01.2018 - 07.2007

IPhone OS, XCode 2013
MS Azure, Docker, Micro Services, Kubernetes

04.2024 - 01.2007

MS Entity framework, Web API, RESTful services, LINQ to entities

Senior Front-End Developer

Royal Bank of Canada

11.2005 - 06.2006

Description: Modifications for the major Branch application front-end and corporate financial applications
Part of GUI (graphic user interface) team
Provided revision and re-engineering of corporate Sales Platform application
Provided changes according to the new business requirements, re-engineering, migration and integration application's GUI modules written in VB6 and MS C++ to the .NET platform (Visual Studio 2003, C# , VB6.0 , MFC, COM, NUnit ).

Senior Database Developer

Nesbitt Burns Inc, Bank of Montreal

06.2005 - 10.2005

Creation of corporate web applications
Development of complicated back-end procedures for overnight data processing
Developed new security features for application
Provided development as a part of a team for the Investment Advisors profitability corporate web-based report (Visual Studio 2003, ASP.NET, C#, MS SQL Server 2000, ADO.NET)
Created complicated stored procedures for report’s data upload from the different FTP sources and transferring to the corporate database, providing data validation, errors handling and e-mail notification (MS SQL Server 2000)
Created processing test cases and system documentation
Participated in creation of generic ASP.NET custom web controls for corporate report’s information display, especially graphical charts (ASP.NET web services, ChartFX for .NET, MS SQL Server 2000)
Created parameter’s data transferring mechanism using .NET reflection classes
Modified multi-tier Commission Accounting System corporate application’s security model to implement Windows integrated authentication security model
Created modules for authorization and authentication processing
Change application’s code in order to implement new security model at front end and middle-tier (web services) using Kerberos restricted delegation methodology.

Senior Software Developer

Mercer Human Resource Consulting

11.2004 - 05.2005

Description: Database design and custom report development for the client in US
Developed ASP.NET components for the corporate HR survey web application (ASP.NET, C#)
Created web user controls and data-centric modules
Participated in application database design (Visio 2003), created numerous stored procedures (MS SQL Server 2000) and high level of difficulty web-based reports (Crystal Reports 10), including complicated multi-dimensional graphical charts and sub-reports.

Senior Report Developer

St. Michael’s Hospital

10.2004 - 11.2004

Creation of custom reports for medical solution system designed by Siemens
Created end-user reports for Siemens Soarian Medical Solutions system (Crystal Reports 8.5/9.0)
Gathered user’s requirements
Developed complicated stored procedures (T-SQL) and cross-tab analysis reports based on MS SQL Server 2000 stored procedures.

Senior Software Developer / System Analyst

Quiettouch INC

09.2004 - 10.2004

Implementation of new features for Service Desk information system
Created application module for the Hewlett-Packard Service Desk application to provide archiving features for the application data using .NET remote features
(ASP.NET, C#, MS SQL Server 2000)
Created Windows services to consume web application calls, hosting applications on the remote computer and ASP.NET web client.

Senior Programmer / Analyst

Petro-Canada

05.2004 - 08.2004

Description: Creation of the prototype for application to manage inventory and sales for gas station wholesale business
Developed business object model n-tier prototype for the WTBS (Marketer wholesale business) enterprise application using new Visual FoxPro 8.0 internal features
Implemented COM+ MTS functionality for the prototype
Redesigned class libraries
Provide ongoing visual objects, code and stored procedures, constraints and triggers (SQL Server 2000) fixes
Provided reports revision (Crystal Reports 10.0)

Senior Software Developer / System Analyst

Quiettouch INC

09.2002 - 05.2004

Different projects for the company provided network management, co-location services and user support
Created web-based interface for the Hewlett-Packard Service Desk application (Visual Studio 2002, ASP.NET, C#, JavaScript, HTML, MS SQL Server 2000, Oracle 8i, and Crystal Reports 9.0)
Analyzed application’s database, restored data structure (more than 200 tables)
Discovered data relationships, created a data dictionary, analyzed stored procedures and back-end data centric components
Implemented various designing patterns
Created numerous web forms, web controls, perfect multi-windows / multi-frames interface, and system reports
Created relationship and interaction objects diagrams using .NET Enterprise Architect modelling tools
Created Network Security Management system (C#, WinForms, MySQL, XML, ADO) to manage numerous Linux-based network firewalls and VPN settings
Top-level of expertise project, involved all project stages
Created application n-tier architecture model, provided data analysis and database design, application business objects libraries using C# OOP features
Used numerous design patterns, including Engine/Collection/Class pattern
Developed compiler for Linux iptables firewall rules generation, including network address transfers rules, and Virtual Private Network (ipsec VPN) configuration files
Created Customers Relationship Management web application for the company needs (ASP.NET, C#, JavaScript, HTML, MySQL, MS Access 2000 and Crystal Reports 9.0)
Implemented automated email distribution features and page cache pattern to improve performance
Designed numerous data reports.

Microsoft

01.2016 - 01.2003

TFS

01.2007 - 01.2003

Present
Git, , Visual Source Safe, Harvest SCM
Present
Nunit .NET testing framework

Software Developer / Systems Analyst

AE Sharp Inc, Dynegy Inc

06.2001 - 09.2002

Recovering the missing data, providing correction of sales reports and code changes in a process of preparation for the sale of a natural gas distribution company
Individually responsible for system analysis, modification, revision and redesign of Direct Purchase Agreement and Customer Information System (PowerBuilder 8.0, MS SQL Server) applications
Developed solutions to restore data integrity and uncompleted or missing data
Changed system architecture to accommodate the business needs
Created class libraries, multi-conditional end-user reports (Crystal Reports 8.0), provided numerous code and data fixes
Created test cases and testing methodology
Created Data dictionary, use cases and collaboration UML diagrams according to RUP methodology using different kinds of Rational Products
Participated in creation of final financial balance on a moment of company sale
Participated in the creation of a corporate website using PHP 4.0 on a Linux platform
Created corporate web applications database using MySQL database engine
Developed security features to provide authorized user access to corporate website
Created features to send auto responding email and market updates.

Senior Software Developer / Team Lead

SmartSales Inc

12.2000 - 03.2001

Creation of custom CRM application project , team leading for the team of 6 programmers developing back end and middle tier
Member of the development team provided design of OutSmart Enterprise Edition software package for sales force automation
Responsible for the Database layer design in the 3 -tier Windows DNA application
Provided database architecture, data analysis, database design and implementation (SQL Server 7.0, MS Access 2000)
Created Business Object model for data centric COM components
Created stored procedures (T-SQL) supporting mechanism to implement Engine/Collection/Class Object-Based business objects framework
Created prototype for replication data synchronization mechanism (data interchange for the disconnected users) and algorithm to solve data concurrency problem
Participated in creation of Engine/Collection/Class code generator (Rapid Application Development tool) to improve development cycle productivity in a way of generate applications business objects code (VB 6.0, COM/DCOM, ADO 2.5, XML 3.0)
Created GUI and system reports for the application.

Applications

04.2024 - 1 1

0 / 8.5 6

Summary

Overview

Work History

Senior Automation QA Developer

Senior Consultant

Senior Consultant

Senior Full Stack Developer

Senior Backend Developer

Senior Full Stack Developer

Senior Software Developer

Senior Software Engineer

Senior SharePoint Developer

Senior Consultant

Senior Back-End Software Engineer

Senior SharePoint Developer

Senior Software Developer

Senior Consultant

Senior Software Developer

Senior Software Developer

Senior Consultant

Senior Software Developer

SharePoint Designer

Senior Front-End Developer

Senior Database Developer

Senior Software Developer

Senior Report Developer

Senior Software Developer / System Analyst

Senior Programmer / Analyst

Senior Software Developer / System Analyst

Software Developer / Systems Analyst

Senior Software Developer / Team Lead

Applications

Education

Master’s Degree - Mechanical Engineering

Bachelor’s - undefined

Skills

Accomplishments

Timeline