Vinodh Varma C Email and Phone Number

Extensive experience in analysis, design, development & migration of data warehouse applications.Diversified domain experience in banking domain.Experienced in software development life cycle (SDLC). Strong experience in designing the Documents for loading data into Data Warehouse and Data Mart tables.Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Re-engineering, Dimensional Data modeling, FACT& dimensions tables, physical & logical data modeling.Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.Exceptional analytical and problem solving skills. Team Player with the ability to communicate effectively at all levels of the development processLead projects from initialization phase from capturing business requirements to final phases of testing.Dedicated to maintain high quality standards.

Interacted with End user community to understand the business requirements and in identifying data sources. Designed and developed ETL processes to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.The migration and cleanse database will be the central collection point for all data related the migration of customer data. Taking feeds from ODS, Profile as well as some low volume ancillary data.As part of the migration, errors in the data need to be corrected as outlined in Data Cleanse Solution, Errors will be identified internally using ETL Job’s.Involved in performance tuning and optimization to manage very large volume of data. Be the driver table for migrating customers to Barclays systems.

Responsibilities:• Converted all DB2 Queries to Teradata• Migrated all job’s from Datastage 7.5 to 8.5.• Came with new concept of BTCH_I instead of Timestamp.• Developed Unix Shell Scripts with Teradata Queries to load data from source to foundation tables.• Extracting data, cleansing, transforming, integrating, and loading data into Data Warehouse.• Design and Develop the ETL Parallel jobs in Data Stage.• Experience in Unix Shell Scripting• Preparation of Test Scenarios, Test Cases and Test Data.• Fixed Defects came from HP Quality centre• Coordinating with the onsite team for requirement.• Used Microsoft tool MSTFS for code movement in to STAGE and Production environments.