Patrick Stewart Email & Phone Number

San Francisco, Ca, Us

San Bruno, Ca, Us

San Bruno, Ca, Us

New York, Ny, Us

• Designed and built A|B testing platform from weblog data ingestion to result dissemination: 100% in Vertica, Python, and Tableau.Fully automated analysis from multiple data sources, such as Optimizely, ExactTarget, and internal tools.Extensible, provides statistical tests for a wide variety of parametric and non-parametric KPIs, including average order value, conversion rate, and purchase funnel progression tracking. Currently working on Life-time Value, shipping rate, and offer performance measurement. Exploring how to use Bayesian statistics.All metrics and statistical tests are completely reproduce-able and verifiable to anyone in One Kings Lane.• Designed and build shipping rate card optimization analysis platform. First major test resulted in One Kings Lane having a Holiday 2014 shipping promotion that was EBITDA neutral. Second major test resulted in over 3% lift in EBITDA for small parcel orders.

New York, Ny, Us

• Main data architect and business owner for apilog and weblog, Vertica-based analytics platform. Resulting system essentially obsolosced Google Analytics and Optimizely internally.• Daily work included querying a 2.5B+ row Vertica database of weblog data, A|B statistical analysis tests in R and Python, and data presentation in PowerPoint and Tableau• Designed and deployed interaction-level funnel tracking in support of product roadmap. Results led to supporting some portential projects and killing others

San Francisco, Ca, Us

• Developed and maintained Python based ETL tools, MySQL based data warehouse, and PHP based "in house" BI tools. Data sources included internal databases and external APIs. Implemented tracking included language identification in emails, regular expression based data extraction, and foreign key maintenance. Supported business groups widely used the tools provided.• Created multiple executive-level presentations utilizing existing and self-built data sources. Insights drove multiple tactical and strategic decisions throughout the business.• Used machine learning algorithms, including Random Forest and Generalised Linear Models to co-develop first-time predictive model of customer usage patterns and primary engagement drivers. Results were the foundation for TripIt Free and TripIt Pro's 2012 product roadmap.• Developed first-time descriptive model of customer engagement. Improving the analysis' resulting metrics became one of the Prodcut Team's two primary goals for 2012.• Developed lifetime value analysis for TripIt for Business soon after launch. 2011-12 marketing spend was adjusted to match results. Re-analysis six months later with more data proved original estimates were less than 10% off of actual behavior.

Phoenix, Arizona, Us

• Co-developed product management analysis for Microsoft Visio• Developed stochastic model for major shipping company's business operations; simulated results saw 10% cost reduction• Delivered Competitive Intelligence Analysis focusing on Brazilian medical device industry to major US medical device manufacturer• Business Development Consultant at the Business Development Center (BDC) of Jordan• Product Development and Chinese Market Entry Strategist for Bissell• Change Management Consultant for PetSmart Charities, Inc.• Peking University Module Abroad Program, Spring 2010• President, Thunderbird Emerging Markets Business Association• President, Thunderbird Technology & Business Association• Member, Thunderbird Rugby Club

Atlanta, Georgia, Us

• Co-led business evaluation, ROI analysis and initial internal deployment of new multi-million dollar data service • Developed SQL, SAS and Visual Basic based reporting suite; resulted in eight-fold increased team’s efficiency

Seattle, Wa, Us

• Designed data management systems of JoinExpedia.com, Expedia Inc.’s main contact point for new hotel business partnerships; directed implementation team of programmers and mid-level managers; resulted in hundreds of new business partnerships per month globally; maintenance required no new resource allocation• Ideated, designed, and led construction of new SQL based hotel database, led development team and identified, prioritized, and facilitated communication with tens of thousands of potential partners; final product required no new resources and became central to global growth strategy• Developed and analyzed competitor and market intelligence and statistical models for senior level management; instrumental in global corporate development strategy including decision to acquire Italian based online hotel booking engine valued at several hundred million dollars• Built SQL and WebQL based competitive intelligence and analytic tools to identify value and competitiveness of 8 potential strategic account contracts• Led process re-engineering that resulting in over 400% increase in competitive data volume

Seattle, Wa, Us

• Created and conducted price elasticity tests and designed Excel and VisualBasic based analytical reporting tools to optimize revenue for top Americas markets; resulted in over $3 million in annualized incremental revenue and the tool was adopted by the team

Jp

• Reformed entire elementary school English curriculum for Joyo City to foster greater oral communication abilities; junior high school teachers quickly reported marked improvement in incoming students’ capabilities • Led and produced content for 2 professional seminars, all in Japanese, for several dozen Joyo City school officials; resulted in adoption of new elementary school English curriculum• Translated and interpreted between Japanese and English for Joyo City official projects and meetings • Taught English to citizens of Joyo City from a wide range of ages and socio-economic backgrounds

Mba, Business

Bachelor'S Of Arts, Political Science, International Political Economy