Project Insurance

Ms. Krishna Verma

****, *'Sweeney Ln

Phone: +1-510-***-****

Dublin,OH - 43016

E-mail: ********@*****.***

Experience Summary

. Solutions-oriented analyst with 7+ Years of significant, progressive

experience in development, & customization of Large/Complex business

applications.

. Extensive experience in IBM Mainframe Environment and well versed with

all phases of Software Development Life Cycle (SDLC)

. Extensive experience in developing application software on the IBM

Mainframes using COBOL, DB2, SQL, EAZYTRIEVE, JCL, TSO/ISPF, SPUFI,

QMF, XPEDITER, File Aid, IBM Utilities, SYNCSORT in MVS environment.

. GOOD HANDS ON EXPREIENCE ON INFORMATICA,JAVA,VB,UNIX

. Good Domain knowledge in different sectors such as Banking,Insurance

and Medicare.

. Strong combination of Business & Technical skills

. WORKED CLOSELY WITH THE DESIGN TEAM TO RESOLVE BUSINESS DIFFICULTIES.

. VAST EXPERIENCE WORKING WITH LARGE CLIENTS SUCH AS AMERICAN EXPRESS,

NATIONWIDE INSURANCE AND HUMANA HEALTHCARE.

. WORKED WITH THE DISPUTES DEPARTMENT FOR AMEX.ALSO PLAYED AN IMPROTANT

PART IN GLOBALIZATION PROJECTS FOR AMEX.

. VAST EXPERIENCE WORKING WITH LARGE COMPANIES SUCH AS IBM AND SYNTEL.

. EXCELLENT EXPREEINCE WITH TOOLS SUCH AS EXPEDITOR, CHANGE MAN,

ENDEAVOUR, FILE-AID, IBM UTILITIES, SYNCSORT,IBM DEGBUGER & QMF.

. Worked with production team to provide 24 x 7 on call support for

maintenance & development projects.

. Effectively interact with design, development, configuration

management, production support and post production support team to

attain the perfect end product.

. Strong trouble-shooting & user interface capabilities with good

Analytical and communication skills as a good team player.

. Ability to meet deadlines and handle pressure and co-ordinate multiple

tasks in a work / project environment.

. Worked as lead for more than 6 people working at an offsite for

various project requirements and testing suport.

. Recognized in every project for good learning,team player and good

techinical knowledge

. Hands on expreience with different languages and platforms.

Education

. Bachelor of Technology (B. Tech) - Computers.

Skills

Mainframe COBOL II, JCL,DB2,EASYTRIEVE

Technologies

Operating System IBM OS/390,UNIX,Windows 95,98,200 and XP.

Tools File Aid, Panvalet, Chgman, Platinuim DB2

,BMC ADUMAIN,SPUFI,QMF,Xpeditor,IBM

debugger,Syncsort

Basic knowledge of Java, VB,Oracle, HTML,C, C +, UNIX

scripting

ETL tools Informatica Power Center

Databases DB2,Netezza,Oracle

Project Experience

NATIONWIDE INSURANCE

Enterprise Customer Information File

Role: Onsite Coordinator and Sr Mainframe Consultant

Feb 2009 -Till now

The Enterprise Customer Information File (ECIF) is being developed to

provide a consolidated enterprise-wide 360-degree view of customer

information across product lines and business units. The project involves

the migration of customer information from today's Property & Casualty

Customer Information File (CIF) and the Enterprise Customer Information

Broker (ECIB) into a common data store utilizing the Web Sphere Customer

Center (WCC) (aka DWL Customer and Master Database Management or the MDM)

product. Existing data feeds and user access points for CIF and ECIB will

be migrated to a future state Services Oriented Architecture (SOA)

interfacing with the new Enterprise Customer Information File (ECIF)

database.

Responsibilities:

. ANALYZE BUSINESS AND SYSTEM REQUIREMENTS, INCLUDING IMPACT ANALYSES ON

EXISTING SYSTEMS, TO DEVELOP SYSTEMS SPECIFICATIONS

. Work with Business analysts for preparing the training documentation

and communicating the changes and developments in the applications

and tools

. Built DB2 components to unload and load the database tables

