DEBAYAN DAS

Project 1:

• Working as Progress developer role on a Mortgage banking CUI based Progress Open Edge Application running on UNIX server. This system allow Bankers or Loan Providers to process loan applications of customers which undergo through various stages of Mortgage lifecycle. This application feeds XML data from an another Loan Origination Application for initial creation of loan application. Our application sends and receives loan level data to other downstream applications or Agencies.
• Roles and Responsibilities:
• Updating daily/weekly status to our offshore lead and Onshore without any fail.
• Participating and discussing our Release changes with L2 in Implementation call.
• Tracking and updating user story (JIRA) with our findings on every sprints and releases.
• Ensure UAT sign off received from QA on every stories before production deployment.
• Perform Code development and Unit testing with sample document attached along with the Spike/User story.
• End to end discussion with Clients for business for research and development.

Project 2:

• Working as a Senior Data Analytics Engineer (Backend) on an Insurance-Based Web Application owned by Tata Consultancy Services itself. This system supports general insurance (life, motor, health) product development based on clients across various geographic regions. This system supports underwriting (new business), billing, and accounting for all types of insurance products.
• Roles and Responsibilities:
• Worked on various Indian based Insurance products simultaneously based on requirements as shared resource for Backend Validations.
• Coordinate with QA team during the testing phase.
• Address queries raised by QA within defined timelines.
• Data analysis and validations between the Front End and Back End, along with temporary and permanent fixes. Table validation through SQL and PL/SQL for a permanent or temporary fix..
• Participated in support during month end to clear mismatches with scripting modules or manual corrections.
• Reporting the issue and proposing the model to fix the defects to the team.
• Developed patches (stored procedure) and base module changes build in in PL/SQL for new CR.
• Data visualization and transform thru EXCEL and tracked documents for future and client needs.

• Worked as a Application Developer on the Variable Product Administration System GUI owned by a North American insurance company. This system allows customer to issue policy of variable/indexed/ universal life products. This project uses Progress 4GL version 11.0 as a major programming language to develop, UNIX to handle the Progress database and Mainframe for processing feed files for downstream.
• Roles and Responsibilities:
• Incorporated various US based life insurance products in the system along with both Frontend and Backend development.
• Developed Products, base module changes and UI design.
• Worked on XML READ and WRITE thru Progress 4GL for Data in/out to and fro system for Downstream like reports, interface and Client Correspondence.
• Providing business analyst with documentation of current functionality during initial phase of each release.
• Creation of High level Design document (KDD) for the new requirements during each release and coordinate with the team to implement approved design.
• Responsible for promoting the final changes after proper validation and testing before code freeze date.
• Preparing Unit Testing logs and all possible scenarios during each release.
• Providing proper root cause analysis of reported issue and proposing remedies for the same during Pre QA/Model office and production support.
• Perform product development for the insurance product, which consists of base functionalities implementation and downstream changes.
• Spreadsheet validation of new products and providing the breakdown if found any mismatch during construction phase.
• Logging and Tracking defects using Defect Reporting Tool i.e., HP ALM.
• Participating daily stand up calls with our onshore counterparts and Clients.
• Delivering the items to Onshore and undergo with Code/Product Setup/TS/II doc walkthrough with Client, Peers and Onshore Tech-lead.
• Updating daily/weekly status to our offshore lead and Onshore without any fail.
• Listing down the problem faced during each release and maintain lesson learnt document.