About
I have excellent skills and experience over the years in different industries and I am very confident to bring significant change and contribution to your organization. I am a person who is well organized, can properly utilize my time on the assigned tasks, warmhearted, respectful, and a good team player. I can work independently or within a group. I enjoy learning and being involved with developers and end-users. If there is a challenge I am struggling with, I first google what I can. Watch Guy in a cube or Curbal on YouTube. May reach out PBI community on powerBI.com or submit a ticket with Microsoft. Thank you.
Portfolio
Ford Car Price Prediction
Price forecasting may be a feature of consumer-facing travel apps, such as Trainline or Hopper, used... ... More
Employment History
-
BI/Power BI
Colaberry Inc.
August 2017 - Present
• Develop dashboards and interactive visual reports using Power BI, Publishing the report to Service, and Mobile App.
• Identifying key performance indicators (KPIs) with clear objectives.
• Understand business requirements in BI context and design data models to transform raw data into meaningful insights
• Analyzing data and presenting data through reports that aid decision-making.
• Convert business requirements into technical specifications
• Creating relationships between data and developing tabular and other multidimensional data models
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Design, develop, test, and deploy Power BI scripts and perform detailed analytics
• Cleaning and validating Imported data from any source file (SQL, Excel, XML, CSV, etc.)
• SQL querying for best results, use of filters and graphs for better understanding of data
• Used SSIS to create, maintain and troubleshoot ETL packages to validate, extract, transform and load data to data warehouse databases.
• Experience in deploying SSIS packages to multiple environments using different methodologies and performing Automation of SSIS Packages using SQL Server agent.
• Work with users and team members at all levels for performance improvement and suggestions
Education
. Former Fourth year Bachelor of science Statistics student minor in computer science in Addis Ababa University.
Certification
• Certificate of Colaberry Data Analytics, 2021
Technical Summary
• Languages: DAX, T-SQL
• ETL Tools: SQL Server Integration Service (SSIS)
• Reporting Tools: Power BI, SQL Server Reporting Services (SSRS)
• BI Tools: SQL Server 2016/2019, Power BI, Visual Studio
• Office Tools: MS Word, PowerPoint, MS Excel
• Methodologies: Agile
Skills
• Utilized Power BI to create various analytical dashboards that describe critical KPIs
• Experience in the concepts and practices of physical and Logical data model design
• Experienced in DAX queries to calculate KPIs and functions in Power BI
• Experienced in T- SQL queries, Stored procedures, Views, UDF, Joins, Trigger, CTE, Temp table
• Experienced in SSIS Packages (Developing, Deploying, Scheduling, Troubleshooting, and monitoring) and performing data transfers and ETL process
• Expertise in generating reports using SQL Server Reporting Services (SSRS)
• Experience in using and integrating PowerApps with dashboards & reports