Work Experience Summary

• Proficient in planning, analyzing, designing and development of applications.
• Proficient in planning, analyzing, designing and development of applications using PL/SQL, SQL, Shell Scripts, DB2.
• Experience in developing functional/system specifications, use case documents, prototypes, screen mockups, data mapping specs, business process models and data flow diagrams.
• Experience of using tools and technologies SORT/SYNCSORT, IDCAMS, IEBGENER, IEBCOMPR, IEFBR14, IEBCOPY, LOAD, UNLOAD, Toad, SQL Loader, WinSCP, FileZilla, Putty.
• 7 years of extensive IT experience in all phases of software development life cycle SDLC including requirements analysis, design, development, testing, deployment, maintenance, enhancement, support and documentation of applications written in COBOL, JCL, DB2, VSAM, MS, Oracle, PL/SQL, Unix.
• Experience of performance tuning of SQL queries and using Oracle analytical functions to meet the business defined SLA.
• Knowledge of Star and Snowflake Schema.
• Implementations of data structure with the usage of Pointers in Cobol.
• Proficient in writing programs with Cobol, DB2, IMS.
• Proficient Configuration management and Version control tools like SVN, VSS, Vantive, Panvalet.
• Proficient in IBM tools like XPEDITOR, FILEAID, STS, LCS, SPUFI, ENDEAVOR
• Proficient in conducting code reviews, creating Test Plans Test scenarios
• Experience in working with Telecom and Health Insurance industry.
• Possess good interpersonal and Leader ship skills and keen understanding of Business Processes.
• Highly motivated with the ability to work effectively in teams as well as independently.
• Good Communication and Presentation Skills.

Technical Skills

Work Experience

Confidential

Role

Sr. Software Developer

Description

Confidential is the Annual Return/Report of Employee Benefit Plan, which certain employee benefit plans, must file to satisfy annual reporting requirements under ERISA and the Internal Revenue Code. The ERISA system is run in during the months of January through April for active customers for the prior year. The system retrieves contract, income and claims data from various sources in the company for specified customers and is reported on form 5500 of the Employee Retirement Income Security Act of 1974. The data is accumulated in the database and is summarized for the prior year by customer and line of business.

Responsibilities

• Analyze business process and gather project requirements, document and implement the system.
• Created data flow and system integration diagrams to explain the current flows.
• Created use case documents for enhancements done during the project.
• Configure, test and deliver the solution as per requirements.
• Continuous system support throughout the Project.
• Design and develop programs and reports with suggestions to the necessary software components required for the system setup.
• Created test cases in Quality Centre to provide visibility and maintain traceability among user requirements, functional requirements and use cases.
• Attended daily status meeting and offshore conference calls to perform the testing in the Integration, Development and Production environment.
• Analyze business requirements and segregate them into high level and low-level use cases, using MS Visio.

Environment: MVS, JCL, Cobol, DB2, VSAM, Easytrieve, FTP, Endeavor, In sync, HP Service Manager, SQL, PL/SQL,

Confidential

Role

Mainframe Developer

Description

This project is to migrate existing application from one database to data warehouse system. The scope of this project is to update existing the existing programs to source data from the new data source, provided by data warehouse team.

Responsibilities

• Facilitating JAD sessions for requirements walk-through with business and technical teams to resolve business and system issues.
• Create Technical design document for sourcing data from new data source.
• Facilitating JAD sessions for requirements walk-through with business and technical teams to resolve business and system issues.
• Understanding of current system and represent the same in data flow diagrams.
• Creation of data mapping and ERD diagrams.
• Liaise with business team to review high-level requirement documents.
• Analyze business requirements and segregate them into high level and low-level use cases, using MS Visio
• Environment
  • SQL, PLS/SQL, WinSCP, MVS, JCL, Cobol, DB2, VSAM, FTP, Endeavor, In sync, MS Visio

Confidential

Role

System Analyst

Infocare serves as the pre-enrollment, annual fulfillment and reconciliation system for Medicare advantage plans. Medicare is the federal health insurance program for people who are 65 or older, certain younger people with disabilities, and people with ESRD. An interface has been built with CMS to submit enrollment, plan change and disenrollment transactions. The CMS provide response for these transactions based upon which letters are created for the members. Infocare interfaces with different systems like MHS, Marketing data base, MBRS,SLIQ and ROAM thereby synchronizing the data across systems.

• Designed complex SQL queries and SQL procedures as per the business requirements.
• Develops application code using technologies like Unix, PL/SQL.
• Provide Support of existing applications in Unix, Oracle and Mainframe.
• Creates and maintains the documentation for the modules on sharepoint.
• Defect logging and tracking in Service Manager.
• SQL, PLS/SQL, Unix, Putty, WinSCP, MVS, JCL, Cobol, DB2, VSAM, FTP, Endeavor, In sync, Hp service Manager

Confidential

