Group Project Manager / Senior Data Architect
Client: Bed Bath and Beyond IncAs a client reporting Senior Data Architect for Enterprise Data warehousing, responsible for successful operation of enterprise data warehouse and enterprise data management: • Responsibilities included data modeling, data mapping, data analysis. Translate Business Requirements to Conceptual, Logical and Physical Data Models for supporting various databases; Teradata, Kognitio,Netezza and GCP Big query, various data sets; operational, analytical and aggregate, various schema types; dimensional/star schemas, Data Vault 2.0, various user groups; Business Intelligence, Data Science, Data analytics & ETL engineering and various data structures; structured, semi structured and unstructured. • Responsible for migrating data warehouse objects from Teradata to GCP Big Query by rearchitected entire Teradata objects to Big query objects by revising table denormalization, data types, partitions and clusters of the table in order to align with Big query architecture• Performed additional role as Data governance Manager and established data governance / Data modeling process / Metadata Standards & guidelines to maintain the data security, Data accuracy and Data quality. Responsible as escalation point for issues related to data governance.• Assisted the ETL and Reporting teams during ETL design discussions and ETL logic changes for data from various source systems to Data Warehouse to assist reporting • Responsible for understanding end-to-end functionality and building data models for loading data from various source systems including; POS, Web Commerce and Distributed Selling and WMS, JDA MMS - Supply Chain, Pricing Cost and Promotions, Inventory, Vendor, Demand forecasting and planning.As a Service Delivery Manager (HCL), shouldered additional responsibility to manage onsite/offshore development/support teams such as Datawarehouse DBA and ETL Team, Production Support team for I2 DF & Planning system and JDA MMS Production support team.