Constance Masephula
Johannesburg
Summary
Analytical problem-solver with a strong foundation in management information systems and expertise in database management and data analysis. Leverages SQL and Excel to enhance data-driven decision-making and operational efficiency. Skilled in optimising business processes and improving system functionalities to align with company goals. Delivers collaboratively on projects while adapting to evolving technical requirements.
Overview
1
1
Certification
10
10
years of professional experience
Work History
MIS Specialist
Absa Group
Johannesburg
09.2024 - Current
- Performed queries and developed database views on SQL Server.
- Created Power BI reports to visualise key data insights, aiding decision-making.
- Generated monthly reports using SAS to track performance metrics and identify trends.
- Developed in-depth understanding of industry trends and process enhancements to inform strategic initiatives.
- Managed equipment operation to surpass production goals.
BI Developer
CCI South Africa
Umhlanga, Durban
10.2022 - 09.2024
- Cleaned and transformed data using DAX and Power Query to create insightful reports in MS Power BI.
- Transformed data using SSIS, loaded it to MS SQL Server data warehouse, and created and executed jobs for SSIS packages, including views and stored procedures.
- Executed complex queries in Transact-SQL to extract data from databases in MS SQL Server Studio.
- Developed SSRS paginated reports using Visual Studio and MS Report Builder to deliver accurate data visualisation.
Associate BI Consultant
Global Computing and Telecoms
Bryanston, Johannesburg
10.2020 - 09.2022
- Cleaned and transformed data using DAX and Power Query, developing insightful reports in MS Power BI.
- Data Transformation(ETL and ELT) - in Azure Sysnapse Analytics(Azure Data Factory).
- Data Transformation(ETL) - using MS SQL Server Integration Services (SSIS).
- Created and ran queries on a database (T-SQL) using MS SQL Server Studio to support data analysis.
- Created comprehensive documentation for standard operating procedures and business requirements. (Standard Operating Procedure & business Requirements Document).
- Developed chatbots using Bot Framework Composer, Bot Framework Emulator, and Azure Bot Services to enhance user interaction.
Software Development Learnership
Dynamic DNA
Randburg, Johannesburg
03.2020 - 02.2021
- Acquired programming skills through hands-on projects
- Applied project management skills in practical assignments to coordinate tasks
- Improved interpersonal skills through collaborative team activities
- Developed presentation skills in group settings to effectively convey ideas
IT Support Technician
Adaptris
Fourways, Johannesburg
01.2017 - 01.2018
- Recorded and tracked customer support tickets to ensure timely resolution
- Resolved customer queries to enhance user satisfaction
- System monitoring and health checks
- Executed SQL queries to extract and analyse data for troubleshooting
Web Development Intern
DST-NRF
Westville, Durban
05.2016 - 01.2017
- Developed and updated websites to enhance user experience and functionality.
- Researched relevant topics to provide informed insights for website improvement.
- Compiled reports in Microsoft Word to document findings and support decision-making.
- Maintaining server
Education
Bachelor of Science - BScHons IT:Data Science
EDUVOS
Gauteng,Midrand01-2027
Bachelor's Degree - Computer Science, Statistics and Mathematics
University Of KwaZulu-Natal
Durban, KZN01-2015
BSc4 - Mathematics, Physics, Chemistry, Biology, Communications in Science
University Of KwaZulu-Natal
Durban, KZN01-2010
Grade 12 - English FAL, SiSwati HL, Mathematics, Physical Science, Life Sciences, Geography, Life Orientation and Computer Applications Technology
Samora Machel Comprehensive School
eMpumalanga, MP01-2009
Skills
- MS Office 365
- JAVA SE8
- C
- HTML5
- Python
- CSS
- C#
- XML
- Linux
- Windows
- MacOS
- Android
- MS Power BI
- MS Report Builder
- Visual Studio 2019
- Eclipse IDE
- Netbeans IDE
- Code::Blocks IDE
- LATEX
- Microsoft SQL Server
- Azure Databases
- NoSQL
- Cosmos DB
- Oracle DB
- MySQL
- Interpersonal relations
- OO-Programming
- Teamwork
- Communication skills
- Prioritisation
- Focus
- Determination
- Positive attitude
- Willingness to learn
Certification
- PL300 - Power BI Data Analyst Associate, Present
- DP203 - Azure Data Engineer Associate, Present
- AZ900 - Azure Fundamentals, Present
- DP900 - Azure Data Fundamentals, Present
- AI900 - Azure AI Fundamentals, Present
- MS900 - Microsoft 365 Fundamentals, Present
Custom
- Ms Dessica Ramsamy, CCI SA, Durban, (+27) 82 896 6725
- Mr. Setshedi Huma, Global Computing and Telecoms, Johannesburg, (+27) 72 514 1937, setshedi@hotmail.com
- Ms. Sandy Macaulay, Dynamic DNA, Johannesburg, (+27) 83 600 9734, smacaulay@dynamicdna.co.za
Timeline
MIS Specialist
Absa Group
09.2024 - Current
BI Developer
CCI South Africa
10.2022 - 09.2024
Associate BI Consultant
Global Computing and Telecoms
10.2020 - 09.2022
Software Development Learnership
Dynamic DNA
03.2020 - 02.2021
IT Support Technician
Adaptris
01.2017 - 01.2018
Web Development Intern
DST-NRF
05.2016 - 01.2017
Bachelor of Science - BScHons IT:Data Science
EDUVOS
Bachelor's Degree - Computer Science, Statistics and Mathematics
University Of KwaZulu-Natal
BSc4 - Mathematics, Physics, Chemistry, Biology, Communications in Science
University Of KwaZulu-Natal
Grade 12 - English FAL, SiSwati HL, Mathematics, Physical Science, Life Sciences, Geography, Life Orientation and Computer Applications Technology
Samora Machel Comprehensive School