SUMMARY

• More TEMPthan 12 years of experience in Teradata Enterprise Data Warehouse (EDW/ADW) and Data Mart.
• Experience working with clients of all sizes in the insurance, financial, Retail, healthcare, manufacturing industries.
• Expert in tuning complex Teradata SQL Queries including Joins, Correlated Sub queries, and Scalar Sub queries
• Good understanding of DataWarehousing concepts such as Third Normal form (3NF) as well as Dimensions Schema.
• Used Informatics’ features to implement Type II, III changes in slowly changing dimension (SCD) tables.
• Developed Teradata 13.10&14.0 features such as PPI, Character PPI, and Timestamp PPI, and Columnar Tables.
• Expert DBA skills in Teradata DBMS Administration, development and production DBA support, use of Teradata Manager, FASTLOAD, MULTILOAD, TSET, TPUMP, SQL, PDCR and ARCMAIN, TASM for workload management.
• Experience in planning and coordinating Disaster recovery solution for Teradata
• Working with BUSINESS OBJECTS/OBIEE team to optimize various report run times by applying various Confidential performance techniques such as Partitioning, JIs, AJIs, USI and NUSI.
• Implemented various Teradata recommended best practices while defining Profiles, Roles, Alerts, Multi - Value Compression, TARA GUI, Teradata Data Mover, and NetBackup.
• Created and implemented BAR strategy for the Confidential application and system databases.
• Did the Teradata SQL troubleshooting and fine tuning of scripts given by Analysts and developers.
• Created PPI for some of the monthly and daily tables to has a good performance on range queries with date constraints. Also created NUSI on PI column for the PPI tables has a good performance on queries with PI access.
• Implemented ETL level collection statistics for the Indexes and for some of the columns going to be involved in the constraints or join conditions.
• Experienced on implementing system securities Using LDAP and SSO.
• Defined account IDs, priority scheduler performance groups, and system date and time substitution variables in user and profile definitions.
• Responsible for the design and implementation of the entire DW Dimensional Model architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed the desired performance.
• Generated a Capacity management reports on analyzing the Spool/CPU/I/O/Usage resources and proactive monitoring to meet performance and growth requirements on PDCR Database.
• Having good experience in SUSE 11/ Linux operating system and command set as well as competence with shell scripting.
• Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
• Modification of views on Databases, Performance Tuning and Workload Management. Maintenance of Access Rights and Role Rights, Priority Scheduling, Dynamic Workload Manager, Database Query Log, Database Administrator, Partitioned Primary Index (PPI), Multi-Value Compression Analysis, Usage Collections and Reporting of ResUsage, AmpUsage, Security Administration Setup etc. and leading a team of developers for workaround with different users for different, complicated and technical issues.
• Involved in Implementation projects such as ORACLE to TERADATA DB/DW, and SQL SERVER to TERADATA conversion projects.
• Excellent understanding / noledge of Hadoop architecture and various components such as HDFS, Resource Manager, Node Manager, Name Node, Data Node programming paradigm.
• Hands on experience in installing, configuring, and using Hadoop ecosystem components like Hadoop Map Reduce, HDFS, HBase, Oozie, Hive, Sqoop, Pig, and Flume.
• Having Good noledge on NoSQL database MongoDB and Cassandra.

TECHNICAL EXPERIENCE:

TechnologyDatabase: Teradata 13.10, Teradata 14.0/14.10, Teradata V2R5, V2R6, 13.00.01.19 and V2R12, DB2, Oracle 9i, Vsam

Hadoop / Big Data: HDFS, MapReduce, Hive, Pig, HBase, Sqoop, Flume, Oozie, Zookeeper, MongoDB, Cassandra

Reporting Tool: Business Objects XI, OBIEE, MicroStrategy

ETL: Informatica 9.0.1, Confidential ETL Mload, Fload, Xport, Bteq, Tpump, Jcl, SQL, Cobol, SPL, PL/SQL, JAVA, TSO, MVS, ISPF, CA7

Operating Systems: Windows 2000, SUSE 11 LINUX, UNIX: Sun Solaris, HP-UX

