Yomiyu E. Malifu

ac7m66@r.postjobfree.com

PROFESSIONAL SUMMARY

4+ years of progressive work experience as an IT professional with a wide range of experience in Software Development, Database Development and BI Development on platforms such as Tableau, Power BI and MS Business Intelligence

In depth knowledge of Software Development Life Cycle (SDLC), database design and Normalizations

Extensive experience developing data visualizations, reporting and dashboard creation with Tableau version10.x and Power BI; publishing those visualizations to Tableau and/or Power BI Servers

Extensive experience maintaining connection between Tableau Desktop and data sources such as Files, RDBMS, web-based APIs, AWS RDS and Azure

Experience in designing and optimizing data connections, Schedule for Background Tasks and Incremental Refresh for periodic dashboard reports on Tableau Server

Experience in developing ETL Solutions using SSIS, report development using SSRS.

Experience in the design and implementation of Normalization and De-Normalization techniques for both OLTP and OLAP systems

Strong knowledge of Relational and Multidimensional Modeling concepts.

Experience in Conceptual, logical, and physical data modeling, data mapping, building Referential Integrity & Constraints, data demoralization with Fact and Dimension tables, data marts, data warehousing with star schema and snowflake schema modeling

Proficient at T-SQL programming (DDL, DML, and DCL) skills creating Stored Procedures, User Defined Functions, indexes, Views, Tables, Constraints, Triggers and writing complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTE.

Excellent communication skill, self-motivated, quick learner, determined to learn new technologies and strong team player with excellent interpersonal skills.

EDUCATION

B.A in Information Systems Management/Business Administration Minor in 2014, Addis Ababa University

Experience Detail

Tableau developer (06/17/2016 – Present)

Marriot Hotels

Bethesda, MD

Interacting with business users to gather and understand requirements.

Analyzing and documenting the required data and information

Developing Interactive Dashboards using Tableau Desktop to present it to applicable internal stakeholders

Creating relationships between different data source using data blend and connecting tables/sheets from a single connection using join

Creating automated scripts for tableau workbook refresh on In-memory connection

Leveraging SQL Queries to handle large volume of data and analyze it

Scheduling data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the change of data accurately

Creating PowerPoint presentations for Business Analytics & Insights for different markets

Applying different types of objects like Sets, Groups, Parameters, Filter, Advanced Calculated Fields, Sorting and Filtering for developing visualizations

Developing several Visualizations using Scatter plots, Gantts, symbol maps, Histograms, Dual-axes, Heat maps, Text Tables and Highlight Tables graphs

Test dashboards to ensure it matches the business requirements.

Business Intelligence Developer (06/27/2015 - 03/01/2016)

MIDROC Technology Group

Addis Ababa, Ethiopia

Performed data analysis, including data profiling, to obtain a good understanding of data availability, relationships and nuances for consideration of BI solution design

Performed data extraction to and from various sources like SQL Server 2008/2012/2014, Oracle, MySQL, MS excel and CSV from Client servers

Built and deployed SSIS packages meant for data extraction and loading

Analyzed the Sources, Targets, Transforming the data, and Mapping the data and loaded the data into Targets using SSIS

Created SSIS (ETL) packages involving Control Flow, Containers and Data Flow Tasks and Email alerts.

Worked on SSIS logging, Error Handling and Package configurations

Created Data-driven Packages in SSIS 2012/14 as part of automating processes including variety of transformations

Load data into dimensions and fact tables using slowly changing dimension using SSIS package

Involved in performing Audits and recovery operations of SSAS objects

Created Parameter, Cascading, Drill-down, Drill-through, Sub-Reports, gauge and Matrix reports using MS SSRS 2012 and Power BI for internal stakeholders

Jr. Database Developer (07/23/2014 – 06/14/2015)

Ethiopian Airlines

Addis Ababa, Ethiopia

Took lead in Analyzing business requirements and built logical data models that describe the data and relationships between the data.

Created review of functional requirement specifications and supporting documents for business systems, experience in database, report and data entry design processes.

Studied existing OLAP system and created facts and dimension tables with star schema representation for the data mart and warehouse systems.

Assess the risks and recommend/ install service packs or hot fixes on SQL Server 2008R2/2012/2014 when needed..

Created complex stored procedures and functions to support efficient data storage and manipulation.

Use systematic techniques for specifying requirements; like use-case scenarios, process modeling, and data-flow diagramming.

Coordination with developers, network administrators, server administrators, and offshore database personnel.

SKILLS

Query Languages: PL/SQL, T-SQL

Web Technologies: HTML, CSS

Database: SQL Server 2014/2012/2008, Oracle 11g/10g/9i, and MySQL

Networking: TCP/IP, LAN, WAN topologies, DNS, DHCP

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager

BI tools: MS BI, Power BI, Tableau Products

Data modeling tools: Lucid Chart

Operating Systems: Windows, Linux

Cloud Environment: Amazon Web Services (AWS) RDS, Azure

References – can be provided up on request.

+1-240-***-****

Contact this candidate