Portfolio - Archana Maruti Pandhare

Archana Maruti Pandhare

Data Analyst

[email protected]

PHONE

+91 9284102030

Download CV

About Me

Passionate Data Professional with 4 years of experience in transforming complex data into actionable insights.

Worked on impactful projects across domains, including 2 years on a geospatial analytics project for Microsoft.

Specialized in building interactive dashboards, KPI scorecards, and reports using Power BI, DAX, and Power Query.

Skilled in SQL, Excel, and Python, with a strong foundation in data modeling (Star & Snowflake schemas) and data cleansing.

Experienced in gathering business requirements, performing GAP analysis, and aligning technical solutions with strategic goals.

Proficient in implementing row-level security (RLS), configuring Power BI Gateway, and automating report refresh schedules.

Adept at translating business questions into BI solutions that drive better decision-making.

Strong communicator and collaborator with experience working in Agile/Scrum teams.

Always curious and continuously learning to stay updated with the latest BI tools and industry trends.

3

PowerBI Projects

Key Skills

Power BI

SQL Server

Excel

Python

My Projects

My Experience

Cyient Ltd – Power BI Developer
Jun 2023 – Dec 2024 | Pune, India
Domain: Geospatial Analytics | Tools: Power BI, Azure DevOps, SQL Server, SharePoint

Collaborated with a Microsoft client to build interactive dashboards focused on revenue, market share, and user feedback analysis.
Created performance maps and KPI visualizations to improve operational efficiency and strategic planning.
Managed dataset refresh schedules, configured workspaces, and shared insights with stakeholders.
Ensured secure data access using row-level security and delivered seamless report experiences with scheduled refreshes.

Neo soft Ltd – Software Engineer
Mar 2023 – May 2023 | Pune, India
Domain: Manufacturing Analytics | Tools: Power BI, Excel, SQL

Developed performance dashboards to monitor plant production, wastage, and recovery trends across global locations.
Designed visuals including map, waterfall, donut, and bar charts to highlight regional KPIs and product-level cost breakdowns.
Calculated monthly wastage % using actual waste over total production to identify operational inefficiencies.
Scheduled data refreshes via Power BI Service, integrating SQL Server and SharePoint data sources for real-time analytics.

Ever seen Ltd – Data Analyst
Sep 2021 – Aug 2022 | Pune, India
Domain: Finance & Healthcare Analytics | Tools: Power BI, Excel, SQL Server

Designed credit card analytics dashboards with drilldowns by region, category, and payment method.
Used DAX to derive insights such as average transaction value, cashback per customer, and failure rates.
Built healthcare dashboards visualizing billing, treatment, and service data segmented by location and service type.
Enabled flexible data exploration using slicers and enhanced UX with optimized visuals and layout.