Data Project

Sundar Rama, ***** Stearns, Overland Park, KS ****2, Email:

*********@*********.***, Mobile: 913-***-****

Objective: Perform key role as Enterprise Solutions / MDM Architect or

data management project lead in an enterprise environment and mentoring the

team in these areas.

Synopsis

. Outstanding Master Data Management, Data Governance, Data quality

experience in Pharmaceutical Industry

. Extraordinary in Service Oriented Architecture (SOA), Business

Information Warehouse (SAP BW)

. experienced in building cost effective business intelligence systems

including Data Governance for greater ROI

. Specialized in MDM, SOA, Enterprise Information Management ( EIM ) and

data management projects

. Experienced in metadata design,,real time BI Architecture, and low

maintenance BI solution for large EDW

. Proven expertise in MDM, EDW/BI and CDI tool selection and vendor

recommendation

. Management experience in project planning, cost estimation, resource

management and project delivery practices

Experience and Skill summary

. 19 years of proven experience in Enterprise Systems Integration,

Enterprise Information Management (EIM) including, project management,

data warehousing, data migration & conversion, data strategy,

Architecture design & development, including but not limited to Telecom,

insurance, healthcare, financial, utility and e-business industry using

real time and various MDM/CDI/EDW/SOA tools and techniques.

. Successfully implemented MDM for 3 major clients and educated more than

45 client users and executives

. Successfully completed 8 major data warehousing (inc. Data Governance,

Metadata, and Data Quality) projects

. Successfully implemented 2 EIM using SOA /ESB / EAI technologies

. Architected 3 CDI, Customer data repository (CDR) to analyze 360 degree

view of customers as part of MDM

. Designed reusable services utilized by multiple departments in an

enterprise using SOA layer

. Designed EDW with loads approximately 300M records in a day

. Designed DW for 32TB of data and accessing 120 concurrent users.

. Proven experience managing team, presenting project status, plan,

solutions and deliver QUALITY solution under budget

. Project management experience including:

o Discovering the business problem and justifying business case

o Prioritizing the business issues and cost benefit justification

o Building ongoing communication plan between business and

Technology team

o Developing executable project plan for various phases of project

o Analyzing ROI for the recommended solution approach and vendor

negotiation for tailored solution

o Quantifying a significant return on investment (ROI) in a

prioritized order

o Delivering prioritized solution on time and within estimated

budget

o Managing client, internal and external resources to complete the

project on time

o Determining the total cost of ownership (TCO)

o Identifying an architecture that delivers on full ROI - in

measurable phases

Core strengths

BPM, SOA, SAP MDM, CDI, ESB, EAI

EDW, BI, Data Governance, Data Quality

Project management from planning to deployment

Solution Architecture from Plan to Deployment

Technical Expertise

Software

C/C++, TIBCO CIM

Siperian MDM Hub , BDD , SAP BW

Oracle, Teradata, SAP MDM

SQL Plus, PL/SQL, Pro*C

Java/J2EE, JavaScript

WebSphere MQ.

SQL Server, Oracle CDH, UCM, OBIEE

Transact-SQL (T-SQL), DataStage, InfoSphere WCC, Informatica

OS Environment

. UNIX , HP-UX, AIX, LINUX, Windows , Sun Solaris, MVS, and OS/390

Hardware Environment

. IBM RS/6000, HP 9000 series, IBM PSeries 690/575, IBM ES/9000, S390

main frames and EMC2 storage servers

Professional Experience

WIPRO Technologies. Oct

2009- Present Enterprise MDM Lead: Worked with business to identify major

business priorities for MDM subject areas. Translated business requirements

to technical implementation. Designed master data management solution for

six subject areas. MDM deployment plan and architecture for Customer,

Products, Supplier, Vendor, and Item Master are executed. Following Key

task performed (but not limited to these items):

. Value Proposition, ROI comparison finalized and socialized with

CIO and business team

. Data Governance & Quality strategy implemented for all major

subject areas (stewardship programs across the enterprise)

. FullView master data model developed for MDM hub (product, vendor,

supplier, customer)

. Various Architecture pros and cons workshops, business workshops

were conducted and results are implemented

. Phased approach developed PoC results are validated with 89%

