Data Warehouse Team Lead/Developer/Analyst/Architecture
Application Architecture/Developer and team lead on large scale Enterprise Data Warehouse for Digital Marketing Platform for IBM. Performed system and data analysis, metadata generation, design, coding (Creating tables, loading tables, building aggregates and other ETL work), testing, performance tuning for Data Warehouse applications. Includes extraction, transformation and loading (ETL) of big data from a number of systems (Segment, MAT. CRM, Segment, Coremetric, CMR Siebel, BH, HHK, DNB etc…) across multiple server platforms and different code pages (Unicode). Development processes in an Agile RTC or Jira daily scrum calls. Development mainly in DB2, DashDB, DB Loads, DB2 stored procedures, DB2 Utilities, Netezza (Pure Data), K-Shell, syncsort, loads, SSH, etc… to build and support Data Marts in America, Emea, and Asian Pacific. Platforms are DB2 Cloud, Pure Data and DB2 AIX/Unix. Implemented GDPR related to PI data and Digital Marketing platform. Applications are used to target Customers using aggregated and matching data processes from many system into a single view for Marketing.