Lakhdar Dehbi
Phone: 571-***-****
Email: ************@*****.***
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)