Summary
Overview
Work History
Education
Skills
Timeline
Generic

ROBIN TROY CHAKA

Centurion

Summary

Experience with object-oriented programming languages with a focus on C# and Java, Hands-on experience in architectural design of complex applications. Self-driven, dedicated developer with 8 years of experience developing reliable Web applications as well as custom SQL reports and Database development. Driven business intelligence professional managing areas such as data mining, database management and report development. Meticulous and hardworking with a disciplined and methodical approach. Exceptional skills in project management, problem-solving and verbal and written communication. Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Overview

11
11
years of professional experience

Work History

Senior BI Developer

PPS Insurnace
01.2023 - Current
  • Compiled, maintained and developed database systems for tracking tailored content reports.
  • Assessed platform statistics to create customized, data-intensive BI analytics.
  • Wrote and optimized SQL statements to assist business intelligence practices.
  • Prepared targeted documentation, specifications, and resources to analyze business data.
  • Oversaw database upgrade, backup, recovery and migration.
  • Monitored assessment software for performance, security and database availability throughout lifecycle.
  • Built databases and table structures for web applications.
  • Conducted data modeling, performance and integration testing.
  • Proved successful working within tight deadlines and a fast-paced environment.

Freelance Developer

Phantom Solutions
01.2019 - Current
  • Created complex SQL queries and database objects to pull and manage data.
  • Optimized data gathering processes, analysis procedures and visualization strategies.
  • Engaged with business users to gather, define and document reporting requirements.
  • Developed, tested and deployed standard reports and dashboards based on business requirement document specifications.
  • Created and oversaw dashboards with Power BI.
  • Reviewed and improved performance of SQL server.
  • Coordinated installation of software systems and collaborated with user experience team on design and implementation of new features.
  • Coordinated testing and validation procedures through software development lifecycle.
  • Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
  • Provided support for complex issues related to software tools, applications and databases.
  • Created and monitored performance metrics to keep databases functioning at optimal capacity.
  • Liaised with clients to clarify business challenges and objectives to optimize performance of existing systems.
  • Optimized application process flow to improve performance.
  • Contributed to requirements gathering and design development meetings.
  • Applied application product support to contractors located internationally.
  • Increased efficiency through task automation.
  • Led cross-functional teams in systems integration projects.
  • Designed and conducted hardware or software systems testing.
  • Analyzed code and debugged errors to improve system performance.

BI Developer/Data Analyst

Growthpoint
12.2019 - 12.2022
  • Gathered and analyzed functional requirements to convert into technical requirements.
  • Prepared documentation for database applications.
  • Designed and created database systems after reviewing end user's requirements.
  • Develop, implement and optimize stored procedures and functions using T-SQL.
  • Review and interpret ongoing business report requirements.
  • Research required data.
  • Build appropriate and useful reporting deliverables.
  • Analyze existing SQL queries for performance improvements.
  • Suggest new queries.
  • Develop procedures and scripts for data migration.
  • Provide timely scheduled management reporting.
  • Investigate exceptions with regard to asset movements.
  • Using the MRI tool for creating property reports.
  • Analyze user needs and software requirements to determine feasibility of design within time and cost constraints.
  • Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design.

Software Developer

Daisy Business Solutions
08.2016 - 12.2020
  • Store, retrieve, and manipulate data for analysis of system capabilities and requirements.
  • Pitched ideas on how to improve performance and efficiency.
  • Development of high quality database solutions.
  • Repurposed existing data sets to incorporate new features and analytics, expanding the use of analytics across the organization.
  • Performed complex SQL queries to extract data from the database.
  • Coordinated with project management staff on database development timelines and project scope.
  • Collaborated on all stages of systems development lifecycle, from requirement gathering to production releases.
  • Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines.
  • Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements.
  • Introduced methodologies and best practices to software development division to enhance product definition and application customization.
  • Developed and maintained system applications customized to suit daily needs of end-users.
  • Documented procedures and business processes and shared information with appropriate stakeholders.
  • Maintained strong working knowledge of ERP, CRM and business intelligence tools and operational features.
  • Mapped processes to holistically examine business flow and identify improvement opportunities.
  • Continually identified areas that needed improvement and guided junior developers in measuring the level of adjustment required.
  • Oversaw the creation of reports concerning software project specifications.
  • Worked with departments across the company, including marketing and project management, in developing new ideas, initiatives, products, and services.

Sport Leader And IT Manager

Decathlon
08.2014 - 08.2016
  • Company Overview: This is a retail sports company from France. Decathlon is a start up in Africa business and I was lucky enough to be a part of their 3rd store opening in Centurion, Gauteng.
  • I was given the opportunity to be the IT manager and was tasked to assist with setting up the stores Servers.
  • Configuring the Firewalls and all IT needs around the store.
  • While doing all that, I was given a chance to grow my IT skills, people skills and interact with people daily and understand what it is to make targets and sales for the company.
  • Provided accurate information about promotions, customer programs and products, helping drive high customer retention.
  • Coordinated efficient restocking of sales floor with current merchandise and accurate signage for current promotions.
  • Consistently met my short and long-term targets.
  • Handled customer complaints with empathy and composure.
  • This is a retail sports company from France. Decathlon is a start up in Africa business and I was lucky enough to be a part of their 3rd store opening in Centurion, Gauteng.

Education

Bachelor - Computer Science, Software Engineering

The Belgium Campus
Pretoria, Gauteng
12.2022

Grade 12 - undefined

Pretoria Technical High School
12.2016

Skills

  • SSIS
  • SSAS
  • SSRS
  • T-SQL
  • SQL
  • Power BI
  • DAX
  • Power Query
  • R
  • C#
  • JAVA script
  • Net Framework
  • CSS
  • HTML
  • ETL/ Data pipelines
  • Azure Data Factory
  • Azure Synapse Analytics
  • DevOps
  • Jira
  • HTML/JavaScript/Angular/ReactJS/Vue
  • Jenkins
  • Docker
  • Kubernetes
  • ERP
  • CRM
  • Application Design
  • Mainframe Backups
  • Requirements Gathering
  • Database Creation
  • Data Warehousing
  • Report Writing Skills
  • Transact SQL
  • Python
  • Spark
  • Scala
  • Azure Data Factory
  • Azure Synapse Analytics
  • Azure DevOps
  • Data Lake
  • Power BI
  • SQL Server
  • Databricks

Timeline

Senior BI Developer

PPS Insurnace
01.2023 - Current

BI Developer/Data Analyst

Growthpoint
12.2019 - 12.2022

Freelance Developer

Phantom Solutions
01.2019 - Current

Software Developer

Daisy Business Solutions
08.2016 - 12.2020

Sport Leader And IT Manager

Decathlon
08.2014 - 08.2016

Grade 12 - undefined

Pretoria Technical High School

Bachelor - Computer Science, Software Engineering

The Belgium Campus
ROBIN TROY CHAKA