Freelance Test Manager / Quality Manager / Data Analyst / Data Scientist / CRM Analyst / Test Analyst

Supporting the International Web Presence of the BA (IntWeb) project in quality management with the goal of taking responsibility for the quality of processes and project results in accordance with BA standards. The project’s main objectives are to give professionals abroad a quick overview of their chances to come to Germany and to enable them to take the necessary steps with consistent digital support through access to services.

• Defining basic guidelines with the QA manual
• Summarizing test results in QA reports for PLA
• Analyzing project results for improvement opportunities
• Quality management of requirements analysis (especially processes, methods and tools)
• Ensuring compliance with SERA requirements
• Creating a cross-project test concept
• Agreeing on sprint closing reports
• Formal review of work results according to guidelines and/or project plan
• Point of contact for internal audit, external audits by accountants or Federal Audit Office

Technologies: JIRA, Confluence, MS Office

Supporting the Credit Structure Reports project by analyzing and querying existing data in SQL. In coordination with Finanz Informatik and SR IDH Reporting, a concept is developed to determine which data is needed for migration. In addition, supporting the design for connecting EKREPP reports (Uniform Credit Review Tool of audit bodies) to IDH. The goal is to successfully create a prototype to ensure migration from the legacy DWH to the new IDH.

• Advising on connecting EKREPP reports to IDH
• Supporting credit structure analysis to build a data dump for reporting
• Creating SQL queries and IDH-R queries
• Close collaboration with SR-IDH Reporting and FI reporting/statistics
• Developing a prototype to secure migration from the old DWH to the new IDH
• Testing the data dump with SQL scripts

Technologies: Microsoft SQL Server, DBVisualizer, JIRA, Confluence, MS Office

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 core objectives are to expand the customer experience across channels, guide customers to relevant offers, and automate communications 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 improvements
• Quality management of requirements analysis (processes, methods and tools)
• Ensuring compliance with SERA requirements
• Creating the test concept
• Agreeing on sprint closing reports
• Formal review of work results as per guidelines/project plan
• Coordinating and monitoring required test coverage via SonarQube metrics
• Coordinating CI/CD pipeline automation
• Point of contact for external audits by accountants, internal audit or Federal Audit Office

Technologies: JIRA, Confluence, MS Office, Dropsolid, Mautic, SAP Solution Manager

Supporting the Data Analytics project in test management to ensure products/software meet PMOPlus quality standards before delivery to German savings banks.

• Establishing test tools
• Methodological support for test activities
• Supporting the introduction, establishment and expansion of test automation
• Organizing, coordinating and conducting load tests with the test management unit
• Monitoring and coordinating the test process (updates and consulting) per PMOPlus including milestone tracking
• Providing, maintaining and advising on test tools
• Defining and advising on test methods
• Creating test data, advising and supporting the team, especially business analysts and testers
• Coordinating external acceptance by savings banks and group companies
• Planning test activities with interface projects
• Creating acceptance protocols and test plans
• Documenting test activities in Wiki
• Coordinating the test team

Technologies: HPQC, OSPlus, OSPlus neo, JIRA, MS Office, Confluence, DBVisualizer, SAP Solution Manager

Supporting the IDH (Integrated Data Repository) Calculation project in quality management to achieve improved quality per PMOPlus standard when creating and integrating OSPlus banking applications before handover to German savings banks.

• Ensuring quality requirements for project results
• Defining quality goals and measures with project manager and contractor
• Advising and supporting managers, project leads, test leads and staff in meeting quality goals
• Proactively informing all stakeholders of quality issues
• Collaborating closely with test leads/managers
• Supporting internal acceptance and approval
• Managing project documentation (with project manager)

Technologies: PMOPlus, JIRA, MS Office, Rochade, Confluence

Supporting the Migration and Data Management subproject in Transaction Banking to build a reconciliation database during migration from the Core Banking System Bank21 (including CCP) to Temenos T24.

• Setting up an Oracle database
• Assisting business analysts with completeness checks
• Redesigning migration steps (ETLs) based on extracts from internal/external sources and mapping documents
• Developing/updating reconciliation reports
• Participating in mapping workshops
• Conducting data masking processes
• Measuring success/quality checks before test handovers
• Aligning with offshore teams
• Presenting interim results to program management and stakeholders

Technologies: Python 3.7.6 (Pandas), Jupyter Notebook, PyCharm, Oracle, SQL Developer, JIRA, MS Office, Confluence, ASANA

