Summary
Overview
Work History
Education
Skills
Interests
Timeline
CustomerServiceRepresentative
Mhretab Gebreyowhanis

Mhretab Gebreyowhanis

SQL/BI Developer
Vancouver,BC

Summary

  • Over 6 years of strong experience in the IT industry as a SQL Server Developer/BI Developer.
  • Extensive experience in MS SQL Server 2005/2008/R2/2012, Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
  • Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server 2005/2008/2008/R2/2012, MS Excel and MS Access databases. Design, develop and implement complete life cycle of data warehouses.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modelling, and reporting tools.
  • Highly experienced in designing, developing, and implementing innovative business processes and system solutions.
  • Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008/R2/2012.
  • Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2008/2005.
  • Hands on experience in data/file security, managing user logins, database role, database permission and creating services account.
  • Experience with T-SQL in constructing Triggers, Tables, User Function, Views and writing store procedure.

Overview

18
18
years of professional experience
5
5
years of post-secondary education
4
4
Languages

Work History

SQL/BI Developer

Swiss Water Decaf
Delta, BC, Canada
07.2021 - Current
  • About: Swiss Water Decaffeinated coffee is manufacturing company that decaffeinates coffee to customers like Starbucks and Nestle. More info: www.swisswater.com
  • Created Email Alerts for successful or unsuccessful completion of scheduled Jobs
  • Created reports in Using Crystal report and added it to SAGE X3.Adding fields to Tables and Screens to Sage X3
    Developed software for label printing and Supplier Management tools using C#
    Created Data visualization for different departments using Qlik Sense.
    Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration
    Services (SSIS) 2017 and 2019
    Created objects such as tables, views, indexes, stored procedures, and triggers & maintaining
    Added User Rolls to SQL Database
    Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for employees and business partners
    Environment:
    SQL Server Data Tools for Visual Studio 2017/2019, MS SQL Server 2016, T-SQL, C#, Qlik Sense ,
    Sage X3,Crystal Report, IPOL,MS Access, MS Excel, MS Office Access., Designed,

SQL/BI Developer

Feysel Internet Café
Addis Ababa, Addis Ababa, Ethiopia
10.2017 - 01.2020
  • Provided day-to-day technical support to employees for managing of data base system, hardware, network infrastructure and software and hardware
  • Build Design and Maintained web page
  • Repaired hardware components on networks and software of computers, including firewalls, routers, and other devices
  • Installed and repaired Operating system of 20 computers
  • Educated computer users about basic and specialized applications
  • Developed Data base and infrastructure projects.

SQL/BI Developer

Delta Information Systems
Asmara, Maekel, Eritrea
07.2012 - 10.2017
  • Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server
  • Reporting services (SSRS)
  • Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration
  • Services (SSIS) 2012
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs
  • Used cascaded parameters to generate report from two different Data Sets
  • Involved with Query Optimization to increase performance of Report
  • Page 3 of 2
  • Developed Reports for business end users using Report Builder with updating Statistics
  • Develop reports using complex formulas and to query database to generate different types of Ashco reports using SSRS
  • Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, views and SQL joins and statements for applications
  • Updated functional specification and technical design documents
  • Problem identification, troubleshooting, resolution, and index tuning databases
  • Taking Database full Backup, Transaction log backup & differential backup in daily Routine
  • Environment:
  • SQL Server Data Tools for Visual Studio 2012/2010, Visual Studio 2013, MS SQL Server 2012/2008/2008R2/2005, T-SQL, C#, Tableau, Visual studio 2008/2008R2, MS Access, MS Excel, MS Office
  • Access.

Database Administrator

Eritrean Ministry of Tourism
Asmara, Maekel, Erirea
01.2010 - 10.2017
  • Developed, modified and enhanced database structures and database objects
    Created several Data Transfer Service (DTS) packages in Microsoft SQL Server 2008/,
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS excel, Flat files, CSV files into SQL Server 2008R2/2012
  • Drove operational improvements which resulted in savings and improved profit margins
  • Offered friendly and efficient service to customers, handled challenging situations with ease
  • Prepared variety of different written communications, reports and documents
  • Actively listened to customers, handled concerns quickly and escalated major issues to supervisor
  • Learned new skills and applied to daily tasks to improve efficiency and productivity

Computer Instructor and Database Administrator

Eritrean National Vocational Centre
Asmara, Maekel, Eritrea
09.2008 - 12.2009
  • Installed and maintained operating system for different computers.
  • Attended professional development technology courses to increase knowledge base and learn new information.
  • Set up computers and networking systems and delivered step-by-step instructions on basic use.
  • Planned and implemented curriculum to teach up-to-date technology to 450 students.
  • Invigilated and graded projects, quizzes and examinations
  • Delivered clear, effective feedback to improve quality and efficiency of student-written computer programs
  • Communicated with students to discuss progress and need for tutoring and extra assistance

Education

Some College (No Degree) -

Emily Care University
Vancouver, Canada
02.2021 - 06.2021

Some College (No Degree) - Business IT

Discovery Community College
Surrey, BC
02.2021 - 06.2021

Bachelor of Science - Computer Science

Eritrean Institute Technology
MayNefhi, Eritrea
05.2004 - 09.2008

Skills

Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Sourceundefined

Interests

Sport

Timeline

SQL/BI Developer

Swiss Water Decaf
07.2021 - Current

Some College (No Degree) -

Emily Care University
02.2021 - 06.2021

Some College (No Degree) - Business IT

Discovery Community College
02.2021 - 06.2021

SQL/BI Developer

Feysel Internet Café
10.2017 - 01.2020

SQL/BI Developer

Delta Information Systems
07.2012 - 10.2017

Database Administrator

Eritrean Ministry of Tourism
01.2010 - 10.2017

Computer Instructor and Database Administrator

Eritrean National Vocational Centre
09.2008 - 12.2009

Bachelor of Science - Computer Science

Eritrean Institute Technology
05.2004 - 09.2008

Similar Profiles

CREATE PROFILE
Mhretab GebreyowhanisSQL/BI Developer