Karthick Mohanasundaram

Implemented the version controlling and end to end automation of testing & deployment (CI\CD) of all data integration solutions such as SQL Server Databases, SSIS, SQL Job Agent & Python executables onto a target server that automatically create bugs in case of failure. Development & Enhancement of data integration solutions using SSIS & SQL Server. Converted an SSIS solution to a Python based utility that auto generates the SQL stored procedures(data pipeline) for data integration based on the data model defined in the excel. Built a new Python based data integration tool\adaptor to extract data from Microsoft Dynamics 365 Finance & Operations using the Data Management Framework & Batch APIs that extracts data from MSD365 F&O and uploads it to Azure Blob Storage. Built an Azure based tool for real time synchronization of data from Microsoft Dynamics 365 Business\Data Events using Azure Event Hub, Azure functions that directly pushes data into the target SQL server tables in near real time. Currently working on an SSIS migration project where SSIS packages are being migrated to o9s integration platform backed by Airflow and Pyspark and SQL Server databases are being migrated to Deltalake(open source version). Also managing few ReactJS based UIs for few o9 data management use cases.

Lead the team responsible for all ETL and Reporting operations for North East Europe Countries. Gathering requirements from clients, analysing it, design and development of new SQL DB objects, SSIS packages, SSRS reports and all required Stored Procedures, Tables, Views, Functions, etc. Designed & developed the SSIS packages & Azure functions which extracts and upload the data from on-prem SQL server database tables into Azure Blob storage on daily basis and migrate data from Azure blob to Azure SQL. Automated the end-to-end deployment of all SSIS packages and SSRS reports through Azure DevOps Pipelines. Version controlling all the SQL DB objects, SSIS packages, SSRS reports using the Azure Devops Repos (Git). Completed the SQL migration project (from SQL 2012 SQL 2016) whose aim was to set up the DEV, TEST, PROD server setup as the application initially had only a production server. Made the SSIS packages deployable across multiple environments by dynamically fetching all connection details during run time. Achieved 100% logging of all the SSIS packages by effective use of the event handlers in SSIS packages.

Managed the QBEs data warehousing and reporting application built using SQL Server & MSBI tools for New Zealand region end to end. Writing T-SQL Queries, Dynamic-queries, subqueries and joins for generating Stored Procedures, User-defined Functions, Views and Cursors. Experience in using CTE, temp tables and various DDL/DML queries to facilitate efficient data load and manipulation. Discussing with Business Analysts, understanding the business requirements and guide junior team member to implement the application developments and enhancements. Used Execution Plan and SQL Profiler to analyse, optimize queries and enhance the performance of the SSIS packages.

Develop, test, implement and maintain SQL Server and DB2 databases including tables, indexes, stored procedures, and complex queries Building\Enhancing\Maintaining ETL - SSIS packages and IBM Datastage jobs to Extract, Transform and Load data from OLTP DBs to Data Warehouse on daily basis through batch process Continuous monitoring and maintenance of ETL batch jobs (SSIS and IBM Datastage) and reporting applications (SSRS) Finding the recurring issues that occur during the daily ETL data load and providing permanent solutions thereby stabilising the application Building\Enhancing\Maintaining SSRS reports which derives data from the data warehouse.