Methodologies: Business Process, Relational Data Modeling, Logical Data Modeling, Object Oriented Modeling, SQL Assistant, Object Relational Modeling, and Physical Database Design, Power Designer 16, Tset, TPT, Visual Explain, Workload Manager, Teradata Priority Scheduler, Teradata Visual Explain, Teradata Manager & Administrator, Net vault, TASM, Confidential Data Mover, Viewpoint, PDCR, SWS, TVI, BAR, SLES, TARA GUI, TDB

Backup Technologies: ABU, Net vault/Netbackup GUI tools, Bar scripts, Data Mover, Tara

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Teradata DBA/Developer

Responsibilities:

• Involved in Physical Data Modeling, and deployed new DDL’s in Teradata DEV servers.
• Deployed DDL’s in Stage and Integration databases in all the Servers.
• Created a Good Primary Index based on SQL Join access frequency.
• Created a Cover views on all Base tables.
• Developed Semantic View logics for Business team.
• Involved in Collect Stats task for all new DDL’s.
• Involved in MVC Compression tasks.
• Involved in Table Cleanup activities in Non-Prod servers.
• Refresh PROD data into a Non-Prod Servers on Monthly basis.
• Highly experienced in SQL performance tuning/SQL optimization and debugging of ETL Informatica process.
• Handled Teradata performance SQL Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Involved in Teradata 14.10/14.0 DBA activities and implemented all new features such as Character based PPI, and Timestamp PPI, and Temporal tables, and columnar tables.
• Implemented diff types of join Index’s, which halps optimizer to generate better Explain plans, for complex join conditions.
• Developed Semantic views, and implemented diff types of Indexes such as NOPI, UPI, NUPI, USI and NUSI, PPI, and JI’s, and AJI’s (Multilevel Join Indexes with compressed).
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
• Performed Space Management for Perm & Spool Space.
• Generated CPU and DISK IO usage capacity reports thru DBC queries on weekly.
• Handled USER management requests such as creating new Users& Profiles, and Roles.
• Teradata 13.10 Viewpoint is used to monitor the system performance when it is in load.
• Debugging& Tuned the Complex end user written queries for better performance.
• Handled Space Management.
• Designed and implemented the Physical Data Model in Teradata thru ERWIN tool.
• Defined the different access paths (i.e, UPI, NUPI, USI, NUSI, PPI, JI...) based on access frequency of the object.
• Developed the DDL's as per Teradata standards in terms of performance gain.
• Set upped diff types of Backup jobs such as Daily/Weekly/Monthly, and Full/Online backup jobs in ABU GUI Tool.
• Developed BAR scripts for new databases and tables thru ABU GUI tool.
• Having solid experience with NPARC, which handles the data movement between two diff systems using a named pipe instead Tape for faster.
• Configured Teradata ABU for handling the Multistreams backup jobs.

Environment: Teradata 14.10, SQL, DBQL, Informatica 9.5, Data Mart Views, Semantic Views, Index, Viewpoint, Linux, TASM, Admin Tool, ABU GUI (Arcmain, Restore, Copy), BO, (Teradata ELT Utilities - Multiload, FastLoad, LDAP, SQL Assistant, TSET, BTEQ, Tpump), DBA Tools (SWS, TVI, BAR, SLES), TPT, Workload Manager, Join Indexes, Erwin.

Confidential, Sacramento, CA

Teradata DBA

Responsibilities:

