VIJAY MANI

Columbus, Ohio 704-***-**** acxu5r@r.postjobfree.com

Summary

Highly accomplished and experienced Data Warehouse Developer with comprehensive understanding of allaspects of data modeling.Extensively involved and experienced in business Analysis, requirements gathering,logical modeling, physical modeling, and ETL (Extraction, Transformation and Load),Data Integration.

10 years’ experience in System Analysis, Design, Development and Implementation in Relational Database and Data Warehouse in Business Banking and Mortgage Banking. Employment History

Cognizant Technologies

Sr.Associate, June 2012 - Present

Design ETL solution encompassing the data model, data transformation routines (i.e. ETL process) using Informatica, Teradata utilities (mload,Fastload,Fastexport,tpt & bteq) shell scripts. Data migration of 140 TB from DB2 to Teradata using Abinitio and TPT. Building Semantic layer and Marts for Business Banking from BDW Model using star schema. Eco System Migration of Business Banking application using CAIP Framework and Hadoop. Sql parsing to analyze the Data set usage in Legacy system for user migration into Eco system. Design and development of Common File pre-processing modules for Data Ingestion into Hadoop. Infosys Technologies

Technology Analyst, June 2006 - June 2012

Building Data Marts for Mortgage Banking from EDW using Mainframes, informatica and Teradata utilites. Data modeling and Data migration of legacy data into EDW. Developing risk reporting and BASEL compliance data for Fed using teradata utilities. Building Strategic decision engines using Mainframes and Cobol to prevent bad and risk customers Certification

Hortonworks Certified Hadoop Developer

Teradata Certified Sql Developer

Teradata Certified Professional

Professional Skills

Teradata, Bteq,TPT,Fast Load, Fast Export, Mload, Tpump,Erwin: Expert Unix, Shell Scription: Expert

Control M,TWS: Expert

Abinitio: Advanced

Informatica: Advanced

Hadoop Eco system : Intermediate

Pig, Hive,Sqoop,Python: Intermediate

Mainframes, Cobol: Intermediate