Zhiyu Pan

Data Analyst(Cmda) @CIBC Capital Markets

Toronto, ON, CA

Led the migration of reports across trading teams to CMDA, streamlining data management and reporting processes by overseeing source analysis, data ingestion, transformations, aggregation, and cloud workflow setup, resulting in improved efficiency and scalability Automated key processes by developing Python scripts and utilizing different internal APIs, minimizing human error and improving the accuracy and timeliness of business reports Provided cross-functional support to teams across FX, Equity, IRD, Commodities, and Structural Engineering,facilitating business user onboarding and enhancing their self-service capabilities on the Databricks Proposed and implemented a solution for transitioning data from the Bronze layer to the Silver layer in the Databricks data lake, enhancing data quality, accessibility, and consistency for downstream analysis and reporting Created production-quality notebooks using PySpark and dashboards with Plotly for data analysis and user aggregation, facilitating the discovery of new trading opportunities and supporting strategic decision-making Addressed data gaps in existing CMDA pipelines by proposing and implementing solutions, ensuring comprehensive and reliable data flows within the Azure cloud database Created specialized spreadsheets using Sniffer to bridge communication between business users and the quantitative team, investigated the root cause of production issues, proposed potential solutions, and enhanced collaboration across departments, resulting in a 30% reduction in issue resolution time

Carnegie Mellon University

Master of Science - MS

University of Toronto

Bachelor of Science - BS