Data Developer

Swapna M

Staff Consultant Email:

**********.********@*****.***

Ph No: 512 815

3439

Substantial Knowledge with Business Intelligence suite of products OBIEE

10g, OBIEE 11g, BI Publisher, Informatica, DAC and ODI.

> Strong experience in Business Intelligence Products like OBIEE 10g,

OBIEE 11g, BI Publisher, Informatica and DAC as a BI Technical

Resource.

> Experience working with OBIEE 10.1.3.x/OBIEE 11.1.1.7.x/OBI

Applications 7.9.6.3 in development of metadata repository using OBIEE

Administration tool, Intelligent Dashboards, Answers, Delivers, iBots

and Oracle BI Publisher

> Experience configuring Interactive Dashboards with drill-down

capabilities using global and local Filters, OBI/Siebel Security Setup

(groups, access/query privileges), Metadata objects and Web Catalog

Objects (Dashboard, Pages, Folders, Reports)

> Experience in creating indexes, aggregations and cache management.

> Extensive experience in Security Setup at both Object and Data levels,

LDAP authentication setup and configuration of Multiuser Development

Environment (MUDE) Demonstrated knowledge of Shared Services security

> Expertise in design and development of Oracle BI Metadata Repository

(.rpd) using OBI/Siebel Analytics Server Admin Tool Repository at all

the three layers (Physical Layer, Business Model and Mapping Layer &

Presentation Layer).

> Configure the BI Publisher scheduler to schedule reports and view the

saved data

> Hands on experience in RDBMS concepts, SQL and PL/SQL.

> Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional

hierarchy, Aggregate navigation, Variables/Initialization Blocks

configuration etc.), converting Snow-Flake Schema to Star Schema, Dim

Hierarchies, Dim Extensions, Physical & Logical Data Modeling

1 Work Experience

> Worked as a Technical Consultant in Apps Associates, from August 2010 -

December 2013

2 Technical Skills

Business Intelligence : OBIEE 10g,OBIEE 11g,OBIApps 7.9.6.3

ETL Tools : Informatica Power Center 8.6.1/9.1

Databases : SQL Server, PL/SQL, Oracle

Web Technologies : HTML, DHTML, XML

Scripting Languages : Java Script, VB Script

Languages : C, C++,Java

Operating Systems : Windows XP, Windows 2008

Others : Microsoft Excel, Oracle Data Integrator

Academic Profile

B.Tech (CSE) passed out with 80% from Bhoj Reddy Engineering College,

JNTU Hyderabad in 2010

Intermediate (MPC) passed out with 97% from Excellent Junior

College, Khammam in 2006

PROJECT EXPERIENCE

Project # 1

Title : Charles River Associates:CRA-BI Sprint1

Clients : Charles River Associates

Duration : Aug 2013 - Dec 2013

Environment : OBIEE (11.1.1.7), Informatica(9.1), SQL Server, SQL

Developer, SQL, PL/SQL

Charles River Associates is a leading global consulting firm that offers

economic, financial, and business management expertise to major law firms,

corporations, accounting firms, and governments around the world.

CRA-BI, EBS data is loaded into BI Data warehouse using informatica tool

and analysis/reports are built based on this data in OBIEE. This OBIEE

reports data must match with the inform reports data(source reports).

Roles & Contribution: As a Analyst and Developer

. Involved in business analysis and technical design sessions with

business and technical staff to develop requirements document, and ETL

specifications.

. Designed and developed the ETL Mappings for the source systems data

extractions, data transformations, data staging, movement and

aggregation.

. Worked on Informatica Power Center 9.1 Used Source Analyzer and Target

designer to import the source and target database schemas and the

Mapping Designer to map the sources to the target, Mapplets and

Transformation Developer.

. Developed standard and re-usable mappings and mapplets using various

transformations like expression, aggregator, joiner, source qualifier,

router, lookup, and filter.

. Worked extensively with Physical Layer, Business Layer and

Presentation Layer to customize the existing business models and also

developed new models for maintenance.

. Developed new Dashboards and Reports, for users through OBIEE Answers.

. Implemented Object Level Security for the objects like Dashboards,

Reports, and Data Level Security for Users using Session Variables

. Implemented 'Act As' functionality to login as a proxy user in OBIEE.

. Validating the data.

. Performance analysis and tuning the performance.

. Validating the OBIEE reports.

Project # 2

Title : Wyndham Managed Services

Clients : Wyndham

Duration : Jan 2011 - Jul 2013

Environment : OBIEE 10g,OBIEE 11g,Informatica 8.6.1,DAC,ODI,SQL Developer,

UNIX, Windows xp, SQL, PL/SQL,m Oracle 10g/11g

Wyndham Worldwide is one of the world's largest hospitality companies

across six continents. They offer individual consumers and business

customers a broad array of hospitality products and services as well as

various accommodation alternatives and price ranges through our premier

portfolio of world-renowned brands.

Wyndham initially used OBIEE 10g, later they upgraded to 11g. This project

involves 3 environments for OBIEE, later all the 3 environments got

migrated into a single environment.

Roles & Contribution: As a Technical consultant

. Involved in gathering requirements and prepare functional and

Technical document for development

. Worked extensively with Physical Layer, Business Layer and

Presentation Layer to customize the existing business models

. Developed new Dashboards and Reports, for users through OBIEE Answers

. Used OBIEE Add-Ins to insert, deploy, and analyze Reports in Excel and

also OBIEE Objects such as table views and chart views (BI Publisher)

. Worked on BI Publisher importing data from multiple data sources and

delivered Reports, scheduling BI publisher reports, common dashboards,

metadata, security, calculation, caching.

. Used Oracle Business Intelligence Delivers to configure, schedule, and

deliver personalized alerts to Interactive Dashboards by using iBots.

. Implemented cache seeding iBots for performance tuning.

. Involved in developing star and snow flake schema

. Involved in creating Fact and Dimensional tables based on requirement

and source tables.

. Created and modified Dashboards and Guided Navigation Links within

Dashboards.

. Implemented security using LDAP servers.

. Created dashboards using analytics requests & assign Permissions to

dashboards, users & their groups

. Administered NQSConfig.ini and Instanceconfig.xml configuration files.

. Maintained documentation for design, implementation & testing OBIEE

Analytics requests, Dashboards.

. Involved in migration for OBIEE components into various test, UAT and

production environments.

. Involved in up gradation of OBIEE from 10.1.3 to OBIEE 11.1.1.6.

Contact this candidate