Senior Business Analyst
BNY Mellon Technology, Managed Investments
Onboarding new Clients Conversion to the platform & de - converting existing clients, if required. Meet with the clients; gat
Perform gap analysis to identify the different systems and discuss options with the clients.
Client discussions to fix the constraints in the data mapping process and ensuring the integrity of the data.
Present the conversion plan, detailed conversion calendar activities & run book with activities to the clients.
Document the code changes that are required to accommodate the conversion, review with the management, and pass it on
Receive client files, build test cases for various business scenarios and test the code changes.
Build complex queries to manipulate the client data and convert them in the required format to be used in the standard ETL t
Complex query validations, fine-tuning the query to improve the performance.
Address the data issues/bugs and present the conversion metrics to the clients.
Provide post-conversion support.
Enhanced the ETL tool to automate the REPORT generation and Data wrangling process