01 // About
I work where operational reality meets practical data engineering. Instead of focusing only on pre-cleaned sandbox datasets, my background comes from fast-paced, high-volume production facilities—where data usually starts fragmented across desktop spreadsheets, handwritten tallies, or rigid ERP ledgers.
Over the past few years, I have built central data pipelines from scratch, scaled database architectures to prevent local file crashes, and supported enterprise ERP deployments. I specialize in identifying where numbers deviate from physical reality, automating manual reporting routines, and turning operational logs into interactive BI dashboards that decision-makers actually rely on.
Today, my focus centers on building reliable data pipelines, operational modeling, and actionable business intelligence. I am actively open to full-time opportunities and strategic projects where practical field knowledge and clean analytics drive measurable business impact.
02 // Experience
Data Analyst • Independent Consultant (Project-Based)
Jul 2026 – Sept 2026Investment Advisory Engagement • Remote
- Performed business data audits and exploratory queries using SQL and Python to evaluate investment targets.
- Validated raw commercial and transactional ledgers for completeness, flagging inconsistencies and data gaps prior to executive review.
- Reconciled reporting discrepancies across historical operational records.
Data Analyst & Operations Planner
Jul 2025 – Jun 2026PT Indonesia Livestock Operations • Lampung & Tangerang
- Managed sales, inbound livestock schedules, and raw material demand projections across feedlot facilities.
- Supported enterprise Microsoft Dynamics 365 rollout: validated opening balances, established data hygiene protocols, and conducted repetitive transaction training.
- Solved local laptop Excel crash limits by deploying an Azure PostgreSQL cloud database linked to automated Power BI dashboards and Power Automate alert triggers.
- Monitored plan vs. actual variances across purchasing, storage, and milling to prevent supply chain bottlenecks.
Operations Analyst & Planning Lead
May 2024 – Jul 2025PT Indo Prima Beef • Central Lampung
- Promoted twice within 12 months from operations analyst to planning section lead.
- Built cloud warehouse from zero: wrote Google Apps Script to ingest standardized Google Sheets data into Google BigQuery, connected to auto-updating Looker Studio dashboards.
- Audited administrative transaction entries in Tally ERP to eliminate discrepancies between physical stock and digital records.
- Modeled daily feed formulation plans and ration adjustments to optimize weight gain and maintain cost efficiency.
03 // Featured Projects
Production data models, executive web storyboards, and interactive dashboards.
Click preview to launch ↗Commercial Beef Feedlot Operations & Closeout Economics
Investigated closeout margin dynamics, carcass tonnage vs. quality grid arbitrage (yield beating marbling premiums), winter thermal drag mitigation in sheltered barns, and the financial impact of the 30-day BRD treatment window. Engineered with custom Star Schema architecture.
Commercial Broiler Operations Hub & Performance Index
Audited commercial performance divergence between Closed House and Open House units. Analyzed net margin differences (+Rp 4,762/kg in closed houses), microclimate heat stress (feed dissipation vs. growth), late-mortality timing, and the European Performance Index (EPEF / IP).
Retail Workforce Productivity & Attrition Analysis
Evaluated store-level labor cost structures, store format productivity, and employee turnover. Quantified micromanagement attrition risk (49% peak under micromanagement), evaluated scheduling efficiency across retail formats, and mapped retention across the 9-Box grid.
Indonesian Beauty & Skincare Market Intelligence
Evaluated product scores, consumer review volumes, and brand competitive positioning across Indonesian skincare categories scraped from FemaleDaily. Modeled category distributions, product score leaders, and reviewer density.
04 // Systems & Solutions
Automated Cloud Ingestion: Google Sheets to BigQuery
When an operation relied on decentralized sheets across various department laptops, daily reporting was manually compiled and error-prone. I standardized data entry structures, authored automated ingestion triggers using Google Apps Script to pipe verified daily rows directly into Google BigQuery, and built auto-updating Looker Studio dashboards for live executive monitoring.
Overcoming Excel Workbook Memory Limits with Azure PostgreSQL
As daily transaction history scaled into tens of thousands of rows, master Excel workbooks regularly froze and crashed local office machines. I migrated storage and heavy aggregation queries to an Azure PostgreSQL cloud database, exposing clean SQL views that connected seamlessly to lightweight Power BI reporting models and alert triggers via Power Automate.
Least-Cost Feed Formulation & Resource Optimization
Raw material feed costs represent the largest expense category in livestock operations. Leveraging background in animal nutrition and quantitative trial modeling, I built mathematical formulation sheets that balanced essential nutrient requirements (crude protein, energy, minerals) against volatile commodity ingredient prices to protect operating margins.
05 // Skills & Stack
Data & Cloud Infrastructure
Business Intelligence & Visualization
Enterprise ERPs & Operational Systems
06 // Background
Universitas Gadjah Mada (UGM)
2016 – 2023Bachelor of Animal Science and Industry
Served as Researcher & Laboratory Assistant at the Animal Nutrition Lab (2018–2021). Handled biological feeding trials, trial experiment design, and quantitative statistical validation using SPSS and Excel.
Certifications
- • DQLab Data Science Trainee (Python, MySQL)
- • SQL & Data Analytics Certifications
- • Kaggle Data Contributor
Languages
- English: Professional Working (B2)
- Indonesian: Native
- Javanese: Native
07 // Contact
Get in Touch
I am open to full-time roles, contract work, and consulting projects in data analytics, cloud pipelines, and operations planning. Feel free to reach out directly: