Yan W.

Yan W. Email and Phone Number

Data Warehouse Engineer at Versicherungkammer Bayern @ Versicherungskammer Bayern
Yan W.'s Location
Munich, Bavaria, Germany, Germany
About Yan W.

More than 3 years of experience in Bereich Data&Analztics, ETL- and Data-Pipelines, Self-Service-BI-solution.More than 6 years of experience in system configuration, QA testing and Business analyse. Many years extensive IBM mainframe experience in online and batch application system using COBOL, JCL, DB2/SQL, CICS, DB2TOOLS. A self-motivated analytical problem solver with expertise in manual and automated testing for mainframe-based applications. Solid understanding of software development life cycle processes and related quantification methodologies. • Erfassung und Analyse von Businessanforderung• Datenintegration (ETL) aus Quelldateien und Vorsystemen• Customizing und Optimierung Benefit-Administration System• Entwurf, Entwicklung von manuellen und automatischen Testfällen• Testplandurchführung und Analyse der Testergebnisse• Untersuchung von Defekts und Systemprozessen, Fehlerverifikation• Koordinieren und begleiten von Projekten im Rahmen der System•

Yan W.'s Current Company Details
Versicherungskammer Bayern

Versicherungskammer Bayern

View
Data Warehouse Engineer at Versicherungkammer Bayern
Yan W. Work Experience Details
  • Versicherungskammer Bayern
    Data Warehouse Engineer
    Versicherungskammer Bayern Nov 2022 - Present
    Munich, Bavaria, Germany
  • Münchener Hypothekenbank
    Big Data Engineer
    Münchener Hypothekenbank May 2019 - Sep 2022
    Karl-Scharnagl-Ring 10, 80539 München
    Projekt Automatische Ermittlung von Daten Qualität Auffälligkeiten in der BI-plattformBereitsstellung der Ergebniss über Data-Mart und Report Daten Qualität BI-plattformDefinieren Schnittstellen, ETL- und Data-Pipelines bis Implementierung Self-Service-BI-LösungenDesign und Implementierung von Power BI Berichten für verschiedene Abteilungen
  • Bmw Bank Gmbh
    Spezialistin Business Analysis
    Bmw Bank Gmbh Jun 2018 - Dec 2018
    Munich Area, Germany
    ▪Management Centralized Regression Testing: Festlegen Scope, Defekt Analyse undSicherstellung der benötigten Testressourcen▪ Steuern und Unterstützen: Manuelles- und Automatisierungs-Testteam von IT-Provider▪ Durchführen von Reviews: Automatisierungskonzepte und IT-Architekturen▪ Operative Providersteuerung im Rahmen der IT-Projektleitung: enge Zusammenarbeit mit IT, IT-Betrieb und Fachbereichen
  • Aon Hewitt
    System Configuration Specialist /Qa Test(Defined Contribution Enterprise Implementation U.S.A)
    Aon Hewitt Jul 2014 - Aug 2016
    Toronto, Canada Area
    •Complete business requirements analysis, develop workflow diagrams for web application, and test all the functionalities on both GUI and Web platform.•Design and execute test cases, investigate defect rates and provide a list of possible solutions on how to keep these risks under control.
  • Aon Hewitt
    Configuration Specialist/Qa Test(Defined Benefits Team Canada)
    Aon Hewitt Oct 2010 - Jun 2014
    Toronto, Canada Area
    ●Write SQL queries to locate specific test cases, create, update and maintain Maestro tasks●Accorately update test plan and test scripts as required● Debugging Echo testplan for release and regression testing●Set up activities based on analysis specifications●Support production environment (defects and trends), execute workflow and defect management● Design test plans (unit, integration, regression, acceptance) and incorporate recommended updates into test plans.●Design and lead the process of Total Benefit Administration System (TBA) and Data warehouse, resolve various conflicts and issues with different tools (DB2, Tool Box, Conservation, ETL)●Perform GUI, Functional, System, Exploratory, Spot and Web accessibility testing on mainframe environment.●Create regression and integration test plans and execute test cases to verify if appropriate conditionals are printed within the Personalized Communication Statements for the participants ●Analyze defects and debug the system issues when configuration is not producing appropriate results
  • Savings Banks Foundation For International Cooperation (Sbfic)
    Freelance Technical Specialist
    Savings Banks Foundation For International Cooperation (Sbfic) Jul 2009 - Nov 2009
    Bonn Area, Germany
    Technical communication support for audit projects which are related to security specification in bank of China.Translated IT-audit project documentation, communicated development requirements between programming team, QA team and project managers.
  • Volkswagen Bank  Germany
    Quality Assurance Analyst Internship
    Volkswagen Bank Germany Oct 2007 - Jan 2008
    Braunshweig Germany
    ●Cooperated with software developers to tune the SQL queries using SQL Profiler. Supported and monitored implementation qualities through regular database health checks.●Prepared QA status summary reports for each assignment and performed manual data testing staged production releases in quality assurance testing with implementation specialists.●Developed automating processes with automation testing tools.

Yan W. Education Details

Frequently Asked Questions about Yan W.

What company does Yan W. work for?

Yan W. works for Versicherungskammer Bayern

What is Yan W.'s role at the current company?

Yan W.'s current role is Data Warehouse Engineer at Versicherungkammer Bayern.

What schools did Yan W. attend?

Yan W. attended Technische Universität Clausthal, Aon University, George Brown College, University Of Toronto.

Not the Yan W. you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.