Jaya Kranthi Madineni

Phone: 302-***-**** (c)

E-mail: acd5hn@r.postjobfree.com

SUMMARY:

* Over 5+ yrs of IT experience in the fields of Data Warehousing, RDBMS

and Client/Server applications.

* Over 5+ yrs of technical hands-on expertise using OLAP tool Business

Objects 6.x, XIR2, XIR3.1 (Designer, Desktop Intelligence, Web

Intelligence, Infoview, Central Management Console, Import Wizard,

Report Conversion Tool, Performance Manager, Life Cycle Management),

XI R4.1 (Web Intelligence Rich Client, Universe Design Tool, Report

Conversion Tool etc.).

* Extensive experience in Universe Design, Web Intelligence reports and

Full Client reports from multiple sources.

* Experience working with Business Managers, Architects and End users in

documenting requirements, providing work estimates, creating High

Level Design documents and Detail Design documents. Extensive

experience in offshore/onsite development model.

* Experience working with Business Analyst for gathering the

requirements and converting them into functional and technical

requirements document. Involved in discussing the technical features

and functionalities of Business Objects tool with the Business Users

to make them understand the tool features.

* Experience working on large production support projects, worked as a

production support coordinator, coordinating with the off shore team

for daily production support. Define process for hyper care production

support and general production support.

* Experience in migration work, was involved in few migration projects,

involved in migrating BOE from 6.5 to XIR2 SP5 and 6.5 to XIR3.1.

Design migration plan which includes migrating all BO objects from one

repository to other, design the security model for newly migrated

environments.

* Experience in providing Adhoc reporting solutions by designing user

friendly universes for Business users and providing training on

reporting techniques like slice and dice, drill up/down, applying

alerters, report formatting etc ...

* Experience in migration work and was involved extensively in migrating

from R3 to R4.1 and is ready now for a Pilot launch. Completed full

UAT of around 50 reports migrating to R4.

* Knowledge in administering the Business Objects 6.5, XIR2, XIR3.1 like

managing users, groups and setting security at user and group level

using LDAP authentication.

* Knowledge of Data Warehousing concepts like Fact and Dimension design

using Star Schema and Snow flake design techniques.

* Experience working with the following databases Oracle 8i, 9i, 10g,

SQL Server 2000, 2005, Teradata, IBM-DB2, experience working with OLAP

cubes like SAP BW Cubes, Oracle Hyperion OLAP Cubes.

* Experience in writing complex SQL queries, PL/SQL procedures.

* Excellent Technical, Interpersonal, and Communication skills. Good

Programming and Data Management skills.

* Has good exposure to the entire project life cycle viz. requirements

collection and other project management activities and imparted

training to users.

* Able to handle multiple tasks and projects simultaneously.

EDUCATION:

Masters in Computer Applications (MCA) from St. Ann's College, Osmania

University in year 2003.

Technical Skills:

OLAP Tools:

Business Objects (5.0, 5.1.x, 6.x) :- Business Objects Supervisor,

Designer, Desktop Intelligence, Web Intelligence, BCA

Business Objects (XI R1, R2, R3, R3.1, R4.1) :- Business Objects

Designer, Desktop Intelligence, Web Intelligence, WebI Rich Client,

Central Management Console, Info View, Import Wizard, Report

Conversion tool, Report Comparison Tool, Live Office, Life Cycle Management

Operating Systems:

UNIX, Windows 2000/NT/98/95.

Databases:

Oracle 8.x/9i, 10g, SQL Server 2000, 2005, MS Access, Teradata, IBM-

DB2

Query:

SQL, PL/SQL

Languages:

C, C++, Visual Basic, Core Java

PROFESSIONAL EXPERIENCE

Intercontinental Hotels Group

Nov '10- Till Date

Atlanta, GA

Sr BI Analyst & Developer

IHG (InterContinental Hotels Group) operate various hotel brands - Inter

Continental Hotels, Holiday Inn Hotels, Holiday Inn Express, Stay bridge

Suites, Candlewood Suites, Crowne Plaza Hotels, Hotel Indigo etc. IHG has

more guest rooms than any other hotel company in the world with more than

4,200 hotels across nearly 100 countries. Our guests make over 180 million

stays in IHG hotels every year.

Project includes capturing all the data from a customized Sales Force

application called "IHG Javelin" into a data mart, SMART for reporting

purposes. Mostly involved in validating the business requirements against

the MART and working closely with Business and Global Technology to deliver

right and quality data through BO reports. Also re-wrote at least 35

reports in an existing MART in Oracle to a new sales data mart in Teradata

