Chandan C V

ac70zg@r.postjobfree.com – 614-***-****

SUMMARY

Over 13 years of experience in various roles like Developer, Tech Key, Team Lead etc., with expertise in Application Software analysis, design, development, testing and maintenance of various applications.

Extensively worked on various technologies like Cobol, DB2, JCL/PROCS, VSAM, CICS, REXX, IMS DB/DC, SAS, PERL, Oracle/SQL, Java, Javascipts, HTML & XML.

Expertise in working with various databases including DB2, IDMS, IMS DB/DC and oracle. Extensively worked on database design, normalization, Stored procedures, Cobol-DB2 both batch and online systems. Worked on Database tools such as SPUFI, QMF, Platinum, AQT, TOAD, IBM Data Studio etc.

Extensively used version control tools such as Changeman, Github, PANVALET, HARVEST & Endevor.

Extensively on worked on IDE’s like RDZ/IDZ, Visual Studio & Microfocus Workbench (Net Express).

Strong working knowledge on other mainframe tools such as SYNCSORT, DFSORT, ICETOOL, FILE-AID, FTP, FILE MANAGER, TSO/ISPF, ABEND-AID, Xpediter, IBM Debug, System Utilities like IEFBR12, IDCAMS, IEBCOPY, IEBGENR etc.

Batch Scheduling tools like ESP/CA 7 etc. with extensive development on the same.

Good experience on Web Services and tools like Parasoft and SoapUI SOAtest API’s.

Good experience as Developer & Technical lead in Insurance (Auto & Property Policy Systems), Billing System, Securities, Cash Movement through EFT (Checks, Wires, Deposits etc.), Annuities, Brokerage Commissions System (Life & Annuities) & Healthcare, Claims Processing system (Healthcare & Auto).

Was part of Successful implementation of Transformation Project which involved rewrite of legacy system with a new approach.

Worked as a Tech Key for Agile Line in Nationwide Insurance. Extensively worked with Agile teams and extensive knowledge of Agile Methodology.

Scrum Certified & M101N (MongoDB for .net Developers) certified.

Performed various roles from Developer, Lead, SME/Specialist, Tech Key, Onsite Co-Ordinator, Business Analyst, tester etc.,

Experience in working with Development projects, Maintenance projects, Re-Engineering projects, Conversion projects using Agile and Waterfall methodologies.

Good working knowledge on Dev-Ops. Was part Harvest to Github migration.

EDUCATION & CERTIFICATIONS

Bachelor of Engineering from Malnad College of Engineering Hassan, Visvesvaraya Technological University, India

TECHNICAL SKILLS

Function Domain

Insurance (Auto & Property), Banking (Cash Movement), Billing System, Annuities & Claims Processing (Auto & Health Care), Brokerage Commissions System(Life)

Languages

Cobol (MF & VS), REXX, SAS, XML, CList, Java, C#

Database

DB2, Oracle, SQL, IMS DB/DC, MongoDB (Trained & M101 Certified),

Application / Web Servers

CICS Web Services (Channels & RRBUS), SoapUI, Parasoft

Operating Systems

MVS, OS/390, Z/OS, Windows

Development/Productivity Tools Used/Utilities

Rdz, Eclipse, File-AID, File Manager, Platinum, AQT, FTP, JCL/Proc, PERL, Net Express, TSO/ISPF, QMF, SPUFI, IBM Data Studio, TOAD, DFSORT, Xpeditor, TraceMaster, SWIFT Tool.

Front End Systems

CICS (SDSF, TEX/SDL), MF Dialog(like VB), VB, .net (Basic)

File Systems

VSAM, ISAM

Version Control Tools/ Testing Tools/ Technologies

Changeman, Github, Harvest, Endevor. Gherkin, Cucumber, Ruby Mine, SoapUI, Parasoft

Desktop Tools

Excel, Word, PowerPoint, Visio, Project, Microsoft Outlook, Jira, Quality Center(QC), IBM RTC, SPOT, Lotus Notes.

PROFESSIONAL EXPERIENCE

Organization : Populous Group

Location of Work : Camp Hill, PA

Period of Work : August 2018 – till date

Project Name : ECS (Enrollment Communication System) Outbound

Client : Highmark Health Solutions (HMHS)

Role : Senior Developer

