Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Mathu Balan Subramaniyan Dhanabalan

Plano,TX

Summary

Senior BI and Analytics Solutions Developer with expertise in Snowflake, Tableau and PowerBI. I have 6 years of experience in Data modelling, transformation and reporting using cloud data warehouses and reporting tools. Proven track record in automating reporting processes and enhancing data-driven decision-making. Strong analytical skills complemented by effective communication, driving actionable insights from complex datasets to optimize marketing strategies.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Software Engineer

Aricent Technologies
10.2015 - 07.2017
  • Worked on the development and product support for IPv6 protocol enhancements, IPv6 Router Advertisement and IPv6 Neighbor discovery Protocol for Coriant routers.
  • Data Analysis using wireshark to capture and perform data analysis on network packets.


BI and Analytics Intern

Visual BI Solutions Inc
02.2019 - 07.2019

HR Analytics using Alteryx designer and Tableau

  • Worked on the development of HR reporting in Tableau with data from SAP Success Factors.
  • Performed data Cleaning and transformations using Alteryx designer core and published the reporting table to Alteryx Server.
  • Developed an interactive report in tableau to analyze Attrition data by age, sex, race, people of color etc.

BI and Analytics Solutions Developer

Visual BI Solutions Inc
07.2019 - 12.2021

HR Analytics – Celanese

  • Developed HR Analytics reporting using 10 years of HR data, focusing on Attrition and Diversity analytics via Tableau dashboards.
  • Sourced data from SAP SuccessFactors; performed data cleansing and transformation using Alteryx Designer.
  • Built interactive Tableau dashboards segmented by Age, Gender, and Ethnicity using data blending and ETL in Alteryx.
  • Automated end-to-end workflow—Alteryx Gallery schedules trigger updates, and dashboards on Tableau Server reflect real-time data.
    Tools: Alteryx, Tableau Desktop/Server, Tableau Prep


BW on HANA Implementation with Sales & Revenue Reporting– Tech Data

  • Modeled calculation views over BW and native HANA for Invoice, Sales & Distribution, Delivery, and Quoting data.
  • Built star schema models and implemented MTD/QTD/YTD Revenue and Margin analysis using HANA views and stored procedures.
  • Designed interactive Tableau dashboards for Revenue and Margin analysis using data from SAP BW and multiple sources.
  • Consolidated sales data across systems with drill-downs by Geography and Time (MTD/QTD/YTD), including cascading filters.
  • Added dynamic visual cues (color-coded icons) and customizable views at Customer, Market Segment, nd Vendor levels.
    Tools: Tableau Desktop, SAP HANA Studio, Analysis for Office.

Senior BI and Analytics Solutions Developer

Maven Wave Partners LLC
01.2022 - Current

Marketing Analytics Reporting – AMD
I was part of AMD’s Marketing Analytics team, delivering end-to-end reporting solutions using Snowflake, DBT, Tableau, and Power BI.


Organic Social Reporting

  • Designed a comprehensive reporting suite to analyze organic performance of AMD’s social media posts on platforming - Facebook, Twitter, LinkedIn, YouTube, TikTok.
  • Data ingestion into snowflake was done through Fivetran connectors. Developed transformation tables in Snowflake using DBT based on platform-specific business logic.
  • Built specific dim and fact tables and incremental tables using DBT. Implemented DBT data integrity tests for daily QA checks.
  • Built Tableau dashboards enabling detailed analysis of top-performing posts by Impressions, Engagements, Clicks, Video Views, etc., with filters by Campaign, Platform, and Partner.


Operational Reports – AMD Fund Tracking

  • Built transformation tables in Snowflake/DBT and developed hierarchical Power BI reports to track Marketing Fund allocation from AMD’s Creatio platform.
  • Automated daily ingestion via Data Factory; transformed cross-quarter budgets into quarterly fund allocations so that business users get a niche view of quarterly allocation.
  • Reports tracked fund flow from Regional to Subregional to Partner reservations/claims, and flagged unallocated funds or delays.
  • Developed Partner Performance dashboards in PowerBI ranking the top 100 partners per BU based on Units Sold, Investment, Product Mix, Claim Quality, etc.—
  • Scores were calculated using Standard deviation and Z scores were used to rank partners where appropriate. This reporting was widely used by leadership for quarterly investment decisions.


Salesforce Reporting – Marketing ROI

  • Developed PowerBI reporting suite for Marketing ROI.
  • Analyzed total campaigns and opportunities from the campaigns, total quantity sold and expected revenue based on opportunity stage in salesforce.
  • Built several transformation tables in snowflake to track opportunities that were sourced from marketing campaigns vs Lead sourced and analyzed the pipeline revenue based on several categories like OEM, Product category, Campaign Type etc.Salesforce


Account Based Marketing(ABM) reporting

  • Analyzed AMD's ABM campaigns run by third party providers to understand whether the campaigns contributed to page visits to AMD's website.
  • Created transformation tables in snowflake to find Accounts that had a lift in page views before and after an ABM campaign.
  • Built a comprehensive reporting in PowerBI to which helped ABM team to understand Accounts that had immediate interests AMD's offering and helped plan future campaigns.

Tools: Snowflake, DBT, Data Factory, Tableau, PowerBI


Education

Master of Science - Information Systems

The University of Texas At Arlington
Arlington, TX
05-2019

Bachelor of Technology - Information Technology

College of Engineering Guindy, Anna University
Chennai
05-2015

Skills

  • Snowflake
  • PowerBI
  • Tableau
  • DBT
  • Python
  • SAP HANA
  • SQL
  • Data Modelling and Data Transformation
  • Azure Data Factory
  • Big Query
  • SQL Server

Certification

  • Tableau Desktop Specialist
  • Snowflake Snowpro Core(2022)
  • Alteryx designer Core
  • Azure Fundamentals AZ900

Timeline

Senior BI and Analytics Solutions Developer

Maven Wave Partners LLC
01.2022 - Current

BI and Analytics Solutions Developer

Visual BI Solutions Inc
07.2019 - 12.2021

BI and Analytics Intern

Visual BI Solutions Inc
02.2019 - 07.2019

Software Engineer

Aricent Technologies
10.2015 - 07.2017

Master of Science - Information Systems

The University of Texas At Arlington

Bachelor of Technology - Information Technology

College of Engineering Guindy, Anna University