Rami is available for hire

Rami Ouanes

Verified Expert in Engineering

Data Engineer and Developer

Location

Tunis, Tunisia

Toptal Member Since

November 1, 2021

Rami is an experienced business intelligence engineer, well-versed in defining requirements and implementing enterprise-level solutions that result in stable, scalable, and viable data-driven systems. He identifies business needs and develops valuable solutions to improve day-to-day business operations. Rami is a results-driven professional with a proven track record in data analytics and reporting. Prepared to offer 9+ years of experience, he enjoys using data to drive business success.

Data Engineering Data Analysis Data Analytics Data Warehousing Data Warehouse Design Data Visualization DAX Data Integration SQL Server BI SQL Server Integration Services (SSIS)ETL Business Intelligence (BI)Data Pipelines Microsoft Power BI SQL

Portfolio

Panzura LLC

Microsoft Power BI, Data-informed Visual Design, Data Visualization...

Yellowsys for KPMG

SQL Server BI, Azure Data Factory, Azure Synapse, Microsoft Power BI...

VistaPrint

SQL Server BI, SQL Server Integration Services (SSIS), SSAS Tabular...

Experience

Data Warehouse Design - 9 years SQL Server BI - 9 years Data Analytics - 9 years Business Intelligence (BI) - 9 years Data Visualization - 9 years Microsoft Power BI - 8 years DAX - 8 years Data Build Tool (dbt) - 2 years

Availability

Part-time

Preferred Environment

Microsoft Power BI, Data Build Tool (dbt), Data Visualization, Data Engineering, Reporting, ETL, Business Intelligence (BI), Data Warehousing, Microsoft BI Stack, SQL Server BI, BI Reporting

The most amazing...

...thing I've developed is a complex data reconciliation and matching algorithm for a Big Four company resulting in reliable and viable customer master data.

Work Experience

Data Management Consultant

2022 - 2022

Panzura LLC

Audited the legacy data platform and suggested new tools, technologies, and processes for quicker, more maintainable, and more efficient data integration between systems.
Designed and developed a sales and financial data warehouse that provided wider business views, analysis, and optimized sales processes.
Developed data pipelines with dbt that provided higher speeds and bigger volumes of data otherwise not accessible by the legacy system with all change history.
Designed and created an enterprise-wide flexible OLAP model through Power BI that served a set of multiple reports and dashboards with a centralized business logic providing ease of change.
Architected multiple complex sales and financial dashboards enabling the executive team to analyze sales pipeline performance, annual recurring revenue, and multiple other metrics.

Technologies: Microsoft Power BI, Data-informed Visual Design, Data Visualization, Dashboard Design, Data Build Tool (dbt), Google BigQuery, Data Analysis, Data Pipelines, Data Engineering, Reporting, APIs, Business Intelligence (BI), Data Transformation, CRM APIs, DAX, SQL, Power Query, Power Query M, Data Architecture, Data Analytics, Dashboards, Interactive Dashboards, Data Warehousing, Data Warehouse Design, Business Intelligence (BI) Platforms, Microsoft Excel, Fivetran, BigQuery, Microsoft BI Stack, Data Structures, Data Integration, Excel 365, Excel 2010, BI Reporting

Business Intelligence Manager

2019 - 2022

Yellowsys for KPMG

Developed and delivered business information solutions.
Established and secured enterprise-wide data analytics structures.
Unified disparate data structures and operating environments during revamps of processing facilities, data centers, and more.
Designed multidepartment data models for complex analysis needs.
Generated customized architectures specifically optimized for several database technologies, including Azure Synapse and Power BI models for big data clients.
Migrated numerous legacy systems to newer technologies reducing costs and enhancing the efficiency of all computing tasks.
Gathered, defined, and refined requirements. Led the project design and oversaw its implementation.
Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.

Technologies: SQL Server BI, Azure Data Factory, Azure Synapse, Microsoft Power BI, Azure DevOps, SQL Server Integration Services (SSIS), SSAS Tabular, SQL Server Management Studio (SSMS), Visual Studio, Database Development, DAX, Power Query M, SQL Server Reporting Services (SSRS), SSRS Reports, Azure SQL, Azure Analysis Services, Data Architecture, ETL, Data Engineering, SQL, Data Modeling, Data Analysis, Data Analytics, Dashboards, Interactive Dashboards, Business Intelligence (BI), Microsoft SQL Server, Oracle SQL Data Modeler, Data Warehousing, Data Warehouse Design, Dimensional Modeling, Relational Databases, Relational Database Design, Data Visualization, Business Intelligence (BI) Platforms, Excel 2016, Microsoft Power Apps, Microsoft Excel, Databases, Data Pipelines, Reporting, APIs, Data Transformation, CRM APIs, Power Query, Data-informed Visual Design, Dashboard Design, Microsoft BI Stack, Data Structures, Data Integration, Excel 365, Excel 2010, Azure, BI Reporting

Senior Business Intelligence Consultant

2017 - 2018

VistaPrint

