Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

ANUJ GUPTA

Pune

Summary

Strategic IT leader with 20 years of expertise in Data Architecture, Enterprise Data Modeling, and ETL solutions. Specialist in Google Cloud Platform (GCP) Data Solutions with a proven track record of delivering large-scale data transformations for global firms including HSBC, IBM, Capgemini and Deloitte. Expert at bridging the gap between business requirements and complex technical data landscapes.

Overview

1
1
Language
6
6
Certifications
21
21
years of professional experience

Work History

Lead Data Modeller

HSBC EDPI
12.2024 - Current
  • Worked on Application Data Models for Finance.
  • Streamlining the Data Architecture approach by creating artefacts such as Business and Tech Data Flows, defining reference data, Naming Standards for Data Assets, Data Landscape for Finance Subject Area.
  • Owning Application Data Models for Finance Data Platform.
  • Getting the requirement for Finance Data Assets for different use cases and convert into Application LDMs.
  • Creating ALDM from Bottom Up approach and align the same with Enterprise Data Models.
  • Project Handled: Finance
  • Period: Dec 2024 to till date
  • Tools Used: Data Architecture/ Modelling Tool: Visual Paradigm, ERwin, Collibra
  • Data Initiatives: GCP Suite of Tools: Big Query, Data Catalog, Cloud SQL, CloudStorage, Dataflow
  • Collaborated with cross-functional teams to ensure model relevance and applicability.
  • Streamlined processes, resulting in increased efficiency in model creation and analysis.
  • Mentored junior modelers, fostering a culture of continuous learning and growth.
  • Managed multiple modeling projects simultaneously, delivering timely and accurate results.
  • Managed identification, protection and use of data assets.

Sr Data Architect

HSBC Technology India
09.2021 - 12.2024
  • Worked on various Data Architecture Initiatives for Compliance.
  • Owning Enterprise Data Models for Risk Management.
  • Working on building Enterprise wide Conceptual and Enterprise Logical Data Model for Risk Management under Risk and Compliance Service Line using BIAN BOM Approach.
  • Working on aligning Enterprise Data Models for existing applications using BIAN Architecture.
  • Worked on unified Architectural Data Flow Diagram by aligning Collibra Data Assets and Application Inventory, which can be used to define and catalogue the process and associated business/technical data elements.
  • Worked on defining enterprise level Data Storage decision guidelines based on different use cases.
  • Working on Data Architecture advisory for Cloud migration solutions.
  • Responsible for Data Controls implementation in Compliance area.
  • Created Data Mesh Metadata Model using GCP Suite of Tools, which was planned to use data pipeline solutions on Cloud Platform.
  • Worked on initiative for Data Entitlement using GCP Suite of Tools , resulting in generic automated solution.
  • Worked on Low Code No Code POC for Workflow process that can be utilised across the Organization.
  • Creation of Logical data models for Compliance area to complete the missing artefacts.
  • Working on initiative to Source Controlled Data Models using ant script and Cloud SQL env.
  • Working on initiative to integrate Data Governance Tool Collibra with Data Modeling tool.
  • Worked on Data reference Architecture Process for On Cloud/On-premise solutions.
  • Project Handled: Compliance Central Data Architecture
  • Period: Sep 2021 to Dec2024
  • Tools Used: Data Architecture/ Modelling Tool: Visual Paradigm, IDA, Collibra
  • Data Initiatives: GCP Suite of Tools: Big Query, Data Catalog, Cloud SQL, CloudStorage, Dataflow

Data Architect

HSBC EDPI
05.2020 - 09.2021
  • To work with Compliance CDO team to handle business data modelling requirement and enrich the existing HBIM model w.r.t. Collibra assets as per DMAN1 initiatives.
  • Worked on different requirements for Critical data asset and Preferred Business Term maintenance within collibra for Compliance.
  • Analysis work w.r.t. DMAN initiatives.
  • Creation of Collibra assets such as Preferred Business Terms and Critical Data Elements and mapping them with Physical Data Assets.
  • Creation of Logical data models for Compliance area to complete the missing artefacts.
  • Project Handled: Compliance Business Data Modeling
  • Period: May 2020 to Sep 2021
  • Tools Used: Data Modelling Tool: Visual Paradigm, IDA
  • Data Governance: Collibra

Senior Data Modeller / Data Architect

IBM India
10.2017 - 04.2020
  • To develop a new BIW solution to replace current Warehouse that has scattered approach and no enterprise wide presence. Utilize Big data and Spark technologies for better and faster results.
  • As design team member, managing Marketing Exclusions and Personal Banking Products design activity.
  • Involved in KPI Analysis, identification ofgolden source, data analysis of Source data, Transformation of Business requirements to Technical model, discussions with Requirement team, Business SMEs.
  • Ensuring Creation of LDM and PDM for BSL and mapping to support ETL flow.
  • Creating and reusing Reference Data required for design, supporting ETL development for the same.
  • Successfully delivered 3 projects involving 300+ KPIs, where responsible for end to end delivery of project starting from Requirement gathering to production move.
  • Project Handled: 9PSDM – EDW Design
  • Client: Leading Multinational Bank (Client is a multinational bank and financial services company. It is a universal bank that has operations in over 50 countries)
  • Period: Oct 2017 to till date
  • Tools Used: Database: Hive, Teradata Data Modelling Tool: ER Studio
  • Data Processing: PySpark

Manager

