SUMMARY

• Over 8 years of work experience in IT Industry in the Teradata Developer/performance Tuning/DBA, Informatica and Unix in Data warehousing stream.
• Thorough understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and Full Life Cycle.
• Experienced in building the semantic views.
• Experienced in Teradata utilities like BTEQ, Fast Load, Multi Load, Tpump, Fast Export And Teradata SQL.
• Experienced in Teradata performance tuning.
• Experienced with Teradata Tools like SQL Assistant, Teradata View Point, Teradata Manager
• Experienced in Administrative activities like creating users, roles and monitoring performance of queries.
• Through understanding in protection concepts like Fallback, RAIDs, Journals.
• Good Knowledge on backup and recovery operations.
• Good Knowledge in TERADATA data warehouse architecture.
• Experienced in Informatica Power Center (versions 9.x/8.x/7.x), Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, Star Schema Modeling, Slowly Changing Dimensions (Type 1, Type 2 and Type 3)
• Strong understanding of Performance tuning in Informatica and Databases. Experienced in loading data into Data Warehouse/Data Marts using Informatica
• Experineced using PDO ( Pushdown optimization ) in Informatica with Teradata
• Good Knowledge on Dimensional Modeling concepts Star Schema and Snow Flake Schema.
• Experienced with UNIX shell scripting and processing files.
• Having good knowledge about financial sector (Banking and Insurance)

TECHNICAL SKILLS

DATABASES: Teradata 13, Teradata 12, Teradata V2R6, Teradata V2R5,Netezza, Oracle 9i,SQL Server 2008

ETL Tool: Informatica 9.1, Informatica 8.6, Informatica 7.1, Datastage 8.7, Abinitio 2

Operating systems: Unix, Windows, Mainframes

Languages: UNIX Shell Programming, SQL, PL/SQL

Application Utilities: BTEQ, Multi load, Fast Load, Fast export, TPUMP

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Teradata DBA

Responsibilities:

• Working as Teradata developer and Application DBA.
• Performance tuning of Teradata code, analyzing the explain plan and determining which column/index/table needed to collect statistics, improved the performance up to 40% - 50%.
• Analyzed the skew ness and suggested the changes to Primary Index at the time of development to resolve the performance bottle necks.
• Involved in preparing Physical Data Model (PDM).
• Worked closely with Modelers while creating physical tables.
• Capacity planning based on project planning.
• Analyzed the space requirement and assigning and recovering.
• Database / Users / Other objects creations.
• Space assignment and recovering.
• Granted Access Rights between databases.
• Created and granted ROLES to the users as per the requirement.
• Reviewed DDL for the objects.
• PI Selection attributes.
• Published the DDLs into repository.
• Reviewed Objects and code as per the Teradata Best Practices.
• Stats recommendation and defining.
• Performance improvement suggestions and implementation.
• System monitoring completing daily basis incidents from multiple application teams.
• Designed and Developed Informatica mappings, mapplets, sessions and workflows for data Loads.
• Created design and mapping documents for ETL processes, defining the transformations and join conditions.
• Developed complex mappings involving joiners, lookups, routers and update strategy.
• Used parameter files, reusable sessions and worklets in the workflows.
• Parameterized all the queries using the unix scripts
• Used FTP connections to read files from various FTP Sources.
• Did migration of the code between environments having all the components in sync.
• Involved in unit testing and source code reviews.

Environment: Teradata 14.0, Informatica 9.1, unix, Control-M

Confidential, Richmond, VA

Teradata Lead

Responsibilities:

• Discussed the requirements with client.
• Attended the calls with data Architect to get the knowledge on data models.
• Involved in preparing the low-level technical design documents.
• Building the views in semantic layer.
• Created the Teradata bteq scripts, Fastload, Multiload and Fastexport scripts.
• Developed various Mappings, Mapplet and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Created the mappings using transformations such as the Source Qualifier, Aggregator, Expression, Look up, Filter, Router, Normalizer and Update Strategy
• Created Informatica sessions and workflows to use Pushdown optimization with Teradata.
• Created and defined DDL’s for the tables at staging area.
• Attended the defect analysis calls with testing team.
• Prepared the work status reports.
• Prepared the status reports and presenting to the client.

Environment: Teradata 13, Informatica 8.6.1, unix, Cognos 8

Confidential, SanJose, CA

Teradata Consultant

Responsibilities:

• Created the mappings using transformations such as the Source Qualifier, Aggregator, Expression, Look up, Filter, Router, Normalizer and Update Strategy
• Created and configured Worklets, workflows, and sessions to transport the data to target warehouse using Informatica Workflow manager.
• Mapplets and Reusable transformations were used to prevent redundancy of transformation usage and maintainability.
• Identified the performance problems.
• Identified the bottlenecks in the sql queries.
• Tuned the queries using tuning techniques.
• Tested the query performance with sample data in development environment.
• Tested in the test environment.
• Migrated the code to the production.
• Created Bteq scripts as per the requirement.
• Good experience of error handling in bteq scripts
• Handled job failures of fast load and tpump.
• Written reconciliation queries between oracle and teradata
• Fixing reconciliation issues.
• Scheduled sessions through $U tool.
• Loaded the data to Teradata using utilities.
• Provided Adhoc reports to users.
• Created CRs to change in database objects.
• Implemented permanent fixes through CR.
• Analyzed and modified the Unix shell scripts as per the requirement.

Environment: Teradata 12, Informatica 8.6.1,unix, Cognos 8

Confidential, Minneapolis, MN

Teradata Developer

Responsibilities:

• Understanding the Business Process and providing the interim solution to users.
• Retrieved data from Teradata database.
• Involved in SQL performance tuning and also handled critical spool space errors in database.
• Implemented quick fix and suggested a Permanent fix to the other Teams as per the Business need.
• Implemented Data fix on database as per the User Request for the Business.
• Generated the adhoc data as excel Reports to Users (through Teradta SQl).
• Done Route cause analysis on Production Support issues.
• Created UNIX shell scripts as per the business requirement.
• Developed simple & complex mappings using Designer to load dimension and fact tables as per STAR schema techniques.
• Implemented Informatica transformations such as Source Qualifier, Aggregator, Expressions, Look up Filters and Sequence Generator
• Updated slowly changing dimensions (SCDs).
• Received the sales data from stores and loaded that into data warehouse.
• Involved with migration team to fix the deployment issues in the Production environment.

Environment: Teradata V2R6, Informatica 7.1.3, unix, Microstrategy

Confidential

Teradata Developer

Responsibilities:

• Understand the Business Process and provided the interim solution to users.
• Interacted with Client to get the requirements.
• Used Erwin to change relations in data model.
• Created the Physical data model by using logical Data model.
• Implemented the Slowly changing dimensions to hold the historical data.
• Created Bteq scripts as per the requirement. Used most of the SQL functions.
• Created fast load and multi load scripts and tested in test environment and move the code to production.
• Extensively used Fast export to export the data and Multi load to import the data
• Pre processing of source files.
• Created unix scripts to call Teradata Utilities.
• Resolved the loader issues in Abinitio.
• Provided Adhoc reports to users.

Environment: Teradata V2R6, Abinitio, unix