Alexander Hauskrecht, Developer in 德国巴登-符腾堡州斯图加特
Alexander is available for hire
Hire Alexander

Alexander Hauskrecht

Verified Expert  in Engineering

数据质量开发人员

Location
德国巴登-符腾堡州斯图加特
Toptal Member Since
March 4, 2020

Alexander has over 20 years of experience in data warehousing in different environments and roles (maintenance, development, administration, test, SWOT-analysis) using several tools (from hand-coded to enhanced ETL tools) and paradigms. He's experienced with historization in DWH and has professional experience with banking and insurance.

Data Modeling数据仓库设计Data WarehousingSASSQLETLData QualityIBM Db2JasperReportsJavaAb InitioMicrosoft Power BIApache HiveLinuxOracleBase SAS

Portfolio

Bausparkasse Schwäbisch大厅
Ab Initio图形化开发环境(GDE)...
Finanzinformatik,明斯特
z/OS, SAS, JointJS, Elasticsearch
省西北，d - m - nster
SAS商业智能(BI), Data Modeling, ETL, SQL, 数据仓库设计...

Experience

SQL - 20 yearsSAS - 20 yearsETL - 15 yearsIBM Db2 - 6 yearsPentaho数据集成(Kettle) - 5年JasperReports - 5年数据质量- 2年Ab Initio - 2 years

Availability

Part-time

首选的环境

JasperReports, Pentaho数据集成(Kettle), Ab Initio, SAS Data Integration (DI) Studio, SAS

The most amazing...

...项目为业务用户提供了自助服务, regulatory compliant, 在多个数据集市中调整数据的可靠过程, 分配资讯科技资源.

Work Experience

ETL Developer

2022 - PRESENT
Bausparkasse Schwäbisch大厅
  • Developed and maintained risk data marts and added new data sources.
  • 管理和监控测试系统的负载过程.
  • 用ETL流程替换手动数据源/流程.
技术:Ab Initio图形化开发环境(GDE), Sybase PowerDesigner, Oracle, Automic (UC4)

Consultant

2021 - PRESENT
Finanzinformatik,明斯特
  • 咨询公司在BCBS 239和数据质量方面有工作吗. Developed a data dictionary and data lineage tool for a legacy SAS data warehouse.
  • 对数据质量工具的选择进行了初步研究.
  • 就地址为BCBS 239的遗留数据仓库进行了咨询.
技术:z/OS, SAS, JointJS, Elasticsearch

发展商及顾问

2013 - PRESENT
省西北，d - m - nster
  • Selected and de-identified test data for all non-production environments. Built a framework for metadata-driven selection and de-identification of production data. 来自不同主机存储系统的1000多个数据源.
  • Stabilized processes, 源数据集成, sas93—迁移数据和批处理程序, and optimization of run-processing to support the Business Intelligence Center.
  • Consulted on the architecture for an SII data mart and implementation of ETL programs for the Solvency II project.
  • Implemented generic auditing and accepted the application for the adjustment of data in data marts, 使用快速编辑作为数据输入工具.
  • Designed and implemented an application for calculating bonuses for field service. 使用SAS EG进行计算，JasperReports进行报告.
技术:SAS商业智能(BI), Data Modeling, ETL, SQL, 数据仓库设计, Data Warehousing, Erwin, JasperReports, z/OS, IBM Db2, SAS Macros, SAS Enterprise Guide, SAS Data Integration (DI) Studio

发展商及顾问

2020 - 2021
慕尼黑拜仁信用卡服务公司
  • Developed form letters using JasperReports to be called from a given application.
  • 回顾并检查了使用Jasper的选项和最佳实践.g. 将标准文字外部化以降低维护工作).
  • Taught internal staff using Jaspersoft Studio to maintain and build new form letters.
技术:JasperReports

Tester

2020 - 2020
德国Informationsfabrik GmbH
  • 在银行的数据仓库项目中建立了一个测试流程.
  • Built a framework for automated tests of data with the option to enhance this as a data quality framework.
  • 与开发人员协商编写自动和手动测试.
  • Integrated automated test into the loading process using Data Factory Pipelines.
Technologies: SQL, Data Warehousing, 数据仓库设计, Microsoft Power BI, Azure DevOps, Test Automation, Azure Data Factory, Pipelines, T-SQL (Transact-SQL), Microsoft SQL Server, Azure

业务分析师和ETL开发人员

2018 - 2019
Bausparkasse Schwäbisch大厅 (Building and Loan Facility), D-Schwäbisch Hall
  • 与数据所有者一起开发和实现数据质量规则.
  • Improved communication between IT and business concerning the DQ framework.
  • 帮助稳定DQ框架并使其更加灵活.
技术:数据建模, Oracle RDBMS, Data Quality, ETL, SQL, 数据仓库设计, Data Warehousing, Sybase PowerDesigner, Oracle Database, Ab Initio

Software Architect

2017 - 2018
W&W(建筑、贷款和保险)，d -路德维希堡
  • Reviewed and refined the system architecture for a marketing data mart.
  • Created performance tests of DB2 BLU specifics and PoC for the performance of a data vault data model.
  • 为历史记录实现了一个高性能组件.
技术:SAS商业智能(BI), Data Modeling, ETL, SQL, 数据仓库设计, Data Warehousing, Apache Hive, IBM Db2, SAS

Developer

2016 - 2017
BLB(联邦国家银行)，d - m_nchen
  • 将遗留程序从SAS Base迁移到SAS DI. 重新设计并记录逻辑. 已执行的并行测试.
  • 重新设计给定的通用规则，以适应新主题的使用.
  • 实现了增强的通用规则集.