accuracy (due to time line FULL DQ was not applied)

Accenture LLC. June 2006-

Sep 2009

MDM/EDW/BI Implementation : Feb 2009 -

Sep 2009

MDM Subject matter Expert: Client products division is fragmented across

the globe. Customer and vendor information are repeatedly stored in each

product divisions (e.g. Pharmaceutical, Animal Health, Nutritional).

Business was facing core problems to identify their client and suppliers to

maximize their interaction (selling). Every vendor creation takes time, and

approval processes (High cost). And pharmaceutical products application is

tightly coupled point-to-point integrations among the systems, along with

information consolidated in some data stores. To realize a business

capability, enhancements need to be made in application systems as well.

Client recognized to improve their business capabilities by provided

centralized data management systems. Accenture worked with client to

develop data management solution that includes master data management,

enterprise data warehouse, and business intelligence.

. Played as a SME to provide prioritized data solution on MDM, BI

and EDW

. Delivered Enterprise Data Governance, Data Quality, Metadata, and

ETL solution

. Interacted with client business executives and Accenture to

develop cost, resource, time estimation for entire project (3

years plan)

. Designed end to end data architecture, project plans, and resource

planning for the entire project

. Enforced data management processes across the enterprise (part of

People, Process, Technology pillars)

. Managed team of 7 consultants, 3 client and 2 offshore resources

. Quantified the Business Value for MDM and data strategy

initiatives

Enterprise Data Management

Nov 2007 - Jan 2009

MDM Program Consultant: Identify client business issues and provide

centralized solution for single view of the enterprise

Goal: Deliver a complete & accurate view of customers to an Agent & Client

Desktop. Manage an 'enterprise view' of parties (agents / customers /

service providers) and associated hierarchies for effective relationship

management.

Challenges: All data accessed by Agents and employees is policy-centric; a

customer centric view is currently unavailable. The lack of a customer-

centric view significantly increases CSR training times and decreases

efficiency at the customer touch point.

Solution: MDM solution provides the ability to look up the complete profile

of a customer (party id), including associated policy information with a

single query. The complete customer profile delivered to all systems that

issue a 'get party' business service (based on their entitlements).

Accomplishments:

. Developed project estimation from planning to deployment including

pilot and Proof of Concept (PoC)

. Identified data management gap, cost of data replications, and

solution benefits for short and longer terms

. Developed ROI, value proposition for the entire data management

project

. Identified duplicate/redundancy data systems and developed

application retirement plan along with application consolidation

. Designed data governance and data quality process for the subject

areas including periodic communication plan to the business team

. Developed evolutionary master data architecture including EDW and BI

data stores for party and products

. Developed data delivery architecture for subscribing applications and

trained business users and application owners

Business Benefits Achieved:

. Single view of party data across all lines of business and channels

leads to a consistent customer experience

. Business process efficiency through 'once and done' processing of

customer information

. By leveraging a BI and an Enterprise Data Warehouse with MDM solution,

customer information are further enriched

EIM / MDM Jul 2006 -

Oct 2007

MDM/Information Architect: Responsible for project management, delivering

MDM and data warehousing solution-using SOA. Developed system independent

MDM strategy and designed MDM at the enterprise level for Customer, Vendor,

Products, and Suppliers. Data transformed in near-real time to multilevel

application.

Business Issues: Client had many supplier and supplier owned systems. It

was time-consuming process to get a single version of supplier and product

information that fulfill client business requirement. Sales and marketing

department spent time to resolve issues instead of their core

functionalities. Many external vendors systems used various tools to

provide data which created issues in Client information systems. MDM

solution provided, quality data that the business can instantly access, and

integrated, accurate, current view of the products, supplier, and customer

information in a single location

. Developed MDM program road map including plan, analyze, design, Build,

test and deploy phases

. Identified and designed master entities, synchronization and

harmonization requirements

. Developed data quality, merge, match, and consolidated product,

customer, vendor information

. Integrated MDM hub with Clinical information systems and life science

data hub for reporting

. Implemented data stewardship pilot to govern external and internal data

standards, policies and processes

. Completed the current systems integration touch point for MDM integration

requirements for various vendor location

IBM Corporation Dec 2003 -

Jul 2006

