Dylan Hira Email & Phone Number

Montreal, Quebec, Canada

• Corresponded with logistics managers at Nice to develop a reusable demand forecasting tool in VBA using various forecasting methodologies
• Acted as team data lead in handling all ELT and EDA tasks
• Presented project to University of Waterloo faculty, peers, and stakeholders at Nice

Ottawa, Ontario, Canada

• Used SQL Server, BigQuery, Excel, and Tableau to answer meaningful business questions and support product decisions
• Leveraged Python and Google Colab to conduct unsupervised clustering analysis of user demographics to inform future marketing campaigns
• Communicated analysis thoroughly in a way that addressed what action should be taken in response to the findings
• Worked directly with stakeholders and presented analysis results to team leads

Waterloo, Ontario, Canada

• Moderated daily stand-up meetings with 20+ participants to discuss project statuses and blockers
• Conducted analysis on the Corporate Marketing team’s business process and redesigned it using Kanban methodology
• Utilized JIRA, Confluence, and Smartsheets to facilitate Agile processes on the team
• Tracked project KPI’s in JIRA and documented them using Excel and Smartsheets
• Delivered weekly reports to the team regarding Sprint status

Toronto, Ontario, Canada

• Communicated with team members to prepare status updates and progress reports for the project manager
• Conducted variance analysis on a weekly basis to assess expenditures
• Maintained JIRA for multiple projects daily
• Automated report generation using VBA
• Created change orders, and scheduled meetings for upcoming system implementations

Burnaby, British Columbia, Canada

• Delegated team tasks and Sprint deadlines using JIRA software
• Regularly participated in meetings with stakeholders on project trajectory
• Assisted in UX design for TELUS offer web portal
• Used change management knowledge to assist in executing test cases

Toronto, Ontario, Canada

• Regularly conducted data analysis on government forms in Excel and presented concise reports to supervisors
• Demonstrated an adept detail-oriented lens when conducting QA on hundreds of forms
• Applied problem-solving skills by developing strategies to efficiently progress through form inventory project such as v-lookup, pivot tables, and macros in Excel