SUMAYAH Sumayah

· Ad-hoc duties – Allocating payments from Suspense account reconciliation system, attending to refund requests for debt counselors and customers.

· Follow the allocation of payment process if proof of payment is received where the payments do not reflect on the matter.

· Analyze debt review trends

· Liaising with debt counselors and customers queries daily via Fresh Desk and inbound line.

· Processing all debt review documents: 17.1,17.2, 17.w, payment proposals, court documents, Sequestration and Administration.

· Investigate and resolve Hello Peter complaints escalated by team manager.

• Monitor performance of database systems resources and query throughput.
• Back Up and Restoring of databases.
• Optimize SQL Code as necessary.
• Monitor and maintain database storage resources
• Schedule a backup with SQL server agent.
• SELECT queries: DDL, DML.
• Grant User access and Permissions on SQL.
• Create windows logins and windows accounts.
• Create and Execute Stored Procedures.
• blocking and deadlocking.
• SQL Activity Monitor.
• Tracing- SQL Server Profiler.
• INDEXES ( Clustered – Non Clustered).
• SQL Performance Tuning.

Trouble shoot and resolve database connectivity issues.

• Maintain and administer database security access.
• Proactively monitor and respond to MSSQL database Alerts.
• Perform database Ad-hoc backups and restores.
• Installing SQL Server Instances.

• · Generating documents: settlement letters, paid up letters, statements.
• · Resolving customer queries from the call center via Query Net.
• Updating customer information on the system: Title, Name, Surname.
• Daily, weekly, and monthly reporting: Collections Dialer Report, Agent bucket count
• Hyphen Duties- Allocating payments from suspense, running receipts and bank statements received from Hyphen. debit orders, collections Ad hoc payments. Uploading/ Downloading disbursement Batch via FTP site, processing manual and auto refunds, Running collections dialer and sms job via package executor.
• Trouble shooting and reporting technical issues, experienced in the call center.
• Assisting IT with service requests.
• On boarding of new starters