Skills, Technologies, & Publications

Click to view my portfolio and project showcase!

Certifications

BUSINESS
INTELLIGENCE

Dashboarding & Business Intelligence

Expertise Area

DATA
STRATEGY

STAKEHOLDER
MANAGEMENT

Reporting, KPIs & Insight Building

Collaboration, Communication & Decision Support

Education

Brawijaya University (UB)

Bachelor of Economics (BEc) — GPA: 3.69 / 4.00 (Cum Laude)

• Graduated with honors from a comprehensive economics program focused on analytical thinking, data interpretation, and practical application.

• Undergraduate Thesis: "The Epistemics of Philanthropic Causality: The Bakrie Foundation Paradigm" — examined how the Bakrie Foundation constructs and communicates causal narratives in philanthropy, and how these influence public perception and participation.

Malang, East Java | Aug 2020 – Apr 2024

Vytauto Didžiojo Universitetas

IISMA – Exchange Program (Awarded by the Indonesian Government)

• Selected as an awardee of the prestigious IISMA scholarship, a fully funded student exchange program initiated by the Indonesian Ministry of Education.

• Completed courses in: Commerce, Financial Management, Strategic Leadership, & Executive Decisions — with a focus on cross-cultural collaboration and global business practices.

Kaunas, Lithuania | Aug 2023 – Jan 2024

Imam Muhammad ibn Saud Islamic University

Independent Study – Jakarta Campus

• Completed an independent study focusing on Islamic Financial Management and Economics, with emphasis on Sharia-compliant financial principles and economic systems.

Riyadh, Saudi Arabia | Jan 2022 – Jul 2022

Work Experience

Xiaomi Indonesia

KPI & Strategy Analyst
Business Intelligence Analyst
Business Intelligence Intern

• Strategic KPI & Forecasting Framework: Developed Xiaomi’s national KPI and target-setting framework across regions and key accounts (Erajaya, Blibli, Digiplus, New Retail). Built forecasting models integrating sell-in, sell-through, sell-out, and stock levels (warehouse, distributor, depo, dealer, store) with respective DOS thresholds (30–45 days offline, 21–30 online). Factored in HQ targets, finance alignment, CAPA, GDP area, ASP, price range, etc. achieving ~IDR 17B sell-out and ~IDR 15B sell-in per month per channel in H2 2025, consistently meeting targets.

• Growth & Channel Strategy: Developed a growth index and incentive schemes driving +5–10% sales uplift and ~5% cost efficiency, supported by tracking systems that aligned area incentives with program success and achieved >80% employee target attainment, while co-designing GTM initiatives (DWP, GWP, bundling, etc.) to boost underperforming regions, accelerate conversion, and strengthen cross-channel sell-through performance.

• Analytics-Driven Business Optimization: Led analytics for smartphones, tablets, and AIoT across all channels, driving insights for >400K unit sales/month and >IDR 2T annual AIoT sales, optimizing inventory efficiency from warehouse to stores, and building 20+ Power BI dashboards with Hadoop & Python automation, including bots for dashboard push, reducing manual reporting by ~80% and enabling real-time insights.

• Tools & Skills: Python, SQL, Excel, Power BI, Power Query, Hadoop, Data Visualization, Automation, Dashboard Development, Forecasting & KPI Modeling, Incentive & Pricing Strategy, Business & Growth Strategy

SCBD, South Jakarta

(Jul 2025 - Nov 2025)
(Jul 2024 - Jul 2025)
(Jan 2024 – Jul 2024)

eFishery

People Partner and Analytics Intern

• HR Analytics: Built dashboards for >1,000 employees, automating reports by ~70% and enhancing workforce visibility.

• Change Mgmt.: Created a Prosci-based Playbook, improving transformation consistency by ~40% across departments.

• People Insights: Managed People & Culture GPT dashboards, driving HR decisions and raising retention by ~10%.

• Tools & Skills: Excel, Mailchimp, Change Management, HR Analytics, Data Modeling.

Bandung, West Java

(Mar 2023 – Oct 2023)

GAOTek Inc.

Business Development Intern

• Business Growth & Partnerships: Led sales approaches and developed partnerships with 20+ resellers, VARs, and distributors across North America, expanding regional presence in Tennessee and key markets and driving a ~15% increase in qualified leads.

