RESUME OF KAREN AMUNDSON

Career Summary:

Looking for a BSA, Team Lead or Data Analyst contract position due to my strong background in business analysis, database administration, data analysis, data modeling and team/project management. My capabilities for merging business needs with technical solutions via a positive, team-oriented approach have resulted in applications that are designed to enable future growth and support reporting and analysis needs. I have successfully led teams in data warehousing and OLTP application development projects.

Specific expertise in:

•Requirements gathering, creation of scope, process and data models, MDM, rules and use cases

•Database administration and/or reporting per queries on Teradata, Oracle, Netezza, DB2 and SQL Server

•Design of software applications and of data warehouses for decision support and performance optimization

•Development of Project Plans, Process Flows, Source to Target Mappings, Standards / Procedures, Entity Relationship Diagrams, Data Dictionary and Metadata; Conceptual, Logical and Physical Models

•Presentations using Excel – with charts and pivot tables, PowerPoint and other methods

•Personnel supervision and project team lead

•Ability to bridge the business and IT realms via excellent verbal and written communication

•Information Systems Plan (ISP) development; project plans and time/$ estimates of work

•Enterprise data architecture, to include globalization and integration of diverse data sources

•Strong SQL, most recently on Teradata, Oracle, Netezza, and SQL Server databases

•Data conversion specifications and implementation; data cleansing and integrity

•Conceptual, logical and physical data design, 3NF or Dimensional, ErWin, ERStudio and Power Designer

•Selection of database vendors; ETL (extract/transform/load), reporting, and data design tools

•Exposure to Informatica, Business Objects, Tableau, MongoDB, Hadoop, AGILE, and ArcGIS

•Excellent analytical and problem solving skills, working independently or on teams

•Experience in financial brokerage, payments, marketing, petroleum management, airline applications, aviation, utilities, telecom, insurance, cable-internet-phone, satellite TV, government land management, and conferencing solutions

Professional Experience:

NV5 buys Quantum Spacial / BLM Sept, 2021 - June, 2023

Business and Data Analyst work within the Data Resource Team at the BLM

•Data design and governance with GIS datasets on the Grazing and Energy Project. This includes:

- Potential Fossil Yield Classification - analysis to load hundreds of geologic maps for 8 states

- Water Wells - analysis to document a Geocortex application for possible future rewrite

•Data and domain design for feature classes to keep inventory on Shooting Ranges

•Data design using ER Studio for the National Scenic and Historic Trails and for RECS 2.0

Sanborn Map Company / BLM Nov, 2020 - Sept, 2021

Business and Data Analyst work within the Data Resource Team at the BLM

•Data design and governance with GIS datasets on the Grazing and Energy Project. This includes:

- Application for Permit to Drill - guiding the GIS merge of national, state office and field office data

- Potential Fossil Yield Classification - doing the schema and specification to load geologic maps for Florida

- Oil and Gas Wells - leading schema development for 5 feature classes and tracking load issues to be fixed

Boeing / Jeppesen Feb, 2019 - Apr, 2020

Systems and Data Analyst work within the Data Architecture group

•Did requirements gathering/documentation and collection of metadata on hundreds of applications

•These are the projects that were involved:

•Cloud Data Hub - gathered requirements for putting data from AHM (Airplane Health Management), ADW (Analytics Data Warehouse), and ARMS (Aircraft Reliability and Maintainability System) into the Azure Cloud for use by SSA (Self Service Analytics).

•Portfolio Data Map - identified Subject Matter Experts and set up meetings to obtain aviation metadata information on over 270 Applications within 9 Portfolios.

•Provided recommendations to the Analytics and the Integration Work Groups.

WOW! (Wide Open West) Feb, 2018 - Jan, 2019

Business and Data Analyst work within the Data Warehousing group (BIANQA)

•Handled business and data analysis, dashboard design, requirements and mapping documentation, and led various people through design, development, QA and moves to Production within an Agile environment

•These are the projects that were involved:

•Sales Flash Dashboard (Tableau) - displayed numerous metrics involving New Connects, Call Center, Door-to-Door, and Headcount and Productivity

•Worker data cleanup to improve information on Employees and Contractors

•Call Center Sales Dashboard (Tableau) - coordinated the design and display of numerous metrics on 3 tabs, from Calls Handled and Sales to Connects and Products; numerous filters and a strong hierarchy with Locations, 2 levels of Managers, and Sales Reps; data from 2 billing systems and several employee sources and IVR

•Budget and Forecasting data capture for tracking against Sales Flash data

Charles Schwab Dec, 2015 - May, 2017

Business Systems Analyst work within the Data Warehousing group (GDT)

•Handled business and data analysis, logical modeling on ErWin, occasional project management and cost estimation, and led various people through design, development, User Acceptance Testing and moves to Production within an Agile environment with documentation and tracking in JIRA.

•These are the source systems that were involved:

•American Express Credit Card - application and status tracking

•Lynx replacement with Salesforce dot com (SFDC) – primary and foreign key modifications, source file changes, and major testing

•Schwab Intelligent Advisory (SIA) – in-house Financial Planning data, TimeTrade Appointment (third party vendor) data, and over 20 tables in a Money Guide Pro set of vendor software information collected from individual investors and advisors.

•Yodlee Held-Away Account and Position information along with aggregation of that data

