freiberufler ETL , database developer , Business Analyst, Migration , payment , AML , dashboard auf freelance.de

ETL , database developer , Business Analyst, Migration , payment , AML , dashboard

offline
  • 45€/Stunde
  • 60598 Frankfurt am Main
  • Europa
  • hi  |  en  |  de
  • 01.10.2020

Kurzvorstellung

Ich habe als Business Intelligence-Ingenieur, Data Warehouse, ETL, Datenbankentwickler, Integrations- und Datenmigration Experte für mehrere Kunden wie Barclaycards, Standard Bank Entercard As und andere Zahlungsdienste an verschiedenen international

Qualifikationen

  • Business Intelligence (BI)
  • Crystal
  • ETL
  • MariaDB
  • Microsoft SQL Server Analysis Services (SSAS)
  • Microsoft SQL Server Integration Services (SSIS)
  • MicroStrategy
  • Oracle Database

Projekt‐ & Berufserfahrung

International IT Consultant (ETL and DWH) (Festanstellung)
Arvato financial solutions, Gutersloh , 33332
7/2019 – offen (4 Jahre, 9 Monate)
IT
Tätigkeitszeitraum

7/2019 – offen

Tätigkeitsbeschreibung

Technology used : Microstrategy, SSIS, SQL server, Microstrategy reports.
Project : Integrate AfterPay,collection DWH and ETL setup to support
business.
Product configuration for new clients and prepare file exchange format
for additional information as per requirement.
Interact with business analyst and data modelers and DBA to finalize the
requirements
Translate the mapping and functional design requirements into technical
design document, which consists of the lower level design details with
respect the ETL process
Develop the script to perform the file validation of input source file to
check whether the file contains valid header, trailer and details records as
per the form it defined in the requirements
Design and development of CDC process using time‑stamping method
and implemented SCD method including type 2 to keep track of historical
data.
The transformation like router, jointer, lookup, Expression editor, sorter,
filter Union and update strategy etc used in the mappings between source
and Target to achieve the transformation logic with respect to the
requirements
The data stage like aggregator, lookup join, merge ,switch, filter
,Transformer ,copy etc are used to accomplish the transformation logic.

Eingesetzte Qualifikationen

Microsoft SQL Server Analysis Services (SSAS), MicroStrategy, Microsoft SQL Server Integration Services (SSIS), Oracle Database, Crystal

DWH and Business Intelligence Engineer
Inatec Solutions Gmbh (Frankfurt), Frankfurt
12/2016 – 6/2019 (2 Jahre, 7 Monate)
IT & Entwicklung
Tätigkeitszeitraum

12/2016 – 6/2019

Tätigkeitsbeschreibung

Technology used : MYSQL , Sybase ,MariaDB scheduling tool‑Crons ,
Pentaho as BI and ETL
Project : Requirement gathering , Development, automation , monitoring
and maintenance of daily tasks
Prepare interface design between new merchant , payment providers and
financial database.
Follow standard payment and data exchange format and customize it
according to new requirements.
Design and develop new dashboard and automate new process for better
monitoring and analysis purpose.
Bug fixing and writing scripts to restore data in case of any issue.

Eingesetzte Qualifikationen

Business Intelligence and Reporting Tools (BIRT), Pentaho Open-Source-BI-Suite, MariaDB, Sybase

Senior consultant (Festanstellung)
Capgemini, oslo
9/2011 – 11/2016 (5 Jahre, 3 Monate)
IT & Entwicklung
Tätigkeitszeitraum

9/2011 – 11/2016

Tätigkeitsbeschreibung

Technology used: Oracle 10g, Informix, Informatics, Crystal reports, Job
scheduling tool
Project : Maintenance and Migration of card portfolio(Issuer) from client to partner bank.
Participated in design sessions where decisions are made involving the
transformation from source to target.
Responsible for developing various data extracts and loading routine
using Informatica, Oracle stored procedure (pl and sql), packages,
triggers, UNIX, and Sas
Created detailed process flow designs, drafts and high‑level Standard
Operating Procedures and Data warehouse.
Implemented various Transformations: Joiner, sorter, Aggregate,
Expression, Lookup, Filter, Update Strategy and Router.
Designed and implements the error handling strategy for ETL team.
Monitored data warehouse month‑end/daily loads to ensure successful
completion.
Point of contact for many clients for technical issues and integrations.
Interacted with business representatives and business analysts for
requirements analysis and to define business and functional
specifications.

Eingesetzte Qualifikationen

Oracle Business Intelligence (BI), Informix, Technische Informatik, CARD/1

Zertifikate

Professional Scrum Master
2020
ITIL
2018
Oracle certified associate
2005

Ausbildung

Bachelor's degree in IT
yes
2006
India

Über mich

Kernkompetenzen: Daten- und Prozessüberwachung, Datenbankentwicklung, Berichte und Dashboard
Erstellung, Datenmigration und -integration, Data Warehouse-Entwicklung, Business Intelligence, ETL-Jobs usw.

Weitere Kenntnisse

Ich habe mehr als 12 Jahre multinationale Erfahrung in der Abwicklung von IT-Projekten und habe in dieser Zeit an verschiedenen Rollen und Verantwortlichkeiten gearbeitet.

Domänenkenntnisse: Bank- und Zahlungsverkehr, Online-Transaktionen, E-Commerce, Abwicklung, Betrugs- und Risikoüberwachung, Abstimmung, Automatisierung und Überwachung von Transaktionen, Geldwäsche und Compliance.

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Deutsch (Gut)
  • Hindi (Muttersprache)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Profilaufrufe
1657
Alter
40
Berufserfahrung
17 Jahre (seit 03/2007)
Projektleitung
5 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden