obiee resumes 2011dec

Bhaskar K Date of Birth: Not SpecifiedGender: MaleNationality: India

Phone: Not specifiedMobile: +91-8886018005

Email: [email protected]

Current Location: Bangalore

OBIEE

Work Experience : 4 years 5 months

Skills : OBIEE

Domain Knowledge : Not specified

Industry : IT/ Computers - Software

Category : IT

Roles : Datawarehousing Consultants

Current Employer : HCL

Current Annual Salary : Not Specified

Previous Employer : YashTechnologies

Highest Degree Held : MCA, Computers, Bangalore University

Preferred Job Location : Anywhere

BHASKAR Mail: [email protected]:-+918886018005summary: 4+ years of experience in all aspects of Business Analytics Applications including analysis, design, development, configuration, Customization, validation and deployment. 4 years of exp in SiebelAnalytics and OBIEE Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, chart;and tables Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer. Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, OBIEE Security Setup (groups, access privileges), Metadata objects and Web Catalog objects (Dashboard, Pages, Folders, Reports) Developed many Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters) using OBIEE Web

Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users Implemented Security by creating roles & web groups, checks with External tables & LDAP Having Exp in BIPublisher Good knowledge in ETL process using Informatica PowerCenter for various transactions and loading data from various legacy data sources Good knowledge in Datawarehousing Administration Console (DAC) Having good knowledge in oracle9i/10g/11g Expertise in debugging and optimizing OBIEE Reports/ Dashboards Good understanding of Software Development Life Cycle (SDLC). Ability and aptitude in scheduling, tracking and prioritizing activities Excellent analytical, interpersonal, problem-solving, trouble-shooting skillsAbility to set and achieve goals, work well independently or in team, skills in identifying Problems and meeting goalsEDUCATION: MCA from Bangalore University, Aug 2006. TECHNICAL SKILLS:BusinessIntelligent Tool

OBIEE 10.1.3.x, Siebel Analytics 7.8.4/7.8.2/7.7/7.5

Data Warehouse Tools

Informatica Power Center 8.1.1/7.1/6.2/5.2

Operating Systems Windows XP/2000, UNIX

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

Databases ORACLE 8i/9i/10g/11g

ERP Oracle Applications Release 11i

Tools SQL* Loader, Toad, Ms-Visio, XML Publisher

GUI Developer 2000/6iPROFESSIONAL EXPERIENCE:

Working as Senior Software Engineer in HCL, Bangalore from Oct 2009 to till date. Worked as Software Engineer YashTechnologies, Hyderabad from Jan 2007 to Sep 2009PROJECT #1

Franklin Templeton, New York Oct 2009 to till date

Franklin Templeton offers clients and policy owners an array of financial services, such as investment products and advisory services, with 145 billion in total assets and 19.7 billion in revenues3.2 million life insurance policy owners with more than 4.9 million policies. As a OBIEE Consultant developed and implemented the Policies, Premiums, Claims and Expenses (PPCE) Reports for decision making purpose.

Roles and Responsibilities: Used the OBIEE 10.1.3.3.x Administration tool to develop and enhance meta-data. Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository Configured and Created repository using OBIEE 10.1.3/ Siebel Analytic Admin tool. Worked extensively with Physical Layer,

Business Layer and Presentation Layer Created numerous executive level reports. ��Dashboards� were generated to provide insight into the sales/marketing/financial data. Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables Created business reports using Siebel Answers as per requirements Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters Involved in modifications of physical, business and presentation layers of metadata repository using OBIEE Administration Tool Identified the aggregate levels for each source and created dimension sources for each level of aggregates Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards. Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters. Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes Managed day-to-day rpd, Scheduler & iBots Managed security privileges for each subject area and dashboards according to user requirements Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance Develope the BIPublisher ReportsEnvironment: OBIEE 10.1.3.4.1, Informatica 8.1.1, Dac, TOAD, Win 2003/UNIX and Oracle 10g.PROJECT #2Procter & Gamble, Toronto Aug2008 to Sep2009

Procter & Gamble Co. (P&G, NYSE:�PG) is a Fortune 500 American multinational corporation headquartered in Downtown Cincinnati, Ohio [2] that manufactures a wide range of consumer goods. P&G is credited with many business innovations including brand management and the soap opera, The company began to build factories in other locations in the United States because the demand for products had outgrown the capacity of the Cincinnati facilities.Procter & Gamble acquired a number of other companies that diversified its product line and significantly increased,The main Objective was to perform Sales Analytics on the company's sales data to further improve the growth of the company's Sales

Roles and Responsibilities: Used the Siebel Analytics Administration tool to develop and enhance meta-data. Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository. Worked extensively with Physical Layer,

Business Layer and Presentation Layer Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables Enhanced existing Business Models & created customized Dashboards for revenue ratio reports for North America and Asia Pacific regions. Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables Developed custom reports using Seibel Answers and assigned them to application specific dashboards. Developed different kinds of Reports (pivots, charts, tables/compound layout) using global and local Filters. Implemented both Object and Data level security as part of the projectEnvironment: OBIEE 10.1.3.4.1, Informatica 8.1.1, Dac, TOAD, Win 2003 and Sqlserver.PROJECT #3AXA Equitable Life Insurance Company, New York, USA Jan 2007 to July 2008

