SUMMARY

• Progressive and innovative software professional with over 7 years of experience in requirement gathering, system analysis, application design, development, testing, configuration management, client/user support services
• Experience in designing and developing Extract Transform and Load (ETL) processes on Teradata
• 6 + years of experience in Teradata V2R12/V2R6/V2R5 (Teradata Administrator, Teradata SQL Assistant, BTEQ, Fast Load, Multi Load, TPump, FExport, ARCMain, PMON, Visual Explain).
• Good knowledge about the Teradata Architecture and Concepts
• Strong working experience in planning and carrying out of Teradata system Extraction, Loading Processes, Data Warehousing, MPP and Large - Scale Database Management and Reengineering
• Experience working on performance tuning and optimization of Teradata queries
• Involved in Data Migration between Teradata, MS SQL server, DB2 and Oracle.
• Experience in Database Programming, SQL, PL (Stored Procedures, and Triggers) in Teradata.
• Experience in Database Programming, SQL, PL/SQL (Stored Procedures, Functions and Triggers) for faster transformations and Development on Oracle
• Solid experience in tuning of large warehouse jobs (Database level fine tuning, Sql optimization, Workflow/session/mapping optimizations)
• Extensive knowledge on Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables
• 1 (1) years of Data Warehousing experience using Informatica Power Center (Workflow Manager, workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer) and Informatica Power Mart.
• Handling all the domain and technical interaction with client and the application users
• Well versed with Win XP/2000 Advanced Server /98/95/NT, UNIX, LINUX, Korn shell.
• Knowledge in Mainframes and JCL Environment.
• Excellent ability with competitive spirit in finding various approaches for problem solving and highly skilful, creative and innovative in developing efficient logic/code
• Team player with ability to adapt to various environments with excellent communication, interpersonal skills and a strong commitment towards Customer Satisfaction
• Worked on data analysis and data validations and preparing Unit Test Cases
• Performed unit testing and integration testing for the developed data load process
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Lead Teradata Developer

Responsibilities:

• Gathering of Requirements from the various systems business users.
• Communicating with the business users to understand business requirements clearly
• Conducting meetings with the data architects to understand the source system elements
• Mentoring, distributing, gathering statuses from the offshore Team.
• Worked on waterfall Lean SDLC model.
• Creating the DBA run books, DB Objects, ICRF forms and cross environment migration documentation.
• Worked on loading of data from several flat files sources to staging area using Teradata TPT.
• Extracted Data through different source systems like Oracle, MySQL and SQL Server Databases for Applications Development and report Maintenances.
• Worked on several BTEQ scripts to transform the data and load into the Teradata database.
• Migrated TPT and BTEQ scripts from old Windows environment to the New UNIX Environment.
• Performed Data analysis and prepared the physical database based on the requirements.
• Used Teradata SQL to convert data from one data type to Teradata data type.
• Performed Data validations.
• Created Views and wrote several single tables join Indexes to improve the performance for the reporting purposes.
• Worked with a very large team.
• Build tables, views with UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked on Tuning, and troubleshooting Teradata system at various levels
• Performed unit testing, regression testing and Integration testing.
• Assisted the Testing team in developing SQL/PLSQL scripts for Automated Testing.
• Designed and developed using shell and Perl scripts.
• Wrote UNIX scripts, Perl scripts for the business needs.
• Created Informatica Transformations, Work flows using Informatica 9.0 for various projects.
• Little Experience on SAP Business Objects XI for reporting on SSBDW.
• Worked on Onsite-Offshore model

Environment: Teradata 13.10, Teradata Viewpoint, IBM AIX, UNIX Shell Scripting, TPT, Mload,Fast Export and BTEQ, RASC Fort Runner, RASC Report Builder, Windows NT,Oracle.SQL Server, MySQL, Informatica 9.0,SAP Business objects X, IBM Clear Case, IBM Clear Quest, WLM scheduling tool

Confidential, Richfield, MN

Sr. Data Analyst/ Teradata Developer

Responsibilities:

