BI Developer (E-commerce)

○ Served BI and analytics needs for the eCommerce business units in Thailand and Philippines

○ Lead the data warehousing initiative for PH data and covered end to end BI projects from understanding the business requirements to preparing the data to delivery of the solution

○ Sole BI developer for the PH project which consists of the following outputs: KPI dashboard, SKU and inventory report, cohort analysis

○ Served as Project Manager for the HQ's (Thailand) data analytics hub supporting the different business units (eCommerce, digital marketing, logistics and fulfillment, financial technology, and micro finance)

○ Managed project delivery for a team of data scientists, data engineers and BI developers

○ Main POC for ongoing projects, new business initiatives and represented the team during cross-functional meetings

○ Team's projects consist of the following: cohort analyses, customer acquisition and retention, demographics, customer segmentation, upselling, cross-selling, cannibalization, campaigns, cost reduction, fulfillment routing, ad hoc data requests, KPI dashboards, data ingestion and ETL, risk and fraud scenarios (alerts and monitoring)

○ Assigned as regional PM for BI and Analytics for the rollout of TrueMoney in the following countries: Cambodia, Vietnam, Myanmar, Philippines, Indonesia

○ Created a regional dashboard for monitoring the growth of the different products and services in each market

○ Lead regional data warehousing and automation of the KPI dashboard ○ Built a data management tool for pricing with the following features:

dynamic product search with info on current price, traffic and sales performance, demand and supply

price comparison on scraped products from competitor websites and manual inputs from offline store hunts

dashboard and self-service report extraction:

SKU report - detailed report on SKU level generally used by the different departments for daily operations: content, buying & sourcing, marketing, pricing

KPI report - high level dashboard showing the company's sales performance on different time frames

○ Supported ad hoc data and analysis requests

○ Supported data management and analysis for marketing campaignscollaborated in defining metrics to measure the effectiveness and profitability of each campaign

supported data requests for targeted customers / audience

○ Handled tickets and delivery of market research and scraping requests