AXA Equitable Life Insurance Company is a leading financial protection company and a premier provider of life insurance, annuity, and investment products and services. The project involved creating business intelligence solutions for the various work streams (compensation, compliance, finance) by comparing and contrasting data from various sources and then consolidating them at the report/dashboard level.Roles and Responsibilities: Used the Siebel Analytics Administration tool to develop and enhance meta-data. Created connection pools, physical tables, defined joins and Implemented authorizations in the physical layer of the repository Worked extensively with Physical Layer, Business Layer and Presentation Layer Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables Created Users and Groups and managing the object level and data level security. Managing the intelligent dashboards by using dashboard, page and report level security. Enhanced existing Business Models & created customized Dashboards for revenue ratio reports for North America and Asia Pacific regions. Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables Developed custom reports using Seibel Answers and assigned them to application specific dashboards. Developed different kinds of Reports (pivots, charts, tables/compound layout) using global and local Filters. Designed/Developed reports in Siebel Answers/Dashboards and trained the Business/ Power Users to create reports in AnalyticsEnvironment: SiebelAnalytics, Informatica 8.1.1, TOAD, Win 2003 and Oracle 10g.

BiswaraPhone: Not specified

njan Mohanty Date of

Mobile: 8553347545

Email: [email protected] email: [email protected]


OBIEE devloper

Work Experience : 3 years 1 month

Skills : Obiee

Domain Knowledge : IT/ Computers - Software


Category : IT

Roles : Software Engineer/ Programmer

Current Employer : NCS Global Services Pvt. ltd

Current Annual Salary : 3.00 lacs per annum

Highest Degree Held : B.Sc, Mathematics, Utkal University

2nd Highest Degree Held : PGDCA, Computers, Computer Point


Skill Name Last Used Skill Level Experience

C++ Not specified Not specified Not specified

C Not specified Not specified Not specified

OBIEE Jul 2011 Expert 36 months

oracle Not specified Not specified Not specified

Java Not specified Not specified Not specified

Biswaranjan MohantyMobile:+91-8977558183

OBIEE DeveloperEmail:[email protected]

Career Objective:

I am seeking a challenging position where I can utilize my strong programming skill sets and domain

knowledge towards continuous growth and advancement of the company.

Professional Summary:

3.1 years’ of comprehensive working experience as OBIEE consultant inOBIEE.

• Extensive experience in OBIEE Administration Tool, Answers, Dashboards, Delivers/iBotsand Publishers.

• Hands on experience on Reports and Repository creation.

• Expertise in building reports using drill up-drill downs, pivot, chartviews and embedded them into dashboardpages.

• Creating dashboard prompts and configuring them onto dashboards.

• Implementing the business logic by customizing dimensional hierarchies, aggregate navigation, and level based measures, Security management (Data level/Object levelsecurity).

• Working with Presentation, Repository and Session variables.

• Extensive experience in performance tuning with Aggregate Navigation.

• Designing Business layer with multiple sources.

• Good understanding on Datalevelsecurity

• Creating and scheduling iBots

• Working knowledge on catalog manager

• Excellent communications, interpersonal leadership skills

• Good understanding of business processes and Technical Architecture.

Professional Experience:

Currently working as OBIEE Developer inNCS Global Services Pvt. Ltd.,Hyderabad march 2008 to Till date.

Academic Qualifications:

• Bachelor of Science(math),UtkalUniversity, Bhubaneswar with 65% aggregate.

Technical Profile:

Business Intelligence: OBIEE (Admin, Presentation services, publisher)

Data Base Applications: SQL, PL/SQL

Relational Databases: Oracle 9i, 10g

ProgrammingLanguages:Core Java, J2EE

Operating Systems: Windows 2000, Windows NT, Linux (RedHat9)

Project #1

Project Name : Customer Order Analysis

Client : Target.com

Role : OBIEE Developer

Environment : Oracle 10g, OBIEE 10.1.3.3.2 and windows.

Project Description:

Customer Order Analysis is of prime importance to the business. The scope of this project to build a customer order dataset on oracle to enable the business to analyze and understand the data in all possible ways. To enable the customer and to help business understand our customer’s behavior and pattern detail table at customer grain will be built on Oracle.

Responsibilities:

• Developed many Reports using OBIEE analytic views.

• Implementing Pivot table view, Chart view, Narrative View, View Selector, Title View and Table View.

• Developed Level Based Measures, Time series measures.

• Developed the various Reports like ORDER DETAILS, ORDER CANCELLATION and AMENDMENTS.

• Using administrator tool to develop and enhance metadata to build business model and establish relationships.

• Organize presentation layer in a format that is easy for user to use as basis for reporting.

Project #2

Project Name : Capacity Management

Client : British Telecom(BT).




Capacity Management is a process used to manage capacity across BT network. Its primary goal is to ensure that capacity meets current and future business requirements in a cost-effective manner.

Capacity Management activities are intended to optimize performance and efficiency, and to plan for and justify financial investments.

Responsibilities:

• Understanding the Business requirements ,Involved in Designing and OBIEE Repository as per Business Needs.

• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.

• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.

