Carsten Leschik - Business / Functional Analyst and Oracle Developer DWH

Q: Where is Carsten based?

Carsten is based in Lübben (Spreewald), Germany .

Q: What languages does Carsten speak?

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

Q: How many years of experience does Carsten have?

Carsten has at least 28 years of experience. During this time, Carsten has worked in at least 12 different roles and for 9 different companies . The average length of individual experience is 2 years and 4 months . Note that Carsten may not have shared all experience and actually has more experience.

Q: What is Carsten's latest experience?

Carsten's most recent position is Business / Functional Analyst and Oracle Developer DWH at Comdirect .

Q: What companies has Carsten worked for in recent years?

In recent years, Carsten has worked for Comdirect , Westnetz (EON) , Deutsche Bank AG , and Alte Leipziger Versicherung .

Q: Which industries is Carsten most experienced in?

Carsten is most experienced in industries like Banking and Finance , Utility Services , and Insurance . Carsten also has some experience in Information Technology (IT) and Government and Public Administration .

Q: Which business areas is Carsten most experienced in?

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

Q: Which industries has Carsten worked in recently?

Carsten has recently worked in industries like Banking and Finance , Utility Services , and Insurance .

Q: Which business areas has Carsten worked in recently?

Carsten has recently worked in business areas like Information Technology (IT) , Quality Assurance (QA) , and Product Development .

Recommended expert

Lübben (Spreewald), Germany

Experience

Aug 2024 - Present

1 year 7 months

Quickborn, Germany

Business / Functional Analyst and Oracle Developer DWH

Comdirect

Requirements analysis
Source data analysis
Development of ETL pipelines
Data modeling of the staging, core and mart layers
Calculation of key performance indicators (KPIs) at the mart layer
Methods used: Agile, Data Vault 2.0
Technologies used: Oracle 19, ODI, PL/SQL, Kafka, Python, PowerDesigner, SAP-BO, Git, Jira, Confluence

Jul 2023 - Present

2 years 8 months

Dortmund, Germany

Business / Functional Analyst and Lead Oracle Developer for the migration of asset data and maintenance plans from ACOS to

Westnetz (EON)

Analysis of the data and hierarchical structures to be migrated in the ACOS source system
Analysis of the target data structure in SAP
Design, implementation and testing of the framework for migrating asset data
Implementation and testing of class-based migration of master and attribute data based on the migration framework
Implementation and testing of maintenance plans migration
QA of migrated data
Performance tuning of migration processes
Methods used: Agile, Scrum
Technologies and tools used: Oracle 19, DBeaver, Excel, PL/SQL, Git, Sharepoint, Jira

Aug 2020 - Jun 2024

3 years 11 months

Eschborn, Germany

Business and Functional Analyst for the migration of Postbank in the Sales Management area

Deutsche Bank AG

Analysis of the relevant business processes and use cases of Postbank
Requirement analysis/management in direct contact with business departments, the Architecture Board, stakeholders and application owners
Functional and non-functional requirements
Analysis of the target application landscape for migrating Postbank’s business processes
Concept and design of a new back-end system at Deutsche Bank to manage the “Sales Event” business object class
Analysis and design of all necessary application interfaces
UI/UX design
Team lead for offshore development of ETL processes
Team lead for business and functional analysis
Data security officer: architecture and design of data security mechanisms, definition of data retention periods and coordination with BISO and TISO stakeholders
Definition of SIT and UAT test cases
QA: code review and performance tuning
UAT management
Defect management
Agile: product owner, partly scrum master, QA, backlog grooming, release planning, definition of epics, user stories and defects
Methods, technologies and tools used: Jira, Bitbucket, Confluence, HP-ALM, ServiceNow, SharePoint, Oracle, ODI, Informatica, MS Office

Aug 2020 - May 2022

1 year 10 months

Oberursel, Germany

Analysis, development and optimization of datamarts in the sales area

Alte Leipziger Versicherung

Building a central “time” dimension with all the time references needed across the group
Optimizing the dimension and fact structure for a better balance between load and access times
Designing access to n-dimensional data marts that contain (n-x)-dimensional fact classes
Designing and implementing a PL/SQL framework for generating and executing dynamic SQL
Designing and implementing a PL/SQL framework for defining and executing domain data consistency checks based on the developed generic framework
Methods, technologies and tools used: Oracle Exadata, PL/SQL, SQL, SQL Developer, ODI, Data Vault, TFS, MS Office

Apr 2020 - Jul 2020

4 months

Frankfurt, Germany

Technical operations and further development in the fund accounting area

Helaba Invest

