My Projects
Project 1 -
Data analysis on H. Pylori antibiotic resistance in Pediatric Patients of Latino and African American
Helicobacter pylori (H. pylori) infection disproportionately affects Latino and African American Children. Due to lack of data to inform expert pediatric guidelines, these children and their families are not being actively screened for the infection. As a result, they remain at higher risk for future complications including gastric and duodenal ulcer disease, and gastric cancer. We aim to determine the rate of H. pylori antibiotic resistance in symptomatic patients infected with H. pylori from Latino and African American racial-ethnic groups via next generation sequencing (NGS) in order to provide tailored antibiotic susceptibility-guided therapy to these patients, with the ultimate goal to improve the treatment eradication rates. In this way, the project will reduce health care disparities in these vulnerable populations at risk of significant morbidity and mortality if left untreated. We expect to observe an improvement in treatment success rates compared to declining success rates of empiric antibiotic therapy. The project will generate novel information on antibiotic resistance in H. pylori in our community which has the potential to change clinical practice and insurance coverage for non-invasive antibiotic resistance testing.
​
Top Right Image Link:
https://www.labmanager.com/product-focus/the-third-wave-of-next-generation-sequencing-22898
​
Bottom Right Image: NGS Data Process at American Molecular Lab
Project 2 -
Uber Teens App Marketing Strategy
Uber Teens’ motto is “safety first.” Based on our data, parents are primarily concerned with their children’s safety and are willing to pay a higher price and have longer wait times to ensure this.
​
Here is a brief overview of our product:
-
One of the app’s most vital features is the ability for parents/teens to choose their drivers based on factors like gender & sexual orientation
-
Most parents have expressed that they’d be most if their teenage daughter was being driven by a straight female driver
-
-
The next feature is the “cancel ride” feature that Jingjie described in the UI/UX slides
-
Either prior to the ride or during it, parents can select this button to cancel a ride that their teen booked, leaving them at the nearest safe point or not departing at all, and The driver will be notified and will be compensated for their time.
-
Parents can also see where their children are along with what is on the roads or in the car with cameras.
-
These features would drive the prices of rides upwards, but parents are okay with this. By putting “safety first,” Uber Teens eases the anxiety that comes with letting a child ride alone.
​
Uber Teens will require various channels of communication to spread awareness of our product. This is because we must cater to a wide variety of audiences at different ages.
-
Apps such as Instagram, YouTube, SnapChat, TikTok, and Twitter are all strong and viable channels for short ads to teens as they tend to use social media
-
For parents, the best marketing strategies would be on the Uber app, YouTube, Facebook, and the News.
-
Finally, drivers would learn about the opportunity to chauffeur teens through the Uber app and UberPeople.net.
Project 3 -
Shipping Cost Optimization Modeling using Excel Solver during Pandemic
Summary:
Traditionally, inventory was built based on customer forecast, and stored at the closest warehouse from customer’s location. During Covid and international logistic issue, inventory shortage occurs often at different warehouses. To meet customer’s demand, the company had to transfer inventory from one warehouse to another warehouse frequently, or ship product from a further warehouse to customer. I developed an excel solver using least cost model for logistic department to use during the difficult time to cost optimize the shipping upcharges. The model reduced the logistic upcharge by 20%, around $168,000 for the last 2 years.
​
Approach:
The transportation problem is one of the subclasses of a linear programming problem in which the objective is to transport products stored in facilities such as warehouses to different customer destinations in such a way as to minimize total transportation cost while satisfying all the supply and demand constraints.
​
The first step was to build a database was built with the following information:
-
Facility locations and distances between each source and destination facility.
-
Unit cost of shipment for each customer from difference warehouses.
-
The maximum storage capacity or inventory count of each source facility.
​
Then estalished a least cost model in the excel solver to cost optimization the shipping cost while best meeting customer's demands.
​
Outcome:
​
User friendly Excel Solver was delopment. Logistic Planer only need select customer's name and imput the customer's order qualities, the solver will solve to it's least cost option.
