Ditian Zhu Email & Phone Number

Toronto, Ontario, Canada

• Develop reporting dashboards and initiate proactive analysis to identify trends and data that support recommendations and innovations to improve performance across the Operations (Rapid Transit) Division and achieve.
• Establish and maintain Key Performance Indicators (KPIs) and supporting metrics to be used across Operations (Rapid Transit) to track performance.
• Develop reporting requirements with business unit subject matter experts and utilize a standardized… Show more
• Develop reporting requirements with business unit subject matter experts and utilize a standardized approach to performance reporting.
• Support the use of Enterprise Asset Management Information Systems and other operational systems; develop reporting dashboards to inform performance of the Division; and enable fast, easy, meaningful operational and.
• Participate in periodic reviews of BI tools and reports with Executive Leadership team.

Toronto, Canada Area

• Collaborating with different teams to identify data needed for a business problem, independently design and build data models using SQL and Python, and create BI reports to present the key data insights visually using.
• Collaborating with MS CRM, F&O and Salesforce teams to establish centralized data warehouse, capture and integrate data from various internal and external sources of data (EDW, MS Azure, Odata).
• Building ETL pipelines to move complex data across different… Show more
• Building ETL pipelines to move complex data across different platforms including SQL Server and real-time systems.
• Creating user-friendly dashboards with Power BI to provide business analytical snapshot, for example Sales Performance, Segmentation, Global Churn, and Activations Scorecard. Validating reports accuracy with SQL.
• Automating and scripting repetitive work with Python.

Toronto, Canada Area

• Working in an Agile environment, collaboratively with PD and IT departments to design, develop and implement BI solutions which will improve efficiency and analytic capabilities of the company.
• Reviewing current processes and advising on database design plans to support business needs.
• Developing ETL processes using Python Pandas. Prepared the data with complex SQL queries.
• Developing quality control processes to ensure quality of data feeds.
• Standardizing coding of data… Show more
• Standardizing coding of data to enable better data consolidation.

Beijing, China

- Engaged in railway communication design and information construction of stations.- Being part of a Shi-Tai railway communication capacity improvement project, design an optical fiber communication route for GSM-R network to achieve a higher connection speed.- Designing and drawing optical fiber route by AutoCAD.- Making engineering quantities estimation.

Master Of Communications & Signal Processing, Electrical &Electronic Engineering

Bachelor Of Communication Engineering, Communication Engineering