Suresh Mobile : +91-998*******

E-mail :

ace38k@r.postjobfree.com

Summary:

o Having 9 years of IT experience, In Which 6.2 Years of experience in

Analysis, Design, Development, Implementation and testing using

OBIEE10g/11g/Tableau Software 7.0,OBIA/Siebel Analytics.

o Skilled experience in RPD Building (Physical Layer, BMM Layer and

Presentation Layer in OBIEE).

o Experience in developing Dimensional Hierarchies/New logical

columns/Filters/Variables per business requirements.

o Have good customer facing skills.

o Experience configuring Interactive Dashboards with Drill-Down

capabilities.

o Experience in working on different aspects of OBIEE/Siebel Analytics

RPD.

o Expertise in designing and development of Dashboards, Reports in

OBIEE.

o Well versed with the Database and Data Warehouse concepts like OLTP,

OLAP, Star and Snowflake Schemas, RDBMS, Multidimensional Modeling and

ETL.

o Knowledge of ETL (Extraction, Transformation, Loading) tool using

Informatica.

o Knowledge on data warehousing concepts like star, snowflake schemas

and fact & dimensions.

o Strong knowledge of Software Development Life Cycle (SDLC),

Methodologies and Techniques.

o Expertise in Customizing and Implementation of various Oracle

Application Modules Like Account Payables (AP), Account Receivables

(AR), Purchasing (PO),General Ledger(GL) & Fixed Assets.

o Technical Expertise in working on Purchasing, Order Management,

General Ledger, Payables, Inventory, Fixed Assets, Cash Management

and Receivables.

o Good knowledge on BI applications(OBIA) and DAC

o Good working knowledge on OBIEE11g.

o Having good knowledge on BI Publisher.

o Strong Problem solving & Communication skills and ability to handle

multiple projects and able to work in teams or individually.

Academic profile:

o Master of Business Administration from Andhra University in the year

1999.

o Bachelor of Engineering from Bangalore University in the year 1996.

Experience:

o Working with VMWARE SOFTWARE INDIA Bangalore since March 2013.

o Worked with IBM, Pune from November 2007 to March 2013.

o Worked with SARGA SOLUTIONS, Hyderabad from December 2004 to September

2007.

Technical Proficiency:

Business OBIEE 10.1.3.3.x,OBIEEE11g, Siebel Analytics

Intelligent Tool 7.x,Tableau Software 7.0

ETL Informatica Power Center 8.x/7.x

Operating Systems Windows XP/2000, UNIX, Solaris

Languages SQL, PL/SQL, C, C++

Databases ORACLE 8i/9i/10g

Tools Toad, SQL Developer, Ms-Visio, Jdeveloper

Internet JSP, servlets JDBC, SWINGS, HTML, DHTML,

Technologies JavaScript,

Professional Experience:

Client : VMWARE

Duration : Since April 2014

Role : System Analyst

Environment : OBIEE, Informatica, TOAD, Win XP, Tableau

Software 7.0

Description:

VMware is a virtualization and cloud computing software provider for x86-

compatible computers. VMware Inc. is a subsidiary of EMC Corporation and

has its headquarters in Palo Alto, California.

VMware virtualization is based on the ESX/ESXi bare metal hypervisor,

supporting virtual machines. The term "VMware" is often used in reference

to specific VMware Inc. products such as VMware Workstation, VMware

View, VMware Horizon Application Manager and VMware vCloud Director.

VM, which stands for "Virtual Machine",is a widely-installed operating

system for IBM-compatible computers and servers that can host other

operating systems in such a way that each operating system behaves as if it

were installed on a self-contained computer with its own set of programs

and hardware resources.

Responsibilities:

o Worked closely with Business Analyst in understanding the analytics

requirements and creating the business models for generating reports

as per the requirements.

o Managing security and roles configuration.

o Preparing High level and Low level design.

o Developed Ad-hoc and standard Reports / Dashboards with different

Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column

Selector, Tabular with global and local Filters) using Siebel

Analytics Web.

o Created and administered the Physical Layer, Business Model and

Mapping Layer and Presentation Layer in Siebel Analytics Repository

using Siebel Analytics Administration Tool.

o Developed the Facts, Dimensions, necessary hierarchies and the joins

between the logical tables, adding aggregates in the BMM layer

o Documentation covering Deployment across environments, Administration,

Issues and their resolutions.

o Imported physical tables and creating the required aliases, views and

creating the joins in the physical layer.

o Analyzed and validated the business model in Administration Tool by

