Sql Server Data
Resume:
Mohamed Ghareb
858-***-**** . *********@*****.***
Summary:
> Over 7+ years of experience in MS SQL Server 2008/2005/2000, Database
Migration
> T-SQL and Microsoft Business Intelligence tools SSIS, ETL, SSRS and
SSAS.
> Experience in Database Normalization, Designing, Creating Indexes,
Developed Queries and T-SQL Scripts in MS SQL 2008/2005.
> Experience in Creating Tables, Views, Complex Stored Procedures,
Triggers to facilitate efficient data manipulation, data integrity and
other T-SQL (DDL, DML) statements for various applications.
> Experience in designing, developing, and delivering business
intelligence solutions using SQL Server Integration Services (SSIS),
Analysis Services (SSAS), and Reporting Services (SSRS).
> Designed SSIS Packages to extract data from various heterogeneous data
sources such as Access database, Excel spreadsheet and flat files into
SQL Server for further Data Analysis and Reporting by using multiple
transformations provided by SSIS.
> Experience in developing SSAS Cubes, Dimensions and data source views
and Deploying and Processing SSAS objects
> Expertise in creating complex SSRS reports against OLTP, OLAP
databases.
> Experience in designing and developing rich user experience reports
using Matrix, Tabular, Drill down/up, and Drill through features in
using Business Intelligence Development Studio (BIDS )
> Experience in using Expressions to customize SSRS reports dynamically.
> Knowledge in working with all Collections in reports like Fields,
Globals, User, Parameters, Variables and Report Items.
> Experience in Report Caching and Subscriptions including Standard and
Data-Driven Subscriptions.
> Experience in extracting and transforming data using SSIS.
> Experience in creating Packages, Jobs and Experience in migration of
Data from Excel, Flat file, Oracle to MS SQL Server
> Developed effective working relationships with client team to
understand support requirements, develop tactical and strategic plans
to implement technology solutions, and effectively manage client
expectation.
Educational Qualifications: Bachelor Degree in IT. Database Administration
Technical Skill:
Operating Systems : Windows 7/Vista/XP, MacOS X
10.4/10.5/10.6
Programming tools : C#, MSSQL 2005/2008, Microsoft Visual
Studio
Bids : SSIS, ETL, SSAS & SSRS
Scripting Languages : VB Script, Bash Shell, AppleScript (Mac)
Database Tools : Oracle 10g, MySQL, Microsoft Access
Web Technologies : XML, HTML, HTML5, CSS, SQL, JavaScript
Servers : Windows server 2008 R2, IIS,
TFS
Professional Experience:
Clear Channel, Los Angeles CA
Jan13-July13
SQL BI Developer
Description: As the leading media company in America, Clear Channel Media
and Entertainment delivers music, news, talk, sports and other content to
diverse audiences across multiple platforms, including: broadcast stations;
online, via iHeartRadio and on its stations' hundreds of websites; HD
digital radio channels; satellite; smartphones; iPads and other tablets; in-
vehicle entertainment and navigation systems; and via live events.
Responsibilities:
> Created database objects like Tables, User Defined Functions,
Triggers, Procedures, Indexes and Views, SQL joins and statements as
per the team's request through team tracks.
> Used different Control Flow Tasks and Data flow Task for Creating SSIS
Packages.
> Involved in supporting database & BI (ETL and Reporting) activities
for various applications and teams across all business units.
> Created SSIS packages for the extracting, transforming and loading the
HR data from Oracle into SQL Server 2008.
> Designing, processing and deploying Cubes from the different fact and
dimension tables based on the business requirement using SSAS.
> Developed reports from these OLAP cubes using SSRS.
> Created Excel based reporting tools using SSAS cube driven data
sources.
> Involved in dimensional modeling by Identifying the fact and dimension
tables based on the user & reporting requirements.
> Created Monthly portfolio reports using SQL Server Reporting Services
(SSRS).
> Created Tabular, Matrix, and Drill down reports for different levels
of risk officers and sectors.
> Involved in Creating Complex Sub Reports, Linked Reports, Charts,
Drill through, and Report Models Drill Down Reports
> Designed large number of reports using table filters, single value
parameters, multi value parameters, dependent parameters and Cascading
Parameters.
> Created SSRS reports using Report Parameters, Drop-Down Parameters,
Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and
Charts.
> Created Report Email Subscription using Data Driven and Time Driven
Report Subscriptions.
> Queried against Heterogeneous Data Sources like SQL Server, Oracle, to
retrieve records for data loads using SSIS 2005/2008.
> Worked with various upstream and downstream systems and customers in
interfacing various systems for data extractions, ETL and Reporting
needs.
> Used different Control Flow Tasks and Data flow Task for Creating SSIS
Packages. Used different types of Transformations for Data Conversion,
Sorting and cleaning the data from different Sources into Company
Format.
Environment: MS SQL Server 2008 R2/2008/2005, SQL Server Integration
Services (SSIS), SQL Server Reporting Services (SSRS), Business
Intelligence Development Studio (BIDS), MS Excel, Windows XP, SQL Server
Management Studio (SSMS)
Care fusion, San Diego, CA
Nov10- Dec12
SQL BI Developer
Description: Care Fusion is a global, medical technology corporation
serving the health care industry. The company specializes in two areas:
reducing medication errors and prevention of health care-associated
infections. The company manufactures health care technologies including
Alaris IV pumps; Pyxis automated dispensing and patient identification
systems, AirLife, AVEA and LTV series of ventilators and respiratory
products, ChloraPrep skin prep products, Med Mined services for infection
surveillance, V. Mueller and Snowden-Pencer surgical instruments and a line
of products that support interventional medicine
Responsibilities:
> Responsible for creating database objects like table, Views, Store
Procedure, Triggers, Functions etc. using T-SQL to provide structure
to store data and to maintain database efficiently
> Designed and maintained complex stored Procedures using Joins and Sub
queries and to retrieve data from multiple tables
> Created SSIS Packages to pull data from Online Database Server to Data-
warehouse Server.
> Designed SQL SSIS Packages to extract data from various data sources
such as Access database, Excel spreadsheet, and flat files into SQL
Server 2005 for further Data Analysis and Reporting by using multiple
transformations provided by SSIS such as Data Conversion, Conditional
Split, Bulk Insert, merge and union all; Scheduled and maintained
nightly and weekly loads of data by creating the corresponding job
tasks.
> Used SSIS to create ETL packages to validate, extract, transform and
load data to data warehouse and data marts.
> Transferred data from flat files, Excel spreadsheets and heterogeneous
data to and from SQL Server using DTS (Data Transformation Services)
and also Bulk Insert for ETL purposes.
> Created SSIS packages for the extracting, transforming and loading the
data from MS Access into SQL Server 2005.
> Created OLAP cubes using SSAS and created reports from the OLAP cubes
using SSRS
> Involved in Generating on-demand and Scheduled Reports for business
analysis or management decision using SQL Server Reporting Services
> Created Excel based reporting tools using power pivot tables and SSAS
cube driven data sources.
> Worked for SSRS for report generation using Excel spreadsheet and also
from MS Access.
> Involved in creating cubes in Business Intelligence Development Studio
(BIDS), deploying them on the server and processing the OLAP cubes to
generate aggregate data for faster querying.
> Generated Monthly and quarterly Reports as bar charts for the
management using different techniques like data filtering, adding
interactivity, deploying reports to report server using SSRS.
Environment: MS SQL Server 2008/2005 SSIS, SSRS, SSAS, Visual Studio
2008, T- SQL, Windows 2003 Server, XML, MS-Access, MS-Excel
Med Impact, San Diego, CA
Nov08-Oct10
Sr. Business Intelligence/SQL Developer
Description: Med Impact Healthcare Systems, Inc., is the nation's largest
full-service Pharmacy Benefit Manager (PBM) that derives revenue by
managing the drug benefit, not from dispensing drugs. We use information
technology and human capital to improve the practice of managed care
pharmacy.
Responsibilities:
> Analyzing the Business Requirement Document (BRD) to design a
conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to
develop a solution.
> Created Stored Procedures for complex business, SQL Agent jobs, and
designed tables by following RDMS rules.
> Administering SQL Server 2008 Management Studio tools including SQL
Profiler and Database Engine Tuning Advisor.
> Working with design, development, implementation and support of ETL
process using SSIS Packages in SQL Server 2008.
> Involved in Incremental Data Load from various sources into SQL Server
Database Engine with ETL Operations.
> Data Migration automation process and mapping from legacy system to
new SQL Server environments.
> Source (Oracle), Excel Spreadsheet to SQL Server 2005.
> Created, scheduled and monitored daily SQL jobs using SSIS packages
> Experience in gathering and developing user requirements into
functional specifications from data sources (ETL) through to report
delivery for BI solutions
Environment: Windows Server 2008, MS SQL Server 2008, T-SQL, SSIS,
SSAS, SSRS.
Double Line Partners, Austin, TX
May07-Oct08
Sr. Business Intelligence/SQL Developer
Description: Double Line Partners is Information Technology Company in
Education Sector. The project requirements were to integrate data from
various sources using SSIS and other ETL tools and develop custom reports
for local, State and Federal Government on student performance meeting
various criteria established by government and private entities for
monitoring purposes.
Responsibilities:
> Analyzing the Business Requirement Document (BRD) to design a
conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to
develop a solution.
> Performance tuning of Stored Procedures and T-SQL Queries.
> Created indexes on selective columns to speed up queries and analyses
in SQL Server Management Studio.
> Used Execution Plan, SQL Server Profiler to trace the slow running
queries and tried to Optimize SQL queries for improved performance and
availability.
> Used SSIS to create ETL packages to validate, extract, transform and
load data to data warehouse databases, data mart databases.
> Used Analysis Services (SSAS) processing task to update with the
current data.
> Involved in dimensional modeling by Identifying the fact and dimension
tables based on the user & reporting requirements.
> Created Monthly portfolio reports using SQL Server Reporting Services
(SSRS).
> Created Tabular, Matrix, and Drill down reports for different levels
of risk officers and sectors.
> Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked
Reports, Charts, Drill through, and Report Models Drill Down Reports
> Designed large number of reports using table filters, single value
parameters, multi value parameters, dependent parameters and Cascading
Parameters.
> Created SSRS reports using Report Parameters, Drop-Down Parameters,
Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and
Charts.
> Created Report Email Subscription using Data Driven and Time Driven
Report Subscriptions.
> Queried against Heterogeneous Data Sources like SQL Server, Oracle, to
retrieve records for data loads using SSIS 2005/2008.
> Worked with various upstream and downstream systems and customers in
interfacing various systems for data extractions, ETL, Analytics and
Reporting needs.
> Used different Control Flow Tasks and Data flow Task for Creating SSIS
Packages. Used different types of Transformations for Data Conversion,
Sorting and cleaning the data from different Sources into Company
Format
Environment: MS SQL Server 2008/2005, SQL Server Integration Services
(SSIS), SQL Server Reporting Services (SSRS), Business Intelligence
Development Studio (BIDS), MS Excel, Windows XP, SQL Server Management
Studio (SSMS).
Home Depot, Atlanta, GA Mar06 -
Apr07
Business Intelligence Developer
Description: The scope of the project was to facilitate in the development
and maintenance of the system and report generation using SSIS and SSRS
respectively. The Project involved supporting various applications by
designing databases, performing data modeling tasks, identifying entities,
attributes, migrating data into applications, managing development and
production databases.
Responsibilities:
> Analyzing the Business Requirement Document (BRD) to design a
conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to
develop a solution.
> Created Stored Procedures for complex business, SQL Agent jobs, and
designed tables by following RDMS rules.
> Administering SQL Server 2008 Management Studio tools including SQL
Profiler and Database Engine Tuning Advisor.
> Working with design, development, implementation and support of ETL
process using SSIS Packages in SQL Server 2008.
> Involved in Incremental Data Load from various sources into SQL Server
Database Engine with ETL Operations.
> Created DDL scripts to create database schema and database objects.
> Created functions, views and triggers.
> Developed source to target specifications.
> Created DTS package and schedule the jobs for batch processing.
> Developed stored procedures to transform the data from enterprise data
warehouse to APT data mart to build dimensions and load data to fact
tables.
> Greatly involved in Performance tuning to optimize SQL queries using
query analyzer.
> Created indexes, constraints and rules on database objects to improve
the data base performance to have best out of it.
> Worked on building the cube using cube wizard in analysis services,
refreshed the cube on regular basis and giving the permission on the
cube to users
> Worked on submitting various reports from database using Excel pivots
and SQL Reporting
Environment: SQL Server Integration Services (SSIS), SQL Server Reporting
Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel,
Windows XP, SQL Server Management Studio (SSMS)
Contact this candidate