Description: ECS is a DB2 based membership system with a GUI interface and is primarily used by the Membership and Billing Department to enter and maintain enrollment information. ECS houses Highmark's membership data. The data (5.5 mil covered individuals) is stored in tables for current and history data for up to 7 years. On top of 40 Current and History tables, ECS has ID card table, Security Blue survey and survey response tables, inbound specific tables and application system error log table.

Responsibilities:

Perform various development activities like code Cobol/DB2/CICS modules, JCL’s etc.

Performed Functional testing on various CR’s like TELADOC, OPTUM Yearend testing etc.

Supported all implementation related tasks on release weekend.

Write/Update scripts to Select, Insert & Update SQL’s. Wrote some complex queries.

Ran Daily Standups, Bi-weekly grooming sessions across the team that was located in various geographical locations.

Work with offshore team to get the tasks completed.

Work with Business Team to gather requirements and update technical specs accordingly.

Got involved in review process across the team be in Code Review, Test Case Review, etc.

To keep track of all the documentation required for each CR’s.

Support QA testing and was major point of contact for any issues.

Present the functionality developed during Show & Tell every iteration.

Provided technical solutions to business problems and Initiatives.

Environment: Cobol, DB2, Endevor, TraceMaster, TOAD, FTP, DFSORT, IDT, M4IN, Web Services, SQL, SPUFI, JCL, VSAM, CA Workstation, ESP, MVS, ISPF, EZTriv.

Organization : Populous Group

Location of Work : Dublin, OH

Period of Work : May 2018 – July 2018

Project Name : LCS (Commission System for Life)

Client : Nationwide Insurance

Role : Specialist/Developer

Description: LCS administers brokerage commission tracking and payments. Current systems feeding into LCS are: ALS, IPAS, Prefix and LCOM. The daily commission interface calculates broker commissions, verifies licensing, processes commission suspense, and performs accounting. The non-daily commission interface generates commission payment and statement transactions, which are sent to downstream systems. LCS non-daily process runs on a weekly (4 cycles per month) basis.

Responsibilities:

Develop new MF Visual Cobol programs on Visual Studio.

Develop new SQL’s to fetch the data from oracle database for LCS and DB2 for LCOM systems.

Wrote SQL Scripts to Insert, Update, Alter tables as part IUL Product setup which was run across regions.

Wrote scripts to Insert & Update rows, Alter Tables, Update Indexes etc. on the DB and executed them on AQT.

Wrote FTP steps on LCOM to Import/Export the files from desktop path.

Developed SOAP web service both from scratch as well as updated existing ones. Coded required copybooks, modules etc.

Work on batch scripts developed on PERL for LCS and JCL’s for LCOM.

Working on few Utilities on VB Scripts to help speed up process.

Supports Test region flows for the new code being developed for Promise 2020.

Good understanding of various concepts of Annuities like Funds, Withdrawals, various products offered etc.

Scheduling 3 Amigo and walk through the cards that are worked on with Analysts & Tester.

Present the functionality developed during Show & Tell every iteration.

Provided technical solutions to business problems and Initiatives.

Environment: MF Visual Cobol, DB2, PERL, Github, Harvest, Oracle DB, AQT/TOAD, Web Services, SQL, SPUFI, RDz/IDz, JCL, VSAM, File manager, SPUFI, CA Workstation, ESP, Gherkin, Cucumber, MVS, ISPF, Java.

Organization : Populous Group

Location of Work : Dublin, OH

Period of Work : Nov 2016 – May 2018

Project Name : PALLM (Packaged Automated Life & Liability Management)

Client : Nationwide Insurance

Role : Specialist/Developer

Description: PALLM is used to manage annuity policies Nationwide has been contracted to manage for customers. PALLM system is capable of handling new business setup as well as the any changes to existing contract. The policy can be setup and changed on IATD system or PALLM CICS system. There are three parts to batch processing on PALLM. The pre-cycle, the cycle processing & Finally, the post-cycle. Worked on all of batch system cycles as well online CICS & IADT screens.

Responsibilities:

Develop and test new programs/job’s as part of dev cards. Update and write new Sort cards.

Worked on CICS Screen changes and Programs. The Map changes were made using TEX/SDL script.

Develop and test Screen changes on IADT on Jacada and Java platform.

Writing REXX routines for ad-hoc utilities as per requirement. Worked on REXX utility to set up the cycle parallel for Test region (BETA & Prod)

This system was a multiple computer distributed transaction processing system with multiple sub-systems and software.

