John Lee

John Lee

Sales Planning Supervisor · Targus

Rowland Heights, California, CA

In My Own Words

Detail-oriented Sales Planning and Operations professional with 10+ years of experience driving revenue insights, optimizing workflows, and supporting cross-functional teams in the consumer electronics and retail industries. Adept at Microsoft Excel (vlookup, xlookup, pivot tables, power query, power BI), Salesforce administration, reporting automation, and distribution partner enablement across North America. Strong analytical, project management, and vendor coordination skills. Open to Relocation, On-site, Hybrid, Remote.

Work Experience

Sales Planning Supervisor

Targus

2016 – 2025

Conducting daily reviews of sales quotes to ensure data integrity and adherence to corporate policies. Managing product data within Salesforce for the North American market, including the U.S., Canada, and Mexico. Implementing product setup for six distribution partners, leading to more efficient sales and purchase workflows. Monitoring and analyzing distribution partner sales and inventory levels to support data-driven decisions. Investigating and resolving price discrepancies for Accounting and Finance during account reconciliations. Calculating quarterly performance for six distribution partners for growth incentive payouts. Providing on-demand, data analysis reports to internal teams across the US, Canada, LATAM, APAC, and EMEA. Generating daily reports that synthesized key metrics for cross-functional teams, driving operational awareness. Skills: Microsoft Office. Microsoft Excel: vlookup, sumif, pivot tables, conditional formatting. Microsoft Access. Salesforce: User & data management, automation, maintenance & updates, lead & opportunity management, quote management. Data Analysis. Ad hoc reporting. Time management. Project management. Cross-functional team management.

Operations Manager

Payment Systems Corp

2011 – 2015

Empowering management in sales with data analysis and dashboard reports to inform strategic decisions. Analyzing and interpreting Salesforce data to develop accurate business forecasts and inform decision-making. Spearheading the management of multiple projects, ensuring all outcomes directly addressed critical business needs. Developing standard operating procedures to coordinate and manage operational/business workflow and projects. Handling the procurement of goods and services for 8 regional offices and record keeping through Erequester. Negotiating and maintaining relationships with vendors, leading to improved terms and access to goods and services. Contributing to a high-performing office through comprehensive administrative support. Skills: Microsoft Office. Microsoft Excel: Pivot Tables, Conditional Formatting. Salesforce. Ad hoc reporting. Time Management. Project Management. Procurement Management. Vendor Management. Cross-functional team management.

Planning Analyst

99 Cents Only Stores

2006 – 2010

Responsibilities include managing the entire life cycle of a product from acquisition to disposal. Managing and optimizing a $2M weekly inventory flow to 165+ stores from Commerce, CA headquarters. Acting as the primary liaison between stores and corporate headquarters, bridging communication gaps. Improving the company’s inventory turnover and weeks of supply by reducing scrapped dollars. Serving as a liaison for all stores’ merchandising issues. Partnering with the buying divisions to successfully execute all allocations per supply chain vision and strategy. Building effective relationships with Distribution Center staff resulting in reliable execution of directives. Skills: Microsoft Office. Microsoft Excel. Time Management. Cross-functional team management.

Inventory Analyst

Jet Apparel Group

2005 – 2006

Managing the tracking of shipments, purchase orders, and sales orders for the Buying Department, and resolve inventory discrepancies with vendors and warehouse staff. Directing inventory allocation to maximize merchandise movement and achieve full sales order completion. Serving as the primary point of contact for the sales department, providing real-time information on product availability and forecasting potential delivery issues. Ensuring data accuracy by monitoring and entering inventory and purchase orders directly into the MAS90/MAS200 system. Auditing vendor statements against internal invoice and payment ledgers to identify and resolve discrepancies. Generating insights from financial and sales reports to develop accurate cost and brand trend forecasts. Leading cross-functional initiatives with Accounting, Fulfillment, Warehouse, and Sales to solve supply chain challenges and improve performance. Skills: Microsoft Office. Microsoft Excel. Time Management. Cross-functional team management. Vendor management.

Education

Master of Science (M.S.)

California State University, Fullerton

2001 – 2004

Bachelor of Arts (BA)

University of California, Davis

1999 – 2001

Projects

Partner POS Reporting (Targus US, LLC)

Developed a comprehensive report from the ground up to track point-of-sale (POS) data for our three distribution partners on a daily, weekly, and monthly basis—quantitative & visual dashboards. This reporting tool has supported Channel Managers since 2017 by providing actionable insights to optimize partner performance and management.

MS Access to Salesforce (Targus US, LLC)

Led the initiative to transition our sales quoting process from a manual, keystroke-intensive MS Access system to an integrated Salesforce platform. Collaborating with Salesforce consultants, I helped automate quote delivery, centralized data management, and enhanced our ability to generate actionable sales insights.

Tariff Pricing Implementation (Targus US, LLC)

Successfully managed the complex implementation of tariff pricing changes for over 100 products in 2018. This involved updating internal and external pricing structures, cancelling 1,400 outdated quotes, and generating new quotes—completed within a tight timeframe of four business days.

Setup and Price Change Database (Targus US, LLC)

Identified a gap in documentation for new product setups and pricing changes while at Targus. Created an efficient Excel-based tracking system to record product introductions and price adjustments, enabling quick retrieval of critical data for internal and external stakeholders and significantly improving response times.

Call Center Build-out (Payment Systems)

Lead negotiations for the procurement of office furniture, computers, headsets, telephony systems, network infrastructure, and general office supplies. Coordinate essential services including telephony, IT support, cleaning, pest control, and vending solutions. Ensure compliance with insurance requirements in collaboration with property management. Oversee the complete office build-out process from initiation to completion. Successfully managed office build-outs in Orlando, FL, and two locations in Los Angeles, CA.

Salesforce Implementation (Payment Systems)

Initially, data management was fragmented across a custom CRM system, Excel spreadsheets, and email. I partnered with Salesforce to develop and implement an integrated data and reporting solution tailored to call center operations. Centralizing data improved reporting accuracy and enabled effective tracking of incentives for both outside and inside sales promotions. The implementation included the creation of interactive dashboards that enhanced business management and decision-making.

Interests

FoodOutdoor activitiesNba basketballSacramento kingsRecreation basketballGymInstagram

Skills

Microsoft OfficeMicrosoft ExcelVlookupXlookupPivot TablesAd hoc ReportingData AnalysisSalesforceSQLitePower QueryPower BIPerplexity AICopilotCommunicationTeamworkProblem SolvingAdaptabilityTime ManagementCross-functional

Industries

SkateSnowSurfBikeGolfDiveCreative AgenciesFashionFishingLifestyleMoto & PowersportsMusicOutdoorRunStreetwearSwimTechTriathlonWakeYogaHealth & FitnessOther