Abel Gebremariam Tel: 202-***-**** Email – adyxdc@r.postjobfree.com

PROFESSIONAL SUMMARY

Certified Power BI Data Analyst with 6+ years of experience in Financial and Retail Domains. Expertise in Designing and developing of data models, visualizations, user-friendly interactive reports, and dashboards, databases, data warehouses, using MS Power BI, MS SQL Server, SQL Server Integration Services

(SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Excel, and Tableau.

Significant expertise and substantial work experience in transforming data into valuable insights to expedite decision-making, optimizing internal business processes, Increasing the operational efficiency, driving revenues, gaining competitive advantages, Identifying the market trends, and spotting addressable business problems.

PROFESSIONAL EXPERIENCE

Darden Restaurants, Orlando, FL.

Role: SQL Server TSQL/Power BI Developer May 2021 – Present Responsibilities:

Worked with Project Managers to refine and analyze business needs.

Developed a Power BI solution that integrated data from multiple sources, including Excel, SQL Server, and SharePoint, for a logistics company.

Developed and deployed over 50 Power BI reports leading to a 10 % increase in sales.

Utilized Power BI to create a real-time dashboard, resulting in a 20% increase in efficiency.

Utilized Power BI to create a predictive analytics model, resulting in improved forecasting and inventory management.

Implemented data visualization best practices to create more effective and intuitive dashboards.

Created more than 15 KPI’s with outlined business objectives and maintained regular monitoring of this indicators.

Implemented data governance and security protocols for Power BI environment, ensuring compliance with industry regulations.

Designed and developed a Power BI solution that integrated with Power Automate, resulting in increased automation of business processes.

Created SSIS packages to Successfully extract transform and load data into data warehouse.

Tools &; Technologies: MS Power BI, Data Modeling, data visualization, Row level Abel Gebremariam Tel: 202-***-**** Email – adyxdc@r.postjobfree.com security (RLS), MS SQL Server 2019, 2014/2012, T-SQL, SSIS 2012, SSRS 2012, C#., Git, DAX, M query, Python, R, Jason, Business Requirement, Power Apps, Power Automate, Share Point Folder, Azure.

Prudential Financial Inc., Arlington, VA.

Role: Business Intelligence /Power BI developer May 2018 – April 2021 Roles and Responsibilities:

Developed a Power BI solution that provided real-time KPI monitoring, resulting in improved operational efficiency.

Developed a Power BI solution that automated the generation of reports and alerts, reducing manual effort by 50%.

Led the migration of on-premises BI solution to the Azure cloud, resulting in cost savings and improved scalability.

Collaborated with cross-functional teams to design and implement a Power BI solution that. improved decision-making.

Created Complex Stored procedures, Triggers, Indexes, Rules, Integrity constraints, Cursors, Views, and ad hoc queries using SQL 2012/2008.

Developed and deployed over 50+ ETL packages using SSIS, resulting in a 25% increase in data accuracy.

Developed and optimized SQL queries to extract, transform, and load data into Snowflake, ensuring efficient data processing. Zillow Group Inc., Denver, CO.

Role: Business Intelligence /Power BI developer June 2016 – April 2018 Responsibilities:

Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL.

Developed a Power BI solution that provided real-time KPI monitoring, resulting in improved operational efficiency.

Created SSIS packages to Successfully extract transform and load data into data warehouse.

Developed interactive reports, KPI’s and dashboards using Working knowledge on Power BI objects like Power Bi desktop, Power Bi services, Power Views, power query, power pivot, Workspaces, Dashboards, Row Level security Implementation and delivered actionable insights. TECHNICAL SKILLS:

Abel Gebremariam Tel: 202-***-**** Email – adyxdc@r.postjobfree.com

Power BI development and implementation experience

Strong SQL skills for data retrieval and manipulation

Experience with data warehousing concepts and design

Knowledge of Microsoft BI tools such as SSAS, SSRS, and SSIS

Experience with data integration and ETL processes

Strong analytical and problem-solving skills

Understanding of data governance, data security, and data privacy best practices

Familiarity with Azure and other cloud services for BI solutions

Strong communication and collaboration skills

Knowledge of data visualization, dashboard design, and user interface design

Experience with R or Python for data modeling and analysis

Familiarity with data connectors and data sources such as SQL Server, Oracle, SharePoint, and Excel

Experience with Power Automate and PowerApps

Familiarity with Power BI administration and governance

Proficient in Power Query (M) for data transformation and data modeling

Knowledge of DAX (Data Analysis Expressions) for data modeling and calculations.

Experience with Power BI embedded, Power BI Report Server, and Power BI Premium

Understanding of industry trends and BI best practices

Strong understanding of data governance, data security, and data privacy best practices.

Familiarity with other business intelligence and data visualization tools such as Tableau, QlikView, and Looker

EDUCATION

Bachelor’s Degree

CERTIFICATION

Microsoft Certified: Power BI Data Analyst Associate

Contact this candidate