Lily Tran Email & Phone Number

Carson, Ca, Us

Carson, Ca, Us

Beverly Hills, Ca, Us

• Created financial models and various scenario-based reporting for executive management to assist in strategic planning and decision making• Created pricing and cost analyses to help drive promotional initiatives and understand the impact of pricing adjustments on overall profitability• Initiated monthly discussions with department leaders to ensure that their spending and financial projections are aligned with their plan/budget • Prepared month-end financial summaries for executive management highlighting profitability and sales performance across all retailers, product categories, new launches, and store locations• Increased accuracy and efficiency in expense tracking by establishing a system for budgeting and cost center coding • Supported expansion opportunities by researching current market trends to identify customer insights and potential risks before entering prospective markets• Beginning-to-end implementation of a new sales analytics platform (Askuity) for over 80+ users

Düsseldorf, North Rhine-Westphalia, De

• Consolidated financial data for all entities under the total Henkel NA Professional Beauty Care business unit during the acquisition of three companies and helped integrate them onto the Henkel platform.• Delivered monthly reconciliations and reporting including P&Ls and variance analyses of actuals, forecasted numbers and sales plan for brands and products, customers, and accounts.• Executed projects to boost efficiency such as creating manuals and shifting a series of reporting to the SSC, as well as functioned with other departments distributing monthly and ad hoc reporting like brand/product analysis and budgeting.• Performed ad-hoc analysis and special projects as needed• Experienced in SAP/Business Warehouse systems including other add-ins such as Tagetik, ALEA, and COMET for financial reporting, data extraction, and researching accounting issues

Düsseldorf, North Rhine-Westphalia, De

• Created monthly reports for trade spending, P&L’s, brand spending, administrative costs, commission accruals, inventory balances, fill rates, promotional cost of goods, and all other ad hoc projects in an effective and timely manner.•Helped prepare annual budget and additional forecasts, created schedules for uploading into the planning database, in addition to gathered and organized information and financials for monthly executive meetings.•Proactively interfaced with other departments such as marketing and demand planning to enhance the retail business; provided support in forecasting and planning promotions through the analysis of sales and trends.

Düsseldorf, North Rhine-Westphalia, De

• Prepared monthly reports and analysis for marketing accruals, trade spending, brand spending, administrative costs, commission accruals, inventory balances, and promotional costs of goods• Performed ad-hoc analysis and special projects as needed• Utilized SAP for financial reporting and researching accounting issues

Irvine, Ca, Us

• Resourcefully performed many various secretarial and administrative duties, along with minor academic advising.• Provided assistance to five counselors and three peer advisors on various ad hoc projects.

• Researched current trends of particular industries and several domestic and international companies to provide clients with the best business solutions and cost savings, and provided assistance in producing purchase orders and quote letters.• Corresponded with forthcoming customers and vendors to inquire about interest in probable business relations, and collaborated with sister company, Global Discoveries, Inc., in various future sales and marketing projects and promotions.