Chiamaka (Amy) Nzeakor

**** **** ** *******, **. 825-***-**** ad3850@r.postjobfree.com LinkedIn Portfolio

Professional Summary

Results-driven Business Intelligence Analyst with over 5 years of experience in data analysis, visualization, and reporting. Proficient in Microsoft BI Stacks, Tableau, and Power BI, with a solid understanding of database design and data engineering principles. Certified Business Analyst (ECBA) committed to continuous learning and professional development.

Skills

Business Intelligence Tools:

oETL: SSIS, Azure Data Factory

oReporting: SSRS, Excel PowerPivot, Power BI

oAnalysis: SSAS, DAX, SAS DI, SAS Enterprise Guide

oDatabase Management: SQL Server Management Studio (SSMS), SQL Data Tools

oVersion Control: Team Foundation Server, Git

Data Visualization: Power BI, Tableau

RDBMS: MS SQL Server, Oracle, Azure SQL Database

Programming: Python, Microsoft Power Query

Collaboration Tools: Jira, Git

Microsoft Office Suite: Excel, Word, PowerPoint, Outlook, Visio

Certifications and License

Certified Business Analyst (ECBA) IIBA

Certificate IBM Cognos analytics

Certificate in Excel for Data Analytics

Professional Memberships:

Member, International Institute of Business Analysis (IIBA)

Experience

Customer Support Analyst TD Canada Trust Calgary AB Jan 2023

Utilized data-driven insights to improve customer service processes, resulting in 85% increase in customer satisfaction.

Engaged with customers through various channels to ensure their concerns were heard, understood, and addressed empathically.

Applied strong CRM skills to build and maintain positive customer relationships, resolving inquiries, and providing financial guidance.

Business Intelligence Analyst

United Bank for Africa Umuahia Abia State Nigeria Jul 2020 – Nov 2022

Created and Deployed ETL/ELT pipelines extracting data from different source systems using Azure Data Factory / SSIS.

Developed and optimized Store procedures to transform data based on business requirements using SQL.

Created and developed ETL pipelines to extract data from ERP systems, transformed based on business requirements and created.

Developed Power bi dashboards based on the company’s business requirement.

Implemented SCD1 & SCD2 on dimension tables and fact tables for Data warehousing projects.

Developed Enhancement and defects on existing Analytical models (SSAS) based on business requirements.

Liaised with business users and functional analysts to gather business requirements.

Identified the requirements and KPIs needed by the Consumers for dashboarding requirements.

Connected to multiple sources which included Azure, Snowflake, SAP, SharePoint, Oracle etc.

Utilized advanced DAX queries and Calculations to create measures needed for my dashboards.

Business Intelligence Analyst

Polaris Bank Abia State Nigeria Feb 2018 – May 2020

Used Microsoft Power Query to transform data in power BI that enabled data visualization

Created advance measures in power BI using DAX language to answer Business questions

Created reports in SSRS within Visual Studio, designing paginated reports with tables and matrices, and implementing drill-through and drill-down functionalities.

Designed interactive visualizations with defined metrics using Power BI, fostering user interaction and enabling self-service BI.

Established connections between Power BI Gateway and data sources for accurate and timely report refresh.

Created and maintained SAS, SSIS ETL packages to extract data from different systems and load large volume data into data warehouse from CSV files, Text files, Excel.

Design and Implement Ralph Kimball Methodologies slowly changing dimension (SCD) Type 1 and 2 using data flow transformation.

Utilized data modelling techniques in identifying, extracting, and analyzing business data then provided the result using data visualization and reporting tools (SSRS).

Produced source to Target mapping document for ETL framework and data load jobs.

Created Migration documents, Metadata scripts and liaised with stakeholders in deployment of new packages.

Business Intelligence Analyst

Connected GEO Solution NIG LTD Benin Nigeria Dec 2016- Nov 2017

Designed SSIS packages to extract, transform and load data (ETL) from CSV files to Staging and Production SQL Server Databases using SSIS.

Analyzed, design and create de-normalized dimension tables, fact tables and entity- relationship using SQL Server Database Diagram and Star and Snow Flake Schema Dimensional Modelling approach.

Created SQL Objects (Tables, Views, Store Procedures, functions) using MSQL scripting, and SQL database administration.

Created and reviewed master data in accordance to Data Governance and Business Stakeholders requirements.

Analyzed, designed, developed and ensured Source to Target Mapping, Transformation and Data Quality.

Wrote optimized SQL queries, data extraction scripts across multiple data sources.

Executed SSIS task to extract, transform and load data from excel files to Staging and Production SQL Server Databases using excel data source.

Created Data Warehouse for customer info based on categories for target marketing.

Education

B.S.C Economics Michael Okpara University Nigeria Sept 2013 - Jun 2017

Contact this candidate