Learn Data Skills
Beta
Tshepo Lenkgwete Masemola

Tshepo Lenkgwete Masemola

Data Analysis

Payspace

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

Statistical poet, weaving elegant stories with the threads of data.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Joining Data in SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

PaySpace | Oct 2022 - Present

Reports Developer

Utilizing DevExpress reporting tools, create and build reports that adhere to business objectives and specifications. Collaborate with cross-functional teams and stakeholders to establish important performance indicators, comprehend data sources, and collect report needs. Implement and maintain Agile processes to guarantee timely and effective report delivery. Use cloud storage, retrieval, and processing services like Microsoft Azure and others to prepare data for reporting. Extract and analyze data using Microsoft tools like SQL Server and SSRS to meet reporting requirements. To retrieve and manipulate data for reporting, create intricate SQL queries, and improve database efficiency. Utilizing Git or other version control systems, cooperate on the construction of reports. Troubleshoot and resolve issues related to report generation, data quality, and performance. Collaborate with team members to ensure seamless integration of reports with existing systems and applications. Stay up to date with industry trends and best practices related to reporting, data visualization, and database queries.
Show More

Rentoza | May 2022 - Sep 2022

Data Engineer

Design, develop, and maintain scalable data pipelines, data warehouses, and data processing systems using technologies such as Python, SQL, ETL tools, and cloud platforms like Google Cloud Platform (GCP) and Amazon Web Services (AWS). Design and implement data models that ensure data integrity, performance, and scalability, and optimize database structures for efficient data retrieval and storage. Plan, coordinate, and carry out data engineering projects, making that delivery is timely, resources are allocated effectively, and project deadlines are followed. For the purpose of ingesting, manipulating, and loading data from diverse sources, create and maintain end-to-end data pipelines that guarantee the accuracy, consistency, and dependability of the data. Work with large-scale, intricate data sets, including both structured and unstructured data, and process and analyze them using distributed computing frameworks like Apache Spark. For the purpose of ingesting, manipulating, and loading data from diverse sources, create and maintain end-to-end data pipelines that guarantee the accuracy, consistency, and dependability of the data. Design, optimize, and manage databases to ensure efficient data storage, retrieval, and querying, utilizing technologies such as SQL, relational databases, and NoSQL databases.

ArcelorMittal | Aug 2020 - May 2022

Junior Specialist

Conduct data analysis tasks using various tools and techniques to identify trends, patterns, and insights from large datasets. To successfully explain findings, use statistical tools and data visualization strategies. Develop and maintain data models that capture the structure, relationships, and constraints of the organization's data. Ensure data integrity, normalization, and optimization for efficient data retrieval and analysis. Create, manage, and optimize databases among other database management duties. Write complex database queries using SQL to retrieve and manipulate data efficiently. Utilize tools like Microsoft Power BI to create aesthetically appealing and interactive dashboards, reports, and presentations that highlight critical insights and aid with data-driven decision-making. Participate in projects involving data analysis, working with cross-functional teams to establish project objectives, deliverables, and deadlines. Participate in project monitoring, reporting, and planning to ensure successful project outcomes. To improve productivity and streamline data analysis workflows, identify and resolve data-related problems, troubleshoot technological problems, and offer original ideas. Keep clear and concise notes of the steps you took, the methods you used, and the results of your data analysis. Make sure the essential paperwork is current and available to the team and stakeholders.

Rand Merchant Bank | Jul 2019 - Jun 2020

Software Developer

Design, create, and test software solutions in conjunction with the development team using Agile methodology. Use Microsoft tools to create and maintain software programs, such as Visual Studio and SQL Server. To design and use REST APIs for data retrieval and manipulation, apply the Representational State Transfer (REST) principles. For version management, branching, and merging code changes, use GitHub and Git. Write C# and TypeScript code that is clear and effective while adhering to coding standards. To design user-friendly and responsive web interfaces, utilize HTML, CSS, and Bootstrap. In order to efficiently store and retrieve application data, design and manage databases using SQL. Develop and improve web applications with the team using AngularJS and the.NET Framework. Adapt to changing project requirements and prioritize tasks to meet project deadlines. Continuously learn and improve technical skills by staying up-to-date with industry trends and advancements in software development.

My Education

Take a look at my formal education

FirstRand Youth Development Graduate Programme GIBS Business School (Gordon Institute of Business Science) | 2020
Bachelor of Science (BSc), Computer Science and StatisticsUniversity of Limpopo | 2018
National Senior Certificate Ithemba Institute of Technology | 2011

About Me

Tshepo Lenkgwete Masemola

As an intermediate data analyst/reports developer, I have a strong foundation in data analysis, visualization, and reporting. I am skilled in extracting, cleaning, and analyzing data from various sources to uncover valuable trends and patterns.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free