About me
I am Kexi Chen, a master's student at the University of Pennsylvania, majoring in Statistics. I got a BS degree in Computer Science, with a minor in Mathematics at the Pennsylvania State University.
I'll graduate in December 2024.
Data Analyst & Programmer focusing on the healthcare and pharmaceutical industries, specializing in clinical data analysis, quality control, and visualization. Leveraging a strong foundation in Applied Statistics and Computer Science, I have hands-on experience with clinical trial data and database management.
Currently, a second-year graduate student at the University of Pennsylvania, completing a Master’s degree in Statistics, and available to start full-time work in January, with a diverse skill set that includes data management, statistical analysis, and experimental design. My technical proficiency spans SAS, Excel, Python, R, and Power BI, with a solid understanding of SQL for data processing and manipulation.
🖥 Domain
Clinical Research
Healthcare
Pharmaceutical
🖥 Programming Skills
Languages: SAS, Python, R
Frameworks/Tools: SQL, Excel
BI Tools: Power BI
My Skills
• SAS Certified Specialist: Base Programming Using SAS 9.4
• SAS, MySQL Workbench, Python, R, HTML, CSS, JavaScript, Java, API, GitHub, Pandas, Flask, Django, Excel, Amazon S3
Work Experience
Statistical Programmer Intern
Shanghai Pharmaceuticals
May 2024 - Aug 2024, Shanghai, China
Utilized SAS for statistical programming to process and analyze Clinical Trial Data.
Managed and organized datasets using SDTM (Study Data Tabulation Model) and ADaM (Analysis Data Model).
Developed and maintained code for generating Tables, Listings, Figures and other statistical outputs.
Conducted quality control by writing programs to compare results with the lead programmer's outputs. Collaborated with clinical teams to ensure data quality and accuracy for regulatory submissions.
Data Analyst Volunteer
Philly Community Wireless
Current
Assisted in the installation of community-based wireless networks by setting up mesh access points, running cables through buildings, mounting antennas on rooftops, and deploying air monitors. Implemented a feature enabling bulk uploads of WiFi hotspots to the Philadelphia public WiFi map. Also managed site maintenance and developed pages for partners and funders on the organization's website. The project aims to expand internet access in Philadelphia, focusing on Norris Square, Fairhill, and Kensington. https://phillycommunitywireless.org/
Software Engineering Intern
Syntronic
Jun 2022 - Aug 2022, Chengdu, China
Developing the Smart City traffic management application, encompassing frontend interactions and backend data processing.
Utilized Python for software development and data analysis.
Established an integrated environment using Software Stacks.
Enhanced system efficiency using Kubernetes for container operation automation.
Contributed to the HTML UI design for improved user accessibility.
Education
Bachelor of Engineering: Computer Science (Major), Mathematics (Minor)
May 2023
University Park, PA
Pennsylvania State University
Dean's List Fall 2019, Spring 2020, Fall 2020, Spring 2021
Master of Science: Statistic, Measurement, Assessment, Research, and Technology
Expected in Dec 2024
Philadelphia, PA
University of Pennsylvania
Research Assistant Volunteer
Research Assistant, Supervised by Prof. John M. Carroll
Center for Human-Computer Interaction, PSU
10/2021 – 12/2021
Conceptualized and created an interactive application aimed at enabling local researchers to input nearby Water Condition Data and visualize general and local water pollution conditions, contributing to environmental sustainability efforts.
Conducted a comprehensive literature review in the field of sustainable HCI, collaborating with professor and Ph.D. students to brainstorm innovative ideas and approaches for project's development.
Frontend Design: Designed an intuitive and user-friendly interface using HTML, ensuring the application was both visually appealing and functional.
Key Projects
Individual Projects, Supervised by Prof, Wang-Chien Lee
Database-backed Web Application to Buy/Sell Products on Campus
01/2022 – 05/2022
Developed NittanyMarket, a secure online platform enabling students, faculty, and staff to exchange surplus goods within the campus community, promoting sustainability.
Executed a comprehensive project lifecycle, including Requirement Analysis, Conceptual Database Design, Technology Survey, Logical Database Design, and Schema Normalization, employing technologies such as Flask Web Framework, Python, PyCharm, MySQL, and Pandas.
Seamlessly integrated the Web Interface with a robust Database, facilitating secure user logins, password management, personal information access, product catalog exploration, and item listing for buyers and sellers.
Individual Project
Visualize Data with Amazon Quicksight
9/2023 – 10/2023
Create Data Visualizations using Amazon S3 and Amazon Quicksight, working with a large dataset of best-selling Amazon products.
Individual Project,
Advanced Recipe Management
10/2023 - 11/2023
Utilized Python, Django, and Docker to create an API that features user authentication, recipe CRUD operations, image uploading, and complex querying.
Employed Test-Driven Development for reliable and robust code.
Configured GitHub Actions for continuous integration.
Managed a Postgres Database for efficient data handling.
Outcome: Successfully built a functional REST API that demonstrates my ability to construct complex Back-End systems, showcasing proficiency in modern development practices and tools.
Individual Project,
A Chatbot with the ChatGPT API in React
11/2023 – 12/2023
Gained in-depth understanding of the ChatGPT API and its implementation.
Mastered React, enhancing Front-End development skills.
Implemented efficient API request handling for real-time chat functionality.
Individual Project, Supervised by Prof. Al Verbanec
College Course Scheduling Application
11/2021 – 12/2021
Engineered a database-driven course scheduling application catering to both Admin Users and Student Users. Crafted and optimized a user-friendly GUI interface, designed and implemented the database structure, and established seamless connectivity between the database and web interface using Java.
Empowered Admin Users with SQL capabilities to manage the database, including student and course management, student search by ID, display of selected student courses, and real-time course vacancy updates.
Member, Supervised by Prof. Ishtiaque Hussain
Company Stock Information Webpage Design
01/2021 – 05/2021
Built an informative webpage featuring hyperlinks to present current stock situations and future trends for +20 stocks.
Implemented a Google search function to further enhance website usability.
Successfully completed the project using Python, HTML, Django framework, and JavaScript.
Tiger Woods