PROFESSIONAL SUMMARY:

• Over 7+ years of strong experience in Databases/Data warehousing processes, in software development methodologies/concepts like SDLC, AGILE and CMMI process improvement.
• Data warehouse and client server technologies, exclusively involved in Analyzing / building Teradata EDW using Teradata ETL utilities and SSIS or Data stage.
• Extensively worked in Development of ETL Process Flows, Mappings and writing BTEQ scripts in loading data by utilizing Teradata utilities Fastloads /Mloads, TPT in to Teradata.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, and SQL Trace in Teradata.
• Involved in Data Migration between Teradata, MS SQL server and Oracle.
• Working knowledge in relational databases (RDBMS), data modeling and in building Data Warehouse, Data Marts using Star Schema and Snowflake Schema.
• Expert in Data visualization and report development using Tableau tool and SSRS (SQL Server Reporting Services) for Dashboards and Ad - hoc reports.
• Have strong handling experience of Production support failure jobs.
• 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
• Extensive experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages in Sql, Oracle and Teradata
• Good knowledge of reporting tools like SSRS, Tableau and ETL tools like SSIS.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Participated in Daily scrum meetings, sprint planning, sprint review, and sprint retrospective.

TECHNICAL SKILLS:

Teradata, MSSQL Server, Oracle, MS: Access, MS Excel

DB Tools/Utilities: Teradata SQL Assistant, Fastload, Multiload, TPT, Teradata Visual Explain, BCP (Bulk Copy Program)

BI/ Analytical Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Tableau, H2O(Hadoop)

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

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

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, MS Visual Studio

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

Operating Systems: Windows 98/2000/XP/Vista/Win 7,8,10, UNIX, Linux, Windows Server 2008R2

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

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, Rhode Island

Teradata Developer

Responsibilities:

• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Created functional and technical detailed design documents for the ETL
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, DDL Commands and DML Commands (SQL).
• Performed tuning and optimization of complex SQL queries using Teradata Explain and Run stats.
• Created a BTEQ script for pre population of the work tables prior to the main load process.
• Extensively used Derived Tables, Volatile Table and Global Temporary tables in many of the ETL scripts.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Created Primary Indexes (PI) for both planned access of data and even distribution of data across all the available AMPS. Created appropriate Teradata NUPI for smooth (fast and easy) access of data.
• Worked on exporting data to flat files using Teradata FastExport.
• In-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks.
• Worked with PPI Teradata tables and was involved in Teradata specific SQL fine-tuning to increase performance of the overall ETL process.
• Automated the ETL process using UNIX Shell scripting.

Environment: Teradata14, SQL Assistant 14.0, BTEQ, FastLoad, FastExport, MultiLoad, MS Visio, Putty, Microstratergy, Microsoft Project, ClearQuest

Confidential, Bloomfield, CT

Teradata Developer

Responsibilities:

• Extracted data loaded into staging server through fast export, later which is been cleansed transformed, integrated and loaded into database through, Mload and Bteq.
• Architected and developed FLoad and MLoad scripts in control file, developed BTEQ scripts to process the data in staging server.
• Expertise in SQL and Performance tuning on large scale Teradata Database
• ETL design using Informatica and Unix Shell Scripting
• Enhancements, Maintenance and Development for DWH applications
• Prepare Requirements documents, SRS documents, Unit Test Cases, Deployment Guides, User manuals, Technical documentation etc ensuring that storage, archiving, back-up and recovery procedures are functioning correctly
• Analyzed and designed USI and NUSI based on the columns used in joins during data retrieval.
• Used BTEQ and SQL Assistant front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Designed and developed physical models with appropriate Primary, Secondary, PPI and Join Index taking into consideration of both planned access of data and even distribution of data across all the available AMPs.
• Designed and developed workflows and automated with UNIX shell scripts.
• Handled production issues by co-coordinating between client and development team.

Environment: Teradata14, SQL Assistant, BTEQ, TPT, Microsoft SSAS, Informatica, Microsoft Project, MS Visio, MS Excel, MS Word, MS PowerPoint

Confidential

ETL Developer

Responsibilities:

• Involved in standard reports and dashboard integration.
• Developed common framework in SSIS package to bring the data from files to Reports database.
• Created complex Stored Procedures in comparison and data profiling module.
• Prepared Solution Design and Solution Architecture documents
• Involved in troubleshooting and resolving database integrity issues, Performance issues, blocking and deadlocking issues etc.
• Generated Dashboards with Quick filters, calculated fields, Parameters and sets to handle views more efficiently.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data in Tableau.
• 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, PL/SQL, MS Access, MS Excel

Confidential

ETL Developer

Responsibilities:

• Entrusted with the responsibility of gathering and analyzing of the specifications provided by the clients.
• Worked with the team, in detail design and performed tuning of SQL scripts.
• Involved in database design for every requirement.
• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Actively involved in the Design Reports using with Groupings and Conditions and Generate the Drill Through, Tabular, Matrix, Drill Down and Sub Reports in SSRS.
• Help team member in case they face any problem during Development.
• Perform code reviews if any changes required in production environment.
• Analysis and implementation of better performance strategies.
• Used the SSIS ETL Architecture to transfer data from Source server to Data Warehouse Server.

Environment: SQL Server 2008, SSIS, SSRS, ASP.Net, C#, TFS, Tableau, PL/SQL, MS Access, MS Excel

Confidential

PL/SQL and ETL Developer

Responsibilities:

• Responsible for the systems study, analysis, understanding systems design and database design.
• Involved in Functional requirement analysis.
• Involved in enhancement of application portability and performance.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Experience in creating Packages.
• Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.

Environment: SQL Server 2008,, SSIS, SSRS, ASP.Net, C#, SQL Navigator, PL/SQL, MS Access, MS Excel