• Gathering of Requirements from the various systems business users.
• Communicating with the business users to understand business requirements clearly
• Conducting meetings with the data architects to understand the source system elements
• Worked on loading of data from several flat files sources to staging area using Teradata TPT.
• Extracted Data through different source systems like Oracle, MySQL and SQL Server Databases for Applications Development and report Maintenances.
• Created several BTEQ, FLOAD, TPT Scripts and Executed through homegrown ETL tool RASC Fort runner.
• Created the SQL cubes for reports generation through home grown Reporting tool through RASC report Builder
• Worked on several BTEQ scripts to transform the data and load into the Teradata database.
• Migrated TPT and BTEQ scripts from old Windows environment to the New UNIX Environment.
• Performed Data analysis and prepared the physical database based on the requirements.
• Used Teradata SQL to convert data from one data type to Teradata data type.
• Performed Data validations.
• Created Views and wrote several single tables join Indexes to improve the performance for the reporting purposes.
• Worked with a very large team.
• Build tables, views with UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked on Tuning, and troubleshooting Teradata system at various levels
• Performed unit testing, regression testing and Integration testing.
• Assisted the Testing team in developing SQL/PLSQL scripts for Automated Testing.
• Designed and developed using shell and Perl scripts.
• Wrote UNIX scripts, Perl scripts for the business needs.
• Worked on rotation based Production Support developer

Environment: Teradata V2R12, Teradata Manager, IBM AIX, UNIX Shell Scripting, TPT, Fast Export and BTEQ, RASC Fort Runner, RASC Report Builder, Windows NT,Oracle.SQL Server, MySQL

Sr.Teradata Developer

Confidential, Chattanooga, TN

Responsibilities:

• Gathering of Requirements from the various systems business users.
• Communicating with the business users to understand business requirements clearly
• Conducting meetings with the data architects to understand the source system elements
• Worked on loading of data from several flat files sources to staging area using Teradata TPT.
• Worked on several BTEQ scripts to transform the data and load into the Teradata database.
• Performed Data analysis and prepared the physical database based on the requirements.
• Optimizing the Existing Batch Job Process so as to speed the Batch Job Process.
• Creating the New UNIX Wrappers to Automate the Nightly Batch Jobs.
• Interacting with the Database Administrators for creating the new Databases, Tables and migration of scripts and DDL’s from one environment to the other environment.
• Analyzing the new Teradata utilities for ETL processing and developing the Scripts accordingly.
• Doing the impact analysis if there are any changes to the tables so as to maintain the Normalized rules.
• Did capacity planning for the Databases and Tables for various Applications.
• Used Teradata SQL to convert data from source data type to Teradata data type.
• Performed Data validations.
• Created Views and wrote several single tables join Indexes to improve the performance for the reporting purposes.
• Worked with a very large team.
• Build tables, views with UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked on Tuning, and troubleshooting Teradata system at various levels
• Performed unit testing, regression testing and Integration testing.
• Assisted the Testing team in developing SQL/PLSQL scripts for Automated Testing.
• Designed and developed using shell and Perl scripts.
• Wrote UNIX scripts, Perl scripts for the business needs.

Environment: Teradata 13.10, Teradata Viewpoint (13.0), IBM AIX, UNIX Shell Scripting, TPT(Insert,Update,Load,Export Operators),BTEQ, IBM Clear quest, DB2,Control M

Confidential, Pittsburgh, PA

Sr.Teradata Developer

Responsibilities:

• Gathering of Requirements from the various systems business users.
• Communicating with the business users to understand business requirements clearly
• Conducting meetings with the data architects to understand the source system elements
• Worked on loading of data from several flat files sources to staging area using Teradata TPT.
• Worked on several BTEQ scripts to transform the data and load into the Teradata database.
• Performed Data analysis and prepared the physical database based on the requirements.
• Used Teradata SQL to convert data from one data type to Teradata data type.
• Performed Data validations.
• Created Views and wrote several SJI’s, AJI’s to improve the performance for the reporting dashboards.
• Worked with a very large team.
• Created several Teradata Tables based on the requirements.
• Build tables, views with UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked on Tuning, and troubleshooting Teradata system at various levels.
• Worked on creating several Autosys job scripts (Jil files) for the batch Jobs.
• Performed unit testing, regression testing and Integration testing.
• Assisted the Testing team in developing SQL/PLSQL scripts for Automated Testing.
• Designed and developed using shell and Perl scripts.
• Wrote UNIX scripts, Perl scripts for the business needs.
• Worked on production Support

