SUMMARY

• 6+ years of IT experience as Data Warehouse developer and Data analyst using TERADATA, ORACLE and ETL processes involving in all SDLC phases like Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and Documentation.
• Extensively worked with Teradata utilities like BTEQ, FastExport, FastLoad, Multiload to export and load data to/from different source systems including flat files.
• Expertise in creating Databases, Users, Tables, Triggers, Macros, views, stored procedures, Functions, Packages, Joins and Hash indexes in Teradata database.
• Extensive experience on SQL programming and complex stored procedure development.
• Designed, developed, tested and supported Extract, Transform and Load (ETL) processes necessary to load and validate data warehouse using UNIX shell scripting.
• Created Tables with Referential Integrity for implementing business rules and queries were developed using SQL.
• Involved in Data Migration between Teradata, MS SQL server and Oracle.
• Strong ability with standard, non - specialist software tools such as Excel, PowerPoint, Word and good working knowledge of SQL.
• Perform Grant, Revoke table accesses to Database Analysts, Business Analyst, Operational Analysts and Project Manager.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions.
• Extracting data from existing data sources, Developing and executing Business reports for Performance Monitoring.
• Strong SQL experience in coding and query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
• Expert in Data visualization and report development using Oracle, Teradata, BTEQ, and UNIX for Dashboards and Ad-hoc reports.
• Experience in working on Performance and Optimization of teh SQL Queries.
• Hands on experience and proven practices of resolving performance issues at various (Applications, Database) Levels.
• Team player with ability to adapt to various environments with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Databases: Teradata, MS-SQL Server, Oracle, MS-Access, MS Excel

DB Tools/Utilities: Teradata SQL Assistant, Fastload, Multiload, TPT, Teradata Visual Explain.

ETL Tool: Informatica 8.x/9.x (Source Analyzer, Mapping Designer, Mapplet Designer, Transformation Designer, Workflow Monitor, Workflow Manager)

Programming Languages: BTEQ, TSQL, PL/SQL, UNIX, C#, Shell Scripting.

Data Modelling: Logical/Physical/Dimensional, Star/Snowflake

Methodologies: Agile, Scrum, Waterfall Model, Iterative, Continuous Integration

Operating Systems: Windows, UNIX, Linux, Windows Server 2008R2

Web Technologies: ASP.NET, HTML, CSS, JavaScript, XML, PHP

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Teradata developer/Campaign Technical Analyst

Responsibilities:

• Performed major role in understanding teh business requirements and designing and Loading data into data warehouse (ETL).
• Developing MLOAD scripts for loading teh data from flat files to teh staging tables for teh new shipper item feeds.
• Developing BTEQ scripts to load teh data from teh staging tables to teh base tables.
• Working with SQL assistant and utilities Like BTEQ, MLOAD, FLOAD, Tpump etc.
• Collection of data source information from all teh legacy systems and existing data stores.
• Working with Different Teradata source systems to analyze data and load it into teh Data warehouse
• Preparing reports according to teh business requirements and review them, review existing reports and fix if any issues
• Worked on Role based access control for defining teh users with specific roles and validate teh existing role based views
• Added ranges to Partitioned Primary Index tables that were about to expire.
• Created Teradata objects like Databases, Users, Tables, Views and Macros.
• Fixed issues with teh existing FastLoad/ MultiLoad Scripts in for smooth loading of data in teh warehouse more effectively.
• Involved in scheduling Backups and archives and restoring data when required.
• Loading business data into data warehouse.
• Developed simple & complex mappings using Designer to load dimension and fact tables as per STAR schema techniques.
• Used Teradata Data Mover to copy data and objects such as tables and statistics from one system to another.
• Good knowledge of Teradata Manager, Teradata Dynamic Workload Manager (TDWM), PMON, Data Base Query Logging (DBQL), SQL assistant and Teradata Utilities.
• Worked on optimizing and tuning teh Teradata SQLs to improve teh performance of batch and response time of data for users.
• Implemented Informatica transformations such as Source Qualifier, Aggregator, Expressions, Look up Filters and Sequence Generator.
• Tuned various queries by COLLECTING STATISTICS on columns in teh WHERE and JOIN expressions
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain teh metadata, Security and Reporting.
• Non-Production DBA support
• Worked on Access Rights scripts, Spool space issues, DBA procedures.
• Responsible for coordinating with teh upstream teams to get teh data into system.
• Responsible for validating teh ETL transformation logic.
• Analyzing and troubleshooting teh issues that were found.

