Data Software Engineer

Parthiban Venkatesan Email : ***********@*****.***

Phone : 469-***-****

Professional Summary

** ***** ** ** ********** in Teradata Development, ETL, Requirements Gathering Data warehousing for clients in Banking, Health care and Retail domains.

7+ years of experience in Banking domain and expertise in Retail banking concepts

4 years of Expertise in Teradata FSLDM Concepts

Current role as Technical Lead responsible to gather requirements, Design, Develop and review the code Teradata with Informatica 9.5.1 as ETL on UNIX, create shell scripts, DIH coding operating system for Retail client.

Worked in Data and System migration projects Performing ETL operations with UNIX, Informatica and Mainframes in Teradata, Oracle 11g

Expertise in SDLC model project deliveries in traditional and Agile methodologies

Expert in creating Source to Target Mapping and Value added processes (VAP) in ETL Design

Expertise on Teradata Architecture (Indexes, Space, Locks, Data distribution and retrieval, Data protection)

Good knowledge on prescribing Indexes and usage of tables to be created in Staging, Target areas like Temporary, SET, Multi-Set, Volatile, global temporary tables

Worked on Teradata utilities - Fast load, Multi load (Mload), BTEQ, Fast Export.

Successful in projects that require Teradata SQL Performance tuning for optimal performance, Collect statistics, Join strategies, Join types and Explain/Optimizer plans That has OLAP functions,derived tables and complex joins.

Knowledge on various Indexes like Join Index, Multi Table JI, Single table JI

Good knowledge on Teradata Standards, best Practices and Ansi-SQL

Expertise in unit test cases, scenarios and validating unit test results

Write Unix Shell scripts, used functions like SED,AWK for file handling

Creating mapping,sessions and workflows in Informatica Power Center ETL, usage of different transformations and handled files (csv, xml), Database as source and target

Gather requirements, write design documents, engage in data analysis along with Business Analysts, Enterprise Architects

Worked on Type,I II and III data model and perform data cleansing before commencing the ETL process for the data from various source systems

Responsible to support QA,UAT, Functional and Non functional testing.

Possess strong analytical and problem solving skills and Fast learner to gain functional knowledge on the requirements.

Prepared presentations on Teradata architecture, DML, DDL, Basic and OLAP functions for training new resources.

Involve in review of design documents, on Teradata best practices and standards

Part of the Teradata interview panel in current company

Technical Skills:

Database and systems : Teradata and IBM Mainframe

Teradata Utilities : Mload, FastLoad, BTEQ, Fast Export and Tpump

Teradata PerformanceTuning : Indexing,Table creations, Collect stats, Dbc tables, Space handling, Temporal tables

ETL : Informatica Power Center 9.5.1, Data Integration Hub

Oracle Utilities : SQLPLUS, SQLLDR

Scripting : Unix Shell Scripting

Operating Systems : Windows,UNIX, IBM Mainframe

Scheduling Tool : CA7,ENDEVOR

Test case tracking tools : HP Quality Center

Version Control Tool : Changeman,VSS,Endevor

Languages : JCL, SQL, Shell Scripting

Other Client Tools : SQL Assistant, Visio, Mainframe- File Aid and,

OPCA, Teradata Viewpoint, Db Visualizer

Awards and Accomplishments:

Received Infosys SPOT Award, recognition for the work on a quarter among around 50 peers

Received appreciation in the LBG Newsletter by the IT head, for successfully bringing in mortgages data from one system to other, which was a high priority activity for the bank, the implementation took place for a week.

Received top ranking in the WIPRO Annual performance appraisals.

EDUCATION

Degree

Year of Passing

Bachelor of Engineering in Electronics and Communication

2007

Previous Overseas Experience:

Worked in Manchester, UK for the client LBG between December 2012 and November 2013.

Currently in United states from February 2015

Work Visa status:

Currently working on H1B visa since feb 2015

Professional Experience

1)Cognizant Technologies Ltd, Plano TX Jan 2016 to Current

Role – Senior Associate, Teradata, Informatica Analyst and Developer

Working as a Teradata Analyst and Developer for a retail domain, responsible for gathering requirements, develop sql code, Unit testing, on Teradata Utilities MLOAD, BTEQ,

Create Mappings, workflows in Informatica powercenter 9.5.1 and 10.1 and usage of different transformations

Write Shell scripts in handling csv,xml,txt files in Unix, use SED,AWK commands in file handling and writing trigger scripts

Involve in performance tuning of Teradata SQL Queries, creating mapping source to target mapping sheets, handling stats on the tables

Prescribe the type of tables to be created in Staging and Target areas like Temporary, SET, Multi-Set, Volatile, global temporary tables

Generate reports by writing ad-hoc sql queries

Responsible for creating and doing unit test, ensure performance tuning using Informatica Power Center 9.5.1 and 10.1

Develop new components in Informatica Data Integration Hub (DIH), a latest tool by Informatica and good understanding of DIH components, concepts

Teradata Utilities Fastload, Mload, Bteq, Tpump and responsible for Performance tuning

Worked in Oracle 11g, using load utilities like SQLPLUS,SQLLDR

2)CVS Care Mark, Richardson, Dallas TX Feb 2015 to Jan 2016