Environment: Teradata 13.10, Teradata Viewpoint, Red hat Linux, Linux/Unix Shell Scripting, TPT, BTEQ, Harvest, SVN, AutoSys

Confidential

Sr.Teradata Developer

Responsibilities:

• Gathering of Requirements from the various systems business users.
• Communicating with the business users to understand business requirements clearly
• Conducting meetings with the data architects to understand the source system elements
• Worked on loading of data from several flat files sources to staging area using Teradata TPT.
• Worked on several BTEQ scripts to transform the data and load into the Teradata database.
• Migrated TPT and BTEQ scripts from old Windows environment to the New UNIX Environment.
• Performed Data analysis and prepared the physical database based on the requirements.
• Used Teradata SQL to convert data from one data type to Teradata data type.
• Performed Data validations.
• Created Views and wrote several single tables join Indexes to improve the performance for the reporting purposes.
• Worked with a very large team.
• Build tables, views with UPI, NUPI, USI and NUSI.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked on Tuning, and troubleshooting Teradata system at various levels
• Performed unit testing, regression testing and Integration testing.
• Assisted the Testing team in developing SQL/PLSQL scripts for Automated Testing.
• Designed and developed using shell and Perl scripts.
• Wrote UNIX scripts, Perl scripts for the business needs.

Environment: Teradata V2R12, Teradata Manager, IBM AIX, UNIX Shell Scripting, TPT, Fast Export and BTEQ.

Confidential, PA

Sr.Teradata Developer

Responsibilities:

• Gathering of requirements from the various systems business users.
• Working with end users and developers to understand the data needs of an application and the larger systems
• Providing different designs for different database uses. For example an OLTP database design will not be the same as one for a data warehouse.
• Documenting the data involved including definitions, constraints and access needs
• Creating and maintaining data definition language (DDL) that can be used to create and update the database.
• Creating and maintaining logical designs, including Entity Relationship diagrams, which illustrate what data will be stored, how it is rganized, how it can be retrieved (keys) and how it relates to other data in the database
• Conducting meetings with the data architects to understand the source system elements.
• Teradata Data Warehouse centric physical database modeling experience.
• Worked on loading of data from several flat files sources to staging area using teradata MLOAD, FLOAD, TPUMP and FASTEXPORT.
• Created Global and volatile temporary tables to load large volumes of data into teradata database.
• Created, updated and maintained ETL technical documentation.
• Build tables, views, UPI, NUPI, USI and NUSI.
• Written VBA macros with formulas and extracted Data and made Excel reports.
• Written several Teradata BTEQ scripts to implement the business logic.
• Interacting with SME’s and Business Analysts for clarifications.
• Done Query optimization explain plans, collect statistics, Primary and Secondary indexes
• Involved in physical and logical design of the applications.
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Wrote several Macros, Stored Procedures.
• Worked with SQL Assistant for ad hocking.
• Wrote several Bteq scripts for implementing Business logic.
• Worked on Fast load, Multi load for loading the data into the teradata database.
• Involved in working with PMON, monitoring the usage of the users.
• Worked on OLELOAD to load tables and to export tables into spreadsheets.
• Participate in Data Modeling sessions to identify data warehouse requirements
• Involved in design, data modeling.
• Having experience in relational database theory and design including logical and physical structures & data normalization techniques.
• Designed and Developed logical and physical data models of systems that hold Terabytes of data.
• Coordinated with the QA team for the derived scope of testing
• Worked on Tuning, and troubleshooting Teradata system at various levels.
• Excellent in Teradata Data Warehousing environment.
• Gathering of Requirements from the various systems business users.
• Involved in physical and logical design of the applications

