About me

Hey there! 😃

I'm Kaiyue, a Business and Data Analyst passionate about turning data into actionable strategies. With a sharp eye for patterns and a knack for problem-solving, I empower business to thrive in the digital age.

My job is to transform raw data into clear, concise reports, providing valuable insights that drive informed decisions by leverging cutting-edge tools and techniques. From generating quantitative analysis and optimizing operations to identifying growth opportunities, my analytical acumen is complemented by a deep understanding of business dynamics, making me a valuable assets in any data-driven endeavor.

I had experiences in many top-brand companies and worked on various projects especailly in finance. Let's connect and explore the possibilities together.

What i'm doing

  • design icon

    Data Analysis

    Analyze data and manage the database at a professional level.

  • Web development icon

    Model Development

    High-quality development of quantative and big data models to improve efficiency.

  • bi icon

    Business Intelligence

    Provide business insights dashboards and reports for strategical decision-makings.

  • management icon

    Management

    Care about the whole business process and connect with people from different sides.

Testimonials

  • Ethan Schur

    Ethan Schur

    Kaiyue was hired to place the data analysis, model development and business intelligence for our specific projects. As a partner of GTSP, I was very pleased with the work done; she has a lot of experience and is very concerned about the needs of our project's ultimate goal. As her supervisor, I was delighted for her improvement during her daily works and practices.

  • Jason Spence

    Jason Spence

    I am Karen's mentor during her time at GTSP SVG project. I do say having Karen as a data analyst intern has been a genuine pleasure. Throughout her internship, she consistently showcased exceptional analytical prowess, a keen eye for detail, and a passion for deriving valuable insghts from complex datasets. Also, Karen has a remarkable ability to tackle challenging problems with creativity and precision, contributing significantly to our team's success.
    I shared my career experience and tips to her, and I do believe this position will be a good start for her to get her path as a professional data analyst. Karen's quick learning and dedication will make her a valuable asset to any data-driven organization.

  • Jennifer Liu

    Jennifer Liu

    I am the Director of the Wisconsin branch of TransAmerica Financial Group, and I have had the pleasure of working with Kaiyue since September 2022.
    Kaiyue's role as a Financial & Data Analysis Assistant is a multi-faceted and dynamic role, as no two days are the same. Notwithstanding, having worked with Kaiyue under my direct supervision, I can attest to her sharpness, acuity and dedication to her professional undertakings. She has excellent pedigree across project management and account management with an extensive knowledge in finance and business, and I am impressived that she can fit these parts with data analysis perfectly to dig more insights for our group.
    Furthermore, I appreciate that she can always tried to understand and think from other people's pespectives, not only for clients but also for our teams.

  • Louise Zhang

    Louise Zhang

    I am the Head of Transaction Banking at BNP Paribas in China, and it is with great pleasure that we can have Kaiyue (Karen) worked in our team as an outstanding Business Project Analyst Intern in the last 6 months.
    Karen has consistently impressed us with her dedication, professionalism, and exceptional analytical skills during her internship with us. Throughout her tenure, Karen demonstrated a remarkable ability to grasp complex concepts quickly and apply them to our daily cases and operations. Her attention to detail and critical thinking were invaluable in identifying key insights and providing well-thought-out solutions to various challenges.
    Our clients give very good feedbacks on their connections with Karen regarding her support provided for BADD and BADI transactions, and our team also impressed with her works on developing our pipeline. Karen will continue her graduated studies, and we believe she will be a valuable member of any future team.

Companies

Resume

Education

  1. Rensselaer Polytechnic Institute

    08/2021 — 01/2023

    Master of Science in Business Analytics.

  2. Xi'an Jiaotong-Liverpool University

    09/2016 — 06/2020

    Bachelor of Business Management in Accounting.
    Elected as Leader of University Math Club, Student Representative of Academic Development Forum.
    Achieved Outstanding Student (top 5%) (05/2017), and Excellent Student Cadre (top 1%) (05/2019).

  3. University of Liverpool

    09/2016 — 07/2020

    Bachelor of Arts with Honors in Accounting.

