Benjamin Tsapfack

Test Manager and Software (SW) and Hardware (HW) Tester

Wickede (Ruhr), Germany
Experience
Jul 2023 - Present
2 years 1 month
Berlin, Germany

Test Manager and Software (SW) and Hardware (HW) Tester

Deutsche Bahn (DB)

  • Designed and implemented a comprehensive test strategy for digital rail projects.
  • Defined and documented systematic testing approaches to maximize coverage and efficiency.
  • Assigned roles and responsibilities within the test team to ensure effective, goal-driven test execution.
  • Made decisions on core testing principles to ensure test integrity and quality.
  • Developed and executed integration and system tests based on specific specifications and standards.
  • Built and enhanced the infrastructure for automated test environments, including test systems and prototypes.
  • Tested Yemba event detection algorithms in a vehicle data logger using generative artificial intelligence.
  • Created detailed test cases for internal use and for partner companies (equipment manufacturers).
  • Conducted performance and load tests to ensure system stability and scalability.
  • Ensured compliance with relevant standards like Cenelec, EN50126, and EN5012.
  • System environment and technologies: Codebeamer, Polarion, Jira, Confluence, Agile, Python, Pytest, Scrum, Terraform, OpenAI, Replit, REST API, Azure DevOps.
Nov 2022 - Jul 2023
9 months
Bonn, Germany

Data Scientist, CRM, Software Testing

Deutsche Bank

  • Selected and classified customers by target groups to provide tailored information and offers.
  • Created and implemented machine learning models for customer segmentation and classification.
  • Supported migration from Postbank to Deutsche Bank systems, including data structure integration and adjustment.
  • Performed tests on new processes to ensure functionality and efficiency.
  • Applied DevOps practices and CI/CD to improve development and deployment processes.
  • System environment and technologies: SAS, DB Developer, SQL, DB2, Jira, Confluence, OpenAI, CDWH, Python, Scrum, Agile, Docker, LLM.
Apr 2022 - Sep 2022
6 months
Nuremberg, Germany

Data Analyst, Data Scientist, SAS and SQL Developer

ERGO AG

  • Analyzed insurance data from partners to identify trends, patterns, and anomalies.
  • Performed statistical evaluations of customer insurance portfolios to optimize products and services.
  • Developed and maintained programs using SAS and SQL to automate and improve analysis processes.
  • Presented analysis results and discussed them with business units to support data-driven decisions.
  • Carefully documented findings and developed programs to ensure transparency and traceability.
  • System environment and technologies: SAS Base, SAS EG, SQL, Mainframe Host, DB2, Jira, Confluence, Unix, Power BI.
Jan 2022 - Apr 2022
4 months
Hanover, Germany

SAS and SQL Developer

Finanz Informatik

  • Developed and maintained data processing and analysis programs using SAS and SQL.
  • Performed tests to ensure functionality and accuracy of developed programs.
  • Documented test results and developed programs to guarantee traceability and transparency.
  • System environment and technologies: SAS, SQL, Mainframe Host, Snowflake, DB2, Jira, Confluence, zOS, Unix, DBVisualizer, WinSCP, PuTTY, Agile.
Jun 2021 - May 2022
1 year
Münster, Germany

Software Test Manager

Fiducia GAD/Atruvia

  • Developed and continuously updated the test plan to ensure structured and efficient testing.
  • Described the testing approach in the test plan and aligned with project managers and testers for a clear strategy.
  • Advised on coordinating and reviewing test activities, including resource and team management.
  • Organized and executed tests on various objects to verify software quality.
  • Advised and supported creation, execution, and management of test cases, resources, and testers.
  • Collaborated closely with project managers and quality officers to align test strategies with project requirements.
  • Expanded and implemented test automation to boost efficiency and reduce manual effort.
  • Defined infrastructure requirements to support testing activities.
  • Supported provisioning and management of necessary test data.
  • System environment and technologies: FitNesse, Aqua, BitBucket, BAP, Kafka, Angular, Postman, Jira, Confluence, Agile.
Mar 2021 - Aug 2021
6 months
Munich, Germany

SAS Developer

Die Bayerische Versicherung

  • Reviewed existing SAS programs and developed new functions to optimize data processing and analysis.
  • Created and managed JCL jobs to automate and control batch processes on the mainframe host.
  • Conducted analyses across various insurance lines and developed solutions to improve business processes.
  • System environment and technologies: SAS Base, Mainframe Host, SAS Viya, DB2, ED, SQL, Unix, zOS, Jira, Confluence, Agile.
Jan 2021 - Mar 2021
3 months
Wuppertal, Germany

