Alfred Dende

Database Administrator & SAP BI Specialist
Experienced database administrator specializing in high-availability configurations, system upgrades, performance tuning, and adherence to configuration policies across SAP and non-SAP environments. Proficient in data modeling, ETL processes, and data warehousing using SAP Data Services and MSSQL. Expertise in developing Universes, Reports, and Dashboards with SAP Web Intelligence and BOBJ 4.2. Strong ability to analyze user requirements, design BI applications, and ensure optimal data governance. Skilled in workflow automation, data transformations, and batch-job scheduling using SAP BODS. Adept at executing test plans, system monitoring, and metadata reporting while delivering strategic insights to stakeholders.

This version highlights your technical expertise and leadership in database administration, SAP BI, and ETL processes. Let me know if you'd like any refinements!

• Improved customer satisfaction by promptly addressing and resolving support issues.
• Increased efficiency of problem-solving by implementing automated diagnostics tools for common issues.

SAP Solutions Architect & Technical Lead
Highly experienced in SAP system administration, implementation, and optimization, with expertise in upgrading SAP ECC environments to the latest versions of SAP S4HANA. Skilled in database migrations, including transitioning from Sybase to SAP HANA. Strong leadership in overseeing SAP consultants, driving security and role-based administration, and ensuring seamless system operations. Adept at managing enterprise-wide SAP workflow email notifications, system performance tuning, and disaster recovery planning. Expertise in SAP Basis, landscape synchronizations, SAP HANA Database administration, and Change & Transport Management. Proven ability to execute technical architecture analysis, administer ABAP development, and ensure high availability of mission-critical systems.

This version emphasizes your technical leadership, system administration expertise, and project execution skills in a way that suits Australian resume expectations. Let me know if you'd like any refinements!

• Install and upgrade SAP application from SAP ECC 6 EHP6 to SAP ECC 6 EHP8 including application servers, and databases.
• Provide input to budget, ensure cordial relations with SAP service providers.
• Ensure correct operation of SAP workflow email notifications in SOST, SCOT, SM37, SMICM, SBWP.
• Take technical lead in all SAP projects and deliver technical as well as functional support of SAP.
• Migrate from the legacy Sybase database and ZINARA is now running on the latest SAP HANA database.
• SAP HANA Database administration using HANA Studio.
• Implement software upgrades, enhancements, patches as needed in coordination with technical, functional teams and business users.
• Proactively monitor and manage the environment on day-to-day basis.
• SAP System Landscape synchronizations of DEV, QAS and PRD.
• Lead SAP consultants and implemented security and role-based user administration to ensure systems are enabled and working correctly.
• Implemented offsite cloud-based backup to ensure high availability and disaster recovery of SAP and they are in place and are working correctly to detect faults, minimize malfunctions and backup systems.
• SAP super-user training for best practice, backup, restore, system administration.
• Confirming the successful daily backup of all customer systems on Sybase, Oracle, MSSQL, and SAP HANA.
• Tune SAP environments to ensure integrity, and stability and optimal performance.
• Upgrading and maintaining the ZINARA systems to provide a correct picture of the prevailing situation.
• Maintain server documentation, configuration and server mapping to ensure efficient operation of all systems.
• Develop and deploy methodologies for testing system performance, conduct testing and develop disaster recovery plans, ensure high availability and acceptance levels of mission critical processes.
• Administering SAP workflow and ABAP development as well as payroll development.
• Perform periodic system refreshes non-production systems and maintain multi-landscape environments.
• Ensure adherence to configuration management policies and execute SAP transports.
• Change and Transport Management System using STMS- Within 3 System Landscape and 2 System Landscape and Single System Landscape.
• System Parameter changes and maintenance in RZ10, RZ11.
• Upgrading SPAM version, Deployment of SAP Support Packages and Patches using SPAM and SAINT.
• Background Job Scheduling and ABAP Dumps Monitoring.

• Collaborated with cross-functional teams to achieve project goals on time and within budget.
• Improved customer satisfaction rates through proactive problem-solving and efficient complaint resolution.

SAP PCoE & Enterprise Cloud Services Specialist
Highly skilled professional with extensive experience in SAP Partner Center of Expertise (PCoE) audits, system architecture, and enterprise cloud services. Expertise in SAP S4HANA Basis, Linux administration, and Oracle database management. Adept at leading consultants, managing customer transitions, and ensuring seamless project delivery. Proven ability to optimize system performance, execute upgrades, and maintain security compliance. Strong collaborator with development teams, driving enhancements and troubleshooting technical challenges. Skilled in stakeholder engagement, service reviews, and incident management to ensure customer success.

This condensed version highlights your leadership, technical expertise, and key responsibilities while remaining clear and engaging. If you need adjustments or specific emphasis, let me know, and we can refine it further!

