Dhiya M

Dhiya M

Data Analyst
India
Malayalam, English

About Me

DataScience postgraduate skilled in Python, SQL, Excel, Power BI, and Tableau, with internship experience in analytical problem-solving, automation, and exploratory data work. Good at interpreting raw data into clear fin…

Experience

Saint-Gobain Pvt Ltd
Jul 2024 - Aug 2024 · 1 month

Cleaned and analyzed VRSG machine-operation data using Python to reveal module-usage trends and support operational planning.
Conducted shift-wise EDA with Seaborn boxplots to detect workload imbalance across Shifts A, B, and C, informing scheduling recommendations.
Built time-gap heatmaps and feed-rate analyses with Matplotlib to flag high-idle machines and prioritize maintenance actions.

AIENSURED

Developed Power BI dashboards with advanced KPIs and What-If analyses for banking and retail datasets, automating routine reports.
Automated SQL workflows and integrated Python Dash with SQL Server to streamline data refreshes and reduce report latency.
Documented end-to-end AI pipelines (preprocessing, feature engineering, SHAP explainability), improving model reproducibility and data quality.

PROJECTS

Customer Churn Analysis (Credit Card) — SQL, Python, Tableau

SELF
Duration : 09-Sep-2025 - 18-Sep-2025

Performed churn analysis identifying a 16% churn rate and uncovering low-engagement customer segments causing attrition. •Highlighted high-risk demographic groups and built a Tableau dashboard that enabled targeted retention and marketing actions.

AdventureWorks Manufacturing Analysis — SQL Server, Python, Power BI

SELF
Duration : 11-Aug-2025 - 22-Aug-2025

•Analyzed multi-year manufacturing and inventory data, uncovering long lead times and large stock accumulation impacting throughput. •Built DAX-driven Power BI dashboards that exposed key bottlenecks, improving oversight of production efficiency and on-time completion rates.

VendorSales Summary — SQL, Python, Power BI

self
Duration : 13-Aug-2024 - 29-Aug-2024

Consolidated sales and purchase data to identify that top vendors drove 65% of total procurement, revealing dependency risk and guiding diversification strategies. •Flagged significant slow-moving inventory value and built a Power BI dashboard to improve procurement visibility and decision-making.

Skills

Programming: Python (Pandas NumPy) SQL (Joins CTEs Window Functions) BI Tools: Power BI (DAX) Tableau Data: Data Cleaning & EDA Data Modeling ETL Analytics: Statistical Analysis Trend Analysis KPI Design Other: Excel (PivotTables Power Query) Git Data Visualization Python Pandas NumPy SQL Joins CTE Window Functions Power BI DAX Tableau Data Cleaning EDA Data Modeling ETL Statistical Analysis Trend Analysis KPI Design Excel PivotTables Power Query Git Data Visualization SQL Server Python Dash Seaborn Matplotlib SHAP
Report this Profile?