Datawarehouse architect

SUDIPTA MITRA

**** ******* ** *** ** PHONE: 224-***-****

DES PLAINES IL 60016 EMAIL: **********@*****.***

SUMMARY

Information management architect having 13 years experience in BIPM Practice of a Global IT consulting firms, providing Strategy & Solution for BI/DW applications to Fortune 500 clients.

DELOITTE CONSULTING LLP 02/09/2010 – till date

TATA CONSULTANCY SERVICES 12/05/1996 – 02/07/2010

EXPERTISE

• BI strategy, Assessment and roadmap

• Data Modeling

• Solution Architecture

• ETL Architecture

• Technical Leadership

• Tools & Technology evaluation/selection

• Capacity Planning

• Data Governance

• Master Data Management

• Inmon & Kimball Methodology, Best Practices

• Data Quality Assessment

• Metadata Management

• Performance Tuning

• Requirement Analysis

• Project/Engagement Management

• Scoping & Estimation

• Design , Development Implementation of BI/DW Projects

• Implementing Data Access Security for legal compliance

• Data Analytics / Data Mining

• Agile Methodology

• Onsite /Offshore execution

EDUCATION

Bachelor of Technology specialization Chemical Technology, University of Calcutta, India

INDUSTRY DOMAIN

FMCG, Retail, E-commerce, Banking, Credit Bureau Services, Telecommunication, Consumer Financial services, Manufacturing, Healthcare

TECHNOLOGY SKILLS

Database Technology - Teradata, Oracle 10 g, SQLServer, DB2, Redbrick

ETL Tools – Datastage 8.0.1/7.5.1, Informtica Powercenter 8, MS SQL Server DTS, Oracle Warehouse Builder, Quality Stage V8

Reporting Tools – Business Objects XI, OBIEE, ProClarity, Oracle Sales Analyzer, Microsoft Analysis Services

Languages – PL/SQL, Shell Scripting, Perl, SQL

Modeling Tool – Erwin, TOAD

Others - MS Office, MS Visio, MS Project

PROFESSIONAL EXPERIENCE

The list of projects below were executed for Deloitte’s clients where I am employed from 02/09/2010 till date

Architect Federal Depository Insurance Corporation Oct 10 – Till Date

Projects Bank Resolution and receivership

Key Activities

• Worked for the department of Bank Resolution and Receivership and participated in bank pre closing and closings.

• Performed download of deposit data and transformation and migration of the data to the Claims Administration system for Insurance determinations

• Used IBM infosphere to automate Account Ownership determination in deposits Data . Perfomed Data Quality Checks by ensuring trial balances match deposits data and the GL for specific product categories.

• Generated reports for Franchise Marketing, Claims and Proforma department to enable receivership & resolution processing of the financial institution by FDIC.

• Currently involved in re-engineering the system to have a single central repository and a reporting layer using Business Object & have automation of data processing.

Architect Genentech Inc June 10 – Aug 10

Projects MDM enhancement project

Key Activities

• Definition of Requirements, Functional Specs and strategy for migration of Roche HCO and HCP data into the Genentech MDM environment.

• Development, design of mapping.

• Managing work stream for Virology and Specialty master data migration to the Genentech environment.

ETL Architect Del Monte Foods Mar 10 – May 10

Projects Development of Incremental ETL logic for TPM implementation

Key Activities

• Responsible for providing the design of Incremental ETL for trade promotion management project in Oracle BI analytics package

• Development, design of mapping.

• Led development team in client meetings for KT sessions.

The list of projects below were executed for TCS’s clients where I was employed from 12/05/1996 to 02/07/2010

Data Warehouse Architect Walgreens Inc June 08 – Feb 10

Projects Development of E-commerce EDW

Development of Specialty Client Reporting

Inclusion of Mail Management subject area into EDW

Key Activities

• Responsible for providing the design for E-commerce EDW and the Specialty Client reporting Data Mart

• Delivered the Logical and Physical Data Model

• Implemented Data Security views to comply with HIPAA regulations for PII information

• Delivered ETL architecture and design

• Provided Solution for Product Data Integration in Walgreens EDW

• Provided Roadmap & Solution for Building the presentation layer on the EDW.

