Summary
Overview
Work History
Education
Skills
Certification
Websites
Timeline
Generic
Sumaiya Fatima

Sumaiya Fatima

Waukegan

Summary

Enterprise Architecture Analyst with 5+ years of experience leading enterprise repository migrations, Power BI solutions, and Power Platform automation. Sole analyst driving ARB/SRB/TRB governance, delivering $400K+ in cost savings in one year, automating compliance and intake workflows, and building executive dashboards that ensure business continuity, architectural compliance, and faster decision-making.

Overview

5
5
years of professional experience
1
1
Certification

Work History

IS System Analyst of Enterprise Architecture Dept

Medline Industries
08.2020 - Current

2025 Key Projects

Enterprise Architecture Repository Transition & Business Continuity

  • Led the transition from a legacy EA repository to a new enterprise tool during the rollout phase
  • Built a Power BI–based interim repository to replicate legacy functionality and keep business running when the new tool was delayed by 6+ months
  • Avoided the need for a temporary replacement tool, saving the company $200K+
  • Maintained and managed EA data without an active repository, updating data directly at the database level and connecting it to Power BI for secure access
  • Delivered multi-page Power BI reports, including:
  • Application ownership
  • Lifecycle and end-of-support timelines
  • Technology and application inventories with easy-to-use filters
  • Completed the full migration from the legacy EA system to the new tool, ensuring clean and accurate data
  • Created user training documents and process guides, explaining how to use the new tool and key terminology differences from the legacy system
  • Power Apps–Driven ARB / SRB Determination & Compliance Automation
  • Designed and developed a custom Canvas Power App to automate ARB,SRB & TRB determination process, avoiding a $200K+ external solution and saving Enterprise Architects significant time by eliminating manual meeting determination and Well-Architected Framework (WAF) score calculations.
  • Built dynamic questionnaires with backend logic that automatically determine review type, route users to the correct workflow, prefill submission details, assign Architects, and send confirmation emails
  • On SRB request, App redirects to conduct Well-Architected Framework (WAF) assessments to ensure cloud solutions are secure, reliable, cost-efficient, and operationally sound by evaluating 26 enterprise architecture and security policies.
  • Automated WAF compliance scoring, excluding non-applicable responses and calculating compliance percentages in the background to determine status and next steps
  • Persisted all results to SharePoint Online using Patch() functions and generated structured email summaries for users and assigned Architects

Ongoing Responsibilities & Operational Ownership

  • Manage and coordinate ARB, SRB, and TRB intake, scheduling, and execution, ensuring timely progression of requests through governance processes
  • Track review requests end-to-end and follow up with Architects and stakeholders to ensure completion, functioning in a Scrum Master–like role to remove blockers and maintain momentum
  • Serve as the sole Enterprise Architecture Analyst on the team, independently managing:
  • All Power Apps and Power BI development
  • Data modeling, testing, deployment, and production support
  • Design, build, test, and deploy solutions independently, with Architects participating only in final validation and user acceptance testing
  • Develop and maintain multiple governance and operational dashboards, including:
  • ARB, SRB, and TRB Metrics reports to track request ownership, status, turnaround time, and architect workload
  • Produce additional ad-hoc dashboards and reports as needed to support leadership visibility, operational tracking, and decision-making

Education

Masters In Data Analytics -

University of Wisconsin-Parkside
01-2023

Bachelor of Science -

University of Wisconsin-Parkside
01-2020

Skills

  • Power Fx (Power Apps formulas, Patch, LookUp, Filter, validation logic)
  • Python (data analysis, automation and scripting)
  • PowerShell (automation & scripting)
  • Power Apps (Canvas & Model Driven Apps)
  • Power Automate
  • Power BI
  • DAX
  • SQL
  • SharePoint / Dataverse Integrations

Certification

Microsoft:

  • Azure Fundamentals (Az-900) 09/2023-Present
  • Power Platform Fundamentals (PL-900) 10/2023-Present


Institute for Leadership Excellence & Development Inc:

  • Advanced Project Management 12/2024-Present


College of Lake County:

  • Essentials of Project Management 10/2024-Present


SAP Lean IX:

  • Application Rationalization with LeanIX 05/2024-Present


LinkedIn Learning:

  • Power BI Data Analyst Associate 05/2024-Present
  • SQL for Data Analysis 04/2024-Present
  • Tableau10 Essential Training 01/2023-Present
  • Learning Python 04/2023-Present

Timeline

IS System Analyst of Enterprise Architecture Dept

Medline Industries
08.2020 - Current

Bachelor of Science -

University of Wisconsin-Parkside

Masters In Data Analytics -

University of Wisconsin-Parkside
Sumaiya Fatima