Phenyo RasefakO
Gaborone
Summary
Business intelligence professional with thorough understanding of data analysis and reporting. Known for driving meaningful insights through comprehensive data evaluation and visualization. Reliable team collaborator committed to achieving results and adapting to evolving business needs. Skilled in SQL, data warehousing, and business analytics.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst Intern
Orange Botswana
09.2023 - Current
- Developed predictive models that supported proactive decision-making in areas such as business strategy.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Automated frequently requested reports that enable end users to perform self-service and publish on the BI platform.
- Enhanced business decision-making by creating user-friendly dashboards and visualizations that communicated complex data trends effectively.
- Provided ad-hoc reports for different departments to support informed decision-making during critical situations or periods of change management.
- Designed and developed data pipelines to acquire, clean and process data for Finance department
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Collaborated with different departments to define key performance indicators and develop actionable insights from large datasets for data modelling purposes.
- Use big data technologies such as Apache Hive for data extraction and analytics for Finance, B2B, CRM and Marketing
- Maintained up-to-date knowledge of industry trends through continuous learning initiatives.
- Managed large datasets efficiently using advanced Excel functions, such as pivot tables and complex formulas.
- Gathered and documented requirements for projects.
Business Intelligence Analyst Attachee
Botswana Accountancy College
Gaborone
02.2022 - 06.2022
- Used both qualitative and quantitative analysis techniques frequently.
- Created detailed Power BI reports from student data for research and review by the development team.
- Collected data from wide-ranging sources.
- Created dashboards to monitor and track key performance indicators.
- Assisted finance, IT, quality assurance, and teaching departments and school staff to improve client satisfaction.
- Worked with IT team members on system automation and advancement initiatives.
- Collaborated with finance department to uncover revenue efficiencies among top clients to maximize opportunities to up-sell products and services.
Education
(Hons) - Business Intelligence and Data Analysis
Botswana Accountancy College
Fairgrounds, Botswana06.2022
(Hons) - Business Intelligence and Data Analysis
University Of Sunderland
Fairgrounds, Botswana06.2023
Skills
- Proficient in Python programming
- R programming
- PL/SQL
- proficient in data warehouse concepts
- Proficient in database management
- Good knowledge of Hive and Hadoop ecosystem
- Good knowledge of Power BI
- Team player
- Rapid and adaptive person
- Applied statistics and machine learning
- Business requirements gathering
- SQL programming
- Microsoft Excel
- Adaptability and flexibility
- Dashboard development
- Business process optimization
- Attention to detail
Certification
- Big Data and Hadoop Training, Edureka,
- Apache Spark and Scala Training, Edureka
- Apache Storm Professional, Edureka
- Apache Kafka Professional, Edureka
- Map Reduce Design Professional, Edureka
Timeline
Business Intelligence Analyst Intern
Orange Botswana
09.2023 - Current
Business Intelligence Analyst Attachee
Botswana Accountancy College
02.2022 - 06.2022
(Hons) - Business Intelligence and Data Analysis
Botswana Accountancy College
(Hons) - Business Intelligence and Data Analysis
University Of Sunderland
Similar Profiles
Precious Merapelo MabalaniPrecious Merapelo Mabalani
B2B Support and Administrative Executive at Orange BotswanaB2B Support and Administrative Executive at Orange Botswana
Joko Wedu TumeloJoko Wedu Tumelo
Brand Activations Coordinator at Orange BotswanaBrand Activations Coordinator at Orange Botswana
Charity Mmopelwa Nee SegokgoCharity Mmopelwa Nee Segokgo
Retail/Direct and Controlled Channels Manager at Orange BotswanaRetail/Direct and Controlled Channels Manager at Orange Botswana
Kenosi NkapeKenosi Nkape
Principal Wildlife Officer I at Department of Wildlife and National Parks, Research DivisionPrincipal Wildlife Officer I at Department of Wildlife and National Parks, Research Division
CHARITY LORATO SEMERECHARITY LORATO SEMERE
Financial Crime Risk Management Team Leader at First National Bank BotswanaFinancial Crime Risk Management Team Leader at First National Bank Botswana