Hoa Pham Email & Phone Number

San Francisco, California, Us

San Jose, California, Us

solid state LiDAR startup

Kanata, Ontario, Ca

Mitel acquired ShoreTel on September 25, 2017

Kanata, On, Us

ACQUIRED by Mitel September 2017• Improved visibility to daily Billings/Bookings by 700%, daily distribution of custom reports (SQL Server Stored Procedures) with drilldown details. • Created Custom SQL Sales Compensation database for quota setting & actual attainment for 300+ payees. Tool provides the luxury of adjusting variables to measure & promote Sales productivity.• Revamped the Market Share categorization using D&B/SIC Codes. Classified 400% more than the prior process. Able to determine Margins by Segment and expected Billings stream of customer.• Refined List Price Discounting calculations. Derived at invoice level details with Margin$ impact.• Introduced hierarchical Product Family reporting to magnify the key product line trends which contribute to company’s standard margins, and anticipate inventory obsolescence.• Instituted Revenue countdown report with Real Time snapshot progress, +/- 0.5% accuracy rate.• Produced and continually identify new key indicators/metrics to measure company effectiveness. • Solely designed and rolled out web-based Executive Dashboard (SSRS/BIDS).• Developed POS (Point of Sale) line item reporting system for North America 2 Tier Channel.• Solely implemented Expense Forecast Tool (Adaptive Insights), from design to production, including all complex Benefits and Tax calculations by location. • Built SQL database to monitor self-funded health plan claims vs ghost rates by service dates.• Forecast to Actual variance analysis for Income Statement, including Product lines and Channel.• Financial business support to all functional areas except Sales.• Developed Worldwide NPV ROI model with sensitivity analysis to evaluate R&D/PLM projects.• Prepared key metrics and managerial reporting for Earnings Call.• Development and roll out of Onsite Sales Incentive Programs. • Facilitated the AOP, monthly & quarterly forecasts, and long range strategic plans. • Managed 2 Senior Financial Analysts.

Geneva, Switzerland, Ch

• Maintained 12 month rolling Book forecast by Part & Customers, updated monthly with Sales/Mkt input. Created Reports to track monthly progress and visibility to ASP erosion & Unit mix changes.• Issued quarterly Board packages and weekly status reports to the Board of Directors.• Evaluated, designed and implemented strategic internal controls related to Revenue, Inventory and COGS, including related reserves, during initial implementation of Sarbanes Oxley 404 (SOX).• Designed SQL Server-based daily billings/booking/backlog reports and web-based Executive Dashboard used by 50% of the company, and 100% of insiders.• Responsible for the annual planning, monthly forecasting process, and 5 year Business Plans.• Provided financial business support to the Executive Staff, senior sales/marketing management.• Provided monthly variance analysis and commentary on revenue and margin for the Executives.• Prepared key metrics and managerial reporting for Earnings Call and script• Created Oracle FSG Statutory and Managerial reports.• Managed 1 Senior Financial Analyst.

San Jose, Ca, Us

• Consolidated internal reporting packages by Vertical (Profit Center) Market.• Managed data integrity of SAP R/3 and Bex reports. SAP SEM-BPS administrator.• Designed Business Unit structure in order to report with complex allocation process.• Solely responsible for creating custom SAP R/3 Report Painter reports (ECCS, LC, PCA, CCA), SAP Business Warehouse Bex Analyzer Queries/Workbooks (ECCS, PCA, CCA, SEM-BPS, APO). • Maintained and created SAP R/3 & SAP BW master data (cost centers, profit centers), report writer sets, variables, structures, row/column models, restricted key figures, and finance workflow table.

B.S., Accounting

Mba, Computer Information Systems