Axel Kraus-Data Engineer & Business Analyst
Check rate
Experience
Data Engineer & Business Analyst
Metafinanz
- Migration of existing data jobs from Cognos Data Manager to Tibco/IBI Datamigrator
- Migration data jobs parametrisation for dynamic runs
- Optimisation and cutting-back
- Regression tests
- Knowledge transfer and documentation
Data Engineer
Metafinanz
- Organization, content creation and contract management for SAS training and workshops
- SAS trainings coordination with clients, partners and trainers
- Provision of trainings and workshops in both German and English
Data Analyst & Engineer
Metafinanz
- Analysis of existing data sources including reporting of missing data
- Modelling datapool
- Claims KPI reporting and creating ETL processes with SAS
- Operational controlling definition interfaces to web reporting (Power BI)
- Creating automated jobs
- Knowledge transfer and documentation
Data Analyst / Modeler / Engineer
Metafinanz
- Consulting at tribe Future Work
- Coordination and implementation of employee surveys
- Analytics & PMO: survey design
- Preparing employee core data for survey
- Creating results of employee survey
- Analysis of operational KPIs and calculating correlations
- Preparing result presentations for stakeholders
Data Analyst
Metafinanz
- Consulting at Strategical Workforce Planning
- Coordination and consolidation of all source data deliveries
- Preparation and analysis of anonymized employee data
- Determination of surplus and deficit of required job roles
- Data transformation into target format for group consolidation
- Preparation of result presentations for stakeholders
- Calculation of various KPIs and automation
Data Analyst
Metafinanz
- Creation of different use cases with SAS Visual Analytics on SAS Viya
- Data pre-preparation with SAS Studio and creation of dashboards in SAS Viya SAS Visual Analytics showcases
- Maintenance in AWS Cloud
Data Specialist
Metafinanz
- Serving customers as account manager
- Leading a team of 10 staff members (including skill and business development)
- Managing additional 10 members from other teams or external
- Processing of proposals and contracts
Data Engineer
Metafinanz
- Reading and joining datasources
- Data preparation/aggregations/matching with negative lists
- Data analysis with Python: automatic, groupwise generation of exports
- Testing with typical use cases from daily BI business
Business Area Lead
Metafinanz
- Serving customers as account manager
- Leading team made up of 10 staff members and managing additional 10 members
- Processing of proposals and contracts
Project Manager
Metafinanz
- Project management for several BI projects for Managed Service ABS Performance Test
- Serving customers as account manager
- Managing approximately 30 staff members
Local Environment Officer
Metafinanz
- Yearly environmental reporting of Metafinanz according to group standard
- Collection, joining and preparing of data sources (heating, electricity, water, travel, paper, waste)
- Presentation and discussion with stakeholders
- Creation of energy audit
Data Scientist
Metafinanz
- Data preparation of log files from Metafinanz website
- Analysis by user location, duration time, click paths
- Logfile analysis and result presentation for stakeholders
Data Specialist
Metafinanz
- Creation of extensive functional specification for calculation of storno quota in complex scenarios
- Conception and implementation of valid methods returning only relevant findings and reliably detecting functional errors in the data mart
Data Modeler & Analyst
Metafinanz
- Data modelling for optimal representation of customer inventory and customer movements
- Designing and developing business concepts for categorization of contract movements in Datamart (CIDM)
- Analysis and assessment of different data sources
- Creation and validation of mapping rules
- Alignment with business experts and IT
Data Analyst & Engineer
Metafinanz
- Warranty insurance reporting: design and implementation, creation of functional specification for consolidation of notifications and cancellations, creation of analysis base
- Residual debt insurance reporting: design and implementation, validation of source data from ABSi and BIBSi databases
- Selection of contract, claims and posting data
Data Engineer
Metafinanz
- Testing and test coordination for around 270 data elements in Datamart Claims: functional testing for completeness of OM (claims), examination of restrictions and logical dependencies
- Creation of comparison set and comparison with DM claims
- Defect management
Data Analyst & Engineer
Metafinanz
- Creation of standardized Data Mart Claims for ABS
- Testing for completeness of OM (claims) from different sources
- Securing data quality (comparison of sums, dimension sizes)
- Determination of derivative rules if 1:1 comparison not possible
- Implementation of KPIs and plausibility checks for deviations
Trainer
Metafinanz
- Central responsibility for maintenance, administration and development for IT-Reporting (mainframe KPIs, UC4 statistics, SAS maintenance & server statistics; formerly cloud statistics and tickets/incidents)
- Delivery and operation of a SAS reporting infrastructure
- Consulting and processing of technical migrations
- Ad hoc analysis
- Technologies: SAS, Unix, UC4, Tortoise Subversion
Data Analyst & Engineer
Metafinanz
- Analysis of data model in data sources BI-Basisschicht (BIBS) and FLASH
- Reporting for different claims systems: extraction from Oracle DWH, combination and handling of both data sources
- Conception and implementation of ETL jobs with SAS Enterprise Guide
- Calculation of standard statistics
- Creating PDF, Access and Excel reports with SAS
Data Analyst & Engineer
Metafinanz
- Migration of standard reportings (from WebFocus, RAMIS, AS, Access and Excel to SAS)
- Data extraction from Oracle
- Conceptualization and implementation of ETL processes with SAS Enterprise Guide
- Calculation of standardized statistics with SAS
- Creation of PDF, Access and Excel reports with SAS
- Macro programming to allow for large-scale reporting
Data Engineer
Metafinanz
- Consolidation of large amounts of data for actuarial database
- Data extraction from Oracle DWH
- Data aggregation for calculation purposes
- Conceptualization of optimized and performant ETL processes
- Implementation with SAS Enterprise Guide
- Creation of calculation table with risk and claims data
Data Analyst
Metafinanz
- Development of showcase for planning department (Cognos TM1, Excel)
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance, Information Technology, Professional Services, and Insurance.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, Operations, Customer Service, Sustainability Management, and Sales.
Summary
Axel Kraus has worked intensively in data analysis & engineering for the last 15 years, including insurance statistics, customer traffic etc.. He has an excellent feel for numbers, a well-developed proficiency with statistics, many years experience with BI tools and proven skills as a teacher.
Skills
Data Analysis & Reporting
Business Analysis
Data Modelling & Etl
Customer, Contract And Claims Statistics
Trainings
Project Coordination
Analytics & Datamining
Environmental Reporting
Bi-Systems Of Allianz Deutschland (Bi-Basisschicht, Cidm, Datamarts, Mdl, ...)
Python (Pandas, Pyspark, Sklearn, Matplotlib, Numpy)
Microstrategy
Power Bi
Rapid Miner
Cognos Tm1
R
Sql (In Oracle, Postgres, ...)
Spss
Sas (Base, Macro, Eg, Bi, Di, Va)
Uc4
Suba
Tortoise Subversion
Jira
Sas Viya
Cloud Computing
Databricks
Office 365 / Microsoft 365
Tibco Data Migrator
Excel
Languages
Education
Master · Statistics
Certifications & licenses
Accredited As A SAS Trainer
Associate Pyspark Developer
Databricks Certified Data Analyst Associate
PCEP - (Certified Entry-Level Python Programmer)
SAS Certified Advanced Base Programmer For SAS 9
SAS Certified Base Programmer For SAS 9
SAS Certified Visual Business Analyst
Statistics
Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Engineer & Business Analyst
Nearby freelancers
Professionals working in or nearby Munich, Germany
