Power Bi Developer

Sumedh Athawale

POWER BI DATA ANALYST

Tirupati Apartments, Hinjewadi Phase 1, Pune 411057

+91-730*******) I ******.*************@*****.***

Summary A results-driven Power BI Developer highly skilled in data analysis and predictive analytics. I have a proven track record of enhancing business efficiency by leveraging advanced SQL queries and effective data visualization to deliver actionable insights that supported strategic initiatives. I excel at collaborating with cross-functional teams, ensuring both data integrity and accuracy throughout the development life-cycle. I approach challenges with an analytical and driven mindset, consistently solving complex problems. I am dedicated to achieving demanding development objectives, delivering impeccable code and meeting tight schedules. 5.2 years of experience developing robust Power BI dashboards and reports using SAP HANA and Snowflake datasets, with strong expertise in SQL, Python-based ETL pipelines, and data performance optimization. Work Experience Cognizant – Payroll (Dynfolics Technologies Pvt. Ltd.) Pune, India POWER BI DEVELOPER Nov. 2023 - Till Date

• Built databases and table structures for web applications.

• Coordinated deployments of new software, feature updates and fixes.

• Corrected, modified and upgraded software to improve performance.

• Designed and developed forward-thinking systems that meet user needs and improve productivity.

• Used statistical methods to analyze data and generate useful business reports.

• Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.

• Enhanced business efficiency by identifying trends and patterns in complex datasets.

• Produced monthly reports using advanced Excel spreadsheet functions.

• Improved decision-making processes with accurate data analysis and visualization techniques.

• Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.

• Implemented robust control measures to improve analytical output reliability.

• Developed and maintained data pipelines for seamless flow of information, ensuring timely availability for decision-making.

• Improved data visualization techniques, making insights more accessible to non-technical stakeholders.

• Optimized data collection methods to enhance quality and volume of data captured for analysis.

• Analyzed data to identify root causes of problems and recommend corrective actions.

• Developed customized reports, summarizing and presenting data in visually appealing format.

• Provided technical support for troubleshooting analytics and reporting issues.

• Created data models to support decision-making processes.

• Increased model accuracy by fine-tuning hyperparameters and employing rigorous validation techniques.

• Enhanced business decision-making by building interactive dashboards and visualizations using Python libraries.

• Proactively identified potential bottlenecks within data processing workflows, implementing corrective measures to maintain optimal perfor- mance.

• Collaborated with cross-functional teams to integrate data science solutions into existing systems, streamlining operations.

• Integrated third-party APIs into existing systems to automate data collection and expand analytical capabilities further.

• Designed and implemented end-to-end data pipelines using Microsoft Fabric components including OneLake, Lakehouse, and Warehouse.

• Developed and managed Lake houses to store structured and semi-structured data for analytical workloads.

• Developed and optimized KQL queries for live dashboards and anomaly detection in streaming scenarios.

• Integrated lot/Telemetry/Clickstream data pipelines into Microsoft Fabric for real-time decision making.

• Automated data ingestion from multiple sources (on-prem, Azure Blob, SQL DBs, APIs) into Microsoft Fabric using ADF pipelines.

• Utilized Microsoft Fabric Data Warehouses for high-performance querying and BI reporting. Sep 11, 2025 1

• Managed multiple high-priority projects simultaneously, consistently meeting deadlines while maintaining attention to detail.

• Proved successful working within tight deadlines and a fast-paced environment.

• Tested and deployed scalable and highly available software products.

• Conducted data modeling, performance and integration testing.

• Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.

• Built databases and table structures for web applications.

• Designed and developed forward-thinking systems that meet user needs and improve productivity.

• Utilized data visualization tools to effectively communicate business insights.

• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

• Facilitated knowledge sharing by creating centralized data repository accessible to all relevant parties.

• Automated routine data analysis tasks, freeing up time for more complex analysis.

• Created dashboards to monitor and track key performance indicators.

• Identified patterns and trends in large data sets and provided actionable insights.

• Collaborated with stakeholders to identify business needs and data sources.

• Used statistical methods to analyze data and generate useful business reports.

• Developed and maintained data pipelines for seamless flow of information, ensuring timely availability for decision-making.

• Analyzed data to identify root causes of problems and recommend corrective actions.

• Utilized Microsoft Fabric Data Warehouses for high-performance querying and BI reporting.

• Established data modeling standards and optimized storage using Delta Lake formats within OneLake.

• Developed and managed lake houses to store structured and semi-structured data for analytical workloads.

• Integrated Fabric lake houses and Warehouses with Power BI to enable self-service and enterprise reporting.

• Built Power BI semantic models directly on top of Fabric datasets for performance-optimized, real-time reporting.

• Created custom dashboards and DM measures based on data hosted in Fabric Lakehouse and OneLake.

• Leveraged Direct Lake mode in Power BI for high-speed data querying from Fabric.

• Provided technical support for troubleshooting analytics and reporting issues.

• Enhanced team's analytical capabilities with training on latest data analysis tools and techniques.

