Profile
A Data Analyst with five years’ experience in data warehousing, integration, analysis, reporting and visualization using different Business Intelligence’s tools. Extensive experience in Business Intelligence such as Data Architecture and ETL processes.
Core Competencies
SSMS, SSAS, SSIS, SQL, Power BI; Tableau; Data Staging & Warehousing; Data Mining; Data Cleaning; Data Visualization, Data Storytelling, Dashboard Design using Power BI, Tableau; Business Analysis; Microsoft Word; Advanced data analysis with Excel Pivot Table; PowerPoint; Visio
Education
Northern Alberta Institute of Tech., Edmonton (Degree – Technology Management) 2018
Northern Alberta Institute of Tech., Edmonton (Network & Database Management) 2018
Federal Polytechnic, Offa, Nigeria (Higher National Diploma - Mechanical Engineering) 2007
Professional Summary and Skills
Data Analysis and Reporting tools: SSMS, SSIS, SQL Server, My SQL, Tableau, Power BI, MS Excel, MS Access
Multi-dimensional modeling, predictive modeling, regression, Naive Bayes
Planning, forecasting and financial modeling
Financial statement analysis and project requirements gathering
Business process modeling tools: Lucid Chart, MS Visio, Rational Rose
Insights data extraction, provisioning and analysis for accurate decision making
Enterprise Resource Planning (ERP): Deployment Support, User Acceptance Testing, Go-live and validation, ERP integration Dashboard monitoring
Professional Experience
Mosanada Facility Management Services, Doha-Qatar Feb 2018 – August 2019
Database Developer (Contract)
Job Profile/Responsibilities
Developed visual reports, dashboards and KPI scorecards using Power BI
Built SSAS Tabular Model Analysis Services databases
Designed, developed, tested and implemented relational databases
Used SSIS packages to extract, transform and load data from various flat files (CSV, MS Access, Excel) to staging area, warehouse, then to data-marts
Planned, analyzed and defined data as per business requirements, and documented accordingly
Built and maintained SSIS, ETL packages and established effective techniques for raw data exchanges
Designed and implemented OLTP database logical and physical data models as per business requirements
Analyzed and interpreted data feed sources to migrate data from various data formats into SQL server databases using automated import processes such as SSIS packages
Prepared optimized SQL queries, stored procedures for data extraction across multiple data sources and to improve the performance time
Project: Financial Management Analysis (FMA)
oCreated 25 identifiable key performance indicators and measures in Power BI based on management requirements
oDesigned, developed and implemented FMA Operational and Decision support dashboards
oWrote optimized SQL Server stored procedures and functions on FMA Database
oUsed SSIS to perform ETL on multiple sources (Maximo, CAFM & ETM) and transformed data based on business rules to generate required datasets for FMA sources
oFacilitated and gathered business requirements, designed working prototypes to meet business expectations
oDeployed Tabular Model Cubes on User Acceptance Testing and Production Multidimensional databases
oMaintained, supported and enhanced FMA
Project: Assets Tracking and Monitoring
oExtracted data of daily captured assets from the Maximo software, transformed and loaded the same data into the database warehouse and then into the data marts for CAFM software setup
oPerformed data cleansing and test unit for the data before loading into data marts
oWrote optimized SQL Server stored procedures and functions for the ETL processes
oTracked and monitored the number of datasets of assets captured daily in order to prepare accurate updated reports
Mosanada Facility Management Services, Doha-Qatar October 2014 – December 2016
ETL Developer/Data Analyst
Job Profile/Responsibilities
Developed and maintained ETL mappings, using SSIS to extract data from multiple source systems to the staging area, warehouse and then to the data marts
Performed data management and visualization using Power BI
Involved in business analysis and technical design sessions with concerned departments to develop requirements and ETL design specifications.
Prepared various technical documents, including functional and technical specifications, business requirements, data flow, and process diagrams using MS Visio tools
Created and executed mapping using Slowly Changing Dimensions (SCD) of different types based on business requirements
Developed mapping for fact loading from various dimension tables
Gathered requirements, designed and developed database solution for resource planning application
Project: Bill of Quantities (BOQ) and Material Submittals Data Migration, Monitoring and Management
oUsed SSIS to perform ETL on multiple sources (Oracle Primavera database; CSV, MS Access, Excel) and transformed data based on business rules to generate required datasets for Business Intelligence
oDeveloped dashboards, KPI scorecards and visual reports using Power BI
oAnalyzed and translated data into informative visuals and reports
oDeveloped design methodology and project documentation
oDeveloped tabular and multidimensional models that are compatible with warehouse standards as per the business requirements
Trivalley Engineering, Doha-Qatar May 2013 – Oct. 2014
Business Data Analyst/Power BI Developer
Job Profile/Responsibilities
Negotiated and liaised between the business teams and technology team
Supported and maintained healthy relationships with the business partners
Performed data management and visualization using Tableau and Power BI
Performed root cause analysis and designed corrective actions to meet both short term and long-term business goals
Executed and validated test cases
Developed and analyzed data and reports for the management team
Managed a wide range of data sets, including data mining, warehousing, extraction, loading and transmitting and archiving
Tracked, monitored and reported Key Performance Indicator (KPI) dashboard for continuous improvement
Conducted troubleshooting on BI models
Generated reports to support business decision making and business performance
Project: Tableau Dashboard Development and Server Administration
oConducted performance tuning/server management of Tableau server environment
oManaged and supported migration of dimensions, measures, reports and dashboards from the development to production environments
oMonitored server activities to identify performance issues