• Liaise with DW team to review high-level requirement documents and technical documents.
• Create Business Requirement document for the migration of IDW application to data warehouse.
• Analyze business requirements and segregate them into high level and low-level use cases, using MS Visio
• Develops application code using technologies like COBOL, CICS, JCL, DB2 and Unix shell scripting, PL/SQL.
• Designed complex SQL queries and SQL procedures as per the business requirements.
• Design testing strategy for different components of the system.
• Identifies and creates unit test cases and write code to validate those test cases.
• Deployment of code from test to production regions.
• Provides Test Team Support and Data setup in test environment.
• Emergency patch for critical production issues.
• Defect logging and tracking in Quality Centre.
• Creates and maintains the documentation for the modules on sharepoint.
• Work experience in message transmission using MQ series Queue manager to communicate among different systems
• Production Support of existing applications in Unix/ Oracle/ Mainframe.

Environment

MVS, JCL, Cobol, DB2, VSAM, CICS, MQ series, UNIX, XML, WinSCP, Putty, Oracle 11g, PL/SQL, Secure FTP, Panvalet, Endeavor, ESP, Quality Center, SVN, Data Fix tool, HP Service Manager

Confidential

Role

Developer and Coordinator

Description

• The new version of this product is implemented in this release, which will eliminate the Visual Basic code from this application and will be available on intranet for the user to order print online.
• Avanti is a vendor product used to order, track, allocate charges and ship State Farm produced fabricated items. This application order print items for Agents and employees for corporate and regional departments.

Responsibilities

• Analyze business process and gather project requirements, document and implement the system.
• Technical coordination amongst Vendor and State Farm.
• Involved in Analysis, Design, Development, and Unit Testing of solution.
• Development of Mainframe code for reconciling customer information between Avanti and State Farm database using technologies COBOL, PL1, JCL, DB2 and SQL.
• Involved in Performance tuning and optimization process.
• Actively participated in the enhancement / maintenance activity for DB2.
• Application deployment on Windows workstation and server.
• Involved in discussion meetings with system test support.
• Coordinating the installation of the vendor product.

Environment

• MVS, JCL, Cobol, DB2, SQL, PL/SQL, PL1, Citrix, File-Aid, Panvalet, RACF, TSO BLDISS, Hp Service manager, Lotus Notes, RMS

Confidential

Role

Developer/Offshore Coordinator

Description

Bill Print project was a redesign of the legacy bill printing system, which is a group of mainframe applications that handles billing calculation and presentation for CABS. It also handles miscellaneous billing, bill editing and bill distribution through various media and Connect:Direct.

Responsibilities

• Gathering client requirement and creating Detailed Design documents.
• Developed code using pointers to create linked lists instead of arrays.
• Conducting code review, creating unit Test Plan, Executed unit test cases and documented test results.
• Handling production defects.
• Browsing the VSAM files and datasets using FileAid
• Performance improvement activities.
• Experience in conducting training sessions.
• Environment
  • MVS, JCL, Cobol, DB2, VSAM, File-Aid, Panvalet, FTP, NDM, SPUFI, STS, LCS, Xpidetor, UNIX, SQL.
• Confidential

Role

Mainframe Developer

Description

• Carrier Access Billing System CABS is a group of mainframe applications that process billing information for Industrial Customers, such as CLECs, RBOCs and Inter-Exchange Carriers IXCs . SECABS has two different sub applications to bill IXC and UNE. M/F bills IXCs and Midrange applications bill UNEs.

Responsibilities

• Involved in all phases of SDLC including analysis, design, development, testing, maintenance and support of mission critical business applications using formal software engineering and project management methodologies in IBM Mainframe.
• Prepared Unit Test Plan, Executed unit test cases and documented test results.
• Developed code using complex logic of pointers to create linked lists instead of arrays.
• Deployment of code to testing and production environment.
• Handling production defects.
• Performance improvement activities.
• Experience in conducting training sessions.
• Troubleshooting and analytical as well as problem solving skills.

Environment

• MVS, JCL, Cobol, DB2, CICS, IMS DB, VSAM, File-Aid, Panvalet, FTP, NDM, SPUFI, STS, LCS, Xpidetor, UNIX

Confidential

Role

Mainframe Developer

Description

is an important part of the IT division of AT T. ESS project is an enhancement and maintenance project that has multiple applications like LERG Local exchange routing guide , NDS Network data system and TNDS total network data system . NDS and TNDS projects provide Network Planning Engineers with network usage information and forecasts to support reliable and economic use of the trunk network

Responsibilities

• Responsible for development and implementation of technical solutions.
• Testing the developed applications at various stages UNIT, Integration .
• Developed new JCLs and jobs.
• Work experience in message transmission using MQ series.
• Written SQL Queries for Test Data Setup using various joins.
• Prepared Unit Test Plan, Executed unit test cases and documented test results.

Environment

OS-390, JCL, COBOL, MQ series File-Aid, Changeman, FTP, NDM