Data Analyst Power Bi

Bhuwan Purohit

716-***-**** *******************@*****.*** www.linkedin.com/in/bhuwanpankajpurohit PROFILE

Data Analyst with 5+ years of experience in finance, supply chain, and healthcare. Expert in SQL, Power BI, Tableau, and Python for building scalable data models, automating ETL, and delivering dashboards that drive cost savings and strategic insights. Experienced in applying Artificial Intelligence and Machine Learning to enhance analytics and reporting. Technical skills: SQL, Python (pandas, NumPy), Power BI (DAX, Power Query Editor), Tableau, Looker, Qlik, Excel, VBA, Data Modeling, ETL, Azure Data Factory, Alteryx, Snowflake, SSRS, MySQL, T-SQL, NoSQL, Oracle, Agile Scrum, MS Office, SharePoint, CI/CD pipeline, A/B Testing, Data Warehousing, Azure, AWS, GCP, Statistical Analysis, Data Governance, ServiceNow, R programming, SAP, KPI tracking Microsoft Certified: Power BI Data Analyst Associate(PL-300), Fabric Data Engineer Associate(DP-700), Azure Data Fundamentals(DP-900) EDUCATION

University at Buffalo - Master’s in Business Analytics (GPA: 3.93/4.0) Jun 2025 Relevant Coursework: Applied AI, Machine Learning, Healthcare Analytics, Supply Chain Analytics, Financial Modeling, Data Warehousing Nagpur University - Bachelor of Engineering (GPA: 3.62/4.0) May 2021 Relevant Coursework: Python, SQL, DBMS, Statistics, Data Visualization, Cloud Computing, Project Management, Data Modeling PROFESSIONAL EXPERIENCE

Business Data Analyst – University at Buffalo Oct 2024–Jun 2025

• Built interactive Tableau dashboards using calculated fields, parameter controls, level-of-detail expressions, and dynamic filters to track key revenue KPIs across 3 departments, enhancing leadership visibility and cross-functional alignment.

• Performed deep financial analysis using advanced SQL (CTEs, window functions, joins, subqueries) on complex financial datasets, identifying a 12% YOY decline in a core unit and driving pricing, operational, and strategic improvements.

• Automated recurring reports by developing end-to-end data pipelines in Python and SQL, including data cleaning, transformation, and scheduled extracts; improved report accuracy, availability, and reduced manual effort by 40%.

• Designed data models and optimized SQL queries to integrate data into a centralized database, supporting scalable data warehouse. Data Analyst – Infosys Ltd Feb 2022–Jun 2024

• Designed and deployed 10+ interactive Power BI dashboards using DAX, Power Query Editor, and M language to monitor Azure cost trends, resource utilization, and KPIs, resulting in a $20K/month reduction in spend through actionable BI insights.

• Automated recurring Power BI reporting processes by implementing auto-refresh schedules, row-level security (RLS), and paginated reports, enabling self-service analytics and reducing manual effort by 5+ hours weekly for cross-functional business users.

• Built scalable star schema data models in SQL Server and Power BI to support enterprise BI reporting, optimizing fact and dimension tables for query performance, accuracy, and data governance across multiple reporting layers.

• Wrote and optimized complex SQL queries using CTEs, window functions, and stored procedures to analyze multi-terabyte datasets, reducing data processing time by 60% and improving report accuracy by 98% for month-end financial and operational dashboards.

• Developed and maintained ETL pipelines using Azure Data Factory and Python to extract, transform, and load data from diverse sources (e.g., Blob Storage, SQL, REST APIs) into Azure Synapse, improving data quality and reducing reporting latency by 35%.

• Published Power BI reports to the Power BI Service, integrated Power Apps, managed stakeholder access, set up auto-refresh, and maintained reports, with integration of AI and copilot reducing manual reporting effort by 40%.

• Managed and deployed over 100+ Azure resources using Azure DevOps, VS Code, and CI/CD workflows, improving cloud provisioning speed by 2 hours per deployment, while documenting all procedures for team knowledge sharing and DevOps governance. Business Operations Analyst – Sanghi Automotive Pvt Ltd Jan 2020–Feb 2022

• Automated invoicing and billing processes using Python (Pandas, NumPy) for data cleaning, advanced Excel functions (VLOOKUP, IF, SUMIFS), and VBA macros, reducing manual work by 40% and improving accuracy in financial tracking.

• Designed interactive dashboards in Amazon QuickSight by querying structured data with SQL from Redshift and Athena, and connecting to datasets in Amazon S3, enabling real-time analysis of sales and supply chain KPIs for executive decision-making.

• Conducted cost optimization and supply chain analytics by cleaning and transforming multi-source data using Python (Pandas) and SQL, driving a 20% revenue increase and $10K in annual cost savings through strategic pricing and vendor negotiations.

• Migrated Excel reports to AWS QuickSight and Athena using Advanced SQL queries and Python. PROJECT EXPERIENCE

Retail BI & Data Warehouse Project: Collaborated with stakeholders to gather reporting requirements and define KPIs. Designed a star schema data warehouse in Oracle using SQL and Apache Airflow for ETL processes. Integrated Salesforce CRM data to enrich customer insights. Developed interactive Tableau dashboards using calculated fields, filters, and custom visualizations to analyze sales trends, inventory performance, and customer behavior, enabling data-driven forecasting and strategic decision-making. AI Agent project: Built an AI-Powered Data Retrieval Agent using Llama 3.2: Built a local AI agent with Llama 3.2 and Ollama to enable on- device inference and semantic search. Developed a Retrieval-Augmented Generation (RAG) pipeline using Python, PyTorch, and vector databases (FAISS/Chroma) to retrieve context-aware results from structured and unstructured datasets. Fine-tuned the model with embeddings for improved query accuracy and integrated data preprocessing, transformation, and feature engineering workflows.

Contact this candidate