Varshini Sankar

Experienced Software Engineer with over 12 years in IT, specializing in product development and support for the insurance industry. Proficient in Mainframe technologies including COBOL, PL/I, DB2, and JCL, with significant achievements in legacy system migration. Led teams in the successful development of life insurance products and data conversion initiatives, enhancing operational efficiency. Strong project management skills demonstrated through timely delivery and adherence to quality benchmarks.

Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Engaged in certification course at LearnBay focused on cloud computing and DevOps.

• Client Appreciation for resolving a production issue related to Accounting out of balance.
• Have been applauded by peers for analysis and resolving several production abends and issues within the SLA defined.
• Client Appreciation for providing suggestions and solutions to handle Data Conversion from legacy billing system to new.
• Customer Satisfaction index was above 97% during my tenure as project leader. Customer has mentioned about my leadership and subject matter expertise.
• Was awarded Star of the month for the performance in handling project deadlines and deliveries with no error.

Risk Servicing – Product Migration, Infosys Limited, Northwestern Mutual, 10/01/17, current, Technology Lead, 10, The Northwestern Mutual is a U.S. financial services mutual organization based in Milwaukee, Wisconsin. Its products include life insurance, long-term care insurance, disability insurance, annuities, mutual funds, stocks, bonds and employee benefit services. Project involves development of new Ulife product in Mainframe similar to the existing product in Legacy system developed in PL SQL., Reverse Engineering, Gathering Requirement, Resource Management, Detailed Project planning, Analysis and design document, Coding and Testing, Functional testing, Customer Demo, Generating feeds in MQ., Tracking Team progress in TFS for agile., PL1, DB2, JCL, Excel, Changeman, IDZ, Jmeter, APA, MQ Data Conversion, TATA Consultancy Services, Selective Insurance, 02/01/14, 03/31/16, SME and Project Leader, 12, Selective Insurance Group, Inc. is primarily a holding company for ten customer-focused property and casualty (P&C) insurance companies rated “A” (Excellent) and ranked as the 44th largest P&C insurance group in the United States by A.M. Best Co. These companies offer a broad range of insurance and alternative risk management services. Selective provides value-added products and services to businesses, public entities and individuals through independent agents in 22 primary eastern and Midwestern states. The company uses a product TARABS for Billing related processing (Policy maintenance, Billing, Cash Application, Disbursement, Write offs and Cancellation). Selective has been using the product for close to 20 yrs. TARABS front end is CICS screen and Backend in DB2. Customer wanted to upgrade to a new billing system that has a better UI. The project was formed to carry out the migration of 20 yrs of Policy Data from the Legacy system (TARABS) to a new billing system. The migration was to be carried out as a hybrid approach with older than 3 yrs data to be converted at a summarized level and the recent ones to be converted at a detailed level. The challenge was to map the policy data according to the conversion layout of the new system wherein the functionality of the legacy and new system are completely different., Legacy system Data Quality & Integrity review, Gathering Requirement of Customer and Vendor of new billing system, Mapping of Policy data between Legacy system and conversion layout of New system., Documentation of the requirement and sign offs, Resource Management, Detailed Project planning, Analysis and design document, Coding and Testing, Creating Extraction process to extract data from legacy system as per the conversion layouts, Code Review and signoffs, Prevalidation process and support to Vendor, QA and UAT support to Vendor and Customer, Go live planning and preparation, Reconciliation processing and Accounting, Project Management Activities, Defect Prevention and Causal Analysis, COBOL, DB2, JCL, VBA for Excel, Excel Macros Copy Utility Development, TATA Consultancy Services, Selective Insurance, 11/01/15, 01/31/16, Project Leader, Selective Insurance Group, Inc. is primarily a holding company for ten customer-focused property and casualty (P&C) insurance companies rated “A” (Excellent) and ranked as the 44th largest P&C insurance group in the United States by A.M. Best Co. These companies offer a broad range of insurance and alternative risk management services. Selective provides value-added products and services to businesses, public entities and individuals through independent agents in 22 primary eastern and Midwestern states. The company consists of two Policy Admin system 1. Commercial Line of Business and 2. Personal Line of Business (Home and Auto). To handle Personal lines of business, they use the application PLUS( Personal Lines Underwriting System). The front end is designed with .Net framework and the Backend is Mainframe. There are several utilities that aid the development and testing team in case of production support activities. The project was to revamp the utility to copy policy data from one environment to another to recreate scenarios and provide fixes. The new copy utility was designed to handle multiple environment using a single program and also provide additional features like copy ‘n’ policy, copy ‘n’ policy terms or copy all terms of a policy. The copy utility was developed using DB2 Stored procedure as it allows dynamic calls and also it is faster. On comparing the performance of the new copy utility with the old, the new copy utility was 75% faster than the old utility., Requirement Gathering, Analysis and Design, Development and Testing, Promoting the code, UAT support, Documentation of the process for maintenance and support., DB2 stored procedure PLUS Backend Production support, TATA Consultancy Services, Selective Insurance, 11/01/15, 02/29/16, Project Leader, 2, Selective Insurance Group, Inc. is primarily a holding company for ten customer-focused property and casualty (P&C) insurance companies rated “A” (Excellent) and ranked as the 44th largest P&C insurance group in the United States by A.M. Best Co. These companies offer a broad range of insurance and alternative risk management services. Selective provides value-added products and services to businesses, public entities and individuals through independent agents in 22 primary eastern and Midwestern states. The company consists of two Policy Admin system 1. Commercial Line of Business and 2. Personal Line of Business (Home and Auto). To handle Personal lines of business, they use the application PLUS( Personal Lines Underwriting System). The front end is designed with .Net framework and the Backend is Mainframe. The Backend system interacts with the other applications in the company like Billing, Accounting, Knowledge Management and Collection. The project was to carry out production support activities for PLUS backend batch process., Knowledge Transfer to offshore resource, Documentation of the Backend process in PLUS system, Documentation on handling production support for the Backend Batch jobs, Production support, Incident Reporting and temporary fixes., COBOL, DB2, JCL CLAS Backend Development and Production Support, TATA Consultancy Services, Selective Insurance, 10/01/13, 02/28/14, Project Leader, 5, Selective Insurance Group, Inc. is primarily a holding company for ten customer-focused property and casualty (P&C) insurance companies rated “A” (Excellent) and ranked as the 44th largest P&C insurance group in the United States by A.M. Best Co. These companies offer a broad range of insurance and alternative risk management services. Selective provides value-added products and services to businesses, public entities and individuals through independent agents in 22 primary eastern and Midwestern states. The company consists of two Policy Admin system 1. Commercial Line of Business and 2. Personal Line of Business (Home and Auto). To handle Commercial lines of business, they use the application CLAS (Commercial lines automation system). The front end is designed with .Net framework and the Backend is Mainframe. The Backend system interacts with the other applications in the company like Billing, Accounting, Knowledge Management and Collection., Requirement Gathering, Creating the Design Document, Code Review, Coding and Implementations, Testing, Code Promotion and signoffs, Project Management Activities, Defect Prevention and Causal Analysis, Client interaction on various enhancements and queries, COBOL, DB2, CICS, JCL, ChangeMan TARABS (TATA Accounts Receivable and Billing System) - Maintenance & Enhancement, TATA Consultancy Services, Selective Insurance, Amerisure, ACE, Society Insurance, 02/01/09, 09/30/13, System Engineer, TARABS (TATA Accounts Receivable and Billing System) is a TCS product for Insurance Billing and Receivables. It is designed to fit into the existing system architecture of Insurance companies who typically have different systems for different functions. It is designed to help insurance companies focus directly on one of the most controllable components of the expense ratio — premium accounting and collection — while simultaneously improving customer service and increasing cash flows. The system is available as a stand-alone module, which can be interfaced with an existing insurance administration system. The system processes both Direct bill (The insurance company bills the insured directly) and Agency bill (the agent bills the insured and remits to the insurance company). It is a DB2 based system and is capable of running under IMS/DC, CICS or TSO transaction processing environments on the IBM ES 9000. A personal computer version is available which runs using DB2 and Micro Focus Cobol., Impact Analysis for client requirements, Creating the Design Document, Coding and Implementations, Testing, Product Maintenance and support, Project Management Activities, Defect Prevention and Causal Analysis, Shipment and Version management, Client interaction on various enhancements and queries, Knowledge transfer sessions for trainees and team members, COBOL, DB2, CICS, JCL, MQ Series

Bachelor of Engineering, B.E, Computer Science Engineering, Anna University, RMK Engineering College, 84%

• Ongoing Cloud computing and Devops course(LearnBay)
• Python and Linux certifications received as part of the course