Alexander Hauskrecht
Verified Expert in Engineering
数据质量开发人员
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.
Portfolio
Experience
Availability
首选的环境
JasperReports, Pentaho数据集成(Kettle), Ab Initio, SAS Data Integration (DI) Studio, SAS
The most amazing...
...项目为业务用户提供了自助服务, regulatory compliant, 在多个数据集市中调整数据的可靠过程, 分配资讯科技资源.
Work Experience
ETL Developer
Bausparkasse Schwäbisch大厅
- Developed and maintained risk data marts and added new data sources.
- 管理和监控测试系统的负载过程.
- 用ETL流程替换手动数据源/流程.
Consultant
Finanzinformatik,明斯特
- 咨询公司在BCBS 239和数据质量方面有工作吗. Developed a data dictionary and data lineage tool for a legacy SAS data warehouse.
- 对数据质量工具的选择进行了初步研究.
- 就地址为BCBS 239的遗留数据仓库进行了咨询.
发展商及顾问
省西北,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进行报告.
发展商及顾问
慕尼黑拜仁信用卡服务公司
- 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.
Tester
德国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.
业务分析师和ETL开发人员
Bausparkasse Schwäbisch大厅 (Building and Loan Facility), D-Schwäbisch Hall
- 与数据所有者一起开发和实现数据质量规则.
- Improved communication between IT and business concerning the DQ framework.
- 帮助稳定DQ框架并使其更加灵活.
Software Architect
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.
- 为历史记录实现了一个高性能组件.
Developer
BLB(联邦国家银行),d - m_nchen
- 将遗留程序从SAS Base迁移到SAS DI. 重新设计并记录逻辑. 已执行的并行测试.
- 重新设计给定的通用规则,以适应新主题的使用.
- 实现了增强的通用规则集.
Consultant
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.
- 支持有关数据集市测试的业务单位.
Consultant
gm(健康保险),D-Schwäbisch gm nd
- 建立营销数据集市,专注etl开发.
- 完成维度数据集市的数据建模(星型模型).
- 优化了Pentaho DI作业和转换的性能.
Consultant
省级西北,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).
Consultant
联邦国家银行,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.
Consultant
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.
Consultant
联邦国家银行,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.
Experience
快速控制-自动数据测试工具
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
Uses Apparo Fast Edit as data entry and a generic SAS macro for the implementation.
DWH分级层的历史、写入和提取模块.
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
—添加历史记录信息
Skills
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
Education
工商管理硕士学位
fuer Wirtschaft -普福尔茨海姆,德国
Certifications
专业Scrum Master I
Scrum.org
SAS认证数据集成开发人员SAS9
SAS
Prince2 Foundation
APM Group
ISTQB认证测试员基础水平
Cert Insitute
如何使用Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
开始你的无风险人才试验
对顶尖人才的需求很大.
Start hiring