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

7/2019 – offen

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.

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

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.

Business Intelligence and Reporting Tools (BIRT), Open Source, Mariadb, Sybase

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

Oracle Business Intelligence (BI), Informix, Computer Engineering, CARD/1