Thirumavalavan Ganesan

Data Professional with solid hands-on experience in SQL Server, SSIS, and SSRS, delivering end-to-end data integration, transformation, and reporting solutions. Proven expertise in designing and optimizing ETL workflows, managing complex datasets, and automating data pipelines in enterprise environments.

Currently expanding skillset through practical learning projects in SSAS, Azure Data Factory, Azure Synapse Analytics, Databricks, Apache Spark, and Python to support cloud-based analytics and big data solutions. 

Prudential Services Singapore – Technical Consultant

Feb 2019 – Jun 2024

• End to end experience in ETL design and implementation for seamless data integration, transformation, and consolidation.
• Managed multiple modules such as supplier screening, invoices, travel expenses, payments, and FX rates across multiple systems.
• Utilized SQL Server, Procedure, SSIS, SQL Jobs, and SFTP for data management and automation.
• Managed Jira-based issue tracking and Confluence for system documentation, ensuring smooth project execution.
• Directed offshore development teams and coordinated with production support for continuous system optimization.
• Participated in data science learning through the corporate professional development advisory board and contributed to testing the AI for the Pulse module.
• Contributed to the Azure to GCP cloud migration for the project, leading up to the UAT setup.

Health Promotion Board – Senior Software Consultant

Feb 2018 – Aug 2018

• Led migration of applications from a legacy data center to the new MEDINET data center, ensuring a smooth transition and minimal downtime including SQL server database, CRM, SSRS and batch job. Modifying code to the new environments.
• Configured virtual machines, ensured load balancing, and database clustering for high availability in UAT and production environments.
• Collaborated across infrastructure and development teams to ensure application readiness.

Monetary Authority of Singapore – Data Lead

Jun 2016 – Mar 2017

• Managed integration with MS CRM using SQL server, Oracle, SSIS, REST API, KingswaySoft, XML & FETCHXML.
• Using data model concept to designed centralized database.
• Improved data quality through deduplication and validation.

CIMB Securities – System Analyst

Feb 2015 – Feb 2016

• Integrated operational and CFD data from multiple formats such as csv, excel and web service to integrate trading platform.
• Managed integration jobs for Asia, USA, and Japan markets.
• Developed robust data integration solutions with SQL Server, SSIS, and .NET.

BDP Asia Pacific – Senior Software Engineer

Nov 2012 – Mar 2014

• Enhanced global Air / SEA cargo export, import job and money module with tracking system using ASP, ASP.Net, C#, and SQL Server.
• Optimized SQL queries for performance improvements.

Keppel Shipyard – Senior Software Engineer

Mar 2012 – Aug 2012

• Developed HR reporting integration using MVC, SQL, and Telerik-Kendo.

My Asset – Senior Software Engineer

Jul 2011 – Dec 2011

• Developed inventory system using ASP.NET, C#, SQL.

ST Logistics – System Analyst

Aug 2010 – May 2011

• Implemented digital aviation fuel billing solution.
• Developed Windows mobile app with RDA, C#, and SQL.

Hewlett Packard – Software Engineer

Aug 2006 – Oct 2009

• Developed C# client for SABA-Java integration.
• Standardized data center applications across EMEA/NA.

Ryder Ascent Logistics – Programmer Analyst

Nov 2005 – May 2006

• Supported global clients with application fixes (SQL Server,  ASP.Net, C# & VB.Net)  and enhancements.

NCS Hub – Dot Net Developer

Jun 2005 – Oct 2005

• Worked on various DOT.NET components in Singapore government projects.

Dicklin Corporation Pte Ltd – System Support Engineer

Sep 1999 – Apr 2004

• Built biometric data polling systems and integrated payroll systems using VB6 & SQL.

Education

Master of Science, Chemistry

May 1988 –May 1990 

Annamalai University, India

Certifications

• Microsoft Certified: Azure Fundamentals (AZ-900), AI Fundamentals (AI-900), Data Fundamentals (DP-900)
• Python Basics – HackerRank
• MSBI Suite (SSIS, SSRS, SSAS) Refresher – Udemy
• Azure Data Factory for Data Engineers – Udemy
• Azure Databricks & Spark for Data Engineers – Udemy
• DevOps Training (Tech Mahindra)
• Web Programming with Java – Software Solution Integrated Ltd.
• Advanced & Honors Diplomas – NIIT & SSI