Business Analyst - Manager
Scottish Widows
Total years of experience :11 years, 4 Months
• Provide fund reporting into investment committees in line with the requirements of each committee
• Establish and maintain relationships with Aberdeen and other fund managers to ensure delivery of analysis and supporting commentary.
• Resolve fund issues raised by fund managers and other stakeholders.
• Proactively identify key market messages and areas of potential strength/weakness, with a view to onward communication to sales channels and other stakeholders through the Marketing team.
• Provide timely and professional reactive service for fund performance and ad-hoc fund analysis for internal and external customers.
• Liaise with third party suppliers and data providers (including Financial Express) as required
• Participate in the broader activities of the IS&E team, sharing insight and plans to ensure consistent view and strong communication. Support the broader portfolio of investment projects as required.
Analyze Accounting data that feeds through accounting system (PAM) to Alladin (data warehouse)
Identify huge cash flows, securities transfers and accounting adjustments.
Resolve any data issues to enable performance calculation accuracy.
Calculate Dietz returns bases on the above data on an excel sheet. Chain link longer term returns and perform reasonability checks on returns.
Check reasonability of Standard Deviation, Tracking error, VaR and other risk numbers generated by the risk system (PRADA)
Liaise with clients to ascertain changes in fund structure and benchmark requirements.
Resolve any client queries via email, phone and face to face meetings
Participate in quarterly and annual client service reviews and presentations.
Regular allocation of work to team members, mentoring team members as required.
Assessing training requirements and training team accordingly.
Conducting regular one to ones and performance appraisal for team members.
Running controls on stat-Pro to check holdings, transactions and cash flows for computation of performance and attribution reports.
Liaising with NAV team and Fund Managers in case of queries on data.
Production of monthly and quarterly performance and attribution reports.
Checking time weighted returns and benchmark returns, chain linking long term returns manually to ensure accuracy in the reports.
Implementation of change of manager and other static fund changes on Stat-Pro
Setting up customized performance and attribution reports on Stat-Pro Interactive.
Improve client and consultant relationship by responding to queries on a timely basis and being able to explain in detail issues they might have with the performance and attribution data
Thorough reconciliation of holdings and transactions data including cash analysis for the computation of performance and attribution report.
Calculation of returns using modified dietz and time weighted return methodology for multi asset portfolios and being able to explain the differences to clients, consultants and relationship managers.
Production and explanation of detailed client specific performance and attribution report including benchmarks on a monthly and quarterly basis
Improve client and consultant relationship by responding to queries on a timely basis and being able to explain in detail issues they might have with the performance and attribution data
Identify discrepancies in accounting data i.e. pricing, corporate actions, back dated trades, investigate and liaise with accounting team to make sure these issues do not arise again.
Interpret and highlight discrepancies between fund managers returns and that of Bank of New York Mellon and provide detailed explanation and justification for such differences.
Developed strong relationships at senior level and the confidence of clients, consultants and relationship managers by providing accurate and timely performance and attribution numbers
Strong statistical acumen. Used to translating complex information and data into usable format. Able to use V-lookups, Pivot tables etc
Conducting Pre NAV checks
Generating the income report and validating dividend accruals
Validating and backing up prices for new trades via FTS or Bloomberg
Backing up corporate actions via FTS or Bloomberg
Checking Exception through the exception management system in Invest one
Manually posting Appropriation and Expropriations in case of system failure
Checking and fixing the out of balance figures in trial balance
Validating transactions like ROCA, bond interest, bank interest and AMC rebates posted
Validating and verifying the units in issue for each share class
Validating forward transactions and currency deals
Preparation of MIS reports
Investment Banking Operations
Working as a part of team handling custodian reconciliation for Morgan Stanley Investment Management
Daily reconciliation between the AMC and the custodians which includes investigation of discrepancies, escalation to fund managers, follow ups with custodian banks, corporate action team and posting of Fx for income repatriation, expenses and income
Monitoring daily trades for global trade transfer accounts and liaising with the fund managers for daily allocation of expenses in sub accounts
Fortnightly reconciliation of stocks which include reconciliation of holdings with the custodians, brokers, trust bank (in case if Japanese markets) and fund accountants
Market value due diligence - Reconciliation of Net Asset Values and escalation of discrepancies to the fund accountants and the client service associates
Preparation of various client reports on basis of parameters defined by the clients
Escalation of ageing and high risk breaks in cash and securities position
Investigation and review of breaks related to accruals, market values, pricing, tax reclaims and expenses in the market value due diligence
Assist senior managers in implementation of projects for continuous improvements
Preparation and upgradation of standard operating procedure (SOP)
Ensure adherence to various timelines for reconciliation
Investment Banking Operations
Handling the asset reconciliation EMEA and the Asia pacific zone
Training and assisting the team to perform the daily activities
Preparation of MIS reports for top management
Setting objectives and time bound task for the team to maintain productivity levels
Assisting team in reconciliation of asset holdings on basis of MT 535 and MT536 SWIFT messages received from the agent banks across the world
Supervising investigation of discrepancies done by the team using the mainframe system and tools like Reuters, Bloomberg and FTS and referring out the discrepancies to the concerned departments.
Liaising with the concerned departments like corporate actions, settlements, securities lending etc to get the discrepancy resolved
Analyzing the root cause of the asset discrepancies to avoid reoccurrence of the same and mitigate risk
Liaising with the agent banks for non-receipt of the MT535 and MT536 SWIFT messages
Investigation of swift messages in case the same fails to step onto the mainframe system
Documentation of Standard Operating Procedure (SOP)
Analysis of the system on a continuous basis to improve the step rates of SWIFT messages into the system
Work on various process improvement projects and implementation of automated solution to enhance efficiency
Two years full time MBA from Mumbai University
B.COM from Mumbai University.