KUMAR S
Chennai
Summary
Hard- working Reconciliation Specialist with 11.8 years of experience in reconciliation and financial management. Skilled in identifying errors, resolving disputes, and resolving financial discrepancies. Proven ability to optimize accounts and reconcile bank statements accurately. Highly organized and detail- oriented, with excellent communication and problem- solving skills.
Overview
12
12
years of professional experience
Work History
Specialist
BNY MELLON
Chennai
12.2019 - Current
- Perform daily reconciliation activities to ensure accuracy of financial data
- Analyze trends of financial discrepancies and develop solutions to minimize errors
- Generate reports for DDA Reconcilation weekly, monthly breaks
- Doing break escalation of share units and performing recon escalations of redemption account, billing account, reinvestment accounts on weekly basis
- Performing cash import, cash evaluation based on ageing breaks on daily basis
- Collaborated with cross-functional teams to find out exact breaks and get immediate resolution
- Increased customer satisfaction by addressing and resolving complaints in timely manner
- Spearheaded process improvement projects, leading to significant time savings without compromising quality or accuracy of work completed
Process Advisor
BARCLAYS
Chennai
09.2015 - 03.2019
- Handled daily breaks to clear and update .CSV file and PDF daily basis
- Handled daily, week, monthly break escalation for bank accoun
- Investigating ageing breaks and escalation for resolution to update all breaks
- Handled multiple teams work whenever high-volume period.
- Evaluated customer accounts and identified any discrepancies
- Generated monthly reports to track bank reconciliation activities
- Analyzed financial data and identified any discrepancies
- Processed customer payments in accordance with company policies accounts
- Resolved customer disputes in timely manner
Process Advisor
KELLY SERVICES DEPUTED AT BARCLAYS
Chennai
08.2013 - 09.2015
- Trade verification of redemption and sub deposit accounts
- Cauterized all settled trades and unsettled trades to update .CSV files
- Creating fails trades report into onshore team for escalation
- Escalation of trade that have matured/termination report
- Create wire for terminated trades for settlement
- Set up security record for new trades
- Generate complete summary report of daily trade report based on settled date.
Education
Master of Science - Computer Applications
Mahendra Engineering College
Tamil NaduBachelor of Arts - Physics
Islamiah College
Tamil Nadu, IndiaSkills
- Bank Reconciliation & Cash Reconciliation
- Dispute Resolution
- Financial Analysis
- Problem Solving
- Communication
- Team Collaboration
- Power BI
- MS Excel
- Data Analytics
Project - Hedge Fund Reconcilation
- Process Flow
- NAV strike will be received via Email
- The NAV has to make with FSR next day and must be be compared with FDBI screen
- Once NAV strikes on FSR. all trades entered on FSR will get settled in the nightly and the same will reflect on drass reports
- Trades settled in FSR will reflect inthe transaction tracking report and will be matched and verified with OPS log
- Share register excel os prepared using the shareholder register report to verify share balance aginst FSR
- Reporting must be sent to client as per dealer codes
- Project Flow
- Important input file and dress report file into alteryx
- ETL process and get the required data
- Get the output of recon date, units, amount and update in share register file with client
Project -Cash reconciliation break identification
Cash Reconciliation Macro:
- Process Flow
- For cash reconciliation each day receiving more than 10 accounts for redemption, reinvestment and billing.
- Each account having more than 500 to 1000 transactions. so take more time to identify the breaks.
- The transactions would be
- Purchase and sweeps matching
- Cash deposit and cash withdraw matching
- Account swing and account swing reversal
- If all matches then has to be zero
- If any break identified then break can be escalated to relevant team to clear the breaks
- Project Flow
- Import settle cash statement sheet into alteryx
- I created the macro to find out each break based on transaction type.
- Buy vs Capital stock
- Cash deposit vs Cash withdraw
- Account swing vs Account reversal
- Based on above type macro will pull the value according to purchase and sweeps to match the break easily
- So it can reduce the time 3 hours
- Easy to finish BAU without any struggle
Project - Fee Reporting
- Process Flow
- Every fund having fees like federal fee, wire, new account, admin fee, sponsor fee etc
- Drass is application to use to pull the reports based trade date to find the fee value
- Manually create excel sheet to update the fee value based on excel on daily basis and maintain consolidated monthly report of all funds
- Project Flow
- Import the input excel file to alteryx
- ETL process for data cleaning
- Summarized the fee value, fee description ans trade date
- Update in existing file maintain by the team based on fund name
- Also write in monthly maintain excel sheet too
Activities
Got the star awards three times in Bny Mellon
previous company also got the advocacy batch for productivity, quality, flexibility of work.
given training and teaching BAU to more than 15 employees in my career
Personal Information
Disclaimer
I do hereby declare that the above said information's are true to the best of my knowledge and belief.
Languages
English
Upper Intermediate
B2
Tamil
Advanced
C1
Timeline
Specialist
BNY MELLON
12.2019 - Current
Process Advisor
BARCLAYS
09.2015 - 03.2019
Process Advisor
KELLY SERVICES DEPUTED AT BARCLAYS
08.2013 - 09.2015
Master of Science - Computer Applications
Mahendra Engineering College
Bachelor of Arts - Physics
Islamiah College