Junghyeon Ahn

Seoul, Mapogu | Korea

About Me

As a passionate and motivated junior data analyst, my goal as a junior data analyst is to apply my analytical skills and tool proficiency to support a company in making informed, driven decision-making that enhances sales.

I have spent the last 6 months honing my problem-solving skills using MECE and Agile methodologies. I have developed strong analytical abilities, including statistical hypothesis testing, exploratory data analysis (EDA), and funnel analysis. Proficiency in span tools such as MySQL, Google Big Query, Excel, Python, R, Tableau, and Power BI. I’m eager to contribute to boosting Sales and driven decision-making within a dynamic team.

Resume

Junghyeon_Ahn_Resume.pdf

179.5KB

Contact

ro033026@gmail.com

Education

May, 2024 - Aug, 2024

SeSAC Data analyst Bootcamp
SeSAC(Seoul software ACademy) / Offline 

•

Enhanced analysis and visualization skills through 5 projects (2 personal projects and 3 team projects) utilizing Excel, My SQL, Python and Tableau, focusing on diverse datasets and complex analyses.

•

Applied Agile and MECE methodologies across 5 projects, significantly improving team collaboration and problem-solving skills in completing 3 team projects within 5-6 days.

•

Contributed to the 2014-2015 US Used Car market analysis project by utilizing DML and DDL in MySQL to clean and organize the dataset, supporting comprehensive data analysis.

•

Utilized Pandas, Seaborn, Numpy, and Scipy in Python to assist a team project aimed at identifying fire risk factors in Korea, through public weather and fire data to uncover key correlations.

•

Studied independently and applied Calculated Fields, Actions, Parameters, and Filters in Tableau to develop the 2022-2023 US Car Sales dashboard and effectively presented it to Mentors and colleagues.

Mar, 2017 - Feb, 2023

Sungkyul University, Anyang, Korea
B.A. in Theological Seminary, Christian Education 
(GPA: 4.13 / 4.5)

•

Relevant Course work: Communication skills, Presentation skills, Logical thinking to solve problems (Rich experiences with various team and individual assignments) 

Work Experience

Dec, 2023 - Apr, 2024

Marketing and Administrative Coordinator 
at Selfmade Gym

•

Self-Made Gym is a fitness center that provides clients custom classes with a personalized nutrition plan.

•

Promoted the center through Instagram and Blog (naver) by uploading content for people interested in fitness.

•

Published 100 blog posts on Naver in 5 months, with 70% ranking in top search results, a key indicator of promotional success. Six out of seven total clients who, I provided consultations, were acquired through the blog content.

•

Utilized Microsoft Excel to create a Keyword tracker for blog post recording to ensure a 20% increase in blog visitors compared to before.

•

Utilized COUNTIF, VLOOKUP and aggregation functions to organize the data from the Keyword tracker.

•

Provided personalized fitness consultations to 7 clients based on their needs that I organized previous clients’ data.

Jan, 2022 - Jan. 2023

 Administrative Assistant   
at Mind Contact Counselling Center 

•

Mind Contact Counselling Center provides clients with structured services for improving individual’s mental and relationships with others.

•

Supported first-grade middle school student with borderline intelligence to improve their academic achievement by providing basic Korean grammar, Mathematics and English.

•

Asked a question to gain satisfaction and feedback after every counselling session to improve counselling methods. Especially applied feedback from middle school student to the counselling process step by step, resulting in noticeable improvements in his attention control and engagement during sessions.

•

Utilized Microsoft Word to document what I’ve done in every counselling.

Portfolio

Projects

2022- 2023 USA Car Sales Dashboard

Tableau

Excel

2014 & 2015 USA Used Car Market Analysis

SQL

Excel

Analysis of fire causes in Gyeonggi Province using firefighting data

Python

Certificates

Apr.2024

SQL(Basic) Certificate
Haker Rank / Online 

Mar, 2024

Daterian SQL(Basic) Course 
Daterian  / Online 

•

Studied about database, SQL commands and comprehensive knowledge about analysis methods (RFM, Funnel).

•

Enhanced SQL Skills by solving diverse problems from Hacker Rank and SolveSQL.

