Welcome to My Professional Portfolio


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
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: "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)