OBJECTIVE:

Seeking a challenging role where my leadership and Business Intelligence skills can be fully leveraged to implement effective solutions that enhance both business performance and customer satisfaction.

SUMMARY:

• Over Fourteen Years of diversified experience in IT in Enterprise Application Architecture, Database Administration, and Project Management. Recently focused on Data Warehouse optimization and business intelligence applications.
• Over 8 years of working experience in TERADATA Data Warehouse landscape/Administration.
• Certified DBA Professional with Strong Knowledge of Data warehouse Design Methodology, and Data modeling techniques.
• Worked on physical/Logical data modeling, implemented using ERWIN.
• Worked on EDW utilities like BTEQ, MultiLoad, FastExport, Tpump, Visual Explain
• Experienced in diversified application development in Teradata, Oracle, Peoplesoft, Netezza et al.
• Good at working with high volume databases of multi terabytes. Trained other team members in Teradata.
• Good exposure on Hadoop, ASTER Architecture and Administration
• Involved in Data Migration between Teradata/Oracle, Teradata/Hadoop.
• Being a Certified SQL Tuning professional reduced execution time significantly for long running tactical queries. Good experience in Oracle (10g, 9i, 8i), ms sql server on OLTP/OLAP environments for large Databases.
• Extensive experience writing TERADATA Macros, triggers, and views.
• Proficient in TERADATA DBA activities like creating databases, managing tables, Indexes, User Security, Space/Performance management, System monitoring.
• Customized and Deployed Confidential portlets for management dashboards reporting.
• Experience with UNIX Shell Scripting and good coding practices using SQL, PL/SQL.
• Major Clients worked with; Confidential Bank, Confidential, Confidential, Confidential, Confidential et al.

TECHNICAL EXPERTISE/ENVIRONMENT:

RDBMS: Teradata 14/13/12/v2R6.0/v2R5.x, Oracle 10g/9i/8, DB2, SQL Server 2005/2000

ETL/OLAP/Reporting Tools: Informatica PowerCenter 9.5/8.x/7.x, Business ObjectsXI r2, Xcelsius, FastLoad, MultiLoad, TPump, MicroStrategy 7.1.2, SqlAssistant, DataStage7.5, BTEQ, AtanaSuite Expert, Tableu

Data Modeling/Domains: CA Allfusion ERWin, ER/Studio Data Architect 9.0, Rational S/w Architect, Data Mart Design Conceptual/Logical/Physical Modeling, Metadata Management, Visio, HealthCare, Banking, Retail

Tools: /GUI: Teradata Administrator, TD Performance Monitor, Teradata Manager, Query Analyzer, TOAD, Priority Scheduler/UC4, winDDI, TDWM, ARC, Teradata Confidential

Hardware platforms/Operating systems: TD 6750/5650/5500 , Teradata Enterprise/Appliances, SLES 10/SLES 11, AIX5.3/5.1, Solaris 8/6, HP - UX 11.11, Windows7/2008/2003/NT, Linux AS2.1

Languages: BTEQ, PL/SQL, SQL*PLUS, Unix Shell, C, Java, UML, PeopleCode

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Sr Teradata Architect/Big Data Admin

Responsibilities:

• Managed Teradata, Hadoop, Aster Environments
• SQL Optimization of Reports, Informatica workflows. Explain Plan, AJIs used
• Capacity Planning for Teradata, Hadoop landscape and forecasting
• Resolved TD issues, used TSET, DBQL, TDWM dump, CrashDumps, Perflook
• Data Mover set up, Created jobs to move data across Teradata/Hadoop
• Executed Performance Benchmarking for SQLs and Backups
• Monitored, Improved TD systems using Confidential, Resources usage, Alerts. Published performance Metrics. Modified DBS control parameters, Confidential Data Collectors.
• Implemented PDCR and Upgrade
• Designed physical data models, Implemented in databases. Implemented PPI, Compression
• Used best practices for EDW landscape to improve PIs, Stats Collection process, efficient Storage, Backups, Archive & Purge, Security, SOX.
• Improved TASM settings based on Workloads changes, Jobs priorities/Exceptions, penalty box
• Lead & mentored junior DBAs, Presented POCs to management for Backups, New Appliances

