ANIL KONDA

714-***-****

acss50@r.postjobfree.com

SUMMARY

11+ years of IT experience as Mainframe Programmer Analyst in the complete spectrum of Software Development Life Cycle including requirement gathering, system design, application development, Testing, deployment and maintenance.

Extensive experience in the design, development, enhancement, migration and testing of applications using COBOL, DB2, JCL, CICS, File Aid, Changeman and xpediter, Oracle BI publisher and FOCUS.

Experience in various domains such as Healthcare, Property and Liability Insurance and Trading (Equity, Fixed Income and Mutual Funds).

Experience with both "Waterfall" and "Agile" methodologies.

Experience in developing SOA (Service Oriented Architecture) based applications.

Experience in leading small development teams both at offshore and onsite.

TECHNICAL SKILLS

Programming Languages: COBOL, JCL, SQL, CICS

Database: DB2, IMS

Oracle Technologies: OBI - BI Publisher

Other Tools: TSO/ISPF, MQ, VSAM, Changeman, File Aid, XPEDITER, File Manager, SPUFI, QMF, SDF II, Endeavor, HP Service Center, HP ALM, Autosys, SDSF, Microsoft Visio, SharePoint, TOAD, Rapid SQL, Data Stage, SAS and UNIX.

Certifications IBM Certified DB2 Associate

PROFESSIONAL EXPERIENCE

Freddie Mac May 2015 – Current

Senior Consultant

Projects:

CDW L3 Development & Maintenance - Supporting level 3 development and maintenance work related to Corporate Data Warehouse application and it’s related compoenets.

Responsibilities

Participating in business prioritization meetings.

Writing Technical requirements and creating required design documents as per the maintenance and L3 devlopment business requirements.

Creating and maintaining SDLC artifacts such as design documents, RTM, SIT plans using tools such as HP ALM and client specific templates.

Modifying and as well as building new components using COBOL/DB2/JCL/SAS components as per Extraction requirements.

Working with various tools such as File Aid, Xpediter, Rapid Sql, IBM Datastage, WinSCP and Beyond Compare.

UBS, Wealth Management Americas May 2012 – March 2015

Senior Consultant

Projects:

Production Support - Wealth Management Trading. As part of this project, Intra day, End of Day and Nightly batch systems that includes key processes such trade collection, validation, Posting and early morning reconciliation.

WMA IT – WMA Remediation. Batch streams of several key applications such as billing, cost basis, fixed income trading, street side trading and mutual funds were redesigned. The project objective is to improve the execution time of critical end of day allocation processing and reconciliation process. Existing EOD batch is redesigned to go hand in hand with Vestmark Trading platform.

End of Day Allocation Booking – Remediation. As part of this project, the End of Day allocation processing batch stream was redesigned by migrating all report-generating batch codes to Oracle BI publisher. For the Intra Day Fixed Income Trading – Remediation project, Cobol/DB2 modules were redesigned to separate the reporting tasks out of Mainframe.

Responsibilities

Participating in BRD walk through.

Writing Technical requirements and creating required design documents.

Maintaining RTM and building System and Integrations test plans.

Analyzing the existing/new Production issues and categorizing them as L1 and L2 deliverables.

Analyze several existing batch streams such as Intraday fixed income processing, End of Day allocation processing, mutual funds processing, reconciliation process jobs (COBOL DB2 VSAM FTP) and prepare inventory of impacted components.

Construction and modification of new and existing source code (COBOL, JCL, DB2, VSAM, CICS) modules per Technical Design Document.

Creating and maintaining DB2 Stored procedures as per the requirements.

Work with QA team in identifying and preparing system and integration test plans.

Coordinate with L3 Development team to handle multiple releases and plan the releases appropriately as per high level project plan.

Work with Change Control in scheduling new jobs and creating triggers (FTP & NDM).

Used Xpediter debugging tool to expedite the root cause analysis process.

Creating Visio Work flow diagrams and documenting As-Is and To-Be processes.

End of Day Allocation Booking – Remediation. As part of this project, the End of Day allocation processing batch stream was redesigned by migrating all report-generating batch codes to Oracle BI publisher. For the Intra Day Fixed Income Trading – Remediation project, Cobol/DB2 modules were redesigned to separate the reporting tasks out of Mainframe.

Analyzed the existing Intraday Process and identify L1 and L2 deliverables.

Prepared list of reporting batch jobs (Cobol/DB2) to be migrated to Oracle BI Publisher.

Created data models for based on file data processing and sql present in existing Cobol/DB2 modules.

Create reports using data models in OBI publisher.

Created custom templates with OBI Publisher plug in using Microsoft Word and Excel.

Scheduled the reports using scheduler to be distributed across money managers via email and printer.

Environment: COBOL, DB2, JCL, File Aid, Changeman, Xpediter.

Auto Club of Southern California, Costa Mesa, CA Sep 2011 – Apr 2012

Senior Mainframe Applications Developer

PRIME to HUON Migration – Automated Underwriter. A critical part of Prime to Huon conversion is to build a new automated underwriting system to support the needs of Auto Underwriters. This included cleansing the Underwriting rules on PRIME and transferring them into the HUON system. A new routing system was built to track the status of new business/amendment transactions from the point of keying in the system to until the completion of underwriting approval.

Responsibilities

Coordinated and attended user meetings to understand and capture user requirements.

Analyzed existing legacy application and identified sub-systems, modules, interfaces and components

Created Visio documents depicting system interfaces and functionalities in the current system

Wrote technical requirements per HUON development standards.

Created system integration test cases

Created requirements traceability matrices for improved tracking

Loaded all test cases in HP Quality Center

Tested and tracked the defects using test lab and defects modules.