. Reviewed code for several internal applications

. Mentored other team members in understanding and completing work

assignments

. Coordinating with offshore teams at Hyderbad for various requirements.

. Informatica mappings and session creations

. Supporting Informatica Flows

. ETL Transformations between Netezza and Mainframe databases

. Created Unix and Informatica ETL Codes

. Created functional specifications and many techinical designs for the

project.

. Prod Support 24X7 for the project and several other partner projects.

Environment: IBM OS-390/MVS, COBOL, JCL, DB2, SQL,UNIX,

Tools Used - ChangeMan, TSO, File-Aid,SPUFI,QMF,Informatica,Sync-sort

IBM Product - MDM

AMERICAN EXPRESS

Role: Technical lead/Sr Mainframe Consultant Jan

2008 - Jan 2009

American Express, headquartered in SLA. The Online Merchant Service (OMS)

is the second biggest business after the card. OMS manages the services

provided by Amex to its merchants. Most of its services dealt with

Payments and Disputes .This Project deals with. Launch of new services

during globalization of AMEX.

OMS International -GLOBAL DISPUTES

Global Disputes deals with the Launch of new Dispute product in 7 different

markets like Australia, New Zealand etc.It made a complex project because

of the various timezone and server time mismatch issues.

RESPONSIBILITIES:

. LEAD THE TEAM EFFICIENTLY AND MAINTAINED THE TIMELINES.

. Review Design process for mainframe as well as for databases

applications

. Coordinate with other teams/companies and synchronize the project dead

lines

. Design mainframe modules/SPs/load jobs and reports

. Technical,Design as well as Quality Documentation

. Coding for complex codes

. Help during Unit/integration testing/UAT

. Install preparation for the backend components

OMS International - Data Usage

October 2006 - Jan 2008

Role : Team member

Data usage was brought into picture to capture the links traversed by the

merchant while logged on .This was in order to make the mostly used

services more user friendly and enhanced..

Responsibilities:

. TOOK OWNERSHIP FOR THE PROCESS OF REQUIREMENT ANALYSIS, CODING,

TESTING, DELIVERY AND MAINTENANCE FOR MATT LOGGING.

. Coded Cobol, DB2 batch programs and Stored procedures for Matt

logging

. Enhanced and provided support for delivered programs.

. Involved in debugging and test plan preparation.

Environment: IBM OS-390/MVS, COBOL, JCL, DB2, SQL

Tools Used - ChangeMan, TSO, File-Aid,SPUFI,QMF,Sync-sort

HUMANA Healthcare System

August 2005- October 2006

Humana Inc. is one of the largest publicly traded health benefits companies

in USA, with approximately 7 million medical members located primarily in

18 states. Operated by CMS - Centers for Medicare & Medicaid Services

Medicare is a federal government Insurance program that provides health

insurance to

. People over age 65 (plus 40 quarters of work )

. People with disabilities.

. People having End-Stage Renal Disease (ESRD).

. People who buy in to Medicare Part A and pay a monthly premium

Medicare Regulatory 2007

Role : Module Lead /Team member

This module dealt with report generation for all those rules which are to

be followed by Humana under the consideration with Centers for Medicare &

Medicaid Services (CMS)

Responsibilities:

. CO-ORDINATION WITH END-USERS AND SUBJECT MATTER EXPERTS IN REQUIREMENT

ANALYSIS, PLANNING AND PREPARING FUNCTIONAL AND TECHNICAL

SPECIFICATIONS

. Being responsible for co-ordination with Onsite in task delivery in

terms of timely query resolutions, follow-up and being within the

allotted deadline

. Development/Coding

. Code Review

. Technical Documentation

Plan Designer feed to DPl

Role: Team Member

Various rules and constraints which were made by the PDB (Product Data

base) team were to be

incorporated into the business by the PD team...

Responsibilities:

. TAKEN OWNERSHIP FOR THE PROCESS OF REQUIREMENT ANALYSIS, CODING,

TESTING, DELIVERY AND MAINTENANCE FOR PLAN DESIGNER FEED TO DPL.

. Coded Cobol, DB2 and Easytrieve batch programs for Plan Designer.

. Coded Cobol batch programs

