OGHENENYORE OTANOCHA

Project: HSBC Integration Project
Role: ETL / Power BI/ Report Developer

Responsibilities
• ETL/Power BI/ Report Developer in the migration and report development for Retail Banking SBU of legacy branches of HSBC.
• Collaborated with Business Analyst and other key stakeholders in requirement gathering.
• Produced Source to Target Mapping document based on Business transformation rules and requirements.
• Analyzed, designed, implemented and deployed dependent data marts across multiple business areas using SSAS (Tabular Model and Multi-dimensional Model) based on business requirements.
• Wrote SQL and DAX queries to extract data from different source systems (SQL Server, MS Excel, CSV files, Salesforce and Oracle) in line with source-to-target mapping.
• Wrote optimized T-SQL queries to load transformed data to target systems (from OLTP to Staging Area, ODS, EDW, Databases, Data Marts and Report Servers).
• Performed data munging and profiling, in line with business requirements.
• Used SQL Server Integration Services (SSIS) to create Connection Packages, Packages for the constituent dimensions, and used different Containers to migrate data from source to target (OLTP-Staging-EDW-SSISDB Catalog).
• Ensured conformity of data being transformed and loaded meet the minimum accuracy and reliability standards in line with data governance.
• Supported and maintained the ETL process, resolving issues and debugging.
• Gathered business requirements from Business Unit(s)s for report development.
• Developed self-serve interactive Power BI reports and dashboards from multiple data source systems (Snowflake, SQL Server, CSV files, Postgres and SQL Server Analysis Services-Tabular Model) and published same on Power BI Service.
• Built Measures and Calculated Columns using DAX language.
• Implemented row level security in Power BI workspaces based on prescribed access as contained in business requirements.
• Used Power Query to clean, filter and transform data in line with business needs.
• Wrote M queries in Power Query for data transformation.
• Wrote T-SQL queries, stored procedures and functions based on Business requirements.
• Enabled gateway for data refresh from on-prem data sources.
• Supported and trained end users on the use of PowerBI.
• Participated in daily Scrum standups and Sprint Retrospective meetings while working in Agile environment.

Environments: Power BI Desktop, Power Bi Service, SQL Server database, MS Excel, Postgres, SSAS Tabular Model

<p>Collaborated with Business Analyst and other key stakeholders in requirement gathering.<br>
Produced Source to Target Mapping document based on Business transformation rules and requirements.<br>
Analyzed, designed, implemented and deployed dependent data marts across multiple business areas using SSAS (Tabular Model and Multi-dimensional Model) based on business requirements.<br>
Wrote SQL and DAX queries to extract data from different source systems (SQL Server, MS Excel, CSV files, Salesforce and Oracle) in line with source-to-target mapping.<br>
Wrote optimized T-SQL queries to load transformed data to target systems (from OLTP to Staging Area, ODS, EDW, Databases, Data Marts and Report Servers).<br>
Performed data munging and profiling, in line with business requirements.<br>
Used SQL Server Integration Services (SSIS) to create Connection Packages, Packages for the constituent dimensions, and used different Containers to migrate data from source to target (OLTP-Staging-EDW-SSISDB Catalog).<br>
Ensured conformity of data being transformed and loaded meet the minimum accuracy and reliability standards in line with data governance.<br>
Supported and maintained the ETL process, resolving issues and debugging.<br>
Gathered business requirements from Business Unit(s)s for report development.<br>
Developed self-serve interactive Power BI reports and dashboards from multiple data source systems (Snowflake, SQL Server, CSV files, Postgres and SQL Server Analysis Services-Tabular Model) and published same on Power BI Service.<br>
Built Measures and Calculated Columns using DAX language.<br>
Implemented row level security in Power BI workspaces based on prescribed access as contained in business requirements.<br>
Used Power Query to clean, filter and transform data in line with business needs.<br>
Wrote M queries in Power Query for data transformation.<br>
Wrote T-SQL queries, stored procedures and functions based on Business requirements.<br>
Enabled gateway for data refresh from on-prem data sources.<br>
Supported and trained end users on the use of PowerBI.<br>
Participated in daily Scrum standups and Sprint Retrospective meetings while working in Agile environment.</p>

<p>Active participation in several requirement gathering sessions with key stakeholders.<br>
Developed source-to-target mapping on database of Finacle10 and Finacle11E.<br>
Developed an ETL model that loaded data from multiple source systems through Staging, ODS, EDW, Multidimensional Cubes, UAT and eventual deployment.<br>
Created over 50 Derived Measures with data sourced from 12 Multidimensional Analytic Databases using SSAS, MDX, T-SQL.<br>
Designed mock-up models for visualization of project layout for Business users.<br>
Developed interactive dashboards and reports that gave Business self-serve features using PowerBI, SSRS, Tableau, T-SQL and MySQL.<br>
Wrote efficient SQL scripts to create tables, established relationships and structure of data that were stored in the EDW, to ensure ease of querying and self-serve reporting by business.<br>
Performed ETL process using efficient SQL queries and Visual Studio.<br>
Designed, developed and deployed Multidimensional cubes using SSAS, MDX, T-SQL and Visual Studio.<br>
Carried out data munging and profiling, in line with business requirements.<br>
Migrated data to cloud storage system using Azure Data Factory.<br>
Created Pipeline to oversee 2 Integration Runtime that moved data from Blob Storage.<br>
Furthermore, I created a Linked Service to connect Dataset to Blob Storage in order to allow for Copy Activity, which moved data to the Sink Dataset in SQL Server.<br>
Developed and maintained Metadata dictionary in the form that is understood and usable by Business.<br>
Implemented data control in line with Business requirement by granting access to the EDW based on roles, tables and columns.<br>
Participated in daily scrum standups and sprint retrospective meetings while working in Agile environment.</p>

