Carsten Leschik

Business / Functional Analyst and Oracle Developer DWH

Avatar placeholder
Lübben (Spreewald), Germany

Experience

Aug 2024 - Present
1 year 6 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 7 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

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

Lorem ipsum dolor sit amet

Diploma in Computer Science · Theoretical Computer Science

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

Similar Freelancers

Discover other experts with similar qualifications and experience

William Nguyen
William Nguyen

Product Owner Frontend

View Profile
Stefan Corsten
Stefan Corsten

SSIS Development

View Profile
Torsten Glunde
Torsten Glunde

BI consultant

View Profile
Joachim Bleichert
Joachim Bleichert

Further development and maintenance of a company-wide monitoring database

View Profile
Alexander Zhirov
Alexander Zhirov

Senior Data Architect & Data Engineer

View Profile
Alex Odesser
Alex Odesser

Contractor

View Profile
Markus Groh
Markus Groh

Data Solution Architect, Founder

View Profile
Marcus Kühl
Marcus Kühl

Senior Software Developer (APEX)

View Profile
Marco Skulschus
Marco Skulschus

Business Analyst, Data Warehouse Developer

View Profile
Germo Görtz
Germo Görtz

BI Developer

View Profile
Ben Spouse
Ben Spouse

Data Engineer/ ETL Developer

View Profile
Felix Meermann
Felix Meermann

Business Developer, Product Owner Support

View Profile
Peter Brungs
Peter Brungs

Data Warehouse Consultant (Development and Analysis)

View Profile
Christian Dröge
Christian Dröge

Requirements Engineer

View Profile
Younes Hadrous
Younes Hadrous

Senior Backend Developer

View Profile
Willi Ziegenhagel
Willi Ziegenhagel

Data Analyst

View Profile
Petru Kisalita
Petru Kisalita

Architect & Technical Team Lead & Senior Developer

View Profile
Felix Reimann
Felix Reimann

SAP Analytics & Planning Expert

View Profile
Guido Klein
Guido Klein

Power BI Report Developer

View Profile
Moez Seyedan
Moez Seyedan

Data Engineer

View Profile
Stefan Wimmer
Stefan Wimmer

Architect/Software Developer/Infrastructure

View Profile
Philipp Grunert
Philipp Grunert

Data Scientist & Data Engineer

View Profile
Steffen Pollin
Steffen Pollin

Senior SAP BI Consultant

View Profile
Eric Bouendeu
Eric Bouendeu

Quality Assurance Manager (QSV)

View Profile
Andre Wroblewski
Andre Wroblewski

PRINCE2® Foundation Examination

View Profile
Henning Uiterwyk
Henning Uiterwyk

Senior Expert Data Governance, Master Data Quality and Data Migration

View Profile
Michael Gonschor
Michael Gonschor

Scrummaster

View Profile
Natascha Kluike
Natascha Kluike

Business Analyst DORA and System Architecture

View Profile
Gurpreet Dhami
Gurpreet Dhami

Digital Finance Consulting – Advanced Data Analysis

View Profile
Henok Abraham
Henok Abraham

Founder and Managing Director

View Profile