Environment: Teradata V14, BTEQ, MLOAD, FLOAD, ORACLE, SQLASSISTANT, UNIX, ETL, Informatica, MS EXCEL, HPSM, VERSION-ONE

Confidential, Dallas, TX

Teradata Developer/ Data Analyst

Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying teh data sources required for teh requests.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Developed teh DW ETL scripts using BTEQ, Stored Procedures, Macros in Teradata
• Development of scripts for loading teh data into teh base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Worked on Teradata utilities like BTEQ, FastExport, FastLoad, Multiload to export and load data to/from different source systems including flat files
• Worked on Different source systems to analyze data and load them into teh data warehouse
• Validating teh data, categorizing teh data and organizing according to teh existing business rules, managing teh data if any business rule change occurs
• Worked on teh reports according to teh Requirements and worked on any fixes required in existing reports
• Used Joins like Inner Join, Outer join while creating tables from multiple tables.
• Developed reports using teh Teradata advanced techniques like rank, row number
• Communicated with business users and analysts on business requirements. Gathered and documented technical and business Meta data about teh data.
• Worked on Data Verifications and Validations to evaluate teh data generated according to teh requirements is appropriate and consistent.
• Developed mappings in Informatica to load teh data including facts and dimensions from various sources into teh Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Experienced in using OLAP functions like sum, count, csum etc.
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• Proficient working in loading data into staging tables via views.
• Designed and developed weekly, monthly reports related to teh marketing and financial departments using Teradata SQL.
• Experience in Power Point Presentation (Financial Data, Charts).
• Expertise in generating graphs using MS Excel Pivot tables.
• Extracted data from existing data source, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.
• Extracted data from existing data source and performed ad-hoc queries.

Environment: Teradata V12, BTEQ, MLOAD, FLOAD, ORACLE, SQL, UNIX, Windows XP, ETL, Informatica.

Confidential, Round Rock, TX

Teradata Data Analyst

Responsibilities:

• Used ETL for efficient mapping and transformation techniques and processed teh data from various source to Teradata target tables
• Analyzed user requirements and developed, tested, and tuned various scripts, procedures, and database triggers to validate data.
• Migrated Oracle database objects to Teradata
• SQL scripts were developed for accessing data from teh Teradata tables.
• Developed Bteq scripts to load data to Teradata and developed UNIX scripts to access Teradata.
• Tuned teh SQL queries for optimum performance.
• Developed teh welcome kits campaigns for teh new members
• Created various channels of Phone, Email and Direct Mail campaigns
• Extracted data from various production databases using Teradata to meet Campaign data needs.
• Data loaded into Teradata from flat files using data stage dynamic sequence job with schema file concept.
• Wrote Case Expressions, Data Manipulation Command by using Teradata (BTEQ).
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, MS Excel.
• Worked closely with different Marketing Groups in designing and analyzing teh data.
• Performed two kinds of data loading processes (Daily and Weekly) depending on teh frequency of source data.

Environment: Teradata V13, BTEQ, SQL Assist, Oracle, SQL, PLSQL, UNIX Shell Scripts, MS Excel, MS Power Point.

Confidential

Teradata Developer

Responsibilities:

• Responsible for gathering requirements from business analysts and operational analysts and identifying teh data sources.
• Written Scripts to extract teh data from oracle and load into Teradata.
• Highly experienced in performance tuning and optimization for increasing teh efficiency of teh scripts.
• Experience working on campaigns and loading data into staging tables via views.
• Writing SQL scripts for huge data pulls and ad-hoc reports for analysis.
• Develop reports using teh Teradata advanced techniques like rank, row number and etc.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Wrote hundreds of DDL scripts to create tables and views in teh company Data Warehouse.
• Experience in scheduling teh jobs in UNIX using Crontab and sleep functions.
• Good at modifying UNIX existing scripts.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.

Environment: Teradata V12, SQL Assist, TD UTILITIES, SQL, UNIX Shell Scripts, MS Excel, MS Power Point.