Kiran Ramaswamy, Developer in Montreal, QC, Canada
Kiran is available for hire
Hire Kiran

Kiran Ramaswamy

Verified Expert  in Engineering

Data Reporting Developer

Montreal, QC, Canada
Toptal Member Since
June 18, 2020

Kiran is an IT professional with over a decade of experience working on a wide range of projects. His expertise is in database design and administration with Microsoft SQL Server, and web and application development with C#.NET. Where Kiran shines is in the design and implementation of projects of all scales and sizes and has a particular passion for ETL projects involving large amounts of varying data.


KRAK Consultants
Database Testing, Databases, SQL Server DBA, Database Design, .NET...
Database Testing, Databases, SQL Server DBA, Database Design, .NET, Shopify API...
Database Testing, Databases, SQL Server DBA, Database Design, .NET...




Preferred Environment

Database Design, Microsoft SQL Server, .NET, C#, Visual Studio, IIS, Windows

The most amazing...

...goal I've achieved on is starting up my own corporation and building its product portfolio and client base from scratch.

Work Experience

CEO | Director of Development

2017 - PRESENT
KRAK Consultants
  • Launched a small-business startup with the goal of bringing a new web-based management platform to market, with elements drawn from the product created with Nuonn.
  • Implemented several small-to-mid scale enterprise products, including some custom .NET and SQL Server solutions, for clients in various industries.
  • Worked with clients to integrate third-party products into their workflows as well as optimizing workflows to improve processing times of various tasks.
  • Managed the finances of a small-business startup, including collecting and documenting invoices and receipts and filing sales and income taxes with the aid of an accountant.
Technologies: Database Testing, Databases, SQL Server DBA, Database Design, .NET, Microsoft SQL Server, C#, ASP.NET

Applications and Database Developer

2019 - 2020
  • Worked as part of the development team on the development of a new C# Blazor .NET Core web app using MongoDB.
  • Managed legacy Angular 1 and Angular 2 projects, implemented using MySQL, SQL Server, and MongoDB.
  • Developed an integration tool connecting a DB2 database with Shopify, used to manage pricing rules in Shopify for customers.
Technologies: Database Testing, Databases, SQL Server DBA, Database Design, .NET, Shopify API, DB2/400, MongoDB, SQL Server 2017, MySQL, Angular CLI, .NET Core, C#, Blazor, ASP.NET

Webmaster | Database Administrator

2014 - 2017
  • Led the web development and database administration of a small-business startup.
  • Created a web-based management platform for handling typical company affairs, including but not limited to project management, timesheets, and payroll.
Technologies: Database Testing, Databases, SQL Server DBA, Database Design, .NET, Microsoft SQL Server, C#, ASP.NET

Applications and Database Developer

2011 - 2015
Laurentian Bank of Canada
  • Led the .NET development as part of the applications development team for the call center.
  • Developed and migrated applications from MS Access to VB.NET and C#.NET.
  • Administered several Microsoft SQL Server 2005 databases.
  • Migrated a principal system used by the call center from Microsoft Access to ASP.NET.
  • Used SQL Server Integration Services (SSIS) to pipeline information from various credit reporting agencies into tables accessible by the fraud department and call centers.
Technologies: Database Testing, Databases, Data Reporting, SQL Server DBA, ETL, Database Design, .NET, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server, C#, ASP.NET

Applications Developer

2014 - 2014
  • Led the development to migrate a Microsoft Access app used across Canada to a VB.NET app.
  • Liaised between management and developers to ensure the proper implementation of requirements.
Technologies: Database Testing, Databases, SQL Server DBA, Database Design, C#, .NET, Microsoft SQL Server, VB.NET


2008 - 2011
Technology Evaluation Centers
  • Supervised a web development team consisting of three other employees.
  • Led the development of a project to overhaul the company website, which involved transitioning from the classic ASP to ASP.NET.
  • Created and automated the production of reports using SQL Server reporting services, resulting in over 30,000$ per year in monetary savings for the company.
  • Used SQL Server Integration Services (SSIS) to handle ETL processes, including efficiently importing tens of millions of flat-file records into various tables.
  • Worked with the marketing team to accurately target email campaigns towards ideal clients based on client interactions with company websites and products.
