Adrian Chung Email & Phone Number

- Empowered data-driven decision-making by conducting comprehensive data analysis encompassing data cleaning, ETL (Extract, Transform, Load) processes, and detailed examination of sales metrics. Leveraged SQL and Excel to uncover pivotal trends, subsequently delivering actionable insights that optimized marketing strategies and fueled strategic decision-making.- Conducted Python API requests alongside Power Query for comprehensive ETL implementation, achieving a consistent On-time Delivery… Show more - Empowered data-driven decision-making by conducting comprehensive data analysis encompassing data cleaning, ETL (Extract, Transform, Load) processes, and detailed examination of sales metrics. Leveraged SQL and Excel to uncover pivotal trends, subsequently delivering actionable insights that optimized marketing strategies and fueled strategic decision-making.- Conducted Python API requests alongside Power Query for comprehensive ETL implementation, achieving a consistent On-time Delivery rating greater than 90% and reducing Fill rate errors to less than 1%.- Enhanced operational efficiency within the Distribution Center by optimizing pick paths, refining inventory level management, ERP reporting process, and implementing automated periodic replenishment, which resulted in a 22% reduction in order fulfillment time.- Automated weekly report generation using VBA and DAX, reducing manual time from 45 to 2 minutes, and introduced drill-down capabilities for root cause analysis.- Utilized historical data for forecasting labour distribution, effective inventory control, and informed decisions on freight usage. Proficient in Matplotlib and Seaborn for impactful data visualizations. Show less

Vancouver, British Columbia, Canada

- Analyzed and selected the entities and fields to consolidate a dynamic list for configuration data export in preparation for CRM platform migration.- Provided trading support for discretionary and non-discretionary clients through the review and monitoring of daily reports, Investment Policy Statement, and KYC updates.- Performed CRM database clean-up and quality assurance to enhance operational efficiency and document improvement.

Hong Kong Sar

- Consulted and led discussions with C-level executives of listed companies to understand business needs and organizational goals, and formulate development & and communication strategies that align with market trends, resulting in a 150% increase in stock value.- Acted as liaison between business stakeholders, internal & and external departments, and sell-side/ buy-side investors to ensure smooth implementation of business solutions and positive market exposure.

- Arranged over 100 logistics of samples and event materials to support editorial shoots in Asia, and press previews in Beijing, Shanghai, Singapore, and South Korea.- Draft, translate and distribute content such as press releases and newsletters to media contributors and stakeholders.- Develop catalogue marketing strategy, mailing schedule, and recipient lists to make sure that it goes to the right audience at the right time.

Applied Data Analytics Certificate

Bachelor Of Business Administration - Bba