GOPINADH

[pic]

Phone: 518-***-****

Email: ab6rbe@r.postjobfree.com

TERADATA DBA (Proven Technical expertise in NCR Teradata)

Professional Summary:

. Expert in tuning complex Teradata SQL Queries including Joins, Correlated

Sub queries, and Scalar Sub queries.

. 10+ years of experience in Teradata Enterprise Data Warehouse (EDW) and

Data Mart.

. Teradata Certified Professional in V2R5.

. Experience working with clients of all sizes in the insurance, financial,

Retail, healthcare, manufacturing industries.

. Good understanding of DataWarehousing concepts such as Third Normal form

(3NF) as well as Dimensions Schema.

. Developed 13.10 features such as PPI, Character PPI, and Timestamp PPI,

and Columnar Tables.

. Expert DBA skills in Teradata DBMS Administration, development and

production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD,

TSET, TPUMP, SQL, PDCR and ARCMAIN, TASM for workload management.

. Experience in planning and coordinating Disaster recovery solution for

Teradata

. Working with BUSINESS OBJECTS/OBIEE team to optimize various report run

times by applying various TD performance techniques such as Partitioning,

JIs, AJIs, USI and NUSI.

. Existing FT Physical DM is created based on even distribution of tables

by defining 10 to 20 column Primary Indexes not taking usage into

consideration. Redesigned and Optimized the Finance Transform Physical DM

by defining the right PIs and PPIs using ELDM. Also implemented multi-

valued compressions and Soft RIs when necessary.

. Implemented various Teradata recommended best practices while defining

Profiles, Roles, Alerts, Multi-Value Compression, Data Mover, and Backup.

. Created and implemented BAR strategy for the TD application and system

databases.

. Created and scheduled various Teradata recommended Performance, Capacity,

trending and activity reports such as Space, Usage, Access, security

reports.

. Did the Teradata SQL troubleshooting and fine tuning of scripts given by

Analysts and developers.

. Created proper Teradata Primary Indexes (PI) taking into consideration of

both planned access of data and even distribution of data across all the

available AMPS. Considering both the business requirements and factors,

created appropriate Teradata NUSI for smooth (fast and easy) access of

data.

. Created PPI for some of the monthly and daily tables to have a good

performance on range queries with date constraints. Also created NUSI on

PI column for the PPI tables have a good performance on queries with PI

access.

. Implemented ETL level collection statistics for the Indexes and for some

of the columns going to be involved in the constraints or join

conditions.

. Defined account IDs, priority scheduler performance groups, and system

date and time substitution variables in user and profile definitions.

. Responsible for the design and implementation of the entire DW

Dimensional Model architecture using Join Indexes and Partitioned Primary

Indexes to achieve and exceed the desired performance.

. Generated a Capacity management reports on analyzing the

Spool/CPU/I/O/Usage resources and proactive monitoring to meet

performance and growth requirements on PDCR Database.

. Set up the Teradata Workload Manager with the proper partitions and

workloads based on Service Levels. Set up Teradata Query manager to

automate many of the DBA tasks such as collection of statistics,

monitoring spool space, candidate tables for purge, etc.

. Monitored the production and development systems on a daily basis to

catch trouble queries, monitor access violations, and provide capacity

planning.

. Modification of views on Databases, Performance Tuning and Workload

Management. Maintenance of Access Rights and Role Rights, Priority

Scheduling, Dynamic Workload Manager, Database Query Log, Database

Administrator, Partitioned Primary Index (PPI), Multi-Value Compression

Analysis, Usage Collections and Reporting of ResUsage, AmpUsage, Security

Administration Setup etc. and leading a team of developers for workaround

with different users for different, complicated and technical issues.

. Implemented different performance features for several Subject Areas by

choosing the right Primary Indexes, ETL level statistics collection,

Column Compressions. Also implemented Partitioning on the periodic

monthly and Daily tables to increase the performance of range queries.

