Data Analyst

ROBERT KOHLHASE

**********@*****.*** Concord, California 94521 415-***-****

CORE COMPETENCIES

Senior Data Analyst, Data Engineer, Systems Analyst, and Database Developer. Experience includes:

Data Analysis (10+ years): SQL in Oracle, Teradata, and other environments; source, staging, data warehouse and data mart layers; data validation, data profiling, data quality, data lineage

Requirements Analysis & Functional Specifications (10+ years): requirements gathering, systems analysis, use cases, Business Requirements Documents (BRDs), dataflow diagrams, functional specification documents, business rules, scenarios

Data Engineering (10+ years): ETL/ELT (extract/transform/load); data pipelines; data integration; data mapping; scripting/automation; technical specifications; stored procedures and user-defined functions, materialized views, MPP environments; tuning/optimization

Development Methodologies (10+ years): agile/iterative methodologies such as Scrum and Kanban, "waterfall" system development lifecycle (SDLC), QA; release planning; deployments; change management

Business Intelligence (BI) (10+ years): Tableau dashboards, data visualization, data marts

Database Design (10+ years): data modeling, entity-relationship diagrams (ERDs) also known as logical database designs, physical database designs, performance tuning

Data Management/Governance (10+ years): Master Data Management (MDM), data dictionaries, data standards, security, privilege/access management, metadata, reference data

Development Tools & Environments: SQL, Toad, PL/SQL, Python, Tableau, ERwin, Oracle RDBMS including v11.2/11g and v12.1/12c; Teradata, IBM Netezza; SQL*Server, Aginity Workbench, Oracle SQL Developer, Linux, Notepad++, TortoiseSVN, GitHub, Jira

General Tools: Windows 7 and 10, Mac OS; Excel, SharePoint, Word, Visio, PowerPoint

WORK EXPERIENCE

(Short projects are grouped or omitted)

Blue Shield of California, San Francisco - Data Analyst / Database Developer (Consultant) 1/2019 to 1/2020

Performed data analysis and database development in healthcare insurance data warehouse environment. Worked with healthcare member, provider, and claims data. Environment: IBM Netezza v7.2, Aginity Workbench, Linux, TortoiseSVN, Jira.

Performed data analysis on source systems, and on staging, data warehouse, and dimensional data mart layers. Created data profiling SQL scripts to research defects, analyze data lineage, and identify data quality issues.

Developed SQL prototypes to refine new logic and establish source data suitability.

Created analysis and design artifacts for changed and new data targets. Reviewed business requirements, documented data transformations, and created/updated Source to Target Mapping (STM/STTM) documents.

Developed/refactored SQL scripts for go-forward ELT loads, historical updates, UIT testing, and deployment.

Wells Fargo & Co., San Francisco - Senior Database Developer (Contractor) 9/2016 to 9/2018

Designed and developed new fact, dimension, and other tables for corporate Human Resources data warehouse. Environment: Oracle v11g and v12c Exadata, Toad v12.8, Erwin 9.7, GitHub, Visio 2013.

Designed and developed new fact, dimension, aggregate, and staging tables. Solutions generally used sophisticated Oracle materialized views to translate data integration structures into presentation-layer objects.

Analyzed and refactored legacy ETL and presentation logic to meet new security and architectural goals.

Developed DBA scripts to install and back-out complex database changes. Managed deployments from development through final go-live in production.

Collaborated with business systems analysts to refine business requirements, and to test and document new features. Worked closely in an agile environment with system architect, production DBAs, ETL developers, and security teams to design solutions and implement new processes and standards.

Made extensive use of Toad and ERwin, for example to perform data profiling, reconcile data structures between environments, and regression-test refactored objects. Created logical and physical data models/ERDs, dataflow diagrams, data dictionaries, and technical specifications.

Apple Inc., Sunnyvale - Senior Data Analyst (Contractor) 1/2015 to 6/2016

