About

Let me introduce myself.

Passionate, driven, and meticulous data specialist with a habit of coming up with creative solutions to complex problems.

Profile

Data Scientist by trade, adventurous and entreprenurial by nature. I have 7+ years of experience across multiple, diverse industries in various positions ranging from engineering-focused to visualistaion-focused placements and everywhere in between.
Have developed my own FinTech company to the point it's fully automated, transacting with $150k per day at its peak, has generated $400k in profit for my clients to date.

Full name: Duncan Graham Charles Andrew
Birth Date: 23 July 1992
Current Position: Director of Lumina X
Nationalities: British, South African
Language: English
Website: duncan-andrew.com
Email: me@duncan-andrew.com

Python
AWS
Data Analysis
SQL
BI Tools

More Skills

Soft Skills

Problem solver

Curious

Fast learner

Adaptive

Communicator

Empathetic

Ambitious

Technical Skills

Pandas

Plotly

NumPy

Selenium

PowerBI

QlikView

Tableau

Kubernetes

Docker

JavaScript

HTML

PHP

Wordpress

Automation

Interests

Hiking

Cooking

Trail Running

Travel

Squash

Woodworking

Download Resume
2 pages

Work Experience

Some of the places I've worked.

I've had a wonderful career to date. Between working alongside highly talented people at dynamic companies and having the opportunity to start my very own company, there has been no shortage of fun.

Director

July 2019 - Present
Global

Lumina X

FinTech company focused on data-centric, fully automated financial services for multiple clients

Started as a side-project to learn cloud based services and infrastructure for just a handful of clients - currently sitting with 45+ active clients
Fully automated processes with horizontal scaling and vertically integrated with multiple service providers
Extreme cost optimisation - overheads are less than 0.5% of revenue

Financial Representative

July 2021 - Present
South Africa

RS Anderson Treasury

A registered Financial Services Provider, a treasury outsourcer which offers foreign exchange dealing, private wealth, and cryptocurrency solutions for its clients

Offering financial services and advice to clients
Booking of FX trades
Process automation and integration

Lead Data Scientist

April 2018 - February 2020
Cape Town

Mr D Food

South Africa's largest on-demand food delivery service, a part of the Takealot.group

Internally head-hunted to manage and develop all data flows, ETL processes, BI tools, data models, and reporting within the company and Takealot.group
Custom-built a real-time ETL and replication tool which improved reporting capabilities and optimised every BI and data process flow (reduction in reporting time: ±40 mins to ±5 secs)
Develop solutions with Marketing, Finance, Operations, and Development/Engineering departments to drive business' decision-making
Implemented extensive cost-reducing solutions which also increased the flexibility of models, BI tools, and reporting

Data Analyst (Contract)

November 2018 - February 2019
Berlin & New York

Dynamo Partners

A marketing and management consulting firm with offices in Berlin, Cologne, and Warsaw

Perform mobile marketing analysis on funnel conversion and drop-off rates of users within a mobile app for a New York-based company
Resulted in major changes with the user-flow, and overall app design as per our recommendations - requested to come back for a follow-up analysis

Data Analyst

September 2016 - March 2018
Cape Town

Takealot

South Africa's largest online retailer

Developed and actively maintained 6 QlikView apps which were used by 145+ users including CxOs to drive business decisions
Generated various data models which assist with predictions, analyses and cost breakdowns
Worked with multiple divisions: Retail & Marketplace, Finance, Private Label, and the whole Mr D Food business
Designed and implemented the company-wide Business Intelligence infrastructure
Head-hunted to lead the BI and Data team in Mr D Food

Analyst

January 2015 - August 2016
Cape Town

KPMG

One of the Big Four international audit firms

Performed and designed Data & Analytics procedures (Data Visualisation and Analysis, Data Migration reviews, and generating analytical models) for clients
Ran and performed IT Audits (General IT Controls, Data Audits, and ISAE 3402 reviews) for multiple clients across the financial industry
Started heading up the Data and Analytics team in the Cape Town office

Education

My formal qualifications.

I've been extremely lucky to have been able to attend some of the best schools as well as doing the courses of my choice.

Education

BCom Honours

2014
First Class/Cum Laude

Rhodes University

Bachelor of Commerce with Honours in Information Systems
Dissertation: Blended Learning in Tertiary Education