• Developed machine learning models with Python to predict customer behavior, resulting in improved marketing strategies.

• Created RESTful APIs using the Django REST framework, enabling seamless communication between front-end and back-end components.

• Designed responsive user interfaces with HTML, CSS, and JavaScript for optimal viewing on various devices.

• Designed and deployed Power BI dashboards leveraging SAP HANA and Snowflake as primary data sources for real-time business insights.

• Developed and optimized complex SQL queries for Snowflake and SAP HANA, significantly improving report performance

• Stayed current on developments in related Python frameworks.

• Integrated Java-based web services into database management projects using Python.

• Automated data ingestion from multiple sources (on-prem, Azure Blob, SQL DBs, APIs) into Microsoft Fabric using ADF pipelines. Ascendots Consulting & Services Pvt. Ltd. Pune, India POWER BI ASSOCIATE Oct. 2020 - Jan. 2022

• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

• Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.

• Managed large-scale databases to ensure timely access to critical information for key stakeholders.

• Contributed to development of predictive models, aiding in forecasting of market trends.

• Collaborated with IT to ensure data security measures were in place, safeguarding sensitive information.

• Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.

• Conducted comprehensive data analysis to support strategic planning, leading to more informed decision-making.

• Streamlined reporting processes, resulting in faster turnaround times for monthly performance reports.

• Developed complex dashboard and reporting tools to track business performance metrics.

• Created dashboards to monitor and track key performance indicators.

• Deployed predictive analytics models to forecast future trends.

• Built hybrid data movement flows using ADF mapping data flows and copy activities with Microsoft Fabric as sink. Scheduled data refreshes and implemented error handling, logging, and monitoring of data flows into Fabric Lakehouse and Warehouse. Infosys Ltd. Pune, India

SYSTEM ENGINEER Jan. 2022- Oct. 2023

Sep 11, 2025 2

Education Maharashtra Institute of Technology Aurangabad

BACHELOR'S OF TECHNOLOGY IN ELECTRICAL

Government Polytechnic Nanded

DIPLOMA Jun. 2016

Pratibha Niketan High School Nanded, India

SSC Mar. 2013

Projects Fixed Assets & Business Plan (Real Estates) DAMAC Group—UAE POWER BI DEVELOPER Jul 2024 - Present Date

• Objectives: Identify areas for improvement, and make data-driven decisions. These dashboards typically focus on property management, and financial performance, offering a real-time overview of the business's progress. It keeps record of capital foundation such as land, buildings and development infrastructure from the operational base of real estate business. It keeps track of investment justification investment long term growth, valuation and depreciation of Fixed assets. Also, it helps to stakeholders to evaluate the physical and financial risks tied to the properties such as market volatility.

• Responsibilities: As a proficient Power BI Developer and Data Analyst, I am responsible for the complete lifecycle of interactive dashboards and reports, transforming complex data into actionable insights for stakeholders. My expertise includes designing and building Power BI solutions from conception to deployment, leveraging custom SQL queries for data extraction and transformation, and performing robust data modeling to manage relationships between diverse datasets. I excel in writing advanced DAX functions, creating calculated columns and measures to enable comprehensive data analysis. A key focus of my work involves implementing Row-Level Security (RLS) to ensure data privacy and compliance. I am adept at optimizing SQL queries and database systems to guarantee high performance and responsiveness. Furthermore, I automate data refresh schedules in Power BI, significantly reducing manual effort (e.g., by 40 /0), and publish reports on Power BI Service to facilitate real-time access and seamless collaboration. My role consistently involves conducting in-depth data analysis to identify trends and patterns, followed by presenting clear, concise findings and strategic recommendations through effective visualizations and presentations to inform critical business decisions.

HR Recruitment Performance & Hiring DAMAC Group-UAE POWER BI DEVELOPER Dec 2023 – Jun 2024

• Objectives: HR Recruitment dashboard and reporting to monitor workforce needs and track recruitment process and gaps in staffing. It aligns hiring goals with business strategy. Optimize resource planning by identifying trends and bottlenecks. Also optimize resource planning and support data-driven HR decision making. It forecast workforce demand based on business growth and requirement and project needs. Track open position and recruitment progress and identify skill gaps and improve the efficiency through real time metrics.

• Responsibilities: In my role, I was instrumental in driving data-driven decision-making, beginning with in-depth data analysis on over 1 million records which directly led to a 30% improvement in business decision-making by identifying critical trends. I was responsible for the full life cycle of data manipulation and reporting, developing, maintaining, and optimizing complex SQL queries and T-SQL stored procedures to efficiently extract, manipulate, and analyze data from various relational databases. A key focus involved analyzing existing SQL queries for performance enhancements, subsequently suggesting and deploying new queries and database code to ensure optimal system performance. I specialized in creating highly interactive dashboards and reports using both Tableau and Power BI, visualizing key metrics and trends for diverse stakeholders. This included importing and validating data into BI tools from various sources like SQL and Excel, leveraging DAX and Power Query for robust data reporting and visualization. A significant achievement involved streamlining data validation and mining processes through automation, which reduced data processing time by 50%, thereby enhancing overall decision-making accuracy and efficiency. Throughout the project, I actively collaborated with cross-functional teams to thoroughly understand their business requirements, translating them into effective analytical solutions, and consistently presented clear, concise findings and strategic recommendations to stakeholders through compelling visualizations and presentations.

