Anindya Nandy

MIG21-CRIMS Migration(3 year 2 Months ongoing)

• Gather & Analyze requirements from Business Users/Stakeholders and communicate/Co-ordinate with multiple DEV & QA Teams
• Work On Analyzing Current MIG21 Regulatory & Prospectus Compliance Rules and plan on required Data related to Security,Fund,Issuer, and other Reference data for Compliance Tests
• Create Design for data load between different source system and transform data into a structural form to be loaded in Upstream
• Analyze CRD Business data requirements in relevance to Client Investment Compliance requirements
• Set up structure for Different Asset classes in CRIMS to ensure data completeness from Accounting, Reference Data
• Manage and contribute individually for Data Development,Compliance tests Development in CRD & QA, Deployment schedules,planning
• Work on Data Analysis using SQL/PL-SQL for Reporting Purposes

Charles River SaaS (1 year 1 Month)

• Perform and Monitor daily BOD, EOD, Intraday process in Tidal for all Charles River SaaS Clients
• Set up and run AD-HOC feed process to load data into CRD
• Manage CRIMS(Charles River IMS) SaaS Environments for all clients
• Resolve all daily Issues with CRD System and Load issues
• Resolve and Check Any compliance Rules/ Test exception
• Perform user management in Windows AD and Azure AD

GX Compliance(9 Months)

• Work on Implementing MIG21 Investment Compliance for SaaS Clients
• Upgrade/Enhance MIG21 Systems to Higher Versions
• Implement System Design Changes On Data Load using PL/SQL to resolve and Improve Performance Issues
• Develop backend Functionalities and Additional Client Requested Functionalities using PL/SQL
• Analysis Data Model and Rules/Rule Code and assist in translation to Charles river
• Work on Data Sourcing of Existing MIG21 Clients to Charles River for MIG21-CRD Migration

MIG21 Client Services (6 years)

• Handle and Resolve Client Reported MIG21 SaaS and Product Issues
• Oversee,manage and maintain all MIG21 SaaS Citrix Environments
• Manage MIG21 Client Services Team, Clients and Team Members
• Implementation Project Responsibilities
• Set up DEV,UAT Environment For New MIG21 SaaS Clients and Go Live in Prod
• Set up ETL sources, Mappings based on Investment Compliance System Requirements
• Design and Create End to End Data flow for loading data into MIG21 from Multiple Systems using Technologies like PL/SQL,Oracle Loader, DOS,VB etc
• Develop backend Functionalities and Additional Client Requested Functionalities using PL/SQL
• Create/Modify Investment Compliance Rules based on Regulatory or Contractual Requirements

MIG21 Testing (2 Years 1 Month)

• Design And Execute test cases for Smoke Testing, functional testing, Regression testing, Performance testing, ETL Testing, Database Testing etc as per CR
• Installation and configuration of product in testing environments for all Levels of Testing along with set up of test data for execution
• Logging and tracking defects in scrum portal and create Final Test execution report
• Develop PL\SQL scripts, stored procedures,Functions,Packages etc to Automate ETL testing effort and Contribute to developing Client Requested Additional System Functionalities
• Testing of Post Trade Investment Compliance Data and Investment Compliance Rules
• Execute Tests for OS compatibility as well as Database load Compatibility between systems such as SQL Server, File based,Teradata ->Oracle and vice versa