Otshepeng O'Neal Ditshego
Pretoria
Summary
Efficient and proactive professional with 6+ years of experience and a proven knowledge of SQL, Oracle, PowerBI and Data Analysis, aiming to leverage skills to successfully become a Data Scientist. Currently seeking and maintaining a full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills as well as opportunities to collaborate.
Overview
8
8
years of professional experience
Work History
Operational Specialist: Network Quality Management
Openserve
Centurion, GP
02.2021 - 03.2023
- Creation of Fault Monitoring tools to provide weekly and monthly Service Level Agreement reports
- Developing tools and systems for integration of multiple reports
- Creation of report automation tools using Python, C# and SQL
- Development and management of databases on MySQL and SQL Server
- Creation, management and automation of PowerBI Dashboards to provide data insights and analysis on operational, managerial and executive levels
- Development of tools for measuring Key Performance Indicators
- Collecting, compiling, interpreting and documenting user specifications for projects.
- Conducted root cause analysis in deficient areas to identify and resolve issues.
- Gathered, organized and input information into digital database.
- Generated reports detailing findings and recommendations.
- Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
- Service Level Agreement reports managed to ensure that Targets were met and reduced Not Met services to less than 2% per week
Database Administrator: Database Management
Openserve
Centurion, GP
11.2019 - 01.2021
- Test programs or databases, correct errors and make necessary modifications
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Train users and answer questions
- Specify users and user access levels for each segment of database
- Synthesize current business intelligence or trend data to support recommendations for action
- Analyze competitive market strategies through analysis of related product, market, or share trends
- Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs
- Disseminate information regarding tools, reports, or metadata enhancements
- Manage timely flow of business intelligence information to users
- Provide technical support for existing reports, dashboards, or other tools
- Collect business intelligence data from available industry reports, public information, field reports, or purchased sources.
- Created and updated database designs and data models.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Designed and developed analytical data structures.
- Modified databases to meet needs and goals determined during planning process.
- Coordinated with project management on database development timelines.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Implemented security measures to protect vital business data.
- Developed and managed FTTH Value Chain dashboard. Reduced waiting time for Order Fulfillment from 7 days to 4 days resulting in overall customer satisfaction.
Business Intelligence Apprentice
Openserve
Centurion, GP
05.2018 - 10.2019
- Analyze technology trends to identify markets for future product development or to improve sales of existing products
- Disseminate information regarding tools, reports, or metadata enhancements
- Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs
- Maintain or update business intelligence tools, databases, dashboards, systems, or methods
- Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends
- Create or review technical design documentation to ensure accurate development of reporting solutions.
- Collected data from wide-ranging sources
- Developed and implemented data governance policies and procedures
Internship: Business Intelligence
Openserve
Centurion, GP
01.2017 - 02.2018
- Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders
- Conduct or coordinate tests to ensure that intelligence is consistent with defined needs
- Maintain or update business intelligence tools, databases, dashboards, systems, or methods.
- Analyzed problems and worked with teams to develop solutions.
- Developed and maintained relationships with key internal stakeholders.
- Explored new technologies and approaches to streamline processes.
- Prepared project presentations and reports to assist senior staff.
- Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
- Handled massive quantities of business intelligence data, personally managing as much as 5 terabytes
Learnership: Human Resources Administrator
Coca Cola Beverages South Africa (prev. ABI Bottling Pty(Ltd))
Pretoria West, GP
02.2016 - 12.2016
- Prepared new hire letters, employee contracts, and corporate policies.
- Answered employee inquiries regarding health benefits and 401k options.
- Oversaw hiring, staffing, and labor law compliance.
- Handled on-boarding process for newly hired employees, which included distribution of all paperwork.
- Updated HR database with new employee information, changes in benefits, and other details.
- Managed employee data and privacy to keep employee data confidential per organizational privacy policies.
- Monitored safety and health practices to protect employees from hazards and promote healthy work habits.
- Coordinated technical training and personal development classes for staff members.
- Streamlined HR efficiencies, coordinated new hire orientations and provided onboarding and training for new employees.
- Managed payroll and timekeeping to track hours and accurately pay employees.
- Developed and implemented onboarding and orientation programs for new employees.
- Developed and monitored employee recognition programs.
- Partnered with departmental managers to ascertain hiring needs and subsequently provide candidate recommendations.
- Administered employee benefits programs and assisted with open enrollment.
- Generated and analyzed reports to monitor employee engagement and attrition trends.
- Assisted with writing job postings and job descriptions for boards.
General Assistant
Denver Auto Spares
Pretoria, GP
03.2015 - 12.2015
- Responded to telephone, email and in-person customer inquiries
- Reviewed files, records and other documents to obtain information to respond to requests.
- Kept office supplies well organized and sufficiently stocked, placing orders promptly to replenish materials before depleted.
- Informed and supported business leaders through consistent communication and administrative support duties.
- Supported staff on special assignments and ad hoc projects.
- Input data into spreadsheets and databases.
- Utilized office management software to record and track customer information.
Education
Bachelor of Information Science In Information Science -
UNIVERSITY OF PRETORIA
Pretoria, Gauteng12.2014
High School Diploma -
WALLMANSTHAL HIGH SCHOOL
Pretoria, Gauteng12.2010
Skills
- ETL
- MS Office
- DAX
- SQL Server
- MySQL
- Python
- Oracle
- C#
- Java
- PowerBI
- Power Apps
- Power Automate
- Azure
- Data Modelling
- Analytical Techniques
- Project Management
- SSIS
- Risk Management
- Quality Assurance
- Customer Relations
- Project Planning
- Project Management
References
References available upon request
Timeline
Operational Specialist: Network Quality Management
Openserve
02.2021 - 03.2023
Database Administrator: Database Management
Openserve
11.2019 - 01.2021
Business Intelligence Apprentice
Openserve
05.2018 - 10.2019
Internship: Business Intelligence
Openserve
01.2017 - 02.2018
Learnership: Human Resources Administrator
Coca Cola Beverages South Africa (prev. ABI Bottling Pty(Ltd))
02.2016 - 12.2016
General Assistant
Denver Auto Spares
03.2015 - 12.2015
Bachelor of Information Science In Information Science -
UNIVERSITY OF PRETORIA
High School Diploma -
WALLMANSTHAL HIGH SCHOOL
Similar Profiles
LERATO LEGODELERATO LEGODE
Functional Specialist Administrator at OpenserveFunctional Specialist Administrator at Openserve
Otshepeng O'Neal DitshegoOtshepeng O'Neal Ditshego
Operational Specialist: Network Quality Management at OpenserveOperational Specialist: Network Quality Management at Openserve
Norman MashimbyeNorman Mashimbye
Fiber-optics-technician at OpenserveFiber-optics-technician at Openserve
Emmanuel BloseEmmanuel Blose
FTTH Technician at OpenserveFTTH Technician at Openserve
THEMBINKOSI VINCENT MDLULITHEMBINKOSI VINCENT MDLULI
Constable at South African Police ServiceConstable at South African Police Service