• Customized the dashboard objects like folder, section and guided navigation.

• Creating the requests in answers and see the results in various views like title, table, compound layout, chart and pivot table.

• Worked extensively on OBIEE Answers to create the reports as per the client requirements.

• Developed different kinds of reports (pivots, charts, tabular)

• Created Dashboard prompts and Page prompts for better understanding of the trends.

Project #3

Project Name : SalesAnalysis system

Client : Renovo cosmetics Ltd




This project is developed for a Multinational cosmetics and accessories company, which sells their products in various countries and maintains all the information. The company does a high volume of business, so it runs business statistics reports to aid in decision support. Many of these reports are time-based and nonvolatile. That is, they analyze past data trends. The company loads data into its database and then into its data warehouse regularly to gather statistics for these reports. Some examples of these reports include annual, quarterly, monthly, and weekly sales figures by product.

Responsibilities:

• Understanding requirements and customizing the Repository to meet the requirements

• Developing Dimensions (Drill-Down Hierarchies) & Measure objects in Business Model Layer.

• Customized the dashboard objects like folder, section and guided navigation.

• Created time series measures, Level based measures.

• Developed many reports with different analytics Views like Pivot tables, Charts, Narrative etc as per the requirements using OBIEE Answers.

• Developed different brand level Reports using Filters, and Prompts.

• Organize presentation layer in a format that is easy for user to use as basis for reporting. Implemented cache mechanism & Aggregate tables to improve performance of reports

Confidential

Date of Birth: 13 Jul 1986Gender: MaleNationality: India

Contact Details: Confidential

Current Location: Pune

obiee with 4 years exp


Skills : obiee,plsql/sql, informatica,dac

Domain Knowledge : IT/ Computers - Software,Telecom

Industry : Telecom

Category : IT

Roles : Software Test Engineer, ERP, CRM - Support Engineer

Current Employer : Confidential


Previous Employer : Kanbay Inc,accenturepvtltd

Work Authorization : Need H1 Visa - Authorized to work in Algeria

Highest Degree Held : B.Sc, Computers, OSMANIA UNIVERSITY

2nd Highest Degree Held

: Other, Other, board of intermediate

Preferred Job Location : Anywhere, Bangalore, Hyderabad

Skill Name

Last Used Skill Level Experience

obiee Sep 2011 Intermediate 48 months

RESUME

LAKSHMAN.CPhone: +91-9763358430E-mail: [email protected] Summary 4.5 Years of IT experience which includes 4 Years of experience in development of Data warehouse, Data Modeling, OBIEE (Oracle Business Intelligence Enterprise Edition). Well versed with the Data Warehouse concepts like OLTP, OLAP, Star and Snowflake Schemas. Have a thorough understanding of Oracle Business Intelligence Enterprise Edition (OBIEE) Architecture and the role played by different OBIEE components like analytic server, web server, rpd, security, Dashboards, Reports, iBots and scheduler. Well trained in designing OBIEE Analytics Repository with Aggregate Navigation, Dimension Hierarchies, and level based measures. Well trained in implementing Data security using GROUP and UI security using WEBGROUPS in OBIEE. Have knowledge in designing and development of Dashboards, reports, Prompts in OBIEE. Have knowledge in most of the Views available in OBIEE Answers for report development. Have knowledge in OBIEE Delivers to create iBots for scheduling reports. Have knowledge in BI publishers developing.Summary of Work Experience Currently working as a OBIEE developer in Datastraits,pune from Jun 2010 to Till Date. Worked as a OBIEE developer in Kanbay Inc pune. from may 2009 to june 2010. Worked as OBIEE software engineer in Accenture Pvt Ltd, Bangalore from march 2008 to ap 09. I have trained on OBIEE in Yeritas Technologies Bangalore from Sep 2007 to Feb-08.Academic Qualifications 2003-06: Bachelor of Computer Science from Osmania University, Hyderabad.Technical ExperienceBusiness Intelligence Tool

OBIEE 10.1.3.3.2

OS / Environment Windows NT, 98, 2000, XP,UNIX

Databases / RDBMS SQL Server 2000, Oracle 9i/10g

Etl Knowledge Informatica 8.6 ,DACProject Summary Project # 01: Project : Chemicals & BioassaysClient : Hindustan Organic Chemical Ltd.Duration : June'2010 to PresentEnvironment skills : Oracle BIEE 10.1.3.3.2, Informatica 7.1.4Role : OBIEE DeveloperDescription:Hindustan Organic Chemical ltd is a large migration project where we were helping them to migrating existing reports to OBI reports. Here in this reporting to developing instruments and drugs. Preferred for reporting needs. There supports global reporting to Hindustan Organic Chemical ltd.

Bio-assays is data warehousing project platform, current built at Hindustan Organic Chemical ltd. In this project will delivers a more complete set of daily and monthly wise drugs & instruments

proceeding and reporting.

Responsibilities:

