Sign in

Sr. Business Intelligence Consultant

Riyadh, Riyadh Province, Saudi Arabia
November 13, 2017

Contact this candidate


Global Business Services

* ** *

Waqas Ashraf

Sr. Certified DWH/BI Consultant


Riyadh, Saudi Arabia

Professional experience


Having 7+ years of diverse experience in DWH, ETL and BI projects aligned with critical business requirements through strong exposure of telecom and healthcare sector. Built wealth of knowledge about end to end processes involved in DWH/BI projects. Recognized for being productive and creative resource for respective organization.

Worked for fortune companies like Saudi Telecom (STC) and China Mobile Pakistan (CMPak) in various capacities as DWH Architect, ETL Developer, BI Lead and Technical Project Manager.

Managed one of leading telecom operator’s DWH project with DBMS having 60+TB that focuses on DWH and BI subjects including end to end service delivery and team management.

Extensive experience of BI solution implementation and deployment including installation, upgradation and migration in high available environments. Skills

Technologies/Methodologies: Data/Dimensional Modelling, ETL, DWH, BI, PL/SQL, SQL tuning


Modelling: Toad Data Modeler 6.1

ETL: Ascential Data Stage Server Edition 8.5 (certified) BI: SAP Business Objects 3.1/4.1(certified), WebI Reports, Crystal Reports 2008/2013, SAP Dashboards, IBM SPSS Modeler v2(certified), IBM Cognos 10(certified), MS Power BI

Other: PLSQL Developer, Toad for Oracle, Visual Studio 2011 Databases: Oracle(certified), MS SQL Server 2008, MS Access, MySQL Languages: Python, R, MATLAB, C#, Java, Shell scripting Certifications:

1. SAP Certified Application Associate – SAP BusinessObjects Business Intelligence platform 4.0

2. IBM Certified Designer - Cognos 10 BI Reports

3. Oracle Certified Professional (OCP) - Advanced PL/SQL Developer 4. IBM Certified Solution Developer - InfoSphere DataStage v8.5 5. IBM Certified Specialist - SPSS Modeler Professional v2 6. Oracle Certified Associate (OCA) - PL/SQL Developer 7. Oracle Certified Expert - Database SQL

Global Business Services

2 of 3

Career History

Dec 2013 – Date

(4 years)

Sr. BI Consultant IBM, KSA

Riyadh, Saudi


Client: Saudi Telecom (STC)

Project: SQM/SLM Development (Current)

IBM is providing SQM/SLM solution that is targeted to ensure that STC will implement a robust Service Quality and Service Level Management Solution to help STC better manage the customer experience and Service Level Agreements (SLAs) with them. Achievements:

• Proposed and Implemented data mart for Wholesale Business Unit (WBU) including data modelling, dimensional modelling, ETL, universe designing and Reporting (WebI, Crystal Reports, Dashboards)

• Optimized and revamped existing reports and achieved 400% performance gain

• Consolidated 75+ reports into 9 reports for increased customer usability

• Successfully migrated BI content from BO XI 3.1 to BO 4.1

• Setup new HA (Highly Available) BI cluster environment with load balancing

Jul 2013 – Dec 2013

(6 months)

Technical Project


IBM, Pakistan Islamabad, Pakistan

Client: China Mobile Pakistan (Zong)

Project: DWH Operations & Support

IBM is providing support for daily batch operations and maintenance to CMPak. This project added Churn Analysis, Mobile Number Portability (MNP) Analysis, Site Profitability Analysis, Location Based Revenue, Usage and Customer Analysis, Market Intelligence Analysis as enhancements to their existing Data Warehouse system. Contribution/Achievements:

• Supervised and provided technical support to DWH batch operations & support team

• Ensured service quality by managing project’s triple constraint

• Successfully lead DWH team to achieve customer satisfaction

• Got involved in overall service delivery from creating PCRs to client signoff

Global Business Services

3 of 3

Other relevant information

Honours • Recipient of ‘Best Industrial Project’ award and honorary shield for the final year project ‘Semantic enabled Cloud-based EMR’.

• Attained merit based scholarship funded by NUST-SEECS in BS (IT) and MS (CS).

• Awarded fully funded 4-year program scholarship by ICT R&D Fund for BS (IT) program.

Languages English Fluent

Urdu Native

Last Updated: Sep 2017

Jul 2011 – Jul 2013

(2 years)

ETL Consultant IBM, Pakistan Islamabad, Pakistan

Client: China Mobile Pakistan (Zong)

Project/Assignment: DWH Operations & Support


• Optimized ETL jobs to reduce batch time

• Successfully handled DWH Daily batch operations and support activities

• Got Promoted to Technical Project Manager role over excellent performance assessment feedback and customer satisfaction Mar 2011 – Jul 2011

(5 months)

Jr. Software Design

and Development


Tecnex LLC,


Islamabad, Pakistan

Nov 2010 – Feb 2011

(4 months)


TRG Tech,


Islamabad, Pakistan



2007-11 BS(IT)

NUST School of Electrical Engineering and

Computer Science (SEECS), Islamabad,


Contact this candidate