Arjun S

Data Analyst

Avighna Systems Pvt. Ltd.

Mar 2022 - Present

Developed interactive Power BI and Tableau dashboards to support business decision-making and performance monitoring. Extracted and analyzed large datasets using SQL, including Joins, Subqueries, CTEs, Aggregations, and Window Functions. Performed data cleaning, data wrangling, transformation, and validation to improve data accuracy and reporting quality. Built and optimized ETL pipelines using Azure Data Factory and Snowflake for data integration and reporting automation. Conducted descriptive and inferential statistical analysis to identify trends, patterns, and business opportunities. Automated repetitive reporting and data analysis activities using Python, Pandas, NumPy, Matplotlib, and Seaborn. Improved reporting efficiency using Advanced Excel, including Pivot Tables, VLOOKUP/XLOOKUP, and advanced formulas. Created KPI dashboards and performance reports for stakeholders. Collaborated with business teams to gather requirements and translate business needs into data-driven reporting solutions. Monitored data quality and performed validation and reconciliation to ensure accuracy and consistency. Optimized SQL queries and reporting workflows to improve data retrieval and dashboard performance.