Ofentse Nkitseng
Data Analytics And Business Intelligence
Gaborone,Botswana
Summary
I am a highly skilled Data Analytics and Business Intelligence professional with over a decade experience across data analysis, exploration and presentation. I pride myself in achieving tangible results and cross-team collaboration. I am proactive and always excited to partner with like-minded individuals to achieve goals.
Overview
12
12
years of professional experience
1
1
Certification
Work History
MIS Manager
Bank Gaborone
Gaborone, Botswana
03.2023 - Current
- Developed the Revenue Leakage report. It is a powerful tool for identifying areas where the business is losing money or missing out on potential revenue. Examples are incorrect pricing, inaccurate pricing, uncollected fees or interest, fraudulent activity such as unauthorized charges.
- Produced a monthly Impairment (ECL) report.
- Developed Performance dashboards for Retail, Treasury and Wholesale Banking and presented it on Power BI.
- Developed actuals against targets reports for Retail and Wholesale Banking by salesperson and branch.
- Developed the Arrears report. This report provide insights into the health of the loan portfolio and identify potential risks and areas of improvement.
- Motivated for Power BI to be adopted as a visualisation and reporting tool.
- Produced adhoc and standing Regulatory reports for among others Bank of Botswana, IMF, SADC, FIA etc.
- Audit Reporting
- Collaborated with the Data Engineering team to come up with a customer 360 model. This is a single view of all customer interactions and information.
- Developed a client profitability report. It shows the amount of revenue each customer generates.
- Training colleagues on business intelligence tools e.g Excel, Power BI, SQL
- High level reporting
- Participate in various projects within Business
Data & MI Analyst
Absa Bank Botswana
Gaborone, Botswana
08.2018 - 03.2023
- Driving the automation of Data and MI strategy
- Enabling performance management by producing scorecards
- Training and onboarding stakeholders or colleagues on the usage of data tools like excel, Tableau, Power BI, C360
- Regulatory reporting
- Enable Balance sheet target attainment through Portfolio and Segmental balance sheet reporting at Retail
- Digital channels utilization reports
- Branch performance reports
- GoAML reports
- Fraud and Financial crime reports
- Exceptions reports
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
- Developed tables, views and materialized views using SQL.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Created and improved intelligence resources to facilitate consistent data management strategies.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Trained employees on software to improve data management, monitored use and suggested improvements.
Collections and Recoveries Data and MI Analyst
Absa Bank Botswana
Gaborone, Botswana
02.2016 - 07.2018
- Used wide variety of financial analysis tools to examine customers for potential risk via liquidity, leverage ratios and forecasting trends.
- Prepared reports on current findings and actions taken for accounts under investigation.
- Reviewed files to select delinquent accounts for collection efforts.
- Compiled and analyzed data for review by senior management of loan loss reports to measure portfolio performance.
- Identified issues, analyzed information and provided solutions to problems.
- Carried out day-day-day duties accurately and efficiently.
- Developed a weekly flash showing performance trends
- Supporting portfolio managers and team members with relevant data to improve collection efforts
- Produced a daily delinquency report
Consumer Data and MI Analyst (Intern)
Barclays Bank Of Botswana
Gaborone, Botswana
05.2015 - 01.2016
- Compiled, cleaned and manipulated data for proper handling.
- Ran data analysis reports and distributed to management staff.
- Identified, analyzed and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.
- Cleaned up and backed up data to maintain data integrity during extraction, manipulation and processing.
- Developed the MI framework for the Cards Issuing and Acquiring function
- Produced daily, weekly and monthly sales performance reports
- Produced the Retail scorecard
- Produced daily, weekly and monthly Card reports for example: Spend analysis, Balance sheet and portfolio performance
- Point of sale (POS) performance reports
Retail Risk Data and MI Intern
Barclays Bank Botswana
Gaborone, Botswana
05.2013 - 05.2015
- Data mining using Teradata SQL
- Analyzing through the door applications and tracking the portfolio lead and lag indicators
- Carrying out vintage analysis on monthly basis on key customer segments and providing feedback to the Risk team on the high risk segments
- Profitability analysis and development of triggers for unsecured loans, mortgages, SME loans and Barclay card.
- Developed monitoring packs and MI to manage portfolios effectively ensuring process compliance as per policy guidelines
- Participated in forecasting and providing analysis required to make informed decisions
- Participated in workday meetings to establish month end impairment forecasts and understanding impairment drivers
National Strategy Officer Intern
Botswana Government
Tonota, Botswana
01.2013 - 01.2013
- Worked directly with management to brainstorm, discuss strategy and mitigate all village development issues.
- Conducted research across hospitals, schools and other government entities in the region
- Analyzed findings and relayed them to top officials
Operations Manager
Worldwide Commodities (FMCG)
Tonota , Botswana
07.2012 - 12.2012
- Led warehouse improvement initiatives to advance operational efficiencies and increase revenue.
- Investigated and resolved departmental non-conformances.
- Reduced financial inconsistencies while assessing and verifying billing invoices and expense reports.
- Updated and resolved incidents and managed accessorial charges objectively while maximizing profit.
- Monitored daily cash discrepancies, inventory shrinkage and drive-off.
- Drafted invoices for completed work.
Education
Bachelor Of Business Administration - Business Management
University of Botswana
Gaborone, Botswana10.2012
Skills
Data analysisPower user of ExcelTableauPower BISQLDenodoHadoopTeradataPostgres
Proficient with Microsoft Stack
Excellent planning and organizational skills, ability to prioritize my time and workload to meet deadlinesGood People skillsAccomplishments
- Automation of manual reports.
- Train colleagues on Business Intelligence tools like Excel and Power BI.
- Using Power query for data transformation.
- SQL query optimisation.
- Scheduled reports on Power BI report server to automatically refresh to address issues of turnaround time and self service.
Additional Information
- SQL training certificate
- Power BI training certificate
- Microsoft Excel Training Certificate
Certification
Microsoft Power BI Data Analyst
Timeline
Microsoft Power BI Data Analyst
01-2024
MIS Manager
Bank Gaborone
03.2023 - Current
Data & MI Analyst
Absa Bank Botswana
08.2018 - 03.2023
Collections and Recoveries Data and MI Analyst
Absa Bank Botswana
02.2016 - 07.2018
Consumer Data and MI Analyst (Intern)
Barclays Bank Of Botswana
05.2015 - 01.2016
Retail Risk Data and MI Intern
Barclays Bank Botswana
05.2013 - 05.2015
National Strategy Officer Intern
Botswana Government
01.2013 - 01.2013
Operations Manager
Worldwide Commodities (FMCG)
07.2012 - 12.2012
Bachelor Of Business Administration - Business Management
University of Botswana