Principal Consultant: On Demand Customer Interaction Center (ODCIC) project

is to provide the call center solution for Sprint Nextel Corporation. It is

the CDI integration for customer, product, and services integrated with

Enterprise Master Data domains (MDM) as part of the project there was a

need to architect, design and develop the Data warehouse for call center

performance analytics and customer service ranking.

. Defined Strategy for MDM domains and CDI for universal customer master

(UCM)

. Implemented fast data access (MQT, MDC, and SQL), Intelligent Optimizer,

Workload management (QP) and unlimited scalability

. Designed MDM, CDI, UCM and EDW to view the business activities in 360

degree view and made it available for 1000s for users

. Designed logical and physical model and implemented in DB2 / Oracle

environment.

. Developed customer contact metrics and validated them with business

users.

Sprint Corporation Dec

2000 - Nov 2003

Sr.Consultant: Actively participated in system analysis, system

architecture and development life cycle. Early stage on the project (2000)

successfully studied the business requirement of data warehousing

environments and designed the data models. Successfully extracted and

staged three Data warehousing systems and implemented in production. As a

part of the team, played key role to analyze and convert the customer base

data from the P2K billing system to the Renaissance billing system (Amdocs)

while minimizing system and customer outages.

o Involved on complete SDLC activities from early stage of the

project to the production implementation.

o Implemented the Data warehouse Architecture for 10 TB of

financial data

o Designed / developed real time data acquisition processes (ETL)

for data staging and data mart level.

o Designed multidimensional data model for Decision support stream

using Star, Snowflake design.

o Delivered data conversion product on time, which is key for

~$200M revenues for the client.

Covansys Inc., Farmington Hills, MI

Mar 1999 - Nov 2000

Medical Assurance Company, Birmingham, AL

Oct 1999 - Nov 2000

Technical Analyst: Successfully completed writing the policy rating

code on HP-9000. Analyzed database systems and optimized for

performance. Analyzed the complete policy rating system and designed

the data transformation. Designed and tuned the policy rating part of

the system.

Electronic Data Interchange, Farmington Hills, MI

Mar 1999 - Oct 1999

Technical team Lead: over a staff of 35 to deliver key functionality

in e-business application. Data model developed for a complex data

structure. Provided complete business supports to the development team

and solved time-to-time business issues. Gathered business requirement

from the client, implemented solution by utilizing available

resources, and delivered the result on time.

Barra Inc., Berkeley, CA Dec

1998 - Feb 1999

Technical Consultant: Analyzed Barra financial data including

financial risk management to migrate various financial data from

operational model to data warehousing model. Data analysis and

validation scripts were developed. Successfully implemented tools to

automate financial models and validate data quality. Designed and

coded ETL modules for various source data systems. Data integration

code developed between source systems. Designed the data refreshing

process and uniquely identify the historical financial data.

Lowe's Companies Inc., North Wilkesboro, NC

Sep 1998 - Dec 1998

Consultant: Developed data migration code to move retail store data

from various legacy OLTP systems to new unified & centralized system,

where all centralized data models available for business applications,

executives, and reporting process. Developed data validation and QA

processes for DataStage. Reporting packages developed against retail

data mart.

Beckman and Coulter Inc., Los Angeles, CA

Feb 1998 - Aug 1998

Consultant: Distributed data warehousing environment designed using

multidimensional models. Data integration code developed to stage data

from source applications. Data collection programs developed for

Global data warehouse using Oracle and DB2 packages.

Tata Consultancy Services

Jun 1997 - Jan 1998

Team Lead: Supported the team to develop data conversion modules to

accommodate insurance data. Involved on development and implemented

translation process. Developed data expansion and validation methods.

Codes developed for metadata information.

P&O Nedlloyd.

July 1996 - June 1997

Apple Computers. Sep

1995 - Jul 1996

Physical Research Laboratory Sep

1993 - Sep 1995

Intergraph Corporation Sep

1992 - Sep 1993

Education

Master of Science (M.S)

1990 - 1992

Bachelor of Science (B.S)

1986 - 1989

Post Graduate Diploma in Information Technology.

1992 - 1994

Microsoft Certified Systems Engineer (MCSE ).

2000 - 2000

Contact this candidate