Data Engineering

RESUME

LOGASHUNMUGAM GANGATHARAN Email: ********@*****.***

H/P: +91-978******* Karapakkam-OMR-Chennai

Certifications:

SnowPro Core Certification

Snowflake Platform Training-APAC

SnowPro Associate Certification

Microsoft Power Bi Certification in Data Camp

Amazatic Software Pvt Ltd

Data Consultant – (Remote -Contract Role) (Feb - 25 To July - 25)

EDMI Singapore Pvt Ltd (Jan - 24 To Jan - 25)

Techinical Data Lead Consultant

Singapore (Contract -Remote)

BridgeTalent Pvt Ltd.& Thinkbridge Pvt Ltd (Nov - 21 To Nov-23)

Senior Lead- Data & Software Engineering (Remote)

Quantum Automation Singapore Pvt Ltd -Singapore (On Site) (June - 07 To Mar - 19)

Senior Lead- Application Engineering

Iios Systems (P) Limited, Chennai (Mar - 05 To May - 07)

Senior Software Engineer/ Data Architect

Swaram Medicare and Research Centre PVT Ltd, Chennai (Feb - 03 To Mar - 05)

Software Development Engineer & Data Architect

RKM SOFTWARE, INDIA (Jan - 01 To Jan - 03)

Programmer/Developer

EXPERIENCE SUMMARY

Seasoned IT professional with 23+ years of experience across Singapore and India, specializing in data engineering, data architecture, and enterprise data solutions. Proven leader in data warehousing, ETL/ELT pipelines, data migration, and analytics across Healthcare, Government, Insurance, Retail, and IoT domains. Delivered high-impact solutions for organizations including Government of Singapore (LTA), Data Centers, and AXA Insurance, driving performance, scalability, and data quality excellence.

Extensive experience in Project Management, Team Leadership, Data Engineering, Data Architecture, Data Quality, and Data Governance. Proven ability to lead cross-functional teams, define scalable data architectures, and deliver enterprise-level data solutions using Agile methodology. Strong expertise in stakeholder management, risk mitigation, documentation standards, knowledge sharing, and continuous improvement. Hands-on experience with JIRA for sprint planning, tracking, and reporting, with a consistent focus on high-quality, on-time, and value-driven delivery.

Data Modelling, ETL & Reporting Expertise

Strong hands-on experience with Snowflake, AWS Redshift, MS SQL Server, and PostgreSQL for data warehouse design, modelling, and optimization.

Skilled in Python and Spark for AWS Glue ETL pipelines, integrating diverse data sources using tools such as Stitch and Fivetran.

Experienced with DBT (Data Build Tool) for data transformation in both Cloud and Core layers across Snowflake, PostgreSQL, and Redshift environments.

Proficient in 3-layer data modelling (Staging, Core, Reporting) using ERWIN, MySQL Workbench, and Visio.

Created 100+ Power BI dashboards by migrating reports from Periscope and SSRS, integrating data from Azure SQL and Google Looker Studio.

Strong in DAX, Power Query, and data visualization design for executive and operational reporting.

Managed data access and security roles across AWS, Redshift, PostgreSQL, and MSSQL environments.

Expertise in SSIS, SSRS, and SQL Server data migration (MSSQL to PostgreSQL), including ETL automation via SQL Agent Jobs and Active Batch.

Experienced with Azure SQL Database and Power BI Desktop for analytics and visualization.

Familiar with Agile and Kanban methodologies, using Jira, Notion, and Slack for collaboration and documentation.

SKILL SETS:

Data Warehousing & ETL:

Snowflake, AWS Redshift, MS SQL Server, PostgreSQL, SSIS, AWS Glue, DBT, Stitch, Fivetran, Python, Spark

Data Modelling & Architecture:

Star & Snowflake Schema Design, 3-Layer Data Model (Staging, Core, Reporting), ERWIN, MySQL Workbench, Visio, Schema Optimization, SCD Implementation, Data Governance

Programming & Scripting:

Python, SQL, Spark, Shell Scripting, DAX, Power Query

Data Analytics & Reporting:

Power BI, SSRS, Periscope, Google Looker Studio, Azure SQL, Dashboard Design, KPI & Trend Analysis

Cloud Platforms:

AWS (S3, IAM, Glue, DMS, RDS, EC2, Athena), Azure SQL, AWS Lambda, CI/CD Pipeline Integration

Version Control & DevOps:

Git, VS Code, CI/CD with DBT & Python, SQL Catalog, SQL Agent Job Automation

Security & Access Control:

RBAC, DAC, IAM Policy Configuration, Data Encryption, Access Management in Snowflake & AWS

Testing & Quality:

Data Validation, Regression & Functional Testing, UAT, QA Documentation

Tools & Collaboration:

Jira, Kanban, Notion, Slack, Confluence, MS Office Suite

Participated in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, UAT, implementation, and maintenance with timely delivery against aggressive deadlines.

Having 5 years Expertise in Manual Testing like Database Testing, Black Box & White Box testing, Functional Testing, Integration Testing, System Testing, Regression Testing, Sanity Testing.

