Piano playing
Ofentse Nkitseng
Business Intelligence
Gaborone,Botswana
Summary
Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Motivated and results-driven Data Analyst with proven track record in data analytics and process mapping. Identifies business needs and develops valuable solutions to improve accuracy and process optimization. Drives business success with recommendations based on data findings.
Dedicated and motivated data analyst with proven skill driving process and data integrity improvements. Over nine years of experience leading teams in data mining and data warehousing solutions. Exceptional skill in SQL-based environments.
Enthusiastic Data & MI Analyst and dedicated employee with integrity, strong work ethic and great leadership skills. Over nine years of experience building revenues, improving processes and driving business growth through periods of ranging market health. Exceptionally aware of early warning signs of economic downturn with strategic adaptability.
Overview
12
12
years of professional experience
4
4
years of post-secondary education
2
2
Languages
Work History
Data & MI Analyst
Absa Bank Botswana
Gaborone, Botswana
08.2018 - Current
- 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, Botswana 08.2008 - 05.2012
Skills
Data analysis
Accomplishments
- Automated the Remediation rate template from excel to Power BI
- Actively training colleagues on excel to simplify tasks that take a long time by teaching them vlookup, pivots tables, inserting slicers, creating charts etc
- Provide assistance with non standard data which is normally collected manually by checking, cleaning and structuring it
Interests
Farming
Traveling
Timeline
Data & MI Analyst
Absa Bank Botswana
08.2018 - Current
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
08.2008 - 05.2012
Similar Profiles
Johanna Tsholofelo BakwenaJohanna Tsholofelo Bakwena
Customer Due Diligence Officer at ABSA Bank BotswanaCustomer Due Diligence Officer at ABSA Bank Botswana
Kabo BusanangKabo Busanang
Engineering and Facilities Specialist at ABSA Bank BotswanaEngineering and Facilities Specialist at ABSA Bank Botswana
Thato SebegoThato Sebego
Head of Product Development and Implementation at Absa Bank BotswanaHead of Product Development and Implementation at Absa Bank Botswana