Implemented a master data management tool and the processes to further optimize data integrity.
Refactored the existing data warehouse to include an ODS layer, historization, and other BI standards that enabled the development of new analyses like agents' fraudulent change of customer profiles.
Introduced new management techniques that improved team occupancy and provided stakeholders with more visibility.
Trained new team members and business users on projects and technical tools like Microsoft BI and Power BI.
Collected the business needs and wrote specifications and appropriate documentation.

Technologies: SQL Server BI, SQL Server Integration Services (SSIS), SSAS Tabular, SQL Server Management Studio (SSMS), Visual Studio, Database Development, DAX, Power Query M, ETL, Data Engineering, SQL, Data Modeling, Data Analysis, Data Analytics, Dashboards, Interactive Dashboards, Business Intelligence (BI), Microsoft SQL Server, Oracle SQL Data Modeler, Data Warehousing, Data Warehouse Design, Dimensional Modeling, Relational Databases, Relational Database Design, Data Visualization, Business Intelligence (BI) Platforms, Databases, Excel 2016, Data Pipelines, Reporting, APIs, Data Transformation, CRM APIs, Microsoft Power BI, Power Query, Snowflake, Microsoft Excel, Data-informed Visual Design, Dashboard Design, Microsoft BI Stack, Data Structures, Data Integration, Excel 365, Excel 2010, BI Reporting

Business Intelligence Consultant

2014 - 2016

Methys

Developed a data integration solution between several systems that harmonized data cross-company.
Refactored a BI tool to simulate customer evolution and decrease processing time from hours to minutes.
Built an enterprise data warehouse for the finance and sales departments, providing customers' assets analysis.
Developed a data integrity project for sales, ensuring the accuracy of prospects' information for the marketing campaigns, reducing spamming, and increasing the prospect conversion rate by 25%.
Created and maintained a cross-sell project that improved sales revenue.
Designed and developed multiple proofs of concept (POCs) and mini-projects.

Technologies: SQL Server BI, Microsoft Power BI, Excel 365, SQL Server Integration Services (SSIS), SSAS Tabular, SQL Server Management Studio (SSMS), Visual Studio, Database Development, DAX, Power Query M, SQL Server Reporting Services (SSRS), SSRS Reports, ETL, Data Engineering, SQL, Data Modeling, Data Analysis, Data Analytics, Dashboards, Interactive Dashboards, Business Intelligence (BI), Microsoft SQL Server, Oracle SQL Data Modeler, Data Warehousing, Data Warehouse Design, Dimensional Modeling, Relational Databases, Relational Database Design, Data Visualization, Excel 2016, Business Intelligence (BI) Platforms, Databases, Microsoft Excel, Data Pipelines, Reporting, APIs, Data Transformation, CRM APIs, MySQL, Power Query, Data-informed Visual Design, Dashboard Design, Microsoft BI Stack, Data Structures, Data Integration, Excel 2010, Azure, BI Reporting

Experience

Monitoring and Evaluation Dashboards

https://www.iri.org/resource/data-tunisians-pessimistic-about-electoral-process

Data preparation, complete design, and implementation of monitoring and evaluation dashboards following surveys carried out in multiple countries like Tunisia, the Balkan Countries, Malaysia, and more. I developed these dashboards in the context of a long-term consultancy for the International Republican Institute between 2019 and 2020.

Complex Data Reconciliation and Matching Algorithm

Developed a complex data reconciliation and matching algorithm for a Big Four company resulting in reliable and viable customer master data. This data integrity project was targeted for sales and ensured the accuracy of prospects' information for the marketing campaigns, reduced spamming, and increased prospect conversion rate by 25%.

Custom Hybrid Architecture for Big Data Clients

Built customized architectures specifically optimized for several database technologies, including Azure Synapse and Power BI models for big data clients. Through the use of Power BI and Azure Synapse, I developed a hybrid dataset with both direct queries and import mode pushing Power BI to handle big data.

Skills

Languages

SQL, Power Query M, Snowflake

Tools

SQL Server BI, Microsoft Power BI, Microsoft Excel, Power Query, Visual Studio, Excel 2016, Oracle SQL Data Modeler, Excel 2010, Microsoft Power Apps, BigQuery

Paradigms

ETL, Business Intelligence (BI), Dimensional Modeling, Data-informed Visual Design, Azure DevOps, Database Development

Platforms

Microsoft BI Stack, Azure, Azure Synapse

Storage

SQL Server Integration Services (SSIS), SSAS Tabular, Azure SQL, Microsoft SQL Server, Relational Databases, Data Pipelines, Data Integration, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Databases, PostgreSQL, MySQL

Other

DAX, Data Engineering, Azure Analysis Services, Data Analysis, Data Analytics, Dashboards, Interactive Dashboards, Data Warehousing, Data Warehouse Design, Relational Database Design, Data Visualization, Business Intelligence (BI) Platforms, Dashboard Design, Reporting, Data Transformation, Data Structures, BI Reporting, Data Architecture, Data Modeling, SSRS Reports, Data Build Tool (dbt), Fivetran, APIs, CRM APIs, Excel 365, Azure Data Factory, Google BigQuery

Education

2010 - 2014

Bachelor's Degree in Computer Science

Faculty of Sciences of Monastir - Monastir, Tunisia

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring