SQL & SSRS/Power BI Developer - RCI Bank
(2022-11)
- Creating stored procedures, functions, tables and other database objects from scratch in SQL Server and Sybase, in order to fix existing issues (for example, incorrect invoices and payments, rounding issues, etc) or to create new applications
- Optimising the performance of existing SQL code, fixing bugs and working with various teams to carry out tests based on the requirements of the relevant project
- Creating ETL and ELT processes via SSIS packages and creating batch scripts to automate routine jobs
- Migrating and transforming data on a daily basis from third-party databases into the SQL Server data warehouse and Sybase transactional systems
- Creating Power Bi and SSRS reports and dashboards to measure the bank's risk exposure among other parameters, based on regulatory requirements
- Creating technical specifications to document development work that needs to be done
- Ensuring the code repository is up-to-date in Git Lab
- Creating knowledge base documents to aid knowledge sharing and New Starter onboarding
- Reconciliation of financial account discrepancies and differences in invoices and payments
- Providing updates in Stand-Ups, developing and delivering fixes with an Agile approach, and liaising with Project Managers, Business Analysts and Scrum Masters in a timely manner in order to meet the Sprint's targets
- Mentoring junior developers and new starters on SQL coding standards and RCI Bank's technologies and processes
- Code reviews
Contract SQL Engineer - Firstport Property Management
(2023-03 - 2024-11)
- Building databases and database objects to house data from Property Management companies being acquired by Firstport
- Obtaining third party databases, cleaning and transforming the data by building ETL processes in SSIS and SQL Server
- Writing SQL queries to reconcile transformed data with data in the destination database/server, to ensure migration occurs without glitches
- Creating migration scripts in SQL and SSIS to output data to be migrated
- Migrating data to Salesforce
- Performance-tuning of existing SQL objects and processes in order to speed up execution time
- Creating reports in SSRS
- Documenting processes as I create them, in order to build a knowledgebase that others can easily refer to
Contract SQL & SSRS Developer - RCI Bank & Financial Services
(2017-12 - 2022-07)
- Creating stored procedures, functions, tables and other database objects from scratch in SQL Server and Sybase, in order to fix existing issues (for example, incorrect invoices and payments, rounding issues, etc) or to create new applications
- Optimising the performance of existing code, fixing bugs and working with various teams to carry out tests based on the requirements of the relevant project
- Creating ETL and ELT processes via SSIS packages and creating batch scripts to automate routine jobs
- Migrating and transforming data on a daily basis from third-party databases into the SQL Server data warehouse and Sybase transactional systems
- Creating SSRS reports to measure the bank's risk exposure among other parameters, based on regulatory requirements
- Creating technical specifications to document development work that needs to be done
- Creating knowledge base documents to aid knowledge sharing and New Starter onboarding
- Reconciliation of financial account discrepancies and differences in invoices and payments
- Providing updates in Stand-Ups, developing and delivering fixes with an Agile approach, and liaising with Project Managers, Business Analysts and Scrum Masters in a timely manner in order to meet the Sprint's targets
- Mentoring new starters on RCI Bank's technologies and processes
- Peer code review
Systems Analyst - Intelerad Medical Systems
(2016-07 - 2017-12)
- Building SQL reports/spreadsheets for internal/external customers
- Developing database components such as tables and stored procedures in SQL Server, Sybase and Postgres
- Developing reports in Power BI as requested by the relevant parties
- Monitoring Linux server and database alerts in order to catch issues before they escalate
- Writing FAQ and knowledge base documents and training new starters
Cloud Operations Data Analyst - Axioma Inc
(2015-12 - 2016-03)
- Creating and modifying risk-related stored procedures/functions in Azure SQL database
- Creating dashboards and reports for various departments using Power BI
- Building scripts in T-SQL to troubleshoot software issues and working with the Development team to resolve related bugs
- Monitoring Azure VMs and their logs, in addition to monitoring Nagios alerts and troubleshooting associated issues
SQL Developer | Support Manager - Qinec Ltd
(2013-01 - 2015-10)
- Providing technical training to my team (and external NHS customers), ensuring tickets are worked on and resolved within target times and building SQL scripts for 1st and 2nd line analysts to use
- Creating reports in MySql, T-SQL and Excel for customers, to provide a breakdown of appointments and studies, and optimizing dashboards/reports for better user experience
- Restructured the Support team and the ticketing process, which reduced the overall queue by 70% and resulted in more positive feedback from customers
- Project-managing mini projects and working with my team to deliver them within scope
- Designing databases and creating stored procedures and functions
- Customizing customers' web pages by modifying PHP/HTML/CSS code
- Documenting processes in knowledge base articles
- Manpower planning/budgeting and conducting interviews for job candidates for my team
Software Support Analyst - Hornbill Service Management Ltd.
(2011-08 - 2013-01)
- Troubleshooting software issues, carrying out user acceptance tests on new releases
- Designing SQL reports for customers
- Monitoring software logs
SQL Analyst - Contract - Epicor Software Ltd
(2011-01 - 2011-07)
- Writing SQL queries to resolve software issues on client databases and troubleshooting SQL backup issues
- Troubleshooting Crystal Report problems reported by our clients
- Assisting clients with the installation of Epicor software and troubleshooting resulting issues
- Resolving issues with bank reconciliation and other financial discrepancies
- Advising on corrective journals to post to the General Ledger
Support Consultant - Iris Software & Services
(2008-06 - 2011-01)
- Using Excel (V-lookup, Pivot tables, formulas, etc.) to reconcile discrepancies on the balance sheet, profit and loss account, trial balance, and other reports created on IRIS Accounting Software
- Training new staff on IRIS software
- Carrying out software installations and updates for clients and troubleshooting resulting issues
- Writing and publishing Knowledge base items on the company's website
Banking Officer - Triumph Bank/Ecobank
(2003-05 - 2008-01)
- Making bank transfers to other banks using SWIFT and processing staff salaries in Excel
- Creating reports on the bank's liabilities, assets and profit for submission to regulatory authorities and making MIS decisions based on the cost and revenue statistics pooled
