Zhaoyu ZHANG

- Consultant at Virtual Beehive, on assignment at BNP Paribas CIB Securities Services. - Data processing modelisation using Python and VBA for US tax reporting. - Oracle PL/SQL for securities data querying, database operations, and performance optimisation in collaboration with IT services. - Power BI for KPI visualisation and reporting to track project performance and data quality. - Data retrieval, cleansing, and reconciling on KNIME and Alteryx.

- Trading Data Visualisation for best execution reports for portfolio managers with Power BI and Tableau. - BlackRock Aladdin trading data integration with Oracle PL/SQL Developer. - Supported traders with their reporting needs: performance analysis, trading cost analysis, PnL via Tableau. - Automated data processing via Python and Excel VBA, reducing errors and optimising delivery to traders. - Collaborated with several internal departments : front, middle, back offices and compliance.

- Development of 2 PowerApps softwares (warehouse management system and after-sales product tracking system) based on SQL Server databases. - Forecast of spare parts orders and optimisation of costs control with Power BI data analysis. - Optimisation of workshop's intra logistics by Microsoft Visio Professional digital modeling. - Spare Parts, Consumables, and worldwide after-sales operations performance Management.

- Established Financial dashboard on Tableau for operations costs control, supporting financial decision-making. - Created supply chain financial performance report (procurement, transportation, warehousing) using PowerBI.

- Data analysis and visualisation of thermodynamic experiment data with MATLAB and Excel VBA. - Building machine learning models to classify vehicles (K-Means Clustering with scikit-learn module).

- Process recording with Excel VBA, use of pivot tables, and use of built-in data analysis tools to determine the overall quality of the laboratory operation and the ability to comply with FDA regulations. - Practised pharmaceutical analytical instrument operation and quality inspection experiments including drug dissolution tests, pharmaceutical water quality test methods and the microbiological method.

Participated in Prof. ZHAO Guangrong’s research project, Advances of Betalains Biosynthesis and Metabolic Regulation. The paper has been published in the journal China Biotechnology and I am the third author. I got involved in the work of plasmid transformation, PCR amplification, reading gene sequences, analyzing the result of DNA purification, DNA and protein electrophoresis, application of ultraviolet-visible spectrophotometer and centrifugal equipment.