Data Analyst & Software Developer

Bridging technical execution with organizational strategy

About Me

Marcello De Filippis

Hi, I'm Marcello De Filippis, a Software Developer and Data Analyst based in Hamilton, Ontario.

I have always believed that progress happens at the intersection of human understanding and technical innovation. My journey began in the social sciences, studying the systems that govern our society. But I soon realized that to truly improve those systems, we need the tools to build them. That is why I’ve dedicated myself to mastering the language of code and the power of data.Whether it’s developing seamless user experiences with React or unlocking insights within BigQuery, my work is driven by a simple mission: to take complex information and turn it into something useful.

"Technological progress becomes even more exciting when it enters into the service of the social idea which demands that not only a small elite but humanity at large should profit by it." ~ Rudolf Christoph Eucken

Experience

Front-End Developer

Jan 2025 – Sep 2025 | Parva | Hamilton, ON

  • Built a drag-and-drop form builder with inline editing, field configuration modals, and embed code generation using Next.js, React, and TypeScript, enabling users to create and publish customizable forms without code.
  • Developed a reusable component library using ShadCN UI components and Tailwind CSS, ensuring consistent design patterns and accessibility standards across the application.
  • Applied state management tools (Zustand, React Query) to support features like multi-brand switching.
  • Implemented testing infrastructure with Jest, React Testing Library, and coverage reporting, establishing test patterns for components, hooks, and API clients.

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 on a data engineering initiative building a medallion-style data pipeline within Google Cloud Platform (GCP) to transform and integrate 27 disparate data sources to build a complex data model to quantify how each campaign marketing spend translates into revenue.
  • Ensured data accuracy and integrity during the data landing and ingestion lifecycle by performing SQL verification and data profiling; authored ETL technical documentation within shared Confluence pages.
  • Standardized marketing taxonomy and executed source-to- target mapping using Attaccama to unify disparate data streams, ensuring high-quality data integrity for the Marketing Mix Model (MMM) and strategic business intelligence.

Data Analyst Intern

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

  • Supported the Meat Plant Audit Program using data on plant risk levels, compliance history, and operational activities, to develop a data-driven tool to streamline the inspection schedules at abattoirs.
  • Automated a multi-step re-occurring process using VBA Macros within Microsoft Excel to save time and reduce the chance of human error within a spread sheet with over a thousand records of data reducing time spent on manual processes for greater efficiency.
  • 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

  • Managed a team of three executives to lead the recruitment process of the mentors, judges, workshop hosts, and challenge hosts for a coding competition attended by 600+ participants.
  • Created a task delegation spreadsheet to assign responsibilities and track progress. Used Google tools like calendars and email templates to improve team collaboration and streamline workflows.
  • 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 longitudinal course evaluation data (2015–2020) across 12 departments, managing high-dimensional datasets with 1,000+ variables per program to uncover long-term institutional trends.
  • Architected interactive Excel dashboards to visualize multi-departmental KPIs, implementing data normalization and integrity checks to provide 12+ leadership teams with a unified single source of truth.
  • Designed a weighted-average methodology to reconcile historical evaluation results across varying scales; transformed inconsistent datasets into actionable year-over-year 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
View My Notes