Power Bi Data Analyst

Pranav Jogladevikar

Certified Power BI & Azure Data Analyst

+91-727******* *************@*****.*** Pune, India LinkedIn: https://www.linkedin.com/in/pranav-jogladevikar-9367a7316/ Professional Summary

Certified Data Analyst with 4.6 years of relevant experience in business intelligence and data modeling using Power BI, SQL, and Excel, with a strong foundation in Azure Data Services (Data Factory, Databricks, Synapse). Skilled in transforming raw data into actionable insights through dashboards and visual storytelling. Strong operational background from a mechanical engineering career, now focused on delivering data-driven solutions in real-world business environments. Key Skills & Tools

BI Tools: Power BI (DAX, Power Query, Power BI Services), Excel (Advanced formulas, PivotTables),

Databases: SQL Server, Azure SQL DB, SSMS

Azure Stack: Data Factory, Databricks, Synapse Analytics, Data Lake Gen2, Blob Storage (Lab-based)

ETL & Data Modeling: Dimensional modeling, Star schema, KPI tracking, M code

Other: SharePoint, Git (ADF repo), Jira, Agile methodology, Figma Professional Experience

Conference Technology Inc. Pune, Maharashtra (March 2024 – Jan 2025)

(Power BI Analyst)

Roles and Responsibilities: -

Delivered actionable insights to C-suite stakeholders by translating complex data into strategic recommendations, resulting in enhanced business operations and improved customer experience.

Revamped Power BI reports with modern UI/UX design principles—standardizing layouts, optimizing visual hierarchy, and enhancing interactivity—resulting in a 40% boost in user satisfaction and faster decision- making.

Built interactive dashboards, statistical reports, and advanced visualizations in Power BI to drive data- informed decisions across departments—enhancing executive visibility and improving operational efficiency by 30%.

Extracted and integrated data from multiple enterprise sources including on-premise SQL Server, cloud-based SharePoint Online, and Excel files stored in OneDrive and local network drives. Ensured secure and reliable data connections for real-time reporting and automated refresh cycles in Power BI.

Optimized complex SQL queries using indexing strategies, subquery refactoring and CTEs resulting in up to 50% reduction in data retrieval time for large-scale datasets.

Connected Power BI to SharePoint Online lists and document libraries using OData feeds and REST APIs, enabling real-time collaboration and automated data updates.

Performed robust data modeling by defining relationships between fact and dimension tables, implementing star and snowflake schemas to ensure data accuracy, integrity, and optimized query performance in Power BI.

Conducted comprehensive data transformation tasks in Power Query and DAX, including column merging, value appending, custom column creation, and duplicate removal—ensuring clean, analysis-ready datasets for accurate reporting.

Streamlined dataflow migration and automated scheduled refreshes across workspaces, enhancing data reliability and reducing refresh failures by 25%. Implemented MTD, YTD, and dynamic calendar functionalities using DAX to support advanced time intelligence analysis.

***

Professional Experience

Bhagyalaxmi Rolling Mill (Polaad) Pvt.ltd Jalna, Maharashtra (July 2020 – Feb 2024) Data Analyst

Designed and delivered Power BI and Excel-based performance tracking reports for sales and manufacturing operations, enabling real-time visibility and contributing to a 20% increase in revenue through data-driven decision-making.

Designed and styled bookmarks, slicers, and action buttons in Power BI to enhance user interaction, streamline navigation, and improve overall report usability and adoption.

Utilized advanced DAX measures to implement complex time intelligence calculations including YTD, QTD, MTD and YOY growth enabling accurate trend analysis and performance benchmarking across reporting periods.

Configured Power BI Gateway for real - time updates and implemented Row - Level Security (RLS) for secure access

Developed custom dashboards and reports using Power BI to support data-driven decision-making

Optimized data models and refined schema structures to improve report performance, ensure scalability, and support high-volume data analysis in Power BI

Tuned SQL Joins, filters and aggregations to enhance Power BI Performance when connecting via Direct Query and Import mode.

Created stored procedures and views to centralize logic and reduce redundancy, improving maintainability and performance.

Built and deployed Power BI reports with SQL-based data models; managed Azure Data Factory pipelines for nightly data refresh.

Introduced Databricks notebooks and Delta Lake to improve data processing, reducing load times by 40%

Employed Azure Synapse SQL pools for centralized data warehousing and efficient analytical queries

Actively participated in Agile ceremonies Daily Stand-ups, Sprint Reviews, Retrospectives) with Jira backlog and sprint tasks monitoring.

Mechanical Maintenance Engineer (Apr 2016 – Jun 2020)

Managed plant machinery maintenance and preventive schedules

Prepared production analysis reports using Excel

Collaborated with operations to reduce downtime and improve efficiency Education

Bachelor of Mechanical Engineering – 7.4/10 CGPA

(Dr. Babasaheb Ambedkar Marathwada University A’bad) - 2021 Certifications

Microsoft Certified: Power BI Data Analyst Associate (PL-300) Microsoft Certified: Azure Data Fundamentals (DP-900) Languages

• English Marathi Hindi

Declaration

I hereby declare that all the facts given above are true and correct to the best of my knowledge.

Contact this candidate