Sarah Marshall

Experienced Data/Cloud Engineer
  • North Riding, South Africa
  • January 24, 2023

Data extraction and aws cloud report automation to allow generation of scheduled reporting and best practices in accessing cloud based db configs. SQL and python for the extraction, cleansing and transformation of data for reporting. PowerBi advanced for report visualisation. Database design and modelling as well as the implementation of access control measures to align with governance standards and the protection of personal information, including creation of db views and various methods of authentication. Accessing and utilisation of various aws products and services including ssm, ses, lambda, ec2, code commit etc.  Database and reporting support of various company chapters and departments to ensure the accurate and qualitative reporting of business information that supports operations and business decisions. Github for collaboration on projects. Test support and the identification and resolution of production issues.

AWS Cloud Services data warehouse implementation including implementation of various AWS products. Extraction of data from various sources, including RestFul API, FTP and other. Python for extraction and loading of data including data manipulation, cleansing. Dashboard creation using software such as PowerBi, AWS Quicksight and Excel automation with Python.  API staging and deployment to production. Business Analysis activities including table mapping, UML drawing, Requirements gathering and Solutions etc. Mongodb and pentaho Warehousing basic implementation. MS PowerApps and automate. Automation reporting scripting and business process flow streamlining and maximisation.

 

E-mail
rusasarut@gmail.com
Phone Number
+27737051063

Education

Computer Science @ University of South Africa
Feb 2019 — Feb 2023

Experience

Data Engineer @ Metropolitan Getup – Data Engineer
Feb 2022 — Current

Data extraction and aws cloud report automation to allow generation of scheduled reporting and best practices in accessing cloud based db configs. SQL and python for the extraction, cleansing and transformation of data for reporting. PowerBi advanced for report visualisation. Database design and modelling as well as the implementation of access control measures to align with governance standards and the protection of personal information, including creation of db views and various methods of authentication. Accessing and utilisation of various aws products and services including ssm, ses, lambda, ec2, code commit etc. Database and reporting support of various company chapters and departments to ensure the accurate and qualitative reporting of business information that supports operations and business decisions. Github for collaboration on projects. Test support and the identification and resolution of production issues.

Data Analyst @ Axsure Administrators
Mar 2020 — Jan 2022

AWS Cloud Services data warehouse implementation including implementation of various AWS products. Extraction of data from various sources, including RestFul API, FTP and other. Python for extraction and loading of data including data manipulation, cleansing. Dashboard creation using software such as PowerBi, AWS Quicksight and Excel automation with Python. API staging and deployment to production. Business Analysis activities including table mapping, UML drawing, Requirements gathering and Solutions etc. Mongodb and pentaho Warehousing basic implementation. MS PowerApps and automate. Automation reporting scripting and business process flow streamlining and maximisation.

Associate BI Data Analyst @ Constantia Insurance
Jul 2016 — Oct 2019

Agile implementation of new insurance product to market. Engaging with users, stakeholders, external and internal, developers, digital marketers and sales teams. Ensuring initial scope implementation as well as updating of requirements and documenting iteration workshops, scrums, requirements specifications etc. UX engagement to identify potential users and identify target market to initiate user cultural and behavioral motivation. Engaging with various users and developers on user acceptance criteria, documenting and liaising with users consistently throughout project. Various UML diagrammatic documentation, process flows, use cases, activity diagrams. Ensuring that compliance and all legal/regulatory requirements and expectations are met by stakeholders, system and developers, ensuring best practices and full accountability. Sign off on UAT, full engagement with developers during each iteration.
Marketing insurance products, resolving customer queries. Social media marketing and drawing up and creating marketing material, eg: articles, presentations, imaging for billboards, social media etc. Compliance function, insuring that all communication complies with the FAIS act and with underwriting legality.

Contact Candidate

Contact
Back to top button