SSIS,SSRS,SSAS,SQL Server, Data Base

MOHAMMED ALHADDAD

Phone: 832-***-****

********.**********@*****.***

PROFESSIONAL SUMMARY

A dynamic and effective IT Specialist with 4 years of experience in database analyst, business intelligence developing and business intelligence projects using Microsoft SQL Server 2008/2008R2/2012/2014. Applying the knowledge obtained in the undergraduate program in (Computer Science) and skills absorbed from years of overcoming multiple sources including Microsoft SQL Server, SSAS, SSIS and SSRS. Strong inclination for completing jobs before project deadlines, a critical thinker, quick learner with excellent communication skills and a good performer both in team and independent job environments.

SKILLS

Data Backup and Data Mirroring.

Data Warehouse and Data Models.

Maintenance, Security and Upgrade.

Web platform development.

MS-SQL Server 2008/2008R2/2012.

SQL Server Integration Services (SSIS).

SQL Server Reporting Services (SSRS).

SQL Server Analysis Services (SSAS).

WORK EXPERIENCE

BI Developer

4M Pharmaceuticals Houston, TX Dec 2015– Present

Develop and maintain complex SQL queries from multiple data sources for custom reports.

Use T-SQL to analyze, sort and manipulate data according to defined business rules and procedures.

Designed, installed and created SSRS reports that reside on application for the users to regularly check the performance.

Create dashboards, sub reports, drill down reports, drill through reports, schedule reports and parameterized reports using SSRS.

Work closely with users to develop matrix reports, chart reports and presentations for quality activities.

Extensively designed the packages and data mapping using control flow task, data flow task, sequence container task, execute SQL task, data conversion task, derived column task and script task in SSIS.

Created shared dimension tables, hierarchies, levels and cubes on MS OLAP/ Analysis Server SSAS.

Designed aggregations and pre-calculations in SSAS.

Implemented MS SQL Server security policies and granted object level permissions.

Perform daily checks for failed process, research errors, validate disk space and validate none of the databases are offline or corrupt.

Business Intelligence Developer

Sutherland Global Services Houston, TX JUN 2015 - DEC 2015

Installed and configured MS SQL Server and responsible for configuration, tuning and provide support to all production and development servers.

Developing high level ETL packages, creating, configuring and tuning ETL workflows for overall data transfer using SSIS.

Create and update Data Warehouse and Data Mart using ETL packages

Writing stored procedures, functions and triggers based on the requirement.

Developing queries to retrieve and analyze data from multiple databases.

Analyze tables using database diagrams in SQL server.

Establish referential integrity relationship in multiple tables using primary and foreign keys constraints.

Involved in designing Partitions in Cubes to improve performance using SSAS.

Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements

Designed and implemented a disaster recovery system.

Database Developer

C&J Energy Services Houston, TX May 2013– APR 2015

Monitored the performance of the database and checked on the execution time.

Developed various SQL servers and ensued that they were properly maintained and supported.

Design, develop and maintain data conversion scripts and processes to include various types of ETL (programming, SSIS, batch scripts, etc.).

Developed SSIS packages to perform data loading from various types of sources files (OLE DB, Flat files, CSVs, Excel and XML).

Daily backup and maintenance the data.

Installing and configuring the necessary components to ensure that the database is accessible.

Develop, document and improve custom TSQL stored procedures.

Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.

Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.

Communicate and work well with others, mentoring, guiding and supporting developers with SQL needs.

EDUCATION

Bachelor in Computer Science JUN 2002 – OCT 2006

Certifications

Administering Windows Server 2012 AUG 2015

Contact this candidate