Mark Cui Pan Email & Phone Number

Providence, Rhode Island, Us

Menlo Park, Ca, Us

I created value for millions of businesses and their customers by improving the Shops experience: https://www.facebook.com/business/shops

San Francisco, Ca, Us

I worked remotely with the Social Updates team - mostly feature work and domain design in Ruby on Rails with Sidekiq, Redis, MySQL and Kafka, with occasional plumbing/debugging excursions into GraphQL and Vue.Some highlights from my work here:• I improved an algorithm for reaggregating notifications, which decreased that endpoint's memory allocations by over 90%.• I built a pipeline for disseminating 1K+ peer recommendations per month on top of Sidekiq, Redis, and Kafka.• I wrote a backfill task to safely and efficiently update 180M+ records in our production database.• I optimized a daily-run archive job by making use of batching, caching, and a compound index, which reduced the job's execution time by 98%.I use Docker containers for local development, GitHub for code reviews, and Pivotal Tracker for issue tracking.

Madison, Wisconsin, Us

I built tools to assist researchers and administrators with a wide variety of workflows. One large project I worked on was a Rails API/React UI microservice for visualizing respirometry data.Some highlights from my work here:• I wrote rake tasks to import mission-critical Excel data for reporting to the U.S. Department of Energy, the institute's primary funding source.• I audited our Rspec + Capybara test suite, making fixes to align it with industry best practices, which reduced its single-process runtime by over 20%.• I built dynamic nested forms and a file tree navigator using AJAX + jQuery.• I wrote shell scripts to assist with database management and config file updates, making context switches faster and less error-prone for our entire team.I developed against a Docker clone of a production Oracle database, using Gitlab for code reviews and Jira for issue tracking.

• I worked on an import script for JPW Industries. In particular, I wrote code to alert members of the core maintenance team when parts of the import script raised errors.• I built the website for Vilas & Company (www.vilasandcompany.com) using Jekyll and Amazon S3.

• I got Julia to play nice with Heroku, resolving 100% of request timeout issues caused by a processor-heavy task taking too long to complete on the server.

• I taught biology and math to local and international students aged 8 to 28.• I leveraged web and mobile technologies to track progress and enhance learner outcomes.

• I taught ACT Maths, SSAT/SAT Quantitative, SAT Maths Subjects, SAT Biology/EM Subject, AP/IB Biology, MYP Maths, and GRE Verbal Reasoning.• I wrote diagnostic exams to identify gaps in student understanding and designed a math curriculum to address these gaps, focusing in particular on translation of word problems into math symbols.

• I drafted the FY15 budget and helped secure $69,161.10 in institutional funding.• I prepared time-sensitive reports and justifications of expenditures for both our funding entity and the general public.• I increased operational efficiency by 11%, cutting costs of the organization by nearly $8,000 over the course of one fiscal year.• I approved the twice-monthly payroll activities of 15 employees.• I maintained a complete record of financial transactions for auditing purposes.• I coordinated logistics for the annual Freethought Festival - one of thelargest secular student conventions in the nation.• I led weekly meetings in which I prepared and presented material from field-specific literature to audiences of 30 to 70 people.

Madison, Wi, Us

• I assisted the principle investigator with data collection and analysis to study epigenetic mechanisms using the central nervous system of Rattus spp. as a model.• I wrote a Python script to perform calculations and expedite the process of cDNA synthesis.• I performed slice preparation, tissue homogenization, DNA, RNA and protein purification, cDNA synthesis, and immunocytochemistry, Western blot and polymerase chain reaction assays.• I kept my peers, graduate mentors, and PI up-to-date on lab activities and results as part of weekly lab meetings.

- Organized and maintained laboratory facilities and experimentation equipment for principle investigators to ensure on-demand working order- Prepared and changed cages used for rodent storage while adhering strictly to biohazard safety protocols- Performed regularly schedule cage-checks, room-sanitizations and other custodial duties

Bachelor Of Science, Molecular Biology

High School Diploma