Kiran Ramaswamy, Software Developer in Montreal, QC, Canada
Kiran Ramaswamy

Software Developer in Montreal, QC, Canada

Member since August 15, 2019
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.
Kiran is now available for hire

Portfolio

Experience

  • ETL, 10 years
  • C#, 10 years
  • SQL Server DBA, 10 years
  • Database Security, 10 years
  • Database Design, 10 years
  • .NET, 10 years
  • jQuery, 5 years

Location

Montreal, QC, Canada

Availability

Part-time

Preferred Environment

Windows, IIS,Visual Studio, C#, .NET, SQL Server

The most amazing...

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

Employment

  • 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: ASP.NET, C#, SQL Server
  • Webmaster | Database Administrator

    2014 - 2017
    Nuonn
    • 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: ASP.NET, C#, SQL Server
  • 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 to pipeline information from various credit reporting agencies into tables accessible by the fraud department and call centers.
    Technologies: ASP.NET, C#, SQL Server, SQL Server Reporting Services, SQL Server Integration Services
  • Applications Developer

    2014 - 2014
    Telus
    • 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: VB.NET, SQL Server
  • Webmaster

    2008 - 2011
    Technology Evaluation Centers
    • Supervised a web development team consisting of three other employees.
    • Led development on a project to overhaul the company website, which involved transitioning from 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 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: ASP, ASP.NET, VB.NET, C#, SQL Server, SQL Server Reporting Services, SQL Server Integration Services

Experience

  • Conversion of a Website from ASP Classic to ASP.NET (Development)

    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 (Development)

    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 (Development)

    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.

Skills

  • Languages

    SQL, C#, C#.NET, VB, Visual Basic .NET (VB.NET), JavaScript, CSS, Excel VBA, HTML, HTML5, XML, Java
  • Frameworks

    .NET, .NET 4, VB.NET WinForms, Bootstrap 3, Json.NET
  • Tools

    C#.NET WinForms, DataTables, Fiddler
  • Paradigms

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

    Windows
  • Storage

    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, MySQL, Oracle DBMS, OpenXML, JSON
  • Other

    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)
  • Libraries/APIs

    jQuery, jQuery UI, jQuery DataTables, jQuery Validation

Education

  • Master of Business Administration (MBA) degree in Global Business Administration
    2015 - 2015
    EDHEC Business School - France
  • Master of Science (MSc) degree in Bioresource Engineering
    2009 - 2012
    McGill University - Quebec City, Canada
  • Bachelor of Engineering degree in Computer Engineering
    2003 - 2008
    Concordia University - Quebec City, Canada
Certifications
  • MCTS 70-433
    JUNE 2008 - PRESENT
    Microsoft

To view more profiles

Join Toptal
I really like this profile
Share it with others