Benjamin Tsapfack

Test Manager and Software/Hardware Tester

Wickede (Ruhr), Germany

Experience

Jul 2023 - Present
1 year 9 months
Berlin, Germany

Test Manager and Software/Hardware Tester

Deutsche Bahn

  • Development of test strategy: Design and implementation of comprehensive test strategy for digital rail projects
  • Definition of test approaches: Definition and documentation of methodological test approaches to maximize test coverage and efficiency
  • Team management: Distribution of roles and responsibilities within the test team
  • Definition of test principles: Decision on fundamental test principles to ensure test integrity and quality
  • Integration and system tests: Development and execution of integration and system tests based on specific specifications and standards
  • Infrastructure development: Development of infrastructure for automated test environments including test systems and test patterns
  • AI-based event detection: Testing of event detection algorithms in a vehicle data logger using generative AI
  • Test case development: Creation of detailed test cases for internal purposes and cooperative companies
  • Performance and load tests: Execution of performance and load tests to ensure system stability and scalability
  • Standards compliance: Ensuring compliance with relevant standards like Cenelec, EN50126, and EN5012

Technologies: Codebeamer, Polarion, Jira, Confluence, Agile, Python, Pytest, Scrum, Terraform, OpenAI, Replit, Azure DevOps

Jun 2023 - Jun 2023
1 month
Cologne, Germany

Statistical Modeling Specialist

Ampega GmbH

  • Development of regression models that estimate default rates in different countries from macroeconomic factors
  • Analysis and preparation of various available macroeconomic data and time series
  • Development of adequacy analysis for using Expected Default Frequencies (EDFs)
  • Creation of interactive dashboards with Tableau
  • Writing development documentation

Technologies: R, Tableau

Nov 2022 - Jul 2023
9 months
Bonn, Germany

Data Scientist, CRM, Software Tester

Deutsche Bank

  • Customer segmentation and classification: Selection and classification of customers by target groups to provide targeted information and offers
  • Development of ML models: Creation and implementation of machine learning models for customer segmentation and classification
  • System migration: Support in migrating from Postbank to Deutsche Bank systems, including integration and adaptation of data structures
  • Process testing: Conducting tests in new processes to ensure functionality and efficiency
  • DevOps and CI/CD: Use of DevOps practices and Continuous Integration/Continuous Deployment to improve development and deployment processes

Technologies: SAS, DB Developer, SQL, DB2, Jira, Confluence, OpenAI, CDWH, Python, Scrum, Agile, Docker, LLM

Sep 2022 - Nov 2022
3 months
Frankfurt, Germany

SAS Host, Python and SQL Developer, Software Tester

KFW Bank

  • Analysis and further development: Conducting detailed analyses of existing systems and further development of applications to improve bank processes
  • Programming: Development, creation and continuation of programs and scripts using SAS, Python and SQL
  • Results discussions: Regular discussion and coordination of results with departments
  • Documentation: Careful documentation of results and developed programs

Technologies: SAS Host, SQL, Mainframe Host, DB2, Jira, Confluence, Agile, Unix, Azure, GitLab, Jenkins, Snowflake, Artifact Manager, SQL-Developer, Python, Terraform, JUnit, Kubernetes

Apr 2022 - Sep 2022
6 months
Nuremberg, Germany

Data Analyst and Data Scientist

ERGO AG

  • Insurance data analysis: Analysis of insurance data from partners to identify trends, patterns and anomalies
  • Statistical evaluations: Conducting statistical evaluations of customer insurance in various portfolios
  • Programming: Development, creation and continuation of programs using SAS and SQL
  • Results presentation: Presentation of analysis results and discussion with business units
  • Documentation: Careful documentation of results and developed programs

Technologies: SAS Base, SAS EG, SQL, Mainframe Host, DB2, Jira, Confluence, Unix, Power BI

Jan 2021 - Apr 2022
4 months
Hanover, Germany

SAS and SQL Developer

Finanz Informatik

  • Programming: Development and continuation of programs for data processing and analysis using SAS and SQL
  • Test execution: Conducting tests to ensure functionality and accuracy of developed programs
  • Documentation: Careful documentation of test results and developed programs

Technologies: SAS, SQL, Mainframe Host, Snowflake, DB2, Jira, Confluence, zOS, Unix, DBvisualizer, WinSCP, PuTTY, Agile

Jan 2021 - Apr 2022
4 months
Wiesbaden, Germany

Test Manager and Data Analyst

WIBANK

  • Creation of technical concepts: Writing technical concepts for various funding programs
  • Test strategy development: Creation of comprehensive test strategies
  • Definition of test approaches: Definition of methodical test approaches
  • Test execution/coordination and analysis: Execution of tests, analysis of test results
  • Acceptance criteria: Determination, formulation and verification of testable acceptance criteria
  • Regulatory tests: Coordination of regulatory tests and their documentation
  • Test tracking: Tracking of tests and identification of improvement potential
  • Manual tests: Execution of manual tests in the info portal
  • Test automation: Development and implementation of automated test scripts
  • SAP integration: Connection of info portal to SAP and SAP HANA

