Bruce is available for hire
Hire BruceBruce Edwards
Verified Expert in Engineering
Software Developer
Pretoria, Gauteng, South Africa
Toptal member since November 9, 2016
Bio
Having led the development of a great number of high-profile systems, Bruce is a highly experienced software developer. He communicates well at all levels. Apart from web development, he is also highly experienced in BI and has worked with large teams and individually.
Portfolio
Ur AI Co., Ltd.
Python, Amazon Web Services (AWS), GitHub Actions...
Techniquex, LLC
Microsoft Excel, Excel Macros, Excel 2016
Carrier - Residential - Mobile Apps Product Management
ETL, Snowflake, Data Build Tool (dbt), Metabase, Microsoft SQL Server...
Experience
- SQL - 20 years
- Data Modeling - 10 years
- Business Intelligence (BI) - 10 years
- Data Engineering - 8 years
- Amazon Web Services (AWS) - 5 years
- D3.js - 5 years
- Python - 5 years
- React - 4 years
Work Experience
AI-first Systems Engineer
2026 - 2026
Ur AI Co., Ltd.
- Developed a CDK app to deploy instances of the system to AWS. This entailed a stage and testing environment. Deployed worker nodes to ECS.
- Developed CI/CD pipelines to update EC2 instances and ECS containers triggered by GitHub events.
- Implemented RDS Blue/Green deployment for PostgreSQL databases.
Technologies: Python, Amazon Web Services (AWS), GitHub Actions, AWS Cloud Development Kit (CDK)
Software Developer
2025 - 2025
Techniquex, LLC
- Rendered complex data into the required format using Excel formulas alone.
- Built a work area where data formatting could occur.
- Filtered complex data for rendering into a simple template.
Technologies: Microsoft Excel, Excel Macros, Excel 2016
Data Engineer
2025 - 2025
Carrier - Residential - Mobile Apps Product Management
- Built data structures in Snowflake and created AWS glue pipelines to serve as the data source for Metabase dashboard queries for the Virtual Power Plants (VPP) initiative.
- Developed dashboards and models in Metabase to visualize the progress of the VPP initiative.
- Built an AWS Glue pipeline to deliver output for compliance with Energy Star for connected thermostats.
- Created a pipeline to ingest warranty data through an internal API.
- Converted data transformations on Snowflake to use dbt.
- Built an automated workflow to render management reports into an Excel format.
Technologies: ETL, Snowflake, Data Build Tool (dbt), Metabase, Microsoft SQL Server, Database Design, Node.js, Microsoft Excel, Amazon Athena, PostgreSQL, Data Analysis, Complex Data Analysis, Database Development, Database Architecture, Dimensional Modeling, Data Architecture, Data Pipelines, ETL Development, Python 3, Databases, APIs, ETL Implementation & Design, Data Modeling, Amazon Elastic Container Service (ECS), GitHub, Data, NumPy, Pandas, Database Performance, Data Warehouse Design, Data Migration, Reporting, Data Transformation, Data Queries, Data Manipulation, Amazon DynamoDB, Stored Procedure, Data Analytics, Automation, Dynamic SQL, AWS SDK, NoSQL, JSON, MongoDB, AWS Glue, MongoDB Atlas, Data Science, Excel 2016, AWS Cloud Development Kit (CDK), REST APIs, API Integration, Spark, RESTFul APIs, Postman, Apache Spark, PySpark, YAML, Command-line Interface (CLI), Time Series, ETL Pipelines, Data Cleaning, Git
React and Python Full-stack Developer
2024 - 2024
Climate Edge Law Group, a California Professional Corporation
- Developed an online portal to access data from the Clio API and generate invoices in Excel spreadsheets for downloading.
- Stored data in DynamoDB to support application features via AWS API Gateway.
- Used Amazon Cognito to build a logon process that enabled new sign-ins, forgotten passwords, and other security features.
- Built an ETL pipeline for loading new data via an Amazon S3 bucket.
Technologies: React, Python, Microsoft Excel, Clio API, REST APIs, API Integration, RESTFul APIs, Postman, Reports, API Development, Front-end Development, Git
Full-stack Developer (via Toptal)
2024 - 2024
Climate Edge Law Group, a California Professional Corporation
- Developed an app to download data from the Clio API and then upload Excel invoices for selected attorneys.
- Used the ExcelJS library within React to ensure that all the calculated values in the uploaded Excel invoices were still actionable with Excel formulas.
- Developed a way to persist data for customized payment percentages by uploading modified invoices through a data pipeline developed with AWS services.
- Built a secure API to Clio with support to add new users, change passwords, and reset forgotten passwords using Amazon Cognito.
Technologies: React, Python, Microsoft Excel, Amazon API Gateway, Amazon CloudFront CDN, Amazon Cognito, Amazon DynamoDB, Amazon Route 53, Amazon S3 (AWS S3), AWS Lambda, Clio API, ExcelJS, Windows PowerShell, Amazon Web Services (AWS), NoSQL, JSON, Postman, REST APIs, API Integration, RESTFul APIs, Reports, API Development, Front-end Development, Git
React and Excel Automation Developer
2024 - 2024
D2 Legal Change Inc.
- Created a visual representation of a legal compliance process where a user can navigate through a flow chart to get results instead of wading through a PDF document.
- Built a data pipeline to keep the flow chart application up to date easily.
- Created administrative features to easily manage the layout of the flow charts after a default layout is created.
- Developed an API and storage facilities with AWS to persist changes.
Technologies: JavaScript, React, Microsoft Excel, Web Design, Database Schema Design, Windows PowerShell, Amazon Web Services (AWS), Python, NoSQL, JSON, REST APIs, API Integration, RESTFul APIs, Time Series, Dashboards, API Development, Front-end Development, Git
Full-stack Developer
2024 - 2024
VecViz LLC
- Modified the data pipeline to handle data from new sources.
- Improved performance for mobile browsers and browsers using incognito mode.
- Added new data to some D3.js chart tooltips and improved the performance of the rendering.
Technologies: Data Visualization, Full-stack, React, Dashboards, Tableau, Wix, Amazon Web Services (AWS), D3.js, Web Design, Windows PowerShell, Python, BI Reports, NoSQL, JSON, REST APIs, API Integration, RESTFul APIs, Time Series, API Development, Front-end Development, Git
Data Visualization Expert
2024 - 2024
Children's Home Society of North Carolina
- Developed an app to visualize data geographically.
- Created an interface for the user to make style changes in a very responsive manner.
- Used AWS to store config during the development phase. Once development was complete, the final config was hard coded into the React app. The idea was to empower the client to do most of the design and styling.
- Created a data pipeline to gather data from a variety of sources into the dashboard.
Technologies: Web Development, Data Visualization, User Interface (UI), User Experience (UX), React, AWS SDK, Web Intelligence, Web Design, Amazon Web Services (AWS), Python, NoSQL, JSON, Dashboards, Front-end Development, Git
D3.js Expert
2024 - 2024
HR Data Hub Ltd
- Showed the developers how to structure a react component to use D3.js so that the D3.js chart scales with the component size.
- Taught the developers how to use a foreign object to display dynamic tooltips.
- Demonstrated the best design patterns to use with React and D3.js.
Technologies: JavaScript, React, D3.js, Web Intelligence, Web Design, BI Reports, JSON, Dashboards, Front-end Development, Git
Full-stack Developer
2024 - 2024
VecViz LLC
- Modified an existing React application I created in an earlier project to run on a WordPress instance of Amazon Lightsail.
- Devised a deployment strategy to deploy the React application from GIT to the Lightsail instance.
- Resolved styling conflicts between the React application and the WordPress styles.
Technologies: Data Visualization, Full-stack, React, Dashboards, Amazon Web Services (AWS), D3.js, Chart.js, Amazon Lightsail, Lava, Web Intelligence, Web Design, Windows PowerShell, Python, BI Reports, NoSQL, JSON, Database Development, REST APIs, API Integration, RESTFul APIs, Time Series, API Development, Front-end Development, Git
Data Architect
2023 - 2024
Ricoh Corporation - DSC - PortfolioSoftwareSolutions
- Developed the MySQL stored procedures and functions required for the Simple Send application. Modified data structures where necessary.
- Developed an innovative generic AWS lambda function that routes all traffic from and to the FE and BE without needing any modification, using MySQL's JSON support.
- Simplified the system's architecture, helping to meet the project deadlines in a timely fashion.
- Integrated some parts of the Simple Send application with a 3rd-party vendor called Planet Press and managed the digital communication between APIs.
Technologies: Data Engineering, Data Architecture, AWS Lambda, SQL Stored Procedures, APIs, Amazon Web Services (AWS), SQL, Performance Optimization, Complex SQL Queries, Database Schema Design, Python, JSON, Debugging, Troubleshooting, System Integration, Complex Data Analysis, Database Development, Postman, REST APIs, API Integration, MySQL, RESTFul APIs, YAML, Command-line Interface (CLI), ETL Pipelines, Data Cleaning, API Development, Git
Full-stack Developer
2023 - 2023
VecViz LLC
- Developed a secure React portal hosted on AWS utilizing API Gateway, S3, CloudFront, Route 53, Lambda, and DynamoDB.
- Created a set of highly interactive dashboards with D3.js.
- Made data pipelines to keep the dashboards up to date.
Technologies: Data Visualization, Full-stack, React, Dashboards, Wix, Amazon Web Services (AWS), D3.js, Chart.js, Web Intelligence, Web Design, Windows PowerShell, Python, BI Reports, NoSQL, JSON, Database Development, Postman, REST APIs, API Integration, RESTFul APIs, Time Series, API Development, Front-end Development, Git
Database Engineer
2023 - 2023
D2 Legal Change Inc.
- Made an assessment of the issues that needed to be resolved. There were two known bugs in a Python script that loaded data from Excel. Formatted the data into a Word document, and then converted it to pdf.
- Found a solution to overcome the 40-character limit on Microsoft Word bookmarks. I used a hash algorithm to ensure uniqueness with a length that came in well under the 40 limit.
- Extended the functionality to add hyperlinks to the summary table.
Technologies: Scripting, Data Engineering, Python, Automation, Web Intelligence, Web Design, Database Schema Design, JSON, Debugging, Troubleshooting, Database Development, Postman, REST APIs, API Integration, Time Series, Dashboards, API Development
D3.js Developer
2023 - 2023
Medify Ltd
- Developed a React app that let the user play with different configuration settings for each chart until the look and feel were exactly right.
- Developed six highly customized charts using D3 that were responsive to user interaction and changes in data.
- Developed a CI/CD pipeline to ensure timely integration into the React and Ember apps, where the charts ultimately reside.
Technologies: JavaScript, D3.js, TypeScript, Front-end Design, React, Agile, Automation, HTML, Web Intelligence, Web Design, Amazon Web Services (AWS), BI Reports, JSON, Dashboards, Front-end Development, Git
Data Engineer
2023 - 2023
Health Data Atlas
- Automated existing data collection processes using AWS. Converted Python scripts to run as command line jobs within Amazon Batch and Amazon Lambda. All processes were improved by enabling the logging of all events either in Postgres or Dynamodb.
- Created an app to recognize data structures in JSON and CSV and then automatically create Postgres tables from the metadata and populate those tables while ensuring no duplicates. SQLAlchemy was used mainly for this.
- Created a web application to enable manual downloading of data files to Postgres. This was a React app using TypeScript and hosted on Amazon S3. It was secured using Amazon Cognito.
- Advised the client on best practices for data warehousing and data pipelines.
Technologies: Amazon RDS, Amazon Elastic Container Service (ECS), Amazon S3 (AWS S3), Amazon Web Services (AWS), Amazon Cognito, AWS Batch, TypeScript, Python 3, SQLAlchemy, JavaScript, Amazon API Gateway, PostgreSQL, Amazon DynamoDB, Agile, PL/SQL, Stored Procedure, Web Scraping, Scripting, Automation, SQL Stored Procedures, Microsoft SQL Server, HTML, Dynamic SQL, Database Design, Data Integration, Full-stack, Data Architecture, Windows PowerShell, Python, BI Reports, Business Analysis, JSON, Debugging, Troubleshooting, System Integration, Database Development
Data Engineer
2023 - 2023
Marubeni America Corporation - Main
- Developed a set of TSQL procedures to effectively clean IoT data and make it useable for BI purposes.
- Utilized the Elastic Jobs service in Azure to schedule initial and incremental loads.
- Used Azure Data Factory to transfer data between servers and databases.
- Created a methodology to simplify querying of maintenance data utilizing mapping and validation tables using calculated values measuring values against standard deviations. Utilized TSQL.
Technologies: Data Engineering, SQL, Azure, ETL, DB, AWS IoT, Azure IoT Hub, Azure Data Factory (ADF), Azure SQL Databases, Data Manipulation, Data Pipelines, Agile, Stored Procedure, Data Analytics, SQL Stored Procedures, Microsoft SQL Server, Dynamic SQL, Database Design, Data Integration, Performance Optimization, Complex SQL Queries, Business Analysis, Troubleshooting, Complex Data Analysis, Database Development, Data Science, Time Series, Data Cleaning, Git
Full-stack Developer
2022 - 2022
Fimadex Sarl
- Developed an online portal to serve as a POC for a new online commodities trading platform.
- Moved the client's domain to AWS Route 53 and set up the portal using AWS S3, Amazon CloudFront, Route 53, API Gateway, Lambda, Batch, DynamoDB, Cognito, and IAM services.
- Rendered a large point cloud using Potree so that users can navigate through a warehouse as though in a 3D game.
- Created a feature to enable the creation of 3D mesh objects to visualize stacks of commodities in a warehouse.
- Created data visualizations using custom D3 components.
Technologies: JavaScript, Front-end, User Interface (UI), Databases, Full-stack, Data Visualization, Three.js, Amazon Web Services (AWS), TypeScript, Potree, D3.js, MongoDB, APIs, Business Intelligence (BI), Amazon S3 (AWS S3), Amazon CloudFront CDN, GitHub, CI/CD Pipelines, DevOps, Data-driven Dashboards, AWS Lambda, Agile, HTML, Web Intelligence, Web Design, BI Reports, JSON, Dashboards, Front-end Development, Git
React Developer
2021 - 2022
Alchemy Consulting LLC
- Developed a web portal to visualize data from drone and satellite footage to mitigate fire risks by understanding the fuel situation and terrain of the areas of concern.
- Developed interactive features for user analysis. This meant extracting usable data from image files and storing the data in a relational database for rapid retrieval.
- Built all the data pipelines and image manipulation processes required to fulfill the needs of the portal users.
- Created the development environment and a CI/CD pipeline.
Technologies: React, Amazon Web Services (AWS), OpenLayers, SQL, Python 3, Docker, D3.js, TypeScript, Relational Database Design, Database Architecture, Relational Databases, MongoDB, APIs, Amazon RDS, Data Visualization, Amazon S3 (AWS S3), Data Modeling, Amazon Elastic Container Service (ECS), Amazon CloudFront CDN, Data Engineering, GitHub, Data, NumPy, Pandas, DB, CI/CD Pipelines, DevOps, Business Intelligence (BI), Python, Reporting, Databases, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Data Analysis, Data-driven Dashboards, AWS Lambda, Amazon EC2, Agile, Stored Procedure, API Design, Scripting, Automation, SQL Stored Procedures, HTML, Dynamic SQL, Database Design, Data Integration, Full-stack, Data Architecture, Web Intelligence, Complex SQL Queries, Web Design, FTP, Windows PowerShell, NoSQL, JSON, Debugging, Troubleshooting, System Integration, Database Development, ETL Development, REST APIs, API Integration, GeoJSON, Command-line Interface (CLI), Dashboards, Data Cleaning, API Development, Front-end Development
React Developer
2021 - 2021
Shanbohogue Corp.
- Used the FlexLayout React component to enable moving components around on the UI.
- Created a heatmap component with D3 to render hundreds of thousands of points instantaneously with user interaction. This was done by integrating D3 with canvas.
- Created a configurable D3 bar chart component to improve the performance of an existing feature.
- Got heatmap component to act as a data filter for other components so that any zoom or brush events would affect the other visualization components to show visible data only.
Technologies: React, D3.js, React Redux, Business Intelligence (BI), Data Visualization, GitHub, Data-driven Dashboards, Agile, HTML, Web Intelligence, Web Design, BI Reports, JSON, Dashboards, Front-end Development, Git
Full-stack JavaScript Developer
2020 - 2021
Albayanat Alwasphiah LTD
- Developed an app using React and D3 that visualized data for a large international trading company.
- Created customized D3 charts and mapping and selection components to be used within the project.
- Created data structures, SQL queries, and the API to access the data.
- Packaged the app in Electron for certain use cases.
- Productionized the app for deployment to the client. This app renders LTR for English and RTL for Arabic.
- Created a translation module to translate between English and Arabic based on the version selected.
Technologies: JavaScript, React, Node.js, SQLite, PostgreSQL, Electron, D3.js, Docker, Express.js, Business Intelligence (BI), Data Visualization, GitHub, CI/CD Pipelines, DevOps, Data-driven Dashboards, Agile, HTML, Web Intelligence, Web Design, BI Reports, JSON, Front-end Development
Data Visualization Engineer
2020 - 2020
Moneyhub
- Created a series of React components based on Recharts to visualize data retrieved from AWS Athena.
- Built the web service using Node.js to access the data from Athena. This service created SQL on the fly based on user-defined parameters.
- Developed a Node.js module to prepare Athena data for optimal data retrieval as part of the daily ETL process.
- Created an application with Node.js and React to test my React components before they were uploaded to the live system. This application also simulated all the possible filters that users would be able to specify.
- Built custom charts with D3 and integrated them into the React components. All React components were functional components using React hooks.
- Suggested and created charts to highlight interesting aspects of the business.
- Cleaned up data on Athena and formulated an efficient method of data retrieval eliminating all data joins in real time.
- Created forms with Material-UI.
Technologies: Amazon Web Services (AWS), Node.js, Presto, Material UI, SQL, Amazon Athena, D3.js, Recharts, React, Business Intelligence (BI), Data Visualization, GitHub, Data-driven Dashboards, Agile, HTML, Web Intelligence, Web Design, BI Reports, JSON, Dashboards, Front-end Development
Web Developer
2017 - 2020
Mine Tech Services
- Created an interactive mapping website to visualize the data generated by mining vehicles on open pit mines. The website includes near-real-time animations of the entire fleet and numerous features to understand health events, site inspections, and more.
- Built a data management component using C# to easily manage Ajax calls from a website to a SQL database.
- Designed normalized SQL data structures to handle the interactions on the website and facilitate reporting.
- Created a user management module to secure the site and ensure user activity can be reliably reported.
- Built a task management module where work requests can be made from the interactive map and distributed to the right people. It includes all the features needed to manage tasks from beginning to end.
- Developed an administration application to manage users and the security context.
- Created a highly interactive dashboard using D3.js to visualize complex data returned by transponders on the mining equipment.
Technologies: jQuery UI, jQuery, JavaScript, Microsoft SQL Server, Leaflet, Relational Database Design, Database Architecture, Relational Databases, APIs, Business Intelligence (BI), Data Visualization, Data Modeling, Data, SQL Server DBA, DB, CI/CD Pipelines, Reporting, Databases, SQL DML, Transact-SQL (T-SQL), Data Queries, Data-driven Dashboards, Agile, Stored Procedure, API Design, Scripting, Automation, .NET, SQL Stored Procedures, HTML, Dynamic SQL, Database Design, Data Integration, Full-stack, Data Architecture, Web Intelligence, Complex SQL Queries, Web Design, Database Schema Design, FTP, BI Reports, Business Analysis, JSON, Debugging, Troubleshooting, System Integration, Database Development, Time Series, Dashboards, Data Cleaning, Front-end Development
C# Engineer
2019 - 2019
Bula
- Supported an MVC application for Bula Law written in C#.
- Added new features such as tree structures to display company offerings.
- Extended JavaScript objects to resolve issues that could not be resolved at the C# level.
- Managed virtual machines using the Azure interface.
- Worked with the integrated VS Azure source control to manage versions and deploy to Dev and Prod.
Technologies: Azure, SQL, Model View Controller (MVC), Razor, JavaScript, C#, GitHub, Data, DB, Azure SQL, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Agile, Stored Procedure, Automation, .NET, SQL Stored Procedures, Complex SQL Queries, Web Design, JSON, Debugging, Troubleshooting, Reports
C# .NET Engineer
2019 - 2019
Bula Law
- Made numerous enhancements to an existing MVC web application.
- Created SQL scripts to manipulate complex data without losing integrity for bulk user activity.
- Performed system admin tasks on Azure portal.
Technologies: Azure, SQL, Model View Controller (MVC), Razor, JavaScript, C#, GitHub, Data, DB, Azure SQL, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Agile, Stored Procedure, Automation, .NET, SQL Stored Procedures, Complex SQL Queries, Web Design, JSON, Debugging, Troubleshooting, Reports
Qlik Sense Expert
2019 - 2019
Bula Law
- Created an app to query an Azure SQL database via a C# API with various end points. I passed credentials to the appropriate connector to get an access token and then applied this to the post body of the subsequent HTTP requests to the API. This could only be done by coding in the load script. The retrieved data was then used to incrementally populate a bunch of QVD files which I designed in accordance with the visualization requirements.
- Built a load script to use Qlik Sense SQL to process the QVD raw data in ways required by the visualization. Some tricky workarounds were required because Qlik Sense does not support SQL window functions such as Rank().
- Created an SVG extension with D3 in order to satisfy a mapping requirement of Bula's, apart from putting together the basic building blocks for Bula to expand upon the charts I created.
- Managed the licensing, publishing, security, and task scheduling to create a fully automated system that gets updated every day.
- Built the ETL in a robust way so that any failures were handled without loss of data or the need for interventions.
Technologies: D3.js, JavaScript, Qlik Sense, SQL, Business Intelligence (BI), Data Visualization, ETL, ETL Implementation & Design, Data, DB, Data-driven Dashboards, Data Pipelines, Agile, Data Analytics, Automation, Qlik, Complex SQL Queries, BI Reports, ETL Development, Reports, ETL Pipelines, ETL Tools
D3 Developer
2018 - 2018
University of Colorado
- Created a data visualization using D3 that simulated a lava lamp effect.
- Created geographical data visualization using D3.
- Integrated D3 modules with React.
- Modified an existing API to access MongoDB with Node.js.
- Used Git.
Technologies: Node.js, Express.js, React, JavaScript, D3.js, MongoDB, Business Intelligence (BI), Data Visualization, GitHub, Data-driven Dashboards, Agile, Web Design, BI Reports, JSON, Dashboards
SQL/Crystal Reports Developer
2017 - 2018
Space Machine & Engineering Corp (via Toptal)
- Created a Crystal Report with dynamically extendable columns for export into Excel.
- Created an SQL stored procedure to pivot data dynamically based off the Crystal Report parameter selections to support the report above.
- Created a number of Crystal Reports to be embedded within the E2 Shop software.
- Liaised with the E2 support staff to overcome limitations in the E2 Crystal integration.
Technologies: Crystal Reports, Microsoft SQL Server, ETL, ETL Implementation & Design, Data, DB, Business Intelligence (BI), Reporting, SQL DML, Transact-SQL (T-SQL), Data Queries, Microsoft Excel, Excel VBA, Agile, Stored Procedure, Scripting, SQL Stored Procedures, Complex SQL Queries, BI Reports, SAP Crystal Reports, Reports
Engagement Manager
2014 - 2016
Decision
- Created visualization extensions for SAP Lumira using D3.js.
- Created a maintenance-free table-driven ETL system using MS SQL Server linked servers. Deployed to four different clients with differing requirements.
- Created a SQL-based table-driven workflow rules engine to manage assets for a bank. Created the dynamic front-end in Flash player with AS3.
- Created a BI system for an online movie download site using PostgreSQL for the back-end, ETL, and data warehouse, and Tableau for the front-end visualizations. Data mostly derived from Google Analytics.
- Created numerous extensions for Xcelsius with AS3 and HTML5. These extensions were used to create a multitude of dashboards for a wide selection of clients.
- Satisfied the data visualization requirements of a multitude of different clients. This included database design, ETL, report writing, and data visualization.
- Managed development teams on-site on three occasions. The largest team I managed had three members.
Technologies: Python, SAP Analytics Design Studio, SAP, Tableau, AS3, SAP HANA, PostgreSQL, SQL Server Integration Services (SSIS), Java, D3.js, JavaScript, Crystal Reports, Dashboard Design, SAP Lumira, SQL, Google Analytics, Relational Database Design, Database Architecture, Relational Databases, APIs, Business Intelligence (BI), Data Visualization, ETL, ETL Implementation & Design, Data Modeling, Data Warehousing, Data Engineering, Data, SQL Server DBA, Team Leadership, DB, DevOps, Data Warehouse Design, Data Migration, Finance, Reporting, Databases, Data Transformation, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, SQL Performance, Performance Tuning, Data Analysis, Microsoft Excel, Excel VBA, Data-driven Dashboards, QlikView, Database Administration (DBA), Data Manipulation, Data Pipelines, Analytics, Data Auditing, Agile, PL/SQL, Stored Procedure, API Design, Data Analytics, Scripting, Automation, .NET, SQL Stored Procedures, HTML, Dynamic SQL, Database Design, Data Integration, Full-stack, Data Architecture, Web Intelligence, Qlik, Performance Optimization, Complex SQL Queries, Web Design, Database Schema Design, FTP, BI Reports, Business Analysis, JSON, SAP Crystal Reports, Debugging, IT Support, Troubleshooting, System Integration, Complex Data Analysis, Database Development, Dimensional Modeling, ETL Development, Kimball Methodology, RESTFul APIs, Time Series, Dashboards, Reports, ETL Pipelines, Data Cleaning, ETL Tools, API Development, Lumira
Senior BI Consultant
2009 - 2014
Asyst Intelligence
- Modeled a dimensional data warehouse for an asset management company. Used SSIS for the ETL and SAP Business Objects to visualize and report the data.
- Created a geo-spatial dashboard system capable of rendering huge amounts of spatial data rapidly. Points changed shape, size, and color in response to questions asked of the data embedded within the KML. Shapes changed color and lines changed width, color, and style in response to questions.
- Gathered the requirements, created the ETL, designed and developed the data warehouses when required, wrote the reports, and satisfied the data visualization requirements of a wide variety of clients. Created dashboards on a daily basis.
Technologies: Flex, SQL Server Integration Services (SSIS), AS3, Apache Tomcat, Jakarta Server Pages (JSP), HTML5, JavaScript, Java, C#, SAP BusinessObjects Data Service (BODS), SQL, Relational Database Design, Database Architecture, Relational Databases, APIs, Google Geocoding API, Business Intelligence (BI), Data Visualization, ETL, ETL Implementation & Design, Data Modeling, Data Warehousing, Data Engineering, Data, SQL Server DBA, Team Leadership, DB, DevOps, Data Warehouse Design, Data Migration, Finance, Reporting, Databases, Data Transformation, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, SQL Performance, Performance Tuning, Data Analysis, Microsoft Excel, Excel VBA, Data-driven Dashboards, Database Administration (DBA), Data Manipulation, Data Pipelines, Analytics, Data Auditing, Agile, PL/SQL, Stored Procedure, API Design, Data Analytics, Scripting, Automation, .NET, SQL Stored Procedures, HTML, Dynamic SQL, Database Design, Data Integration, Full-stack, Data Architecture, Web Intelligence, Performance Optimization, Complex SQL Queries, Database Schema Design, FTP, BI Reports, Business Analysis, JSON, SAP Crystal Reports, Visual Basic for Applications (VBA), Debugging, IT Support, Troubleshooting, System Integration, Complex Data Analysis, Database Development, Dimensional Modeling, ETL Development, Kimball Methodology, RESTFul APIs, Time Series, Dashboards, Reports, ETL Pipelines, Data Cleaning, ETL Tools, API Development
SQL Technical Lead
2006 - 2009
Massana Technologies
- Initiated and developed a system to manage the data transformations from the legacy “Venus” system to the new SAP system being developed by the city of Johannesburg. The system was required to process 30 TB of data in a limited window.
- Created applications to manage the extracts coming from the city, to manage the loading of data into SAP and to give an online view of all activity to the business on demand.
- Created a system to generate the purification logs to enable the city to identify data requiring purification.
- Did extensive data analysis to help all areas of the project to better understand the data and issues surrounding it. This includes an automated system to request and return test data for the testing team.
- Served as acting project manager for data for a couple of months until a SAP specialist was recruited.
Technologies: DTS, SQL, Relational Database Design, Database Architecture, Relational Databases, ETL, ETL Implementation & Design, Data Engineering, Data, SQL Server DBA, Team Leadership, DB, DevOps, Data Migration, Databases, Data Transformation, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, SQL Performance, Performance Tuning, Data Analysis, Microsoft Excel, Excel VBA, Database Administration (DBA), SQL Server 2012, Data Manipulation, Data Pipelines, Data Auditing, Stored Procedure, Scripting, Automation, SQL Stored Procedures, Dynamic SQL, Database Design, Data Integration, Performance Optimization, Complex SQL Queries, Database Schema Design, FTP, Visual Basic for Applications (VBA), Debugging, Troubleshooting, Database Development, ETL Development
Independent Contractor
2006 - 2006
Alexander Forbes Insurance
- Developed a self-contained component for integrating the quoting system with a large brokerage.
- Wrote a .NET version and wrote a migration script for another project.
Technologies: SQL, VB.NET, Visual Basic, Relational Database Design, Relational Databases, DB, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Agile, Stored Procedure, .NET, SQL Stored Procedures, Database Design, Full-stack, Complex SQL Queries, Database Schema Design, Troubleshooting, Front-end Development
Majority Shareholder
2002 - 2005
Nedbank (Client of Comvision)
- Wrote three modules for the collection system at Peoples Bank: a module to manage third-party external trace companies, a module to manage third-party attorneys, and a module to manage the handling of write-offs for the bank. All the modules were built on the Flux framework, which I developed for Comvision.
- Hired to give guidance to the MIS department at Peoples Bank. After automating the manual procedures in place and developing structures to generate and distribute reports throughout the organization, I negotiated a deal whereby Comvision supplied and managed resources to develop software for Peoples Bank.
- Oversaw the development and implementation of a collections system and an up-front segmentation system. Both systems leverage the intranet for the user interface and utilized the RDMS SQL Server to protect the data and enforce business rules. Both systems have become mission critical and are an integral part in the success of Peoples Bank. The credit checking system is responsible for assessing and processing loan applications. It comprises an out-of-process component to asynchronously query the Experion database and a system of parameter tables to manage application scoring and ensure a dynamic environment essential to the business.
- Created the debt collection system using a product called Flux, which is the property of Comvision and is a unique framework capable of developing complex workflow systems in a relatively short space of time. Flux excels at enforcing business rules for organizations whose business rules change frequently and sometimes dramatically.
Technologies: Active Server Pages (ASP), VB.NET, Visual Basic, SQL, Relational Database Design, Database Architecture, Relational Databases, Data Modeling, Data Engineering, Data, SQL Server DBA, Team Leadership, DB, DevOps, Finance, Databases, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Data Analysis, Microsoft Excel, Excel VBA, Database Administration (DBA), System Administration, SQL Server 2012, ASP.NET, Visual Studio, Stored Procedure, Data Analytics, Scripting, SQL Stored Procedures, HTML, Database Design, Full-stack, Data Architecture, Complex SQL Queries, Database Schema Design, IT Support, Troubleshooting, System Integration, Complex Data Analysis, Database Development, Front-end Development
Independent Contractor
2000 - 2000
ICS (UK-based Microsoft Service Provider)
- Contracted out to the Drug Safety Research Unit (D.S.R.U.) on behalf of ICS. The D.S.R.U. maintains a database of medical case studies in an attempt to spot long term side effect in drugs.
- Created a workflow system to manage the input of data into the database. Because of the difficulty in deciphering the handwriting of those in the medical profession, the actual documents were scanned into the system and stored on the database. We used a product called Image Basic to allow users to zoom into and out of the stored images in order to decipher the handwriting and keep track of all the notes scribbled in the margins.
- Produced a series of stored procedures, which extracted the data and images for publication.
- Created a series of GUI screens to maintain static data and data relationships.
- Identified ways of speeding up the workflow system especially with regard to uploading large images. I eliminated unnecessary processing and significantly improved performance on both the front and back ends.
- Mentored the head of the DP department.
Technologies: BASIC, SQL, Visual Basic, Relational Database Design, Database Architecture, Relational Databases, DB, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Visual Studio, Stored Procedure, .NET, SQL Stored Procedures, HTML, Complex SQL Queries, Database Schema Design, Front-end Development
Independent Contractor
1999 - 1999
Harrods, Ltd.
- Eliminated deadlocks from the Harrods Sales Audit System arising from replication conflicts.
- Wrote a management reporting system to produce formatted reports and distribute them throughout the organization via an exchange server integrated with MS Outlook. The scheduler was written in VB and the reports were formatted in MS Access and distributed via Microsoft Exchange.
- Wrote a fully transactional cash management system to reconcile actual cash collected with expected trade. The bulk of the work involved writing stored procedures in SQL with some DBA work involving replication.
- Optimized SQL queries.
Technologies: Microsoft Access, SQL, Visual Basic, Relational Database Design, Relational Databases, Data Engineering, Data, SQL Server DBA, Database Performance, DB, DevOps, Reporting, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, SQL Performance, Performance Tuning, Data Analysis, Microsoft Excel, Database Administration (DBA), Data Auditing, Stored Procedure, .NET, SQL Stored Procedures, HTML, Data Integration, Complex SQL Queries, Database Schema Design, Visual Basic for Applications (VBA), Debugging, Troubleshooting, System Integration, Complex Data Analysis, Database Development
Independent Contractor
1998 - 1999
Honda UK
- Created ActiveX components for the Honda Company Cars system, primarily all of the overnight scheduled tasks managing feeds from a mainframe system and a back-end module of stored procedures to validate vehicle documentation for accounting purposes.
- Created a report writing system making use of the Excel object.
Technologies: Microsoft Transaction Server (MTS), SQL, Visual Basic, Relational Database Design, Database Architecture, Relational Databases, DB, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Agile, Stored Procedure, .NET, SQL Stored Procedures, HTML, Full-stack, Complex SQL Queries, Database Schema Design, Front-end Development
Independent Contractor
1994 - 1997
Automobile Association of South Africa
- Analyzed, designed, developed, and implemented a claim processing system for the AA.
- Trained staff to maintain systems written by myself prior to my leaving.
- Customized a product called Customer Ixchange for the launch of a new product within the AA.
- Analyzed, designed, developed, and implemented a call taking and vehicle dispatching system for the AA’s new state-of-the-art call center. The system integrated with a trunk radio network to communicate between the vehicles in the field and the control center.
- Analyzed a new membership system. Maintained and converted PRO IV-based software to SQL Server 6 and Windows NT 3.5.
Technologies: SQL, Visual Basic, Relational Database Design, Database Architecture, Relational Databases, Data Modeling, Data, SQL Server DBA, Team Leadership, DB, DevOps, Databases, Microsoft SQL Server, SQL DML, Transact-SQL (T-SQL), Data Queries, Microsoft Excel, Excel VBA, Database Administration (DBA), System Administration, Agile, Stored Procedure, Data Analytics, SQL Stored Procedures, HTML, Database Design, Full-stack, Data Architecture, Complex SQL Queries, Database Schema Design, Debugging, IT Support, Troubleshooting, System Integration, Database Development, Front-end Development
Systems Analyst and Programmer
1988 - 1992
Huw Edwards Computer Systems
- Analyzed, designed, developed, and implemented a claim processing system for the Rand Mutual Assurance Company. During this time, I was hired out by Huw Edwards Computer Systems on a contractual basis to write the Rand Mutual System.
Technologies: Database Architecture, Relational Databases, Data Modeling, Data, DB, DevOps, Reporting, Databases, System Administration, Agile, Data Analytics, Database Design, Full-stack, Data Architecture, Database Schema Design, IT Support, Troubleshooting, System Integration, Front-end Development
Experience
Trend Exception Tool
A D3 interactive visualization for answering questions from data-driven by mining vehicle telemetry. The application was used on open-cast mines and was part of a collection of features designed to optimize operations.
D3.js Chart Portal
A React-based app to assess D3.js charts before integrating into an Ember application. The point of the app was to enable the client to choose between the many config options available before integration. The D3 charts were designed to fit into the available container and adjust themselves accordingly.
Education
Students need a way to monitor their progress in the mock exams they are taking to pass the medical board exams in the UK eventually. The application linked to was the feedback I gave the client before integrating with their Ember application.
Education
2010 - 2010
SAP Certified Application Associate in Crystal Reports
SAP - Johannesburg, South Africa
2010 - 2010
MCP in Microsoft SQL Server 2008 Database Development
Microsoft - Johannesburg, South Africa
1991 - 1991
Diploma in Business Management
Damelin Business School - Johannesburg, South Africa
Certifications
APRIL 2012 - PRESENT
Microsoft Certified Professional
Microsoft
OCTOBER 2010 - PRESENT
Certified Technology Specialist, SQL Server 2008, Database Development
Microsoft
Skills
Libraries/APIs
React, Leaflet, D3.js, jQuery, Node.js, Google Maps API, Complex SQL Queries, API Development, OpenLayers, Potree, Google Geocoding API, NumPy, Pandas, REST APIs, Recharts, jQuery UI, React Redux, Three.js, SQLAlchemy, Chart.js, Clio API, ExcelJS, PySpark
Tools
Git, Lumira, Xcelsius, Microsoft Excel, Crystal Reports, Qlik Sense, SAP Crystal Reports, Excel 2016, Microsoft PowerPoint, Google Analytics, Microsoft Access, Tableau, Eclipse IDE, Apache Tomcat, Amazon Athena, Amazon Elastic Container Service (ECS), Amazon CloudFront CDN, GitHub, Visual Studio, Amazon Cognito, AWS Batch, AWS Glue, AWS Cloud Development Kit (CDK), Postman, SQL Management Studio, Microsoft Transaction Server (MTS), SAP Analytics Design Studio, DTS, Visual Studio 2012, Azure IoT Hub, Wix, AWS SDK, MongoDB Atlas
Languages
HTML5, Transact-SQL (T-SQL), Python, SQL, JavaScript, CSS, Python 3, TypeScript, SQL DML, Excel VBA, Stored Procedure, HTML, C#, VB, AS3, Visual Basic for Applications (VBA), Snowflake, YAML, Visual Basic, VB.NET, Active Server Pages (ASP), BASIC, Java, Lava
Paradigms
Database Development, Dimensional Modeling, ETL, Database Design, Database-driven Web App Development, Business Intelligence (BI), ETL Implementation & Design, DevOps, Agile, Automation, Kimball Methodology, Model View Controller (MVC), Design-driven Development (D3), MVC Design
Platforms
Amazon Web Services (AWS), Docker, Qlik, SAP HANA, QlikView, AWS Lambda, Amazon EC2, Visual Studio Code (VS Code), Azure, AWS IoT, Amazon Lightsail
Storage
Database Architecture, Data Pipelines, SQL Server 2012, Microsoft SQL Server, Amazon S3 (AWS S3), Databases, Relational Databases, SQL Server DBA, Database Performance, DB, SQL Performance, Database Administration (DBA), SQL Stored Procedures, Dynamic SQL, Data Integration, NoSQL, JSON, MySQL, Azure SQL, SQL Server Integration Services (SSIS), MongoDB, PostgreSQL, Azure SQL Databases, PL/SQL, SQLite, Amazon DynamoDB
Industry Expertise
Web Design
Frameworks
Presto, Jakarta Server Pages (JSP), ASP.NET, MVC Razor, .NET, Material UI, Express.js, Windows PowerShell, Flex, Razor, Electron, Spark, Apache Spark
Other
Relational Database Design, Data Architecture, ETL Development, SAP Business Intelligence (BI), Dashboard Design, Web Intelligence, SAP BusinessObjects (BO), Google Earth KML, Data Visualization, Complex Data Analysis, Data Analysis, Front-end, User Interface (UI), Full-stack, APIs, Data Modeling, Data Warehousing, Data Engineering, Data, Data Warehouse Design, Data Migration, Reporting, Data Transformation, Data Queries, Performance Tuning, Data-driven Dashboards, Data Manipulation, Data Auditing, API Design, Data Analytics, Scripting, Dashboards, Front-end Development, Performance Optimization, Database Schema Design, BI Reports, Debugging, Troubleshooting, System Integration, GeoJSON, RESTFul APIs, Time Series, Reports, ETL Pipelines, Data Cleaning, ETL Tools, Material Design, IIS 7, Amazon RDS, Team Leadership, CI/CD Pipelines, Finance, System Administration, Analytics, Amazon API Gateway, Front-end Design, FTP, Business Analysis, IT Support, Data Science, API Integration, Command-line Interface (CLI), Windows 10, SAP Lumira, SAP, SAP BusinessObjects Data Service (BODS), Business Management, Azure Data Factory (ADF), Web Scraping, Web Development, User Experience (UX), Amazon Route 53, Data Build Tool (dbt), Metabase, Excel Macros, GitHub Actions
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring