At the present

January-

****

Casablanca

Business Intelligence Consultant Qlik / MSBI / NPrinting

In Capgemini

Hadoop Ecosystem

(HDFS,Kafka,Pig,Hive,Sqoop)

+212-***-**-**-**

OUTAL

linkedin.com/in/wajih-outal

Qlik View

Power BI

Talend

Professional Skills

Wajih

Spark

Business Intelligence

Big Data

Business Intelligence / Big Data Consultant

NPrinting

DataBases

Development Languages

T-SQL

DAX / MDX

Visual Basic

SQL

Set Analysis

CONTACTS

PROFESSIONAL EXPERIENCE 3 Years

a

Elasticsearch stack

Mongo DB

Cassandra

MySQL

Sql Server

Python

26 years old

Moroccan Nationality

MSBI

Analytical ability

PERSONAL SKILLS

LINGUAGES

English

French

Arabic

Organization and

adaptability

Autonomy and

teamwork.

Main Project: BDA (Big Data Analytics) project for Capgemini Group Responsibilities:

Project: Development and realization of a BI solution to manage the activities of HR department: “Supply and Demand “and the management of resources at the Project level for Capgemini World: Data Part (ODS / DWH / DTM):

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client Team and Development team

• Created SSIS Packages to get data from different sources (Flat Files, Tables) consolidated and merged into one single source

• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications

• Designed custom Dimensions and Facts Tables to extend data warehouse.

• Building Tabular SSAS Cubes (Tabular SSAS 2016, DAX, MDX) Moving from (Qlik / Nprinting) to (Power BI / SSRS) Technical Lead:

• Take in charge the technical management of the migration

• Experienced in using Data Analysis Expressions DAX to creating custom calculations in SSAS tabular model.

• Develop reports using complex formulas with (DAX /MDX) query to generate different types of ad-hoc reports using SSRS.

• Distribution of SSRS reports with Data driven Subscriptions both email and windows file sharing.

• Designing and Developing the Dashboard Reports in power BI using DAX. Reporting Part (Qlik / Nprinting): Technical Lead

• Played an active role during the requirements gathering, analyzing and designing of the business needs.

• Design and development of QlikView dashboards

• Created Pixel Perfect reports, Excel reports and Word Reports using NPrinting tool.

• Expertise in NPrinting Creating Apps, Connections, task, Users, generating reports and publishing.

• Scheduled Data Extractions, Data Model and Dashboard Reloads using Qlik Management Console (QMC).

• Optimize the report distribution process from NPrinting with the Recipient List.

• Used Section access and Sheet access to make the application available to desired users.

• Developed QlikView Dashboards using various Charts with added functionality like Drill Down, Drill up & Cyclic Grouping, Pivot Table, Input Field, Table Box

• Developed KPI’s, Set Analysis, Variables and implemented triggers/macros to provide custom functionality in Dashboards

• Implemented best practices for Qlik performance optimization and improved reload time.

• Refactoring the existing dashboards for better performance and usability. Project: Evolution and design of new modules of a decisional system piloting the HR activities which covers the predictive management of employees and skills (Recruitment, payroll, accounting, ...).

• Participated in daily meetings to understand business logic and requirements of the project and provide optimal solutions to the users.

• Designed SSIS packages and created SQL Databases, table, views, Stored Procedures, and Triggers to support business applications

• Recommending optimizations, and defining axes of improvement

• Designed Tabular cubes with star schema using SSAS.

• Involved in creating advanced KPI’S for the SSAS cubes.

• Designing and Developing the Dashboard Reports in power BI using DAX. Qlik Sense

addti7@r.postjobfree.com

Java

R

Project: Evolution and Remake of My Learning Project for Capgemini world. Data Part (ODS / DWH / DTM):

• Actively participated with business users and functional team to understand the reporting requirements and worked on all phases of the project.

• Analyzing the existing (Datawarehouse / Reporting).

• Involved in writing PowerShell batch scripts to fill the Staging area.

• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.

• Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored Procedures, and Triggers to support business applications

Virtualization

VMware, Docker, Openstack,

LXD, KVM, Libvirt.

Scripting Batch

Junuary-2019

April-2018

Reporting Part (Qlik View):

• Developed automated scripts for data reload form different data base sources and created tasks in QMC.

• Designed & developed reporting applications using QlikView.

• Automated and scheduled daily data loads of QVW documents using QlikView Publisher.

• Used Section access and Sheet access to make the application available to desired users. Team Lead of Run Team:

• Leading, developing the Qlik Sense and QlikView environment and supporting the business decision process.

• Represent a technical reference in the team.

