Position: Data Analyst
Category: Data Engineer
English level: fluent
Years of experience: 5

Agency Dashboard  – Jubilee Insurance
Modelled and Developed a dashboard for the Agency Team to track on daily, monthly, quarterly and yearly basis, the number of policies sold as well as the premium collected. This assisted the management in tracking on a daily basis whether the different teams were in line to achieve the targets and implement and investigate further where more effort was needed to ensure that the monthly targets were achieved. Previously they had to wait until the end of the month for a compilation of the report on excel from the different unit managers. This has greatly improved proactive rather than reactive engagement with the different agents, unit managers and regional managers.

Reinsurance Dashboard – Jubilee Insurance
Modelled and developed a dashboard for the Reinsurance team for tracking of the premiums, commissions, paid and outstanding claims. This resulted in a drastic drop in the time taken to develop the report manually on excel to reporting available at the click of button and change the reporting from monthly to daily improving the efficiency and productivity of the team.

Corporate OMNI Channel – Co-operative Bank   
Implementation of OMNI channel platform solution as Lead data integration engineer and report developer where my role included:    
Transformation of customer data from the old system to allow for consumption in the OMNI channel platform.    
Migration of customer information from the old system to the OMNI channel system.    
Design and creation of report scripts to allow for monitoring in the OMNI platform system.   
  
VeriTouch  CRM - Microsoft Dynamics 365- Co-operative Bank   
Implementation of Microsoft Dynamics 365 VeriTouch CRM solution as a data modeller and data integration engineer. My role included:   
Modelling of data from various source systems that customer information is stored, to create a 360 view of the customer from all systems in the bank such as loans, credit cards, current accounts and saving accounts, fixed deposit accounts, internet banking, mobile banking among others.   
Development of SQL Server Integration Services Packages for the loading of a daily batch feed from the banks source systems to the CRM application database as well as automation of the same process.
Experienced Data Practitioner whereby through my studies, experience and personal initiatives, I have acquired skills in ETL development using (ODI, PowerCentre, SSIS, Pentaho, Oracle PL SQL, Google Big Query), Data Analysis using SQL Queries and Python, Data integration and Dimension modelling, Data mining, Oracle database administration, Master Data Management development, Business intelligence analysis and reporting on (OBIEE, COGNOS, POWERBI, SSRS, Tableau), Big Data Engineering, Data Warehousing among others.