Harish Koduri ab9l2f@r.postjobfree.com

Columbus, OH **230, USA. Mobile: 614-***-****

Summary

Goal oriented, proven Senior Manager in the BI & DW Delivery, BI Portfolio

Management and Architecture with excellent communication and technical

documentation skills. More than 18 years of IT Experience of which 14 years

in Business Intelligence (BI). Highly Skilled in the BI Platform

Architecture, ETL Architecture & Design, Data Architecture & Integration,

BI Analytics, Project Management and Agile Development techniques. Drove BI

Roadmap, BI Organization Strategy & vision for Global EDW. Skilled in

partnering with the business to translate tactical and strategic business

needs into innovative Information Technology (IT) solutions.

Specialties: Business Intelligence, Data Warehousing, Customer Data

Integration, ETL, Data Architecture, Master Data Mgmt, Data Quality and

Strategy, Service Oriented Architecture, Data Privacy and Security

Areas of Expertise and Key Management Strengths

. 10+ Years of Experience in Senior Application Manager Roles providing

the technology leadership in BI Analytics, ETL and Data Architecture in

BI Projects. Managed Data Architects, ETL Architects/Developers and

Reporting Analysts of 20+ team sizes.

. 14 years of combined experience in Retail, Financial Services and

Telecom on Enterprise Data warehouse Implementation, EDW Releases &

Production Support

. Handled $10+ million dollar BI Projects

. 14 Years of Experience with Teradata & Oracle RDBMS

. 6 Years of SAP Retail & BW Experience

. 10 Years of ETL Tools Experience with Datastage, Informatica &

Abinitio

. 5 years of experience with Data Profiling tools (IBM Information

Analyzer, Informatica DQ)

. 10 years of experience working with Microstrategy and Cognos Reporting

Tools

. Experience in working with multiple brands, lines of business

executives in driving BI Roadmap, Strategy & Vision

. Key Liaison between BI Technology and Business Community

. Managed End to End Delivery of BI Project Portfolio for 10 years

. Managed Fiscal Annual Budget for BI Development Resources and External

Vendor Consultants.

. Experience of Global Delivery Models working with Multiple lines of

business and offshore development teams in enforcing BI Standards,

Architecture & Processes

. Well versed with Teradata Retail & IBM Banking Industry Data Models

. Established ETL Competency Centers at JP Morgan Chase and Limited

Brands

. Experience in establishing competency centers in ETL, Data Modeling &

Application DBA Areas.

. Successfully initiated & deployed multiple BI process improvements &

innovations

. Deployed various Agile Methodologies likes Iterative Development and

Scrum

. Well Versed with Star Schema, Dimensional Modeling, OLAP and data

modeling tools (ERWIN)

. Oversaw Platform Architecture, DR & Capacity Planning for EDW, Data

Marts & ODS.

. Oversaw publication of best practices for ETL and Data Model

Development

. Oversaw development of Reusable components which cut development by

25%

. Owned End to End Development of BI Projects including Dashboards in

Microstrategy, Data Marts and ODS.

Technical Proficiencies:

Data Integration/ETL: IBM Datastage 8.1, Abinitio GDE 3.0.2, Informatica

9.01, Tibco, MQ Series (Message Queues)

DW Platform : Teradata V2R13.1, SAP BW 7.0, DB2, Oracle 11g, SQL Server

Data Profiling : IBM Information Analyzer, Profilestage

Data Modeling : Erwin 7.2, IBM Data Architect

Analytics & Reporting : Microstrategy 9.02, SAS 9.2, Cognos 10

Programming Languages: C++, Java, PL/SQL

ERP: SAP Retail & Manufacturing Modules

SQL : Advanced SQL Skills in Teradata & Oracle Databases

Scripting: Advanced Unix Shell Scripting Skills, Visual Basic

Educational Qualifications:

. 1992-1995 Masters Degree in Computer Applications, Osmania

University, Hyderabad, India.

. 1996-1997 Masters Degree in Management and Information Systems,

Rajasthan, India.

Certifications/Training/Membership :

. Teradata V2R5 Master Certification

. Attended multiple Teradata Partner and TDWI Conferences

. TDWI Member

. Follower of DAMA-DMBOK (Data Management Association) Framework

Work Experience:

JP Morgan Chase November'11 thru Current

VP, BI Application Sr Development Manager

. Responsible for Entire Development Lifecycle which includes Data

Model, ETL and Ana lytics for Card Services, Mortgage Banking, Auto

Finance, Customer Profitability & Consumer Banking Projects into

Integrated Consumer Data warehouse

. Managed overall estimates and recruitment of DW & BI Resources

. Worked with multiple lines of business in understanding requirements,

business processes, negotiation and managing business expectations

. Managed BI Portfolio for Auto & Mortgage Banking Verticals

. Established ETL Competency & Application DBA Competency Centers

. Reviewed advantages of BI Architecture, Solutions and Vision with key

business stakeholders

. Delivered BI Analytics & Reporting in Cognos

. Oversaw Data Management Architecture for Semantic Layer, Data Security

& Data Modelling

. Responsible for overall architecture of ETL/ELT Framework for

Acquisition, Staging and Integration Layers in Integrated Consumer

Data Warehouse

. Core Member of Data Architecture Review Board. Reviewed several

projects planned to be integrated into Integrated Consumer

Datawarehouse.

. Evaluated multiple BI Tools & conducted Proof of Concepts

. Responsible for Logical, Physical Data Models and overall solution

architecture for Chase Auto Finance Project

. Established Reference Architecture for DI and provided governing

principles of overall Integrated Consumer Data warehouse.

. Oversaw design & development of Reusable components

. Scoped Disaster Recovery Planning for DW

. Capacity Planning for Informatica and Teradata ETL Staging

Environment

. Provide Data Integration Architecture Direction to all JPMC Lines of

Business

. Led 20+ offshore and onsite DW Resources

Software/Tools : Teradata V2R13.1, Oracle 11g, ETL-Informatica 9.01, SAS

9.2, Erwin, MS Office Tools, IBM Information Discovery, Cognos 10

Limited Brands March 1999 thru October 2011

(Victoria Secret Stores, Victoria Secret Direct/Online, Bath & Body Works,

Express, Limited Stores, Lane Bryant)

BI Architecture and Development Manager

Project: EDW Enhancements April'11 thru October 2011

. Managed the delivery of BI Project Portfolio for all EDW Enhancements

. Key participant in the rollout of multiyear BI Roadmap for Retail &

Direct Businesses

. Draft Options for ODS, EDW, Customer Data Mart Platform Architecture

. Oversaw ETL Development of 1000+ Datastage Objects for Unicode

Compliance Project

. Provided Resource Planning & Estimates for Projects in 2011 & 2012

. Provided Estimates for Internal Staff and External Consulting

Resources

. Oversaw Data Model and Physical Model Changes

. Oversee design and development for BI Releases

. Oversee scoping effort for EDW Unicode Compliant Project

. Scope enhancements for customer loyalty project with marketing team

. Key Liaison between BI Technology and Retail, Marketing Business

Community

. Oversee Data Quality Reporting working with the Data Governance and

Business Community

. Oversee enhancement work for customer loyalty project

. Oversee Cutover Planning and Prod Support Transition of new

Enhancements

Software/Tools : Teradata V2R12.0.2, SAP BW 7.0, ETL-Data Stage 8.1,

Informatica, Microstrategy V9.0.1

Hardware : 12 Teradata Nodes of 5550H - Tperf 431

Project : Customer Loyalty & EDW Enhancements Oct'10-

Mar'11

. Provided High Level Estimations for Data Design and ETL Design and

Delivery along with Staffing Resource Proposal.

. Identification of Data Feeds to the External Vendor hosting the

Loyalty Points Processing

. Oversaw ETL Design, Development and Data Architecture for both Inbound

and Outbound Feeds to/from External Loyalty Engine Hosting Vendor

. Defined Data Quality Metrics working with Customer Marketing Business

. Gather Requirements for the Outbound and Inbound Data Feeds from EDW,

Customer Marketing and External Vendor

. Coordinate Build and Testing Timeline with Customer Marketing Team

. Prepared Statement of Work, Scope and Oversaw the Build of the

Interfaces with Onsite and Offshore Teams

. Determine SLA's with stakeholders and formulated Workload Strategy

. Oversaw optimization of end to end loyalty processing

. Oversaw Data Design and ETL Design, Development of EDW Enhancements

for Monthly EDW Releases

Software/Tools : Teradata V2R12.0.2, ETL-Data Stage 8.1, Informatica,

Microstrategy V9.0.1

Hardware : 12 Teradata Nodes of 5550H - Tperf 431

Project : EDW 2010 Blue Chip Initiatives March'10 -

September'10

. Oversaw Requirements Gathering, design and development of Data

Integration, ETL, MSI Metrics, Logical and Physical Data Model for

below Enhancements

o VSS & VSD Common View of Article - Enable consolidated view of

item inventory over store and retail channels

