SUMMARY

• Around 8 years of experience in IT industry, have more experience in Data Warehousing, Monitoring, Performance Tuning, Capacity Planning and Migration activities, TPT, BTEQ, Teradata SQL assistant, Multi load, Informatica, Fast Load, Data modeling, SAS and Fast Export, Oracle, Autosys, MS SQL Server, TSET,ODBC and ETL tools.
• Have more experience in Teradata Database Design, Application Support, Tuning & Optimization, User & Security Administration, Data Administration and Setting up the Test and Development environment.
• Performed DBA functions like database creation and setup, user management, system performance, resource monitoring, database backup using archive and restore (BAR).
• Have more knowledge in Teradata Architecture and Query Analyzing, Data modeling, performance tuning and testing.
• Experience in different database architectures like Shared Nothing and Shared Everything architectures. Very good understanding of SMP and MPP architectures.
• Involved in Unit Testing, Integration Testing and preparing test cases.
• Have great Experience in Backup and Restore (BAR) methodologies. Design, implement and co - ordinate all back-up and restore strategies.
• Have Good experience in Teradata RDBMS using FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT, Teradata SQL,PMON and BTEQ Teradata utilities and MLDM.
• Have Written BCP/FAST LOAD scripts to load the large size tables from SQL Server to Teradata EDW.
• Experienced in Informatica Power center Repository from 6.2 to 8.1.1
• Have strong experience with ETL tool Informatica 8.1/7.1/6.2.
• Experience inExtraction,TransformationandLoading (ETL), Data modeler data from various sources into Data Warehouses using Informatica Power Center(Repository Manager,Designer,Workflow Manager, andWorkflow Monitor).
• CreatedMappingsto load data from various sources using complex transformations likeLookup,Joiner, JIs, AJIs, PPIs,(SLPPI,MLPPI),Sorter,Aggregator,Update Strategy,FilterandRoutertransformations.
• Expertise in using Secondary indexes, PPI, Join indexes, hash indexes.
• Expertise in Teradata Parallel Transporter and scripting at Windows/Unix servers.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Hands on experience in monitoring and managing varying mixed workload of an active data warehouse using various tools like Teradata Workload Analyzer, Teradata Dynamic Workload Manager and Teradata Manager .
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Have experience in Data Warehousing concepts including in Data mart and Data Mining using Dimension Modeling (Star Schema and Snow-Flake schema Design)
• Expert in building ER Diagrams and analyzing the relationships among database objects.
• Proficient in analyzing business processes requirements and translating them into technical requirements.
• Experience with Teradata Unity system in the environment.
• Involved in production support activities 24/7 during on call and resolved database issues.
• Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.
• Proficient in installation and troubleshooting of TTUs on client workstations.
• Highly enthusiastic, self-motivated and rapidly assimilate new concepts and technologies.

TECHNICAL SKILLS

RDBMS: Teradata V2R6/R12/R13,Teradata 14Oracle 9i/ 10g/11g, MS SQL Server.

Programming: C, Java, & T-SQL

Operating System: MS DOS, Windows NT/ 2000/ XP, Solaris and UNIX

Tools: & Utilities: Teradata SQL Assistant,, PMON, BTEQ, MLOAD, FASTLOAD, FAST EXPORT, Shell scripting, Informatica,, Tpump, Teradata Parallel Transporter (TPT), Teradata Visual Explain, TD Index Wizard,Teradata Index Wizard, NetBackUp, SAS, Data modeling,SVN,ERWIN,LDMS.

Database Tools: Oracle 9i, Teradata Queryman 7.2, Teradata v12.0, SQL *plus

Web Technologies: HTML, HTML5,CSS,XHTML

Other: Microsoft products (word, excel, power point, outlook).

PROFESSIONAL EXPERIENCE

Confidential, IL

Teradata Developer

Responsibilities:

