Kevin Yu Email & Phone Number

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

- Managed complete stock movements and adjustments in SAP, ensuring stock reconciliation and addressing variances to maintain a high level of inventory accuracy.- Perform root cause analysis on Slow Moving and Obsolete (SLOB) and Out of stock items with demand forecasts.- Analyzed warehouse and transaction data to identify efficiency opportunities, working closely with supply networks to optimize warehouse costs, improve product availability, lead times, and delivery schedules.- Conducted regular stock takes and optimized inventory levels to reduce obsolescence, ensuring a balanced approach between stock availability and minimal waste.- Extracted and analyzed Material Requirements Planning (MRP) data to adjust purchasing requirements, achieving a 95% service level for supply planning and inventory management.- Maintained and reconciled purchase orders with shipments diligently, addressing any discrepancies promptly to maintain accurate inventory balance files and report critical stock levels to management.- Customized and integrated SAP systems to align with master data and MRP parameters, conducting root cause analyses on slow-moving, obsolete, and out-of-stock items to refine demand forecasts.- Developed and assisted in the implementation of data analytics and reports for senior management, providing insights on inventory movement and holding optimization, and played a key role in the Sales and Operations Planning (S&OP) process, enhancing decision-making and operational efficiency.

Melbourne, Victoria, Australia

- Design BI solution with Subject Matter Expert from stakeholder requirement elicitation to provide PoC (Prove of Concept). Key projects involvement including: Migrating on-premises Data Warehouse into Azure Data Lake using Synapses Analytics. E-Commerce & Retail Sales Data Integration Service Establishment. Google Ads & GA4 Digital Performance Dashboard. Microsoft Dynamics 365 (ERP) Power BI Reporting in Finance and Operation Module.- Supporting delivering insight and trends BI Reports like Product Up-selling, Service WIP Sales & Revenue Dashboard, Budget Forecasting, Inventory on hand/Inventory Ageing reports, Retail & Wholesale Reports by using Power BI DAX and T-SQL to consolidate data and populate measures and columns for ad hoc insight report by applying models like Pareto Analysis, on demand forecasting and so on.- Set subscription of automatically send Daily/Monthly Sales Summary snapshot to managers’ Email.- Familiar with generating cumulative sales forecast, customer life cycle analysis, sales pricing modelling to drive business sales performance.- Implementing Power Apps and Power Automate to schedule automated flow for sales managers to call data by simple button click, helping sales department to achieve automation business flow.- Daily Written T-SQL script in MS SQL Server Studio, to create and amend views, store procedures to enhance the BI report automation efficiency.- Assist to Build up ETL pipeline in MS Visual Studio 2017, ensuring batch data from OLTP automatically stored in data warehouse for the consistent Power BI analysis demands, running the SSIS package by scheduling from Server Agent. Build transformation pipeline to consolidate data from Azure data lake.- Collaborating with IT to launch BI report testing in UAT environment, following the test case and acceptance criteria to gather testing feedback, then update the live branch.

Melbourne, Victoria, Australia

- Daily Scrum meeting and interact with the Scrum Master and data engineer via Jira the data life cycle related to digital campaign performance HRIS insight reporting.- Continuously Integrate Google Ads, Google Analytics 4 into MS SQL server data warehouse for populating insights in Power BI to streamline the reporting flow, scheduled auto extract refresh, resulting in approx. 20% of the time saving.- Assisting marketing team to implement SEO data tracking project, setting up tags and triggers in Google Tag Managers in HTML class to collecting user purchasing behavior data (event click, call to action button click, landing page viewing & duration time, etc.), achieving 20% of budgets saving.- Generating reports including charts (Pareto, waterfall, radial bar chart, lollipop charts, etc.) and managing the user-friendly dashboard for marketing team to interact with the visualization, for viewing key metrics such as Event Clicks, retention rate, conversion contribution modelling, ROAS (Return on ads spend), Cost Per Click, Click Through Rate to adjust bidding strategies.