Environment: Teradata 14.10, Informatica PowerCenter9.5, Tableau, TD2650, TD2750/SLES11, PDCRDATA, BTEQ, Embarcadero, TD Admin, Hadoop, ASTER, TD Confidential, Data Mover

Confidential, Milpitas, CA

Teradata Platform Architect/DBA

Responsibilities:

• Set up & managed Data Labs for various Groups after interacting with business
• Performance Tuning of long running queries, Informatica workflows. Used Explain Plan
• Capacity Planning for Teradata landscape and forecasting
• Resolved TD issues, used TSET, DBQL, TDWM dump, Perflook, worked with TD support
• Participated in Upgrade to TD14.10, and H/W upgrade. Executed Performance Benchmarking.
• Worked on physical data models, Implemented in databases. Implemented PPI, Compression
• Analyzed TD landscape for gaps, Used best practices to improve PIs, Stats Collection process, efficient Storage, Backups, Archive & Purge, Security, SOX.
• Implemented TASM settings for Workloads changes, Jobs priorities/Exceptions, penalty box
• Lead & mentored offshore DBA team for TD DBA tasks

Environment: Teradata 14.10/13.10 , Informatica PowerCenter9.5, BO XI r2, TD6700/SLES10, PDCRDATA, BTEQ, ERWIN, TD Confidential, TD Admin, ARCMAIN, TD Unity Director

Confidential, Plano, TX

Teradata Application Architect/Data Modeler

Responsibilities:

• Developed Physical Data Models using ERWIN after analyzing Logical data Models and interacting with business
• Analyzed and translation of data models to Star or Snowflake database schemas.
• Worked on physical data models, Implemented in databases.
• Implemented multi value Compression. Reduced storage cost and gained performance
• Improved Performance optimizing TERADATA SQL statements and various data loading strategies using TERADATA VISUAL EXPLAIN.
• Enhanced existing processes to run more efficiently by working on PPI, Skew, Joins, AJIs, workload management and Compression.
• Executed Admin tasks using TD Administrator, Confidential, TD Manager such as workload activity, space utilization, statistics collection, and system performance monitoring.
• Managed security, space, jobs, tuning of loads, and Change management using HPSM.
• Performance tuning of queries, and Capacity Planning for TD landscape.

Environment: Teradata 13.10, Ab Initio, BTEQ, BO XI r2, NetVault, Teradata5650, ERWIN, TD

Confidential, Pleasanton, CA

Lead Teradata Application DBA/Architect

Responsibilities:

• Developed Logical and Physical Data Models using ERWIN after interacting with business
• Analyzed and translation of data models to Star or Snowflake database schemas.
• Implemented physical data models, created scripts for Tables, views, Created PIs.
• Implemented multi value Compression to save storage cost, and gain performance
• Monitoring system and resolving Performance issues
• Analysis for Capacity, Workload for different regions, Implemented and enhanced TASM
• Coordination among regional teams for smoother upgrades, and change management
• Optimized Performance of long running tactical queries.
• Revisited Physical Data Models for Performance, Schema Optimization
• Used best practices for Backups, Statistics Collection, new applications implementations
• Provided guidance to less experienced team members, and trained them

Environment: Teradata12, Clarity, TARA, WindowsXP, TD Administrator, BTEQ, DBQL, ERWIN, TDWM, Teradata5550/5450, Teradata Manager, Business Objects

Confidential, Milpitas, CA

Lead Performance DBA/Architect

Responsibilities:

