概要

Highly accomplished and experienced Data Warehouse /Business intelligence consultant with comprehensive understanding of all aspects of data modeling. Good balance of technical and management skills, with proven ability to lead complex, globally distributed teams and deliver projects on time and on budget.

Technical Expertise:

Data warehousing
ETL architecture using (SSIS, Custom SQL scripts using Oracle /SQL Server)
Data Analysis, Data Profiling, Data Cleansing and Data Verification.
SQL/PL-SQL (ORACLE /SQL SERVER), Procedures, Functions, Triggers.
Data Modeling- Conceptual /Logical and Physical modeling. Optimization (Query/Database)
Master Data Management, Metadata

Big data Tools/Scripting
Hadoop, Scala, Spark using Scala, Spark SQL Using Scala, Pyspark,Python, Linux shell scripting , R scripting

Business Intelligence
SSAS/SSRS/MDX queries/SAP Business intelligence /SAP Crystal Report/Power BI/QlikView and Tableau. OLAP, ROLAP, MOLAP, Cubes.Custom charts using .net framework

Development
Microsoft .Net technologies C# MVC5

项目

BI Solution
BI Solution
DSU (Decision Support System)

工作经历

公司标识
Principle Data Specialist
TRG Tech (IBEX)
Nov 2020 - 代表 | Lahore, Pakistan

Manager BI 

公司标识
Sr. EDW/BI Consultant
MINISTRY OF TOURSIM –RIYADH- SAUDI ARABIA
Mar 2020 - Aug 2020 | Riyadh, Saudi Arabia


Designation:  Sr. EDW/BI Consultant.
Role: EDW/BI
Working model : COVID-19 Work from Home
Accomplishments : Implemented Data warehouse solution MT(ministry of tourism)– Riyadh , Saudi Arabia
Responsibilities.
Design technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores). 
 Assisting the team with performance tuning for ETL and database processes
Creates logical and physical data models, mapping logical to physical. 
Developed data organization models considering user data and business rules
Contributed in the creation and supporting activities of complex data storage models
Design and develop ETL processes. Establish coding standards, perform code review and automate the health of the platform
Perform data analysis, develop database design, share and get consensus on design, and then develop the stored procedures to fulfill the database design
MSBI (SQL Server intermigration services  / Analysis services / Power BI)

公司标识
Sr. Data Warehouse Consultant
IMAM ABDULRAHMAN BIN FAISAL UNIVERSITY – DAMMAM- SAUDI ARABIA
Jan 2018 - Feb 2020 | Riyadh, Saudi Arabia


Designation:  Sr. EDW/ETL Consultant.
Role: EDW/ETL
Responsibilities.
Supporting and Developing day to day KPI on existing Decision support unit (DSU).
Oracle 11g/ Tableau
Designs and develops BI reporting deliverables. 
Project:
Princess NORA BINT ABDUAL RAHMAN  UNIVERSITY–Riyadh- SAUDI ARABIA
Designation:  Sr. EDW/ETL Consultant.
Role: EDW/ETL(Team Lead)
Accomplishments : Implementing DSU (Decision support unit ) solution on Prince NOURA UNIVERSITY – Riyadh , Saudi Arabia
Responsibilities.
Analyzed the existing systems and the business user requirements for tactical and strategic needs. Created the Multi-Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements due to various corporate groups accessing the data.
ETL Architect.
Data Profiling / Data Quality Report.
Develop presentation/Symantec layer using Oracle 11g. 

公司标识
Sr. Data/BI Consultant
Holool Aloula (NCBS National Company for Business Solutions)
Aug 2016 - Jan 2018 | Riyadh, Saudi Arabia

公司标识
Senior PS Consultant
Bilytica (Pvt) Ltd
Aug 2014 - Dec 2015 | Lahore, Pakistan

Role: ETL Consultant
Accomplishments:
1) Successfully implement Enterprise Data Warehouse /business intelligence solution on UNIVERSITY OF DAMMAM –DAMMAM, Saudi Arabia.
2) Successfully implement BI solution on ALBAWARDI HEARDWARE as Data BI Team Lead. Major source was SCM (Supply Chain management), Finance and HR.
Responsibilities.
ETL Architectures.
Data Profiling / Data Quality Report.
Information Sourcing
Data profiling and Issue tracking
Data Quality, Data cleansing
Design and develop ETL scripts
Documenting the types and structure of the business data (logical modeling)
Develop presentation/Symantec layer using Oracle 11g.

公司标识
Sr. Software ENGG
Catalisse (Pvt) Ltd
Feb 2006 - Jul 2014 | Lahore, Pakistan

Role: Team Lead(Data/BI)
Responsibilities.
Requirement gathering from USA management for data analysis on Daily, Weekly, Monthly and yearly bases by using different reporting tools Identify and evaluate industry trends in database systems to serve as a source of information advice for upper management
Write and code logical and physical database descriptions specify identifiers of database to management system or direct others in coding descriptions
Responsible for inbound healthcare and hospital data verification and validation using established ETL (Extract, Transform, Load) data warehousing procedures and processing.
Write complex SQL queries to evaluate and update inbound data. Create SQL processing script templates for new datasets. This consists of new written workaround scripts if needed to verify raw data.
Creates business requirements and guidelines as it relates to receiving data, data quality and data profiling
Clean and manipulate complex healthcare datasets in order to create the data foundation for further analytics and the development of key insights (MSSQL server, Power BI, SSRS, Crystal Report)
Modelling the data relationship to provide assistance for business decision making (SSRS, Crystal Report).

学历

Hamdard University
硕士, 科学硕士学位, Masters in Computer Sciences‎
BA (Hons) Urdu for Foreigners
CGPA 3.3/4
2003
Institute of business administration Punjab University
学士, 贸易学士, B.Com‎
Commerce
所占比重 58%
2001

技能

初学者 Automation Languages Command
中级 Big Data
熟练 Business Intelligence
熟练 Business Intelligence Projects
熟练 C#
熟练 Data Aggregation
熟练 Data Analysis
熟练 Data Mapping
熟练 Data Modeling
熟练 Data Quality
熟练 Data Warehouse Architecture
熟练 Database Replication
熟练 DAX
熟练 Design With UML
熟练 ERD
熟练 ETL
熟练 ETL (Custom/SSIS)
熟练 ETL Tools
中级 Executing Content
中级 Hadoop
初学者 Hive
初学者 Linux Shell scripting
中级 LTN
熟练 Master Data Management
中级 MDX
熟练 Microsoft .NET
熟练 Microsoft SQL
熟练 Microsoft SQL Server
熟练 Microsoft SSIS
熟练 Ms Excel Excel
熟练 MS SQL Server
熟练 MS Visual Studio
熟练 MSBI
中级 Object-Oriented Software
熟练 OLAP
中级 Oracle
熟练 PL and SQL
熟练 Power BI
熟练 Query Language
熟练 SAP Crystal Reports
熟练 SASS
初学者 Scala
熟练 Software Analysis
中级 Softwares Design
中级 Spark Data
熟练 SQL
熟练 SSAS
熟练 SSIS
熟练 SSRS
熟练 T-SQL

语言

熟练 乌尔都语
熟练 英语