Data Architect Management

ATANU BISWAS

Email : *********@*****.*** ( Preffered Contact Method )

Phone : 240-***-**** ( R ) / 302-***-**** ( Cell )

Immigration Status : US Citizen

SUMMARY

Have over 14 plus years ( overall twenty five plus years in IT ) Data

Management experience in USA, with concentration on Data Architecture

Management, Data Development and Metadata Management :

. Strong in - Conceptual / Logical - 3 NF ( learned from IBM

Consultants, Anderson Consultants and Sr. Enterprise Data Architects

of J P MorganChase ), Physical Modeling, Business requirement

analysis and Dimensional Modeling ( including conceptual Dimensional

Fact Modeling )

. Other model related Hands-on experience in -

Compare and Merge, Generation of DDL, Version control, Defect

Resolution, Data Analysis

Exposure to Industry Models - IBM Retail Data Warehousing Model, IBM

Insurance

Warehouse Model ( IIW )

Customized UML Class Diagrams ( IBM Insurance Business Objects Model )

based on

Use Cases

. Experience with ---

a) Creating XML - Schema with tools like XML SPY,Rational Rose,

Rational Rosescripts

b) Informatica Metadata Manager

Exposure and experience with NIEM ( National Information Exchange Model )

Exposure, experience and knowledge of --- Data Management Principles, Data

Governance ( Data Management Council, Data Review Board and Data

Stewardship ), Metadata Management, Data Standards, Data Flow Diagrams

and BPMN Models

Exposure and knowledge of Data Architecture related DIV/1/2/3 of DoDAF

( Department Of Defence Enterprise Architecture Framework ), Data

Reference Model of FEA ( Federal Enterprise Architecture Framework )

RDBMS ( Optimization, Indexing, Constraints ) --- Oracle 11.x ( PL/SQL ), Teradata

12.x, DB2 V 8.2

EDUCATION :

Bachelor Of Engineering in Mechanical Engineering from National Institute

Of Technology, Durgapur ( West Bengal ), India. Specializing in Industrial

Engineering and Material Handling

Proffesional Training :

. Retail Enterprise Model of IBM, IBM Insurance Business Object Model,

Rational Rose UML Tool

. Informatica Powercenter / Powermart 5.x

. Embarcadero Describe 5.0 ( UML Tool ) and ER-Studio 7.x

Experience in USA

Data Architect / Sr. Data Modeler

Mar'2014 --- Present

NCI Informations Systems, Inc

Working, for a project with Federal Agency, with Enterprise Data

Management team ( reporting to Chief Data Officer ). Responsibility

. Since agency has started re-engineering their legacy applications,

playing temporarily, the role of a Data Analyst for analyzing the "

Tracking " and " Licensing " subject areas using the information in the

reversed-engineered Data Models and the Enterprise Repository Data

elements.

? Based on the analysis - Conceptual Models are being

developed and will be mapped to the Enterprise Process Model.

. Worked for the Licensing Subject area -- creation / documentation

of the Prototype Data-mart Model ( using Ralph Kimball approach ) .

? Study of the Requirement document prepared by Business

Analyst

? Document measures / hierarchies for Fact - Dimension,

using Dimensional Fact Modeling ( DFM ) approach

? Creation of the Bus Matrix for Conformed dimensions

? Analyzing canned reports and identifying measures (

existing )

? Source to Target Data Mapping, Source data analysis

? Conformed Entities -- Identifying / creation of conformed

entities to be shared across Licensing System

. Suggest approach plan for existing Legacy Metadata Repository data

elements, for improvement in terms of -- redundancy, duplications,

naming standards and business definitions ( where applicable )

. Gain knowledge of Amazon Web Services ( AWS ), Amazon Redshift, MongoDB

and Accumulo

Tools Used : PostgreSQL 8.x ( along with pgAdmin tool ), Oracle 11x,

PowerDesigner, SAP Business Objects 4.1, Rapid SQL, Informatica Analyst (

data profiling )

Data Architect / Sr. Data Modeler

July' 2013 --- Mar'2014

Fannie Mae,Tenlytown - AU, Washington DC

Worked, on contract, with the Enterprise Data Governance and Management

Office of Fannie Mae . This department is responsible for the Enterprise

Data Architecture artifacts ( Enterprise - Conceptual and Logical Data

Model ( Cannonical Data Model ), CORE / Enterprise Data Glossary, Data

Governance and Data Quality, Enterprise Repository Management ( EMR ).

As a team member with Securities and Party subject area, responsibility

includes ---

. Creation of the Securities and Party ELDM subject area ( using top-

down and bottom-up approach )

o Attend work sessions with Business Analyst / Data Warehouse

Analyst -- for eliciting business requirements, designing the

Security and Party Conceptual and ELDM ( top-down approach )

o Analysis of existing Data-warehouse Model, Data-mart

Models,source application models, PL/Sql source codes --- for

understanding the data objects to be modeled ( bottom-up

approach )

o Reconcile Business requirements, Process Model and Enterprise

Logical Data Model ( ELDM ) and create the CRUD Matrix

o Provide input to creation of the Integrated ELDM Model showing

relationship between subject areas - Security, Party, Loan,

Agreement, Property

o Based on scenario's provided - creation of individual subject

area based Message Models, with controlled de-normalization and

hierarchy leveling and converting the same to XML - for defining

standard data formats and semantics for the data being exchanged

between systems

o Data Governance activities ---

. Model review, Model defect capture and resolution

. Validating metadata with

. Mortgage Industry Standard Models ( MISMO ) and

. CORE / Enterprise Data Glossary

. Generate Data Model Quality Control Reports

. Class Word check, Primary Qualifier check,

Abbreviation check

. Escalation of requirement issues to Management

Tools Used : ERStudio with repository, Enterprise Metadata Repository ( EMR

/ IMR ) using Informatica Metadata Manager,Mortgage Industry Models (

MISMO, SIFMA ), IBM Rational ClearQuest

Data Architect / Sr. Data Modeler

Oct'2012 --- June 2013

United States Patent and Trademark Office ( USPTO ), Alexandria, VA

Worked with the Enterprise Data Management Group of USPTO on behalf of

ManTech International. The group owns the EDW Model and is also responsible

for Enterprise Data Governance . Due to the re-engineering effort going on

across USPTO, as a member of the group responsibility includes

. Creation / Maintenance of EDW Model ( Dimensional Model ) based on re-

engineering Project requirements

. Based on related Business Requirement document, reviewing and

approving ( with the goal of ensuring data quality ) the --- source-to-

target mapping document, ETL mappings documents showing the

new/updated/changed data structures for the Target ( EDW )

. Complete the data modeling efforts for individual BI/DW projects

ensuring the consistent use of data element names, data types,

business definitions as well as domain / range values

. Data Governance activities ---

o Ensure that Enterprise Information Repository ( Rochade ) is

maintained across multiple systems, and particularly the

metadata for the EDW

o Provide EDW data model version control and reconciliation with

Production

o Reviewing the re-engineered source data model for adherence to

USPTO Data Modeling Standard

Tools Used: IBM Infosphere Data Architect, Enterprise Information

Repository ( Rochade ), IBM Clearcase

Data Architect ( Enterprise )

April' 2011 --- Sept'2012

Science Application International Company ( SAIC ), Washington DC

Worked with Enterprise Data Architect Group of SAIC for projects related to

Immigration and Customs Enforcement ( ICE ), a division of US Homeland

Security. This group is responsible for, creating the Enterprise Data Model, perform Value Chain Analysis ( Gap Analysis, CRUD ) and follow the

Federal Enterprise Architecture ( FEA ) framework. As a member of the team

responsible for the following tasks ---

. Device Enterprise Conceptual Data Model and Enterprise Logical Data

Model using both top-down ( Business Requirements, Process Model )

and bottom-up approach (( the source models are - a) Data-warehouse

Model, b) Dimensional Models of ICE specific subject areas and c)

Application source models )) along with Data Dictionary Repository

and Metadata

. Mapping the ICE Conceptual Model to the Department Of Homeland

Security Enterprise Conceptual Model

