Rami Kallel-Business Intelligence & Data Specialist
Check rate
Experience
Tech Lead BI
BPCE
Context: Leading the analysis and reporting on IT security data by processing logs and system data to monitor server patches, antivirus status, and overall security metrics. Providing support for security committees.
Responsibilities:
- Managing a team of 5 developers working on SSIS, SSAS Tabular, Power BI, and Power Automate.
- Developing data models and ensuring the quality of analytical insights.
- Designing dashboards and reports for IT security and system monitoring.
- Supporting Agile Scrum practices for project management and team coordination.
Technologies:
- SQL Server (SSIS, SSAS Tabular)
- Power BI
- Power Automate
- Scrum Methodology
Tech Lead BI
Deloitte (DSI)
Context: Being the referent on the implementation of several decision-making solutions within the DSI concerning:
- HR Department: Monitoring of training and certifications.
- Finance Department: Budget and expenditure monitoring.
- Travel Department: Monitoring of expenses, reservations, and travel
Responsibilities:
- Modeling and implementing data warehouse.
- Modeling and creation of multidimensional and tabular models.
- Designing reports.
- Manage Azure DEVOps branches TFS and Git
Technologies:
- SQL Server 2016,2017,2019: SSIS, SSAS, SSRS
- PowerBI
- Azure Data Factory
Business Intelligence Consultant
ORPEA
Context 1: Financial
Implementation of a data warehouse that centralizes all the financial entries of several business units around the world to be able to have an overview using different reports and KPIs.
Responsibilities:
- Design and modeling of the data warehouse.
- Implementation of a data loading process based on various parameters present in the MDS.
- Development of different SSIS flows for data loading with monitoring and alerts.
- Update data according to the existing according to the MDS repository.
- Modeling a Tabular cube.
- Creation of different functional dashboards for monitoring financial entries, accounts, and entities on SSRS and PowerBI.
Context 2: Real Estate
Implementation of a data warehouse containing data from various real estate projects as well as existing properties and migration of data from an old tool to a new one.
Responsibilities:
- Design and modeling of the data warehouse.
- Development of SSIS flows for data loading
- Modeling of the tabular cube to allow the analysis of this data.
- Development of SSIS flows and scripts to allow data migration to the new tool.
Technologies:
- SQL Server 2016: SSIS, SSAS, SSRS
- PowerBI
- Oracle DB
Business Intelligence Consultant
GROUPAMA
Context: Reliability of data to migrate: apply the migration rules on the data to be in phase with the data to migrate and be able to compare.
Responsibilities:
- Gaps identification between different databases/systems.
- Analyze data and detect the differences.
- Ad-hoc analyzes and extractions on everything concerning contracts, affiliates, insurance schemes ... etc.
- Automate SAS programs.
- Set up SAS EXCEL add-in to automatically generate pivot tables from SAS tables as source.
Responsibilities:
- SAS Entreprise Guide 7
- SQL Server 2012
- Excel
Business Intelligence Specialist
Cimpress
Context: Implementation of a data warehouse for a self-service BI solution to offer global visibility on the different CIMPRESS factories: Plan the volumes and the capacity, optimize shipments, generate monthly reports, and analyze and production costs
Responsibilities:
- Data warehouse implementation and managing
- ETL packages development (sources MySQL, Hive, PrestoDB), stored procedures, cubes
- Maintenance plan and health dashboards to detect data anomalies (SSRS)
- Data standardization
- Support teams and partners with Looker reports creation and script SHELL to load data into Big Data environment
Technologies:
- SQL Server 2014: SSIS, SSAS, SSRS
- Hadoop/AWS EMR/Qubole
- Looker/Tableau Software
TMA: Database maintenance (containing production, orders, and shipping data from five Vistaprint plants), ETL packages and the cube.
Responsibilities:
- JIRA tickets creation and administration
- ETL packages, stored procedures and cubes update and modification according to analysts requirements
Technologies:
- SQL SERVER 2012: SIS, SSAS
Business Intelligence Consultant
Intellico Conseil
Context: Generic BI solution to provide reports and performance indicators under a Microsoft Sharepoint portal that will analyze the financial status, resources and progress of projects.
Responsibilities:
- ETL packages and cubes creation and deployment
- Dashboards and KPIs development and design
TMA:
Context: Maintenance of data fulfillment mechanisms related to different projects and clients.
Responsibilities:
- Customer needs analysis
- Existing solutions maintenance
- ETL packages optimization
- Cube updates
- Excel reports update and creation
Technologies:
- SQL Server 2012: SSIS, SSAS
- Microsoft Sharepoint
- HTML/CSS/HighCharts JS , C# .NET
Business Intelligence Developer Intern
BIAT
- Modeled a data warehouse for banking operations.
- Deployed Talend jobs to get the data.
- Created dynamic and interactive dashboards using Qlikview.
Industry Experience
See where this freelancer has spent most of their professional time.
Experienced in Professional Services, Banking and Finance, Insurance, Manufacturing, and Real Estate.
Business Area Experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, Project Management, Finance, Operations, and Production.
Skills
Data Warehousing
Microsoft Sql Business Intelligence (Ssis, Ssas, Ssrs)
Power Bi
Azure Devops
Azure Data Factory
Sql/T-Sql
Mdx
Dax
C#.Net
Languages
Education
Private Higher School of Engineering and Technology (ESPRIT)
Computer Business Intelligence Engineer Degree · Computer Business Intelligence
Higher Institute of Computer Science (ISI)
Computer Sciences License Degree · Computer Sciences · Ariana, Tunisia
Certifications & licenses
DA-100: Power BI Data Analyst Associate
DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
DP-900 : Azure Data Fundamentals
PL-300: Microsoft Power BI Data Analyst
Statistics
Experience
Expertise
Qualifications
Profile
Frequently asked questions
Have questions? Find more information here.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Tech Lead BI
Nearby freelancers
Professionals working in or nearby Le Vésinet, France
