SUMMARY:

A Banking and Financial Services (BFS) technology leader with 19 years of consistent experience across the enterprise data management ecosystem; an expert in industry models and data integration solutions.

DOMAIN EXPERTISE:

BASEL

Credit Risk Reporting

Commercial Lending

P&C Insurance Analytics

TECHNICAL EXPERTISE:

Industry Models: IBM BDW, IBM IIW, SAS DDS

Data Management: EDW Party MDM, Data Management

Banking Platforms: Confidential, AFS, ACBS, FDR, MISER, Aspire Lease, ACLS, CRIF, CMSI, UNIFI, HOGAN, FLP, SHAW, STUCKY and CLC

Tools: and Technologies ERWin, ER Studio, Oracle 10g, Exadata, SQL Server, Informatica Power Center

EXPERIENCE:

Confidential

Senior Data Architect

Responsibilities:

• Designing custom master data management solution for a regional bank as part of Enterprise Digital Integration Platform.

Confidential

Senior Data Architect

Responsibilities:

• Designed an integrated Operational Data Store for provisioning data related to commercial loans, borrowers, guarantors, collaterals and deposits to cloud - based loan origination platform Confidential (hosted on Salesforce)
• Architected an end to end solution for provisioning data to Actimize CDD implementation at regional bank with assets over 140 Billion.
• Designed an Integrated Data Repository using SAS DDS Model to integrate loan origination, servicing, charge off and recovery data for a regional bank s credit risk reporting.
• Designed Customer MDM and Data Management solution using Informatica MDM for a regional bank with assets over 40 Billion.
• Cognizant Technology Solutions, Architect - Technology
• Designed enterprise data warehouse and reporting solutions for P&C insurance organizations with books of business more than $3 billion, using IBM s Insurance Information Warehouse framework.
• Tata Consultancy Services, Data Architect
• Architected an IBM BDW centric information platform, for a bank that became a $252 billion entity post-merger, so that they could be BASEL II compliant.
• Designed data mart for marketing performance analytics (conversion funnel).
• Designed OLTP systems for employer pension plan, wealth management platform.

Confidential

Senior Data Architect

Responsibilities:

• Requirements gathering and data analysis of attributes that are part of Confidential
• Identification of attributes that are required in match and merge process.
• Creating baseline match and merge rules, trust framework and threshold scores for auto merge vs manual merge and discussing it with SMEs
• Designing Logical and Physical data model for Confidential core tables, configuration tables and stage tables
• Guiding Python development team while building match and merge POC.
• Participating in different Agile Scrum activities like Sprint Planning, Backlog Refinement and Sprint Review

Confidential

Data Architect

Responsibilities:

• Lead the legacy data capture track to gather domain based (Loan, Customer, Collateral, Rate and Payment) data requirements for Confidential
• Identification & documentation of validation rules in existing loan booking systems and loan approval system. data identification and standardization for CLM program including Product and Collateral Type standardization across the systems and mapping into Confidential
• Source system data analysis for loan servicing systems like AFS, SHAW, CLS, CLC, FLP and STOC.
• Designed an on-premise integrated Operation Data Store (ODS) which acted as single source for pushing data to cloud database.
• Creating source to target data mapping documents for ODS.
• Designed an end to end data architecture for moving data from on premise applications to a new cloud-based platform Confidential
• Developed data acquisition strategy, change data capture strategy and Confidential load strategy
• Identifying data quality issues and coordinating with data quality team on fixing the issues in source systems.

Confidential

Information Architect

Responsibilities:

• Designing an end to end solution to provide data into Actimize CDD staging area.
• Analyzing the Actimize data requirements and source system analysis.
• Creating Data Model for CDD stage area and ETL audit balance control.

Confidential

Information Architect

Responsibilities:

• Architected CRR (Credit Risk Repository) feeds from Confidential legacy systems to Confidential .
• Architected Treasury Management data feeds for Customer, Account and Services, to convert Confidential online banking customers to Confidential ’s online banking platforms.
• Designed Confidential ’s loan valuation extracts for EVOLV -Primatics

Confidential

Information Architect

Responsibilities:

• Analyzed different source systems to identify customer related data.
• Designing the Informatica MDM Landing Data model.
• Designing the Informatica MDM Target Data model.
• Acted as IT SME for mapping customer data from 7 source systems into MDM landing data model.

Confidential

Information Architect

Responsibilities:

