FM/QUERY PORTFOLIO

Type help for commands or search nine case studies.

00 Data systems · Commercial intelligence

Data, made decisive.

I build analytics systems that move teams from raw signals to trusted, repeatable business decisions.

Explore selected workHow I work

Experience SKINTIFIC · Maleo · Lifepack.id · FMCG operations

01 Professional Orbit

Built across organizations and brands.

Organizations where I worked and brands or projects I supported.

OrganizationsEmployment and founder experience
  1. 2021–23Selasar KampusFounder & CEO

    Founded a campus marketplace; built the early analytics and ops backbone.

  2. 2024GajahpanganData Analyst

    Built commercial reporting and inventory analytics for the F&B distribution business.

  3. 2024–25LifepackData Analyst

    Shipped pharmacy retail dashboards and automated recurring reporting.

  4. 2025–26MaleoData Analyst

    Delivered brand and campaign analytics across agency client portfolios.

  5. 2026–NowCurrentSKINTIFICSenior Associate Data Analyst

    Own the governed BI semantic layer, RBAC, and commercial monitoring.

Brands & portfolios worked withSelected work delivered through agency, consulting, and project contexts
  • Blue BandBlue BandCampaign monitoring
  • ChocopieChocopieCommercial analysis
  • GarnierGarnierCampaign monitoring
  • Head & ShouldersHead & ShouldersCampaign monitoring
  • ID/X PartnersID/X PartnersConsulting project
  • L’OréalL’OréalBrand analytics
  • PantenePanteneCampaign monitoring
  • Top CoffeeTop CoffeeCommercial analysis
  • CeraVeCeraVeRetail analytics
  • ConcertoConcertoBrand analytics
  • Garuda IndonesiaGaruda IndonesiaCommercial analysis
  • HyundaiHyundaiBrand analytics
  • Kimia FarmaKimia FarmaCommercial analysis
  • MaybellineMaybellineCampaign monitoring
  • SilverQueenSilverQueenSocial analytics
  • Ultra MilkUltra MilkCommercial analysis

02 Selected work

Systems built around decisions.

Selected analytics systems spanning governed BI, automated reporting, and predictive modeling.

01 / Future Creative Network (Maleo)Professional Experience
Campaign monitoring dashboard for a SilverQueen campaign, recreated with synthetic data, showing actual-vs-KPI gauges, a track score, and best-performing content

Marketing and creative analytics

Social Media Analytics and Reporting Automation

Led 30+ client-facing reports and strategy decks while building a repeatable social-media analytics pipeline from multi-platform data into automated spreadsheets, KOL scrapers, and BI dashboards.

Four-brand pipeline
02 / SkintificProfessional Experience
NEXUS Domain Intelligence dashboard showing category scorecards and a category-breakdown table with synthetic data

Beauty and personal care (e-commerce)

NEXUS — Business Intelligence and Decision Platform

Built an internal BI platform on Google Apps Script and BigQuery that gives commercial and marketing teams governed self-serve analytics — visual query builder, RBAC with row-level security, executive dashboards, and a sales-extrapolation engine.

BigQuery BI platform · RBAC
03 / ID/X Partners x Rakamin AcademyProject-Based Internship
Loan default model results showing ROC and Kolmogorov-Smirnov evaluation charts

Financial services

Loan Default Prediction

Developed and evaluated a Random Forest model for loan-default prediction, achieving an AUC of 0.857 and KS statistic of 0.5675 on the project dataset.

AUC 0.857 / KS 0.57
03 selected / 09 totalSee all case studies

03 Operating model

From infrastructure to action.

Technical delivery stays connected to decision context, ownership, and measurable use.

01

Ingest

Analytics systems

Reliable data flows connecting fragmented business data.

  • SQL
  • BigQuery
  • PostgreSQL
02

Govern

Automation

Repeatable reporting, alerts, and updates removing manual steps.

  • Apps Script
  • REST APIs
  • Git
03

Model

Business intelligence

Decision-ready dashboards built around stakeholder questions.

  • Python
  • Pandas
  • Excel
04

Decide

Commercial analysis

Inventory, pricing, and performance analysis ending in action.

  • Power BI
  • Tableau
  • Looker Studio

04 Current focus

Commercial and inventory intelligence.

At SKINTIFIC, I support inventory and commercial analytics across brands and channels: stock health, pricing parity, NPD, critical SKU, and promotional analysis.

Public descriptions remain high-level to protect confidential operating data.

Commercial health decision system.

Governed inputsChoose an input to inspect

05 Contact

Need an analyst who connects systems to decisions?

Open to conversations about analytics, business intelligence, commercial performance, and automation.

Contact FarihDownload resume

Available for high-impact data roles