Wasif Wakeel

Leading Jedox projects end to end implementation.
Lead Business Intelligence team and conduct training to enhance team efficiency
Work with Mantrac Group, UAE government entity (GPSSA) and Sorbonne University Abu Dhabi.
Client support on live project and new implementation and meetings on weekly basis for project update & gather requirements with understanding of all business processes & then creating POC for the clients on their organization’s data.
Created Digital Sales (Actual vs Budget) dashboard and reports that was published to executive management (VP, Director + Audience. Leading in Dynamic ETL development in Jedox
Created Audit trail project using Jedox log
UAT sessions with client, verify and validate all the requirements with client.
Creating Planning and Budgeting reports and business rules.
Security implementation in dashboards and reports on client's requirement
Design and develop data warehouse database schemas
Perform data analysis that support and enhance Business intelligence system.
Expert knowledge of Data Management, Business Intelligence and Analytics concepts including
Analysis, architecture, design, and development of ETL, data warehouse and business intelligence systems.
Collaborate to create and enhance data structures (data marts, cubes) to facilitate decision-making.
Currently working on Agile Scrum using Trello board system for task management.
Explore data in a Variety of ways and across multiple visualizations
Proficient in Advance Excel including Advance Functions Eg: vLookup, Pivot tables, Match, Inquire to match data accuracy, charts, graphs, power view etc.
Lead analysis, architecture, design, and development of data warehouse and business intelligence solutions.
Responsible for BI support - New report development, report maintenance, troubleshooting, performance tuning, etc.
Experience and a strong interest in data modelling, data querying, data manipulation and visualisation of data outputs (Jedox/Power BI /Tableau/ MSBI)

Leading Jedox projects end to end implementation
Lead Business Intelligence team and conduct training to enhance team efficiency
Work with Mantrac Group, UAE government entity (GPSSA) and Sorbonne University Abu Dhabi
Client support on live project and new implementation and meetings on weekly basis for project update & gather requirements with understanding of all business processes & then creating POC for the clients on their organization’s data
Created Digital Sales (Actual vs Budget) dashboard and reports that was published to executive management (VP, Director + Audience
Leading in Dynamic ETL development in Jedox
Created Audit trail project using Jedox log
UAT sessions with client, verify and validate all the requirements with client
Creating Planning and Budgeting reports and business rules
Security implementation in dashboards and reports on client's requirement
Design and develop data warehouse database schemas
Perform data analysis that support and enhance Business intelligence system
Expert knowledge of Data Management, Business Intelligence and Analytics concepts including Analysis, architecture, design, and development of ETL, data warehouse and business intelligence systems
Collaborate to create and enhance data structures (data marts, cubes) to facilitate decision-making
Currently working on Agile Scrum using Trello board system for task management
Explore data in a Variety of ways and across multiple visualizations
Proficient in Advance Excel including Advance Functions Eg: vLookup, Pivot tables, Match, Inquire to match data accuracy, charts, graphs, power view etc
Lead analysis, architecture, design, and development of data warehouse and business intelligence solutions
Responsible for BI support - New report development, report maintenance, troubleshooting, performance tuning, etc

Work with Nissan Middle East and Majid Al Futtaim client on their BI & CPM Project
Client support on live project and new project development.
Client meetings on weekly basis for project update & gather requirements with understanding of all business processes & then creating POC for the clients on their organization’s data.
Developed Power BI workbooks from multiple data sources with data blending.
Data analytics implementation with DAX expressions in Power BI.
Create dynamic reports and dashboards according on client’s requirement.
Leading in Dynamic ETL development in Jedox
UAT sessions with client, validating all requirements with client.
Restricted data for particular users using Row level security and User filters in Power BI
Creating filter, parameters & calculated fields for preparing dashboard & worksheet in Power BI Currently working on Agile Scrum using Jira ticketing system for task management.
Explore data in a Variety of ways and across multiple visualizations using Power BI
Used Power BI Gateways to keep the dashboards and reports up to date.
Creating SSIS packages using various transformations such multicast, merge join, lookup, Conditional split, aggregate, derived column, and data conversion transformations.
Proficient in Advance Excel including Advance Functions Eg: vLookup, Pivot tables, Match, Inquire to match data accuracy, charts, graphs, power view etc.

Reporting on Viftech’s own Reporting Product with SSRS
Also Reporting on Power BI
Write Stored Procedures
Reporting on Tableau Data Visualization Tool
Data Cleaning and Filtration as client reporting requirement
Hands-on Command on Tableau
ETL Solutions to support key business data using SQL Server Integration Service
Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
Fine tune SQL Stored Procedures
Datawarehouse Development
Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
Communication with Client to get clear requirement
Currently working on AGILE software process model
Prepare the Analytical Model in Excel and ERD for Warehouse for Schema.
Data Analysis using Excel including Advance Functions (Vlookup, Inquire to match data accuracy, Pivot Tables, Advanced formulas, etc

Currently Working on Mascat Bank Oman Project ‘MASAR’
SQL Programming
Construct & Troubleshoot Stored Procedures
Client’s Site reporting on Tableau
Data Filtration and Data Cleaning
SSAS Cube Development
Data Gathering, Research and Generate Solutions to Address User needs
Data Transfer, Import & Export Data, Data Load with Data Transformation from different sources to destinations through SSIS Package
Data Migration
Analytics / OLAP Cube Troubleshooting (Microsoft SSAS)
Data Present in Share Point Performance Point
Development of Key Performance Indicator
Data Warehouse Development
Fine tune SQL Queries with Indexing etc
Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)

ETL (SSIS).
Tableau visualization software
Reports and Dashboards Development on Tableau
Development of Dashboard
Concept Data Modeling
Data Quality Checks and reporting.
Hadoop and its File System
SQL Server 2012.
Data mining
Big Data
Tool: SQL Server 2008/2012, Tableau (Data Visualizer)
Good Knowledge of Artificial Intelligence techniques
AI Techniques such as Association Rules, Gini Index, Cluster

Work with Nissan Middle East and Majid Al Futtaim client on their BI & CPM Project
Client support on live project and new project development
Client meetings on weekly basis for project update & gather requirements with understanding of all business processes & then creating POC for the clients on their organization’s data
Developed Power BI workbooks from multiple data sources with data blending
Data analytics implementation with DAX expressions in Power BI
Create dynamic reports and dashboards according on client’s requirement
Leading in Dynamic ETL development in Jedox
UAT sessions with client, validating all requirements with client
Restricted data for particular users using Row level security and User filters in Power BI
Creating filter, parameters & calculated fields for preparing dashboard & worksheet in Power BI
Currently working on Agile Scrum using Jira ticketing system for task management
Explore data in a Variety of ways and across multiple visualizations using Power BI
Used Power BI Gateways to keep the dashboards and reports up to date
Creating SSIS packages using various transformations such multicast, merge join, lookup, Conditional split, aggregate, derived column, and data conversion transformations
Proficient in Advance Excel including Advance Functions Eg: vLookup, Pivot tables, Match, Inquire to match data accuracy, charts, graphs, power view etc

Reporting on Viftech’s own Reporting Product with SSRS
Also Reporting on Power BI
Write Stored Procedures
Reporting on Tableau Data Visualization Tool
Data Cleaning and Filtration as client reporting requirement
Hands-on Command on Tableau
ETL Solutions to support key business data using SQL Server Integration Service
Analytics / OLAP Cube Development (Microsoft SSAS and MDX)
Fine tune SQL Stored Procedures
Datawarehouse Development
Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)
Communication with Client to get clear requirement
Currently working on AGILE software process model
Prepare the Analytical Model in Excel and ERD for Warehouse for Schema
Data Analysis using Excel including Advance Functions (Vlookup, Inquire to match data accuracy, Pivot Tables, Advanced formulas, etc

Currently Working on Mascat Bank Oman Project ‘MASAR’
SQL Programming
Construct & Troubleshoot Stored Procedures
Client’s Site reporting on Tableau
Data Filtration and Data Cleaning
SSAS Cube Development
Data Gathering, Research and Generate Solutions to Address User needs
Data Transfer, Import & Export Data, Data Load with Data Transformation from different sources to destinations through SSIS Package
Data Migration
Analytics / OLAP Cube Troubleshooting (Microsoft SSAS)
Data Present in Share Point Performance Point
Development of Key Performance Indicator
Data Warehouse Development
Fine tune SQL Queries with Indexing etc
Direct quality assurance and user acceptance testing by writing test plans and managing the execution of testing (Unit and UAT)