Data Analyst
CurrentBuilt Sales Performance Reports: Created weekly and monthly sales data reports compared to targets and benchmarks.Built KPI analysis report: Analyzed location success (percentage of new store locations meeting or exceeding performance benchmarks); Tracked revenue growth of newly opened stores; Evaluated financial metrics (ROIC, EBITDA) for newly opened stores; Conducted employee performance analysis.Developed Threshold & Checklist for New Store Location Decisions: Utilized regression methods to develop comprehensive threshold criteria based on demography data and features of successful stores and Created checklist forms to evaluate potential new store locations.Market Analysis: Collected, pre-cleaned, and analyzed data on market value, demography, economic structure, GRDP, FDI, tourists, retail information, and competitor analysis.Evaluation of Analysis Tools & Equipment: Assessed the Gapmap tool for administrative level checks across 63 provinces and evaluated 242 location proposals from the Gapmap supplier. Conducted trials for 4 store locations based on Gapmap proposals, achieving a 25% target success rate, compared to Highlands proposals which achieved a 77% success rate.System Performance Analysis for All Stores: collapse with Operations and Finance team to analyze store operating, profit and convenience locations for all system stores