Himanshu Mehta

Seeking a challenging and growth-oriented career, offering good opportunities to learn and apply my

skills for the achievement of personal and team/organization goals.

13 years of experience in financial services, with focus in Reference Data Services.

Organization:             Cognizant Ltd. (Mumbai)

Designation:               Business Analyst – Testing (Wealth Management) – Contractual Role (UBS)

(November 2022 – May 2023)

Roles and Responsibility

• Going through Test cases and preparing flow charts accordingly.
• Implementation of Test cases on UAT.

Designation:               Team Leader – Tax Operations – Contractual Role (BNY Mellon)

(March 2022 – October 2022)

Roles and Responsibility

• Producing and quality assurance checking CGT reports.
• Assisting the team with large scale reconciliations projects.
• Fixing reconciliations breaks in CGIX to ensure accurate reporting.

Designation:               Team Leader – Reference Data – Contractual Role (RBC)

(July 2021 – Jan 2022)

Job profile:

Roles and Responsibility

• Monitor failure queues, mailboxes and databases to ensure all items are cleared in a timely manner (within SLA).
• Participate in UAT testing, pass/fail reporting, raising and tracking of defects and resolution.
• Maintaining master data, reference data, and data management processes to manage impact analysis and bad data resolutions for global strategic data
• Ensuring errors are resolved in the set of jobs which are responsible for processing incoming data from the accounting system FMC.
• Investigate and choose trusted sources (both internal and external) for each required reference data attribute.
• Security data feed exception review & resolution: monitoring Bloomberg, Index Provider and internal portfolio data feeds. Investigating exceptions and providing notification to relevant stakeholders.
• Daily data quality checks: resolving exceptions relating to corporate actions, duplicate securities and market identifiers.

Organization:             Mphasis Ltd

Designation:               Team Leader – Global Reference Data – CIB (Contractual Role)

(May 2020 – February 2021)

Job profile:

Roles and Responsibility

• Creation of Counterparty accounts as per client’s requirement.
• Facilitating set up of Counterparty Reference data to facilitate trade booking, confirmation, settlement for the equities, derivatives & fixed income business.
• Responsible for managing all aspects of the reference data setup, maintenance and linkage of client information as it pertains to various aspects of the trade life cycle.
• Performing quality checks to ensure control and error free processing.
• Providing timely and accurate information to middle office in relation to status of problem trades.
• Monitoring the error queues on a daily basis and follow up done to reduce the errors, which would help in STP.
• Modification of existing accounts as instructed by the clients.
• Retrieving client’s data from OMGEO Alert and making necessary amendments.
• Completing all relevant control checks.

Organization:             Nomura Services India Pvt. Ltd. (Mumbai)

Designation:               Senior Analyst (Enterprise Data Management – Product Setup)

August 2014 – June 2019

Job profile:

Roles and Responsibility

• Worked as a Senior Analyst to support, European, Asia pacific develop and emerging countries markets with the Product team who is responsible for creating and maintaining all security indicative data in the various trade processing and clearance systems to ensure accurate trade capture and settlement processes.
• Monitoring the various corporate action events by retrieving the data from Bloomberg/Reuters and reporting the same to Business trading unit for Asia pacific develop emerging countries/ European market.
• Improvising the operational reference data flow of the Products (equities, fixed income, derivatives) related details within the Nomura infrastructure from a Front/Mid/Back-office perspective. Includes self-initiated projects and internal/ external vendor follow ups, participating in change management process including user acceptance testing.
• Daily pre-market monitoring on all the all the exchange notification and accordingly informing the business unit, which includes new listing stocks/future/option/warrants, stock split, delisting, change in name, change in listing, ticker change and Round Lot change, multiplier for future and option contracts.
• Maintenance of Daily Product and Pricing data. Work with teams globally in determining ways of improving and streamlining the process. 
• Handling all kinds of queries raised by Traders, Front Office, Middle Office and Back Office department relating to product set up, maintenance of all types of financial products, Trade accruals discrepancy, Coupon calculation discrepancies and resolving all kinds of errors experienced by traders, Settlement teams while booking trade or settling a trade.
• Working with Traders and Middle office for any change in the static data in Nomura Internal trading platforms due market data change and ensuring minimal impact if the trades are rejected and ensuring that the positions are correctly transferred to the Correct Instrument
• Creating Nomura issued securities and highly critical convertible bond in all the dependent system to ensure the smooth flow of business.
• Strategy building to keep middle office and back-office systems in sync with front office trading systems and vendor.
• Conducting calls and meetings with the head of regional process owners to understand the gaps and concerns in the process which forms part of the member under the Data-Guardian and Virtual product Group.
• To update the weekly KRI (Key report indicator) report.
• System Integration and assisting Quality Assurance through timely reviews and audits
• Monitor internal Quality reports to ensure information integrity. 
• Working knowledge of Bloomberg and Thompson Reuters.

Key Projects 

• Robotic Process Automation (RPA): Analyzed the requirement and prepared Business Requirement Document (BRD) with the RPA development Team and executed the automation of creation and updates of Nomura issued securities in the internal systems associated with Front office systems through BOT.
• Migration of old Request Platform to Service Now (ABLE):  Created detailed workflow test cases for the execution of requests for automated closure to be used by IT to create the workflow and for developer to understand the processing and Published the Business Requirement Document for it, conducted walk-through sessions with all business stakeholders to get consensus on the project objective and deliverables.
• Introduction of New data source in the system: Analyzed and Sourced the structured data directly from the exchanges rather than from the vendor which saved a lot of cost from the vendors via per security functionality.

Organization:             CRISIL Ltd. (Mumbai)

Designation:               Senior Associate (Fixed Income – Securities Evaluation)

April 2009 – June 2013

Job profile:

Roles and Responsibility

• Maintaining and managing Terms and Conditions Data of US Fixed-Income Securities like Corporate Bonds, Convertible Bonds, Municipal Bonds, US Govt. agency Bonds, Treasuries.
• Setting up of Securities using prospectus and Official Statements in Internal systems of S&P which will in turn used by Bond Pricing Desk and External Clients for Trading purpose
• Updating T&C of bonds within the TAT (Timeliness) thereby enabling trades to clear on time.
• Providing real time support to S&P products like Risk to Price (R2P), Municipal Index, Ratings withdrawal, Corporate actions like call redemption, Escrow, Ratings upgrades.
• Supporting both primary and secondary market activities
• Updating of accurate information to facilitate trades for clients on timely basis & providing secondary market updates for bonds which are called before maturity or paid-off from the proceeds of newly issued bonds.
• Maintaining relationship with different underwriters, Bond counsel & financial advisor for timely requirement of information pertaining to Bonds issued by them.
• Delivering Clients with independently evaluated securities prices for global fixed income securities
• To update all the redemptions of corporate and government agency Call Bonds.
• To deal with the terms and conditions of the corporate Bond & Government Bonds issued by U S treasury and agency likes FHLB, Freddie Mac, and Fannie Mae etc.
• Prepare weekly and monthly MI regarding the team performance
• Identifying opportunities to enhance current operating procedures
• Identify areas of improvement, provide feedback and continuous coaching and training to the team members on a regular basis in order to improve performance;
• Maintain error and query log and update it on a regular basis;
• Assist Ops Manager in ad-hoc projects and performance improvement initiatives; and
• Assist and mentor colleagues by sharing experience where appropriate, in meeting SLAs.