Sr. Principle - Big Data Lab @ Clarity Solution Group
Managing Consultant @ ACT Consulting, LLC
Head of West Consulting Consulting, Rx @ Model N
Education:
About:
Strong track record ($B) of applying combined management consulting, data science/machine learning, software development to increasing CRM, sales, marketing, and finance performance in healthcare/pharmaceutical, high tech, CPG, insurance industries;
SAS, R, Python (pandas, scikit-learn), Excel/VBA, Cognos/TM1, Tableau, MS SQL, Oracle, Salesforce, Hadoop, NoSQL, Hive, Pig, ASP.NET, C#, C, C++, Java, Javascript, Phonegap, Unix admin
Clients/employers: McKinsey, HP,
Strong track record ($B) of applying combined management consulting, data science/machine learning, software development to increasing CRM, sales, marketing, and finance performance in healthcare/pharmaceutical, high tech, CPG, insurance industries;
SAS, R, Python (pandas, scikit-learn), Excel/VBA, Cognos/TM1, Tableau, MS SQL, Oracle, Salesforce, Hadoop, NoSQL, Hive, Pig, ASP.NET, C#, C, C++, Java, Javascript, Phonegap, Unix admin
Clients/employers: McKinsey, HP, IRI, BroadVision, Amazon, IMS Health, Sanofi, Merck, Novartis, Allergan, Takeda
Sr. Principle - Big Data Lab @ Consulting at Facebook on big data engineering and marketing analytics. Presto, Hive, Vertica, Tableau, etc From 2015 to Present (less than a year) Palo Alto, CAManaging Consultant @ Data science/machine learning for sales/marketing/managed care leadership to plan, track, and optimize performance. Covered broad spectrum of business issues through innovative data analysis/mining, communicated complex analysis to senior management, and established strong credibility with sales and marketing leaders. Technologies and statistics - SAS, Oracle, MS SQL, Hadoop, Python, Excel/VBA, t-test, chi-sq, linear and logistical regression, survival analysis. Some representative work:
- Recommended KPI metrics to sales force and brand management team to track performance, financial results, sales force activity, competitor promotion investments, etc; Prioritized sales calls and non-personal marketing promotions through segmentation, profiling, targeting with SAS, Excel/VBA, Oracle PL/SQL.
- Refocused sales force efforts on high priority physicians through value/call alignment analysis for newly acquired business unit.
- Evaluated relative effectiveness of sales messages to physicians. linear regression
- Analyzed compliance/persistence for specialty pharmacy product. survival analysis
- Designed and implemented a mobile/web system to help doctors acquiring new patients (marketing). The system consists of cloud based backend (Azure), doctor web site, and consumer mobile/web app. Consumer app is available at Google Play and Apple itunes stores.
- Developed web, mobile, Excel/PowerPoint front-end software systems for performance management, sales activity tracking, and incentive compensation for sales force, marketing, managed care.
- TM1 forecasting solution – Functioned as TM1 administrator/developer of forecasting group.
- TM1 cost accounting solution - Designed and implemented a set of TM1, Excel/VBA cost tracking solutions.
- TM1 cost allocation solution – Developed and support FP&A team on cost allocation system.
Forecasting: Managed forecasting of blockbuster CV drug with sales >$3B; From February 2003 to Present (12 years 9 months) Head of West Consulting Consulting, Rx @ Provide pharmaceutical client with business analytics and software consulting services.
- Achieved highest revenue in account history ($3.7MM) in first year while client company cutting cost by 25%.
- Team leadership: lead team in client projects for managed care, brand, and sales force. Significantly improved team’s capability by attracting high caliber people to the team. Hand-on work in SQL, Excel/VBA, QlikView.
- Personally analyzed large scale IMS Anonymized Patient-level Longitudinal data, discovered large opportunities. From 2013 to 2014 (1 year) Irvine, CAPrincipal @ Founding principal to build a new consulting practice which helps pharma senior leadership, marketing, marketing research, sales force, channel management to optimize business performance via our end-to-end solutions ranging from data collection, data management, reporting, analytics, to management consulting.
* Have total responsibility for entire business including strategy, sales, project delivery, recruiting, etc.
* Sold million+ US dollar of consulting work in 11 month to both MNC and local drug makers from a base of zero for the practice area. Achieved 190% in 2011.
* Built a high performance team. In client’s written words, “a united team with strong sense of responsibility and high professional devotion, perfectly organized and highly efficient, full of energy and positive optimistic spirit”
* Created large scale sales force management and planning systems
* Created marketing brand management report systems.
* Functioned as project manager, lead architect, and programmer when facing shortage of resources
* Technologies: SAS, MS SQL, Excel/VBA, ASP.NET, C#, Roambi. From May 2010 to July 2012 (2 years 3 months) Director, Advanced Analytics @ * Consumer goods industry marketing mix modeling to evaluate ROI, price elasticity, assortment strategies. From 2004 to 2005 (1 year) Sr. Product Manager, Vertical Marketing @ * Corporate strategies - developed company's growth strategy
* Product management - Portal integration with SAP, Siebel, MS Outlook, etc
* Vertical marketing - Telecom From 2000 to 2001 (1 year) Sr. Associate @ * Business strategy for high-tech companies
* IT strategy for insurance, banking clients From 1998 to 2000 (2 years) techinal sales, system engineer @ * Technical sales for global top 20 financial accounts
* Expert in high availability (MC ServiceGuard) From 1995 to 1998 (3 years)
MBA, Strategy, Marketing @ Northwestern University - Kellogg School of Management From 1995 to 1998 Alex Tsui is skilled in: Analytics, SAS, Data Warehousing, Management Consulting, Strategy, CRM, Microsoft SQL Server, Business Analytics, Segmentation, Consulting, Business Intelligence, Product Management, Statistics, Business Development, Market Research, Leadership, Business Strategy, PMP, Forecasting, Market Analysis, Enterprise Software, SaaS, Sales, Sales Operations, C#, Unix, ASP.NET, C, Corporate FP&A, Software Development, Marketing Research, Data Mining, Predictive Modeling, Competitive Intelligence, Data Management, Data Modeling, Big Data, Data Integration, Master Data Management, Customer Insight, Sales Management, Data Science
Websites:
http://www.ActConsultingLLC.com
Looking for a different
Alex Tsui?
Get an email address for anyone on LinkedIn with the ContactOut Chrome extension