Insurance Data

IBRAMSHAH ABDULRASAD

E-mail: ************@*****.*** Columbus, OH Phone: 336-***-****

Highly skilled Guidewire Data Migration Analyst with 7 & Half years of experience

•

Qualification Summary Over 2 years of experience in Guidewire Data Object model.

• Over 2 years of experience in Guidewire Product Model.

• Over 2 years of experience in Legacy to Guidewire Mapping.

• Over 7 and half years of experience in Property, Auto and Worker’s Compensation Insurance

Domains.

• Over 7 and half years of experience in DB2 Data Base.

• Over 3 years of experience in Oracle Data Base.

• Over 2 years of experience in Informatica Power Center 9.1.

• Over 3 years of experience in Requirement Analysis and Project Estimation.

• Over 4 years of experience in leading offshore and onshore development teams.

• Leading team of professionals with technical and non-technical skills.

Strengths and

Accomplishments

Strong Knowledge in Guidewire Policy Center Data Object model.

Strong Knowledge in Guidewire Policy Center Product Model (Property / Auto and Umbrella

insurance).

Strong knowledge in Guidewire studio.

Strong Knowledge Informatica Power Center 9.1.

Strong knowledge in Oracle DB.

Strong Knowledge in Mainframe DB2 DB and IMS DB.

Strong knowledge in SQL queries.

Experience with performance tuning SQL and Data Bases.

Strong Knowledge in COBOL programing, VSAM Files.

Strong Business Knowledge in Property and Causality Insurance, Auto Insurance.

Strong Business Knowledge in worker’s Compensation Insurance.

Experience with XML and a scripting language such as VBScript.

Experience with Scrum and Agile development methodologies.

Primary Skills Guidewire Policy Center, Oracle, DB2, IMS, Informatica.

HP Quality Center.

Windows and Mainframe z/OS.

Other Skills

Data Migration – Personal Lines Transformation Project

Professional Experience

May 2012 – till now Goal of Personal Line Transformation is about bringing in business agility and it is aimed to modernize

TCS (Nation Wide Insurance and simplify Nationwide's processed, technology and product offerings. Nationwide is planning to

- PLT) develop a Policy Center application using Guidewire to support its Personal lines Business. As part of this

implementation there will be a need to integrate this newly developed Policy Center application to the

existing upstream and downstream application of Nationwide.

The data to be Migrated from existing Mainframe IMS Hieratical Database, DB2 Database and VSAM

files into Guidewire Policy Center Data Model for its future existence.

Carried out the following activities in the project:

• Analyze Mainframe IMS and DB2 Data Base Meta Data and its Data Model.

• Analyze Mainframe Programs and VSAM Files to identify the Data Which requires migration.

• Create Source Staging Database Model to load the Data from Various Database into Relational

Data Base Model.

• Load the Data from Various Databases, VSAM Files to Source Staging Database Using

Informatica Transformation and Load.

• Cleansing the legacy data to identify the data issues based on the business rules and fixes the

data while extracting into Source staging Database.

• Create Mapping Document to Map the Data from Legacy Data to Intermediate Staging Oracle

Data base that is the replica of Guidewire Policy Center Data model Database.

• Create Informatica Transformations for the Mapping created between Source Staging and

Intermediate Staging.

• Create Guidewire Policy Center XML payload and load the policies into Policy Center Database.

• Create Reconciliation report for all the stages right from Legacy, Source Staging, Intermediate

Staging and Policy Center.

• Rerate the Premium from policy center and compare with legacy premium.

Professional Experience

Database Management and Maintenance

Working closely with Business requirement that needs the data changes on the insurance IMS Database.

• Analyze the business requirement and business needs for the Data to be changed.

Jan 2012 – May 2012

• Understanding the business requirement and its scenario to execute the business needs.

TCS (Consultant for State

• Executing the Recode program on the Database.

Farm Insurance)

• Performance testing on the Recode Programs on the vast data that needs to be updated.

• Data verification thru various generated report and Post implementation support.

Application Development and Business Analyst

Aug 2011 – Dec 2011