• Provided oversight to development activities for implementation of the project

• Advised on Development/Test/Production infrastructure setup requirements and capacity planning for the EDW project requirements

• Participated in JAD sessions with users groups to elicit business requirements

Lead Architect Hallmark Inc Nov 07 – June 08

Project Data Migration from Oracle Applications to SAP R/3

Key Activities

• Prepared Project Plan, effort & cost Estimates, Resource Scheduling plans, Identified Risk & issues

• Prepared the Functional Design document for mapping legacy functions to the target SAP R/3 modules.

• Identify data quality issues and compile recommendations. Interface with LOB Data Owners as needed to resolve source data quality and cleansing issue

• Manage, Monitor and support construction, SIT testing and production roll out of the Data Migration Software of the development team and report progress to the Hallmark IT project manager

• Delivered ETL architecture

• Designed ETL and Cleansing Modules

BI Engagement Manager Toyota Financial Services Mar 07 – Nov 07

Project Collapsing of Data Marts into Enterprise Data Warehouse

Key Activities

• Provide Solution for collapsing the existing data Warehouse application to the evolving OneSource EDW.

• Identified and promoted best practices and patterns for data modeling and provided oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.

• Provide Technical recommendations for optimized data access and retention for the data warehouse

• Build repository of reusable knowledge assets and implement best practices, concept documents for client education.

• Managed the teams involved in the engagement. Participated in staff recruitment activities for the engagement and mentoring team members.

• Lead aspects of proposal development process , scope out effort and cost of solution , develop statement of work

Project Manager British Telecommunication Plc Feb 06 – Feb 07

Project Openreach EDW development

Key Activities

• Review Logical and physical data model

• Project Hardware capacity requirements

• Provide oversight to all design and development activities

• Develop and communicate project plans, work assignments, target dates. Ensure that projects follow Agile development life cycle and meet quality standards

• Responsible for costing, budgeting, resource planning, quality, timely completion, contract management, billing, project health check, profitability, closure, issue resolution and escalation

Lead Architect National Health Service, UK Jul 05 – Jan 06

Project Development of Migration Tool

Key Activities

• Design and develop Tool using ETL and geo coding tools

• Presentation of Migration to stakeholders and end clients

• Implement data quality assessment framework

Technical Lead Experian UK Nov 04 – Jun 05

Project Customer Sales Data Mart

Key Activities

• Maintain and enhance existing data marts

• Strategize and architect the evolution of the of Data Warehouses from one that was loaded weekly to one that would be loaded daily

• Provide on call support to critical issues for resolution.

Data Modeler and ETL Lead Experian USA Mar 03 – Sep 04

Project Development of National Business Database

Key Activities

• Formulation of Blueprint for re-engineering of National Business Database

• Provide Solution Architecture, Technical architecture

• Tool Evaluation & Selection

• Gap Analysis between as-is and to be state

• Meeting Business Users for Requirements Gathering, Organizing JAD sessions/workshops

• Design of data model for National Business Database

• Data Quality Assessment

• ETL process Design, Design and development of cleansing strategy

• Development of Test Scripts

• Capacity Planning – provide database size projections

• System deployment

Prior to this during Dec 96 till Feb 03 have been part of development team of several projects implementing data marts, ODS, EDW, reporting solutions and ERP implementation having junior and senior developer roles. The client names and the period of work are mentioned below. Have also supported pre-sales activities for the BIPM practice of the company by writing proposals, providing estimations generating knowledge assets for the practices and supported enterprise wide training on DW concepts and tools

Role Client From – To Project Name

Data Architect Harrods UK Jul 02 – Feb 03 Sales data Mart

Data Warehouse Developer General Electric May 00 – Jun 02 CDS data warehouse

GE Digital Cockpit

FMIS Project

Global Data Warehouse Project

ETL and Report Developer Dumrath & Fassnacht Aug 99 – Apr 00 Sales Management System Data mart

Developer TATA bearings May 98 – Jul 99 Migration Legacy to Avalon MRP II system

Developer Heinz India Private Limited Feb 97 – Apr 98 Implementation & Customization of AVALON CIIM (an MRP package)

Contact this candidate