Sam Y. Email and Phone Number
Experienced Reporting Analyst with a demonstrated history of working in various industries. Strong information technology professional skilled in Oracle Database, Business Object in SAP, Visual Basic for Applications (VBA), Modeling, and Microsoft Excel.
A.P. Moller - Maersk
View- Website:
- maersk.com
- Employees:
- 27916
-
Business Performance Reporting AnalystA.P. Moller - Maersk Feb 2024 - PresentSydney, New South Wales, Australia -
Excel SpecialistChatered Accountant Company Apr 2023 - Jan 2024Sydney, New South Wales, Australia -
Talent Planning AnalystTransport For Nsw Jan 2022 - Jan 2023Sydney, 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. -
Reporting And Performance AnalystHume Building Products Apr 2019 - Dec 2021South 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 -
Payroll Reporting AnalystToll Group Jul 2018 - Mar 2019Granville, 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. -
Sales Reporting AnalystVolkswagen Financial Services Sep 2016 - Jul 2018Chullora, 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. -
National Rebate Analyst - Pre-PlanningLg Electronics Australia Pty Ltd Apr 2011 - Sep 2016• 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.
Sam Y. Education Details
-
Electrical, Electronics And Communications Engineering
Frequently Asked Questions about Sam Y.
What company does Sam Y. work for?
Sam Y. works for A.p. Moller - Maersk
What is Sam Y.'s role at the current company?
Sam Y.'s current role is Business Performance Reporting Analyst.
What schools did Sam Y. attend?
Sam Y. attended University Of Sydney.
Who are Sam Y.'s colleagues?
Sam Y.'s colleagues are Lyndon Cheesbrough, Prasanna Huggi, Runali Kale, Jiang Wu, Darlyne Ibarra, Roger Munoz, Charles Dickson.
Not the Sam Y. you were looking for?
-
2pestcontrolsydney.com.au, pestcontrolsydney.com.au
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial