LingLing Liu

1. System integration - UAT & data validation during the acquisition for new systems go-live. 2. S&OP (SIOP) - Weekly & Monthly cadences: - Weekly current quarter to date forecast consumption status tracking & adjustment. - Monthly outer quarters forecast by facilitating consensus forecast discussion with Sales, Product Management and Sales Finance teams (interlock). - Sales In demand forecast planning based on sell thru, channel inventory level health check and target on-hand goal setting, overlaying with top sales deals and promotions. Call out shortage and excess for teams to implement action items for improvements and/or corrections. 3. NPI & EOL forecasting - product transition trend and timeline analysis. 4. Salesforce deal tracking - Sales pipeline dashboard, tracking top deals by product family (Video collaboration) 5. Collaboration with Supply Planning - signaling forecast changes & ensuring regional inventory balancing.

A cyber security start-up: 1. Price book and quote to cash full sales cycle management. 2. Revenue forecasting and deal stage tracking. 3. OEM cost tracking tool built from the ground-up supporting Financial planning. 4. Salesforce.com administration (reports and dashboards, validation rules, process builder to automate multi-workflows, live update and automation among Salesforce.com, Gmail, Outlook and Google Sheets, etc) 5. Sales performance metrics (KPI) & commission reporting.

A consumer electronics start-up: 1. Demand forecast and supply planning - Built analysis and planning tools from the ground-up to perform inventory health check and drive inventory replenishment signals, which in turn reduced inventory cost by 1 million dollars while keeping sufficient supply to satisfy ongoing demand for retail channels such as Amazon, Apple and Best Buy. 2. Cost-to-revenue ratio analysis - review & approval of 3PL vendor billings - identified areas where logistics related expenses can be minimized & errors to be disputed, negotiated service contract renewals based on actual needs and reduced costs by over $30k a year in fulfillment & warehousing resources. Familiar with vendor portal systems from DCL, PCH and Flexport, etc. 3. Salesforce administration and customization -- identified gaps and inefficiencies in the existing process and created automated workflow and validation rules to ensure data integrity, reduce email traffic, and improve communication and productivity among Sales, Operations and Finance teams. 4. Product EOL & NPI coordination - worked closely with Product Marketing, Sales, Customer Support, partners, manufacturers and 3PLs to manage EOL and NPI projects 5. Sales metrics dashboard to monitor sales quota attainment -­ looking at gaps between forecast vs. actual, and triggering action alerts for account executives to reach sales target & ensure on-time quota achievement. 6. Business process improvement ­- Project lead for systems integration between Salesforce & 3rd party portals to automate data transit from order to invoice, minimized manual entry & avoided human errors. 7. New objects setup in Salesforce based on business needs such as workflow from ECR approval req to ECO execution.

A cyber security start-up: 1. Sales territory alignment & Sales compensation calculation tool - worked directly with executives and built out sales commission payout plan calculator that was used for a team of over 100 sales team members worldwide. 2. CRM: Salesforce.com and CPQ (SteelBrick - Quote Quickly) administration & customization including: a. Profile accessibility management, Objects & Templates creation & customization. b. Streamlining sales processes, appling validation rules to ensure data integrity, providing recommendations and implementing workflow & approval processes for productivity improvement & communication effectiveness. c. Advanced dashboard and report creation allowing executives slicing and dicing data straight from the SFDC dashboard page. d. Lead assignment rules to align with sales territory assignment. e. Single point of contact supporting and trouble shooting within Salesforce and CPQ. 3. Analysis: a. Subscription pricing analysis and price book management. b. Sales performance metrics. c. Data collection from various resources and cost analysis. d. Partner revenue analysis and business forecast. e. Other ad-hoc report creation and analysis 4. Cross-functional Support: a. Worked closely with HR, Finance and Sales executives to coordinate sales team members' quota and commission goal settings. Set up automated approval processes for Legal, Cloud Ops, Finance and Sales departments utilizing Salesforce.com. b. Pricing analysis for Product Marketing team.

1. Efficiency Improvement: Built macros (VBA) in Excel to automatically reorganize & analyze 65,000+ rows of data within seconds. Reduced work time from near one month to 2 days per quarter, for the external reporting team as a result of it. 2. Corporate in-house ERP Systems: Adapted the use of in-house Health Care Compliance (HCC) reporting system, understood the definitions & requirements of each HCC transaction category and provided training to employees to ensure compliant to government regulations. Also participated in UAT for new systems launch. 3. Work flow & process Automation (Adobe Acrobat Pro): Designed interactive PDF forms to standardize request forms used across several J&J family companies, as well as worked with the IT team lead to automate work-flow process by implementing digital signature approval process across departments. 4. Analysis: Prepared compliance/deviation analysis reports for department Director. 5. Reporting: Prepared monthly compliance report, monitored marketing spending and provided alerts to the Compliance Officers. 6. Reviewed HCC policies and procedures with management team.

Semiconductor division: 1. Sales forecast and production schedule planning. 2. Managed and validated forecasts from semiconductor customers such as Applied Materials, Lam Research and KLA Tencor. 3. Managed logistics vendors to ensure delivery schedule commitment was met. 4. ERP and other business systems management (Microsoft Dynamics GP, company backup systems). Worked with IT team on workflow design to enhance process and productivity. 5. Oversaw order to cash cycle and inventory reconciliation with Accounting team. 6. Documented and provided training of company systems. 7. Sales performance reporting and industrial news research.