Experience

Camelot Illinois

• United States
• Manufacturing
• 1 - 100 Employee

• Data Analyst

  • Nov 2020 - Present

  Chicago, Illinois, United States



Paul Fredrick

• Apparel & Fashion
• 1 - 100 Employee

• Ecommerce/Web Analyst

  • Nov 2019 - Sep 2020

  Sparks Glencoe, Maryland • Applied multiple tools, such as Excel, Adobe, Google Analytics, SAS CI360 and SAS VA to thoroughly track customer journey, customer retention, e-commerce KPIs, trends, anomalies and opportunities • Created new web traffic rules, tagged and configured them to track information through URL Parameters, dataLayer, page elements, JavaScript API, or HTML into 11 main channels and 25 tables for future predictive analytics • Conduct analysis with Python and SAS, provided bestseller products… Show more • Applied multiple tools, such as Excel, Adobe, Google Analytics, SAS CI360 and SAS VA to thoroughly track customer journey, customer retention, e-commerce KPIs, trends, anomalies and opportunities • Created new web traffic rules, tagged and configured them to track information through URL Parameters, dataLayer, page elements, JavaScript API, or HTML into 11 main channels and 25 tables for future predictive analytics • Conduct analysis with Python and SAS, provided bestseller products, homepage clicks, channel path analysis, error pages, and other product reports to UX, Marketing and Merchandising teams to optimize web pages, define A/B test, modify promotion, cross-selling and campaign strategies, adjust products design and product recommendations • Built and evaluated hourly, daily, MTD, QTD, YTD KPIs performance reports on hourly, daily and ad hoc basis, delivered insights and actionable recommendations to Marketing team and increased sitewide sales by 10% • Generated real-time dashboards through Google Analytics, and built interactive hourly, daily, device, web traffic, etc. dashboards through SAS VA, Adobe Analytics, or Power BI to visualize performance and provide data-driven insights • Built Path Analysis dashboard to better understand customers’ visits, conversion, and shopping behaviors, while parsed URL to track product page clicks (color, size, etc.) and built intuitive Tree Map dashboard for UX team to target customers with diversified preferences (customer segmentation) and drive customer growth • Conducted data manipulation and auditing on 2019 and 2020 data, collaborated with IT department to find vertical and horizontal cleaning rules, and built high quality SQL database and marketing data warehouse for robust analysis Show less



Beverly Pediatric Dentistry

• Medical Practices
• 1 - 100 Employee

• Digital Marketing

  • Apr 2019 - Nov 2019

  • Launched two Google Ads Search Campaigns, analyzed data from Google Analytics and Google Ads, adjusted bids based on keywords level, locations, and ad scheduling in order to target different customers • Provided insights through the bi-weekly report, and increased impressions nearly 3 times and clicks nearly 2 times • Investigated and researched more than 30 CRM software, communicated with each CRM sales representatives, and finally determined the best three CRM for the office to use… Show more • Launched two Google Ads Search Campaigns, analyzed data from Google Analytics and Google Ads, adjusted bids based on keywords level, locations, and ad scheduling in order to target different customers • Provided insights through the bi-weekly report, and increased impressions nearly 3 times and clicks nearly 2 times • Investigated and researched more than 30 CRM software, communicated with each CRM sales representatives, and finally determined the best three CRM for the office to use through comparison and analysis Show less



GlobalDentalShop

• Customer Profile Data Collector & Data Analysts

  • Feb 2019 - Nov 2019

  Washington D.C. Metro Area • Collected data on Oral Surgeons in all 50 states, applied Tableau to visualize and analyze data, and provided marketing team with a feasible roadmap to expand their online customer base • Gathered and cleaned the customer survey data, conducted analysis with Python, Excel and Tableau, calculated Net Promoter Score, and found out what customers value most from user survey results • Launched Google Ads Search Campaigns, analyzed data from Google Analytics and Google Ads, adjusted bids… Show more • Collected data on Oral Surgeons in all 50 states, applied Tableau to visualize and analyze data, and provided marketing team with a feasible roadmap to expand their online customer base • Gathered and cleaned the customer survey data, conducted analysis with Python, Excel and Tableau, calculated Net Promoter Score, and found out what customers value most from user survey results • Launched Google Ads Search Campaigns, analyzed data from Google Analytics and Google Ads, adjusted bids based on keywords level, locations, and ad scheduling in order to target different customers Show less



