Abdelrahman Merdan
OPen

I’m a Computer Science student at York University with experience as a Software Developer at the Government of Ontario. I’ve worked on web development, data engineering, accessibility, and user-focused applications using technologies like React, JavaScript, Python, SQL, and Azure Databricks. My experience has given me a strong foundation in problem-solving, collaboration, and creating digital experiences that are both functional and accessible. I’m passionate about combining technical skills with creativity to develop meaningful solutions that make a difference for users. Outside of work, I enjoy playing volleyball, exploring graphic design projects, and building personal projects that challenge me to learn and grow.

Hi, I'm
Abdelrahman Merdan!

Experience

Software Developer -
Ministry of Children, Community and Social Services

July 2025 - Current

• Led a 6-person team in building an Azure Databricks and Microsoft Fabric medallion Lakehouse platform that automated ingestion, processing, and classification of 500+ articles into structured datasets enriched withsentiment and keyword analysis across 8 policy domains.
• Drove an evidence-based intranet redesign by conducting research with 60+ users, creating six personas, and optimizing information architecture, reducing pages from 230 to 106 and homepage links from 41 to 18,significantly improving usability and navigation.
• Spearheaded the end-to-end design and development of the departmental homepage and 25+ intranet pages, creating wireframes in Figma and coding them with HTML, CSS, and React while meeting WCAG 2.2 standards.
• Developed a modular design system with 15+ reusable UI components, creating assets in Adobe Illustrator and Photoshop and integrating them into a shared Figma component library to ensure interface consistency.
• Engineered a Power BI dashboard using DAX-based data transformation to aggregate information across 50+ database tables, centralizing compliance reporting for 500+ applications and 2,000+ administrators.
• Restructured the relational data model supporting government application compliance tracking, consolidating 50+ tables into 10 interconnected tables using SQL to improve data organization and maintainability.
• Implemented and maintained 50+ features across 5 React applications using JavaScript, managing source control, branching, and code integration through Azure DevOps within Agile development cycles.

Developer Co-op -
Ministry of Children, Community and Social Services

April 2024 - July 2025

• Conducted WCAG 2.1 AA accessibility audits and code reviews for 75+ Ontario government websites using WAVE, Axe DevTools, NVDA, and ARC providing technical expertise and delivering remediation plans thatachieved 100% compliance across user paths.
• Built and executed 50+ Selenium-Python automation scripts for functional and regression testing, uncovering 30% more defects, improving code quality, and reducing post-release issues within an Agile workflow.
• Integrated Google Analytics into 5 web applications to track website traffic and user engagement, supportingdata-driven analysis of user interactions.

Web Developer Contract -
MMB Planning and Architecture

April 2023 - September 2023

• Designed, developed, and published 10+ responsive pages using TypeScript and React, incorporating interactive elements such as forms and carousels, performing cross-browser and device testing, and deploying on Netlify.
• Conducted competitor analysis, stakeholder interviews, and user research with 20+ participants to gather requirements and inform design decisions, resulting in optimized website features and layouts that increased job inquiries and project opportunities by 30%.

Use this form to describe your project
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.