• Source system data analysis for loan origination systems like CRIF, UNIFI, CMSI and different loan servicing systems like FDR, ACBS, Miser, Aspire Lease and STUCKY.
• Designing the Integrated Data Repository (IDR) by integrating retail and commercial loan and deposit accounts.
• Mapping of credit risk data elements into SAS Detail Data Store (DDS) model. Customization of SAS DDS model for Confidential requirements.
• Integrating Retail loan origination (Mortgage, Indirect Loan, Credit Card, HELOC) data into IDR.
• Designing the GL Reconciliation process for retail assets in IDR.
• Helping data governance team in rationalizing the codes and descriptions at enterprise level.
• Reviewing the design artefacts with information architects
• Preparing source to target data mapping document for ETL development.
• Interacting with DBAs and Release Manager for production release management

Confidential

Solution Architect

Responsibilities:

• Understanding and analyzing the functional requirements from Business Requirement Document and Data Requirements Document.
• Mapping of data elements from Data Requirements Document (DRD) into the IBM IAA Business Object Model.
• Conducting gap analysis between requirements and IAA business object model and proposing customization to the base model.
• Developing the IAA Business Object Model for Confidential specific requirements by adding Types, Attributes and Associations using the Rational Software Architect.
• Defining the logical data model for Operational Data Store (ODS).
• Managing metadata around different types attributes enumerations and business rules.
• Reviewing the modelling artefacts with Confidential architecture team

Confidential

Data Architect

Responsibilities:

• Understanding the analytical reporting requirements around Auto Insurance and Billing and Payment.
• Analyzing the universal dimensions, auto insurance dimensions and measures matrix.
• Mapping high level requirements to different IIW subject areas and entities and come up with conceptual model.
• Reviewing the conceptual model with the IT team and business SME.
• Mapping required data elements into IIW model, identifying gaps in IIW model and customizing the model for Confidential Insurance requirements.
• Created the logical data model for enterprise data warehouse (atomic layer) using ERwin.
• Created different scenarios for Role Player and Money Provision subject area for discussing with business and development team.
• Reviewing the logical data model with business SME.
• Designing the foundational dimensional model (Policy Transaction Star Schema) for Auto Insurance LOB
• Reviewing the model with architecture team and Business SMEs.
• Preparing Source to Target data mapping documents for ETL specification.
• Interacting with data governance team to standardize the calculation formulas, data element naming standards and data definition.

Confidential

Information Architect

Responsibilities:

• Analyzing source system data from different source systems like FDR (Credit Cards), ACLS (Instalment Loans), MSP (Mortgage Loans), ACBS (Commercial Loans and Commitment), NC4 (Commercial Lease).
• Analyzing the new requirements for each release from different data consumers like SAS Risk Modelling, BASEL II, OCC data submissions and Credit Quality Book.
• Creating conceptual design and high level data flow diagram and reviewing the same with information architects.
• Logical and Physical data modelling of Enterprise Data Warehouse (EDW) by using Erwin and IBM’s Banking Data Warehouse (BDW) methodology.
• Creating and updating enterprise data domains, classification schemes and naming standards.
• Interacting with DBA’s for schema creation, alterations, indexing strategy and partitioning strategy.
• Created Source to Target mapping document.
• Designing the EDW General Ledger Reconciliation process
• Designing the Enterprise Data Exchange (EDX) dimensional model layer and Credit Quality Book data mart by using conformed dimension created in EDX layer.

Confidential

Data Modeler

Responsibilities:

• Interacting with business users to understand the reporting requirements.
• Source system data analysis of different source systems like IVR, Campaign Management and Advisor System to identify data that needs to be brought into reporting database.
• Source system data profiling to understand inter-relation between different entities, domain values, null counts.
• Designing the staging schema, data acquisition strategy and change data capture logic for each source system.
• Logical and Physical data modelling of facts and dimensions by using Power Designer 12.5.
• Interaction with DBAs for schema creation, alterations and indexing strategies.
• Preparing Source to Target Mapping documents for ETL Development with transformation logic and filter criteria.

Confidential

Data Architect

Responsibilities:

• Analyzing the business requirements and coming up with conceptual data model.
• Creating Logical Data Model by using QDesigner 11.
• Creating Physical Data Model and DDL Scripts.
• Doing the impact analysis of Change Requirements.
• Reviewing the code changes for a CR and testing the same in system testing environment.
• Preparing the DB Release note for each release.
• Analyzing Top 10 SQLs for performance improvement by using Explain Plan.

Confidential

Data Architect

Responsibilities:

• Gathering, analysis, and translation of business requirements into a conceptual data model for Client Portfolio Management (CPM) module.
• Create Logical Data Model in ER Studio.
• Reviewing logical data model with technical architects.
• Create Physical Data Model and DDLs using ER Studio.
• Data model management activities like creating new data domains, merging of ER Models during baselining effort.
• Development and testing of PL/SQL packages and triggers.
• Preparing ETL data mapping documents for data movement from EDB to Reporting database