Partnered with the OBIEE team in gathering and analyzing business requirements from various sources, ensuring the business needs and delivery feasibility. Worked with the ETL team to design the Star Schema and populate the Data warehouse. Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas. Involved in creating Dashboards for the reports also using Guided Navigation and Links. Configured Web Catalog Objects (Dashboards, Pages, Folders and Reports) and Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc. Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.Project # 02:Project : Amethyst Billing SolutionsClient : British TelecomDuration : May-2009 to June-2010Environment skills : OBIEE 10.1.3.3.1, Oracle 9iDescription:Amethyst Billing Solutions is a migration project where we were helping them to migrating the existing Crystal Report to OBI report. Business object reports will be using as various sources.Responsibilities: Enabled Aggregate navigation in the Business model layer. RPD as well as web catalog side which consists of Answers, Dashboards, and Report Formatting. Involved and developed various steps to improve the performance of the queries used in the reports by having the aggregate tables. Customized Dashboards. Implemented Initialization blocks to populate Session variables for creation of dynamic filters in the reports.Project # 03:Project : ADW Shipment Siebel Analytics ImplementationClient : Procter & Gamble, Ltd. USADuration : Feb-2008 to April-2009Environment skills : OBIEE, Oracle 9iDescription:Procter & Gamble has a large Siebel Shipments Reporting program spanning customers globally, The Siebel technology has been selected by P&G as the preferred platform for Reporting needs. There are currently approximately 500 Shipment related Siebel report that are run from the Symphony Data-mart to support the global reporting needs of various P&G users.The ADW (Atomic Data Warehouse) is a new data warehouse platform currently being built and deployed at P&G. ADW Shipments project will deliver a more complete set of Daily and Monthly Shipment processing and reporting, and will take the place of the current Shipments component once delivered into production.Responsibilities: Involved in Data Modeling of the Data warehouse using Star Schema based on the requirements. Developed Fact, Dimension tables. Also created

aggregate tables for want of better performance. Created Physical, Business Model and Presentation Layers of Repository with lot of custom logical calculated measures based on the requirement. Created Dimension Hierarchies in the BM layer for Time, product, Geography and Customer Dimension. Created Dashboards Revenue Lifecycle, Shipment Analysis etc with Prompts and Reports having multiple views like Table, Pivot Table, Chart and Narrative based on requirement.

Maqsood Hussain Date of Birth: 18 June 1982Gender: MaleNationality: India

Phone: Not specifiedMobile: 9581958989


Current Location: Hyderabad

OBIEE 4.5 years experience


Skills : OBIEE

Domain Knowledge : Telecom


Category : IT

Roles : Software Engineer/ Programmer

Current Employer : Deloitte


Previous Employer : IBM

Work Authorization : Need H1 Visa - Authorized to work in India

Highest Degree Held : B.E/B.Tech, Electronics/Telecommunications

Preferred Job Location : Hyderabad

Skill Name


Operating Systems

Not specified

Not specified Not specified

Maqsood HussainMobile: +919581958989 Email: maksood.hussain

@gmail.comSeeking a position as OBIEE professional in a

growth oriented organizationSynopsis

B. Tech. with 4 Year and 6 Months of experience in OBIEE 11, OBIEE 10. Currently associated with Deloitte Consulting India Private Limited as a Consultant. Have got recognition for my work through awards and promotion. Adept at taking the inputs from clients, understanding the user requirements, developing the user stories and delivering the best within the time frames. Worked on all phases of Data Warehouse development lifecycle, from gathering requirements to testing, implementation and support. Conversant with OBIEE 11, OBIEE 10

Excellent written & oral communication, inter-personal, liaison and problem solving skills.

Technical Skill SetDatabase : OracleDevelopment Tools : OBIEE 11, OBIEE 10

Languages : SQLCareer Highlights

Consultant Deloitte Consulting India Private LimitedApplication Developer IBM India pvt Ltd from Mar'07 - Feb'10Proficiency Forte Interacted and contributed with onsite team for requirement analysis. Learnt and Helped in Aspects of Data Modelling. Implemented the overall functional requirement in OBIEE and also did the Unit testing. Giving Project related Training to the new joiners in the team and Promoted knowledge sharing with colleagues. Review of Design and Code of other Team members. Excellent debugging skills and Exploring New ways of getting to a solution. Implemented Functionalities like Creating Reports, Dashboards,IBOTS, Usage Tracking, OBIEE Customizations as well as Installation.

Have also been trained on ETL Tool Informatica.Projects Worked On -1>Client : A mojor game publishing client Feb 11- currentLanguages : SQL

Database : Oracle 10g

Tools : OBIEE 11, Informatica

Project DescriptionClient is a publisher of video game software, peripherals, and online games. The company caters to a wide range of game genres and devices including consoles, handheld platforms, and PCs.

This program seeks to:

Establish a Data Warehouse to capture and organize key data from Client's data sources for a particlular game.

Define and provide metrics and reporting capability leveraging Oracle Busines Intelligence Enterprise Edition (OBIEE) and the Data Warehouse to enable marketing campaigns and measure their effectiveness.

Roles and Responsibilities Doing requirement analysis for the module Maintenance Analysis. Creating data models for the new requirements. Implemented the overall functional requirement in OBIEE. Involved in Reviewing of code of other team members. Exploring New ways of getting to a solution. Implemented Functionalities like Creating Reports, Dashboards, Implementing Write Back, IBOTS, Usage Tracking, OBIEE Customizations as well as Installation. Doing Changes in Informatica mapping as per the enhancements.

