Data Architecture Manager

• Feb 2022 - Present

Data Architect

• Jan 2021 - Feb 2022

Data Architect

• Sep 2019 - Jan 2021

As Data Architect for Business Process Management Team, responsible for designing Data Architecture and modelling Process Data warehouse in Snowflake DWH. • Designed data architecture for process reporting using Snowflake DWH in AWS cloud, Denodo Data Virtualization and Power BI Data Visualization which was approved by Architecture Council. • Designed a data analytics system to support the business team, developed a continuous integration and continuous deployment process, and monitored… Show more As Data Architect for Business Process Management Team, responsible for designing Data Architecture and modelling Process Data warehouse in Snowflake DWH. • Designed data architecture for process reporting using Snowflake DWH in AWS cloud, Denodo Data Virtualization and Power BI Data Visualization which was approved by Architecture Council. • Designed a data analytics system to support the business team, developed a continuous integration and continuous deployment process, and monitored infrastructure to guide the development team. • Developed Simplified Logical Data Model and Semantic layer for the requirement across multiple BPM (Business Process Management) tools like in-house legacy systems, Appian and Blue Prism; and obtained data governance approval. • Recommended alignment of Process Taxonomy across all processes and systems; and built reference data model integrated with organisation data strategy. Show less As Data Architect for Business Process Management Team, responsible for designing Data Architecture and modelling Process Data warehouse in Snowflake DWH. • Designed data architecture for process reporting using Snowflake DWH in AWS cloud, Denodo Data Virtualization and Power BI Data Visualization which was approved by Architecture Council. • Designed a data analytics system to support the business team, developed a continuous integration and continuous deployment process, and monitored… Show more As Data Architect for Business Process Management Team, responsible for designing Data Architecture and modelling Process Data warehouse in Snowflake DWH. • Designed data architecture for process reporting using Snowflake DWH in AWS cloud, Denodo Data Virtualization and Power BI Data Visualization which was approved by Architecture Council. • Designed a data analytics system to support the business team, developed a continuous integration and continuous deployment process, and monitored infrastructure to guide the development team. • Developed Simplified Logical Data Model and Semantic layer for the requirement across multiple BPM (Business Process Management) tools like in-house legacy systems, Appian and Blue Prism; and obtained data governance approval. • Recommended alignment of Process Taxonomy across all processes and systems; and built reference data model integrated with organisation data strategy. Show less

Data Architect

• Aug 2012 - Jan 2021

Data Architect

• Jun 2019 - Aug 2019

Consolidated BT’s Legacy source systems and supported on Forecasting Modeling using Machine Learning. • To create BT’s Energy Forecasting Model, gathered information from different platforms including PSTN, VOIP etc ; to address technical challenges across each system and its consistency. • Developed a generalized data model for consolidating different systems from Equipment to card level across all UK locations with its meter reading, theoretical power consumption map and weather data… Show more Consolidated BT’s Legacy source systems and supported on Forecasting Modeling using Machine Learning. • To create BT’s Energy Forecasting Model, gathered information from different platforms including PSTN, VOIP etc ; to address technical challenges across each system and its consistency. • Developed a generalized data model for consolidating different systems from Equipment to card level across all UK locations with its meter reading, theoretical power consumption map and weather data for the last 5 years. • Led agreement of equipment and location data hierarchy with stakeholders to build reference data model and master data. • Built a data platform on Oracle and designed visualization for businesses to view data on their energy consumption by equipment type and locations. Key contributor to build a ML model for energy forecasting. Show less Consolidated BT’s Legacy source systems and supported on Forecasting Modeling using Machine Learning. • To create BT’s Energy Forecasting Model, gathered information from different platforms including PSTN, VOIP etc ; to address technical challenges across each system and its consistency. • Developed a generalized data model for consolidating different systems from Equipment to card level across all UK locations with its meter reading, theoretical power consumption map and weather data… Show more Consolidated BT’s Legacy source systems and supported on Forecasting Modeling using Machine Learning. • To create BT’s Energy Forecasting Model, gathered information from different platforms including PSTN, VOIP etc ; to address technical challenges across each system and its consistency. • Developed a generalized data model for consolidating different systems from Equipment to card level across all UK locations with its meter reading, theoretical power consumption map and weather data for the last 5 years. • Led agreement of equipment and location data hierarchy with stakeholders to build reference data model and master data. • Built a data platform on Oracle and designed visualization for businesses to view data on their energy consumption by equipment type and locations. Key contributor to build a ML model for energy forecasting. Show less

Data Architect

• Jul 2017 - Apr 2019