Experience

  1. GTSP Lab - Data Analyst

    03/2023 — Present

    • Developed and implemented code changes to establish and improve models for analyzing data according to specific project requirements. Utilized Git for version control and collaborated with team members using Agile methodologies.
    • Applied machine learning algorithms, exploratory data analysis, and statistical techniques to develop predictive models.
    • Implemented data warehousing solutions using Snowflake and optimized automatic data processing workflows for high performance, assisting in managing clients' targeted price database with the use of GCP, WSL, Docker, and Python.
    • Leveraged data visualization tools such as Tableau and Power BI to generate insights and dashboards, presenting complex data sets in a user-friendly and accessible format to support effective decision-making.

  2. Transamerica Financial Advisor, Inc. - Financial Data Analysis Assistant

    2013 — 2015

    • Analyzed data for over 5 individual clients to calculate the annual return on cash value insurance investments based on various indexes such as S&P 500, and summarized average return rates with different strategies and projected future 20-year income through Nationwide. Provided valuable insights and specific suggestions to supervisors for business operations.
    • Engaged in marketing research, business development strategy research, and client relationship management.
    • Managed the social media platform, and utilized SQL to interpret the data including location, gender, etc.
    • Suggested 2 marketing strategies to supervisors for brand promotion and growth.

  3. BNP Paribas - Business Project Analyst Intern

    10/2020 — 04/2021

    • Interacted with clients to oversee and support the process of trade financing transactions among the client enterprises, suppliers, and banks, achieving 98% customer satisfaction and the 2020 BAD Issuance and Discounting target with the team ahead of schedule.
    • Calculated the daily available trading amount and quoted rates, collaborating with the Risk Control and Background Processing teams.
    • Established a visual diagnostic model to offer a weekly pipeline review of all ongoing negotiations with customers and trades in progress, and used it to develop an analysis report with the APAC GB team to support the bi-weekly top management meeting in Greater China. Resulted in saving at least 20% of reviewing time within the team.

  4. Deloitte - Tax Consulting & Business System Spring Analyst

    02/2019 — 03/2019

    • Performed analysis and structured tax-related statements for senior managers, including data analysis based on datasets from tax administration and the corporate tax letter. Assessed the impact of new regulations announced in China on clients.
    • Generated tax issues from clients regarding special expense deductions for personal income tax using the Deloitte Tax Intelligent Platform. Furnished specific proposals, reducing complaint cases by 48%.

Projects

  1. Valen Studio - Business Analysis Capstone

    02/2022 — 05/2022

    • Applied the exploratory data analysis following the CRISP-DM model to identify the target customer and most influenced factors from Nov. to Dec. 2021.
    • Forecasted the satisfaction and retention rate of Knockout City players. Ran baseline models using Python to analyze the coefficients among various features, and created proposals for 3 subgroups to predict the impacts on different players. Produced an analysis report and proposals for Valen to complete its 2021 annual game insights.

  2. CIMA Global Business Challenge

    03/2019 — 05/2019

    • Developed a marketing plan including the market position analysis, financial analysis, and competitor analysis for a newly-launched brand, GymFit, considering its main competitor, Super Monkey. Helped improve its operations in China by projecting a 4-year start-up proposal and implementing a targeted strategy for young elites. Guaranteed a sustained operation with a projected 7.3% annual profit growth.
    • Led a 3-person team and competed against over 250 competitors in the CIMA Program. Won the prize in Suzhou, China.

My skills

  • Microsoft Office (Word/PowerPoint/Excel)
    98%
  • Coding Languages (Python/SQL)
    90%
  • Git
    80%
  • SAS
    50%
  • Cloud Technologies (Google Cloud Platform/AWS)
    55%
  • Big Data Technologies (PySpark/Spark SQL)
    30%
  • BI and Reporting (Tableau/ Power BI)
    95%
  • Machine Learning (Random Forest/Logistic Regression/RNN/PyTorch)
    65%
  • Financial Reporting & Management
    85%

Portfolio

Blog

Contact

Contact Form