Obiee Senior developer with 6+ years experience

SUMMARY

V Have overall *+ Years of experience in Information Technology with

experience in OBIEE, Siebel Analytics, Informatica, Siebel EIM, On Demand

Analytics, Siebel Marketing and domain expertise in the Telecom, Pharma

Domains.

V Experience in Data Warehouse and Business Intelligence tools like OBIEE,

Siebel Analytics, Informatica and Siebel Data Warehouse Application

Console (DAC).

V Experience in Data Migration projects to migrate data from external

sources to Siebel DB.

V Experience in creation and customization of ETL extracts and load process

(SDE/SIL) using Informatica.

V Functional experience includes supporting Siebel CRM Applications, CRM

Release deployments, analyzing and resolving defects etc.

V Installing and configuring various OBIEE, Siebel Analytics components,

Mapping the requirements and customizations to OBIEE and Siebel

Analytics.

V OBIEE RPD Modeling, building reports using Answers and publishing them on

Dashboards/Delivers to meet the business requirements.

V Possessing good knowledge in RDBMS Concepts (SQL Server).

V Task oriented and a good team player with excellent communication,

Interpersonal, Organizational Skills.

V Ability to adapt quickly to new environments.

PROFESSIONAL EXPERIENCE:

V From May 2013 to till date Working as a OBIEE Lead with Syntel

Limited.

V From Dec 2006 to May 2013 worked as a OBIEE developer with Cognizant

Technology Solutions.

CERTIFICATIONS & EDUCATION

V Cognizant Certified Siebel Analytics Application Developer

V Cognizant Certified Siebel Analytics Architect

V B.Tech from Rajiv Gandhi Memorial College of Engineering and

Technology (Nandyal), JNTU, Hyderabad.

SOFTWARE SKILLS:

Business Intelligence OBIEE 10.1.3.2, Siebel Analytics 7.8.4 /7.7

Tools

ETL Tools Informatica 8.1.1, 7.1.2, 6.1.2, 5.1

Databases Oracle 10g, 9i, SQL Server 2000, MS Access

Programming Languages PL/SQL, Shell Scripting.

Operating Systems UNIX, Windows 98/00/NT/XP

Others Siebel EIM, Toad, SQL and DAC.

PROJECT EXPERIENCE:

Projectprofile-1:

Client Humana EDW PSM

Duration May 2013 - till date

Tools OBIEE 10.1.3.4., DAC, SQL Developer, Oracle

Database 10g,.

Role OBIEE Lead

Organization Syntel Limited

Location Pune, India

Project The company is a largest healthcare payer in USA

Description that offers a wide range of insurance products

such as health and wellness services that

incorporate an integrated approach to lifelong

well-being. By leveraging the strengths of its

core businesses, the company believes it can

better explore opportunities for existing and

emerging adjacencies in healthcare that can

further enhance wellness opportunities for the

millions of people across the nation with whom

the company has relationships. As part of this

project, we hold the responsibility of OBIEE and

Community Manager Applications Production

support.

Responsibilities

Coordination with the onsite and client team in

gathering the requirements and guiding the

offshore team.

Preparing High Level and Technical design

documents based on the Business requirements.

Design and develop OBIEE Reports & Dashboards.

Provide technical guidance to the team .

Projectprofile-2:

Client McKesson Health Care (US Oncology Network)

Duration Aug 2012 - May 2013

Tools Informatica 8.6, OBIEE 10.1.3.4., DAC, SQL

Developer, Oracle Database 10g,.

Role OBIEE Lead

Organization Cognizant

Location Bangalore, India

Project The US Oncology Network is one of the nation's

Description largest networks of community-based oncology

physicians dedicated to advancing cancer care in

America. Siebel 7.8 Financial Services

Application is used for case management requests

for Patient Assistance programs and

Reimbursement services. Siebel entities used in

this application include Cases (Service

Requests), Facilities (Accounts), Patients

(Contacts), Doses, Drug, Policy, Activities,

Orders. The application also has an extended

portal interface for patients and providers to

submit and track cases.

The OBIEE reports caters to various

organizations (Programs) to get an insight into

their orders, performance metrics, ADHOC,

billing, operation metrics, program metrics,

daily metrics, ppa reports, region territory

reports. These are various dashboards used for

internal and external purposes inorder to

maintain various performance metrics, Adhoc

requests, Billing details, reimbursement,

Activity details, status based on the type of

the program, region, territory, date ranges,

status, date range, payer and cases.

Responsibilities

Requirements gathering by interacting with the

onsite and client team.

Preparing High Level and Technical design

documents based on the Business requirements.

Design and develop OBIEE Reports.

Creating new dimensional data model according to

OBIEE.

Design and Developed Informatica Mappings &

Workflows.

Provide technical guidance to the team when

complex issues arise.

Prepared test cases.

Projectprofile-3:

Client ngCRM CZ

Duration Mar 2012 - July 2012

Tools Siebel EIM, Informatica, PL SQL, Unix

Role EIM Developer

Location Mumbai, India

Organization Cognizant

Project NG CRM Program aims at designing and

Description implementing a Next Generation Customer

Relationship Management Solution that will be

