maricia.com

> HOME / RESUME.EXE

> RESUME ARCHIVE LOADED

Maricia Alleman

Senior Data Engineer · Analytics Engineer · BI Developer building SQL pipelines, Power BI models, automation tools, and data platforms from messy real-world systems.

SQL Server Snowflake Power BI Python Power Automate Data Warehousing ETL / ELT Data Governance

> CORE MISSIONS

Projects

Core missions completed throughout my career, featuring data platforms, analytics solutions, automation tools, and reporting systems built to solve real-world problems.

SNOWFLAKE DATA PLATFORM

District Data Platform

Layered Snowflake architecture using raw, staging, and analytics schemas.

> Resume Match

  • Centralized district data from disparate sources.
  • Supported governed analytics workflows.
  • Connected to automated Power BI reporting.
SQL ENGINE ACCOUNTABILITY

CCMR Classification Engine

TEA-aligned accountability logic for CCMR buckets and IBC tier classification.

> Resume Match

  • Built bucket assignment logic.
  • Classified IBC tiers.
  • Supported weighted accountability calculations.
PYTHON DEPLOYED

SDR Sorter

Python/Tkinter desktop tool for routing STAAR, TELPAS, and EOC files.

> Resume Match

  • Automated assessment file processing.
  • Reduced manual sorting time.
  • Improved consistency and file routing accuracy.
SQL SERVER WAREHOUSE

PeopleSoft Data Warehouse

ETL packages importing 79 extracts into SQL Server.

> Resume Match

  • Loaded structured extracts from two PeopleSoft databases.
  • Supported SSRS and SharePoint-integrated reporting.
  • Enabled institutional compliance reporting.
POWER PLATFORM DEPLOYED

Power BI Phone Directory

Mobile-friendly staff phone directory embedded in Microsoft Teams.

> Resume Match

  • Used Power Automate and Power Apps.
  • Exported Mitel Connect Director data.
  • Surfaced directory in Power BI with print/download options.

> CAREER TIMELINE

Experience Path

Director of District Data Analytics

Ector County ISD · Data platforms, Power BI, SQL pipelines, accountability reporting.

Chief Technology & Information Security Officer

Eastern New Mexico University - Ruidoso · Infrastructure, security, Power BI, automation.

System Analyst II

University of Texas Permian Basin · SQL Server warehouse, SSIS, SSRS, SharePoint BI.

Programmer Analyst / Network Communications Specialist

Odessa College · ERP systems, reporting, UniData, automation, SQL processes.

Signal Support Specialist

U.S. Army · Communications systems, technical training, readiness documentation.