Dharshini A

Senior Data Analyst

Chennai, Tamil Nadu, India 5+ yrs exp 90 · Outstanding

About

Data Analyst with 5+ years of experience in data analysis, business intelligence, reporting, data validation, and process improvement, with experience supporting large-scale customer and utility datasets. Hands-on experience with SQL, Snowflake, Power BI, Python, Excel, DAX, and Power Query for data analysis, dashboard development, reporting, data quality analysis, and automation. Experienced in analyzing customer, provider, meter, account, credential, billing statement, and interval usage data to identify data issues, monitor operational metrics, perform root cause analysis, and support data delivery. Skilled in developing interactive Power BI dashboards, creating analytical reports, automating recurring reporting processes using Python, and translating large datasets into actionable insights for business and cross-functional teams. Strong experience working with cross-functional teams including Product, Customer Success, Account Management, and technical teams to investigate data issues, validate results, track actions, and support resolution.

Skills & Expertise (37)

SQL Advanced

8.5/10

Years Exp

Power BI Advanced

8.2/10

Years Exp

Python Advanced

8.0/10

Years Exp

Data Analysis Advanced

8.0/10

Years Exp

Excel Automation Advanced

7.8/10

Years Exp

Data Visualization Advanced

7.5/10

Years Exp

Snowflake Pandas NumPy Reporting Automation KPI Reporting MySql Microsoft Excel Pivot Tables LOOKUP functions Data Validation Root Cause Analysis KPI Analysis Operational Reporting Process Improvement CASE Statements Query writing Select WHERE GROUP BY HAVING Aggregate Functions Joins Subqueries Business Reporting Date functions Window Functions Dashboard Development DAX Power Query Data Modelling Interactive Visualizations

Work Experience

Senior Data Analyst

Urjanet – Now Part of Arcadia

May 2021 - Present

Analyze and support the delivery of utility billing statements and interval usage data for enterprise customers including EnergyCAP, AT&T, Voltus, Palmetto, Ivy Energy, and Walmart, supporting 64K+ meters across 53 active customers. Work with large-scale utility datasets covering approximately 1.6M accounts and 233K credentials, performing data analysis and reporting to support customer data delivery and operational requirements. Develop Power BI dashboards and analytical visualizations to analyze customer and provider output, providing visibility into interval-data status, pending meters, extraction issues, provider issues, and customer actions such as login failures, MFA issues, password resets, and site availability issues. Perform Root Cause Analysis (RCA) on data-delivery exceptions and categorize issues across Customer Action, Provider Action, and Arcadia Action to support issue prioritization and resolution. Analyze customer data stored in Snowflake and develop interactive dashboards to provide stakeholders with visibility into customer-level operational metrics and data status. Develop Python-based reporting automation using Pandas and Excel, reducing monthly reporting effort from approximately 3 hours to 20 minutes. Develop a Python-based non-compliance calculation and reporting workflow, reducing the analysis effort from approximately 2 hours to 10 minutes. Use Python to process operational datasets, apply business logic, calculate required metrics, and generate structured Excel outputs for recurring reporting requirements. Collaborate with Product, Customer Success, Account Management, and technical teams to investigate data issues, communicate findings, and track resolution of customer and provider-related actions.