SUMMARY:

• Over 7 years of experience in designing, analyzing, adapting and developing database solutions and applications, and Business Intelligence solutions and applications using SQL Server 2012/2008R2/2008/2005, SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS) along with 1 year plus experience in analyzing, designing and developing ASP.net web applications and scripts using C# and .NET Framework 3.5/4.0/4.5/4.5.1
• Experienced in creating BI DSS from the conception until the deployment of business reports utilizing SQL Server 2012/2008R2/2008/2005 and SQL Server BIDS and Data Tools.
• Proficient in generating analytic reports with SQL Server Reporting Services in SQL Server 2012/2008R2/2008/2005 and SQL Server BIDS and Data Tools.
• Proficient in designing and deploying analytical services with SSAS implementing data hierarchies, data mining models, partitions, star schema including dimension, fact tables, measures, etc.
• Proficient in designing and deploying OLAP cubes for business analysis utilizing SQL Server 2012/2008R2/2008/2005 and SQL Server BIDS and Data Tools.
• Excellent experience designing Data Warehouses solutions for further Business Intelligence Analysis of relevant measures.
• Experienced in ETL processes. Extensive experience in extracting, cleaning/transforming and loading data from Transactional Databases and other data sources into Data Warehouses for further Business Intelligence Analysis using SSIS.
• Proficient in designing and executing TSQL Query Statements implementing many types of Tables, Joins, Constraints, Stored Procedures, Triggers and Exception Handling using SQL Server management studio.
• Expert in designing databases solutions that meet projects requirements.
• Experienced in migrating data from heterogeneous and homogeneous data sources into SQL Server 2012/2008R2/2008/2005 using SSIS.
• Excellent knowledge about SharePoint and Microsoft Power BI Tools such as Power Pivot, Power Map, Dashboards and Scorecards.
• Troubleshooting, checkpoints, etc., in every level of development, testing and production environment.
• Experienced in creating web solutions and scripts with Microsoft ASP.Net Framework 3.5/4.0/4.5/4.5.1 and C#.
• Experienced in creating script tasks and script components utilizing C# scripts in SSIS and SSRS.
• Extensive experience in understanding client’s requirements and translating them into enterprise solutions.
• Excellent communication and interpersonal skills, including analytical, problem - solving, leadership and computer skills.

TECHNICAL SKILLS

