Fayaad Samaai

Data Analyst

Cape Town, South Africa

Summary

Passionate about uncovering insights from large volumes of data to drive key business decisions.

Skills

SQL

Python

PowerBI

Excel

Data Pipelines

Data Visualisation

API's

A/B Testing

Data Vault

Docker

Linux

Github

JavaScript

PHP

HTML

CSS

Cloudera

SAP Hana

Confluence

Jira

Py Spark

Pandas

Geolocation

Qualifications

BCom Information Systems

Hons Information Systems

Certificates

BI Course

Data Vault

Data Analyst

Appy Insights

July 2023 - Present

Client Project Management:
  • Oversee and coordinate client projects from initiation to completion.
  • Ensure projects meet client expectations, timelines, and budget constraints.
Solution Scoping:
  • Define and design comprehensive solutions to address client needs.
  • Develop and document project requirements and deliverables.
Data Analysis:
  • Analyze internal data to derive actionable insights.
  • Conduct in-depth data assessments to understand trends and patterns.
Visualisation Dashboard Development:
  • Build and maintain visual dashboards using tools like PowerBI and Grafana.
  • Create interactive and informative reports to aid data-driven decision-making.
Data Source Integration:
  • Work with various data sources, including APIs and databases, to aggregate and manage data.
  • Develop and implement data integration strategies.
Data Pipeline Creation:
  • Design and construct data pipelines to efficiently transfer data from sources to databases.
  • Ensure data accuracy and integrity throughout the pipeline process.
Server Setup and Maintenance:
  • Set up and configure servers to support application and data requirements.
  • Maintain server performance, security, and availability.
Data Capture Solutions:
  • Implement solutions for direct data capture into databases like PostgreSQL and SQLServer.
  • Ensure data is accurately collected and stored.
Database View Creation:
  • Develop database views to facilitate effective data visualization and reporting.
  • Optimize views to enhance performance and usability.

Business Intelligence Analyst

Sanlam

January 2023 - June 2023

Project Requirements Analysis:
  • Analyze and identify project requirements using SQL and business analysis techniques.
  • Provide detailed analysis of data implemented into the system.
Project Scoping and Planning:
  • Scope projects by defining requirements and establishing timelines.
  • Ensure projects are on track through various sprints.
Functionality Testing:
  • Test and validate that the functionality of requirements meets specifications.
Support Management:
  • Manage the support mailbox and handle ad hoc requests efficiently.
  • Provide continuous support for projects throughout their lifecycle.
Data Acquisition and Transformation:
  • Acquire data from various sources, combine and transform it into meaningful datasets.
  • Extend company information by integrating relevant third-party data sources.
Data Processing and Integrity:
  • Process, cleanse, and verify the integrity of data used for analysis.
  • Perform data profiling of information contained within source systems.
Data Mapping and Rules:
  • Develop and provide data mapping and rules for new data within the system.
Data Model Support:
  • Support and maintain project data models at multiple levels of detail.

Data Insights Analyst

MySchool MyVilliage MyPlanet | Woolworths

Februrary 2020 - December 2022

SQL Query Development:
  • Write and optimize MySQL queries to fulfill data requests and extract relevant information.
Month-End Reporting:
  • Prepare and handle month-end reports for various departments, ensuring accuracy and timely delivery.
Campaign Reporting:
  • Manage and report on the progress of ongoing campaigns, tracking key metrics and milestones.
  • Create comprehensive reports on campaign performance upon completion, covering aspects such as sales, demographics, advertising expenditure, and ROI.
Partner Performance Analysis:
  • Analyze and assess the performance of partners to determine effectiveness and opportunities for improvement.
Report Automation and Migration:
  • Automate the generation of reports and migrate reporting processes to online solutions for increased efficiency.
Data Cleanup and Integrity:
  • Identify and implement methods to clean up existing data, ensuring that clean and accurate data is inserted into systems.
Audience Targeting:
  • Refine and create targeted audience segments to enhance marketing efforts and campaign effectiveness.
Code Repository Management:
  • Create and maintain a code repository, ensuring organized storage and version control of scripts and code.