Support Analyst Life Insurance

SENTHILNATHAN SUBRAMANIAN

(Auto, Banking, Financial, Insurance, Healthcare and Auto)

********@*****.*** 13640 Bellerose Dr,

Contact: 470-***-**** Chantilly, VA 20151

Profile

Senthilnathan has 15+ years of strong experience in analysis, design, application development, Maintenance and support using Mainframe Technologies. He has expertise working experience in Retail banking, Health Insurance, Life insurance and financial projects. He has sound working knowledge in all phases of SDLC starting from Requirements to Warranty support and maintenance. Performed roles as Mainframe Project lead, Onsite co-coordinator, Mainframe Technology lead, Senior Application mainframe developer, Mainframe Production Support Analyst and Senior System Analyst and team member. He was responsible for analysis, design, coding, testing, implementation and documentation of the change requests and enhancements.

Key Responsibilities

•Hands-on experience in translating business requirements into detailed design, program specs, code, test, debug and support business applications in mainframe environment.

•Identifying business or technical requirements applied to the design, development, implementation, management, and support of software systems.

•Translating and interpreting IT policies, standards and guidelines for software design

•Developing metrics and benchmarks for use by systems analysts and applications developers

•Providing technical guidance in designing, coding, testing, debugging, and maintaining programs.

•Evaluate existing systems and procedures to identify deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage.

•Assists with analyzing, developing and revising existing system logic difficulties and documentation as necessary and works on all phases of applications systems analysis activities.

•Coordinate the resolution of Client data risk and control issues, audits, corrective actions globally.

•Expert knowledge of SDLC, and development methodologies (Agile, Scrum and waterfall).