Data Scientist Specialist, SAS Statistics Developer

Gefa Bank

  • Analyzed and built a tool to monitor and ensure customer base stability.
  • Performed detailed risk parameter analyses to measure loan default probability and support credit risk decisions.
  • Developed and implemented processes for test statistics on various samples to ensure measurement reliability and accuracy.
  • System environment and technologies: SAS Base, SAS Enterprise Guide, Oracle.
Oct 2020 - Mar 2021
6 months
Berlin, Germany

Data Scientist, Text Analysis, Text Mining

Bundesdruckerei (Bdr) and Foreign Office

  • Developed and applied statistical models for early crisis detection by analyzing large datasets.
  • Implemented text mining and NLP techniques using spaCy and AI models to identify and analyze text similarities.
  • Built statistical models to classify questions from members of parliament by ministry to streamline responses.
  • Developed models to detect contacts between specific groups (meetings).
  • Implemented methods to detect words and synonyms in texts.
  • Created and maintained ETL pipelines and job processes for efficient data processing and integration.
  • System environment and technologies: Python, Django, spaCy, BeautifulSoup, OCR, Elasticsearch, Kibana, Logstash, R, R-Shiny, MinIO, Jira, Confluence, Agile, Azure.
Apr 2020 - Sep 2020
6 months
Bad Homburg, Germany

Business Analyst

Basler Versicherung AG

  • Collaborated with business units to analyze and align concepts for the Guidewire Center, especially claims, accounting, and contracts.
  • Reviewed and approved IT concepts to ensure they met business needs and were feasible.
  • Analyzed interfaces between business requirements and IT concepts to ensure seamless integration.
  • Developed data processing concepts to support business processes.
  • Implemented ETL workflows in SAS DI Studio to build and load datamarts according to architectural guidelines.
  • Used the Guidewire system to manage contracts and claims.
  • Converted SAS DI jobs into Automic job schedules.
  • Supported test management in executing and analyzing test cases to ensure solution quality.
  • Created and maintained reports to support decision-making and business processes.
  • System environment and technologies: SAS DI Studio, SAS Enterprise Guide, Automic, DB2, Jira, Confluence, Agile, Erwin Data Modeler, Tableau.
Feb 2019 - Jun 2019
5 months
Frankfurt, Germany

Data Engineer, Developer/Software Tester

Zürich Versicherung AG

  • Analyzed existing processes and identified improvement opportunities to boost efficiency.
  • Created and implemented a process for catastrophe accounting of vehicles under IFRS 17.
  • Optimized and sped up SAS systems to improve data processing performance and reduce runtimes.
  • Developed and documented recommendations for accounting under new IFRS 17 requirements.
  • Collaborated closely with stakeholders in accounting and reinsurance to ensure requirement compliance and process integration.
  • Prepared documentation for regression tests to ensure process stability and correctness.
  • Conducted manual tests to verify functionality and accuracy of developed processes.
  • System environment and technologies: SAS Base, SAS Macro, Microsoft Office, DB2 Xray, Jira, Confluence.
Mar 2017 - Mar 2020
3 years 1 month
Mönchengladbach, Germany

Business Analyst/Data Scientist/Software Developer/Software Testing

Santander Consumer Bank AG

  • Conducted strategic analyses and developed scorecards for portfolios to assess risk and support decisions.
  • Analyzed business concepts and their data for informed decisions and optimizations.
  • Developed behavior-scoring logic for corporate and retail customers using data science techniques.
  • Analyzed and decided on credit card limits (increase or decrease) based on scorecard results.
  • Led and coordinated the development team to monitor and optimize systems and processes.
  • Implemented and monitored strategic analyses and scorecard databases for various portfolios.
  • Managed data science analyses and designed and ran campaigns to improve scorecard usage.
  • Conducted A/B and champion/challenger tests to calibrate and optimize scorecards.
  • Created and executed automated regression tests and manual tests for new software and applications.
  • Identified and fixed process errors and automated UAT tests.
  • Developed and tested new software applications and tools, including an "Operational Risk Tool" for loss reporting.
  • System environment and technologies: Python, Pandas, NumPy, TensorFlow, SAS Base, SAS Macro, SAS Enterprise Guide, R, ServiceNow, JavaScript, HTML, Vue.js, Bootstrap, CSS, Jira, Scrum, Confluence, Bash Script, Unix, Linux, QC, Microsoft Office, PL/SQL, SharePoint, ALM, Selenium, MS Azure, Oracle.
Dec 2016 - Feb 2017
3 months
Eschborn, Germany

Quality Assurance/Credit Risk Modeling

