Rami OUANES

Developed and implemented Data & Analytics strategies and architectures for multiple clients:

• Paladin
• Wegmans
• Outdoor Living Supply
• EquinEdge
• Panzura

Altventur is a platform that helps users customize their own trips by choosing from a list of alternative accomodations and activities provided by locals.

• Managed a team of 6 employees on a daily basis.
• Identified revenue streams and optimized cost.
• Analyzed market trends and kept an ear on a highly evolving market.
• Developed business strategy and financial models that follow market trends.

iMMAP for ACF

Key Responsibilities:

• Data preparation
• Complete design and implementation of Power BI dashboards to evaluate multi-sector rapid response mechanism that took place in Burkina Faso.

Technologies: Microsoft Power BI, DAX, Power Query M, Data Analysis, Dashboards, Interactive Dashboards, Business Intelligence (BI), Microsoft Excel

Responsibilities:

• Data preparation
• Complete design and implementation of Monitoring & Evaluation dashboards following surveys carried out in:

Serbia, Bosnia, Kosovo and North Macedonia: https://www.iri.org/resource/data-balkans-poll-shows-split-between-east-and-west-room-western-engagement

Tunisia:

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

Burma:

https://www.iri.org/resource/new-burma-poll-public-satisfied-country%E2%80%99s-direction-supports-further-political-reform

Technologies: Microsoft Power BI, DAX, Power Query M, Data Analysis, Dashboards, Interactive Dashboards, Business Intelligence (BI), Microsoft Excel

Data Architect for KPMG - June 2019 - March 2022

Key Responsibilities and Achievements

• 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 data models for complex analysis needs.
• Generated customized architecture 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 efficiency of all computing tasks.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.

Co-founder - BI Manager (Since 2017)

Key Responsibilities

• Contribution to prospect, select and recruit effective candidates
• Set, enforced and optimized internal policies to maintain efficiency and responsiveness to demands.
• Collaborated with development teams, internal customers and product line management to verify delivery of desired quality requirements to distributors.

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

Team Lead / Technical Lead - December 2016 - October 2017

Clients

Grofin — African Capital Alliance.

Key Responsibilities and Achievements

• Building and management of support team working simultaneously with several customers, increasing client satisfaction
• Integration and customization of eFront solution for several clients with different contexts and needs
• Focal point for support related customer needs
• Introduction and implementation of management techniques improve agility in processing client requests
• Acquisition of technical and functional eFront certifications

BI Project Manager - February 2016 - November 2016

Clients

Sage

Key Responsibilities and Contribution

• Coordination between several project actors(Final Users, Developers,Designers, Product Owners..)
• Management of deliverables and deadlines
• Project planning and human resources assignments
• Maintenance of delivered projects
• Design and development of Proof of Concepts (POC) and mini-projects

BI Consultant - September 2014-February 2016

Clients
Sage — Veolia

Key Responsibilities and Contribution

• Development of data integration solution (between several systems) harmonizing data cross-company
• Refactoring BI tool permitting simulation of customer's evolution, also to decrease processing time (from hours to minutes)
• Development of the Enterprise Data Warehouse for Finance and Sales departments providing analysis of customers’ assets
• Development of data integrity project for Sales, insuring accuracy of prospects’ information for marketing campaigns. This lead to increase prospect conversion rate by 25% and reduce spamming
• Development and maintenance of cross-sell project improving sales revenue.

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