PROFESSIONAL SUMMARY

• 5+ years of experience as SQL and Business intelligence Developer engaged in requirement analysis, SQL database design, development and implementation.
• Experienced MS SQL Server 2008/2012/2014/2016, SSIS (SQL Server Integration Service) 2012, SSRS (SQL Server Reporting Service).
• Efficiently upgrade and migration from SQL Server 2005/2008 to SQL Server 2012 or to the newest version.
• Proficient in T-SQL for developing complex joins, stored procedures, triggers, user defined functions and windows functions.
• Experienced in Data Warehousing methodologies: star schema and snowflakes and dimensional modeling and reporting tools.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS for executives, Business analyst and clients.
• Developed Query for generating drill down/drill through reports in SSRS 2008.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services.
• Used ETL tools to implement the Slowly Changing Dimensional maintain Historical Data in the Data warehouse.
• Scheduled reports or job daily, weekly, monthly for the executives, Business analyst and clients with Query Optimization to increase the performance of the report.
• Quickly identify problem, learn new technology and deliver results in a timely manner.
• Work with minimum supervision to achieve individual and team goals.

TECHNICAL SKILLS

Programming Languages:                                                                 C#.NET, VB.NET, Java, C++, Python, Android
Web Design Programming:                                                               HTML, PHP, XML, CSS, Java Script, ASP.NET
Development Environment:                                                               SSMS, Visual Studio, NetBeans, Dev C++
Operating Systems:                                                                             Windows, Linux, MacOS
Database:                                                                                            MS SQL/Access, MySQL, Oracle
MS BI tools:                                                                                        SSIS, SSAS, SSRS, Power BI, excel
Modeling tools:                                                                                    Microsoft Visio, Visual paradigm for UML
Project Management Tools:                                                                  TFS, MS Project, JIRA

WORK HISTORY

ETL/BI DEVELOPER                                                               03/2017– CURRENT

APEX SYSTEMS                                                                        SEATTLE, WA

RESPONSIBILITIES:
• Created ETL packages to validate, extract, transform and load data to a destination using SQL Server Integration Services (SSIS) 2012.
• Applied various data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Look up, and Fuzzy look up and so on.
• Experienced in deploying the SSIS packages to SQL Server and the file system and creating SQL server agent jobs for scheduling
• Scheduled and monitored all job activities by SQL Server 2014/2016 to meet business requirements activities.
• Interacted with third party vendors and identified different homogenous and heterogeneous sources extracted and integrated data and loaded to the staging area and database.
• Modified SSIS packages to facilitate the business requirement by transform and loading of files in a database
• Created mappings using look-up and dynamic look-up with different caches

SQL DEVELOPER                                                               04/2015 –02/2017

CLEARSTORY DATA                                                               SEATTLE, WA

RESPONSIBILITIES:
• Created complex joins, indexes, views, stored procedures, functions, triggers and other T-SQL scripts for applications.
• Designed, developed, modified and enhanced the database structures and database objects using agile methodologies.
• Developed conceptual, logical and physical data models, design data access strategies and write SQL code to access and manipulate data.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity.
• Conducted a performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
• Expertly performed requirement gathering and analysis, analyzed and documented the system specifications, business requirements.
• Designed database and database objects using MS SQL Server 2014/2016.
• Involved with business users and business analyst for requirements gathering and business analysis.

SQL REPORT WRITER                                                          05/2012 –12/2015

ETHIO TELECOM                                                      ADDIS ABABA, ETHIOPIA

RESPONSIBILITIES:
• Created complex T-SQL query, views and store procedure to group data, filter and parameterize reports based on business requirement.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created a report models and subscription schedule for managers and clients.
• Created data maps to organize critical information required for reports, clarified user requirements, and migrated reports
• Organized and distributed extract data files required by external and internal clients
• Developed Query for generating drill down/drill through reports in SSRS 2008 based on MS SQL Server 2008/2008R2.

EDUCATION

BSC IN COMPUTER SCIENCE                                               JULY 2012

AMBO UNIVERSITY                                                                 AMBO, ETHIOPIA