Sql Server Data

D awit S.Gedibe 720-***-****

.***********@*****.***. 11001 E. Ohio PL. 80012 Aurora, Co.

P rofile

* ***** ** ************ ********** with knowledge in Data Modeling, T-SQL development, Data

Warehouse, ETL and develop reports using MS Business In telligence Tools like (SSIS, SSAS and

SSRS) in SQL Server 2008/2008 R2/2012.

Education

University Degree

Helsinki Meteroplolia Univ. of Science (Espoo, Bachelor’s in Information Systems

F inland)

Addis Ababa University (Addis Ababa, Electrical Engineering Advanced Diploma

E thiopia)

Work Experience

D i recTV E nglewood, CO 80112-5003 April 1, 2014 -current

R oles:

Updating and maintain the data base consistency

Handling the exception and correction.

Refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and

System stored procedures along with usage of tools like SQL Profiler and Database Tuning

A dvisor.

• Performed data management tasks including automation of data loads, performance tuning,

TSQL programming and data manipulation.

A lere Healthcare Solutions San Diego, CA – 92121 August 2013 – Jan 2014

SQL/ETL Developer

R oles:

Created stored procedures to perform Index maintenance, data profiling, metadata search,

c ritical staging procedures for loading data marts and reporting database.

Refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and

System stored procedures along with usage of tools like SQL Profiler and Database Tuning

A dvisor.

Monitored and Tuned SQL Server performance and, created baselines using log-file viewer

activity monitoring system, DBCC utili ties (database consistency checks), SQL profiler and

Database Tuning Advisor (DTA ).

Implemented the Master Child Package Model for easier maintenance, optimizing sources as well

executing packages in parallel and for better performance

Implemented error & failure handling in SSIS packages using event handlers, row redirects,

check points and used loggings for monitoring the execution.

Deployed SSIS packages to the production server using XML and SQL server configurations.

Created alerts and mail confirmation of all packages in SQL server Agent to get event messages

such as success/failure of package, procedure.

Delivered on demand reports in different rendering formats using Standard and Data Driven

Subscriptions.

Improved the performance of reports by optimizing data sets, making use of report caching and

snapshots along with taking into consideration networking aspects.

Tools Used: M S SQL Server 2008 R2/2012, BIDS/SSDT, SSIS, SSRS, DB2, Oracle, Erwin, Visio,

W indows 2008 Server, SP 2010.

I F P&C I nsurance Espoo, Finland - 02200 Jan 2012 – May 2013

SSIS Developer

Responsibilities:

• Created, modified and redesigned OLTP and DW Data Models and Forward Engineered Data

Model of Staging Database to SQL Server using Erwin.

• Analyzed different heterogeneous sources like DB2, Oracle and SQL Server 2005 for ETL

s trategy that needs to be implemented with the help of SSIS packages.

• Designed the ETL processes using SSIS to load data from Oracle, SQL Server, Flat Files and

E xcel files to target SQL Server staging database.

• Performed data t ransformations using complex stored procedures and queries and embedded

t hem into SSIS Packages.

• Implemented various types of Transformations in Packages including Slowly Changing

D imension, Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.

• Implemented the Master – Child Package environment to minimize overhead of Package

Schedule Maintenance

• Monitored all the packages that were scheduled. Involved in debugging the Packages by

u tilizing SSIS features like breakpoints, event-handlers, Data-Viewers and custom loggings.

• Implemented t ransactions in SSIS by appropriately setting Transaction Option property to

Supported, Not-Supported and required based on the type of strategy being implemented.

• Maintained existing SSIS Packages and worked on the performance tuning of the queries,

E TL Procedures and processes

• Created various types of Reports like linked report, parameterized report and sub-report from

SQL Server Reporting Services

• Used SQL Server Agent to schedule jobs, maintenance tasks, and BCP and ETL packages.

Environment: M icrosoft SQL Server 2005/2008, T-SQL, BIDS, SSIS, SSAS, SSRS, Profiler, Erwin,

V isio

Nordea Espoo, Finland - 02230 Aug 2011 – Dec 2012

SQL BI/ SSRS Reports Developer

• Created and optimized database objects like Procedures, Functions, T riggers, Indexes and

i ndex Views using T-SQL to create complex scripts and batches.

• Performed data management tasks including automation of data loads, performance tuning,

TSQL programming and data manipulation.

• Fil tered data based on user requirements using Derived column, Fuzzy Lookups, Conditional

split and also archived the processed results using FTP tasks and Script Tasks.

• Extracted, t ransformed, and loaded (ETL) data from the various application teams whose

data would be mainly in the Oracle database.

• Managed very large reports that return a large volume of records and optimized their

performance using techniques like cascading parameters and fil ters.

• Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and

data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports

i ncluding current status.

• Created Sub-Reports, Drilldown-Reports, Summary reports, parameterized reports, cascaded

reports in SSRS by linking aggregate data to support summarized view as well as detailed

v iew.

• Used different layout such as Mat r ix, tabular, chart, tablix to display data in a grid format,

w ith layout possibili ties ranging from simple tables to advanced mat rices.

•

Environment: MS SQL Server 2005/ 2008, SSIS, SQL Server Management Studio

Tools Used : SQL Server 2008R2/2008, SSIS, SSAS, SSRS, Erwin, Windows Server 2008, Visio

H elsinki Metropolia UAS Espoo, Finland - 02610 Oct 2010- Aug 2011

A pplication Developer – I nternship

• Actively involved in JAD Session, gathering business requirements from Business users.

• Used Android platform and phone Gap frame work for an application which is for playing

specific music and sound for elderly people for nursery home.

• Managed to build the application from the front end t ill the back end using SQL query,

H T M L5,CCS3, JavaScript and JSON.

• Used Android frame work and Java built in libraries to adopt the same application for

A ndroid devices.

• Also involved with a web development for EU funded project,smart Campus project by

p roviding graphical representation of energy consumptions of selected pilot Areas using d3

JavaScript library.

• Managed to build the web application to the mobile using the PhoneGap and JQuery API .

• Involved in Application test as a tester and end user for maintenance.

T echnical P roficiencies

Operating Systems : Windows XP,Vista,2007,2012,Windows Server 2000/2008,Linux

Database Packages : SQL Server 2005/2008/R2/201

BI Tools : BIDS/SSDT, SSMS/SSIS/SSAS/SSRS 2005/2008/2008R2

Database Tools : Erwin, MS Visio

Languages : C, Java,C#, javascript,PHP5

Application Development tools : Eclipse,Netbeans

Contact this candidate