Sql Server Developer

Aziz Nouri

TEL:773-***-****

SQL Server/BI Developer

PROFESSIONAL SUMMARY:

• 3 years of experience in Database programming, System Analysis, Design, Development & Support of MS SQL

Server 2000/2005/2008/2012.

• Experience in SQL Server tools DTS, SSIS and SSRS.

• Proficient in requirement analysis, system design, and Object Oriented Design (UML).

• Experience in logical and physical data modeling using ER Studio and Microsoft Visio.

• Extensive experience in the development of Reports using SQL Server 2005/2008/2012 Reporting Services

(SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix

Reports, drilldown reports and score cards in multiple formats using multi – dimensional objects.

• Experience in monitoring SQL Server Performance, troubleshooting using SQL Profiler, Index Tuning Wizard

(DTA), Windows Performance Monitor and Maintenance plan.

• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from

various sources, Bulk Insert, BCP and DTS/SSIS Packages.

• Deployment of SSRS Reports on SharePoint Portal and integrating Reports, Analysis Reports with SharePoint

2007(MOSS).

• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.

• Hands on migrating DTS Packages to SSIS packages.

• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan,

Performance Monitor and DBCC Commands.

• Having good knowledge on backup and recovery.

• Experience working in a clustered OLTP environment with Very Large Databases (VLDB) and having version

control (Visual SourceSafe and Team Foundation Server).

• Experience with all phases of software development life cycle (SDLC) and project methodologies.

• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star

and Snowflake Schema used in dimensional and multi-dimensional modeling.

AREAS OF EXPERTISE

RDBMS SQL Server 2000/2005/2008R2/2012, Oracle 9i/10g/11i, MS Access, SQL Plus, SQL

*Loader, Excel

SQL Server Tools SQL Server Management Studio, DTS, SSIS, SSAS, SSRS, Profiler, Enterprise

Manager, BIDS, Database Tuning Advisor, SQL CMD, Query Analyzer, Service

Broker

Web Technologies HTML, JavaScript, PHP, XML, XHTML

Version Control Tools MS Visual Source Safe(VSS), Microsoft team foundation server (TFS)

Operating Systems Windows XP/2003/2000/NT/98/95, MS DOS

Other Tools Oracle Toad, MS Office, Share point server 2007(MOSS), MS Toad, MS Report

Builder, MS SQL Server Migration Assistant for Oracle

PROFESSIONL EXPERIENCE

AQL TECHNOLOGIES INC April 2014 - To Date

Role: SQL Server BI developer TRAINING

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and

relationships between the data using SSMS (ER-DIAGRAM) and Microsoft Visio 2010.

• Developed drill down and drill through reports from multidiensional objects like star schema and snow flake

schema using SSRS.

• Involved in Performance tuning of ETL transformations, data validations and stored procedures.

• Designed and developed various types of reports using SSRS and rendered them in front end applications like

Excel and .net.

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in

Development and Production environment for SQL Server 2012.

• Designed various types of reports and deployed them into production server using Microsoft office share

point services (MOSS).

• Developed and maintained different SSIS packages to integrate data from different servers to main

production server.

• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV

using SQL Server 2012 Reporting Services (SSRS) and MS Report builder.

Environment: SQL Server 2005/2008/2012, SSIS, SSRS, Excel, Share point (MOSS), Oracle, TOAD for SQL server,

MS Report Builder.

Client: JAAMOUM COMPTABILITE ANALYTIQUE MAY 2004 – JAN 2007

Role: SQL Developer/Oracle developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design,

creating E-R diagrams using Visio 2010.

• Designed logical and physical database structure to facilitate analysis of data.

• Created Stored Procedures to transform the Data and worked extensively in SQL for various needs of the

transformations while loading the data.

• Created stored procedures for the business logic using T-SQL and performed coding of several database

triggers and stored procedures and maintained integrity constraints.

• Setting up database backup and recovery procedures for quality and development servers.

• Implemented the database for production and marketing purpose.

• Created tables, indexes and constraints.

• Created Triggers, Stored procedures for implementing the business logic.

• Administered of all SQL server database objects, logins, users and permissions in each registered server.

• Managed Database files, transaction log and estimated space requirements.

• Managed ongoing activities like importing and exporting, backup and recovery.

• Configured and monitored database application.

• Designed and implemented several complex reports and administration modules.

• Designed crystal reports for business reporting purpose.

• Defined stored procedures for module integrity and application.

• Wrote database triggers in T-SQL to check the referential integrity of the database

•

Environment: MS SQL Server 2005/2008, Windows Server 2003, MS access, Excel, Oracle, Toad for oracle, Toad

for sql server.

EDUCATION: Computer science.

LANGUAGE: French, Spanish.

Contact this candidate