2>

Client : Global payments Technology Company 6 monthsLanguages : SQL

Database : MS SQL Server

Tools : OBIEE 10.1.3; Informatica PowerCenter 8.1.1

Client Description: Global payments Technology Company that enables consumers, businesses, financial institutions and governments to use digital currency instead of cash and checks.Project DescriptionProviding support to Clients OBIEE application. Clients Support Application (Siebel) keeps a track of Service Requests created by users of different regions all over the world. Analytics application (OBIEE) is used to provide metrics about Service Requests received by Client per region per product and also the time spent on satisfying the Service Requests.

Roles and Responsibilities

Worked as an OBIEE developer for enhance requests raised by the user. Involved in RPD design and development for the Enhancement Request. Creating physical layer objects (Tables and Joins). Designing the BMM model and creating dimensions to fit with the existing Core star schema. Debugging issues in Informatica mappings and providing solutions for the same. Providing solutions for the incidents raised by production users in a timely manner.3>Client : Regional Insurance Company 3 monthsLanguages : SQL, PL SQL


Tools : OBIEE 10

Client Description: Regional insurance company (A.M. Best top 100) that offers property and casualty coverage for both individuals and businesses.

Project Description

Development of policy scoring engine for our Insurance Clients. This scoring engine scores each policy from 1 to 100 based on factors like employment index, Agency age etc.The score then helps the client to take decisions about that policy.


Generating the physical database model using Erwin data modeler. Generating ddls using Erwin data model for tables, triggers, synonyms, sequences etc. Setting up the development environment by running the ddl scripts. Writing stored procedures to load the monthly snapshot of policies and also to calculate the values of the variables .These variables are used as input for the scoring engine. Implemented the overall functional requirement in OBIEE. Populating data in development environment for unit testing. Unit testing debugging and fixing the issues.

4>

Client : AT&T 32 monthsLanguages : SQL


Tools : OBIEE 10

Project Description

The company uses Siebel 7.7 as its front-end for its Sales CRM. They use Siebel Analytics 7.7 for their BI requirements. It was later upgraded to OBIEE.

There were enhancements in the Siebel CRM application in every release and as a result enhancements were made in existing subject areas or new subjects areas and reports were brought inOBIEE application to satisfy reporting needs.


Repository development for OBIEE and Siebel Analytics. System Requirement Review. Reviewing Technical design document and helping Designer with Design analysis. Unit test case preparation and execution. Coding & giving Code walk through to Onsite team. Creating physical, Complex joins, dimensional hierarchies, level based measures, Opaque views, Variables etc. Debugging and fixing Reports and Dashboard issues. Debugging and fixing performance issues. Implemented iBots and Delivers for Unit Testing. Entering the data in various interfacing applications and validation of the data in Oracle Answers. Fixing the issues raised during System Testing phase and User Acceptance testing phase with minimal turnaround time. Support Business team for Installation of the code in Business environment. Giving knowledge transfer to team members about functionality of the Subject Areas.

AcademicsB. Tech (Electronics) from MIET Gondia,

Affiliated to Nagpur University in 2005Date of Birth: 18th June, 1982

I hereby state that the information stated above is correct to the best of my knowledge and belief.

Date: 17th November 2011Place: Hyderabad (Maqsood Hussain)

Pratap Singh Date of Birth: 10 Feb 1985Gender: MaleNationality: India

A-505, Knightsbridge Appartment Kundalahalli Colony Banglore-560037 State KA

Phone: Not specifiedMobile: 91-9686293760



OBIEE


Skills : OBIEE

Domain Knowledge : Not specified

Industry : Other

Category : Others

Roles : Consultant

Current Employer : Accenture


Previous Employer : Amdocs

Highest Degree Held : MCA, Computers, Sikkim Manipal university


: MCA, Computers, Sikkim Manipal university

Preferred Job Location : Bangalore

Pratap Singh

Mobile: 9686293760Email: [email protected]: A-505, Knightsbridge Apartment,Kundalahalli Colony, Banglore-560037State KACareer Snap Shot:To work in a creative and challenging team environment and to achieve a responsible position in the company where my techno-proficient skills will always be well utilized.Experience Summary: Almost 3.6 years of experience in IT industry. Good Working Knowledge in OBIEE, Oracle and Teradata. Ability to translate Concepts/Ideas to working Products.Work Experience:Company Name

Designation Period

AccentureSenior Software Engineer

31st May2010 to till date

AMDOCS Software Engineer

November 2010 to 27th May 2011

Lakshika IT Solutions Pvt. Limited

Software Engineer

February 2008 to 4th Nov 2010

Education and Certifications Teradata 12 certified professional Pursuing MCA from SMU (6th Sem) B.Com from Rajasthan University Jaipur (2007) HSC from Rajasthan Board Ajmer (2004) SSC from Rajasthan Board Ajmer (2002)Software Skills: BI Tools : OBIEE Languages : C, SQL Operating Systems : Windows 2000, NT and XP, Linux Databases : Oracle 9i, 10g and MS-Access Others : MS-Word, Excel and Power PointMajor Assignments:(Reverse Chronological Order)

1. AT&T ABS ANALYTICS

