Amar Rijhwani

Befristete Vertrag SAP Migration Projekt – DWH & Reporting - BI Entwickler & Datawarehouse Engineer • T-SQL, MS SQL Server, SSIS, SSAS • SAP Datenmodel Analyse • Targit Reporting • SAP - Analyse des Datenmodels • VB.Net Erfolge Enthalten: Implementierung eines neues DWH zur Group Reporting. Entwicklung und Implementierung eines neues Testumgebung. Analyse, Datenmodellierung, Entwicklung und Implementierung Cubes zum Zutrittskontrolle ( SALTO ), Lagerdaten und Bestellrapportierung. ETL Optimisierung

Anwendungsbetreuung von verschiedenen vermögensverwaltungs Systemen in bereich Leistungsberichten und Index Handeln. Erfolgt hauptsachlich durch Microsoft Stack Technologien: • T-SQL, MS SQL Server, SSIS, ETL data feeds, SSRS, Oracle • MS VS – C# & VB.Net, IIS7, WCF • Excel & Access Vba • Control-M job scheduling • Powershell, XML, .bat, Linux Unix, mstsc, citrix, Windows Server OS • Jira, Service-now, Sharepoint

Spreadsheet modelling Vba work on own network. Studying MCSA SQL 2016 BI Development.

Implementation of system migration to the new “DvSZ” test environment. Including full system architecture ( Windows Servers, Data Servers, Implementation of multi-tier system, svn migration… ).

Introduction of new wrapped funds enhancement to the SCOPE fund management system. FCA Reporting requirements enhancement. Statutory declaration wording changes implemented across all external reports. Significant enhancement to existing complex SP and Crystal Report templates System Data Bridge – Client Invoicing, Benchmarks, Asset Classes etc. ETL stored procedures extract data from SCOPE CBOR ( client book of records ) which is a central depository of data.