Roy Wang

Experience

• 

  VIAVI Solutions

  Jul 1999 - Oct 2001

  Optical Engineer

  Product/process development for optical switch group.- Performed root case analysis to increase yields by 25%.- Designed switch geometry to power requirements by 80%. - Programmed in LABVIEW for R&D test automation

• 

  Human Solutions NA

  Jan 2003 - Dec 2011

  Key Account Manager

  Business development to the apparel, automotive, military/government, and research communities for our HW, SW, PLM/PDM, and consulting services.- Trained customers & wrote custom XML scripts to measure 3D cloud data- Sold & consulted on Bayesian size prediction using mySQL DB training sets for major brands and military- Author and point man on multiple government projects for ARN/CDUM programs, using data analytics for prediction of sizes, inventory optimization, and product design, saving over $10 M over 10 years. Show less

• 

  Incoe Corporation

  Jan 2012 - Aug 2014

  Sales/BD Manager - Asia

  Directed 80 sales, service, and applications engineering in Greater China, as well as Asian channel partners. ($30 M revenue)- Wrangled & analyzed global data to find true sales drivers, increasing 2014 revenue 30%- Created Excel dashboards for executive to sell insights & strategy- Unified global engineering & sales to present one face to international customers, securing over $1 M in global business- Developed Chinese performance to Western norms- Transitioned WOFE to new leadership & legal rep, acted as interim GM Show less

• 

  RWF Training

  Aug 2014 - May 2018

  Owner

  Providing best in-class value e-training for niche applications, currently featuring CASPer™ test preparation, required for many progressive medical and nursing programs in the US & Canada. Consult on micro data projects. Get it done fast without the fuss and 50-page proposal!- Data wrangling, NHST, visualization, and reports for clients in R, Python, Tableau, and Excel- Verified Remicade side-effects statistically in line with national rate for local clinical pharmacy- Develop online test simulations with JavaScript, mySQL, PHP, over 100% year-on-year growth- Used Google Analytics to reduce Adwords spend by 50%- Prototyped workout app using JQuery Mobile. 4000+ downloads Show less

• 

  MakerBot

  May 2018 - Dec 2020

  Business Intelligence Analyst

  Chief BI Analyst working with cross-functional teams including sales, marketing, support, product, operations, and executive/C-suite for analytics and data-driven operations• Spearheaded the development of go-to-market KPIs to align sales, marketing, and customer success strategies. • Developed marketing timing strategy driven by printer event data, increasing consumables promotions by 24%• Increased dashboard adoption by 33% by boosting Tableau performance 2x via pre-aggregated reporting layer in AWS Redshift via Matillion • Built fractional marketing attribution model and machine learning lead scoring using Marketo, Salesforce, and Netsuite ERP data, explained to stakeholders with Shapley • Initiated data governance, decreasing post-deployment breakdowns by 80%• Automated data ingestion and admin processes via Python, reducing manually processing by 10’s of hours/wk• Performed analytics on hourly event data ingested via Kinesis to characterize user behavior & experience to guide product & marketing initiatives, increasing on-boarding completion by 14%• Established data culture with readily discoverable self-service exploratory dashboards, allowing functional teams to discover relationships and test hypotheses within Tableau before requesting a refined data story Show less

• 

  Keyrus

  Dec 2020 - now

  Led small teams (2-7) on multiple business intelligence and data platform modernization engagementsSME and coach for Tableau and analytics for pre-sales, client and internal teamsPropose and translate business questions into technical requirements, SQL, and KPIs/dashboards• Executed digital transformation to scalable Tableau self-service analytics, increasing report velocity 5x and saving 100’s of hours in manual reporting• Architected and developed semantic layer (1000+ line SQL queries) using dbt & Snowflake assuring alignment of metrics, interpretation, and visibility of lineage, increasing trust and usage by 50%, including key executives• Refactored to performant SQL to meet SLAs—taking key queries from 2 hours to 5 minutes• Built logistics solution in Alteryx, saving over 80+ hours/wk of manual optimizations and $20,000+ in monthly stock out penalties• Developed benchmarks for sales activity, contributing to a $20M+ sales lift• Found critical gaps in product strategy, refocusing on a neglected 2/3 of the business• Took vague requirements to compelling insights on time, on budget in as short as 3 weeks• SME on pre-sales, proof-of-concept calls and projects, landing over $1M in new contracts Show less

  • Managing Consultant

    May 2024 - now

  • Technical Lead

    Mar 2023 - May 2024

  • Senior Consultant

    Oct 2021 - Mar 2023

  • Consultant

    Dec 2020 - Oct 2021