Environment : Teradata SQL Assistant 12.0, OBIEE 10.1 .

Duration : November 2010 to 27th May 2011

Synopsis:

Project Details:Working for USA based telecommunication company. It provide services in the telecommunication field like Mobility and Wire line. Following are the objective of this project :

The sales team of the telecommunication company needs a single way to identify and view customer data, regardless of

product or segmentation / entity boundaries.

All the personnel working on a sales opportunity need access to the necessary data to do their job, regardless of product, Sales org structure, customer structure, etc.

Common product catalog allows both sales forces to sell the same set of products. Product catalog supports wireline / wireless bundles, funnel reporting, compensation, and product revenue aggregation.

Single Reporting platform facilitating Integrated Wireline and Mobility Reporting functionality.Roles and Responsibilities

Worked on documentation part, understand the business requirement through SRS document for creating the HLD and AD. Created Unit testing documents and Validation plan. Worked on development, in existing subject area (Repository). Worked for Various Facts & Dimension. Repository Configurations: Creating measures, Attributes mapping, Hierarchies in logical layer in Siebel Analytics repository etc. Applied various Aggregation & Calculation on Metrics in BMM Layer or at Report level. For front end visibility worked on presentation layer, rearrange the folder, subfolder or reporting columns in order. Set up the MOD on folders, subfolders or each reporting columns. (Unit Testing)Tested all the attributes, folder or sub-folders validation plan by following Test Cases. Worked on report analysis. Worked on performance tuning to find out root cause and accordingly suggest to backend team. Worked on ST and UAT defects.Major Assignments:(Reverse Chronological Order)

2. 20'th Century Fox, USA (Home Entertainment Division) BI Solution

Environment : Oracle 10g, OBIEE 10.1.3.4

Duration : February 2009 to November 2010

Synopsis

20'Th Century FOX Home Entertainment Division is a movie production house. It produces and distributes movies in most parts of the world. The process of planning and measuring sales at customer level allows Fox Home Entertainment to partner with the customer and establish mutual growth plans. This also allows them to gain customer buy-in on category growth and supports detailed promotion and program

pitches throughout the year.

This BI solution contains an Intelligent, Rich and User-friendly dashboard containing tons of reports around sales, promotion, finance and operations etc. I have worked on all aspects of this project including a detailed analysis of reporting requirements developing and testing the metadata and RPD (Repository), testing the mappings from physical layer to business layer to presentation layer.


Worked on OBIEE Administration Tool In Creating Repository. Applied various Aggregation & Calculation on Metrics in BMM Layer or at Report level. Handled Siebel Analytics Administrative tasks: Creating Users and assigning privileges to the repository& Web users etc. Repository Configurations: Creating measures, Hierarchies in logical layer in Siebel Analytics repository etc. Designing and configuring Dashboards: To prepare Siebel Analytics reports based on the requirements. Worked with the Security Requirements (Object level and Data level). Worked for Different Scenarios (Forecasted, Estimate, Agreed Estimate, Actual, Reforecast, Returns) etc. Worked for Various Facts & Dimension.3. Volkswagen, IndiaEnvironment : Oracle 9i, OBIEE 10.1

Duration : March 2008 to December 2008

Synopsis

