خلاصہ

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)
نومبر ۲۰۲۰ - موجودہ | Lahore, Pakistan

Manager BI 

کمپنی کا لوگو
Sr. EDW/BI Consultant
MINISTRY OF TOURSIM –RIYADH- SAUDI ARABIA
مارچ ۲۰۲۰ - اگست ۲۰۲۰ | 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
جنوری ۲۰۱۸ - فروری ۲۰۲۰ | 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)
اگست ۲۰۱٦ - جنوری ۲۰۱۸ | Riyadh, Saudi Arabia

کمپنی کا لوگو
Senior PS Consultant
Bilytica (Pvt) Ltd
اگست ۲۰۱۴ - دسمبر ۲۰۱۵ | 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
فروری ۲۰۰٦ - جولائی ۲۰۱۴ | 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

پیشہ ورانہ مہارتیں

ماہر Advanced Excel
ابتدائی 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
متوسط Hadoop
ابتدائی Hive
ابتدائی Linux Shell scripting
متوسط LTN
ماہر Master Data Management
متوسط MDX
ماہر Microsoft .NET
ماہر Microsoft SQL
ماہر Microsoft SQL Server
ماہر Microsoft SSIS
ماہر MS SQL Server
ماہر MS Visual Studio
ماہر MSBI
متوسط Object-Oriented Software
ماہر OLAP
متوسط Oracle
متوسط PHP
ماہر PL and SQL
ماہر Power BI
ماہر Query Language
ماہر SAP Crystal Reports
ماہر SASS
ابتدائی Scala
ماہر Software Analysis
متوسط Software Engineering
متوسط Spark Data
ماہر SQL
ماہر SSAS
ماہر SSIS
ماہر SSRS
ماہر T-SQL

زبانیں

ماہر اردو
ماہر انگریزی

آپ کن کمپنیز کی پیروی کر رہے ہیں