Open to opportunities

Amanda Wilson

@amandawilson

Message

I build reliable data pipelines, reporting, and database modernization solutions.

United States

Message

At Zurich Cover-More, I modernized 35+ legacy SSIS ETL packages for SQL Server 2022, helping keep the AIG-to-Zurich enterprise migration on schedule. I also enhanced 30+ SSRS reports and developed SQL updates that supported uninterrupted policy sales across 20+ countries and five major airline partners.

Previously at AIG Travel Guard, I transformed hundreds of millions of XML quotes and purchases into normalized Snowflake tables, optimized production ELT queries, and improved downstream data quality. I’ve also built PowerShell deployment automation, supported enterprise data governance in Collibra, and delivered Tableau analytics for vendor spend and financial oversight.

Experience

Work history, roles, and key accomplishments

Database Developer

Zurich Cover-More

Dec 2024 - Jul 2026 (1 year 7 months)

Modernized 35+ legacy SSIS ETL packages for SQL Server 2022, enabling the AIG-to-Zurich migration to stay on schedule. Developed SQL scripts for dimension table updates and enhanced 30+ SSRS reports for Accounting and Claims.

SQL SSIS SQL Server ETL CI CD TFS Version Control

Database Developer

AIG | Travel Guard

Aug 2023 - Nov 2024 (1 year 3 months)

Engineered a transformation to parse hundreds of millions of XML quotes and purchases into normalized Snowflake tables, closing a five-year data gap. Optimized 25+ SQL queries to reduce warehouse compute consumption and improved data quality by tracing duplicate and missing records.

SQL Snowflake ELT data transformation Data Quality Documentation

Technology Analyst Program Rotational Analyst

AIG

Jul 2021 - Aug 2023 (2 years 1 month)

Developed reusable PowerShell automation to generate SQL deployment scripts, tripling delivery capacity for database modernization releases. Rescued a stalled recertification for 13K shared mailboxes and advanced Collibra configuration through cross-functional sessions.

PowerShell SQL Automation Collibra Power Automate Data Governance

Analyst Intern

The Resource Group at Ascension

Jun 2020 - Aug 2020 (2 months)

Led a four-member intern team to standardize 100+ facility addresses into coordinates using R and a geocoding API. Replaced Excel-based analysis with an interactive Tableau dashboard for 200+ vendors and prepared monthly variance analyses against a $27M budget.

R Tableau Data Analysis geocoding Excel Financial Analysis