Mpoletsang Perceverance Lekaota
BI Developer
Potchefstroom
Summary
Highly skilled BI Developer with a track record of achieving exceptional results. Proficient in MS SQL, Relational Database Management System, T-SQL scripting, SSIS, SSAS, SSRS, and Power BI. Demonstrated leadership abilities and a collaborative approach in team settings. Equally adept at working independently on projects. Experienced in both agile and waterfall models. Excels in a self-directed environment, consistently delivering superior outcomes. Committed to leveraging my expertise in MS SQL to help organizations exceed their data-related goals.
Overview
16
16
years of professional experience
7
7
years of post-secondary education
Work History
BI Developer
FNB
Johannesburg
11.2021 - Current
- Assess own performance through seeking timely, and clear feedback and request training where appropriate Partner with team members, including Application Developers and Product Owners to minimize project delays.
- Build working relationships across teams and functional lines to enhance work delivery, collaboration, and innovation.
- Develop, encourage, and nurture collaborative relationships within the group.
- Ensure compliance to legislative and audit requirements and adherence to relevant processes.
- Extract, Transform and Load data from various sources and convert it into meaning information.
- Served as a subject matter expert for all BI-related topics, providing guidance and support to key stakeholders throughout the organization.
- Developed strategic reports for executive decision-making using advanced data visualization techniques.
- Prepared targeted documentation, specifications, and resources to analyze business data.
- Created proofs of concept for innovative new solutions.
Senior BI Developer
Britehouse
Johannesburg
07.2019 - 10.2021
- Company Overview: A division of Dimension Data
- Work closely with clients to establish problem specifications and requirements
- Partner with team members, including Application Developers and Product Owners to minimize project delays
- Follow standard practices (Azure DevOps) for migrating changes to test and production environments and provided technology support to meet business requirements
- Apply knowledge from 11 years of experience to develop custom database objects, stored procedures and application support
- Maintain complex T-SQL queries, views and stored procedures in SQL Server-database environment with little supervision
- Design and implemented TSQL queries for reporting and complex solution development
- Evaluate project requirements and specifications and develop SSRS reports that surpassed client expectations
- A division of Dimension Data
System Analyst
PPS Insurance
Johannesburg
03.2017 - 07.2019
- Daily production- ensuring that the production environment is stable by 8am and attend to any failure thereof
- Month end production - ensuring that all the month end processes run successfully by the 5th of each month
- Attending to logged service requests within the specified SLA, service requests involve mostly the creation of new reports, either CSV reports that are created via SSIS and scheduled via SQL server agent jobs or SSRS reports
- This 90% of the time involves the creation of SQL stored procedures and tables
- Attending to logged incidents within a specific SLA
- These are logged queries from business on existing data related processes or reports
- I am also responsible for various project deliverables from data perspective within the company
- Reason for leaving: An urgent requirement for flexible work
BI Consultant
Praesignins
Johannesburg
05.2016 - 02.2017
- Support ROA countries from a BI perspective
- Monitor existing data integration jobs for EOD
- Managed the full lifecycle of BI projects from requirement gathering to final implementation and post-launch support.
SQL BI Developer
JD Group
Johannesburg
12.2015 - 04.2016
- Developed complex ETL processes, ensuring accurate and timely data movement between source and target systems.
- Managed multiple concurrent projects successfully with strict deadline adherence and exceptional attention to detail.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed custom database objects, stored procedures, and delivered application support.
- Designed visually appealing reports in SSRS to provide insights into key business metrics.
SQL BI Developer
Collective Dynamics
Johannesburg
06.2012 - 11.2015
- Daily monitoring of IT (SSIS Packages) processes within the company
- Daily policy premium collections (NAEDO system)
- Report design and development (excel)
- Data extraction requests (T-SQL)
- Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
- Created models and templates for new business.
SQL Developer
Incredible Connections
Johannesburg
04.2011 - 05.2012
- Build and maintain SQL scripts, indexes and complex queries for data analysis and extraction.
- Ensure best practices are applied and integrity of data is maintained through security, documentation and change management
- Creating and designing Crystal reports
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Participated in regular status meetings with project stakeholders to provide updates on progress and address any concerns or feedback promptly.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with the application.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Optimized server resource usage by monitoring performance metrics and making necessary adjustments to SQL Server configurations.
- Maintained complex T-SQL queries, views, and stored procedures in MS-SQL database environment with little supervision.
Data Administrator
Collective Dynamics
Johannesburg
05.2009 - 03.2011
- Creating and modifying existing DTS packages (Data integration)
- Creating excel reports
- Resolving data related queries
- Writing simple to complex T-SQL queries
- Creating Stored procedures, triggers, functions and views
- Collaborated with IT professionals to design, implement, and maintain secure database systems for sensitive information storage and data integration.
- Collaborated with stakeholders across various departments to gather requirements and develop tailored database solutions that met specific business needs.
- Checked records for accuracy and completeness, and corrected errors.
Education
Matric -
Itshupeng Secondary School
Northwest, South Africa 01.2003 - 12.2003
National Diploma -
Oval College
Johannesburg, South Africa 01.2004 - 12.2006
MCDBA -
IT Business Campus
Johannesburg, South Africa 01.2009 - 03.2009
Bachelor of Commerce - Information Technology Management
Mancosa
Johannesburg 01.2025 - 12.2027
Skills
Business intelligence tools
Performance tuning
Data modeling
Interpersonal skills
Professionalism
Written communication
Continuous improvement
Database programming
Agile
Big data technologies
Dashboard creation
Data warehousing
SQL programming
ETL development
Report design
Personal Information
ID Number: 8507020873085
Timeline
Bachelor of Commerce - Information Technology Management
Mancosa
01.2025 - 12.2027
BI Developer
FNB
11.2021 - Current
Senior BI Developer
Britehouse
07.2019 - 10.2021
System Analyst
PPS Insurance
03.2017 - 07.2019
BI Consultant
Praesignins
05.2016 - 02.2017
SQL BI Developer
JD Group
12.2015 - 04.2016
SQL BI Developer
Collective Dynamics
06.2012 - 11.2015
SQL Developer
Incredible Connections
04.2011 - 05.2012
Data Administrator
Collective Dynamics
05.2009 - 03.2011
MCDBA -
IT Business Campus
01.2009 - 03.2009
National Diploma -
Oval College
01.2004 - 12.2006
Matric -
Itshupeng Secondary School
01.2003 - 12.2003