DevOps and 3rd level support for standard software: Xentis, Calculo and DMS (ETL tool)
Responsible for the Swift 2020 project to implement automatic reconciliation of outgoing payments (MT103) with confirmations via the API of the Swift Payment Tracker
Responsible for the project to automate position reconciliation for interest rate swaps with custodians
Responsible for the project to develop a central platform for file exchange via SFTP with external institutions
Methods, technologies and tools used: Oracle, DMS, Java, Git, Jira, Eclipse, Toad, SQL Developer, Xentis, Final, Calculo, Doxis, Windows PowerShell, UltraEdit and Microsoft Office

Feb 2020 - Mar 2020

2 months

Oberursel, Germany

Migration of the agent portal from Cognos/SDK to Oracle/Web Services

Alte Leipziger Versicherung

Functional analysis of the underlying metrics
Design and implementation of the OLAP data model
Design, implementation, and unit testing of the ETL processes
Design of the web services
Methods, technologies, and tools used: Oracle Exadata, PL/SQL, SQL, SQL Developer, TFS, MS Office

Oct 2019 - Dec 2019

3 months

Berlin, Germany

Migration of Oracle Reports to a web service-based reporting system

Deutsche Rentenversicherung DRV

Design, implementation, and testing of PL/SQL functions to generate raw report data in XML format
Design, implementation, and testing of XSLT templates to generate the SOAP messages for the web service that creates reports in PDF format
Methods, technologies, and tools used: Oracle 12, PL/SQL, SQL, SQL/XML, XSLT, SQL Developer, XMLSpy, SVN, Jira, and Apex

Feb 2014 - Sep 2019

5 years 8 months

Frankfurt, Germany

Development of a global risk monitoring and reporting system

Deutsche Bank AG

Responsible for the data model
Responsible for the three layers of the data warehouse
Development of the ETL processes
Development of a highly sophisticated collateral assignment algorithm based on the integration layer
Development of the OLAP data model
Development of the data marts for Cognos reporting, the risk monitoring dashboard, and stress testing
Development of the risk monitoring dashboard
Design and implementation of data historization with compression
Functional analysis, design, and implementation of KPI reporting
Development of the stress testing application
Development of a database-based logging API
Development of an HTTPS API for consuming web services
Oracle performance tuning
Data anonymization and de-anonymization
Architecture and design of distributed databases
Design and implementation of a full-text search for normalized instrument data
Implementation of an audit trail API
Methods, technologies, and tools used: Oracle 11 and 12, SQL, PL/SQL, SQL*Plus, XML, Shell Script, SVN, GIT, Toad, PL/SQL Developer, SQL Developer, Jira, XMLSpy, Exadata

Oct 2013 - Jan 2014

4 months

Frankfurt, Germany

Prototyping a CRM system for structured deposits

Deutsche Bank AG

Migration of a user-developed application (MS Access) to a compliant platform (Oracle, Linux, application server)
Responsible for database and backend design and implementation
Responsible for the design and implementation of interfaces to the trading, finance, and booking systems
Methods, technologies, and tools used: Oracle 11, PL/SQL, SQL, SQL*Plus, XML, XSL, Java, Shell Script, MS Access

Oct 2011 - Sep 2013

2 years

Makati City, Philippines

IT outsourcing and cloud computing market study

IT-Outsourcing

Negotiations with potential outsourcing partners
Architecture and design of cloud solutions
Management of outsourcing projects
Presentation and panel discussion at the International Franchise Conference 2012 (Manila, Philippines) on cloud computing

Nov 2005 - Aug 2011

5 years 10 months

Eschborn, Germany