• Long running queries were tuned for Optimal Performance.
• Enforced proper use of Primary and secondary indices after analysis.
• Saved CPU by optimizing the collection of Statistics
• Reduced execution time for jobs by working on the workload management using TASM.
• Worked on Confidential requirements, and Prepared the Design Document
• Customized Confidential Portlets to provide better functionality
• Set up Alerts & Metrics for monitoring purposes by Operations
• Worked with Architect team to create centralized application to report Performance Metrics and Capacity Utilization.

Environment: Teradata13/12, Informatica PowerCenter 8.6.1, Oracle, NetBackup/TARA, TD Administrator, DBQL, TDWM, Teradata5555/5650, TD Manager, TD Confidential

Confidential, Dallas, Texas

Teradata Performance Analyst/Application DBA

Responsibilities:

• Data warehouse was running out of capacity.
• Performed Data analysis to make data types optimization suggestions.
• Enforced proper use of Primary and secondary indices after analysis.
• Achieved better performance, and saved CPU by Optimizing the collection of Statistics
• Developed process to get rid of unused data, and reclaimed huge space by purging unwanted data. Worked on schema optimization.
• Reduced execution time for jobs by working on the workload management.
• Analyzed DBQL to find AWTs/CPU usage, long running queries, STATS collection
• Reviewed Physical Data Models to remove the data redundancy.
• Conducted interviews with business users to help them understanding the efforts, and to expedite the implementation of recommendations.

Environment: Teradata12/Teradata v2r6, DataStage7.5, DB2, NetVault, WindowsXP, Teradata Administrator, BTEQ,DBQL, ERWIN, PL/SQL, TDWM, Teradata5550, Teradata Manager

Confidential, Brisbane, CA

Lead Teradata DBA/ Architect

Responsibilities:

• Data Source Mapping to the Retail Logical Data Model
• Worked on logical and first-cut physical data models using ERWIN
• Implemented physical data models considering PPIs and Compression for the optimized performance, and reduced storage costs
• Performed bulk data load from multiple data source like Oracle9i, sql server, flat files to TERADATA EDW. Created scripts using FastLoad, Multi-Load, TPump to load data.
• Reduced execution time for long running queries using VISUAL EXPLAIN.
• Gathered reports on spool space, table skews, Index usage and provided recommendations.
• Developed Unix shell scripts to schedule heavy reports to run during off peak hours
• Performed Teradata DBA tasks using Teradata Manager such as workload activity, space utilization, statistics collection, and system performance monitoring.
• Used winDDI for user administration which involved Security, Space, Roles, Profiles.
• Setup of Statistics Collection process which ensures all tables have current Statistics.
• Worked on backup/restore processes using ARCMAIN with NetVault

Environment: Teradata v2r6, Business Objects XI r2, Informatica PowerCenter 8.6, PL/SQL, PeopleSoft, Solaris2.8, Oracle 9i, Windows XP, AtanaSuite CompressTool

Confidential, NC

Teradata DBA

Responsibilities:

• Involved in source/target analysis to implement EDW and ETL architecture
• FASTLOAD and MULTILOAD jobs to load extracted data into TERADATA databases.
• Enhanced existing queries and data loads to run more efficiently and faster by query optimization using Teradata Visual explain, Statistics collection, & proper Indexing.
• Worked on Operational Data Stores (ODS) for specific healthcare requirements
• Worked on ARCMAIN with NetVault for backup and recovery operations
• Scheduled, Managed batch jobs using Priority Scheduler and used ENDEVOR for change control.
• Involved in the archiving of patients data, and making accessible to Teradata
• Handled DBA tasks like User creation, security, database creation, Primary/Secondary indexes and Scheduling/maintenance of jobs.

Environment: Teradata v2r5.1, QueryMan, BTEQ, FLoad, FastExport, Oracle 8i, UC4, MVS, JCL, SAS, Windows2003, ERWIN, Informatica PowerCenter/PowerMart6.2, Business Objects XI.