Shijie（Mark) Chen Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Contributed to the 3rd stage of the Semi-Automated Design of Ontology project that extracts and leverages the embedded knowledge in RBC’s large amount of data models to support business operations and information system development• Obtained thorough understanding of project background, communicated with project leads and team members to determine the goals and timeline of the current project stage• Improved accuracy of the axiom generator and extracted more than 400 relationships between tables and columns in logical database tables from RBC enterprise database warehouse using Python• Generated axioms for SIC code, Postal Code and Industry Code; Built a text classification model to address explicit and implicit relationships between columns using Python• Exploited constraints in the data models, enhanced user interface and output format for use-friendly experience

Toronto, Ontario, Canada

• Leveraged SQL and Python to retrieve large volumes of raw data from external database and performed extensive data inspection and cleaning on missing data, outliers, consistency, completeness, etc.• Researched and studied machine learning models built by senior data scientist to predict disability and mortality rates; Performed feature engineering on cleaned data to construct out-of-sample test set • Validated model performance by conducting cross-comparative analysis on training and test datasets • Leveraged multiple statistical analysis methodologies including Xgboost and Logistic regression to contribute towards model construction • Generated formal report on model testing results and signed models off for implementation

Waterloo, Ontario

• Led a migration project to rebuild reporting structure of a department consisting of 14 teams on SharePoint Online, as well as diligently maintain system and implement enhancements • Extensive use of Excel to visualize and monitor team structure, reporting hierarchy and schedules, frequency and quantity of submitted reports, and presented to senior management on regular basis • Designed detailed step-by-step guidelines; Held training sessions for end-users and collected feedbacks • Coordinated and organized multiple weekly activities to enhance corporate culture and team-relations

200 Consumers Rd Suite 409, North York, On M2J 4R4

• Collaborated with project team to launch company's mortgage services website; Independently developed the mortgage calculator function using Excel VBA for the website• Developed and coordinated project expectations and timeline; Maintained timely communication with project manager and internal stakeholders to ensure accurate implementation of all web functions• Identified new business opportunities and took actions proactively to drive business growth

2 Carlton St #901, Toronto, On M5B 1J3

• Conducted research and constructed multiple analysis models to create workflow and project dashboards on blockchain applications• Implemented workflow and dashboards on Confluence site with automated data and dashboard updates• Managed multiple processes on Confluence team platform on IBM cloud

Master Of Business Analytics, Business/Data Science

Undergraduate, Mathematics