Data Analytics Specialist

● Led the development of an OEE (Overall Equipment Effectiveness) dashboard across 3 manufacturing plants in Indonesia, enabling real-time performance monitoring and identifying efficiency gaps. The initiative reduced manual reporting efforts by 95 hours/month. ● Developed and maintained merchandising reports for Thailand and Malaysia using SQL queries and Power BI. Reduced manual reporting time by 12 hours/month and enabled the commercial team to focus on merchandising strategy and decision making. ● Led the design and deployment of a validation automation dashboard for Thailand, enabling fast identification of data mismatches between raw inputs and the Data Lake. Eliminated 1–2 man-days of manual validation per cycle. ● Designed and implemented an automated data validation framework in the Thailand market to detect discrepancies between distributor raw data and Data Lake output, reducing validation time by 98% (from 960 minutes to just 15 minutes) and significantly improved data accuracy for business reporting. ● Integrated Direct Sales and In-Market Sales (IMS) datasets into a unified dashboard, enabling the leadership team to identify sales gaps, improve decision-making accuracy, and reduce reconciliation effort by 8 man-hours/month. ● Led the development of a Power BI report that focused on strategic high contribution SKUs. The report enabled the Thailand marketing team to monitor key indicators from Direct Sales to Offtake, saving 150 minutes per month. ● Improved data reliability and data quality assurance in Thailand Offtake dashboard project by building a Python script to detect mismatches in product group names between raw sales data and product master using similarity scoring. Enabled business users to correct inconsistent naming, ensuring accurate reporting and reducing manual follow-ups during dashboard development. Reduced validation time by 95%. ● Provided one-on-one mentorship to a junior data analyst in Thailand, enabling her to independently build a Power BI report twice as fast as the former method.

● Delivered 5+ reporting solutions for the Japan and South Korea markets. ● Enhanced the visibility and inventory management by developing a Power BI report to track stock, shipment, and new supply in Distributor. This initiative saved 20 hours/month. ● Provided market share report digitisation for Reckitt Japan brands. The initiative saved 45 hours/month of working time. ● Collaborated with demand planner to develop a daily shipment report for Japan. The report saved 6 hours/month of manual work. ● Designed the weekly report automation to track tertiary sales of Reckitt Japan brands. This initiative led to 36 working hours/month of time savings. ● Developed custom report for Korea Pharma team. Provided information about MSL, Secondary Display, and Detailings. The report supported monthly 4P (Presence/Placement/Price/Promotion) meetings.