Ashu (Ashenafi Haylegebriel)

ac3zl9@r.postjobfree.com Cell # 469-***-****

Professional Summary

* + years of experience in role of a Microsoft Business Intelligence Developer with Experience in MS SQL Server 2016, 2012, 2008 and 2005 with Business Intelligence in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Highly proficient in the use of T-SQL, creating Relational Database models and maintaining Data integrity.

Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.

Created SSIS package configurations using XML configuration, scripts and documents SQL Server, parent package variable, registry entry and environment variable.

Deployed SQL Server 2005/2008/2008 R2 SSIS packages using msdb, file system storage methods.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server 2005/2008/2008 R2 Reporting Services.

Generated Sub-Reports, Drill down reports, Drill through reports, Parameterized reports, Toggle reports, Chart reports, Gauge reports, Map reports(by territory, by country, by state) using SSRS.

Have a very good knowledge in designing OLAP(Online Analytical Processing) and OLTP(Online Transaction Processing).

Expertise in complete Software development life cycle (SDLC) also has strong understanding of Agile methodologies/Scrum.

Quick learner who strives for new technical knowledge.

Education/Certifications

UNITY UNIVERSITY: BA Major in Marketing and Financial Management, Minor in Accounting.

Microsoft Certification on: SQL Server 2012/2014

Technical Competencies

Operating Systems

Windows 98/2000/2003/XP/NT/Vista/7, Windows Server 2003 /2008/2010

Database Tools

SQL Server Management Studio(SSMS), SQL Profiler, Query Analyzer, DTS Designer, Index Tuning Wizard, Oracle 8i/9i

GUI Tools

SQL Server Business Intelligence Development Studio, ER Studio, Visual Studio 2005/2008/2010/2012

Languages

T-SQL, XML, HTML

OLAP Tools

SSIS, SSRS

Source Control Tools

Visual Source Safe 2005, Team Foundation Server 2010

COMMUNICATION SKILLS

OR follow this link Press CTRL + Click to watch my Video http://www.kandidate.co/profile/28340/89116608/17604

Professional Experience

American Airlines Inc. (AA) Dallas, Texas (Client) June 2016-Current

SQL Server SSIS/SSRS ETL Developer

Responsibilities

Gathering the requirements, Creation/review of Business, Functional requirement Documents for business systems, experience in database design process with Microsoft SQL Server.

Defining and implementing the required business transformation rules and logic (ETL development) and Perform unit testing at various levels of the ETL.

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

Created database objects like tables, views, indexes, triggers and stored procedures.

Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.

Extensively used SSRS to create reports as per user requirements.

Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues.

Created Database Triggers to implement business requirements

Optimized SQL queries for improved Performance and availability

Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.

Extracted data from XML to SQL Server.

Worked in Development, Testing and Production environment.

Environment: SQL Server 2005/2008 R2/2012, Visual Studio 2008/2010, Visio, ER Studio.

Nuts and Jerky.com, Dallas, Texas (Client) May 2013-June 2016

SQL SSIS/SSRS ETL Developer

Responsibilities

Performed some DBA Tasks like checking the jobs that fail and troubleshooting the issues in Development, Testing and Production environment

Maintain and optimize the existing databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS).

Used different type of transformations for cleaning the data from different sources into company format.

Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages

Configured packages with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.

Maintained data integrity by Creating constraints.

Developed, deployed and monitored SSIS Packages.

Supported efficient data storage and manipulation by creating complex stored procedures and functions.

Created and modified indexes to optimize query performance.

Environment: SQL Server 2005/2008/2008 R2, Visual studio 2008, Oracle 9i, Visio, ER Studio.

Contact this candidate