نبذة عني
Consultant bi / data engineer
blockchain
الخبرة
Consultant BI & Data Engineer
Consultant Business intelligence & Data Engineer,
I support companies' various business lines in exploiting their data And I'm working on the company's data architecture to evolve the IS from an on premise service to the cloud.
CONSULTANT BUSINESS INTELLIGENCE / ANALYTICS
Migration from SAP Business Object to Microsoft Business Intelligence solution.
Adaptation/Development of SQL queries.
Creation of views, stored procedures, SSRS/Power BI reports.
Creation of subscriptions, implementation of security measures.
Gathering requirements and various calculation rules for KPIs.
Data ingestion from different sources (SalesForce, SqlServer, AS400).
Creation of SQL stored procedures to populate the data table.
Creation of Azure DataFactory pipelines to deposit files on the Eloqua FTP server.
Scheduling file delivery through trigger.
Gathering business requirements.
Adapting SQL queries.
Creation and deployment of SSRS / Power BI reporting service reports.
Implementation of security measures / Subscriptions and scheduling for client distribution.
Implementation of a Data Quality storage rule (Bronze, Silver, Gold).
Creation and maintenance of a linked SQL Pool and dedicated SQL Database server.
Creation of ELT/ETL data ingestion pipelines.
Creation of linked services for Data Bricks, SQL Server, and File System.
Migration of SSIS packages to Azure Data Factory.
Creation and update of pipelines datasets and storage.
Extraction and Ad hoc querying.
Creation and administration of deployment pipelines and workspaces.
Creation and development of tables, stored procedures, and views.
Data ingestion, cleansing, normalization, transformation, and modeling.
Monitoring and evolution of Power BI and SSRS reports.
Creation and update of SSIS packages and Tabular Cubes.
Maintenance of existing applications.
Tracking and resolution of business tickets.
Migration of Azure Data Lake components to Gen2.
Consultant Business Intelligence / Analytics
Migration from SAP Business Object to Microsoft Business Intelligence solution
Adaptation/Development of SQL queries
Creation of views, stored procedures, SSRS/Power BI reports
Creation of subscriptions, implementation of security measures
Project aiming to provide a reporting and management tool for the marketing department
Gathering requirements and various calculation rules for KPIs
Data ingestion from different sources (SalesForce, SqlServer, AS400)
Creation of SQL stored procedures to populate the data table
Creation of Azure DataFactory pipelines to deposit files on the Eloqua FTP server
Scheduling file delivery through trigger
Creation of fleet status dashboards for the sales department
Gathering business requirements
Adapting SQL queries
Creation and deployment of SSRS / Power BI reporting service reports
Implementation of security measures / Subscriptions and scheduling for client distribution
Creation of a Data Platform on Azure Synapse Analytics for the finance department
Implementation of a Data Quality storage rule (Bronze, Silver, Gold)
Creation and maintenance of a linked SQL Pool and dedicated SQL Database server
Creation of ELT/ETL data ingestion pipelines
Creation of linked services for Data Bricks, SQL Server, and File System