PROFESSIONAL SUMMARY
•	Experience in designing and implementing data warehouse and BI solutions with
Microsoft SQL Server Integration Services (SSIS/DTS), Reporting Service (SSRS),
SQL Server Database and Visual Studio .Net.
•	Extensive experience in SQL Server DTS/SSIS packages to import and transform
data between databases and external data sources 
•	Experience to design and develop reports with reporting services. 
•	Experience working with relational database using SQL Server 2000/2005
Business Intelligence Development Studio and SQL Server Management Studio.
•	Extensive exposure in creating database T-SQL scripts, stored procedures,
triggers, views, tables, indexes, and constraints, user defined functions,
security, BCP using SQL SERVER 2000/2005. 
•	Experience in Object Oriented Design and Analysis with Rational Unified
Process (RUP).
•	Extensive experience of C#, ASP.Net and .Net Framework.
•	Experience of Unit, Integration, UI, Black box, White-box ,Performance, Beta,
and Alpha Testing
•	Excellent analytical, co-ordination, interaction skills and an outstanding
team player with an aptitude to learn.
STRONGEST SKILLS

Data Warehouse Tools	MS SQL Server 2000/2005/2008, Data Mining Tools,
Integration Services, Performance Point Server 2007
Business Intelligence Tools	SQL Server 2005 Business Intelligence Development
Studio(SSIS,SSAS,SSRS), Performance Point Server 2007
Programming Languages	C#,ASP.NET, HTML, XML, T-SQL
Reporting Tools	Crystal Reports, SQL Server 2005 Reporting Services
Development Environment	Visual Studio .NET, SQL Server Management Studio, MS
Project 2000/2003
Operating Systems	Win NT 4.0, Windows XP/2000 server, Win 3.x/95/98, Vista
Web 	Web Services, IIS, HTML, XML, XSLT and CSS
	
