SUMMARY:

Teradata Certified Master V2R5 and over 16+ years of industry experience in Information Technology, including 4+ Years as Oracle Database Administrator and 11+ Years of Experience in Teradata where the clients include Telecom - Retail-Life sciences-Healthcare on model in Production Database. Worked with Production, Development and Test databases on Unix, Linux and Windows platform. Strong skills in Teradata Database Administration, Data Architecture, Database Tuning, SQL Tuning, Backup & Recovery, TD BAR Architecture and Performance Monitoring-Hadoop Admin skills includes the internals of YARN, MapReduce, and HDFS-Determining the correct hardware and infrastructure for your cluster-Proper cluster configuration and deployment to integrate with the data center-How to load data into the cluster from dynamically-generated files using Flume and from RDBMS using Sqoop-Configuring the FairScheduler to provide service-level agreements for multiple users of a cluster-Best practices for preparing and maintaining Apache Hadoop in production-Troubleshooting, diagnosing, tuning, and solving Hadoop issues-Cloud Computing with AWS -AWS Solution Architect includes S3 Operations-EC2 Elastic Cloud Compute-Amazon Relational Database Services(RDS)-Deploying and Scaling an application-ELB(Elastic Load Balancer)-Auto Scaling-VPC-Identity and Access Management-Cloud Front-Route S3-Cloud Formation-Amazon DynamoDB

TECHNICAL SKILLS:

Operating Systems: UNIX, Sun Solaris,HDFS

Scripting Languages: Unix Shell Script

RDBMS: TERADATA V2R5/TD 13,14.1, ORACLE 8i/9i, Sybase IQ,MS SQLSERVER 2000

ETL and BIG Data Tools: Informatica 8.X/Hadoop Administration/Mango DB

Tools: and Utilities: Teradata Administrator, Teradata Manager,TASM, Workload Management, Performance Monitor, Teradata SQL Assistant, PDCR, Fast load, Multi load, Fast Export, Bteq, Ferret, TPT,Teradata Data Mover and Erwin, Informatica7 & 8.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo NY

Teradata DBA Consultant

Responsibilities:

• Teradata Job load monitoring & Problem Solving.
• Database Performance - Perf Tuning & Query Optimization.
• System Performance using Teradata Utilities.
• Sound knowledge of Teradata System Architecture, System administration tools, Client applications and Code maintenance processes.
• Familiar with Teradata Load/Unload utilities like BTEQ, FastLoad, MultiLoad, Tpump, FastExport, ARC.
• Familiar with Teradata Administration Tools like Teradata Manager, PMON, Teradata Administrator, TDQM, MultiTool, Vprocmanager.

Confidential, St. Louis

Project Lead, Teradata DBA

Responsibilities:

• Teradata: Unix/Linux ARC/Restore Scripts- Advanced SQL- Performance Tuning- Backup & Recovery-Advanced Shell scripting- Technical documentation- Teradata Viewpoint-TASM- Teradata administration.
• Assist data modeling to design and implement data structures, which meet the business requirement for timely, accurate data.
• Promote data quality and enforce data integrity.
• Resolve database performance issues, capacity issues, replication, and other distributed data issues.
• Determine user requirements, set up and test computer databases, and coordinate changes.
• Interact with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases

Confidential

Senior Manager

Responsibilities:

• Working closely with TERADATA Professional Services Consultant to setup the new TERADATA environment in PROD, DEV, QA with various backup strategies.
• Designed Best Practice-Guidelines - Standards to write efficient TD SQL for ETL Developers, BI Reporting and TD PDM/LDM Modeling team includes client team and Cognizant team.
• End to End Architect Solutions-PDM Deployment-Involved with Core team of LDM Modelers in designing the Dimensional modeling-Semantic Layer on top of 3NF TD Database Model.

Confidential, Dallas, Texas

EIM-Teradata Database Performance Architect and Tuning Consultant

Responsibilities:

• Understanding the client Teradata Environment -Identified the Performance Assessment Areas
• Performance Tuning for the Bad Performing Queries, which are undergoing Deadlock-Block-Locking issues and identified other areas to bring down the top 10 bad queries in TD Prod environment using various TD tools and done troubleshooting finally with summary of Presentation to clients.
• During this exercise closely worked with ETL, Reporting, Data Modelers, DBAs, Data Architect and Business Team.

Confidential, St. Louis, MO

Teradata DBA, Datawarehouse

Responsibilities:

• Direct the modeling, design, and database development of corporate data storage.
• Responsible for the technical infrastructure designs, data management/flows and reports, as well as for the day-to-day operations and ETL End-to-End Solution on DBA, TERADATA Optimization and development activities.
• Manage the enterprise data planning and support functions.
• Be responsible for the development and maintenance of the enterprise data and database architecture to include the data and database resource planning functions.
• Provide recommendations for data architecture and database strategies; and communicate data architecture concepts, strategies and standards.
• Oversee key performance decisions for the project data.
• Design, implement, deploy and maintain the data warehouse, processes, business intelligence and reporting solutions.
• Work with business users, management and executives to analyze, define and document systems, data sources and business requirements for analytical needs related to the data warehouse and processes.
• Participate in the complete systems development life cycle (planning, analysis, design, documentation, prototyping, development, testing, training, and launch) of new and existing business applications and business processes .Manage and deliver components of client engagements that identify, design and implement technology.
• Direct teams in the identification of business requirements, functional design, process design (including scenario design, flow mapping), prototyping, testing, training cognizant resources on TERADATA, defining support procedures

Confidential, New Jersey

Teradata Solution Architect

Responsibilities:

• Involved and Support team in project enhancement and architectural design.
• Reviewing ETL Code developed in BTEQ and other TERADATA tools.
• Complete support to team in data migration and data mapping project assignment for healthcare client from different database sources from EDW to EIW-TERADATA database.

Confidential

Teradata Environment Change Coordinator

Responsibilities:

• Managing new projects/changes release into the production environment in a controlled and retractable fashion.
• Working with Project Managers and Technical Project Leads in successfully transitioning new subject areas and/or batches/sessions into the production environment.
• This includes ensuring that adequate training, documentation and support plans have been provided from the project management team prior to transitioning over to production support team. Develop technical, functional and support documentation and delivering presentations/training (in TERADATA) as required.
• Coordinate when and how environments will be used with development/project teams. Working with the individual project teams, project managers and developers to ensure that the deployment plan and environment requirements are clearly defined and documented for new projects and incremental change requests.
• Coordinating folder migrations and execution of MCRs with DBAs until the CR is released in Production.
• Reviewing and maintaining all database scripts that are sent from the Business Analysts/Data Modelers.