SUMMARY:

• Experience in designing and developing Extract Transform and Load (ETL) processes on Teradata
• 7 years of experience in using Teradata SQL Assistant, BTEQ, Fast Load, Multi Load, TPump, FExport, PMON
• 4 years of experience in extracting, transforming and loading (ETL) data from other databases and text files using SQL*Loader utility and SQL Server ETL tools, DataStage and SSIS.
• Around 4 years of experience in Business Intelligence, Teradata Database design, Implementation and Maintenance mainly in large scale Data Warehouse environments.
• Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Experience in working with various heterogeneous Source Systems like Mainframe OLTP, Oracle, SQL Server, DB2, ERP, Flat files and Legacy systems.
• Expertise in database programming in writing of the SQL, Stored Procedures, Functions, Triggers, Views in Teradata, Oracle, MS Access .
• Extensively worked with BTEQ, FASTEXPORT, FASTLOAD and MULTILOAD Teradata utilities to export and to load data to/from flat files.
• Expert in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers.
• Expertise in Query Analyzing, performance tuning and testing.
• Extensively worked on Query tools like SQL Assistant, TOAD and PLSQL Developer.
• Involved in Data Migration between Teradata, MS SQL server, DB2 and Oracle
• Good Knowledge in Logical and physical modeling using Erwin. Hands on experience in 3NF, Star/Snowflake schema design and De - normalization techniques.
• Proficient in converting logical data models to physical database designs in Data warehousing Environment.
• Experience in extracting source data from Mainframe OLTP systems by writing several COBOL and JCL scripts.
• Worked on Schedulers like Crontab, Autosys and Tivoli Maestro.
• Experience in writing UNIX shell and PERL scripts to support and automate the ETL process.
• Highly experienced in Creating Sandboxes and saving graphs in the sandbox for check in and check out of graphs from the EME.
• Involved in Unit Testing, Integration Testing and preparing test cases.
• Involved in production support activities 24/7 during on call and resolved database issues.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.
• Strong problem solving, analytical, interpersonal skills, communication skills and have the ability to work both independently and as a team.

TECHNICAL SKILLS:

Databases: Teradata 14.1, 13.1, V2 R12, Oracle 10g/9i/8i, DB2, MS-SQL Server, MS-Access.

DB Tools/Utilities: Teradata SQL Assistant, BTEQ, Fastload, Multiload, FastExport, TPump, Teradata Manager, Teradata Query Manager, Teradata Administrator, Teradata SQL Assistance, PMON, SQL Loader, TOAD 8.0.

ETL Tools: Informatica Power Center 9/8.6.1/8.1 (Designer, Workflow manager and monitor)

Data Modeling Tools: Logical/Physical/Dimensional, Star/Snowflake, OLAP, ERWIN.

Scheduling Tools: UC4, Autosys

Version Control Tools: Clear Case, GIT

Operating Systems: Linux, Windows XP/NT/ 2000, UNIX.

Reporting Tools: Microstrategy 10.x, 9.4x, Business Objects 6.x, Cognos 10

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

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
• Experience in loading of data from several flat files sources to staging area using Teradata
• Performed Data analysis and prepared the physical database based on the requirements.
• Performed Data validations.
• Developed UNIX shell scripts for processing/ cleansing incoming text files.
• Worked with a very large team.
• Build tables with UPI, NUPI, USI and NUSI.
• Developed Macros with formulas and extracted Data and made Excel reports.
• Developed several Teradata BTEQ scripts to implement the business logic.
• Worked on Tuning, and troubleshooting Teradata system at various levels
• Designed reports comprising of charts, cross tabs and drill down
• Involved in data profiling on data source and collected stats.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Wrote hundreds of DDL scripts to create tables, views and indexes in the company Data Warehouse.
• Involved in Historical data migration to new reporting environment.
• Used dashboard tool to suspend and resume a migration and monitor the status of a migration

Environment: Teradata 14.1, V2R12, V2R5.1, Fast Load, Fast Export, T Pump, Multi Load, BTEQ)Informatica, GoldenGate, HP -UX UNIX SHELL SCRIPTS, JCL, MVS/Mainframes, WINDOWS 2000 Erwin 4.0.