Environment: Teradata V2R12, Teradata Manager, SAP BW, Siebel, Oracle 10g, Teradata Analyst PackSun Solaris 5.1, UNIX Shell Scripting, Fast load, Multiload, Fast Export, HP Quality Center.

Confidential, St. Louis, MO

Teradata Developer

Responsibilities:

• Worked on loading several tables using Teradata Parallel Transporter.
• Built Aggregate Join Indexes for ROLAP performance
• Involved in creating several tables.
• Converted many Stored Procedures from SQL database to teradata stored procedures.
• Interacted with Business Analysts and participated in JAD sessions and gathered the requirements.
• Handled different types of Indexes, Joins etc. for optimum performance of Teradata.
• Designed/Developed scripts to move data from the Staging tables to the Target tables.
• Wrote several Macros, Stored Procedures.
• Worked with SQL Assistant for ad hocking.
• Wrote several Bteq scripts for implementing Business logic.
• Worked on Fast load, Multi load for loading the data into the teradata database.
• Involved in working with PMON, monitoring the usage of the users.
• Worked on OLELOAD to load tables and to export tables into spreadsheets.
• Participate in Data Modeling sessions to identify data warehouse requirements
• Involved in design, data modeling.
• Having experience in relational database theory and design including logical and physical structures & data normalization techniques.
• Designed and Developed logical and physical data models of systems that hold Terabytes of data.
• Coordinated with the QA team for the derived scope of testing
• Worked on Tuning, and trouble shooting Teradata system at various levels.
• Excellent in Teradata Data Warehousing environment.
• Gathering of Requirements from the various systems business users.
• Involved in physical and logical design of the applications.

Environment: Teradata V2R12, V2R5.1 (Fast Load, Fast Export, TPump, Multi Load, BTEQ), Informatica 7.5, UNIX SHELL SCRIPTS, priority scheduler, WINDOWS 2000 Erwin 4.0.

Confidential

Teradata /Informatica Developer

Responsibilities:

• Used External Loaders like Multi Load, T Pump and Fast Load to load data into Teradata database.
• Wrote Teradata BTEQ and FASTEXPORT scripts to export data to various data marts.
• Designed ETL process flows for entire DWH application and developed data mapping spreadsheets to define transformation rules for each stage of ETL process.
• Developed Informatica ETL code using various mappings and transformations for transport of data from legacy extract files to data mart as per the business requirements.
• Developed reusable transformations and Mapplets transformations.
• Worked with PMCMD to interact with Informatica Server.
• Developed Shell scripts for Job Automation.
• Responsible for migration of Informatica mappings, workflows between different environments.
• Developed robust Informatica mappings and fine-tuned them to process millions of input records with estimated throughput.
• Developed Windows Batch scripts for setting customized commands.
• Responsible for monitoring scheduled, running completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Extracted data from Oracle, SQL Server, Flat files, and DB2 source systems.
• Involved in Unit testing and Integration Testing of the developed code.
• Responsible for four types of performance tuning Mapping Level, Session Level, source Level, and target level.
• Coordinate with the Actuate reporting team in modifying the existing Informatica ETL code as per the new business requirements.
• Familiar with concepts involving different types of Indexes, Joins, Spaces etc. for optimum performance of Teradata.
• Development of Bteq /Fast Load /Multiload script for loading purpose.
• Designed/Created several BTEQ scripts to apply the business rules manipulate and/or massage the data according to the requirements.
• Designed/Developed scripts to move data from the staging tables to the target tables.
• Designed the order of flow for the execution of the jobs and scheduling the jobs.
• Fine tuning of SQL to optimize the performance, spool space usage and CPU usage.
• Responsible for migration and production support.
• Wrote hundreds of DDL scripts to create tables, views and indexes in the company Data Warehouse.
• Provided on-call trouble-shooting support for all applications run in the west coast data center with responsibility for all applications involved in Data Warehouse Services.

Environment: Informatica Power Center/Power Mart 6.x, Informatica Power Exchange, Sun Solaris, Teradata Database V2R5.x, NCR Servers, Teradata Utilities (BTEQ, Fast load, Multiload, T pump).