•Extensive hands-on experience in mainframe technologiesand distributed environments (TSO/ISPF, z/OS, MVS/VM, COBOL, JCL, VSAM, CICS, SQL, DB2 for z/OS, IMS, ANSI C, and open systems.

•Experience in DB2 Database administration and performance tuning.

•Experience with DB2 database operation support in 24x7 environment performing DBA functions to include maintenance, backup, recovery, monitoring and performance tuning on a mainframe environment.

•Analyze and research data into meaningful facts for businesses to help them make better business decisions.

•Coordinate with Project Managers, Vendors, Architects, Business Analysts and Quality Analysts in an agile environment.

•Act as liaison between management and Business team for Requirements.

•Experience with leading projects in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment.

•Well versed in MS-Visio, MS-Project, MS-PowerPoint, MS-Excel, MS-Word and other office Suites for Project Management and Business Analysis.

•Adaptable to new systems and environments quickly, takes ownership of all duties, excellent.

•Project Tracking, Team Management, Issues Tracking and Reporting.

•Good understanding in installing, configuring and using Hadoop ecosystem components like Hadoop Map Reduce, HDFS and Hive.

•Deep knowledge of emerging software application trends.

Education

•Master in Computer Science.

Employment

• IT Specialist (Mainframe Developer) – Social Security Administration

Technical Skills

MVS (COBOL, JCL, VSAM, CICS, SQL, DB2 and IMS DB/DC), PL/1, SQL, Easytrieve, ANSI C

Additonal: RDz, Microsoft VBA, Power BI, Hadoop, Agile, JIRA, Kanban

PROFESSIONAL EXPERIENCE

Project Experience Highlights

Project Name : Informational Certified Earnings Record (ICERS) System

Duration : August 2021 to till date.

Technology : z/OS, COBOL, VSAM, SQL, DB2, Terra Data, TSO, CICS, ESP, Visual C++, MS Access, Changeman

Company : Social Security Administration, Woodlawn MD.

Description :

Certified earning records refer to the available SSA records containing earnings from the Internal Revenue Service (IRS) that we can utilize to make a “formal” determination for benefits.

Responsibilities:

•Analyzing mainframe codes COBOL-CICS, JCL, SQL, DB2, VSAM programs in the ICERS systems to perform impact analysis and prepare technical design document for enhancements.

•Write, design, code, test, implement, and debug programs (COBOL-CICS programs, COBOL Batch, JCLs) adhering to agency requirements and standards.

•Research and Analyze the MEF (Master Earning File) records those from various sources such as IRS, RRB.

•Analysis, Estimate, Design, Coding, unit testing and regression testing in ICERS system(mainframe)

•Co-ordinate with Business users, System analysts and extract data and support adhoc activities.

•Adhere 100% security policies when handle the data.

•Perform routine monthly/quarterly/annual tasks HIMEX processing, QCI (Quarterly Index set), creating and executing Electronic Wage Reporting stored procedures.

•Provide necessary presentations for each major release of projects to other teams as requested, including IT and business groups.

•24/7 on call production support for ICERS (Informational Certified Erning Systems) and ICOR (Item Corrections) applications.

Project Name : Internal Risk & Controls

Duration : November 2018 to till date.

Technology : z/OS, COBOL, VSAM, SQL, DB2, Terra Data, TSO, CICS, ESP, Visual C++, MS Access, Changeman

Company : Navy Federal Credit Union, Vienna, VA USA.

Description :

Internal Risk& Controls (IRC) handles monetary processing. Types of monetary transactions include

Deposits, Withdrawals, Transfers, Cash Advances, Payments, Payoffs, Interest Accrual, Fees

And Charge Offs. A transaction enters the system via a variety of Front-End applications or is generated internally by a posting system. The transaction posts to the Member’s account in one of the main Posting Systems. As the transaction travels through the Front End and Posting System, it is reflected in the General Ledger. For each movement of funds in the Front Ends or Posting Systems, there should be a corresponding set of two-sided GL entries. Every debit entry (or entries) will have a corresponding credit entry (or entries). The five major Member-account posting systems at NFCU are ALS (Advanced Loan Systems, IMPACS (Checking, Savings, Money Market Savings, and Checking Line of Credit), ST (CD and IRA), TSYS and MSP (Mortgage, Fixed Equity and Home Equity Line of Credit). All these systems reside in mainframe environment. IRC is the front line for all interactions with internal and external systems.

Responsibilities:

•Analyzing mainframe codes COBOL, JCL, SQL, DB2, VSAM, and Terra data scripts programs in the posting systems to perform impact analysis and prepare high level technical design document for enhancements.

•Write, design, code, test, implement, and debug COBOL programs adhering to corporate requirements and standards.

•Research and Analyze the FIS Systems and GL entries for monetary transactions.

•Analysis, Estimate, Design, Coding, and unit testing in FIS IMPACS system(mainframe)

•Research and review data source mapping with Business elements from various systems MSP, TSys, IMPACS (ALS, AM, RM).

•Co-ordinate with Business users, senior accountants and extract data and support adhoc activities.

•Extract and analyze data from MSP Passport queries and TSys Analytics for helping Technical Accounting/Operational Accounting team for their daily, monthly and year end reconciliation tasks.

•Technical lead and mentor to junior members in the team.

•Work with Information Systems Department team to validate/fix the data in the posting systems.

•Process & Governance and Data Quality (ensuring data used is complete and accurate) by performing source to target mapping and prepare document for auditors.

•Develop and perform IRC self-audit of process document and monitoring in order to identify opportunities for enhancement in the data quality.

•Review project BRD for potential 1) Corporate Accounting impacts, 2) risks and controls, and 3) proposal of ongoing IRC project role.

•Schedule meetings with project managers, IT architectures and business analysts to gather business requirements and prepare High level technical design documents.

•24/7 on call for JVS monitoring (Journal Voucher System) and check and confirm the accuracy, if any transaction is posted more than 50K$.

•Status reporting to my immediate manager & Senior Management.

•Provide necessary presentations for each major release of projects to other teams as requested, including IT and business groups.

Project Name : Global Purchasing & Supply Chain

Duration : October 2015 to November 2018.

Technology : z/OS, NATURAL/ADABAS, COBOL, Ansi C, VSAM, SQL, DB2, IMS DB/DC, TSO, CICS, ROSCOE, CA-7, Zeke, Fault Analyzer, Endevor,

Company : General Motors Georgia IT Innovation Center, USA

LOB : Auto

Description :

The Global Purchasing System (GPS) was developed to improve the flow of purchasing information and knowledge worldwide. GPS retrieves and consolidates purchasing data residing in systems used within North American Vehicle Operations (GMNA), General Motors Europe (GME), General Motors Latin America (LAAM), and General Motors Asia Pacific (AP). All of the major Global Purchasing business processes are supported by GPS. Buyers use GPS to create, track, and revise action plans that make up the buyer business plan. Contract functionality promotes the decision-making process from product sourcing to contract creation, as well as facilitates the tracking of savings. By improving access to information, GPS aids the General Motors Global Purchasing organization in managing and facilitating its global purchasing process.

