Athandiwe Zimkhitha Poyo
Johannesburg
Summary
Accomplished Technical Data Analyst and Engineer with extensive experience in developing and optimising ETL processes, SQL scripting, and data migration initiatives. Demonstrates proficiency in SSIS, SSRS and Power BI to deliver insightful operational reports and enhance business intelligence. Proven track record in managing database projects from inception to completion, ensuring data integrity through rigorous validation procedures. Adept at integrating diverse data sources for streamlined analysis and facilitating actionable insights. Career focus on leveraging technical expertise to drive process optimisation and support strategic business improvement actions.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Engineer
(Nedbank ) Redscreen (Consultant)
Johannesburg
05.2022 - Current
- Developed ETL processes with AB INITIO Express IT for data transformation and ingestion between servers.
- Executed SQL scripting for stored procedures and views to enhance database functionality.
- Conducted SAS development for advanced data processing needs.
- Performed Oracle development and reporting to ensure accurate data representation.
- Led data migration initiatives, ensuring seamless transitions between systems.
- Facilitated data discovery and analysis to uncover actionable insights.
- Created STTM documents for standardized technical communication.
- Implemented rigorous data validation procedures to maintain integrity.
- Conducted thorough data quality checks, rectifying inconsistencies and ensuring reliability of information.
- Designed and implemented scalable data pipelines, integrating diverse data sources for streamlined analysis.
- Managed lifecycle elements of ETL development, from robust testing to final deployment.
- Optimised existing data processing systems to enhance efficiency and reduce processing time significantly.
- Demonstrated outstanding technical skill, including comprehensive working knowledge of SSIS, SSRS, SQL, Python and Azure Data Factory.
- Managed database projects from start to completion, with focus on using optimum practices for designing, constructing, modifying, integrating, implementing and testing software.
- Delivered insightful operational reports through successful dataset manipulation, aiding business improvement actions.
- Crafted custom ETL Extract, Transform, Load processes tailored to specific project needs, enhancing data usability.
Data Engineer
(Absa Bank) Redscreen (Consultant)
05.2022 - 04.2023
- Developed custom ETL processes with Pentaho to meet specific project requirements.
- Executed SQL scripting, including stored procedures, for data manipulation and retrieval.
- Configured Collections and Debt Manager systems to optimize financial operations.
- Performed rigorous data quality checks to rectify inconsistencies and ensure information reliability.
Software Engineer/ Software Developer
(Standard Bank ) TalentCRU Pty (Consultant)
02.2019 - 04.2022
- Developed packages for data ingestion into database using SSIS.
- Created reports utilizing SSRS to enhance business insights.
- Designed Control M jobs to execute SSIS packages and custom database imports.
- Constructed Power BI reports and dashboards for comprehensive business reporting.
- Assisted team with ad hoc queries to support various projects.
- Resolved incidents logged by business users to maintain operational efficiency.
- Addressed daily call-outs for application failures, ensuring minimal downtime.
Education
Bachelor of Technology (Btech) - Information Technology specialising in Software Development
Walter Sisulu University
01.2022
National Diploma - Information Technology specialising in Software Development
Walter Sisulu University
01.2014
Nation Senior Certificate -
St Andrews Comprehensive School
01.2009
Skills
- SQL
- SSIS
- SSRS
- Power BI
- Control-M
- PLSQL
- Version control
- Pentaho Data Integrator
- Ab initio CBT
- SAS
- T-SQL
- Data Engineering
- Data Analysis
- Data Migration
- ETL Development
- Data integration
- Quality assurance
- Client engagement
- Business Intelligence
- Team Leadership
- Technical communication
- Risk assessment
Certification
- Microsoft Technology Associate, Software Development Fundamentals, 2017-01-01
- Microsoft Certified Professional, 2018-01-01
- Microsoft Certified: Azure Fundamentals, 2020-01-01
- Microsoft Certified: Azure Data Fundamentals, 2024-01-01
Timeline
Data Engineer
(Nedbank ) Redscreen (Consultant)
05.2022 - Current
Data Engineer
(Absa Bank) Redscreen (Consultant)
05.2022 - 04.2023
Software Engineer/ Software Developer
(Standard Bank ) TalentCRU Pty (Consultant)
02.2019 - 04.2022
Bachelor of Technology (Btech) - Information Technology specialising in Software Development
Walter Sisulu University
National Diploma - Information Technology specialising in Software Development
Walter Sisulu University
Nation Senior Certificate -
St Andrews Comprehensive School