PROFESSIONAL SUMMARY:

• Over 7 years of IT experience with extensive experience in Data warehousing, Data Analysis, Reporting, ETL, Data Modelling, Development, Maintenance, Testing and Documentation.
• Excellence in teh implementation of Data Warehouse and Business Intelligence using ETL tools like Informatica Power Center (versions 9.x/8.x) PowerMart, PowerExchange (version 9), and Power Analyzer
• Experienced in TuningInformaticaMappings to identify and remove processing bottlenecksAutomation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man
• Expertise in working inTeradata V2R12.x systemsand used utilities likeMultiLoad, FastLoad, FastExport, BTEQ, TPump, Teradata SQL
• Expertise in Teradata Database design, implementation, and maintenance mainly in large - scale Data Warehouse environments.
• Proficient in coding and optimizing Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
• Teradata consultant with experience in Teradata Physical implementation and Database Tuning
• Strong experience in coding and debugging Teradata utilities like Fast Load, MultiLoad and Tpump for loading data from various sources into Teradata and data export using Fast Export.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling
• Proficient in converting logical data models to physical database designs in Data warehousing Environment and in-depth understanding in Database Hierarchy, Data Integrity concepts and Data Analysis
• Proficient in writing complex SQL, stored procedures, functions for ETL processing.
• Experience in working with TOAD and ERWIN.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support
• Maintaining and Supporting during Assembly/Integration Test, QA, UAT, and Production for Issues/Bug fixes/Defects.
• Experience in writing UNIX korn shell scripts to support and automate teh ETL process
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring teh data meets teh business requirements.
• Involved in Unit testing, System testing to check whether teh data loads into target are accurate.
• Experience with Business Intelligence tools like Cognos 10,8.4
• Involved in troubleshooting of Informatica jobs and addressing issues like performance tuning and enhancements
• Highly motivated and goal-oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies

TECHNICAL SKILLS

ETL Tools: Teradata SQL Assistant, BTEQ, TPT, FastLoad, MultiLoad, FastExport, TPump, Informatica Power Center 6.x/7.x/8.x, Ab Initio

Languages: C, C++, UNIX Shell Scripting, SQL, PL/SQL, HTML, DHTML, Visual Basic

Applications: MS Word, Excel, Outlook, FrontPage, PowerPoint, MS-Vis

Databases: Teradata, Oracle 8i/9i/10g, DB2, MS SQL Server, Sybase

Data Modeling: Erwin 4.x

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Sr. Teradata Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand requirements.
• Converted business requirements into technical documents- BRD, explained business requirements regarding technology to teh developers.
• Gather information from different data warehouse systems and loaded into warehouse using Fast Load, Fast Export, Multi-Load, BTEQ, Teradata parallel transporter (TPT) and UNIX shell scripts.
• Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server, IBM DB2 using Teradata utilities BTEQ, MLOAD, FLOAD and PUMP to load staging area
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning teh SQL queries.
• Interacted with different system groups for analysis of systems.
• Created tables, secondary indexes, Join indexes, views etc. in Teradata development Environment for testing.
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer, cleanup and summarize data.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Wrote appropriate code in teh conversions as per teh Business Logic using BTEQ scripts.
• Analyze and recommend solutions for data issues.
• Executing UNIX shell scripts for Informatics ETL tool to run teh Sessions.
• Created, Scheduled and Monitored Batches and Sessions using Power Center Server Manager/WLM
• Played a major role in setting up different regions - Testing, Integration, Performance, Break fix and Production environment with teh Wrapper scripts and setup folder structure for Teradata scripts to run in UNIX environment.

Environment: Teradata 13.0, BTEQ, Informatica PowerCenter (7.1.3/8.6.1 ) TPT, MLOAD, FLOAD, FASTEXPORT, Oracle, DB2, SQL Server UNIX, UNIX Shell Scripts, Ab Initio.

Confidential, Wilsonville, OR

Sr. Teradata Developer

Responsibilities:

• Design and development of new data warehouse (Analytical Data Warehouse) for better reporting and analysis.
• Work with teh data modelers, architects and Cognos developers to create a consumption layer in Teradata and Cognos.
• Involved in implementation of teh requirement and Involved in coding and walkthroughs, inspection of code.
• Worked with several vendors in sending outbound extracts and load inbound files into teh warehouse.
• Developed complex mappings using Informatica PowerCenter Designer to transform and load teh data from various source systems like Oracle, Teradata, and Sybase into teh Oracle target database.
• Build a re-usable staging area in Oracle for loading data from multiple source systems using template tables for profiling and cleansing in IDQ or Quality Stage.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Maintaining teh Visual Source Safe (VSS), Quality matrices, Knowledge management and Defect prevention & analysis.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Relational Tables and XML targets.
• Created Informatica server administration automation scripts, Shell scripts for data manipulation and process automation using UNIX Shell scripting.
• Created procedures to drop and recreate teh indexes in teh target Data Warehouse before and after teh sessions.
• Tuning teh complex mappings based on source target and mapping, session level.Involved in performance and tuning teh ETL processes.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Developed UNIX Shell Scripts for scheduling teh sessions in Teradata.
• Used SQL tools like TOAD 9.5 to run SQL queries and validate teh data in teh warehouse.

Environment: Teradata 13.0, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, UNIX, Unix Shell scripts, Informatica 8.6, Cognos, FTP.

Confidential, Richmond, VA

