Data Project

Rama Chandra Reddy Obulam

**** ******** ****, *** ***, Troy, MI-48084

Tel# 313-***-****

Email: abmfyy@r.postjobfree.com

professional summary:

. HAVING 2+ YEARS OF IMPLEMENTATION AND UPGRADE EXPERIENCE IN SIEBEL

APPLICATIONS,

. Expertise in Data Warehousing, Data Analysis, Reporting, ETL, Data

Modeling, Development, Maintenance, Testing and Documentation.

. Clear understanding of the various Analytics CRM data models in Siebel

(Service Analytics, Call Center, ERMS, Survey etc)

. Working knowledge of Siebel eRoadmap Methodology in a CRM environment

. 2 years of experience on OBIEE/Siebel Analytics in designing Dashboards,

Answers, and Analytics/Oracle Administration Tool

. Knowledge of the Siebel Data Warehouse: Key generation, WIDS, Slowly

changing dimensions, basic table sources, etc

. Data modeling experience using Dimensional Data modeling, Star

Schema/Snow flake schema, Fact and Dimension tables, Physical and logical

data modeling.

. Expertise in ETL skills and development of transformation standards and

processes using Informatica Power Center 8.1.1/7.1.4/6.1

. Expertise in providing end-to-end business intelligence solution by

configuring metadata & building Analytics Repository, dimensional

modeling design, building business models, generating reports, and

creating Inter-active Business Intelligence Dashboards

. Self-motivated, team-oriented individual with strong ability to merge and

coordinate with other team members in the respective work environments

TECHNICAL SKILLS

APPLICATION SIEBEL (6.0, 7.7, 7.8), SIEBEL ANALYTICS (7.7, 7.8),

OBIEE (10.1.3.4, 10.1.3.3)

ETL TOAD, SQL Developer

Languages Siebel VB, Siebel eScript, VB, VBScript, SQL,

JavaScript, PL/SQL, ASP, JSP

OS Windows (98 & 2000), Windows NT, UNIX, Sun

Solaris 8, IBM AIX

Databases Oracle 7-8-9i/10g, DB2, SQL Server

Data Modeling MS Visio, Rational Rose Model

project experienceS:

DELPHI CORPORATION

TROY, MI

OBIEE Developer

Feb 2nd 2009 - Present

Delphi: Delphi is a leading global supplier of electronics and technologies

for automotive, commercial vehicle and other market segments. Operating

major technical centers, manufacturing sites and customer support

facilities in 30 countries, Delphi delivers real word innovations that make

products smarter and safer as well as more powerful and efficient.

Project Brief: The project was an enterprise wide initiative to create a

central Data Warehouse which could bring together legacy systems and

leverage the OBIEE 10.1.3.4. The main challenges of the project were to

bring together legacy data sources and create a custom warehouse with

custom mappings.

Environment: Disparate data sources loaded into Oracle 10g Database,

Informatica 8.1.1 (SP4) used for SDE & SIL, OBIEE 10.1.3.4, DAC 10.1.3.4,

Siebel Service Analytics 7.9.5, SQL Developer.

Responsibilities:

. Analyzed reporting requirements for data mart, dashboards and reports

. Captured and documented business requirements into low level design for

the data mart

. Responsible for Oracle Business Intelligence (OBIEE) following Siebel

eRoadmap methodology (Agile project management)

. Worked extensively to configure Physical, Logical and Presentation Layers

. Developed various output formats such as tables views, charts, pivot

tables

. Created Logical Joins/keys, Set levels to support Drill-down, Aggregation

etc

. Developed Initialization Blocks, Repository and Session Variables for

defining security

. Managed and fine tuned the Analytics Cache Environment

. Involved in Migration, UAT, Go-Live, and Production Support

. Created & Administered user training sessions and refresher courses

. Created a detailed plan for knowledge transfer to internal teams

Internship:

CHRYSLER LLC

AUBURN HILLS, MI

INTERNSHIP

MAY 2008-AUGUST 2008

Project Brief: The Payment Term Deviation (PTD) Workflow Application is a

Chrysler Global Supply Management (CGSM) tool used to initiate, track and

report on approval of non-standard terms. The current economic environment

requires that all PTD requests are approved by Treasury in addition to the

CGSM Executives. Consolidate the functionalities of the four data

structures (Price increase, TISS reporting/metrics, Deterioration Tracker

and Critical Issues). This functionality must be integrated with the

current PTD application in an effort to consolidate the storage and use of

common data elements. Provide a manual interface to load Chrysler Global

Sourcing System (CGSS) portfolio data. This data should be available for

various components of the PTD application, including reporting, workflow,

database, etc. Enhance the workflow approval functionality from 2-Levels to

4-Levels in PTD. Replicate this type of functionality in the Price

Increase module with different approvers. Modify the screen layout, data

elements, and fix data related issues as defined in the requirements for

the existing PTD application. This includes changing the data structure to

remove duplicate approvals in support of correct reporting.

Environment: Visual Studio 2003, K2.net 2003, Sql Server 2000, Visual

Source Safe, Visio.

Responsibilities:

. Created User Interfaces

. Designed and Implemented Base classes

. Normalized and created new databases

. Interacted with Subject Matter Experts to translate business requirements

to technical terms.

. Successfully Completed data Movements in every phase of development,

staging and production.

. Played a Major role in creating integration test plans, Use cases

analyses using UML 2.0

. Involved in data migration from Project inception to deployment phase.

Chrysler LLC

Auburn Hills, MI

Internship

May 2008-August 2008

. Played the active role in coordinating the Chrysler-TCS Engagement of the

Phase 2 Connectivity

. Was the key responsible person for getting the access to the 326

applications which were spread across 5 Functional Portfolios and 14 Sub

Functional Portfolios of Chrysler to 3 Offshore development centers of

TCS in India

. Created and maintained the complete issue log template of TCS Application

access issues and getting them resolved with the Chrysler ITI Team.

. Was recognized by Chrysler spotlight Recognition award for the successful

Phase 2 Connectivity

EDUCATION:

. MASTER OF SCIENCE (M.S.) IN COMPUTER SCIENCE FROM WAYNE STATE UNIVERSITY,

DETROIT, MI

. Bachelor of Technology (B.Tech.) in Computer Science Engineering from

Jawaharlal Nehru Technology University, Hyderabad, INDIA.

Contact this candidate