• Develop data collection, storage, and processing models, including sourcing, loading, transformation, and extraction using AWS internal tools such as S3, Redshift, Athena, SageMaker, etc.• Design data gathering, mapping, and processing pipeline and procedures using AWS data technologies and techniques with advanced SQL queries• Perform data analysis and statistical modeling with Python to provide deep-dive analysis into key business metrics and drive business decisions • Build machine learning model with open source packages to detect anomalous customer usage and recommendation system for customer outreach programs• Create business reports, dashboards, and machine learning models to automatically deliver business insight and provide real-time metric summaries to advise the product team to take customer-related actions• Collaborate and communicate with teams of data scientists, software development engineers, data engineers, and product managers to create innovative data solutions and data pipelines

• Developed SQL scripts to identify and query feature utilization of API Gateway, an AWS core service, processing over 3,000,000 rows of data from AWS Redshift cluster• Researched BI data pipeline and created documentation for 51 table schema and 32 API Gateway features• Constructed aggregated data tables using SQL for product managers to perform ad-hoc analysis and built QuickSight dashboard with interactive visualizations to display feature usage• Conducted statistical analysis and presented analytical findings to senior leadership groups

• Assisted the instructor to develop course content on introduction to Python and data science packages, statistical modeling, data visualization, and machine learning• Helped students with their Python and statistics questions during the lecture• Facilitated lab sections on Python coding and guided the students to work on their individual data science project

• Hold consultation session with student and faculties in-person or online to help solve their personal software question, such as Microsoft product suite, Adobe products, and other web applications• Design a unique solution for special software requests from faculty members, such as VBA programming• Assist instructors during the regular class sessions and help students with their software set up

• Evaluate and compare the performance of various package (including FIND, DESeq2) on processing Hi-C data under different resolution and cell line• Attend poster exhibition session for undergraduate research and present on the research project• Write the honor thesis on the research project and present to the review committee (in April, 2020)

• Develop new apps using R programming language for in-house Penn State online lecture and course materials for upper division statistical classes• Modify old shiny apps from previous semesters and debug the code with other team members • Create new game modules for interactive learning and class lectures• Conduct follow up surveys and write the research paper on the result of implementing Shiny app to classroom

• Built Power BI template for financial report with Power Query and drafted a step by step instruction guide for other users to set up the report. • Developed a time series data model to analyze underlying loss driver and forecast the future loss trend. • Coordinate with other 5 team members to deliver a presentation on the loss model for management level audience of 50+ attendees. • Assisted the FP&A team on creating closing period USGAAP financial report and organized large Pivot table data files daily. • Led the creation and consolidation of legal entity reporting presentation to local external auditors