Jingfan(Summer) Qu

Experience

• 

  Hengai Technology

  Mar 2021 - Sept 2021

  Data Analyst

  - Collaborated closely with department manager to pinpoint business challenges and adhering to financial requirements on advertisement with existing product; and translated strategic proposals to digital solutions in an analytic framework- Executed data integration and transformation to extract 2.5k+ historical operational data from external resources and load to target database for performance of advertisement company performance on advertisement market analysis- Conducted quantitative analysis on advertisement markets with existing 8 key metrics of advertising channels to analyze over 800 channels of advertisement placement data through Python to deliver cost suggestion and business strategy- Delivered technical and analytic reports and reflect 6 key metrics (search volume, unique visitors, ad types etc.) through interactive Tableau Dashboards to support business decisions on 150,000 RMB advertisement spending Show less

• 

  University of Southern California

  Aug 2022 - Dec 2022

  Product Development Project

  - Partnered with supervisor to identify challenges and existing life problems of Afghan women in the daily life, building analytic framework to support business development and product design to provide help to Afghan women- Cleaned, transformed, and loaded 6.3k+ data into target database for data manipulation and analytic purpose using SQL and Excel- Developed K-Means models to analyze the relationship information between different metrics and Afghan women happiness level, developing feature engineering to get 7 key important and significant metrics causing pain within their lives- Engaged in app design, defining 5 critical app features based on the data-driven pain points and built prototypes with a four-member team of product managers and software developers using Figma, increasing user satisfaction by 40%- Compiled and articulated periodic progress reports to product managers and supervisors, reflecting data insights and analytics information through data visualization dashboard by using Tableau Show less

• 

  Siemens

  May 2023 - Sept 2023

  Data Analyst

  - Performed the fit-gap analysis on 10+ existing products to evaluate performance and market demand; project guided the analysis roadmap in digital pipeline- Implemented the data migration pipeline utilizing RestAPI, combining 5.1k data requested from financial systems including Bloomberg and Yahoo to conduct competitive analyses of market trend and business insights, informing organizational strategy- Developed linear regression model to forecast products performance and track consumer behavior, helping leadership teams to understand market positioning, enhancing product loyalty, and expanding consumer base by 20%- Collaboratively performed ad-hoc analysis and analyzed financial key metrics over 5 years in energy industry; developed and designed 7 macroeconomic Tableau dashboards to reflect the financial information and insights to support go-to-market decision- Prepared analytic reports to summarize and share insights on boosting market share by 10% over next five years, gain deep knowledge of markets and consumer segments to maximize product targeting Show less

• 

  Moo Housing

  Apr 2024 - Jun 2024

  Leasing Specialist

  - Promptly address inquiries from potential tenants via phone, email, and in-person visits. Utilize a Customer Relationship Management (CRM) system to log interaction data, optimizing customer service processes and response strategies.- Guide prospective tenants through available properties, collecting feedback data to analyze tour effectiveness and tenant preferences, thereby improving future property presentation strategies.- Manage the move-in and move-out processes, conducting property inspections, and digitally collecting security deposits and rental payments to ensure data accuracy and traceability.- Address concerns or issues from current and future tenants in a timely and professional manner. Apply data analytics to monitor customer satisfaction and service quality, making timely adjustments to service strategies.- Keep accurate records of rental applications, leasing agreements, and tenant communications. Use database management tools to analyze leasing data, providing operational insights and recommendations for process and strategy optimization. Show less

• 

  BonCamel Inc.

  Jul 2024 - Nov 2024

  Business Analyst
• 

  Yowant

  Nov 2024 - now

  Business Analyst