Teradata DBA
Resume:
GOPINADH
[pic]
Phone: 518-***-****
Email: ****.*****@*****.***
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