Recommended expert

Yevgeniy Österle

Business & Data Analyst

Yevgeniy Österle
Bad Vilbel, Germany

Experience

Sep 2023 - Present
2 years 6 months

Tester, Test & Data Analyst

NORD/LB

  • Analyze system requirements and mapping concepts (ETL requirements) for data flows and transformation logic in the bank's DWH
  • Analyze data in DB tables and views of the DWH using SQL (DB2)
  • Independently define, create, and execute test cases in JIRA Xray (SIT)
  • Write SQL queries in DB2 to verify data scenarios and mappings
  • Create test plans for SAP FSDP and concurrent projects
  • Conduct error and root cause analyses in coordination with business analysts, developers, test managers, and the infrastructure team
  • Thoroughly document test results in JIRA Xray
  • Coordinate between business analysis, development, DB infrastructure, business units, and external vendors
Jul 2020 - Jun 2023
3 years

Requirements Engineer, Business- & Data Analyst

DWS GmbH & Co. KGaA

  • Gather business requirements for a specialized reporting solution and analyze data in an MS SQL database
  • Create technical designs for calculation logic for performance, fund assets, turnover, and risk and performance metrics
  • Define new processes and replace manual workarounds with reporting software
  • Implement and test functional requirements in database tables, views, and stored procedures
  • Analyze investment guidelines and broker setups for the Brexit task force and derive correct system requirements
  • Report to task force leads in Frankfurt and London
  • Align regulatory requirements from PRIIPs RTS with technical implementation in EPTs and conduct a proof of concept
  • Create decision papers for steering committees on connecting real estate funds
  • Analyze existing data via SQL and derive functional data requirements
  • Define and model target processes using BPMN
  • Conduct gap analyses and technical specification of data mappings and calculation logic
  • Align requirements with product owner, define user stories, maintain backlog, and requirements engineering (SCRUM)
  • Provide continuous implementation support and coordinate development work
Oct 2019 - May 2020
8 months

Business Analyst

Helaba Invest

  • Analyze and document existing interfaces
  • Assist in selecting service providers and ETL software (Talend, Informatica, SSIS)
  • Analyze and specify current and target processes for a proof of concept with Talend and SSIS
  • Capture existing data flows and define target data flows
  • Create test scenarios and support setting up target processes in selected tools (Talend, SSIS, toBrain.NET)
May 2019 - Oct 2019
6 months

Functional-/Data Analyst

NORD/LB

  • Analyze business requirements for the EBA stress test 2020 and collaborate on the conceptual data model for securities
  • Analyze data structures in the DB2 database using SQL
  • Develop mapping concepts for data solutions in the DWH (SPOT)
  • Design data solutions for the FRTB regulation
  • Provide implementation support and testing
  • Contribute to the technical target architecture for integrated interest rate management
  • Create user stories and plan sprints (agile methods)
Nov 2018 - Mar 2019
5 months

Business- und Functional Analyst, Requirements Engineer

DWS GmbH & Co. KGaA

  • Analyze business requirements and translate them into functional specifications
  • Describe the aggregation and calculation logic of fund holdings
  • Align the exposure calculation for derivatives
  • Perform data analysis in an MS SQL database
  • Execute SIT and support business units during UAT
  • Analyze regulatory and client reports (EMIR, Basel III, GroMiKV, short selling)
  • Determine scope and estimate development efforts
  • Contribute to the technical target architecture for regulatory reporting and project plans (waterfall model)
  • Shape sprints (agile methods)
Apr 2018 - Oct 2018
7 months

Business and Functional Analyst, Requirements Engineer

DWS GmbH & Co. KGaA

  • Analysis of documentation and business processes in Germany, UK and USA
  • Translation of business requirements into functional requirements for IT developers in India
  • Specification of user stories and acceptance criteria in JAMA and JIRA
  • Development of business logic and system behavior
  • Support of the SCRUM team during implementation
  • Analysis of product types and derivation of functional requirements for the global product master
  • Analysis of regulatory data requirements (MiFID, PRIIPs)
  • Data analysis using SQL and expertise in Oracle database
  • Contributing to sprints
Jul 2016 - Mar 2018
1 year 9 months

