Summary
Overview
Work History
Education
Skills
Interests
Disclaimer
PERSONAL Information
Timeline
Generic
Waseem Iqbal

Waseem Iqbal

Senior Specialist Business Intelligence
Jubail

Summary

A dynamic professional with around 12 years of Experience in Business Intelligence in Microsoft Power BI, MSBI, Azure BI and SAP BO. Currently working in SABIC, Jubail (Saudi Arabia). Experience with visualization tools (Microsoft Power BI, Tableau, SAP BO etc.) Experience in Azure Analysis Services. Experience in Azure Data Warehouse. Knowledge of Azure Data Factory and Azure Data Lake. Experience with MSBI (SSAS, SSRS, SSIS). Having rich exposure on Power BI Desktop/Service, Mobile and Report Server and Embedded with DAX & Tabular SSAS and implementing role based & dynamic security. Have over 7 years of experience on Power BI hands of experience in end to end to development and administration. Worked on the Power BI reports & dashboards with SQL Server/Tabular SSAS/share point and Google analytics sources. Used table/matrix/trend lines/bar/card/gauge/slicers etc and custom visualizations. Comfortable in working with filters/calculated columns/measures/relationships. KPIs/partitions/perspectives and transformations of edit Query section. Published/shared the reports by Creating a content pack/Apps. Worked on on-premises gateway to refresh the data sources/creating a live connection with tabular SSAS, Implemented RLS as part of security. Experience in Data Warehousing and ETL using MSBI, Mosaic ETL and SAP BW Tools. Experience on Data Extraction, Transformation and Loading data from various sources like Oracle, SQL Server and Flat Files. Experience with Analytical tools (Power BI, Tableau, BO Web Intelligence/ Launchpad, Crystal Reports). Developed Power BI Reports and Dashboards from Multiple Data Sources using Import Mode, Direct Query and Live Connection. Connected to data sources from Excel, CSV, Blank queries to SQL Server Database, Azure HD Insights, Oracle Database, ODBC, OLEDB, R Script and others. Designed Power BI Data Visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts, tornado charts, different slicers and filters etc. Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Overview

11
11
years of professional experience
4
4
Languages

Work History

Senior BI Consultant

SABIC
04.2019 - Current
  • Creating reports and Dashboards for Corporate Digitalization Program module.
  • Gathering the requirements of different projects and providing the complete end to end BI analytics solution to SABIC Affiliates.
  • Created several reports for different affiliates such as Yanpet, Yansab, Petrokemya reports.
  • Data Modeling done in Big Data systems and consuming to create dashboards via direct query connections.
  • Developed Power BI Reports and Dashboards from Multiple Data Sources using Data blending.
  • Projects: SABIC Corporate Digitalization Program Project.
  • Tools Used: Microsoft Power BI, Tableau, Hadoop Big Data Systems, MS-SQL Server and OSI-PI System.

Senior Software Analyst

Cloudmoyo Ltd
11.2018 - 04.2019
  • Created reports for StatTrak module for FTE Calculation in projects.
  • Created several reports for different departments such as Water, Power, Telecom reports.
  • Working in Power BI and created several Reports and Dashboards for respective clients.
  • Worked on Live Connection reports using SSAS and Azure Analysis Services.
  • Data Modeling done in SSAS and Azure Analysis Services.
  • Worked on SSIS and Azure Data Factory.
  • Developed Power BI Reports and Dashboards from Multiple Data Sources using Data blending.
  • Projects: Black and Veatch (USA), Maritz (USA).
  • Tools Used: Microsoft Power BI, SSAS, Azure Analysis Services, ADF.

Software Engineer

L&T Infotech Ltd
12.2017 - 11.2018
  • Worked in Power BI and created several Reports and Dashboards for all the three clients.
  • Developed Power BI Reports and Dashboards from Multiple Data Sources using Data blending.
  • Connected to data sources from Excel, CSV, Blank queries to SQL Server Database, Azure HD Insights, Oracle Database, ODBC, OLEDB, R Script and others.
  • Created and deployed cubes on star and snowflake schema.
  • Performed and worked with calculated columns, measures, DAX Queries.
  • Designed Power BI Data Visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts, tornado charts, different slicers and filters etc.
  • Worked on Import Query and Direct Query Mode.
  • Worked a lot on Query Editor mode and advanced query mode in Power BI.
  • Worked on Power Query, Power View and Power Map.
  • Explored data in variety of ways and across multiple visualizations in Power BI.
  • Contributed in the development of Knowledge Transfer documentation.
  • Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Worked especially for Account Receivables reports and dashboards.
  • Worked on Accounts Payable reports and Dashboards.
  • Worked on different PUC reports and DSO reports.
  • Worked for a product named Redaxis.
  • Projects: P&G (USA), Sanofi Pharmaceuticals (France) and LTI (India).
  • Tools Used: Microsoft Power BI, SSAS, Mosaic ETL, Hive Connectors.