<p>Continually developed, maintained and prioritized the Product Backlog.<br>
Facilitated effective collaboration with the Development Team to understand and translate PBIs into shippable results within Sprints.<br>
Constantly liaised with Developers to create tasks for new features and epics.<br>
Facilitated Daily Standup meetings with the Scrum team, where necessary.<br>
Guided/assisted Developers in estimation, setting and monitoring of progress towards meeting sprint goals/objectives.<br>
Regularly updated the product roadmap for various projects assigned to me.<br>
Handled effective communication channel between the Scrum Development Team and stakeholders/Senior management.<br>
Ensured that the Development Team accepted appropriate tasks that are deliverable within the sprint iteration.<br>
Actively participated in different agile ceremonies, namely: sprint planning, daily stand-ups, retrospectives, backlog refinement, parking lot etc.<br>
Provided necessary clarifications to Development Team in areas where such is needed in relation to product features/requirements.<br>
Attended Scrum of Scrum meetings in the company of the Scrum Master, where Dependencies and other key issues were being discussed and resolved.<br>
Served as the bridge among key stakeholders in enhancing mutual understanding and alignment with product goals<br>
Updated Product Backlog with feedbacks from stakeholders for product improvement/development.</p>

<p>Partook in requirement gathering from stakeholders.<br>
Conducted Business requirements analysis on customers’ bank accounts integration with BVN database<br>
Wrote SQL scripts to identify Account Numbers tied to individual BVN with different Account Names.<br>
Segregation of all anomalous BVN/Account records.<br>
Scheduled jobs under SQL Agent Server to automatically identify and remove anomalous records, and keep its log.<br>
Generated daily reports and dashboards on anomalous BVN resulting from the deduplication process, using paginated reports and Dashboard on SSRS and Power BI.<br>
Wrote SQL and DAX queries to extract data from the Bank’s database in line with source-to-target mapping.<br>
Performed data munging and profiling, in line with business requirements.<br>
Used optimized SQL queries and scripts to load transformed data from OLDB to Retail Banking Data Mart.<br>
Ensured conformity of data being transformed and loaded meet the minimum accuracy and reliability standards in line with data governance.<br>
Carried out debugging where necessary in the ETL process.<br>
Developed Reports and Dashboards using PowerBI and SSRS, to enable Business generate self-serve reports.<br>
Deployment of reports on Retail Banking SharePoint Folder to allow for access by authorized users.<br>
Trained Business Users on the use of self-serve PowerBI in report and dashboard generation.<br>
Provided continuous support to Business in Report generation and maintenance.<br>
Participated in daily scrum standups and sprint retrospective meetings while working in Agile environment.</p>

<p>Developed BUS Metrics in conjunction with the Business Analysts to gather business requirement from stakeholders.<br>
Created mock-up model visualize project layout for Business.<br>
Designed conceptual, logical and physical models using SQL Server Diagrammer, and presented same to stakeholders during requirement gathering meetings.<br>
Developed and implemented the EDW using Ralph Kimball Dimensional modelling approach in line with business requirements.<br>
Created two Data marts for categories of the disciplinary cases and decisions reached by the Disciplinary Committee.<br>
Wrote SQL scripts to perform the ETL process from CSV files through Staging, EDW to Data Marts.<br>
Designed Fact and Dimension tables using Star and Galaxy Schema Models.<br>
Intermittently incorporated change request submitted by Business Unit.<br>
Developed Reports and Dashboards using visualization tools like PowerBI, Tableau and SSRS, to enable Business generate self-serve reports.<br>
Deployment of reports on Human Resources SharePoint Folder to allow for access by authorized users.<br>
Trained Business Users on how to use the self-serve PowerBI in report and dashboard generation.<br>
Provided continuous support to Business in Report generation and maintenance.</p>

<p>Participated in the planning and development of roadmap for the project and gathering of requirement.<br>
Visualized the project roadmap using MS PowerPoint.<br>
Used SSMS to design conceptual, logical and physical models in line with the project requirement.<br>
Designed, implemented and documented data architecture and model.<br>
As part of the Agile/Scrum process, I monitored and provided bi-weekly updates on my tasks and deliverables, ensured requirements/deliverables are reflected in user stories and tracked to completion.<br>
Designed, developed and deployed Multidimensional cubes using SSAS, MDX, T-SQL and Visual Studio.<br>
Developed and maintained Metadata dictionary in the form that is understood and usable by Business.<br>
Implemented data control in line with Business requirement by granting access to the EDW based on roles, tables and columns.<br>
Developed Reports and Dashboards using PowerBI and SSRS, to enable Business generate self-serve reports.<br>
Deployment of reports on Retail Banking SharePoint Folder to allow for access by authorized users.<br>
Trained Business Users on how to use the self-serve PowerBI in report and dashboard generation.<br>
Provided continuous support to Business in Report generation and maintenance.</p>