Experience

Pinnacle Micro

• 1 - 100 Employee

• Business Intelligence Developer

  • Mar 2019 - Present

  • Translating business needs to technical specifications • Designing, building and deploying BI solutions, establishing, implementing and overseeing effective systems, processes and controls • Customer service and liaison, building strong working relationships and effective communication channels with key stakeholders, resolving complaints and enquiries • Maintaining and supporting data analytics platforms • Creating tools to store data such as OLAP cubes • Conducting unit testing and troubleshooting • Evaluating and improving existing BI systems • Collaborating with teams to integrate systems • Developing and executing database queries and conducting analyses • Creating visualisations and reports for requested projects • Performing as a strong member of a cohesive team with strict adherence to statutory regulations, quality standards, governance processes and compliance requirements Show less



Pinnacle Technology Holdings Limited

• South Africa
• IT Services and IT Consulting
• 1 - 100 Employee

• Group Database Administrator

  • Jan 2013 - Feb 2019

  • Customer service and liaison, building strong working relationships and effective communication channels with key stakeholders • Resolving complaints and enquiries • Maintaining SQL servers and databases, implementing and maintaining SQL replication • Maintaining backup and recovery functions • Supporting and maintaining data warehousing • Capacity planning including data cleanups, archiving and drive size increases • Change control management and impact analysis • Data modelling and database design • Managing and supporting application integration • Developing and maintaining best practices for SQL environment • Planning, implementing and supporting high availability • Installing, configuring, patching and upgrading SQL server software • Creating and maintaining documentation • Monitoring and managing SQL server-based applications and usage • Implementing and managing test environments • Conducting needs and requirements analysis for business, performance tuning and execution plan optimisation • Report writing in SQL server reporting services (SSRS) • Managing scheduled tasks and jobs in SQL server agent • Maintaining and assigning permissions and database security • Developing and maintaining SQL server integration services (SSIS) • Performing as a strong member of a cohesive team with strict adherence to statutory regulations, quality standards, governance processes and compliance requirements Show less