L. Tankiso Maduana

KEY RESPONSIBILITIES:

• Work closely with management to priorities business and information needs.
• Facilitated smooth system migrations while minimizing downtime, carefully managing change control processes and ensuring thorough testing procedures.
• Increased productivity by automating manual report generation through the development of dynamic templates.
• Optimized data warehouse performance with meticulous ETL optimization and regular maintenance tasks.
• Designed and developed forward-thinking systems that meet user needs and improve productivity.
• Locate and define new process improvement opportunities.
• Developed custom dashboards and visualizations to provide actionable insights for key stakeholders.
• Conducted detailed root cause analyses to troubleshoot complex issues within the BI environment, resulting in swift resolutions of critical problems.
• Reduced query response times significantly, optimizing database indexes and fine-tuning SQL scripts.
• Enhanced decision-making capabilities by designing and implementing advanced business intelligence reporting tools.
• Mentored junior team members on BI concepts and best practices, fostering a culture of continuous learning within the team.
• Delivered timely, high-quality reports under tight deadlines, ensuring that stakeholders had access to critical information when needed.
• Improved data quality by implementing robust validation checks during the ETL process.
• Standardized data definitions and metrics across the organization by establishing comprehensive data dictionaries, leading to more accurate reporting and analysis.
• Streamlined data analysis processes for improved efficiency and accuracy, utilizing SQL queries and stored procedures.
• Strengthened data security measures by establishing strict access controls and monitoring protocols.

SYSTEMS, CLOUD SERVICES, SOFTWARE APPLICATIONS:
• Collaborator
• Internet
• Intranet
• Meditech
• Microsoft SQL Server
• Microsoft SQL Stack-BIDS
• Microsoft Power Automate
• Microsoft Power BI
• Visual
• Jira

• Design, build and deploy BI solutions (Dashboards, reporting tools)
• Maintain and support data analytics platforms (in-house built)
• Evaluate and improve existing BI systems
• Develop and execute database queries and conduct analyses
• Create visualizations and reports for requested projects
• Develop and update technical documentation
• Design, build and deploy BI solutions (Dashboards, reporting tools).
• Maintain and support data analytics platforms (in-house built).
• Evaluate and improve existing BI systems.
• Develop and execute database queries and conduct analyses.
• Create visualizations and reports for requested projects.
• Develop and update technical documentation.
• Generated reports, updated spreadsheets, and presented results.
• Optimized data processing for faster insights by designing efficient ETL processes and data models.
• Wrote and optimized SQL statements to assist business intelligence practices.

• Designing, developing, and maintaining business intelligence solutions
• Crafting and executing queries upon request for data
• Presenting information through reports and visualization
• Weekly Standby - Support and resolve operational issues
• Monitored and optimized SQL server performance.
• Generated reports, updated spreadsheets, and presented results.
• Optimized data processing for faster insights by designing efficient ETL processes and data models.
• Automated BI reports for secure virtual server environment.

• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
• Conducted data modeling, performance and integration testing.
• Developed conversion and system implementation plans.
• Developed software for desktop and mobile operating systems.
• Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.

• Assisted mentees in setting realistic short-term goals that align with long-term ambitions increasing accountability in goal achievement.
• Established strong relationships with students, building trust and open communication channels for ongoing support.
• Monitored student academic progress, communicating with each student frequently and intervening to assist students experiencing difficulties.
• Monitored student progress through regular check-ins, adjusting mentoring strategies as needed.