Lakhdar Dehbi

Phone: 571-***-****

Email: acdebg@r.postjobfree.com

5+ years of development and administration experience on Data Design

•

and Development on SQL server in OLTP and OLAP environment.

Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows

•

Performance Monitor for monitoring and tuning MS SQL Server

performance

Experience in Extracting, Transforming and Loading ( ETL) tools using DTS

•

packages, Bulk Insert, BCP, Log Shipping and Replication between

different homogeneous/heterogeneous system and SQL Server.

• Experience in planning and implementing Microsoft SQL Server Security and

database permissions, together with Client/Server support and Web based

applications.

Expert in creating indexed Views, complex Stored Procedures,

•

appropriate functions, and effective Triggers to facilitate efficient data

manipulation and data consistency.

Highly skilled in implementation of various Replication Models (Snapshot,

•

Merge and Transactional) along with Backup/Restore of a database.

Actively engaged in software Analysis, Design, Development, Testing,

•

Implementation and production of SDLC.

In-depth knowledge of Transact-SQL (DDL, DML,DCL).

•

Expertise in generating reports using Crystal Reports, SQL Server

•

Reporting Services, XML, Access and Excel Spreadsheets.

Strong analytical and problem-solving credentials coupled with excellent

•

written, verbal and inter-personnel communication skills.

Flexible and versatile to adapt to any new environment with proficiency on

•

managing multiple projects.

A well-organized, goal-oriented, highly motivated team player with an ability

•

to perform individually.

TECHNICAL SKILLS

RDBMS: SQL Server 2012/2008R2/2008/2005/2000, Oracle 9i, MS

Access 2000/XP

Database Tools: SQL Server Management Studio, Enterprise Manager,

SQL Profiler, Query Analyzer, Index Analyzer, Security

Manager, Service Manager, Team Foundation Server,

Visual safe Source, SQL Mail Agent, Replication Tool,

Backup Server, Management Studio

Reporting Tools: SSRS, Crystal Reports 10/9.0, MS Reporting Services,

MS Excel

Data Modeling Tools: MS Visio, Erwin

Programming T-SQL, PL/SQL, Visual Basic, C, C++, Java, Python,

languages: XML, DHTML, ASP.Net, ActiveX, VBA

Operating Systems: Windows Me/XP/NT/2000, UNIX, Linux, Mac OS X

ETL Tool: SSIS,DataStage,DTS (Data Transformation Services),

BCP

PROFESSIONAL EXPERIENCE

Merrill Lynch, Princeton, NJ June 2013 – Present

SQL Server DBA

E-portfolio

Institutional investors are an important segment of the target market. The

purpose of this project was to enhance their customer experience and provide

them with an access on account activity and investments. E-portfolio was a web-

based decision support system. Daily feeds from merrin trading were loaded to

Eport for all the transactions executed during the day. Eport History kept track of

historical data for last thirty business days, end of month and end of year.

Responsibilities:

Actively involved as part of a team for gathering and analyzing the needs of

End User Requirement and System Specification.

Participated in design of the application that covers process flow of the

business logic.

Created interface stored procedures to load data for scheduled jobs, and

created stored procedures to generate business reports.

Created Triggers to enforce data and referential integrity.

Backup and restore database using third party tool.

Enhanced the current system by adding tables and relationships required to

support the system.

Created SSIS Packages to transform data from source database to the related

tables in E-portfolio.

Performance tuning of SQL queries and stored procedures using SQL Profiler

and Index Tuning Wizard.

Analyzed database for capacity planning, and was responsible for providing

production support.

Analyzed the requirements and enhancements that can be done to migrate

from SQL Server 2008 to 2012.

The loading process was orchestrated to ensure durability and consistency.

Environment:

Autosys Job Scheduling System, Windows XP, MS Visio, T-SQL, MS Office

Suite, SQL Server 2012/2008R2/2008/2005,SQL Server Management Studio,

SQL Query Analyzer, SQL Server Agent, SQL Service Manager, SSIS, SSRS,

Crystal Reports 10, Visual Source Safe.

Quanta Insurance, New York, NY February 2012 – May 2013

SQL Server Developer/DBA

Policy Issuing System

The main aspect of PIS was to track premium information for policy issuing. In

addition to that, also took part in agency management system. Another major

part of this project was to feed policy data to claim management system. For

reporting purpose, involvement of data transformation to people soft was a plus.

Responsibilities:

Determined the SQL Server installation. Installed SQL Server management

