PROFESSIONAL SUMMARY

More than 7 years of IT experience as a Software programmer and Analyst with the ability to work independently and manage business expectations with a delivery-focused approach to work; ability to build and maintain strong working relationships with senior and junior business sponsors, as well as business specialists.

• Experience in System analysis, design, development - Software Development Life Cycle (SDLC), all phases of software development, Production Support, Maintenance, Enhancements.
• Extensive working experience of IBM Mainframes using Vs COBOL, JCL, DB2, VSAM, CICS, EASYTREIVE, SQL, XPEDITOR, FILE AID, ABEND AID, FILE MANAGER, MF COBOL, ENDEVOR.
• Also, working knowledge of TERADATA, HP-UNIX, and ORACLE and tools like Autosys, CA7, Change man, OPC, RMDS.
• Strong analytical, problem-solving and communication skills, with particular emphasis on clear, detailed Business Requirements and Functional Specifications, as well as reports for management. Have very strong domain knowledge - Banking, Insurance, Retail and Health Care systems.
• Ability to understand, analyze business processes and workflows and with the objective of providing recommendations for the best use of technology for improvement.
• Expertise in Problem Identification and Solution, Analysis, Design and Implementation.
• Analyze job and batch applications performance. DB2/SQL Performance tuning. Log applications schedule times. Maintain all necessary documentation to support report distribution process.
• Manage issues using incident management tools, Heat, Remedy, HPSD and Peregrine/Service Center tickets within the stipulated SLA & OLA.
• Created reports for user reports for programmers, distribution report lists, and
  distributed output.
• Experienced in requirements gathering, including review and analyze and documentation to determine project scope, functional specifications and deliverables.
• Proficient in writing status reports and detailing the tasks for complex projects and working with senior management to ensure client satisfaction with resultant work product.
• Experience in working with end users for developing use cases.
• Unit Testing, UAT, SIT scripts preparation and test plans and also use defect tracking tools like HP Quality Center, Test Director etc...

EDUCATION/ CERTIFICATIONS

Bachelor of Engineering

TOOLS PROFICIENCY

Platforms : IBM s/390, UNIX
Programming Languages : COBOL, JCL, CICS, Easytrieve, REXX/CLIST, SQL,
UNIX- Scripting
Tools : MVS, TSO, ISPF, Endevor, Xpeditor, File-Aid, SORT, Abend-Aid, SDSF, File Manager, BMSPLUS, E -changeman, SPF editor, SQLPLUS, HPSD (Alert/Service management system), MQ series, TCP/IP, MainView, Query Monitor/Manager, DFSort, SyncSort, Query Management Facility (QMF), DB2 Admin tools, ETI
Database : ORACLE (Client/Server), VSAM, DB2, MS Access
Operating System : Windows, MVS (z/OS 390), HP 9000-UNIX

DATA WAREHOUSE -
Platform : IBM S/390
Data Base : TERADATA
Utilities : BTEQ, MULTI LOAD, FAST LOAD
Knowledge of BO.

PROFESSIONAL EXPERIENCE -

Confidential, May 2009 - Present

Senior System Analyst/Lead Developer

Insurance policies of Fortis bank have to migrate to ABN AMRO Bank as a result of merger/take over. This is done in two parts - One time migration and Monthly migration. This involves writing new programs on Mainframes platform; create new tables in DB2 environment.

Responsibilities:

As senior systems analyst/Lead developer, I am involved in all phases of SDLC - requirement gathering, analysis, designing the application, coding and testing phases of the project. Application is developed on IBM Mainframes platform.

• Requirement gathering from the client and analysis.
• Effort Estimation of the requirements in number of hours based on the number of LOC.
• Design phase - Prepare High Level Design (HLD) and Low Level Design (LLD) documents, this involves finding out the optimized way of coding and using utilities.
• Create DDLs to create the required tables in DB2.
• DB2 query performance tuning, embedded COBOL-DB2 programs.
• Coding as per the standards.
• Test case scripts and document preparation - UAT, SIT and execution of them.
• Participate in project meeting, suggest for improvements in coding/QC techniques
• Apart from the technical activities, have to mentor other junior team members.
• Take KT sessions on project specific topics - overall design of the project - HLD.
• Follow up activities - about their task progress and report it to project manager.
• Conduct technical seminars of the standards followed in the project and industry in general.

Confidential, Nov 2007 - May 2009

Senior System Analyst/Lead Developer

21st C Insurance, formerly AIG direct is a major auto insurance company. As an important entity in the Actuarial and accounting division, my work required me to Develop, Maintain and Support the applications on various platforms involving different business segments.

