Professional Summary

• Has over 12 years of experience in Information Technology and in Mainframe-based systems.
• Excellent experience in training and mentoring team members with technical/system knowledge and business processes.
• Highly driven, versatile and analytical IT specialist with global experience delivering Infrastructure support and projects across large enterprise environments.
• Worked closely with business stakeholders to manage the delivery of high quality, cost effective infrastructure improvements across large, complex environments from development to production
• A solid communicator, problem solver and infrastructure specialist who clearly articulates complex scenarios to both business and IT personnel, and demonstrates a strong customer focus.
• Worked in Multiple roles as a Database Administrator,System Administrator,Data Conversion Lead and Mainframe Senior Analyst in previous assignments
• Worked extensively in design, development, implementation, testing and re-engineering on IBM Mainframes along with excellent database knowledge and programming skills.
• Coordinated and implemented configurations and performed revision management solutions. Worked extensively in COBOL, PL/1, CICS, DB2, IMS DC, IMS/DB, JCL, VSAM, ChangeMan, and J2EE and well versed with RDBMS, Hierarchical Databases.
• Record of success in design, development and implementation of software applications.
• Currently working as a Systems Administrator supporting Windows environment and SQL Server environment.
• Technically savvy and a quick study in emerging technology, able to quickly assess and utilize the appropriate response to meet specific needs of the business.
• Certified with ITIL F ,INS 21
• Good Exposure to Quality Standards in Six Sigma .Participated in Companys certification to SEI-CMM Level 5

Technical Skills

Hardware:

IBM Mainframes

Operating Systems:

Windows 98, Windows XP, OS-390, UNIX.Windows Server 2003.Windows 2008 Server R2

Languages:

C/C++, Core JAVA, COBOL, PLI, JCL, REXX, IMS DB/DC, ,MVS,TSO, ISPF

Databases:

DB2, ORACLE 8i, VSAM, MS Access, MS SQL Server 2005 & 2008

GUI:

Visual Basic.

FRONT END:

Oracle Developer 2000, CICS.

Web Related:

HTML, Java Script

Tools & Utilities:

Eazytrieve, Abend-aid, Panvalet, Dumpmaster, Xpeditor, SPUFI, File-Aid, Omegamenon,Extra and Rumba for Mainframe Connectivity,Clearcase ,ClearQuest,DB2 SQL Stored Procedures,IBM Control Center,JIRA,Cygwin,XF Rendering,SQL Delta,VMWare,Vsphere,SSIS

Domain Knowledge:

P & C Insurance Business, Retirement System,Unemployment Insurance,Department of Motor Vehicles

ERP:

People soft 8.12 Financials ,HRMS,SAP PCM

CRM :

Siebel 7.5

Reports:

SQR, Crystal Reports, PS/nVision, Actuate

Professional Experience

Working as a Software Specialist with Confidential, (12/2006 – Till Date)
Worked as Senior Systems Analyst with Confidential, (08/2003-12/2006)
Worked as Software Engineer with Confidential, (06/2000-07/2003)

Education & Trainings:

• Bachelor of Engineering (BE)

Professional Experience

1.

Client

Confidential,

Role

Duration

07/2007-Till Date

Environment

COBOL, JCL, TSO/ISPF, VSAM, Eclipse, Xpeditor, File-Aid, SQL, QMF, J2EE, WebSphere,Omegamenon,SPUFI, UNIX,Clearcase,Stored Procedures,Control M,DB2 Platinum services.

Confidential,has been building a complete replacement of the existing unemployment compensation tax system. The new system is designed with manyself-service options and will offer the newest technologies available to empower our staff, employers and their representatives. Employers will be able toeasily manage their tax accounts and quickly resolve many problems that may arise. The new unemployment compensation tax system will becalled the Employer Resource Information Center (ERIC).

Responsibilities:

• Analysis and execution of Change requests. Modifications and Enhancements to the system as per business and commercial requirements.
• Responsible for overall conversion of the data from Unisys Mainframe into IBM Mainframe.
• Developed many IBM programs to convert the ASCII data into EBCDIC format.
• Involved in Mock conversions which results in DB2 loads which will be used by developers.
• Worked as a DBA and handling the Database Administration tasks.
• Developed & Maintained around 70 SQL DB2 Stored prcoedures.
• Worked on Control M environment which schedules jobs on Mainframe Environment.
• Is the only Point of Contact for any DB2 ,Mainframe issues for the team.
• Is the only Point of Contact for all the Application Builds for the project.
• Involved in daily deployment of the application build in all environments.
• Provided production support and job monitoring for migration jobs and 24/7 on call support and worked on the incident tickets during Production support.
• Development of new online and batch programs and modification of existing programs. Data conversion and modifying and enhancing existing code in COBOL and DB2 as per the requirements.

3.

Client

Confidential,Maryland

Role

Duration

12/2006-06/2007,03/2010-07/2010

Environment

COBOL, JCL, TSO/ISPF, VSAM, Eclipse, Xpeditor, File-Aid, SQL, QMF, J2EE, WebSphere, UNIX.

Confidential,administers retirement, disability and death benefits on behalf of active and former State employees, teachers, State police, judges, law enforcement officers, correctional officers and legislators.