Responsibilities:

•Provide SME support for the Technology Operate team to address production outages. Proactively assess production environment for potential outages or system performance issues.

•Maintain standards compliance Perform Level 2 support for GPSC mainframe applications currently running in Production for GPS CS and PPS applications.

•Schedule meetings with project managers, IT architectures and business analysts to gather business requirements and prepare High level technical design documents.

•Performing DB2 DBA activities using Platinum and DB2 connect.

•Attend meeting with Test lead and QA analysts to prepare testing plan of each project.

•Develop applications using Agile/Waterfall, COBOL, JCL, IMS DB/DC, SQL, DB2, CICS, Mainframe Debug Tools, abend-aid, Fault Analyzer and Xpeditor.

•Analyzing the existing COBOL, SQL, DB2, Ansi C, VSAM, and CICS programs to prepare technical specification and design/code new programs.

•Write, design, code, test, implement, and debug programs adhering to corporate requirements and standards.

•Coded new SQL, DB2/COBOL programs and create reports.

•Review and analysis of SQL performance and Tuning.

•Perform application testing and validation, programming, and documentation.

•Document design decisions and develop software components, adhering to existing process guidelines.

•Co-ordinate with Business Analysts and senior internal and external stake holders.

•Effectively communicates technical information to peers and management, and can provide training as needed.

•Providing Weekly Status Report & modifying the stories as part or scrum meeting.

•Status reporting to my immediate manager & Senior Management.

•Provide necessary presentations for each major release of projects to other teams as requested, including IT and business groups.

Project Name : Bankers Interactive Claims Processing System (Healthcare)

Location : Chicago, IL, USA

Duration : February 2013 to May 2015.

Technology : COBOL, JCL, VSAM, CICS, SQL, DB2, Easytrieve, Visual C++, Endevor,

CA-7, Zeke, CICS Web services

Company : CNO Financial Group, Chicago, USA

LOB : Life & Supplementary Health Insurance (Medicare Supplement, LTC)

Description :

Bankers Interactive Claim Processing System (BICPS) is the Claims adjudication and processing application used in CNO (Both CNO and BLC). CNO has two major business units, Bankers Life and Casualty (BLC) and Conseco Insurance Group (CIG).

Both BLC and CIG have their own line of businesses in Healthcare domain namely:

Medicare Supplement, Long Term care (LTC), Miscellaneous Insurance such as Hospital indemnity, Disability income, Major medical and Specified Disease. The BICPS application consists of batch as well as online components and runs on IBM OS 390. The database is handled by VSAM files. Batch claims will be processed via EDI.

Responsibilities:

•Attend Business meetings to gather business requirements and prepare BRD and High-level technical design documents.

•Participate in QA meetings to derive testing approach for each phase of the project.

•24/7 on call production support for BICPS application.

•Working Application Requests (ARs – Enhancements) directly with Business users and SMEs.

•Analyzing the existing COBOL, DB2, VSAM, and CICS programs to prepare technical specification and design/code new programs.

•Develop/maintain programs using CICS, COBOL, JCL, DB2, PROCs and VSAM.

•Designing, Reviewing, preparing test plans and test cases, and implementing new software.

•Mentored junior team members on the technical aspects, business knowledge aspects

•Perform unit testing and UAT support.

•Perform QA activities such as code quality analysis.

•Resolving issues posted in QC and ServiceDesk.

•Creating new reports in mainframe using EASYTRIEVE and SARVIEW.

•Providing Weekly Status Report

•Status reporting to my immediate manager & Senior Management.

•Involve Disaster Recovery drill and review DR plans, resolve reported incidents and problems via Service Now.

•Provide necessary presentations for each major release of projects to other teams as requested, including IT and business groups

•Assigning work to the team at offshore, reviewing their work.

•Involved in setup for Hadoop Cluster in Pseudo-Distributed Mode based on Linux commands.

•Involved in Core Concepts of Hadoop HDFS, Map Reduce (Like Job Tracker, Task tracker).

