W Mohammed Shuhiab

Aspiring Data Analyst & Computer Science Engineer

Projects Portfolio

Data Analytics and Visualization Job Simulation

June 2024 | Tableau, MS Excel

  • Conducted in-depth analysis of sales data across multiple product categories, identifying key trends and patterns to drive strategic decision-making.
  • Performed extensive data cleaning and preprocessing in Excel (handling missing values, removing duplicates, standardizing formats) ensuring data integrity.
  • Created interactive dashboards and compelling visualizations in Excel using charts, graphs, and conditional formatting for effective stakeholder communication.
  • Executed descriptive statistical analysis via Excel functions and pivot tables to summarize key metrics, uncover trends, and extract dataset insights.

Data Analytics Job Simulation

June 2024 | Python, Excel, SQL, Git

  • Developed an end-to-end Data Analysis Pipeline using Python & SQL, efficiently extracting and transforming large, multi-source datasets into structured formats.
  • Executed data extraction from diverse sources employing SQL and utilized Power Query for robust data transformation, consolidation, and cleaning.
  • Implemented Python scripts to automate repetitive data processing tasks, significantly reducing manual effort and minimizing errors in analysis preparation.
  • Employed Git for rigorous version control, facilitating effective change tracking, version management, and collaboration on analysis scripts and documentation.

Data Visualisation: Empowering Business with Effective Insights

June 2024 | Python, Tableau, SQL

  • Implemented sophisticated data visualizations in Tableau & Excel (treemaps, sunbursts, heat maps, scatter plots) enabling intuitive data exploration.
  • Automated data workflows using Python scripts for extraction, cleaning, and transformation, ensuring data consistency and accuracy for visualization.
  • Developed optimized SQL queries for extracting and transforming data from various sources, integrating seamlessly with visual analytics platforms.
  • Designed interactive Tableau dashboards with advanced features (filters, parameters, story points) delivering actionable business insights for data-driven decisions.

Education

B.Tech - Computer Science & Engineering

Dr M.G.R Educational And Research Institute

Maduravoyal, Chennai

Aug 2021 – Jun 2025 (Expected)

High School

Don Bosco Matriculation Boys Higher Sec. School

Yagappa Nagar, Thanjavur

Jun 2019 – May 2021

Technical Skills

Programming Languages

Java Python C/C++ HTML/CSS PHP SQL

Operating Systems

Windows Linux (RHEL Based)

Tools & Technologies

Git & GitHub MS Excel MySQL Tableau VS Code XAMPP Power Query Data Analysis Data Visualization

Certifications

  • Data Analytics using Google Bard with Excel and Python
  • Python For Data Analysis
  • Data Analytics using ChatGPT with Excel and Python
  • Data Visualization using Tableau