Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

OMON UGBOKE

Forney

Summary

Result driven Business Intelligence developer with over 5 years of extensive experience in database design and development. I am proficient with MS SQL Server versions 2016/2021 using SSIS, SSRS, Power BI, Tableau, Azure, Snowflake, D365, Azure, Cognos, Power Apps, Data Bricks. I prioritize data integrity and strive to communicate complex information clearly, ensuring it drives strategic outcomes.

Overview

6
6
years of professional experience

Work History

Data Engineer, Data & Analytics

BRIGHTLINE TRAIN
10.2022 - Current
  • Designed and maintained several reports to meet client’s business needs and processed client data requests.
  • Oversee the implementation, configuration, and maintenance of BI platforms, ensuring optimal performance and scalability.
  • Developed and maintained the Executive dashboard for the company which carried all the major matrix with organizational goals and objectives.
  • Redefined and made technical/strategic changes to enhance existing Business Intelligence systems.
  • Worked with users and team members at all levels for performance improvement and suggestions.
  • Defined and updated key matrix using Dax studio external tool.
  • Created Paginated Reporting.
  • Analyzing data and present data through reports that aid decision-making.
  • Organize and prioritize workload to consistently meet deadlines.
  • Perform ad hoc analysis using data from various systems and explain results of analyses to all levels of management.
  • Created and managed data flows for reusability of data.

Senior Business Intelligence Developer

DELIOTTE
01.2020 - 09.2022
  • Designed and created several reports to meet client’s business needs and processed client data requests.
  • 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.
  • Created stored procedure, view, and several queries for reporting purpose.
  • Configured packages with checkpoints, error logging and event handling to redirect error rows and fix the errors in SSIS.
  • Completed Full life cycle of ETL/ELT development to address business needs or resolve issues including design, mapping, scheduling, and testing.
  • Designing and implementing scalable, distributed systems leveraging cloud computing technologies such as Microsoft Azure, Snowflake.
  • Experience using Azure Data factory, Databricks, Data Lake & Azure Synapse.
  • Used the bulk load option while loading data into tables in snowflakes.
  • Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements.
  • Created Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
  • Performed the extraction, presentation, and analysis of mortgage company using their data information to develop new solution that support business needs.
  • Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
  • Designed, developed, and deployed SSRS reports that include parameterized reports, drill down reports, drill through reports, list reports, Sub Reports, Gauges, Pie Chart, Bar Chart.
  • Created and Deployed reports to Report Server and Troubleshooting for any error occur in execution.
  • Created relationships, filters, parameters, hierarchies, calculated fields, sorting, groupings and live connections in Tableau.
  • Created reports, dashboard, and stories in Tableau.
  • Published tableau reports to Tableau Server.
  • Pulled data from several data sources such as Azure, AWS, Snowflakes, SQL Server, SharePoint, Dataflow, Dataset, D365 ERP.
  • Rendered Power BI reports to be executed automatically on weekly or monthly basis, created and managed subscriptions.
  • Used DAX to calculate Year Over Year, Month Over Month and various comparison calculations.
  • Embedded report into Azure active directory for external client to view reports.
  • Scheduled the reports to run on daily and weekly basis in report manager and email them to managers and analysts to review in excel spread sheet.
  • 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.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing.
  • Power BI Administration-Creating role level security, subscribing users to report page, giving access to users, and embedding report in Azure active directory app.

Data Analyst

MEDEXCEL
01.2019 - 12.2019
  • Designed and created several Integration packages and business-related data.
  • Processed departmental data requests and created applications to provide patients data reports.
  • Collaborated with the team to gather requirements and create reports for HR and Finance department.
  • Designed and built ETL packages in SSIS to load data to data warehouse for dashboard reporting.
  • Scheduled for ETL package to run automatically using SQL Server job agent.
  • Developed queries such as CTE, stored procedures and views for reporting purpose.
  • Conducted code review based on companies’ standard.
  • Designed, developed, and established KPIs to monitor analysis and provide strategic insights to drive growth and performance.
  • Identified and recommended process improvements to reduce inefficiencies and improve accuracy and automation of workflow and data transfers.
  • Developed several SSRS reports from End to End.
  • Deployed SSRS report to Report Server and maintained existing reports in Report Server.
  • Trouble Shoot SSRS reports.
  • Created and rendered reports in different formats like pdf, excel etc.
  • To be executed automatically on weekly or monthly basis and managed subscriptions.
  • Generated Sub-Reports, Drilldown reports, Drill through reports and Parameterized reports using SSRS.
  • Developed Power BI Paginated report for internal clients.
  • Created Power BI Reports and Dashboard to service internal clients based on requirement.
  • Imported data from SQL Server Database to Power BI to create report.
  • Created several custom Power BI and Microsoft SQL Reporting Services reports and dashboards based on requirement.
  • Created reports using time intelligence calculations and functions.
  • Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.

Education

Bachelor of Science - Computer Science

Benson Idahosa University
12-2013

Skills

    BI Tools: Proficient in Power BI, Tableau, Cognos and SQL Server Reporting Services (SSRS)

    Data Modeling: Experience in data warehousing concepts, ETL processes, and data modeling

    Programming Languages: Proficient in SQL, Data Bricks, Snow Flakes, Oracle, Python, and R for data analysis and manipulation

    Data Visualization: Skilled in creating interactive dashboards and reports that effectively communicate insights

    Problem Solving: Strong analytical and critical thinking abilities to identify trends and patterns in data

    Collaboration: Excellent interpersonal skills, with experience working in cross-functional teams

Languages

English
Native or Bilingual

Timeline

Data Engineer, Data & Analytics

BRIGHTLINE TRAIN
10.2022 - Current

Senior Business Intelligence Developer

DELIOTTE
01.2020 - 09.2022

Data Analyst

MEDEXCEL
01.2019 - 12.2019

Bachelor of Science - Computer Science

Benson Idahosa University

Similar Profiles

CREATE PROFILE
OMON UGBOKE