Resume

Sign in

Data Analyst Power

Location:
Everett, WA
Posted:
May 11, 2020

Contact this candidate

Resume:

Karen F. Schaefer

adc595@r.postjobfree.com 206-***-****

http://www.linkedin.com/pub/karen-schaefer/63/779/747

Qualifications Profile

Solutions-oriented Data & Power BI Analyst with proven expertise analyzing various large datasets for the e-commerce, healthcare, aerospace, financial, and telecommunication industries for over 25 years.

Proven qualifications in data modeling, analyzing requirements, planning, designing and implementing innovative database solutions that meet or exceed challenging business needs.

Designed, developed and implemented Power BI Dashboards, Scorecards & KPI Reports.

Project Lead accountable for providing strategic and tactical leadership to ensure full project life cycle design, development and implementation of database solutions.

Software development life cycle (SDLC): from initial feasibility analysis and conceptual design through testing and documentation.

Designed, developed and implemented test plans, user documentation and completing projects on schedule.

Combined expertise in strategic planning with strong technical qualifications. Strength in developing projects planning, tracking and reporting strategies.

Interface effectively with clients, team members and management.

United States Air Force Veteran – served for 5 years, honorably discharged

Core Competencies:

Power BI (Business Intelligence)

Project Lead

Design of Dashboards, Scorecards & KPI Reports

Requirements Analysis, SME

Data Analysis & Modeling

Data Mining, Migration & Consolidation

Complex Excel Spreadsheet Development

Visio diagrams

Data Visualization

ODBC, OLAP, OData, OLEDB Connectivity

Project Planning & Monitoring

Database Design & Development

Software Development Life Cycle(SDLC)

Test Plan Documentation

Agile Philosophy

Technical Background

Databases:

SQL Server, SSIS, MS Access, Oracle

Languages:

DAX, SQL, PLSQL, TSQL, MySQL, VBA, ODBC

Software:

Power BI, Excel - Power Pivot & Power Query, Data Models, BPMN

Professional Experience

Amazon.com (Amazon.com -TAM Cross Functional/Sellers Support) - Collabera (1-month Contract) Dec 2016-Jan 2017

Data Analyst

- Responsible for business intelligence reporting, dashboards & SQL queries, Excel 2013 design of ADHOC reports.

QuoteWizard.com (full-time (laid off)) April 2016-Aug 2016

Power BI Data Analyst/Financial Operations

- Responsible for financial Power BI reporting, Dashboards & Scorecards (KPI), SQL queries, Excel 2016 design & development of an Invoice system. Web Queries, VBA Developer, Business processes documentation.

Consultant - Power BI/Sr. Data Analyst/ Project Lead May 2013-April 2016

Created Power BI visualization of Dashboards & Scorecards (KPI) for Finance Department

Designed and implemented a Monthly Resource Allocations system using Excel Power Query & Power Pivots to be included in dashboard reporting.

Assisted Supply chain analysts with automating reporting functionality using Power BI tools (Power BI reporting, Dashboards & Scorecards (KPI) and MySQL, AWS & Data warehouse data sources.

Analyzed business requirements, created business/process flow charts, database flow charts and reporting tool database for Research Revenue Management tracking for Expedia.

Manage Departmental Reporting systems, troubleshooting daily issues, and integrating existing Access databases with numerous external data source including (SQL, Excel, & Access).

Documented the re-design of queries that were to be converted to SSIS

Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in house metrics.

Scorecard ADHOC development of SQL to Excel dashboards, charts, graphs, and Pivot tables.

For the following agencies:

Gilsbar, Inc.- OneSource Services (2016)

Bridge Partner Consulting - Volt (2016)

Amazon.com (SCCA –Supply Chain) - Aditi Staffing (2015)

Expedia.com -Tapfin-Manpower Group (2014-2015)

Ericsson @ AT&T-Apex Systems (2014)

Thyssen-Krupp Aerospace - Robert Half Technology (2013)

Boeing Corporation - PDS Technical Services (7 years Contract) Aug 2006-May 2013

Project Lead/Business/Data & Database Analyst

- Created documentation and reversed engineered existing Access Databases to consolidate and automate the databases. Integrated numerous external data source including (Oracle, SQL, MS Office products)

- Acted as Subject Matter Expert (SME) for the AGILE team on the redesign of the Access databases to Oracle web-based system.

- Documented business, process and data flow documentation on multiple data systems

- Designed Data models on multiple database systems

- Customer support, troubleshooting and modifying databases to meet the customer’s requirements.

- Developed multiple databases that have saved time and money for the various organizations.

Key Project Achievements:

Improved an Oracle database download process from Access and improved running time from 12 hours to 30 minutes.

Designed and developed Employee’s Training database system that exported data to an on-demand excel spreadsheet., this new system improves processing time form 30 days to 30 minutes a month.

Improved, redesigned, and maintained 100’s of individual Access databases which tracked work statements & work load for testing of instrumentation of aircraft within Boeing Instrumentation Flight Test.

Education / Training

o Power BI – Pragmatic, Inc.

o Certificates in Oracle 10g PL/SQL, Understanding RDBMS & SQL Fundamentals Global Business Solutions

o Certificates in SQL, Triggers, Functions & Stored Procedures Global Business Solutions

o Certificate in Database Design & MS SQL 7.0 Bellevue Community College

o Certificate in Visual Basic 6.0 North Seattle Community College

o Microsoft Office Specialist Certification Smart Force

Courses towards Bachelor of Arts Degree in Education; Minor in Communication



Contact this candidate