•

Improved SQL Skills such as JOIN and Subquery.

Apr, 2024

Google Data Analytics Certificates    
Cousera / Online 

•

Gained comprehensive knowledge in data analytics tools such as Excel, R, Big Query, R, and Tableau.

•

Cleaned and viewed the data by utilizing Excel, R, Big query, and visualized the results using Tableau and R

•

Developed problem-solve skills as well as logical thinking through an experience of cleaning the data and visualizing the results.

Aug, 2022

TEFL Certificate
Wisconsin ESL Institute / Online 

•

Learned how to teach people who speak English as a second language from other countries and taught local students from Wisconsin ESL institution.

•

Studied the culture of the students to build a stronger relationship.

•

Improved English proficiency through interactions with people from diverse backgrounds for 7 weeks.

•

Developed effective communication skills and presentation skills through a diverse interaction with students.

Apr, 2021

ZERTIFIKAT A2 
Goethe Institute / Offline 

Skills & Languages

Analysis & Visualization tools

Python

️️

SQL (My SQL & Big query)

️️️️

️️

Excel

️️️️

Tableau

️️️️

Power BI

️️️

Languages

English

️️️

German

️️

Korean

️️️️️

Extracurricular activities

갤러리 보기

Experiences

For four years, I was an active member of Ae-yang Ministry, a long-standing organization with over 40 years of history, dedicated to organizing retreats and recreational activities for children in underfunded churches.

Each summer, I participated in more than ten volunteer events at churches in the Gyeonggi area and on-campus activities, where I developed strong communication and teamwork skills to ensure smooth execution of recreational activities. During the winter, I contributed to strategizing for the recruitment of new members, fostering connections with senior members, and planning for the following summer’s volunteer work.

Although we encountered unexpected challenges due to a less-than-enthusiastic response to the planned activities, we quickly adapted by switching to a recreation program we had successfully executed during a previous retreat. By communicating effectively with my team members, we were able to seamlessly make this change, ultimately engaging the children and parents and creating unforgettable memories for them. Through this experience, I deepened my understanding of the true meaning of service while also developing my teamwork and leadership skills.

4 Years of Volunteering in a Children’s Ministry

From April 2, 2022, to April 2023, I underwent a year-long program in counseling techniques, spending the first six months studying counseling theories and the next six months assisting as a counselor at a counseling center. My role involved providing counseling to unemployed young adults, students with borderline intellectual disabilities, and high school students involved in bullying incidents. I also facilitated a program aimed at improving relationships for middle school students starting a new academic year.

This experience taught me that meaningful communication is possible, even with individuals from vastly different backgrounds and personalities, as long as it is grounded in empathy and understanding. It also gave me the confidence to engage in deeper, more meaningful conversations with a diverse range of people.

One-Year Internship Experience in Counseling

During my military service, I participated in the National Love Speech Contest. Although I wasn’t selected as the overall military representative, I was chosen to represent the Marine Corps.

I delivered a 10-minute speech in front of an audience of around 1,000 people, including the regimental commander, at the division's auditorium. For my efforts, I was awarded a special leave.

This experience taught me the importance of thoroughly understanding the topic, as well as the significance of eye contact, vocal tone, and emotion when communicating and persuading others. It also boosted my confidence in delivering clear and compelling communication in the future.

Presenting Before a Large Audience of 1,000 People

As a freshman, I participated in a university speech competition where teams presented on the theme of "Christmas" in English, Chinese, or Japanese. Despite being a Christian Education major among students proficient in languages like English and East Asian Logistics, I partnered with a senior from the English Language and Literature department, who was also in the same club, and together, we won first place.

Our topic was the "Christmas Truce" during World War I. I took the lead in researching the topic, writing the script, and creating the presentation slides. My senior provided valuable feedback on areas of the script that felt unnatural and helped correct my English pronunciation. For the week leading up to the competition, we practiced together in our club room for an hour each day, and when we couldn’t meet in person, we each practiced for two hours at home.

Thanks to our rigorous preparation, we were able to present confidently on the day of the competition, and out of the eight teams that presented in English, we won first place.

First Place in university-sponsored Speech Festival (English Category)