Summary * Over 3 years of experience with Data Modeling, DataBase design and programming with sql server 2008 R2/2012/2014 * Having experience in creating database object such as Tables, views, Stored procedure, UDFS, Trigger and index to facilitate efficient data manipulation * Having experience in creating cluster index and non clustered index on the table for performance tuning * Having experience in writing T-SQL queries with Pivot, Unpivot, Partionned by, Lag and Lead * Having 2 years' experience in developing datawarehouse for Retail and healthcare * Experienced in SQL Server Analysis Services (SSAS) OLAP Cubes, Snow Flakes Schema, Star Schema, Regular/Reference/Many-to-Many Relationships, Hierarchies key, Calculations, Dynamic Partitions and Aggregations Experienced with Cube Analysis using MS-Excel with excel PowerPivot. ( Experienced in Data Extraction, Migrations, Transformation and Loading (ETL) * Expertise in Developing and Extending MS SQL Server Analysis Services 2008 R2/2012 (SSAS) Cubes, Dimensions, Measures, Deploying & Processing SSAS objects, writing MDX and DAX queries. * Hands on experience and outstanding knowledge in building and deploying the reports by using SQL Server Reporting Services-SSRS 2012 * 1 year experience with Power BI * Experiences in various types of tasks control flow and data flow in SSIS. ( * Good Experience in Implementing Checkpoint, Transactions in SSIS. * Good experience in deploy ssis with Job and scheduling the job * Good experience with SSIS catalog. ASP.NET4.0 * As part of API web development * scheduling scripts Development * Creating reports in SSRS * Management modules Development (Orders, invoices, delivery items, ) * développementsdes management modules (Promotions, Loyalty, sales objectives, Stock, ) * Geo -localization with Google API * Reporting with SSRS (Chart, Gauge, tabular) * Creating Web API Rest fashion Json (Get, Post, Put, Delete) * data layer development with EF6 first code * Developing layer presentation with Kendo UI / jQuery * Deploying the application to IIS7 / Windows Server 2008 R2 * Migration with ssis of excell-> SQL server Technical environment : EF6, Web API, Sqlserver201, MVC Json, Sage, SSIS, SSRS, Google APIs SQLSERVER2008 T-SQL JScript AJAX JQuery.IIS7 Entity-Framewok From 25/03/10

Highlights:

• Microsoft SQL Server
• SQL Server Reporting Services
• SQL Server Analysis Services
• Adobe Dimensions
• Stored Procedures
• Data Warehouse
• ETL
• Extract Transform Load Tools
• HTTPs
• Microsoft Excel
• c#
• sql
• software