G.SRAVANTHI

C:+91-986*******

E:tr2eb8@r.postjobfree.com

Professional Summary

• Having 3.7 years of experience in IT and 3.2 years of experience in BO Design,

Development, Data Warehousing, documentation and implementation in BOBJ.

• Experience in IT industry with strong knowledge in all phases of Software

Development life Cycle (SDLC) such as report developments, scripting and testing

with all security managements.

• Extensively worked on Web Intelligence reporting and Universe Designer using BOXI

3.1, BOXI 3.0, and BOXI-R2.

• Worked on Business Objects XI 3.1 Integration with SAP BI and SAP R/3.

• Experience in Crystal Reports 2008 with Universe for dashboard designing.

• Having working experience of methodologies like Star Schema and Snowflake

Schema.

• Knowledge in Oracle 9i/10g, SQL Server.

• Proven abilities in creating complex reports by linking data from multiple data

providers, using free hand SQL and stored procedures.

• Installation and configuration of Business Objects XI Release 3.1 Products on

Windows.

• Experienced in interacting with business users to analyze the business process,

requirements and transforming requirements into report data, documenting and

rolling out the deliverable.

• Involved in requirement analysis and effort estimation for report development and

deployment.

• An enthusiastic self motivated fast learner , good listener and project-oriented team

player with solid communication and leadership skills and the ability to develop

creative solutions for challenging client needs.

• Exposure to Data Integrator/ Data Services.

• Have good Domain Knowledge in Health,Insurance,Retail

• Hands on Experience in SAP BO Integration kit.

Technical Expertise

Reports : Universe Designer, Desktop intelligence, Web intelligence Rich Client,

LiveOffice,Crystalreports2008 with Universe,CMC,InfoView, Xcelsius2008,BOXI-4.0,BOXI-3.1,SAP BI,BOXI 3.0, and BOXI-R2.

Languages : SQL

RDBMS : Oracle 9i and 10g.

OS : Windows 2003 server, Windows 95 98 2000 XP, 7.

SAP BI/BW : BEX Query / Info Provider(ETL & Modeling).

Professional Profile:

Working for Wipro Technologies, Mumbai, as BO Developer from May 2010 to till date.

Joined CORBZ DATA INFO SOLUTIONS,HYD in AUG,2008 as a S/w Developer.

Education & Training

Bachelor of Science from Osmania University, Hyderabad.

Professional Experience

Project 1:

Project : BIMS - Business Intelligence Maintenance Services

Type : Development and Support.

Software : Business Objects XI 4.0, SAP R/3, Web Intelligence, Live

Office, QaaWS, SAP GUI and Windows XP.

Client : Swiss Re, Zurich - Switzerland

Duration : Feb 2011-Till Date.

Role : SAP Business Objects Developer

Business Need:

Swiss Re is one of the leading global re-insurers. Swiss Re offers a wide range of traditional reinsurance products and related services. The main business functions include Client Management, Underwriting, Claims and Liability Management, Pricing, Technical Accounting and Financial Management. Non-Life Treaty Reporting a project of BIMS mainly supports the information exploitation needs of the business functions "Client Management" and "Underwriting / Pricing" on a global basis for P&C business. Pro vide highly flexible analysis, suggestions to the existing data mart, provision of standard reports, expert environment and ad-hoc reporting. Provide Reporting solutions for Renewal-tracking reports, Technical, Economic reports & even for combined reports.

Responsibilities:

• Interacted with Business Users to gather business requirements and performed detailed

analysis.

• Worked closely with ETL Team for the implementation of Business Logic/Rules.

• Preparation of Technical design document for reports based on the functional specifications

• Responsible for Universe creation, Hierarchy Building for Data Analysis and applied

conditions in Business Objects.

• Worked with database connections, joins, cardinalities, loops, aliases, views, aggregate Condi tions, parsing of objects and hierarchies.

• Resolved the loops using Contexts and checked the Integrity of the Universes.

• Created Web Intelligence reports using functionalities like Cascading Prompts, @Functions,

Cross Tabs, Master/Detail, Slice and Dice, Drill Down, and Formulas

• Created filter objects, and formatted objects and measures within the universe for faster report

generation.

• Designed, developed, tested and maintained highly complex reports.

• Worked closely with SAP BI team to integrate SAP with BO.

• Created Queries, Calculations, Variables, Breaks, Sorting, Alerter and Formatted Presentation

Styles (Graphical). Most of the reports involved using multiple data providers.

• Scheduled ETL jobs and created materialized views at DB level to improve the Query

performance.

Project 2:

Project : MICS - Medical Insurance Claim System.

Type : Development and Support.

Software : Business Objects XI 3.0/3.1, Xcelsius 2008, Crystal Reports 2008, Web

Intelligence, SAP BI, SAP R/3, SAP GUI, Windows XP.

Client : Swiss Re, HONG KONG

Duration : April2010-Dec2010.