• Collaborated closely with client managers, architects, PSF, PMON, Informatica and DBA’s and business users.
• Developing the queries using Teradata SQL Assistant, Teradata database query Log.
• Involved in System Maintenance /Database upgrade/ patch Upgrades - Planning, Scheduling, Co-ordination, Communications, Implementation, and Testing.
• Involved in Backup / Restore (BAR) - Performing backup, recovering and monitoring, Implemented Online Archive feature for certain databases which had ETL conflicts.
• Provide exceptional Teradata Database Administration, Surrogate Key Monitoring, Hashing technique for Index generation Teradata statics wizard and Maintenance services for the customer’s production environments.
• Managing database space, allocating new space to database, moving space Data modeling between databases as need basis and worked to keep space sync between databases in our dual active systems.
• Involved in performance tuning of the SQL queries and the reports.
• Helping in maintenance work related to reports.
• Involved in writing scripts for loading data to target data warehouse for BTEQ, FastLoad, Data modeler and MultiLoad, PMON.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using BTEQ, FastLoad, TDQM, Autosys, SAS and Fast Export.
• Involved in writing the scripts using Teradata SQL as per requirements.
• Did error handling and performance tuning in Teradata Queries and Utilities
• Extensively usedInformatica Power Center 7.1,an ETL tool toextract,transformandloaddatafrom remote sources to DW.
• Collect data on the current system configuration, resource usage, status of an individual Access Module Processor (AMP), Parsing Engine (PE), node and also the resource usage and status of an individual session.
• Involved in migration(Data Copy) of files.
• Written several Teradata BTEQ scripts to implement the business logic.
• Created volatile tables, views, macro and stored procedure.
• Extensively worked in capacity planning.
• Responsible for populating warehouse-staging tables.
• Performed Unit testing, Integration testing and generated various Test Cases.
• Performed Data analysis and Data validations.
• Involved in writing, debugging SQL for TD load utilities and ERWIN.
• Performed developing/creating TD DDL for tables, multi table view, denormalization, index selection.
• Ensured data integrity and referential constraints for accurate database operations.
• Support continuous extract, transform, and load functionality across systems using INFORMATICA.
• Involved in System Maintenance /Database upgrade - Planning, Scheduling, Co-ordination, Communications, Implementation, and Testing.
• Responsible for Performance Reports (PDCR) -Daily, Weekly, Monthly and Quarterly reports generation, review and presentation.
• Query optimization - explain plans, collect statistics, data distribution across AMPs, Primary and Secondary indexes, locking etc.
• Transferring data between production and development environment.

Environment: Teradata 13.10, Teradata SQL Assistant, BTEQ/BTEQWin, FastLoad, MultiLoad, FastExport, Tpump, View point, Data modeling Oracle 10g, PL/SQL, UNIX, IBM Rational clear case, Informatica Power center 9.1.0, Windows NT/2000,NCRs world mark 5200 MPP.

Confidential, NC

Teradata Developer

Responsibilities:

• Space usage analysis, and recommendation regarding the utilization of space.
• Index Analysis, Statistics Analysis and selection and implementation of the indexes and Statistics.
• Compression analysis and choosing the best candidates for compression.
• Involved in workload balancing through TASM, Data modeling.
• Performed query optimization and assisted ETL developers and users by analyzing DBQL data, EMC Data Domain, NETBACKUP explain plan and join strategy and Partitioning large tables to improve performance of SQL.
• Using the workload management tool and methodology to manage the system workload to help business team to meet SLA.
• Monitoring the sessions and their resource usage.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FAST EXPORT, MULTI LOAD, Data modeling and DataStage.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Heavily involved in System Performance activities such as: Workload management, TASM, Job Scheduling, Priority /Resource allocation, Query Performance Tuning and Optimization.
• Creation of Mload Scripts and facilitating in automation of the process of creation of the Mloads.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, Informatica, skewed redistributions, join order, optimizer statistics, physical design considerations etc.
• Involved heavily in writing complex SQL queries based on the given requirements.
• Created an archive process that archives the data files and FTP to the remote server.
• Created reports using BTEQ scripts reporting functionalities and FastExport for the end user.
• Involved in Backup / Restore (BAR) - Performing backup, recovering and monitoring, Implemented Online Archive feature for certain databases which had ETL conflicts.
• Managing database space, allocating new space to database, moving space between databases as need basis.
• Addressing day-to-day user’s issues such as resetting passwords, unlocking used id’s, working on permission issues.
• Created a cleanup process for removing all the Intermediate temp files, Data modeler that were used prior to the loading process.
• In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Overall Production Support for Teradata system.
• Deliver new and complex high quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
• Worked on creating and managing the partitions.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Performed database health checks and tuned the databases using Teradata Manager.
• Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics & secondary indexes.

Environment: Teradata V2R12, SQL, BTEQ, FastLoad, MultiLoad, FastExport, Visual Explain, Teradata SQL assistant 6.1, Decision Analyst 2.8/3.0, Medstat Advantage Suite 2.8/3.0, Oracle 9i/10g, Solaris 8, AIX 5.3, Windows XP/2000, MKS Source Integrity 8.6, NCRs 5400E MPP.

Confidential, Woodbury,MN

Teradata Developer

Responsibilities:

• Worked with the Teradata Query man to interface with the Teradata.
• Built tables, views, UPI, NUPI, USI and NUSI.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD Surrogate Key and TPump.
• Worked on exporting data to flat files using Teradata FASTEXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes).
• Transferred data between heterogeneous sources.
• Developed BTEQ scripts for Teradata.
• Responsible for tuning the performances of Informatica mappings and Teradata BTEQ scripts.
• Worked with DBAs to tune the performance of the applications and Backups.
• Creation of Data bases and users. Space and User maintenance on dev machine.
• Used FastLoad for loading into the empty tables.
• Involved heavily in writing complex SQL queries Hashing technique for Index generation based on the given requirements.
• Designing the ETLs and conducting review meets.
• Interacted with people from various teams in the Project like Oracle/Teradata DBAs', EMC Data Domain, NETBACKUPMaestro Schedulers.
• Spec. Creators, Reporting, Unix etc. to aid in the smooth functioning of the Project flow.
• Exported the data into from UNIX to Mainframe for backup.
• Developed the triggers to handle history and audit data for production environment.
• Performance changes to allow fast handling of transaction processing related request (plan caching).
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Created Understanding documentation and Release Testing documentation on the tickets handled, and documented the issues found in a central repository.
• Involved in Data mining, Data modeling through Teradata miner and in database optimization.
• Involved in the code reviews prepared by the teams.
• Analyzing production support documents and finding the feasible time to run their jobs.

Environment: Teradata V2R12, SQL, BTEQ/BTEQ Win, Fast Load, Multi Load, Fast Export, Visual Explain, Teradata SQL assistant 6.1, IBM OS/390, TSO/ISPF, MVS utilities, JCL, Windows XP/2000, NCRs world mark 5200 MPP systems with 318 Nodes.

Confidential, MO

Teradata Developer

Responsibilities:

• Developed BTEQ scripts for Teradata.
• Performed Unit testing, Integration testing and generated various Test Cases.
• Built and Deploy scripts are done.
• Writing UNIX Shell Scripts for processing/cleansing incoming text files.
• Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics.
• Participating in the application architectural review meetings and performing the code review.
• Configured View Point in setting up alters to page DBA for events such as node down, AMP down, too many blocked sessions, high data skew, database space utilization etc.
• Setup AMP usage collection, canary query response, spool usage response etc.
• Managing database space, allocating new space to database, moving space between databases as need basis.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Generated periodically space utilization reports on prod /test env.
• Developed the triggers to handle history and audit data for production environment.
• Providing Spool space, Perm space Jobs wise and User wise usage report whenever required.
• Generated various system usage reports such as peak CPU/IO usage, CPU parallel efficiency to make sure all AMPS are running parallel, CPU skew, IO skew, CPU ideal etc to management team.
• Configured TASM to change resource allocation based on priority.
• Increased performance by 35-40% in some situations.
• Extracted from OLTP system to dump files and upload to data warehouse using FastLoad, MultiLoad and TPump.
• Exported data to flat files from database using Fast Export, Data modeling.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, Informatica.
• Created Primary index, secondary index and PPI.
• Involved in peer to peer reviews.
• Created Teradata External loader connections such as Upsert and Update, while loading data into the target tables in Teradata Database.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Analyzed and provided solutions for all database related issues.
• Involved in understanding Business and data needs and analyze multiple data sources and document data mapping to meet those needs.
• Proven client-facing skills, outstanding project success record, communication and collaboration excellence
• Developing the queries using Teradata SQL Assistant.
• Used IBM Rational Clear Case as a version tool.
• Worked on Tivoli Work Scheduler.
• Supported24 X 7 Production environment.

Environment: Teradata V2R12, Teradata SQL Assistant, BTEQ/BTEQWin, FastLoad, MultiLoad, FastExport, Tpump, Visual Explain, Queryman, Oracle 8i, PL/SQL, UNIX, IBM Mainframes, Windows NT/2000,NCRs world mark 5200 MPP.

Confidential

ETL developer

Responsibilities:

• As a Technical Team Member, involved in identifying thebusiness user requirementsand development of different modules andPL/SQL procedures.
• Extensively usedInformatica Power Center 7.1,an ETL tool toextract,transformandloaddatafrom remote sources to DW.
• Worked extensively on variousactive&passive transformationsandcreated complex mappingsand tuned them for better performance.
• UsedODBCto connect to the target Oracle database.
• Extensive Use ofSQL Overridesandsubstitutedthem in place ofmultiple transformations.
• Usedtransformationsfordata joins,complex aggregations.
• Responsible for improvingqueryandsession performance.
• Created,launched&scheduled sessionsandbatchesusingServer manager.
• Define mappingsslowly changing dimensionsandslowly growing Targets.
• PerformedUnit testing.

Environment: Oracle 8i, PL/SQL, Informatica Power Center 7.1, Windows, SQL plus, Win Runner, Toad.