Lerato Lerata
Bophelong
Summary
Qualified BI developer with expertise in data modeling, ETL processes, and Power BI reporting. Committed to enhancing data accuracy and reporting efficiency, driving organizational success through effective data solutions and collaboration.
Overview
7
7
years of professional experience
1
1
Certification
Work History
BI Developer
Momentum
01.2023 - Current
- Power Bi data modeling
- Power BI Reporting (Data Visualizations)
- Created visual reports using Power BI tiles to enhance data presentation.
- Established row-level security protocols in Power BI to ensure data confidentiality.
- Power Bi dataflow and datasets
- Identifying and defining data requirements
- SQL Scripting
- ETL (data Cleansing)
- Data warehousing
- SSRS Reporting
Data\BI Analyst
ArcelorMittal
01.2021 - 01.2022
- Power BI Reporting (Data Visualizations)
- SQL Scripting
- ETL (data Cleansing)
- Implemented data integration processes to combine data from multiple sources.
- Conducted data profiling to assess data quality and integrity.
- Python scripting (Pandas&Numpy)
- APS and Supply chain Management
SQL Developer/Data Analyst
Standard bank
01.2019 - 01.2021
- Designed databases and scripted SQL to optimize data management
- Facilitated data flow through ETL processes to support analytics
- Integrated data from multiple sources to ensure comprehensive analysis
- Data modeling
- SQL Scripting
- Data Profiling
- Report writing (SSRS and power BI)
- Hive Scripting
Education
National Diploma - IT
Vaal University of Technology
01-2016
Senior National Certificate -
Tsolo secondary school
01-2011
Skills
- Power BI reporting
- Dashboard development
- SQL scripting
- SSRS reporting
- Data warehousing
- Data modeling
- ETL processes
- Data integration
- Data quality management
- Data profiling
- SQL programming
- Database design
- Python scripting
- SDLC compliance
- Attention to detail
- Problem solving
- Effective communication
- Team collaboration
- Team collaboration
Personal Information
- Gender: Male
- Nationality: Black
- Driving License: C1
Languages
- Sesotho
- Afrikaans
- English
- Sesotho
- Afrikaans
Social Links
www.fscebook/profile/LeratoLerata, https://www.linkedin.com/in/leratolerata-a046b2146/
Certification
- National Certificate in Business Analysis
Timeline
BI Developer
Momentum
01.2023 - Current
Data\BI Analyst
ArcelorMittal
01.2021 - 01.2022
SQL Developer/Data Analyst
Standard bank
01.2019 - 01.2021
National Diploma - IT
Vaal University of Technology
Senior National Certificate -
Tsolo secondary school