Busines Analyst
Barclays Shared services
Total years of experience :21 years, 3 months
Currently working in Barclaycard partnership reconciliations under Retail & Business Banking as Team Support Specialist (Business Analyst3) in GL Control department.
-: Handling daily, weekly and monthly General ledger, Bank and Account receivable reconciliations.
-: Used SAP P11 software to pull data of GL balances and transactions activity and Vision plus used for view the customer data regarding Barclaycard.
-: Daily GL reconciliations include Cardholder lending account and System integrity reconciliations of 6 partnership deals with Barclaycard.
-: Weekly General & Bank reconciliations include : sundry accounts, bank accounts of shopper card & Thomas cook, Working capital of Thomas cook.
-: Monthly Joint Venture reconciliations which include SPF (solution personal finance) between Barclaycard & Little wood company & Thomas cook JV.
-:Weekly Account receivable (AR) reconciliations regarding 6 deals with Barclaycard includes- Bill payment, Telephone & Internet suspense, Unpaid, clearing difference, remittance, card scheme, BACS & PPI.
-: Weekly Branch AR accounting reconciliations.
-: Daily Cardholder lending & System integrity reconciliation and Weekly GL Direct debit and Rejected suspense reconciliation (Multiple currency-USD, EUR, GBP, SGD, CHF & HKD)of Barclays Wealth Merrick process.
-: Keep tracking upon the SWIFTS which processed via CHAPS must be reflected in the bank statement under Merrick which is pertains to Barclay wealth process in multiple currencies.
-: Prepare the monthly log for open items regarding Merrick GL reconciliation and discussed with customer on weekly basis.
-: Weekly Prepared Merrick Bank & AR reconciliations.
-: Monthly AR control accounts.
-: Prepared Monthly GL Fraud reconciliation.
-: Handling monthly AR Issuer & Merchant Chargeback reconciliation.
-: Maintained GL & AR monitory log tracker every weekly to keep track on balances.
-: Daily doing force clearing for BPF GL suspense accounts-Cheque, BACS, CHAPS, Unidentified & Identified receipts and if any amount which remain open then discussed with customer to resolve those amounts.
-: Prepare monthly Unapplied Barclaycard Partnership Reconciliation.
-: Daily doing force clearing of AR Fraud accounts and montly prepared their reconciliations.
-: Month end prepared GL, Branch & AR ageing file for Barclaycard partnership, SPF, Thomas Cook, Merrick GL & Branch reconciliations.
GENPACT company-:(Oct-2008 to Oct-2011)
Worked in GE-CDF(Commercial Distribution Finance)- Cash reconciliation which now called Wholesale as Process Associate.
-: Preparation of various cash reconciliations template on daily basis.
-: Handling 3 currency cash reconciliations like USD, CAD & JPY.
-: Matching system of cash reconciliation are three way i.e. bank vs genral ledger vs subsystem.
-: AIMS subsyetem used for CDF reconciliations. Collections, payments, NSF checks, Drafts are processed in this system.
-:Pull 6 reports from AIMS and Reveal report for Check outstanding on daily basis which are used for cash reconciliations in different accounts.
-: Preparations of open item tracker on weekly basis and work with customer to resolve the open items by taking weekly calls.
-: Preparation of NSF tracker(Non-sufficient fund checks) on daily basis and send to the National processing Team.
-: Preparation of Manual Journal Tracker to keep check, all the entries approved by customer and posted in GL.
-: Preparation of performance summary report which send on weekly basis to customer. which includes the bank dashboard like GL balances, Bank Balances, NSF list & closed bank account list.
-: Keep tracking upon the closing balances of each bank accounts to see if there is any overdraft or high balance above 1 million stand. Send to customer and inform them on timely basis.
-:Preparation of manual feed & trema feed tracker on daily basis to keep tracking upon the bank treasury debit & credit ZBA sweep.
-: In closing time of every month & quater closed, booked the manual Journals entries in GL where ever it is required in cash reconciliations.
In reporting part, work on the balances explanation of each treasury code account of cash reconciliation with proper explanation about that balances stand in GL of each accounts and give it to the Customer in each month & QTR closed.
ADFC private Ltd.(Dec, 2004 to Sept, 2008)
Worked in Credit Card department of HDFC
-: Experience with the bucket 1 and o
-: Handling portfolio of the bank over and above 1 lacs of outstanding.
-: Handling platinum and titanium' portfolio of the bank.
-: Handling near about 400 accounts in a particular month.
-: Settled the accounts after giving approval negotiations from 13%-20 % of
waiver depending on the history of the customer.
-: End of the day maintained HDFC credits cards books of accounts of customer.
-: Amount is collected in cash and cheques with receipts of card holder to reconcile them.
I have experience as of now is 7 years.Currently i am working in Barclays Shared services in GL, bank & AR reconciliations for Barclaycard with SAP user. Before that company,i was in Genpact who working for GE company of U.S Working on MS-Excel,SAP & Oracle User.