Teradata DBA

Sensitivity: Internal & Restricted

Veeresh Charmani

Teradata DBA

Technical Leader

Mob No: +91-855*******/701-***-**** *******.********@*****.*** Objective

Eager to learn, Efficient, sincere, Cloud Technologies, looking for challenging and responsible opportunities to excel.

Professional Summary

Having an overall experience of 11+ years. Possess knowledge & experience working in Health Care Domain as Performance DBA. Possess knowledge and experience in Banking Domain as an Application DBA. Have worked on Retail customers, where it gives over all type of Business areas.

Wipro Technologies Limited: Oct 2010 – May 2017

Have tuned many queries which was consuming more time and affecting to Business. Possess knowledge about Data copy from production to dev/test/cert.

Worked on many reviews as per the Business standards. Have implemented code to the live.

Possess experience of working on TARA, Teradata Administrator, Teradata Manager and Teradata Viewpoint DSA architecture.

Having good communication, interpersonal, analytical, problem solving, leadership and organizational skills.

Have travelled to onsite on Business Visa to twice to Germany and once to Ireland. Brillio Technologies Limited: May 2017 – Dec 2018

Worked as LEAD DBA, supporting the team with my knowledge. Have worked with one of the leading client Walmart

Have worked on many projects.

As a lead, have been involved on reviews and changes to the code.

Have worked on many client applications like JIRA, Service now, Teracopy etc Sensitivity: Internal & Restricted

SLK Software services Ltd: Dec 2018 – Dec 2019

As a Technical lead, handling the overall Teradata DBA database of M&T Bank.

Have worked on system cleanup, Backup and recovery tasks.

Have been involved on Migration and deployment activities.

Incident and change management are part of day today activities.

I have worked on Hadoop too, as an admin.

Data copy between higher to lower environments.

Hue, Hive & impala I have worked on.

Wipro Technologies Limited: Jan 2020 – till date

Working as Lead Consultant, automobile project.

Recently we have upgraded the system to Teradata 17.10 Education

Master of Software engineering:

BITS Pilani (Rajasthan) Year of Pass and CGPA – November 2014 (5.76) Bachelor of Computer Applications - Kuvempu University, Shivamoga, Karnataka. Year of pass

(and pass %) – 2010 (73.68%).

Project 9:

PROJECT TITLE Daimler

CLIENT Germany

DURATION JUN 2020 – Present

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Unix, Teradata DSA, T-SET, Macro Generator.

Project Description:

Daimler AG is a German multinational automotive corporation. Daimler AG is head quartered in Stuttgart, Baden-Württemberg, Germany. By unit sales, it is the thirteenth-largest car manufacturer and second-largest truck manufacturer in the world. In addition to automobiles, Daimler manufactures buses and provides financial services through its Daimler Financial Services arm.

Sensitivity: Internal & Restricted

Roles Played: Technical Lead

Responsibilities:

As per the standards creating the environments and databases to the projects.

Coordination with development, testing and support teams.

Data copy from live to development and test environments.

Backup and restoring the databases.

Project 8:

PROJECT TITLE M & T

CLIENT M & T

DURATION Dec 2018 – Dec 2019

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Teracopy, Unix, Teradata Manager, T-SET

Project Description:

M&TBank Corporation is an American bank holding company head quartered in Buffalo, NewYork. They operate 780 branches in New York, New Jersey, Pennsylvania, Maryland, Delaware, Virginia, West Virginia, Washington, D.C., and Connecticut. M&T is ranked 467th on the Fortune 500. M&TBank has been profitable in every quarter since1976. Other than NorthernTrust, M&T was the only bank in the S&P500 Index not to lower its dividend during the financial crisis of 2007–2008. The bank owns the Buffalo Savings Bank building in down town Buffalo. M&T Bank also sponsors M&TBank Stadium, home of the BaltimoreRavens. M&T Bank is the official bank of the Buffalo Bills in Western NewYork and of their home Stadium New Era Field in Orchard Park, NewYork. Wilmington Trust is a subsidiary of M&T Bank Corporation, offering global corporate and institutional services, private banking, investment management, and fiduciary services. Project 7:

PROJECT TITLE Walmart

CLIENT Walmart labs

DURATION May 2017 – Dec 2018

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Teracopy, Unix, Teradata Manager, T-SET, Macro Generator

Project Description:

Walmart is the world's largest company by revenue–approximately US$480billion according to the FortuneGlobal500listin2016–aswellasthelargestprivateemployerintheworldwith2.3million employees. It is a publicly traded family-owned business, as the company is controlled by the Walton family. Sam Walton's heirs own over 50 percent of Walmart through their holding company, Walton Sensitivity: Internal & Restricted

Enterprises, and through their individual holdings. Walmart is one of the world's most valuable companies by market value and was the largest U.S.grocery retailer in2016. 62.3percent of Walmart's US$478.614 billion sales came from its U.S. operations. Roles Played: Lead Teradata DBA

Responsibilities:

Managing the space and tuning queries.

Creating the database, objects and sandboxes for projects.

Maintaining the database and managing the system health.

As a lead, helping the team to be at top in solving the issue at any point of business. Project 6:

PROJECT TITLE Allied Irish Bank

CLIENT AIB

DURATION FEB 2016 – May 2017

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Teracopy,Unix, Teradata Manager, T-SET, Macro

Generator

Project Description:

Allied Irish Banks (AIB) is one of the so-called "Big Four" commercial banks in Ireland. AIB offers a full range of personal and corporate banking services. AIB Capital Markets is the division of the company that offers international banking and treasury operations. The bank also offers a range of general insurance products such as home, travel and health insurance .It offers life assurance and pensions through its wholly owned subsidiary, Ark Life Assurance. In December 2010 the Irish government took a majority stake in the bank, which has since grown to 99.8%. AIB's shares were formerly traded on the Irish Stock Exchange and the London Stock Exchange, but its shares were delisted from these exchanges following its effective nationalization. The remaining publicly traded shares of AIB are now listed on the Enterprise Securities Market of the Irish Stock Exchange.

Have been to Dublin, Ireland on Business Visa.

Roles Played: Teradata DBA

Sensitivity: Internal & Restricted

Responsibilities:

Implementing the script as per the standards in live environment.

Coordination with development, testing and support teams.

Creating the databases for projects.

Data copy from live to development and test environments

Maintaining the database and managing the system health. Project 5:

PROJECT TITLE Daimler

CLIENT Germany

DURATION FEB 2015 – FEB 2016

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Teracopy, Unix, Teradata Manager, T-SET, Macro Generator

Project Description:

Daimler AG is a German multinational automotive corporation. Daimler AG is head quartered in Stuttgart, Baden-Württemberg, Germany. By unit sales, it is the thirteenth-largest car manufacturer and second-largest truck manufacturer in the world. In addition to automobiles, Daimler manufactures buses and provides financial services through its Daimler Financial Services arm.

First visit in the month of April 2015 to Germany on Business Visa for steady state discussion and meetings with the customer.

Second visit on Business trip to Germany and stayed for 40 days for meetings with customer July 5th till August 11th 2015

Roles Played: Teradata DBA

Responsibilities:

As per the standards creating the environments and databases to the projects.

Coordination with development, testing and support teams.

Data copy from live to development and test environments.

Backup and restoring the databases.

Sensitivity: Internal & Restricted

Project 4:

PROJECT TITLE TELKOMSEL

CLIENT INDONESIA

DURATION Jan 2015 – FEB 2015

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Teracopy, Unix, Teradata Manager, T-SET, Macro Generator

Project description:

Telkomsel is a brand name of a GSM and UMTS Mobile phone network operator which operates in Indonesia. It was founded in1995, and is a subsidiary of Telkom Indonesia. The company currently has 122 million subscribers. Telkomsel Operates in Indonesia with GSM900-1800MHz, 3Gnetwork, and internationally, through 323 international roaming partners in 170 countries (end of September 2008). The company provides its subscribers with the choice between three prepaid cards-simPATI, Loopand Kartuas, or the post-paidkartu Halo service, as well as a variety of value-added services and programs.

Roles Played: Teradata DBA

Responsibilities:

