Data Management

Location:

Irvine, CA

Posted:

October 15, 2012

Contact this candidate

Resume:

Srini Centhala

BI DW Architect at DIRECTV

Location

Irvine, California (Orange County, California Area)

Industry

Information Technology and Services

Srini Centhala

Contact Srini Centhala directly

Srini Centhala's Overview

Current

BI DW Architect at DIRECTV

Sr. Architect at Absolut-e Data Com Inc

President & Founder at Absolut-e Data Com, Inc

Past

BI / ETL- Data Architect at Experian

Sr. Architect at IMSHealth

BI Architect at Lafarge

Architect at Lafarge Gypsum

Architect at ebay

Architect at Temple Inland

System Architect at HCL Technologies

Sr. Software Engg / System Architect at Revenue Technologies

Consultant / System Architect at UPS

Senior Software Engineer at Lovell Hubbard Associates

see less

see all

Education

Bangalore University

Ramakrishna Higher secondary School

Recommendations

14 people have recommended Srini

Connections

500+ connections

Websites

Company Website

eServicePlace.com

Follow in twitter

Srini Centhala's Summary

SUMMARY:

Over 19 years of Information Technology (IT) industry experience in the area of full

life cycle software development of commercial client-server and web applications as

Technical Architect / Data Architect / Data Modeler in business data management system.

Over 11 Years US On-site Client Experience.

Over 10 years of Experience in Decision Support System Using OLAP, ROLAP,MOLAP & HOLAP

as BI Architect / Data Architect / Data Modeler.

All the projects were completed and implemented successfully on time with in allocated

budget with High Quality standards.

Extensively used Rational Unified Process (RUP) Methodologies & Delivered Quality

Standards SEI CMM model Level 4 & 5.

Re-Engineered the Business Process of Revenue Management, Marketing Management,

Contract Management, and Pricing Engine for United Parcel Service (UPS).

Business process re-engineering to convert from HR People Soft to JD Edwards and

Designing data warehouse to enable decision support system (DSS) of Human Resources (HR),

Sales & Marketing, Manufacturing, Finance (GL) & Inventory management Applications.

Expert in Designing of Data warehouse, Business Intelligence tool, ETL Process, Data

Mining, Data Mapping, Data conversion, Data Migration using Data Stage, Informatica,

Microstrategy 8i, Cognos & Business Objects.

Extensive experience in Data Modeling, Database Design, System Architecture, System

Design, Database Administration, Relational to object mapping, Object Oriented Analysis

and Design.

Very good experience in Oracle DBA activities, SQL, PL/SQL, Pro*C, Oracle Stored

Procedures, Functions, Triggers, SQL / Loader,SQL / Plus,Back UP & Recovery and SQL

Tuning.

Good Experience in Java, J2EE & JMS using application server, e-commerce, B2B and B2C

portals and System Integration (B2Bi and EAI).

Specialties

Business process re-engineering, on-line business ideas & concepts, Business

Intelligence, Technical Architect / Data Architect / Data Modeler in business data

management system, Project Management, Under taking full Projects developments.Srini Centhala's Experience

BI DW Architect

DIRECTV

Public Company; 10,001+ employees; DTV; Broadcast Media industry

September 2012 Present (1 month) Greater Los Angeles Area

Analysis and design of Enterprise data warehouse (EDW) for Supply Chain Management

subject area.

Sr. ArchitectAbsolut-e Data Com IncJanuary 2009Present (3 years 9 months)

Working on creating an On-line BI system to be developed in SaaS model. Evaluating the

existing systems in the market such as OBIEE (Oracle Business Intelligence Enterprise

Edition), SAP BI / BO (Business Objects), IBM s Cognos. Collecting requirements &

defining efficient business Process model to easy implementations and design of adoptable

for different industries & clients.

Responsibilities: (

Sr. Architect)

Streamline the Development process & preparing Standards for SDLC of data warehouse

implementation.

Requirement analysis and prepared detailed functional specification.

Adoptable architecture for On-line BI by evaluating existing Infrastructure

Defining revenue models & common data warehouse models

President & FounderAbsolut-e Data Com, IncOctober 2007Present (5 years)

www.eServicePlace.com

Services market place that connects to the service requester and service providers all

over the world. In United States of America alone there are 33 Million service providers

and nearly a Billion requesters. Every day there are service requesters who need service

providers to enable the ease of their service. Absolut-e has realized this need and has

developed eServicePlace.com to maintain the service requesters and providers transactions

by enabling tools to efficiently manage the community.

The following are the key features of eServicePlace.com:

1. Finding the providers and requesters

2. Placing service request

3. Bidding on the service request

4. Scheduling appointment for on-site estimation

5. Scheduling appointment for performing the services

6. Provider selection

7. Contract management

8. Work order management

9. Managing the service status

10. Financial management

11. Payment management

12. Rating/Review of requesters and providers

BI / ETL- Data Architect

Experian

Public Company; 10,001+ employees; EXPN; Information Services industry

December 2009August 2012 (2 years 9 months) Irvine CA

Design and development of NextGen Credit bureau Product, developed to implement in

multiple countries based on CORE functionality and Customization for each country. The

Customization countries AU, NL - Design complete & Development in-progress & For India -

Technical proposal & Design.

Sr. Architect

IMSHealth

November 2007October 2008 (1 year)

Responsibilities: (Sr. Architect)

Streamline the Development process & finalized the Extraction Transformation loading