Responsibilities:

As a senior system analyst, I am working on the Personal Lines Division Backend application and am solely responsible for Checkbook application. PLD backend application is based on IBM mainframes technology. Daily, Weekly and Monthly data from all the various segments of AIG direct/21st C is processed, balanced and reports are generated for business. Checkbook application works on HP UNIX and IBM mainframes (including CICS). Check cashing database inputs are received from various sources (both premium refunds and claims) each day. These files are fed to Checkbook system by the HP UNIX box to IBM mainframes. This is a highly critical and significant system, as this is the only source for all AIG/21st C auto insurance policies - includes both refunds and claims.
Also assist the Finance Business Team including the Director of Treasury and Finance VP to evaluate information gathered from multiple system sources byreconciling and presenting in the format that can be easily understood by business.

• Automation of the application, enhancement of the system which involves design and development of new jobs, change in architecture and flow of jobs.
• Enhancement and maintenance of daily and weekly and monthly jobs.
• Migration of IBM mainframes data center from East coast to West coast - system analysis.
• Created SQL scripts for monthly recurring jobs and reports to refresh the Data Server.
• Support production runs and resolve any abends/job failures.
• Worked with business users, developers, and infrastructure team to define, create Application design.
• Provided daily administration of developments operations, such as problem resolution, performance management, maintenance upgrades, and production migrations.
• Production support, both on UNIX & IBM mainframes systems for this critical application, which involves resolving abends/job failures ASAP.
• Integration of various systems like SAP GL to feed and use the application.
• Lot of Enhancement and maintenance projects within the system to make system more easily accessible for the business users.
• As part of maintenance, involved in working on change requests. (This involves analysis of the business specifications, preparing HLD/LLD, coding, unit testing and deploy the code in production.

Confidential, JULY 2006 - NOV 2007

Senior System Analyst

Confidential, plc is a United Kingdom-based international hypermarket chain. It is the largest British retailer, both by global sales and by domestic market share, and the fourth largest retailer in the world.
Responsibilities:

As a System Analyst for the Confidential, hsc, I worked with the Management Information Systems (MIS) team. This application involved maintaining data in a ready to deliver form using Data warehousing concepts, generate Business Objects reports for the business users to take effective decisions.

• Production support for MIS system.
• Fixing the jobs as they fail.
• Resolving data issues raised by the report users and confirming with them for final/permanent resolution.
• Giving permanent fixes for recurring failures.
• Preparing test data for System Integration Testing.
• Resolving all the problem tickets with in SLA, this involves contacting users, business analysts and SMEs. Sometimes contacting external trading parties, to correct the data.
• Effective communication and accurate reporting managed technical expectations and streamlines development/implementation lifecycles.
• Handling take over of projects for support.

Confidential, Dec 2004 - July 2006

System Analyst/Technical Lead

Confidential, is a leading health care system in United States. It is an operating division of UnitedHealth Group, the largest single health carrier in the United States. As a software engineer, I was with Online Reporting System application, which is the software application used by all the customer care representatives.

Responsibilities:

As Systems Analyst, I was handling the Host - Online Reporting application. This is an online application (on CICS-DB2 platform) which is used by all the customer care representatives for obtaining the claims information about the customers calling in. There were lots of enhancement activities with the application. This is apart from 24*7 production support, involving fixing online (CICS) abends.

• Initial Requirements analysis.
• Preparation of HDD & LDD, System specifications, Technical Specifications, UTD & STD.
• Coded Programs for the Enhancement projects using COBOL and DB2.
• Production support (involves both online and batch support) for one of the critical application, which involves resolving abends without missing SLAs.
• Giving permanent fixes for online as well as batch programs.
• Analysis of the critical and complicated programs.
• Debugging of errors within the system.
• Involved in Endevor conversion project.
• Interacting with clients for daily technical/status meetings'.
• As a module lead, handling a team of 4 people, giving KT to new joiners.
• Presented periodic Metrics, Monthly reports and updated trackers to the senior management to show the progress, constraints and dependencies in the project.
• Training sessions on DB2, JCL

Confidential, Nov 2002 - Dec 2004

System Analyst

Confidential, Technologies is a leading software services company. It provides services to clients which include major healthcare, bio pharma companies.

Responsibilities:

As an analyst, my responsibilities were:

• Analysis of technical specification document and identifying the elements to be modified.
• Updates to Application documentation
• Debugging of errors within the system. Unit and System Testing.
• Documentation of all the project enhancements.
• Involved in Field Expansion project.
• Impact analysis.
• The scope of work covered includes bug fixing, enhancements.