SUMMARY

• 8 years of extensive implementation experience of data warehouse design, ETL Development data mapping and data modeling.
• Experience of delivering projects end to end, worked with business user for UAT acceptance and with technical teams for deployment from Dev to higher environments.
• 5+ years of experience with Teradata utilities Fastload, Multiload, BTEQ, TPUMP, TPT, Teradata Administrator and SQL Assistant.
• 3+ Years of experience with ETL tool Power Center Informatica 8.X and 9.X which includes components Power center Designer, Power center Workflow Manager, Power center Workflow Monitor and Power center Repository Manager.
• 3 years of experience working in Telecom industry, worked in the role of data mapper, DWH architect and data modeler.
• 3 years of experience working in Finance industry, worked in the role of ETL developer, Team lead and database administrators.
• 5 years of experience of designing and developing ETL/ELT architect and development design.
• 5+ years of experience with massively parallel architecture (MPP), such as Shared Nothing Architecture, Nodes, AMPs, BYNET, Query Optimizer, Partitioning, Primary Indexes etc.
• 3+ years of experience in data modeling and database designing
• 7 years of experience writing SQL queries for data profiling, data analysis and data auditing.
• 2 years of experience as lead data modeler.
• Hands on experience of Teradata Stored procedure writing, trigger development, PPI, AJI and performance tuning.
• In Depth understanding and usage of TERADATA OLAP functions. Proficient in TERADATA SQL, Stored Procedures, Macros, Views, Indexes (Primary, Secondary, PPI, Join indexes etc).
• Expertise in Information sourcing, data mapping, data modeling, data profiling, data governance, data warehouse, data mining, and data mart.
• Experience of using PMON, Teradata View Point, Visual Explain, Index wizard, Statistic Wizard, Data dictionary views, Teradata Mapping Manager.
• Working knowledge of Big Data and Teradata Unified Architecture (UDA).
• Having experience of working with Aprimo and SAS for customer segmentation and data analytics.
• Experienced in environments requiring direct customer interaction and excellent communication skills.
• Well versed in writing UNIX shell scripting.
• Worked as Team Lead on many projects and also worked in onshore/Offshore model.
• Delivered walk - through sessions for designing and demonstrations to the customers.
• Strong Data Modeling experience in ODS, Dimensional Data Modeling Methodologies likes Star Schema, Snowflake Schema. Design and development of OLAP models consisting of multi-dimensional cubes and drill through functionalities for data analysis.
• Performed Teradata query and performance optimization.

TECHNICAL SKILLS

Operating System: UNIX, Windows

Databases/Sources: Teradata V2R5/V2R6/12.0/13.X/14.X, SQLServer 2008/2005

Scripting: Shell Scripting, T-SQL.

Tools: & Utilities: Teradata SQL Assistant, Teradata Administrator, BTEQ, Multiload, Fastload, FastExport, TPT, TPUMP, PMON, View Point, Teradata Mapping managerVisual Explain, Index Wizard, Statistic Wizard,SSIS, SSRS

ETL/Reporting Tools: Crystal Reports 8, Informatica 8.X./9.1. Powercenter Designer, Powercenter workflow Manager, Power center Repository Manager

Data Modeling: ERWIN 7.X, VISIO., MS Office(Excel,Word)

PROFESSIONAL EXPERIENCE

Confidential, California

Lead Teradata Developer

Environment: Teradata, ERWIN, TPT, Fastload, Multilaod, BTEQ, Informatica 9.5, Teradata Mapping Manager, SSIS, SQL Server 2005

Responsibilities:

• Conducted sessions with business users and technical source SMEs for business and data understanding.
• Worked with Data modeling team to meet the business requirements for designing ETL architecture.
• Designed and developed the framework for data migration using Informatica 9.6 mappings.
• Designed physical data model for whole sale credit risk data mart.
• Designed Strategy for data migration from SQL Server 2005 to TD 14.0.
• Executed business scenarios on data model to validate business questions.
• Resolved performance issues related to data distribution and queries response times issues.
• Worked with business analyst to perform data mapping for data migration.
• Designed ETL strategy for loading data from file sources and relational sources to staging, core and semantic layer using TPT.
• Worked with offshore team to complete the ETL development.
• Communication with stack holders for project statuses and technical reviews.
• Used various Teradata Index techniques to improve the query performance.
• Performed data analysis and suggested optimal solutions for data model, partition and indexes.

Confidential

Sr. Teradata Modeler

Environment: Teradata, UNIX, Informatica 9.1, ERWIN. Fastload, Multiload, BTEQ

Responsibilities:

• Conduct data model discussions and meetings to come out with the appropriate Data Mart at the lowest level of grain for each of the Dimensions involved.
• Designed data model for STAR schema implement data marts and Plan data marts involving confirmed dimensions.
• Created and maintained the Data Model repository as per company standards.
• Ensured the feasibility of the logical and physical data models;
• Collaborated with the Reporting Team to design Monthly Summary Level data model to support the further aggregated level of detailed reports.
• Worked on the Snow-flaking the data model dimensions to remove redundancy
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase
• Created and configured workflows, work lets and sessions to transport data to target systems using Informatica Workflow Manager.
• Involved in tuning of Teradata queries and increased the performance to a greater extent.
• Developed sessions and batches. Schedule those to run at the desired timings and order using GCFR.

Confidential

TeraData Lead Modeler

Environment: UNIX, Teradata, Fastload, Multiload, BTEQ, TPT, Teradata Anlytical pack

Responsibilities:

• Conducted sessions with business user to gather business requirement for data modeling
• Developed aConceptual data modelusing Erwin based on requirements analysis.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed data models
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis for data model.
• Exhaustively collected business and technical metadata and maintained naming standards for physical data model.
• Developed scripts using BTEQ, Fastload and Multiload for data loading.
• Involved in information sourcing, data mapping and data modeling.
• Used Teradata mapping manager for data mapping.
• Proactively analyzed the semantic/access layer to identify bottle necks for various aspects like data type different hash analysis, Latin vs Unicode analysis.
• Responsible for tuning the long running SQL's and complex joins for better performance.
• Prepared TPT (Update Operator) scripts for loading target tables based on requirements.
• Automated TPT and BTEQ scripts thru MS DOS batch files SLJM for Production.

Confidential, Somerset, NJ

Sr. Teradata Developer/Modeler

Environment: Informatica Power Center 8.6.1 (Repository Manager, Designer), TeraData

Responsibilities:

• Developeddata model, Data Mapping, Data Governance, TransformationandCleansingrules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Conducted major stakeholder interviews involving SME’s, Business Analysts and other stakeholders to determine the requirements for logical data model.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions.
• Worked extensively on Lookup, Router, Filter, Aggregator, Expression and Update Strategy Transformations.
• Developed BTEQ scripts for data transformation.
• Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for the business
• Developed Fastload scripts for data loading into staging area.
• Implemented the Push down optimization for faster transformation to Teradata database.
• Performed unit, data and integration testing of Informatica source and target data.
• Optimized the mappings by changing the logic to reduce run time.
• Developed the mappings to extract the data on incremental load basis.
• Worked with lead data modeler for physical implementation with in Teradata.

Confidential, NJ

ETL Lead/Analyst

Environment: Teradata, Teradata SQL Assistant, SQL Server, Flat files,SSIS,SSRS

Responsibilities:

• Involved in designing the ETL architecture, strategy and design.
• Used BTEQ and SQL Assistant front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Developed data extraction, transformation and loading jobs from flat files sources into Teradata using BTEQ, Fast Load, MultiLoad and TPUMP.
• Expertise in using Visual Explain, Index wizard, Statistics wizard to tune the bad queries and analyze the plans implemented for recommendations to gain the performance.
• Teradata performance tuning via Explain, PPI, AJI, Indices, collect statistics or rewriting of the code.
• Developed BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Involved in 24x7 production support.

Confidential, NJ

ETL Developer

Environment: SQL Server 2005/2000, SQL SERVER Integration Services (SSIS), Crystal Reporting

Responsibilities:

• Developed ETL strategy for development and data mapping.
• Developed data migration strategies using SSIS

Confidential

ETL Developer

Environment: Teradata, Crystal Reporting,SSIS

Responsibilities:

• Worked on the project in the development team as well as working with the SiT team
• For the last 3 months, worked as development team lead and SiT team lead from Teradatra’s side