Welcome to My Professional Portfolio

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

HELLO! IT'S ANDHIKA

Commercial Strategy professional with experience driving revenue growth, performance transformation, and strategic decision-making through KPI architecture, commercial planning, and advanced analytics. Experienced in translating complex business challenges into scalable frameworks, actionable insights, and growth initiatives that improve commercial performance and organizational effectiveness.

5+

10+

Skills

Years of experience

15+

Projects

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

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

  • OKR Strategy & Performance Governance: Led end-to-end OKR strategy, target-setting, performance measurement, and incentive governance across B2B (Non-Merchant), Ads Business Solutions, Vertical Solutions, and Client Success Unit (CSU), covering Mobility (2W, 4W-HVR, Non-4W HVR, Offline Rental), Food, Mart, Express, GE API, OVO, AR Collection, Omni Dine Out, GrabGifts, and Advertising Solutions (In-App Ads, Pure Ads, Fleet Ads, GMS). Designed KPI architectures, target-setting methodologies, and governance frameworks leveraging QoQ/YoY trends, seasonality modeling, and performance normalization (P25–P75) to establish objective performance baselines, complemented by structured management calibration to balance commercial ambition, role expectations, and organizational priorities across the full performance cycle—from account mapping and target allocation to incentive settlement and quarterly business reviews. Improved average achievement from 89% to 94% and increased sales representatives achieving ≥100% target from 7.3% to 28.3% through performance redesign, incentive alignment, and measurement optimization.

  • Commercial Planning & Revenue Growth: Led commercial planning and performance management across commercial verticals representing ~USD 1.5M revenue scope, translating performance insights into growth strategies, revenue opportunities, and commercial interventions through forecasting, run-rate management, opportunity sizing, pipeline prioritization, and performance diagnostics. Delivered 10–12% sales productivity improvement, 8–12% conversion uplift, and 15–20% enhancement in AR visibility while strengthening commercial execution, resource prioritization, and cross-functional decision-making.

  • Sales Intelligence & Strategic Analytics: Built a centralized sales intelligence ecosystem using Power BI, Presto, Databricks SQL, and Python, enabling real-time performance visibility, forecasting, compensation governance, OKR transparency, and root-cause diagnostics. Automated and governed 1,000+ incentive payouts, achieved 95% platform adoption, reduced manual reporting and analysis by 80%+, accelerated decision-making by 30–40%, and established a single source of truth for commercial performance, forecasting, and incentive management.

  • Tools & Skills: Power BI, Databricks, Presto SQL, Python, OKR & KPI Architecture, Target Setting & Performance Governance, Incentive Strategy, Commercial Planning, Revenue Growth Management, Forecasting & Opportunity Sizing, Sales Intelligence, Performance Analytics, Growth Strategy, Stakeholder Management, Cross-Functional Leadership.

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.

architectural photography of building with people in it during nighttime
Address

South Jakarta, 12180
Indonesia

Contacts

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