Mohammed Sinan A K

Mohammed Sinan A K

Data Analyst
India
Malayalam, English

About Me

Mail ID : [email protected]

I am a data analyst , I use Python, SQL and BI tools to turn messy tables into reports teams use. I completed Bachelors in Computer Application specialized in Data, Machine learning.

My r…

PROJECTS

HR Analytics and Insights Report

Duration : 30-Jun-2025 - 31-Jul-2025

Built a full-cycle HR analytics solution in Tableau to deliver executive summaries, workforce demographics, salary insights, and detailed employee records in one interactive dashboard. - Dashboard Design: Created multi-view dashboard with Overview, Demographics, Income, and Employee Records modules to enable both high-level KPIs and granular employee lookups.- Data Modeling: Structured HR data for analysis, including department, job title, location, education, gender, and salary, ensuring accuracy across all visualizations. - Key Insights: Exposed gender pay gaps by education level, identified salary-age trends per department, and visualized HQ vs branch workforce distribution for staffing decisions. - Efficiency Gains: Centralized reporting reduced manual spreadsheet analysis and improved decision-making speed for HR managers by enabling instant filtering and export.

Supply Chain Analytics Automation

Duration : 31-May-2025 - 30-Jun-2025

- Integrated Fragmented Data: Automated ingestion of 20,000+ order records across India & US branches using n8n workflows into a centralized PostgreSQL database resolving inventory delays by synchronizing data sources. - Reduced Manual Effort replacing manual CSV uploads with scheduled automation using AI Agentic workflow automation tool, projected to save ~15 hours of weekly labor. - Forged an AI-powered data model in Quadratic AI merging orders, customers, products, and exchange rates. - Enabled KPIs like OTIF%, Line/Volume Fill Rates, improving delivery insights.

Hotel Business Data Analysis

Duration : 30-Apr-2025 - 31-May-2025

- Completed a full-cycle business intelligence project in the hospitality sector. Built a Power BI dashboard with KPIs to analyze performance across cities and hotel types. - Dashboard Design: Created interactive dashboards to track RevPAR, ADR, occupancy%, and revenue trends across cities.- ETL & Modeling: Cleaned and modeled hotel data using SQL to ensure analytical accuracy. - Business Insights: Identified underperforming properties and recommended dynamic pricing, improving strategy alignment.

Food Ordering Chatbot

Duration : 28-Feb-2025 - 31-Mar-2025

Built a production style ordering assistant with session memory and item catalog Connected Dialogflow to FastAPI and MySQL with secure CRUD APIsLogged orders intents and errors to support menu and staffing decisions Load tested the pipeline to handle continuous ordering with stable latency

Certifications

Microsoft Certified: Power Platform Fundamentals

Microsoft · Remote · 2024

Data Analysis with Python

IBM Coursera · Remote · 2024

IBM Data Science Professional Certificate

IBM Coursera · Remote · 2024

Skills

Python Structured Query Language (SQL) MS Excel Power BI Data Analysis and Reporting pandas joins window functions DAX dashboards interactive reporting Excel Probability and Statistics Data Analytics Data Mining Data Visualization ETL MySQL
Report this Profile?