• PHP
• HTML
• CSS
• IQuery
• JavaScript
• C, C++, C#
• Java
• VB 6.0
• Visual Basic
• .Net Framework 3/3.5/4/4.5
• Windows (XP
• Linux (Ubuntu 5.04-11.04)
• PostgreSQL 7.0
• MySQL
• SQL Server 2012/2008R2/2008/2005
• SAS Enterprise Miner
• Tableau 6/8.2
• Crystal Reports
• Visual Studio 2008/2010/2012/2013
• Visio 2012
• Microsoft Office Suite 2010/2013/365
• Programming
• Software Development
• Web Development
• Web Applications
• Software Engineering
• Management of Information Systems
• Project Management
• Project Planning
• IT Governance
• Business Analysis
• Analytics
• Business Intelligence
• Data Mining
• ETL
• Data Warehousing
• System Analysis and Design.

PROFESSIONAL EXPERIENCE

Confidential, NY

MS SQL Server/Business Intelligence Analyst

Responsibilities:

• Integrated the data from different data sources using components like send mail task and scripts tasks written in C# with SSIS designer for excel file manipulation in order to validate the data source.
• Created new packages, configured them using configuration manager, made changes object by object and property by property, saved it, and then ran it.
• Worked with two distinct engines, the run-time engine that controls the flow of execution and set options for logging, event handlers, and variables. The data flow engine to extract, transform, and load the data.
• Designed, implemented and maintained data marts by implementing Kimball’s architecture using SQL Server 2012 that would store integrated data from different sources.
• Designed and developed analytical cubes for analysis purposes using SSAS 2012.
• Implemented calculated fields and KPI’s for analysis purposes in SSAS 2012.
• Installed and configured a reporting server using SSRS 2012 and IIS 8.0 for report viewer and manager.
• Designed and developed different specific and ad-hoc reports using report builder and delivered them via email.
• Developed different TSQL queries using different constraints, joins and bulk inserts to organize data and bring useful information to the client.
• Created a dashboard containing different reports and scorecards with filtering capabilities that were later deployed in a SharePoint server and presented for further decision-making.
• Creation of data visualization in Excel using Power BI tools such as Power Pivot and Power View.
• Collaborated in the implementation of a data mining model using SSAS to identify specific patterns and aid in different analysis for decision making.
• Environment: SQL Server 2012, SQL Server Data Tools 2012 (SSIS, SSAS, SSRS), Microsoft SharePoint Server 2010, Windows 8, Windows Server 2012, Microsoft Office 365, .Net Framework 4.0, C#, IIS 8.0

Confidential .MA

Business Intelligence Analyst/Developer

Responsibilities:

• Actively participated in the development cycle of Business Intelligence solutions including detailed design, configuration, deployments and execution of integration packages, analytical cubes and reports.
• Developed, maintained, and enhanced guidelines for Business Intelligence solutions.
• Participated in design and analysis sessions with other BI teams to provide flawless design.
• Gathered requirements, designed, developed, tested, maintained, and supported complicated data extraction, transformation and loading according to the business needs using SSIS 2008 R2.
• Developed analytical cubes with KPI’s and calculations using SSAS 2008 R2 and later exported the data to excel using a pivot table for better exploration of the data.
• Developed scorecards and reports using the SSRS 2008 R2 that were later deployed into a Reporting Server and later visualized in a customized web portal developed in .NET with C# using Web Services and SOAP to access the reports and scorecards.
• Worked with the DBA group to analyze and optimize slow running packages, queries, scorecards or reports.
• Created and monitored SQL Server Agent Jobs to schedule weekly backups of logs to reduce database size and secure the logging data.
• Developed reports models with report builder to support ad-hoc requests from users and management outside of scheduled work using SSRS 2008 R2.
• Developed, maintained and continually enhanced an executive dashboard using Tableau. Environment: SQL Server 2008 R2, SQL Server BIDS 2008 R2, SharePoint Server 2010, Windows Server 2008 R2, Windows 7, Visual Studio 2010, .Net Framework 4.0, Tableau 6.

Business Intelligence Developer

Responsibilities:

• Developed simple and complex packages in SQL BIDS 2008 (SSIS) with the purpose of extracting, transforming and loading data for further analysis and reporting.
• Implemented different transformations components in SQL BIDS 2008 (SSIS) in order to clean and organize the data before loading it into a new destination for analysis or reporting purposes.
• Implemented error handling on SQL BIDS 2008 (SSIS) by using transactions and break points in a package.
• Designed and implemented a logical and physical data mart with different measures and dimensions.
• Created analytical cubes with SQL BIDS 2008 (SSAS) for analysis purposes.
• Created different types of reports like drill down reports, tabular reports, bar chart reports, etc. using SQL BIDS 2008 (SSRS).
• Deployed the reports created in SQL BIDS 2008 (SSRS) in a Reporting Server and implemented report subscription and security using the Report Manager.
• Created simple and complex queries, views, User Defined Functions (UDF), Common Table Expressions (CTE), stored procedures and triggers that were implemented in different steps of the BI process.
• Performed queries optimization using SQL Profiler, Database Tuning Advisor and by creating different indexes on tables.
• Created a SQL Server Agent Job that triggers a SSIS Package that updates the data warehouse in a scheduled timing.
• Environment: SQL Server 2008, SQL Server BIDS 2008, Windows Server 2008, Windows 7

Business Intelligence Developer

Responsibilities:

• Developed an ETL package using SSIS 2005 in order to extract transactional data from the store database and load it into a data warehouse for analysis purposes.
• Implemented different transformations components using SSIS 2005 in order to clean bad data and prepare it before loading it into a data warehouse.
• Implemented an analytical cube in SSAS 2005 for analysis purposes of the company’s sales operations.
• Developed and deployed different reports such as drill down, drill through, parameterized, etc. and implementing different visualizations like bar charts, pie charts, tabular presentation and others, using SSRS 2005.
• Deployed the reports into a reporting server with SSRS 2005 and implemented security and subscription using the Report Manager.
• Developed simple and complex TSQL Queries, Views, Triggers, and Stored Procedures that were implemented in different phases of the project.
• Performed queries optimization using SQL Profiler, Database Tuning Advisor and by creating different indexes on tables such as Clustered, Non-clustered and Full Text Indexes.
• Enhanced the company’s e-commerce website by implementing and configuring Google Analytics tracking code.
• Implemented credit card and PayPal payment options on the company’s e-commerce website using Authorize.net and PayPal web service.
• Environment: Windows Server 2005, SQL Server 2005, SQL Server BIDS 2005, Windows Vista, Visual Studio 2008.

Software Developer

Confidential

Responsibilities:

• Maintained and enhanced the company’s e-commerce website using PHP and MySQL database.
• Enhanced the e-commerce website by updating the payment system, database tables, and improving the security of the site by implementing security questions, IP detection and credit cards validation.
• Developed an internal Supplier Website that allowed the review of suppliers account information, print theirtax withholdings,review and change their information, and contact theaccounting department using PHP, MySQL and FPDF library.
• Improved the Employment Website by expanding the form of required data from the candidates, created user access control by implementing access control rules, designed a PDF form using FPDF for the hiring process, and developed a page that showed the statistics related to job applications using the Google chart api.
• Installed and customized the Mantis Bug Tracker System (GPL) and conducted Training Sessions for around 90 employees.
• Participated in the migration of data and the replication solution from PostgreSQL Database Management System into SQL Server 2005.
• Developed an Assets and Consumables Management System using C# and Visual Studio 2005 that allowed the company to manage the inventory of assets and consumables, their movements between branches, know the status of the inventory with alerts, and print a variety of reports in Crystal reports 9 or Excel.
• Developed simple and complex TSQL Queries, Views, Indexes, Triggers, and Stored Procedures that were implemented in different phases of the project.