Data Power

Kumelachew Goda Visa: Green Card

Number: 425-***-**** Email adjzuj@r.postjobfree.com

PROFESSIONAL SUMMARY

Highly motivated SQL Server/BI Developer with 2+ Years of IT Experience in Database and Business Intelligence Technologies with expertise in SQL Server Development and Reporting using SQL Server 2014/2012/2008, SSRS and SSIS.

Experience in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types and functions, Cursors and Indexes using T-SQL.

Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key, Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.

Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS)) and MS SQL Server Reporting Services (SSRS).

Experienced in Agile SDLC for Design, Development and Staging phases of the projects

Involved in Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling, and Snow-Flake Modeling.

Expert in designing (development) and deployment of SSIS package from various sources like Excel, Microsoft SQL server, flat file, and XML.

Power Bi Expert with 2+ years of experience in creating complex reports and dashboards using advanced DAX. Extensively using Power Bi suit for Extracting data from different sources and created attractive visualizations.

Expertise in Power Bi Desktop and power Bi Service.

Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.

Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).

Working knowledge of Relational Database Management System (RDMS), Data Warehousing, OLTP, OLAP, Data Migration and Data Analysis using SQL Server Business Intelligence solutions (SSIS, SSAS, SSRS).

Expertise in generating reports on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services, MS Excel and Power BI

Configure database replication from on premises to Azure SQL, data sync and migration of database to and from Premise/Azure DB.

Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.

Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, Excel, CSV, MS access and flat files.

Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Experience with logical and physical data modeling, Fact and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.

Very good Self-motivated, smart working Professional with good organizational leadership.

Ability to work in-groups as well as independently with minimal supervision.

Databases

MySQL, MS SQL Server (2008.2008R,2012,2014,2016), Oracle (10g,11g,12c), MS Access, IBM DB2, Mongo DB

Languages

SQL, T-SQL, PL/SQL, R, SAS, Python, UML, Java, HTML, CSS

Tools

SQL Server Management Studio (SSMS), MS Visual Studio (2013/2015/2017), Eclipse, SQL Server Profiler, Power BI (Desktop, Server, Mobile), MS Excel, MS Word, MS Project, MS Visio 2016, SQL Plus, Tableau (Desktop, Server).

ETL Tools

Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) Import Export Data, Alteryx

Methodologies

Waterfall, Agile, Business Analysis, Object-Oriented (Use Case) Analysis, Database Design and Normalization, Data Modeling.

Big Data Technologies

Hadoop, Pig, Hive, Oozie, Flume, Impala, Avro, Kafka, Spark

Operating Systems

Windows Server 2003R2/2008R2/2012, Windows (XP,7,10), Unix.

Multimedia Resources and Training Institute (MMRTI), WA Seattle Mar 2020 – Present

MSBI/Power BI Developer

WAAS International PLC, Addis Ababa Ethiopia Jan2018 – Aug 2019

MSBI/Power BI Developer

Contact this candidate