Bhuvan Sai Reddy
Strategic Business Analyst | Bridging Data and Business for Real-World Impact | python | sql | c programming | power BI | Tableau | power query | R | AWS.
02
Years
Experience
2
Projects
Completed
01
Companies
Worked
0
blogs
About Me
Who i amI am a dedicated Data Analyst with a solid foundation in Business Analytics and Computer Science.
- I bring 2 years of experience in data analysis, visualization, and business intelligence, with a focus on leveraging data to solve complex problems. With a keen eye for detail and a passion for insights, I am actively seeking roles in Data Analysis, Product Analytics, and Data-Driven Strategy.
- My expertise includes working with Python, SQL, Power BI, and Tableau to clean, transform, and visualize data, helping organizations make informed decisions. I excel in creating dashboards and performing exploratory data analysis that directly impacts business outcomes.
- I have contributed to projects involving ETL pipeline development, data mining, and predictive analytics. Additionally, I worked on optimizing reporting systems and created automated workflows using Python and SQL, which significantly improved reporting efficiency and accuracy.
Technologies I've been working with:
Languages
- Python
- SQL
- Java
- HTML
- CSS
- GIT
Databases
- AWS
- Google Sheets
- Microsoft Excel
- MYSQL
- Google Collab
ETL Tools
- Prefect
- SSIS
Visualization Tools
- Power BI
- Looker Studio
- Tableau
Developer Tools
- Visual Studio
- Sublime Text
- Pycharm
Libraries
- Pandas
- Numpy
- Matplotlib
- Beautiful Soup
Qualification
Experience & EducationProfessional Experience
Data Analyst-Operations
Company: Cadential Technologies Private Limited |
Bangalore,Karnataka
- Developed an automated email allocation system using Python scripts and GitHub Actions to streamline project communication and improve accuracy.
- Monitored and maintained a tracking system for customer projects, ensuring accurate and timely handovers.
- Performed in-depth data analysis, developing key performance metrics and building dashboards to provide actionable business insights.
- Designed user-friendly data architectures and implemented efficient workflows for seamless data handling and storage, improving operational efficiency.
- Gained hands-on experience with Smartsheet, learning to manage and track projects efficiently using the platform's advanced features.
October 2022 - august 2024
Data Analyst Intern
Company: Cadential Technologies Private Limited |
Bangalore,Karnataka
- Designed and implemented efficient ETL pipelines on live data streams using Apache Airflow, ensuring automated, real-time data ingestion and transformation.
- Applied advanced data analytics techniques on complex datasets, transforming raw data into meaningful insights, and visualized findings using Tableau dashboards for clear, actionable results.
- Designed and implemented efficient ETL pipelines on live data streams using Apache Airflow, ensuring automated, real-time data ingestion and transformation.
February 2022 – October 2022
Education
Bachelor of Information Science Engineering
Presidency University
Bangalore,Karnataka,India
Aug. 2018 – june 2022
Master Of Science in Business Analytics
Hult International Business School
Boston,Masachusetts,United States Of America
Sep. 2024 – Aug 2025
Services
What I doSmartsheet
Analytics
- Integrate Smartsheet with Python and Github Actions to perform effective allocations of various teams involved in projects .
- Using Smartsheet I can create tailored project tracking dashboards that provide valuable insights by visualizing KPIs, optimizing processes, and enabling data-driven decision-making with real-time updates .
- I design custom automated workflows to streamline project management, integrate seamlessly with existing systems, and automate recurring tasks, saving time and reducing errors.
- I create meaningful metrics for dashboards, including milestone tracking, resource utilization, and risk analysis, to ensure projects stay on schedule and address potential challenges effectively.
Data
Analytics
- Data Collection & Integration: Experienced in web scraping to extract structured and unstructured data from websites, transferring it to databases like MongoDB or MySQL for analysis, and automating data pipelines using Python with tools like Selenium, BeautifulSoup, and Scrapy.
- Data Cleaning & Transformation: Proficient in cleaning raw data using Python libraries like Pandas and NumPy, transforming and preprocessing datasets for analysis or visualization, and ensuring data integrity and accuracy for actionable insights.
- Visualization & Reporting: Experienced in designing interactive dashboards with Tableau, Power BI, and Matplotlib/Seaborn in Python, effectively communicating insights through data storytelling and tailored visualizations, and generating reports in formats like PDF, Excel, or live dashboards.
- Automation & Optimization: Proficient in automating routine data analytics tasks with Python scripting and Prefect workflows, creating reusable pipelines for data collection, analysis, and visualization, and optimizing database queries and scripts for enhanced processing speed.
Power BI
Services
- Data Integration: Expertise in connecting Power BI to various data sources, including MySQL, MongoDB, and CSV files, to ensure seamless data import and integration.
- Data Analysis & Modeling: Skilled in transforming raw data into meaningful insights by performing advanced analysis and creating robust data models within Power BI.
- Visualization & Reporting: Proficient in designing interactive dashboards and reports tailored to stakeholder needs, enabling effective decision-making through clear and actionable visualizations.
Projects
Airbnb Project
Tech Stack: Python, Google Sheets, Jupyter Notebook, Google Data Studio
- Developed Python scripts to generate real-time data for multiple facets of the Airbnb project
- Identified key market trends, pricing strategies, and customer preferences
- Engineered data pipelines to seamlessly collect and process data into Google Sheets and Utilized Google Looker Studio for interactive, visually engaging dashboards.
- Created an Airbnb API and hosted on RapidAPI.
Dashboard Link: @Airbnb
Github Link: @Github
Live Weather ETL Dashboard
Tech Stack: Python,Prefect,Selenium, BeautifulSoup, MySQL,Google Sheets,PowerBI
- Orchestrated end-to-end data pipeline utilizing Python, Selenium, and Beautiful Soup for scraping to gather real-time weather data, from microsoft news.
- Maintained MySQL database to efficiently store and manage the weather data, ensuring data integrity and accessibility for downstream analytics.
- Developed interactive visualizations in Power BI, integrating real-time updates from Google Sheets, to provide actionable insights into weather patterns and trends derived from the scraped data.
Github Link: @Github
Brazilian Customer Analysis
Tech Stack: Python,Pyspark, Pandas
- I conducted a comprehensive Brazilian customer analysis, utilizing datasets such as customer information, order details, shipping freight, and order data.
- To analyze this data, I employed powerful data processing tools such as PySpark and Pandas.
- Leveraging the capabilities of these libraries, I performed various analyses on the datasets, extracting valuable insights and uncovering meaningful patterns.
- Through data manipulation, aggregation, and statistical calculations, I gained a deep understanding of customer behavior, order trends, and shipping patterns.
- This analysis provided valuable insights that can inform strategic decision-making, optimize business processes, and enhance customer satisfaction in the Brazilian market
Github Link: @Github
Coffee Market Insights Automation
Tech Stack: Python, Google Sheets, Looker Studio, Github Actions, Smartsheet
- Web Scraping & Data Pipeline: Collected real-time coffee data from multiple websites through web scraping and structured it into Google Sheets. Automated data flow from Google Sheets to Smartsheet using Data Shuttle for seamless integration and analysis.
- GitHub Actions & Reporting: Developed GitHub Actions to automate data processing and ensure up-to-date insights. Designed interactive dashboards in Power BI and Looker Studio to analyze key metrics such as tag popularity, vendor performance, and revenue trends
- Insights & Automation: Created a dynamic, automated weekly report that tracks changes in coffee tag popularity and revenue-driving products. Implemented conditional formatting to highlight high-performing and underperforming tags, enabling data-driven decision-making.
Github Link: @Github
Dashboard Link: @Github
Achievements/Certification
AchievementsAchievements
- Made 4 valid PR contributions on github repositories during the Hacktoberfest and won digital badges
-
- Created and published 4 APIs on RapidAPI.com using FastAPI
-
