SUBHASMITA MISHRA

Project: Emerald (HSBC to CIBC Migration)

Account: Banking Domain - Core Credit System (Load and Mortgage)

Client: Royal Bank of Canada

Website: https://www.tcs.com

Roles & Responsibilities:

• Handing team and individual work
• Royal Bank of Canada acquired HSBC Canada retail Business in 2022
• I worked on a project involving a merger and acquisition. The TCS Emerald project is enabling the movement of the book of business for value streams (Retail Banking, Private Banking, Wealth Management, Asset Management)
• Working with Banking Clients and Handling Team and Individual work
• Working on Mainframe API Conversation modules.
• My project's aim was to load the data from HSBC and provide reports to different business units for retail and commercial loans and mortgages, so that the business unit and operations team can take proper action manually before accounts are loaded into the RBC system.
• As a lead developer, I owned the solutioning and development of about 25 reports, which helped the business fix errors and issues in loan and mortgage accounts for commercial and retail customers.
• Our report provided an end-to-end picture of the migration activity for loans and mortgages.
• The reconciliation report between the source HSBC data and the RBC migrated system helped the business unit validate the data received and loaded.
• I resolved rejected account issues due to data errors for manual processing.
• Setup version control and deployment process within team and planned for smooth execution of all reports during migration window
• Designed and deployed software solutions to satisfy customer needs
• Mentored and guided the team's junior developers in terms of technology
• Developed and designed intricate algorithms to address difficult issues
• Specialized in creating and managing mainframe solutions using COBOL and JCL.
• Tools/Technologies: Mainframe, Cobol, JCL, DB2, FOCUS, JIRA, IMSDB, Confluence, ServiceNow

Project: COST BASIS REPORTING AND WMAP MODERNIZATION

Account: Wealth management

Client: UBS

Roles & Responsibilities:

• Handled team and individual work
• The project tracks security from investment to closure, assessing unrealized gains/losses over time
• Got involved in business
• Facilitated the debate
• Communicated with my team
• Assigned responsibilities
• Supervised and supported the team during problem solving, design, development, review, and delivery
• Dividend Reinvestment: A mini batch of eight jobs for mutual fund dividend reinvestment that operates five days a week was successfully constructed
• Reconciliation between Cost Basis, Gainskeeper, and Bookkeeping has successfully setup
• Tools/Technologies: Cobol, JCL, VSAM, IMSDB, DB2, stored proc, SQL

Project 1: ACES Claims and Cash disbursement (AUG 2017 - OCT 2018)

Project 2: Modernized Migration (Nov 2018 - Jan 2020), Account: Healthcare.

Client: Anthem Consolidated East Systems

Roles & Responsibilities:

• Track Lead and Developer
• This project involved a claims system that complies with AGILE methodology and supports regional products in addition to state-specific laws and standards in a real-time setting
• As implied by the name, this was a migration project in which we combined two big healthcare systems into one
• Since PEGA was our upstream, it was essential to our project that we worked with them to undertake DIT testing and help them understand the logic and usage of fields
• Made ensuring that all papers were version managed and kept up to date in accordance with the Project Life Cycle
• Tools/Technologies: Cobol, JCL, IMSDB, IMSDC, DB2, CTL

Project 1: Policy package Conversion (Dec 2016 - June 2017) Project 2: ELECTRONIC DOCUMENT PROCESSING PRE-ISSUANCE (June 2015 - Nov 2016)

Project 3: CUSTOMER COMMUNICATION (AUG 2013 - May 2015)

Account: Insurance

Client: Allstate

Roles & Responsibilities:

• COBOL programmer, Report Development, Enhancement plus Maintenance, Cheques Processing using cobol-cics
• Utilizing the existing framework and Make Tibco and HPX treame aware of the requirements by mapping the analysis sheet to the requirement package
• Recognizing the need for code development, requirement analysis, unit and system integrated testing, and business requirements
• Examining the test cases, test results, and test plan
• Guaranteed prompt and error-free delivery within designated timeframes
• Tools/Technologies: Cobol, JCL, EDL, Documerge, Xenon, XCOM, VSAM