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

freiberufler ETL , database developer , Business Analyst, Migration , payment , AML , dashboard  auf
en  |  de  |  hi
60598 Frankfurt am Main


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

Ich biete

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

Projekt‐ & Berufserfahrung

International IT Consultant (ETL and DWH) (Festanstellung)
Arvato financial solutions, Gutersloh , 33332
7/2019 – offen (1 Jahr, 4 Monate)

7/2019 – offen


Technology used : Microstrategy, SSIS, SQL server, Microstrategy reports.
Project : Integrate AfterPay,collection DWH and ETL setup to support
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
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
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
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

12/2016 – 6/2019


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

9/2011 – 11/2016


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
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

Eingesetzte Qualifikationen

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


Professional Scrum Master
Juni 2020

November 2018

Oracle certified associate
Juni 2005


Bachelor's degree in IT
Jahr: 2006
Ort: India


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.

Über mich

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

Persönliche Daten

  • Englisch (Fließend)
  • Deutsch (Gut)
  • Hindi (Muttersprache)
  • Europäische Union
13 Jahre und 7 Monate (seit 03/2007)
5 Jahre


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

Jetzt Mitglied werden »