HELLO! IT'S ANDHIKA

Education

Brawijaya University (UB)

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

• Graduated with honors from a comprehensive economics program emphasizing analytical thinking, quantitative reasoning, economic modeling, data interpretation, and evidence-based decision-making across business, public policy, and development contexts.

• 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.

Vytauto Didžiojo Universitetas

IISMA – Exchange Program (Awarded by the Indonesian Government)

• Selected as an awardee of the prestigious IISMA Scholarship, a fully funded international mobility program sponsored by the Indonesian Ministry of Education, awarded to high-performing students to develop global perspectives and cross-cultural competencies.

• Completed interdisciplinary coursework in Commerce, Financial Management, Strategic Leadership, and Executive Decision-Making, while collaborating with international students and participating in academic and cultural exchange activities across Europe.

Imam Muhammad ibn Saud Islamic University

Independent Study – Jakarta Campus

• Completed an independent study program focused on Islamic Financial Management and Economics, covering Sharia-compliant financial systems, Islamic banking principles, risk-sharing mechanisms, and contemporary economic issues in Muslim-majority economies.

• Explored the integration of conventional economic theories with Islamic economic principles, strengthening understanding of ethical finance, financial governance, and alternative economic frameworks.

Malang, East Java

Aug 2020 – Apr 2024

Kaunas, Lithuania

Aug 2023 – Jan 2024

Riyadh, Saudi Arabia

Jan 2022 – Jul 2022

Work Experience

Xiaomi Indonesia

Business Strategy Analyst
Business Intelligence Analyst

Responsible for commercial strategy, KPI, forecasting, channel performance, and business intelligence across smartphones, tablets, and AIoT, covering key channels and accounts including Erajaya, Blibli, Digiplus, and New Retail, with >400K units monthly sales, >IDR 2T annual AIoT sales, and approximately IDR 17B monthly sell-out and IDR 15B monthly sell-in per channel in H2 2025.

• 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.

• Data Engineering & Business Intelligence Enablement: Developed integrated data workflows connecting multiple database environments to Power BI, delivering D+1 sales and inventory visibility for stakeholders across various business levels. Leveraged Python, SQL, and Selenium to automate data extraction, validation, and scheme settlement processes, improving data accuracy while reducing manual effort by 90% and enabling faster business decision-making.

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

Jakarta, Indonesia

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

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, Indonesia

