Otshepeng O'Neal Ditshego

• Produced monthly and weekly reports using advanced Excel spreadsheet functions.
• Extracted and interpreted data patterns to translate findings into actionable outcomes.
• Identified, analyzed and interpreted trends or patterns in complex data sets.
• Designed and implemented tools to support strategic value chain optimization initiatives.
• Deployed predictive analytics models to forecast future trends.
• Created data visualizations using PowerBI to present and explain complex data sets in order to provide actionable insights
• Automated data imports from various sources such as CSV and Excel files, web-based applications, API's and SQL Databases in order to provide automated reports and PowerBI Dashboards
• Collaborated with stakeholders to identify business needs and data sources.

Achievements

I managed to create and automate the Service Level Agreement dashboard that focused on tracking logged faults and providing the regions with insights into which faults are in jeopardy of violating the Service Level Agreement with customers. The dashboard improved KPI's by 5%, resulting in a reduction of escalations and improvement on overall customer satisfaction.

• Collaborated with other developers to produce end-to-end Business Intelligence solutions
• Developed, automated and managed PowerBI Dashboards in order to provide frequent and timely insights with little human interaction
• Collected and documented business needs and requirements, ensuring that user specifications and requirements are available during development and testing of business intelligence solutions and that users needs are satisfied
• Queried SQL Server databases to produce ad-hoc reports and also provide web developers with queries to feed web-based applications with requested data
• Maintained SQL Servers and databases with use of stored procedures and triggers to ensure databases were up to date and maintaining overall server health
• Implemented security measures to protect vital business data.
• Produced dashboard user guides to assist users how to best utilize dashboards in order to gain significant value from them
• Trained other developers and users on development of PowerBI Dashboard and functionalities

Achievements

• Supervised team of 3 developers in order to provide end-to-end solution to CAPEX reporting. I was tasked with validating figures, testing web-based application functionalities, recommending modifications and standards; and to create and maintain CAPEX database; develop, test and automate CAPEX dashboard. Received Spotlight award for all our efforts.
• Developed and automated FTTH Value Chain dashboard which identified bottlenecks in FTTH Order Fulfillment Value Chain to improve delivery on outstanding orders. Dashboard managed to improve waiting time for order installation from average of 7 days down to 4 days. Received Spotlight award in recognition of efforts.

• 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 and 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.
• Managed over 30 dashboards, ensuring dashboards were updated regularly without error, also reducing overall downtime by 70%.

• 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.

• Prepared new hire letters, employee contracts, and corporate policies
• Answered employee inquiries regarding health benefits and retirement 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.

• 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.

Achievements

Managed to achieve over R5 000 in sales first time running the store on my own