Showkat Jamil

Skills & Certifications

Skills

Programming & Data Tools: Python, R, SQL, ETL, Tableau, Power BI, Microsoft Excel, Google Analytics
Database Management: Microsoft Visual Studio, MySQL, SSAS, SSIS, Oracle, PostgreSQL, Microsoft Azure
Machine Learning & Analysis: EDA, hypothesis testing, predictive modeling, forecasting, statistical modeling, time series forecasting
Business Strategy: Data visualization, KPI tracking, trend analysis, supply chain management, demand planning, project management, strategic decision-making

Certifications

📘 Microsoft Certified: Azure Data Fundamentals
📊 Google Data Analytics Professional Certificate

Projects

AI Dynamic Pricing Model – Kpop Dance Company

Developed a demand-driven pricing engine using Python, SQL, SSIS, and Power BI to optimize pricing strategies, achieving 92% accuracy and projecting 15% revenue growth. Built ETL pipelines and predictive models to analyze customer demographics and demand trends. Sole contributor under the supervision of Dr. Son Bui.

Tools: Excel, Visual Studio, SSIS, MySQL, Python, Power BI

🔒 Please Contact me for the main code

Sample Output:

Predicting Real Estate and Housing Prices with AI

Created a relational database and implemented machine learning models to predict housing prices using historical datasets. Achieved 89% accuracy through EDA, regression techniques, and supervised learning. Sole contributor.

Tools: Visual Studio, SQL, Python, ML

💻 View full Code (IPYNB)

Comparison of Predictive Model Performance:

Would You Like to Invest in Connecticut Real Estate?

Designed a compelling data story using Power BI and 20+ years of sales data to uncover trends in real estate investment potential. Presented actionable insights using regression-based ROI forecasts, city-level comparisons, and property-type analysis. Supervised by Dr. Vinaayaka Gude.

Tools: Excel, Power BI, Python, SQL

📄 View Data Story

Movie Ticket Demand Analysis – Cinemark

Built an interactive dashboard visualizing variation in movie ticket demand by weekday and showtime. Enabled dynamic analysis through filters on ticket price and movie ID, supporting decision-making in pricing and scheduling.

Tools: Power BI, Excel, Python

📄 View Dashboard

Industry Projects

Mini Home Coming – In-House Integration of Mini Soap Production

A strategic cost-saving initiative at Unilever to relocate mini soap production from a third-party (3P) facility to an in-house line at the KGF factory. The team tackled NMSCC costs (BDT 7.4 Cr/year), transport inefficiencies, and quality issues through RCA, 5G analysis, and targeted Kaizens on billet instability, packaging defects, and conveyor jamming.

The result: BDT 5.6 Crore/year cost savings, 3000Tons/year additional capacity, 3% NMSCC cost reduction, and a 0.045% improvement in skincare gross margin (GM) — all with minimal Capex. This project laid the foundation for future expansion and operational excellence.

Tools:Data Analysis, predictive analysis, Root Cause Analysis, 5G, Kaizen, Strategic Ops, Capacity Planning, Cross-Functional Team Collaborations,Supplly Chain Management,Engineering

📄 View Case Study

About Me