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 the 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

Roles and Responsibilities:

• Performed major role in understanding the business requirements and designing andLoading data into data warehouse (ETL).
• Developing MLOAD scripts for loading the data from flat files to the staging tables for the new shipper item feeds.
• Developing BTEQ scripts to load the data from the staging tables to the base tables.
• Working with SQL assistant and utilities Like BTEQ, MLOAD, FLOAD, Tpump etc.
• Collection of data source information from all the legacy systems and existing data stores.
• Working with Different Teradata source systems to analyze data and load it into the Data warehouse
• Preparing reports according to the business requirements and review them, review existing reports and fix if any issues
• Worked on Role based access control for defining the users with specific roles and validate the 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 the existing FastLoad/ MultiLoad Scripts in for smooth loading of data in the 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 the Teradata SQLs to improve the 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 the WHERE and JOIN expressions
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Non-Production DBA support
• Worked on Access Rights scripts, Spool space issues, DBA procedures.
• Responsible for coordinating with the upstream teams to get the data into system.
• Responsible for validating the ETL transformation logic.
• Analyzing and troubleshooting the issues that were found.

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

Teradata Developer/ Data Analyst

Roles and Responsibilities:

• Responsible for gathering requirements from Business Analysts and Operational Analysts and identifying the data sources required for the requests.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Developed the DW ETL scripts using BTEQ, Stored Procedures, Macros in Teradata
• Development of scripts for loading the data into the 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 the data warehouse
• Validating the data, categorizing the data and organizing according to the existing business rules, managing the data if any business rule change occurs
• Worked on the reports according to the 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 the 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 the data.
• Worked on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent.
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the 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 the 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.

Teradata Data Analyst

Roles and Responsibilities:

• Used ETL for efficient mapping and transformation techniques and processed the 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 the Teradata tables.
• Developed Bteq scripts to load data to Teradata and developed UNIX scripts to access Teradata.
• Tuned the SQL queries for optimum performance.
• Developed the welcome kits campaigns for the 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 the data.
• Performed two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.

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

Teradata Developer

Roles and Responsibilities:

• Responsible for gathering requirements from business analysts and operational analysts and identifying the data sources.
• Written Scripts to extract the data from oracle and load into Teradata.
• Highly experienced in performance tuning and optimization for increasing the efficiency of the 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 the 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 the company Data Warehouse.
• Experience in scheduling the 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.