Bi Developer / Senior .Net Developer
Jeddah, Makkah, Saudi Arabia
As BI/DW Developer, I have been responsible for developing high-quality extraction/transformation/load (ETL) programs, creating logical and physical data models, data flow diagrams, entity relationship diagrams and building business intelligence reports using SQL Server, SQL Server Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS). As Senior .Net Developer, I developed multiple intranet portals used organization wide with key focus on system performance, TDD, CI/CD and version management. Followed coding best practices ensuring delivery of scalable solutions. • Wrote code extensively in C#.NET, VB.NET and ASP.NET for several in-house developed systems.• Created user-friendly interfaces utilizing javascript, jquery, HTML and CSS.• Used third-party user controls such as Telerik and Fusion Charts in web applications.• Part of an in-house development team and tasked with bringing BI to the forefront of data analytics through the comprehensive use and application of Microsoft BI stack (SSIS/ SSRS/ SSAS) and Qlikview. • Wrote and developed ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports based on the latest SSRS (2008/2012/2016) versions & features. Led the creation of standards for SQL Server database administration that supports the use of optimal database server resources and performance. • Designed data warehouses and data marts based on Kimball methodologies (best practice). • Developed the architecture for OLAP environments to provide fast and efficient data for analysis using multiple data sources. • Wrote complex Stored Procedures, Functions, Views, Triggers, and Cursors for business applications, and leveraged from DDL, DML, and DCL to create and modify the structure of database objects. • Leveraged from SQL, T-SQL, Visual Studio, Crystal Reports, Microsoft Excel and QlikView.