Power Developer
Resume:
Hirut Tafesse
adgkbz@r.postjobfree.com
Charlotte, NC
Professional Summary
Over the past 5+ years, I have been working as SQL and Power BI developer with Central Business Solutions and Wholefoods Markets. As SQL developer, I worked extensively in an end to end relational database design, planning and implementation projects. I involved in creating and maintaining complex SQL queries and routines. I have also SSIS experience where I built a number of SSIS packages with error handling debugging, and troubleshooting. In the process of developing ETL solution I employed a wide range of tasks such as Data flow task, execute SQL task, script task and bulk insert task. In the data flow task, I used array of transformations including multicast, data-conversation, lookup, fuzzy lookup, derived column, merge join and conditional split. I have also worked on complex ETL that involve use of variables, expression and containers. As SSRS developer I created and maintained numerous dashboards with different functionality including drill-down, drill-through and sub-reports with parameter and expression using SSRS. Among the data visualization technique, I used KPI, gauge, charts, tables and matrix. As a Power BI developer, working knowledge with Power BI (Power Query, Power Pivot, Power View, Power BI Desktop, Power BI Publisher) and DAX scripting language a plus. Design and Implement reporting solutions using Reporting Services, Power BI, or other data visualization tools. SQL and Power BI Developer
• Experience in Power BI (Power Query, Power Pivot, Power View, Power BI Desktop, Power BI Publisher) and DAX scripting language a plus.
• Design and Implement reporting solutions using Reporting Services, Power BI, or other data visualization tools.
• Experience in writing complex ad hoc query/routines/applications that pull data from different sources systems (SQL and SharePoint site) using different languages (TSQL).
• Experience in writing complex queries that involve multiple tables and exception handlers using inbuilt functions, joins, temporary tables and expressions
• Experience in creating and using complex routines such as Stored Procedures, User Defined Functions, Triggers and Views
• Experience in creating and maintaining SSIS packages with error handling, debagging, and troubleshooting features.
• Experience creating packages using various tasks (DFT, EST, script task, send email task, bulk insert tasks).
• Create packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, data conversion, fuzzy grouping, script components.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experience in developing various types of custom reports including with functionalities such as Drilldown and Drill through, Ad hoc reports, Sub report with parameters and expressions, and all available report objects
• Expertise in creating interactive Dashboard that includes different reports with different functionalities using SSRS
• Distributed reports to business users in multiple formats through email, file shares, and SharePoint using SSRS deployment.
• Expertise in using EXCEL and its data summarization tools and adds-ins including PivotTables, PivotChart, PowerPivot and Power View
Education/Certification
• On job Training 2018
• Unity University, Addis Abeba, Ethiopia Sociology 3 Years (2011)
• College Diploma Information Technology, Infonet College Addis Abeba, Ethiopia, (2007) Hirut Tafesse
adgkbz@r.postjobfree.com
Charlotte, NC
Technical Skills
• Operating Systems: Windows 10 Pro 2004/ Windows Server 2003/ Windows 98/XP/Vista/7/8
• RDBMS: MS SQL Server 2016/2014/2012
• Software/ Computer Languages: .Net application, T-SQL, Teradata and Oracle
• BI/Reporting Tools: Power BI, SSRS, Report Builder 3.0, SharePoint, PowerPivot and Power View
• GUI Tools: Power Query, SQL Server Management Studio and Visual Query Builder
• Collaboration Tools: Power BI Services, SharePoint, and Dropbox
• Development Methodologies: Agile, Waterfall, Software Development Life Cycle (SDLC)
• Tuning Tools: SQL Server Profiler and Database Engine Tuning Advisor
• Microsoft Office: Word, PowerPoint, Publisher and especially EXCEL (including, PivotTable, PivotChart, PowerPivot and Power View).
• SharePoint
• Teradata:
Profession Experience
Central Business Solutions LLC
SQL /Power BI Developer March 2017-Present
Central Business solutions (CBS) is an IT consulting company that provides IT related services throughout the country. The company have been a trusted partner with numerous big and small projects that stretch from the support of a single branch to the entire operation. As data and reporting analyst I worked on all-inclusive ETL and Power BI solution while the company was partnering with companies on a mortgage Projects. The ETL solution receives data from various sources in different formats, consolidate and loads it into designated data warehouse. As an ETL developer during this project, I implemented various extraction, transformations and loading techniques including using stored Procedures, variables and expressions to build dynamic SSIS packages. The Power BI solution devoted in developing various data modeling, visualization and reporting techniques. Performed various transformations using Query Editor and also developed actionable Key Performance Indicators (KPI). Created numerous complex DAX calculated columns and measures, data modeling, drill down hierarchies, data-slicers, page level and report level filters. And also, publishing Power BI reports to the Power BI Services, setting up gateways, securities and permission level while sharing reports.
• Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
• Implemented SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
• Designed incremental loads to populate the data mart with checksum and timestamp techniques.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Designed expressions to calculate, group, filter, parameterize, and format report contents.
• Generated score cards with executive summary dashboards to display performance monitoring measures with Power BI.
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs Add what you done on mortgage project.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Hirut Tafesse
adgkbz@r.postjobfree.com
Charlotte, NC
Profession Experience
Whole foods Market
SQL /ETL Developer March 2015 - February 2017
Whole Foods Market Inc. is an American multinational supermarket chain headquartered in Austin, Texas. The company focus on selling products free from hydrogenated fats and artificial colors, flavors, and preservatives. Currently the company has more than 500 stores in North America (US and Canada) and seven in the United Kingdom. As SQL/ETL developer, my task was to write simple and complex query which aid to develop ETL solution that consolidate data from transactional server into data warehouse for the region and also produce daily branch store perforce summary report. To this end,
• Designed the Functional Requirements and Mapping Technical Specifications on the basis of Functional Requirements.
• Creating Index, Views, Complex Stored Procedures, Triggers, Cursors and appropriate User defined functions to implement the business logic.
• Involved in creation and updates procedures to clean and load data.
• Transferred data from flat files, Excel spreadsheets, and XML Source data to SQL Server using SSIS and also used BCP and Bulk Insert.
• Created, maintained and scheduled various ad hoc report reports for daily performance and weekly and monthly summers on regional level
• Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2010.
• Created document for Self-Service Deployment and Execution process for SSIS packages
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi- dimensional reports in SSRS.
Contact this candidate