performing consistency check, validating logical source tables,

logical columns, and also validating repository level calculations

done in the business model layer.

o Worked closely with Users, Developers and Administrators to resolve

ongoing Production Problems by reviewing design changes to production

systems and made corresponding changes to Repository.

.

Client : SunGard, KOP, PA

Duration : April 2011 to November 2012

Role : Siebel Analytics/Sr.OBIEE Consultant

Environment : OBIEE 10.3.3.1, Informatica, TOAD, Win XP

Description:

SunGard is a global leader in software and processing solutions for

financial services, higher education and the public sector. SunGard also

helps information-dependent enterprises of all types to ensure the

continuity of their business. SunGard serves more than 25,000 customers in

more than 50 countries, including the world's 25 largest financial services

companies.SunGard is comprised of four businesses - Availability Services,

Financial Systems, Higher Education and Public Sector - that provide IT

services and infrastructure, and software and processing solutions

Responsibilities:

o Understanding the basic reporting needs of D.C logistics division of

Sports Authority.

o Worked closely with Business Analyst in understanding the analytics

requirements and creating the business models for generating reports

as per the requirements.

o Created and administered the Physical Layer, Business Model and

Mapping Layer and Presentation Layer in Siebel Analytics Repository

using Siebel Analytics Administration Tool.

o Developed the Facts, Dimensions, necessary hierarchies and the joins

between the logical tables, adding aggregates in the BMM layer

o Preparing High level and Low level design.

o Developed Ad-hoc and standard Reports / Dashboards with different

Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column

Selector, Tabular with global and local Filters) using Siebel

Analytics Web.

o Imported physical tables and creating the required aliases, views and

creating the joins in the physical layer.

o Analyzed and validated the business model in Administration Tool by

performing consistency check, validating logical source tables,

logical columns, and also validating repository level calculations

done in the business model layer.

o Worked closely with Users, Developers and Administrators to resolve

ongoing Production Problems by reviewing design changes to production

systems and made corresponding changes to Repository.

Client : Alticor, MI

Duration : February 2010 to August 2010

Role : Siebel Analytics/OBIEE Consultant

Environment : OBIEE 10.1.3.x, Informatica, SQL Developer, UNIX.

Description:

Alticor Inc. is a global corporation offering products, business

opportunities and manufacturing and logistics services in more than 80

countries and territories worldwide. Alticor is the parent company of Amway

Corp, Quixtar Inc and Access Business Group LLC. The ATLAS project is an

Alticor corporate initiative with an overarching goal of improving the

affiliates' operational processes while upgrading the technologies

currently used to support back office transactional systems. Alticor has

selected and purchased Oracle's E-Business Suite ERP software to replace

current affiliate core systems.

Responsibilities:

o Designed and developed the Siebel Analytics Metadata Repository (.rpd)

using Siebel Analytics Server Admin tool by importing the required

objects (Dimensions, Facts & Aggregates) with integrity constraints

into Physical Layer using connection pool, developing multiple

Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures

objects in Business Model Layer, and creating the Presentation

catalogs in Presentation Layer.

o Participated in requirements reviews, system specification.

o Created Dimensions and Hierarchies and Measures

o Created the Reports for Usage Tracking Subject Area

o Review of Metadata Configuration, Web Cat development and writing Test

Plans.

o Customization of Dashboard and dashboard management.

o Configuring iBots to deliver the reports using Siebel delivers.

o Implementing the object level security in the project.

o Enhancing the subject areas as and when suggested by the business

analyst.

Client : Pfizer, Lancaster, PA

Duration : April 2008 to June 2009

Role : OBIEE Developer

Environment : OBIEE 10.1.3.x, Informatica, TOAD, Win XP

Pfizer is the world's largest research-based biomedical and

pharmaceutical company with a leading portfolio of medicines that prevent,

treat and cure diseases across a broad range of therapeutic areas, and an

industry-leading pipeline of promising new products in areas such as

oncology, cardiovascular disease and diabetes. Pfizer investing huge amount

money into those departments and Pfizer wants to know the project status of

each product they are researching or researched time line frames &

financial status of them. Also they want to know the invoicing and purchase

order amounts. So far Pfizer using manual feeding sheets each of them in

the text format. After some time as per the company growth they found that

this is bit hectic to follow for the huge amount of data and had decided to

see the financial status and time lines and each of activities status while

researching the projects in the sophisticated way such a graphical view,

Pivot table views and so on. Siebel Analytics is BI tool to show the