• Conducted training sessions to users about the functionality and usage of application.

• Optimized existing data models including changing load scripts to load data in optimized way to achieve reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.

• Trouble shooting QMC/Server log files to fix task failure errors.

• Experience in providing Doc admin access and user licenses. And Hands on experience in resolving access point issues.

• Installed & configured QlikView tool and upgraded QlikView software to the latest version. Environment: Qlik View, Qlik Sense, Power BI, NPrinting, Set Analysis, SQL, T-SQL, DAX, MDX, Scripting Batch SSIS, SSAS, SSRS SSMS, SQL server 2016, QMC Project: Design and implementation of a BI solution for Data Visualization of financial data for each existing and future project for Capgemini Monde.

Responsibilities:

Design and development part:

• Actively participated with business users and functional team to understand the reporting requirements and worked on all phases of the project.

• Involved in extracting data from MongoDB Database, storing into QVD files, write load scripts, develop UI according to user requirements

• Design and create reports, dashboards, and visualizations to reliably drive business processes

• Implemented best practices for Qlik performance optimization and improved reload time.

• Performed optimization of the QlikView Application by removing unnecessary fields, avoiding complex joins, avoiding date functions, avoiding conditional functions inside the application using mapping load.

• Created QVDs & updated on timely basis by using Incremental Load

• Developed automated scripts for data reload form different data base sources and created tasks in QMC.

• Security and section access implementation at data level, sheet level, App level and Stream level.

• Use of Set analysis and aggregation functions for sheet objects.

• Fully involved in the Release Management process & monitoring for successful deployment

• Implementation of a Connector that allows to generate relational schemas and translate SQL queries between Qlik and MongoDB

Testing Part:

• Involved in creating test case scenarios for end users to test the applications.

• Perform error handling process, debugging and troubleshooting the applications.

• Involved in testing process and performing the Unit testing and System testing. Administration / functional part :

• Created detailed technical specification, business requirements and unit test report documents.

• Experience in creating tasks in QMC and providing access to the Users through QMC as per the user privileges.

• Excellent knowledge on Security rules and Custom properties in Qlik Sense.

• Involved in training sessions to users on Qlik Sense usage. Environment: Qlik Sense, MongoDB, ODBC connector, SQL, Set Analysis Atlassian, QMC.

Project: Creation and realization of a BI system for the follow-up of the Sales Agents and the management of the performed calls:

• Analyze the tables generated by Genesys and define the correlations.

• Created SSIS Packages to get data from different sources (Flat Files, Tables) consolidated and merged into one single source

• Designing and Developing the Dashboard Reports in power BI using SQL & DAX.

• Involved in creating advanced KPI’S in Power Bi with DAX.

• Optimized the performance of Dashboard Reports.

• Involved in testing process and performing the Unit testing and System testing. Environment: SSIS, Power BI, Genesys, SQL Server 2014, SQL, DAX, MDX. Internship Business Intelligence:

April-2018

February -

2018

In Leyton

Casablanca

Mission 1: Implementation of a Java EE application connected to a Big Data platform for the management and extraction of frauds generated from different transactions made by clients:

• Setting up the work environment.

• Data preparation and processing (formatting, cleaning, ...)

• Detect fraudulent cases and also critical (suspicious) cases with some predefined rules.

• A simulation of fraud detection in streaming with Spark Streaming.

• Generated reports on client activity.

• Display detection results as diagrams.

Mission 2: Extraction, filtering and analysis of the data contained in the generated log files through Albarid Bank's web servers.

• Setting up the work environment.

• Data preparation and processing (formatting, cleaning, ...)

• Perform processing to extract information from the log files ( Hive & Pig ).

• Generated reports on client activity.

• Create Dashboards from data calculated from log files Environment: Ecosystem Hadoop (Hive, Pig, Sqoop), Spark, hortonworks, Java EE, Bootstrap, Highcharts .

.

In Al Barid Bank ISD

2015

2013-

EDUCATION AND FORMATION

EDUCATION ET FORMATION

Rabat

Specialized Master « BIG DATA and CLOUD COMPUTING » at the Faculty of Sciences Ain-Chok HASSAN II.

Bachelor's Degree in Mathematical and Computer Sciences « Database and Web Development » at the Faculty of Sciences Ain-Chok HASSAN II. Diploma of General University Studies in Computer Mathematical Sciences at the Faculty of Sciences Ain-Chok HASSAN II.

Secondary School Diploma in Mathematical Sciences series option - A- Graduation internship:

2017

2015-

September-

2017

April-2017

Hobbies

Walking, New Technologies, News, Web and Travel.

2013

2011-

2011

2010-

Contact this candidate