BCom

2011 - 2013
First Class/Cum Laude in Information Systems

Rhodes University

Bachelor of Commerce

Major: Information Systems
Major: Economics

Matric

2006 - 2010
4 Distinctions

St John's College

IEB Matriculation

Achievements

Some of the things I've done that have me beaming from ear-to-ear

Awards

Year	Name
2015	Academic Colours
2014	IBM Award for Best Information Systems Honours Dissertation
2014	Henderson Prestigious Scholarship
2013	Merit Award for First Class Pass in Information Systems

Certifications

Year	Name
2022	AWS Certified Cloud Practitioner
2022	RE5 Financial Services Representative Exam
2022	Class of Business - Structured Deposits
2022	Class of Business - Short and Long Term Deposits
2022	Class of Business - Investments
2018	QlikSense Visualisation
2018	Data Analysis in Python with Pandas (Udemy)
2016	Certified Security Sentinel (Mile2)
2015	COBIT 5 Foundations

Services

What Can I Do For You?

As the owner of Lumina X, I offer a range of professional services. With a strong background in Python and experience in various other languages mixed into a focus on data science, I am able to provide a variety of solutions for businesses looking for data-related technological services. Additionally, as a qualified financial services representative, I am able to assist with individuals' financial planning and decision making.

Arbitrage

One of the most popular products that my own company offers is Orbits, a fully automated arbitrage system with 45+ clients. Built with passive-income generation in mind, this product has been highly successful since 2019, generating $400k in profit for our clients from just over 1500 transactions.

Python Development

There isn't much I haven't done (or at least tried) using this versatile programming language. According to LinkedIn, I rank in the top 5% globally for the Python skills assessment. My experience ranges from analysing data, producing data models, automating tasks and even web application development. I have used it extensively to develop my own platforms and services. I am constantly learning and staying up to date with the latest Python tools and best practices, and am confident in my ability to deliver high-quality, and secure software solutions.

Systems Design

As a systems designer with an AWS Certified Cloud Practitioner certification, I have the knowledge and skills to design and implement scalable, reliable, and secure cloud-based systems. I have experience with various cloud technologies, including Amazon Web Services (AWS), and am able to architect and deploy solutions that meet the needs of a wide range of businesses. My own company runs very successfully on the cloud to manage our clients' finances.

Financial Services

As a registered Financial Services Representative in South Africa, I am fully qualified and authorized to provide financial advice. I have the knowledge and skills necessary to understand your financial needs and goals, and to provide you with personalized advice and solutions to help you achieve them. I am able to act on your behalf and handle a variety of financial transactions, including investments, deposits, insurance, and foreign exchange. I am also able to perform foreign exchange transactions for you, ensuring that you receive the best rates and ensuring that your transactions are completed in a timely and efficient manner.

Data Science

Through years of experience of being a Lead Data Scientist, I provide businesses with the expertise and resources for them to make data-drivern solutions. I provide a range of services, including data collection, cleaning, analysis, visualisation, predictive modeling, and machine learning. I keep up to date with the latest cutting-edge technologies and methodologies to provide actionable insights that can drive real business results.

Consultancy

I offer consulting services including Python development, Data Science, Systems Design, and Financial Services. Through these services, I can help businesses make data-driven financial decisions by providing them with actionable insights and building software systems for automation and optimization. This combined service can help businesses to improve their performance and achieve financial success in a highly efficient and effective manner.

Hello, World.

I'm Duncan Andrew.

About

Let me introduce myself.

Profile

More Skills

Soft Skills

Technical Skills

Interests

Work Experience

Some of the places I've worked.

Director

Financial Representative

Lead Data Scientist

Data Analyst (Contract)

Data Analyst

Analyst

Education

My formal qualifications.

Education

Achievements

Some of the things I've done that have me beaming from ear-to-ear

Awards

Certifications

Services

What Can I Do For You?

Arbitrage

Python Development

Systems Design

Financial Services

Data Science

Consultancy

1

Company Started

45+

Happy Clients

1 500+

Transactions Completed

$400k+

Profit Generated

$8.9m

Transacted

7 768

Cups of Coffee

Contact

I'd Love To Hear From You.

Where to find me

Email Me At

Call Me At