Business intelligence consultant | Data warehouse |Data engineer

12/2021 – 12/2022

Skills : MS SQL Server, Oracle (12c), Tableau, Power BI, SSIS, SSRS, SSAS, Excel
Domain: Payments | Anti-Money Laundering
- Worked on Descriptive and diagnostic analysis to prevent AML activities for
Debit and Credit card transactions.
- Replacing old data source (Netezza) with Oracle platform
- Creating views for reporting layer.
- Worked on re-creating data sources, enhancing performance,
- Modifying SSAS Cubes and SSRS Reports with new sources and fields
- Worked on enhancing existing dashboards, design, incorporating new fields
- Supporting for testing and enhancing SSIS packages

Business Intelligence (BI), Datawarehouse / DWH, Datenanalyse, ETL, Meldewesen (Bank), Microsoft Power BI, Microsoft SQL-Server (MS SQL), Microsoft SQL Server Reporting Services (SSRS), Oracle Database, SQL, Tableau

6/2019 – 12/2021

Skills - Oracle (11g 12c -SQL, PLSQL), Hive, Impala, Tableau , Excel
Domain:OperationalRiskmanagement,Governancerisk compliance (GRC)
- Worked on Descriptive analysis for operational risk assessment,
monthly, quarterly and yearly dashboards
- Created Analytical and informational dashboards excel reports which
helped for decision making.
- Provided insights in form of ofkpi,overview anddetailedreports which
helped to assess and mitigate the risk, improve the data accuracy.
- Constructeddatasources,extracts,model, dashboards(tableau),excel reports
- Workedonimproving dashboardperformance,dataaccuracy, data quality,
Rewriting custom sqls , re building extracts for better performance.
- DesignedanddevelopedOLTP data model, database objects (tables, views,
procedure, packages)for GRC application using SQL, PLSQL (11g ,12C)
- Designed a snapshot database and created ETL and ELT packages to
build staging and reporting layer.
- Managedend to end delivery for BI and database development application
teams
- Helpeduserswithimprovingprocesses forquality deliverables
- Helped project managers for requirement gathering, feasibility analysis,
UI wireframe design, UAT testing. Managedtokeepdefect ratiobelow
10%

Business Intelligence (BI), Datawarehouse / DWH, Datenanalyse, Datenmodellierung, ETL, Meldewesen (Bank), Oracle Database, SQL