FP
Firhan P
Section Head Commercial & Customer Insight Analysis at PT. Lion Super Indo
Jakarta, IndonesiaWork 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.
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 NopemberJan 2015 - Jan 2019 - 4 yr
Skills
View More
Languages
English
Intermediate