Ruibin Li Email & Phone Number

Carlingford, Nsw, Au

Sydney

• Develop data visualization via Tableau Reporting; Team lead for Tableau Champion Project: Transit BI from BW queries to Tableau reports;• Business partnering with Sales Team (NBM, SAMs); Prepare sales reports; Provide analysis on Price Volume Mix (PVM), Promotion Effectiveness, Pricing Strategy (Hi-Lo vs LPED) and Sales KPIs tracking;• Support Marketing and Category Team; Validate NPDs Financials; Track Gate process and drive monthly Project Management Review (PMR); • Prepare annual sales budget and deliver monthly forecast; Involve in IBP and Demand Review cycle; Publish monthend Sale Deck;• Support decision making process by P&Ls and scenario analysis for Tenders, NPDs, Private Label and Price Increase projects; Variance analysis on Return, Costing and Gross Margin;• Automate and streamline financial templates and process; Liaise among Sales & Marketing, Finance, BTS share service to resolve problems;

Macquarie Park, Sydney, Australia

Responsibilities:• Provide monthly management report pack and explain variances; • Support Commercial Team with monthly sales forecast, Rolling Latest Best Estimates (rLBE), and Integrated Business Plan (IBP); • Review GL Recs, GIT Recs & GST Recs for both Abbott AU & Abbott NZ;• Review and approve journals• Develop, maintain and update financial models; Streamline and improve financial process; • Problem solving for month end process and sub-system issues;• Liaise business with Finance, IT and Share Services;Achievements:• Streamline and automate GIT clearing process. The new process reduced one full day workload to less than half a day. Financial Controller was highly impressed and presented it in 2014 Asia Pacific Finance Conference as best practise in the APAC region;• Lead Abbott Molecular Division planning for 3 years;• Supervise and lead the new team to deliver all KPIs on time during ADD Finance Transformation period;• Introduce Access database to improve reporting process; Simplify financial templates and deliver higher accuracy and efficiency;

Sydney, Australia

Responsibilities:• Prepare weekly Executive Dashboard Report to Senior Management team; Comment on KPIs and highlight risk;• Coordinate planning process among states, regional and national level; • Prepare monthly sales/rebate reports and forecast;• Provide commercial supports to Merchandise and Marketing Department with wide range of reports and analysis; • Work closely with Finance Dept. and explain variance to Non-Finance stake holder;Achievements:• Introduce and deploy new planning templates; Enhance control over planning process. Develop VBA program to automate the consolidation of 13 profit centres; • Restructure and streamline weekly Executive Summary Report, reducing time taken by 20%;• Lead monthly Sales/Rebate Review meeting; Provide GM Commercial & Merchandise Team with in-depth analysis which are critical in trading terms decision making;

Sydney, Australia

Responsibilities:• Calculate and report IBA national rebates & IGA gate rebates; • Manage Key Retailor Reward program and Volumetric Rebate program;• Develop, maintain and update relationship database; • Liaise business with IT team to develop systems tailor to business need;• Continuously improve system performance, enhance data integrity;• Manage and build relationship with major liquor suppliers and customers (retailers);Achievements:• Secure and maximize rebate income with over 10% increase each year; • Identify system loophole and recover revenue over 3 million;• Improve rebate administration process; Reduce rebate collection time and enhance cash flow management;• Develop the prototype “Retailer of the Year” survey; Enhance Key Retailer Reward program and Volumetric Rebate model. These projects promote customer incentive and deliver customer satisfaction;• Lead supplier direct sales data integration project which enable third party sales data to be reported and analysed within the same ALM data warehouse.

Guangzhou, Guangdong, China

Responsibilities:• Supervise invoice processing,• Maintain the general ledger and subsidiary ledger • Calculate and distribute expenses among cost centres• Month end processing and financial reporting• Analysis, investigate and explain account variances• Balance Sheet reconciliations

Guangzhou, Guangdong, China

As a local business partner of PWC, Yangcheng Accounting firm is one of the largest auditing firms in China at the time, which has more than 300 professional employees specialized in auditing, access appraisal and tax consulting. It has a wide client base from listed companies, multinational companies and large state-owned companies. Lotus Notes auditing package is used to comply with PWC auditing standard.

Master'S Degree, Finance, General, Distinction

Bachelor'S Degree, Accounting, Distinction