For HSBC Global Operations MI Executive Summary Program, interacted with business owners to consolidate and analyse data requirements and information gaps, and outlined required steps to build an integrated data system in Google Cloud Platform. • Key contributor in designing GCP architecture and tool selection as part of HSBC’s Operations MI strategic solution. • Designed, built and managed Data model for Global Operations and MI requirements. • Identified, classified and captured… Show more For HSBC Global Operations MI Executive Summary Program, interacted with business owners to consolidate and analyse data requirements and information gaps, and outlined required steps to build an integrated data system in Google Cloud Platform. • Key contributor in designing GCP architecture and tool selection as part of HSBC’s Operations MI strategic solution. • Designed, built and managed Data model for Global Operations and MI requirements. • Identified, classified and captured Critical Data Elements supporting Operations and Operations MI program in Collibra. • Actively participated in Data Governance Steering Group and Group Data Architect Forum Show less For HSBC Global Operations MI Executive Summary Program, interacted with business owners to consolidate and analyse data requirements and information gaps, and outlined required steps to build an integrated data system in Google Cloud Platform. • Key contributor in designing GCP architecture and tool selection as part of HSBC’s Operations MI strategic solution. • Designed, built and managed Data model for Global Operations and MI requirements. • Identified, classified and captured… Show more For HSBC Global Operations MI Executive Summary Program, interacted with business owners to consolidate and analyse data requirements and information gaps, and outlined required steps to build an integrated data system in Google Cloud Platform. • Key contributor in designing GCP architecture and tool selection as part of HSBC’s Operations MI strategic solution. • Designed, built and managed Data model for Global Operations and MI requirements. • Identified, classified and captured Critical Data Elements supporting Operations and Operations MI program in Collibra. • Actively participated in Data Governance Steering Group and Group Data Architect Forum Show less

Data Architect

• Dec 2016 - Jun 2017

• Defined scope, objectives and approach for migration of data from Carillion’s legacy systems as part of Tranche 1A implementation • Provided migration team with a roadmap to perform data conversion, and ensured team members understood and followed the same approach • Exclusively involved in defining data architecture, Master Data Management principles and data model design. • Defined scope, objectives and approach for migration of data from Carillion’s legacy systems as part of Tranche 1A implementation • Provided migration team with a roadmap to perform data conversion, and ensured team members understood and followed the same approach • Exclusively involved in defining data architecture, Master Data Management principles and data model design.

Data Architect

• Mar 2014 - Sep 2016

• Represented Information architecture for the solutions with IT and business stakeholders • Designed Semantic Layer to support analytic tools like Business Objects or Tableau. • Modelled multi-layer architecture from Integration Layer (extracting data from multiple source systems) to Enrichment Layer (Deriving Business Needs) to User Layer (Deliverable to Business as views). • Profiled data in multiple legacy systems • Reconciled existing finance report with At User Views and… Show more • Represented Information architecture for the solutions with IT and business stakeholders • Designed Semantic Layer to support analytic tools like Business Objects or Tableau. • Modelled multi-layer architecture from Integration Layer (extracting data from multiple source systems) to Enrichment Layer (Deriving Business Needs) to User Layer (Deliverable to Business as views). • Profiled data in multiple legacy systems • Reconciled existing finance report with At User Views and helped users adopt the system. • Studied customer experience and predicted prospective customers for Mortgage and other products • Responsible for Delivery of the Information Data Model based on FSLDM and Data Flow Diagrams for various DWH projects.

Solution Architect/ Data Architect

• Aug 2012 - Feb 2014

• For LBG GDW Batch Optimisation Program, analysed critical batches, redundant jobs, alerted gaps that ran in the platform and provided high-level recommendation for scope of optimization. • Analysed upstream and downstream applications in GDW platform, identified their dependencies and provided recommendation for optimising the data flow from each of these systems. • Identified Batch Queries which utilized more resources on Batch Window and recommended necessary changes.

Data Architect

• Nov 2009 - Jul 2012

For General Electric Commercial Finance Transformation Program; analysed the requirements for different business and profiled data from Source and Enterprise Data Warehouse (EDW). • Identified the entities to be mapped in Teradata Financial Service Logical Data Model (FSLDM) for different businesses . • Customised /modelled new entity in FSLDM and got design approvals from Data Model Governance Group. • Prepared and released ETL specification document and coordinated with ETL team for… Show more For General Electric Commercial Finance Transformation Program; analysed the requirements for different business and profiled data from Source and Enterprise Data Warehouse (EDW). • Identified the entities to be mapped in Teradata Financial Service Logical Data Model (FSLDM) for different businesses . • Customised /modelled new entity in FSLDM and got design approvals from Data Model Governance Group. • Prepared and released ETL specification document and coordinated with ETL team for implementation. Show less For General Electric Commercial Finance Transformation Program; analysed the requirements for different business and profiled data from Source and Enterprise Data Warehouse (EDW). • Identified the entities to be mapped in Teradata Financial Service Logical Data Model (FSLDM) for different businesses . • Customised /modelled new entity in FSLDM and got design approvals from Data Model Governance Group. • Prepared and released ETL specification document and coordinated with ETL team for… Show more For General Electric Commercial Finance Transformation Program; analysed the requirements for different business and profiled data from Source and Enterprise Data Warehouse (EDW). • Identified the entities to be mapped in Teradata Financial Service Logical Data Model (FSLDM) for different businesses . • Customised /modelled new entity in FSLDM and got design approvals from Data Model Governance Group. • Prepared and released ETL specification document and coordinated with ETL team for implementation. Show less

Team Lead

• May 2007 - Oct 2009

• For Telstra EDW Transformation Program, designed and developed Datastage jobs for Event Base and Party facets. • Designed transformation business rules using Teradata Utilities for Back Loading process. • Designed BTEQ and Procedures for retrofit activities to update existing ADS data as per business rule. • Successfully built Telstra’s EDW on Teradata Communication logical data model. • For Telstra EDW Transformation Program, designed and developed Datastage jobs for Event Base and Party facets. • Designed transformation business rules using Teradata Utilities for Back Loading process. • Designed BTEQ and Procedures for retrofit activities to update existing ADS data as per business rule. • Successfully built Telstra’s EDW on Teradata Communication logical data model.

Team Member

• Jun 2006 - May 2007