Learn Data Skills
Beta
Chia-Wen Kao

Chia-Wen Kao

Business Analyst

Merck

Technologies

My Portfolio Highlights

My New Course

Data Manipulation in SQL

My New Course

Data-Driven Decision Making in SQL

My New Course

Intermediate Python

My New Course

Data Manipulation in SQL

Actively seek Project Manager opportunities. Experienced Senior Business Analyst and Highly Data-Driven Analytical and Enthusiastic

My Work

Take a look at my latest work.

course

Introduction to R

course

Introduction to Python

course

Intermediate Python

course

Introduction to R

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Google Academy Google Data Analytics

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Introduction to R

My Work Experience

Where I've interned and worked during my career.

Merck | Aug 2021 - Present

RPA Business Analyst

• Managed projects that saved the company $10 million in operating costs annually by automating a labor-intensive process, while reducing human effort by 20%. • Experienced project management with knowledge of interpersonal skills and the ability to provide strategic solutions for developing and maintaining automation processes. • Proficient in Agile methodologies and skilled in using JIRA for RPA development. • Expertise in managing cross-functional teams and diverse platforms/systems, optimizing project outcomes through risk management, data-driven decision- making, and timely delivery within budget and scope. • Strong ability to communicate with stakeholders, facilitate team collaboration, and deliver successful projects within scope and budget. • Fluent in translating clients' requests and troubleshooting issues and bugs during the RPA development process, using tools like MS Excel and diagrams to effectively manage issue resolution. • Experienced in documenting the Process Definition Document and cross- verifying test results with business requirements to ensure successful project outcomes, managing project timelines, budgets, and resources effectively. • Advanced in project management, including scheduling, delivering business values on time, prioritizing tasks based on priority, and taking initiatives to follow up on tasks, with the ability to communicate fluently in English, Mandarin, and Japanese.
Show More

Columbia University Mailman School of Public Health | Jan 2021 - May 2021

Graduate Teaching Assistant

As a course assistant, I facilitated discussion sections, provided course logistical support, and offered office hours while proactively identifying and reaching out to students who may need extra support to ensure course engagement and success.

Columbia University Mailman School of Public Health | Aug 2019 - Apr 2021

Student of Public Health in Epidemiology with Applied Biostatistics and Public Health Data Science

I have recently completed my Master's degree in Epidemiology with Applied Biostatistics and Public Health Data Science from Columbia University. During my study, I have developed understanding of causes, distribution, and prevention of disease and disability. I also gained knowledge, skills, and credentials required to engage in rigorous population health research. Key Accomplishments: • Enhanced expertise in both foundational concepts that underlie study design / analysis and innovative methods that change and improve practice of epidemiology. • Learned measuring, monitoring, and analyzing complex data in population sciences from genetics to precisions medicine and from brain science to clinical trials.

Taiwan Centers for Disease Control | Jun 2020 - Oct 2020

Data Analyst Intern

In this role, I utilized R, APIs, Shiny App, and Google Data Studio to visualize the daily increase in infected and death COVID-19 cases in Taiwan with interactive charts during the COVID-19 pandemic outbreak, enabling 50 personnel from different government departments can understand the spread. Key Contributions: • Participated in building a machine learning model aimed at predicting the outbreak of COVID-19. • Crafted perspective regarding machine learning application which monitored mask-wearing at Taoyuan International Airport and reached an accuracy rate of 90%.

The Robert N. Butler Columbia Aging Center (Remote) | Jun 2020 - Sep 2020

Summer Fellowship

• Analyzed changes in healthspan across sociodemographic groups with SAS by investigating US age trends from the 1970s to the present through Integrated Public Use Microdata Series. Successfully figured out 2 disability factors that led to the slow increase.

National Yang Ming University | Mar 2018 - Mar 2019

Research Assistant

• Recruited 400 subjects and mentored 5 research assistants for a designated case-control study in the third month after employment. Enhanced the attendance rate by 20% during the 3rd - 9th month of the study by following up with program participants every three months. • Analyzed 1200 entries over seven sites in Taiwan with MS Excel, MS Access, and SAS in the 3rd, 6th, and 9th months, data-visualized that subjects in the case group have higher cognitive function compared to the control arm.

Yueyue bookstore | Dec 2016 - Apr 2017

Art and Marketing Event Curator

My main duty in this role was to prepare the marketing events via the Facebook page, collaborate with artists by shelving their works or independent zines in the bookstore, and plan events that may match the monthly reading recommendation. Meanwhile, I was also attaining marketing success by setting a vending machine that brought stable income (around 300 USD monthly) for the bookstore. Key Contributions: • Succeeded in collaborating with Asian artists of different languages, such as Asian-American authors, Japanese musicians, Japanese and Korean zine artists.

Procter & Gamble | Sep 2015 - Nov 2016

Marketing Technical Assistant

My main duty in this role was to prepare the promotional marketing materials, label, regulatory review, and execute promotional marketing events for three brands in Taiwan which including Olay, Gillette, and Braun. Meanwhile, I was also attaining marketing tasks with a keen focus on ensuring seamless marketing operations. Key Contributions: • Delivered proactive assistance with logistics for marketing events and campaigns which led to 30% sales in the seasonal promotion of Gillette in Taiwan.

SHIN KONG WU HO-SU MEMORIAL HOSPITAL | Sep 2014 - Jan 2015

Intern

During my internship in the Department of Quality Management, I collected satisfaction data from the ICU for the Hospital Accreditation and Resilience of Staff in Shin Kong Hospital project. Besides, I assisted with confidential data entry by using Excel and Access and administered the survey to patients and family members in the high-pressured emergency rooms. At the end of my internship, I provided suggestions to elevate the response rate from survey collection in the emergency room during the Quality Management section meeting.

Taipei Medical University Hospital | Feb 2014 - Jun 2014

Intern

Committing to my internship as a Pharmacy Operation Assistant, I assisted medicine inventory and management with logistics and controlled drug knowledge. In addition, I conducted confidential data entry on patient medical records and assisted the distribution and allocation of Inpatients' medication in a high-volume environment.

My Education

Take a look at my formal education

Master of Public Health - MPH, EpidemiologyColumbia University Mailman School of Public Health | 2021
Bachelor of Science, Health AdministrationTaipei Medical University | 2015

About Me

Chia-Wen Kao

Actively looking for Project Manager opportunities. Experienced Senior Business Analyst with expertise in Robotics Process Automation (RPA) development and analysis within the pharmaceutical industry. Skilled in statistical analysis and management.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free