Alemesfin Alemayehu

adaifb@r.postjobfree.com

Los Angeles, CA. Tel. 213-***-****

PROFESSIONAL SUMMARY:

oMicrosoft Certified Business Intelligence Developer with 4 years of work experience

oHighly motivated and competent individual with good communication and analytical skills.

o Business Intelligence experience in Development, Client Analysis, Database Design, Reporting, and Presentation using SQL Server 2014/2016, SSIS and SSRS.

oExcellent backend skills 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.

oProficient to build end to end data integration and workflow solutions from input source extraction, apply various transformations and data load.

oDeveloped Custom Reports and different types of Reports, drilldown, drill-through, sub-report, Ad-hoc Reports, and distributed Reports in multiple formats using SSRS in Visual Studio 2017.

SSMS:

oDesign, implement and maintain database schema, entity relationship diagrams, data modeling, tables, stored procedures, constraints, indexes, functions, views, defaults, and complex SQL statements using SQL Server Management Studio (SSMS).

oDeveloped, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.

oOptimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, and created indexes.

oReviewed and fine-tuned stored procedures and optimized the queries.

SSIS:

oFormulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions.

oCreate packages in SSIS with error handling capability, and using different type of data transformations like conditional split, for each loop, multi cast, derived column, merge join etc.

oScheduled and monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio to automate manual tasks.

oWorked with different Control flow tasks in creating SSIS packages.

SSRS:

oAnalyzing existing reports so as to understand the logical and interface design changes to be applied accordingly.

oDefined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures, and views.

oDeveloped various types of intricate reports like drill down, drill through, gauges, pie chart, bar chart, sub-reports.

oCreated SSRS report projects in Visual studio and created, modified, and managed various report models with multiple objects, source fields and expressions.

EDUCATION/CERTIFICATION:

Bachelor of Art (BA) in Library and Information Science

Addis Ababa University, Ethiopia

Microsoft Certified Professional - Querying Microsoft SQL Server 2012/2014

TECHNICAL COMPETENCIES:

Database

SQL Server 2012/14

IDE & BI Tools

SQL Server Management Studio (SSMS) v.17, MS Visual Studio 2017, SQL Server Business Intelligence Development (BIDS)

Programming Languages

T-SQL

ETL /Reporting Tools

SSIS, SSRS

Office Tools

MS Word, Excel, Power point, Access

Development Methodology

Agile/SCRUM

COMMUNICATION SKILL:

Public Consulting Group:

SQL BI Developer Nov. 2017-Present

oInteracted, retrieved, and analyzed business requirements.

oWorked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, and User Defined Functions.

oCreated clustered and non-clustered indexes on tables for new database for faster retrieval of data for the Reports.

oQuery Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Database engine tuning advisor.

oDesigned and developed SSIS packages using various control flow and data flow items to extract, transform, and load the data from various Sources into staging database table using SQL server integration services (SSIS).

oCreated SSIS Packages which perform filtering operations to import data on daily basis from an OLTP system to SQL server Database.

oDeveloped several detail and summary reports, including bar graphs and pie charts, trend analysis reports and sub-reports according to business requirements. Added parameterized report functionality for the users with drill-down and drill-through features.

oInvolved in creating different Parameterized reports like standard parameter and cascading parameter reports.

oDeployed and configured reports in the Report Server.

IPeople:

SQL BI Developer Mar.2015-Nov. 2017

oAnalyzed source data to determine the data model and ETL solution that will meet business requirements.

oDesigned, reviewed, and created primary objects such as Views, Indexes based on logical design models, user requirements and physical constraints.

oWorked in Development, Testing, and Production environment.

oInvolved in performance tuning of the database which includes index maintenance, optimizing SQL statements and monitoring the server.

oScheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

oCreated complex SSIS packages using various transformations and tasks like sequence containers, for loop and for each loop containers, execute SQL package, file system task, conditional split, data conversion, derived column, lookup, merge join, union all along with flat file, CSV, XML, OLE DB and excel sources and destinations.

oDesigned complex packages with error handling and package logging that stores the logging results in SQL table and flat files on error, on warning, on task failed event types.

oWrote SQL queries and stored procedures to generate datasets for reports.

oDeveloped various types of reports including Drill Down,

Drill Through, Gauges, Pie Chart, Bar Chart, and Sub-Reports along with a dashboard using SSRS.

Contact this candidate