tools using SQL Server Setup Program.

Created interface stored procedure to load feeds from Chaucer, PWIB, and

ANG into PIS.

Actively involved in tracking of policy issuing and premium information.

Modeling and architecture of the SQL Server 2008/2008R2 database.

Successfully fed policy data to claim management system.

Merged data into a single server environment to have better control,

consistency and security of data.

Created reporting stored procedures to roll up transactions level data up to

policy level data.

Responsible for developing Agency Management System that facilitate users

to evaluate broker performance.

Developed ER diagrams and mapped the data into objects to modify the

database and created alerts for error reporting.

Worked on Client/Server tools. Used SQL Server Enterprise Manager to

administer SQL Server.

Created views and stored procedures and optimized them as required by front

end people, as well as scheduled jobs for backup.

Created Triggers to enforce data and referential integrity.

Used DTS packages to transform data from various data sources using OLE

DB connection.

Environment:

Windows XP, MS Visio, T-SQL, MS Office Suite, SQL Server 2008/2005/2000,

SQL Query Analyzer, SQL Server Agent, SQL Service Manager, Crystal

Reports 10.

SETS ALGERIA September 2009 - January 2011

SQL Server Developer/DBA

General Ledger Application System (GLAS)

The development of business logic and reporting extraction were the main roles

of this project. Being part of a group, managed changes related to design and

implementation issues, occasionally requested by change management system,

operations and technology management. Transformed data from cash

management system and trial balance into general ledger database and also

interacted with corporate reporting system for reporting purposes.

Responsibilities:

Gathered user requirements from users and managers to better understand

the business logic of the company and create database that fits their needs.

Participated in creation of logical database and developed physical database

architecture for servers using normalization up to third normal form.

Migrated data from text files and Excel spreadsheets to SQL Server databases

using DTS.

De-normalized some tables that used lots of computations and joins, for

corporate reporting services.

Successfully applied schema change scripts to existing objects to synchronize

with changing business rules.

Created interface stored procedure to load data from Cash Management

System and Trial Balance into GLAS.

Created views and stored procedures and optimized them as required by front-

end developers for easier implementation.

Implemented jobs to automate backup strategy as per disaster recovery

model.

Developed database objects such as DTS Packages, Procedures, Functions,

Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise

Manager.

Developed partitioned views and tables for the purpose of security and fast

upload.

Environment:

IBM PC Compatibles O/s, Windows Server 2008/2003/2000, SQL Server

2008/2005/2000, ODBC, Visual Basic 6.0, DTS, MS Visio, Crystal Reports

9.0.

SONELGAZ ALGERIA 2008 – August 2009

SQL Server Developer

Customer Management System

As a part of development team, helped and developed application that is used to

service All American, a subsidiary of City group card members. The primary

object of the project was to look through the company’s entire customer database

for each region and then to separate those regions based on the customer

details and their business profiles. Furthermore, the work was involved to extract

any old data from their legacy applications into SQL server.

Responsibilities:

Actively involved as part of a team for gathering and analyzing the needs of

End User Requirement and Online System Specification.

Configuring, tuning, and optimizing SQL Server 2008/2005/2000.

Modeling and architecture of the SQL Server 2005/2000 database.

Successfully applied schema change scripts to existing objects to synchronize

with changing business rules.

Developed stored procedures, triggers, views and adding/changing tables for

data load and transformation, and data extraction.

Performance testing on existed stored procedures, indexes, and triggers.

Created DTS Packages for data import, export, scrubbing and scheduled jobs

for backups.

Worked on DTS import and export wizard.

Created views and stored procedures and optimized them as required by front-

end developers for easier implementation.

Job Monitoring and making sure all jobs run successfully every night.

Created Database Maintenance Planner for the Performance of SQL Server,

which covers Database Integrity Checks, Update Database Statistics and

Re-indexing.

Generated daily, weekly, monthly, quarterly and yearly Reports using Crystal

Reports.

Determined the SQL Server Installation. Installed SQL Server Management

tools using SQL Server Setup Program.

Participated in testing and debugging of the system.

Environment:

Windows Server 2008/2003/2000, SQL Server 2005/2000, Crystal Reports 9,

Oracle 8i, MS Office Access 2000

EDUCATION & CERTIFICATIONS

Bachelor of Science in Computer Science, Farhat Abbas, SETIF, ALGERIA

Microsoft Certified Professional for SQL Server 2005 Design and Implementation (70-

229)

Contact this candidate