Yevgeniy Österle
Business & Data Analyst
Experience
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
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
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)
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)
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)
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
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
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
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
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
Test Analyst
Commerzbank AG
- Analysis of system processes
- Creation of test cases
- Definition of data requirements
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
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
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).
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).
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
Education
FOM University of Applied Sciences for Economics & Management
Master of Science in Big Data & Business Analytics · Big Data & Business Analytics · Essen, Germany
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
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Yevgeniy based?
What languages does Yevgeniy speak?
How many years of experience does Yevgeniy have?
What roles would Yevgeniy be best suited for?
What is Yevgeniy's latest experience?
What companies has Yevgeniy worked for in recent years?
Which industries is Yevgeniy most experienced in?
Which business areas is Yevgeniy most experienced in?
Which industries has Yevgeniy worked in recently?
Which business areas has Yevgeniy worked in recently?
What is Yevgeniy's education?
Does Yevgeniy have any certificates?
What is the availability of Yevgeniy?
What is the rate of Yevgeniy?
How to hire Yevgeniy?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Tester, Test & Data Analyst
Nearby freelancers
Professionals working in or nearby Bad Vilbel, Germany