Alazar Bekele
Nashville,TN
Summary
Power BI Developer | Data Analyst | Business Intelligence Specialist
Highly skilled Power BI Developer, Data Analyst, and Business Intelligence (BI) Specialist with 10+ years of experience in designing, developing, and optimizing data-driven solutions. Proven ability to transform complex datasets into actionable insights through advanced data visualization, reporting, and analytics.
Overview
10
10
years of professional experience
1
1
Certification
Work History
SQL and Power BI Developer
Groups 360
07.2021 - Current
- Power BI development and administration
- Building Analysis Service and Reporting Models
- Developing Visual Report, Dashboards,KPI, Score Card using power bi desktop
- Connecting Data source, Importing and Transforming data for Business Intelligence
- Installed and Configured SQL Server 2012/2014/2016 on physical Server and Virtual environments
- Evaluated the data structures and making enhancements of existing logical and physical database designs to fit new business requirement, and implemented new design into SQL Server
- Created T-SQL Stored Procedures, User Defined Functions, Indexes, Views, Constraints, Triggers and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs
- Queried relational and multidimensional OLAP data warehouses
- Worked on transitioning database and report packages from Development and Test Environments to Production
SQL and BI Developer
Targeted Technology
07.2018 - 06.2021
- Analyzed business requirements and built conceptual, logical, and physical data models that describe all the data and relationships between the data
- Installed and Configured SQL Server 2012/2014/2016 on physical Server and Virtual environments
- Evaluated the data structures and making enhancements of existing logical and physical database designs to fit new business requirement, and implemented new design into SQL Server
- Created T-SQL Stored Procedures, User Defined Functions, Indexes, Views, Constraints, Triggers and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs
- Queried relational and multidimensional OLAP data warehouses
- Worked on transitioning database and report packages from Development and Test Environments to Production
Business Analyst and BI Developer
Safeway supermarkets
12.2014 - 09.2018
- Company Overview: Addis Abab Ethiopia
- Built and deployed SSIS packages for data extraction, transformation and loading including slowly changing dimensions and other advanced transformations
- Worked with users and the development team to develop technical solution proposals to business challenges
- Working closely with project managers to facilitate the processing of Statements of Work
- Created project plans that adhere to Software Development Life Cycle (SDLC) standards, and provide comprehensive status reporting for ongoing programs of work
- Wrote T-SQL queries and Stored procedures for dynamic data retrieval for reporting purposes
- Worked on SSIS logging, Error Handling and Package configurations
- Created reports that contained Parameters, Sub-Reports, charts, gauges with Drilldown and Drill-through features in MS SSRS 2014/16
- Developed various data visualizations reports and dashboards with Power BI and deploying them to Power BI Services
- Created tables and visualizations in MS Excel which involved frequent use of logical functions
- Created complex stored procedures and functions to support efficient data storage and manipulation
- Analyzed data sources, targets, transforming data, and load the data into target database using SSIS
- Perform data analysis, including data profiling, to obtain a good understanding of data availability, relationships and nuances for consideration of BI solution design
- Conducted advanced econometric modeling using Cross-sectional data (Data gathered across various entities at a point in time), Time series data (Data gathered for the same entity over time), and Panel data (Data gathered across entities over time)
- Addis Abab Ethiopia
Education
Bachelor Degree Engineering -
DBU University
07.2015
Skills
Technical Skills
Business Intelligence & Reporting:
- Power BI (DAX, Power Query, Data Modeling, Row-Level Security)
- Tableau (Data Visualization, Dashboard Development, Calculated Fields)
- SQL Server Reporting Services (SSRS)
- Qlik Sense / QlikView, Looker, Google Data Studio, IBM Cognos
- SQL Server, MySQL, PostgreSQL, Oracle (10g, 11g, 12c, 19c)
- MongoDB, Cassandra, IBM Db2, Snowflake, Google BigQuery, SAP HANA
- T-SQL, PL/SQL, MDX (Multidimensional Expressions), DAX
- Database Performance Tuning, Query Optimization, Indexing, Partitioning
- Capacity Monitoring, Database Security, Backup & Recovery, Failover Administration
- Oracle RAC, ASM, Automatic Database Diagnostic Monitor (ADDM)
- SQL Server Integration Services (SSIS), Talend, Informatica, Apache Nifi
- Azure Data Factory (ADF), AWS Glue, DataStage, Pentaho, Matillion
- Extract, Transform, Load (ETL) Processes, Data Migration, Data Cleansing
- AWS (RDS, Redshift, DynamoDB, S3, Glue, Lambda, EC2)
- Azure (SQL Database, Synapse Analytics, Data Lake, CosmosDB, Logic Apps)
- Google Cloud Platform (BigQuery, DataFlow, Pub/Sub, Cloud SQL)
- Snowflake (Data Warehousing & ELT Development)
- Python (Pandas, NumPy, SciPy, Matplotlib, Seaborn, Flask, Django)
- R (Data Analysis, Statistical Modeling, ggplot2, dplyr)
- JavaScript (Nodejs, Reactjs, D3js, Expressjs)
- C#, NET Framework, VBA, PowerShell
- Star Schema, Snowflake Schema, Fact & Dimension Table Design
- Kimball & Inmon Methodologies
- Data Lake, Data Vault, Data Mart, Master Data Management (MDM)
- Power BI (Paginated Reports, Custom Visuals, Bookmarks, Drill-throughs)
- Tableau (Filters, Parameters, Level of Detail Expressions, Storytelling)
- Excel (Power Pivot, Power Query, VBA, Macros, Pivot Tables)
- D3js (JavaScript Library for Data Visualization)
- Jira, Confluence, Trello, Microsoft Project, Asana, Mondaycom
- Agile (Scrum, Kanban), DevOps, CI/CD Pipelines
- Version Control (Git, GitHub, GitLab, Bitbucket, Azure DevOps)
- Windows Server (2012, 2016, 2019, 2022, Active Directory, IIS, SCCM)
- Linux (Ubuntu, CentOS, Debian, RedHat, SUSE, Fedora)
- macOS Server, FreeBSD, OpenBSD, Solaris
- LucidChart, Drawio, Microsoft Visio, Google Drawings
- ERD (Entity Relationship Diagrams), UML, BPMN (Business Process Model Notation)
Certification
- MCSA Developing Microsoft SQL Server Databases
- Microsoft BI (SSIS, SSAS, SSRS) training
- Power BI training
- Database Administration
Skills
SQL Server 2012, SQL Server 2014, SQL Server 2016, MySQL, PostgreSQL, T-SQL, MDX, Python, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft Power BI, LucidChart, Draw.io, Windows Desktop and Server (2008/2012R2), Linux – Ubuntu/Redhat, AWS, Azure, Oracle 10g Database Administration, Performance Tuning & Capacity Monitoring, Data Security, Backup & Recovery, Standby/Failover Administration, Power BI, DAX, Power Query, Azure Environment, AWS, PostgreSQL, SQL, Jira, Project tracking Tool, Oracle RAC & ASM Administration/Installation, Oracle Forms and Reports Development, Database-Backed Web Solutions, SQL Tuning in an Oracle Environment
Timeline
SQL and Power BI Developer
Groups 360
07.2021 - Current
SQL and BI Developer
Targeted Technology
07.2018 - 06.2021
Business Analyst and BI Developer
Safeway supermarkets
12.2014 - 09.2018
Bachelor Degree Engineering -
DBU University
Similar Profiles
VIKAS CHAUDHARIVIKAS CHAUDHARI
Sr. Executive - Finance at 360 SMS App LLP unit of 360 Degree Cloud Technologies Pvt. Ltd.Sr. Executive - Finance at 360 SMS App LLP unit of 360 Degree Cloud Technologies Pvt. Ltd.
Avishay WeinbergAvishay Weinberg
Construction Project Manager- ADU / Property Manager at West Valley Plaza, Inc. / Retrofitting 360 dba 360 BuildersConstruction Project Manager- ADU / Property Manager at West Valley Plaza, Inc. / Retrofitting 360 dba 360 Builders
AMOS ODUROAMOS ODURO
Assistant manager at OAK-VAN GROUPS OF COMPANIES (PROCUREMENT&SUPPLY)Assistant manager at OAK-VAN GROUPS OF COMPANIES (PROCUREMENT&SUPPLY)
Jase KeithleyJase Keithley
Freelance Audio Engineer at Self-employeedFreelance Audio Engineer at Self-employeed
Lisa GieseLisa Giese
Birthday Party Director at BOOST GymnasticsBirthday Party Director at BOOST Gymnastics