FP

Firhan P

Section Head Commercial & Customer Insight Analysis at PT. Lion Super Indo

Jakarta, Indonesia

Work Experience

  • Section Head Commercial & Customer Insight Analysis

    PT. Lion Super Indo

    Dec 2023 - Present -1 yr, 7 months

    Indonesia

    • Job Details:Delivered weekly, monthly, and quarterly business reviews directly to the CEO of Super Indo, covering key commercial and customer functions such as national market analysis, market share, customer insights, revenue, promotions, and data partnerships. Developed cost and profitability analysis, including 'what-if' scenarios, to support strategic pricing and margin decision. Led the data monetization project by developing a secure, self-service analytics environment for supplier partners, generating IDR 32 billion annually. Increased other income by 250% by transforming manual data monetization tasks into an automated, self-service dashboard, resulting in a 75% increase in participating suppliers. Transformed manual reporting processes into automated Power BI dashboards, enabling customized market analysis with various parameters. Created annual target of sales, profit, and promotion support from supplier breakdown into daily, and per store for operational execution. Developed system of sales forecasts by incorporating actual sales, profit, and promotion support.
  • Project & Cost Management Specialist

    PT. Tiara Vibrasindo Pratama

    Nov 2021 - Nov 2023 -2 yrs

    Indonesia

    • Job Details:Created and managed invoice systems integrated with project milestones and vendor performance tracking. Led the transformation of business processes from manual reporting to an integrated system, delivering cost savings of over IDR 250 million annually through improved efficiency and accuracy. Developed automated dashboards for daily, weekly, and monthly contractor reports, supporting on-time project delivery and cost transparency. Designed and developed in-house applications from scratch to manage cost control, project monitoring, S-curve tracking, and ROI reporting, in collaboration with finance & engineering teams. Streamlined documentation processes and monitored equipment rental usage, reducing reporting errors and increasing operational accountability. Initiated a project control dashboard to track all customer activities and potential upselling opportunities. Improved communication across finance, engineering, and commercial teams with shared reporting tools and alert systems.
  • Business Analyst Coordinator

    PT Midi Utama Indonesia Tbk

    Mar 2020 - Nov 2021 -1 yr, 8 months

    Indonesia

    • Job Details:Analyzed and monitored sales performance across 250+ stores, identifying product-level trends and recommending data-driven marketing strategies to boost category performance. Automated reporting and enabled real-time performance monitoring, significantly reducing manual analysis time. Delivered actionable customer insights by presenting customer segmentation, behavioral patterns, and their strategic implications to management, directly supporting business decision-making. Collaborated with operations teams to drive sales growth by leveraging customer data insights, using Pareto analysis to identify key items for product adjacency strategies and improve customer retention. Conducted market trend analysis by scraping data from e-commerce platforms, social media, and web sources using Python, enabling early identification of shifts in customer preferences and competitive dynamics.
  • Education

    • Bachelor's Degree in Geomatics Engineering

      Institut Teknologi Sepuluh Nopember

      Jan 2015 - Jan 2019 - 4 yr

    Skills

    • Power BI
    • Python
    • SQL
    • Cost Control
    • process automation
    • Forecasting
    • excel
    • Nielsen
    • PROJECT REPORTING
    • operation
    View More

    Languages

    • English

      Intermediate
    Share this Profile