Natasha Ndlovu

(- |-www.linkedin.com/in/natasha-zama-ndlovu/ https://nashzama.github.io/NashAnalytics.github.io/ Harare, Zimbabwe Data Analyst/ Business Analyst NATASHA Z NDLOVU Skills • • • • SQL (SQL Server, MySQL, PostgreSQL) Python (Pandas) Tableau • • Microsoft Azure (DataBricks, Azure Data Lake, Azure Data Warehouse) Microsoft Power BI Excel (VLookup, Conditional Formatting, Pivot Tables) Projects D AT A CLEAN ING IN S QL – Personal Project – Harare, Zimbabwe ● ● ● Utilized SQL to perform reviewing and profiling of the raw housing data to identify inconsistencies. Developed SQL scripts to perform various data cleaning tasks. Transformed and filtered data by using aggregating and filtering function to improve reporting process. D AT A P RO FES S IO NALS S U RV EY D ASH BOARD – Personal Project – Harare, Zimbabwe ● ● ● February 2023 Created a dashboard with Power Bi to analyze data professionals' satisfaction with work/life balance and salary, and the challenges faced in entering the field, segmented by gender. Transformed and processed survey data by using DAX and Excel to ensure data completeness and validity. M O V IE CO RREL AT IO N WIT H P YT H O N – Personal Project – Harare, Zimbabwe ● August 2023 November 2022 Utilized Python to look at what variables affect the gross revenue from movies. Loaded and visualized data with Python to identify key business intelligences that can improve sales performance. Work Experience ET L D EV ELO P ER – ZB BANK – Harare, Zimbabwe ● ● ● ● Designed and developed ETL processes to extract, transform, and load data from various sources into our data warehouse. Optimized and fine-tuned ETL workflows, enhancing system efficiency by 40% , Successfully collaborated with cross-functional teams to understand data requirements and implement effective data models. Troubleshot and resolved issues related to data integration, ensuring data accuracy and consistency. BU S INES S I NT ELLIG ENC E ANA LYS T – ZB BANK – Harare, Zimbabwe ● ● ● ● ● ● January 2020 - December 2021 Developed and automated visually appealing reports and dashboards using BI tools such as Power BI/Tableau. Performed data analysis to identify trends and anomalies, identified and resolved 95% of data anomalies, resulting in more accurate reporting. Developed and maintained processes around data governance. Provided actionable insights that led to a 10% increase in sales conversion rates. Prepared KPI reports incorporating key industry metrics and analysis against peers. FINANCI AL AN ALYS T INT ERN – ZB BANK – Harare, Zimbabwe ● January 2022 - Present January 2019 -December 2019 Conducted market research and built discounted cash flow model. Prepared in-depth valuations and other financial analysis. Education BU S INES S INT E LLIG ENC E AND D AT A AN A LYS T CERT IFI CAT IO N – CFI FINANCI AL M O D ELLING AND V ALU AT IO N ANALYS R CERT IFI CAT IO N – CFI B.CO M M H O NS IN BANKING & INV ES T M ENT M G T – National University of Science & Tech – Byo, Zimbabwe May 2023 Aug 2022 Nov 2017