Business/Functional Analyst, Requirements Engineer

DWS GmbH & Co. KGaA

  • Analysis and alignment of business requirements for the Global Client Reporting Package (GCRP)
  • Creation of business specifications and gathering of data requirements for a new data warehouse
  • Analysis of business and data requirements in the source system Aladdin as well as regulatory dependencies (MiFID 2, EMIR)
  • Support in strategic decision making and coordination with enterprise architects
  • Analysis of business processes and use cases for vendor selection
  • Support of proof of concept with vendors and creation of scorecards
  • Analysis of functional gaps and data flows for a global data warehouse
  • Creation of functional specifications and data analysis using SQL in Oracle and MS SQL
  • Supporting the implementation phase
Jan 2016 - Apr 2016
4 months

Business Analyst

Commerzbank AG

  • Analysis of regulatory requirements from the PRIIPs regulation and business processes of consumer systems
  • Creation of business concepts for IT implementation and description of technical interfaces
  • Support in the creation of the IT high-level concept and IT architecture
Apr 2015 - Jan 2016
10 months

Functional Analyst, Tester/Test Manager, Developer

Erste Bank Group AG

  • Analysis of business requirements and design of the functional solution
  • Implementation in EffCom Passiv+ (proprietary syntax)
  • Creation and execution of test cases and test concept
  • Coordination of test-related tasks during UAT
  • Analysis of data availability in the Oracle database using SQL
  • Creation of data mappings for the PRIIPs regulation
May 2013 - Mar 2015
1 year 11 months

Business and Functional Analyst, Tester

DWS GmbH & Co. KGaA

  • Analysis of requirements for client reporting and process documentation
  • Analysis of data availability and quality in reporting and Oracle databases (SimCorp Dimension)
  • Creation of functional specifications for client reports (Actuate, Excel)
  • Test execution and support of UAT
  • Support of database extensions and portfolio migrations
  • Support during the implementation phase
Feb 2013 - Mar 2013
2 months

Test Analyst

Commerzbank AG

  • Analysis of system processes
  • Creation of test cases
  • Definition of data requirements
Apr 2012 - Dec 2012
9 months

Business Analyst and PMO

Deutsche Börse AG

  • Recording and optimizing business processes according to new legal requirements
  • Creation of business specifications and test cases
  • Preparation and execution of user acceptance tests
  • Analysis of test results
  • Project Management Office
Mar 2011 - Mar 2012
1 year 1 month

OTC Products Trade Settlement Specialist

Wüstenrot Bank AG Pfandbriefbank

  • Creation of a role concept and assignment of minimal permissions on the host
  • Adding and removing user rights in coordination with IT
  • Settlement of OTC derivatives for proprietary trading, building society, KVG and insurance
  • Review and coordination of contracts and master agreements
  • Checking market fairness prices according to MaRisk and fixing interest rates
  • Settlement of Eurex interest rate derivatives, FX swaps, overnight and term deposits
  • Settlement and market price check of promissory note and covered bond issuances
  • Settlement of group and private equity investments
Mar 2008 - Aug 2010
2 years 6 months

Market Control Specialist

Börse-Stuttgart AG

  • Creation of a relational Access database and front-end form
  • Definition of the data entry process and creation of SQL queries
  • Back-office services for securities trading
  • Monitoring and reconciliation of securities transactions, including clearing discrepancies
  • Handling price differences, mistrades and cancellation requests
  • Suspension and resumption of the listing of knock-out certificates
  • Maintenance of an internet database and preparation of trading statistics
  • Preparation of trading data for the §9 report to BaFin

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Banking and Finance (16 years).

Banking and Finance

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (14.5 years), Business Intelligence (10 years), Quality Assurance (6 years), Operations (3.5 years), Project Management (1 year), and Finance (1 year).

Information Technology
Business Intelligence
Quality Assurance
Operations
Project Management
Finance

Skills

Domain And Process Expertise

  • Investment Advisory And Non-advisory Business
  • Securities Processing/settlement And Accounting
  • Processing Of Otc Products (Incl. Derivatives)
  • Exchange Processes, Securities Listing
  • Client Reporting Processes (Investment Management Environment)
  • Automated Document Creation For Structured Derivatives (Certificates)
  • Knowledge Of Mifid Ii, Priips, Solvency Ii, Frtb
  • Basic Knowledge Of Esg

