Welcome to My Professional Portfolio

blue and white striped round textile
blue and white striped round textile

HELLO! IT'S ANDHIKA

Currently excelling as a KPI & Strategy Analyst at Xiaomi Indonesia, overseeing end-to-end analytics for both Phone and AIoT products across online and offline channels. Responsible for KPI management, target setting, and strategic program design that drive sustainable business growth. Skilled in Python, SQL, R, and Power BI, with strong analytical and strategic thinking abilities, complemented by a proven ability to deliver impactful insights for stakeholders and leadership.

5+

10+

Skills

Years of experience

15+

Projects

cars parked on the side of the road in the city

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: "Perspective-Driven Appraisal of Bakrie Fdn. Initiatives: Efficacy, Accountability, and Dissemination" — examined how communication, perceived impact, and transparency of programs affect public interest and participation.

Malang, East Java | Aug 2020 – Apr 2024

Vytautas Magnus University

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: Business Communication, Company Financial Management, Leadership, and Managerial Decision Making — with a focus on cross-cultural collaboration and global business practices.

Lithuania, Eastern Europe | 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

  • Owned the framework for target setting, achievement tracking, and KPI management across regions and key accounts. Proposed incentive schemes, salary adjustments, and pricing strategies, while collaborating with leadership to design strategic programs that ensure Xiaomi’s sustainable growth.

  • Led end-to-end analytics for all products, covering sales performance, business coverage, and inventory management.

  • Delivered comprehensive insights across: Online E-Commerce, Key Accounts, New Retail, Regional/Offline, and CAM.

  • Built and managed mission-critical dashboards, ensuring accurate and real-time reporting to support decision-making.

  • Presented insights and strategy proposals to stakeholders, aligning cross-functional teams on business objectives.

  • Tools & Skills: Python, SQL, Excel, Power BI, Power Query, Data Visualization, KPI Management, Business Strategy

SCBD, South Jakarta

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

eFishery

People Partner and Analytics Intern

  • Worked directly under the People Partner Senior Manager, contributing to key HR functions.

  • Managed People & Culture Dashboard as well as People GPT.

  • Developed a comprehensive Change Management Playbook based on the Prosci Change Triangle Model.

  • Managed a real-time HR Employee Dashboard including Demographics, Headcount, Turnover data, etc.

  • Tools & Skills: Spreadsheet, Mailchimp, Change Management, Strategic Communication, Data Management Modeling.

Bandung, West Java

(Mar 2023 – Oct 2023)

GAOTek Inc.

Business Development Intern

  • Cultivated alliances with resellers, VARs, integrators, and distributors to promote GAOTek products and services.

  • Maintained accurate business opportunity records in the CRM system.

  • Drove growth in Tennessee, with emphasis on key regions.

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

New York, United States

(Feb 2023 – Mar 2023)

Qwork Malaysia

Business Intelligence Dev. Intern

  • Conducted web scraping of over 20 job listings from various sites using Scrapy and utilizing Get/Post requests or XPath/CSS Locator methods.

  • Analyzed, developed, and maintained job scraping results and completed ad-hoc tasks as assigned by supervisors.

  • Tools & Skills: Python, Power BI, Data Cleaning, Web Scraping, OOP, SQL.

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)

architectural photography of building with people in it during nighttime
Address

South Jakarta, 12180
Indonesia

Contacts

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