Performed data analysis and data quality management in data warehouse environment. The system received data for every iPhone, iPad, and Mac system produced worldwide, in near-real time. Identified, researched and corrected data issues in a dynamic environment. Environment: Oracle v11g Exadata, Tableau v9, Linux/Bash, Python.

Built dashboards and other data visualization and monitoring tools to enhance visibility, insight, and responsiveness for data issues, using Tableau, SQL, PL/SQL stored procedures, Python, and shell scripts.

Did troubleshooting in complex data pipeline involving hundreds of heterogeneous data sources and a complex data ingestion architecture. Monitored the full data flow from data intake to ETL exception management to data integrity in the production tables. Wrote scripts/automation for operations on large data volumes.

Wrote and tuned queries on "big data" data volumes with SQL and procedural scripts. (Data warehouse involved a federation of over 20 Oracle instances. Some tables contained over 40 billion rows.)

Wells Fargo & Co., San Francisco - Data Analyst (Contractor) 7/2012 to 8/2014

Led projects to expand Teradata data warehouse. Supported fraud detection and risk reduction groups in areas including identity theft, account takeover, and identity verification. Environment: Teradata.

Performed data analysis, data profiling, and validation of new data sources, involving both operational data and special-purpose fraud-detection data feeds.

Gathered and documented requirements from subject matter experts and analysts. Determined appropriate data structures, transformations, and data integration process. Wrote metadata.

Wrote database object and ETL technical specification documents/STMs. Collaborated with DBAs and ETL developers to identify and resolve technical, data quality, and change management issues.

San Francisco Health Plan, San Francisco - Systems Analyst (Contractor) 9/2011 to 3/2012

Performed process and systems analysis for a health insurance organization. Environment: SQL Server, Visio.

(Various clients), San Francisco Bay Area (Contractor) 7/2009 to 9/2011

Supported projects in data warehousing and ETL, data management, customer relationship management (CRM), and other areas.

Med-Vantage Inc., San Francisco - Senior Technical Product Manager (Employee) 10/2007 to 7/2009

Managed features for ETL, complex search, data administration, and web analytics within a SaaS suite of health insurance analytics products. Environment: SQL Server, ERwin.

Gathered requirements from customers and stakeholders, created ERDs and process diagrams, and wrote market and product requirements documents (MRDs and PRDs).

Managed product releases. Refined product roadmap, determined release scope; collaborated in planning and estimating, adapted plans to changing conditions, and participated in QA testing and rollout.

(Various clients), San Francisco Bay Area (Contractor) 8/2005 to 10/2007

Supported ventures in web-based customer relationship management (CRM), online role-playing game services, social networking, project management software, and other areas.

GetActive Software, Berkeley - Product Manager (Employee) 5/2004 to 5/2005

Managed features for credit card transactions, fraud detection, crediting, and payment web analytics for SaaS fundraising and CRM product suite. Environment: Oracle, UNIX.

Genentech Inc., South San Francisco - System Architect / Lead Developer (Contractor) 4/1999 to 9/2002

Led project to build custom ETL/MDM application for loading, verifying, managing and analyzing sales and distribution data. Environment: Oracle RDBMS, Oracle Forms, SQL*Loader, Oracle Reports, UNIX.

Designed highly flexible data model and application. Created feature-rich tools for ETL, exception management, and data analysis, greatly raising user productivity.

Gathered all requirements and wrote all functional and technical specifications. Managed five developers.

Earlier positions included SQL database design and development roles at Oracle, Cisco Systems, Charles Schwab, Syntex Pharmaceuticals, and several startups (Employee and Contractor). Environments: SQL, Oracle RDBMS, UNIX.

EDUCATION / OTHER

Education: Bachelor of Arts, San Francisco State University. Graduated Magna Cum Laude, Phi Beta Kappa.

LinkedIn: www.linkedin.com/in/robertkohlhase

Contact this candidate