خالد Barhoumi

BI Developer (iTech Solutions 06/2011-11/2012)

Our project was created to enable management to better leverage information collected within Marriott's current operational systems to help in their decision-making process to analyze the sales product wise, sales team's performance and sales promotions etc. The system aimed to provide continuity of knowledge about customers and facilitates proactive sales management techniques for customer-centric teams.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Triggers, Constraints, Indexes, Functions, Views and complex SQL statements.
• Involved in optimizing queries for faster retrieval and Server efficiency.
• Created stored procedures for day end operations using SQL Server agent.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Tuning Wizard.
• Implemented failure alerts using email in SSIS.
• Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services (SSAS)
• Built data cubes and Key Performance Indicators (KPIs) for analytics using
Microsoft SSAS.
• Responsible for designing and developing reports using SSRS.
• Extensively worked along with the business users and provided report analysis and design.
• Developed Query for generating drill down reports in SSRS.
Prepared AD HOC reports through report builders.
Environment: SQLSERVER 2005, SSIS, SSRS, SSAS, UNIX, and Windows 2000.

BI Developer (MedSoft 02/2010-02/2011)
The goal of this project was to build a reporting warehouse that provides integrated views of information that can be verified with respect to historical as well as present data and show trends regarding sales data, customers, supplier profiles, products, and their relationships.
• Involved in dimensional modeling of the reporting warehouse.
• Interacted with clients in requirements gathering, designing functional and technical specifications for reporting needs.
• Design and implement multi-dimensional OLAP cubes using Microsoft SQL Server Analysis Services (SSAS)
• Create and optimize mappings (ETL) for large scale data warehouse by indexing, create both database table partitions and cube partitions to optimize big tables' performance, create summary tables for additive facts/metrics properly to improve query performance greatly.
Environment: Oracle 10g, SQL, PL/SQL, Erwin, TOAD, SQL Plus.

BI DEVELOPER (GL Trade 02/2009-01/2010)
• Environment: SQL Server 2008, SQL Server Management Studio, SSIS, Erwin, Windows
• Languages: T-SQL, PL/SQL, UML, C#


• Designed, implemented and maintained database schema
• Utilized entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, functions, views, defaults and complex SQL statements
• Tuned existing SSIS packages and T-SQL code for performance
• Optimized inserts into the data warehouse including bulk loading, set-based operations, and data conversions
• Developed T-SQL scripts & commands to extract and load external data
• Scrupulously installed and configured databases, administered policies and standards


ADDITIONAL SKILLS
* Computer
* Programming/scripting languages: C, C++, Java (J2EE), JSP, HTML, JavaScript, AJAX, PHP, XHTML, PL/SQL, SQL, shell Unix, CSS.
* IDEs: Eclipse, MyEclipse, JDeveloper Dreamweaver and Visual Studio.
* Server platforms: Apache Tomcat and WampServer.
* Modeling and design tools: Merise (1&2), PowerAMC (11&9) and UML.
* Database: Installation, configuration, administration and management of database: Oracle, Acess, MySQL, SQL Server 2008R2/2012.
* Data Analyst: SQL SERVER Tools: SSMS, BIDS (SSIS, SSRS, SSAS)
* Operating Systems: Windows, Unix, Linux.
* Office tools: Microsoft Word, Excel, PowerPoint, Adobe products and SharePoint.
* Ability to install and troubleshoot computer hardware, software and peripherals
* Non-Technical
* Fluent in French and English (both written and spoken)
* Ability to work in groups and under pressure
* Communication, organization and problem-solving skills

UNIVERSITY STUDIES