Jiangnan Song

Analytics Student Consultant at Carlson Analytics Lab
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Minneapolis, Minnesota, United States, US

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Intro to SQL for Data Science
    DataCamp
    Mar, 2018
    - Oct, 2024
  • Introduction to R
    DataCamp
    Mar, 2018
    - Oct, 2024
  • Programming for Everybody (Getting Started with Python)
    Coursera
    Oct, 2017
    - Oct, 2024
  • Python Data Structures
    Coursera
    Oct, 2017
    - Oct, 2024
  • Using Python to Access Web Data
    Coursera
    Oct, 2017
    - Oct, 2024

Experience

  • Carlson Analytics Lab
    • United States
    • Information Services
    • 1 - 100 Employee
    • Analytics Student Consultant
      • Jan 2019 - Present

      • Conducted Driver Analysis in R to measure each profit center’s contribution to total daily traffic to help the general manager make decisions about operation hours of each profit center and optimize staffing and operational supports • Created a regression-based metric to measure customer worth using Pyspark and helped the client optimize the hotel room allocation strategy using the new customer worth metric to avoid losing business from high worth customers • Built ETL pipeline to extract, clean, merge data, prepare aggregated results for dashboards using Python on 24.5M+ transaction data and helped client’s internal data engineering team deploy the ETL pipeline into their system • Built interactive dashboards and KPI scorecards of product performance and daily traffic prediction using DAX in Power BI to help decision makers including VPs and managers track daily/monthly KPIs and make timely decisions • Improved hotel room allocation system by building prediction models on 500K+ transaction data to forecast hotel yearly/biweekly/daily demands, reducing the prediction error rate by 61.5% Show less

    • Analytics Student Consultant
      • Jun 2018 - Aug 2018

      Client: Mall of America • Performed market basket analysis using association rules in R to increase overall sales and provide bundling and upselling strategies of best-selling products • Applied k-means clustering algorithm in R to identify best performing staffing group and designed employee training plan to optimize staffing efficiency and improve customer experience • Transformed and manipulated 1M+ transaction records and mall traffic data using R and Python • Presented the insights to client's executives and other stakeholders as finalist Show less

  • KPMG
    • Brazil
    • Construction
    • Audit Analyst
      • Oct 2015 - Jul 2017

      • Accomplished audit analytics projects for 8 top companies in energy, manufacturing and other industries in China and closely collaborated with audit teams and clients to continuously refine project demands and working deliverables • Conducted rule-based anomaly detection and defined a cost related metric to detect potential fraud in client’s procurement department, saving ~$160K for the client by preventing fraud • Collaborated with data science and engineering team to develop a fraud detection system that can automatically report anomalous activities to decision makers • Built ETL pipeline to automate data cleaning, merging and aggregating process to enhance data integrity/quality and improve work efficiency Show less

  • Citi
    • Mexico
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • Intern
      • Aug 2014 - Sep 2014

      • Conducted A/B testing on email campaigns and created 4 customer engagement metrics to measure the testing result • Prompted marketing promotion strategies based on the result of A/B testing, improved customer acquisition rate by 9% • Conducted A/B testing on email campaigns and created 4 customer engagement metrics to measure the testing result • Prompted marketing promotion strategies based on the result of A/B testing, improved customer acquisition rate by 9%

  • Three on the Bund
    • Hospitality
    • 1 - 100 Employee
    • Intern
      • Sep 2013 - Dec 2013

      • Tracked CRM KPIs across stores and regions on Salesforce and automated weekly/monthly sales, customer retention and business partner relationship reports using SQL and Excel spreadsheet • Performed Key Driver Analysis on customer feedback survey to identify key drivers of customer retention and presented marketing promotion insights to marketing director, improved customer satisfaction score by 0.2(1-5 scale) • Web-scraped customer reviews from TripAdvisor.com using Beautiful Soup and identified the main reasons for the decline in customer satisfaction and sales revenue from the analysis Show less

Education

  • University of Minnesota - Carlson School of Management
    MS Business Analytics, Analytics
    2018 - 2018
  • Shanghai University of Finance and Economics
    Bachelor of Business Administration (B.B.A.), Business Administration and Management, General
    2011 - 2015

Community

You need to have a working account to view this content. Click here to join now