Senior Analyst Settlement and Reconciliation

• Develop daily audit report for EGP 123,ACH, MC and customs and taxes transactions through comparing the operations system generated excel sheet with all transactions against the development text file that records all the transactions as well to Send accurate settlement report to CBE through RTGS system.
• Develop daily audit report for Dollar transactions (regional & International) and Master card dollar transactions (ATM & POS), To issue accurate monthly report with amounts due to different banks and send it to accounting department to issue cheques.
• Reconcile & settle Daily MC (local & international transactions) against acquiring & issuing banks posted transaction from EBC HSBC account & JB Morgan account to assure MC settled transactions in HSBC Bank and JB Morgan is accurate and verify any variations and send request to MC for settlement (debit or credit)
• Download, share ,process and Review Send the daily MFE files for Mobile project for all banks even issuer and Acquirer To process the ATM and POS mobile transactions through DCF application and ensure accuracy of transactions posted in EBC mobile System as well as send reports receive by MasterCard in share point (daily bases) regarding each bank.
• Create, review and analyze Receive Claims from Bank regarding Chargeback Dep. In banks to be analysis and process by EBC Settlement Team Send Chargeback cases for EBC-MasterCard members through MasterCard Application even ATM or POS and check the reason code before sending to Choose the accurate reason code and follow the whole cycle till end of cases.
• Analysis, Review MasterCard Billing System (MCBS ) Analysis & Review MasterCard billing reports charged on EBC and EBC MasterCard members & Analysis , Review MasterCard Fee collection Analysis & Review MasterCard Fee collection reports charged on EBC and EBC MasterCard members.
• Receive, record and follow-up Charge back info (surplus or dispute) either from EBC disputes tracking system or by email/fax from issuer network Send request to acquirer bank to investigate charge back request and transmit feedback to issuer network to take action accordingly
• Settlement of ATM charge back transactions against banks CBE accounts ( Issuer And Acquirer) to debit corresponding accounts with appropriate amounts or settle by check in-case of dollar transactions.
• Confer With client banks through email & phone to resolve problems or escalate to other departments
• Prepare Monthly report per each EBC product Send a report per each EBC product, as the main goal is to determine the whole net revenue in monthly basis besides applying the contract fees per each product regarding banks & Quarterly report for master card including cash transactions & POS transactions send the report to Master Card to debit EBC accounts with fees.
• Extract , record, compare and settle Master Card POS daily transaction files (MC generated report) to EBC databases base POS recorded transactions send accurate daily settlement reports to concerned banks and perform bi-monthly settlement for EBC accounts at HSBC.

• Bachelor of commerce with 2 to 6 years of experience relevant to same field.
• Good analytical and problem-solving skills.
• Effective verbal and written communication skills.
• Multi-task to work
• Good knowledge of Excel, and PowerPoint.
• Good Command of English in both Verbal and written.
• Fully aware of summery and operation reports concerning settlement and reconciliation of international schemes (e.g: MasterCard and VISA) and Domestic Scheme (e.g: meeza).

Egyptian Banks Company