seun ogun

• 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 involves 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 and technical design documents for reference purposes.

• Refactored multiple manual report generation processes by automating data retrieval, transformation, and reporting to track vaccines distribution
• Created PowerBI dashboards that provided insights into customers order ; this included usage trends and patterns
• Created PowerBI & Tableau reports that displayed forecasted gas usage based on historical trends; applied complex DAX measures to provide best recommendation (plans) based on historical usage and forecasts
• Used Power Query to acquire data and Power BI desktop for designing rich visuals. 
• Created medium to complex queries using SQL to report customer gas usage data.
• Fixed bugs in reports and dashboards by performing thorough research and writing queries against source data to determine root cause.
• Participated in strategic objective meetings to help establish reporting standards, development processes and documentation

BS in business Administration At Crown Polytechnic Ado-Ekiti, NIGERIA