Very Good experience Agile Methodology & Jira Working Knowledge in Insurance and Singapore LTA Government like LTA Fines & ERP Admin fees i.e., LTA e-payment Web portal

Extensively worked on Writing Test Cases, Execute Test Cases, Logging Defects, Defect Tracking and Prioritize Defects.

Experience in hospital management and health care domains

ACADEMIC EDUCATION:

Master of Computer Application (MCA), Madurai Kamaraj University,

B.sc (Physics), Bishop Heber College, Tamil Nadu, India

WORK EXPERIENCE - Project Leader & Engineering Manager & Senior Data Engineering Lead

Amazatic Software Pvt Ltd : Data Consultant ( Data Modelling & Rporting Services)

AWS Redshift – Data Modeling & Optimization

Designed and implemented star and snowflake schema models for analytical workloads.

Created fact and dimension tables, maintaining data integrity and scalability.

Optimized performance using sort keys, distribution styles, and materialized views.

Collaborated with ETL teams to ensure data model consistency across staging, core, and reporting layers.

Implemented RBAC security and schema version control for Redshift environments.

EDMI Singapore Pvt Ltd -Remote

IOT—Data migration (Streaming Data) from on-premise system to Snowflake Data warehouse

• Led data migration from on-premise IoT systems to Snowflake Cloud Data Warehouse.

• Automated data transfer from HVAC, sensor, and BMS systems using Python and AWS S3.

• Designed ELT pipelines for data ingestion and transformation in Snowflake.

• Migrated 25+ SSRS reports to Power BI dashboards improving visualization efficiency.

1. ORGANIZATION: BRIDGETALENT (INDIA) PVT LTD

Bridge talent is a subsidiary of Talentinc located in central HQ in New York and it’s a product-based company mainly focus on their product like Career.io, resume.io, Top Resume, Top CV and etc.

Scope of the Work:

Gather requirements and business process knowledge to transform data according to the needs of end-users.

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.

Collaborate with developers and business users to gather required data and execute ETL programs and scripts.

Work on data models, transformation scripts, and pipelines in collaboration with business users and peers.

Ensure data architecture and design are scalable, repayable, and maintainable.

Document design content and perform unit testing activities.

Setup and maintain Redshift data Warehouse

Creating New & maintaining existing ETL pipeline like Stitch & periscope reporting Tool.

Data Analysis in different DB like PostgreSQL, redshift & Clickhouse for the reporting and analytical team for their Dashboards

Knowledge of data governance and data quality.

Whole data engineering Activates in all Talentinc product DB’s

Leads a small team of 8 members team who work across single and multiple projects

Generate Various SQL Query output for marketing team/Production team for their business to increase their revenue and helps for all Pod through ETL or ELT.

Worked in Aws Looker for to prepare dashboards.

Creating index and materialized view in Dwh for make the dashboard effective

Create & setup network connection in AWS VPC for different database in Talentinc

Maintain regular archive of data backup and use AWS S3 Glacier to sore the data is needed.

Work with Reporting & analytical team for the data preparation for the management dashboard

Closely work with Infra team for the implement of WLM and increase the redshift cluster Nodes

Take full ownership of Access control in AWS IAM and in redshift based on the access level.

Prepare different type of data preparation for the stakeholders and project/product managers

Prepare Data Architecture for the new & upgrading projects

Recent migration: AWS redshift to Snowflake Cloud data warehouse via AWS S3

Use AWS Looker for the dashboard presentation

Conduct Scrum meeting with the team on regular basis for the project work and update in Jira case.

2. ORGANIZATION: QUANTUM AUTOMATION PVT LTD

Project: LTA – Equipment Monitoring System (Singapore Government Data Centre)

Client : LandTransportAuthority (LTA),Singapore

Role : ApplicationEngineer–Operations&Maintenance

Duration : 10 Years

TeamSite : 15

Technologies : MS SQL Server 2005/2012, SSIS, SSRS, Crystal Reports 11, SCADA (iNexus),

Visual Basic, PLC,

Testing : Manual Testing (Waterfall & Agile Methodology) & Testing & Commissioning

Migration : MS SQL Server Data is migrated to Aws Redshift and Eco Systems

Project Overview:

Developed and maintained a large-scale centralized monitoring system under the Transport Department Hub at LTA Data Centre. The system monitored escalators, pedestrian underpasses, lighting, and FMS signals across 130 zones in Singapore.

Key Responsibilities & Achievements:

Designed and implemented MSSQL database architecture using normalization techniques for efficient data management.

Developed ETL workflows (SSIS) to extract, transform, and load data from multiple subsystems including flat files, Excel, CSV, and SQL sources.

Configured database replication and maintenance plans for full and partial backups.

Created and deployed reports and dashboards using SSRS and Crystal Reports XI for data analysis, audit, and submission to government authorities.

Integrated SCADA (iNexus) and PLC communication for real-time monitoring and data collection.

Led periodic database migration from MSSQL 2005 to MSSQL 2012 ensuring minimal downtime.

