Daniel Cai

A software veteran focused on creating complex and sophisticated data connectivity and integration solutions @kingswaysoft

Oakville, Ontario, Canada

About

I am working as the Managing Director and Solution Architect at KingswaySoft, a leading provider of data integration solutions for many different data sources, including enterprise applications such as Microsoft Dynamics, Microsoft SharePoint, Salesforce, Oracle CRM on Demand, Shopify, Yammer, Microsoft Teams, HubSpot, etc., message queuing systems such as AMQP, MSMQ, Azure Service Bus, RabbitMQ, etc., database systems such as SQL Server, Oracle, MySQL, DB2, PostgreSQL, etc., cloud storage such as Box, Dropbox, OneDrive, Google Cloud Storage, Azure Blob Storage, etc., and NoSQL systems (such as Amazon DynamoDB, Cassandra DB, Cosmos DB, MongoDB), data warehouse solutions (such as Google BigQuery, Snowflake, Slowly Changing Dimension), etc. I have a diverse background in IT, and I have worked on different roles spanning from system engineer, developer, technical architect, to project manager, and etc. While I appreciate the diversity, I admit that I enjoy the most while I am crafting a piece of code that solves a real problem.

Experience

  • Managing Director and Founder at KingswaySoft
    Oct 2011 - Present · 14 yrs 9 mos

    KingswaySoft is a leading provider of data integration solutions for Microsoft Dynamics software, Salesforce, SharePoint, Active Directory, and many other enterprise applications. Thousands of organizations from over 100 countries rely on our solutions to drive their business data efficiency. We currently offer the following products. * SSIS Integration Toolkits and SSIS Productivity Pack * JDBC Driver Pack * Integration Gateway * and more... For more information about our products and services, please visit our website at http://www.kingswaysoft.com

  • Contract Application Developer at Sierra Systems
    Apr 2011 - Sep 2011 · 6 mos

    Designed and developed SSIS-based ETL packages, and custom reports for a large-scale public safety system.

  • Consultant at CGI
    Oct 2007 - Mar 2011 · 3 yrs 6 mos

    Led the development of AEI CMIS application, a large-scale xRM solution based on Microsoft Dynamics CRM 4.0 platform, by utilizing C#, JavaScript, SQL, LINQ, and XML etc. The solution consisted of some complex CRM form scripts, CRM plug-in, workflow, offline setup package, data load and data integration components, etc. Developed Travel Alberta EOPS data load solution, which loads data from various data sources into Microsoft Dynamics CRM 4.0 platform Developed Travel Alberta CMIFS, an order fulfillment and inventory control application based on Microsoft Dynamics CRM 4.0 Developed Alberta Justice AccClaimWeb application's prototype and TPoC solution utilizing C#, xUnit.NET, ASP.NET, etc.

  • Contract IT Developer at EnCana
    Jul 2007 - Oct 2007 · 4 mos

    Developed LPA (Lost Production Allocation) and RTT (Runtime Tracker) applications, during the 3-month contract, using ASP.NET 2.0, C#, iText, SQL Server. Most of the challenges are related to the integration with PI System (the production system), Active Directory, and EnCana's HR system.

  • Director of Applications Development at WealthCraft Systems Limited
    Jul 2006 - May 2007 · 11 mos

    Oversaw the day-to-day development effort of AWB 2.0, a financial planning and portfolio management product based on Microsoft Dynamics CRM 3.0.