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.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Expertise in writing large/complex queries using SQL.
• Proficient in performance analysis, monitoring and SQL query tuning usingEXPLAIN PLAN,Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Good knowledge in Unix Shell scripting.
• Excellent Experience withdifferent indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI))and Collect Statistics.
• In - depth hands on experience in database,ETL/ELT design and developmentand have excellent data analysis skills
• Well versed with all stages ofSoftware Development Life Cycle (SDLC)i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Good knowledge onAgile Methodologyand the scrum process.
• Have knowledge on Big data Technologies like Hadoop, Hive, MapReduce, HDFS
• Having complete domain and development Life Cycle knowledge of Data Warehousing & Client Server Concepts and knowledge of basicdata modeling.
• Very good in Fast learning, Analytical thinking, decision making and problem solving skills.
• Have experience in working with both3NF and dimensional modelsfor data warehouse and good understanding of OLAP/OLTP systems.
• Strong understanding of the principles of DW usingFact Tables,Dimension Tables,StarandSnowflake SchemaModeling.
• Proficient in preparinghigh/low level documentslike design and functional specifications.
• Actively involved inQuality Processes and release management activities- To establish, monitor and streamline quality processes in the project.
• Very good in Analytical thinking, decision making and problem solving skills.
• Involved in review meetings with Project Managers, Developers and Business Associates for Project
• Ambitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.

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 MLOAD, FLOAD, TPUMP and FASTEXPORT
• 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 Teradata BTEQ scripts to Import data into Teradata and to Export data to a file shared drive, share point.
• Designed Teradata BTEQ scripts with complex SQL and also Parameterized based on DEV, QA, PROD environment and Region in a batch mode.
• 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, SC

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.
• Designed Teradata BTEQ scripts using BTET mode to execute multistatement transaction.
• Designed Teradata BTEQ scripts for a many conversion projects like converting currencies and locations.
• 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.
• Designed Teradata BTEQ scripts to just collect all Keys from our daily transaction delta tables.
• 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.

Confidential

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