Also implemented NUSI on PI for PPI tables to increase the performance on

NUPI access.

TECHNICAL EXPERIENCE:

Technology

Database Teradata 13.10, Teradata V2R5, V2R6,

13.00.01.19 and V2R12, DB2, Oracle 9i,

Vsam

Reporting Tool Business Objects XI, OBIEE,

MicroStrategy

ETL Informatica,TD ETL Mload, Fload, Xport,

Bteq, Tpump, Jcl, SQL, Cobol, SPL,

PL/SQL, JAVA, TSO, MVS, ISPF.

Modeling Tools Erwin and Visio Enterprise

Operating Systems Windows 2000, and XP Professional,

UNIX: Sun Solaris, HP-UX

Methodologies Business Process, Relational Data

Modeling, Logical Data Modeling, Object

Oriented Modeling, SQL Assistant,

Object Relational Modeling, and

Physical Database Design, Tset, TPT,

Visual Explain, Workload Manager,

Teradata Priority Scheduler, Teradata

Visual Explain, Teradata Manager &

Administrator, Net vault, TASM, TD Data

Mover, Viewpoint, PDCR.

PROFESSIONAL EXPERIENCE:

Teradata Corp, Minneapolis, MN.

Sept'12 to Till Date

Teradata DBA/Architect

Project Description:

Teradata Corp MN. Designed an integrated, optimized and extensible Web

based application named "SPF", which loads all OLTP transactions directly

into "TARGET-EDW" data warehouse which stores repository of current and

historical data, forming the Web based framework of the business

intelligence architecture. Teradata offers a broad family of platforms that

span the business and analytical data warehouse needs throughout It entire

organization. It also provides the parallel database technology including

the cost based optimizer and wide range of management tools for

administrating the data warehouses.

. Responsible for solving the issues from "TARGET-EDW" customer support

on 24x7 bases.

. Performed performance Tuning and Administration activities of

Teradata.

. Involved in the EDW complete re-design of the process flow, starting

with design considerations, technical specification and source to

target mapping.

Performance:

. Highly experienced in SQL performance tuning/SQL optimization and

debugging of ETL process.

. Involved in Teradata Query Tuning and tuned complex Queries, and

Views, and implemented Macro's for reduce Parsing time.

. Handled Teradata performance SQL Tuning, Query optimization (Explain

plans, Collect statistics, Primary and Secondary indexes).

. Involved in Teradata 13.10 DBA activities and implemented all new

features such as Character based PPI, and Timestamp PPI, and Temporal

tables, and columnar tables.

. Implemented diff types of join Index's, which helps optimizer to

generate better Explain plans, for complex join conditions.

. Developed Semantic views, and implemented diff types of Indexes such

as NOPI, UPI, NUPI, USI and NUSI, PPI, and JI's, and AJI's (Multilevel

Join Indexes with compressed).

. Designed and build a Temporary tables thru Batch Job, for Simplify a

Complex views.

. Performed application level DBA activities creating tables, indexes,

monitored and tuned Teradata BETQ scripts using Teradata Visual

Explain utility.

. Tuned & developed a semantic views for - Micro strategy report

generated SQL's.

. Experienced in Data modeling phase in Data warehousing design-

creation of tables and choosing indexes in Teradata.

. Developed Unix/MVS Teradata Scripts to load source systems data into

Target DW.

. Performed Space Management for Perm & Spool Space.

. Generated CPU and DISK IO usage capacity reports thru PDCRDATA queries

on weekly.

Backup system:

. Set upped diff types of Backup jobs such as Daily/Weekly/Monthly, and

Full/Online backup and PPI&Triggered based backup jobs in Net vault

GUI Tool.

. Having good experience with Backup and Recovery using Teradata ARCMAIN

in Net Vault.

. Having solid experience with NPARC, which handles the data movement

between two diff systems using a named pipe instead Tape for faster.

