SUMMARY:

Optimistic and assertive individual with 15 years achievement of consistently exceeding client expectations.In - depth experience in Enterprise Data Warehouse Architecture and implementation.Expertise in highly available Multi-system Teradata Enterprise data warehouse solutions,Data Warehouse Management and Administration. Good communication skills, combined with patience, determination and persistence to troubleshoot complex multi-system issues.

CORE COMPETENCIES:

• Teradata Multi-Systems Architecture and Implementation
• Teradata Database and System Administration
• Teradata Data Warehouse capacity planning
• Teradata Query Tuning and Performance Management
• Teradata Hardware and Software upgrades
• Data warehouse High Availability/Business Continuity solutions
• Teradata Backup Archive & Restore
• Network & Data Security for Databases
• Systems Programming and Teradata Database internals
• ESCON/FICON local and Channel Extender connectivity
• Team and Project Leadership

TECHNICAL PROFICIENCIES:

Platforms: Windows NT/2000/XP/2003, Linux-REDHAT 2.6.7 & SLES 9/10, MPRAS - System V, SOLARIS SPARC, HPUX-(PARISC,ia64), TDP connectivity using ESCON/FICON from IBM Z/OS.

Programming: C, C++, Visual Studio 6.0/7.0/7.1 (.net), COBOL, JCL, Pascal, Assembly & Shell script, Perl, TCP/IP

Tools: CISCO ACE/CSM, F5 (Network routing & Context switching), CA Autosys, Zeke Enterprise Scheduler, Protegrity Defiance DPS, Rational Rose, Rational ClearCase, Microsoft Active Directory, SunOne directory, System Debugger, gdb, VC++ Debugger, windbg, crash, make.

Database: Teradata V2R3/V2R4/V2R5/V2R6/V12/V13.0/V14.0, SQL Server, Oracle.

Teradata Database Administration Tools: Teradata Viewpoint, Teradata Multi-system Manager (TMSM), Teradata Viewpoint, Teradata Query Director/Unity (TQD), Teradata Active Systems Management (TASM), PDCR, Index Wizard, Statistics Wizard, Visual Explain, Named Pipe (NP)ARC, BEZVision, Visual Edge, Teradata Data Mover (TDM), Teradata BAR (TSM,NetBackup, Tape Storage& Data Domain), Baremetal Backup

Teradata Server Utilities: Database Window (DBW), DBS Control, CONFIG, RECONFIG, VprocManager, Database Initialization program (DIP), FERRET, CheckTable, ScanDisk, TableRebuild, Recovery Manager.

Teradata Application Tools &Utilities: BTEQ, SQL Assistant, Multiload, Fastload, FastExport, Tpump and Archive/Restore, TDP for Z/OS

BI/ETL Tools: Microstrategy, OBIEE, Composite, Datastage, Informatica, AbInitio

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Lead Teradata DBA

Responsibilities:

• Lead a team of 3 Teradata DBAs.
• Implemented Disaster Recovery solution for Teradata platform. The solution involved NetBackup using Data Domain, Data Mover, Riverbed Dedup and OC48 connectivity between the Production and the Recovery Data Centers.
• Implemented Teradata Software Upgrade from V2R6 to V14.0.This involved multiple NPARCs from the source to Target system. All legacy backup tapes on TSM were converted to NetBackup tapes. Redesigned TASM for V14.
• Implemented Hardware upgrade from NCR 5500 to NCR 6650.
• PMCP to PDCR conversion.
• Implemented Teradata Viewpoint. Migrated all Alerts and System Monitoring SOPs from Teradata to Viewpoint. Setup functional roles for various teams and conducted training sessions as part of rollout.
• Implemented Teradata Multi Systems Manager to monitor and maintain the Production and Recovery Teradata Ecosystems. This implementation also involved deployment of Data Mover and Teradata Unity Query Routing capabilities.
• Designed the Teradata Performance Management strategy. Defined the best practices around Statistics, Indexes, Compression, Roles & Profiles. Implemented MVC, PPI, Join Indexes, Statistics Management process.

Confidential, Mooresville, NC

Senior Teradata DBA

Responsibilities:

• Lead edge database warehouse research and MIS level advisement. Design data warehousing, multiple relational databases, operating systems and networking platforms.
• Design and Architect Business continuity solution for Teradata platform at Confidential ’s. Lead the periodic Disaster Recovery exercises to demonstrate the ability of recovering Teradata Enterprise data warehouse.
• Tune and optimize Teradata Applications. Implement Multi-Value compression, Provide recommendations for new Statistics, Primary Secondary and Partitioned indexes. Implement TASM changes.
• Design and Implement Teradata Multi-system environment for increasing server availability for business critical applications. Implement simultaneous loading processes, multi-system monitoring (Teradata Viewpoint, Teradata Multi-system Monitoring), load balancing tools (Teradata Query Director, CISCO CSM/ACE) and remote connectivity (Brocade ESCON/FICON extension)
• Serve as a database technical performer, researcher and facilitator by providing expertise for technical development of MIS staff.
• Interface with Teradata Global Support center in logging/tracking issues. Assist GSC with remote connectivity and provide requested information for analysis.
• Guide, collaborate and execute full system support, effective database utilization and implementations for a relational database.
• Provide escalation for lower-level, Systems Programmers, DBA's and Application Developers.

