About Me

Marcello De Filippis

Hi, I'm Marcello, I am a Software Developer living in Hamilton, Ontario, Canada. I have experience in front-end and back-end development, including Javascript, .NET, Java, PHP, and SQL. Previously, I worked as a Data Analyst at organizations such as Geotab, Loblaw, the Ontario Ministry of Agriculture, and McMaster University, where I developed dashboards, automated processes, and analyzed large datasets. I hold a post-graduate Certificate in Data Science, degree in Human Rights, and a Certificate in Human Resource Management.


Experience

Project Analyst

Jan 2024 – August 2024 | Geotab | Oakville, ON

  • Collaborated on a software migration project for 6,000+ devices, developing processes, maintaining spreadsheets, coordinating with partners, and using Jira for ticket management.
  • Created a swim lane process map in Miro to streamline workflows across departments, improving task efficiency.
  • Analyzed missed revenue and identified a delinquent client, raising the urgency of a billing system improvement initiative to close the loophole and ensure accurate revenue capture.

Business & Customer Insights Analyst

Jan 2023 – Aug 2023 | Loblaw Companies Limited | Brampton, ON

  • Assisted with building and maintaining a data warehouse using Google Cloud Platform, conducting data profiling and source-to-target mapping analyses.
  • Collaborated with cross-functional teams in an Agile environment, participating in sprints and using Jira for task management.
  • Documented landing, ingestion, curation, and publication logic in Confluence, ensuring clear guidelines for data engineers.

Data Analyst

May 2022 – Aug 2022 | Ontario Ministry of Agriculture, Food and Rural Affairs | Guelph, ON

  • Supported the Meat Plant Audit Program by developing data-driven tools to optimize inspection schedules based on risk levels and compliance history.
  • Created VBA Macros in Excel to automate manual processes, improving efficiency in handling large datasets.
  • Developed a swim-lane process map to identify inefficiencies and documented strategies for process optimization.

Head of Supportive Relations

Jun 2021 – Jan 2022 | McMaster University's ‘Deltahacks’ Hackathon | Hamilton, ON

  • Led a team of three executives in recruiting mentors, judges, workshop hosts, and challenge hosts for a coding competition with 600+ participants.
  • Streamlined team workflows using Google tools, including calendars and email templates, and created a task delegation spreadsheet to track progress.
  • Successfully onboarded 30 mentors, 50 judges, 6 challenge hosts, and 10 workshop hosts.

Data Analyst

Nov 2020 – Aug 2021 | McMaster University | Hamilton, ON

  • Analyzed 6 years of course evaluation data for 12 departments, creating dashboards that provided insights across multiple teams.
  • Cleaned and compiled data to build an interactive dashboard, ensuring data integrity and normalization.
  • Utilized weighted averages for more accurate insights from historical course evaluation data with varying scales.

Projects

Education

Software Development (Diploma)

Mohawk College

Relevant courses: Data Structures and Algorithms, Client-Side Web Programming, Server-Side Web Programming, Project Management, Cloud Computing, Database Theory, Programming in Java, .NET.

Data Science (Post-Graduate Certificate)

Sheridan College

Relevant courses: Advanced Statistics, Business Problem Analysis and Data Modelling, Big Data Tools, Machine Learning, Applied Capstone Project.

Human Rights and Equity Studies (Honours, B.A)

York University

Relevant courses: Research Methods, Human Rights and the Canadian Charter, Public Law, Social Policy, Honours Thesis (on mental health within the social economy).

Human Resources Management (Certificate)

York University

Relevant courses: Accounting, Compensation, Administration, Recruitment and Selection, Training and Development, Occupational Health and Safety.

Notes

Click the link below to be taken to where I keep all of my notes. Topics include:

  • Software Development
    • Java
    • .NET
    • JavaScript
    • PHP
    • SQL
  • Data Science
    • Statistics
    • Machine Learning
    • Big Data Tools
    • Business Problem Analysis
  • Book Summaries
    • Confident Data Skills
    • 201 Knockout Answers To Tough Interview Questions
    • 12 Rules Of Life
    • The First 20 Hours

My Notes