Development of a global Clearing & Settlement system for Global Custody Transaction Banking (On Market, OTC, securities lending

Deutsche Bank

Responsible for OLTP and OLAP database design and development
Responsible for metadata and golden source master data
Responsible for backend design and development, including complex algorithms for CCP netting, client matching, settlement and corporate actions
Responsible for DWH, ETL and reporting
Responsible for inbound and outbound SWIFT messaging (PACS)
Responsible for inbound and outbound interfaces to global market places, clearing institutes and clients
Responsible for internal interfaces to booking systems and MIS
Methods, technologies and tools used: Oracle 11, PL/SQL, SQL, SQLPlus, XML, XSL, Java, Shell Script

Sep 1997 - Oct 2005

8 years 2 months

Frankfurt, Germany

Development of a Clearing & Settlement system for Domestic Custody Transaction Banking (On Market, OTC, securities lending and

Dresdner Bank AG and DrKW

Responsible for data modeling
Responsible for backend development
Responsible for external and internal interfaces
Responsible for the euro conversion
Responsible for posting securities transactions
Responsible for SWIFT communication
Responsible for implementation of corporate actions
Methods, technologies and tools used: Informix, Informix-SPL, Unix Shell Script, C, Java Tcl, Python

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 (25.5 years), Utilities (2.5 years), Insurance (2 years), and Information Technology (2 years).

Banking and Finance

Utilities

Insurance

Information Technology

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 (28 years), Business Intelligence (14.5 years), Quality Assurance (5.5 years), Product Development (4 years), Project Management (2 years), and Finance (0.5 years).

Information Technology

Business Intelligence

Quality Assurance

Product Development

Project Management

Finance

Summary

More than 26 years of experience in IT consulting and business analysis and more than 17 years of Oracle experience

Skills

All Aspects Of It Projects
Business And Functional Analysis
Requirements Management
Architecture And Design
Prototyping
Development
Testing: Unit (Cit), Integration (Sit), User Acceptance (Uat)
Deployment
Level 2 And 3 Support
Devops
Agile, Scrum: Roles As Product Owner, Scrum Master And Developer; Epics, User Stories And Defects
Oracle Database Development
Sql, Ddl, Dml, Pl/sql, Sql*plus, Java Stored Procedures, Data Objects
Apex, Forms, Reports
Xml, Xpath, Xslt, Sql/xml, Xsd
Html, Https, Web Services, Wallets, Acl
Oracle Aq
Hierarchical Data
Oltp, Olap
Data Warehouse, Etl, Data Marts, Reporting, Dashboards
Oracle Odi
Bi, Kpi
Replication, Distributed Databases, Dblink
Performance Tuning
Dba, Server Parameter Setup
Complex Algorithms
Oracle Data Vault
Exadata
Data Vault 2.0 Modeling
Other Databases
Informix
Db2
Mysql
Ms Sql Server
Ms Access
Sybase
Unix Development
Ksh, Bash
Shell Scripting, Tcl, Python, C, Java
Banking
Dresdner Bank Frankfurt, Deutsche Bank Frankfurt, Amsterdam, Switzerland, Luxembourg, Usa And Singapore; Helaba Invest Frankfurt; Comdirect
Transaction Banking, Domestic And Global Custody, Wealth Management, Investment Banking, Retail Banking, Kvg, Fund Management, Portfolio Management
Trading, Security Master Data, Market Data And Time Series, Order Routing, Trading Venues
Clearing & Settlement, Structured Deposits, Risk Management, Payments, Corporate Actions, Treasury, Finance, Sales Management/steering, Reconciliation
Securities, Bonds, Fixed Income, Structured Deposits, Funds, Derivatives, Swaps, Warrants, Certificates, Commodities
Swift Messaging For Securities Clearing & Settlement And Payments Including Sepa
Swift (Mt, Mx): Mt1xx, Mt2xx, Mt5xx, Camt, Pacs, Sese, Seev
Swift Parsing And Generation
On-market Transactions, Xetra, Deutsche Börse Clearing, Ccp, Otc, Securities Lending And Repo Transactions
Kyc, Legal Reporting
Data Security Governance
Insurance
German Pension Insurance Drv, Alte Leipziger / Hallesche Versicherung, Ergo, Zurich, Hdi
Sales, Teller Applications
Energy Providers
Westnetz, Eon
Asset Management, Maintenance Planning

Languages

German

Native

English

Advanced

Education

Diploma in Computer Science · Theoretical Computer Science

Profile

Created

August 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

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

Where is Carsten based?

Carsten is based in Lübben (Spreewald), Germany.

What languages does Carsten speak?

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

How many years of experience does Carsten have?

Carsten has at least 28 years of experience. During this time, Carsten has worked in at least 12 different roles and for 9 different companies. The average length of individual experience is 2 years and 4 months. Note that Carsten may not have shared all experience and actually has more experience.

What roles would Carsten be best suited for?

Based on recent experience, Carsten would be well-suited for roles such as: Business / Functional Analyst and Oracle Developer DWH, Business / Functional Analyst and Lead Oracle Developer for the migration of asset data and maintenance plans from ACOS to, Business and Functional Analyst for the migration of Postbank in the Sales Management area.

What is Carsten's latest experience?

Carsten's most recent position is Business / Functional Analyst and Oracle Developer DWH at Comdirect.

What companies has Carsten worked for in recent years?

In recent years, Carsten has worked for Comdirect, Westnetz (EON), Deutsche Bank AG, and Alte Leipziger Versicherung.

Which industries is Carsten most experienced in?

Carsten is most experienced in industries like Banking and Finance, Utility Services, and Insurance. Carsten also has some experience in Information Technology (IT) and Government and Public Administration.

Which business areas is Carsten most experienced in?

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

Which industries has Carsten worked in recently?

Carsten has recently worked in industries like Banking and Finance, Utility Services, and Insurance.

Which business areas has Carsten worked in recently?

Carsten has recently worked in business areas like Information Technology (IT), Quality Assurance (QA), and Product Development.

What is Carsten's education?

Carsten attended education in Theoretical Computer Science.

What is the availability of Carsten?

Carsten is immediately available for suitable projects.

What is the rate of Carsten?

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