Teradata Developer

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules
• Implemented logical and physical data modeling with Star and SnowFlakes techniques using Erwin in Data Mart
• Created tables, views in Teradata, according to teh requirements
• Performed bulk data load from multiple data source (ORACLE 8i, legacy systems) to TERADATA RDBMS using BTEQ, Multiload and FastLoad
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Performed tuning and optimization of complex SQL queries using Teradata Explain
• Responsible for Collect Statics on FACT tables
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations
• Designing, creating and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support normalized and dimensional models. Maintain teh referential integrity of teh database
• Created proper Primary Index taking into consideration of both planned access of data and even distribution of data across all teh available AMPS
• Write numerous BTEQ scripts to run complex queries on teh Teradata database
• Created a cleanup process for removing all teh Intermediate temp files that were used prior to teh loading process
• Created test cases to unit test teh code prior to teh handover process to QA. Performed SQL tuning, provided testing approach for unit and SIT testing
• Developed UNIX shell scripts to run batch jobs in production

Environment: Teradata V2R5/12.0, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, Erwin Designer, UNIX, Windows 2000, Shell scripts.

Confidential, Chicago, IL

Teradata Developer

Responsibilities:

• Extracted data from various source systems like Oracle, Sql Server and flat files as per teh requirements
• Created a BTEQ script for pre population of teh work tables prior to teh main load process
• Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and FastLoad scripts
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse
• Involved heavily in writing complex SQL queries to pull teh required information from Database using Teradata SQL Assistance
• Created a shell script that checks teh corruption of data file prior to teh load
• Loading data by using teh Teradata loader connection, writing Teradata utilities scripts (Fastload, Multiload) and working with loader logs
• Created and automate teh process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Involved in troubleshooting teh production issues and providing production support
• Streamlined teh Teradata scripts and shell scripts migration process on teh UNIX box
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding teh current system
• Created a cleanup process for removing all teh Intermediate temp files that were used prior to teh loading process
• Involved in troubleshooting teh production issues and providing production support
• Developed unit test plans and involved in system testing

Environment: Teradata V2R5, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, BTEQ, MLOAD, FLOAD, FASTEXPORT, ERWin Designer, Quality Center, UNIX, Windows 2000, Shell scripts.

Confidential, Norristown PA

Teradata/ETL Developer

Responsibilities:

• Actively participated in transforming enhanced logical data model to physical data model
• Actively involved in Data Gathering, recognizing and confirming teh data sources/elements
• Designed teh ETL processes using Informatica to load data from Oracle, SQL Server, Flat Files, (Fixed Width), XML files and Excel files to target Teradata Database
• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica Power Center 7.x and 8.x.
• Worked on installation, configuration of Oracle, Informatica and extensively worked on Repository manager
• Extensively used ETL to load data from flat files into Staging area and then to Data warehouse
• Experience in performance tuning of sources, mappings, targets and sessions
• Implemented various Teradata specific features like selection of PI, USI/NUSI, PPI and Compression based on requirements
• Implemented access rights mechanism using restricted views, macros and roles
• Responsible for space management and user management including accounting based on performance group allocation
• Provide ongoing Teradata system performance management using Teradata manager and PMON
• Reviewing and monitoring priority scheduler and TDQM settings
• Involved heavily in writing complex SQL queries based on teh given requirements and used volatile tables, temporary tables, derived tables for breaking up complex queries into simpler queries
• Gather information from different data warehouse systems and loaded into warehouse using FastLoad, FastExport, MultiLoad, BTEQ and Unix shell scripts
• Involved in unit testing, systems testing, integrated testing and user acceptance testing.
• Involved in 24x7 production support

Environment: Informatica Power Center 7.x and 8.x, NCR Teradata V2R5, Oracle8i, SQL, C, C++, Shell scripting, Teradata Manager, Teradata Administrator, TDQM, Priority scheduler, BTEQ, SQL Assistant, TSET, Index Wizard, Statistics wizard, FastLoad, MultiLoad, FastExport, Tpump.

Confidential

Informatica/Teradata Developer

Responsibilities:

• Created reports using SQL Server
• Provided high end design consultancy in all aspects of SQL Server 2000
• Checked teh coding standards followed by peers of teh team
• Prepared test reports and bug logs for teh testing done
• Provide support to design/break fix issues in SQL Server 2000 and track to a closure
• Involved in data migration and data integration
• Developed stored procedures, triggers and functions and added/changed tables for data extraction, transformation and loading
• Development of scripts for loading teh data into teh base tables in EDW using FastLoad, MultiLoad and BTEQ utilities ofTeradata.
• Performed tuning and optimization of complex SQL queries usingTeradataExplain.
• Created a BTEQ script for pre population of teh work tables prior to teh main load process.
• Created/EnhancedTeradataStored Procedures to generate automated testing SQLs.
• Involved in troubleshooting teh production issues and providing production support.
• Streamlined theTeradatascripts and shell scripts migration process on teh UNIX box.
• Involved in analysis of end user requirements and business rules based on given documentation and working closely with tech leads and analysts in understanding teh current system.
• Created a cleanup process for removing all teh Intermediate temp files that were used prior to teh loading process.
• Involved in troubleshooting teh production issues and providing production support.

Environment: Informatica - Power Center 6.1, Oracle 8i, Erwin Data Modeler, BTEQ, FastLoad, Multiload, TOAD, Windows XP, Teradata SQL Assistant