Collaborated with cross-functional teams to prepare GUI designs and performance reports for all 130 zones.

Conducted manual testing (unit, system, regression) to validate system stability under both Waterfall and Agile phases.

Supported ongoing operation and maintenance for LTA’s centralized infrastructure, ensuring 99.9% uptime.

At the year of 2015 from onwards, we started to Migrate to AWS Cloud Data warehouse

Project 2: LTA – E-TRAP DATA SERVER MIGRATIONS – Batch Processing

We have migrated data from other third-party vendor database server from MYSQL –Open-Source system to MSSQL Server 2012 for newly launched MRT-LRT train station data for the Analysis and Reporting for the management of Transport Authority and used Power BI Data Visualization tool for the reporting for newly and existing reports.

Project 3: AXA INSURANCE – BUILDING AUTOMATION & ANALYSIS SERVER MIGRATION

Project : AXA Insurance – Data Modelling & Reporting Modernization

Client : AXA Asia Pacific Centre, Singapore

Role : Senior Data Engineer / Data Modelling Lead

Technologies : MSSQL, Oracle, SSIS, SSRS, Power BI, SQL Agent

Summary:

Designed and implemented end-to-end data models and reporting solutions for AXA’s insurance analytics platform covering policy, claims, billing, and hospitalization data from 14 regional centres.

Key Contributions:

Designed OLTP and OLAP data models supporting multi-source integration across 28 databases.

Developed ETL pipelines (SSIS) to extract, transform, and load structured/unstructured insurance data.

Built dimensional data models (fact and dimension tables) for policy, claim, and payment analytics.

Implemented automated reporting using SSRS and SQL Agent for business and compliance dashboards.

Optimized database performance through indexing, normalization, and schema tuning for faster insights.

PROJECT 4: DB SCHENKER OF SINGAPORE –CENTRAL RETAIL STORE

One of the customers of DB Schenker and newly opening at Airport Road in Singapore

This project is migration of smaller to larger dataset from MSSQL 2005 to MSSQL 2014 with fact & Dimension table Preparation and based on the data from their daily business using customer, supplier product, order and sales, purchase and based on the data, we build new implement of SSIS, SSAS, SSRS for to extract, transform and load data for Business Analysis and Business reports and for prepare various dashboards.

Project 5: Equinix Data Centre -APEC OF SINGAPORE - IoT Data migration

Analysis & Design & preparation of Engineering Documents & SCADA Graphics of BUILDING MANAGEMENT SYSTEM and programming to monitor and Control of System and Live data which is periodically data transfer from various type of Equipment to Our BMS Server using various network and communication protocols and also from High Level interface equipment which are monitor by Google data centre at Singapore. We involved in Extraction of Daily data from shared Folder and Load to SQL Server database on daily basics and need to prepare various report using different like excel, PDF Using Microsoft SSRS and Power Builder 3.0 for the verification and validation reports for the Customer and Preparing EMS report presentation and generate Auto reporting method, Setup Entire Network Configuration of whole data Centre in place for data Monitoring to the Management

And connecting Third party Vendor system through our application and monitoring of Network port/Switch/Hub and Auto generation of SMS Paging system, if any fault happens in the building.

Front End Graphics : SCADA (INexus) & Visual Basic Application, SNMP

Database/Data Warehouse : MS SQL SERVER 2012

Reporting Tool : SSRS Reporting with Power BI Migration

Role : Senior Application Engineer

Team Size : 20

Duration : 1.5 years

Manual Testing : Unit testing in every module finished

Involved in testing phase for the verification of QA and preparation and Signoff of UAT

Senior Software Engineer – Ilios Systems Pvt Ltd, India

Apr 2005 – May 2007

Tech Stack: VB, MS Access, SQL Server 2000

Client: Log Win Tech, Italy

Designed and implemented database architecture for COSMACS, a global cosmetic industry management system.

Led end-to-end database migration ensuring performance, scalability, and data integrity.

Developed custom modules for production, R&D, sales, and inventory, improving system efficiency and client operations.

Software Engineer – Swaram Medicare & Research Centre Pvt Ltd, India

Projects: Home Healthcare System, Hospital Management System

Designed database models and built core modules for patient registration, treatment tracking, follow-up, and emergency care workflows.

Developed billing, consultation, and reporting modules enabling complete digitization of patient records.

Enhanced operational efficiency by automating consultant payments, patient documentation, and hospital workflows across multiple healthcare units.

Delivered stable, production-ready systems that improved data accuracy and turnaround time for healthcare operations.

Software Engineer – RKM Software, India

Projects: Implementation & Support Management System, Philips Lighting Distributor System

Tech Stack: VB, MS Access

Developed modules for stock management, invoicing, customer records, and user administration for Philips Lighting distributors.

Designed the database and built support & implementation tracking modules (installations, payments, job status, journey plan).

Participated in full SDLC: requirement analysis, design, development, testing (unit & integration), and deployment.

Created detailed documentation and conducted training for support executives to streamline adoption.

DECLARATION

I hereby declare that the information provided above are true and confide to the best of my Knowledge

Contact this candidate