Warehouse Management Blackand Decker

DATA ANALYST- POWER BI Dec 2022 – Sep 2023

• Objectives: Warehouse summary dashboard determines monitoring of real-time inventory visibility, of instant access of stock level across all the warehouses, stores. It detects stock imbalances (overstock, under stock, stock outs situations) Dashboard evaluate Inventory Optimization level. Reduce excess inventory and minimize cost controls. Improve Decision-Making, use data-driven insights to make smarter purchasing. Track Inventory Performance and monitoring turnover ratio. It improves and support demand Forecasting ratio and reduce operational costs.

• Responsibilities: In this project, I was responsible for the end-to-end development of Power BI solutions. This included actively participating in requirements gathering and Scrum calls, documenting detailed business rules, and performing data transformations using Power Query/Query Editor. I specialized in creating robust data models in Power Pivot, developing DAX measures and columns to enhance visuals, and designing hierarchies and drill-down reports. I regularly created and presented multiple visual options to stakeholders, integrated custom visuals, and published Microsoft Power BI Dashboards to the Power BI Service. Aurangabad, India

Sep. 2016 - Aug. 2019

Sep 11, 2025 3

Transformation And Maintenance ABB Ltd.

DATA ANALYST- POWER BI Feb 2022 – Nov 2022

• Objectives: ABB is one of the top companies in word for electrical and transformation product manufacturing basically in this requirement they want to analyze overall nine applications which is used by their employees in day today work Also they want track every KPI of these applications.

• Responsibilities: In this project, I managed the full life cycle of project phases, encompassing development, testing, and ongoing support. My role began with defining project scope, meticulously gathering business requirements, and conducting thorough analysis to produce essential documentation. I was responsible for building robust data models in Power Pivot, effectively establishing relationships between various tables. To enhance reporting capabilities, I consistently created new columns and measures using DAX functions and implemented various filters, including visual, page, and report level filters, as per specific reporting needs. I expertly utilized a diverse range of visualizations such as Matrix, Column and Bar charts, Tree maps, Waterfall charts, and Card Visualizations, and designed sophisticated reports including drill-down, drill- through, and interactive slicers. Furthermore, I developed custom report tool tips to display multiple data points efficiently within a single report, creating highly customized and interactive reports and dashboards in Power BI. A critical aspect of my work involved implementing Row- Level Security (RLS) at both region and zone levels to ensure data governance. Finally, I was responsible for completing all final documentation of reports during deployment and facilitating a smooth handover to the client. Logistics and Freight Forwarding MAERSK

DATA ANALYST - POWER BI Nov 2020 – Dec 2022

• Objectives: Maersk provide real-time visibility and insights into the movement, management, and efficiency of freight forwarding and logistics operations. This helps stakeholders optimize delivery performance, reduce costs, and improve customer satisfaction. Monitor Shipment Status, Optimize Operation Cost, track on-time delivery rate. Shipment transit time. And check volume of shipment, also track total number of shipments on transit time. Cost shipment wise and Demurrage and detention of yard and warehouse. It keeps record of warehouse turnover rate.

• Responsibilities: As a key contributor, I was responsible for the full life cycle of BI report and dashboard development, extending through User Acceptance Testing (UAT) to ensure data accuracy and alignment with critical business goals. I collaborated closely with stakeholders to gather and translate complex requirements into actionable insights and comprehensive Business Requirement Documents (BRDs). My role also involved building both canvas and model-driven PowerApps, designing intuitive interfaces that optimized business workflows. I seamlessly in- tegrated Power Apps with Data verse, SharePoint, and various external data sources. Furthermore, I designed dynamic galleries and conditional forms, implementing automated validations to significantly enhance the overall user experience. Skills

• Power BI

• Advance SQL

• Data Visualization

• DAX Queries

• Data Modeling

• Power Query

• CTE

• Snowflake

• Predictive Analysis

• Performance metrics analysis

• BI reporting tools

• ETL development

• Agile development methodologies

• Data Warehouse

• Query Optimization

• Real Time Analysis

• Effective Communication and team work.

Software

• Microsoft Power BI

• SQL

• Snowflake

Sep 11, 2025 4

Languages

• Marathi

• English

• Hindi

Additional Information

• Date of Birth : 13th Jun, 1998

• Temporary Address : Tirupati Apartments, Hinjewadi Phase 1, Pune 411057

• Permanent address : Anjai Niwas Prabhat Nagar Near Nagsen Highschool, Nanded 431605

• PAN Number : BXFPA7874M

• Mobile No. : +91-730*******

Declaration

• I hereby certify that all the information furnished above is correct to the best of my knowledge and belief and I promise to abide by all the norms laid down by your esteemed organization. Sep 11, 2025 5

Contact this candidate