Anand Chavan

As a Data Analyst, I am driven by a deep curiosity to uncover meaningful insights and an ambition to continuously expand my expertise. I thrive in environments that allow me the autonomy to independently delve into complex data, applying focused concentration to deliver precise and impactful solutions.

Experience

U

Data Analyst

UAS IT Consultancy Services Pvt. Ltd · Jul 2024 – Present

Not yet confirmed

• Cleaned, validated, and consolidated financial records from 5+ source systems using SQL and Advanced Excel, maintaining 99% data accuracy across monthly reporting cycles.
• Built and maintained 10+ Power BI dashboards tracking KPIs and financial trends for 4 business units, replacing manual spreadsheet reporting with automated refreshes via Power BI Service.
• Developed 40+ DAX measures and calculated columns across 5 data models to support department-level financial analysis.
• Wrote and optimised SQL queries (joins, subqueries, CTEs, views) to streamline data extraction and mentored 3 junior analysts on query design and reporting standards.
• Reduced MIS documentation turnaround by 25% by redesigning recurring daily, weekly, and monthly reporting workflows.
• Partnered directly with finance and cross-functional stakeholders to translate reporting requirements into analytical solutions used in day-to-day decision-making.
• Analyzed large datasets using SQL and Power BI to surface seasonal spending patterns and operational bottlenecks for business unit leaders.
• Investigated historical transactional records with SQL and Power BI to surface purchasing trends, seasonal patterns, and data anomalies for business leadership.
• Consulted regularly with department leads to define analytical requirements and guarantee delivered dashboards met internal reporting standards.

Data Analyst

UAS IT Consultancy Services · Jul 2024 – Present

Not yet confirmed

• Deliver finance reporting and business analytics support across revenue tracking, operational performance, and management reporting, partnering directly with stakeholders to ensure data accuracy and timely insight delivery.
• •      Extract, clean, and validate financial data from multiple source systems using SQL and Advanced Excel, achieving 100% accuracy in downstream reporting
• •      Design and maintain interactive Power BI and Tableau dashboards tracking KPIs, revenue trends, and operational performance for leadership decision-making
• •      Write and optimize complex SQL queries (joins, subqueries, CTEs, views) to streamline data extraction and reduce report turnaround time
• •      Automate daily, weekly, and monthly MIS reports, reducing manual reporting effort and improving consistency across teams
• •      Build DAX measures, calculated columns, and scalable data models in Power BI to support advanced analytical reporting
• •      Configure scheduled data refreshes in Power BI Service, ensuring dashboards always reflect current financial data
• •      Conduct trend and pattern analysis on large datasets to surface insights driving operational and financial improvements
• •      Partner with cross-functional stakeholders to translate reporting requirements into clear, actionable dashboards and presentations