Professional Summary

• 3+ years of experience in IT as a professional specializing in MS SQL Server 2008/2005/2000 development in transactional and data warehousing environments
• Well versed with Software Development Life Cycle (SDLC) methodologies and gathering business requirements.
• Experience of accommodating and facilitating Joint Application Development (JAD) sessions, documenting and analyzing the results as parts of business requirements.
• Hands on Experience using Data Modeling Tools like ERWin and MS Visio.
• Designed Data Models and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Strong experience in coding T-SQL for Stored Procedures, Batches, Views and complex queries.
• Created several database objects such as Tables, Constraints, Indexes, Views, Indexed Views and Cursors.
• Expertise in Performance Tuning and Query Optimization using indexing, defragmentation and proper query design as well as using DBCC utilities.
• Supported the migration of data from heterogeneous sources and different formats to relational data warehouses, staging databases using complex stored procedures and SSIS.
• Proficient in implementing business logic and batch process in backend using Stored Procedures and Functions.
• Performed Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using SSIS, Bulk Insert, BCP).
• Created Master Child Packages and managed Package using Configurations in SSIS.
• Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, fact and dimension tables.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Optimized reports using snapshots and caching reports and delivered them using standard and data driven subscriptions.
• Developed multidimensional optimized cubes using the SQL Server Analysis Services.
• Implemented Cube processing, added KPIs and Calculated Members using SSAS and designed Aggregations and pre-calculated them in SSAS.

Technical Skills

RDBMS/DBMS:

MS-SQL Server 2008, 2005

Database Technologies/Tools:

SSIS, SSAS, SSRS, BIDS

Operating Systems:

Windows XP, Vista, Windows Server 2003/2008, Linux/Unix

Programming Languages:

C/C++, C#, ASP.NET, T-SQL, Java, MATLAB

Design Technologies/Tools:

Erwin, MS Visio

Professional Experience

Confidential, EthiopiaSep 2007 – Aug 2009 
SQL Developer

Confidential has several public information systems that are driven by complex transactional and decision support systems. This project involved enhancing the functionality of these systems by implementing new business logic.

Responsibilities:

• Designed Logical and physical data models for the Data Warehouse using ER-Win.
• Enforced the Business Rules by creating constraints in both the transactional and relational data warehouse databases.
• Developed various complex stored procedures, UDFs, views, Indexed views in support of .Net front end applications.
• Optimized the performance of various SQL scripts, stored procedures by using proper indexing and identifying potential performance blocks using execution plans and SQL profiler.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered, Non-Clustered and covering Indexes for significant performance boost.
• Designed SSIS packages to migrate the data from Oracle OLTP, flat files to SQL Server Staging Area.
• Implemented SSIS features like event handlers, expressions, checkpoints and Parent Child Package Model for easier maintenance and enhanced functionality.
• Developed custom tasks in SSIS using .Net script task.
• Managed Package Configurations in XML Files to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Created bottom up designed cubes using the SQL Server Analysis Services in support of front end applications, reports.
• Designed new Aggregations by creating Hierarchies and then pre calculating the Aggregations using Aggregation Wizard in SSAS.
• Implemented new and complex Calculated Members that will be permanently stored in cubes to boost query performance of reports.
• Created KPIs that will track the response and behavior of customers based on the project Requirement Documents.
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Developed report models for creation of ad hoc reports.
• Implemented conditional formatting for reports as well as used expressions in SSRS for enhancing the functionalities of these reports.
• Created an effective backup plan for both the data warehouse and the cubes data.
• Created documentations of all objects and code created in support of the project as well as keeping records of all change request documents.
• Worked hand to hand with the QA team to quickly and effectively fix all bugs that had been raised by applications and dashboards using the new objects.

Environment 
SQL Server 2000/2005, SSIS, SSAS, SSRS, T-SQL and Windows 2000/2003

Confidential, Ethiopia Jan 2006 – Aug 2007
Database Developer

Responsibilities:

• Involved in creating logical and physical model of the database using ERwin, MS SQL Server 2000/2005.
• Implemented the developed database into SQL Server 2000 and 2005 using T-SQL.
• Facilitated data retrieval and manipulation through implementation of Views, Procedures, Triggers and Cursors.
• Created complex SQL Stored Procedures, Triggers and User Defined Functions to manage incoming data as well as to support existing applications.
• Extensively involved in data gathering for the locations, and insertion into Database using DTS, BCP, and bulk insert.
• Supported advanced efficient data retrieval and manipulation by creating indexed view with triggers.
• Successfully implemented indexes on tables and views for optimum performance tuning.
• Set up scheduled Jobs and alerts for updates and backups.
• Assisted VB Developers in creating Data Entry Forms and embedding Dynamic SQL in Visual Basic.

Environment: 
SQL Server 2000 / 2005, VB, Windows 2000/XP, ER-Win

Education

Master of Science in Computer and Information Sciences

Bachelor of Science in Computer Science and Engineering