The State of Maryland is the primary sponsor of this multi-employer defined benefit system; local eligible governmental agencies voluntarily participate in the System as well. The State Retirement and Pension System provide important coverage both during a member\'s working career and after members retire.

Responsibilities:

• Analysis and execution of Change requests. Modifications and Enhancements to the system as per business and commercial requirements.
• Responsible for day-to-day maintenance of specific applications (break fix and the design, code, test and implementation of changes to applications).
• Coordinated with onsite-offshore teams and fallow up the development activities.
• Provided production support and job monitoring for migration jobs and 24/7 on call support and worked on the incident tickets during Production support.
• Development of new online and batch programs and modification of existing programs. Data conversion and modifying and enhancing existing code in COBOL and DB2 as per the requirements.
  
• Understanding the DP request/control log requests from Data Control Division to implement the necessary changes in to the system.
• Involved in analysis, coding, testing, unit and integration testing.
• Does the comparex between production and test results which will make sure programming changes does not impact any other part of the system.
• Used debugging tools expeditor to test and fix.
• Involved in production support, resolving production problems.
• Involved in DP request meetings with business users in preparing accurate requests/control log requests.

4.

Client

Confidential,

Role

Duration

(Aug/2004) – (Nov/2006)

Environment

COBOL, JCL, DB2,Panvalet,ChangeMan, TSO/ISPF, Endevor, Xpeditor, File-Aid, SQL, QMF, XML.

Confidential,is one of the leading insurance companies in USA. CLAS stands for Commercial Lines of Business.It accounts for 90% of Selective’s business.Knowledge Management is a tool used by Selective to help the Underwriters in Decision Making.
Responsibilities:

• Responsible for design and supported development for the web technologies to get the files from the legacy systems.
• Utilized test cases for checking the test load during unit testing, system testing and user acceptance testing. Preparation of relevant documents adhering to Quality procedures.
• Utilized XREF to map the output file with the copybook layout
• Performance tuning of SQLs and ABEND reduction to meet or beat pre-conversion metrics and Testing SQL queries using SPUFI, QMF and SQL programmer utilities
• Performed data modifications and impact analysis of all the components
• Involved in development of COBOL DB2 Stored procedures
• Developed many Conversion programs to generate XML files using Legacy data.
• Created the source code integrity documents, created documents like component resource list, application testing responsibilities, roll out plan and back out plan

5.

Client

Confidential,

Role

Duration

October 2002 – July 2004

Environment

VS-COBOL II, JCL, DB2, CICS, Librarian, XPEDITOR, File-Aid, CA-View, Platinum, QMF, SPUFI ,SQL ,PanValet.

Confidential, is a backend batch processing system which provides statistics to ISO(Insurance Standard Organization). Bureau system sub divides insurance data into commercial lines, personal lines, personal Auto, workers compensation and other files. It uses ISO Edit package and generates ISO required output packages.

Responsibilities:

• Analysis and development of program specifications, JCL specifications for batch processes
• Modified existing programs and writing new programs to support new added rules and functionalities of various processes like Client Merge, Retrieval of Overrides and Reassignment of overrides – Trigger Processing and developing code for various batch processes
• Developed test plans and tested various reusable components and individual modules using XPEDITOR.
• Provided excellent support to the web components development team in understanding the host side implementation and interface and providing support during system testing and user acceptance testing and deployment phases
• Involved in analysis, preparation of test cases, coding, testing, unit/integration testing.
• Conducts production parallels with which make sure of programming changes does not impact any other part of the system.
• Understanding the ISO changes guide and involvement in design of specifications with actuarial department users
• Used debugging tools to test and fix, involved in production support.
• Understanding the ISO user bulletin, this details ISO Edit Package changes.
• Work with scheduling department in implementing the ISO changes in operating system and individual LOB changes in edit package, JCL and reports.
  
  6.

Client

Confidential,

Role

Mainframe Analyst

Duration

May 2000– Sep 2002

Environment

VS-COBOL II, JCL, IMS DB/DC, DB2,VSAM,CICS, Librarian, XPEDITOR, File-Aid, CA-7, Platinum, QMF, SQL,SPUFI.

Confidential,is a backend batch processing system, which interfaces with all the underwriting systems viz., Property Insurance, Vehicle Insurance, Workers’ Compensation, Commercial-Lines, Automated Claims System and almost all other automated systems. This information is thoroughly validated by MSTAT system and generates output files, which used by subsequent systems for their processing.

Responsibilities:

• Active role for the extensive analysis of the programs
• Prepared the Data Flow Diagrams to understand the data flow
• Identified the files coming into the system and going out to other systems with development of the programs to implement new functionality
• Performed unit testing and system testing of the applications and Installation and promotion of the elements to Production
• Provided maintenance support, production on-call support, enhancement to existing applications and online screens that are developed in CICS and performed unit testing and system testing
• As a developer/project lead and point of contact, was responsible for
• Involved in analysis, preparation of test cases, coding, testing, unit and integration testing.
• Involved in production support, resolving production problems in no-time and making sure subsequent systems does not impacted.
• Analysis of the specifications provided by the client and passes the info to offshore.
• Assisting team in analysis, design, coding and testing.
• Testing - unit testing & integration testing.
• Assisting team in technical and domain knowledge.
• Meeting client’s expectations and never deviate form schedules.