Junwei Yue Email & Phone Number

Salt Lake City, Ut, Us

United States

- Agile product owner of External Performance Reporting team, co-leading a team of analysts and focusing on reporting and payment model analytics that are delivered outside of Castell.

Salt Lake City, Utah, United States

- Providing analytical support to the development, implementation, and measurement of value-based care at system-wide level.- Writing SQL and harnessing multiple data sources from enterprise data warehouse (EDW) and population health management database to create, automate and maintain various Tableau dashboards that help leadership teams make informed decisions.- Evolving and executing data validation plans in close collaboration with data managers and data architects.- Leading Physician Performance Reporting project, which distributes performance and payment reports, as frequent as weekly, to over 1,000 clinics in 5 states.

Greater Pittsburgh Area

- Created and presented Tableau dashboards to analyze participant demographics, study status, and participant-study interactions from over 200,000 participants and 300 studies within the Pitt+Me research registry.- Performed QA on database. Identified and facilitated missing data sources by creating new database views. Built SQL queries to answer key questions from stakeholders, aiding in decision making and performance monitoring.- Developed text processing scripts that freed the clinic scheduling manager from repeated manual data prep.

Greater Pittsburgh Area

- Supported two large grant-funded projects targeting opioid use disorder among members. Conducted data analysis and reporting to meet grant deliverables and analyzed participant data to help answer evaluation questions.- Provided support to projects related to social determinants of health. Generated reports that identify neighborhoods with high socioeconomic disparities and where there were a large number of Medicaid members.- Applied statistical analysis to reveal programs and services that were frequently used together and to test relationships between member's health outcomes and treatment adherence.- Designed and implemented data visualization dashboard of key project process and outcome measures using Power BI.

Greater Pittsburgh Area

- Designed surveys using Qualtrics application to assist in nursing research projects.- Performed analysis on survey data and reported findings that may improve nursing training outcomes.

Newark, Ca

- Utilized Excel and Tableau reports to develop standard analytical tools. Optimized distribution routes between the main PDCs and various service centers across U.S., improved cost efficiency and reduced shipping duration.- Identified inefficiencies in fulfillment process. Supported ad-hoc data analysis requests. - Through data analysis, maintained and drove department and organizational goals and objectives. - Supported cross-functional teams on automation projects by creating customized Python scripts.- Collaborated with a team of four to investigate the root causes of shipping discrepancies.

University Park, Pa

- Performed three-way match on check and ACH payments.- Prepared annual cost spreadsheet for end of fiscal year audit for sponsors and agencies.- Prepared A/R aging report and obtain related documentation for senior review.- Updated and maintained the accounting contract information and instructions that serve as a basis for invoicing.- Gathered, compiled, indexed and scanned the expenditure files information for record retention purposes.

University Park, Pa

- Part of a fast food process team, coordinated food supply and preparation.- Assisted cooks with various duties, such as transporting raw materials, selecting ingredients, setting up kitchen tools, making food and cleaning kitchen.

Wuhan, Hubei, China

- Designed and planned for half-year and annual meeting for employee reward.- Interviewed top performing employees for the half year and annual meetings. The Interviews were recorded and played on internal meetings for training and rewarding purposes.- Helped reviewing employee benefit plans and collaborated with upper management to amend the commission and bonus criteria.

Wuhan, Hubei, China

- Pitched to potential clients the bank’s opportunities, such as high CD rates and currency transaction fees.- Created online accounts for customers to facilitate clients’ operations with the bank.- Assisted with corporate loan contracting process, performed accuracy check on contract content.- Consulted with current clients to identify optimal investments to maximize their returns.

Master'S Degree, Health Informatics

Bachelor’S Degree, Economics

Activities and Societies: Penn State Asset Management Group & Penn State Economics Association

General Education Study, Business/Commerce, General

Activities and Societies: Phi Beta Lambda, Epic Christian Church, TCTA Tennis Association