Technologies: SAP, SAP HANA, Microsoft, ALM Client Launcher 4.0, Jenkins, Jira, TOSCA

Jun 2021 - May 2022
1 year
Münster, Germany

Software Test Manager

Fiducia GAD/Atruvia

  • Creation and continuation of test plan: Development and continuous updating of test plan
  • Test approach coordination: Description of test approach in test plan and coordination with project managers
  • Consulting and coordination: Consulting on coordination and review of test activities
  • Test object execution: Organization and execution of tests for various test objects
  • Test case creation coordination: Consulting and support in creation and management of test cases
  • Collaboration with project management: Close coordination with project managers and quality officers
  • Test automation: Expansion and implementation of test automation
  • Requirements definition for test infrastructure: Definition of requirements for test infrastructure
  • Test data provision consulting: Support in provision and management of test data

Technologies: FitNesse, Aqua, BitBucket, BAP, Kafka, Angular, Postman, Jira, Confluence, Agile

Mar 2021 - Aug 2021
6 months
Munich, Germany

SAS Developer

Die Bayerische Versicherung

  • SAS code review and enhancement: Review of existing SAS programs and development of new functions
  • JCL job development and processing: Creation and management of JCL jobs
  • Division analysis and development: Conducting analyses in various insurance divisions

Technologies: SAS Base, Mainframe Host, SAS Viya, DB2, ED, SQL, Unix, zOS, Jira, Confluence, Agile

Jan 2020 - Mar 2021
3 months
Wuppertal, Germany

Data Scientist Specialist, Statistics Developer

Gefa Bank

  • Tool development for population stability: Analysis and development of a tool for monitoring customer population stability
  • Risk parameter analysis: Conducting detailed analyses of risk parameters
  • Development of test statistics processes: Development and implementation of processes for test statistics

Technologies: SAS Base, SAS Enterprise Guide, Oracle

Oct 2020 - Mar 2021
6 months
Berlin, Germany

Data Scientist, Text Analysis, Text Mining

Bundesdruckerei and Auswärtiges Amt

  • Data processing and statistical models: Development and application of statistical models for early crisis detection
  • Text mining and NLP: Implementation of text mining techniques and NLP methods with spaCy and AI models
  • Question classification: Creation of statistical models for classifying questions from representatives
  • Contact models: Development of models for detecting contacts between certain person categories
  • Word and synonym recognition: Implementation of methods for word and synonym detection
  • ETL pipelines: Creation and maintenance of ETL pipelines and job processes

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 and Data Engineer

Basler Versicherung AG

Business Analyst:

  • Analysis and coordination: Collaboration with departments for Guide Wire Center concept analysis
  • Review and acceptance: Review and acceptance of IT concepts
  • Interface analysis: Analysis of interfaces between business requirements and IT concepts

Data Engineer:

  • Creation of data processing concepts: Development of data processing concepts
  • ETL development: Implementation of ETL processes in SAS DDS DI Studio
  • Operational systems usage: Use of Guide Wire System
  • Job workflows in Automic: Implementation of developed SAS DI jobs
  • Test management support: Support of test management
  • Report creation: Creation and maintenance of reports

Technologies: SAS DI Studio, SAS E-Guide, Automic, DB2, Jira, Confluence, Agile, Erwin Data Modeler, Tableau

Feb 2019 - Jun 2019
5 months
Frankfurt, Germany

Data Engineer and Software Tester

Zürich Versicherung AG

  • Process analysis and optimization: Analysis of existing processes and identification of improvement potential
  • Development of IFRS 17 process: Creation and implementation of process for accounting of car catastrophes
  • SAS system optimization: Optimization and acceleration of SAS systems
  • Action recommendations: Development and documentation of accounting recommendations
  • Stakeholder coordination: Close collaboration with accounting and reinsurance stakeholders
  • Documentation for regression tests: Creation of documentation for regression tests
  • Manual tests: Execution of manual tests

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 Tester

Santander Consumer Bank AG

  • Strategic analysis and scorecards: Conducting strategic analyses and development of scorecards
  • Data analysis and technical conception: Analysis of technical concepts and data
  • Statistical analysis and logic development: Development of logic for behavioral scores
  • Credit card limit analysis: Analysis and decision on credit card limits
  • Development team management: Management and coordination of development team
  • Monitoring strategies: Implementation and monitoring of strategic analyses
  • Data science and campaign management: Management of data science analyses and campaigns
  • Strategy tests: Execution of A/B tests and champion/challenger tests
  • Automated and manual tests: Creation and execution of automated regression tests
  • Debugging and automation: Identification and fixing of process errors
  • Development and testing: Development and testing of new software applications

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 Specialist

