Data Analysis – for Sales & Marketing and Finance• Maintenance, expansion and optimization of CIS analytics services (databases, reports, dashboards).• Develop data organization roadmap for key brands, customers and channel for sales and marketing department, based on analyses, market evaluations and historical trends.• Work hand in hand with Finance to prepare Sales Data and necessary information for ASEAN territory on weekly, monthly, quarterly and annually basis.• Perform monthly inventory check to ensure sufficient supply of product on-trade from both the supply and the demand point of view through ongoing monitoring of trend.• Drives the execution of internal Bayer CRM and ensure the KPI is aligned with trade marketing plan.• Implement and conduct holistic evolution to monitor the ROI of marketing & trade promotions and measure the effect in-store/online activities on channel, customer, or activities/campaign basis.• Generate, analyze & conduct market/trade insights report, competitor tracking and other relevant analysis on regular basis to support business strategic planning.Key achievements:• Revamping & restructuring the whole sale & marketing business reporting system by developing sales analytics reports and dashboards to provide actionable insights that support data-driven decision-making for the sales and executive leadership teams (Revenue, P&I, Inventory etc)• Engaged and worked closely with 3 aligned teams (Sales & Marketing, Finance management, and Supply Chain Team) to more effectively achieve data needs and analysis results.• Upgraded the existing internal tracking system with help of software such as Advance Excel, SQL, Power BI/Tableau to reduced tracking time by and helped in attaining 100% data transparency (Market Distribution Tracking, Price Tracking, Competitor Tracking, Customer Tracking)

Data Analyst – for Sales & Marketing and Finance•Supporting for Sales & Marketing Team on financial & marketing post-campaign analysis, tracking and reporting •Perform market analysis to efficiently achieve objectives and proposed solutions to improve marketing strategies and reduce total marketing and media expenses•Liaising with Nielsen in performing Econometric or Mix Marketing Modeling Analysis to determine the shortfall of company performance by using mix models from all range type of databases•Liaising with media & creative agency to ensure all media campaign align with the business plan and be executed accordingly.•Working together with the Social Media Agency in preparing monthly report and analyzing Google Analytic in measuring advertising ROIMarket & Competitor Research •Develop market and consumer intelligence through conducting quantitative and qualitative research as well as leveraging existing research sources syndicated and otherwise.•Investigate and conducted study on consumer demand, product insight, pricing, brand proposition and capital for products•Determine cost-effective alternatives for current and future projects and recommended changes to the allocation of the marketing budget based on data analysis.Consumer Behaviors Study•Tracking company performance via online review platform (Tripadvior, Google Business, Ctrip,) and social media platform (Facebook, Instagram etc) to analyst and study the consumer perception and feedback on the brand•Supporting Product Excellent department for KPI tracking and reporting•Supporting the CRM Team for LEGOLAND loyalty member programme in analyzing the customer purchasing behavior

•Create and run reports, metrics, analytics, and work with the right groups to improve key performance indicators.•Perform business analysis of eCommerce sales and operations to improve overall business performance•Provide eCommerce functionality expertise during project planning, development and production-support•Perform Quarterly site audit tasks and provide metrics summary on performance to management•Collaborate with scrum masters and project managers to create timely project status reports to all cross-functional stakeholders.•Define and create use cases and value proposition through market research and create metrics for data-driven and value-driven business decisions

• Utilized SPSS and MiniTab statistical software to track and analyze • Presented findings and data to team to improve strategies and operations• Develop new reports and delegated tasks to team members

• Assisted manager in optimizing data collection procedures in providing weekly and monthly status report to management on overall sales and purchase of marketing-communication material and marketing spent.• Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel function.