Description

I am a Data Enthusiast with 5+ years of experience in IT industry.

I have worked on following projects:

BI Migration ( Migration of ETL packages from BIDS to SSIS )

Business support (Developing ETL packages for the Finance team)

Data Integration (Extracting data from a web api into JSON files and sending it into a file server in text files via ADF pipelines)

Developing Power BI reports and creating tables/views/Stored Procedure/Jobs to extract data from Oracle database.

I always try to follow proven methods and best practises of the industry. Always try to go as much detail as possible and Communication is the key.

Langues

Hindi
Bilingue ou natif
Anglais
Capacité professionnelle complète
Néerlandais
Notions

Préférences en matière de lieu de travail

Accepte de travailler sur site

Brussels (jusqu’à 50 km)

Intys
Data Analyst
AGENCE & SSII
septembre 2022 - Aujourd'hui (3 ans et 8 mois)
Creating power bi dashboards.
Supporting business in the day to day operations.
Performing monthly updates for the business.
Requirement gathering.
Preparing data in Oracle Sql developer creating tables, stored procedure, views, scheduling jobs and performing data cleansing activities.
Oracle SQL Developer Microsoft Power BI Power Apps Tableau
Synfac
Data Engineer
AGENCE & SSII
janvier 2021 - janvier 2022 (1 an)
Brussels, Belgique
▪ Optimized the SQL query to improve the performance of the query.
▪ Modified the existing ETL package.
▪ Created a C# solution to extract data from a web API into JSON files.
▪ Maintained pipeline in ADF using linked services/datasets to extract, transform data from Azure Data Lake storage and load into SFTP server.
▪ Fixed the support tickets.
▪ Worked in GIT repository to check in and checkout the solution.
▪ Worked with the GIT integration of Azure Data Factory pipelines and deploying solution in CI/CD way to DEV environments using Azure DevOps.
▪ Analysed the JSON data in Azure Databricks.
Microsoft Visual Studio Microsoft Power BI SQL Server SSIS Azure Data Factory Azure DevOps
Arcatin Solid Information Technologies
BI developer
AGENCE & SSII
octobre 2018 - mars 2020 (1 an et 5 mois)
Brussels, Belgique
Analyze existing SSAS cube and understand the data flow of financial reporting.
Perform reverse engineering to understand the data flow in the system.
Develop SSIS packages to extract the data from sources (SQL Server, MS Excel, Flat Files) and apply
necessary transformation rules.
Built SSIS packages to extract data from multiple sources, perform transformations and load into
Datawarehouse.
Converted Excel/SSRS/PowerPivot/Cube reports to Power BI report server.
Modified and optimized existing reports available in Einstein reporting server.
Developed and modified the existing data cubes in SQL server analytical services (SSAS).
Understand the requirements and create facts / dimensions in reporting database.
Define associations between various facts and dimensions.
Implemented slowly changing dimensions in data warehouse tables.
Created Operational Data Source services in ODS database.
Written stored procedures and created database objects (tables, views, indexes etc.…)
Created scheduler jobs and defined the schedule for SSIS Packages using SQL Server Agent.
Prepared technical and functional design documents to include new changes in the reports.
Actively participate in daily scrum calls and ensure agile way of delivering the solution.
SSRS Microsoft Visual Studio SQL Server SSIS SSAS Microsoft Power BI