Experience

Tsingtao Brewery Co., Ltd

• China
• Food and Beverage Services
• 1 - 100 Employee

• Data Analyst

  • Jan 2021 - Present

  • Conducted business process analysis and identified critical issues, gaps and needs for an established process center.• Utilized analytical and technical expertise to provide insights and proposal to support business improvements.• Actively engaged in the quantitative analysis of sophisticated data to address business issues based on SQL.• Developed Key Performance Indicators (KPI) using Excel and used tableau to create dashboards for presentation to management which led to the execution plan.• Worked on the North America Market Flow (NAMF) project and performed the following: * Ensured 100% accuracy of data collection and reporting, used statistical techniques for hypothesis testing to validate data and interpretation. *Analyzed current and past financial data and performance across 15+ years, devised KPIs using SQL and Excel, identified a drop of 2.7% in net profit margin and a 5% increase in interest expenses. *Prepared dashboards with tableau to visualize and communicated insights, patterns and trends from complex data sets. *Minimize selling, distribution and administrative expenses and achieved a 5% increase in net profit and reduced the amount of debt used to finance equity and achieved 11% drop in interest expense. *Increased the accuracy of forecasting sales from 80% to 95%. Show less

• Analyst Internship

  • Jul 2018 - Dec 2020

  • Assisted the accounting team in the preparation of monthly journal entries, analyzing results and preparation of account reconciliation based on Excel.• Created several spreadsheets to organize the information and track the status of different tasks.• Reviewed financial statement and assisted with the preparation of dashboards which provided beneficial support to the finance manager and executives.• Executed various administrative tasks, analyze sales revenues, cost and expenses, identify trends and develop forecast.• Used Activity Based Costing (ABC) method which led to financial costs savings.• Participated in several webinars for new software that has being implemented in the company. Show less



CRAPME SARL

• Akwa-Douala-Cameroon

• Accountant

  • Aug 2014 - Sep 2015