Abraham Emishaw

Gaithersburg, Maryland 240-***-**** adbulq@r.postjobfree.com

PROFESSIONAL SUMMARY

* ***** ** ********** ** Database Design, Development & Administration of MS SQL Server 2005/2008/2012/2014.

Experience in all phases of the Software Development Life Cycle (SDLC).

Proficient in relational database modeling(Conceptual, Logical and Physical Modeling) and normalization

Excellent knowledge in Relational database concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types,

Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers

Designed Data Mapping documents, DDL scripts, Data Dictionary and Meta data of the models

Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity,

SQL joins and Query Writing.

Experienced in SSIS\SSRS\SSAS, building static, dynamic and interactive reports using BIDS and Report Builder.

Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.

Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.

Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures

Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.

Experienced in designing Star, Snow flake Schemas and OLAP cubes.

Experienced in migrating data from one SQL Server version to another.

Highly experienced in database server performance tuning and optimization of Complex SQL queries.

Experienced in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring.

Team player who has capability to work with business users, project managers, team leads and architects

Flexible and versatile to adapt to any new environment and work on any project.

Ability to use Geographic Information Systems and applications including but not limited to MapInfo, Google Earth, Microsoft MapPoint and Arc-View

TOOLS AND TECHNOLOGY

RDBMS: SQL Server 2005/ 2008/2008R2/ 2012/2014 and SQL Azure

Database/ETL Tools: SSIS, SSAS, SSRS

Reporting: SQL Server Reporting Services (SSRS)

Languages: VB.NET, C#, C++, T-SQL, E-SQL

MS-Office: Microsoft Office Tools

Operating Systems: Windows Server 2000, 2003, 2005, 2008, 2008R2, 2012

Tools: Lite Speed for SQL Server, Visio, ArcGIS, Power BI

PROFESSIONAL EXPERIENCE

Client: Edge It Solution 01/2018 – Present

Role: MS SQL/BI Developer

Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

Developed SSIS packages using Lookup Transformations, Merge Joins, Union all Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks

Exported and imported data from Flat file, CSV file, Excel to/from SQL Server Database using SSIS.

Utilized power BI to design multiple reports of dashboards, maps, KPIs, waterfalls and charts

Monitored & managed the table spaces and data files growth

Analyzed Tables & Schemas, collecting system statistics and rebuilding indexes

Added report mapping functionality to the reports using MS SQL Reporting Services

Created Drill through, Drill down, Matrix and Sub reports

Worked on formatting SSRS reports using the Global variables and expressions

Developed Stored Procedures, functions and database triggers and maintained integrity and implement complex business logic.

Created complex joins to retrieve data from multiple tables for business analysis.

Monitored performance and optimizing queries for maximum efficiency.

Client: Intelligence Effect 02/2015 – 11/2017

Role: MS SQL/ BI Developer

Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS

Analyzing already existing reports and increasing the performance on these reports.

Worked on Migrating the Reports from SQL Server 2012 environment to 2014 environment.

Developing reports using SQL Server Reporting Services.

Developed Drill down, Drill through, Matrix reports, Parameterized reports, cascading parameterized Reports using SSRS.

Worked on SQL Profiler, Tuning Advisor in SQL 2012 to increase the performance of the reports.

Worked with shared Data source and shared data sets for multiple reports.

Deployed the reports from Team Foundation Server to Development Report Manager.

Worked with report subscriptions in SSRS 2012 to send the weekly run automated reports to end users

Developed SSIS Control Flow items and SSIS Data Flow items in SQL Server 2012 Environment.

Develop SSIS package for implement Slowly Changing Dimension, Fact Load and Dimension Load with Incremental Lookup.

Worked with SSIS Package migrations from SQL Server 2012 environment to SQL Server 2012 Environment.

Worked in Creating Team projects for Reporting and Integration using TFS.

Environment: MSSQL Server 2012 Developer Edition, Visual Studio 2012, SSMS, SSIS, SSRS, Team Foundation Server.

Designed and created accurate geo-databases and models

Provided technical support for the creation and visualization of data layers and map products using Arc-GIS software products

Company: Faffa Food share company

Addis Ababa, Ethiopian 10/2013 - 08/2014

Role:SQL Developer

Created, published standard and ad-hoc reports using report designer and report builder.

Designed data source views (DSV) and report models for business users using SSRS.

Deployed, managed and migrated data sources, report models, reports in Report manager and/or Share point/MOSS sites

Designed complicated reports with drill-down, drill-through, cascading parameters, etc.

Designed and Implemented row-level access control for users to access detail reports

Developed various T- SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.

Developed Complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.

Involved in migrating data from MS SQL server 2008 database to MS SQL server 2008 database.

Wrote MDX queries and created OLAP report sourcing from SSAS cube

Developed assemblies to extend SSRS, SSIS, SSAS features using CLR

Developed web application for reporting portal using .NET, ASP.NET, C#, VSS

Built dashboards from OLAP cubes/views using Performance Point Server/ProClarity

Created and updates cubes (measures, dimensions, hierarchies, relationships), defined calculation (calculated members, named sets), KPIs, perspectives using SSAS and MDX

Developed SSIS package for source to staging and/or staging to DW data mappings

Environment: MS- SQL Server 2005/2008-R2, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SSRS, SSIS, C#, VB.Net.

Education

Bachelors

Training

Microsoft SQL Server 2005, 2008, and 2008R2 /2012

Post-Graduate Certificate – Spatial Business Intelligence (GIS) American College of Commerce & Technology Falls-Church, VA May 2017

Contact this candidate