Data Analytics & AI-Driven Insights Specialist

Kondwani Ngwira

Mckinney, Tx ****** +1-469-***-**** **************@*****.*** LinkedIn Gitshub EDUCATION

University of North Texas May 2025

Master's, advanced data Analytics (Data Science) and Generative AI

• GPA: 3.9/4.0

EXPERIENCE

CHANGING THE PRESENT Sep 2025 - Present

Data Analyst Florida, New York

• Automating ETL transfer of applicant resumes, cover letters, and supporting documents from Google Sheets to Box.com using Python and R.

• Creating and maintaining organized folder structures in Box.com to securely store applicant files and prevent duplication.

• Streamlining applicant data management by implementing database design principles to integrate JotForm submissions into Google Sheets for easy processing.

• Uploading and categorizing multiple file types (PDFs, JPGs, PNGs) into applicant-specific folders for efficient retrieval.

• Author a step-by-step process manual to enable interns and team members to replicate workflows with minimal training SPRINGER CAPITAL Sep 2024 - Dec 2024

Data Automation Intern (Data Analyst)

• Developed and maintained automation tools and workflows to optimize business processes, leveraging Power Automate and SQL queries to analyze data and extract actionable insights.

• Collected, cleaned, and integrated data from multiple sources using R scripts, collaborating with teams to implement data-driven solutions and enhance operational efficiency.

OPULENCE Feb 2021 - Aug 2023

Data Analyst/Business Analyst

• Led stakeholder workshops, implementing change management strategies to improve data management processes and build interactive dashboards.

• Analyzed operational data using statistical and regression analysis in Python, leveraging data structures for efficient data processing, which improved data accuracy and insights

• Developed dashboards in Tableau and Power BI, visualizing key performance indicators to enhance decision-making and improve data management practices.

• Conducted statistical analysis for a literacy project, increasing beneficiary employability by 40%; demonstrated data analysis, change management, and data structure skills

PLAYWORLD Feb 2019 - Jan 2021

Technical Support Specialist Blantyre

• Resolved customer gaming system issues, providing technical support and ensuring smooth operation, contributing to positive customer experience and overall business operation.

• Managed strategic partnerships and collaborated with senior leadership to drive alignment, strengthen relationships, and achieve key business objectives

• Troubleshooted hardware, software, and network issues impacting Video Game functionality, documenting all helpdesk interactions.

• Led team efforts, decreasing cyber threats by 50%, showcasing leadership, technical expertise, and enhanced business operation strategies PROJECTS

Generative AI Q&A search system 2023 - 2025

• Developed a Generative AI Q&A system by designing a novel data model and implementing distributed computing techniques, leveraging Large Language Models (LLMs) on Google Cloud Vertex AI to deliver accurate, scalable, and real-time responses for complex user queries.

• Engineered and deployed deep learning forecasting models for NVIDIA and Tesla stock prices by applying advanced time-series modeling and integrating technical indicators; optimized model performance to achieve 95% forecasting accuracy, enhancing decision-making insights for financial market analysis.

SKILLS

• Programming Languages: Python, SQL, R

• Data Analysis and Visualization Tools: Tableau, Excel, Power BI

• Machine Learning and AI: Predictive Modeling, Generative AI, LLMs, deep learning forecasting models

• Cloud Platforms: GCP, Google Cloud Vertex AI, active directory

• Business Acumen: Business Analysis, Communication Skills, Problem-Solving

• Data Engineering and Database Management: ETL Processes, Database Design, Database Management SUMMARY

Data Analyst proficient in SQL, Python, and data visualization tools such as Tableau and Power BI, with hands-on experience in automating ETL processes and integrating diverse data sources. Skilled at designing interactive dashboards and employing statistical analysis to uncover actionable insights and improve data accuracy. Demonstrated ability to streamline workflows and support strategic decision-making in cross-functional teams.

Contact this candidate