. Contribute to, the creation of context and structures ( Domain

Model - Class Diagram for a scenario ) required in the

information exchange between DHS domains ( NIEM ), in terms of

providing table / column mapping existing in Enterprise

Conceptual Data Model, Enterprise Logical Data Model of ICE for

the IEPD Domain Model classes and contents

. Data Analysis of existing data and PL/Sql codes

. Interact with Enterprise Business Engineering group to reconcile

Business Requirements, Process Model and Enterprise Conceptual Model

to create a Gap Analysis checklist

. Responsible for reviewing source models ( E-R and Dimensional ) as per

Data Management Plan ( DMP ) of Immigration and Customs Enforcement (

ICE )

Tools used --- Oracle Database 11.x, ERWin 8.x / 7.x ( with Modelmart

), ERWin Process Model

Data Architect - Design ( Enterprise )

July' 2010 - March'2011

DeCA ( Defence Commissary Agency ), Fort Lee, VA

Worked with Business Information Engineering - Enterprise Data Management

group of DeCA ( Defence Commissary Agency --- Department Of Defence ) in

Fort Lee,VA on behalf of Claraview ( a division of Teradata ). The group is

responsible for creating Business Information Models ( BIM ), Enterprise

Logical Data Model, Data Governance Standards and Policies along with Meta-

data Repository for structured and unstructured data as per DoD

Architecture Framework (DoDAF).

As a member of the team responsible for following tasks

. Gaining knowledge of the existing EDW ( Teradata ) Logical and

Physical Model, including views and aggregates

. Used SAP - Business Objects Designer to create and load

structured data in Informatica Metadata Manager (IMM) tool -

from BO Universe and EDW Database ( in Teradata ), which in

turn will be connected to Master Data, Reference Data populated

from ELDM

. Extend the existing draft Conceptual Data Model with information

collected during workshops conducted by Claraview and Gartner

with DeCA's SME's, Store and department heads for Contract and

Resale Item functional areas

Tools used --- Teradata Database 12.0, Teradata SQL Assistant, BO

InfoView / Designer ( Enterprise X1 Release 2 ) and Informatica Metadata

Manager 8.6.1, Systems Architect 11.x

Data Solutions Architect

Sep' 2006 - June'2010

JPMorgan Chase, Wilmington, Delaware

Responsible for the Marketing Services ( Credit Card Services )

application ( Campaign and Offer Mgmt. System, Premium Rewards Engine )

and Data-marts ( Reporting and Analytical Environment ( RAE ) ), in terms

of ---

. Participate in requirement gathering activities for defining

the scope, detail requirements and any business rule change

or changes to source feeds

. Issue resolution with the business team to ensure business

requirements are understood, aligned with and supported by

the data model.

. Focus to ensure that the business requirements are supported

by the model and that best practice design concept are

maintained

. As part of Data Governance

. obtaining approval from the Data Review Board for any new

/ enhancement to existing Data Models in terms of data

modeling standards and requirement capture

. as a data custodian, work with Data Stewards in order to

obtain approval from the Data Management Council for

addition of a control data element ( which may be termed as

Enterprise Level ) and related Valid values

. convert models to XML format and upload to Enterprise

Metadata Repository for sharing of metadata across

enterprise

. perform data profiling and upload relevant data to a

repository -- used by Data Stewards for data quality

. Maintain model versions in ERWin Modelmart

. Involved with review / enhancements / maintenance of the

departments Reporting And Analytical ( RAE ) Data Mart model

( in Oracle ) along with Data Integration activity ( used

Informatica 8.x ), related to Marketing Campaign for

prospective customers. Data is sourced and integrated from

Prospect Database ( designed and maintained by third party )

and the companies Mkt. Campaign Planning database. The data

mart stores multiple Fact tables - Product Campaign Response,

Aggregated Facts ( for various dimensional hierarchy ) along

with Dimensional tables.

Data Architect / Data Modeler

Dec' 2004 - July'2006

The Children's Place, Garment Designer, Manufacturer & Retailer, New

Jersey

As a Data Architect / Data Modeler with Business Intelligence & Data

