Mob: +91-725**-***** Mohankumar Raju Bangalore

acxyge@r.postjobfree.com Teradata Certified Master India – 560068

Career Objectives

Technically sophisticated professional in Teradata Administration and ETL and am looking for a position where I can utilize the knowledge gained and scope for continuous learning and improvement to deliver the best in every opportunity

Professional Summary

Almost 9 years of experience in IT industry especially in the area of Data ware housing and Business intelligence

Sound understanding and experience in all stages of a DWH-ETL project lifecycle (Data requirements, Design, source to target mapping, reference data mapping, ETL Control Framework design, ETL design, ETL development, ETL testing, Job scheduling, System & Integration testing, Implementation, Post Implementation Warranty Support and User documentation

Experienced in Teradata Tools like Viewpoint, Teradata Manager, TASM, Teradata Administrator and SQL Assistant

Hands on experience in building, modifying and activating rule sets using TASM

Extensive knowledge in Teradata Load Utilities - Fast Export, Fast Load, Multiload, BTEQ, Tpump and TPT

Experience in on-call DBA related activities like Space and User Management, Backup and Archive, Data Mover, Batch Monitoring & Incident Management

Analysis of production issues in handling critical tasks such as database system restarts, system performance degradations, query performances and data corruptions

Experience in Application DBA related tasks such as Performance tuning, MVC, PPI analysis, Index Analysis, Capacity Planning and implementing change requests

Converting logical data models into physical data tables and support the development team in implementing CR and enhancements

Working as System DBA and responsible for Teradata database maintenance & Upgrade activities and update the necessary info requested by GSC for incidents

Implemented automation process using stored procedures for index maintenance, user drop and creation, user sandbox table drop and to drop utilities interim tables

Experience in conducting internal corporate trainings and recruitment activities

Creation and maintenance of Defect Prevention log. Assisting in the smooth transition from development to production

Self-managed, responsible, accountable, result-oriented, value-adding, excellent team player, ability to meet deadlines and produce quality works on time

Employment History

Wells Fargo – June 2015 to Present

Infosys Technologies – Jun 2013 – April 2014 (Key Client: RBS Bank)

Capus Technology Solutions – Jun 2010 – Jun 2013 – (Key Clients: Unilever, Lloyds Bank)

Mphasis an HP Company – Aug 2007 – Jun 2010 – (Key Client: Vodafone)

Tata Consultancy Services – Jan 2007 – Aug 2007 – (Key Client: Motorola)

Education

Masters Degree in Computer Science

Bharathiar University, Coimbatore

Tamil Nadu, India

74% - 2003

Technical Skills

Operating Systems : UNIX, Windows 9x, 2000

Database : Teradata 15.10, Oracle and MS Access

Language Known : VB 6.0, VB.Net

Teradata Tools : Teradata Manager, PMON, Teradata Administrator, SQL Assistant, Viewpoint

Teradata Utilities : Teradata Fast Load, Multiload, Fast Export, BTEQ, Tpump & TPT

ETL Tool : Informatica

Scheduling Tool : Control-M, TWS and Autosys

Project Details

1.Banking Client – USA

Jun 2015 – Present

DBA Specialist

Description:

Wells Fargo is one of the largest USA esteemed banks in the world and they have strong customer base in USA. EIW is the enterprise wide database used for almost 90 percent of their business applications. EIW Data warehouse platform is maintaining variety of applications ranging from basic customer information to advanced customer behavior prediction and analysis. Our team is responsible for availability of EIW to end users all the time. There are critical applications which are complex in nature, so high availability and disaster recovery have been built into their architecture using query director and BCP. Activities include capacity planning, backup and archive, database performance tuning, new implementation and Infrastructure support.

Responsibilities:

Responsible and managing On-call, Application and Infrastructure DBA activities

Move data/applications to production and other environments using Data mover and Query Grid

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles

Responsible for User Management, Space Management, Profile & Role management and production issues

Handling system and job failures

Perform periodic backups and archive of database and restore on as needed basis

Performance tuning, MVC, PPI analysis, Index Analysis and Capacity Planning

Support the development team in implementing CR and enhancements at scheduled time

Provided Infrastructure support for Teradata database maintenance & Upgrade activities and update the necessary info requested by GSC to investigate on incidents

Implemented automation process using stored procedures for index maintenance, user drop and creation, user sandbox table drop beyond a week and to drop utilities interim tables

Implemented automation process to revoke User access when they do large number of single row inserts

Implemented Filters and throttles to make use of system resources wisely

Mentoring the new team members for smooth on-boarding

Coordinating weekly team meetings and knowledge sharing sessions

Support recruitment activities

2.Banking Client – UK

Oct 2013 – Mar 2014

Teradata DBA

Description:

Client is one of the largest UK bank and they have established their business globally around the world. EDW involves Design, Build, Testing, Implementation and Operational Support of Oracle & Teradata databases. These databases run high performing critical financial applications (like Online Banking, Wire transfers). The databases are complex in nature and have high availability and disaster recovery built into their architecture. Activities includes architecture design,capacity planning, backup and recovery, database performance tuning, High Availability solutions, planning and implementing, Business Continuity Planning (BCP) and database space management.

Responsibilities:

Worked with data modelers and designers to perform physical database implementations

Resource utilization and performance monitoring using View Point

Identifying the potential queries for skewness and taking corrective action

Responsible for User Management, Space Management, Profile & Role management

Move data/applications to production and other environments

Create / Modify / Drop Teradata objects such as Database, Users, Profiles, Roles, Tables and Views

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles

Perform periodic backups of database and applications, and restore on as needed basis

Incident and change request management

Account Related Activities:

Involved in creating ETL framework for Rainbow program

Proposed best practices to be followed in Teradata

Conducted Unit wise Teradata sessions

Actively participated in new proposals and COE activities

Continuous support for recruitment related activities

3.Banking Client - UK

May 2012 – May 2013

Teradata DBA

Description

Project is about ‘Customer Insight’ program that will enable the client to leverage insight driven from customer data across the group and turn deep customer understanding into value for us and for our customers. A major factor to enable delivery of this customer understanding is the ability to exploit key data assets. These assets relate to customers within individual lines of business, across the group, external feeds and 3rd parties. It gives ability to utilize the data in a seamless and proactive way across all interaction opportunities will deliver a sustainable competitive advantage for the Bank.

Responsibilities:

Worked with data modelers and designers to perform physical database implementations

Resource utilization and performance monitoring using View Point

Identifying the potential queries for skewness and taking corrective action

Responsible for User Management, Space Management, Profile & Role management

Involved in Capacity Planning and Workload Management

Move data/applications to production and other environments

Create / Modify / Drop Teradata objects such as Database, Users, Profiles, Roles, Tables and Views

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles

Perform periodic backups of database and applications, and restores on as needed basis

Creating Fast load, Multi load, Fastexport and BTEQ scripts to import data from Source system for data fix

Selection of Primary Index to ensure uniform data distribution

Compressing columns for efficient utilization of available disk space

Monitoring the usage of secondary indexes and then unused indexes are dropped

Involved in query optimization for various business queries and scripts

Attending code review meetings and providing solutions

Actively participated in project sizing and effort estimation

4.Retail Client – UK

Aug 2010 – Apr 2012

Teradata Lead

Description

Client is one of the largest retailing company established their business globally around the world. At present they have a data warehouse implemented in SAP BW which concentrates only on North America consumers. So they planned to build a global data ware house in Teradata. All expected sources are flat files which get loaded into EDW as per the business logics using BODS with backend as Teradata. For reporting needs, MSBI is used.

Responsibilities:

Guide the team from Requirement phase to Implementation phase

Involved in Requirement and Impact analysis phase and accountable for design (HLD and LLD) deliverables

Provide design for CDC implementation for real time data solutions

Mentor and guide the development and testing team for all project deliverables

Analyze and recommend solutions for data issues

DBA related activities which includes:

Selection of Primary Index (UPI, NUPI) for a table to ensure uniform data distribution across the AMP’s and Compressing Columns for efficient utilization of available disk space

Monitoring the usage of secondary indexes using explain plan, so that unused indexes can be dropped, so that more space is available to the database

Using MVC multi-value-compression to compress the selected tables and reduce the space consumption

Suggested senior developers to implement mandatory steps to fine tune bad SQL’s to give better response times

Create / Modify / Drop Teradata objects such as Database, Users, Profiles, Roles, Tables and Views

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles

Perform periodic backups of database and applications, and restore on need basis

Trained couple of fresh trainees in Teradata and on-boarded into project

Contributed towards the building of most dedicated, energized, enthusiastic and conversant team of people by providing numerous time to time technical and functional inputs to the team members

Worked on POC and POV as a part of Business Proposals

5.Telecom Client - Germany

Aug 2007 – Jun 2010

Module Lead

Description

Client implemented a data warehouse to better plan and manage revenue realization, customer retention and acquisition and also to establish a data warehouse of usage, billing and provisioning information for the Mobility business units. This is an enhancement cum development project, As a part of migration we involved in both development and enhancement of DWH. Our main source is KIAS which is received in the form of interface and is used for loading the DWH.

Two types of extractions are implemented:

Delta Extraction – Only the records (first time insert, recent update and deletion) which has been updated since last loading has been selected for processing.

Full Extraction – All records has been considered for processing.

Responsibilities:

Lead the team from Design Phase to Testing Phase

Involved in preparation of Solution Design / Technical Design Documentation for various project portfolios

Involved in setting up architecture guidelines for new enterprise data warehouse

Created Teradata utility scripts based on user inputs for Teradata utilities such as Fast load, Multi load, Tpump, Fast Export and BTEQ

Coordinating with on-site teams during offshore development

Participated in Unit, SIT and UAT Testing phases

Coded complex scripts for the Teradata Utilities and fine-tuned the queries to enhance performance. Well versed with understanding of Explain Plans and confidence levels

Implemented Compression and Multi-value Compression

Implemented Partition Primary Index

Implemented Join Index (Aggregate Join Index)

Defined standards for Performance tuning and peer-review activities

Handling management activities like delivering weekly and monthly status reports and monitoring project flow and planning.

Co-ordinate offshore with onsite through conference calls every week to run the project smoothly

Implemented MVC to reduce space consumption and to improve performance

Minimized the collection of Full stats by Sample stats wherever the data distribution is uniform to reduce the usage of CPU without compromising any performance degradation

Contributed in Teradata POC

6.Manufacturing Client - USA

Jan 2007 - Aug 2007

ETL Developer

Description

Client has three main business units. They are Enterprise Mobility, Network & Enterprise (N&E) and Connected Home Solutions (CHS).The SWAETL will be implanted for the two units N&E and CHS.

The scope of this project SWAETL is to facilitate SAS application by loading the required data into Staging area which is then accessed by SAS data mart. Main objective is to provide the products and warranty / claims data collected from various source systems to SAS to improve their business potential.

The Technical environment is as follows:

Extract the data from the available sources in to Pre-staging database from where applying the Transformations and Business rules and validations. The records which pass thru validation are populated to staging database and the rejections are populated to rejection database.

Responsibilities:

Identified the data source and analyzed the source data

Gathering the requirements of Business from Analysts

Preparation of Mapping and Design documents

Identified the types of Transformation to be used

Preparation of Test cases for each source system

Personal Details

Name: Mohankumar Raju

Birth Date: 4th July 1980

Residence: Gobichettipalayam

Nationality: Indian

Gender: Male

Passport Details:

Number: N9966459

Issue Date: 12TH Sep 2016

Expiration Date: 11TH Sep 2026

Country India

Pan Card: AIBPR3485P

Permanent Address: #3/2, UmaMohan Illam, Thillai Nagar, L.Kallipatti, Gobichettipalayam, Erode Dist Tamil Nadu - 638452

Declaration

All the details mentioned above are true to the best of my knowledge and belief

Thank you

Mohankumar R

References

Dhanabal Subramaniam – Teradata Architect

+44-746*******

Ramanand Avanasiappan – Senior Manager

+91-984*******

Contact this candidate