SUMMARY:

• 7+ years of IT experience from a highly reputed IT firm, has knowledge in SDLC processes in estimation, analysis, design, development, implementation, change control management supporting data warehouses residing on Teradata used all Teradata utilities (MultiLoad, FastLoad, FastExport, BTEQ, TPump, TPT) extensively.
• Strong skills in resolving Teradata issues, providing workaround for the problems, knowledge on diagnostics, Database Tuning, SQL Tuning and Performance Monitoring.
• Experienced in UNIX Shell scripting as part of file manipulation and text processing.
• Expertise in designing tables especially the permanent tables (Multiset /Set) with opt character set and Compression feature, macros and views in Teradata database.
• Experience in Database Programming, SQL, PL/SQL (Stored Procedures, Functions and Triggers) for faster transformations and Development using Teradata.
• Expertise on Star Schema and Snowflake Schema, Fact Dimension Tables, Slowly Changing Dimensions. Interacting with both clients and users as well to know their requirements.
• Expert in TSQL - DDL/DML/DCL, perform most of the SQL Server Management Studio functionality using T-SQL Scripts.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2012/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Hands on experience using query tools like TOAD, SQL Developer, PL/SQL developer and Teradata SQL Assistant.
• Strong understanding and experience in software development methodologies/concepts like SDLC and AGILE process improvement.

TECHNICAL SKILLS:

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

ETL/Reporting Tools: SQL Integration Services (SSIS), SQL Reporting services (SSRS), Tableau, Hadoop - H20

Tools: Teradata SQL Assistant, BTEQ, Teradata Visual Explain, FastLoad, MultiLoad, TPump, TPT, Bulk Copy Program (BCP)

Languages: BTEQ, T-SQL, PL/SQL, Unix Shell scripting, C, C++, Java, C#

Web Languages: ASP.net, XML, HTML, CSS, Java Script

GUI Tools / IDE: Teradata Viewpoint, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, MS SQL Enterprise Manager, SQL Query Analyzer, SQL Server Profiler, Database Engine Tuning Advisor, MS Visual Studio 2008/2012

Methodologies: Agile, SDLC Waterfall

Software/Utilities: ODBC, MS Office

Operating Systems: Windows 2010/2008/2007 and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

Sr. Teradata Developer

Responsibilities:

• Provided standards/guidelines for development, responding to customer/client requests or events as they occur, and developed solutions to problems utilizing formal education and judgment. Accomplished tasks by gathering the requirements and elicitation, documented business requirements.
• Data modeling experience focusing on high-activity, normalized transaction systems (OLTP), highly-usable de-normalized reporting systems (OLAP) as well as staging areas and data marts.
• Studied the existing source tables and created facts, dimensions and star schema representation for the data mart.
• Good experience in overall Database design and architect for large size applications like Tables, Indexes and defining design norms etc.
• Expertise in importing/exporting large amounts of data from files to Teradata and vice versa.
• Did Performance Tuning by collecting statistics, analyzing explains, choosing appropriate indexes.
• Developed SQL objects like tables, views, stored procedures, macros in order to get the data with business rules from source to target databases, at optimum performance.
• With the in-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI and USI and NUSI and JI etc.) etc.
• In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
• Delivered BTEQ scripts to extract, transform and load data into target Fact tables.
• Delivered MLOAD scripts to load data in the target tables.
• Extensive experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers on Microsoft SQL Server.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server SSIS.
• Created ETL packages using Heterogeneous data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc.,) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Good in writing, scheduling and modifying UNIX scripts.

Environment: Teradata v14, BTEQ, FLOAD, MLOAD, Teradata SQL Assistant, UNIX, Microsoft SQL server 2012/2008, Microsoft Integration services(SSIS), Microsoft Reporting services(SSRS), MS Excel, MS Word, MS PowerPoint.

Confidential, Jacksonville. Florida

Teradata Developer

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
• Developed scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Created numerous scripts with Teradata utilities BTEQ, MLOAD and FLOAD
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• 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.
• Tested database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata
• Proficient in working on Set, Multiset, Derived, Volatile Temporary tables.
• 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, PLSQL, UNIX, Windows XP.

Confidential

ETL Developer

• Involved in planning, controlling and monitoring, and also managing the assigned resources to best meet project objectives.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Used reporting services (SSRS) generated various reports like Drill Down, Drill through, Gauge, Map, Matrix.
• Performed code reviews if any changes required in production environment.
• Involved in stored procedures and ETL performance tuning.
• Participated in Daily scrum meetings, sprint planning, sprint review, and sprint retrospective.

Environment: SQL Server 2008, SSIS, SSRS, ASP.Net, C#, TFS, Tableau

Confidential, Gurgaon

ETL Developer

Responsibilities:

• Converted DTS package into SSIS for the Database migration from SQL 2008.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Worked directly with functional analysts and business users in understanding the information needs of the business and developing new database/BI functionalities or tools to meet these requirements.
• Research, defined and deployed BI improvement opportunities and streamline the business intelligence processes
• Created detail design, work on development and perform code reviews.
• Analyzed & implemented better performance strategies.
• Developed SSRS Reports like Drill Down, Drill through, Gauge, Map, Matrix.
• Generated ETL engine by using SSIS
• Involved in stored procedure performance tuning for Calculation module.

Environment: SQL Server 2008, SSIS, SSRS, Tableau 8.2, Visual studio 2010

Confidential

SQL Database Developer

Responsibilities:

• Wrote queries for converting existing customer and product data to a new database.
• Created forms and reports to make changes for existing customer services, site survey and service location for customer and order record databases.
• Extracted data from existing data source by using SQL.
• Assisted in the development of user documentation by using Live Link.
• Gathered user requirements and business need from users.
• Performed system analysis on businesses and prepared Functional specifications, Technical documentation, and User documentation.
• Created weekly, biweekly, monthly reports by using MS Excel, MS Access, SQL, PL/SQL.
• Extracted data from existing data source and performed ad-hoc queries by using SQL, PL/SQL, MS Access.
• Developed tutorials and FAQ pages for new email servers and other related software.

Environment: Microsoft SQL Server 2005, Oracle, Crystal Reports, SQL Navigator, PL/SQL, MS Access, MS Excel, Visual Basic.