. Configured Teradata TARA server for handling the Multistreams backup

jobs.

User Management:

. Handled USER management requests such as creating new Users& Profiles,

and Roles.

. Interacted with End users, and Data Modeler and Data Analyst to

develop the Physical Design for the new tables.

. Teradata 13.10 Viewpoint is used to monitor the system performance

when it is in load.

. Debugging&Tuned the Complex end user written queries for better

performance.

. Handled Space Management.

Environment: Teradata 13.10, SQL, Index, Viewpoint, PDCR DATA/INFO, ARC NET

VAULT (Arcmain, Restore, TaraGui, Datamover), Microstrategy, Semantic

Views, (Teradata ELT Utilities - Multiload, FastLoad, SQL Assistant, PMON,

TSET, TASM, BTEQ, Tpump), TPT, WorkLoad Manager, Data Mover, Join Indexes,

Microsoft Products, ISPF, TSO, Java, Erwin.

Wells Fargo Bank N.A, Charlotte, NC.

Mar'11 to Sept'12

Teradata Database Administrator

Project Description:

Wells Fargo Bank N.A. is a leading diversified financial consultant, and

its EIW-Teradata Data warehouse, data is sourced from different sectors

including banking, insurance, wealth management and estate planning,

investments, mortgage and consumer finance.

. Involved in the complete re-design of the process flow, starting with

design considerations, technical specification and source to target

mapping.

. Responsible for solving the issues from EIW customer support on 24x7

On-call issues.

. Involved in Teradata 13.00.01 DBA activities in the tests, such as

creation of users, spool, temporary, permanent space. Checking the

tables skewing, compression.

. Performance Tuning, Query optimization (Explain plans, Collect

statistics, Primary and Secondary indexes).

. Performed application level DBA activities creating tables, indexes,

monitored and tuned Teradata BETQ scripts using Teradata Visual

Explain utility.

. Performed Space Management for Perm & Spool Space.

. Created users with different profiles and Roles through Stored

Procedures, to control the access on the system.

. Supported Business Object report generated SQL's.

. Handled Netvault Backup and Recovery tasks, and Tape Management, and

Drive issues.

. Used Teradata Manager& Administrator to Monitor and Manage Teradata

Databases.

. Involved in various Operational Teradata DBA activities on daily

basis.

. Teradata 13 Viewpoint is used to monitor the system performance when

it is in load.

. Worked on loading of data from several flat files sources to Staging

using Teradata TPUMP, MLOAD, FLOAD and BTEQ in Mortgage applications.

. Interacted with Clients, Data Modeler and Data Analyst to develop the

Logical & Physical Design for the new tables.

. Worked on TSET tool, to get the Explain Log, and send it to Teradata

team to analyze it.

. Implemented the Work Orders in Production Systems.

. Experienced with Backup and Recovery using Teradata ARCMAIN in Net

Vault.

. Build tables, views, UPI, NUPI, USI and NUSI, PPI.

. Handled Workload monitoring using TASM.

Environment: Teradata 13.1, UNIX, Viewpoint, Teradata Administrator&

Manager, PDCR DATA/INFO, DBQL, NET VAULT(Arcmain Backup&Restore, TaraGui,

Datamover), (Teradata ELT Utilities - Multiload, FastLoad, PDCRDATA, SQL

Assistant, PMON, TSET, TASM, Visual Explain, FastExport, BTEQ, Tpump), ETL

JCL, MVS, ISPF, TSO, Abi nitio, ArcMain, TD SQL, Microsoft Products, Linux,

DB2, Erwin.

New York State Govt - Medicaid, NY

Teradata Data Base Administrator

Aug'09 to Mar'11

Project Description:

New York State's Medicaid program is administered by the Department of

Health.

EMedNY medical services are provided to low-income individuals who meet the

program's eligibility

Requirements. Medicaid is the single most costly program administered by

the State, as the State spends more than $42 billion annually for the

medical services provided to approximately four million Medicaid

recipients.

A new hierarchy tool was developed to support the Phase 2. A new Logical

Data Model has been created in DW TERADATA and BI in order to accommodate

the new hierarchy structure.

. Involved in DBA activities in the tests, such as creation of users,

spool, temporary, permanent space.

. Checking the tables skewing, table compression, and Index

recommendations.

. Used Teradata Manager& Administrator to Monitor and Manage Teradata

Databases.

. Performed application level DBA activities creating tables, indexes,

monitored and tuned Teradata BETQ scripts using Teradata Visual

Explain utility.

. Suggested some tuning of DBS control parms such as MaxLoadTasks,

DBSCacheThr, MaxParseTreeSegs, ReadAheadCount, FreespacePercent,

Cylinderssavedforperm, DefragLowCylProd, MiniCylPackLowCylProd etc.

. Designing Archival Jobs, considering archival resources like the

number of Media Servers, tapes, various limiting factors of

Transmit/receive of data to the media in Netvault.

. Capacity planning and proactive monitoring to meet performance and

growth requirements on PDCR Database.

. Debugged MicroStrategy queries, and enhanced the tuning tips.

. Monitoring Production system whenever in need and controlling Online

and Batch jobs.

. Converted DB2 Logical data models into Teradata Logical and Physical

database models.

. Interacted with Clients, Data Modeler and Data Analyst to develop the

Logical& Physical Design for tables.

. Performed bulk data load from multiple data source SQL SERVER, LEGACY

SYSTEM to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.

. Extensively used Teradata system Priority Schedule in controlling the

load of the system.

. Worked on exporting data to flat files using Teradata FEXPORT.

Environment: Teradata 13/V2R6, Teradata Manager, Teradata Administrator,

TSET, TPT, TDWM,,NETVAULT(TARAGUI, Archive*Restore), (ETL tools)

Multiload, FastLoad, PMON, FastExport, BTEQ, JCL, Viewpoint, TASM, Tset, TD

Data Mover, PDCRDATA, DB2, Tpump, MicroStrategy, Priority Scheduler, Ldap,

DBQL, PMCP, Visual Explain, Zeke Schedule, Unix-AIX, Jcl, Mvs, TSO,ISPF, Td

sql, ERWIN.

Wal-Mart, Ar

Teradata DBA

Nov'08

to July'09

Project Description:

Wal-Mart is World's number one retail Company caring to the needs of people

around the Globe with Discounted goods and Groceries. Wal-Mart is known for

its cheaper goods reaching people with a caption of Save Money Live

Better.The SWAS Reports on Retail link used by Merchandising are based on

hierarchy maintained by Category Maintenance, Demand Planning Applications.

A new hierarchy tool was developed to support the Planning for

Profitability solutions. A new Logical Data Model has been created in

TERADATA and SQL Server in order to accommodate the new hierarchy

structure.

Responsibilities:

. Involved in the complete re-design of the process flow, starting with

design considerations, technical specification and source to target

mapping.

. Worked on loading of data from several flat files sources to Staging

using Teradata TPUMP, MLOAD, FLOAD and BTEQ.

. Interacted with Clients, Data Modeler and Data Analyst to develop the

Logical and Physical Design for a table.

. Created users with different profiles and Roles to control the access

on the system.

. Written several Teradata BTEQ scripts to implement the business logic.

. Moved database schema changes to stage/production database.

. Extensively worked on the Performance Tuning of mappings, ETL

Procedures and process

. Extensively used FEXP utility to export and load data to/from Flat

files

. Worked exclusively with the Teradata SQL Assistant to interface with

the Teradata.

. Experienced with Backup and Recovery using Teradata ARCMAIN.

. Teradata PMON is used to monitor the system performance when it is in

load.

. Experienced in Teradata Manager which is used to create Alerts,

Monitor system.

. Worked on loading data from EDW and Supporting Subject areas using Ab

Initio.

. Familiar with Teradata Database Query Manager used mainly for query

logging and access logging.

. Developed BUSINESS OBJECTS (UNIVERSE) Desktop Intelligence&Crystal

Reports to DOH users.

. Experienced in using DBS Control Flags.

. Involved in documentation of requirements and technical design.

Environment: Teradata V2R5, Teradata Manager, (ETL Mf Jcl), Multiload,

FastLoad, PMON, TSO, ISPF, SAP Business Object Universe, TD Data Mover,

Tset, FastExport, MicroStrategy, ViewPoint, Tset, TASM, Sql, BTEQ, Tpump,

Mpras, W2k, Linux.

Medco, Franklin Lakes, NJ

Teradata Administrator

Jun'08 to

Oct'08

Project Description:

Medco Health Solutions, Inc. (NYSE:MHS) is nation's leading pharmacy

benefit manager. Medco and FDA will jointly develop research projects,

programs and strategies in the area of pharmacogenomics, collectively aimed

at improving patient health and quality in the delivery of care.

In Order to pass an opening balance as of 01/01/2008 to load into the

facets system, Medco finance needs to execute a True Up of the 2006 &2007

balances for both Active and Inactive Members and calculate the Tax on late

payments. Medco Finance will be executing a Refund or Write -Off for the

Inactive Members and passing only the Refund to our Current Premium billing

Operations vendor (CGI).

Responsibilities:

. Used Teradata manager to query Teradata RDBMS status and CPU

utilization in reports and graphs.

. Maintain and Tune Teradata Production and Development systems

. Worked extensively with Teradata utilities BTEQ, Multiload, Fastload,

TPUMP, Fastexport.

. Performance Optimization

. Measuring and monitoring the performance of the 16 node Teradata

system with new Teradata file system having WAL feature embedded.

. Designing and implementing the Physical Data Model. Received the

Physical Data Model DDL from Erwin.

. Measuring performance of the systems with different configurations.

Configuration of the systems like changing number of AMP per node,

Changing number of Clusters, Changing number of Clique, Changing

number of nodes in a clique.

. Capacity planning and proactive monitoring to meet performance and

growth requirements

. Performance Tuning and Administration activities of Teradata

. Experienced in working with Teradata ETL tools like Fast Load, Multi

Load, Tpump and Fast Export.

. Teradata PMON is used to monitor the system performance when it is in

load.

. Disk array failures were recovered using AWS and SIMPLICITY .

. Recovering the database/tables whenever we have disk drive failures.

And used most of the recovery scenarios to recovery the data of the

Teradata System.

. Experienced with Backup and Recovery using Teradata ARCMAIN.

. Upgrading the Teradata Versions.

. Worked on patch upgrades of the Teradata systems.

. Extensively used Teradata system Priority Schedule in controlling the

load of the system.

. Created users with different profiles and Rules to control the access

on the system.

. Experienced in Teradata Manager which is used to create Alerts,

Monitor system.

. Familiar with Teradata Database Query Manager.

. Experienced in using DBS Control Flags.

. Developed Universe (Metadata) WEBI Reports in SAP Business Objects.

. Maintained Teradata system with all UNIX, LINUX and WINDOWS platforms.

. Well familiar with System Administration activities and certified in

Linux operating system.

Environment: Teradata Manager, Teradata V2R602/V2R611/V2R620, SQL

Assistant, (ETL Abinitio tool), Multiload, FastLoad, Tset, PMON, Visual

Explain, BUSINESS OBJECTS INFOVIEW, FastExport, BTEQ, Tpump, Td sql, Mpras,

W2k, Linux, Erwin.

Sprint, Overland Park City, KA

Systems Analyst/DBA

Dec '06 to

Apr '08

Project Description:

Sprint is the one of the largest telecom sector business in the USA. Sprint

Providing Services to millions of Customers in USA. Sprint is the one

largest network coverage in 42 States in USA.

One Sprint Finance Information System (FIS) will be single Data mart for

whole Sprint to access customer and revenue information. Right now sprint

data marts are spread across their three business divisions that are Local

division, Tax on usage of Service call, Long Distance division and Wireless

division, Once FIS is completely operational all the existing data marts

will be shut down. Before their shutdown all the existing functionalities

of these data marts needs to be incorporated into FIS.

Responsibilities:

. Interacting with Business for the requirements

. Upgrade the Logical Model as per the Business requirements.

. Develop and enhance the Physical Data model using Erwin. The Design

shall be served as per the requirements.

. Performance tuning of the existing engines data.

. Involved in the tests, such as creation of users, spool, temporary,

permanent space, checking the tables skewing, table compression,

Troubleshooting the failure jobs

. Worked on loading of data from several flat files sources to Staging

using Teradata MLOAD, FLOAD and BTEQ.

. Worked on exporting data to flat files using Teradata FEXPORT

. Query optimization (Explain plans, Collect statistics, Primary and

Secondary indexes)

. Build tables, views, Procedures, UPI, NUPI, USI and NUSI

. Used ETL for complex transformations

. Attending the calls with Business and other technical groups to

resolve the production issues

. Writing QA and Production Migration scripts.

. Design reviews with Informatica team.

. Responsible for overseeing the Quality procedures related to the

project.

Environment: Td (ETL Fload,Mload,Fxport,Bteq), Teradata V2R5, Teradata

Manager, ORACLE, ETL Informatica tool, PMON, Tset, Visual Explain, Tpump,

sql, Mpras, W2k, Cognos, Linux, Netvault, MS SQLServer 2000, SQL Assistant.

Travelers' Insurance, MI.

Jr.Teradata DBA/Developer

July '05 to Nov

'06

Project Description:

Travelers are one of the largest providers of property and casualty

insurance products in the United States. Travelers offer a wide variety of

insurance and surety products, as well as risk management services, to

numerous types of businesses, organizations and individuals. Our products

are distributed primarily through U.S. independent insurance agents and

brokers.

Personal insurance offers a wide variety of products including automobile,

homeowners, renters and condominium policies. Business insurance offers a

broad array of coverage to businesses of all sizes, including workers'

compensation, property, and general liability, product liability,

commercial auto, and business owners' package policies.

Responsibilities:

. Modifications and adding new insurance policies as per Clients

Requirements.

. Converting the Finance Segments (WFIN25SD, WFIN26SD) data from DB2

Database to TERADATA region.

. Experienced in Designing Database with prominent activities like

deciding Primary / Secondary index, creating Join index, creating

Partitioned Primary Index, Compare Load Utilities to determine the

best Scenario, using Automatic Data protection using Recovery Journals

and Fallback protection.

. Disk array failures were recovered using AWS and SIMPLEX software.

. Recovering the database/tables when ever we have disk drive failures

and used most of the recovery scenarios to recovery the data of the

Teradata System.

. Experienced with Backup and Recovery using Teradata ARCMAIN.

. Used Normalization and Denormalization considering merits and demerits

of SQL query execution.

. Worked on patch upgrades of the Teradata systems.

. Extensively used most popular tool of Teradata system, Priority

Scheduler, in controlling the load of the system, where we define

performance Group, Allocation groups, performance periods, Resource

Partition.

. Creating users with different profiles and Rules to control the access

on the system.

. Experienced in Teradata Manager which is used to create Alerts,

Monitor system, and see historical Reports.

. Familiar with Teradata Database Query Manager.

. Experienced in using DBS Control Flags.

. Extensively used EXPLAIN in analyzing the SQL query execution flow.

Using this analysis tuned SQL queries to use Teradata resources

efficiently.

Environment: Teradata V2R5, Multiload, FastLoad, Mf Jcl, Tset, Teradata

Manager, FastExport, BTEQ, Tpump, sql, Netvault, Cognos, Mpras, W2k, Linux,