. Enhanced and provided support for delivered programs.

. Involved in debugging and test plan preparation

Environment: IBM OS-390/MVS, COBOL, JCL, DB2, SQL

Tools Used - Panvalet, TSO, File-Aid,SPUFI,QMF,Sync-sort

RAMARAO ADIK INSTUTE OF TECHNOLOGY June 2004

- May 2005

Ramarao Adik Instute of Technology, A well ranked & known college in Mumbai

was my graduate school.As a part of my final year Bachelor projects, I

worked for RAIT and developed a NETWORK Monitoring system.Installed on 25

computers,this Software was programmed to give Individual Network usage,

Programs Installed on Indidual machine, Chat sessions and overall Network

Usage.It also served as a medium to authenticate machine usage in the lab.

Network Monitoring system

Role: Team Member/Project lead

Responsibilities:

. WAS CONSIDERED ONE OF THE BEST PROJECTS FOR THE INSTITUTE FOR THE

YEAR 2004-05

. Lead and trained a team of three.

. Analysed the requirements and system Usage of the College machines

. Programmed VB scripts for server and client applications.

Environment: Windows XP

Languages used :- VB

SUNCITY NET CAFE

June 2003 - May 2004

Suncity is a small Mumbai based Netcafe .It is locally owned and

run.The main purpouse of this netcafe is to provide INTERNET services as

well as to educate small children about the internet and computer

usage.Suncity is also used by several education systems for training their

kindergarden kids.

Role: Developer

Responsibilities:

. DEVELOPED HTML WEBPAGES FOR THE LOGIN FOR THE CAF

. Developed gaming Java applets for small kids

. Developed HTML web pages for itneral usage for the Netcafe

. Montiered and updated puzzles for Kids under 5.

Environment: Windows XP

Languages used : Java,HTML,DHTML,XML

Achievements:

. Career:

. Awarded 'I GOT CAUGHT' award 5 times at Natiowide Insurance.

. Awarded Excellence award at IBM for technical excellence in the

project 2008.

. Awarded Excellence award at IBM for active participation in Extra

curricular activities in the project 2008.

. Oracle Certified Professional (0Z1-007) 2007.

. Brain Bench JCL certified programmer 2006.

. Appreciations for delivery of complex programs within the given

deadlines .

. Appreciation for taking ownership during benefit package

reconciliation deliveries

. Appreciation for commitment to work and giving support with personal

interest.

Academic:

. Overall College Topper for the 8th Sem.

. 40th Rank in B.E overall MUMBAI UNIVERSITY..

. 435th Rank all over state in HSC (Maharashtra board)

. Distinction throughout the academic years.

. Awarded Scholarship for outstanding performance in HSC exam by the

NPCIL

Extra Curricular/ Co-Curricular Activities:

Technical:

Member of CSI (Computer Society of India) -2001-2005.

1. Council Member of CSI-RAIT (student chapter) in the capacity of

Membership Head for the year 2003-2004.

2. Co-founder/Co-coordinator for the CSI-RAIT technical festival-

Techknow 2K3.

3. Functioned as the Coordinator for CSI-RAIT Techknow 2004.

4. Co-founder/Chief-Organizer, TECHMATE 2004, CSI-RAIT technical

festival.

. Became IBM certified database associate DB2 Universal Database

V8.1 family.

. Reached 'Qualifying position' in Manual Robotic Contests in inter-

collegiate competitions.

. Participation in various Technical festivals like IEEE-RAIT's---360

degrees.

. CSI-RAIT's---Techknow (Attending seminars and workshops).

. Volunteered for IEEE-RAIT's 360 degrees (2001-2002).

Cultural/Social:

. Participated and won prizes in Essay writing, Group Dance

competitions, sports at school level.

. Member and participant in all events of MINDSpri-RAIT. (A public

speaking and debating society, first of it's kind.)

. Participation in various events at HORIZON-cultural festival, RAIT.

. Won 2nd prizes for 'Group discussion' event.

. Hosting various building functions like Annual days, sports day etc.

. Secured 1st class in Cleared 1st level exam of classical music.

. Cleared General Knowledge papers conducted by UNESCO.

Contact this candidate