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
Manager BI
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)
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.Â
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.
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).