Bogdan S. - Data Engineer / DWH Designer / Data Architect

Go to Website

Stadecken-Elsheim, Germany

Experience

Nov 2023 - Present

1 year 10 months

Hanover, Germany

Data Engineer / DWH Designer / Data Architect

BG Phoenics

Design and refactoring of logical and physical data model within a multi-tier DWH (Data Vault 2.0, data lake, STAGE, CORE layer design). Functional and nonfunctional requirements elicitation.
ETL/ELT pipes – design,development and orchestration, design deployment strategy (DevOps, CI/CD) according to the (ITIL 4) stakeholder values.
Design and implement CI/CD deployment and transport methods, hypercare phase support (pre/prod environment), daily operations.
Data provisioning / data injection from/into diverse legacy systems (Azure DataFactory, Dataverse, Business Objects), standard reports consolidation and migration, performance tuning and quality assurance provisoned data. transformation into MS OneLake (POC), definig alerting and notification methods and canals.
Business needs assesement according to the NIS2 directives and their prototypical (POC, MS PowerBi) implementation.
Skills: Innovator 15.2, SAP Hana Studio, MS DataFabric, Amazon Elastic Kubernetes Services (EKS), SAP Hana (incl. CDS/CS Views) HDBSQL, NIS2UmsuCG, Salesforce, Jira /SCRAM, CICD methods, GitHub, Apache Airflow, SAP BO (Webi, Crystal), Python 3.x, SAP Fieldglass, SQL/PLSQL.

Mar 2023 - Oct 2023

8 months

Zürich, Switzerland

Data Analyst / Solution Designer

Zurich Insurance Group AG

Intensive interaction with business stakeholders, estimate and analysis of functional changes. New data objects integration and data extraction from lagacy systems into hub/core/analytical layer of DWH (SAP Datasphere Business Builder).
Migration SAP FI/CO to SAP S/4Hana (master-, transactional- and historical data) from div. SAP/NonSAP legacy systems (Ariba, SuccessFactors…), conversion analysis and preparation of simplification objects, definition of several Cfin transformation and error hqandling. Perequisite work for setup DORA’s regulations.
Determine/define business and natural keys, build the SCD2 methods on the stage/ core layer ("Light Integration"), introduce of bi/multitemporal data historisation routins (within Wherescape RED templates and SAP Data Services).
Provisoning and optimisation of data distribution, orchestration of data pipes (ParTcl), packeting/versioning data models, perform the full and delta loads, scheduling and continuous monitoring loads across the envs, mock data prep. in front of the data migration.
Perform the developer and integration tests, document the tests results, prepare the automatic integrity test methods (incl. envs deployments and building performance metrics), develop the cleansing and notification rules.
Skills: Wherescape (RED, BLUE), ParTcl, Computer System Validation (CSV) guidelines, MS SQL, OpenShift, MS Azure DevOps, Azure Data Factory, „Digital Operational Resilience Act“ – DORA, SAP FI/CO (Cfin*), IBM Process Mining, ABAP (extractors), Fiori, SAP S/4Hana, SAP Powerdesigner / ArchiMate, SQL/TSQL, SAP LSMW, SAP DS 4.3, MLOps Pipes, GitHub.

Apr 2021 - Mar 2023

2 years

Bern, Switzerland

Data Engineer and Migration Developer ADW(”Active DataWarehouse”)

PostFinance AG

Efficient data transfer DB2–2-Oracle incl. migration dashboard solution (retail customers and payment reports).
The performance analysis and several optimizations of long running tasks and reports), run deployments across the envs, monitoring the production rollouts, enabling security protection, the orchestration and stabilisationof ELT processes.
Design and development data models, develop SAP migration strategy, build interfaces and aggregats for Metis's Chatbot solution, implement DSGVO guidelines.
Skills: AS400 DB2 and Oracle 19c Enterprise Edition, SAP FI/CO (IDocs), SAP Data Services 4.x, ABAP OO, SQL/PLSQL, SAP ECC, Quest's Toad, Toad for DB2, Snowflake and Snowpipe, dbt (data-base-tool) with dbtvault plugin, Docker Desktop, IntelliJ IDEA, DevOps, CI/CD pipelines inside of ML frameworks, GitLab, Grafana, Atlassian Software (Jira, Confluence).

