Experience

• 

  Rennaissance merchant bank

  Jul 2006 - Aug 2007

  Technical support consultant
• 

  Ctu

  Jan 2011 - Nov 2012

  Developer
• 

  Ipsos south africa

  Nov 2012 - Feb 2016

  Software developer

  1. Maintaining and supporting existing systems2. Upgrading existing systems3. Creation of reports as per client request (Microsoft SS Report Builder 3.0)4. Creation of Web Services (WCF)5. Creation of dtsx packages and Push Reports6. System integrations

• 

  Business science corporation

  Feb 2016 - Jan 2019

  Involved in proactively delivering value to clients through in-depth analysis of their data and deriving meaningful insights out of their data. Designing Kimball data modelsDesigning and implementing end to end BI solutions (SSIS , ETLs)Analysis Tools: Power BI, Tableau and Excel.Database technologies : MS SQL, MySQL, Oracle, SAS, Teradata,PostgreSQLMicrosoft Azure Cloud databasesDatabase designing and implementationData warehouse designing and implementation Creating and maintaining SQL scripts and advanced stored proceduresBuilding and maintaining reports.Maintaining and monitoring System Integration between in-house system and SAP system.Creation , scheduling and monitoring of batch scriptsCreation and maintaining of Dtsx packages

  • BI Analyst Developer

    Nov 2016 - Jan 2019

  • Software Developer

    Feb 2016 - Oct 2016
• 

  Ecentric payment systems

  Feb 2019 - Jan 2020

  Software developer

  • Developing T-SQL stored procedures and functions to implement business logic• Developing regression tests to test T-SQL code• Performing database performance optimisation• Performing application support• Database designing• Scrum/Kanban managed teams

• 

  Datonomy solutions

  Mar 2020 - Feb 2021

  Analyst developer

  Building SSRS and imbedding the reports in ASP net web applications.Writing SQL scriptsStored ProceeduresViewsReports QAStack holder engagement