Sandeep Mallick

Junior Data Analyst / Web Developer

sandeepmallick7254@gmail.com | 9555812368

Linkedin | Github

PROFESSIONAL SUMMARY

Motivated and detail-oriented Data Analyst with a solid foundation in visualization, and statistical analysis to extract meaningful insights and support data-driven decision-making an creating interactive dashboards and performing trend analysis and Skilled in front-end web development using HTML, CSS, and JavaScript to build responsive, user-friendly interfaces.

TECHNICAL SKILLS

  • Languages : Python,JavaScript,HTML,CSS,R
  • Tools & Technologies:MySQL,Excel,Power BI,GitHub,WordPress
  • Skills: Data cleaning,Google Spreadsheet,Data Visualization,Dashboard Creation,Responsive Web-Page

PROJECTS

1.Employee-Trends-Dashboard

This project is an Excel-based Employee Data Analysis Dashboard that visualizes workforce trends, salary distribution, and attrition insights. The dataset includes employee job roles, departments, salaries, demographics, and exit dates.

  • Raw Data Sheet (employee_data) – Contains employee details like job title, department, salary, hire date, and exit date.
  • Dashboard (VISUAL) – Tools Used Excel Pivot Table , Power Query , Data Visualizing key insights.
  • 2.Inventory-Management-System--GUI

    This is a GUI-based Inventory Management System built using Python, Tkinter, and MySQL and The application provides an interactive interface to manage inventory records, making it easy to add, update, delete, select, and export inventory data stored in a MySQL database.

  • Graphical User Interface (GUI) A connection function is defined to establish a link between the application and the MySQL database, allowing data storage and retrieval.
  • Graphical User Interface (GUI) built using Tkinter.
  • 3.Llama-Mini-Chatbot-Extension

    Sandeep AI is a lightweight Chrome extension that brings the power of Llama API right into your browser you Ask questions, get smart answers instantly, and enjoy a minimalist design for quick interactions.

  • Chat with Llama API from your browser Simple and sleek UI Clear and send functionality Fully client-side Easy to install and use
  • tech used-JavaScript,JSON,HTML,CSS,Llama API,Chrome Extensions API
  • 4.DataVisualization-mysql-python

    This exploratory data analysis (EDA) and advanced SQL queries performed on a customer orders dataset originally provided in Excel format an aslo The dataset was cleaned, transformed, and analyzed using Python and SQL.

  • Tools used-Python (Pandas, NumPy),MySQL,Jupyter Notebook,Excel (for initial exploration).
  • Pandas Converted the data to SQL tables Performed data analysis using complex SQL queries.
  • 4.hotel-cancellation-insights

    This project analyzes hotel booking cancellations using Excel, covering data cleaning, exploration and visualization.

  • Tools Used Excel Pivot Table , Power Query , Data Visualization.
  • Data Exploration A separate data filtering sheet helps analyze Previous cancellations Assigned vs. requested rooms Booking lead time Guest types (couples, families, etc.).
  • 5.Close-Tabs-Extension

    The Close Tab Chrome extension allows users to quickly close the active browser tab with a single click or shortcut. This lightweight extension improves browsing efficiency by reducing the need for multiple clicks.

  • Closes the current tab instantly you can Works with a browser action button and its also Lightweight and fast.
  • Easy and very useful feature its save your time an make your work efficient
  • EDUCATION

  • BCA
  • Bachelor of Computer Application (2023–2025)

  • O Level Certification
  • National Institute of Electronics and Information Technology - (NIELIT)

    SOFT SKILLS

  • Quick Learner
  • Strong Communication
  • Analytical Thinking
  • Time Management
  • Attension to Detail