SOMESHWAR AGASHE
Power BI Developer DAX SQL KPI Dashboards Data Modeling Performance Optimization 952-***-**** *******************@*****.*** Pune, Maharashtra CAREER OBJECTIVE
Power BI Developer with 3+ years of experience in designing scalable dashboards and advanced DAX models. Specialized in delivering business insights through KPI dashboards, sales analytics, and time intelligence. Looking to contribute to data-driven decision making in a growth-focused organization.
SKILLS
BI Tools: Power BI, Power BI Service, Power Query, Paginated Reports Languages: DAX, SQL
Concepts: Data Modelling, KPI Dashboards, Time Intelligence, ETL, RLS Other Skills: Performance Optimization, Report Documentation, Stakeholder Communication EXPERIENCE (3 Years)
1. Power BI Developer Dec 2021 – Oct 2024
Randstad India (Deputed to NVIDIA)
Roles & Responsibilities
Pune, Maharashtra
Gathered & analyzed business requirements by coordinating with various stakeholders including team leads, managers, SMEs, and sales teams to develop tailored BI solutions.
Extracted, transformed, & loaded data from SQL Server databases, ensuring data integrity and quality for accurate reporting.
Designed and implemented scalable and efficient data models using Power BI Desktop, creating relationships among multiple tables to support complex business analysis.
Developed, tested, and maintained interactive Power BI dashboards and reports that provided insights into team performance metrics, sales trends, and operational KPIs.
DAX calculations and measures to drive meaningful KPIs such as monthly sales growth, average team productivity, and region-wise performance.
Scheduled & monitored data refreshes in Power BI Service, troubleshooting any failures to maintain up-to-date reports.
Performed regular data validation through SQL queries and cross-verification with source systems to ensure accuracy & reliability of BI outputs.
Collaborated cross-functionally to incorporate feedback and evolving business needs into dashboards, ensuring continuous improvement.
Optimized data models and DAX queries to enhance report performance and minimize load times for end-users.
Prepared and delivered ad-hoc reports and presentations to management for strategic decision-making.
Maintained comprehensive documentation of data sources, report development processes, DAX formulas, and refresh schedules for knowledge sharing and audit purposes.
Ensured compliance with data governance and security policies while handling sensitive business. PROJECTS-
1. Labeling Team Performance Dashboard
• Built a Power BI dashboard to track weekly performance of the data labeling team.
• Created DAX measures for productivity, task accuracy, and turnaround time.
• Implemented dynamic filters by team member, week, and task category.
• Helped operations team identify bottlenecks and improve labeling speed by 20%. 2. GPU & Motherboard Sales Analysis
• Developed a sales analytics dashboard using Power BI for GPU & motherboard products.
• Used DAX to calculate QoQ Growth, Cumulative Sales, and RANKX for top products.
• Visualized sales trends using Year-Quarter line chart, store-level bar charts, and KPIs.
• Enabled business to optimize inventory and identify top-performing SKUs per region. 2. Power BI Developer Dec 2024 – Aug 2025
Stark-IT Solutions Pvt. Ltd.
Freelance / Contract-Based Projects
Roles & Responsibilities
• Developed & deployed Power BI dashboards for retail & finance domains with actionable KPIs.
• Built DAX measures for QoQ Sales, Forecast Accuracy & Store/Product Ranking.
• Integrated data from Excel, SQL Server & SharePoint into optimized data models.
• Applied RLS, slicers & drilldowns to enhance usability & secure access.
• Managed scheduled refresh & report publishing via Power BI Service.
• Collaborated with clients for requirements, feedback & iterative improvements. PROJECTS -
1. Retail Sales Performance Dashboard
• Created an end-to-end Power BI solution for a retail chain client.
• Implemented DAX measures for QoQ Sales, Profit %, and Store Ranking.
• Improved decision-making on inventory allocation and store focus. 2. Financial KPI Tracker
• Built interactive dashboard to track monthly revenue, expenses, and profitability.
• Enabled department-wise drilldowns and role-based access via RLS.
• Used advanced DAX for Forecast vs Actual and Trendline visuals. EDUCATION
Bachelor OF Engineering 2015 - 2019
Sant Gadge Baba Amravati University
ACHIEVEMENT
Automated daily KPI monitoring using SQL + Power BI, saving 4+ hours/week of manual effort.
Created reusable templates, reducing dashboard development time by 30%.
Improved dashboard adoption by 40% through stakeholder feedback loops and UX enhancements.