Technologies: Database Testing, Databases, Data Reporting, SQL Server DBA, ETL, Database Design, .NET, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft SQL Server, C#, VB.NET, ASP.NET, Active Server Pages (ASP)

Conversion of a Website from ASP Classic to ASP.NET

The company's production website was written in ASP Classic and needed to be upgraded to ASP.NET to accommodate the growing list of requirements. The development team was tasked with migrating the code, as well as gathering feature requests from relevant stakeholders throughout the company.

I was put in charge of the project and led a team of three others (a graphic designer, another developer, and QA). My responsibilities included working with all of the other people in the company to make sure their feature requests were adequately implemented.

We successfully launched the new site after about a year of development. After the site launched, I was responsible for maintaining it and communicating new feature requests with our team.

Conversion of an Application from MS Access to ASP.NET

The client was the call center of a financial institution in Canada. The call center was using an MS Access app to manage their interactions with clients. These interactions included but were ot limited to handling app/cancellation requests, managing address changes, and validating/invalidating fraudulent transactions.

In the past, they had attempted to redo the app in ASP.NET; it failed due to massive scope creep. Our team was brought in to revive the project and try again.

We successfully migrated several vital parts of the application to a new ASP.NET solution and positioned our product to be able to handle more migrations if necessary.

Development of a Management Portal for Student Unions

Our company was tasked with the creation of a management portal to handle various tasks required by student unions, including but not limited to management of timesheets, events, jobs, inventory, and membership.

We developed a .NET portal which was implemented using an Azure SQL Server Database and an Azure-hosted website. Later, we revisited the project with other clients and adapted it to fit their specific needs.

After several years of being used, we decided to launch a new version, reworked from the ground up with all of the lessons we learned from the previous version.

Development of an ETL Process Using SQL Server Integration Services (SSIS)

The client had a requirement to import large amounts of data from different sources, primarily composed of flat files. They had set up a process of gathering that data and using bulk import tools within SQL Server to handle the importing. However, the recordsets were often composed of tens of millions of records and the import process was taking days to complete.

We were tasked with developing a new method to import the data, along with the added requirement of also capturing any failed imports to diagnose, ideally without interrupting the primary import process.

We solved this problem by using SQL Server Integration Services (SSIS). We developed several pipelines to stream the data from the flat files to their destination tables. We were not only able to reduce the overall execution time from days to mere minutes, but also handle import problems by transferring those records to secondary error tables. Depending on the severity of the error, these could optionally have the primary record continue to import, with null or default values as required.

The overall solution was also easily extensible to different types of imports and became the primary method for importing data for the company.
2015 - 2015

Master of Business Administration (MBA) Degree in Global Business Administration

EDHEC Business School - France

2009 - 2012

Master of Science (MSc) Degree in Bioresource Engineering

McGill University - Quebec City, Canada

2003 - 2008

Bachelor of Engineering Degree in Computer Engineering

Concordia University - Quebec City, Canada


MCTS 70-433



jQuery, jQuery UI, jQuery DataTables, jQuery Validation, Shopify API


C#.NET WinForms, DataTables, Visual Studio, Angular CLI, Fiddler


.NET, .NET 4, VB.NET WinForms, ASP.NET, Blazor, .NET Core, Bootstrap 3, Json.NET


HTML DOM, Database Design, ETL, ETL Implementation & Design, OLAP, Requirements Analysis


SQL, C#, C#.NET, VB, Visual Basic .NET (VB.NET), JavaScript, CSS, Excel VBA, HTML, HTML5, Active Server Pages (ASP), VB.NET, XML, Java




SQL Server Integration Services (SSIS), Microsoft SQL Server, SQL Server DBA, SQL Server 2008, SQL Server 2005, SQL Server 2014, IIS SQL Server, Databases, Database Triggers, Database Testing, OLTP, SQL Server 2017, Database Security, SQL Server Reporting Services (SSRS), MongoDB, DB2/400, MySQL, Oracle RDBMS, OpenXML, JSON


Reporting, ETL Development, ETL Tools, Data Reporting, IIS, IIS 6, IIS 7, IIS 8, Web Server (IIS), Internet Information Services (IIS), APIs, Requirements & Specifications, Requirements, Business Requirements, Product Requirements Documentation (PRD), FontAwesome, Regular Expressions, Ajax, Single Sign-on (SSO)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring