Employment History 

• Power BI Developer

  Colaberry Inc

  March 2018 - Present

  • Created various dashboards that depicts critical KPIs such as Monthly Revenue vs. Target, Top products based on Profit and Orders, Sales by Location, and Expenses vs. Budget, along with slicers and dicers enabling end users to make filters.
  • Data sources such as Excel, Text/CSV, MySQL, SQL Server DB and Azure SQL DB imported to Power BI to generate reports in different domains like Marketing, Sales, Insurance, Human Resources and Real Estate.
  • Wrote DAX calculated column and measures to optimize performance in reports and dashboards.
  • Explore data in a variety of ways and across multiple visualizations using Power BI.
  • Used Power BI gateways to keep the dashboards and reports up to date and enhance data security across organization network.
  • Create relationships between data and develop tabular and other multidimensional data models.
  • Scheduled dataflow and dataset refresh from SQL Server DB and Excel data sources.
  • Created Data Driven Alerts on KPI cards, Gauges charts and Cards to monitor changes on indicated target or goals.
  • Performed automation setup using SQL Server DB, Data Gateway and Power BI to share reporting with team members and team leads.
  • Developed Power BI model used for financial reporting of Sales, Salaries and Human Resources.
  • Developed SQL queries / scripts to validate the data such as checking for duplicates, null values, truncated values and ensuring data aggregations.
  • Involved in troubleshooting, resolving, and escalating data related issues and validating data to improve quality.
  • Employ Agile methodology on all projects embarked on.
  • Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions and measures.
  • Wrote queries to produce reports using SQL server 2016, and Reporting services (SSRS).
  • Worked with users and team members at all levels for performance improvement and suggestions.
  • Collaborated with managers to gather requirements from business stakeholders and perform process analysis.

• SQL BI Developer

  MTN Nigeria

  August 2016 - February 2018

  • Designed SSIS packages to extract data from different sources like SQL server 2012, MS Excel, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.
  • Developed SSIS packages using for each loop in Control Flow to loop all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert data into the SQL table.
  • Performed operations such as Fine-tuning overly complex T-SQL stored procedures for maximum efficiency and performance.
  • Produced operational reports in SSRS 2012 i.e., drill-down, drill-through, chart reports, parameterized reports, and snapshot reports.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Slowly Changing Dimension, and row count etc.
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Wrote SQL queries using joins, stored procedures, and user defined functions to verify the data from the database based on the business requirement.
  • Used Temp table to update information in the database.
  • Handled ad Hoc request and created parameterized reports using SQL server 2012 reporting Services.
  • Provided data analysis and data quality validation, managing report approval process, distributing, and storing reports to provide a meaningful and efficient summary.
  • Maintained SQL scripts, indexes and complex queries for analysis and extraction on a day, weekly and monthly basis.
  • Queried SQL database on daily basis to create and modified existing Stored Procedures and Views.
  • Wrote SQL triggers for checking Insert and Update on tables.
  • Worked with stakeholders, developers, and production teams across units to identify business needs and solution options.