Responsibilities:Maintaining data pipeline using AWS LambdaDBACreating new ways to integrate data from numerous third party sources using PythonCreating, maintenance and analysis of ML modelsSupplying the business with ad-hoc reportsDevelopment of Tableau dashboarsDevelopment and Management of Airflow (DAGs)Cloud Architect for AWS resourcescreate CI/CD pipelines using Bitbucket

Create Reports in SQL Server Reporting Services (SSRS) for all Retail Businesses owned by the companyCreate Analytic Reports and Dashboard using ZapBI for company dataManage and Administrate MSSQL databaseManage a clean up project for all company Retail Data using Python and Pandas and XLSXWriter library to help with data clean upOversee a team of 5 Data ClerksEnforce Data Cleanliness Policies and Good Practice in Sage ERP 300 system

Develop, review, test and maintain ETL for 15+ sources including Oracle, MySQL, Excel (via an email), REST API’s from Third Party ServicesDesign, create and extend ERDs for various databasesSetting up Kafka and design, implementation and maintenance of data pipelines for microservicesManagement and Implementation of Docker Swarm ClusterOversee a team of backend and database developersActing as Scrum Master for projects that me or my team are involved inDevelopment and… Show more Develop, review, test and maintain ETL for 15+ sources including Oracle, MySQL, Excel (via an email), REST API’s from Third Party ServicesDesign, create and extend ERDs for various databasesSetting up Kafka and design, implementation and maintenance of data pipelines for microservicesManagement and Implementation of Docker Swarm ClusterOversee a team of backend and database developersActing as Scrum Master for projects that me or my team are involved inDevelopment and Maintenance of PL/SQL Stored Procedures Show less

Researched and created ERD’s for legacy systems built on Oracle and MySQL and for a new operational data store (ODS) made in OracleCreated ERD’s for new custom built CRM system to be built on top of the ODSCreated, Reviewed and Tested PL/SQL code for Packages, Procedures and Functions used to deliver data to the Backend team, therefore removing need for custom queries and direct table accessCreated, reviewed, tested and maintained PL/SQL and Java code for ETL from (at the time) 8… Show more Researched and created ERD’s for legacy systems built on Oracle and MySQL and for a new operational data store (ODS) made in OracleCreated ERD’s for new custom built CRM system to be built on top of the ODSCreated, Reviewed and Tested PL/SQL code for Packages, Procedures and Functions used to deliver data to the Backend team, therefore removing need for custom queries and direct table accessCreated, reviewed, tested and maintained PL/SQL and Java code for ETL from (at the time) 8 different source systemAssisted with design of dashboards and reports to be presented in CRMCreating tools and plugins (mostly in Java) to add proprietary functionality Show less

Assisted Java Architect with system analysis documentsAssisted Oracle Architect with ERD modelling and requirements gatheringCoded solution with team that consolidated HTML files using a combination of Jsoup for scraping generated HTML, Bootstrap for appearance, and Javascript to decompress a Base 64 version of the HTML pages in Java