Lead and facilitate the data migration project which entailed data extraction from Salesforce (legacy system) and other data sources and data cleaning and upload into a central hub which is Sugar CRM
Improved data analysis and data extraction process timelines by 80% due to reconstructing database in Sugar CRM and improving data quality.
Ensure company maintains data compliance standards set by the government while also training company staff on data requirements, security and rules for daily operations
Monitor and track SCN’s key performance indicator(s) (KPIs) in alignment with
corporate planning to ensure targets are met, flag for the VP, Corporate Services and President & CEO when targets and data are not aligned
Prepare a midyear report for submission to government that provides a data
assessment on SCN’s KPIs and corporate plan commitments
Interpret data, analyze and present results using statistical techniques and provide ongoing reports as directed with Excel, SQL, Tableau and Python.
Organize and lead meeting between internal and external stakeholders for data projects.
Data Management Specialist
MD Financial Management
Ottawa, ON
09.2021 - 07.2022
Monitor pipeline health in Microsoft Dynamics 360 and support business planning process with regular reporting to management
Build advanced finds in Microsoft Dynamics 360 and create SQL queries for data extraction to complete data requests
Perform data cleaning on client information on company data source
Apply analytical knowledge in the form of building models, data analysis and data visualization with Microsoft Excel, SAS and Tableau for business projects
Manage data migration projects during Advisor transitions which included setting up meetings with stakeholders and assigning tasks to team members while using Git for source code version control
Develop data management practices to improve overall data quality while also applying privacy and compliance practice requirements
Data Analyst
MD Financial Management
Ottawa, ON
10.2019 - 09.2021
Successfully managed projects that entailed pricing, loyalty and product strategy which increased number of accounts opened by high-net-worth clients by 20% and increased capital inflow by 14%
Determined which products and sample size would be used for A/B testing while tracking analytics and impact on project goal during testing
Prepared monthly reports for management that helped understand monthly inbound and outbound money trends in the company
Used SQL, SAS, Excel and Tableau for collecting and tracking business KPI's, building complex inference/prediction models and giving recommendations to the marketing team for upcoming projects
Automated reports using Tableau for senior management that helped track number of accounts opened
Education
Master of Science - M.Sc. Data Science And Business Analytics (Concent
HEC Montreal
Montreal, QC
12-2024
Post-Graduate Certification - Data Analytics, Big Data, And Predictive Analytic
Master thesis student at Center for Neuroscience and Cell Biology - Gene and Stem Cell Therapies for the BrainMaster thesis student at Center for Neuroscience and Cell Biology - Gene and Stem Cell Therapies for the Brain
Assistant Manager (2IC) Client Services at Cell Care Australia (Stem Cell Biobank)Assistant Manager (2IC) Client Services at Cell Care Australia (Stem Cell Biobank)
Senior Post Doctoral Research Fellow (Full Time) at Lee Kong Chain School of Medicine, Stem cell and Regenerative Medicine, NTU SingaporeSenior Post Doctoral Research Fellow (Full Time) at Lee Kong Chain School of Medicine, Stem cell and Regenerative Medicine, NTU Singapore