Business Intelligence Associate Consultant
ITWORX
مجموع سنوات الخبرة :16 years, 1 أشهر
- Enterprise Data Warehouse design and implementation
- In-memory analytics (Microsoft Tabular Model)
- Data mining project (Description and predication data mining models)
• Building a data warehouse and business intelligence solutions for governmental organization, KSA, Riyadh.
o Developing strategic-oriented reports and KPIs
o Designing and building analytical dashboards for top management
Used Technologies: Microsoft SQL Server 2012, Excel 2013, SharePoint 2013, Excel Services, PowerPivot and Power View in-memory analytics.
• Building a data warehouse and business intelligence solutions for Technical and Vocational Training Corporation (TVTC), KSA, Riyadh \[Offshore\].
o Developing more educational KPIs
o Advanced usage for SSRS and Dundas Dashboard
o Using PowerPivot in Excel 2010
• Delivering a practical training course in MSBI to fresh employees in Wipro Egypt.
The course contents are:
o Data warehousing design and architecture
o Extract, transform and load (ETL) the data. Building the data warehouse using SSIS
o Building cubes using SSAS
o Using SSRS, PerformancePoint Services in SharePoint 2010 and Dundas Dashboard
• Implementation of SRI and SVM models to build language models for analyzing the International Corpus of Arabic (100 million words)
• Implementation of a rule-based and statistical system for the Arabic corpus
• Designing and building a data warehouse and business intelligence solutions for Technical and Vocational Training Corporation (TVTC), KSA, Riyadh \[On-Site\].
o Using MS SQL Server R2 and Microsoft Business Intelligence Development Studio.
o Developing ETL packages to build the data warehouse
o Building and analyzing the cubes and dimensions
o Deploying dashboards, KPIs and scorecards over SharePoint 2010, PerformancePoint Services (SPS) and PowerPivot
o Using Silverlight-based dashboards (Dundas Dashboard and ComponentArt)
• Building a web interface for Base SAS application for the Ahli United Bank project (AUB), Kingdom of Bahrin \[Offshore\].
o Using MS SQL Server 2005 and .NET framework 3.5, C#
o UML design of the project.
o Design user logging and authentication module
o Build the Operational Data Store (ODS) module
o Build auditing module for the project
• Building the web site for the Indian embassy in Cairo
o Using MS SQL Server 2005 and .NET framework 3.5, C#
o Support the website and implementing new requirements
• Building a web site for the Indian community in Egypt
o Using MySQL and .NET framework 3.5, C#
o Developing registration module and sending registration confirmation though email
• Designing and building a website for a restaurant (Wipro training)
o Using MS SQL Server 2005 and .NET framework 3.5, C#
o Developing XML web service for e-banking payment
• Machine translation specialist in the International School of Information Science (ISIS), ICT Sector.
• Using the Universal Networking Language (UNL) platform to design a system for answering questions in several languages about books meta-data and return the
result in one of these languages.
• Building the database of Arabic dictionary in UNL format.
• Adding part of Encyclopedia of Life Support Systems to the UNL platform to make it language independent.
• Developing and designing the official website of faculty of arts, Alexandria University using Microsoft Expression Web.
• Designing and building the data base of the website.
• Publishing the results of exams and internal coordination of students on the website.
- TDWI Data Warehousing Architectures - TDWI Advanced Data Modeling Techniques - TDWI Business Intelligence Principles of BI Design - TDWI Business Intelligence Principles & Practices: Charting the Path to BI Success
• Class and lab leader at the ITI. • MS SQL Server 2008 • SQL Server Business Intelligence • Business Intelligence and Data Warehouse • Oracle SQL/PLSQL • Software Engineering (Architecture and Security) • C#.NET Programming Using Framework 3.5 • ASP.NET 3.5 • Ajax & ASP.NET MVC • Web Portals Using ASP.NET • Windows Workflow Foundation (WWF) • Windows Presentation Foundation (WPF) & Silverlight 2.0 • XML & Allied Technologies • XML Web Services • Windows Communication Foundation (WCF) • Microsoft SharePoint Server (MOSS 2007) • .NET Network Programming • .NET Design Pattern • .NET Game Programming (XNA) • JavaScript & JSON • Advanced Java Web Programming. (Struts II and Spring frameworks)
Scientific study of the human language (Phonetics, Phonology, Morphology, Syntax, Semantics and Pragmatics). Applied linguistics (Speech and Language Pathology, Acoustics, Forensic Linguistics) Computational Linguistics (Machine Translation, Statistical Linguistics, Universal Networking Language, Databases and VB programming language) Graduation project: "Towards building a syntactically analyzed corpus for written modern standard Arabic WMSA" Graduation project's grade: Distinct Natural Language Processing using Visual BASIC 6.0. Faculty of Arts ideal student (2005/2006)