Wei Shan Lee
480-***-**** ******@***.*** Phoenix, AZ 85054 linkedin.com/in/wei-shan/
Drives business value by executing data-driven improvement strategies, performing ad hoc analysis, and automating processes.
Business Analytics Revenue & Gross Margin Analysis Strategic Forecasting & KPI Reporting Data Migration & Management
Data-Driven Business Solutions: Identified influencer metrics for Find Your Influence, Inc.’s recommender system by developing a new rating algorithm. Mapped processes, developed entity relationship diagrams, and conducted exploratory data analysis.
Process Optimization: Reduced customer wait time by 41% and increased revenue by 2% at Starbucks by implementing operational framework changes such as assigning additional counter staff and relocating equipment based on data insights.
Seamless Project Execution: Delivered a 6-month long project in only 3 months at American Express by continuously monitoring project progress; delivered weekly data analytics reports and executive-level presentations for informed decision making.
Industry Skills & Tools: MySQL, Microsoft Office (Advance in Excel, PowerPoint, SharePoint), Tableau, Power BI, R, and ANOVA.
Data Optimization Modeling
Business Stakeholder Management
Financial Modeling & Visual Analytics
Data Quality & Integrity
Requirements Analysis & Elicitation
Operational Analysis & Automation
Data Exploratory Analysis
Six Sigma/DMAIC
Budget Compilation & Reporting
Analyst Experience
Business Analyst, American Express 07/18/2018 - 10/1/2019
Developed information security KPI and performed data warehouse cleaning for company applications as part of a 6-month project with the Business Information Security department. Maintained brand reputation by working closely with on-site and off-shore teams to optimize inventory management. Help increase adherence to regulatory and contractual compliance. Support and execute risk and control activities including Partner Control Assessments and Data Integrity Assessments.
Stakeholder Relationship Management: Currently working with the Global Partner Network team; use Excel VBA and SharePoint mapping to facilitate automation and improvements in business processes, mitigate operational risk, and improve enhancement to controls.
Root Cause Analysis: Scrutinize processes and provide recommendations to improve alignment to overall business objectives.
Data Source Creation & Transformation: Streamlined information flow for business unit leaders by creating data dashboards in Power BI using SQL. Analyzed data outliers and improved the mining process by working with business and technical teams.
Standardized Metrics: Augmented data security by automating inventory reconciliation and building a centralized database.
Improved inventory accuracy by performing data profiling and cleaning for 1K+ business applications. Addressed configuration item errors by remediating discrepancies between documented notes and data path findings.
Business Analyst, Find Your Influence, Inc. 01/18/2018 - 05/18/2018
Assisted a team of marketing analyst for a six-month long project to strengthen the company’s current influencer scoring model for targeted customer product marketing; presented a new, improved scoring algorithm and identified potential influencers.
Data Accuracy: Elevated company’s rating performance by measuring correlation of variables for accurate algorithm patching. Conducted predictive analysis and factor analysis on engagement and multivariate analysis on key score variables contributing to influencer rating.
Exceeded client expectations by providing mathematical rationale to eliminate weaker variables.
Business Analyst, ASU Starbucks 8/17/2017 – 12/17/2017
Improved service quality and revenue for a Starbucks franchise by revitalizing the unit’s business strategy. Recommended implementation of a revamped operational structure including an efficient resource utilization process using statistical analyses.
Profitability Analysis & Reporting: Selected sample data from 6-month transaction records by using Six Sigma/DMAIC principles. Ran statistical tests to identify and assess peak time patterns and customer wait-time trends throughout the week.
Functional Analyst, Jiingi Metal Industrial Co. 07/15/2015 - 07/17/2017
Drove operational efficiency for the jewellery accessories company by expediting project delivery and facilitating stakeholder communication across global companies and manufacturing locations. Led process mapping sessions for manufacturing sites in China and Philippines comprising of 300+ employees, translated functional design requirements into viable technical specifications for vendors, and presented key project analytics for customer and executive team interactions.
Unit Cost Preparation: Achieved 40% in cost-savings by identifying low-cost raw materials for product development. Invested in design samples that required low labor costs and automated processes as an alternate to manual resources.
Operational Analysis: Accelerated productivity by strategizing communication between diverse management levels within sales and technical design teams. Prioritized contracts, negotiated pricing, and interpreted demand to suggest design improvements.
Recruiting Performance Improvement: On-boarded 5 new hires by redefining the selection criteria to closely align candidate strengths with job requirements. Devised sustainable recruiting strategies by sourcing candidates with long-term growth goals.
Education
MS in Business Analytics, Arizona State University 2018
Courses: Enterprise Analytics, Accounting, Analytical Decision Modelling, Data-Driven Quality Management, and Marketing Analytics.
BA in Industrial Economics, Tamkang University 2015
Data Science Certifications & Online Courses: SAS Certified Programmer and Introduction to R.
Leadership Involvement
Activity Executive Officer, Economics Department Student Association (2015-2017): Led 8 direct reports to execute seamless operational workflow; planned and introduced 20+ new student program activities. Increased student membership by 50% within a year by effectively marketing program activities to new students and encouraging engagement.
Volunteer, Library of Society for a Happy Family Life (2012 – 2013)
Volunteer, Huashan Social Welfare Foundation (2011 – 2012)
Wei Shan Lee Resume Page 2 480-***-**** ******@***.*** Phoenix, AZ 85054 linkedin.com/in/wei-shan/