May 2020 - Mar 2021

11 months

Braunschweig, Germany

SAP Data Migration Architect / Data Migration Developer

Volkswagen Financial Services

Several data migration projects from div. CRM’s SAP/Non SAP/legacy systems (Salesforce, MS.Dynamics) into SAP S/4 Hana.
Develop the migration strategy for transaction- and master data (MARA), build the mapping documents and GAP-analysis, propagate the changes via DevOps, data profiling and mitigate the data quality issues in SAP FI/CO.
Develop the data validation rules, preparation test cases, validate the integration tests results, visualisation data quality issues (via dashboarding), coordination of Delivery Owners, Go-Live support.
Skills: Informatica PowerCenter 10.2 (with idocs interface, TDM and QM), SAP Migration Cockpit, SAP FI/CO, SAP Embedded Analytics, LSMW/LTMC, Qlik Sence, SAP MDM/MDG, Redshift/ Oracle for data staging.

Dec 2019 - May 2020

6 months

Hanover, Germany

Data Analyst p.p Adesso Group

KKH Hannover

Design and implementation of the methods for “selective data efface”, according to “Art 17 DSGVO” (General Data Protection Regulation – GDPR).
Prototypical implementation of the fast “delete routin” for the high volume database tables inside of the existing Enterprise Data Warehouse.
Development of the efficient Data Lineage Reports to reflect the hierarchical source- target dependency.
Skills: Informatica 10.2 (PowerCenter, Developer, Enterprise Data Catalog, Data Quality, TDM, MX Views), Enterprise Architect/ERWin, TOGAF 9.x, Oracle 19c Multitenant, Microsoft PowerBi Desktop, DAX, PowerOneBi (according to IBCS rules), GitLab.

Jan 2019 - Nov 2019

11 months

Frankfurt, Germany

Self-employed Full Stack Architect

DB Systel / Z.O.D

Project “Decision Service Room – DSR”, design and development enterprise DWH architecture (MySQL Server / PostgresSql on AWS RDS).
Design/implementation logical and physical data model (stage, core and mart(s) layer with „Row Level Security“ enabled).
Build ETL/ELT jobs, orchestration of loading processes cross over the DHW layers and legacy systems, RESTful API and Kafka interfaces.
Extension and customising of existing SAP SAC reports („Smart Predict“, „Smart Discovery“).
Integration and E2E s, performance test preparation, UML.
Skills: Wherescape (3D, RED) and SAP Data Services, GitLab, PostgresSql, IBM AS400/DB2, Data Vault 2.0, TMT, OpenShift, SAP Analytics Cloud (SAC), ABAP, Apache Messaging (Kafka), IntelliJ, Postman API, Keycloak, RESTful API, Set up of the continuous integration / delivery (CI/CD) methods, Atlassian Software (Jira/Confluence).

Feb 2016 - Dec 2018

2 years 11 months

Bern, Switzerland

Self-employed DWH Architect

DB Systel GmbH / SwissPost AG

Build functional Data Marts (PostgresSql with Data Vault 2.0 and Snowflake DB) and publish it to the customers via REST Api connectors.
Transfer existing Informatica workflows into the Amazon Cloud.
Several migration projects around the AWS Cloud Computing (data sourced from DB2, Oracle, flat files...).
Transfer existing Informatica workflows into the Amazon Cloud.
Redirection of existing reporting solution (SAP BOXI) from Oracle to AWS Redshift.
Collection and documentation of functional and non-functional requirements, requirements management.
Build an interface to the SAP PP "Production Planning" and to SAP sAFI (SAP HANA with Calculation Views ans SLT) and set up the daily load pipelines.
Online shop interface, design the connectivity to DWH and SAP Hybris, implementation, tests and roll-out.
Load performance optimisation (full and delta load).
Design of the reporting framework for the hierarchical product composition.
Skills: Informatica 10.2 (Developer, Data Quality Transformations and Product Integration), AWS (managed stack), Redshift, Snowflake (multi cluster), IBM DOORS, IBM AS400, UML, SAP Hana Studio, Talend Open Studio (TOS 7.x), Apache Kafka Streams, IntelliJ with Spring Boot, Jenkins, Swagger, SAP Hana, Informatica PowerCenter 10.x and MDM Module, BMC Remedy, Oracle 11c/12, Snowflake DB, Scaled Agile Framework 4.x (SAFe).