deployed across the DTAG Group National

Companies to leverage on synergies from a

central and a local perspective

DTAG intends to have a single CRM implementation

in 4 countries viz. Czech Republic, Macedonia,

Hungary & Slovakia. There would be two parts to

it; Kernel & Local. The core part which remains

common for all countries will be around 70%.

Localization would cater to country specific

requirements (30%). The solution used is Siebel

8.1.1.3 eCommunications, Oracle AIA,

Avaya/Genesys CTI, TIBCO etc. In the NG CRM

project the Company's Account Management, Order

Management, Opportunity Management, Quote

Management, Contract Management, Service

Management, Loyalty Management, Campaign

Management, Sales Management, Partner

Management, CTI, Self Care Management, Partner

Portal are created and integrated.

Responsibilities

Analysis of functional specification and

designing technical speciation

Design, Development and Coding of the Tool.

Development of PL SQL code and IFBs.

Test planning, Deployment and Bug fixing

Projectprofile-4:

Client Merck

Duration April 2011 - Feb 2012

Tools On Demand Analytics, OBIEE

Role On Demand Analytics & OBIEE Developer

Organization Cognizant

Location Mumbai, India

Project The Client, Merck Sharp & Dohme Malaysia, is

Description embarking on a strategic initiative to

standardize its Sales Force activities by

building an Oracle on Demand and Oracle BI based

Sales Force Automation system solution across

Asia Pacific Countries (Including Malaysia,

Singapore, China, Hong Kong, Korea, Philippines,

Vietnam, India, Thailand and Indonesia). Merck

Sharp & Dohme has chosen Ygyan Consulting Sdn

Bhd, a subsidiary of Cognizant Technology

Solutions, as the strategic partner to implement

and Support Oracle on Demand Solution for the

MSD Connect program. As the strategic Oracle on

Demand partner, Ygyan is expected to perform

Design, Development and Coding, Test planning,

Deployment as well as Support of the rolled out

applications to the markets of Asia Pacific

Countries.

Responsibilities

Team supervision and system performance

analysis.

Analysis of functional specification and

designing technical speciation

Design, Development and Coding of the Reports

Test planning, Deployment as well as Support of

the rolled out applications

Projectprofile-5:

Client Verizon

Duration Jan 2009 - March 2011

Tools Siebel Analytics 7.8.4, Informatica 7.1.2 and MS

SQL Server

Role Siebel Analytics Developer

Organization Cognizant

Location Bangalore, India

Project Client is a provider of technology services to

Description telecommunication providers in North America and

Internet service providers around the world.

Client was looking for tool to analyze the data

created in Siebel Communication 7.8 application

(i.e. data related to Accounts, Contacts,

Quotes, Orders, Assets and Service request).

The Analytics system is based on Siebel

Analytics 7.8.4.The basic requirement for this

project is to display the data available in

Siebel OLTP and provide ad-hoc reporting

capability.

Responsibilities Configuring Siebel Analytics Server Metadata as

per business.

Configuring Siebel Analytics Reports as per

business requirements.

Developed dashboards and tested the same in

Siebel Analytics 7.8.5.

Scheduling iBots as per business needs.

Modifying Custom mappings using Informatica

7.1.4

Monitoring loads in DAC

Projectprofile-6:

Project Name New York Times

Duration Nov 2007 - Dec 2008

Tools Siebel Marketing 7.8 & Siebel Analytics 7.8

Role Team Member

Organization Cognizant

Location Bangalore, India

Project The client is a leading media firm with

Description newspaper publications.

The project delivers a single view of Order,

Subscriptions, Service Requests and Activities.

Also includes summary & detail level analysis of

Call Center Performance with an eye on SLA

compliance and Analysis of IVR response and

snapshot view of calls from Cradle to Grave.

Responsibilities Worked on Programs, Campaigns,

Worked on segments and segment trees.

Worked on Caching, Loading, Launching, QAing and

Notification Template of the Programs.

Assisted in configuring the marketing

repository.

Projectprofile-7:

Project Name Phones 4U

Duration March 2007 - October 2007

Tools Siebel Analytics 7.8.2, Toad

Role Team member

Organization Cognizant

Location Bangalore

Project Client is a dynamic and fast growing business

Description operating in a fluid and highly competitive

market. To support the growth plans of the

business, Phones 4u is undertaking a large IT

transformation programme underpinned by the

replacing of its existing legacy systems with

the latest Oracle and Siebel applications.

A key element of the transformation is the

programme of work necessary to build an

application platform to support the client's

direct business (The Programme). It will be a

new, agile channel for the client to connect

with customers in new ways, with rapidly

changing propositions, and will be a platform

for material incremental revenues. Crucially it

will help the client to maintain its RPU

leadership and subsequent leverage with

networks.

Technology Solutions US Corporation, Inc.

(Cognizant) has been engaged to undertake The

Programme and implement The Integrated Solution.

Responsibilities Created Reports and Dashboards and tested the

same.

Coordinating with team of 10 for functional and

UI testing.

Preparing, Reviewing and Executing the Test

cases as per the Test Plan for Oracle BI reports

Coordinating with the development team to help

in fixing the defects.

Contact this candidate