Nicola Toma Email & Phone Number

Cape Town, Western Cape, South Africa

Migration of on prem data to AWS cloud, datalake formation, datawarehouse creation and maintance.

Cape Town Area, South Africa

• Worked as Business Intelligence and Data Engineer Consultant at Pernod Ricard and Capitec Bank respectively:Data Engineer at Capitec Bank (Jan 2020-Present):
• Writing SQL stored procedures in an enterprise data warehouse and datalake
• Ad hoc data analysis and projects including SMS campaigns, case studies etc.Business Intelligence Analyst at Pernod Ricard (Nov 2018-Dec 2019):
• Migrated QlikView production server with over 150 models using custom coded Python scripts to bulk edit reload scripts and transform server file architecture.
• Maintained and modified Power BI dashboards and created power queries for manipulating data in Power BI.
• Troubleshooting inaccuracies, model change requests and maintenance of QlikView models in a BI production environment.

Cape Town Area, South Africa

• Routine Excel reports for sales teams using Salesforce and Qlikview data sources on daily and weekly lead KPIs, daily bookings reporting, pre-released orders, exception reports and pipeline opportunities from existing.
• Built commercial bookings and retail sales leads dashboards in DOMO (an online BI platform).
• Wrote Python code to scan through our repositories of SQL scripts and extract the names of tables used using regular expressions. This was used to manage the migration of Oracle databases to AWS.
• Converted Oracle SQL scripts into MySQL scripts and wrote YAML scripts for a new ETL process that fed a data lake running on AWS.
• Routinely worked with GitHub as the central repository for the YAML scripts.
• Frequently assisted colleagues with their SQL challenges during the data migration.

• Designed and ran routine sales reporting dashboards and ad hoc data analysis requests.
• Routine Excel reports for sales teams using Siebel On Demand (SOD) and Qlikview data sources on daily and weekly lead KPIs, daily bookings reporting, pre-released orders, exception reports and pipeline opportunities.
• Built automated reports in Excel using data connectors and data cubes which cut down weekly workloads from tens of man hours to an hour or two.
• Learnt Oracle SQL and had an introductory course in QlikSense followed by building a analytical leads dashboard in QlikSense.
• Built new automated dashboards for pending order queue in Oracle BI Enterprise Edition (OBIEE). All was managed by ticketing in JIRA and documented on Confluence.
• Performed data analysis for historical sales metrics used in quarterly business reports. Was awarded the certificate for excellence by the company for my work in report automation in Excel.

Bachelor’S Degree, Chemical Engineering

High School, English, Afrikaans, Mathematics, Physical Science, Biology, Technical Drawing, Computer Science, Graduated With 6 Distinctions (A Grades)

Activities and Societies: Chess