Sangjun Yoon

Sangjun Yoon Email and Phone Number

Business Analyst @ LKQ Corporation FP&A @ LKQ Corporation
Sangjun Yoon's Location
Nashville Metropolitan Area, United States, United States
Sangjun Yoon's Contact Details

Sangjun Yoon personal email

n/a
About Sangjun Yoon

As a Reporting & Automation Analyst at LKQ Corporation, I apply my analytical skills and data expertise to create queries, reports, and dashboards that support management decisions and business processes. I have reduced the reporting time by up to 30% by using advanced Excel features such as VBA, Macro, Power Pivot, and Power Query, as well as Cognos and SQL.I hold a Master of Science in Business Analytics from Bentley University, where I learned how to use Python, Tableau, and Seaborn to perform descriptive, inferential, and predictive data analysis. I also have a background in Economics and a certificate in Business Analytics from Harvard Business School Online. I am motivated by finding insights and solutions from data, and I value collaboration, responsibility, and positive influence.

Sangjun Yoon's Current Company Details
LKQ Corporation

Lkq Corporation

View
Business Analyst @ LKQ Corporation FP&A
Sangjun Yoon Work Experience Details
  • Lkq Corporation
    Business Analyst
    Lkq Corporation Dec 2023 - Present
    Chicago, Illinois, Us
  • Lkq Corporation
    Reporting & Automation Analyst
    Lkq Corporation Aug 2022 - Dec 2023
    Chicago, Illinois, Us
  • Lkq Corporation
    Ar Business Analyst
    Lkq Corporation Jan 2022 - Aug 2022
    Chicago, Illinois, Us
    • Think analytically to create queries for multiple datasets to execute projects that reduced the business reporting process by 20% ~ 30% using Cognos, and Advanced Excel skills like VBA, Macro, Power Pivot, and Power Query.• Prepared descriptive, inferential, and predictive data analytics and analysis reports to support management decisions• Developed, maintained, performed, automated, audited, analyzed, and managed daily, weekly, and monthly reporting solutions• Formulate and convey actionable business proposals based on information from various data sources• Worked and communicated with various teams to understand the business needs and requirements for business processes and report improvements
  • Wirebarley
    Marketing Data Analyst
    Wirebarley Jul 2021 - Sep 2021
    Seoul, Seoul, Kr
    • Perform data analysis on three large datasets (approx. 30,000+ rows & 20+ columns) using SQL and Tableau to develop and refine marketing strategy• Create calculated fields in Tableau as needed in the process of the analysis, such as ad hoc analysis• Work with co-workers in the Marketing Team, by listening to what the Marketing Team needs and wants to know about the customers
  • Digital Factory, Inc.
    Business Analyst
    Digital Factory, Inc. Feb 2021 - Apr 2021
    Chicago, Il, Us
    • Create detailed business analyses report outlining problems, identifying opportunities, and proposing solutions to achieve organizational goals• Analyze organizational data and processes to find the principle, mechanism, and reasons for the explanation of the steps and format• Work with a wide range of teams, including upper management like Senior Management and the Operations team
  • Bentley University - Mccallum Graduate School Of Business
    Research Assistant
    Bentley University - Mccallum Graduate School Of Business Jan 2021 - Apr 2021
    Waltham, Ma, Us
    • Utilize NLP method to extract words from doctor’s notes on Alzheimer patients and executed Lemmatization and Fuzzy Matching to group by and reduce to produce concise word bank data• Create visual representations and website using R (ggplot2) shiny package and interact with Python programming language using the reticulate library• Using Python (NumPy, Pandas, Matplotlib) to create multiple functions for data processing automation, produce graphs and extract meaningful findings
  • Bentley University
    Classroom Presentation Assistant Graduate
    Bentley University Jan 2020 - Dec 2020
    Waltham, Massachusetts, Us
    • Provide guidance and support to the professors with the classroom technologies such as Smart Screen, Zoom, and Microsoft Office• Support online students in Zoom with the technical problems by notifying the Campus Presentation Technologies of the issue• Manifest effective communication between the online students and the professors by checking sounds and microphones
  • Fullerton College
    Student Assistant
    Fullerton College Apr 2018 - May 2019
    Fullerton, Ca, Us
    • Conducted administrative support with a team of four co-workers with all front desk duties such as: phone calls, e-mails, and documentations• Suggested Pumpkin Patch activity for ISC’s events to better provide international students’ US cultural experiences• Organized and filed confidential student documentation to expedite PDSO and DSO’s admission process and to mitigate counselors’ functions
  • James Worldwide, Inc.
    Import & Export Operation
    James Worldwide, Inc. Mar 2017 - May 2017
    • Developed and designed entire customized freight logistics services for each client from port to port• Administered freight orders through customs and domestic transportations on truck or train via e-mails, and phone calls• Communicated with various partners and vendors to efficiently perform freight logistics by reserving trucks ahead of time to transfer the cargo

Sangjun Yoon Skills

Pandas Powerpoint R Ibm Cognos Analytics Powerpivot Cognos Korean R (Programming Language Data Analysis Load Business Analysis Data Mining Tableau Pivot Tables Statistical Data Analysis Microsoft Office Microsoft Word Excel Pivot Microsoft Excel Seaborn Visual Basic For Applications Numpy Extract Sql Python Machine Learning Analytics Transform Data Visualization Django Mysql Databases

Sangjun Yoon Education Details

  • Bentley University - Mccallum Graduate School Of Business
    Bentley University - Mccallum Graduate School Of Business
    Business Analytics
  • Fullerton College
    Fullerton College
    Business Management
  • University Of Minnesota
    University Of Minnesota
    Economics
  • Harvard Business School Online
    Harvard Business School Online
    Other; Certificate In Business Analytics

Frequently Asked Questions about Sangjun Yoon

What company does Sangjun Yoon work for?

Sangjun Yoon works for Lkq Corporation

What is Sangjun Yoon's role at the current company?

Sangjun Yoon's current role is Business Analyst @ LKQ Corporation FP&A.

What is Sangjun Yoon's email address?

Sangjun Yoon's email address is sy****@****ley.edu

What schools did Sangjun Yoon attend?

Sangjun Yoon attended Bentley University - Mccallum Graduate School Of Business, Fullerton College, University Of Minnesota, Harvard Business School Online.

What skills is Sangjun Yoon known for?

Sangjun Yoon has skills like Pandas, Powerpoint, R, Ibm Cognos Analytics, Powerpivot, Cognos, Korean, R (Programming Language, Data Analysis, Load, Business Analysis, Data Mining.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.