Confidential, Mooresville, NC

Teradata Systems DBA

Responsibilities:

• Provide Teradata DBA support. Create Teradata objects like Databases, Users, Profiles, Roles, Tables, etc. Modifying Databases, Users, Roles & Profiles.
• Provide 24X7 on-call support to the Confidential ’s enterprise Data Warehouse. Handle database restarts, release database utility locks, Analyze spool issues, Move space.
• Implement and maintain Secured User Authentication using TDGSS feature of Teradata Database RDBMS. Design and implement Protegrity Data Encryption solution for sensitive customer data on the enterprise data warehouse.
• Provide a focal point for integrating technical efforts on projects that involve multiple departments across the enterprise.
• Analyze and profile various workloads on Teradata using Teradata Active Systems Management. Implement BEZVision reporting software for an ongoing monitoring/re-profiling of workloads.
• Administer Teradata Demand Chain Management (TDCM) and Teradata Customer Relationship Management (TCRM) applications. Implement features, software upgrade and troubleshoot application issues.
• Plan, design and implement the Hardware and Software upgrade strategy for the Teradata database.

Confidential, NJ

Systems Analyst

Responsibilities:

• Study the client server architecture of Teradata Gateway and Teradata CLI(Call level interface).
• Study and implement GSS-API (RFC-2743) in Teradata.
• Build a new component TDGSSin Teradata database based on GSS-API.
• Study and implement AES(Advanced Encryption Standard) and Blow Fish encryption algorithms in encryption routines for Teradata authentication mechanism.
• Study and implement Diffie-Hellman Key exchange for Teradata authentication mechanism.
• Design and implement changes to Teradata Gateway product in order to support the new TDGSS component.
• Design and implement interface changes from Gateway to Dispatcher, PDE and AMP.
• Write PERL scripts to test the Teradata server before the Teradata client group implements the support for Network Security feature.
• Test each one of the client utilities for a secure connection establishment and encrypted data transfer to the Teradata V2R6 Server.
• Study the client server architecture of Teradata Gateway and Teradata CLI(Call level interface), ODBC Driver, Type 4 JDBC Driver.
• Design and implement changes to Teradata Gateway to support Protection against Denial of Services.
• Implement connection timer to prevent unauthorized users who send an assign request for a Teradata session and never send UserName/Password to complete the logon process thereby chewing up Server resources.
• Implement keepalive timer in Teradata Gateway to check for active connections on a periodic basis to prevent malicious users who establish numerous sessions exhausting the Teradata Server resources and deny access to authentic users.
• Write PERL scripts to test the Teradata server before the Teradata client group implements the support for this feature.
• Test the feature with all the Teradata client utilities which run based on CLI, ODBC driver and Type 4 JDBC Driver.

Confidential

Responsibilities:

• Study the Teradata database architecture and understand the Teradata Client - Teradata Gateway - Teradata DBS interface.
• Design and implement Multi-part data parcels in order to carry various pieces of LOBs.
• Design and implement changes to the Teradata Gateway in order to support LOB transfer from Teradata Client to Server and vice versa.
• Implement new states and events for the Gateway state transition machine to support LOBs.
• Design abort/disconnect handling during LOB transfers and provide the norms to Teradata client and Teradata DBS.
• Design and implement LOT (Large Object Transport) context in Teradata Dispatcher.
• Write PERL scripts to test the Teradata server before the Teradata client group implements the support for LOBs feature.
• Test Teradata client products for LOB transfer against V2R5.1 server.
• Study the implications of acquire large data segments of up to 1MB in the MPRAS kernel streams module.
• Design the Gateway-Client protocol to support 1MB messages.
• Design and implement changes to the Teradata Gateway to support large messages up to 1MB from server to client and vice versa.
• Write PERL scripts to test the Teradata server before the Teradata client group implements the support for 1MB request/response feature.
• Test Teradata client products against V2R5 server for this feature.

Confidential

Senior Software Engineer

Responsibilities:

• Analyze the functionality of the Teradata DBS and analyze the customer problems and provide solution for the discrepancies in the software.
• Fixed problems encountered by the customers in the areas or Dispatcher, AMP, PDE and Gateway.
• Worked on the problems involving design, logic, detail design changes, performance issues and other customer issues.
• Help the team in analyzing the problem and provide technical guidance to the team members as required.
• Contribute to Learning sessions, for providing other team members information on the solution and building long term expertise in the team.
• Visiting the customer sites during the upgrades and solving the customer problems. Visited SBC (St. Louis) site for upgrade to V2R4.
• Providing 24/7 On-Call support for Teradata customers.

Confidential

Software Engineer

Responsibilities:

• Design of the product.
• Documentation of the design.
• Implementation and testing of the product.
• Integration of the product with the existing Modules “Dealer Master” and “Returns Filing System”