Sam Y. Email & Phone Number

Sydney, New South Wales, Australia

Sydney, New South Wales, Australia

Sydney, New South Wales, Australia

• Provide data and analysis input into recurring reporting deliverables (having weekly, monthly, quarterly, and annual reporting cycles) including ad-hoc reporting requests.• Maintain regular liaison with and training of various personnel across the organisation, cross referencing information weekly to ensure all data is accurately captured.• Assist in defining and developing reporting strategies and contribute to reporting solutions for business strategy and program/project decision makers.• Provide support to the Manager in the interpretation of trends, problem areas and opportunities from the data gathered from HR and other business systems used by the division.• Engage internal business stakeholders regarding requirements gathering, deployment to ensure that reporting requirements are understood and met.

South Granville

• Partner with various internal stakeholders to define and document reporting and analytical requirements for continuous improvement• Create and prepare periodic KPI reporting that highlights business and individual/team performance levels and ensure deviations are investigated, rectified and establish what ‘best practice’ looks like in our business • Provide valuable analysis and insights that drive further investigation and develop recommendations to extract optimal return on investment• Participate in the development of strategies, operating models, roadmaps and business cases for Analytics and Business Intelligence solutions• Proactively provide key insights and analysis to various business units to help formulate strategy and investment decisions• Identify and analyse situations and/or issues, consider options, develop solutions and implement or monitor appropriate solutions• Gather, validate, store, retrieve filter and disseminate business information to key team members within agreed procedures to assist in effective and efficient decision making• Identify risks and opportunities across the business, bringing a collaborative approach and strong business partnering ability• Listens, interprets and conveys information in a clear and accurate manner providing timely delivery of information• Other company-wide ad-hoc projects and tasks

Granville, New South Wales, Australia

• Oversee the review and analysis of systems functions and process improvement.• Interpret multiple EBAs.• Reconcile any discrepancies and correct existing faults.• Outline and build frameworks.• Automate the manual processes where reduction in time taken is critical.• Implemented automated Redundancy Calculation template that reduces human error and time taken per estimate.

Chullora, New South Wales, Australia

• Implemented automation on MIS morning process that used to take 3 – 4 hours every day and now it only takes around 15 minutes with few buttons clicks.• Implemented automation on Wholesale Facility Schedule Rate Calculation Process for Finance/Accounting departments in VWFS that used to take 4 – 5 hours and now only take less than 10 minutes.• Implemented macro-based automated Retention Rate International KPI report at my third month at VWFS that HQ has been requested for the last 5 year before my time and no one across departments could resolve.• Implemented macro-based tool to manage Dealer and Contact information at my forth month at VWFS.• Have automated all current responsible reports to reduce average days to deliver the reports to 2 – 4 days at VWFS, and previously it took 12 – 15 days.• Develop and streamline internal and external dealer performance and KPI reporting.• Assist Regional Managers with new Dealer Credit proposals and presentations including dealer quarterly performance reviews.• Analysis and reporting of competitor activities in the market and maintain competitor pricing and product database.• Deliver timely, accurate, executive and functional reporting via periodic and ad hoc output for use by Sales and Brand Management.• Work cross functionally with internal departments on projects and initiatives including budgets, forecasts, sales and program effectiveness.• Meet ad hoc data analysis and report requirements of managers and others.• Keep track of business changes and initiatives whilst anticipating data/report needs.• Arrange data collection, analysis and preparation of the reports to meet the ad hoc needs of the business.• Prepare reports for Senior Management to ensure they are aware of developments and their implications for the business.

• Initiated, developed and automated a reporting tool base on Excel VBA, reducing the time it takes to generate customer related reports from 7 days to 1.5 days, saving the company approximately half personnel per year and improving response times to the customers at LG.• Created CFO’s KPI management tool that has fixed past incorrect measure at LG.• Created Budget Balance Report tool that assists senior manager to make more accurate decision on aged accruals at LG.• Managed to dramatically improve the rebate structure schedule table and automated it in order to make it more user friendly and easier to interpret the information at LG.• Was promoted within 3 months of starting at LG.• Initiated, developed and automated a reporting tool base on Excel VBA, reducing the time it takes to generate customer related reports from 7 days to 1.5 days, saving the company approximately half personnel per year and improving response times to the customers.• Created CFO’s KPI management tool that has fixed past incorrect measure.• Created Budget Balance Report tool that assists senior manager to make more accurate decision on aged budget.• Developed automated rebate reconciliation tool that cross matches accrual in the system and actual rebate amount, and produces reports.• Managed to dramatically improve the rebate structure schedule table and automated it making it more user friendly and easier to interpret the information.• Adapted a new global system across the company’s subsidiaries to help headquarters to manage and monitor sales deductions more effectively.• Maintain various data that are collected from Oracle and Data Warehouse and generate regular/ad-hoc reports with high level of attention to detail and accuracy, based on Excel formula and VBA scripting.• Register all national sales rebate requests across Australia and New Zealand.• Monitor all registered sales program and reconciliation of rebate accrual figure versus sales.