(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

• Fundraising Analytics & Campaign Management: Managed and monitored crowdfunding campaigns across KitaBisa and BenihBaik, supporting fundraising initiatives that raised approximately IDR 50 million.

• Partnership & Stakeholder Engagement: Collaborated with 20+ corporate partners and supported community-focused philanthropic programs to strengthen fundraising outreach and impact.

• Data Visualization & Decision Support: Enhanced fundraising analysis and reporting using Power BI, enabling data-driven decision-making for campaign performance and stakeholder management.

• Tools & Skills: Fundraising Analytics, Corporate Partnerships, CRM, Spreadsheets, Power BI, Data Visualization.

Jakarta, Indonesia

(Mar 2022 – Aug 2022)

BangBeli

Growth & Data Analyst Intern

• Market Intelligence & Competitive Analysis: Conducted research on 19 competitors, evaluating performance, valuation, cost structures, and market positioning to identify business opportunities and execution improvements.

• Growth Strategy & Performance Tracking: Developed innovative strategies to enhance unique selling points, promotion effectiveness, and pricing approaches while preparing monthly team reports and weekly KPI tracking to monitor growth performance.

• Tools & Skills: Pricing Analysis, Data Analysis, Performance Tracking, Growth Strategy, Market Research.

Malang, Indonesia

(Aug 2022 – Nov 2022)

Pirion School

Social Media Analyst Intern

• Marketing Analytics & Reporting: Developed reports and dashboards to monitor content performance, audience engagement, and key marketing metrics, supporting data-driven content strategies.

• Business Intelligence & Data Visualization: Implemented Power BI dashboards and visualizations to improve reporting efficiency and provide actionable insights for stakeholders.

• Data Management & Operational Support: Ensured data accuracy, maintained reporting workflows, and supported ad-hoc analytical requests to improve operational effectiveness.

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

Jakarta, Indonesia

(Nov 2021 – Mar 2022)

Grab

Commercial Strategy

Jakarta, Indonesia

(Jan 2026 - Present)

Responsible for commercial strategy and performance across B2B & B2G, GTM, Ads Specialists, and Client Success Unit, covering 8+ segments and 8+ verticals across Mobility (2W, 4W, Offline Rental), Food, Mart, Express, Express-API, OVO, AR Collection, Omni Dine Out, GrabGifts, and Advertising Solutions including In-App Ads, Pure Ads, Fleet Ads, and GMS, with ~USD 231M GMV commercial scope and ~95 commercial employees within the planning framework.

• OKR & Target Setting: Improved average achievement from <90% in Q1 2026 to ~100% in Q2 2026, with the proportion of representatives achieving ≥100% target increasing from 7% → 91%, by redesigning half-year and quarterly OKRs from broad business groupings into focused product-level priorities (e.g., splitting Mobility & Express into specific priorities such as 4W-HVR). Built a four-layer target framework combining data objective (historical performance, QoQ/YoY, seasonality, P25–P75 normalization, QTC, AOV), pipeline objective (pipeline potential and vertical leverage), leader objective (senior-leader direction), and KAM-level subjective calibration (±35%).

• Business & Growth Strategy: Optimized commercial coverage across 8+ segments and 8+ verticals, translating weekly, monthly, and quarterly performance gaps into account-level farming and acquisition strategies across a ~15,000-account B2B/B2G universe and 500+ Ads brands. Designed portfolio allocation across Head Office and Territory using employee size, GMV potential, geography, account type, job grade, and Mid-Market / Enterprise structure, including 75% Territory / 25% Head Office allocation for group accounts and 100% account mirroring across collaborating KAMs to enable cross-selling between Ads and B2B/B2G. Prioritized opportunities using time-gone, gap-to-target, required run-rate, Salesforce pipeline, GMV / investment needs, AR / attachment rate, and account potential.

• Commercial Impact & Economics: Strengthened commercial economics across a ~USD 231M GMV scope by linking product-level OKRs, achievement thresholds, incentive multipliers, commercial investment, and resource allocation. Designed a 70% minimum performance hurdle before incentive eligibility, creating a performance-based gate for variable compensation; with salary-based multipliers, higher payouts were tied to higher achievement, aligning incentive cost with commercial performance.

• Commercial Data & Analytics: Reduced manual commercial reporting by 80%+, accelerated decision-making by 30–40%, and achieved 95% adoption based on Power BI dashboard usage by building a unified Databricks commercial data layer integrating core company business data, Oracle, marketing data (tele, agency, etc.), subsidiary-team data, and manually maintained datasets into a centralized master table. Encoded 20+ commercial business rules using advanced SQL across Databricks SQL and Presto / Trino (CTEs, complex joins, window functions, correlated subqueries, NOT EXISTS / anti-joins, incremental filtering, deduplication, and query optimization); built Python / Databricks Notebook workflows using Pandas, PySpark, and NumPy (large-scale data processing, reshaping / unpivoting, joins / merges, aggregation, transformation, validation, deduplication, analytical dataset preparation, business-rule processing, and workflow automation); and developed advanced Power BI solutions (Power Query / M, Dataflows, semantic modeling, fact-dimension modeling, complex relationships, advanced DAX, calculated tables / measures, and multi-source integration).

Organizational & Volunteering Experience

5,000 Cities

Innovation Analyst

• Urban Innovation Research: Conducted strategic research for the “Exploring Jakarta’s Innovation” initiative, identifying innovative solutions and best practices to support sustainable urban development in Jakarta.

• Smart Mobility & Trend Analysis: Researched smart traffic management trends and urban mobility challenges, generating insights on emerging technologies and city-level innovation opportunities.

• Tools & Skills: Qualitative Analysis, Urban Innovation Research, Smart Mobility Analysis, Trend Analysis..

American Fork, Utah

(Mar 2023 – Apr 2024)

Economics Laboratory

Tutor & Deputy Head, Research & Education Deptartment

• Research Education & Knowledge Development: Led educational initiatives and knowledge-sharing programs covering economics, econometrics, and quantitative research methodologies.

• Research Capacity Building: Mentored students and aspiring researchers in conducting academic research, statistical analysis, and publication development.

• Tools & Skills: Stata, EViews, Excel, Spreadsheets, R, Econometrics, Research Methodology.

Malang, East Java

(Oct 2022 – Apr 2024)

Investment and Capital Market Laboratory

Staff of RND Department

• Capital Market Research & Analysis: Conducted weekly stock market analysis using fundamental and technical approaches to support investment decision-making and portfolio strategies.

• Investment Education & Market Engagement: Participated in stock analysis competitions and developed educational content to improve financial literacy, trading knowledge, and market understanding.

• Tools & Skills: Capital Market Analysis, Fundamental Analysis, Technical Analysis, Financial Research, IPOT.

Malang, East Java

(Feb 2023 – Apr 2024)

Economics Student Association, Faculty of Economics and Business

Staff of Economic Study Department

• Mentorship Program Development: Coordinated three mentor upskilling programs, enhancing coaching quality, knowledge-sharing effectiveness, and learning experiences for 16 mentors.

• Event Management & Community Engagement: Organized 11 educational webinars and discussion forums under CIES work programs, each attended by 100+ participants, supporting knowledge dissemination in Islamic economics and finance.

• Tools & Skills: Mentorship Coordination, Webinar Management, Event Planning, Stakeholder Coordination, Community Engagement.

Malang, East Java

(Oct 2020 – Dec 2021)

Centre Of Islamic Economic (CIES) FEB UB

Staff of School Of Islamic Economic

Malang, East Java

(Oct 2020 – Dec 2021)

• Research Leadership & Publication Management: Led research initiatives resulting in 4 publications covering quantitative and qualitative economic research topics, including multiple linear regression analysis.

• Event Strategy & Stakeholder Coordination: Coordinated a divisional economic webinar attended by 100+ participants and supported large-scale faculty events through stakeholder engagement, public relations, and operational planning.

• Student Engagement & Program Execution: Served as Liaison Officer for the FEB UB Economic Olympic and Public Relations Officer for the FEB UB Economic Festival, supporting participant management and event execution for 100+ attendees.

• Tools & Skills: Research, Leadership, Event Management, Stakeholder Coordination, Publication Development.

Address

South Jakarta, 12180
Indonesia

Contacts

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