Resume

Sign in

Data Analyst Developer

Location:
Alberta, Canada
Posted:
February 29, 2020

Contact this candidate

Resume:

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



Contact this candidate