VR Leasing AG

  • Developed and automated processes to create and manage balance sheet data from predefined source files.
  • Built and implemented IFRS 9 accounting processes to meet regulatory requirements.
  • Reviewed and ensured quality of current data processing concepts, especially interfaces to cash-flow models.
  • Scheduled daily automatic balance sheet calculations and deliveries to ensure smooth operations.
  • Ensured flexibility in reading and processing source files to adapt to various data sources.
  • Adapted and refactored SAS code to boost efficiency and performance of data processes.
  • Documented operational processes and procedures in a comprehensive operations manual.
  • System environment and technologies: SAS Base, SAS Macro, DI Studio, SAS Enterprise Guide, Python, C++.
Mar 2016 - Jun 2017
1 year 4 months
Stuttgart, Germany

Developer/Statistician/Business Intelligence

Landesbank Baden-Württemberg (via Finanz Informatik Solutions AG)

  • Developed specifications and designed a data warehouse system, including planning and executing a migration project.
  • Conducted statistical analyses and evaluations to support business decisions and process improvements.
  • Adapted existing scorecards and modeled new ones to assess customer and business risk.
  • Migrated a compliance mart to meet regulatory requirements.
  • Modeled and tested data warehouses to ensure data integrity and availability.
  • Designed and implemented ETL workflows to integrate and process data in the warehouse.
  • Optimized and updated processes to improve data processing and analysis.
  • Translated business requirements into data processing concepts for IT implementation.
  • Developed and implemented job controls with Control-M to automate and monitor batch processes.
  • Built and deployed anti-money laundering tools per BaFin requirements.
  • System environment and technologies: SAS Base, SAS Macro, DI Studio, SAS Enterprise Guide, Oracle PL/SQL, Unix QC, Bash Script, ALM, OSPlus SharePoint.
Jun 2015 - Feb 2016
9 months
Mönchengladbach, Germany

Data Analyst/Business Intelligence

ISBAN GmbH (Santander Consumer Bank AG)

  • Developed and implemented statistical models to assess credit risk.
  • Adapted existing SAS programs and built new ones to improve data processing and analysis.
  • Designed, modeled, and developed data structures and releases in various data warehouses and marts.
  • Performed cluster analyses to support and optimize CRM campaigns.
  • Analyzed all SEPA card-related payment processes, such as debit card transactions.
  • Created specifications for business intelligence and data warehousing, including staging, core, and marts.
  • Executed data integration, data cleansing, data analysis, ETL, data mining, and profiling.
  • Generated reports to support business decisions and communicate analysis results.
  • Developed and implemented job controls to automate data processes.
  • Designed and implemented ETL processes for efficient data integration.
  • System environment and technologies: SAS Base, SAS Macro, DI Studio, R, Unix, Redmine, ALM, SharePoint.
Apr 2013 - Jun 2015
2 years 3 months
Stuttgart, Germany

Data Scientist/Statistician/Credit Risk Development/Software Testing/Data Modeling

Landesbank Baden-Württemberg (via ARA-Tec GmbH)

  • Developed and implemented models for impairment calculation and disclosure.
  • Created software solutions for credit risk management and reporting.
  • Conducted comprehensive testing of data warehouse software, including unit, integration, system, and manual tests.
  • Modeled and implemented credit value-at-risk methods.
  • Calculated credit risks, syndication allocations, and rating models.
  • Built and implemented BI systems and data warehouses for risk analysis and reporting.
  • Automated processes for creating and distributing credit risk reports.
  • Developed and implemented statistical models for borrower rating.
  • Carried out development tasks in finance and pharma sectors.
  • Implemented ETL processes for efficient data storage and processing in the warehouse.
  • Built an OLAP prototype for credit risk reporting with time series, migrations, and drill-down analyses.
  • Specified and designed database solutions, data modeling, and interface layers.
  • Managed data versioning, history, and release processes for transaction data.
  • System environment and technologies: UML, Microsoft Visio, C++, SAS Base 9.3, SAS Enterprise Guide, Unix, Linux, Java, Pentaho, Saiku, SAS DI Studio, MS Visio, R, ALM.
Oct 2011 - Mar 2012
6 months
Ludwigshafen, Germany

Statistical Consultant for the Automatic Dishwashing Lab (Internship)

BASF

  • Managed data and performed exploratory and descriptive analyses to support lab research projects.
  • Analyzed and interpreted statistical results to provide insights and recommendations.
  • Introduced and trained staff in R programming to enhance internal analysis capabilities.
  • System environment and technologies: R, ggplot2, Oracle, Linux.