reports as they want to see.

Responsibilities:

o Understanding the basic reporting needs of D.C logistics division of

Sports Authority.

o Worked closely with Business Analyst in understanding the analytics

requirements and creating the business models for generating reports

as per the requirements.

o Created and administered the Physical Layer, Business Model and

Mapping Layer and Presentation Layer in Siebel Analytics Repository

using Siebel Analytics Administration Tool.

o Developed the Facts, Dimensions, necessary hierarchies and the joins

between the logical tables, adding aggregates in the BMM layer

o Preparing High level and Low level design.

o Developed Ad-hoc and standard Reports / Dashboards with different

Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column

Selector, Tabular with global and local Filters) using Siebel

Analytics Web.

o Imported physical tables and creating the required aliases, views and

creating the joins in the physical layer.

o Analyzed and validated the business model in Administration Tool by

performing consistency check, validating logical source tables,

logical columns, and also validating repository level calculations

done in the business model layer.

o Implemented Security/Access privileges by creating roles & web groups,

checks with External tables.

Project: CIA eGateway (Product for Pearson Learning Technologies MESA USA)

Client: Pearson Learning Center

Description: The eGateway System is a message transfer service that

provides data exchange between diverse systems and their applications. An

Agent is a software component that each participating application system

uses to connect to the eGateway. Messages are sent between applications

using Extensible Markup Language (XML) encoding to provide a platform

neutral encoding scheme. Message streams are sent via TCP/IP network

connections using Secure Sockets Layer (SSL) encryption for data

security.An agent can send a message (Publish) to the eGateway that other

agents can be configured to receive (Subscribe). An agent can request

information (QueryRequest) from another agent that will return a set of

result messages (Query Response).

The DB Agent provides message connectivity between MYSQL database and

eGateway system. It supports a specific set of eGateway messages, a defined

subset of the eGateway message domain that defines the XML format and

message element content used by all eGateway Agents.

Responsibilities and Contribution:

Involved in Analysis, fixing the bugs, Code Enhancements and Testing

Software Platform; JAVA,

J2EE,, PL/SQL, TOAD.

Project : AptitudeX

Client Fountainhead Pvt Ltd Singapore

Description: AptitudeX ORM is developed as a One-stop repository. It makes

it easy for different users within a company to collaborate and share

resumes. ORM system is designed as a pro-active system intelligent enough

to recognize the needs of recruiters / hiring managers. Once a requirement

is posted, it enables searches, ranks resumes in order of suitability to

requirement and alerts the recruiters on the chosen number of top matching

resumes.ORM is a highly collaborative system shared through web access by

different hiring managers and recruiters in companies whilst ensuring

different levels of access and permissions to view information. The

comprehensive workflow of AptitudeX not only helps companies in managing

information, but maximizing it. ORM can be accessed from anywhere by

dialing into the AptitudeX secure server with login information. It is

aimed to resolve the biggest problem of technology companies - search for

talent! User authentication and security is taken care of by gateway

servlet. This application implements a three tier architecture comprising

of Java Server Pages as user interfaces, Java class objects as business

logic's the database.

Responsibilities and Contribution: As a Team member Involved in the

development of gateway server. Involved in the development of online resume

management. Validation on Client side HTML using JavaScript.

Project

Issue Log System

Client: Internal

Description: This application is useful to track the issue (clarification

points) between the onsite and offshore teams. Any team member concerned

can raise any issue that needs clarification and discussion will be

transcribed. The issue history gets recorded into a database. An issue can

have several parameters like user id, title, opened data, Raised by, Last

Modified date, Last Modified by, Assigned to, Close date, Closed by,

Sensitivity, Priority, Issue Status, Issue Source, Project Phase The issue

raised etc. Several views based on these parameters can be made for

tracking the issues. This system can be extended for anomaly, bugs, and

support cases.

Technology: Java, HTML, servlets, JDBC

Responsibilities and Contribution: System study and requirements analysis,

Preparation of the Functional Specification Document and Coding.

Project

Investor Service System.

Client: Internal

Description: This is a product, which is mainly for Mutual Fund Industries.

It covers the following modules like unit holder management, marketing and

MIS Management, sales, re-purchase, lateral shifts and switching plans

etc., It is a powerful product to maintain the entire information over the

mutual fund schemes and plans.

Technology: Oracle 7.1, Java, AWT, JDBC.

Responsibilities and Contribution : Involved in developing GUI screens for

user input, writing stored procedures to get data from database.

Contact this candidate