Ling Huang

Analyst, Inventory & Capex

Analyst, Inventory Control

1. Data Workflow Optimization: Streamlined ETL processes to ensure data integrity, improving report generation time by 40% through advanced Excel functions and Power Query. 2. Data Transformation & Visualization: Developed control reports in Power BI, leveraging complex DAX calculations and integrating multiple datasets to enable inventory tracking, supporting decision-making by senior management. 3. KPI Development & Trend Analysis: Designed a scoring system and defined KPIs to monitor inventory health, analyzing loss incidents to identify root causes and providing actionable insights for mitigation. Microsoft Power Query, Microsoft Power BI and +1 skill

Specialist, CRM & Marketing

1. Customer Database Management: Managed a 30,000+ customer database in Salesforce across five Asian countries and coordinated SMS campaigns for birthday and VIP events, enhancing customer relationship management initiatives. 2. Social Media Campaign Design: Designed 10+ digital social campaigns, incorporating A/B testing to evaluate key metrics. Applied advanced statistical analysis to optimize campaign strategies and improve audience targeting. 3. Promotions Execution & Coordination: Executed 5 promotional activities, overseeing the development of communication materials and logistics, while ensuring seamless alignment across internal teams and external partners. Microsoft Excel, Customer Relationship Management (CRM) and +2 skills