Andrew Searson Email & Phone Number

Santa Cruz, Ca, Us

We are a boutique business intelligence firm that offers high-quality consulting in the newest data-stack technologies

Portland, Or, Us

Mountain View, Ca, Us

Santa Cruz, Ca, Us

Santa Cruz, Ca, Us

San Jose, Ca, Us

San Jose, Ca, Us

Created and maintained the logic for all Internet Marketing performance

San Jose, Ca, Us

San Jose, Ca, Us

Corte Madera, Ca, Us

Compiled Information from different Enterprise Systems in order to create Freight Analysis which was used to adjust Restoration Hardware's freight charge for customers going forward. Used MS SQL Server along with Microstrategy to perform ad-hoc reporting for different business groups.

El Segundo, Ca, Us

Helped ensure data quality and process improvement methods that improve profits, revenues and cash flows without influencing demand.Discovered significant discrepencies in company processes and have recovered millions of dollars as a result including realized settlements from B2B partners.Migrated all reporting, profiling and monitoring data into the SAS data warehouse which lead to numerous revenue leakage discoveries.Project management lead on a number of margin assurance issues including Base Package reconciliation, Improper HD/DVR fees, etc. resulting in a ~$2 million annual revenue lift

Fremont, Ca, Us

Interpreted Weekly Forecast for multiple JIT Hub locations and followed DOS/DSI metrics in order to satisfy product pulls in an efficient mannerCreate All-in-One Dell reports through Web Intelligence and added dynamics through VBA manipulationDaily interaction with global buyers of Dell and corresponding ODM BuyersRoad-mapped Forecast plan with Seagate to Dell sales team and executed dynamic Forecast plans weeklyFacilitated implementation of Virtual Hub which automates and takes action on Forecast Metrics ultimately trafficking multiple products to multiple Hub locationsPersonally in charge of supplying Dell on average 2 million Hard Disc Drive's every Fiscal Quarter which accounts for approximately 1/5th of Seagate's revenueAnalyzed, Identified and Proved DOS metric disconnect between Dell and STX which resulted in more efficient forecasting and supply traffickingAutomated On-Demand Approximate Inventory used in planning Shipments and Supply Hub StockAutomated Build/Remaining Build reports used in Supply PlanningAutomated DOS/DSI comparison demand supply reports which compare Dell's view to Seagate's viewAutomated Aging Summary report by Customer and Market Segment which identifies action necessary for aging drives

Fremont, Ca, Us

Created Fulfillment data architecture using SQL on a neighboring database and successfully automated Demand Supply files for Enterprise and Notebook products through use of ODBC connections, this was recognized and rewardedAutomated Daily Ship + Book reports for all Market Segments in a variety of categories using VBACreated and automated Available To Promise (ATP) report for the neighboring Distribution Account Management group which was recognized and implemented in daily useControlled all Enterprise Product fulfillment for Distribution Channel, including Inter-company Shipments through the use of the newly implemented Supply Execution ToolActed as the liaison between the Operational Dynamic Planner and the Fulfillment group and helped successfully promote the tool from the Development to Test servers and finally to Production serversWorked with neighboring departments in order to diminish Process Flow time and succeeded through the use of the Operational Dynamic Planner data schemaWorked with Order Management and created a daily Backlog report which identifies process complications including Non Box Quantities and improper freight termsTeam Seagate nomineeUsed SQL and VBA to automate every weekly and daily report asked of me