Role : Business Objects Crystal Report and Web Intelligence reporting

developer.

Business Need:

The Medical Insurance Claim System (MICS) is an application which is used by Third Party Administrator (TPA) to process Claims. At a high-level, the application allows creating different insurance products into the system, enrolling policy for members, process pre-authorizations and claims for those policies. TPA receives claims and enrolment details from health insurance companies. TPA then captures these details into the MICS system. The Claim is then processed, based on the Product specification and the inherent business rules. This application contains modules namely Product Management, Enrolment, Empanelment, Claims Processing, Pre-authorization, Customer Care, Administration and Reports. Business planned to provide reports to insurance companies, which are sent to them based on the Standard Reporting Schedule: monthly, quarterly, annually. Around 40 different report data and dashboard design representation is needed. Reports and dashboards need to be implemented in both English and Chinese languages.

Responsibilities:

• Understanding the user requirements.

• Involved in creating the report requirement documentation.

• Analyze and make Specifications for the development of the reports for modules like claims,

Billings and Enrolments.

• Created classes with Dimension, Detail & Measure Objects and specified the hierarchies.

• Worked with database connections, joins, cardinalities, loops, aliases, views, aggregate

Condi ions, parsing of objects and hierarchies.

• Resolved the loops using alias and Contexts and checked the Integrity of the Universes.

• Preparing test cases for report testing as per the requirements given by clients.

• Created thin client reports using Web Intelligence.

• Involved in all phases of migration from Business Objects Enterprise Dev to QA and

Production.

• Exported reports in different formats like PDF, Text and MS Excel.

• Worked using Import Wizard & Reports conversion Tools for content and report migration

and conversion activities.

Project 3:

Project : Walgreen's Health Care Services.

Type : Development, On-going Maintenance, Enhancements and Support.

Software : Business Objects XI R2/3.0, Oracle 9i, Designer, Info View, Live Office

Web Intelligence, and Windows XP.

Client : Wai green's, US

Duration : June 2009-Feb 2010

Role : Business Objects developer.

Description

Walgreen's is one of the largest pharmacy chains in the world, with over 6000 stores and 12 main ware houses, spread across the USA. Walgreen's provides Services like Mail service pharmacy, Pharmacy benefit management, Home care services , Specialty pharmacy, Long-term care pharmacy , etc. Wai-green's is considered the leader in innovative drugstore retailing. Walgreen's pioneered many store fea tures over the last two decades that are becoming standards in the industry. The company headquarters are located at Deerfield, on the outskirts of Chicago, Illinois, USA.

Roles & Responsibilities:

• Interacted with Business Users and Business Analyst to gather the requirements and Business

Ob jects.

• Created complex Crystal sub reports Created custom Accesslevels/profiles at CMC.

• Created Webi reports for various business needs and formatted reports, generated charts as

per user requirements.

• Created Adhoc Reports using Business objects Universe as the Data source in Web

Intelligence.

• Created Canned Crystal Reports using Business View as the Data source in Crystal 2008.

• Testing the Universe and Reports based on business criteria

• Preparation of Technical design document for reports based on the functional specifications

• Involved in designing Dashboard using Xcelsius. Created UI control Dashboard(Xcelsius).

• Worked with joins, cardinalities, loops, aliases, views, aggregate Conditions, parsing of

objects and hierarchies.

• Identified and created classes with Dimension, Detail & Measure Objects and specified the

hierarchies and used the Aggregate awareness Functions to improve the Performance.

• Also responsible to see the smooth running of reports from the Application in the client

environ ments.

• Scheduled reports on specific schedulers and sending them to specified users.

• Used QAWS & Live office to connect Xcelsius as a Data source to generate Dashboard.

SAP -BW/BI EXPERIENCE

4. Project

Type : IMPLEMENTATION

Client : DSM

Project Name : DSM

Duration :July 2008-Feb 2009

Environment : BI 7.0

Team size : 8

Nutrition and health, personal care, pharmaceuticals, automotive, coatings and paint, electrical and electronics, life protection and housing. . The company is headquartered in the Netherlands, with locations on five continents

Responsibilities:

Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DTP, Info package, transformation.

Involved in creating Cube, DSO’s, Multiproviders, Info sets, Open Hub Destination.

Involved in creating Aggregates, Partitioning, Indexes, Roll-up and Compression to improve the Query performance.

Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating Queries.

Involved in front-end BI Components like Queries, Formulae, Variables, Calculated Key figures, restricted key figures, Structures, Selection, Exceptions, and Conditions.

Involved in creating Variables like Characteristic, Text and Formula using Processing Types.

Worked on all extractors(Generic,FI,COPA and LO) for SD Module.

Worked on Data Source Enhancements for LO Extractor.

Uploading master data and transactional data SAP R/3.

Creation of Process Chains, Meta Chains for upload of Transaction Data and Master Data.

Monitoring and Error handling in PSA like modifying the error records and reloading the data.

Installed objects from business content.

Contact this candidate