Bhuwan Purohit

Associate Consultant

Buffalo, New York, United States5 yrs experience

Key Highlights

Saved over $100K/month in cloud costs at Infosys.
Developed actionable insights using Power BI for climate analysis.
Led sustainability initiatives promoting environmental change.

Stackforce AI infers this person is a Data Analytics and Business Intelligence professional with a focus on Cloud Computing.

Contact

Skills

Core Skills

Power BiData AnalyticsBusiness IntelligenceCloud Computing

Other Skills

AzureBusiness Intelligence ToolsBusiness ResearchDAXData ModelingData TransformationETLMicrosoft AzureMicrosoft ExcelMicrosoft Power BIMicrosoft SQL ServerProject ManagementPython & RPython (Programming Language)SQL

About

I am a data-driven professional with expertise in data analytics, business intelligence, and cloud computing. I specialize in transforming complex data into actionable insights using SQL, Power BI, Tableau, and cloud-based ETL pipelines. At the University at Buffalo, I use Power BI and DAX to analyze climate vulnerabilities, and at Infosys, I optimized Azure cloud costs, saving over $20K per month, while delivering end-to-end BI solutions. Passionate about data storytelling and process automation, I am seeking opportunities in data analytics and business intelligence to support data-driven decision-making. Core Skills: - SQL – Writing complex queries, optimizing database performance, and managing relational databases - Power BI – Creating interactive dashboards, utilizing DAX for advanced calculations, and publishing reports - Tableau – Developing dynamic visualizations, implementing calculated fields, and integrating multiple data sources - Python & R – Performing statistical analysis, machine learning, and automation for data preprocessing & transformation - Data Modeling – Designing star and snowflake schemas, normalizing data, and ensuring efficient storage and retrieval - ETL – Extracting, transforming, and loading data using Power Query, SQL, and cloud-based ETL tools - Cloud Computing – Managing and optimizing Azure cloud resources along with working with cloud databases

Experience

University at buffalo

Data Analyst Student Assistant

Oct 2024 – Jun 2025 · 8 mos · Buffalo, New York, United States

I am a part of the Student Sustainability Impact Team (SSIT) at UB Sustainability, where I contribute to impactful, high-visibility sustainability projects on campus while supporting UB’s 10-in-10 Climate Action Plan. As an SSIT member, I actively work on initiatives like green office certification, campus garden maintenance, and materials reuse programs—all aimed at reducing our carbon footprint and promoting sustainable practices.
I also had the opportunity to collaborate with the university to gain insights into climate vulnerabilities. I worked on a project where I received and researched relevant data to generate deeper insights. Using Power BI, I performed data transformations through Power Query Editor and created DAX measures to develop insightful visualizations, helping analyze climate vulnerabilities across different regions worldwide.
Beyond these projects, we also organize events like ReUSE, where items typically discarded by graduating students—such as table fans, lamps, notebooks, and heaters—are collected and redistributed to students in need, promoting a circular economy and reducing waste. Additionally, we run the Hired Pop-Up, an initiative that provides students with professional attire, including coats, pants, and formal shirts, to support their career readiness.
Looking forward to making a meaningful impact and collaborating with like-minded individuals to drive positive environmental change! ♻️🌍

Statistical Data AnalysisMicrosoft Power BIMicrosoft ExcelBusiness ResearchProject ManagementPower BI+1

Infosys

Business Intelligence Analyst

Feb 2022 – Jun 2024 · 2 yrs 4 mos · Hybrid

As part of the Business Intelligence, Cloud Computing, and Data Analytics team at Infosys for Bausch Health, I contributed to optimizing cloud resources and delivering impactful business intelligence solutions. My key responsibilities included:
Managing the deployment, deletion, and maintenance of over 100 servers on Azure.
Leading the creation of an end-to-end project in Power BI, focused on optimizing Azure resource costs.
Developing Legacy OS reports in Power BI and Tableau for the Director, providing insights to drive informed business decisions.
Integrating data from multiple databases to develop and maintain key reports.
Cleaning and transforming data using ETL tools and Power Query Editor in Power BI.
Designing interactive dashboards and creating measures and columns to enhance data visualization, publishing reports to Power BI Service for stakeholders.
Preparing and submitting an Azure cost optimization report, resulting in savings of over $100k/month in cloud resource costs.
Collaborating with cross-functional teams to address priority incidents, providing solutions to mitigate data loss risks.
This experience allowed me to hone my skills in cloud management, data transformation, and cost optimization while delivering value to the organization through actionable insights and solutions.

Microsoft Power BISQLMicrosoft AzurePython (Programming Language)Microsoft SQL ServerTableau+4

Pankaj sales corp

Business Intelligence Analyst

Jan 2020 – Feb 2022 · 2 yrs 1 mo · Hybrid

I worked as a Business Intelligence Analysts. I contributed to both sales and operations while streamlining the accounting and reporting processes. I spearheaded day-to-day operations and sales efforts to drive revenue growth, building and maintaining strong relationships with clients and vendors. A major part of my role involved transitioning the business from manual record-keeping to a more efficient digital system. I organized and updated all sales and purchase logs in Excel spreadsheets, replacing outdated pen-and-paper methods, which significantly improved accuracy and efficiency.
Additionally, I developed detailed reports and insights from the data I managed, providing valuable market insights that helped my father identify growth opportunities and make informed business decisions. I was also responsible for creating invoices and billing statements using the updated spreadsheets, ensuring accurate financial documentation and timely transactions. Through my focus on increasing sales and improving operational efficiency, I played an active role in boosting the company’s revenue and overall success.
By modernizing our processes and leveraging data for strategic insights, I contributed significantly to the growth and efficiency of our family business.