Paul Nyarugwe

I have over 5 years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau.

Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access.

Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development. 

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

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

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

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. 

Implemented code check-in/check-out and managed multiple versions of complicated code within TFS. 

Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.

Developed Power BI model used for financial reporting of P & L and Headcount. 

Designed and documented the entire Architecture of Power bi Poc 

Expertise in writing complex DAX functions in Power BI and Power Pivot. 

Automated Power Query refresh using power shell script and windows task scheduler. 

Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure

Installed and configured Enterprise gateway and Personal gateway in Power bi service. 

Created Workspace and content packs for business users to view the developed reports. 

Scheduled Automatic refresh and scheduling refresh in power bi service. 

Wrote calculated columns, Measures querys in power bi desktop to show good data analysis techniques. 

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.