Fraud Detection System. Developing a statistical risk tool for online fraud detection.

• Business concept
• Developing a test management framework
• Test concept
• Coordinating/creating test object catalog
• Implementing the full 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

Building a Hadoop-based big data lake for cybersecurity to provide machine data (Netflow, proxy, etc.) in real-time/near real-time to stakeholders/business areas, enabling more efficient cyber attack response.

• Test analysis based on business requirements
• Creating technical and functional test cases
• Developing a test framework
• Executing manual and Talend-automated tests
• Creating/updating test concept/strategy
• Maintaining a release management plan
• Designing and documenting a propagation concept
• Designing and implementing a CI pipeline with TeamCity (plus Nexus, GIT)
• QA of all SDLC documents (Dev & Test)
• DR tests on 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, Unix, Kafka 0.8.2 & 0.9.1, Zookeeper 3.4.8, HDFS, HUE, Nexus, Puppet, Jenkins 2.15, TeamCity 9.1.8

Digital CRM – implementing a new data mining tool to deliver personalized offers in real-time via the right channel.

• Analyzing specifications (functional design) and technical design for test-relevant topics
• Defining test objects and cases from functional and technical concepts
• Assisting test managers in planning
• Leading technical test teams
• Ensuring documentation in HP ALM
• Participating in deviation management
• Defining requirements for test data and environments for functional and non-functional tests
• Contributing to test concept creation
• Coordinating and conducting technical and functional tests (e.g. webservices, campaign setups, offer form setup, mining model creation, control table management, web tracking)
• 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, SAS Management Console, SAS Customer Experience Targeting 6.3, SAS IMAP 4.4, Oracle DWH, DB2/Toad, UC4/OPC, SOAP UI 5.0.0, WinSCP, Putty

Demand-based cluster testing in a DWBI environment / Testing campaign management systems:

• iCP (Integrated Campaign Platform)

• CAI (Customer Analytics and Insights)

• ODS (Online Data Store)

• Reviewing specification documents (application, solution and functional interface specs)

• Coordinating offshore cluster test team

• Creating & reviewing test concepts

• Developing test plans and strategies with effort estimates

• Writing test cases / catalogs / scenarios for functional and non-functional requirements

• Creating test data

• Creating test campaigns (inbound, outbound, email, mail)

• Manual test execution

• Adapting XML test suites for automated tests

• Conducting automated regression tests

• Testing web services with SOAP UI

• Creating daily/weekly reports and contributing to 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

Migrating data from the COBOL-based legacy system KBO/KBO Online to the new Oracle-based Cassiopae system (ETL).

• Implementing given specifications and mapping concepts
• Creating and adjusting mapping documents and specs
• Designing and adapting Informatica mappings

Technologies: Informatica PowerCenter, Oracle, Toad for Oracle, Mantis, WinSCP, Putty, MS Excel

Statistical evaluation in oil exploration. Creating predictive models to estimate oil occurrence probability based on soil air chemistry and geological/seismic data.

Technologies: STATISTICA, Excel

Analyzing and programming a credit risk data mart.

• Analyzing source data from core banking systems
• Implementing functional concepts in SAS Base programs
• Documenting SAS programs
• Managing a SAS Base job control system
• Verifying data mappings implementation
• Extending ETL data loads with SAS Base
• Creating UNIX scripts for load control
• Managing DWH data deliveries
• Data analysis for risk management data mart
• Post-merger source data analysis
• Customer data analysis to prepare mapping
• Creating test concepts, plans and strategies
• Writing test cases, catalogs and scenarios
• Generating test data
• Conducting component tests

Technologies: Doxygen, SAS Base/Macro 9.1/9.2, UNIX AIX, SAS BIS DDS, HP Quality Center, Oracle DWH

Analysis and programming in motor insurance.

• Designing and programming tariff calculation
• Supporting risk statistics for public insurers
• Data validation and cleaning
• Presenting results in Excel tables and charts
• Creating ad-hoc analyses

Technologies: SAS Base 9.1, Enterprise Guide, DI Studio 3.4, Oracle DWH

Statistical analysis and programming for pharmacokinetic data from a clinical study on food interaction.

• Statistical evaluations of Phase I studies
• Data preparation and analysis
• Developing validation programs based on the Statistical Analysis Plan (SAP)

Technologies: SAS Base 8.1/Macro, SAS Enterprise Guide, MS Excel, Oracle DWH