Project Name : Custom Management Reporting (Banking)

Location : Chicago, IL, USA

Duration : March 2012 to January 2013.

Technology : COBOL, JCL, VSAM, DB2, SCLM, CICS, Easytrieve, Java (Passport application)

Company : Northern Trust, Chicago (Thru Cognizant Tech Solutions, USA)

LOB : Investment Banking

Description :

Management Reporting provides services on Custody & Trust reporting. CMR provides customized reports to the clients as per their needs. The Reports can be obtained online by the users using the Passport application. In addition to that customized reports either in .CSV or Tab delimited format are also made available for the clients. This can be either FTPed or emailed to the Clients.

Responsibilities:

•Analyzing the existing COBOL, DB2, CICS and Java programs and stored procedures to prepare technical specification and design/code new programs.

•Translating business requirements into detailed design, program specs, coding, testing and installation.

•24/7 Production support.

•Implementation planning, pre-deployment activities and implementation.

•Designing, Reviewing, preparing test plans and test cases, and implementing new software.

•Supported nightly support activities.

•Designed and developed medium to complex COBOL, DB2, CICS programs and implemented in the production environment for new projects.

•Created called CICS adapter to extract string & numeric data from XML input.

•Wrote stored procedures and SQL queries for extracting the details from DB2 database

•Development of several reports using Crystal Reports designer.

•Mentored junior team members on the technical aspects, business knowledge aspects

•Perform unit testing and UAT support.

•Creating new reports in mainframe using EASYTRIEVE and SARVIEW & developing Crystal reports.

•Providing Weekly Status Report to director and stake holders of the project.

•Status Reporting to manager and senior managers

•Participating in business and Team Meetings

•Assigning work to the team at offshore, reviewing their work.

Project Name : Check Free application support & Tax regulations comp

Location : Minneapolis, MN, USA

Duration : October 2009 to February 2012

Technology : COBOL, JCL, VSAM, DB2, CICS, SCLM, TWS, SQL,

Remedy FTP, SAS

Client : ING Insurance, Minneapolis (Thru Cognizant Tech Solutions, USA)

LOB : Life Insurance, Tax system

Description :

CheckFree IRS application provides ING USFS with the capability of gathering all customer tax compliance events from all admin systems into a central location for the purposes of meeting all federal and state compliance reporting requirements. The CheckFree IRS application is an enterprise-wide application which exists on the NW01 mainframe LPAR. The online user interface is in the PRL1CICS region under the HOST region

Responsibilities:

•Developing designs for enhancing mainframe systems

•Communicate intensively with clients, sub-contractors and vendors to establish cordial/effective working relationship.

•Interact with business team and support for their all IT needs.

•Actively gathered requirements with business users in order to describe the business needs in terms of the main deliverable or products that are created.

•Designed and developed forms and Reports using SAS and Crystal reports.

•Analysis and design of each new release in the tax system using COBOL, JCL, Easytrieve, VSAM, SQL, DB2, SFTP and CICS.

•Developed/maintained programs using CICS, COBOL, DB2, JCL and VSAM

•Implementation planning, pre-deployment activities and implementation.

•Involved in writing test plans and testing the application.

•Completed special projects while managing multiple responsibilities simultaneously.

•Came up with lots of improvement ideas for improving the performance of the system and created different tools to improve the productivity of the support activities.

•Worked on setting up a new test environment for segregating the project testing from other projects.

•Worked on production dry run in QA environment to make sure we simulate the implementation to avoid errors.

•Conducted training sessions on both business and technical aspects.

•Involved in release coordination and code Deployment and Supporting Configuration management.

•24/7 Production support for Tax system. Primary owner.

Project Name : Banking – Card Management System

Location : Wilson, NC, USA

Duration : May 2008 to September 2009.

Technology : COBOL, NATURAL/ADABAS, JCL, VSAM, SQL, DB2, MQ, CICS, CICS Web Services, Changeman

Client : BB&T, NC, USA (Thru Tata Consultancy Services, USA)

LOB : Retail Banking (Savings, Demand Deposits & Card Management).

Description :

BB&T is one of the major banks in the North Carolina state. It is dealing with different card types such as stored value cards, Debit cards and credit cards.