• Company Overview: City of Johannesburg Municipality
• Migration of SAP S4HANA systems from Azure to OnPremises.
• Closely collaborate with client's 3rd party vendors supporting Infra and other systems connecting to SAP.
• Handle OS Administrations tasks with City of Johannesburg hosted on AWS and Azure Cloud.
• Perform pre/ post checks on systems migrated from Azure to On-Premises.
• Contribute to the liaison with different SAP stakeholders, especially virtual customer success partner involved in the accounts, to ensure customer success.
• Take ownership of SAP S4HANA Basis and Linux administration activities including system builds, upgrades, patches, system refreshes, configuration, system monitoring, performance tuning, back-up and recovery.
• Perform a thorough Technical Architecture Analysis and consolidate into an overall Technology Architecture for SAP S4HANA readiness Develop Reports and Dashboards, test reports accuracy and security matrix using Oracle Database.
• SAP HANA Database administration using HANA Studio.
• Monitor user buffer with SU56, Maintain Authorization Objects using SU21, transfer new/updated authorization defaults from the SAP area (SU22) to the Customer area (SU24) in Transaction code SU25.
• Use SUIM User Information System to search for roles and authorizations, search for transactions in roles, transactions executable for a user, and track changes through Change documents etc.
• Administer SAP S4HANA, Microsoft SQL Server, Sybase, Oracle databases.
• Installs, upgrades, patches, data refreshes, configuration, database monitoring, performance tuning, back-up and recovery.
• Maintain SAP Security roles, performs user administration tasks including role assignment changes.
• Manage SAP users, authorizations, and profiles to maintain security of the SAP environment.
• Support team operations by coordinating tasks and monitoring progress to ensure deliverables are met on time.
• Provide responsive and effective support to clients using ERP software, focusing on financial and supply chain functions.
• Address client inquiries and troubleshoot technical issues to ensure satisfaction and efficiency.
• Build proficiency in ERP software to deliver both consulting and support services.
• City of Johannesburg Municipality

• Take ownership for SAP S4HANA Basis and Linux administration activities including system builds, upgrades, patches, system refreshes, configuration, system monitoring, performance tuning, back-up and recovery.
• Data Warehouse Integration Schema Data Model on S4HANA.
• Work closely with clients and internal teams to identify areas for improvement in financial and supply chain operations.
• Balance teamwork with the ability to work independently to achieve objectives.
• Pre-requisite Pre-Checks and Pre-Requisites.
• Assessment of Current SAP ECC Landscape before beginning the conversion process, a detailed review of the current SAP ECC landscape and business processes to identify gaps and areas for improvement.
• Project Planning for Brownfield Migration.
• Maintenance Planner tool for planning updates, upgrades, and new installations in your system landscape.
• ABAP Test Cockpit source code analysis and code quality toolset.
• Technical Conversion Phase using SAP Software Update Manager.
• Data Cleansing and Optimization: Cleanse and optimize data to ensure that it is compatible with SAP S/4HANA.
• Leveraging S/4HANA Capabilities for Business Transformation: Leverage new features and functionalities of SAP S/4HANA to transform your business processes.
• S/4HANA Managed Services and SAP Managed Services to guarantee system is working.
• Perform a thorough Technical Architecture Analysis and consolidate into an overall Technology Architecture for SAP S4HANA readiness Develop Reports and Dashboards, test reports accuracy and security matrix using Oracle Database.
• Develop test data sets, test overall process and system integration.
• Conduct User Training, perform testing of the end-to-end overall process and system integration.
• Administer SAP S4HANA, Microsoft SQL Server, Sybase, Max DB databases.
• Installs, upgrades, patches, data refreshes, configuration, database monitoring, performance tuning, back-up and recovery.
• Maintain SAP Security roles, performs user administration tasks including role assignment changes.

• Install and upgrade SAP application from SAP ECC 6 EHP6 to SAP ECC 6 EHP8 including application servers, and databases.
• Implement software upgrades, enhancements, patches as needed in coordination with technical, functional teams and business users.
• Proactively monitor and manage the environment on day-to-day basis.
• Tune SAP environments to ensure integrity, and stability and optimal performance.
• Perform periodic system refreshes to non-production systems and maintain multi-landscape environments.
• Ensure adherence to configuration management policies and execute SAP transports.
• Manage SAP users, authorizations, and profiles to maintain security of the SAP environment.
• Performing homogenous and heterogeneous system copies as required.
• Disaster Recovery Setup using both manual and automatic methods.
• SAP FIORI Baseline Configuration.
• Applying for and installing SAP Licenses.
• System monitoring and performance tuning which involved modifying the values of memory parameters, scheduling clean up jobs and reports, checking for SM13 entries, Table reorganizations.
• SAP System Landscape synchronizations of DEV, QAS and PRD.
• Defining Logical systems and assigning them to clients.
• Perform Daily, Weekly, Monthly Quarterly Basis Administration Tasks.

• Install and upgrade SAP application from SAP ECC 6 EHP6 to SAP ECC 6 EHP8 including application servers, and databases.
• Implement software upgrades, enhancements, patches as needed in coordination with technical, functional teams and business users.
• Proactively monitor and manage the environment on day-to-day basis.
• Tune SAP environments to ensure integrity, and stability and optimal performance.
• Perform periodic system refreshes non-production systems and maintain multi-landscape environments.
• Ensure adherence to configuration management policies and execute SAP transports.
• Change and Transport Management System using STMS- Within 3 System Landscape and 2 System Landscape and Single System Landscape.
• System Parameter changes and maintenance in RZ10, RZ11.
• Upgrading SPAM version, Deployment of SAP Support Packages and Patches using SPAM and SAINT.
• Background Job Scheduling and ABAP Dumps Monitoring.
• Spool Administration using TCODES SP00, SP01, SP02, SP12 TemSe Administration, SPCC.
• SAP License Auditing.
• SAP Buffer Memory Management, tuning and troubleshooting.
• Database administration, Database backup scheduling, recovery and performance monitoring and tuning, Space Management using BRTools, DB13, DB12, RSync backup on Linux and Windows Full system backup.
• Configure Sybase ASE Backups.
• Create, schedule, and monitor cron jobs for SAP Netweaver System backups on Sybase ASE.
• MaxDB database administration using MaxDB Database Studio and DBMCLI.
• SQL Server database administration using SQL Server Management Studio.
• SAP HANA Database administration using HANA Studio.
• Database admin using T Codes DB12, DB13, DBACOCKPIT.