Bhupesh Dewangan Data Analyst · Data Science Portfolio
View work
Cisco Certified Data Analyst

Turning raw data into decisions people can trust.

I am Bhupesh Kumar Dewangan, a data analyst and aspiring data scientist focused on analytics, dashboards, machine learning, and business-ready insights. I build clean workflows across Python, SQL, Excel, Power BI, and cloud tools to move from messy data to clear outcomes.

Let’s work together LinkedIn GitHub
FocusAnalytics & ML
StrengthBI + Python
BaseBhilai, India

About me

This section presents a cleaner and stronger professional summary for recruiters, collaborators, and hiring managers evaluating your portfolio.

Profile

B.Tech graduate in Computer Science with a strong interest in data analysis, machine learning, and statistics. My work centers on transforming raw information into dashboards, stories, and predictive models that support real decisions.

I am comfortable working with data cleaning, exploratory analysis, feature engineering, model selection, evaluation, and visualization. I also bring a builder mindset from web development, DSA practice, and project-based learning.

Data storytelling Business dashboards Feature engineering Interview ready projects

Current direction

Deepening foundations

Sharpening statistics, machine learning concepts, and applied analytics thinking.

Building project depth

Creating stronger project narratives around SQL, Excel, BI, Python, web scraping, and ML workflows.

Career focus

Preparing for data analyst and data science roles with portfolio-ready case studies and cleaner presentation.

Data Analyst Resume Data Science Resume

Work experience

This section adds real-world delivery, product impact, and engineering depth to your profile so your portfolio reflects both project work and professional execution.

Python Web Developer

Arosys Technologies

Oct 2025 – Present
  • Reduced report generation time by 70% by automating complex Excel-based workflows using Python and Django, and applied multithreading to parallelize heavy data processing for a US-based client product.
  • Improved information accessibility and engagement by developing a RAG-based AI chatbot using web scraping, vector embeddings, and LLM APIs to deliver context-aware answers from dynamic web content.
  • Increased application reliability and scalability by containerizing the full application with Docker and deploying it on GCP to support concurrent users with stable production-like performance.
  • Enhanced backend scalability and modularity by designing RESTful APIs with Django, enabling seamless frontend integration and structured data exchange across multiple application components.

Data Analyst

Riverhouse Technologies

Nov 2024 – Oct 2025
  • Drove data-informed UX improvements for the Truleague product by analyzing user behavior with Microsoft Clarity, Hotjar, and UXCam, contributing to a 30% increase in user engagement.
  • Engineered scalable data and AI solutions, including GCP Sentiment Analysis integration and a RAG-based chatbot using Pinecone, OpenAI API, AWS Lambda, and S3.
  • Built Node.js pipelines to process data and automatically sync insights into Google Sheets for smoother operational workflows.
  • Automated analytics and reporting by developing a full-stack AI report generator with Flask and Azure GenAI, reducing report creation time by 70% and enabling faster executive reporting through Redash dashboards.

Technology and Product Intern

Astroanalytics · Remote

Aug 2022 – Jan 2023
  • Built a responsive WordPress website to improve the company’s digital presence and ensure accessibility across devices.
  • Configured and designed landing pages in Systeme.io and MailerLite, optimizing email automation workflows for targeted campaigns and lead capture.
  • Created Figma designs for code-based website implementation, contributing to both product presentation and marketing execution.

Skills stack

Your original skills list was long but visually flat. This version groups it into clear capability areas that scan faster and look more professional.

Data analysis

SQL, PostgreSQL, MySQL, BigQuery, Excel, data cleaning, transformations, and structured querying.

Business intelligence

Power BI, Looker Studio, dashboards, KPI tracking, visual storytelling, and reporting layouts.

Python ecosystem

Pandas, NumPy, EDA, notebooks, Colab, Jupyter, automation, and exploratory workflows.

Machine learning

Regression, trees, SVM, KNN, clustering, ensembles, preprocessing, evaluation, and feature engineering.

Cloud & tools

GCP, AWS, Docker, Git, GitHub, VS Code, PyCharm, and collaborative development practices.

Apps & deployment

Streamlit, Django, Flask, REST APIs, dashboards, and lightweight analytical application delivery.

Frontend basics

HTML, CSS, Bootstrap, better UI structure, and portfolio presentation improvements.

AI-assisted workflow

Using modern AI tools carefully for ideation, debugging, productivity, and faster project iteration.

Freelance services

Available for freelance contracts, consulting roles, and custom data product delivery. Here is how we can work together.

Backend Development

Building secure, scalable web APIs and backend workflows using Django and Flask. Expert in multithreading data processing, custom web scrapers, and integrating RAG architectures or LLM APIs into stable products.

PythonDjangoFlaskREST APIsDocker

Data Analytics & BI

Transforming complex enterprise datasets into simple, intuitive operational data stories. Crafting automated Power BI and Looker Studio dashboards that monitor core KPIs, track conversions, and point out optimization areas.

Power BILooker StudioEDAData StorytellingKPIs

Excel Automation

Eliminating slow, error-prone manual calculations by replacing spreadsheets with automated tools. Writing high-speed script layers that read, format, update, and export massive multi-sheet business pipelines instantly.

Advanced ExcelAutomationData CleaningReporting Pipelines

SQL & Database Architecture

Writing performant database scripts to clean up unorganized raw data models. Constructing optimized queries, table joins, views, and index solutions across SQL environments for fast execution and reporting ready delivery.

SQLPostgreSQLMySQLBigQueryQuery Tuning

Selected projects

I kept your original categories, but reframed them as stronger portfolio cards with clearer value and cleaner calls to action.

Analytics

Data Analyst Projects

Projects focused on SQL, Excel, Power BI, Python, web scraping, BigQuery, and Looker Studio. Designed to show how you extract, clean, model, and communicate insights from raw data.

  • SQL
  • Excel
  • Power BI
  • Python
  • BigQuery
Show projects
Machine learning

Data Science & ML Projects

Projects built with Python, Streamlit, and core machine learning algorithms, covering EDA, modeling, evaluation, and interactive application delivery.

  • Python
  • Streamlit
  • Scikit-learn
  • Keras
  • TensorFlow
Show projects
Engineering

Software Engineering Projects

Web development and DSA-based work that shows coding discipline, structured thinking, and the ability to build software beyond notebooks and dashboards.

  • HTML/CSS
  • Django
  • C++
  • DSA
  • Problem solving
Show projects

Contact

A portfolio contact area should be simple and direct. I kept your form idea, but made the section cleaner and more trustworthy.

Reach me directly

For internships, analyst roles, collaborations, or project discussions, these are the fastest ways to connect.

Location

Bhilai, Chhattisgarh, India

Quick message