Global Business Services
Waqas Ashraf
Sr. Certified DWH/BI Consultant
www.linkedin.com/in/mwaqashraf
ac2981@r.postjobfree.com ac2981@r.postjobfree.com
Riyadh, Saudi Arabia
Professional experience
Summary
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
Tools:
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
Arabia
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
Manager
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
Contribution/Achievements:
• 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
Engineer
Tecnex LLC,
Pakistan
Islamabad, Pakistan
Nov 2010 – Feb 2011
(4 months)
Intern
TRG Tech,
Pakistan
Islamabad, Pakistan
Education
Qualifications
2007-11 BS(IT)
NUST School of Electrical Engineering and
Computer Science (SEECS), Islamabad,
Pakistan