VR Leasing AG

  • Balance sheet data conception and automation: Development and automation of processes for balance sheet data
  • IFRS 9 accounting: Creation and implementation of accounting processes according to IFRS 9
  • Quality assurance of data processing concepts: Review and quality assurance of current concepts
  • Planning and automation: Setup of schedule tasks for automatic calculation
  • File reading flexibility: Ensuring flexibility in reading source files
  • SAS code optimization: Adjustment and restructuring of SAS code
  • Operations manual creation: Documentation of operational processes

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

  • Data warehouse specification and conception: Development of specifications and conception of data warehouse system
  • Statistical analysis and evaluation: Conducting statistical analyses
  • Scorecard adaptation and modeling: Adaptation of existing and modeling of new scorecards
  • Compliance mart migration: Migration of compliance mart
  • DWH modeling and testing: Modeling and testing of data warehouses
  • ETL processes: Conception and implementation of ETL processes
  • Process adaptation and enhancement: Adaptation and enhancement of existing processes
  • Technical concept implementation: Translation of business concepts into technical concepts
  • Job control development: Development of job controls with Control M
  • Money laundering prevention tools: Development of tools according to BaFin requirements

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

  • Statistical model modeling: Development and implementation of statistical models
  • SAS program adaptation and enhancement: Adaptation of existing SAS programs
  • Data modeling and development: Conception, modeling and development of data structures
  • CRM campaigns: Execution of cluster analyses
  • Payment transaction analysis: Analysis of SEPA card payment processes
  • Business intelligence specification: Creation of specifications for BI and DWH
  • Data integration and processing: Execution of data integration, washing, analysis
  • Reporting: Creation of reports
  • Job control development: Development of job controls
  • ETL conception and implementation: Conception and implementation of ETL processes

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/Developer for Credit Risk Management

Landesbank Baden-Württemberg

  • Modeling for disclosure and impairment: Development of models for disclosure and impairment evaluation
  • Software development: Development of software solutions for credit risk management
  • DWH process testing: Comprehensive testing of data warehouse process software
  • Development for Credit Value at Risk: Modeling and implementation of methods
  • Exposure calculation and rating: Calculation of credit risks and rating models
  • BI and DWH system implementation: Implementation of business intelligence systems
  • Credit risk reporting automation: Automation of reporting processes
  • Statistical model analysis and implementation: Development of statistical models
  • Development tasks in finance and pharma: Implementation of selected development tasks
  • ETL process for data warehouse: Implementation of ETL processes
  • OLAP prototype development: Development of prototype for credit risk reporting
  • Database solutions: Specification and conception of database solutions
  • Movement data historization: Historization and versioning of movement data

Technologies: UML, Microsoft Visio, C++, SAS Base 9.3, SAS E-Guide, Unix, Linux, Java, Pentaho, Saiku, SAS DI Studio, MS Visio, R, ALM

Oct 2011 - Mar 2012
6 months
Ludwigshafen, Germany

Statistical Consultant

BASF

  • Data management and analysis: Execution of data management, exploratory and descriptive analyses
  • Statistical evaluation: Analysis and interpretation of statistical results
  • Employee training: Introduction and training of employees in R programming

Technologies: R, R-ggplot2, Oracle, Linux

Apr 2010 - Feb 2012
1 year 11 months
Dortmund, Germany

Research Assistant

TU Dortmund

Master Thesis:

  • Topic: Prediction of citation frequencies of medical publications
  • Description: Development and application of statistical models

Seminar:

  • Topic: ROC curve for logical rules
  • Description: Analysis and interpretation of ROC curve

Descriptive Data Analysis:

  • Sleep behavior of mammals
  • Calcium, inorganic phosphorus and alkaline phosphatase in over 65-year-olds
  • Impact of safety systems on head injuries in car accidents
  • Correlation between social ranks of sons and fathers
  • Development of a price model for diamonds
  • Connection between smoking and lung cancer
  • Credit application decision using tree-based classification
  • Meta-analysis for breast cancer patients
  • Time series analysis prediction

Technologies: SAS, R, Rapid Miner, SQL, SPSS, C++, Oracle, Linux, Java

Summary

Passionate about working with data and developing innovative solutions

Languages

French
Native
English
Advanced
German
Advanced

Education

Apr 2010 - Oct 2012

Technische Universität Dortmund

Master of Science · Datenwissenschaften · Dortmund, Germany

Aug 2005 - Jul 2007

Universität Jaunde I

Master of Science · Informatik · Yaoundé, Cameroon

Aug 2001 - Jul 2005

Universität Dschang

Bachelor · Mathematik und Informatik · Dschang, Cameroon

Certifications & licenses

CCNA: Cisco Certified Network Associate Certified

CISCO

ISTQB Certified Ctfl

SAS Advanced Programmer Certified

SAS

SAS Certified Base Programmer for SAS 9

SAS

SAS Data Integration Developer Certified

SAS