My name is peter omonjiahio, I am a professional Business Intelligence Developer with a good experience and currently working at Colaberry incorporated, which is a consulting and training firm, I have Associate Degree in Mechanical Engineering from Auchi Polytechnic of Edo State, Nigeria’I have advanced knowledge and extensive work experience in Microsoft business Intelligence stack which include SSIS, SQL,SSAS,SSRS and power BI. My work experience extend to across multiple domain such as Health Care, Financial Sector, Mortgage ,Insurance and criminal Justice.My recent project on power BI was Victims of Mass Shooting in United State from Year 1966 to 2017, In this project I created an eye catchy visualization that shows number of victims shot on the above-mentioned year using chats, maps, key performance indicator (KPI) and slicers to create the dashboard that sanctifies the need of the user, I used different calculations such as DAX and M Language. There was a drill down that help the user to see the numbers of victims within a specific State and city, in addition to this the KPI’s figure was rationalized by using indicators.While working on multiple projects , I used SQL to create and update different tables with the necessary constraints , keys, and identities that maintain the integrity of the data, in this project I got the opportunity to create a store procedure, use of common table expression CTE, temporary and Table variable, I also used the various types of joins, it happens that I have to trouble shoot when my store procedure failed. I also hard experience using SSIS to extract ,transform and load data into the data warehouse, in this regard I used most of the various component of SSIS such as control flow , data flow, event handler and object explorer. I extracted my data from various sources such as flat file, Excel ,XML and OLEDB, this data was transformed by using some of the data flow task such as Data conversion, conditional split , Derived column, merge, Union All etc, before the data was loaded into it’s destination.In SSRS I created a report and dashboard that contains matrix, graph, tables, chats and gauge, I have to implement conditional formatting by using the IIF and Switch statement to help the users to see the trends of KPI’s. With this I have to also create reports such as Sub-Report, parameterized reports with cascading parameters, also Drill through and drill down functionalities were used in creating the report.All our project has been deployed and currently in production, recently I and my team received and award from one of our top client for implementing business intelligence practice.I am respectful, truthful, obedient and ready to learn, I am hard working , I can work independently and I also work with little or no supervision, I am a team player, I can work with any team, also I am an excellent strategic thinker, I enjoyed solving problem and learning new skills.