and successfully launched new reporting environment for Sales Users.

Extensively involved in migration of reports in BOXI R3.1 to R4.1 and did a

full UAT of all the 50+ reports migrating to new BO version. Worked on

providing day to day data requests and ad-hoc reports to Users and also

maintained multiple universes according to Business need.

Responsibilities:

. Interacted with Business Users to understand Business Requirements

and prepare the BRDs.

. Worked with Business Managers, Architects and End users in

documenting requirements, providing estimates, creating High Level Design

and Detail design specifications.

. Writing proposals for new reporting projects, analyze the

requirements and provide the high level work estimates and delivery

timelines and then prepare the project plan.

. Create design plan for the universes and develop the universes.

Prepare the Universe development life cycle documentation which includes

the detailed technical specifications.

. Providing reporting solutions to the Business users by creating some

complex WebI reports.

. Working on tuning the report performance by implementing good SQL

techniques and building the user friendly Adhoc universes for Adhoc

reporting.

. Working on the row level security setup in the universe by creating

restrictions at the universe level.

. Extensively used Calculations Contexts, complex calculations, Drill

down, Slice and Dice, Alerts in the creation of reports.

. Extensively used the OLAP methodology in generating the reports like

Drill analysis, Slice & Dice etc...

. Was also involved in the production support, which includes bug

fixing, enhancements and day to day support to the user community. Also

In charge of Data Requests mailbox by handling the adhoc and data

requests from Users globally by taking care of data requests and adhoc

reporting requests.

. Using Import Wizard for the Migration process. Migrated users,

universes, reports, securities etc from XIR2 to XI R3.1.

. Reformatted most of the WebI reports as all DeskI features were not

supported by WebI. Some Universe and reports were migrated manually.

. Planning, coordinating and executing Business Objects deployment for

End-users and documented the entire project.

. Working on the ETL tool (Informatica) to analyze the data issues

which were potentially from the source systems. The data issues were

handled as part of production support, addressing issues like data feeds

not executed on time, delay in running the scripts, manually executing

the missing files etc.

. Coordinating with the data team to develop the data models that suits

the business requirements, worked with the ETL team and was a liaison

between the Business and the data team.

Environment: BO XIR2 (SP5), BOXI R3.1 (Designer, Web Intelligence, Desktop

Intelligence, Rich Client, Import Wizard ) and BOXI R4.1 (Universe Design

Tool, Web Intelligence Rich Client, Report Conversion Tool, Information

Design Tool, BI Launch Pad, SAP BO Dashboard Design, Life Cycle Manager)

Oracle 11g, Teradata, Windows NT, TOAD, SQL Assistant.

Texas Medicaid and Healthcare Program

June '10 to Oct'10

Austin, TX.

BO Developer & Admin

The Texas Medicaid & Healthcare Partnership (TMHP), a coalition of

contractors headed by ACS, a Xerox company, carries out the Medicaid claims

payment for the state of Texas, under contract with the Texas Health and

Human Services Commission.

The project involved in developing the Universes for the business and also

generating the reports. Extensively worked in the migration from 6.5 to

XIR2. Migration involved around 15 universes and 100+ reports and

converting them to WebI for Healthcare division of The Texas Medicaid &

Healthcare Partnership (TMHP). We had 3 different environments

(Development, Quality Assurance, and Production). Ultimate aim of this

project is to provide Business users and customers reference data for

healthcare division and provide insight into the data using new version of

BOXI.

Responsibilities:

. Co-ordinate with the BA team for the business requirements and also

interacts with the business when required.

. Created linked Universes and universes using multiple databases/data

providers.

. Maintained the CMC in the absence of the lead to provide users with

rights to folders and reports.

. Had training sessions for the users when migration. Trained how to

create WebI reports using Info view and also trained the users on using

the Alerters, Prompts.

. Extensively used Calculations, Variables, Drill down, Slice and Dice,

Alerts in the creation of reports.

. Worked on migration project from 6.5 to XIR2, used Import Wizard for

migration. Used Report Conversion Tool to convert the DeskI reports into

WebI.

. Identified the bugs regarding the Trusted Connections in XIR2, and

worked with BO technical support team.

. Was also involved in the production support while migrating to the

new version of BO.

. Used to receive the requests from the user through the Test Director.

This tool was also used as the knowledge base.

. Extensively used the OLAP methodology in generating the reports,

like, Drill analysis, Slice & Dice etc...

Environment: BO 6.5, XIR2 (Designer, Desktop Intelligence, Info view,

Import Wizard, Report Conversion Tool, CMC, Dashboard Manager). Web Focus

