Metasebia Tefera

**** ******** *****, ******, ** 75035 Cell: 469-***-**** ac0x1a@r.postjobfree.com

Professional Summary

Enthusiastic IT professional with 5+ years experience in Database Design Development, ETL Implementation and

support of OLAP/OLTP/Data warehouse systems using Microsoft SQL Server 2016/2014/2012/2008 across

various SDLC environments which include transforming unstructured data from various data sources using SSIS

Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column for validating data.

Worked with Business analyst, Data architect and business users to understand business processes, document

project requirements and translate them into functional and non-functional specifications for BI reports and

applications

Expertise in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views,

Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.

Proficient in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Drill through and

Drill down reports, parameterized reports, Linked reports, Sub reports, Chart reports and distributed reports in

multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio

(BIDS)

Strong analytical and problem solving and communication skills, ability to work to deadlines, result oriented,

flexible and adaptable

Technical Skills

DBMS SQL Server 2016,2014,2012 and 2008

Languages SQL, C#

Operating Systems Windows server

2003/XP/NT6.0/98/Vista,7,8,10

Development Methodology Agile/SCRUM

Reporting Tools SQL server Reporting Services (SSRS)

2016/2014/2012/2008

ETL Tools SQL server Integration Services (SSIS)

2016/2014/2012/2008

Data Modeling Microsoft Visual Studio 2008,2010, SSAS

Office Tools MS Word, PowerPoint, Excel, Visio, One note,

MS Operations Manager, Share point

Job Scheduler SQL Server Agent

Education

MA: Psychology (Special Needs) Addis Ababa University - Addis Ababa, Ethiopia

BA: Psychology Addis Ababa University - Addis Ababa, Ethiopia

Certifications

SQL Server 2012/2014, Business Intelligence Development and Maintenance

Work History

SQL Server BI/SSIS/SSRS ETL Developer, 02/2014 to Current

Terlato Wine Group (Client)

Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB

providers from the existing diversified data sources.

Involved in data migration between homogenous and heterogeneous systems using various tools (Data Transformation

Services (DTS), SSIS, BCP, and Bulk Insert).

Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data,

aggregate, multicasting, conditional split and derived column.

Scheduled jobs for executing the stored SSIS package which were developed to update the database on Daily basis

using SQL Server Agent

Implemented Error Handling by using the Script component to generate custom error messages and redirected the

error rows to an error file

Analyzed Queries and boost the performance necessary for statistical reporting after monitoring, tuning, and

Optimizing Indexes by using Performance Monitor and SQL Profiler

Worked with users and business analysts to design and develop tabular, matrix, gauges, Charts, drill down

interactive reports

Configured the report viewing security for various users at various levels using Report Manager

Created automatically running stored procedures for day-end / Month-end operation using SQL Server agent.

Designed data structure with multiple facts and dimension tables to hold the source data to be used for building new

reports with SSRS.

Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star

schema.

Environment: SQL Server 2012/2008, Windows 2003, SQL Server Management Studio, T-SQL, DTS, SSIS, Visual

Source Safe, ASP.net.

SQL Server BI/SSIS/SSRS ETL Developer, 01/2012 to 11/2013

Aberdeen Asset Management Inc., (Client)

Responsibilities

Worked with Business analyst, Data architect and business users to understand business processes, document project

requirements and translate them into functional and non-functional specifications for BI reports and applications

Formulated and documented the physical ETL process design based on business requirements and system

specifications, including source to target mappings, transformations, lookups, aggregations and expressions.

Designed packages using data conversion, sorting, scripting, lookup, merge joins, and derived columns with multiple

data flow tasks.

Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.

Experience in Error Handling using TRY / CATCH blocks and performance tuning using counters in Integration

Services

Involved in monitoring and troubleshooting complex packages by using data viewers, grids, debugging and

maintenance of ETL packages and its optimization using SQL server best practices.

Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures

and Scripts.

Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and

materialized views for remote instances.

Created dashboards for Trading Division, Portfolio Manager and Control Division to provide the latest Holdings.

Assembled and converted user requirements from multiple clients into our standard reporting solution and customized

specific client requests when necessary.

Responsible for creating all reports such as matrix report, drill down report, drill through report, sub report and chart

report etc.

Involved in creating different Parameterized reports like standard parameter reports, cascading parameter reports..

Involved in creating dynamic reports using SSRS for the monthly connections and details of all locations, generated

report models using report builder for the end users.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining

Models and Deploying and Processing SSAS objects

Environment: SQL Server 2012/2008(SSMS), SQL Server Business Intelligent Development Studio 2008(BIDS), .NET

Scripting, Team Foundation Server 2005, MS Excel 2007.

Contact this candidate