Abdullah Alfarouk Email & Phone Number

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

Listed skills include Sql, Databases, Html, C#, and 18 others.