Deloitte

• Business Consulting and Services
• 700 & Above Employee

• Business Analyst - London Tourism Analytics Project

  • Sep 2018 - Dec 2018

  Washington D.C. Metro Area • Created a prototype for The City of London’s Local Ministry and National Security Officials to sort out tourists who enter London will stay beyond the legally determined length of visits • Built 6 classification models in Python Sklearn to predict whether a new visitor will stay 15+ days in London with 9 prosperity indices being measured • Achieved 92% accuracy of prediction in the Logistic Regression Model and provided the interactive Tableau & Python dashboard as a visualization… Show more • Created a prototype for The City of London’s Local Ministry and National Security Officials to sort out tourists who enter London will stay beyond the legally determined length of visits • Built 6 classification models in Python Sklearn to predict whether a new visitor will stay 15+ days in London with 9 prosperity indices being measured • Achieved 92% accuracy of prediction in the Logistic Regression Model and provided the interactive Tableau & Python dashboard as a visualization platform for predictive capabilities in detecting London tourism pattern and security issue Show less



taiping life insurance co., LTD

• Insurance
• 100 - 200 Employee

• Data and Operation Analysts

  • Jul 2017 - Aug 2017

  Harbin, Heilongjiang, China • Examined current workplace area of 50 employees by analyzing employee actual attendance rate and performance to test whether company need to expand or shared space when hiring more outworkers • Initiated 2 rules to reach goal of reasonable resource matching, cost optimization, and long-term development needs



Industrial Bank Co., Ltd.

• China
• Banking
• 100 - 200 Employee

• Data & Customer Manager Assistant

  • May 2017 - Jun 2017

  Harbin, Heilongjiang, China • Studied data to identify top 5% target enterprise by learning overall situation of enterprise during pre-loan process • Facilitated product team of 10 to create loan package to potential enterprise in loan process after pre-loan inspection • Assessed risk of investment packages or individual loans in post-loan process weekly and conducted weekly report



Sana Zoan Coffee House

• Retail Customer Service Manager

  • Jul 2015 - Dec 2015

  Harbin, Heilongjiang, China • Revised and redesigned menu by proactively gathering guests’ feedback, increased sales by nearly 2% quarterly. • Developed surveys with the customer service team and interviewed customers, reduced complaints by 5% quarterly.



Taiping Pension Co., LTD

• Human Resource

  • Aug 2014 - Jun 2015

  Harbin, Heilongjiang, China • Established partnership over 50 employees and coordinated worker talents in right position (Labor Relations) • Reviewed personnel expense budget & processed relevant adjustments, attained 98% accuracy monthly (Salary) • Tracked 200+ employees’ attendance & performance, provided performance warning to bottom 10% (Performance)

• Business Associate Rotation Program

  • Jun 2013 - Aug 2013

  Harbin, Heilongjiang, China • Cooperated with all the teams and departments to schedule meetings, monitored projects process, and reduced mistakes. • Managed and developed biweekly reports for organizational supervisors and analyzed retail sales data; provided a monthly presentation to target departments and updated the business plans and goals, increased sales by 2% monthly.



Purdue University

• United States
• Higher Education
• 700 & Above Employee

• Teacher Assistant

  • Jan 2013 - May 2013

  West Lafayette, IN, US • Organized and managed study group sessions with a total of 150 students. • Collaborated with the professor weekly to successfully answer students’ questions and concerns.