Morahi Tsotetsi

Accomplished, senior-level Technical Product Analyst and Application Support Specialist with over 20 years of extensive experience optimizing enterprise financial ecosystems, core banking products, and large-scale relational data platforms. Adept at independent root-cause analysis, production incident diagnostics, and developing complex SQL queries from scratch for both online and high-volume batch processing environments. A proven track record of serving as a Tier-3 technical escalation point, utilizing SPUFI for live production data remediation, and translating complex technical issues into clear business solutions.

Highly adaptable database specialist offering transferable procedural logic capabilities suited for enterprise software platforms.

Technical Product Analyst & Database Consultant (Freelance) - ONEACCESS PTY LTD

(2014-07)

Ad-Hoc Data Operations & Client Consulting (2018 – Present)

• SQL Query Development: Engineered ad-hoc, complex SQL statements from scratch to perform critical data remediation, execute high-risk data corrections, and cleanse raw datasets to restore production readiness for corporate clients.
• Data Pipeline Automation: Optimized data product delivery by building automated pipelines via Power Query and Python, removing manual data preparation cycles and transforming raw transactional datasets into structured customer performance metrics.
• Business Intelligence: Delivered data-driven decision support to executive stakeholders by designing interactive Power BI dashboards that translated multi-source operational trends into actionable commercial insights.
• System Auditing: Mitigated systemic operational risks by independently auditing software architectures, network distribution tools, and data centre backup workflows to ensure high-availability framework alignment.

Basic Accounting System (BAS) Consultant / Product Analyst - NATIONAL TREASURY(SITA)

(2013-07 - 2014-07)

• Advanced Query Optimization: Refactored and optimized complex SQL queries on live DB2 databases to support critical financial reporting and ensure total data integrity across national, provincial, and municipal accounts.
• Production Database Manipulation: Coded complex relational database queries from scratch to handle both real-time online processing and high-volume batch data corrections based on urgent client requests.
• System Impact Analysis: Performed rigorous data impact analyses and architectural assessments for systemic infrastructure upgrades to safeguard priority government financial flows.
• Knowledge Management: Modernized and completely updated the official BAS user training documentation to accelerate the technical onboarding of internal and municipal staff.

Change Management Consultant - STANDARD BANK GROUP TECHNOLOGY

(2012-09 - 2013-05)

• Infrastructure Administration: Directed product deployment infrastructure by managing full-cycle administration and system configuration for ChangeMan ZMF across IBM Mainframe and AS400 environments.
• Incident Resolution: Actively troubleshooted and resolved ad-hoc technical configuration issues to maintain maximum uptime for core deployment pipelines.
• System Integrity Reporting: Generated daily system integrity and health reports across the enterprise release management framework to provide operational insights for leadership.

Analyst Programmer / Systems Consultant (Application Support) - ABSA GROUP TECHNOLOGY

(2009-01 - 2012-08)

• Tier-3 Application Support: Provided high-tier application support with 24/7 standby availability for Absa Group Retail Banking and High-Volume Corporate Investment Banking (CIB) Foreign Exchange (Forex) IT settlement networks.
• Live Database Diagnostics: Utilized SPUFI and mainframe utilities to run live database diagnostics, analyse complex data structures, isolate root causes, and deploy immediate data fixes under strict corporate SLAs.
• System Performance Tuning: Effectively performed system tuning and query optimization undertakings on high-volume transactional data platforms to enhance processing efficiency.
• Industry Committee Representation: Appointed as the corporate technology representative on the Payment Association of South Africa (PASA) Real-Time Clearance (RTC) Technical Committee.

Senior Systems Analyst / Programmer (Application Support) - FIRST NATIONAL BANK (FNB)

(2007-06 - 2008-12)

• Root-Cause Diagnosis: Provided critical application support for Hogan core banking technologies by analysing system logs, diagnosing root-cause technical issues, and resolving core system defects.
• Performance Tuning: Executed deep system impact analyses and system tuning operations to maintain platform stability and monitor high-volume transaction flows.

Senior Software Analyst / Graduate Intern - STANDARD BANK GROUP TECHNOLOGY

(2001-01 - 2007-05)

• Technical Specification Design: Bridged the gap between business and IT divisions by translating high-level Functional Software Specifications (FSS) into architectural Technical Software Specification (TSS) blueprints.
• Integration Support: Served as primary Subject Matter Expert (SME) for Electronic Funds Transfer (EFT) and Code Line Clearing (CLC), steering cross-functional platform integrations with BankServ.

Banking Module Certification - Banking - Damelin School of Banking

Structured Programming Diploma - COBOL - Training and Development for the Future (TDF)

BCom - Accounts and Information Systems - University of Cape Town

Senior Certificate / Matric - Nkhobiso Senior Secondary School