Alemesfin Alemayehu

ad2xy6@r.postjobfree.com

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

PROFESSIONAL SUMMARY:

oMicrosoft Certified Business Intelligence Developer with 5+ 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.

oAnalyzed Queries and boost the performance necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes to trouble shoot slowly running reports.

oDesigned reports using table filters, single value parameters, multi value parameters, Dynamic, dependent parameters and cascading parameters.

oWrote complex stored procedures along with various functions in order to create data sets that generate daily, weekly, and monthly reports along with deploying the reports to report server.

oManaged reports using report manager by creating new users, roles, privileges, shared folders.

oDocumented all database objects, procedures, views, functions & packages for future references along with Creating substantial documentation for reports as a reference for the team.

SSAS:

oDesign and develop data warehouse and data marts using multi-dimensional models - star schema and Snowflake.

oInvolved in creation of fact and dimension tables in the OLAP database along with creating time /date dimension together with its hierarchies.

oUsed ETL to implement the Slowly Changing dimensions, to maintain Historical Data in Data warehouse.

oDeveloping OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS)

oUnderstanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

POWER BI

oImport data from various data sources and create visual reports, dashboards and KPI scorecards using Power BI desktop and then publish them on Power BI Services.

oAble to implement row level security on data and have an understanding of application security layer models in Power BI.

oImplement data analysis Expression (DAX) to create custom calculations for calculated columns and measures.

oUse custom visuals provided by third party services like github to create data visuals.

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/Analysis Tools

SSIS, SSRS,SSAS

Office Tools

MS Word, Excel, Power point, Access

Development Methodology

Agile/SCRUM

COMMUNICATION SKILL:

Public Consulting Group:

Boston, MA

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.

oUse Power BI desktop to create various reports and dash boards and publish them on to Power Bi Services in order to share with various users.

Environment: MS SQL Server 2014/2012, Transact-SQL, SQL Server Integration Services (SSIS), Power BI, SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), MS-Excel.

IPeople:

Dallas, TX

SQL BI Developer Mar.2013-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.

Environment: T-SQL, MS SQL Server 2008, BIDS, Management Studio (SSMS), ETL, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), OLAP, Cubes, Data-warehousing, Windows 2008.

Contact this candidate