5, SQL Server 2000, IBM-DB2, Windows NT, Test Director, SQL Agent, Data

Integrator

Electric Insurance Company

Jan '10- May '10

Beverly, MA.

BO Analyst & Developer

EIC, is a subsidiary of GE, and is an Insurance company serving GE

employees and also public now. EIC had two different product lines called

Commercial Lines and Personal Lines.

The project involved in developing the Universes for the business and also

generating the reports. Extensively worked in the migration from 5.1 to

XIR2. Migration involves of 114 universe and 3460 reports and converting

them to WebI for Sales and Investment Management division of Electric

Insurance Company. We had 3 different environments (Development, Quality

Assurance, and Production). Ultimate aim of this project is to provide

Business users and customers reference data for sales and investment

divisions.

Responsibilities:

. Co-ordinate with the BA team for the business requirements and also

interacts with the business when required.

. Designed Universes for both the product lines in the company. We

developed a total of 85 Universes for all the users.

. Created linked Universes and universes using multiple databases/data

providers.

. Maintained the Supervisor module in the absence of the lead.

. Had training sessions for the users when migration. Trained how to

create WebI reports using Info view and also trained the users on using

the Alerters, Prompts.

. Extensively used Calculations, Variables, Drill down, Slice and Dice,

Alerts in the creation of reports.

. Worked on migration project from 5.1 to XIR2, used Import Wizard for

migration. Used Report Conversion Tool to convert the DeskI reports into

WebI.

. Identified the bugs regarding the Trusted Connections in XIR2, and

worked with BO technical support team.

. Was also involved in the production support while migrating to the

new version of BO.

. Used to receive the requests from the user through the Test Director.

This tool was also used as the knowledge base.

. Extensively used the OLAP methodology in generating the reports,

like, Drill analysis, Slice & Dice etc...

Environment: BO 5.1 (Designer, Business Objects, Supervisor, BCA), XIR2

(Designer, Desktop Intelligence, Info view, Import Wizard, Report

Conversion Tool, CMC, Dashboard Manager). Web Focus 5, SQL Server 2000,

IBM-DB2, Windows NT, Test Director, SQL Agent, Data Integrator

Nova Serra Technologies,

Aug'05-Nov'06

Hyderabad, India.

Client: Deutsche Bank, New York City

BO Developer

Deutsche Bank offers unparalleled financial services in 73 countries

throughout the world. Deutsche Bank is a leading financial institution

involved in personal and institutional lending, mortgages and banking. The

project scope is to design and build a warehouse for decision support for

personal and institutional loan data. The warehouse is built from data

received from various branches and offers summarized view for optimized

decision making.

Responsibilities:

* Interacted with Report Users and Business Analysts to understand and

document the Requirements and translate these to Technical

Specifications for Designing Universes and Business Object Reports.

* Developed Business Object Universes using Designer and Business

Objects for the reporting solution for Operational reporting System.

* Potential usage of alias, context, and shortcut join concepts to

overcome the loops.

* Created Complex Reports Based on the Revenue Data like Revenue by

Segment Area, Interest Rates, Promotion Adjustments, and Top 10

Revenue Lines.

* Involved in providing reporting solutions to the Investment Banking

team, Risk Management team. Created some complex multidimensional

analysis reports.

* Created reports that limit the reports to display information for

particular measures by designing Complex Filters.

* Created Reports like Reports by Category, Reports by Plan, and Reports

by Time (Year, Quarter, and Month Date).

* Created Complex Reports like Master Detail and Cross Tab reports to

view and analyze the data for IR Release.

* Developed Ad hoc reports using Business Objects.

* Formatted Reports as per the User requirements using extensively the

functionalities in Business Objects, which allows the users to analyze

the data.

* Used Web Intelligence for web based query and reporting and published

reports using Info view.

* Extensively used Calculations, Break points, Drill down, Slice and

Dice, @Functions and Formulas, Filters & Alerts for creating Complex

reports.

* Conducted and assisted user training sessions.

* Used the Broadcast Agent for Scheduling and monitoring the Reports.

* Validation of the data by creating different test reports on warehouse

tables and on base tables.

* Tested the report data, performance of data retrieval against the

Warehouse data with TOAD.

Environment: Business Objects Designer6.1a, Business Objects Reporter 6.1a,

Web Intelligence 6.1a, TOAD, Broadcast Agent, Dashboard Manager, Oracle

8.1.7/9i, ASP, Visual Basic, SQL, PL/SQL, SQL*PLUS, Windows XP.

Contact this candidate