Michael Wei Email & Phone Number

• 3 years of experience in the role of E-commerce Analyst with proficiency in digital marketing optimization, pre/post campaign analysis, A/B testing, customer segmentation and profiling• 5+ years of experience of using Excel advanced formulas and functions (such as Vlookup, Hlookup, Index-Match, Offset, Pivot Table, Data Analysis Tools, VBA Macro, etc.) to manipulate and analyze data• 3 years of work experience in digital analytics tools such as Adobe Analytics and Google Analytics• Certified Advanced SAS Programmer with hand-on programming experience in data cleansing, statistical analysis (t-test, ANOVA, correlation, regression), predictive modeling, and forecasting• Knowledge of relational database and analytical tools such as SAS, SQL, MS Access, as well as the experience of extracting data from enterprise data warehouse using third-party data platform• Proficiency with Microsoft Office Applications (Word, Excel, PowerPoint, Access, Outlook)• Attention to details; proven analytical and problem-solving skills with the ability to analyze business problems and interpret large amounts of information into actionable insights• Quick learner and self-starter; the ability to work independently and as a part of a team• Excellent interpersonal and communication skills; strong time management skills with the ability to prioritize multiple tasks and meet deadlines

• 

  E-Commerce Analyst

  Grand & Toy

  Mar 2015 - Present

  • Retrieved data from enterprise data warehouse and merged data across tables using Excel and Access• Generated weekly and monthly reports using Excel formulas, Pivot Table, and Adobe Analytics• Built queries in Excel files with Adobe Report Builder to create reports and refresh the contents periodically • Used Adobe Analytics to create segments, track e-commerce metrics, and generate reports and dashboards• Identified and validated Adobe Analytics variables with the use of… Show more • Retrieved data from enterprise data warehouse and merged data across tables using Excel and Access• Generated weekly and monthly reports using Excel formulas, Pivot Table, and Adobe Analytics• Built queries in Excel files with Adobe Report Builder to create reports and refresh the contents periodically • Used Adobe Analytics to create segments, track e-commerce metrics, and generate reports and dashboards• Identified and validated Adobe Analytics variables with the use of Adobe Debugger• Worked closely with campaign managers to identify campaign objectives and KPIs (Revenue, Gross Profit, AOV, ROI, CTR, Visits, Unique Visitors, Conversion Rate, etc.) • Conducted Pre-campaign Analysis to serve the purpose of customer segmentation and target list generation• Generated email/contact lists from database, cleansed the lists, and prepared them for email/DM deployment• Used Adobe Analytics and Google Analytics to track e-commerce traffic and conversion for each campaign• Created Post-campaign Analysis Report for each campaign to assess campaign performance, analyze campaign participants and promo products, and interpreted the data into actionable insights• Visualized the analysis results with graphs and charts in PowerPoint, presented the findings to the stakeholders, and provided recommendations• Automated report generation process using advanced Excel formulas and VBA macros to improve efficiency Show less