Dish Network May, 2010 - Nov, 2015

Staff Data Analyst

•Handled data analysis, architecture and design, DFD’s and STM’s for a Receiver Connectivity data mart which supports numerous reports and commission payments

•Numerous data analysis activities for the Enterprise Data Warehouse conversion on a CSG Billing Transformation project, including a very involved Deployment Plan for Teradata and Netezza; led 7 system tests to insure a good Go Live

•Implemented a 3rd Party Vendor’s software involving a data migration and 4 encrypted daily files to support activities at 8 collections agencies; this increased Dish revenue by $2.7 million per month and decreased legal issues by 70%

•Managed the project intake/initiation for the Data Warehouse with gathering of LOE’s from 5 groups

•Guided defect tracking and resolution on the Customer 360 initiative

•Handled the addition of census and programming usage data in Teradata for Aprimo and the Marketing teams.

CONNECT The Knowledge Network Dec,2009-Mar,2010

Sr. Consultant

•Business and data analysis related to multiple OBIEE projects

•ErWin was used to reverse engineer production and development environments, including numerous Subject Areas and a Business Dimensional Model

Western Union / First Data Corporation 1997-2008

Business Analyst for Consumer Modeling and Analytics Nov, 2004 - Nov, 2008

•Advised several marketing teams via reports using Customer Relationship Management (CRM) data

•Handled the statistical analysis of customer, loyalty card and transaction information to measure trends and effectiveness of marketing campaigns and new product introduction

•Specific projects included:

•Analysis of migration patterns of Brazilians and Central Americans to New Orleans after Hurricane Katrina to better understand the movement of customers

•A compilation of more than 30 Direct Marketing Campaign ROI reports to measure incremental lift; development of visual charts to compare larger initiatives to similar control groups

•Demographic analysis of ethnic groups, including US senders to various countries to better target marketing campaigns and understand the profitability of those corridors

•Inputs for data cleansing and aggregate tables to speed the data access and accuracy

•A comparison of the Western Union, Orlandi Valuta and Vigo brands in the money transfers from the US to Mexico including detailed geographical and agent segmentation

•Coached an offshore resource in India to successfully complete 8 projects in less than 2 months for 3 Marketing groups.

Western Union / First Data Corporation Aug, 2000 – Nov, 2004

Senior Data Analyst

•Handled the data design and administration involving coordination between Project Managers, Programmers, Database Administrators and Clients

•Application data design for the Inventory Create and Update System, Payment Services Information System, Cashtax Enrollment, Dashboard and others

•Used Dimensional Modeling for Data Warehouses and 3rd Normal Form on OLTP systems

•Requirements definition and third party software analysis for the Merger Integration department

•Led a team of DBAs on the Dashboard data warehouse project in data design, tool selection - Informatica and Business Objects - and ETL strategy and development; used the Kimball Lifecycle methodology for data marts with fact, dimension, and aggregate tables

•Vendor selection for the Western Union Customer Database

•Organization of a four day seminar on enterprise data topics for 70 FDC employees from five locations

•Received a First Data Collaboration award in 2003 for managing this successful event

Western Union / First Data Corporation Apr, 1997 – Jul, 2000

Senior Database Administrator

•Database design and implementation for the Electronic Federal Tax Payments System, an application that moves more than $4 trillion annually to the IRS, has over 200 large tables and data replicated across 3 IBM mainframes

•Experience supporting over 100 developers on this large project

•Selection of the Power Designer data modeling tool to capture logical and physical metadata

Cap Gemini America Aug, 1993 - Apr, 1997

Senior Consultant

•Provided database design and administration support and consultation to a variety of clients

•Created an Information Systems Plan at Total Petroleum

•Administered DB2 databases at Public Service Company (now Xcel Energy)

•Provided analysis and data design at Lee Company in Kansas City

•DB2 database administration at First Data Corporation

Total Petroleum Jul, 1988 - Jul, 1993

Database Administrator

•Production database design and administration to support the acquisition and movement of petroleum products from their source through their eventual sale at retail outlets

•On call support and release upgrades for 3 DBMSs, query tool administration, disaster recovery testing, and performance tuning

•Led data design and conversion specifications for 2 data marts to help business users optimize the trucking and pipeline movement of petroleum among wells, refineries and storage facilities

Cap Gemini America Mar, 1987 - Jul, 1988

Senior Consultant and Technical Services Manager

•Provided senior level support on IT projects for several clients, and served as an internal administrator for other consultants at Cap Gemini

•At Mountain Bell (became Qwest and now Century Link), did data administration, designed DB2 tables and handled conversion responsibilities on a Carrier Subscription System development project

•Led 4 programmers on the NPA Split project, which renumbered some of the 303 area code's territory to have 719 numbers

•Administrative management of 10 consultants

Education & Training:

Bachelor of Science in Mathematics, Minor in Computer Science At Texas Tech University in Lubbock, Texas

2 classes in 2008 at University of Colorado at Denver in the Masters of Engineering, GIS Program

The Data Warehousing Institute (TDWI)

Technical and Business Methodology Classes & Seminars

Joint Application Design (JAD) Facilitator Skills

Business Process Reengineering (BPR)

Database Administration and Design

Project Management Skills

Contact At: 303-***-**** or ad4bqy@r.postjobfree.com

Contact this candidate