ExperienceData Scientist | Datonomy Solutions for Woolworths Holdings LtdHybrid – Cape Town – October 2022 – Current • Analysis of variables across multiple retail stores to apply K-means Clustering machine learning algorithms to efficiently collate product assortments per store.• Utilising AWS cloud technology products such as AWS Athena for SQL queries, AWS Code Commit for git version control, AWS S3 for data storage and AWS Sagemaker for python programming and machine learning algorithms.• Data pipelines and data visualisation using AWS Quicksight

Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.Worked with stakeholders to develop quarterly roadmaps based on impact, effort and test coordinations.Discovered stories told by data to present information to scientists and business managers.Extracted and assessed data from databases to drive improvement of product development and business strategies and processes.Identified, measured and recommended improvement strategies for KPIs across business areas.Applied statistical and algebraic techniques to interpret key points from gathered data.Compiled, cleaned and manipulated data for proper handling.

Identified and documented detailed business rules and use cases based on requirements analysis.Researched and resolved issues regarding integrity of data flow into databases.Identified, analyzed and interpreted trends or patterns in complex data sets.Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.Designed and implemented tools to support strategic value chain optimization initiatives.Utilized data visualization tools to effectively communicate business insights.Used statistical methods to analyze data and generate useful business reports.

Designed a spreadsheet to assist a client in backtesting for use in algorithmic trading related to the cryptocurrency markets.Designed a spreadsheet to assist with Forex calculations in order to assist in determining various parameters such as spread, commissions and other ratiosCreated various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

• Compiling of Sales Tracking spreadsheets and reports• Automation of various financial metrics related to the Beverages division of the company• Utilisation of IRI Temple software to compile reports • Data cleaning and accessing data via the Financial Cube database

• Analysis of market prices in Futures, FX and cash markets. • Daily market reports• Reuters analysis of prices and market information• Automating processes in VBA/Excel to aid traders in spotting price opportunities• Technical and Fundamental analysis and price forecasts.• Daily reporting on prices to traders/clients

Reporting on financial figures via the integration of Oracle database software and the coding of functions in order to facilitate timely and accurate cost analysis and data integrityAnalyzed trends and monitored customer behaviors to serve as predictors for future marketplace actions.Delivered reports to company leaders focusing on financial accounting, cost accounting and sales data to guarantee that organizational objectives aligned with daily operations management.Maintained strict client confidentiality in personal, telephone and email interactions to comply with preset standards and regulations.

Worked on the forecasts and cost curves utilising various tools in Microsoft Excel such asPivot Tables and Pivot Charts as well as writing functions in VBA to automate the various systems and templates in place.• Involved in the resource allocation process via spreadsheets created in Excel• Involved in the coding of various macros and functions to assist Finance department• Automation of various mathematical functions required to asses Bill of Quantities• Writing documentation in order to aid in the processes of the organisation• Finance related tasks such as calculation of Expected Cost vs Actual Cost etc.I programmed a VBA program in Microsoft Excel which collates and calculates the incurred and forecast costs of individual projects and creates a master sheet with this information as well as a pivot chart; this effectively reduces the time taken to create such a sheet manually from 5 hours to 5 minutes, thus saving time and money. Created a real-time system that tracks safety figures across the organisation, allowing users to view and edit should such instances occur

Traded equities on the ASX (Australian Stock Exchange) for State One Stockbroking. The company has offices in Perth and Sydney and is a full trading, clearing and settlement Participant of ASX and a trading Participant of Chi-X.• Acquired IRESS software and systems knowledge necessary to operate on the ASX.• Researched ASX-listed companies based on State One criteria.• Traded ASX-listed equities on a short term basis often closing trades within seconds taking advantage of the mispricing of small cap stocks.

• Forecasting the Costs and Manning hours of the Project.• Collecting, Recording and Analysing variances in Timesheet Hours.• Preparation of Monthly Reports and Flash Reports detailing the progress of the Project.• Utilising the CMS Software to record Cost and Time changes in the Project.• Drawing up Cost Curves in Microsoft Excel to keep track of the Project costs.• Approving and at times drawing up Contracts/Purchase Orders for Subcontractors.• Sending, Receiving and Recording Invoices.• Preparing budgets for the Project, particularly when the scope had changed.• Trend and Change Management • Telephonically communicating with both clients and suppliers and resolving issues