o International Store Reporting for Goals, Sales and other

Performance Management Metrics thru EDW

. Batch Performance Enhancements - Improved Sales Processing and reduced

other critical Processes timing by 25%

Software/Tools : Teradata V2R12.0.2, SAP BW 7.0, ETL-Data Stage 8.1, SAP

ABAP Pack, Unix,Windows 2000, Teradata SQL Assistant, ERWIN 4.1.4,

Microstrategy V9.01

Hardware : 12 Teradata Nodes of 5550H - Tperf 431

Project : International Currency Conversion in EDW Sept' 09 -

Feb' 10

. Managed requirements, technical design and development phases for ETL,

Data Model and MSI Metric Design

. Led overall currency conversion data architecture and ETL design

strategy for EDW

. Provided High Level Estimations for Data Design and ETL Design and

Delivery along with Staffing Resource Proposal.

. Managed Source to Target Mappings and upload into Enterprise Metadata

Repository Tool

. Oversaw Microstrategy International Metrics Development

. Implemented Data Quality Standards in the Currency Conversion Process.

. Implemented Scrum Methodology in Design and Development Phases

. Prepared estimates for Design, Development and Testing Phases.

. Managed team of Data Modelers, Teradata Developers and MSI Reporting

resources (Onsite and Offshore)

. Tracked overall Project Progress for status reporting to PMO

. Tracked Development Status of over 200 Data and ETL Objects by

Functional Spec

Software/Tools : Teradata V2R12.0.2, SAP BW 7.0, ETL-Data Stage 8.1, SAP

ABAP Pack, Unix,Windows 2000, Teradata SQL Assistant, ERWIN 4.1.4,

Microstrategy V8.0

Hardware : 12 Teradata Nodes of 5550H - Tperf 431

Project : Enterprise Datawarehouse Implementation (Multiple Phases)

August' 05 - August'09

. Provided High Level Estimations for Multiple Phases of the EDW

Implementation which included Estimates for Data Design and ETL Design

and Delivery along with Staffing Resource Proposal.

. Managed development team of 20+ people (Onsite & Offshore) consisting

of ETL and Data Modelers

. Led and managed overall Data Architecture for EDW, Interface Standards

Strategy and Metadata Strategy

. Oversaw FSPEC Creation for over 300 interfaces (sales, payroll, master

data) between EDW and source systems

. Participated in meetings with Functional Teams for understanding

requirements and setup Presentations to Key Stakeholders and Business

Users to get Technical Design Signoff.

. Oversaw the Teradata Platform Architecture, formulated the strategy of

Batch, Mixed Loads and CRM Processing

. Oversaw design and development of Logical and Physical Data Model

. Implemented Data Quality Standards as part of Data Integration

. Deployed Agile Development Techniques, divided development into

multiple sprints and implemented iterative integration.

Environment :

Software/Tools : Teradata V2R12.0.2, SAP BW 6.0, V2R6.1, SQL Server 2005,

ETL-Data Stage 8.1, SAP ABAP Pack, Profile Stage, Unix,Windows 2000,

Teradata SQL Assistant, ERWIN 4.1.4, Microstrategy V8.0

Hardware : 12 Teradata Nodes of 5550H - Tperf 431

Project : Customer Data Mart Oct '04 - July '05

Role in the Project : Principal BI Architect/ Technical Delivery Manager

at Limited Brands

. ETL, Data Architecture, Design, Development, Implementation and

Deployment of over 100 interfaces containing customer data

. Met with Functional Teams to understand functional requirements and

create Functional Specs.

. Oversaw design and development of Logical and Physical Data Model for

Customer Data Mart

. Daily Interaction with offshore development team on standards, design,

day to day issue resolution

. Responsible for researching all Source Systems and other External

Sources to identify CDI and CDM data sources for customer.

Other Projects:

Project : BBW & Express Data warehouse Build October'01-

September'04

Role in the Project : ETL Architect & Technical Lead at Limited Brands

Project : Lerner New York & Lane Bryant Data warehouse Build

March'99 -Sept'01

Role in the Project : ETL Architect & Technical Lead at Limited Brands

Project : Credit Risk Management Warehouse January' 98 -

Feb' 99

Role in the Project : ETL Tech Lead at AT&T

Jan'95 thru December'97: Worked as a full time employee in ETL Lead &

Senior Developer roles with Satyam Computer Services, Hyderabad, India.

Worked on teradata system software enhancement to incorporate Stored

Procedure functionality and also developed interfaces for Glaxo Warehouse

Decision DW.

Contact this candidate