Capgemini India
05.2015 - 10.2017
  • Managed the RFDW team as Technical Manager for data flow.
  • Co-ordinated with the client to define the ETL architecture for source system modifications/enhancement and new business segment on-boarding.
  • Worked on existing Data Model enhancement to incorporate new changes of feeds/business segments.
  • Executed process improvement plan for current data drop requests.
  • Gathered business requirements and created the framework; worked on DWH data model which contains migration of current DWH along with new enhancements from SQL Server to Netezza DB.
  • Co-ordinated with the onsite team to define the ETL architecture.
  • Project Handled: RFDW (Credit Risk and Finance data is transmitted through various systems to suffice different reporting and analysis requirements. RFDW works as a middleware single system that consumes data from multiple source systems and provide it to multiple downstream)
  • Client: Leading Multinational Bank (Client is a multinational bank and financial services company. It is a universal bank that has operations in over 50 countries.)
  • Period: Feb 2017 to Oct 2017
  • Tools Used: Database: Oracle 11 g / OS: Unix / ETL Tool: Informatica PowerCenter 9.6
  • Project Handled: Reinsurance Analysis
  • Client: Leading Reinsurance Company (Client is a global reinsurance group having worldwide operations mainly in P&C and Life business lines.)
  • Period: May 2015 to Jan 2017
  • Tools Used: Database: Netezza 7.2 / OS: Unix / ETL Tool: Infosphere Datastage 9.1

Senior Consultant

Deloitte Consulting India
08.2013 - 05.2015
  • Implemented a resource model that provided highly skilled resources at a very reasonable rate.
  • Led the technical design, build and testing phases of the engagement as well as improved visibility and transparency into Actuarial IT Application Portfolio.
  • Created a scalable, replicable and extensible Claims Triangle application that reduced manual processes and reliance on fragmented technologies.
  • Laid the foundation in creating a scalable and reusable ETL architecture which was leveraged across the Finance Transformation projects.
  • Refined requirements with effective interaction with the Business and other stakeholders.
  • Provided single source of policy/customer level information for TPA Files, Shoe Box Policies, Dummy Policies and Manual Policies leading to improved data granularity, consistency and accuracy for Finance & actuarial reporting.
  • Rendered significant reduction in manual processing and maximum system availability across the applications, as part of Production Support.
  • Enable backfill for critical client’s IT SME’s to have them better focus on larger firm wide initiatives.
  • Project Handled: Demand XD
  • Client: Leading Financial Group from USA (Client, a financial services holding company based in Carmel, Indiana. Client's insurance subsidiaries provide life insurance, annuity and supplemental health insurance products to more than four million customers in the United States.)
  • Period: Aug 2014 - May 2015
  • Tools Used: ETL: Informatica 9.1 / Database: Oracle 11g / OS: Unix
  • Project Handled: CV Datamart
  • Client: Leading Soft Contact Lens Manufacturer(Client is a soft contact lens manufacturer. The company was founded in 1980. It has presence over 100 countries.)
  • Period: Aug 2013 - Jul 2014
  • Tools Used: ETL:Datastage 9.1 / DB: Netezza 9.1 /Oracle 10g/MS SQL SERVER 2012 / DataModeling:SQL POWER ARCHITECT 1.0.6

Tech Lead

Wipro Technologies
07.2012 - 08.2013
  • Working as Project Lead, having ownership for preparing the Data Model along with ETL strategy definition and implementation.
  • Responsible of end to end delivery of the project while leading a team of ETL developers.
  • Project Handled: SCV Ireland: SCV (Single Customer View)
  • Client: Leading International Bank (Client, one of the major international banks working for more than 200 years now, is one of the top 5 bank holding company in the United States by total assets. It has retail banking operations in over 160 countries and territories around the world.)
  • Period: Aug 2012-Aug 2013
  • Tools Used: ETL: Datastage 8.5 / Database: Oracle 10g / OS: Unix

Data Specialist

IBM India Pvt. Ltd.
07.2010 - 07.2012
  • BI Development / CEO Dashboard / FPM (Reporting Project)
  • Tools Used: ETL: Datastage 8.1 Database: Oracle 10g/DB2 8.2 / OS: Unix DataModeling: IDA 7.3

System Engineer

TCS India
09.2005 - 06.2010
  • Activity ODS Development
  • GBS LR- TURBO
  • Tools Used: ETL: Informatica 8.1 / Database: Oracle 10g / OS: Unix
  • Tools Used: ETL: Informatica 8.1/Datastage 7.5 Database: Oracle 10g / OS: Unix

Education

B.Tech - Production Engg.

G.B. Pant University of Agri & Tech
Pantnagar
06-2005

Skills

Data Strategy: Enterprise Data Modeling, Data Governance and Data Mesh

Cloud Engineering: GCP (BigQuery, Dataflow, Cloud SQL, Data Catalog), Azure Fundamentals

Data pipeline design

Data migration

Data security

Data modeling

Data integration skills

Data lake management

Big data technologies

Data integration

Data warehousing expertise

Certification

BIAN Banking Architecture Foundation (Valid Upto Dec-2025)

Timeline

Lead Data Modeller

HSBC EDPI
12.2024 - Current

Sr Data Architect

HSBC Technology India
09.2021 - 12.2024

Data Architect

HSBC EDPI
05.2020 - 09.2021

Senior Data Modeller / Data Architect

IBM India
10.2017 - 04.2020

Manager

Capgemini India
05.2015 - 10.2017

Senior Consultant

Deloitte Consulting India
08.2013 - 05.2015

Tech Lead

Wipro Technologies
07.2012 - 08.2013

Data Specialist

IBM India Pvt. Ltd.
07.2010 - 07.2012

System Engineer

TCS India
09.2005 - 06.2010

B.Tech - Production Engg.

G.B. Pant University of Agri & Tech
ANUJ GUPTA