• CRM Management: Maintained 100+ records in Bitrix CRM, improving data accuracy by ~30%.

• Tools & Skills: Bitrix, CRM Management, Strategic Partnerships, Marketing, Customer Engagement.

New York, United States

(Feb 2023 – Mar 2023)

Qwork Malaysia

Business Intelligence Dev. Intern

• Data Automation & Integration: Built an automated scraping pipeline collecting job data from 20+ career sites and integrating 5K+ consolidated entries into the platform via Git-based version control, improving data reliability and reducing manual uploads by ~70%.

• Tools & Skills: Python, SQL, OOP, Web Scraping, Data Cleaning, Automation, Git.

Ampang, Malaysia

(Nov 2022 – Feb 2023)

Bakrie Foundation

Fundraising Data & CRM Analyst Intern

• Oversaw 8 crowdfunding campaigns for KitaBisa and BenihBaik, targeting 50 million Rupiah.

• Contributed to community-focused charity events.

• Partnered with 20+ companies for Bakrie Foundation programs.

• Enhanced fundraising data using Power BI for better decision-making.

• Tools & Skills: Fundrising, Corporate Collaboration, Spreadsheets, PowerBI, Data Enhancement.

Kuningan, South Jakarta

(Mar 2022 – Aug 2022)

BangBeli

Growth & Data Analyst Intern

• Conducted research on 19 competitors, including performance evaluation, cost and market-based analysis, and execution improvements.

• Devising innovative strategies to enhance unique selling points, traction, and pricing analysis.

• Prepared monthly team reports to monitor progress & weekly KPI reports for comprehensive growth metric analysis.

• Tools & Skills: Pricing Analysis, Data Analysis, Performance Tracking, Growth Strategies.

Malang, East Java

(Aug 2022 – Nov 2022)

Pirion School

Social Media Analyst Intern

• Implemented Microsoft Power BI for data visualization and utilized PowerPoint for reporting purposes.

• Created detailed reports and visualizations, emphasizing key metrics to enhance content strategy.

• Ensured data accuracy, and provided ad hoc assistance for data requests and dashboard maintenance.

• Tools & Skills: Social Media Analytics, Data Analysis, Power BI, Growth Strategies.

Ampang, Malaysia

(Nov 2021 – Mar 2022)

Organizational & Volunteering Experience

5,000 Cities

Innovation Analyst

• Conducted innovative research titled "Exploring Jakarta's Innovation" to uncover personalized solutions for a sustainable future in Jakarta.

• Researched "Smart Traffic Management Trends in Jakarta's Streets," demonstrating expertise in urban trends and solutions.

• Tools and Skills: Qualitative Analysis, Smart Traffic Analysis

American Fork, Utah

(Mar 2023 – Jun 2023)

Economics Laboratory

Tutor & Deputy Head, Research & Education Deptartment

• Spearheaded the dissemination of knowledge on economic and econometric research methods

• Empowering individuals and organizations to conduct research and publish their findings.

• Tools & Skills: Stata, Eviews, Excel, Spreadsheet, R

Malang, East Java

(Oct 2022 – Oct 2023)

Investment and Capital Market Laboratory

Staff of RND Department

• Conducted weekly analysis using simple technical analysis techniques to create a buy and sell plan for stocks.

• Participated in trading & stock analyst competitions to improve analytical skills & knwl of financial markets.

• Generated innovative content ideas for Instagram feed related to trading and stock market analysis.

• Tools & Skills: IPOT, Market Analysis, Fundamental & Technical Analysis, Stock Analysis

Malang, East Java

(Feb 2023 – Oct 2023)

Economics Student Association, Faculty of Economics and Business

Staff of Economic Study Department

• Led a team, resulting in 4 publications focusing on multiple linear regression analysis and qualitative methods.

• Coordinated 4 divisions for a successful economic webinar, featuring high-profile presenters and attracting over 100 participants.

• Worked as an Ass’Co LO at FEB UB Economic Olympic, guiding over 100 contestants, and as a Public Relations Officer at FEB UB Economic Festival, securing over 100 participants and 15 media cooperations.

• Tools & Skills: Research, Event Coordination, Leadership, Research Leadership, Event Coordination

Malang, East Java

(Oct 2020 – Dec 2021)

Address

South Jakarta, 12180
Indonesia

Contacts

+62 814-6666-2001
business@rafisunggoro.com