Role – Programmer Analyst, Teradata Analyst

ETL Technical Lead responsible to gather requirements, Design and assist develop and review the code on the health care projects in Teradata 13 with Informatica Power center 9.5.1 as ETL on UNIX operating system.

Perform data analysis alongside solution architects for requirements specifications

Create history files on an adhoc basis after the project deployment based on business requirements.

Responsible for creating design documents, source to target mappings as per functional requirements and presentation to client side Leads and SMEs for approvals

Provide QA support during ST,QAT and UAT

Perform release management process in Serena.

Good knowledge on Health care subject areas CLIENT,MEMBER,ACCOUNT,GROUP, DRUG, PRESCRIBER.

Create Teradata SQLs, components BTEQ,MLOAD,FLOAD and Informatica workflows, sessions and mapping based on data model and requirements.

3)Lloyds Banking Group, Chennai Jan 2014 to Jan 2015

Role – Senior Software Engineer - Teradata SME

GDW - Group Data Warehouse, holds all the data on the bank. It is sub divided into multiple databases each pertaining to corresponding logical sections of data like Customer, Product, Transaction.. Etc

As SME (Subject Matter Expert) for Bank’s datawarehouse and Teradata lead,Responsible to successfully handle and deliver the projects on Retail portfolio.

In depth knowledge in various databases that holds each type of data in the warehouse

Create design and develop sql components like BTEQ,Load utilities, DDLs in Teradata 12, JCLs in Mainframes

The core database of the ware house was built on Teradata FSLDM, Expertise in FSLDM on subject areas- AGREEMENT, PARTY, FEATURE,EVENT,PRODUCT

Knowledge on using different type of Indexes like Join Index, Multi Table JI, Single table JI

Good understanding over the upstream and downstream systems or applications that has data dependency on the warehouse

Perform requirements gathering by liaising with BA, EAD, other stakeholders and transform them into design document

Work with data modelers to map the data into the FSLDM based database

Responsible for performance tuning, space additions, scheduling etc for handling new data

Worked in simplification projects on closure accounts,Money manager, Chip migration etc

Worked for migration project that involved mortgage data of the bank.

Use Fastload, Fast Export, BTEQ scripts for handling ETL requirements.

Done multiple Impact Assessments IA's, before study. This will identify for any impacts to the platform and to give an estimate which has variance level of +- 50

4)Lloyds Banking Group, Manchester, UK Dec 2012 to Dec 2013

Role – Senior Software Engineer - Teradata SME

Attend business workshops before commencing a new project or introducing new technology.

Gather requirements and Regularly attend business meetings representing the platform, provide updates to the CIO and necessary clarifications for EAD for any queries related to GDW data

Submit the design documents to the Bank’s technical team and get the approval on design to proceed for build and UT

Support implementation of projects

Create design and develop sql components like BTEQ,Load utilities, DDLs in Teradata 12, JCLs in Mainframes

Validate the development components on requirements and performance, platform standards

Performance tuning of sql code using various parameters like Stats, join strategies, indexes, DDLs

Having good knowledge over the data in the warehouse, been a point of contact for the BA's in identifying the relevant data as per their requirement and generated one off extracts that do not follow SDLC using Teradata, Mainframes

Create data mapping for the new data into database and extracts from warehouse

Work with support team in case of any batch failures of production jobs

5)Lloyds Banking Group, Chennai, India Jan 2011 to Nov 2012

Role – Senior Software Engineer - Teradata Analyst

Responsible to Develop Mid level platform design document, data mapping sheets

Raise queries to the business and architect team to close all the possible clarifications in design to avoid any hindrance to build

Create Impact assessment documents

Create Teradata BTEQs, JCLs and other components

Create schedule plan for the new jobs

Support QA testing using HP Quality Center

Working on a factory model on Retail portfolio projects

Gather requirements, provide updates to the CIO and necessary clarifications for EAD for any queries related to GDW data

Support implementation of projects

6)Bank of America, Chennai, India Jul 2007 to Dec 2010

Role – Senior Systems Analyst – Teradata Developer

Project :Countrywide Transition and Retail - Enterprise Credit Risk Information System

Country wide a financial institution was acquired by Bank of America. The customer and product related data was loaded into the enterprise data warehouse of the bank

ECRIS-Retail (Enterprise Credit Risk Information system - Retail) is a data mart that supports the information needs of the credit underwriting and credit management processes throughout Bank of America with a primary focus on the total consumer credit process.

Responsible to build Teradata components like BTEQ, MLOAD, FLOAD in Mainframes

Build Mainframe components like JCL, PROCS, parmcards

Create different type of tables like SET, MULTISET, Volatile based on the requirements and the Physical data model defined

Handled multiple files and used MLOAD to load the Teradata staging tables

Applied mapping logic over the incoming data from Landing and staging tables,load to the target tables

Groom new comers on EDW, Teradata and project flow

Presentation on various Banking concepts

Worked on collect statistics, decoding the explain plan, analyzing the confidence level of queries and different type of joins

Presented on the tuning techniques to team of around 15 and explained the efficiency of the different Teradata tables, Architecture and the efficiency of the different load utilities

Contact this candidate