Erhan Yayli, Developer in Vienna, Austria
Erhan is currently unavailable

Erhan Yayli

Data Engineer and Software Developer

Vienna, Austria

Toptal member since October 17, 2022

Expertise
Software DevelopmentData AnalysisData EngineeringOracle DevelopmentSQLDatabaseETLAgile DevelopmentData MigrationVB.NETJavaExtJS
Bio

Erhan is a value-focused professional with diversified experience in designing and leading data-related IT products and services. He is known for providing robust projects, designs, architecture, and solutions and is proficient in designing and delivering solutions for business intelligence and data warehousing. He has extensive experience in the finance sector.

Portfolio

Erste Digital
Oracle, Data Modeling, ETL, PL/SQL, Liquidity Coverage Ratio (LCR)
Cybersoft
Java, Oracle, Finance, Ext JS
Raiffeisen Bank International
Oracle, Oracle Financial Services Analytical Applications (OFSAA)

Experience

  • ETL - 20 years
  • SQL - 20 years
  • Data Modeling - 20 years
  • Databases - 20 years
  • Oracle - 20 years
  • PL/SQL - 20 years
  • Data Analysis - 15 years
  • Data Engineering - 10 years

Preferred Environment

Oracle, PL/SQL, SQL, ETL Tools

The most amazing...

...success I've achieved is designing and delivering Oracle data warehouses and banking analytical apps that are still in use in 10+ countries after a long time.

Work Experience

Senior Business Intelligence Consultant | Freelance Contractor

2015 - 2022
Erste Digital
  • Acted as the senior business intelligence consultant for Erste Group to build one of CEE's largest risk-oriented financial data warehouses to consolidate the daily LCR reporting needs of its 60+ subsidiaries.
  • Designed and developed the backbone of the ETL process and implemented the framework for critical ETL components while identifying and resolving existing critical design problems.
  • Redesigned the workflow application architecture to fulfill the needs of 60+ tenants using the system in a parallel manner.
  • Designed the master data management system for business configuration management.
  • Designed the KAMAKURA application interfaces to support multiple use cases in an easy-to-maintain manner.
  • Acted as a lead developer for liquidity, ALMM calculation, and reporting projects.
  • Led 5+ developers in solution design, architectural decisions, and technical methodologies.
Technologies: Oracle, Data Modeling, ETL, PL/SQL, Liquidity Coverage Ratio (LCR)

Calibus Project Partner, Team Leader, and Consultant | Freelance Contractor

2014 - 2015
Cybersoft
  • Created and implemented brand-new banking profitability applications, such as Oracle OFSAA. Designed full product suite, including architecture, feature set, and data models.
  • Designed end-to-end productivity calculation application and executed it in the market.
  • Supervised and assisted 10+ team members in achieving set goals.
Technologies: Java, Oracle, Finance, Ext JS

Profitability Project OFSA/OFSAA Consultant | Freelance Contractor

2005 - 2015
Raiffeisen Bank International
  • Designed and built the end-to-end profitability and FTP solution used by 10+ Raiffeisen subsidiaries.
  • Built numerous complementary sub-products with the Oracle OFSAA product suite.
  • Led internal technical team to learn and achieve set goals.
Technologies: Oracle, Oracle Financial Services Analytical Applications (OFSAA)

Principal Data Warehouse Consultant

1999 - 2005
Oracle
  • Accomplished mid- and large-size projects by operating desktop reporting tools and data warehouse solutions using Oracle Database, Oracle OFSAA, and Oracle Discoverer.
  • Contributed to sales and presales processes for OFSA and data warehousing solutions.
  • Designed various parts of the largest telecommunication data warehouse in Turkey.
Technologies: Oracle, PL/SQL, Databases

Experience

Rule Migration Tool For OFSAA

Built a complementary tool for the Oracle OFSAA suite for the management of rule migrations between remote systems. The tool is licensed by 15 banks. It was implemented using VB.NET technology. After Oracle included a similar functionality in the standard product suite, the tool became obsolete.

Calibus Application

Accurate profitability calculation in banking requires almost complete banking data in the most possible granular way. Besides the data and performance challenges, it requires a configurable business rule engine to accommodate calculation rules that are generally changing at a fast pace. Designed a rule-based web application with server-side components that are used for banking FTP calculations and cost allocations.

Inventory Management System

Designed and developed a .NET-based inventory management application. The application was used as a temporary solution for a few years in a large automobile company in Turkey before the company switched to SAP.

Master Data Management System

Master data management is a critical topic in the finance world, especially when multiple external data sources are involved in the BI chain. Designed a master data management tool that simplifies the definition, standardization, versioning, uploading, and provisioning of tabular dimensional data, hierarchical dimensional data, and business mappings used within the data pipeline and BI data analysis structures.

Education

2000 - 2003

Master of Business Administration (MBA) in eCommerce

Yeditepe University - Istanbul, Turkey

1992 - 1997

Bachelor's Degree in Computer Science

Marmara University - Istanbul, Turkey

Skills

Languages

SQL, VB.NET, Excel VBA, Java

Paradigms

ETL, Agile Project Management, Application Architecture

Platforms

Oracle, Oracle Database, Software Design Patterns

Storage

PL/SQL, Databases, DB, Master Data Management (MDM)

Frameworks

Ext JS, VB.NET WinForms, Swing

Other

ETL Tools, Software Development, Product Management, Data Modeling, Oracle Financial Services Analytical Applications (OFSAA), Software Design, Data Analysis, Data Engineering, Commercial Banking, Business Rules, Delivery, Team Management, Data Migration, Performance Tuning, IT Project Management, Liquidity Coverage Ratio (LCR), Finance, Web App UI, Windows UI Design

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring