Rohan Bais
Data Analyst
Pune
Summary
Experienced professional with 6 years of demonstrated history in the investment banking industry. Skilled in trade affirmation, cash reporting, FX processing, and cash reconciliation. Recently completed a business analyst certification.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Sr. Analyst (Data Management and Reporting)
Bny Mellon India Pvt Ltd
Pune
11.2019 - Current
- Develop deal-specific models, reports, and user tools in accordance with legal documents and client specifications, utilizing in-house systems and supported applications.
- Create margin reports using Microsoft Access and distribute them to clients.
- Utilize UDT and DART reporting services.
- Generate various reports, including client and internal reports, from an Access database.
- Ensure timely payments by accurately sending Letters of Credit, SOFR rate sheets, and invoices to clients and their respective banks, facilitating prompt payments to bondholders through DTC.
- Verify client statements to identify TLM cash breaks and set up GIC posting entries in the bank account to resolve exceptions.
- Reconcile client accounts and provide quarterly reports of uninvested cash to management for the further benefit of clients and the bank.
Associate Analyst ( Cash Reconciliation )
State Street Syntel
Pune
07.2018 - 11.2019
- Managed the post-cash settlement process, conducting research on payments related to Investment Management (IM) and Custody, and validating fees, dividends, trades, interest, coupons, positions, and FX transactions. Posted this information accordingly in RKS & Portia. Addressed exceptional cases by coordinating with custody to clarify transaction details.
- Utilized SWIFT instructions to validate payments, including trade date, settlement date, units, rates, and broker instructions provided by Custody.
- Conducted reconciliations of payments and positions between investors, managers, and custodians.
- Engaged in Transaction Lifecycle Management (TLM) and Post-Settlement Lifecycle Management (PLM) processes.
- Managed weekly client calls regarding outstanding cash exceptions.
- Interacted with both US and Canadian clients.
- Identified and raised Client Service Requests (CSRs) for high Basis Points (BPS) and high-value flows.
- Handled client emails on a daily basis.
- Conducted research using Bloomberg.
Account Executive - Account Payable
Infosys BPM Ltd
Pune
06.2017 - 07.2018
- Reviewed and processed invoices and check requests using the IA Connect system.
- Entered and uploaded invoices into the system, managing accounts payable vouchers using the Cost-Point system. Researched and resolved invoice discrepancies and issues.
- Set up invoices for payment and prepared payment files for weekly check runs.
- Prepared and processed electronic fund transfers, wires, ACH requests, and check payments.
- Reconciled accounts payable transactions and conducted audits for check payments, providing supporting documents for external audits.
- Processed manual check payments for vendors.
- Conducted P-card reconciliation for expenses.
- Maintained exception queues and PO vouchers.
- Produced weekly reports, monthly reports, and team performance data, providing them to clients.
Education
MBA - Finance
University of Pune
BBA - Finance
University of Nagpur
H.S.C. -
MSB, Pune
S.S.C. -
MSB, Pune
Skills
- TLM & PLM
- Bloomberg
- Mainframe & Nexen
- Deltek Cost Point
- MS- Word
- MS -Power Point
- MS -Excel
- Tally 09
- MS - Access
Certification
- Business Analyst Program by Simplilearn
- Business Analysis Professional (CBAP)
- Power BI
- SQL
- Business Analytics with Excel
- Agile Scrum Master (ASM)
- Lucid chart
Accomplishments
- Spot recognition for best quality work
- A team player, continuous learner and proactive.
- I Received 4 WOW award in BNY Mellon.
Personal Information
- Date of Birth: 02/15/1995
- Marital Status: Single
- Permanent Address : Small Ayachit Mandir Badkash chowk, Mahal Nagpur.
Languages
Hindi, English, Marathi
Timeline
Sr. Analyst (Data Management and Reporting)
Bny Mellon India Pvt Ltd
11.2019 - Current
Associate Analyst ( Cash Reconciliation )
State Street Syntel
07.2018 - 11.2019
Account Executive - Account Payable
Infosys BPM Ltd
06.2017 - 07.2018
MBA - Finance
University of Pune
BBA - Finance
University of Nagpur
H.S.C. -
MSB, Pune
S.S.C. -
MSB, Pune
- Business Analyst Program by Simplilearn
- Business Analysis Professional (CBAP)
- Power BI
- SQL
- Business Analytics with Excel
- Agile Scrum Master (ASM)
- Lucid chart
Similar Profiles
Jainesh PatelJainesh Patel
Senior Manager - Marketing Automation at BNY Mellon India Pvt. Ltd.Senior Manager - Marketing Automation at BNY Mellon India Pvt. Ltd.
YASIR ATTARYASIR ATTAR
Senior Associate, Financial Reporting at BNY Mellon India Pvt. LtdSenior Associate, Financial Reporting at BNY Mellon India Pvt. Ltd
Harshad SahaneHarshad Sahane
Global Support Manager at Helpshift technologies pvt ltd.Global Support Manager at Helpshift technologies pvt ltd.