Alice Kim

Marietta, GA *****

650-***-****

ad39nh@r.postjobfree.com

Skills

● SQL, Python, Pandas, Numpy, Pyspark, R, Streamlit, Scikit-learn, PyTorch

● Tableau, Power BI

● AWS S3, Sagemaker, Athena, Redshift, Informatica, Thirsty, Matrix, Salesforce, SAP, Jira

● Machine Learning & AI: Classification, Regression, Clustering, Time Series, Decision Tree, Random Forests, XGBoost, CNN, RNN

Experience

Cox Communication, Atlanta- Data Scientist

October 2022 - PRESENT

● Leveraged advanced analytical and statistical techniques, including machine learning methodologies using Python, to reveal key data patterns, significantly enhancing ticket handling and time management processes.

● Utilized statistical tests, correlation analysis, and feature selection techniques in machine learning to identify statistically significant features and explore correlations between them, enabling descriptive analysis that revealed insightful narratives within diverse datasets.

● Developed a predictive machine learning model to forecast resource demand for the optimal hiring of technicians.

● Managed ETL pipeline maintenance, including troubleshooting and resolving critical issues, using a multi-faceted approach that delivers immediate, temporary, and permanent solutions for comprehensive problem management.

● Developed and deployed comprehensive Tableau and Power BI dashboards, carefully designed to display key performance indicators (KPIs) and conduct detailed statistical analysis using LOD (Level of Details) and DAX (Data Analysis Expressions)

● Developed a multi-classification and binary image classification model utilizing one of the CNN

(Convolutional Neural Network) pre-trained models, EfficientNet, in both PyTorch and TensorFlow frameworks for my final semester practicum project under the approval of the leadership Cox Communication, Atlanta- Data Analytics Engineer March 2022 - October 2022

● Led a data validation project, building and deploying dashboards that effectively identified and addressed root causes of data quality issues in the workflow.

● Improved the data quality of the Jira ETL pipeline by identifying and resolving issues within the ETL process in the VM, ensuring optimal performance and reliability

● Designed and created a comprehensive data flow diagram for the ETL process with multiple databases, effectively enabling knowledge transfer by conducting training sessions for new team members and collaborating teams to ensure a thorough understanding of the entire process

● Deployed the new developments on the ETL to Dev, QA, and Prod environments to maintain the data integrity modified

● Developed complex SQL queries, aligning with business criteria for efficiency and conciseness, and employed aggregation techniques to effectively reduce data volume, resulting in minimization of data source extraction time

● Managed existing Tableau dashboard by updating attributes, adding new features, and fixing any errors The Coca-Cola Company, Atlanta- Data Analyst

July 2019 - March 2022

● Skilled at data cleaning, mapping, and profiling to improve data integrity and reduce data redundancy in RDBMS by 80%

● Created an automation and Visualized reports based on analyzed data in the Power BI

● Wrote SQL and Python scripts to perform multiple steps automatically according to general criteria 2

● Created SQL queries to identify data that are out of sync between tables and resolved data defects

● Established data string cleansing automation and created validation automation by creating Python functions

● Validated data between the multiple systems, generated standard work process reports, and created analytic reports by utilizing Tableau or Power BI

● Used Informatica, SAP, Thirsty, Salesforce, and Matrix to access databases, identified and resolved linkage issues, and restructured data models

RAPP, San Francisco- Data Analyst

April 2019 - July 2019

● Participated in the Wells Fargo Community Impact Project, which involved big data extraction and management

● Generated data cleansing with a 100% project report completion rate

● Collected and analyzed web content data from potential clients and consumers, and generated complex reports

● Analyzed big data to identify potential issues and errors, and support the redesign and restructure of data models

● Utilized MySQL and advanced Microsoft Excel for data consolidation and collection purposes, and coordinated with the team to generate complex reports Walmart Global eCommerce, San Bruno- Senior Data Specialist Dec 2018 - March 2019

● Managed returned product data and other related online information

● Utilized internal application to access database to retrieve and update warehouse data

● Updated product information from different vendors and locations.

● Supported the resolution of issues or errors that occurred through recent data updates or modifications Apple, Cupertino- Data Specialist

Oct 2018 - Nov 2018

● Worked with the team manager to generate reports on various device test results

● Performed data collection, identified errors, and analyzed data results

● Inspected and recorded incoming data for completeness, code accuracy, and other potential processing problems

Education

May 2018 Graduated,

San Francisco State University, San Francisco- Bachelor of Arts: Mathematics for Liberal Arts December 2023 Graduated,

Georgia Institute of Technology, Atlanta - Master of Science in Analytics

Contact this candidate