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 Thirteen Years of diversified experience in IT in Enterprise Application Architecture, Database Administration, and Project Management. Recently focused on Data Warehouse optimization, ETL, and business intelligence applications.
• Over 8 years of working experience in TERADATA Data Warehouse landscape for Enterprise Data Warehouse applications.
• Extensive experience with TERADATA architecture and administration.
• Worked on Data Models, Logical and physical data modeling, implemented using ERWIN, and IBM Software Architect.
• Experienced in diversified application development in Teradata, Oracle, SQL Server, Peoplesoft et al.
• Good at working with high volume databases of multi terabytes, management of Data and Capacity Planning.
• Worked on Big Data/Hadoop Architecture and Administration
• Worked on reverse engineering projects to improve performance of existing applications. Involved in Data Migration between Teradata and Oracle.
• Being a Certified SQL Tuning professional reduced execution time significantly for long running tactical queries. Good experience in Oracle (10g, 9i, 8i), Sql server on OLTP/OLAP environments for large Databases.
• Certified DBA Professional with Strong Knowledge of Data warehouse Design Methodology, and Data modeling techniques.
• Proficient in TERADATA DBA activities like creating databases, managing tables/ Indexes, Security, Space management, and Performance tuning, System monitoring, ResUsage Reports.
• Experience with UNIX Shell Scripting and good coding practices using SQL, PL/SQL.
• Deployed Business Objects Dashboards for management reporting.

TECHNICAL SKILLS

Data Modeling: CA Allfusion ERWin, ER/Studio Data Architect 9.0, Rational S/w Architect, DataModeler2.0, Visio Conceptual/Logical/Physical Modeling, Data Mart Design, Metadata Management

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

ETL/OLAP/Reporting Tools: Informatica PowerCenter 8.x/7.x, Business Objects, Xcelsius, FastLoad, MultiLoad, TPump, MicroStrategy 7.1.2, Query manager, DataStage7.5/7.0, BTEQ, AtanaSuite Expert

Hardware platforms/Operating systems: Solaris 8/6, Teradata 5550x/Appliance, HDFS, AIX5.3/5.1, Windows 2008/NT, Linux AS2.1

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

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

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton CA

Lead Teradata Application Architect/DBA

Responsibilities:

• Evaluated Data Models for performance analysis.
• Implemented changes to data models to in corporate new features for Compression, Indexes, Statistics, PPI
• Requirements gathering for new applications, Identified various facts and dimensions from the source systems, worked on conceptual models.
• Coordination between different teams across regions for smoother implementations.
• Developed ILDM, Logical and physical models after sessions with Architect/DBAs team.
• Optimized Performance of long running tactical queries
• Supported Applications to design physical implementations like table sizing, and security design, promoting database changes Development through Production
• Developed best practices for Performance monitoring, Query Tuning, Space Management.
• Providing guidance to less experienced team members, and trained them
• Worked with Teradata Support during Upgrade initiative to TD14
• Involved in setting up Hadoop Architecture/clusters for Ohio region, Primary & Secondary NameNodes, and JobTracker on HDFS.
• Used fsck proactively to maintain HDFS, and DFSadmin for administration tasks
• Enabled logging on hadoop to help Audits on Hadoop
• Used Chukwa/Claudera Manager to Monitor/Manage Hadoop stack

Environment: Teradata12, Teradata Manager, TARA, Teradata Administrator, BTEQ, DBQL, Hadoop, dfsadmin, TDWM, CA ERwin Data Modeler r8, Teradata5550/5450, Clarity, Teradata Viewpoint, Business Objects, HIVE, HDFS, MapReduce

Confidential, Milpitas CA

Lead Performance Architect/DBA

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.
• Gathered Viewpoint requirements, prepared the Design Document. Customized Viewpoint Portlets to provide better functionality, and customized ViewPoint was implemented.
• Set up Alerts & Metrics for monitoring purposes by Operations
• Created centralized application to report Performance Metrics and Capacity Utilization.
• Provided Capacity plans for applications. Optimized space requirements for applications

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

Confidential, Dallas, Texas

Teradata Performance Analyst

Responsibilities:

• Data warehouse was running out of capacity. Saved over $1.8 mil after utilizing the space efficiently by implementing the multi value Compression.
• 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 identify, get rid of unused data, and then reclaim huge free space
• Reduced execution time for jobs by working on the workload management.
• 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, Teradata Administrator, BTEQ, DBQL, ERWIN, PL/SQL, TDWM, Teradata5550, Teradata Manager

