MELBA JACKSON

Experience

• 

  Stanbic Bank Botswana

  May 2012 - Feb 2013

  MIS ANALYST PBB & FINACLE CORE BANKING PROJECT COORDINATOR

  • Creating daily MI reports for managers using excel worksheets/spreadsheets e.g. cash flow reports, sales dashboard and DSA tracking templates for tracking sales.• Extraction of information from the bank system (creating queries) using SQL queries that helps in the implementation of new ways to enhance sales.• Project management of the UPL loan and the leads campaign origination.• Performing data clean up on the bank systems and databases to ensure quality and validated data.• Finacle core banking project simulation and testing preparations• Creating training reports and analysing the performance of trainees and trainers for managers (finacle core banking system project)• Help desk support; assisting the trainers in troubleshooting computer and system problems regarding the new system.• Providing user training assistance to finacle users Show less

• 

  Stanbic Bank

  Mar 2013 - Mar 2019

  System Administrator-finacle Core Banking

  • Ensuring Finacle SOD and EOD/EOM, ODS processes execution to successful completion.• Restoring the database on all nodes depending on their resource allocation in preparation for DR Failover simulation.• Performing database administration and maintenance (DB schemas)tasks• Bank systems and networks 24/7 monitoring and administration through ITM system• Performing daily database restores and backups using TSM and Veritas NetBackup Systems.• IBM MQ WebSphere administration: MQFTE agents, Gateways and Brokers administration, troubleshooting Message Broker and MQFTE agents’ errors by debugging flows, checking DB configurations, checking AIX syslog, checking MQ queue depths.• Monitoring the banks systems; Applications ,Networks, Data Centre facilities( Gensets, UPS, Aircon , servers)Integration layers - MAX, MQFTE ,Connect Direct and Control M schedules through ITM Console and Alerts • Data processing and reports extraction through oracle SQL queries • Performing peripherals EOD/EOM and maintenance (HPnL, Sparrow ATM system, IBSNET system). • Assist the project team with EOD test cases /releases for the new projects.• Finacle core banking system patch deployment and batch job monitoring• Supporting and troubleshooting/resolution of Finacle core banking system issues(Finacle L2 support)• Participating and Ensuring UAT environments are up-to-date and ready for testing.• Undertake performance tuning, index generation and view creation and maintenance according to country/group requirements for production/UAT and SANDPIT testing environments.• Creation of user logins and role (in bank systems).• Ensuring response time and resolution time of the work requests raised by users through finacle front-end or back-end application.• Coordinate routine systems clean ups and other database/file management activities to ensure optimum system performance Show less

• 

  Stanbic Bank Botswana

  Apr 2019 - Jul 2023

  Manager, Data Science

  -Extracting knowledge and insights from data and use this information develop data-driven solutions to difficult business challenges.-create and build real time and batch data processing pipelines and conduct testing for the pipelines for data scientists and MI Analyst consumption as well as optimising the pipelines-performing data integration and data ingestion into our data lake-deployment of our data science models into productions-creating views and tables in our databases for easy access and analysis as I build dashboards and model for business use cases-Documentation and creating a blue print for our data models as per each business use case-Usage of analytical , statistical, and programming skills to manipulate data and draw insights from large datasets.-Develop custom data models and ML algorithms to apply to datasets using statistical computer languages (R, Python, SQL, etc) to build machine learning models.-Data visualisation using power Bi and Power Apps to make web applications, dashboards for business.-created a CRM data science model applications using power apps for business and client engagement and data capturing-performing data culture and awareness campaign that teaches employees the importance of data and how data can be used-Project lead for the salesforce data integration ; data profiling and data mapping from source as per scope, scope,defining API standards and integration patters, ensuring data quality and preparing data for migration-Conducting UAT and training of business/users of the developed ML models-implementation of the banks data strategy and driving the banks digital transformation-Business analytics : Use predictive modelling to increase and optimise customer experiences, revenue generation and other business outcomes.-Assess the effectiveness and accuracy of new data sources and data gathering techniques.-Knowledge and experience in Natural Language Processing; text mining, social network analysis, etc. Show less

• 

  Debswana Diamond Company

  Aug 2023 - now

  Data Engineer