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
******@******.***.***