Used Microsoft’s Distributed Transaction Coordinator (DTC) and Microsoft Transaction Server (MTS) for automatic Distributed Transaction Processing (DTP) with Oracle’s database, since Oracle is XA interface compliant.

As part of dev-ops utility to automate the batch cycle, developed the final reports on SAS.

Worked as Business Analyst for few projects. Worked with Requirements team and technical team to break down the requirements into Story Cards.

Extensively used RDZ for development activities.

Scheduled and supported development region flows on daily basis.

Primary contact for test region batch flows (Alpha & Beta support) alternatively.

For Rate Indicator changes worked with Business to gather requirements and wrote the story cards. Wrote detailed design doc, developed and worked with the team till implementation.

Scheduling 3 Amigo and walk through the cards that are worked on with Analysts & Tester.

Present the functionality developed during Show & Tell every iteration.

Provided technical solutions to business problems and Initiatives.

Environment: Cobol, JCL, Changeman ERO, IMS DB, SAS, REXX, VSAM, DB2, File-AID, CICS(TEX/SDL), Web Services, SQL, SPUFI, Eclipse, Java, Jacada, DFSORT, SYNCSORT, SoapUI, RDz/IDz, CA Workstation, ESP, Gherkin, Cucumber, MVS, ISPF.

Organization : Wipro Technologies

Period of Work : July 2014 – Aug 2016

Project Name : COSMOS SS&S

Client : United Health Group

Role : Tech Lead/Developer

Description: COSMOS: stands for Comprehensive On-Line Software for Management and Operational Support, developed for Unisys but later migrated to IBM mainframes using DB2 as Database. UnitedHealth Group uses COSMOS to manage and support millions of members and thousands of employers and providers. COSMOS is primarily used for local health plan business for small market (2-50employees) and middle market (51-10,000 employees) employers. The system contains current and historical information about members, providers, contracts, Claims and payments. This project caters to provide 24/7 SSS support for continuity of business involving online as well as batch applications. Also to solve business problems and provide answers to user questions for application functionality and correct execution.

Responsibilities:

Involved in coordination activities with offshore/client, system analysis, requirement gathering (SUF and SRQ), development, maintenance and enhancements to support 24/7 operations Train & Guide the team throughout the implementation.

Good understanding of claims processing i.e. CALC, UNCALC, RECALC, UFE, and Check-write processes.

Responsible for business continuity of COSMOS application and Batch system by providing timely resolution for errors/business tickets and issues in Batch and problems in online systems Responsible for all the deliverables from offshore and onsite team.

Handling JOB scheduling as per the user requirements, sending reports to user accounts or to common access platforms as and when needed. Initiation and involving the team in White Board discussion if a story card requires further analysis.

Provide technical guidance to team members on the project and defect cleanup.

Maintaining Training plans, knowledge building and team coordination

Identify the area for efficiency improvement in AOA Property application to enhance the system performance, improve business and gain confidence of the End user and IT management.

Creating Technical design documents from Functional/Business requirement documents.

Retouching of production records in DB as well as loading and unloading DB2 databases as per the client requests.

Executing REXX utilities in order to ensure 100% claims processing and taking necessary action as needed.

Enabling team members through mentoring, pointed discussions and issue resolution guidance

Environment: Cobol, JCL, Changeman ERO, IMS DB, REXX, VSAM, DB2, File-AID, CICS, VSAM, SQL, SPUFI, QMF, ABEND AID, RDZ, OPC, HPSM

Organization : Wipro Technologies

Period of Work : May 2013 to June 2014

Project Name : CSS CAPEX

Client : Charles Schwab

Role : Tech Lead/Developer

