Summary
Overview
Work History
Education
Skills
Certification
Languages
Work Availability
Timeline
Generic

Cena Degu

Silver Spring,MD

Summary

  • Certified SQL Server Consultant (Power BI/SSIS/SSRS/SSAS)
  • 6+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server-based applications).
  • Expert Knowledge of T-SQL, Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
  • Experience in SQL Server DTS and SSIS (Integration Service) (2008, 2008R2, 2012, 2014 ,2016 and 2017) package design, constructing, and deployment.
  • Worked Extensively on ETL process using SSIS package.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Provide technical expertise and development support to the project managers and other project stakeholders.
  • Configure Dynamics CRM using the standard toolkit.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
  • Proficiency in creating different types of reports such as Cross tab, Conditional, Drill-down, Sub reports, and formatting them.
  • Experience with ad hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
  • Experience in using variables, expressions and functions and defining Query for generating drilldown reports in SSRS (2014 ,2016, 2017 & 2019).
  • Experience in Dimensional Modeling, Designing of STAR, SNOWFLAKE Schemas.
  • Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Experience in Creation and deployment of cubes on SSAS.
  • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Worked with different versions of SQL - 2008, 2008R2, 2012, 2014 ,2016, 2017 & 2019

Overview

9
9
years of professional experience
1
1
Certification

Work History

SQL Server/Power BI

Concentrix
07.2018 - Current
  • Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD)
  • Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant
  • Worked on writing the T-SQL code for the historical data to pull according to the specification requirement
  • Experience in Data Analysis, understanding trends and patterns in data
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages
  • Converted the old Data flow logic written in .NET C# to SSIS packages
  • Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis
  • Developed custom calculated measures using DAX in Power BI to satisfy business requirements
  • Involved in scorecard and KPI Reporting
  • Migrating SQL Data sets to Data Lake using Hue, Impala
  • Experience in developing the complex Power BI Dashboards
  • Created DAX Queries to generated computed columns in Power BI
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Implemented and successfully tested Log shipping in SQL Server 2008 and SQL Server2012/2016/2017/2019
  • Create reports in Power BI preview portal utilizing the SSAS Tabular
  • Published Power BI Desktop reports created in Report view to the Power BI service
  • Transformed and combined the data using Query Editor in the Power BI
  • Involved in claim adjudication process of facets application
  • Worked on Facets up-gradation project
  • Develop and continue to refine CRM change management standards and tools
  • Provide technical documentation and facilitate training to the administrators and end users of the system
  • Conduct user training and create and maintain knowledge transfer documentation
  • Build CRM forms, screens, and views as well as workflows and reports for the user interface SSRS
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2014 and in adding calculations using Multidimensional Expression MDX & DAX
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for developing Cubes using MDX
  • Developed Star schema using SSAS cubes
  • Created parallel period, filter, ancestors, and cross join MDX queries
  • Developed custom calculated measures using DAX in Power BI to satisfy business requirements
  • Designed Dimensional Modeling using SSAS packages for End-User
  • Created Hierarchies in Dimensional Modeling
  • Provided continued maintenance and development of bug fixes for the existing and new PowerBI Reports
  • Explore data in a variety of ways and across multiple visualizations using Power BI
  • Involved in designing and publishing visually rich and intuitive Power BI dashboards

SQL BI Developer /DBA

Johnson & Johnson
09.2015 - 06.2018
  • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, FTP Server, Excel, DB2 and SQL2012)
  • Actively participate in the Design, Build, Test, and Deploy phases of Siebel UCM implementations for Oracle customers
  • Project-manage Oracle MDM implementations for Oracle customers
  • Developed Custom Logging so user can know when a row is inserted in custom logging table by SSIS package that executes, if SSIS packages extract row from DB2 to CDC DB, or any insert, update or delete rows in dimension or fact tables in DW
  • Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity
  • Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, FTP Task Package Execution task to achieve business needs
  • Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all
  • Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using Web Services Call
  • Wrote and modified various Stored Procedures used in the application using T-SQL
  • Scheduled and maintain packages by daily, weekly, and monthly using SQL Server Agent
  • Responsible for creating partition function and schema for the table partitioning
  • Involved in creating counter logs and trace logs for advanced performance analysis and data logging over a period
  • Created SSIS 2012 Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server
  • Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS
  • Created various jobs using SQL Server Agent
  • Used SQL Server Profiler to trace the slow running queries and the server activity
  • Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements
  • Documented the project work and process
  • ENVIRONMENT: MS SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) Visual Studio 2010/2008, SQL Server Agent, Windows server 2008, Erwin 7.2, Visual Source Safe 2005, C#, SQL Profiler, Microsoft SharePoint 2010

Education

Bachelor’s Degree - Science

University of Maryland Global Campus
Hyattsville, MD
05.2016

Certificate in MCDBA - Administering Microsoft SQL Server 2012/2014 (70-462)

Targeted
Silver Spring, MD
05.2016

Administering a SQL Database Infrastructure - 2016

Targeted
Silver Spring, MD
05.2016

Skills

  • Statistical tools SPSS
  • Hue
  • SAS JMP Applications
  • Visual Basics
  • TOAD Desktop
  • Ms Office Suite
  • Excel - Macros
  • Power Point
  • UMK2
  • Outlook

Certification

Intermediate Sql

IBM certified database associate DB2

Oracle Database SQL Certified Associate

Languages

Amharic
Native or Bilingual
Oromo
Native or Bilingual

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

SQL Server/Power BI

Concentrix
07.2018 - Current

SQL BI Developer /DBA

Johnson & Johnson
09.2015 - 06.2018

Bachelor’s Degree - Science

University of Maryland Global Campus

Certificate in MCDBA - Administering Microsoft SQL Server 2012/2014 (70-462)

Targeted

Administering a SQL Database Infrastructure - 2016

Targeted

Similar Profiles

CREATE PROFILE
Cena Degu