Specialized Applications

  • Simcorp Dimension
  • Aladdin (Blackrock Solutions)
  • Effcom Passiv+
  • Fis Xp – Client Reporting Tool At Dws
  • Vermillion Reporting Suite
  • Xontro (Host)
  • Reuters
  • Hpqc
  • Jama
  • Jira
  • Xray
  • Confluence
  • Alm Test

Methods

  • Business And Data Analysis
  • Functional Design
  • Requirements Management
  • Project Management
  • Scrum (Epics, User Stories)
  • Bpmn
  • Uml
  • Testing And Test Management

Technology Expertise

  • Sql
  • R
  • Python (Pandas, Numpy, Scikit-learn, Kersas, Neural Networks, Machine Learning Algorithms)
  • Ms Sql Server
  • Toad For Oracle
  • Toad For Hadoop
  • Sql Developer
  • Squirel Sql Client (Db2)
  • R Studio
  • Spyder
  • Jupyter Notebook

Standard Software

  • Ms Office
  • Ms Project
  • Ms Visio

Languages

German
Advanced
English
Advanced

Education

Sep 2020 - Jul 2023

FOM University of Applied Sciences for Economics & Management

Master of Science in Big Data & Business Analytics · Big Data & Business Analytics · Essen, Germany

Mar 2006 - Aug 2010

Nürtingen-Geislingen University of Applied Sciences for Business and Environment

Bachelor of Science in Business Administration · Business Administration · Nürtingen, Germany

Certifications & licenses

Certified Exchange Trader

ISTQB Certified Tester

REQB Certified Professional for Requirements Engineering

Profile

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

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Yevgeniy based?

Yevgeniy is based in Bad Vilbel, Germany.

What languages does Yevgeniy speak?

Yevgeniy speaks the following languages: German (Advanced), English (Advanced).

How many years of experience does Yevgeniy have?

Yevgeniy has at least 16 years of experience. During this time, Yevgeniy has worked in at least 13 different roles and for 8 different companies. The average length of individual experience is 1 year and 2 months. Note that Yevgeniy may not have shared all experience and actually has more experience.

What roles would Yevgeniy be best suited for?

Based on recent experience, Yevgeniy would be well-suited for roles such as: Tester, Test & Data Analyst, Requirements Engineer, Business- & Data Analyst, Business Analyst.

What is Yevgeniy's latest experience?

Yevgeniy's most recent position is Tester, Test & Data Analyst at NORD/LB.

What companies has Yevgeniy worked for in recent years?

In recent years, Yevgeniy has worked for NORD/LB and DWS GmbH & Co. KGaA.

Which industries is Yevgeniy most experienced in?

Yevgeniy is most experienced in industries like Banking and Finance.

Which business areas is Yevgeniy most experienced in?

Yevgeniy is most experienced in business areas like Information Technology (IT), Business Intelligence, and Quality Assurance (QA). Yevgeniy also has some experience in Operations, Project Management, and Finance.

Which industries has Yevgeniy worked in recently?

Yevgeniy has recently worked in industries like Banking and Finance.

Which business areas has Yevgeniy worked in recently?

Yevgeniy has recently worked in business areas like Business Intelligence, Information Technology (IT), and Quality Assurance (QA).

What is Yevgeniy's education?

Yevgeniy holds a Master in Big Data & Business Analytics from FOM University of Applied Sciences for Economics & Management and a Bachelor in Business Administration from Nürtingen-Geislingen University of Applied Sciences for Business and Environment.

Does Yevgeniy have any certificates?

Yevgeniy has 3 certificates. These include: Certified Exchange Trader, ISTQB Certified Tester, and REQB Certified Professional for Requirements Engineering.

What is the availability of Yevgeniy?

Yevgeniy will be available from May 2026.

What is the rate of Yevgeniy?

Yevgeniy's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Yevgeniy?

To hire Yevgeniy, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1200
900
600
300
Market avg: 860-1020 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.