Experience

Teleion

• United States
• IT Services and IT Consulting
• 100 - 200 Employee

• Sr. Data Analyst

  • Jan 2018 - Present

  Seattle Data infrastructure and management • Provided ad hoc data import/export and transformation using T-SQL for Azure, Bing Ads, and Amazon clients • Delivered quality assurance of analytic source data, defect mitigation, database migration, and source auditing • Developed stored procedures to extract data for reports rendered in Power BI, Tableau, and QuickSight • Produced and maintained look-up tables Analysis reporting and alerting • Leveraged Excel and Power BI to generate… Show more Data infrastructure and management • Provided ad hoc data import/export and transformation using T-SQL for Azure, Bing Ads, and Amazon clients • Delivered quality assurance of analytic source data, defect mitigation, database migration, and source auditing • Developed stored procedures to extract data for reports rendered in Power BI, Tableau, and QuickSight • Produced and maintained look-up tables Analysis reporting and alerting • Leveraged Excel and Power BI to generate automated revenue and acquisition performance views for 10+ marketing stakeholders • Use of Microsoft Flow Power BI and QuickSight to automate alerts to proactively inform stakeholders of significant performance changes • Followed GDPR and email compliance for monthly and quarterly marketing campaigns across global markets PM/Admin • Determined business questions and objectives to produce more strategic and insightful analyses • Monitored workflow; tracking tasks through completion and making timeline adjustments as needed • Trained in agile/scrum methodologies Compliance/auditing • Experienced in mapping to controls of different frameworks (ex: ISO, Fed Ramp, and SOC) • Participated in external customer audits for Microsoft Azure & M365 global banking customers • Created Azure DevOps infrastructure for tracking audit observations from identification through remediation Show less



HackerAgency

• United States
• Advertising Services
• 100 - 200 Employee

• Business Analyst

  • Nov 2016 - Dec 2017

  Greater Seattle Area • Acquired the responsibilities of two business analysts without missing client deliverables and expectations • Improved upon existing reporting methods to better serve client needs and cut reporting time by 50 percent • Ad hoc ETL query development for visual sales attribution, resulting in a 25 percent decrease of cost per response • Maintained reporting databases and updated lookup tables on a monthly cadence • Identification of key performance metrics and strategies that lead… Show more • Acquired the responsibilities of two business analysts without missing client deliverables and expectations • Improved upon existing reporting methods to better serve client needs and cut reporting time by 50 percent • Ad hoc ETL query development for visual sales attribution, resulting in a 25 percent decrease of cost per response • Maintained reporting databases and updated lookup tables on a monthly cadence • Identification of key performance metrics and strategies that lead to a 20% reduction in cost per conversion • Established documentation to formalize report creation and delivery for 3 health care clients • Provided client facing presentation decks for analysis of both direct mail and digital media campaigns • Maintained and delivered reporting dashboards to drive insights and optimization in Tableau • Subject matter expert and point of contact for all healthcare reporting and HIPPA compliance with dashboarding • Query debugging and quality assurance of disparate data sources according to ISO 27001 and GDPR standards

• Data Analyst

  • Jun 2015 - Oct 2016

  Seattle Execute data extraction, transformation and loading with T-SQL. Provide ad hoc data import and data export requests. Use of Excel, Power Query and Tableau to streamline and automate manual tasks. Responsible for data quality of all incoming client data files and associated processing instructions. Built and presented campaign financial report cards using Power Query, Power Bi and Tableau. Coordinating technical teams in processing the data per customer instructions. Performed quality assurance… Show more Execute data extraction, transformation and loading with T-SQL. Provide ad hoc data import and data export requests. Use of Excel, Power Query and Tableau to streamline and automate manual tasks. Responsible for data quality of all incoming client data files and associated processing instructions. Built and presented campaign financial report cards using Power Query, Power Bi and Tableau. Coordinating technical teams in processing the data per customer instructions. Performed quality assurance of outgoing work. Developed data quality and data assurance documentation within all healthcare projects.



Washington State University

• United States
• Higher Education
• 700 & Above Employee

• Database Development Assistant - Office of Commercialization

  • Jan 2015 - Jun 2015

  Pullman, WA Assisted Database Administrator with the transition of over one million gifts and donor records to Salesforce using Excel and T-SQL. Merged and updated commercialization databases with that of databases from other university colleges. Project supported initiative to implement a university wide system to coordinate and assist with Grants, Gifts and Patents.

• Jr. Data Analyst - TRiO: Student Support Services

  • Aug 2013 - Jun 2015

  Pullman, WA Merged staff data marts using Microsoft Access to create comprehensive database of students, thereby improving program goal setting. Consulted staff and user concerns to redesign program website resulting in streamlining of time intensive tasks, and better counselor-student communications.

• Teaching Assistant

  • Jan 2013 - May 2014

  Pullman, WA Assisted professor with development of multimodal teaching resources. For class of 250 students used video editing software and other video-based techniques to enhance lecture format.



Apollo Mechanical Contractors

• United States
• Construction
• 400 - 500 Employee

• Project Intern

  • May 2013 - Aug 2013

  Kennewick, WA Worked directly with project managers and various project engineers involved with the assembly of a data center for “Yahoo!”. Visually inspected and kept accurate records of all incoming materials. Built and kept inventory of plumbing materials on database software. Worked hands on with the project managers and the division director from the Intel corporation job site to share knowledge across job sites. Presented capstone project to leadership on project development and Internship learnings.