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.
• 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%.

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.
• 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.
• 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.

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.

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.
• 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.
• 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.
• 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.

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