Providing approvals after reviewing the scripts for implementation.

Implementing the script as per the standards in live environment. Coordination with development, testing and support teams.

Data copy from live to development and test environments. Worked on Backup and restoring the environments.

Project 3:

PROJECT TITLE BANKINGACCOUNT – LLOYDS

CLIENT LBG

DURATION Dec 2012 – Sep -2014

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Teracopy, Unix, Teradata Manager, T-SET, Macro Generator

Project description:

Lloyds Bank plc is a British retail bank with branches across England and Wales. It has traditionally been considered one of the "BigFour" clearing banks. Originally founded in Birmingham in 1765, the bank expanded during the nineteenth and twentieth century’s and took over a number of smaller banking companies. In 1995 it merged with the Trustee Savings Bank and traded as Sensitivity: Internal & Restricted

Lloyds TSB Bank plc between 1999 and2013.

The bank is the principal subsidiary of Lloyds Banking Group, which was formed in January 2009 by the acquisition of HBOS by the then-Lloyds TSB Group. That year, following the UK bank rescue package, the British Government took a 43.4% stake in Lloyds Banking Group. As a condition imposed by the European Commission regarding state aid, the group later announced that it would create a new standalone retail banking business, made up of a number of Lloyds TSB branches and those of Cheltenham & Gloucester. The new business began operations on 9 September 2013 under the TSB brand. Lloyds TSB was subsequently renamed Lloyds Bank on 23 September 2013. Roles Played: Teradata DBA (Application DBA)

Responsibilities:

TDD and MLPD review.

Providing approvals after reviewing the scripts.

Implementing the script as per the standards in live environment.

Coordination with development, testing and support teams.

Creating the environments for projects.

Data copy from live to development and test environments. Project 2:

PROJECT TITLE CARDINAL HEALTH

CLIENT USA

DURATION Oct 2011 – Nov 2012

APPLICATIONS Teradata SQL Assistant, Teradata View Point, Teracopy, Unix, Teradata Manager, T-SET, Macro Generator

Project description:

CardinalHealth, Inc. is a Fortune500 health care services company based in Dublin, Ohio. The firm specializes in distribution of pharmaceuticals and medical products, serving more than 60,000 locations. The firm also manufactures medical and surgical products, including gloves, surgical apparel and fluid management products. In addition, it operates the nation’s largest network of radio pharmacies. On December10, 2013, it was announced that CardinalHealth would team up with CVS Caremark, which would form the largest generic drug sourcing operation in the United States. As of April, 2010, it was ranked 17th on the Fortune500 list with 2009 annual revenue of over $99 billion. The firm employs more than 30,000 people worldwide.

Roles Played: Teradata DBA (Performance DBA)

Sensitivity: Internal & Restricted

Responsibilities:

Supported from offshore as a single resource.

Has solved many issues regarding with access and job failures.

Solved production failures efficiently.

Handled the SRT call, with higher severity and solved the issue.

Monitoring the jobs, space movements, user access, job failures etc … Project 1:

PROJECT TITLE ISRVE

CLIENT XEROX

DURATION Jan 2011 – Oct 2011

APPLICATIONS OWB (ORACLE WAREHOUSE BUILDER)

Project description:

Xerox Corporation Ltd. is an American multinational document management corporation that produces and sells a range of color and black-and-white printers, multifunction systems, photocopiers, digital production printing presses, and related consulting services and supplies. Xerox is headquartered in Norwalk, Connecticut (moved from Stamford, Connecticut in October 2007), though its largest population of employees is based around Rochester, NewYork, the area in which the company was founded. On September 28, 2009, Xerox announced the intended acquisition of Affiliated Computer Services for $6.4billion.The deal closed on February 8, 2010. Roles Played:

I have worked as an oracle developer; we used to create mappings for the requested data. We use to pull the required details from the source tables and put into the target system. In between, we used the functions and we use to do some operations to arrive at desired result. Those results were used for reporting purpose. As per the requirement of the project we used to create mappings to pull the required data.

Personal Details

Date of Birth 16-07-1989

Passport No P3879570

Marital Status Married

Languages English, Hindi, Kannada, Telugu

Contact this candidate