Amelia Lee

Experience

1. Quality Assurance Analyst

   Arrowhead General Insurance Agency, Inc.

   Jun 2020 — Present · San Diego, CA, US

   Runs tests/queries to verify database and UI changes for a library of 2k+ SQL stored procedures (data feeds, alerts, reports, payment processing)- Debugs and configures automation test cases via Excel and scripts for changes to the systems, regression testing. Experience with server upgrades - American Claims Management QA: Worked closely with database developers to test feeds, payments, split risk insurers, claims system - Core Commercial QA: Tests rate changes, forms, non-renewal project upon program closure, software workflows between 3 different systems for renewals (Quicksolver/Instec, Arrowhead Exchange, Innovation)- Dynamics CRM QA: Tests development of new CRM system (fields, data mapping, defining workflows)- Database Developer Part Time: Updated and created stored procedures for alerts and reports. Developed SSRS reports that calculate premium changes in policy transactions and utilize data manipulation language. Created SSIS packages that load tables weekly and monitored failures. Worked on decoupling project - verified 80 SP’s were properly decoupled from the linked servers and functioning efficiently on our servers.

Education

• University of California San Diego

  Bachelor of Science - BS

  2016 — 2020

• The American University of Rome

  Mathematics and Architecture

  2018 — 2018

• UC San Diego Extended Studies

  Certificate

  2019 — 2024