Albert Yu Email & Phone Number

Shanghai, China

Shanghai, China

•Establish annual and monthly sales forecasting Excel models for 4S stores based upon annual total target sales volume; and collaborate with accounting team for annual and monthly operation projections•Organize monthly sales reports and conduct pivot and fundamental data analysis on various dimensions utilizing FineBI and internal order systems (stores, cities, central stores etc.)•Track and establish sales forecasting Excel model "X+X" following actual monthly sales figures; and… Show more •Establish annual and monthly sales forecasting Excel models for 4S stores based upon annual total target sales volume; and collaborate with accounting team for annual and monthly operation projections•Organize monthly sales reports and conduct pivot and fundamental data analysis on various dimensions utilizing FineBI and internal order systems (stores, cities, central stores etc.)•Track and establish sales forecasting Excel model "X+X" following actual monthly sales figures; and collaborate with accounting team and MAXUS for rolling projections•Collaborate with IT team to develop online operation status panels, including annual/monthly sales targets, completion, and other evaluation indexes (finance, insurance, post-sales, gross profit margins, etc.)•Collaborate with Tableau team to maintain and develop online databases, and automate the online digitization of offline spreadsheets•Tailor monthly targets for 4S stores and break them down into specific line models, while collaborating with the IT team for send-out actions (Python)•Other data analysis tasks assigned by management (market share analysis, city performance, "Twelfth Five-Year Plan", etc.),•Cross-functional communication in line with data analysis and development demands, ensuring smooth data acquisition and maintaining data effectiveness, authenticity, and reliability, while conducting analysis and visualization operations Show less

Shanghai, China

•Track sales performances by comparing and analyzing actual results with forecasts and periodic KPIs through Excel modeling and reporting back sales strategies and suggestions•Independently develop and structure E-commerce profit & loss models using data from e-commerce platforms and SAP and implement data visualization (PowerBI, Tableau), providing strategies and solutions to existing online sales setbacks• Consolidate sales, costs, and inventory data from SAP and produce weekly and… Show more •Track sales performances by comparing and analyzing actual results with forecasts and periodic KPIs through Excel modeling and reporting back sales strategies and suggestions•Independently develop and structure E-commerce profit & loss models using data from e-commerce platforms and SAP and implement data visualization (PowerBI, Tableau), providing strategies and solutions to existing online sales setbacks• Consolidate sales, costs, and inventory data from SAP and produce weekly and monthly reports for reconciliations and financial planning• Maintain product pricing models, conduct margin analysis, and compile periodic reports for management review on effective profit control• Support formulation and implementation of market data trends and analysis, provide insightful marketing recommendations to senior management• Verify data consistency and variances between reported figures and PowerBI dashboards and conduct variance investigations• Develop and update SOPs on data controlling and analysis procedures• Manage and maintain the company's SharePoint and access control efficiency• Assisted any other ad-hoc and cross-department tasks as assigned by management Show less

Shanghai City, China

• Delivered thorough analysis with management reviewing new and existing deals (deal origination, data analysis, market strategy, target screening and selection, valuation, risk control, and due diligence) • Provided proactive support in all aspects of due diligence including industry research, market analysis, business, and operation analysis to form a detailed proposal for approval• Conducted timely primary research on assigned industries, prepared presentations, and strengthened… Show more • Delivered thorough analysis with management reviewing new and existing deals (deal origination, data analysis, market strategy, target screening and selection, valuation, risk control, and due diligence) • Provided proactive support in all aspects of due diligence including industry research, market analysis, business, and operation analysis to form a detailed proposal for approval• Conducted timely primary research on assigned industries, prepared presentations, and strengthened communication between clients and local government authorities• Developed industry expertise through meetings with companies, industry conferences, and seminars and tracked developments within assigned industry focus• Assisted any other ad hoc tasks as assigned by management Show less

Shanghai City, China

Unisun is a global photovoltaic power plant investor, developer and clean energy solutions provider with the head office in Shanghai China and subsidiaries in India, USA, Australia, Japan, Germany and the Netherlands. By taking full advantage of its exact approach to quality control, technical design capabilities and project management experience, and thanks to its strong global product development and resource integration capacity, the company is able to provide a one-stop PV power plant… Show more Unisun is a global photovoltaic power plant investor, developer and clean energy solutions provider with the head office in Shanghai China and subsidiaries in India, USA, Australia, Japan, Germany and the Netherlands. By taking full advantage of its exact approach to quality control, technical design capabilities and project management experience, and thanks to its strong global product development and resource integration capacity, the company is able to provide a one-stop PV power plant investment service to clients around the world.Main Responsibilities include:• Efficiently reviewed and audited almost 300MW project-level financial models including FCFEs, returns, and sensitivity analysis; prepared corporate-level financial models based on planned business scope forecasting future cash flows, NI, and company valuation, delivering precious calculation outcomes• Supported investment decisions by extensively researching in the overseas renewable industry, macro-environment assessment, and photovoltaic market mainly involving market capacity, policy framework, credit situation, and subsidy mechanisms in SEA, South Korea, CEE, and West Europe• Extensively supported cross-border investment transactions and tax structuring involving local tax regulations, and efficiently handled external communication with overseas law firms and accounting firms such as CAM, KPMG, and local financial institutions• Actively participated in negotiation for financing scheme for a few major renewable projects; accurately analyzed project exits upon completion using the financial models• Prepared key commercial documents such as project teasers, NBO, LOI, project proposals, and other documents; provided executive post-project operation summary and costs analysis for management and potential buyers' review Show less

Auckland, New Zealand

• Accurately handled all significant financial transactions from all departments such as foreign currencies, sales, and transactions related to the daily operation• Conducted basic accounting and financial analysis of all aspect of financial operations such as variance analysis, balancing and cash flow management• Followed local financial compliances and regulations, particularly anti-money laundering

• Business School fundamental courses teaching tasks• Successfully conducted research on pricing hypothesis & demand estimation under supervision

Research associate in economics & policy field, focusing on the application of individual & firms (microeconomics) with PhD candidate at Columbia University.Reviewing literature & writing critiques

Bachelor Of Business, Finance & Economics

Activities and Societies: * Awarded 2014-2015 SRAA Research Scholarship * Awarded first-year Honors Roll student ( A-Level in Economics &.

Associate'S Degree, Business Administration And Management, General, Certificate Of Business