Carsten L.
Business / Functional Analyst and Oracle DWH Developer
Experience
Aug 2024 - Present
1 year 1 monthQuickborn, Germany
Business / Functional Analyst and Oracle DWH Developer
Comdirect
- Requirement analysis
- Source data analysis
- Development of ETL pipelines
- Data modeling of staging, core, and mart layers
- Calculation of key figures (KPIs) in 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 2 monthsDortmund, Germany
Business / Functional Analyst and Lead Oracle Developer for the migration of asset data and maintenance plans from ACOS to
Westnetz (EON)
- Analysis of data to be migrated and hierarchical structures 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 plan 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 monthsEschborn, Germany
Business and Functional Analyst for the migration of Postbank in sales management
Deutsche Bank AG
- Analysis of relevant business processes and use cases of Postbank
- Requirement analysis/management in direct contact with business units, architecture board, stakeholders, and application owners
- Functional and non-functional requirements
- Analysis of the target application landscape for migrating Postbank business processes
- Concept and design of a new Deutsche Bank backend system 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 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, partial 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 monthsOberursel, Germany
Analysis, development, and optimization of data marts in sales
Alte Leipziger Versicherung
- Creation of a central “time” dimension with all necessary time references for the group
- Optimization of the dimension and fact structures for a better balance between load and access times
- Concept for accessing n-dimensional data marts that contain (n-x)-dimensional fact classes
- Concept and implementation of a PL/SQL framework for generating and executing dynamic SQL
- Concept and implementation of a PL/SQL framework for defining and executing business 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 monthsFrankfurt, Germany
Technical operations and further development in fund accounting
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 Swift Payment Tracker API
- 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 monthsOberursel, Germany
Migration of the agent portal from Cognos / SDK to Oracle / web services
Alte Leipziger Versicherung
- Business analysis of the underlying key figures
- 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 monthsBerlin, Germany
Migration of Oracle Reports to a web service–based reporting system
Deutsche Rentenversicherung DRV
- Design, implementation and testing of the PL/SQL functions for generating the report raw data in XML format
- Design, implementation and testing of the XSLT templates for generating the SOAP messages for the web service to produce the 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 monthsFrankfurt, Germany
Development of a global risk monitoring and reporting system
Deutsche Bank AG
- Responsibility for the data model
- Responsibility 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
- Business 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 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, SQLPlus, XML, shell script, SVN, GIT, Toad, PL/SQL Developer, SQL Developer, Jira, XMLSpy, Exadata
Oct 2013 - Jan 2014
4 monthsFrankfurt, Germany
Prototyping of 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)
- Responsibility for database and backend design and implementation
- Responsibility for design and implementation of the interfaces to the trading, finance and booking systems
- Methods, technologies and tools used: Oracle 11, PL/SQL, SQL, SQLPlus, XML, XSL, Java, shell script, MS Access
Oct 2011 - Sep 2013
2 yearsMakati City, Philippines
Market study on IT outsourcing and cloud computing
IT-Outsourcing
- Negotiations with potential outsourcing partners
- Architecture and design of cloud solutions
- Management of outsourcing projects
- Presentation and expert panel at the International Franchise Conference 2012 (Manila, Philippines) on cloud computing
Nov 2005 - Aug 2011
5 years 10 monthsEschborn, Germany
Development of a global clearing & settlement system for Global Custody Transaction Banking (On Market, OTC, lending and
Deutsche Bank
- Responsibility for OLTP and OLAP database design and development
- Responsibility for metadata and golden source master data
- Responsibility for backend design and development including complex algorithms for CCP netting, client matching, settlement and corporate actions
- Responsibility for DWH, ETL and reporting
- Responsibility for inbound and outbound SWIFT messaging (PACS)
- Responsibility for inbound and outbound interfaces to global marketplaces, clearing houses and clients
- Responsibility 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 monthsFrankfurt, Germany
Development of a clearing & settlement system for Domestic Custody Transaction Banking (On Market, OTC, lending and repo)
Dresdner Bank AG and DrKW
- Responsibility for data modeling
- Responsibility for backend development
- Responsibility for external and internal interfaces
- Responsibility for euro conversion
- Responsibility for booking securities transactions
- Responsibility for SWIFT communication
- Responsibility for the 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 IT consulting and business analysis experience and more than 17 years of Oracle experience
Languages
German
NativeEnglish
AdvancedEducation
Oct 1986 - Jun 1991
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
- English
- Deutsch
2025 © FRATCH.IO GmbH. All rights reserved.