SQL Assistant.

Visteon Corporation, MI

Teradata Developer/ETL

Aug'03 to Jun'05

Project Description:

Visteon is the automotive parts manufacturing concern of FORD motor

company, which supplies parts to many of major Automobile companies

including FORD. Visteon was a part of FORD Motor Company, and now it is a

standalone company. It is the one of the largest automotive systems

suppliers in the world - Sells to 19 largest vehicle manufacturers in the

world, having 205 total facilities in 25 countries and six continents.

Visteon contains various domains like MP&L (Manufacturing planning&

Logistics), PD, PURCHASE and FINANCE etc.

Responsibilities:

. Involved in the complete re-design of the process flow, starting with

design considerations, technical specification and source to target

mapping.

. Worked on loading of data from several flat files sources to Staging

using Teradata TPUMP, MLOAD, FLOAD and BTEQ.

. Interacted with Clients, Data Modeler and Data Analyst to develop the

Logical and Physical Design for a table.

. Generated the OLAP Reports in Cognos to the End Users.

. Created users with different profiles and Roles to control the access

on the system.

. Written several Teradata BTEQ scripts to implement the business logic.

. Generated the Teradata Fload, Mload Scripts in Unix Operating Systems

region.

. Moved database schema changes to stage/production database.

. Extensively worked on the Performance Tuning of mappings, ETL

Procedures and process

. Performed bulk data load from multiple data source (Unix, legacy

systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.

. Experienced in working with Teradata ETL tools like Fast Load, Multi

Load, Tpump and Fast Export.

. Used MVC (Multi Value compression) tool for sizing of the database.

Environment: Teradata/V2R5, Explain, NetVault, Db2, Query man, Unix, Td

Sql, Rdbms, Index, View, Elips, CA7,Oltp, Dss, Mf Jcl, Autosys, Erwin, File

Manager.

Swisscom, Switzerland

Mainframe Developer

Sep'01 to Feb'03

Project Description:

The Aim of this Project is mainly concentrated on Database design strategy.

As part of the Migration Phase 1, Six IMS databases are planned to be

migrated to DB2. Four databases namely Anlagen, GV, Telephone and GVA are

migrated 1:1. Other two databases Customer and Address are migrated to a

Relational Data Model. Database design for Anlagen, GV, Telephone and GVA

databases are done on the basis that one IMS database segment will

correspond to a DB2 table.

Primary keys to the tables are identified based on the segment key

definition in the DBDs. Dependent segments are mapped with foreign key

relationship to the immediate parent segment DB2 table mappings. Foreign

keys are defined as 'ON DELETE CASCADE' to facilitate deletion of dependent

table row when the corresponding parent table row is deleted. Unique

Indexes to be created for the Primary Key for all the tables. DBDs are

scanned for fields other than the Primary Key used for retrieval. Indexes

to be created for some of these fields based on their usage in SSAs

Responsibilities:

. Responsible for Pre-analysis & Analysis of all the components in

System

. Identified the Impacts in the program and prepared the Impact

Analysis.

. Responsible for COBOL Coding programs & review of the converted

programs.

. Responsible for changing all the COBOL, JCL, SQL, DB2, IMSDB and CICS

programs, reviewing and testing.

. Review and exhaustive testing of the programs

. Documentation, Preparing test data, Test cases (UTC) and Test results

(UTR)

. Providing permanent fixes to the Production related problems.

. Resolution of User related issues of different severity

Environment:

DB2, COBOL, JCL, IMS DB, CICS, SQL, ISPF, SPUFI, QMF, CA7, ENDEVOUR,

FILEAID,

EDUCATION:

> Bachelor of Engineering in Computer Science.

Certifications:

. Teradata Certified Master

. Teradata Certified Professional

. Teradata Certified SQL Specialist

. Teradata Certified Implementation Specialist

. Teradata Certified Administrator

Contact this candidate