Arhum W. Email & Phone Number

Toronto, Ontario, Ca

Extract actionable insights from product releases worth over +$10M annual incremental spend to senior business and engineering stakeholders.Created dynamic dashboards in Looker to assist data storytelling which including data modeling using LookML.Developed complex SQL queries to generate KPIs for reports and dashboarding based on stakeholder requirements.Data mining with Kafka using Python to sample, aggregate and generate reports for stakeholders.Improved and developed statistical testing framework for new product releases by creating standardized dashboards which tracked KPIs using different visualizations to reduce time required for analysis.Developed, maintained and automated ETL pipelines using Python and GitLab to prepare for reporting and dashboards.

Toronto, Ontario, Ca

Developed SQL stored procedures, triggers, functions, tables and views including complex queries using common table expressions.Building, testing and maintaining data architecture of multiple clients sourced from file uploads and APIs.Optimizing data integration process and transformation processes to ensure scalability and performance.Configured ETL packages in SSIS for data integration and transformation from API to database, which included importing data from APIs using OData to query specific sets of data.Implemented business requirement in a cross functional team of specialists.

Created BI reports and dashboards on data trends to provide summaries and insights promptly to supervisors and management.Scripted SQL queries to assist in data validation which decreased the time of client product release by 75%.Oversaw data collection of Twitter data using Azure virtual machine for surveillance and detection.Troubleshoot SQL queries that check for completion to maintain data integrity.Completed data profiling and validation checks to ensure the quality of the data available for analysis.Developed and maintained data processing pipeline in R using RegEx functions to process string/character variables.Improved data management methodology through team meetings, mind mapping, and data mining which includes providing alternative suggestions that follow data processing guidelines.

Assisted with creation and maintenance of data processing documentation including a data dictionary and technical guide to inform stakeholders of meaning and summaries of each variable.Transformed and mapped substance-related harms data sourced from provinces and territories which includes integration of data from different sources.Collaborated with the team to develop and maintain a categorical variable processing pipeline.Created progress tracker in excel to inform relevant stakeholders of updates.

Toronto, Ontario, Ca

Created dashboards to provide insight on mental illness and comorbidities among students before and after COVID-19 epidemic which was used to make informative digital products on student mental healthVisualized datasets to show relationships, draw conclusions and inform policy on student mental health

Toronto, Ontario, Ca

Data analysis of rodents fed special dietAnalyzed and visualized data using R package (ggplot2) and performed GLM using SPSSProduced 26 bar charts of genetic amplification levels for hippocampus and amygdala brain regions as well as 13 MS Word reports of t-tests

Toronto, Ontario, Ca

Enhanced student experience by marketing and planning 20+ collaborative events as part of a teamReduced event expenses through valuation of event supplies by consultation with events teamInitiated outreach analytics which showed that 200 students attended our events with preference towards career and social events which had 75% higher attendance than other events

Toronto, Ontario, Ca

Collected and coded data from Harvard SAHRE research symposium with research team on ExcelVisualized data and interpreted statistical findings of current trends of the mental health of university students attending the University of Toronto Scarborough Campus

Toronto, Ontario, Ca

Recorded experimental data on lab software under of PhD supervisorVisualized data from analytical chemistry study regarding gold electrodes using lab software and presented findings to supervisor