技术:SAS商业智能(BI), ETL, SQL, 数据仓库设计, Data Warehousing, Linux, IBM Db2, SAS Macros, SAS Data Integration (DI) Studio, SAS

Consultant

2012 - 2013
Vattenfall(电力供应商)，D-Hamburg
  • Provided consulting and support during the implementation of data marts for risk management concerning design, tool usage, administration, and run.
  • Led historization using SCD-Transformation and a customer specific historization transformation.
  • 支持有关数据集市测试的业务单位.
Technologies: ETL, SQL, 数据仓库设计, Data Warehousing, AIX, Oracle, SAS Enterprise Guide, SAS商业智能(BI)

Consultant

2012 - 2012
gm(健康保险)，D-Schwäbisch gm nd
  • 建立营销数据集市，专注etl开发.
  • 完成维度数据集市的数据建模(星型模型).
  • 优化了Pentaho DI作业和转换的性能.
技术:数据建模, ETL, SQL, Data Warehousing, 数据仓库设计, AIX, IBM Db2, Pentaho

Consultant

2010 - 2012
省级西北，d - mnster(保险)
  • 扩展和标准化现有DWH系统.
  • Helped design and set up processes to build a new DWH system (architecture, historization, adjustment etc).
  • Built a historization component with up to three (depending on the business area) historization dimensions. Focused on performance optimization (SAS <=> DB2).
技术:SAS商业智能(BI), Data Modeling, ETL, SQL, 数据仓库设计, Data Warehousing, z/OS, IBM Db2, SAS Macros, Base SAS

Consultant

2010 - 2011
联邦国家银行，d -斯图加特
  • Consulted, designed, and implemented a data mart for centralized regulatory reporting (AWV).
  • Wrote IT concepts for the integration of source systems and the transformation of data.
技术:SAS商业智能(BI), ETL, SQL, 数据仓库设计, Data Warehousing, AIX, SAS Enterprise Guide, Base SAS

Consultant

2010 - 2010
Versorgungswerk der Architekten, D-Stuttgart
  • Migrated an existing reporting system (Cobol, Prescribe) to JasperReports.
  • Led a feasibility study to check if the migration can be done within the given budget.
  • Migrated existing reports to JasperReports, and built a a generic Java Wrapper for batch reporting.
技术:Java、JasperReports

Consultant

2008 - 2010
联邦国家银行，d -斯图加特
  • Designed and developed of ETL processes in the credit risk data mart (GLLP, IFRS-Reporting).
  • Implemented a generic process for self-service data adjustment in the data mart.
  • Designed and implemented a dynamic job scheduling driven by delivery of extracts from source systems.
技术:SAS企业指南，SAS

快速控制-自动数据测试工具

http://www.ara-tec.com/fast-control
构建了一个自动测试数据的工具.

描述数据和测试用例，并运行它们. The first implementation was SAS-based (SAS EG) and used Microsoft Excel for data entry. The second implementation used Java, Tomcat, and SQL using Fast Edit as the front-end.

Adjustment of Data

Built a tool to adjust data in several stages of a data warehouse system (derived area and data marts). It's used as a self-service tool by businesses without IT participation but still adheres to regulatory requirements.

Uses Apparo Fast Edit as data entry and a generic SAS macro for the implementation.

DWH分级层的历史、写入和提取模块.

The Task:
Find a way to store daily delta data in the staging layer of a data warehouse and historize it.

Problems:
历史化必须在几个版本中实现, depending on the source system (no historization or 1 to 3 dimensions).
—每个源系统由1到20个表/实体组成.
- DB2 is used as a storage layer, ETL is done with the SAS foundation.

The Solution:
- Build a metadata-driven generic historization and storage macro in SAS, handling
- Historization (or no historization) in a central historization table per source system.
- Optimize historization and read/write between SAS and DB2 using push down techniques (DB2 temporary tables, Push Down SQL).
—使用DB2 Load功能将增量行写入DB2.
-在SAS处理中构建一个元数据驱动的通用提取宏
- Extract all tables of a source system in the storage layer for a given time interval
—添加历史记录信息
构建数据仓库图像数据质量过程出版物
Publication

构建数据仓库数据质量流程

http://business.microbladingtrainingcourses.com/database/data-warehouse-data-quality-process

Languages

SAS SQL Java T-SQL (Transact-SQL)

Paradigms

ETL，测试自动化，Azure DevOps

Other

数据仓库设计, Data Warehousing, Data Modeling, COBOL Batch, Data Quality, SAS Macros, Base SAS, Pipelines, Azure Data Factory, JointJS, 图形化开发环境(GDE)

Libraries/APIs

JasperReports

Tools

Pentaho数据集成(Kettle), Microsoft Power BI, SAS Data Integration (DI) Studio, Sybase PowerDesigner, SAS商业智能(BI), SAS Enterprise Guide, Erwin, Ab Initio, Automic (UC4)

Storage

IBM Db2, Oracle RDBMS, Apache Hive, Microsoft SQL Server, Elasticsearch

Platforms

Oracle数据库，Linux, Oracle, AIX, Pentaho, z/OS, Azure

1988 - 1992

工商管理硕士学位

fuer Wirtschaft -普福尔茨海姆，德国

JULY 2016 - PRESENT

专业Scrum Master I

Scrum.org

JULY 2012 - PRESENT

SAS认证数据集成开发人员SAS9

SAS

2009年2月至今

Prince2 Foundation

APM Group

2009年2月至今

ISTQB认证测试员基础水平

Cert Insitute

有效的合作

如何使用Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

开始你的无风险人才试验

与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.

对顶尖人才的需求很大.

Start hiring