Rami is available for hire
Hire RamiRami 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.
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
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, 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, 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, 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-processData 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
Storage
SQL Server Integration Services (SSIS), SSAS Tabular, Azure SQL, Microsoft SQL Server, Relational Databases, Data Pipelines, Data Integration, SQL Server Management Studio, 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, Azure Synapse, Google BigQuery
Education
2010 - 2014
Bachelor's Degree in Computer Science
Faculty of Sciences of Monastir - Monastir, Tunisia