Karen F. Schaefer
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
Power BI (Business Intelligence)
Design of Dashboards, Scorecards & KPI Reports
Requirements Analysis, SME
Data Analysis & Modeling
Data Mining, Migration & Consolidation
Complex Excel Spreadsheet Development
ODBC, OLAP, OData, OLEDB Connectivity
Project Planning & Monitoring
Database Design & Development
Software Development Life Cycle(SDLC)
Test Plan Documentation
SQL Server, SSIS, MS Access, Oracle
DAX, SQL, PLSQL, TSQL, MySQL, VBA, ODBC
Power BI, Excel - Power Pivot & Power Query, Data Models, BPMN
Amazon.com (Amazon.com -TAM Cross Functional/Sellers Support) - Collabera (1-month Contract) Dec 2016-Jan 2017
- 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