alifnh14

• Collected product data from marketplace APIs such as Kinguin and IsThereAnyDeal to monitor prices, stock, sellers, ratings, and transaction information. • Compared prices across sellers and grouped and filtered products based on game, item type, region, and category. • Combined pricing data with currency exchange rate APIs to convert multicurrency prices into IDR and calculate markup and payment fees. • Used the lowest competitor price as a benchmark to determine product prices on Itemku while considering exchange rates, markup, and payment fees. • Presented processed and analyzed Itemku product data through dashboards and exports, and sent reports to Telegram for automatic monitoring without needing to open the website.

• Processed and analyzed operational data for performance monitoring and achievement evaluation. • Monitored Target vs Actual, Achievement %, Sales, and AO (Active Outlets) as part of operational performance monitoring. • Used SQL queries to retrieve and process data according to reporting and analysis requirements. • Used Excel Pivot Tables to summarize and analyze operational data. • Updated Power BI dashboards to present KPIs and facilitate performance monitoring. • Checked and validated data before use in reporting to ensure accurate and consistent analysis. • Used Excel VBA Macros to assist in automating salesman reporting processes.