process to generic framework using Unix Shell script.

Requirement analysis and prepared detailed functional specification.

Source System analysis Analysis & design of ETL Mappings and ETL Specification.

Analysis and Design of Datawarehouse (Logical & physical Model using ERWin) from OLTP

System to Accommodate the DSS Business Requirement.

Performance tuning and efficient joins to adopt with the functional requirements and

required summarizations

Workflow of each Reference & transaction information.

Validation against Primary Factory with new build system.

Environment: Netezza, Oracle 9i, ER Win, SQL,UNIX Shell script

BI Architect

Lafarge

Privately Held; 10,001+ employees; LFRGY; Building Materials industry

March 2005October 2007 (2 years 8 months)

Largest ERP implementation of enterprise One (JD Edwards), responsible for designing

Datawarehouse of the Gypsum Division of Sales & Marketing, Manufacturing and Finance

Datamarts and manage the Business team, ETL Team & Reports team. The datawarehouse &

multiple datamarts are designed for getting decision support reports for VP, directors,

sales executives, managers, customer analysis and comparisons of targeted revenue, actual

revenue statistics, KPI s, dashboard HTML reports & Documents.

Architect

Lafarge Gypsum

Public Company; 10,001+ employees; Building Materials industry

20052007 (2 years)

Architect

ebay

Public Company; 10,001+ employees; eBay; Internet industry

August 2004February 2005 (7 months)

Largest e-commerce data warehouse eBay has with 15 Tb size. Ebay site has a advertisement

tracker by different vendors such as Mediaplex, Double Click, Site Email & Kanna

connect. These are all the advertisement used for marketing as well as promoting the ebay

products. The datamart is built to the higher level management to analyze and promote the

Marketing creatives. Developed a combined datawarehouse to analyze from all of the

datamarts with respect to User analyze, Sent email, bounced email by ISP, bounce reason,

User age group analyze, Ad impressions, Clicks, Click Thru Rates GMV & the revenue

generated by these creatives. Simplify Stores is another Subject area to integrate with

the datawarehouse to enable the High level business users to do the analysis on the Store

owners, subscription, listings, listings, Rev Rollup based on Country.

Architect

Temple Inland

Public Company; 10,001+ employees; TIN; Paper & Forest Products industry

August 2003 August 2004 (1 year 1 month)

JD Edwards-One World ERP package has all the built in Inventory control, Manufacturing,

Sales & Marketing, Order processing system & all the employee details are in people soft

(HR management). Combination of both OLTP systems needs to be designed to have data

warehouse (OLAP) & data marts.

Environment: Oracle 9i, Informatica ETL tool, MicroStrategy7i, Windows-2000, ER Win, SQL,

PL/SQL

System ArchitectHCL Technologies

Public Company; 10,001+ employees; 532281; Information Technology and Services industry

September 2001August 2003

(2 years)

Client:

State of Georgia DHR -USA (ISIS) Jun-2003 to Aug-2003

ISIS (Investigative Services Information System) is a system for the DHR- Commissioner,

Director, Chief of Investigator to track/analysis/Forecast/trend analysis on the existing

cases. Automate ETL process to generate Fraud Alert system from EBT-Citibank data mart

based on defined Trafficking patterns and rules and Customers eligibility, benefit &

Budget information from SUCCESS System.

Client:

State of Florida AWI -USA (Decision Support System) Oct-2002 to Jun-2003

OSMIS-Data warehouse is a system for the high level users to

track/analysis/Forecast/trend analysis. OSMIS Application consists of 6 modules, to

integrate all these modules consolidated through data warehouse to make decisions,

Forecasting, budgeting and reporting to Federal Government. The Financial module modified

and extended to meet additional reporting and data requirements of OSMIS-DSS.

Sr. Software Engg / System Architect

Revenue Technologies

Privately Held; 11-50 employees; Computer Software industry

February 1998 September 2001 (3 years 8 months)

MP Composer is Configuration management applications to configure the MP Pricer. It

Capabilities consist of Item Catalog, Pricing catalog, manageability, segmentation and

analysis. Trend analysis, Forecasting, drill down capability across hierarchies (Data

Mining) against OLAP.

Web based Intranet solution to do the internal file sharing, Menu level access, creating

new menu levels and Customer contact info database maintenance. Those are secured by

authentication based on user role and authorization. This project is basically to prove

that technology selection, frame work development for the future Product development.

Consultant / System Architect

UPS

Public Company; 10,001+ employees; UPS; Transportation/Trucking/Railroad industry

February 1998June 2001 (3 years 5 months)

We developed an automated process for the data interaction from mainframe old system to

new database system with minimal user interaction by using Unix shell script as core

component. It consists of cleaning process by C program, Old to new system mapping with

business rules, validations, business process configured through MQ Series Integrator and

oracle stored procedure to complete the total System integration. After Population of data

to OLTP System, designed ETL Process to load data to the newly created data marts, which

is part of Rate Setting 2 Datawarehouse.

Senior Software EngineerLovell Hubbard AssociatesSeptember 1997February 1998 (6 months)

Srini Centhala's Education

Bangalore University

19881994Ramakrishna Higher secondary School

HSC, Computer Science

1986 1988

Srini Centhala's Additional Information

Websites:

Company Website

eServicePlace.com

Follow in twitter

Interests:

On-line Marketing,successful Business, enterprising, Venturing new, Technology Help to

any one

Groups and Associations: