Ted Rhee
Los Angeles,CA
Summary
Highly motivated and detail-focused Data Analyst. Proven to understand customer requirements and translate into actionable project plans. Adaptable, fast learner, and hard-working with passion for Big Data Analytics. Picked up SQL on the job and it has seamlessly integrated into everyday skillset.
Overview
5
5
years of professional experience
1
1
Certificate
Work History
Data Analyst
Lakeshore Learning
04.2022 - Current
- Wrote complex SQL queries to extract and analyze data
- Utilized data visualization tools to effectively communicate business insights.
- Worked with business intelligence software and various reports to glean insights into trends and prospects.
- Coordinated statistical data analysis, design and information flow.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Currently helping with our data migration project and data engineer tasks
- Collaborated with team on ETL (Extract, Transform, Load) tasks using Matillion, maintaining data integrity and verifying pipeline stability
- Establish best practices for development of specialized data sets for analytics and modeling
- Own, build, and maintain scalable data pipelines that connect various cloud data sources
Data Analyst
ATIMS
10.2018 - 04.2022
- Worked with 3rd party data providers and internal data engineering team to extract and deliver data assets, perform data quality validation, and streamline and automate processes
- Executed and coded specific stored procedures in SQL to deliver and ensure inmates' data based upon form saves, medical history, military history, etc.
- Developed database objects, including tables, views and materialized views using SQL
- Participated and directed in requirements meetings and data mapping sessions to understand business needs
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Researched and resolved issues regarding integrity of data flow into databases.
Education
Bachelor of Science -
Western Governors University
Salt Lake City, UT06.2024
High School Diploma -
Crescenta Valley High School
La Crescenta, CA06.2014
Skills
- SQL
- Crystal Reports
- Data Analysis
- Quality Assurance
- Network Engineering
- Programming
- Data analysis
- Data validation
- Data Quality Assurance Processes
- Excel
- Power BI
- Data Extraction
- SQL Server Integration Services (SSIS)
- Matillion
- ETL/ELT
Certification
CCNA Routing & Switching
August 2018
UCLA Python course completed
June 2022
Timeline
Data Analyst
Lakeshore Learning
04.2022 - Current
Data Analyst
ATIMS
10.2018 - 04.2022
Bachelor of Science -
Western Governors University
High School Diploma -
Crescenta Valley High School
Currently studying Python & R
Taking courses online
Currently studying Python & R
Taking courses online
Similar Profiles
Jay DudleyJay Dudley
Vice President - Business Development at Lakeshore LearningVice President - Business Development at Lakeshore Learning
Jordan ChambersJordan Chambers
Sales Associate at Lakeshore LearningSales Associate at Lakeshore Learning
Alicia MendozaAlicia Mendoza
Production/Quality Control Technician at Lakeshore LearningProduction/Quality Control Technician at Lakeshore Learning
Natasha HamonNatasha Hamon
Retail Communications Manager at Lakeshore LearningRetail Communications Manager at Lakeshore Learning
Steve SobelSteve Sobel
VP OF CREATIVE DEVELOPMENT/Lead Copywriter at Critical Content/SK Global GroupVP OF CREATIVE DEVELOPMENT/Lead Copywriter at Critical Content/SK Global Group