Mar 2013 - Dec 2015

2 years 10 months

Munich, Germany

Subject Matter Expert (SME)

MunichRe AG

Design and development of the data extraction process from HP Service Manager to Enterprise DataWarehouse (EDWH).
Data modelling layered Enterprise DWH (including Performance Data Model and Security Concept).
Cost Reports: Design, development and distribution.
Evaluation of real time data processing methods for the interface to a Cockpit Desktop Solution (the comparison of Informatica's PowerCenter 9.5 vs. SLT vs. BODS 4.1 vs. Oracle ODI 12c).
Preparation of User Acceptance Tests, coaching of power users.
Design and build of regulatory reports according to German Banking Law (SolvV, GroMiKV).
Several preliminary work for Solvency II (technical requirement analysis).
Skills: SAP Business Objects 4.2 SP1 (WebIntelligence, Lumira, Universe Designer, IDT etc.), Business Objects Data Services (BODS), Informatica's PowerCenter 9.5, Oracle ODI 12c, Sybase PowerBuilder, HP Service Manager 9.34, Scrum Technics, Analysis for Office (AfO), Design Studio, Data Vault 2.0, Jira (Atlassian).

Mar 2013 - Dec 2014

1 year 10 months

Subject Matter Expert (SME) (part time, 50%)

Lufthansa AirPlus Servicekarten GmbH

Design and development of the data extraction process from HP Service Manager to Enterprise DataWarehouse (EDWH).
Data modelling layered Enterprise DWH (including Performance Data Model and Security Concept).
Cost Reports: Design, development and distribution.
Evaluation of real time data processing methods for the interface to a Cockpit Desktop Solution (the comparison of Informatica's PowerCenter 9.5 vs. SLT vs. BODS 4.1 vs. Oracle ODI 12c).
Preparation of User Acceptance Tests, coaching of power users.
Design and build of regulatory reports according to German Banking Law (SolvV, GroMiKV).
Several preliminary work for Solvency II (technical requirement analysis).
Skills: SAP Business Objects 4.2 SP1 (WebIntelligence, Lumira, Universe Designer, IDT etc.), Business Objects Data Services (BODS), Informatica's PowerCenter 9.5, Oracle ODI 12c, Sybase PowerBuilder, HP Service Manager 9.34, Scrum Technics, Analysis for Office (AfO), Design Studio, Data Vault 2.0, Jira (Atlassian).

Oct 2012 - Feb 2013

5 months

Munich, Germany

DWH/ETL Architect

MAN AG

"Car Leasing" Project.
Design of the data download from SAP BW (BODS Extractors, PL/SQL).
Orchestration, tuning and reengineering of existing ETL pipelines (OWB and ODI 12c).
Implementation of the business semantic layer (Business Objects Universum) for German Commercial Code (“HGB”).
Design, implementation and tests of the standard reports (WebIntelligence, mainly accounting and billing reports).
Skills: SAP Business Objects 4.1 (DeskI, Dashboard, WebI), Business Objects Data Services (BODS), Oracle OWB, ODI 12c, SAP Bank Analyzer, SAP FI Extractors Oracle 12c, PL/SQL, Data Architect, R.Kimball's Star Schema (Data Marts) and Data Vault (Staging Area), shell scripting, HP (ALM, Quality Center).

Apr 2010 - Aug 2012

2 years 5 months

Frankfurt, Germany

DWH Architect

SEB /Santander Bank

“SMART” project for SEB AG.
Designed and developed a large data warehouse (>1 TB).
Handled various reports for BaFin regulations (Master KVGen, MA-Risk, BAIT, EAEG, “Anlegerentschädigunggesetz”).
Split master data and transaction input after SEB AG was acquired by Santander Bank; integrated the “Mandator Concept” during the carve-out phase.
Performed requirements analysis, sizing, and star schema modeling.
Coordinated between business analysts and development teams.
Designed and built ETL interfaces (Informatica PowerCenter).
Managed releases across environments: Production, Testing, Development, Acceptance.
Tuned performance (SAP BO, Oracle 10g/11c) and optimized Informatica load times.
Upgraded SAP BO from 3.x to BO XI 4.1 (front-end and servers).
Provided knowledge transfer to end users, conducted internal training, and created documentation.
Skills: ITIL, R. Kimball dimensional modeling, UML, Erwin, PL/SQL, Informatica 9.34, PowerShell, Atlassian (Jira, Confluence), Oracle APEX, Oracle 10/11c.

Jan 2009 - Apr 2010

1 year 4 months

Munich, Germany

ETL Team Leader (5 people)

Kabel Deutschland AG

Performed ETL development using SAP BO Data Integrator (formerly BODI, now Data Services) to extract data from SAP RMCA/FI.
Led ETL design and defined extraction strategy from SAP RMCA/FI.
Developed security concept with BO CMC.
Designed and implemented interface to SAP RMCA.
Conducted unit and integration (regression) tests.
Managed project control, progress tracking, and status reporting.
Co-designed the reporting data model (staging and presentation layers) and worked on annual, quarterly, and monthly balance sheets.
Managed releases.
Skills: SAP BusinessObjects suite, BO Data Services, SAP RMCA, FI, Erwin, Quest Toad, Data Vault, MS Project, UML, Subversion (Apache).

Apr 2008 - Dec 2008

9 months

Frankfurt, Germany

Self-employed Consultant

Deutsche Buchhandel (Paragondata GmbH)

Designed and developed data warehouse solutions.
Led the “Real Time DWH” project (Data Office).
Evaluated external suppliers.
Managed P&L (approx. €1M).
Oversaw the entire software development lifecycle (BusinessObjects XI3, BO Data Services 3.1, Oracle 10g).
Developed mappings and workflows using BO Data Services.
Supervised startup phase, rollout, and maintenance.

May 2006 - Apr 2008

2 years

Consultant Business Intelligence

Business Objects Germany

Worked on various customer projects in BI and data warehouses (relational and multidimensional databases).
Tools used: Xcelsius 2008, dashboarding, BO XI R2/R3, BODI (Data Services), PowerCenter 8.x, Erwin.

May 2006 - Apr 2008

2 years

Düsseldorf, Germany

Consultant Business Intelligence

Business Objects Germany

Project for Deutsche Ärzte- und Apothekenbank.
Designed data warehouse and ETL concepts.
Worked with Web Intelligence and InfoView.
Evaluated ETL tools: OWB, BO Data Services, PowerCenter.
Designed data warehouse architecture (staging and presentation schemas, using R. Kimball methodology) with Universe Designer and OWB.

May 2006 - Apr 2008

2 years

Wolfsburg, Germany

Consultant Business Intelligence

Business Objects Germany

Project for Volkswagen AG.
Business Intelligence Study and Quality Assurance with BO Voyager, Essbase Hyperion, Informatica's PowerCenter 8.1 and BO Data Services 3x.
Data Cube design and composition, (PowerCenter, BO Universe Designer).

May 2005 - May 2006

1 year 1 month

Senior Consultant

CapGemini Germany

Prepaid System migration by Polkomtel (Poland), 9 Mio subscribers.
Migration Project Leader (up to 10 developers).
Implementation of Operating Number Portability Directives. Cooperation with Sicap, Switzerlad.
RUP rules and methods.
Skills: OOA /OOD, PL/SQL, ITIL/Cobit framework implementation, Quality Assurance, Sicap PPC5.1 Prepaid System, Distributed Software Development, Outsourcing Coordination.

Jan 2003 - May 2005

2 years 5 months

Team Leader Online Development

EDS Deutschland GmbH

Project for TP S.A. Poland.
Kenan/BP migration strategy.
PowerCenter 7.1 /PowerMart development (ETL, Informatica).
Skills: Migration Strategy, Kenan/BP: GUI- unit and integration testing (WinRunner, TestDirector), Design and develop the PowerCenter's extention: Stored Procedures in Oracle 9i, DLLs, Migration of the PowerMart's mappings into new PowerCenter environment, Adoption of the "old" transaction mechanisms in PowerMart and re-utulize they in PowerCenter, ETL Reporting: Design and implementation, SQL, PL/SQL, C++.

Sep 2001 - Dec 2002

1 year 4 months

Sr. Software Architect

EDS Deutschland GmbH

Project for Health Care Austrian.
OOA/OOD (Rational Rose XDE, Toogether Soft.).
Framework development (J2EE), ETL interface (loading data into target system only).
Customising and optimize of the PowerMart entities (mappings, DLLs, key generators) according to the requirements.
Supervising a team of 5 Application Designer.
Skills: PowerMart, J2EE, BEA Software, SSL & Distributed Systems, XML.

Nov 2000 - Sep 2001

11 months

Migration Team Leader

EDS Deutschland GmbH

Project for Mobile Communication Service Provider (Germany).
Migration from BSCS5.21 to MCBS.
1 Million customer, 1Milion wireless contracts (TwinCard and TwinBill contracts included).
Design of Data Mapping Tool (SQLoader based on ORACLE 8i, ERWIN, SQLPlus).
Cowriting of scripts for the data export (PowerMart from INFORMATICA, SQLPlus).
Responsible for the Analysis, Design, Implementation, Testing and Rollout.
Installation and administration of the PowerMart’s repository (including IBMźs DB2 Connector) in multiple server environment.
Testing: Preparation for the test bill run in the new billing system.
Supervising and Support of parallel working in the production environment.
Skills: Oracle 8x, AS400, Unix, SQL, PL/SQL, PowerMart, ERWIN, MS Project.

Feb 2000 - Nov 2000

10 months

Project Leader

EDS Deutschland GmbH

Migration of a International Service Provider (wireless/wireline, Switzerland) to BSCS.
Billing & rating system upgrade: BSCS5.0 to 5.21, only wireline customer.
5k private/business customer and 6k active contracts.
Responsible for the staffing of the Design Team and the Migration Task Force.
Co-operation and coaching during the Design, Development and Implementation of the Migration Client ("C" programmed, TCP/IP based tool worked with BSCS's CAS-Modul).
Performance enhancement of the PowerMart’s mappings (by the optimize of SQL-statements and IO-transactions), design and implementation of the PM’s “schedule tasks” and notifications components.
Writing test cases and acceptance protocols.
Quality Management.
Skills: Oracle 7.34, SunSolaris, C++, Embeded C, COCOMO II.

Aug 1999 - Jan 2000

6 months

Germany

Responsible for the Change Request Management

EDS Deutschland GmbH

Post-Migration-Phase.
Evaluation of the Migration from COPS to BSCS5.0.
Analyse and the 1st level Support for the rating problems.
Management of the migration related problem requests and customer requests.
Skills: MS Project, Vantive, PVCS, Workflow Management System.

Jan 1997 - Aug 1999

2 years 8 months

Frankfurt, Germany

Software Engineer (Migration and System Upgrade, CAS)

LHS Group

Team Leader of CAS (Customer Administration Server) Development Group.
Designed the System Upgrade Strategy.
Responsible for migrations into BSCS.
Design the extract, conversion and loading logic for customer’s migrations (PL/SQL, SQL, C++).
Design, tuning and administration of our databases (ORACLE 7.3.4 and 8i).
Designed and developed Migration Testing Strategy. Develop the templates for ETL reports (SQL, PL/SQL).
Database design: entity relationship, logical/physical, process modeling, CASE tools.
Relational database analysis/programming against Oracle, Sybase, DB2, SQLBase..., etc.
SQL data definition, retrieval and manipulation; Coding of stored procedures, triggers, views.
Skills: Sybase & Oracle 7.34, SQL, PL/SQL, C/C++, Centura.

Jan 1996 - Jan 1997

1 year 1 month

Mainz, Germany

Freelance Computer Consultant, Software Engineer

GodeSYS GmbH

Worked in the Development Division.
Developed and integrated Dynamic Linking Librarys and Shared Objects in C/C++.
Customized billing and rating systems for the telecommunication service provider in EMEA (batch and online modules).
Tested and fixed defect.
Evaluated new technologies for implementation throughout the organization, including Java, JavaScript, HTML 3.0, Netscape, Centura, Access and Visual Basic.
Skills: Centura, C/C++, native interfaces.