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 strategic objectives• 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 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 strategic objectives• 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 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 business insights.• Participate in periodic reviews of BI tools and reports with Executive Leadership team.• Liaise with the business unit stakeholders on design functionality and interpret requirements, design, and support reporting for all internal and external customers.• Liaise with business unit stakeholders to understand their needs for current and future reporting capabilities.• Provide business units and other internal and external customers with insights into KPIs and supporting metrics.• Define and implement data reporting and analysis best practices (e.g. data integrity, test design, analysis, validation, and documentation) Show less

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 Power BI.• 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 • 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 Power BI.• 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 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. • Optimizing complex code to improve efficiency and documenting the projects so others can easily use the code and build upon it. Show less

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 • 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 to enable better data consolidation.• Documenting processes and supporting development of a data dictionary.• Support and maintain regularly scheduled updates to the database.• Training of end users on the BI tools (Tableau) and environment. Show less

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 with a group and do the statistics after the project is finished.- Executed technical Q&A about information of He-Fu-Min-Gan… Show more - 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 with a group and do the statistics after the project is finished.- Executed technical Q&A about information of He-Fu-Min-Gan high speed railway project including broadcast system, security check system, office automation system etc. Show less

Master Of Communications & Signal Processing, Electrical &Electronic Engineering

Bachelor Of Communication Engineering, Communication Engineering