− Developed a user analysis platform which detects popular origins/destinations of taxi and sharing bike trips to/from transportation hubs in New York and provides a comparison between current and historical data

− Built a batch processing pipeline to ingest >300 GB historical trip data and transportation related data, preprocess and perform computation with Spark, store the aggregated results in PostgreSQL with PostGIS extension, and finally use Dash to provide a map-based information query UI and visualize query results

− Designed a data ingest tool that identify a general schema and allow data in various schema to be ingested and converted through Airflow into the platform without recoding

Please check the following link for more information: https://github.com/danzhaozju/insight

Study on Performance of Countercurrent Bioelectrode Nitrogen Removal System (12/2017-05/2018)

• Consturcted the reverse seepage bioelectrode system by reversing the substrate flow in MFC.

• Meatured the removal rate and load of nitrogen pollutants, to evaluate the denitrification performance.

• Adopted the cyclic voltammetry curve, to examine the electrochemical activity and energy recovery potential of the bioelectrode.

• Revealed that the functional microorganisms and metabolic characteristics are the critical factors that determined the enrichment of electrotrophic microorganisms from inocula and the performance of bio-cathode denitrification

Effects of Inoculum on the Performance of Bio-cathode Denitrification (04/2016-05/2017)

• Developed the specific research plan and designed the experiment based on the independent study of bioelectrode denitrification mechanism and bacteria metabolic characteristics.

• Measured the utilization rate and slew rate of the substrate, nitrate and bicarbonate to identify the nitrogen removal performance of inoculum under no electron donor circumstance.

• Adopted gravimetric determination method to obtain the weight of the denitrification, denitratation, and anammox electrode; calculated and compared the growth rate and biomass production.

• Analyzed the influence mechanism of inoculum on bioelectrode nitrogen removal performance and the reasons behind the differences in nitrogen removal performance.

• Published a paper and received two national patents.

Attenuation Effect of Alkalization by Bio-cathode Denitrification and Its Mechanism (05/2017-07/2017)

• Designed the bioelectrochemical denitrification reactor and heterotrophic denitrification reactor.

• Explored the influence of substrate concentration on the attenuation effect of alkalization by bio-cathode denitrification.

• Damaged the cell membrane structure in a high pH environment to study the changes of membrane properties under the condition of high alkalinity.