Yiwen M. Email & Phone Number

San Diego, Ca, Us

• Acted as a IT business analyst to support Clinic Mobile App development. Conducted patient healthcare data management, integrated, transformed and extracted data using MySQL and AWS RDS. Performed meetings with technical team for software development and debugging. Translated business requirements into technical design specifications, streamlined new internal business procedures, and helped the clinic transition to new APP platform.• Utilized EMR system to manage patient records and… Show more • Acted as a IT business analyst to support Clinic Mobile App development. Conducted patient healthcare data management, integrated, transformed and extracted data using MySQL and AWS RDS. Performed meetings with technical team for software development and debugging. Translated business requirements into technical design specifications, streamlined new internal business procedures, and helped the clinic transition to new APP platform.• Utilized EMR system to manage patient records and ensure data are up-to-date. Coordinated with Clinic, Legal, and Finance team to accomplish patient care/treatment. Utilized Trello and Zoho CRM on patient cases and customer relationship management. Analyzed, interpreted, and identified trends of patient data to support marketing decision. Show less

San Diego, California, United States

• Worked in Cloud R&D Engineering team, leveraged PostgreSQL, Cosmos DB (NoSQL) and MS Azure Cloud tools, including PowerShell, Blob Storage, Data Lake, and Data Lifecycle Management, etc., to perform database analysis, database management, and data governance, build and update data dictionary & data modeling.• Supported, diagnosed and resolved production issues. Continuously monitored database & Airflow performance, maintained existing data pipelines and tuned SQL queries.• Worked… Show more • Worked in Cloud R&D Engineering team, leveraged PostgreSQL, Cosmos DB (NoSQL) and MS Azure Cloud tools, including PowerShell, Blob Storage, Data Lake, and Data Lifecycle Management, etc., to perform database analysis, database management, and data governance, build and update data dictionary & data modeling.• Supported, diagnosed and resolved production issues. Continuously monitored database & Airflow performance, maintained existing data pipelines and tuned SQL queries.• Worked cross-functionally with QA, Dev, DevOps and production teams on data architecture improvement, platforms migration, database upgrade & migration, cost analysis, data analytics and software development lifecycle. Show less

• Used Twitter API to collect over 1 million tweets and developed a framework of Sentiment based Topic Modeling on measuring public sentiment and discovering concerns of COVID-19 vaccines. One academic paper was published in JMIR(impact factor of 5.43). (https://www.jmir.org/2022/2/e31726)• Used regulation.gov API to collect 16,000+ comments and 550+ regulations. Measured the tone of public comments and determine how tone impacts the change in final Tax Regulations with LM sentiment and… Show more • Used Twitter API to collect over 1 million tweets and developed a framework of Sentiment based Topic Modeling on measuring public sentiment and discovering concerns of COVID-19 vaccines. One academic paper was published in JMIR(impact factor of 5.43). (https://www.jmir.org/2022/2/e31726)• Used regulation.gov API to collect 16,000+ comments and 550+ regulations. Measured the tone of public comments and determine how tone impacts the change in final Tax Regulations with LM sentiment and Cosine Similarity in Python.• Built SIR models to quantify the impact of political and 10+ socioeconomic factors on COVID-19 transmission. Implemented Bayesian, Markov Chain Monte Carlo (MCMC), Regression methods in R and Python.• Acted as the Enterprise Systems e-Learning Club (SAP ERP) Graduate Assistant. Helped students solve SAP case study problems, graded assignments and conducted data analysis. Show less

• Built a real-time tracker and interactive dashboard to update global COVID-19 case counts and metrics.• Researched, integrated and quality assured data from official sources from 3,169+ counties across U.S./Canada and 30+ countries across the world; prototyped the data pipeline for different countries. Our website has 343+ million visitors and served as an original data provider for CDC and JHU COVID Dashboard.

Wuhan, Hubei, China

• Conducted industry research and performed financial market research. Analyzed corporate financial statements, business operations, and investment risks. Designed product portfolios, the loan amount was up to ¥1 billion.• Collaborated with internal teams and stakeholders to promote and deploy financial products effectively and monitored corporate financial health.• Developed 10+ middle and large sized energy/mineral corporate customers, created ¥600+ millions of savings in two years… Show more • Conducted industry research and performed financial market research. Analyzed corporate financial statements, business operations, and investment risks. Designed product portfolios, the loan amount was up to ¥1 billion.• Collaborated with internal teams and stakeholders to promote and deploy financial products effectively and monitored corporate financial health.• Developed 10+ middle and large sized energy/mineral corporate customers, created ¥600+ millions of savings in two years, and overfulfilled the assigned KPI. Show less

Wuhan, Hubei, China

Worked as an office administrator for Hubei branch, Sichuan branch and Xinjiang branch. Collected and organized information of market and clients.Analyzed client demands, risks and values, and completed investigation reports.

Shanghai City, China

Processed the application of accessing to network port of Unionpay. Checked the merchant’s qualification and provided ongoing service.

Master Of Science - Ms, Information Systems, 3.92/4.0

Master'S Degree, Master Of Management Science And Engineering(Information Security)

Bachelor'S Degree, Finance, General

Bachelor'S Degree, Security Engineering