TCS (Consultant for United

Collaborating with Architecting team and Business Analysts to understand the business needs. Working

Guaranty Corporation, USA) with Project managers, Architects, Business Analysts and Tech Leads in developing the test case to cover

up all the business needs that need to be tested for the Enterprise Content Management (ECM). Following

Agile methodology in the development phase, both development team and Testing team together working

on requirement analysis.

• Analyzing the use case Diagram and requirement document with business.

• Understanding the requirements from Business and get clarification on the requirement from the

business.

• Development on the given requirement.

• Defect fixing on the developed program, defect rose by the tasting team.

• Preparation of daily report during testing cycle

• Defects trend analysis for the testing cycle

• Estimating the QA RCI (Requirement Clarity Index) for a new requirement in the project.

Development on Mainframe DB2 Interface Programs

Oct 2010 – Aug 2011

TCS (Consultant for AIG

Understanding Both Mainframe DB2 and Frontend Java application and developing Integration Programs

Insurance, USA)

using DB2 SPs. Analyze on both Mainframe Data and Frontend Data to make integration with different

character set.

• Requirement analysis of business need.

• Understanding on DB2 Mainframe Data and Java Front End Data.

• Develop the coding for DB2 SP.

• Prepare Test scenario for DB2 SP change.

• Executing Integration program with DB2 Connect tool for testing purpose.

• Execute the DB2 SP programs with JAVA Front End applications.

• Participating in weekly and monthly meetings and preparing minutes of meeting.

Oct 2009 – Sep 2010 Mainframe Developer and Project Lead

TCS (Consultant for AIG

Insurance, USA) Leading development team for Detailed Claims Information Mainframe development project. Analysis

and develop both CICS screens and DB2 COBOL programs. Technical support for Team members.

• Requirement Analysis on business needs.

• Perform Impact Analysis for Existing Batch and CICS program changes.

• Design and Develop CICS Mainframe Screens.

• Prepare Unit Test scenario for the requirement.

• Identifying test conditions and cases based on Change requests by the customer.

• Preparing the Unit Testing Document and System Testing Document.

• Execute the program with Unit test case prepared.

• Participating in weekly and monthly meetings and preparing minutes of meeting.

Mar 2009 – Sep 2009

TCS (Consultant for AIG Mainframe Developer and Team Lead

Insurance, USA)

Design and Develop a Mainframe project for an existing system take over in to new system.

Understanding existing programing languages and converting into Mainframe programs. Writing JCL

with newly Schedule Jobs and.

• Requirement Analysis on the business requirements.

• Perform Impact Analysis for Existing Batch and DYL 280 program changes.

• Identifying test conditions and Test cases based on Change requests by the customer.

• Preparing the Unit Testing Document and System Testing Document.

• Execute the modified Jobs and programs.

• Executing the test case across different environment.

• Participating in weekly and monthly meetings.

Apr 2007 – Feb 2009

TCS (Consultant for AIG Application Development and Maintenance

Insurance, USA)

Understanding Entire system with business backgrounds to implement day to day maintenance activities.

Analyze tickets for change request and get approval for from business Analyst to implement the changes

on the programs and Jobs.

• Perform Impact Analysis for Maintenance change requests.

• Prepare Test scenario and test Case.

• Executing the test cases on the weekly productions.

• Monitor the mainframe batch jobs to ensure successful execution

• Participating in weekly and monthly meetings and preparing minutes of meeting.

Jan 2007– Mar 2007 Assistant System Engineer - Trainee

Tata Consultancy

Services, India • Software Development Process, Requirements Engineering, Software Engineering, Reviews,

Walkthroughs, Inspections, Project Work in Mainframe, Testing & Debugging, Software

Maintenance, DBMS, Object Oriented Methodology, Effective Presentation, Working in teams

effectively, Effective technical writing, Personal grooming, IBM Mainframe, DB2, COBOL,

JCL

Bachelor of Technology (Information Technology), 2002 - 2006

Education and Training

Institution: Anna University, Tamil Nadu, India

DB2 – 700 DB2 Family Fundamentals.

Principles of Property and Liability Insurance

Property Insurance and Auto Insurance

Worker’s Compensation Insurance

Data Scientist on Big Data

Contact this candidate