PROFESSIONAL EXPERIENCE
MUM, Iowa, USA, October 08-Preseent. 
SQL Server 2005 Developer  
Responsibilities:
•	Working with business/functional analysts to determine ETL, report and
analytical requirements
•	Involved in the complete ETL life cycle.
•	creating and manipulating ETL calls through SSIS
•	Developed SQL Server Integration Services (SSIS) packages to transform data
from MS SQL 2000 to 2005
•	Creating stored procedures and complex queries used in SSIS to load/transform
data to the database.  
•	Develop SSIS with logging, event handling and error tracking to support the BI
processes
•	Create package configurations, deploy Integration Services projects and
schedule SSIS packages via jobs.
•	Convert C# application into SSIS package to load/transform data.
•	Extensive use of Stored Procedures. Writing new stored procedures, T-SQL, UDF,
Trigger and modifying existing ones and  tune them such that they perform well
•	Performed a schema change to improve query execution time and performance.
•	Created proper indexes to support queries.
•	Addressed performance issues associated with stored procedures and fix them.
•	Re-written TSQL for the new schema and also make use of the useful indexes.
•	Dropped and recreated the Indexes on tables for performance improvements.
•	Design, Develop and Deploy SQL Server Reports using SSRS.
•	Extract data from the relational database and prepare reports using SQL Server
2005 Reporting Services.
•	Participate in full life cycle of SSRS (Authoring, Managing and Delivery
reports)
•	Working with highly volume databases with partitioned data, performance and
tuning
•	Used VSTS DB pro to resolve performance problems.
•	Provide End Users support, technical guides and host training sessions when
required for all Business Intelligence (SSIS)or reporting applications
Environment: MS SQL Server 2005, MS Visio 2003, SQL Server Reporting Services,
SQL Server Integration Services(SSIS),SQL Server Reporting Service(SSRS),  MS
Excel, MS Outlook, Crystal Reports 9.0, VBScripts, MS Source Safe, TFS(Team
Foundation Server), VSTS DB Pro.
MUM, Iowa, USA December 07 - September 08.
SQL Software Database Engineer 4
Responsibilities:
•	Designs and implements batch processes against OLTP database to load the
data.
•	Redesign of existing SQL batch processes to implement business rules in
volume.
•	Responsible for the creation of ad-hoc and regular SQL queries.
•	Performance tuning of existing database SQL batch processes.
•	Extensive use of Stored Procedures. Writing new stored procedures, T-SQL, UDF,
Trigger and modifying existing ones and  tune them such they perform well
•	Create Automated test case script for all new created objects
•	Involved in creating user interface stored procedures that returns data as an
XML format.
•	Involved extensively in creating and updating technical specification.
•	Worked on creating roles for different data source and wrote scripts that
verifies it.
•	Communicates with external and internal teams.
•	Extensive creation of unit test case script for every stored procedure.
Environment: MS SQL Server 2005(2008 Beta), MS Visio 2003, Microsoft Visual
Studio Team Foundation Server, MS Visual Studio 2008, SQL Server Reporting
Services(SSRS), SQL Server Integration Services (SSIS), Performance Point Server
2007, Crystal Reports 9.0.
Cornerstone Inc, Iowa, USA January 08-Jun 08.
Software Engineer in Test (SDET)
Responsibility:
•	Prepare test cases for each scenario under test plan.
•	Prepare Test Plan based on design document.
•	Enumerate Test Case based on Test Plan and Design document 
•	Executing each test case.
•	Involved in writing T-SQL programming for Quality Assurance Team purpose.
•	Involved in Back end testing (stored procedure, views, sorting data of the
back end.
•	Bug tracking and making bug report 
•	Involved in bug triage and follow up the bug to be fixed.
•	User interface testing for the web application.
•	Performance testing by doing query optimization of stored procedures.
•	Regression testing for the bug fixed and cross check any side effect after the
bug is fixed.
•	Run daily Stress test 
Environment: 
•	C#, ASP.NET, ADO.NET, XML, HTML, XSLT, JavaScript, CSS, Web Service, WSDL, IIS
6.0, RUP Model, Visual Studio.Net 2005, CruiseControl.Net, VSTS, Subversion,
TFS(Team Foundation Server),  SQL Server 2005, Windows Server 2003, Rational
Rose, MS-Project, MS-Visio 2000, Crystal Reports 9.0, NUnit Framework
Addis Ababa University, Ethiopia (April’07- September’07)
Software Developer (DEPortal)
Responsibilities:
•	Involved in user requirement analysis, Use case & Class diagram design. 
•	Implemented the designed components using C#, ASP.NET and SQL Server.
•	Implemented XML Web Services to enable easy interaction between components of
the system.
•	Designed and developed a reporting module using Crystal Report and SQL Server.

•	Unit Test, Integration test and participated on the full system test and
deployment of the application
•	Used CruiseControl.Net and Subversion for integration and version control.
•	Created the technical and compiled full documentation of the project
Environment:
•	C#, ASP.NET, ADO.NET, XML, HTML, XSLT, JavaScript, CSS, Web Service, WSDL, IIS
6.0, RUP Model, Visual Studio.Net 2005, CruiseControl.Net, VSTS, Subversion, SQL
Server 2005, Windows Server 2003, Rational Rose, MS-Project, MS-Visio 2000,
Crystal Reports 9.0, NUnit Framework
Edido Tech, Addis Ababa, Ethiopia (July’04 – March’07)
Software Engineer/Database Developer (Human Resource Management System)
Responsibilities:
•	Designed and Implemented Class, Use Case and Sequence Diagrams using Rational
Rose.
•	Implemented the designed components of the application using C# and SQL
Server
•	Used MSBuild and NAnt for build processes.
•	Designed and developed a reporting module using Crystal Reports. 
•	Involved in performing integration and system tests.
•	Prepared the full documentation of the software.
Environment:
•	C#, ASP.NET, RUP Model, Visual Studio.Net 2005, SQL Server 2000, Windows
Server 2000, Rational Rose, MS-Project, MS-Visio 2000, NAnt, msbuild, Crystal
Reports 9.0, NUnit Framework.
YB Petroleum, Addis Ababa, Ethiopia (January 04-June’04)
Software Engineer (Online Inventory Management System) VB based application
EDUCATION
•	M.Sc. Computer Science, Iowa USA.
•	B.Sc. Information Systems, Addis Ababa, Ethiopia. 
•	Diploma Accounting, Addis Ababa, Ethiopia.
CERTIFICATION
Microsoft Certified Professional (MCP)
•	Microsoft SQL Server 2005 Business Intelligence – Implementation and
Maintenance.
•	Designing a Business Intelligence Infrastructure by using Microsoft SQL Server
2005.
•	Brainbench Certification in C#. (Transcript ID: 15644834).