Hi, I'm Fityan Hanif Assalmi
Data Analyst focused on BI reporting, social listening analytics, and applied machine learning.
I build data workflows, dashboards, and analytical models that turn business metrics, public digital data, and operational datasets into management-ready insights.
Experience
Data Analyst
Kementerian Kehutanan RI
Built data analysis and data science workflows for large scale public sentiment data from YouTube and multi platform social media sources. Developed Python text processing pipelines, NLP based sentiment analysis, forecasting workflows, and executive Power BI dashboards to support public communication decisions and outreach risk monitoring.
Data Analyst Intern
PT Monster Group
Built an SEO analytics and forecasting workflow for MonsterMAC using Google Analytics and Google Trends data. Designed ETL pipelines, Power BI dashboards, and an LSTM time series model that created a 7 day early warning signal for keyword trend movement and supported a 10% increase in organic website traffic.
Role Fit
One data profile, tailored into recruiter-friendly resume versions for the role context that matters most.
Data Analyst / BI / Oracle
SQL, Oracle, Power BI, KPI reporting, dashboard development, data cleaning, database analytics, and stakeholder-ready reporting.
Resume for BI / Oracle rolesMarketing Analytics / Social Listening
Sentiment analysis, marketplace review analytics, customer insight, brand comparison, digital audience research, and marketing recommendations.
Resume for Marketing Analytics rolesApplied ML / Junior Data Scientist
NLP, time-series forecasting, predictive modeling, feature engineering, model evaluation, and dashboard-based model communication.
Resume for Applied ML rolesSelected Data Portfolio Projects
Projects are curated by role fit: BI and Oracle analytics, social listening and marketing insight, and applied machine learning.
FOLU Talks Social Listening & Risk Intelligence
Recreated a government-style social listening workflow with public FOLU Talks data, turning comments into sentiment, topic, risk, and response intelligence.
FraudShield PaySim Fraud Analytics
Built an end-to-end fraud analytics dashboard using 6.36M PaySim transactions, SQL risk marts, ML scoring, threshold simulation, and an analyst review queue for fraud operations.
Supply Chain Risk Intelligence
Built an end to end supply chain risk intelligence dashboard using 180K+ order records, Python KPI marts, and a leakage aware late delivery prediction model.
Oracle E Commerce Operations Analytics
Built an Oracle database analytics project using 1.5M public e commerce rows, SQL views, PL/SQL validation, seller risk scoring, delivery analysis, and a PostgreSQL monitoring add on.
Somethinc vs Skintific Customer Sentiment & Competitor Insight
Built a real-review analytics dashboard comparing Somethinc and Skintific to identify sentiment gaps, complaint themes, customer perception, and competitor positioning.
Indomie Market Pressure & Business Strategy Intelligence
Built an FMCG market intelligence dashboard to evaluate Indomie's pricing power using marketplace snapshots, competitor benchmarks, demand proxies, and macro margin risk indicators.
Brand Crisis: Aqua vs Le Minerale
Analyzed public sentiment, share of voice, content gaps, and market conversation shifts during the Aqua vs Le Minerale brand crisis.
LSTM Prediction Model
Built an LSTM time series forecasting model using Google Analytics and Google Trends data to support SEO planning with a 7 day early warning signal.
Retail Performance Board
Built an interactive FMCG performance dashboard that processes CSV data and turns revenue, profit, product, and regional metrics into executive insights.
Technical Skills
Data Analysis
Data Science
Data Engineering Support
Articles & Insights
FraudShield PaySim Fraud Analytics
Membangun fraud analytics workflow dari 6.36M transaksi PaySim menjadi SQL mart, ML risk scoring, threshold simulation, exposure analysis, dan dashboard fraud operations.
Read Full ArticleFOLU Talks Social Listening & Risk Intelligence
Studi kasus public data yang mereplikasi workflow social listening pemerintahan tanpa membuka data internal, memakai data FOLU Talks yang bisa diakses publik.
Read Full ArticleSupply Chain Risk Intelligence
Membangun workflow data engineering, KPI mart, model prediksi keterlambatan, dan dashboard BI untuk membaca risiko fulfillment dari 180K+ order supply chain.
Read Full ArticleOracle E Commerce Operations Analytics
Membangun analytics layer di Oracle Database dari 1.5M baris data e commerce untuk membaca delivery risk, review impact, seller health, repeat customer behavior, dan kesiapan monitoring database.
Read Full ArticleIndomie Market Pressure & Business Strategy Intelligence
Menganalisis apakah Indomie masih memiliki pricing power melalui marketplace price snapshot, sold count proxy, competitor benchmark, social price pain, dan macro margin risk proxy.
Read Full ArticleSomethinc vs Skintific Customer Sentiment & Competitor Insight
Membedah 2.000 review skincare untuk membaca gap sentimen, loyalitas, sensitivitas harga, keluhan operasional, dan posisi kompetitif Somethinc vs Skintific.
Read Full ArticleOptimizing Retail Strategies: FMCG Performance Analytics
Mengatasi tantangan "Data Overload" pada industri FMCG ritel melalui ekstraksi data real time, metric engineering, dan agregasi lanjutan untuk wawasan eksekutif.
Read Full ArticleKrisis Brand: Aqua vs Le Minerale
Analisis data sentimen yang mengungkap pergeseran otoritas brand di media sosial dan strategi berbasis data untuk merebut kembali kepercayaan publik.
Read Full ArticleGet In Touch
Open to Data Analyst and BI roles focused on SQL, Oracle, Power BI, reporting automation, social listening, customer insight, NLP, and predictive analytics.