-15+ years of IT experience, primarily with IBM, specialized in the field of Leading Software Development, Architecture, Design, Data Modeling, Enhancement & Testing. -Experienced in leading and managing ETL, Data warehouse, Data integration, BI reporting projects.-Experienced in Data Warehousing concepts, Dimensional modeling like Star Schema, Relational modeling, Snowflake Schema, 3NF & Database Architecture for OLTP and OLAP applications, Data Analysis and ETL processes.-Strong experience in modeling, designing, developing, loading and maintaining FACT and dimension tables. Expertise in projects utilizing relational and dimensional (star schema) modeling. -Worked as Project lead for large ETL projects, implemented using Informatica 9x, Teradata and Oracle Exadata. Handled and manipulated really large tables with multi terabytes of data.-Experienced in working with Teradata utilities like BTEQ, FastLoad, MultiLoad, Fast export, TPump, TPT. -Experienced in Perl, UNIX/Linux Shell Scripting/Korn Shell, Window scripting. -Strong ETL knowledge of Informatica PowerCenter, SSIS/SSAS/SSRS, Teradata Tools and utilities including MLOAD, FASTLOAD, FASTEXPORT, BTEQ, TPT. Strong knowledge in Oracle, DB2, MS SQL server and SQL scripting.-Very strong on Teradata SQL query optimization techniques like: EXPLAIN feature, COLLECT STATISTICS, Secondary Indexes, Partition Primary Index (PPI), Volatile and Global temporary tables.-Experience in Agile methodology, including Extreme Programming, Test Driven Development and Scrum/sprint/iterative development.-Excellent knowledge & working experience in all phases of software development life cycle (SDLC) including planning, analysis, design, development, testing, and implementation.
Listed skills include Data Warehousing, Db2, Agile Methodologies, Etl, and 36 others.