Work Experience

Roche Diagnostics

Data Analysis Intern

May 2022 – August 2022

Indianapolis, IN

• Reduced data processing time by 4 hours by developing an online automation system which provides data standardization and interactive visualization dashboards using Streamlit in Python

• Built a standardized library by extracting customers’ historical data from company’s database for the automation system

• Coordinated and managed project development schedule for automation system by recognizing the customer’s needs

• Performed Quality Assurance and pilot tests to identify user feedback and potential errors that need to be fixed

• Organized training sessions for the Healthcare Consulting Group to instruct them on manipulating the system

• Saved 70% of data entry time by building an online daily management dashboard to track consultants’ performance Merck Sharp & Dohme (I.A.) LLC

Marketing Associate

August 2020 – February 2021

Taipei, Taiwan

• Launched a new marketing campaign of transforming traditional face-to-face visits to digital engagement, which increased the sales performance by 45%

• Constructed marketing strategies for the new product and produced promotional materials to assist our sales force

• Increased email open rate by 25% by conducting a persona analysis and delivering tailor-made messages to medical professionals

• Managed a group of individuals to accomplish creative themes aligned with products’ image and systematized 3 medical symposiums for medical professionals, enhancing our clients’ experiences

• Structured standardized operation processes of holding a symposium for the team to follow, attaining the satisfaction rate of 4.8 out of 5 in post-event analysis

Projects

MedSearch - Online Health Care Optimizer Python, Django, ArangoDB, JavaScript, HTML 2023

• Developed a comprehensive web application featuring medication library, user discomfort diary, and AI-powered chatbot

• Utilized FDA drug data sets, seamlessly integrated into our database, and leveraged Django object-relational mapping for efficient query and retrieval of data to power the medication search function

• Implemented a natural language model (Dalai) to enhance our Ask AI feature, enabling efficient processing of user input and generating accurate responses within the web application H1-B Visa Application Visualization and Prediction Dashboard Python, Streamlit, Altair, Scikit-Learn 2022

• Constructed an interactive visualization dashboard of H-1B visa applications that allow users to query applications based on job titles, wages, worksite locations, and majors

• Fine-tuned machine learning models to predict the probability of H1-B visa approval based on employer, worksite locations, job titles, wages, education level, majors, and country of citizenship; the accuracy of the best model is 88%

• Developed a prediction model to allow users input personal information to predict the probability of approval for H-1B visa Prediction models for housing rent and crime rate in the United States Python, Scikit-learn 2022

• Built a Random Forest Regression model for US Housing data to predict the rent based on house features and found out that location, square footage, and laundry options are the top important features

• Classified the level of the crime rate of counties with Random Forest based on demographic data to reduce crime rate

• Applied K-Means and PCA to cluster states into different safety level to find out where are safer states to live Education

Carnegie Mellon University

M.S. Healthcare Analytics and Information Technology — Highest Distinction May 2023

Pittsburgh, PA

Courses: Machine Learning, Data Mining, Big Data and Large-Scale Computing, Unstructured Data Analysis, Management Science, Computational Medicine, Health Economics, Web Application Development, Time Series Analysis, Health Information System National Taiwan University

B.S. Information Management and B.A. Economics

June 2020

Taipei, Taiwan

Courses: Statistics, Economics, Statistical Data Analysis, Big Data and Business Analysis, Operations Management, Database Management, Econometrics, System Analysis and Design, Data Structure and Algorithm, Project Management Technical Skills

Programming Languages: Python(Scikit-Learn, Gurobi, Seaborn, Altair, Django, Streamlit), Spark, SQL, JavaScript, R, Hadoop, HTML Development Tools: Visual Studio, Git, Google Colab, Spyder, Tableau, RStudio, Eclipse, AWS, Oracle SQL Developer Han-Ju (Kylie) Hsieh

5700 Centre Ave, Pittsburgh, PA 15206

412-***-****

ad2b8l@r.postjobfree.com

Contact this candidate