Eric B.
Freelance Test Manager / Quality Manager / Data Analyst / Data Scientist / CRM Analyst / Test Analyst
Experience
Quality Assurance Manager (QSV)
Federal Employment Agency
Supporting the International Web Presence project of the Federal Employment Agency (IntWeb) in the area of quality management with the goal of taking responsibility for the quality of processes and project results according to the agency's standards. The project's main objectives are to give professionals abroad a quick overview of their opportunities to come to Germany and to enable them to take the necessary steps with consistent digital support by accessing services.
- Defining basic guidelines with the QA manual
- Summarizing test results in QA reports for PLA
- Analyzing project results for possible improvements
- Quality management for requirements analysis (especially processes, methods, and tools)
- Ensuring compliance with SERA guidelines
- Creating a cross-project test concept
- Agreeing on sprint completion reports
- Formal review of work results according to guidelines and/or project plan
- Point of contact for internal audit, external audits by auditors or the Federal Audit Office
Technologies: JIRA, Confluence, MS Office
Data Analyst
BNP Paribas S.A. Germany Branch
Supporting the Tribe Data team in Business Analytics & Information, which serves as the bank's central service unit and carries out various data-driven requirement analyses for different departments. My role focuses on data-driven processing of requests from areas such as marketing, trading/securities, and others. This includes data management and preprocessing, providing target groups, and creating dashboards.
- Analyzing large data sets
- Extracting relevant information from the MicroStrategy-based database
- Creating dashboards and reports using Spotfire
- Providing target groups
- Data evaluations with SAS Base
- Various alignments with stakeholders
Technologies: MicroStrategy Developer & Web, SAS 9.4, Spotfire - TIBCO Spotfire Analyst, Confluence, MS Office
Business Analyst / Data Analyst in Risk Management / IDH Reporting
S Rating and Risk Systems GmbH
Supporting the credit structure reports project by analyzing and querying the existing data foundation in SQL. In coordination with the financial IT department and SR IDH Reporting, a concept is developed to determine which data is needed for the migration. Additionally, support is provided for designing the connection of EKREPP reports (standard credit review tool of the auditing bodies) to IDH. The goal is to successfully create a prototype to ensure the migration from the old DWH system to the new IDH.
- Advising on connecting EKREPP reports (standard credit review tool of the auditing bodies) to IDH
- Supporting credit structure analysis as part of building a data dump for reporting purposes
- Creating SQL queries as well as queries in IDH-R
- Close collaboration/coordinating with SR IDH Reporting and FI reporting/statistics
- Creating a prototype to ensure the migration from the old DWH system to the new IDH
- Testing the data dump using SQL scripts
Technologies: Microsoft SQL Server, DBVisualizer, JIRA, Confluence, MS Office
Business Analyst in Regulatory Reporting
S-Kreditpartner GmbH
Supporting the InfraRisk24 project in designing the renewal of the internal data pool "Spark" to prepare data requirements for regulatory reporting and in creating a concept for the future data interface of the reporting software. This includes, among other things, shutting down the BRM data pool to allow a direct transfer from IIB to SPARK via iWHS.
- Analyzing and preparing current workflows and delivery paths
- Identifying data sources
- Various alignments with business analysts
Technologies: JIRA, Confluence, MS Office
Quality Assurance Manager (QSV) Requirements Analysis & Test Manager
Federal Employment Agency
Supporting the Digital Customer Communication (DIKUKO) project in quality and test management with the goal of taking responsibility for the quality of project results. The project's main objectives are to expand the customer experience across channels, guide customers better to relevant offers, and automate communication tasks while using budgets more efficiently and effectively.
- Defining basic guidelines with the QA manual
- Summarizing test results in QA reports for PLA
- Analyzing project results for possible improvements
- Quality management of requirements analysis (especially processes, methods, and tools)
- Ensuring compliance with SERA guidelines
- Creating the test concept
- Agreeing on sprint completion reports
- Formal review of work results according to guidelines and/or project plan
- Coordinating/monitoring the defined test coverage using SonarQube metrics
- Coordinating automation of the CI/CD pipeline
- Point of contact for external audits by auditors, internal audit, or Federal Audit Office
Technologies: JIRA, Confluence, MS Office, Dropsolid, Mautic, SAP Solution Manager
Test Analyst / Business Analyst
Finanz Informatik Solutions Plus GmbH
Provided support for the ECB reporting project in the testing area to ensure that the data supply from Abacus (Abacus360) via the Abacus Transformer, including IDH deliveries, meets the requirements and quality standards of the savings banks before being handed over to the German savings banks.
- Regular coordination with business analysts & developers
- Support for test activities
- Fill-level analysis for different loading runs based on feedback from the clients (savings banks)
- Creation and documentation of test cases in HP ALM
- Development of SAS modules for testing purposes
- Adjustment / creation of SQL test scripts
- Coordination regarding mapping rules & IT concept for the requirements with project lead and business analysts
Technologies: HPQC, OSPlus, JIRA, MS Office products, Confluence, DBVisualizer, SAS Base / SAS Macro
Test Manager / Test Lead & Quality Officer / Quality Management Officer
Finanz Informatik GmbH & Co. KG
Provided support for the Data Analytics project in test management to ensure that the products/software meet the quality characteristics of the PMOPlus standard before delivery to the German savings banks.
- Establishment of test tools
- Methodological support for test activities
- Support in the introduction, establishment and expansion of test automation
- Organization, coordination and execution of load tests with the Test Management unit
- Monitoring and coordination of the testing process (updating and advising) according to PMOPlus, including tracking milestones
- Provision, maintenance and support/advice of test tools
- Definition and advice on test methods
- Test data creation, advice and support within the team, especially for business analysts and testers
- Coordination of external acceptance by the German savings banks and companies of the savings banks group
- Planning test activities with interfacing projects
- Creation of acceptance protocols
- Preparation of the test plan
- Documentation of test activities in Wiki
- Coordination of the test team
Technologies: HPQC, OSPlus, OSPlus neo, JIRA, MS Office products, Confluence, DBVisualizer, SAP Solution Manager
Provided support for the IDH (Integrated Data Repository) calculation project in quality management to achieve an increased quality according to the PMOPlus standard in the creation and integration of applications for the OSPlus banking system before delivery to the German savings banks.
- Ensuring fulfillment of quality requirements for project results
- Defining quality objectives and corresponding measures in coordination with the project manager and contractors
- Advising and supporting executives, project managers, test leads and team members in implementing the planned quality objectives and measures
- Proactively informing all involved staff about any quality issues
- Close collaboration with test leads/test manager in the project
- Supporting internal acceptance and granting approvals
- Managing project document management (in coordination with the project manager)
Technologies: PMOPlus, JIRA, MS Office products, Rochade, Confluence
SAS Analyst
Basler Versicherungen
Provided support for the subproject Technical Implementation of the DDS (Detail Data Store) project in the claims area, among other things to accompany the conception, analysis, and implementation of data warehouses and data marts and to ensure reporting by the business department.
- Assisted in creating data processing concepts based on business concepts
- Developed data marts based on existing data processing concepts
- Supported developer tests
- Advised on error analysis and corresponding error correction
Technologies: SAS DI Studio 4.902, SAS Base, SAS Enterprise Guide 8.1, JIRA, MS Office products, Confluence, Automic software
Data Migration Analyst
Wirecard Technologies GmbH
Supported the subproject Migration and Data Management in the Transaction Banking area, among other things to build a reconciliation database. This involved migrating from the Bank21 core banking system (plus CCP) to the Temenos T24 banking system.
- Set up an Oracle database
- Assisted business analysts in completeness checks
- Developed new migration steps (ETLs) based on extracts from internal and external data sources/databases and mapping documents
- Developed/created and adjusted reconciliation reports
- Participated in mapping workshops
- Performed data masking processes
- Measured success and performed quality checks of migrations before handing over to testing
- Coordination rounds with offshore teams
- Coordination rounds and presentation of interim results to program management and stakeholders
Technologies: Python 3.7.6 (including Pandas library), Jupyter Notebook (notebook server 6.0.3 / IPython 7.13.0), JetBrains PyCharm 2019.2, Oracle, SQL Developer 19.4.0.354, JIRA, MS Office products, Confluence, ASANA
Data Analyst / CRM Analyst
Unitymedia GmbH
Supported the Customer Analytics team and CRM department in campaign preparation, selection, analysis & management.
- Performed data analysis and data preparation for the business unit to evaluate campaign success using statistical methods (e.g., statistical tests, A/B tests)
- Data cleansing and aggregation
- Executed campaign selections and ensured correct data delivery processes to involved service providers
- Developed and adapted lifecycle campaign processes
- Performed exploratory data analysis and prepared results for the business unit in an appropriate format
- Developed and adapted the churn reporting landscape
- Advised on the implementation of new processes/reports
- Redesigned and developed a dashboard for base management
Technologies: Power BI, SAS Base, SAS EG, SAS Enterprise Miner, Oracle, WinSCP, PuTTY, JIRA, MS Office products, Dymatrix, Confluence
Data Scientist / Test Manager
Flex Financial Solutions GmbH
Fraud Detection System. Development of a statistical risk tool for online fraud detection.
- Business concept
- Development of a test management framework
- Test planning
- Coordination / creation of test object catalog
- Implementation of the entire data processing pipeline
- Data quality management
- Scoring
- Dashboard reporting
- Quality management
Technologies: MySQL, R, RStudio, AWS, R Shiny, R Markdown, Visual Studio, Python, API, WinSCP, PuTTY, JIRA
Test Analyst / Test Coordinator
Commerzbank AG
Connecting Digital CRM to the customer center and branch channels based on data stored in a Big Data Lake (Hadoop) – expanding the SAS-based data mining tool to deliver customer-specific offers at the right time through the right channel.
- Analyzing specifications (functional design) and design (technical design) for test-relevant topics
- Analyzing interfaces to partner systems MS Dynamics / Big Data Lake
- Defining test objects and test cases based on functional and technical requirements from business and IT concepts
- Supporting test managers in planning
- Leading technical tester teams
- Ensuring documentation in HP ALM
- Participating in defect management
- Defining requirements for test data and environments for functional and non-functional tests
- Test data definition and requirements
- Contributing to the creation of the test concept
- Coordinating and executing technical and functional tests (e.g., web services, campaign setups, definition/creation of offer formats, development of mining models, management of control tables, web tracking, etc.)
- Developing SAS Base code / macros
Technologies: HP ALM 11, MS Office, SAS Enterprise Miner 13.2, SAS EG 6.1, SAS Model Manager 13.1, SAS Customer Intelligence 6.3 – Marketing Automation / Marketing Optimization / Realtime Decisioning Manager / Offers, SAS Management Console, SAS Customer Experience Targeting 6.3, SAS IMAP 4.4, Oracle DWH, DB2 / Toad for DB2, UC4 / OPC, SOAP UI 5.0.0, WinSCP, PuTTY
Test Analyst / Test Coordinator in the Scrum Team for Big Data
Deutsche Bank AG
Building a Hadoop-based Big Data Lake for Cyber Security, aiming to provide machine data (NetFlow, proxy, etc.) of all kinds to stakeholders/divisions in real time and near real time to fight cyber attacks more efficiently.
- Test analysis based on business requirements
- Creating technical and functional test cases
- Developing a test framework
- Executing manual and Talend-automated tests
- Creating and adapting a test concept/test strategy
- Creating and maintaining a release management plan
- Designing and documenting a propagation concept
- Designing and participating in the implementation of a continuous integration pipeline using TeamCity (plus Nexus, GIT)
- QA of all SDLC documents (development & testing)
- Disaster recovery testing at the Kafka node level
Technologies: HP ALM 12, MS Office, Talend Studio 6.21, TAC, Cloudera 5.5.4, Spark 1.6.0, Flume 1.6.0, Unix, Kafka 0.8.2 & 0.9.1, Zookeeper 3.4.8, HDFS, Hue, Nexus, Puppet, Jenkins v2.15, TeamCity Enterprise 9.1.8
Participation in data mining competitions (kaggle.com)
Topic: Right Whale Recognition. Sector: Zoology (main sponsor: NOAA Fisheries). Developed statistical models/algorithms based on aerial photographs to identify right whale species. The purpose of the analysis was that only a few experienced researchers could identify each whale species when they briefly jump out of the water while swimming. The goal was to support most researchers to make this identification faster than before. One of the first challenges in the investigation was extracting data from the images.
Technologies: R (RStudio), MS Office
Test Analyst / Test Coordinator
Commerzbank AG
Digital CRM – introducing a new data mining tool designed to deliver customer-specific offers at the right time (real-time data processing) through the right channel.
- Analyzing specifications (functional design) and design (technical design) for test-relevant topics
- Defining test objects and test cases based on functional and technical guidelines from business and IT concepts
- Supporting test managers in planning
- Leading technical tester teams
- Ensuring documentation in HP ALM
- Participating in defect management
- Defining requirements for test data and environments for functional and non-functional tests
- Contributing to the creation of the test concept
- Coordinating and executing technical and functional tests (e.g., web services, campaign setups, definition/creation of offer formats, development of mining models, management of control tables, web tracking, etc.)
- Developing SAS Base code / macros
Technologies: HP ALM 11, MS Office, SAS Enterprise Miner 13.2, SAS EG 6.1, SAS Model Manager 13.1, SAS Customer Intelligence 6.3 – Marketing Automation / Marketing Optimization / Realtime Decisioning Manager / Offers, SAS Management Console, SAS Customer Experience Targeting 6.3, SAS IMAP 4.4, Oracle DWH, DB2 / Toad for DB2, UC4 / OPC, SOAP UI 5.0.0, WinSCP, PuTTY
Participation in Data Mining Competitions (kaggle.com)
Topic: Driver Telematics Analysis. Industry: Insurance (main sponsor: AXA). Development of a statistical model/algorithm to create/predict individual signatures of vehicle drivers using traffic telematics data. The goal is, among other things, to offer personalized insurance rates based not on criteria like vehicle type, license age, or similar categories but on individual driving signatures.
Technologies: R (RStudio), MS Office
Tester / Test Analyst
T-Systems International GmbH
Demand-based cluster testing in a DWBI environment / testing of campaign management systems:
iCP (Integrated Campaign Platform)
CAI (Customer Analytics and Insights)
ODS (Online Data Store)
Review of specification documents (Application Specification / Solution Specification / Functional Interface Specification)
Coordination of the offshore cluster test team
Creation & review of test concepts
Development of test plans and test strategies including effort estimation
Creation of test cases / test case catalogs / test scenarios for functional and non-functional requirements
Creation of test data
Creation of test campaigns (inbound, outbound, email, mail)
Manual test execution
Adaptation of XML-based test suites used as the basis for automated tests
Execution of automated regression tests
Testing of web services using SOAP UI
Preparation of daily and weekly reports and contribution to the creation of test reports
Technologies: HP Quality Center 10.00, DDTS, JIRA 6.3.9, ORACLE / SQL Developer, Siebel Marketing 8.1, SAS CI Studio 5.4, SAS Enterprise Guide 4.3 / SAS Base, SAS Management Console 9.2, WinSCP, PuTTY, SOAP UI 3.6, UC4 V8
SAS Analyst and Developer
Allianz Deutschland AG
Development of a platform for claims field service controlling.
- Creation of a data mart as the basis for reports
- Development of specific standard reports to be automated (monthly and weekly reports)
Technologies: SAS Enterprise Guide (version 4.3), SAS Base/SAS Macro, SAS Olap Cube Studio / SAS Web Report Studio, database system: Oracle, DBVisualizer
ETL Developer
ALD Automotive / Bank Deutsches Kraftfahrzeuggewerbe AG
Migration of data from the COBOL-based legacy system KBO / KB Online to the new Oracle-based Cassiopae system (ETL).
- Implementation of provided specifications and mapping concepts
- Creation and adaptation of mapping documents and specifications
- Design and adjustment of new Informatica mappings
Technologies: Informatica PowerCenter, database system: Oracle, Toad for Oracle, Mantis Bug Tracker, WinSCP, PuTTY, MS Excel
SAS Analyst and Developer
Allianz Deutschland AG
Development of a platform for claims field service controlling.
- Creation of a data mart as the basis for reports
- Development of specific standard reports to be automated (monthly and weekly reports)
Technologies: SAS Enterprise Guide (version 4.3), SAS Base/SAS Macro, SAS Olap Cube Studio / SAS Web Report Studio, database system: Oracle, DBVisualizer
Statistical Analyst
Analytic Aurachtal GmbH
Statistical analysis in oil exploration. Development of forecasting models. Goal: Using chemical analysis of soil gas and statistical evaluation based on data from geological and seismic surveys to assess the probability of oil deposits in the ground.
Technologies: STATISTICA, Excel
SAS Analyst / SAS Developer
VR Leasing AG
Topic: RWA calculation core & reporting (Basel II & III project).
- Creation of the IT concept for data provisioning for reporting
- Data requirement analysis
- Implementation of the Reporting Data Layer (RDL), to serve as the basis for various reports in the Risk Controlling department.
- Technologies: SAS Enterprise Guide 4.3/ SAS Base, SAS DI Studio 4.2, SAS Metadata Server, SAS CRM, SAS BIS DDS, Excel 2003, DBVisualizer, Oracle SQL Developer
Topic: Data Quality Management (DQM) in the DWH environment.
- Customization of the QA tool dsquare.de Quality Center (DQC) according to VR Leasing's requirements, to serve as the data quality management tool
- Creation of new DQC modules
- Creation of validation rules in metadata management for different quality gates (BIS DDS, staging levels)
- Test analysis
- Technologies: SAS Enterprise Guide 4.3, SAS DI Studio 4.2, Excel 2003, DBVisualizer
Topic: SAS development for risk management (IRB / Basel II & III project).
- Design and programming with the SAS Risk Management for Banking solution. Development of ETL processes for RWA calculation. Provision of data for disclosure and loss reporting using SAS Credit Risk Management and SAS RMfB.
- Writing the IT concept for data delivery of the Credit Risk Management solution. Implementation of ETL workflows for CRM data delivery.
- DI Studio and SAS Base development, job scheduling
- Technologies: SAS RMfB, DI Studio 4.3, SAS BIS DDS, SAS Base 9.2/Macro, SAS Metadata Server, UC4
SAS Developer / Analyst
Santander / ISBAN DE
Analysis and programming of a Credit Risk Data Mart.
- Analysis of source data from core banking systems of the original banks
- Implementation of business requirements into SAS Base programs
- Documentation of existing SAS programs
- Maintenance of a SAS Base-based job control system
- Review of existing business data mappings
- Extension of data loading processes with SAS Base programs
- Creation of UNIX scripts to control the loading runs
- Support of DWH data delivery
- Data analysis for a risk management data mart
- Analysis of source data after merger
- Analysis of customer data for building a risk management data mart to prepare for mapping
- Creation of test concepts
- Development of test plans and test strategies
- Creation of test cases / test catalogs / test scenarios
- Creation of test data
- Execution of component tests
Technologies: Doxygen, SAS Base/Macro (9.1, 9.2), UNIX AIX, SAS BIS DDS, HP Quality Center, Oracle DWH
CRM Analyst & Statistician
Vodafone Deutschland GmbH
Topic: CRM analysis and reporting.
- Design and implementation of new reports for specific tariff categories
- Development of new customer insights to identify possible influencing factors and improve profitability
- Execution of A/B tests
- Analysis and optimization of the existing tariff simulation tool
- Implementation and coordination of standard analyses & dashboards
- Identification and preparation of innovative approaches that positively impact business goals
- Expansion of the existing reporting system
- Creation of ad-hoc analyses
- Development of automated reports that are sent weekly to management
- Presentation of analysis results to management and derivation of action recommendations
- Data extraction for analyses using SAS DI
- Technologies: SAS Base 9.2, Linux, Teradata, DI Studio (4.2)
Topic: Design and programming of an analysis routine in CRM.
- Impact analysis of consultation consent for mobile customers on churn and revenue using propensity score matching
- Development of forecasting models
- Survival analysis (customer value analysis)
- Value management analysis (e.g., Customer Lifetime Value or CLV)
- Presentation of results in PPT presentations
- Ad-hoc analyses
- Technologies: SAS Base/Macro 9.1, Enterprise Miner 5, Teradata
Statistician / Analyst
Deutsche Rückversicherung AG
Analysis and programming in the motor vehicle insurance sector.
- Design and programming of rate calculation
- Support in creating risk statistics for public insurers
- Data checking and validation
- Data preparation and cleansing
- Presentation of analysis results in Excel tables and charts
- Creation of ad-hoc analyses
Technologies: SAS Base 9.1, Enterprise Guide, DI Studio 3.4, Oracle DWH
Biostatistician / SAS Programmer
Sanofi Aventis Deutschland GmbH
Statistical analysis and programming. Data analysis of pharmacokinetic parameters from a clinical study investigating food interaction.
- Statistical evaluations of Phase I studies
- Data preparation and analysis
- Development of validation programs based on the Statistical Analysis Plan (SAP)
Technologies: SAS Base 8.1/Macro, SAS Enterprise Guide, MS Excel, Oracle DWH
Biostatistician / SAS Programmer
Sanofi Aventis Deutschland GmbH
Statistical analysis and programming. Data analysis of pharmacokinetic parameters from a clinical study investigating food interaction.
- Statistical evaluations of Phase I studies
- Data preparation and analysis
- Development of validation programs based on the Statistical Analysis Plan (SAP)
Technologies: SAS Base 8.1/Macro, SAS Enterprise Guide, MS Excel, Oracle DWH
Summary
I am an experienced freelance test manager, quality manager, and data analyst with over 15 years of expertise in data-driven projects in banking, insurance, telecommunications, and the public sector. My focus is on quality assurance, test management, and data analysis in complex DW/BI environments. I combine technical know-how (including SAS, SQL, Python, R, Talend, Power BI, Temenos T24) with methodological strength (ISTQB-certified, PMOPlus, SERA).
I help companies build and optimize test processes, prepare data for business decisions, and implement regulatory requirements in the finance sector. As a bridge between the business side, IT, and management, I am equally experienced in agile and traditional project environments.
Core competencies:
Test management & quality assurance (ISTQB, HPQC, JIRA, CI/CD)
Data analysis & reporting (SAS, SQL, Power BI, Spotfire)
CRM & campaign analysis (SAS CI, Oracle, Python)
Data science & predictive analytics (R, machine learning)
ETL development (Informatica, Talend, SAS DI Studio, SAS Base)
Industry focus: banking, insurance, telecommunications, public sector
Languages: German (fluent), English (business fluent), French (business fluent)
I look forward to exciting projects where I can deliver real value through structured quality assurance, data-driven insights, and technological precision.
Languages
Education
Statistics, Data Science
Data Analysis & Management
Certifications & licenses
ISTQB® Certified Tester Foundation Level
ISTQB
SAS® Certified Advanced Programmer for SAS® 9
SAS
SAS® Certified Base Programmer for SAS® 9
SAS
Similar Freelancers
Discover other experts with similar qualifications and experience
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.