Description: Charles Schwab is a Banking and Brokerage firm. This project involved Maintenance and Production support for Cash movement system. Cash movement involves processing of incoming and outgoing wires and electronic fund transfers (Wires, ACH transfers, Checks, Journals, Deposits, Interbank transfer etc Deposit Funds to client accounts through different channels and Transfer of funds between Accounts within same bank or different banks.

Responsibilities:

Design, Development, testing & implementation of Blanket SLOA (Standard Letter of Authorization), Wire Redesign (MyQ Implementation – New System to replace current Wire system), Aggregate Margin etc.

Co-ordinated offshore team with 10 members. Single point of contact for any issues with the offshore.

Co-ordinated tasks & issues between offshore & onshore on daily basis. Was responsible and accountable for all deliverables from CAPEX team.

Good understanding of cash movement i.e. Checks, Wires, Journals & Deposits.

Analyze business and technical requirements to create detailed design document.

Responsible for preparing extensive Test case document for the requirement to exhaust all possible scenarios. Created Test Data and analyzed the results.

Worked on few DB2 Stored procedures.

Support QA team during QA testing phase. Address all queries raised by the QA team.

Implementation support.

Prepared traceability matrix to match each requirement through testing.

Review all the deliverables from offshore.

Preceded daily stand ups and weekly onshore calls.

Enabling team members through mentoring, pointed discussions and issue resolution guidance

Environment: MVS, ISPF, Cobol, REXX, SAS, Endevor, DB2, IMS DB, DB2 utilities like load/unload etc., CICS Web Services (RRBUS), SQL, Data Studio, TOAD, SPUFI, QMF, Platinum, File-AID, .net call to stored procedures, DFSORT, SYNCSORT, Parasoft, Stored Procs., TraceMaster, VSAM

Organization : Wipro Technologies

Location of Work : Columbus, OH

Period of Work : June 2012 – May 2013

Project Name : Flex Consolidation (Conversion Project)

Client : Nationwide Insurance

Role : Tech Key/Developer

Description: NBP is Nationwide Billing platform which serves as Billing System to whole of Nationwide Business, be it Agents, Customer etc. Everyone uses the system to pay Bills. NBP is a Mainframe system with DB2 as Database which performs all Billing related transaction. NBP interfaces with NMPS (Nationwide Money Processing System) which is a Money system. Nationwide bought another insurance company called Allied Insurance. Allied Billing platform is Flex. The project is about converting Flex Policies & Accounts to NBP platform. As a Key was involved in the initial estimation, design etc. NBP has a front system called BAM which is developed in ASP.net. The transaction between BAM & NBP is handled through CICS Web services. The initial work in the project was done to get some DB2 tables updated with new column’s and getting a new table added, building some input & response fields to existing Web Service called as BAD.

Responsibilities:

Worked with the NBP requirements team and Architect to understand the scope of the whole initiative.

Initial estimation, Design and breaking down the requirements into story cards.

Responsible for planning/estimation, technical discussions, technical reviews and code walk through, Unit testing, implementation and analyzing the risks.

Responsible for conducting weekly IPM’s with requirement team for estimation for each story card.

Implementation of TDD (Test Driven Development), Paired Programming across the development team.

Initiation and involving the team in White Board discussion if a story card requires further analysis.

QA Support and production support for any implementation.

Development and Unit Testing both online and batch applications based on the card assigned.

Preparing extensive Test cases for the story cards to exhaust all possible scenarios. Created Test Data and analyzed the results.

Provide technical solutions to business problems and Initiatives.

Provide technical guidance to team members on the project and defect cleanup.

Environment: MVS, ISPF, Cobol, REXX, Changeman, DB2, IMS DB/DC, DB2 utilities like load/unload etc., CICS Web Services (RRBUS), SQL, Data Studio, TOAD, SPUFI, QMF, Platinum, File-AID, .net call to stored procedures, DFSORT, SYNCSORT, Parasoft, Stored Procs., VSAM

Organization : Wipro Technologies

Location of Work : Columbus, OH

Period of Work ` : Nov 2008 to May 2012

Project Name : AGSS (Agent Gateway Sales & Service)

Client : Nationwide Insurance

Role : Specialist, Onsite Coordinator, Tech Key, Developer

Description: Rewrite of the Legacy AOA application (Quotes, New Business and Inquiry/Changes) with new platform. AOA is an Agent System for writing Nationwide Policies on Property Insurance. The new platform is developed on an IDE provided by Micro Focus. The Current AOA Screens were redesigned with MicroFocus Dialog (GUI Screens more like VB). MF Dialog Screens serve as Front End for the Agents and MF COBOL is used to perform all Business Validations. All the linkages, modules, segments and file systems are being redesigned to improve the maintainability of the new Application.

Responsibilities:

Learn to design new screens with MF Dialog and implement screens across all LOB’s.

Train & Guide the team throughout the implementation.

Design and implement 4 LOB’s - Tennent, Condo, Dwelling Fire & SPP.

Responsible for all the deliverables from offshore and onsite team.

Implementation of TDD, Paired Programming across the development team.

Initiation and involving the team in White Board discussion if a story card requires further analysis.

Development and Unit Testing both online and batch applications.

Converted ISAM Files to XML files as part development.

Provide technical guidance to team members on the project and defect cleanup.

Communicating with BSA area to understand the impact of the Projects & Defects implemented on the ADC.

Identify the area for efficiency improvement in AOA Property application to enhance the system performance, improve business and gain confidence of the End user and IT management.

Creating Technical design documents from Functional/Business requirement documents.

Responsible for preparing extensive Test case document for the requirement to exhaust all possible scenarios.

Environment: MF Cobol, MF Dialog, Net-Express, Harvest, VS Cobol, CICS, MVS, ISPF, REXX, Changeman, JCL, VSAM, DB2, CICS Web Services, XML, SoapUI, Ruby, Gherkin, Cucumber, File Aid.

Organization : Wipro Technologies

Location of Work : Dublin, OH

Period of Work : June 2007 to Oct 2008

Project Name : Service Advantage Auto

Client : Nationwide Insurance

Role : Developer/Onsite Coordinator

Description: The Service Advantage Integration initiative was identified to support nationwide organizational goal of sustained growth and profitability. Was part of Allied Auto System (Service Advantage). Basic theme of the project was integration of Allied and Nationwide systems. Allied front end was Agent Center developed in VB.net. Worked on following initiatives on allied system:

1. UWRS (Underwriting Report Ordering System)

2. IN Common Product: Introduced some new features on SA like Accident Forgiveness, Minor Violations Forgiveness, Roadside Assistance, Customization etc...

3. Class Plan M: Class M is program by Nationwide to bring uniformity in rating structure across the system. Was part of implementation of same on Allied Platform.

4. FL Auto: FL was only on Nationwide platform earlier. Service Advantage was identified to support the change of Florida agents from Nationwide agents to Independent agencies. Was part of development and testing phase.

Responsibilities:

Responsible for the Delivery of the Tasks Assigned to the team & self.

Creating Technical design documents from Functional/Business requirement documents.

Creation of Test plans for System testing as well as User Acceptance Testing

Development & Unit Testing. Worked as System Tester as well.

Primary point of contact for any support activities during Smoke Test, implementation support etc.

Excelled in tasks assigned got lots of accolades. Had built up great Rapport with the client team,

Environment: Z/OS, IMS DB, DB2, VSAM, COBOL, JCL, QMF, Changeman, XPEditor, CICS (SDSF Tool)

Organization : Wipro Technologies

Location of Work : Dublin, OH

Period of Work : Nov 2006 to May 2007

Project Name : Nationwide New Auto Processing System (NAPS)

Client : Nationwide Insurance

Role : Developer /Onsite Coordinator

Description: NAPS is a configuration of several sub systems, each designed to support a portion of the processing of an automobile insurance contract. The system processes personal auto liability first-party coverage insurance, and several other non-automobile related insurance coverages. It supports the necessity of creating new policies and maintaining, changing and deleting specific information in existing policies. NAPS support thirteen regional offices servicing District of Columbia and forty-five other states.

Responsibilities:

Responsible for the Delivery of the Tasks Assigned to the team & self.

Coding & Unit Testing.

Train & Guide offshore team. Responsible for all the code delivered from offshore.

Successfully completed, KAP, Shadowing processes, which was a phase in setting up onsite/offshore model.

Environment:

Z/OS, IMS DB/DC, VSAM, COBOL, JCL, Changeman, DB2, IBM Debugger.

Organization : Wipro Technologies

Location of Work : Bangalore, IN

Period of Work : Mar 2005 to Nov 2006

Project Name : AOA Auto

Client : Nationwide Insurance

Role : Developer (Offshore)

Description: AOA is front-end system for Agent to do the transactions on Nationwide Auto Insurance. The insurance takes cares of all types of vehicles PPA, MH, A&C etc. It allows a Agent to gather all the information required from the Customer and release a policy. An Agent can perform 3 operations Quote, NB and I/C. Also AOA allows agent to Remittance at EOD. AOA interfaces with the NAPS systems on both the input and output sides. Input from AOA enters through the Auto Input Systems (AIS). Policy record updates are passed back to AOA out of POLICY, CBS, and AUS.

Responsibilities:

Coding, Unit Testing and System Testing

Code Reviews & Supported the team during any issues

Worked as Technical Lead on few enhancements. Provided design documents and was involved in Code reviews, Test Plan reviews etc.

Environment:

Cobol, MF Dialog, Net-Express, Harvest, JCL, DB2.

Contact this candidate