Sql Server Data

Kidanu B. Shume

Address: Charlotte, NC

Cell: (**1) 218 - 9668

*******@*****.***

PROFESSIONAL SUMMARY

9+ years of extensive work experience in Software Development (BI Developer, SQL Server Production - Developer, SDET) including Requirement Analysis, Design, Implementation and Testing multitier applications based on Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) principles

Experienced in SQL Server database design & development and data modeling (conceptual, logical and physical) and strong knowledge of Data Warehousing methodologies and concepts, including Dimensional Modeling (Ralph Kimball and Bill Inmon Methodologies), star and snowflakes schemas, ETL processes.

4+ years of strong experience in developing BI solutions using MS SQL Server 2005/2008/2008R2/2012/ 2014, SSIS (SQL Server Integration Service) and SSRS (SQL Server Reporting Service) Visual Studio .Net(C#) and Excel.

Power BI experience in designing Interactive Reports and Data Visualization using Power BI Desktop, Power Query, Power Pivot, Power View and Power Map.

Working knowledge on SSAS Cube, OLAP and Tableau.

5+ years of experience in writing T_SQL, Stored Procedures and user defined functions.

2+ years of Testing windows and web application, Web Sites.

Excellent analytical, co-ordination, interaction skills and an outstanding team player with an aptitude to learn. Self-starter highly motivated and I have a very good problem solving and communication skill. Have worked in industries like Utility, Health and Environmental across a wide variety of systems and companies from small to large size.

TECHNICAL SKILLS

Technology

Description

BI Tools

SQL Server 2014, 2012/ 2008R2/ 2008/ 2005, SSIS (ETL), SSRS, Tableau,

SSDT, BIDS, Visual Studio, Power BI Desktop, PowerPivot, Power-View, Power-Query, Power-Map, Hudson

Databases

SQL Server (2005, 2008, 2008R2, 2012, 2014), ORACLE, MS Access

Database Programming

T-SQL, PL/SQL

Data Access Technology

OLE DB, ODBC, ADO.NET

Programming Languages

C#, VB.Net

Platforms

Windows NT/XP/7/8/10, Windows Server 2000/2003/2008, SharePoint 2010, Visual Studio .Net 2010/12/13/15

Source Controls

Team Foundation Server (TFS), VSO

Client-side Technology

HTML, CSS, JavaScript

Web Debugging and Tracing Tools

Firebug, Fiddler, IE Developer tool, Chrome Developer tool

Issue Tracking tool

Jira

Data Modeler

Visio

MS-Office

Word, Excel, Access, Power point, Outlook, InfoPath

EDUCATION

Post Graduate Diploma, Computer Science, HiLCoE School of Computer Science and Technology, Addis Ababa, Ethiopia, August 31, 2009.

B.Sc., Applied Mathematics, Addis Ababa University, Addis Ababa, Ethiopia, July 26, 2003.

Certificate of Achievement/Completion of trainings on:

SQL SERVER DEVELOPMENT

SQL SERVER REPORTING SERVICE (SSRS)

SQL SERVER INTEGRATION SERVICE (SSIS)

SQL SERVER ANALYSIS SERVICE (SSAS)

Tableau

COSMOS

PROFESSIONAL EXPERIENCE

BI / SQL DEVELOPER at ALLY FINANCIAL, Charlotte NC: OCT 2016 – Now

Responsibilities:

Designed SSIS packages for moving data from flat file source to SQL Server destination across multiple stages.

Populate data to Dimension and Fact tables in the data warehouse from the source tables using Stored Procedures.

Created SQL Scripts for creating new database objects.

Modify existing tables by adding additional columns according to design requirements

Created reusable variables and expressions for the packages.

Created batch files and package configuration files for executing the packages.

Created jobs for running the batch and configuration files using the job scheduler tool Hudson

BI / SQL DEVELOPER at MICROSOFT, Redmond WA: JUN 2015 – JUN 2016

Partners Incentive Engineering Team

Responsibilities:

Involved in Data flow Analysis and Data validation across multiple servers and databases.

Analyzing different data and writing SQL script that helps viewing the analysis.

Writing SQL scripts for data and schema validation.

Designed Data Flow Diagram using Visio.

Analyzing complex SSIS Packages and Stored Procedures to identify source to target mapping and Data Analysis.

Creating and Enterprise data source for Reporting Solutions

Developed visualizable and Interactive Reports using Power Query, Power Pivot, Power View, Power Map and Pivot Table with charts in Excel 2013.

Created SSIS packages for extracting data from different data sources using ETL techniques.

Accept requirements from users and develop reports and Dashboard using Power BI, SSRS.

Applied SCD (Slowly Changing Dimensions) while designing ETL Packages using SSIS.

Used VSTFS for Sprint Planning and to create and manage tasks in agile environment.

Client Management and Report Team

Responsibilities:

Created Stored Procedures, Functions, Tables, Views and SQL Scripts using SQL Server 2014.

Performing source to destination data conversion, data mapping, designing, reviewing, implementing and optimizing ETL processes using SSIS.

Applied SCD (Slowly Changing Dimensions) while designing ETL Packages using SSIS

Used SQL Server Agent to schedule jobs and to verify successful execution of scheduled tasks that load data from source to destination.

Deployed SSIS Packages to SQL Server Integration Service Catalog.

Accept requirements from users and develop reports and Dashboard using Power BI, SSRS.

Worked on Data Analysis using Data Profiling Task in SSIS.

Defined and Designed Data Warehouse, Dimension and Fact tables using Star and Snowflake schemas applying the Kimball approach.

Build and Deployed SSRS reports on Reporting Server and configured reporting server.

Created data model using PowerPivot importing data from SQL Server database.

Developed visualizable and Interactive Reports using Power Query, Power Pivot, Power View, Power Map and Pivot Table with charts in Excel 2013.

Used Visual Studio 2013 and VSTF for code sharing and version control.

Used VSTFS for Sprint Planning and to create and manage tasks in agile environment.

Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Implementing Backups and restoring when necessary

Technical Environment

SQL Server 2014/2012, SSDT 2014, C#, Visual studio 2013/15, Excel 201316, VSTFS, VSO

BI / SQL DEVELOPER at MKUSA, Seattle WA: MAY 2013 – MAY 2015

Responsibilities:

Preparing requirement document for database development and database modification.

Preparing conceptual and logical document based on the requirement analysis.

Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code for reports and analysis and backend requirements in OLTP system using SQL Server 2012.

Inserting and updating data to SQL Server 2012 database.

Worked on Data Analysis using Data Profiling Task in SSIS.

Created SSIS packages for extracting data from different data sources using ETL techniques.

Requirement gathering, assessing business rules, performing source to destination data conversion, data mapping, designing, reviewing, implementing and optimizing ETL processes.

Defined and Designed Dimensional Models, Dimension and Fact tables using Star and Snowflake schemas applying the Kimball approach.

Scheduled SSIS ETL packages using SQL Server Agent jobs.

Build and Deployed SSRS reports on Reporting Server and configured reporting server.

Used Visual Studio 2012 and TFS for code sharing and version control.

Creating, developing, and managing a SQL Server 2012 databases.

Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Created data model using PowerPivot importing data from SQL Server database.

Developed visualizable and Interactive Reports using Power View, Power Map and Pivot Table with charts in Excel 2013.

Implementing Backups and restoring when necessary

Technical Environment

SQL Server 2012/2008R2, SSRS (2012/2008R2), SSIS (2012/2008R2), C#, Visual studio 2012/10, Excel 2013, TFS

BI / SQL DEVELOPER at ETHIOPIAN INTERFAITH FORUM FOR DEVELOPMENT DIALOGUE AND ACTION (EIFDDA), Addis Ababa Ethiopia: JAN 2012 – JAN 2013

Responsibilities:

Write T-SQL scripts for data visualization and analysis.

Develop Query and Stored Procedure using TSQL in OLTP System.

Maintenance and performance tuning of existing stored procedures and SSRS reports.

Design different types of SSRS reports like parameterized and drill-down based on requirements.

Developed business critical financial and executive summary reports using SSRS 2012.

Worked on Deployment and Subscription of Reports.

Designed SSIS packages for data Extraction, Transformation and Load (ETL) from source to destination.

Used Visual Studio 2012 and TFS for code sharing and version control.

Configuration of Report Manager for subscription and caching.

Build, tested and deployed SSRS reports in different environments.

Worked on database development with MS Access applying VBA techniques.

Technical Environment

SQL Server 2008R2/2012, SSRS (2012/2008R2), SSIS (2012/2008R2), C#, Visual studio 2010, TFS, MS-Excel

DATABASE DEVELOPER at ADDIS ABABA WATER AND SEWERAGE AUTHORITY (AAWSA), Addis Ababa Ethiopia: OCT 2009 – DEC 2011

Responsibilities:

Full support of the billing system developed in ORACLE database.

Writing SQL scripts to access the database and updating any data anomalies.

Taking care of the work flow of the billing system.

Build and deployed sample reports to different environment using SSRS.

Extracted available data from different sources and transformed to the required standard and load the data to the destination database using SSIS.

Assisting the clerks working on the system and maintaining the network system

Prepared basic regular reports and inquiries by the different departments and branches of the organization using SSRS.

Maintenance of personal computers in the department and branch offices

Configuration of new and malfunctioning PCs and installations of different soft wares and drivers

Improving the work order and procedures of the system based on the problems arising through time

Technical Environment

Oracle, PL/SQL, SSRS (2008R2), SSIS, C#, Visual studio 2010, Visio, MS-Office

DATABASE DEVELOPER at RODECO CONSULTING GMBH (A GERMAN CONSULTING FIRM), Addis Ababa Ethiopia: AUG 2008 – SEP 2009

Responsibilities:

Review existing situation related to billing and revenue collection in the three project towns and support the international billing expert in the development of an immediate action program to remedy the most acute bottlenecks in the billing cycle

Involved on requirement document preparation and requirement analysis and defining business rules of the database.

Designed and Developed the billing software in collaboration with the team

Prepared conceptual and logical document based on the requirement analysis

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Build and deployed Reports using SSRS using BIDS.

Prepared and supervised the execution of a customer survey in the three project towns

Trained and support utility staffs in the operation and maintenance of the computerized customer database, the billing software, revenue collection processes and basic computer skills

Participated in the preparation of a Billing and Customer Service manual and draft revision of the billing manual to reflect actual procedures developed in each project town

Enhanced data exchange system among the billing, finance and technical departments

Technical Environment

TSQL, SSRS (2008/2008R2), C#, Visual studio 2008/2010, Visio, MS-Office

SOFTWARE TEST ENGINEER at CYBER-SOFT SYSTEM SOLUTION, Addis Ababa ETHIOPIA: MAY 2006 – JUL 2008

Responsibilities:

Translated complex technical requirements and specifications into robust test cases.

Recorded, tracked and regressed defects using standard test tools and methods.

Developed T-SQL script to test table schema, data type, field size and stored Procedures

Created Test plans and Test cases for objects based on the use case prepared for logical data modeling.

Created Test plans and Test cases for underlining objects of stored procedures, user defined functions and measuring Performance using execution plan and SQL Server Profiler.

Developed SQL Query script to prepare test data.

Developed Test Code to test stored procedures using C#.

Writing and running automated test cases using VSTS.

Addressed performance issues associated with stored procedures.

Running performance test and validating data, working on various data using SQL Server.

Doing first hand investigation report on the launch for each build and preparing weekly reports.

Preparing Templates for Workflows and Specification documents for each test scenario.

Filing bugs in TFS for each test fail area.

Technical Environment

C#. NET, Visual Studio 2005, SQL Server 2005, Windows Team Foundation Server, MS-Office

Contact this candidate