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 Business Intelligence Analyst at Xiaomi Indonesia, responsible for AIoT product analytics, and managing both online and offline markets. Driven and detail-oriented professional with expertise in Python, SQL, R, Econometric Tools, and Power BI. Possess strong analytical and strategic thinking abilities, complemented by a collaborative spirit and a readiness to deliver valuable insights.

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: "Benefits, Transparency, and Promotion in Bakrie Foundation Programs: An Interest Analysis" — 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

Business Intelligence Analyst
Business Intelligence Intern

  • Led comprehensive analytics for AIoT products, including sales analysis, business coverage, and inventory metrics.

  • Managed end-to-end data insights for online & offline markets, driving strategic decisions through data-driven reporting.

  • Oversee key dashboards, including Xiaomi Store, Xiaomi Shop, and Erafone dashboards, ensuring up-to-date, actionable insights for optimal business performance.

  • Tools & Skills: Python, SQL, Spreadsheets, Power BI, Power Query, Growth & Business Strategy.

SCBD, South Jakarta

(Jul 2024 - Present)
(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