Data Alemu
*** * ******** ** ********** VA ***** 206-***-****
addfv1@r.postjobfree.com
OVERVIEW
A US Citizen with active secret clearance and 6 Years of Business Intelligence /SQL Developer and Data Analytics with Bachelor of Science in Information Systems. Extensive expertise in T-SQL, SSIS, SSRS, Power BI and Tableau with initiatives that utilize software and hardware components within a creative and technology-driven organization.
T-SQL development skills in Objects creation such as Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Cursors and Triggers using SQL Server 2008R2/2012/2014.
Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI. Periodic reporting is done on a daily, weekly, monthly and quarterly basis which helps the client.
Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop, Power BI and Excel to provide better data visualization.
Designed, developed and implemented BI solutions leveraging Tableau Desktop, Tableau Online, Tableau Prep, and Tableau Server with proven experience in creating advanced data visualizations, including custom visualizations, discovery, structuring, cleaning, enriching, validation, and publishing.
Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.
Solid knowledge of Power BI and Tableau Desktop report performance optimization.
Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map.
Expert on Microsoft Power BI and Tableau reports, dashboards and publishing to the end users for executive level Business Decision.
Expert on maintaining and managing Tableau and POWER BI driven reports and dashboards.
Experienced in managing users, groups, sites, permissions and roles on Tableau server.
TECHNICAL EXPERIENCE
RDBMS/DBMS: Microsoft Access, SQL Server 2008 R2, and SQL Server 2012, 2014
Software/Databases: MS SQL Server 2008RS,2012 MS SQL Server Reporting Services 2008/2012 (SSRS), MS SQL Server Analysis Services 2008/2012 (SSAS), MS SQL Server Integration Services 2008/2012(SSIS), ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, PerformancePoint Server
Development Environments:
• Microsoft Visual Studio 2008/2010/2012/2013
• Microsoft Visual Studio Team System 2008/2010/2012
• Microsoft SQL Server Management Studio 2008/2012/2014
• Microsoft SQL Server 2008/2012/2014
ORACLE
POWER BI
Tableau
Excel
Smart Sheet
Programming Languages: Experienced in Transact-SQL (T-SQL), XML, and C#.
EDUCATION
Saint Cloud State University Saint Cloud, MN 2009-2013
Bachelor of Science in Information Systems.
PROFESSIONAL EXPERIENCE
Sr.BI/Tableau Developer Sep 2019 – Mar 2020 Department of Defense, Alexandria VA via Knowesis
•Created many interactive Tableau Dashboards for C-Level executives as well as Special Agents and Directors.
•Responsible for development of tools, delivery frameworks, and methodologies to solve business problems and solutions we deliver for our clients.
•Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
•Developed Tableau visualizations and dashboards using Tableau Desktop.
•Developed Tableau workbooks from multiple data sources using Data Blending and joins.
•Provided production support for Tableau users and the clients.
•Worked with a team of developers to design, develop and implement a BI solution for the clients using Tableau desktop.
•Automated monthly Excel reports into Tableau Workbooks and Dashboards.
•Created a Library of presentation templates by topic for future use and created documentation.
•Demonstrated translate a question into a visualization which provides insight and answers the question.
•Lead meetings with technical peers regarding the solution designs.
•Built, customized and published interactive reports, visualizations and dashboards using Tableau desktop and server.
Sr.BI/Tableau/Power BI Developer Jan 2018 – Sep 2019 Department of Veterans Affairs, Washington DC via CACI
Involved in creating different reports based on the business request and ad hoc requirements using Tableau, Power BI desktop.
Created Ad-hoc Reports, proof of concept, and solution mockups.
Experience in writing complex SQL queries to perform End-to-End ETL validations and support Ad-hoc business requests.
Created Dashboards of different types for Analysis, Monitoring, Management and better understanding of the business performance metrics.
Created solution driven dashboards by developing different charts types including cross tab's, Heat/Geo/tree maps, pie/bar charts/circle views/Lines/Area charts, Scatter plots, bullet Graphs and Histograms in Tableau and Power BI Desktop.
Created reports to users in Tableau by connecting to various data sources (MS SQL Server, Oracle, MS Excel, CSV….).
Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and excel.
Worked on extensive SQL Server Integration Services (SSIS) – Extracting data from 8 different sources and load into data warehouse after applying business logic and data profiling.
Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.
Expertise in writing SQL Queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views, Cursors and Triggers.
Created Advanced Tableau and Power BI Dashboards, SQL Queries and SQL Optimization experience.
Sr. BI/Tableau/Power BI Developer Jan 2017 – Dec 2017 Sunovion Pharmaceuticals Inc. via Kforce
Designed, developed and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company.
Conducted meetings with business stakeholders, clients and director level members for requirement gatherings and presented various solutions using best practices.
Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources.
Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt chars, trend lines, waterfall charts, statistical models, heat maps, geo-maps allowing end users to utilize full functionality of the dashboard.
Excellent SQL skills for daily testing of data using various SQL queries.
Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
Built interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
Created complex dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets and customization using filters and actions.
Sr. Business Data Analyst/ Tableau Developer. Sep 2015 –Jan 2017 Starbucks, Seattle WA. Via CompuCom
Responsible for creating SQL datasets for Tableau recurring and Ad-hoc Reports.
Created ad-hoc reports to users in Tableau Desktop by connecting various data sources, multiple views and associated reports.
Worked directly with stakeholders for requirements gathering and developing various decision-making Dashboards.
Created joins and sub-queries for complex queries involving multiple tables.
Created various reports and visualization dashboards using Tableau based on the clients’ needs.
Expert on creating multiple kind of Report in Tableau and present it using Story Points.
Created Dashboards Scorecards, views, pivot tables, charts, for further data analysis.
Expert on creating complex CTE, Sub Queries, Joins, cumulative queries for multiple kind of reports.
Provided an advance Tableau training to top stakeholders and team Members.
Created, maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
Created, maintained & scheduled various reports in Oracle Roast like Tabular Reports, Matrix Reports & Parameterized Reports using SSRS.
Expert on connecting multiple data sources in Tableau to implement working reports.
Performed super user trainings in Basic and Advanced Tableau Desktop.
BI/ Data Analyst/Power BI /Tableau Developer. May 2013 – Sep 2015
T-Mobile, Seattle WA. Via Princeton Information
Managed enterprise services by diagnosing root causes of incidences, determined time of detection, diagnosed and resolved by analyzing data.
Worked with various data sources such as Oracle, SQL Server, Hadoop, ODBC and flat file sources.
Created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
Expert in connecting multiple data sources in Power BI to implement working reports.
Hands on experience in developing reports and dashboards visualization.
Developed confidential proprietary analytical tools and reports with Microsoft Excel, Power Pivot, Power Point, Slicer, Pivot chart, Pie Chart and Macros.
Expert in creating Dashboards Scorecards, views, pivot tables, charts for further data analysis using Power BI desktop.
Expert in creating multiple kind of Power BI Reports and Dashboards.
Created and deployed Matrix, Grid, Chart, and Gauge Reports utilizing SSRS. Created parameters for SSRS reports as well as drill-down and interactive sorting capability.
Implemented subscriptions and snapshots in the SSRS Report Manager.
Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI.
Expert in creating Score Cards, Metrics, Power View/MAP and Pivot Tables using Office 365.
Expert in creating multiple kinds of Report in Power BI and presented them using Story Points.
Created SSIS package to pull all events and programs data from database server and SharePoint lists.
Assisted users in creating and modifying worksheets and data visualization dashboards.
Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.