Sigit Dwiantoro
Data Analyst · Turning Complex Retail Data into Actionable Insights
About Me
I transform complex datasets into actionable business decisions by bridging the gap between Management strategy and Technical Data Analytics. Data shouldn't just be seen; it should be used to drive resilience and efficiency.
My most recent high-impact project involved developing a Retail Network Intelligence Dashboard for a nationwide chain, visualizing 557 outlets to track operational compliance and geographic intelligence. I specialize in Data Engineering (Python, SQL), Business Intelligence (Power BI, Looker Studio), and Risk/Fraud Analysis.
As a Management graduate who speaks the language of both business and data, I bring an analytical rigor to help companies optimize operations, track KPIs, and maximize profit margins.
Education
Core Competencies
Technical Skills
Tools & Technologies
Analytical Domains
Retail & Logistics Analytics
E-Commerce optimization, Supply Chain Control Towers, Inventory Forecasting (ROP), SLA Breach Tracking.
People / HR Analytics
Employee Retention Dashboards, Attrition Cost Calculators, What-If ROI Simulation, Churn Prediction.
ESG & Climate Intelligence
Carbon Credit compliance modeling, Historical Temperature Anomaly Monitors, Green Tech Dashboards.
Legal & Compliance Risk
Enterprise-grade Risk Mitigation Dashboards, Real-time legal dispute tracking, Geospatial risk mapping.
Experience & Projects
Developed and implemented an end-to-end data analytics workflow for large-scale customer datasets, focusing on churn prediction and behavioral segmentation. Built and optimized a Random Forest model (~93% accuracy) and designed interactive Power BI dashboards. Applied K-Means Clustering for behavioral segmentation.
Built an enterprise-grade Looker Studio Dashboard for real-time risk mitigation across 557 nationwide branches. Automated detection for leases (< 90 days), tracked legal disputes, and mapped geographic risk clusters from raw datasets.
Engineered a predictive Supply Chain Control Tower visualizing Reorder Points (ROP) and logistics bottlenecks (> 20 days lead time). Mapped geospatial market growth heatmaps and built a Sentiment Architecture via SQL to process customer reviews into actionable product lifecycle metrics.
Developed an end-to-end HR dashboard evaluating 1,470 employees to track attrition triggers (e.g. Overtime burnout, commute correlation). Featured an "Attrition Cost Calculator" (DAX) highlighting a $17.15M potential loss and What-If scenarios simulating ROI for strategic HR interventions.
Managed project data, documentation, and reporting to ensure seamless stakeholder coordination.