Created design documents with flow diagrams using Microsoft Visio.

Developed source code and conversion modules in COBOL, DB2, VSAM, and JCL.

Changed online CICS screens to accommodate the demands of new underwriting rules using SDFII.

Tested batch and online components from unit through system integration testing.

Changeman was used as the configuration management tool.

Updated the stakeholders and immediate management on various milestones

Work with DBA to getting the test region setup for new programs (requesting synonym creation across test regions for the new DB2 tables)

Supported user testing with the required DB2 table loads and fixing the code if required.

Track and execute the change process using HP-Service Center.

Provided day to day production support, preventive and perfective maintenance on the system.

Environment: COBOL, DB2, IMS, JCL, CICS, File Aid, Changeman, Xpediter, SDF2, Visio, HP Quality Center

WellPoint (Anthem Blue Cross), Newbury Park, CA May 2007 – Aug 2011

Senior Mainframe Applications Developer

Project 1: National Migration to WMDS. Implement the new NY National Accounts with membership held on WGS 2.0 to the WMDS system. Membership Extraction procedures and Client/Division mapping procedures are tailored to Fit National Business.

Project 2: CA-EDI Retirement. Develop methods to support claims routing claim routing basis, plan code, DCN number assignment, postback and member validation. Enterprise EDI was needed to develop a method to support dental FileNet images as currently supported by CA EDI.

Project 3: CMS Part C Reporting. Initiate data collection in operations, costs, availability of services, beneficiary use of available services, patient safety, grievance rates, and other factors pertaining to the performance of Medicare Advantage Organizations (MAOs) under Medicare Part C. This data collection was to be completed in phases that adhered to Center for Medicare and Medicaid Services guidelines.

Responsibilities

Attended Business requirements walk through representing as a technical contact for Dental Claims System.

Updated the Business and Technical Requirements Document (BTRD) with corresponding Technical requirements of Dental claims system.

Created SIT cases and mapped to requirements on RTM.

Used Microsoft SharePoint for maintaining project folders and artifacts.

Created Visio documents depicting system interfaces and data flow.

Developed COBOL code using Micro Focus tools on WMDS system.

Built several data extraction routines using COBOL, DB2, IDMS and VSAM for claims data on DB2 tables

Tested all batch components from unit through system integration testing as per the test plans.

Used Xpediter debugging tool for the root cause analysis process.

Coordinated with network team in setting up secure FTP.

Supported user testing with DB2 table loads and fixing codes if needed

Communicated progress and milestones to stakeholders.

Tracked and coordinated implementation process using Service Center

Completed system impact study to determine the technical feasibility of replacing CA-EDI system.

Created system flow diagrams for the current and proposed EDI system using Visio.

Requirements Traceability Matrix was created for effective tracking.

Tracked and coordinated implementation process using Service Center as per Go Live plan.

Worked with the assigned Business Analyst in gathering the Business Requirements

Provided post-release system support

Environment: COBOL, JCL, DB2, VSAM, IDMS, Xpediter, File Aid, Changeman, SAR, Visio, DATACOM

Auto Club of Southern California, Costa Mesa, CA Mar 2005 – Apr 2007

Mainframe Applications Developer

Project 1: SOA Enabling of HUON Application. Objective was to enable Service Oriented Architecture for HUON application. As part of this Requirement analysis around 700 hundred components were figured out. These components are part of the Core System and as well as Servitized Validation System. This will enable to point of sales to access all the services by AAA through the MRM portal.

Project 2: Internet-based Insurance Transactions. The Internet-based Insurance Transaction Phase 1 project is to implement Internet access to the real-time quote transaction system for California, Texas, New Mexico, Hawaii automobile and home policies. The system forms the backend to the .NET interface that provides a quick and intuitive interface to access quotes; based on the User Inputs.

Project 3: Business Support Group Application. Enable tracking, monitoring and migrating changes to the Business Management Tables through CICS interface for the Business Support Group. The project scope also includes fixing program malfunctions in the existing system.

Project 4: HUON Par Support. The project aimed to resolve various malfunctions existing in the HUON application. Supported, maintained, and enhanced the HUON application for the Membership system. Specific duties were to resolve the assigned defects, maintain system integrity and enhance the Membership system through Change Service Request to meet the company requirements.

Responsibilities

Review the IM tickets and bug descriptions.

Coordinate the bug fix process using Service Center.

Created VISIO documents depicting system interfaces and functionalities in the current system

Coordinate with users and operations and apply code fix in accordance with SLA.

Root Cause Analysis and documentation

Analyzed user requirements and wrote technical requirements.

Analyzed existing user support screens and quote generation process

Prepared design documents and test cases.

Designed UI screens according to user requirements using SDF2

Constructed COBOL, CICS and DB2 programs that could handle the screen operations and updated the DB2 tables.

Coded programs to enable paging logic for the user comfort.

System, unit and user acceptance testing

Coordinated production installation process using Service Center.

Supported post production move activities and system support.

Environment: COBOL, CICS, DB2, SDF-II, Changeman, Xpediter, File Aid

Used Xpediter to identify the problem codes in case of any abends

Center for Development of Advanced Computing, UST Global Oct 2004 – Feb 2005

Mainframe Applications Developer

On boarding Training and Mentoring. Attending several class room and hands on sessions on COBOL, DB2, JCL and VSAM.

Responsibilities:

Attended classroom sessions on various SDLC methodologies, requirements analysis and discussed SDLC artifacts

Participated as a spectator in project kick off meetings.

EDUCATION

Bachelor of Engineering in Electronics and communications from University of Madras, Madras, India

IBM S/390 Mainframe, Centre for Development of Advanced Computing (C-DAC)

Contact this candidate