Confidential, Richmond VA

Teradata Application DBA/Architect

Responsibilities:

• Developed Physical Data Models after interacting with business and analyzing Logical data Models using ERWIN.
• 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. Reduced storage cost and gained performance
• Created MLOAD/FASTLOAD scripts to load data to Teradata.
• 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.
• Performed bulk data load from multiple data source like Oracle 10g to TERADATA, and used utilities like using BTEQ, FastLoad, MultiLoad, and FastExport.
• Utilized Tpump for daily alignment changes to update data
• Created and maintained DBQL historical tables, set up process for data collection and purging for ResUsage which provides valuable information of AMPs and Space usage
• Executed admin tasks using Teradata Manager such as workload activity, space utilization, statistics collection, and system performance monitoring.
• Managed security, space, jobs, tuning of loads, and backup/recovery using ARCMAIN
• Perform Teradata database performance testing and tuning for required data warehouse database changes, and determine proper indexes on newly created tables.

Environment: Teradata 12/Teradata v2r6, FastReader, Informatica PowerCenter 8.6, PL/SQL, Solaris2.8, Oracle 10g r2, Windows XP, BTEQ, BO XI r2, NetVault, Teradata 5550/2500

Confidential, Brisbane CA

Lead Teradata DBA/ Architect

Responsibilities:

• Developed logical and first - cut physical data models using ERWIN by interacting with business analysts. Worked on schema optimization.
• Data Source Mapping to the Retail Logical Data Model
• Implemented physical data models considering PPIs and Compression for the optimized performance and less storage costs
• Reduced execution time for long running queries using VISUAL EXPLAIN.
• Enhanced existing jobs/queries to run more efficiently and faster by working on factors like PPI, Skew, Joins, AJIs, workload management and indexes.
• Performed Unit testing, System Testing and Integration testing to validate the data.
• Created scripts using FastLoad, Multi-Load, TPump to load data into the Teradata EDW.
• 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 DB Indices have current Statistics.

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:

• Analyzing the source and the target systems to aid the implementation of the Enterprise Data Warehouse. Performed technical and functional requirements analysis towards the ETL architecture through interactions with business.
• 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
• Used ENDEVOR to implement Change Control management, and Priority Scheduler with UC4 to optimize the schedule for batch jobs.
• Involved in the archiving of Confidential ts data, and making accessible to Teradata
• Worked on DBA tasks like User creation, security, database creation, Primary/Secondary indexes and Scheduling/maintenance of jobs.
• Prepared downstream data using FASTExport
• Involved in Informatica 6.x ETL mappings/mapplets/workflows to load migrated data and execute converted transformation processes from legacy system and application databases to the new BO Universe based reporting.

Environment: Teradata v2r5.1, QueryMan, BTEQ, FastLoad, FastExport, Oracle 8i, UC4, MVS, JCL, SAS, Windows2003, ERWIN, Informatica PowerCenter / PowerMart 6.2, BOXI.

Confidential, Phoenix, AZ

Teradata Consultant/DBA

Responsibilities:

• Requirements gathering from multiple zones and consolidated for the corporate data
• Translated the logical data model to technical specifications
• Involved in creating Dimensions, Fact tables, Suggested data type.
• Standardized the ETL scripts catering to error table handling process, and load statistics collection using industry's best practices
• Responsible for testing and fixing various issues arising from data validation process.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD and Tpump. Created batch jobs using BTEQ
• Worked on exporting data to flat files using Teradata FEXPORT and to Oracle. Generated scripts to automate loading and unloading using AtanaSuite tool.
• Handled User Security, SqL Tuning, Space management

Environment: Teradata V2R5 (BTEQ, FLOAD, MLOAD, FastExport), T-Sql, winDDI, VISIO, TD Manager, Informix 9.30, Ascential DataStage 6.0, HP-UX 11.11, Queryman, AtanaSuite Expert

Confidential

PeopleSoft/Oracle DBA

Responsibilities:

• Optimizing the Performance of the applications including Oracle database instances
• Updating Financials application by applying the latest Patches & Fixes
• Resolving Production Issues related to App/Web/Database Servers & Process Scheduler
• Configuration of PIA, App Server Domains, and databases
• Database and Environment Refreshes

Environment: PeopleSoft Financials (GL, AP, AR), PeopleTools, Oracle8i, Solaris2.6, Weblogic6.1, Tuxedo6.5/Jolt1.2, Terminal Server, Config Manager, PSADMIN