Any card request that involves an account that has had the primary address changed within the last 30 days will need to have a letter sent to the previous address to notify the customer that a new card has been requested. The indication as to whether the address has been changed (not a NEW account with a NEW address) will reside on Customer Information File. Customer Information File will provide the address-change-date and a reason-code for the address change.

Responsibilities:

•Responsible for Collecting, understanding, and transmitting the business requirements for the project, and translating these into functional specifications and detailed test plans.

•Analyze the business requirements and determine solutions that fit within the recommended time frame and budget.

•Developed medium to difficult COBOL, VSAM, DB2, CICS software modules to meet the old process specifications, as well as new requirements.

•Developed/maintained programs using CICS, COBOL, DB2, JCL, Visual C++ and VSAM

•Implementation planning, pre-deployment activities and implementation.

•Involved in writing test plans and testing the application.

•Worked extensively on exposing mainframe CICS programs as web services.

•Wrote CICS programs to simulate middleware transactions coming from the WEB, to process on CICS.

•Modified and enhanced existing CICS programs/adapters to supply data via TIBCO to the web identified system interfaces and created the requirements specification document. Performed Requirement Analysis to Develop Use Cases

•Architecture and Design Solutions by utilizing the most suitable technology often requiring emerging technologies, multiple interfaces with high performance and reliability.

•Facilitate and coordinate Design Reviews, User Acceptance Test activities across multiple systems & redesigned, coded, tested and deployed all program changes involving TIBCO on the mainframe when integrating the web front end .Net screens with the mainframe.

•Work closely with Business users to understand the business requirements.

•24/7 production support for Card Management system.

Project Name : CIF application maintenance

Location : Syracuse, NY, USA

Duration : January 2007 to March 2008.

Technology : COBOL, IMS DB/DC, JCL, VSAM, SQL, DB2, CICS, Endevor

Client : AXA Equitable, NY (Thru Tata Consultancy Services, USA)

LOB : Life Insurance

Description :

AXA Equitable Life Insurance Company (formerly The Equitable Life Assurance Society of the United States) is a leading financial protection company and a premier provider of life insurance, annuity, and investment products and services.

CRS & TOPS application maintenance is an ongoing initiative, which involves maintaining/enhancing the existing site and adding new functionality to the system.

Responsibilities:

•Involve in analysis of COBOL, VSAM, IMS DB/DC and DB2 code and provide the solution and make the necessary changes and unit testing as needed. Debug programs to fix the issues. Debug COBOL code using COBOL debugger, Xpeditor and Abend-Aid

•Write SQL queries (SPUFIs) for solving production problems and for reporting purpose. Identify resource needs, project timelines, and manage activities, problem resolutions, issues and project risks.

•Writing various COBOL IMS DC programs for Customer/Account Master Maintenance, Interest calculation, various financial reports and year end miscellaneous reports as per requirement.

•Browse and edit the INFORMIX database using the Dbaccess and ISQL for test data setup and troubleshooting data related issues.

•Co-ordinate with DBA for any database Issues.

•Involve in Unit testing, Integration testing, System testing and User acceptance testing.

•24/7 production support for CIF system.

Project Name : Application Maintenance & VSAM to DB2 conversion (Banking – Savings)

Location : Edinburgh, UK & Chennai, India

Duration : December 2004 to December 2006.

Technology : COBOL, JCL, VSAM, DB2, SQL, PROIV

Client : Standard Life, UK (Thru Tata Consultancy Services, India)

LOB : Retail Banking - Savings

Description :

VSAM to DB2 Conversion project is migrate VSAM data to DB2 tables for the Lynx Savings application, a bespoke application for Standard Life Bank, developed from a base version of the Lynx Lending Architecture supplied by Lynx Financial Systems in 1997. One of the main requirements in this project was to convert VSAM data to DB2 and load DB2 tables & test data in the form of executing whole chain of transaction.

Responsibilities:

•Design and code new COBOL, DB2 modules to convert VSAM files.

•Implemented restart logic in DB2 programs.

•Analyze database requirements for Batch, OLTP and reporting and analysis applications.

•Responsible for maintaining, enhancing and improving some of the jobs related to database on production environment.

•Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis.

•Closely worked with DB2 DBAs and provided good ideas to them.

•Review and analysis of SQL performance and Tuning.

•Provide application maintenance & production support for savings system.

Contact this candidate