Database Consultant And BI Engineer
Diyar United Company
مجموع سنوات الخبرة :21 years, 2 أشهر
Database Administrator and Consultant:
Managing and admin many sites in MOI ( Ministry of Interior ) in Kuwait like e-Passport system, PACI
Preventive Maintenance and databases check health
Data Scientist:
Analyze data and build AI tools using Microsoft Power BI and Tableau
attend training for Machine Learning (Microsoft Data Science AI and
Cognitive Services Event) KOENIG in Dubai (Microsoft Partner)
Data Architect :
Maintains database by determining structural requirements; developing and installing solutions.
• Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
• Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
• Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions.
• Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
• Prepares users by conducting training.
• Provides database support by coding utilities, responding to user questions, and resolving problems.
• Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Accomplishes information systems and organization mission by completing related results as needed.
Data Scientist:
Develop and plan required analytic projects in response in business needs.
Contribute to data mining architectures modeling standards, reporting and data analysis methodologies.
Monitor data mining system performance and implement efficiency improvements.
Clouding & Big Data :
• Transfer data from SQL server into Redshift (Managed Petabyte-Scale Data Warehouse Service)
• Creating SSIS Packages using Zappy Sys Tools (http://zappysys.com/) to transfer data from SQL Server into Redshift and versa vise also to crate schedule tasks run on Redshift
• Transfer data from SQL server into EMR Cluster, creating Linux Jobs that import data in JSON format into EMR Cluster using Hive Tables and HQL
• Monitor Jobs on Hive and Cluster Server Jobs Instance
• Monitor Cluster performance using Ganglia,
• R&D in Big data concept and Specific in Hadoop
• Setup and Create cluster using EMR (Managed Hadoop Framework Services in Amazon)
Data Analysis Tools :
• Using Tableau Powerful analytical tools. http://www.tableau.com
go deeper into your data with new calculations on existing data.
creating Dashboards connected to SQL server and EMR cluster using ODBC connection
• Using SiSense Powerful analytical tools. http://www.sisense.com/
Business Intelligence (BI) Software
• Microsoft Power BI to creating Dashboards https://powerbi.microsoft.com
Collecting data from Redshift Amazon services and SQL server to create dashboard online that help managements and decision makers
• Analyzing data using Microsoft Excel connected to Redshift, Microsoft Power BI, SSAS and SQL and created Dashboards, Graphs…
Database administration:
Admin Different MS-SQL server 2008 and 2008 R2 for Database Company
Its backup's strategy, security, Mirror between different Databases in different servers
databases performance, Log Shipping DBs in different Server and control any locks happen on the Databases
Upgrade Live server from SQL 2008 into SQL 2012 Enterprise Edition.
Working in different database administration phases like Backups, Restoring, DTS for Data, managing security levels, managing performance using SQL Profiler.
Migrate Database from old schema into new schema and transfer data
Database analysis:
Working in database projects analysis of requirements and classification into categories to be more efficient in design steps using Erwin Data Modular For Analysis and Design and To Convert with easy way From Designing Mode into a Database Design
Example: Making All analysis for the new Law Of Income Tax For 2006 with all its Requirements.
Database design:
Working in designing databases from A to Z starting with paper design and ending with ERD diagram, Creating and Managing Tables, Jobs, Store Procedures and Views, converting form old databases as (Informix) to new databases as (SQL)
Database administration:
Working in different database administration phases like Backups, Restoring, DTS for Data, managing security levels, managing performance using SQL Profiler.
Integrate Sales System And Income Tax System into On Schema (Transfer Data from Sybase Platform into SQL Engine) Data, DB Design,
Working in Smart Card Application for Income and Sales tax For every Taxpayer should have an intelligent card that has all his transaction and his data related to his work.
For Now …. Working as Analyst and Developer to Make Migration Between Sales Tax and Income Tax to Be One Database Schema For only one system
Converting From SQL Server 2000 Into SQL Server 2005 For 64 Bits and Facing a lot of Problems with 64 Bits in the new Environment and trying to solve these problems.
Database Team Leader:
Lead Database Team in Egyptian Taxation Authority
That team response of managing 227 Locations having database and its Backup, restoring and Replication between these locations and Head Quarter Database and Vice versa
Managing Head Quarter Database that contain all Data for all Sites (227 sites) in Egypt and manage its Jobs, Backup schedule, resolve problems found in Egyptian taxation districts
Large Project In Egyptian Taxation Authority (Achievement):
Upgrade from SQL server 2000 to SQL Server 2005 and SQL Server 2008: Transfer about 227 locations from SQL 2000 into SQL 2008.
Upgrade Cluster server in Head Quarter from SQL server 2000 into SQL server 2005
Participating in the merger between general taxes and sales taxes:
Merge Database of General Taxation with Sales Database and generate unified Database for both with 1 Schema and create Large Taxpayer Center for both General Tax Payers and Sales Taxpayers
Contribution in the selection of the sample central to tax Auditing system for 3 consecutive years:
Working through a team of advisor to the Minister of Finance and head of the tax examination and head of the Central Administration of the tax examination to work on the selection of a sample examination of taxyears2005 - 2009, 2010 and 2011
And a central work reports and submit it to the President of the Egyptian Tax Authority and the sample is determined on the basis of the criteria are placed on the central database and identify financiers selected sample
courses: General Secondary Certificate With a grand Total of 98.5% Attended Courses
Computers Science and Information Systems
With total grade: Very Good.