DAWIT BELETE

Power BI Developer

Alexandria, VA *2312 ad4axd@r.postjobfree.com 443-***-****

SUMMARY

● Strong experience developing and using SQL Server Reporting(SSRS) reports using SSRS development tools (based on Visual Studio), code behind SSRS reports and Data Models, and associated SQL query creation in the past 6 + years.

● Use of MS SQL Server for Development of (Stored Procedures, Queries, Views, Etc.)

● Understanding of Windows Security Principles.

● Good writing skills to help in writing specifications and testing documentation.

● Top communicator and listener to fully understand user perspectives and requirements.

● I worked in different work environments in various industries and can proudly say that I can be a great asset to your organization.

● Experienced BI Developer, who possesses great deal of knowledge as well professional work ethics.

PROFESSIONAL EXPERIENCE

AlixPartners, Power BI, June 2019 – Present

Washington, DC

● Collaborated with senior management, subject matter experts, and IT teams to define business requirements.

● Actively participated in gathering user requirements and system specifications.

● Transformed business requirements into functional and nonfunctional requirements.

● Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources mappings, targets and sessions

● Creating complex stored procedures to perform various tasks including, but not limited to: index maintenance, data profiling, metadata searches, and loading of the data mart.

● Designed expressions to calculate, group, filter, parameterize, and format report contents.

● Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.

● 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 depict critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-users to make filters.

● 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 Unpivot 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.

● Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

● Explore data in a variety of ways and across multiple visualizations using Power BI.

● Used Power BI Gateways to keep the dashboards and reports up to date.

● Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services

● Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Wells Fargo, SQL/Power BI Developer, Apr 2016 – June 2019 San Francisco, CA

● Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

● Determined the SQL Server installation. Installed and configured SQL Server Management tools using SQL Server setup program.

● Maintained Tabular, Linked, Chart, Parameterized, Sub reports, Drill-down, Drill-through reports according to business requirements in a time-restricted environment.

● Created various SSIS packages by extracting data from various sources according to the requirements.

● Worked with various containers in the Control Flow task such as For Loop, For Each Loop, Sequence.

● Worked with various sources in the data flow tasks and used various transformations. Some of the transformations are merge, merge join, union, Lookup transformation, audit and aggregate

● Worked extensively on bad data with configuring the error output, conditional split, derived column transformation

● Deployed the packages in catalog method and worked on job scheduling and send mail task

● Physical implementation of database into SQL Server using T-SQL

● Created views to facilitate easy and user interface implementation and triggers on them to facilitate consistent data entry into the database

● Created stored procedures and functions to support efficient data storage and manipulation Construction Quality Solutions, Project Manager, January 2014 -December 2015 Alexandria, VA

● Provided detailed project status updates to stakeholders and executive management.

● Managed projects from procurement to commission.

● Planned, designed, and scheduled phases for large projects.

● Achieved project deadlines by coordinating with contractors to manage performance. and coordinated material procurement and required services for projects within budget requirements.

● Verified quality of deliverables and conformance to specifications before submitting to clients.

● Reported regularly to managers on project budget, progress and technical problems.

● Sourced, vetted and managed vendors needed to accomplish project goals.

● Identified plans and resources required to meet project goals and objectives.

● Recruited and oversaw personnel to achieve performance and quality targets.

● Developed and implemented strategic project plans to meet business objectives.

● Analyzed project performance data to identify areas of improvement.

● Developed and implemented project plans and budgets to ensure successful execution. EDUCATION and CERTIFICATIONS

Master of Science: Project Management - Florida University Bachelor of Science: Economics - Mekelle University Certified cyber security, CompTIA.org/pro

CAPM - Certified associate in project management

PMP - Project Management Professional

ENVIRONMENT and SKILLS

MS SQL Server 2012, MS SQL Server Analysis Services (SSAS), EDW, Power BI Desktop, Power BI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, M Query.

Contact this candidate