Associate Technical Consultant

KPIT Technologies Ltd
11.2014 - 08.2017
  • Extensively worked in Power BI and created several Dashboards.
  • Exclusive Experience in SAP BW connectivity with Universe Designer and Business objects Infoview using the SAP Integration Kit.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Extensively worked on Business Objects Architecture & Administration. Created Users and Groups and setting the rights on them using Central Management Console (CMC). Scheduled Crystal Reports in CMC on Daily, Monthly, Weekly basis
  • Created reports from multiple sources & functionalities like slice & dice, drill down in WebI Reports.
  • Created Classes, Prompts, Alias, Contexts & number of derived tables and used oracle functions like Start with, Connect by Prior, List Agg, DBMS_lob etc
  • Created complex and sophisticated ad-hoc reports with multiple Data Providers, Master/Detail, Breaks, Filters, Drill Down, Slice and Dice features, 2D/3D charts, Dashboards, Scorecards.
  • Used various @Functions like @Prompt, @Where (For creating conditional filters) and @Select and @Variable
  • Successfully implemented Business Objects functionalities like Contexts, Aliases, Aggregate Awareness, Derived Tables, Cascading LOVs, Customized LOVs, and Cascading Prompts
  • Accountable for providing high-end solutions to Business Objects customers and troubleshooting all issues related to development and administration.
  • Handling escalations of customers and to work on Very high messages whenever required.
  • Connecting to Customers environment using screen sharing for better understanding and faster resolution.
  • Consistently contributing to SAP Knowledge base repository, with my experiences on unique issues.
  • Part of Quality Management Team, which keeps close watch on Incident SLA’s and helps in delivering faster resolution within the team.
  • Understanding customers Enhancements with-in the products and assisting them in proceeding further.
  • Conducted various Knowledge transfer session to Up-skill other teammates on advance technologies.
  • Projects: Internal KPIT Enabling Project
  • Tools Used: Microsoft Power BI, Universe designer, Web Intelligence, Crystal Reports, Upgrade Management tool, LCM, Translation Manager, Import Wizard, Central Management Console, VM Ware, Information Design Tool etc.

Trainee Support Engineer

Mphasis Ltd
05.2014 - 11.2014
  • BI Support
  • Task: Support
  • Team Size: 6

Education

Bachelor of Engineering - Electronics

P.E.S College Of Engineering

Skills

  • Operating System: Windows XP/7/81/10 and LINUX Server

  • Data Warehouse Tools: Azure Data Warehouse, ADF, Mosaic Eco Systems ETL, SAP BW 73

  • Business Intelligence Tool: Microsoft Power BI, Tableau, SAP Business Objects XIR31, 40, 41, Crystal Reports 2008, 2012, SSAS, SSRS, SSIS, Mosaic ETL

  • Reporting Tools: SSRS, Web Intelligence, Crystal Reports, SSRS

  • Dashboards: Microsoft Power BI, Tableau, Qlikview, SAP Lumira and Design Studio

  • Programming Languages: SQL, T-SQL, DAX, MDX

  • Databases: MS SQL Server 2012, 2014, 2016, 2019, Oracle, MySQL, MS Access

  • Database Skills: Star Schema, Snowflake Schema, RDBMS, T-SQL, Fact and Dimension Tables, Conceptual, Logical and Physical Data Modeling

Interests

Exploring New Technologies, Travelling, Cricket

Disclaimer

I hereby declare that the above-mentioned information is correct to the best of my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars. Place: Jubail, Dammam, Saudi Arabia. Date: Waseem Iqbal

PERSONAL Information

  • Date of Birth: 1987-11-06
  • Gender: Male
  • Marital Status: Married
  • Nationality: Indian

Timeline

Senior BI Consultant

SABIC
04.2019 - Current

Senior Software Analyst

Cloudmoyo Ltd
11.2018 - 04.2019

Software Engineer

L&T Infotech Ltd
12.2017 - 11.2018

Associate Technical Consultant

KPIT Technologies Ltd
11.2014 - 08.2017

Trainee Support Engineer

Mphasis Ltd
05.2014 - 11.2014

Bachelor of Engineering - Electronics

P.E.S College Of Engineering

Similar Profiles

CREATE PROFILE
Waseem IqbalSenior Specialist Business Intelligence