Mathu Balan Subramaniyan Dhanabalan

• 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.

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.

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.

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