Warehouse department, performed following ( tools used --- ERWin 7.x,

ERStudio 7.x / 6.6.2 and DB2 V 8.2 as Repository Database ) ---

. Worked on RDWM ( the Retail Data-warehouse Model of IBM ) to be

used in the Central Data-warehousing project.

. Participate in discussions with IBM Consultants and

department team members, for understanding the

Enterprise Model for customization

. Customization of the model in terms of - creation,

updation of entities, attributes and relationships,

using the source applications Transaction Log files

. Creation of Source-to-Target Data Mapping

. Create / maintain Metadata and SQL Views for use in BI

Tool ( BRIO )

Web based Order Management System (E-Commerce )

1. Study of XML documents related to on-line order ( processed

by third party Amazon and also the firms website ) and used

as base input for the design of the Logical Model and

Physical Model E-R Model

2. Additional application requirement gathering through JAD

Sessions and User Interviews

3. DDL Generation

Requirement Modeler

Sep'1999 - Sep'2004

State Farm Insurance, Bloomington, IL

. Worked ( as a Contractor ) with Enterprise Model Administration

Department, and performed following work (using ERWin-Modelmart 4.1 )

o Worked with Business Analyst and Team Lead, to document the

hierarchies involved for the identified Dimension tables in the

Distributor Database and rolling-up the same.

o Attend review meetings and maintained the Dimensional Model of

Fire Claim, Fire Billing, Bank Deposits and Mortgage Loans

o Participated in ETL design sessions, using Informatica

Powercenter 7.x / 6.2.1 / 5.2 ), and gained knowledge related

to Informatica mappings / sessions / workflows ( only

start task and the session - executed thru pmcmd from a unix

script, as the company has their own workflows and scheduling

system ), performance tuning for mappings, Lookup ( static

cache ) Transformation, Expression Transformation, Filter

Transformation, Sequence Generator Transformation, Mapplets

with Input Port, Update Strategy Transformation and Joiner

Transformations in most of the mappings. Used Type I and Type II

Dimension Table updates.

o Customization, from Use Cases, of IBM Insurance Application

Enterprise Architecture models - Business Object Model and

Interface Design Model using Rational Rose

o For the firms EAI project ( with guidance from IBM Consultants )

--- written Rational Rose Scripts for

. Generating XML Schema definition ( using Rational Rose REI,

Embarcadero Describe Tool and XML Spy and MSXML 3.0 Parser)

from the Sequence Diagrams of IBM Business Object Model

o Customized and maintained the Enterprise Insurance Business

Object Model . Used Use Cases to Customize the Class Diagrams

and create Sequence Diagram, Activity Diagram.

Experience in India( Mumbai )

Solution Architect / Sr. System Analyst :

. Worked on a project for Videocon International Ltd., a consumer

electronic and home appliance manufacturing company in technical

collaboration with Toshiba, Japan. Some of the modules in this system

were: product management, reception, and job allocation. The platform

was Oracle 7.3, Developer 2000 and Unix

o Responsible for the requirement study, data modeling using

Oracle Designer 1.3, design, and user interaction .

. Worked on an Electronic Planning and Organizing system for an

advertising agency based in Germany. The system prepared a master

schedule (hourly, daily, quarterly, time slots) at the beginning of a

year for various stations attached to it. Other features of the system

were billing, reporting, and analysis.

. Worked on an office automation system, for chartered accountancy

company based in the United Kingdom. The modules covered were:

address manager, functional manager, document manager, staff manager,

correspondence manger, automatic faxing, and OLE.

o Tools and platform used for both above projects were : Windows

based PC, High end server (Compaq), Oracle 7.1/7.3, Power

Builder 4.0, Windows 95, UNIX, ER-Win3.0, Windows NT, VC++/MFC

5.0, SQL Server 6.5 / 6.0

System Analyst

. Worked on various projects --- inventory management system, credit

card system, airline booking package system online spare parts and

invoicing system. Tools and platform used were : Acer 486 PC, Oracle

6.0, SQL*Forms 3.0, Pascal, SCO UNIX, Windows 3.1

Contact this candidate