Volkswagen is deploying BI solutions to measure `Dealer Performance' as well as to measure and monitor their internal operations (Sales, After Sales (Warranty claims, Invoices, Services Request and Parts Analysis).


Hands on Unit testing and System testing. Testing of Reports along with data. Applied various Aggregation & Calculation on Metrics in BMM Layer or at Report level. Handled OBIEE Analytics Administrative tasks: Creating Users and assigning privileges to the repository& Web users etc. Repository Configurations: Creating measures, Hierarchies in logical layer in Siebel Analytics repository etc. Designing and configuring Dashboards: To prepare Siebel Analytics reports based on the requirements. Worked with the Security Requirements (Object level and Data level). Worked for Different Scenarios (Forecasted, Estimate, Agreed Estimate, Actual, Reforecast, Returns) etc. Worked for Various Facts & Dimension.Personal Details:Date of Birth : 10-02-1985

Gender : Male

Languages known : English, Hindi

Nationality : Indian

Martial status : Single

Sambasiva rao Poluri Date of Birth: Not SpecifiedGender: MaleNationality: India

Marathalli,Banglore


Email: [email protected] email: [email protected]


OBIEE


Skills : OBIA,DAC,OBIEE

Domain Knowledge : IT/ Computers - Software


Category : IT

Roles : Datawarehousing Consultants

Current Employer : Maestros Mediline Systems Ltd


Highest Degree Held : B.Sc, Computers, Nagarjuna University

Preferred Job Location: Bangalore, Chennai, Hyderabad, Mumbai, Pune, Cochin / Kochi / Ernakulam

Skill Name


OBIEE Jun 2011 Intermediate 38 months

summary3+ years of experience in executing projects as team member in varied domains covering all stages of Software Development Life Cycle including analysis, design, development, testing, implementation,

maintenance of Software applications in end-to-end system integration projects including the understanding of the Business process.

Having over 3.2 years of experience as a OBIEE Developer In Modeling the Physical/Business/Presentation Model using Siebel Analytics Server Administration. Expert in creation of dimension and fact tables, logical columns, hierarchies, level based measures in Business model and catalog folders in Presentation layers. Experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports). Demonstrated competence with OBIEE Tools (Answers, Dashboards, Delivers and Admin tool). Installing and configure the OBIEE & OBIA Experience in installation and configuration of Oracle BIEE 10g in the windows environment Good Knowledge on Data Warehousing concepts like Star Schema, Dimensions and Fact tables. knowledge in Data Warehousing using ETL tools such as Informatica Power Center. Worked on MUDE(Multi User development Environment) Working on DAC (Data warehousing Application Console) Having Good knowledge on SQL. Determination to learn new technologies, take-up challenging tasks. Ability to work effectively while working as a Team and as well as individuallyEducational QualificationBachelor of Degree (BSC' Computers) from Nagajuna University. India .Professional Experience

Working as Software Engineer in Maestros Bangalore Since Jan'2010 till date. Worked as Software Engineer in MIND TREE Bangalore since April' 2008 to Dec' 2009skills:OS : Windows Family,UnixLanguages : C, SQLRDBMS : Oracle 10g.OLAP : Siebel Analytics 7X,Oracle BI 10.1.3.3ETL : Informatica 7.1, Informatica power center 8.6.0professional experience

Project Name : ICS (Operation integrated Control systems)Client : Credit Suisse, USAEnvironment : OBIEE 10.1.3.4 , InformaticaPeriod : Jan'2010 to Till DatePrimary Role : OBIEE developerProject description:

Credit Suisse is a world leading financial services company, it has many applications developed for internal use. The process of integrating the data stored in different systems to data warehouse for decision support and advising clients in all aspects of finance, around the world, around the clock. Credit issues group's ambition it provide loans credit cards ,payments, funds ,transactions, the media and other interested parties with relevant information that contributes to a correct valuation of the company. For this they use informatica to develop the data warehouse.Roles & Responsibilities: Get the database connectivity and design the physical layer the business modal and mapping layer(BMML) and the presentation layer in the repository(RPD). Enhancing the subject areas as end when suggested by the business analyst. Create the reports like table, Chart, and pivot and narrative views and publish them in dashboards using answers & dashboards . Created Dimensional Hierarchies in logical layer to achieve Drill down functionality. Configured repository variables to generate dynamic reports. Configured session (system & non system ) variables to implement data level security. Business requirements gathering data source analysis report dashboard analysis User subject area analysis all which involves detailed defining of fact and dimensions tables (Star schema dimensional modeling is used) defining hierarchies defining aggregate levels transforming the business requirements and defining the security model. Define ibots/delivers for various requests needed. Add users to the new group and apply the data level and object level security at RPD as well as WEBcat. Implemented prompts to provide dynamic filter condition to end users.Project Name : Industrial Warehouses, Distribution centresClient : Stock land, AustraliaEnvironment : Siebel Analytics Admin Tool 7.7(Siebel Analytics)Period :Feb' 2009 to Dec'2009Primary Role : OBIEE developer.Project description:Stock land is one of Australia's largest and most progressive property investment and development organizations , and is leading the way in the design, development management of large scale projects across Australia .Own and manages commercial office buildings ,provides high level integrated property services to tenants, industrial warehouses, distribution centres and develop sub region shopping centres .Stock land is involved in both property investment (via stock land trust) and property management and development (via Stock land corporation ).

Roles & Responsibilities: Generated reports based on the client requirements. Creating the reports using multiple views like pivot view, chart pivoted results, Filter view , charts , narrative view ,Ticker view ,static view ,no result view , compound layout view, column selector view ,view selector, legend view and title view. Applied dashboard and report level prompts. Provided drill down functionality at UI level in case of dimension hierarchy are not implemented at RPD level. Generated reports by applying filters and utilizing variables. Created reports by using filter based on result of another request.Clien : OmegaEnvironment : Siebel Analytics Informatica 7.1,OraclePrimary Role : Repository developer

Period : April' 2008 to Jan' 2009.

Project description:The objective of the project was to design and build a data warehouse for Sales of products for company omega. This Project gives an insight into the various business trends. And helps the decision makers to take better forecasting decisions as well as provide them with a good view of the business data. The various business patterns can be analyzed using the different business dimensions like Product Wise, Company Wise, Branch Wise, Counter Wise, Promotion Wise, Customer Wise, Supplier Wise, Area Wise, Time Wise, and Unit of Measurement wise.Roles & Responsibilities: Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions Worked with Admin tool for Physical layer, Business Model Mapping and Presentation Layers in designing RPD. Modified Dimensions and created Custom Dimensional Hierarchies Created different reports using Answers like pivot table, column selector, charts. Used formatting features of BI Answers for Attractive requests. Configured intelligent Dashboard which includes links, images and HTML content. Developed the Reports for various Areas of subject using BI Answers. Configured Intelligent Dashboards for different groups of users to view across regions, customer demography with the facility to drill downs and charts. Implementing dynamic repository variables based on requirement. Creating and managing Web Groups and Reports Security using BI Web Administration.(sambasiva Rao.P)

SambasivaMobile No:91-8884824065 Email:[email protected] No:91-8884824065 Email:[email protected]

Manoj V Date of Birth: 17 Aug 1986Gender: MaleNationality: India

Navi Mumbai



Current Location: Mumbai

Reporting Tool/OBIEE Developer


Skills : Datawarehousing,OBIEE

Domain Knowledge : IT/ Computers - Hardware,IT/ Computers - Software


Category : IT

Roles : Software Engineer/ Programmer, Datawarehousing Consultants

Current Employer : Tech Mahindra


Previous Employer : Sierra Atlantic

Highest Degree Held : B.Sc, Computers, kakatiya university


: Class 12, Any, Board of Intermediate,A.P


Skill Name


OBIEE Apr 2008 Expert 41 months

Email : ♫[email protected] Mobile : +91- 9029008228Professional Summary Having 3.5 years of experience in IT Industry providing Business Analytical Solutions/Reports using Oracle BI (OBIEE).

Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool. Involved in Creation of Dashboards, Pages, Folders, and Reports by using Web Catalog Objects. Experience on assigning security to the users using repository objects & external data base. Excellent Working Experience with Multi User Development Environment (MUDE). Good Knowledge on Data Warehousing concepts like Star Schema, Dimensions and Fact tables. Good team spirit, strong oral and written communications skills.Educational Qualification Bachelor of Computer Science from Kakatiya University, Andhra Pradesh.Technical SkillsBusiness Intelligence OBIEE 10.1.3.4.1.

Databases Oracle 10g/9i/8i, SQL Server 2000.

Languages SQL, PL/SQL, HTML, XML.

Operating systems Windows95/98/NT/2000/xp.Professional Experience Working as a Technical Grade in TechMahindra from Feb 2009 to till date. Worked as an Associate Software Engineer in Sierra Atlantic from April 2008 to Jan 2009.Project SummaryProject Title : Sales Analytics ReportClient : Maplins, UKDuration : Apr 2010 to till date.Role : OBIEE DeveloperEnvironment : OBIEE 10.1.3.4.1, Oracle 10g, Windows XP.Description:This is a data warehousing application made for the analysis and reporting purpose of the sales and marketing company. The main objective of the project is to help the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities. Using this project we can generate various types of reports like best Employee Report, Best Customer Report, Best Product sold report, Best Promotion report, etc.Responsibilities: Involved in designing and development of OBIEE Metadata Repository i.e. Physical, Business Model, and Presentation layer. Having Strong experience in developing Reports / Dashboards with different Analytics Views using OBIEE. Implementation of data level and Object level security Defining Multiple Dimension Hierarchies for the Dimension Logical Table and also Experience in creation of logical columns, hierarchies, level based measures in Business model. Implemented Measures & Dimensions and organized the information data into related subject areas. Implemented Oracle Recommendations / Best Practices to improve performance of reports. Enhanced performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views and managing Cache etc. Using OBIEE Administration tool to develop and enhance Meta data to build Business Model and established relationships.

Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reportingProject SummaryProject Title : Unilever Asia and Europe Promotion & OrderClient : UnileverDuration : Feb 2009 to March 2010Role : OBIEE DeveloperEnvironment : OBIEE 10.1.3.4, Oracle 10g, Windows XP.Description:To analyze the Gross Sales, Net Sales in terms of orders and promotions of Unilever Brands for Future estimations. Backlog in Orders, Orders Shipped, Orders Booked of Consumer Products Division and sales promotions. The Reports has the ability to determine the Sales against their forecast Budgets of different Brands Promotions and compare the current year Sales with Previous Year Sales of Unilever, the Report helps in identifying and relocating the Workforce on the manufacturing line to decrease and increase the working hours on a particular brand based on the trend analysis of the Sales of Products as well as establishing strategies for different types of sales promotions.Responsibilities: Understanding requirements and customizing the Repository to meet the requirements. Created Dimensions and Hierarchies and Measures Involved in creation of Reports using different Analytics Views (Pivot Table, Chart, and Column Selector). Implementation of data level and object level security. Enhancing the subject areas as and when suggested by the business analyst. Involved in Organizing Presentation layer in a format that is easy for end users to use as basis for reporting.Project SummaryProject Title : Dollar Thrifty Automotive GroupClient : DTAG Tulsa, USA.Duration : Apr 2008 to Jan 2009Role : Software DeveloperEnvironment : OBIEE 10.1.3.3.3, Oracle 9i, Windows XP.Description:Dollar and Thrifty are two business entities came together under one umbrella named as DTAG (Dollar Thrifty Automotive Group).Dollar Rent A Car offers a large selection of fine quality DaimlerChrysler rental vehicles in addition to other exceptional rental cars. Dollar and Thrifty combined together with different facilities and different data warehouses. Dollar.com and Thrifty.com are two different brands owned by the Dollar Thrifty Automation Group (DTAG). Client is one of the biggest car rental companies in the world operating in about 60 countries worldwide.Responsibilities: Daily Monitoring Process on servers. Monitoring Digital Workflow regarding tickets. Access given to the new users as per IMAC ticket details. Creating RFC as per the client requirement. Interacting with client/users on regular basis. Resolving Performance issues. Providing production Support. User acceptance test before implementation in production.

obiee resumes 2011dec

Documents