Sagnik Guha

Aspiring Data Analyst

Kolkata, India 0+ yrs exp 82 · Excellent

About

Aspiring Data Analyst and Python Developer with hands-on portfolio work across 8 analytics, machine learning, dashboard, and Flask projects. Skilled in Python, SQL, Excel, Pandas, NumPy, data cleaning, exploratory data analysis, feature engineering, regression modeling, forecasting, model evaluation, dashboard reporting, API routes, and business storytelling. Built projects covering gaming demand forecasting, dynamic fare pricing, real estate price prediction, Airbnb analytics, automotive sales dashboards, emerging technology trends, Netflix content analysis, and Spotify music trends. Experienced in analyzing 50,000+ survey responses, building predictive models with approximately 0.91 test R2, creating 30+ dashboard/report assets, and documenting projects for recruiter review.

Skills & Expertise (48)

Python Intermediate

6.5/10

Years Exp

SQL Intermediate

6.3/10

Years Exp

Excel Intermediate

6.1/10

Years Exp

Pandas Intermediate

5.9/10

Years Exp

NumPy Intermediate

5.9/10

Years Exp

KPI Reporting R² Flask HTML CSS JavaScript Git GitHub Jupyter Notebook VS Code Google Colab Pytest Gunicorn Analytical Thinking Problem Solving Clear Communication Team Collaboration Attention to Detail Time management Adaptability Business-Oriented Thinking Forecasting CSV Data Wrangling Data Cleaning EDA Statistical Analysis Aggregation Filtering scikit-learn XGBoost Regression Models Visual Storytelling Feature Engineering Model Evaluation MAE RMSE R² Matplotlib Seaborn Plotly Chart.js Excel Dashboards

Work Experience

Secure Web-Based Photo Vault Project

Visual Vault

Apr 2023 - Dec 2023

Led development of a secure web-based photo vault using HTML, CSS, PHP, and Apache. Designed logos, banners, navigation menus, and user-facing interface elements for a complete web project. Delegated tasks to team members, coordinated weekly progress reviews, and supported project planning and delivery.

Web Development Intern

Ardent Computech Ltd.

Jul 2022 - Oct 2022

Contributed to front-end development, responsive page layouts, and structured UI components for web pages. Improved user experience through navigation updates, organized layouts, and clean visual presentation. Collaborated with team members to understand requirements, update interface elements, and support web-delivery tasks.