Omphemetse Senna
Sunninghill,GP
Summary
Dynamic Data Analyst Intern with a proven track record at FirstRand Corporate Centre, adept in Python programming and optimizing SQL queries for enhanced productivity. Excelled in automating reports and improving data integrity through meticulous validation, showcasing strong analytical and problem-solving skills. Achieved significant advancements in data management and analysis, leveraging machine learning and data modeling to drive decision-making.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analyst Intern With Automation
FirstRand Corporate Centre
07.2024 - Current
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
- Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
- Developed automated SQL scripts to enable auditors to run monthly reports effortlessly, eliminating the need for manual execution.
Internal Audit: Application Control Review
FirstRand Corporate Centre
07.2023 - 06.2024
- Conducted in-depth analytics to assess the effectiveness of application controls, ensuring data integrity and reliability across systems.
- Utilized advanced data analysis techniques to identify anomalies and mitigate risks within application frameworks.
- Verified that accounting policies were consistently applied across all business units by reviewing supporting documentation during audits.
- Performed walkthroughs of key business processes to gain a thorough understanding of internal control systems in place before commencing detailed testing activities.
- Evaluated the effectiveness of IT system controls as part of integrated audits, ensuring the integrity and security of sensitive financial data.
Education
Bachelor of Science - Information Technology
North West University
Vanderbijlpark, South Africa05-2023
Skills
- Python programming
- Data cleaning
- Excel functions
- Data mining
- Optimization techniques
- Web scraping
- Machine learning
- Text Analysis Skills
- Data modeling
- Risk assessment
- SQL and databases
- ETL processes
Languages
English
Setswana
Setsotho
Sepedi
Additional Information
Project: Creating a Forecasting Airline Sentiment: A Data Science
Source: https://github.com/OmphemetseSenna-Ops/British-Airways_DataScience
Platforms and Technologies Used: Python, Machine Learning, Microsoft SQL Server, CSV, Power BI, Git and GitHub
Project: Creating a Jester - Movie Recommendation System: A Data Mining
Source: https://github.com/OmphemetseSenna-Ops/Jester-Movie-Recommendation-System
Platforms and Technologies Used: Python, Recommendation System, Apriori Algorithm, Association Rules, CSV, Git and GitHub
Project: Automated Design of SIFT for Facial Recognition: A Computer Versions
Source: https://github.com/OmphemetseSenna-Ops/Automated-Design-of-SIFT-for-Facial-Recognition-Computer-Versions
Platforms and Technologies Used: Python, Deep Learning Algorithms, Images, scale-invariant feature transform (SIFT), CSV, Microsoft SQL Server, Git and GitHub
Certification
- Assisted with the transition to a new system at FirstRand Corporate Centre, improving employee processes and overall efficiency.
- Developed a strong understanding of change management and effective communication strategies.
Accomplishments
Name: Mr. Aaqil Ismail – Internal Audit Manager (FNB)
Email: aaqilismail19@gmail.com
Mobile Number: +27 83 380 9363
Name: Ms. Tlou Sebola – Data Analyst (FNB)
Email: Tlou.Sebola@fnb.co.za
Mobile Number: +27 76 730 3805
Timeline
Data Analyst Intern With Automation
FirstRand Corporate Centre
07.2024 - Current
Internal Audit: Application Control Review
FirstRand Corporate Centre
07.2023 - 06.2024
Bachelor of Science - Information Technology
North West University
Similar Profiles
MELANIE STAINBANKMELANIE STAINBANK
Senior Business Analyst at FirstRand Corporate CentreSenior Business Analyst at FirstRand Corporate Centre
Omphemetse SennaOmphemetse Senna
Internal Audit Intern - Application Control Review at FirstRand Corporative CentreInternal Audit Intern - Application Control Review at FirstRand Corporative Centre
KGOMOTSO BELINDA KUMALOKGOMOTSO BELINDA KUMALO
Executive Personal Assistant: Group Chief Officer: Strategy & Planning at Transnet Corporate CentreExecutive Personal Assistant: Group Chief Officer: Strategy & Planning at Transnet Corporate Centre