Confidential, Fort Mill

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.
• Extensively used Stored Procedures and worked with parallel processing
• 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
• Performed Tuning, and troubleshooting Teradata system at various levels.
• Excellent in Teradata Data Warehousing environment.
• Gathering of Requirements from the various systems business users.

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

Confidential, NY

Teradata Developer

Responsibilities:

• Having experience in relational database theory and design including logical and physical structures & data normalization techniques.
• Involved in Designing and Development of logical and physical data models of systems that hold Terabytes of data.
• Worked on loading of data from several flat files sources to staging area using Teradata utilities like MLOAD, FLOAD, TPUMP and Fexport.
• Worked on Tuning, and troubleshooting Teradata system at various levels.
• Gathering of Requirements from the various systems business users.
• Created Global and volatile temporary tables to load large volumes of data into Teradata database.
• Created, updated and maintained ETL technical documentation.
• Build tables with UPI, NUPI, USI and NUSI.
• Written VBA macros with formulas and extracted Data and made Excel reports.
• Developed several Teradata BTEQ scripts to implement the business logic.
• Interacting with SME’s and Business Analysts for clarifications.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Performed Query optimization explain plans, collect statistics, Primary and Secondary indexes
• Excellent in Teradata Data warehousing environment.
• Involved in physical and logical design of the applications.
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Used the Datastage Designer to develop processes for extraction, cleaning, transforming, and integrating.

Environment: Teradata V2R6/5 (Fast Load, Fast Export, TPump, Multi Load, BTEQ), Informatica (7.5.1) Oracle 10g, SQL Server, Shell Script, UNIX, Erwin 6.0, SAS, B Business Objects 5.1 IBM AIX, Erwin 4.0,control M.

Confidential

Teradata Developer

Responsibilities:

• Worked with Business Analyst to gather business requirements and Involved in weekly team meetings.
• Designed and maintained logical and physical enterprise data warehouse schemas using ER-Win.
• Extracted order entry data, product and revenue data from Oracle and SQL server using Informatica.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Centre) tool.
• Created sessions, database connections and batches using Informatica Server Manager. Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems.
• Created migration and metadata documents for users.
• Created test cases and completed unit, integration and system tests for sales data mart system.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, Oracle, Sybase, DB2, SQL Server and loading to Oracle target database.
• Worked on Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of session.
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for Bulk Loading.
• Performed tuning of database and SQL queries.

Environment: Teradata V2R3.0, Informatica Power Center 7.1, Business Objects 5.x, Oracle 9i, PL/SQL, SQL*Loader, TOAD and UNIX.

Oracle Developer and Database Administrator

Responsibilities:

• Have used Bulk Binding features for mass loads.
• Have done SQL Tuning to improve performance.
• Performed database design (Views, Database triggers, Materialized views, packages, functions, and procedures).
• Have done Migration and Upgrade tasks
• Performed performance tuning (TKProf, Explain plan).
• Have used Analytical functions extensively.
• Have implemented frame work for Error Handling.
• Data extraction using UTL FILE.
• Developed materialized views and summary tables necessary for structured and ad-hoc reporting.
• Involved in OLTP database design.
• Experienced on FACT, Dimension tables, workflow process, mappings in Informatica
• Designed and developed privileges form for giving the privileges for each and every user. So bases on the privileges users can enter the data, delete the data and update the data and only query.
• Created materialized views for Data warehouse data
• Scheduled the nightly jobs using DBMS Scheduler.
• Developed control scripts for SQL*Loader for loading data from flat file to Oracle.
• Prepared UNIX shell scripting programs.
• Working on multitasking for different branches and different customers.
• Running script for creating table spaces, tables, indexes etc.
• Involved in day-to-day database maintenance
• Developed Packages to extract data and populate tables in CSV format for reporting.
• Involved in developing packages to convert data from legacy to Oracle.
• Prepared Technical Design Document and Installation Document.

Environment: Oracle 9i, Data warehouse, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, OLTP, OLAP, SQL*Loader, UNIX, TOAD