Abdullah Alfarouk Email and Phone Number
Abdullah Alfarouk work email
- Valid
Abdullah Alfarouk personal email
- Valid
Head of Data Management - Center of Excellence SQL Server:10+ years of experience in Database Designing, Development and Maintenance using MS SQL Server 2008/ 2020.• Experience in writing scripts to Migrate data from multiple source databases to upgrade newly designed database.• Wrote stored procedures using Dynamic SQL, while loop, Cursor to handle special case which can't be handled using static T-SQL or set based operations.• Experience in optimizing performance of various long running queries and stored procedures using indexing strategies, SQL Profiler and SQL Execution plan.SSIS (SQL Server Integration Services):10+ years of experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services 2008/ /2012.• Excellent experience in migration of data from Excel, Flat file, CSV, Oracle to Microsoft SQL Server.• Used ETL transformation (Look up, SCD’s, etc...) to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.• Good Knowledge in optimizing SSIS packages by tracking, Logging and maintaining optimal buffer usage based on the execution trees.• Experience in Error logging and Event Handling: Precedence Constraints, Break Points, Check Points.• Hands on experience in Configuring, Deploying and Scheduling the SSIS packages.SAS : SAS information map - SAS enterprise guide 2+ years of experience in creating and managing data mapping in SAS information map to support SAS Campaign management team . 2+ years of supporting and maintaining tables and schema under SAS enterprise guide used by our Analyst team for analysis and modeling . 1+ year of creating basic analysis and dashboards using SAS VA
National Bank Of Kuwait
View- Website:
- shor.by/nbklinks
- Employees:
- 7535
-
Assistant Vice PresidentNational Bank Of KuwaitKuwait -
Head Of Data Management & GovernanceNational Bank Of Kuwait May 2019 - PresentKuwaitWorking under Center of Excellence in NBK Skills :1-SQL2-SSIS3-VPA Code4- .NET Framework 5- SAS Information map6-SAS Enterprise Guide 7- SAS programming Language 8- in depth understanding of banking products Develop, maintain and enhance ETL "SSIS" and Automation activities for maintaining MIS Data Marts.Generate and manage daily and monthly data marts while assuring they are correct, accurate and updated in a timely manner , Monitor data for quality and consistency.Collect and consolidate required data for our business partners , Assist and Develop customized data deliverables and reports.Submit accurate status reports in a timely manner, as well as document internal processes Maintain MIS website and manage user’s access.Troubleshoot daily, weekly, monthly marts and reports , Manage the execution and reporting of BSC daily reportsIT Liaison:Work closely with IT Architecture team to be aware of new data sources and incorporate them into data martsEnsure that ETL’s "SSIS"are coupled with ODS flash copy activitiesOptimize queries and find ways to automate tasks to reduce time spent on repetitive activities. Deliver complex Ad-hoc Requests :Gather proper data requirements from Business in order to understand the requestDevelop SQL & T-SQL codes to extract the dataProject Management:Assist in creating project plans for small projects in conjunction with the businessAssist with managing, supporting, and following up with the project team on these projectsMonitor and manage project progressAssist our Campaign management team with their creation of SAS Campaigns by creating their data models using SAS information map and registering tables on SAS Enterprise Guide -
Business Intelligence SpecialistAgile Technologies Apr 2019 - Jun 2019Dubai, United Arab Emirates• BI development (SSIS packages, PowerBI, SSRS), Data Migration experience in Migrating Data between Microsoft SQL and Oracle PSRM systems -
Business Intelligence SpecialistAgile Technologies Oct 2017 - Mar 2019Cairo Governorate, Egypt• BI development (SSIS packages, PowerBI, SSRS), Data Migration experience in Migrating Data between Microsoft SQL and Oracle PSRM systems• Extensive knowledge in Test Management (Writing test plan, testing strategy, executing test cases and writing closure reports). -
Specialist , Applications Development And SupportNational Bank Of Kuwait Nov 2013 - Jul 2017KuwaitCore.es – Kuwait (November 2013 – Present)• Responsible for translating business data requirements into conceptual, logical, and physical data Models • Experience in BI (SSIS) , ETL using Data Stage.• Good domain knowledge in Banking• Exposure in Offshore-Onsite Model • Experience in writing Stored Procedures, Indexed Views, Triggers and User defined Functions for data consistency and manipulation
Abdullah Alfarouk Skills
Abdullah Alfarouk Education Details
-
Msc - It Management -
Bsc - Applied Business Computing
Frequently Asked Questions about Abdullah Alfarouk
What company does Abdullah Alfarouk work for?
Abdullah Alfarouk works for National Bank Of Kuwait
What is Abdullah Alfarouk's role at the current company?
Abdullah Alfarouk's current role is Assistant Vice President.
What is Abdullah Alfarouk's email address?
Abdullah Alfarouk's email address is ab****@****ail.com
What schools did Abdullah Alfarouk attend?
Abdullah Alfarouk attended University Of Sunderland, University Of Sunderland.
What are some of Abdullah Alfarouk's interests?
Abdullah Alfarouk has interest in Health.
What skills is Abdullah Alfarouk known for?
Abdullah Alfarouk has skills like Sql, Databases, Html, C#, Oracle, C++, Microsoft Office, Programming, Windows, Analysis, Data Warehousing, Mysql.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial