Punithavalli c

Senior Data Analyst

Chennai, India 4+ yrs exp 89 · Excellent

About

Data professional with 4+ years of experience in data analytics, ETL/ELT, data integration, data transformation, and BI. Skilled in SQL, Python, PySpark, Spark SQL, pipeline design, data quality, source-to-target validation, and dimensional modeling. Working knowledge of the Azure data stack, including Azure Data Factory, ADLS Gen2, Azure Databricks, Azure Synapse Analytics, and Microsoft Fabric (Lakehouse, OneLake, Dataflows Gen2, Delta Lake), with DP-700 certification. Experienced in building reliable, analytics-ready datasets for Power BI and Tableau reporting.

Skills & Expertise (53)

Power BI Advanced

8.5/10

Years Exp

SQL Advanced

8.0/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Stakeholder Management Intermediate

7.5/10

Years Exp

Data Cleansing Intermediate

7.0/10

Years Exp

Data Validation Intermediate

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Alteryx Intermediate

6.5/10

Years Exp

Data Orchestration Intermediate

6.0/10

Years Exp

ETL Intermediate

6.0/10

Years Exp

Azure Data Factory Intermediate

6.0/10

Years Exp

Snowflake Schema Agile Root Cause Analysis Incremental Loads Data Reconciliation Source-to-Target Validation Data Quality Checks Dimensional Modeling Relational Modeling Star Schema Executive Reporting Medallion Architecture Troubleshooting Pandas NumPy Joins Aggregations Requirements Gathering KPI development Trend Analysis Stored Procedures PySpark Spark SQL Tableau Power Query Zoho Analytics Advanced SQL MySql Snowflake CTEs Window Functions Data Integration Query Optimization Microsoft Azure Azure Databricks Azure Synapse Analytics Microsoft Fabric Lakehouse OneLake Delta Lake Batch Processing Data Ingestion

Work Experience

Senior Data Analyst

Clootrack

Nov 2022 - Present

Developed and maintained Power BI dashboards and reports using Power Query, DAX, data modeling, KPIs, filters, drill-downs, and business-defined reporting logic. Used Advanced SQL to extract, join, transform, aggregate, and validate data from multiple sources for analytical reporting and client requirements. Developed and maintained data preparation and transformation workflows using Alteryx, Domo Magic ETL, SQL, and Power Query to cleanse, standardize, and prepare datasets for downstream reporting. Performed source-to-target validation, data reconciliation, data quality checks, and root cause analysis to identify missing values, duplicates, inconsistencies, and metric discrepancies. Created reusable SQL transformation logic for staging, joining, aggregation, business rules, and downstream analytical datasets. Collaborated with business stakeholders, data engineering, and QA teams to gather requirements, troubleshoot data/reporting issues, validate fixes, and deliver accurate analytical outputs. Supported KPI monitoring and business analysis through Power BI and Domo dashboards, translating data trends into actionable reporting insights.

Data Analyst Intern

Mtab Technology

Jan 2022 - Oct 2022

Extracted, cleaned, and processed data from primary and secondary sources to support data analysis, reporting, and business intelligence activities. Assisted in developing and optimizing ETL workflows for integrating data from multiple sources into analytics platforms. Performed data cleaning, reconciliation, validation, and quality checks to improve the reliability and consistency of reporting datasets. Designed and maintained interactive Zoho Analytics dashboards to monitor KPIs and improve reporting efficiency. Used advanced Excel techniques including VLOOKUP and automated Macros to streamline data preparation, reconciliation, and reporting, reducing manual effort by 30%.