Welcome to Sneh's freelance profile!
Location and workplace preferences
- Brussels, VB, Belgium
- Can work onsite in your office in
- around Brussels and 50km
Freelancer code of conduct signed
Read the Malt code of conduct
Native or bilingual
Sneh in a few words
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.
Digital & IT
Data Analyst - As a freelancer
Supporting business in the day to day operations.
Performing monthly updates for the business.
Preparing data in Oracle Sql developer creating tables, stored procedure, views, scheduling jobs and performing data cleansing activities.
Digital & IT
▪ 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.
Arcatin Solid Information Technologies
Digital & IT
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
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.
Are you sure? Your recommendation will be permanently deleted