• Performed performance Tuning and Administration activities of Teradata.
• Involved in the EDW complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Setup and configured the Teradata Viewpoint portals (thru Admin option) for new systems such as Prod, Test, and Dev servers.
• Handled and performed Teradata Ferret utilities such as Packdisk, Scandisk, and freespace to release the unused spaces across cylinders thru Teradata Manager.
• Installed, and configured all Teradata13.10/14.0 tools such as SQL Assistant,TeradataAdmin, Viewpoint, and Visual explain, and stats wizard.
• Handled Workload monitoring using TASM.
• Highly experienced in SQL performance tuning/SQL optimization and debugging of ETL Informatica process.
• Handled Teradata performance SQL Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Involved in Teradata 13.10/14.0 DBA activities and implemented all new features such as Character based PPI, and Timestamp PPI, and Temporal tables, and columnar tables.
• Implemented diff types of join Index’s, which halps optimizer to generate better Explain plans, for complex join conditions.
• Tuned & developed a semantic views for - Micro strategy report generated SQL’s.
• Wrote ETL Informatica scripts to load the data in Teradata DW.
• Developed Unix/MVS Teradata Scripts to load source systems data into Target DW.
• Performed Space Management for Perm & Spool Space.
• Generated CPU and DISK IO usage capacity reports thru PDCRDATA queries on weekly.
• Involved in migration of ORACLE data into TERADATA DB/DW.
• Handled USER management requests such as creating new Users& Profiles, and Roles.
• Teradata 13.10 Viewpoint is used to monitor the system performance when it is in load.
• Debugging&Tuned the Complex end user written queries for better performance.
• Handled Space Management.
• Designed and implemented the Physical Data Model in Teradata thru ERWIN tool.
• Developed the DDL's as per Teradata standards in terms of performance gain.
• Developed BAR scripts for new database’s and tables thru Netbackup/Netvault GUI tool.
• Having good experience with Backup and Recovery using Teradata ARCMAIN in Net Vault.
• Having solid experience with NPARC, which handles the data movement between two diff systems using a named pipe instead Tape for faster.

Environment: Teradata 13.10, SQL, Index, Viewpoint, PDCR DATA/INFO, ARC NET VAULT (Arcmain, Restore, TaraGui, Datamover), Microstrategy, Semantic Views, (Teradata ELT Utilities - Multiload, FastLoad, SQL Assistant, PMON, TPT, TSET, TASM, BTEQ, Tpump), Informatica 9.0.1, DBA Tools(SWS, TVI, BAR, SLES), TPT, Workload Manager, Data Mover, Join Indexes, Power Designer 16, Microsoft Products, ISPF, TSO, Java, Erwin.

Confidential, Atlanta, GA

Teradata DBA

Responsibilities:

• Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
• Interacted with Clients, Data Modeler and Data Analyst to develop the Logical and Physical Design for a table.
• Created users with different profiles and Roles to control the access on the system.
• Written several Teradata BTEQ scripts to implement the business logic.
• Moved database schema changes to stage/production database.
• Extensively worked on the Performance Tuning of mappings, ETL Procedures and process
• Extensively used FEXP utility to export and load data to/from Flat files
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Experienced with Backup and Recovery using Teradata ARCMAIN.
• Teradata PMON is used to monitor the system performance when it is in load.
• Experienced in Teradata Manager which is used to create Alerts, Monitor system.
• Worked on loading data from EDW and Supporting Subject areas using Ab Initio.
• Familiar with Teradata Database Query Manager used mainly for query logging and access logging.
• Experienced in using DBS Control Flags.
• Involved in documentation of requirements and technical design..
• Coordinated with BO developer to create several OLAP cubes for the dimensional analysis.
• Conducted user trainings to halp them understand the Presentation Layer structures and available Cubes and Reports for analysis.
• Created complete metadata (data lineage) from ETL to Reporting and loaded to Enterprise Metadata Repository.
• Configured Teradata TARA server for handling the Multistreams backup jobs.

Environment: Teradata 13.1, Informatica 9.5, Hyperion, Viewpoint, Linux,, Admin Tool, Business Objects, (Teradata ELT Utilities - Multiload, FastLoad, LDAP, SQL Assistant, TSET, BTEQ, Tpump), HP ALM, PVCS, TPT, Workload Manager, Join Indexes, Erwin.

Confidential, Woonsocket, RI

Teradata DBA

Responsibilities:

• Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Responsible for solving the issues from EIW customer support on 24x7 On-call issues.
• Involved in Teradata 13.00.01 DBA activities in the tests, such as creation of users, spool, temporary, permanent space. Checking the tables skewing, compression.
• Performance Tuning, Query optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
• Performed Space Management for Perm & Spool Space.
• Created users with different profiles and Roles through Stored Procedures, to control the access on the system.
• Supported Business Object report generated SQL’s.
• Handled Netvault/Netbackup Backup and Recovery tasks, and Tape Management, and Drive issues.
• Used Teradata Manager& Administrator to Monitor and Manage Teradata Databases.
• Involved in various Operational Teradata DBA activities on daily basis.
• Teradata 13 Viewpoint is used to monitor the system performance when it is in load.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ in Mortgage applications.
• Interacted with Clients, Data Modeler and Data Analyst to develop the Logical & Physical Design for the new tables.
• Worked on TSET tool, to get the Explain Log, and send it to Teradata team to analyze it.
• Implemented the Work Orders in Production Systems.
• Experienced with Backup and Recovery using Teradata ARCMAIN in Net Vault.
• Build tables, views, UPI, NUPI, USI and NUSI, PPI.
• Handled Workload monitoring using TASM.

Environment: Teradata 13.1, UNIX, Viewpoint, Teradata Administrator& Manager, PDCR DATA/INFO, DBQL, NET VAULT/NETBACKUP (Arcmain Backup Restore, TaraGui, Datamover), (Teradata ELT Utilities - Multiload, FastLoad, PDCRDATA, SQL Assistant, PMON, TSET, TASM, Visual Explain, FastExport, BTEQ, Tpump), Informatica 9.0.1, DBA Tools(SWS, TVI, BAR, SLES), ETL JCL, MVS, ISPF, TSO, Abi nitio, ArcMain, Confidential SQL, Microsoft Products, Linux, DB2, Erwin.

Confidential, Medicaid, NY

Teradata DBA/Developer

Responsibilities:

• Involved in DBA activities in the tests, such as creation of users, spool, temporary, permanent space.
• Checking the tables skewing, table compression, and Index recommendations.
• Used Teradata Manager& Administrator to Monitor and Manage Teradata Databases.
• Performed application level DBA activities creating tables, indexes, monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
• Suggested some tuning of DBS control parms such as MaxLoadTasks, DBSCacheThr, MaxParseTreeSegs, ReadAheadCount, FreespacePercent, Cylinderssavedforperm, DefragLowCylProd, MiniCylPackLowCylProd etc.
• Designing Archival Jobs, considering archival resources like the number of Media Servers, tapes, various limiting factors of Transmit/receive of data to the media in Netvault.
• Capacity planning and proactive monitoring to meet performance and growth requirements on PDCR Database.
• Debugged MicroStrategy queries, and enhanced the tuning tips.
• Monitoring Production system whenever in need and controlling Online and Batch jobs.
• Converted DB2 Logical data models into Teradata Logical and Physical database models.
• Interacted with Clients, Data Modeler and Data Analyst to develop the Logical& Physical Design for tables.
• Performed bulk data load from multiple data source SQL SERVER, LEGACY SYSTEM to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
• Extensively used Teradata system Priority Schedule in controlling the load of the system.
• Worked on exporting data to flat files using Teradata FEXPORT.

Environment: Teradata 13/V2R6, Teradata Manager, Teradata Administrator, TSET, TPT, TDWM,, NETVAULT(TARAGUI, Archive*Restore), (ETL tools) Multiload, FastLoad, PMON, FastExport, BTEQ, JCL, Viewpoint, TASM, Tset, TPT, Confidential Data Mover, PDCRDATA, DB2, Tpump, Power Designer 16, MicroStrategy, Priority Scheduler, Ldap, DBQL, PMCP, Visual Explain, Zeke Schedule, Unix-AIX, Jcl, Mvs, TSO,ISPF, Confidential sql, ERWIN.

Confidential, MI

Teradata DBA/Developer

Responsibilities:

• Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
• Interacted with Clients, Data Modeler and Data Analyst to develop the Logical and Physical Design for a table.
• Created users with different profiles and Roles to control the access on the system.
• Written several Teradata BTEQ scripts to implement the business logic.
• Moved database schema changes to stage/production database.
• Extensively worked on the Performance Tuning of mappings, ETL Procedures and process
• Extensively used FEXP utility to export and load data to/from Flat files
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Experienced with Backup and Recovery using Teradata ARCMAIN.
• Teradata PMON is used to monitor the system performance when it is in load.
• Experienced in Teradata Manager which is used to create Alerts, Monitor system.
• Worked on loading data from EDW and Supporting Subject areas using Ab Initio.
• Familiar with Teradata Database Query Manager used mainly for query logging and access logging.
• Developed BUSINESS OBJECTS (UNIVERSE) Desktop Intelligence&Crystal Reports to DOH users.
• Experienced in using DBS Control Flags.
• Involved in documentation of requirements and technical design.

