SUMMARY

• 8 years of IT experience in Data warehousing, Teradata, ETL, Requirements Gathering in Banking and Health care 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 ETL Technical Lead responsible to gather requirements, Design, develop and review the code Teradata 13 with Informatica 9.5.1 Powercenter as ETL on UNIX operating system for health care client for a offshore team of 15
• Responsible to provide design solutions, estimates and timelines for the new development projects
• As a technical lead, responsible as single point of contact to business and project owner for the project delivery, quality and status updates
• Good Knowledge on Snow flake, Star data models, working experience on Type II logic
• Work experience in performing ETL operations from UNIX and Mainframes in Teradata
• Expertise in SDLC model project deliveries in traditional and Agile methodologies
• Expert in defining 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)
• Worked on Teradata utilities - Fast load, Multi load (Mload), BTEQ, Fast Export.
• Experience in Teradata SQL Performance tuning for optimal performance, Collect statistics, Join strategies, Join types and Explain/Optimizer plans.
• Knowledge on writing complex Teradata SQLs using OLAP functions,derived tables and complex joins.
• Knowledge on using different type of 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
• Good knowledge and understanding in Unix Shell scripting
• Knowledge in Informatica Power Center ETL, mapping, sessions and workflows
• Gather requirements, write design documents, engage in data analysis along with Business Analysts, Enterprise Architects
• Currently working on Type II data model playing the role as a Teradata Technical lead for a team of 10
• Responsible to support QA,UAT, Functional and Nonfunctional 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.
• Working experience on Onshore centric as well as onshore-offshore Projects
• 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

ETL: Informatica Power Center 9.5.1

Operating Systems: Windows,UNIX, IBM Mainframe

Scheduling Tool: CA7, ENDEVOR

Test case tracking tools: HP Quality Center

Version Control Tool: Changeman,VSS, Serena and Endevor

Languages: JCL, SQL, Basics in Shell

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Teradata and ETL Analyst

Responsibilities:

• 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.
• Lead and Co-ordinate offshore team of 10 in the SDLC projects that involve ETL operations into and from the datawarehouse built on Teradata
• The technical components involve Teradata BTEQ, DDLs, Informatica Workflow, mapping, sessions and unix shell scripts
• Responsible to define the type of tables to be created, Indexes and ensure other performance parameters are maintained.
• The projects involve data migration, Development, Enhancements and Support activities
• Prepare the Unit test cases, Reports, perform UAT co-ordinating with business
• 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.

Confidential

Teradata and DWH SME

Responsibilities:

• As SME (Subject Matter Expert) for Bank’s datawarehouse and Teradata lead, Responsible to successfully handle and deliver the projects on Retail portfolio.
• Lead a team of 20 for the requirement and technical queries throughout the cycle of the project
• In depth knowledge in various databases that holds each type of data in the warehouse
• Working on Teradata 12, Mainframes, ETL and FSLDM
• 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.
• Used 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

Confidential

Teradata and DWH SME

Responsibilities:

• 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
• Validate the development components on requirements and performance, platform standards
• Support implementation of projects
• Develop sql components in BTEQ, MLOAD to do one time extracts
• Ensure the performance is maintained on the coding using various parameters like Stats,joins, 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

Confidential

Teradata Analyst

Responsibilities:

• 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
• 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

Confidential

Teradata Developer junior

Responsibilities:

• 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