Pooja Gunjkar
Data Analyst
About
Analytical Data Analyst with 2 years in business intelligence and analytics, specializing in Power BI and SQL Server. Skilled in data extraction, transformation, modeling, and visualization, leveraging Power Query, DAX, and Row-Level Security. Developed interactive dashboards and automated reporting processes to analyze business data and identify trends for informed decision-making.
Skills & Expertise (34)
Work Experience
Junior Data Analyst
Technosoft Engineering Projects Pvt. Ltd.
May 2023 - Jun 2025
Developed interactive Power BI dashboards to monitor sales, orders, revenue, profitability, customer behavior, product performance, and delivery metrics. Gathered reporting requirements and converted business needs into interactive dashboards using Power BI Desktop. Designed a dimensional data model using Star Schema to improve report scalability and query performance. Performed data cleansing, transformation, and integration from multiple relational tables using Power Query. Automated data preparation by creating reusable ETL workflows, significantly reducing manual processing efforts. Developed advanced DAX measures for KPIs, enabling comprehensive performance tracking of Total Sales, Order Count, Average Order Value (AOV), Repeat Customers, Customer Retention, On-Time Delivery %, and Year-over-Year Growth. Implemented time intelligence calculations such as YTD, MTD, QTD, previous year sales, running totals, and moving averages. Built drill-through reports, bookmarks, custom tooltips, dynamic titles, slicers, and navigation buttons to enhance report usability. Implemented Static and Dynamic Row-Level Security (RLS) using USERPRINCIPALNAME() to provide secure role-based data access. Optimized report performance by reducing model size, optimizing DAX calculations, removing unnecessary columns, and applying best practices in data modeling. Published reports to Power BI Service, managed workspaces, dashboards, scheduled refreshes, and report sharing. Configured an on-premises data gateway to enable scheduled refresh for SQL Server data sources. Implemented incremental refresh strategies to improve refresh performance for large datasets.
Business Analyst (Intern)
Apparatus Solution Pvt. Ltd.
Sep 2022 - Jan 2023
Developed Power BI dashboards to visualize data insights for media and advertising projects.
GAT
Fiat India Automobiles Pvt. Ltd.
Nov 2017 - May 2019
Worked in the Manufacturing Industry.
Education
Bachelor of Science: Electrical Engineering - Savitribai Phule Pune University
2013 - 2017 · India
Science - Maharashtra State Board
2012 - 2013 · Afghanistan
SSC - Maharashtra State Board
2010 - 2011 · Afghanistan
Certifications
Power BI and SQL Developer
Velocity Institute · 2022
Here I have completed certification for Power BI and SQL with DAX, Data modelling etc
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Not Open to Relocation
Skills (34)
Click a skill to find developers with the same skill
