Nkemakonam Mbachu, MBA

Experience

• 

  Diamond Bank Plc

  May 2012 - Sept 2015

  Personal Banking Officer
• 

  Access Bank Plc

  Oct 2015 - Jul 2022

  • Created new tables, altered existing ones, defined constraints (primary keys, foreign keys), and managed table structures.• Developed views (virtual tables), stored procedures, and functions for complex queries or frequently used tasks.• Tuned queries, optimized database structures, and understood indexing and query execution plans for enhanced performance.• Enforced data integrity through constraints and managed security permissions for users.• Performed basic administration tasks such as user management, backups, and maintenance.• Used SQL queries to generate reports or fed data into visualization tools (such as Tableau and Power BI) for creating dashboards and charts, for ease of data analysis, which aided in making informed management and business decisions.• Worked with large data sets and analyzed data using SQL, Python, and Excel.• Analysed the weekly variance reports for income and financial statements, to prepare high-level financial analyses.• Collaborated with cross-functional teams to identify key business metrics and develop data-driven solutions.• Met and exceeded 100% of annual profitability budgets.• Grew the region’s deposit volume by 103% within 2 years.• Increased the region’s loan portfolio by 237% within 2 years.• Reduced the region’s monthly expense by 29% within one year. Show less •Constructed a model that successfully reduced the ratio of NPLs (Non-Performing Loans) to less than 5%.•Reduced customer attrition rate to less than 1% monthly, significantly improving customer retention ratio.•Achieved over 91% of monthly customer acquisition budget.•Leveraged SQL and Excel for data collection, cleaning, and analysis.•Created data visualizations and dashboards to communicate insights to stakeholders.•Conducted statistical analysis and developed models to predict customer behavior.•Presented findings and recommendations to senior management, for decision making. Show less

  • Data and Database Analyst

    Dec 2019 - Jul 2022

  • Customer Relationship Management Analyst

    Oct 2015 - Dec 2019
• 

  Southern Alberta Institute of Technology (SAIT)

  Sept 2022 - now

  Database Administrator

  • Handled the modelling, ERD designing and maintaining documentation of new databases.• Migrated and validated data between relational and non-relational data sources, into the database (ETL).• Tasked with cloning, patching, backup, recovery, and performance tuning of SQL systems.• Designed and implemented a backup and recovery plan.• Developed views (virtual tables), stored procedures, cursors, common table expressions, and user-defined functions for complex queries or frequently used tasks.• Handled the task of creating schemas, user management (resetting passwords, granting access to data assets, assisting with connection issues), and overall access control management.• Involved with support and maintenance of third-party applications and collaborated with vendors and service providers.• Developed Database Forms and Reports.• Communicated findings and recommendations to non-technical stakeholders using clear and concise language. Show less