South Jakarta, Indonesia
Hello! 👋
I'm Novrian Pratama
Data & Business Intelligence Analyst FMCG-focused
I turn messy sales and distribution data into dashboards and decisions. Currently at PT Amerta Indah Otsuka.
About Me
I am a recent Information Systems graduate with hands-on experience in data analytics and business intelligence, focused on the FMCG industry. I have worked across four organisations — building dashboards, processing large datasets, and translating data into decisions that teams can act on. At PT Amerta Indah Otsuka, I work on national General Trade visibility monitoring, processing 3,600+ audit records weekly and consolidating 62,000+ visibility records into a Looker Studio dashboard.
Experience
Sales Digital Business Application Intern
PT Amerta Indah Otsuka
- Process 3,600+ visibility audit records per week for National General Trade Visibility Monitoring.
- Consolidated 62,000+ visibility records from multiple Excel and Google Sheets sources into a Looker Studio dashboard.
- Monitored display compliance across Region, Branch, Site, and Salesman dimensions, covering categories: AVAILABLE, NO DISPLAY, NO PHOTO, and photo-quality flags.
- Processed ~3,000 new field submissions per week from sales teams across multiple regions.
Network Quality Specialist
J&T Cargo Indonesia
- Monitored operational performance and SLA compliance across 77 outlets, sustaining a 98% SLA rate.
- Processed 200,000+ logistics records using Excel Power Query for exception handling and outlet performance analysis.
Area Marketing Intern
PT Nutrifood Indonesia
- Achieved 60% product trial conversion.
- Built 15+ partnerships from 50+ senior high schools evaluated.
Associate Project Manager Intern
DOT Indonesia
- Delivered 100% on-time milestones with a 7-person team across 8 sprints.
Projects
National GT Visibility Monitoring — PT Amerta Indah Otsuka
Consolidated visibility audit data into a Looker Studio dashboard to monitor display compliance in national General Trade. Processed 62,000+ cumulative visibility records and 3,600+ weekly audit entries.
FMCG Sales Performance Analysis
Exploratory and diagnostic analysis of a FMCG sales dataset, modelling sales performance drivers using Power BI with DAX measures. Project is ongoing.
Operational Performance & SLA Monitoring — J&T Cargo
Designed an Excel-based operational dashboard to monitor SLA compliance, shipment exceptions, and outlet performance for 77 outlets. Processed 200,000+ logistics records using Excel Power Query.
Skills
Tools and technologies I have experience using across data analytics and business intelligence projects.
Data Analysis & Visualisation
Database & Engineering Tools
Productivity & Collaboration
Education
Bachelor of Computer Science in Information Systems
Universitas Islam Negeri Sultan Syarif Kasim Riau
- GPA: 3.89 / 4.00
Contact
Open to Data Analyst, BI Analyst, and Business Analyst roles — especially in FMCG. Feel free to reach out or view my work.