SNEHA PAWAR
Phone: +91-983*******
Email – *****.*****.*******@*****.***
Career Objective
Experienced Power BI Developer with 5 years of hands-on expertise in data modeling, dashboard creation, and end-to-end BI solutions. Eager to contribute advanced data visualization and analytical skills to a forward-thinking organization while continuing to grow as data analytics professional and support strategic business initiatives
Professional Synopsis
Having 5 years of hands-on experience in end-to-end Power BI report and dashboard development.
Expertise in DAX, Power Query, data modelling, and performance tuning.
Proficient in integrating data from multiple sources: SQL Server, Excel, Oracle.
Skilled in requirement gathering, stakeholder communication, and business analysis.
Experienced in deploying reports to Power BI Service and managing workspaces and security.
Strong analytical, problem-solving, and data storytelling capabilities.
Experience in Creating Power BI report authoring dynamic (RLS), dashboard design
Imported data from multiple data sources into BI Tools, cleaning data through ETL process, created relationships between data, adding calculated columns and measures using DAX.
Able to create measures, attributes, hierarchies and relationships in Power BI.
Creating the reports as per client’s requirements in the form of table, matrix and Sub report.
Also good at creating different visualizations using slicers, KPIs, tree maps, donut, pie chart,
Adopt in developing, publishing and scheduling Power BI reports as per the business requirements
Ability to work independently
Interact with customer on daily basic also get report documentation and user training
Requirement gathering & stakeholder management, having agile/scrum methodology experience.
EDUCATION QUALIFICATION
Bachelors of Mechanical
Engineering
Pass out 2020 G.H.Raisoni College Of Engineering and Management, Jalgaon
Diploma Pass out 2017 G.H.R.Polytechnic, Jalgaon
10th Pass out 2014 R.R.Vidyalaya,Jalgaon
TECHNICAL SKILLS
Business Intelligence Power BI Desktop & Service, Paginated Reports, Power BI Gateway Data Modelling & Analysis DAX Optimization, Star/Snowflake Schemas, Time Intelligence ETL Automation Azure Data Factory, Power Query (M), Power Automate Databases & Scripting SQL Server, Snowflake, Oracle, Governance & Security Row-Level Security (RLS), Data Governance, Version Control Collaboration & Tools Microsoft Excel, SharePoint, JIRA, Agile/Scrum Work Experience
Wipro (Payroll of Dynfolics Technologies Private Limited) Role: Data Analyst – Power BI
Duration – Mar 2022 till date
Cognizant (Payroll of Dynfolics Technologies Private Limited) Role: Data Analyst – Power BI
Duration – Mar 2020 to Feb 2022
Project Exposure
Project 4:
Project Name Mobilization Dashboard – Product & Product Line Level Client FedEx
Technology/Tools Power BI Desktop, Power BI Service, Power Query, DAX Role Power BI Developer
Duration Mar 2024 till date
Description:
This project involved building an enterprise-level Mobilization Assessment Dashboard for tracking the adoption of agile practices across product and product line teams. The dashboard helps leadership monitor progress, coach teams, and prioritize improvements by visualizing sprint-level responses across nine agile practice categories (“proof points”). Key views included color-coded matrix heatmaps at the product and product line levels, drilldowns into responses, scoring logic (Green/Yellow/Red), and trend tracking across sprints. Roles & Responsibilities:
Developed a Mobilization Dashboard to visualize sprint-wise adoption levels of agile practices using matrix visuals with RAG (Red–Amber–Green) indicators.
Built DAX measures for calculating proof point scores, % adoption, and change across sprints based on Yes/No/NA responses.
Created row and column aggregations using weighted scores: Green = 1, Yellow = 0.5, Red = 0.
Designed drill-downs to question/answer-level views with filters for product, sprint, and proof point.
Built tooltips to show detailed scoring breakdown and user comments justifying responses.
Applied field parameters and slicers to toggle between sprints and product lines dynamically.
Managed all backend logic including color rules, scoring tiers, and % green aggregation using Power BI DAX and conditional formatting.
Delivered interactive dashboard pages: Product Level, Product Line Level, Action Plan (No Answers), and Tooltip-based guidance.
Published the dashboard to Power BI Service and managed dataset refreshes via SQL and Excel-based intake forms.
Project 3:
Project Name Finance & Capital Market
Client BNY Mellon Organization Level for region for APAC EMEA Technology/Tools Flat Files, Power BI
Role Power BI Developer
Duration: Mar 2022 – Feb 2024
Description: The main objective was to create interactive dashboard to provide Real Time financial visibility & Capital Market across APAC & EMEA region. The main purpose of this project is to track & analyze Insurance KPI’s such as Total premium, Claims, operating profit, risk exposure & regional performance to make strategic decision for profitability, risk mitigation & regulatory compliance Roles & Responsibilities:
Worked with business stakeholders to gather and analyze reporting requirements across the capital markets and insurance verticals.
Data cleaning in Power query.
Data Modeling – star schema
Integrated Power BI with SQL Server data sources to fetch trading and investment data including securities, asset class distributions, and portfolio allocations.
Implemented DAX (Data Analysis Expressions) functions for Calculated columns and measures.
Provided time intelligence calculations for tracking trends over custom fiscal years (April to March) used in financial planning.
Designed power BI data visualization utilizing Matrix, Ribbon Chart, Decomposition chart.
Created synopsis with Smart Narrative and DAX
Bookmarks, Drill down, RLS
End to end process to deliver the project.
Managing Row Level Security
Deployed report through Gateway
Managing Roles in Power BI Services
Publishing Report via email subscriptions
Project 2:
Project Name Inventory system
Client Yale New Haven Hospital (Health care)
Technology/Tools Power BI
Role Power BI Developer
Duration: June 2021 – Feb 2022
Description: Developed an interactive Power BI dashboard to monitor and manage inventory across multiple locations. The solution provided real-time insights into stock levels, reorder status, stock movement, aging inventory, and out-of-stock alerts. The dashboard helped the organization optimize stock levels, reduce excess inventory, and improve order fulfillment. It also supported forecasting demand trends and tracking supplier performance, leading to more efficient inventory control and cost savings. Roles & Responsibilities:
Involved discussion with business users for gathering the requirements and driving daily call with clients and Translating End- User requirements into Efficient Dashboards.
Import data from different data source to create Power BI Reports and Dashboards.
Developed and maintained multiple Power BI dashboards/reports and content packs.
Creating, developing and deploying data reports and dashboards for large volumes of data in
Power BI. Implement Row Level Security (RLS) as per requirement.
Experience in creating different visualizations like Line, Bar, Histograms, Scatter Plot, Water
Fall, Pie, Area, Donut Charts and Bullet Graph, Heat Maps Tree Maps etc.
Good knowledge and understanding DAX Functions in Power BI.
Designed different types of reports like Drill Down, Drill Through and Sync Slicers. Develop
Visual Level Filters, Report Level Filters and Page Level Filters in Power BI.
Created Workspace and content packs for we users to view the developed reports.
Scheduled Automatic refresh and scheduling refresh in POWER BI service.
Installed and configured Enterprise gateway and Personal gateway in POWER BI service.
Created Book Mark Pane applies to the actions on view details and Text/ Matrix Tables.
Testing in MySQL data base to write query to check the data is matching in Power BI desktop.
Publishing reports to Power BI server and providing the access to required users. Project 1 :
Project Name Supply Chain Management
Client Kaiser Permanente (Health care)
Technology/Tools Power BI
Role Power BI Developer
Duration: March 2020 to May 2021
Description: Worked on a Power BI project for Kaiser Permanente, one of the largest non- profit healthcare organizations in the U.S. The goal was to develop centralized dashboards to monitor supply chain performance across hospitals and clinics. The solution tracked metrics like inventory levels, order fulfillment, supplier efficiency, and equipment availability. Data was collected from multiple systems, including procurement, inventory, and logistics platforms. The dashboard helped improve supply visibility, reduce stockouts, manage costs, and support strategic decision-making for better healthcare service delivery. Roles & Responsibilities:
Involved in requirements gathering and preparing technical documents.
Integrated data from multiple sources like ERP systems (e.g., SAP), procurement platforms, and inventory databases using Power Query and SQL.
Built a robust data model to ensure accurate tracking of materials across warehouses and healthcare facilities
Connect, import, shape, and transform data for business intelligence (BI).
Experience in developing Visualization reports and dashboards using Power BI
Visualize data, author reports, and schedule automated refresh of reports.
Implemented Visual Level, Page level, report level filters and pinning in dashboards.
Written simple DAX calculation as per the requirement to maintain business measures.
Worked on report permissions and dashboard permissions to provide access to different users.
Used Quick insights to get various types of visuals to match the requirements.
Experience on relationship tab to provide cardinality between fact and dimension tables.
Involved creating effective reports, dashboards, and publishing into Power bi service.
Creating the roles for the dashboards, sharing the developed dashboards to the client in power BI.
Personal Details
Name Sneha Pawar
Date of Birth 24-04-1998
Pan Card DKXPP3416H
Marital Status Married
Languages Known English, Hindi, Marathi
Address
18, Gulmohar housing society near Wagh nagar,
Jalgaon
Contact Number 983-***-****
Email *****.*****.*******@*****.***