Apr 2010 - Feb 2012
1 year 11 months
Dortmund, Germany

Practical Activities during Studies

TU Dortmund

  • Master’s thesis: Topic: Predicting citation counts of medical publications. Developed and applied statistical models to forecast citation frequency of scientific articles in medicine.
  • Seminar: Topic: ROC curve for logical rules. Analyzed and interpreted ROC curves to evaluate performance of rule-based classifiers.
  • Descriptive analysis: Mammal sleep behavior. Studied and analyzed sleep patterns of different mammal species.
  • Descriptive analysis: Levels of calcium, inorganic phosphorus, and alkaline phosphatase in those over 65. Statistically examined concentrations in seniors to assess health implications.
  • Descriptive analysis: Impact of safety systems on head injury severity in car crashes. Evaluated effectiveness of car safety systems using crash-test data to estimate injury reduction.
  • Descriptive analysis: Relationship between social ranks of sons and fathers. Investigated link between social status of fathers and their sons.
  • Descriptive analysis: Diamond pricing model. Built a statistical model for diamond pricing based on various factors and market conditions.
  • Descriptive analysis: Smoking and lung cancer link. Analyzed epidemiological data to study the association between smoking and lung cancer risk.
  • Descriptive analysis: Loan decision using tree-based classification. Applied decision trees to model and predict credit applications.
  • Descriptive analysis: Meta-analysis for breast cancer patients. Conducted a meta-analysis to summarize and interpret results from multiple breast cancer studies.
  • Descriptive analysis: Time series forecasting. Developed and applied time series models to predict future data points based on historical data.
  • System environment and technologies: SAS, R, RapidMiner, SQL, SPSS, C++, Oracle, Linux, Java.
Cologne, Germany

Statistician

Ampega GmbH

  • Managed macroeconomic factors for the "Statistical Modeling from Macroeconomic Factors" project.
  • Developed regression models to estimate default rates in various countries from macroeconomic variables.
  • Evaluated and processed diverse macroeconomic data and time series.
  • Created an adequacy analysis for using expected default frequencies (EDFs).
  • Built interactive dashboards with Tableau.
  • Wrote development documentation.
  • System environment and technologies: R, Tableau.
Frankfurt, Germany

SAS Host, Python and SQL Developer, Software Testing

KfW Bank

  • Conducted detailed analyses of existing systems and enhanced applications to improve bank processes.
  • Developed, maintained, and extended programs and scripts using SAS, Python, and SQL.
  • Regularly reviewed results with business units to ensure solutions met requirements.
  • Documented results and developed programs thoroughly to ensure transparency and traceability.
  • System environment and technologies: SAS Host, SQL, Mainframe Host, DB2, Jira, Confluence, Agile, Unix, Azure, GitLab, Jenkins, Snowflake, Artifact Manager, SQL Developer, Python, Terraform, JUnit, Kubernetes.
Wiesbaden, Germany

Test Manager, Data Analyst, Manual and Automated Software Testing

Wibank

  • Wrote functional specifications for various funding programs to support project requirements.
  • Created comprehensive test strategies to ensure efficient and effective coverage.
  • Defined systematic testing approaches to optimize test processes.
  • Executed tests, analyzed results, and determined release readiness.
  • Identified, formulated, and reviewed testable acceptance criteria in close collaboration with business units.
  • Aligned on compliance-relevant tests and documented them to ensure compliance.
  • Tracked tests and identified improvement opportunities.
  • Performed manual tests on the info portal to ensure functionality and usability.
  • Developed and implemented automated test scripts to increase efficiency.
  • Integrated the info portal with SAP and SAP HANA, including relevant testing.
  • System environment and technologies: SAP, SAP HANA, Microsoft Office, ALM Client Launcher 4.0, Jenkins, Jira, TOSCA.
Summary

Passionate about working with data and developing innovative solutions

Languages
German
Native
English
Advanced
French
Advanced
Education
Apr 2010 - Oct 2012

Technical University of Dortmund

Master of Science, Faculty of Statistics · Data Science · Dortmund, Germany

Aug 2005 - Jul 2007

University of Yaoundé I

Master of Science · Computer Science · Yaoundé, Cameroon

Aug 2001 - Jul 2005

University of Dschang

Bachelor in Mathematics and Computer Science · Mathematics and Computer Science · Dschang, Cameroon

...and 1 more
Certifications & licenses

CCNA: Cisco Certified Network Associate

CISCO

ISTQB certified CTFL

ISTQB

SAS Advanced Programmer Certified

SAS

SAS Certified Base Programmer for SAS 9

SAS

SAS Data Integration Developer Certified

SAS

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions