PETER OMONJIAHIO

PETER OMONJIAHIO

Power BI/ Business Intelligence

Austin, Texas, United States.

About  

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.

Hours Available / Wk - 40 hrs

Watch Video Pitch

Portfolio 

0 Likes

Victims Of Mass Shootings In United States (1966 -2017)

We all know that Mass Shootings is as a result of Gun circulation to the general public, Because Gun... ... More

Employment History 

  • BI/Power BI Developer

    Colaberry Inc
    August 2020 - Present

    • Responsible for defining, designing and implementation of Power BI Reports and dashboards for end users.
    • Used DAX to create Calculated Columns and Measures.
    • Created Dashboards, Tabular reports, Matrix reports, Charts and Graphs as per customer requirements using Power BI and SSRS.
    • Created Proof of Concept (POC) using Power BI as a tool.
    • Develop and build the Reports,
    Dashboards and scorecards using Power BI and published into Power BI Service.
    • Implemented Row-Level Security (RLS) to securely create user specific reports and dashboards.
    • Scheduled refreshes through the Power BI gateway to refresh Dashboard at regular intervals and appropriate dependencies.
    • Served as a team member in Project
    Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform.
    • Daily progress updates during scrum meetings.

Digital Credentials  

Schedule an Interview