Ayanda Shabalala

Experience

• 

  Mangosuthu University of Technology

  Jan 2013 - Nov 2013

  Peer Educator

  Summary: Peer Health Educators are students who provide outreach health education to MUT students. As a team, candidates will develop, present, and evaluate health education programming Qualifications: Strong interest in preventive health Desire to have fun and “make a difference” on campus Ability to think outside the box Excellent oral and written communication skills Ability to handle a variety of tasks, with good time management skills Ability to work some evenings and weekendsDuties and Responsibilities:Complete required training and periodic training updates Commit to at least 2 (two) semesters as a Peer Health Educator Plan and develop health education programs and events incorporating various learning techniques and formats (lectures, group discussions, role playing, skits, etc.) Participate in the development and design of passive health education programming (newsletter, bulletin boards, brochures, web page, etc.) Attend weekly staff meetings Develop and distribute program assessment tools and evaluate assessment data Network with faculty and other campus professionals in creating opportunities for student health education programming and preventive health messages Assist in development and promotion of health awareness days/weeks (Breast Cancer awareness, Great Talk show, World Aids day, Alcohol Awareness Week, etc.) Perform other duties as assigned Benefits: Gain valuable personal and professional experience, including references Improve organizational and time management skills, leadership potential, and public speaking abilities Become part of a fun and challenging team experience! Meet lots of new people Have a chance to make a difference is someone’s life Show less

• 

  Mangosuthu University of Technology

  Jun 2014 - May 2015

  Tutor

  Duties• Deliver high-quality and engaging training and support in Java and C# students to ensure that all students become familiar with programming languages by the end of the first year • To support the Senior Lecturer in delivering other aspects of Information Technology Software Development Stream.• To retain the learners engaged on the programme and manage their learning and achievement in line with the targets and objectives agreed in their Individual Learning Plan• To ensure all associated learner processes are followed in an accurate and timely manner.• Deliver high quality teaching and learning to individuals and groups• Contribute to improvements to the Scheme of Work, Lesson Plans, teaching and learning materials and resources to meet the qualification requirements.• Complete regular, meaningful and accurate Learner Reviews, linking with the Individual Learning Plan and the Learner Portfolio, to ensure the learner fully understands achievements, objectives and where they are within the Framework. Skills Obtained• Experience of developing software and web applications using C# • Experience of developing software using JAVA.• Excellent knowledge of the full software development lifecycle• Excellent and demonstrable knowledge of software development using C#, .NET and Java• Understanding of equality and diversity issues• Excellent communication skills• logical thinking and passion to achieve• Ability to deliver lively, practical and engaging teaching and learning sessions• Ability to identify and help learners to overcome potential barriers to learning, progress and achievement Show less

• 

  Gijima

  Jul 2015 - Mar 2016

  Software Developer Internship

  PL/SQL Developer and Database Oracle 11gResponsibilities:Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL and Hierarchical databases like Oracle and Access. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied. Work in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.Involved in Logical & Physical Database Layout Design. Set-up and Design of Backup and Recovery Strategy for various databases.Performance tuning of Oracle Databases and User applications.Provided user training and production support.Improved the performance of the application by rewriting the SQL queries.Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports. Show less

• 

  Hulamin

  Jul 2015 - Mar 2016

  Application Developer Internship

  PL/SQL Developer and Database Oracle 11gResponsibilities:Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL and Hierarchical databases like Oracle and Access. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied. Work in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g.Involved in Logical & Physical Database Layout Design. Set-up and Design of Backup and Recovery Strategy for various databases.Performance tuning of Oracle Databases and User applications.Provided user training and production support.Improved the performance of the application by rewriting the SQL queries.Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports. Show less

• 

  BUILDING INDUSTRY BARGAINING COUNCIL

  Dec 2020 - Jan 2022

  • Unisys Mapper Business Information Server (BIS) and Rapid Applications Development Studio (RADS)• Ability to maintain the production Unisys BIS (MAPPER) system, identify, analyze, and resolve issues minimizing user downtime• Experience in data report handling and processing• Translating business needs into technical specifications.• Develop reporting systems that provide accessible information.• Warehouse data to create reports to support business performance. • Maintaining data analytics platforms.• Evaluating and improving existing Report systems.• Generating and delivering quality reports to customers and perform quality assurance checks on report.• Develop and execute database queries and conduct analyses.• Experience in MAPPER administration utilizing the Native Environment, PCMA (Admin Shell) and the MAPPER Administrator Tool.• Ability to develop, test, and debug enhancements to the existing Unisys BIS (MAPPER) system.• Ability to communicate project status and timelines with team members and management staff Show less Create dashboards and interactive visuals reports using Power BI.Create relationships between data and develop tabular and other multidimensional data models.Analyzing data and present data through reports that aid decision-making. Good in programming DAX queries in Power BI desktop.Good in using advance level calculations and transformations on the dataset. Understand the business requirements and develop data models accordingly.Knowledge in developing custom visuals for Power BI. Show less

  • Information Technology Programmer

    Mar 2016 - Jan 2022

  • Power BI Developer

    Dec 2020 - Dec 2021
