Thirumavalavan Ganesan
SSIS developer | MSBI | ETL | SQL Server | C#
Hire this person
Send a job offer directly to this candidate
About
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.
Experience
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.
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.
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.
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.
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.
Mar 2012 – Aug 2012
- Developed HR reporting integration using MVC, SQL, and Telerik-Kendo.
Jul 2011 – Dec 2011
- Developed inventory system using ASP.NET, C#, SQL.
Aug 2010 – May 2011
- Implemented digital aviation fuel billing solution.
- Developed Windows mobile app with RDA, C#, and SQL.
Aug 2006 – Oct 2009
- Developed C# client for SABA-Java integration.
- Standardized data center applications across EMEA/NA.
Nov 2005 – May 2006
- Supported global clients with application fixes (SQL Server, ASP.Net, C# & VB.Net) and enhancements.
Jun 2005 – Oct 2005
- Worked on various DOT.NET components in Singapore government projects.
Sep 1999 – Apr 2004
- Built biometric data polling systems and integrated payroll systems using VB6 & SQL.
Education
Education
Master of Science, ChemistryMay 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