Environment: Teradata V2R5, Teradata Manager, (ETL Mf Jcl), Multiload, FastLoad, PMON, TSO, ISPF, SAP Business Object Universe, Confidential Data Mover, Tset, FastExport, MicroStrategy, ViewPoint, Tset, TASM, Sql, BTEQ, Tpump, DBA Tools(SWS, TVI, BAR, SLES), Mpras, W2k, Linux.

Confidential, MI

Teradata Developer

Responsibilities:

• Used Teradata manager to query Teradata RDBMS status and CPU utilization in reports and graphs.
• Maintain and Tune Teradata Production and Development systems
• Worked extensively with Teradata utilities BTEQ, Multiload, Fastload, TPUMP, Fastexport.
• Performance Optimization
• Measuring and monitoring the performance of the 16 node Teradata system with new Teradata file system having WAL feature embedded.
• Designing and implementing the Physical Data Model. Received the Physical Data Model DDL from Erwin.
• Measuring performance of the systems with different configurations. Configuration of the systems like changing number of AMP per node, Changing number of Clusters, Changing number of Clique, Changing number of nodes in a clique.
• Capacity planning and proactive monitoring to meet performance and growth requirements
• Performance Tuning and Administration activities of Teradata
• Experienced in working with Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export.
• Teradata PMON is used to monitor the system performance when it is in load.
• Disk array failures were recovered using AWS and SIMPLICITY .
• Recovering the database/tables whenever we has disk drive failures. And used most of the recovery scenarios to recovery the data of the Teradata System.
• Experienced with Backup and Recovery using Teradata ARCMAIN.
• Upgrading the Teradata Versions.
• Worked on patch upgrades of the Teradata systems.
• Extensively used Teradata system Priority Schedule in controlling the load of the system.
• Created users with different profiles and Rules to control the access on the system.
• Experienced in Teradata Manager which is used to create Alerts, Monitor system.
• Familiar with Teradata Database Query Manager.
• Experienced in using DBS Control Flags.
• Developed Universe (Metadata) WEBI Reports in SAP Business Objects.
• Maintained Teradata system with all UNIX, LINUX and WINDOWS platforms.
• Well familiar with System Administration activities and certified in Linux operating system.

Environment: Teradata Manager, Teradata V2R602/V2R611/V2R620, SQL Assistant, (ETL Abinitio tool), Multiload, FastLoad, Tset, PMON, Visual Explain, BUSINESS OBJECTS INFOVIEW, FastExport, BTEQ, Tpump, Confidential sql, Mpras, W2k, Linux, Erwin.

Confidential

Teradata/ETL Developer

Responsibilities:

• Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Involved in the complete re-design of the process flow, starting with design considerations, technical specification and source to target mapping.
• Worked on loading of data from several flat files sources to Staging using Teradata TPUMP, MLOAD, FLOAD and BTEQ.
• Interacted with Clients, Data Modeler and Data Analyst to develop the Logical and Physical Design for a table.
• Generated the OLAP Reports in Cognos to the End Users.
• Created users with different profiles and Roles to control the access on the system.
• Written several Teradata BTEQ scripts to implement the business logic.
• Generated the Teradata Fload, Mload Scripts in Unix Operating Systems region.
• Moved database schema changes to stage/production database.
• Extensively worked on the Performance Tuning of mappings, ETL Procedures and process
• Performed bulk data load from multiple data source (Unix, legacy systems) to TERADATA RDBMS using BTEQ, Fastload, Multiload and TPump.
• Experienced in working with Teradata ETL tools like Fast Load, Multi Load, Tpump and Fast Export.
• Used MVC (Multi Value compression) tool for sizing of the database.

Environment: Teradata/V2R5, Explain, NetVault, Db2, Query man, Unix, Confidential Sql, RDBMS, Index, View, CA7, Oltp, Mf Jcl, Autosys, Erwin, File Manager.