JIWON LEE
4527 Student Ln, San Jose,CA
Summary
Detail-oriented data analyst with strong skills in SQL, Python, and data ETL. Experienced in automating processes and generating insightful reports using Power BI. Committed to enhancing data integrity and supporting business goals.
Overview
3
3
years of professional experience
Work History
Data Analyst Intern
Sallie Mae
Indianapolis, USA
05.2023 - Current
- Create or revise Power BI reports to support enterprise value delivery, IT governance, and other areas of the organization.
- Employed SQL queries, Python, and PowerShell scripts to perform data ETL, and analysis tasks.
- Conducted data collection, cleaning, and preprocessing to ensure accuracy and reliability of datasets.
- Automate manual processes using Power Automate and PowerShell scripts.
- Engaged with an external vendor on data integration projects.
Grader
Purdue University - Department of Statistics
West Lafayette, IN
08.2022 - 12.2023
- Grade assignments and quizzes, and give feedback to students in Statistical Methods for Biology.
- Communicate with the professor and other collaborators to revise and create the detailed rubric.
- Report the common mistakes for each assignment and quiz, based on the frequency and importance of the topic.
Data Engineer
Merck
West Lafayette, USA
08.2022 - 12.2022
- Collaborated with Merck on biometric data collection from the Garmin watches.
- Used the GarminConnect Python API wrapper and Python script to collect and clean the data.
- Designed the data flow and created the database to store the information using Azure Data Studio.
- Designed the UI used in the web application using Figma.
Education
Master of Science - Statistics And Computer Science
Purdue University
West Lafayette, IN05-2026
Bachelor of Science - Computer Science
Purdue University
West Lafayette, IN05.2024
Skills
- Agile
- Business Reporting
- C
- C
- Data analysis
- Data engineering
- Git
- Java
- Power BI
- PowerShell
- Python
- R
- SAS
- SQL
- Tableau
- Workflow Analysis
Timeline
Data Analyst Intern
Sallie Mae
05.2023 - Current
Grader
Purdue University - Department of Statistics
08.2022 - 12.2023
Data Engineer
Merck
08.2022 - 12.2022
Master of Science - Statistics And Computer Science
Purdue University
Bachelor of Science - Computer Science
Purdue University
Similar Profiles
Patricia HanifeePatricia Hanifee
Sr Manager Vendor Management at Sallie MaeSr Manager Vendor Management at Sallie Mae
Nakia UnderdueNakia Underdue
Collection Agent at Sallie MaeCollection Agent at Sallie Mae
SHAILENDRA K GUDEPATESHAILENDRA K GUDEPATE
Director - Cloud Operations at Sallie Mae CorporationDirector - Cloud Operations at Sallie Mae Corporation
Jacquline LindsayJacquline Lindsay
Collections Agent at Sallie Mae Student Loan ServicesCollections Agent at Sallie Mae Student Loan Services
Ajith KattilAjith Kattil
Engineering Leader at Neural LabsEngineering Leader at Neural Labs