About Me

Marcello De Filippis

Hi, I'm Marcello, a Data Analyst and Software Developer living in Hamilton, Ontario, Canada who bridges the gap between technical execution and organizational strategy. While many analysts focus solely on interpreting data, I take it a step further by building the automated pipelines, data products, and applications that generate those insights in the first place. My technical expertise spans System Analysis and Design, SQL, Data Integrity, and Project Management, demonstrated through work at organizations like Geotab, Loblaw, and the Ontario Ministry of Agriculture. What sets me apart is my unique foundation in Human Rights, HR, and Business. This background enables me to understand stakeholder needs and organizational context, ensuring the technology I build solves genuine business problems. Having worked extensively in public and government sectors, I'm particularly skilled at navigating compliance requirements and structured governance frameworks, making me a strong fit for Data Engineering, Solutions Consulting, and Technical Product Management roles.

Experience

Front-End Developer Intern

Jan 2025 – Sept 2025 | Parva | Hamilton, ON

  • Gained hands-on experience building a CRM web application with React and Next.js, focusing on responsive design and performance optimization.
  • Contributed to a drag-and-drop form builder with real-time previews and reusable components that can be embedded into external websites.
  • Applied state management tools (Zustand, React Query) to support features like multi-brand switching.
  • Collaborated with team members to improve code quality and workflow using TypeScript, Jest, ESLint, Prettier, and Git in a professional development environment.

Project Analyst Intern

Jan 2024 – Aug 2024 | Geotab | Oakville, ON

  • Collaborated on an initiative to migrate software for 6,000+ devices by developing processes, maintaining detailed spreadsheets, coordinating with external partners, and using Jira to log and resolve tickets.
  • Created a swim lane process map in Miro to clearly outline workflows, helping the team better understand tasks and work more efficiently across different departments.
  • Conducted an analysis of missed revenue, identifying a delinquent client exploiting a loophole. Elevated the issue to solidify the billing system, ensuring accurate revenue capture and closing the identified loophole.

Business & Customer Insights Analyst Co-Op

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

  • Collaborated with cross-functional teams in an Agile environment, using Jira for task management, sprint planning, and progress tracking. Participated in daily stand-ups and sprint reviews to meet project goals.
  • Supported data warehousing initiatives using Google Cloud Platform as an analyst on the data engineering team, conducting data profiling and source-to-target mapping analyses to help build data pipelines.
  • Utilized Google BigQuery for data warehousing and data profiling, performing SQL queries to ensure data accuracy and integrity as part of the data engineering process.

Data Analyst Intern

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

  • Supported the Meat Plant Audit Program by using data on plant risk levels, compliance history, and operational activities to develop data-driven tools to streamline inspection schedules for slaughter plants.
  • Produced VBA Macros within Microsoft Excel to automate recurring processes within a spreadsheet with over a thousand records, reducing time spent on manual tasks.
  • Formulated a swim-lane process map to identify inefficiencies, and documented and optimized strategies.

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 course evaluation trends among 12 departments over a 6-year span using Excel and created accompanying dashboards for each report to be accessed by multiple teams across departments.
  • Cleaned and compiled data from a database to create an interactive and visualized dashboard while ensuring data integrity and normalization.
  • Utilized weighted averages in analyzing historical course evaluation results that used varying scales, enabling more accurate insights and comparisons.

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