• 

  National Institute for Communicable Diseases (NICD)

  Jan 2022 - Jun 2022

  Data Manager

  ■ Manage, maintain, and update surveillance and research study databases within designated NICD Centres ■ Manage and develop data staff members so that they acquire the skills required for optimal performance ■ Compile and automate standard & ad-hoc reports, graphs, tables and spreadsheets for data distribution ■ Perform daily backup and security for databases and ensure that data can be easily retrieved ■ Perform data audits as and when required ■ Develop data collection tool to ensure effective capturing of information /data ■ Ensure all fields in data collectionforms match those in the database ■ Oversee the technical aspects of electronic data collection tools ■ Maintain quality and strict confidentiality of information collected ■ Contributes to the recruitment and selection process of new data staff members ■ Develop new databases for projects as required ■ Contribute to the development and implementation of standard operating procedures for the use and acquisition of database tools and the protection of confidential information ■ Oversee the development and maintenance of a filing system for all studies ■ Set up and run data cleaning programmes for logical data checking which will then generate error reports or queries requiring validation.■ Liaise with surveillance sites and laboratory staff concerning data queries and manage the flow of queries to improve the quality of data ■ Provide clean, good-quality datasets available for quarterly analysis■ Ability to draw required datasets for analysis ■ Participate in epidemiologic research related to surveillance data.Skills: Microsoft Power BI · SQL Server Reporting Services (SSRS) · Extract, Transform, Load (ETL) · Microsoft Excel · VBA Excel · SQL Server Integration Services (SSIS) · Microsoft SQL Server · Stata · R · Python Show less

• 

  Old Mutual Wealth

  Jun 2022 - Oct 2022

  Senior Business Intelligence Analyst

  Skill and Responsibilities: ■ SQL Programming ■ Knowledge of Financial Services ■ Knowledge of Data structures ■ Advanced level in Power BI and PowerBI Report Builder ■ Experienced with advanced DAX measures and calculated columns/tables ■ Experienced with security principles in Power BI (Row-level Security, Dynamic security, etc.) ■ Good understanding and experience with data warehouse design and dimensional modeling ■ Experienced with data visualization best practices■ Experienced with requirements gathering in complex environments Tools:■ SQL Server Reporting Services (SSRS) ■ SSIS■ ETL■ MySQL■ Power BI ■ Microsoft Excel ■ Agile / Scrum - Kanban Show less

• 

  National Institute for Communicable Diseases (NICD)

  Nov 2022 - now

  Data Manager

  ■ Manage, maintain, and update surveillance and research study databases within designated NICD Centres ■ Compile and automate standard & ad-hoc reports, graphs, tables and spreadsheets for data distribution ■ Perform daily backup and security for databases and ensure that data can be easily retrieved ■ Develop data collection tool to ensure effective capturing of information /data ■ Ensure all fields in data collection forms match those in the database ■ Oversee the technical aspects of electronic data collection tools ■ Maintain quality and strict confidentiality of information collected ■ Contributes to the recruitment and selection process of new data staff members ■ Develop new databases for projects as required ■ Contribute to the development and implementation of standard operating procedures for the use and acquisition of database tools and the protection of confidential information ■ Oversee the development and maintenance of a filing system for all studies ■ Set up and run data cleaning programmes for logical data checking which will then generate error reports or queries requiring validation (ie ensure all dates correlate admin, collected, outcompete, dob, etc; ensure all sex-related questions tie together no pregnant men; ensure death questions match the outcome of death; and other outliers of numbers, observations, etc) ■ Liaise with surveillance sites and laboratory staff concerning data queries and manage the flow of queries to improve the quality of data ■ Provide clean, good-quality datasets available for quarterly analysis ■ Ability to draw required datasets for analysis ■ Participate in epidemiologic research related to surveillance data.Skills: Microsoft Power BI · SQL Server Reporting Services (SSRS) · Extract, Transform, Load (ETL) · Microsoft Excel · VBA Excel · SQL Server Integration Services (SSIS) · Microsoft SQL Server · Stata · R · Python Show less