Alison DeFede

Established a Snowflake data environment and supported the organization's transition to a centralized cloud data platform. Designed data ingestion processes and provided guidance and training.

Design, develop, and maintain scalable data pipelines and workflows using Apache Airflow and AWS MWAA. Build integrations with REST and GraphQL APIs, implement dimensional data models, and manage Snowflake environment.

Maintained and troubleshot Apache Airflow environments, designed and implemented Airflow DAGs, and served as database administrator for PostgreSQL data warehouses on AWS RDS.

Developed and maintained Airflow workflows within AWS MWAA, designed data pipelines for API data ingestion, and automated SFTP reporting solutions. Modeled data for Amazon Redshift and managed migration to Snowflake.

Designed, developed, and maintained an enterprise data warehouse using SQL Server. Developed BI solutions with Power BI and SSRS, and led migration to Azure SQL Server.

Developed and maintained SQL stored procedures supporting enterprise reporting, designed ETL processes, and created reports and dashboards using SSRS and Power BI.

Supported legacy data systems and contributed to the design of new data architecture. Developed Apache NiFi ETL processes and custom reporting solutions using SSRS, Tableau, and Datorama.

Extracted and analyzed data from the university's student information system, performed ETL processes, and developed Tableau reports and visualizations.

Developed scripts for ETL of datasets, provided technical support for ICOM3, and customized databases and SSRS reports based on client requirements.

Developed and maintained SQL stored procedures and SSRS reports, performed ad hoc data analysis, and supported accounting audits.

Master of Science in Information Technology with a focus on Project Management.

Bachelor of Science in Information Science.