PROFESSIONAL SUMMARY

Microsoft BI Certified, highly motivated, and dedicated professional with over 5 years of IT experience in Finance and Insurance domains. Currently working as Business Intelligence Developer for a Finance industry with a scrum-based Team using Agile Methodology as their main framework. Skilled in writing complex Sql queries, Extract, Transform and Load (ETL) process and Business Intelligence environments. Have strong interpersonal, business technical and problem-solving skills with ability to take new roles. Working well on multiple projects with multiple deliverables at a time with high passion to learn new technologies.

●Experienced in Data modeling, Database Design, Data warehousing, Database Development during the Extract, Transform and Load process (ETL)

●Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.

●Proficient in writing DAX queries in Power BI desktop.

●Experience in Reporting Services, Power BI (Dashboard Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services.

●Strong experience in ETL methodology for data transformation from different sources to Data staging Tables and Enterprises Data warehouse systems

●Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, implementation of STAR, SNOWFLAKE schemas and Slowly Changing Dimensions.

●Knowledge in Azure Stream Analytics

●Knowledge in Data Modeling (Logical, Physical, Star Schemas)

●Experience in Creating Packages in SSIS using Microsoft Visual Studio for ETL process.

●Very comfortable to work in SQL queries and Business Intelligence environments

●Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

●Experienced in implementing Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View

Experience working in Agile Environment

TECHNICAL SKILLS

Operating System

Windows, Linux

Components/ Environment

MS SQL Server 2016/2014/2012, SQL Server Management studio, Microsoft Visual Studio, PBI Desktop, Power BI Service,

Languages

T-SQL, PL/SQL, Linux shells scripting, Azure

Database

MS SQL Server, Oracle, Flat files

Tools

SSIS, SQL Server, Oracle SQL Developer, SSIS

WORK EXPERIENCE

Colaberry 09/2019 to Present.

(Power BI Developer)

Responsibilities:

●Translate business logic into dashboards, charts, reports, and presentations in support of Sales & Marketing department.

●Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.

Designing Microsoft power BI dashboards and managing the power BI gateways with a focus on usability, performance, flexibility, testability, and standardization.

●Designing OTLP, OLAP databases and creating ETL packages, tabular models, and dashboards.

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

●Using Power BI, Power Pivot to develop data analysis prototype, and used Power View a Power Map to visualize reports available in Web clients and mobile apps.

●Utilizing Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Designed SSAS Cube and developed MDX queries for Analysis.

●Document steps needed to migrate database objects between environments including Development, UAT, Staging and production

●Meet with business for defined requirements of the project.

●Provide production support of existing ETL process and develop cross validation rules to ensure mapping accuracy for newly added business rules.

●Developing SQL queries or use available data profiling applications to perform data analysis based on the business requirement and created data profiling report for data discovery.

●Developing new data integration and support existing dataset for BI teams.

●Creating SSIS jobs and scheduled packages using SQL Server management studio

●Supporting Maintenance of ETL process

●Applying common transformations such as aggregate, data conversion, conditional split, lookup, merge, and sorter transformations

●Responsible for migrating folders or mappings and sessions from development server to test environment.

●Working with Data Architects, DBAs, and Business Intelligence teams in designing and support end-to-end data solutions across multiple platforms.

●Improving ETL performance applying best practices

Environment: MS SQL Server 2016/2014/2012, SSIS, Shell Scripting, SQL, T-SQL, PL/SQL, Oracle, MS Word, MS, Excel, UNIX, Windows OS, Azure

Ethiopia Airlines

06/2015 – 08/2019

(Business Intelligence Developer)

Responsibilities:

●Develop, design, and analyze data architecture and data warehouses using SQL, SSIS, SSRS and Power BI

●Optimizing existing data models including changing load scripts to load data in an optimized way to achieve a reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.

●Working with the business to document and develop KPIs for the calculations in the Power BI and SSRS apps.

●Developed Power BI reports and dashboards from multiple data sources using data blending.

●Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User-Defined Functions.

●Experience in using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks, and handling the Isolation Levels.

●Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.

●Identified and worked with multi-value parameters for parameterized reports in SSRS and Power BI.

●Scheduled, maintained, and supported the distribution and access to reports at the Server level.

●Configured and maintained Report Manager and Report Server for Power BI Gateway and SSRS.

●Created Sub-Reports, Drilldown-Reports, Drill through, Summary Reports, and Parameterized Reports in SSRS.

Education:

●MBA (2018)- Debre Markos University, Ethiopia

●BA in Accounting and Finance (2015)- Jimma University, Ethiopia

Contact this candidate