Shawn Ogunwunmi

Experience

1. Data Analyst

   Fiber Solutions

   Dec 2018 — Present

   Create Project cost analysis dashboard in PowerBI; This dashboard provides insights into costs for implementing product sliceable across multiple dimensions. Convert various SQL statements into Store Procedures thereby reducing the number of database accesses (since store procedures passes the whole block at one time). Create Excel reports that calculated price cable production estimates for potential customers. This solution involve complex algorithms and forecasting techniques to accurately estimate power production and cost based on multiple variables Convert few of our Power BI Dashboard to Tableau for our new acquisition that is already using Tableau Built Power BI data models that facilitated energy power production reporting and analytics; Applied data modelling techniques like bi-directional filtering, composite storage models, appropriate relationships as well as custom themes, custom visuals, row level security and data transformations using Power Query Built Power BI reports that displayed information about current and historical deals based on statuses. Built multiple organizational dashboards and reports using Power BI; wrote complex DAX formulas for energy metric reporting and data transformations within Power BI As part of a team, architected, develop, and maintain a reporting data model (database) to facilitate efficient reporting and analytics Wrote multiple SQL queries for Ad Hoc and standard reporting; created views to extract data from relation databases into Power BI/Tableau and Excel for reporting purposes Worked closely with the business units to understand and document reporting needs for reporting and analytical purposes; applied SDLC methodology including requirements gathering, design, development testing and maintenance strategies to accomplish needs Provided technical documentation on data lineage and data mapping between source systems and reports Created and maintained business requirement documents