PROFESSIONAL SUMMARY:

• *+ years of IT experience, quick learner, easily adapts to various environments and very effective communication and interpersonal skills.

Having 4 years of experience in SAP BW/BI 7.0, and SAP BO.

Exposed to full software life cycle implementation and ability to quickly determine and meet specific client needs that includes Modeling, Extraction and Reporting using BEx and has extensively worked on creation of Info Cubes, ODS objects, KPI’s, activation of Business Content and designing of process chains. Expertise in Extraction of data from SAP R/3, Data loading, Managing of Info cubes, performance issues like indexes, Compression of info cube, rolling up of data to Aggregates, Generation of reports. Knowledge in enhancement of standard SAP functionality using User Exits & Customer Exits. An outstanding contributor to the project team and has excellent communication and presentation skills.

Experience in Business Objects ,Universe Designer, Webi, Deski, Infoview, Webi Rich Client, Central Management Console, Central Configuration Manager, Import Wizard, Supervisor , Web-Intelligence , Crystal Xcelsius -- 2008, Business Objects Live Office, Query as a Web Service.

• Good exposure in overall BO XIR2 application architecture and able to Design, Deploy, Support the application architecture.

• Created Universe from scratch and created reports in Business Objects

• Worked on Web intelligence report and Desktop Intelligence for XI R2.

• Experienced in migration of Business Objects.

• Well versed in Business Objects (6.X and XIR2) with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence, Info view, Dashboards, Auditor and Schema Design.

• Created critical visualization using Business Objects Crystal Xcelsius 2008 the Business Dashboard.

• Linking reports in Webi using Open Doc function.

• Good knowledge and experience in using Querying and Reporting modules of Business Objects Enterprise XI.

• Worked on Web Intelligence to develop and publish thin client reports.

• In-depth knowledge in creation of WEBI reports and Dashboards using Crystal Xcelsius.

• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.

• Solid knowledge of SQL.

TECHNICAL SKILLS:

BO Tools: Designer, Supervisor, CMC, Reporter/Desktop Intelligence, Central Management Console, Info view, Web Intelligence, Crystal Xcelsius 4.5, Crystal Reports XI/2008, Data Integrator

OLAP: SAP BW/BI

Data Modeling: Star-Schema (ROLAP) Modeling, Snowflakes Modeling, Physical and Logical Diagrams

EDUCATION

B.TECH FROM JNTU Hyderabad.

EXPERIENCE: 3.9 years

VG SYSTEMTS PVT LTD ,HYDERABAD AS A TUTURE FROM JUNE 2003 TO MARCH 2005

DATA POINT TECHNOLOGIES,HYDERABAD AS A TRAINEE FROM APRIL 2005 TO SEP 2007

MARCENT TECHNOLOGIES AS A SOFTWARE ENGINEER (BO CONSULTANT) FROM OCT 2007 TO TILL DATE

Client/Company :JPMC

Project :Mutual Fund System

Role :Business Objects Developer

Project Duration : Oct 2007 to Nov 2008

PROJECT DESCRIPTION:

This Project has been developed for investment management system of Citibank, which is one of the largest savings and financial banks in New York. We generated reports that helped analyze how the customers are investing in mutual funds, trade stocks, bonds and mortgages by business users. The project involved development of various complex, Ad-hoc and canned reports. Large manipulations were done to generate reports that could help the mangers to analyze and improve the performance of company in the weaker areas and increase customer base

Designation: Business Objects Developer/Xcelsius Developer

Responsibilities:

•Involved in Full project life cycle (requirement gathering to implementation phase).

• Worked very closely with upper management to get detailed information on what information they require in each report

•Created/Modified Universes and linked with the existing Universes with Oracle backend and exported to repository.

•Created Users and implemented security features.

•Created Slice and Dice, Drill down and Cross Tab reports.

•Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.

•Supported and maintained universes built in the current Dev and Production environments

•Used various functions in Designer to build complex objects in universes.

•Applied custom Hierarchies and generated cascading LOV's for several universes.

•Recreated complex Deski reports into Webi using web intelligence tool.

•Created complex Xcelsius dashboards to reflect User Adoption Metrics.

•Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.

•Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.

•Implemented row and object level security in business objects supervisor module.

•Managed the scheduling options stored in the repository and also involved in changing the document descriptions.

•Created Live data connected Dashboards for the Executive Dashboard portal using Crystal Xcelsius 4.5 to provide them a summarized glance of the reporting environment in an interactive manner.

•Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.

•Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis.

•Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.

•Built multi variable what-if analysis bar charts for all information at one glance about all product lines of the company.

•Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports.

•Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.

•Updated data for crystal Xcelsius visualizations by using export setting commands. Complex data was retrieved from excel files, Flash files using Flashvars property as well as dynamically from external XML data sources.

•Used customized templates and also created visualizations from scratch to build new templates for better understanding and better decision support.

•Used Crystal Report to feed data to Crystal Xcelsius Visualization an XML file as a data source. Also used QAAWS.

•Used query as web option to build visualizations based on the reports built in Business Objects.

•Exported visualization contents to various file formats (pdf,ppt,html,flash) .

•Involved in troubleshooting the visualizations for various problems faced during data connectivity.

•Deployed Business Objects XI R2 on Windows 2003 server using Apache / Tomcat

•Migrated P1 reports from 6.0 to XI R2 , used import wizard to migrate repository and its components (Universes, documents, users, privileges) , reported import wizard bugs related to report formatting

•Resolved loops, chasm and fan traps using contexts, aliases and integrity checks

•Created dashboard by using Xcelsius retrieved data from Excel file by using Live Office.

•Exported the universes to the Repository to make the resources available to the users.

•Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.

•Involved in trouble shooting of various reporting errors.

Federal Trade Commission, DC, USA. Dec ’08 to Aug’09

Role: Business Objects Developer and support

Description:

Project is LANDOC which is system used to retrieve full text and provide quick access to Commission documents for the purpose of research also to use in current work. It also provides indexes to and summaries of older documents that address legal, economic, and procedural issues relevant to the Commission's work.

Responsibilities:

• Created Universes, Classes and Objects for management systems.

• Resolving Loops using Aliases and Contexts and check Integrity of the Universe and exported them to the Repository to make resources available to the users and groups.

• Updated and maintained Universes based on changing user requirements and data source changes.

• Developed and Deployed complex reports. Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.

• using report wizard generated reports in crystal reports

• worked with report formatting such as combined database fields using text objects as well as mapping old fields to new names using crystal reports

• Created OLAP-only reports based solely on the cube in crystal reports

• Linked sub-reports to display related data elements from more than one database table

• Using Business Objects created users and their profiles and applied securities to them

• Created templates for standardizing the Structure of our Corporate Documents.

• Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.

• Created Report level variables by using Used Variable Editor

• Analyzed the reports using the Drill Through, Slice and Dice

• Created reports on web using web intelligence, distributed the reports to different users.

• Scheduled and monitored reports using Broad Cast Agent (BCA).

• Worked on using the import wizard in moving reports and universes from Dev to UAT and to Production environments.

• Resolved loops, chasm and fan traps using contexts, aliases and integrity checks.

• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports.

• Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.

• Deployed Business Objects XI R2 on Windows 2003 server using Apache / Tomcat

• Migrated XI R2 reports to XI3.1, using Life cycle Manager to migrate repository and its components (Universes, documents, users, privileges)

• Created dashboard by using Xcelsius retrieved data from Excel file by using Live Office.

• Exported the universes to the Repository to make the resources available to the users.

• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.

• Involved in trouble shooting of various reporting errors.

• Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis.

• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.

• Built multi variable what-if analysis bar charts for all information at one glance about all product lines of the company.

• Updated data for Crystal Xcelsius visualizations by using export setting commands.

• Used customized templates and also created visualizations from scratch to build new templates for better understanding and better decision support.

• Used Crystal Report to feed data to Crystal Xcelsius Visualization an XML file as a data source. Also used QAAWS.

• Used query as web option to build visualizations based on the reports built in Business Objects.

• Exported visualization contents to Micosoft Excel and Power Point.

• Involved in troubleshooting the visualizations for various problems faced during data connectivity.

Client/Company: GENPACT India

Project: HR Reporting System

Role: SSE - Business Objects XIR3

Project Duration: Sep 2009 to Till Date

PROJECT DESCRIPTION:

The objective of this project is to deploy Business Objects reporting solution to HR Directors, HR Managers and Finance allowing them to have data readily available to make fact-based decisions about the company's human capital. The addition of canned reports (dashboard like reports and/or new reporting templates) will enable HR Directors and HR Managers to extract key information from Business Objects. This will solve significant process and information quality problems that negatively impact current delivery of HR reports and ad hoc queries.

RESPONSIBILITIES:

• Understanding the requirements and feasibility

• Creating the Universe with required classes and objects, modifications and maintenance of Universes

• Resolve the loops using aliases and contexts

• Check the integrity of the Universes and export the universe to the Repository for making available to users

• Creating real time reports using Crystal 2008

• Creating the dashboards using XCelsius 2008

• Created reports from Business Object universe, as main data providers and using the functionality like @functions for user response

• Created reports from variety of data sources

• Creating complex report using graphs, pie charts and multiple data providers on daily, weekly, monthly and quarterly basis

• Used drill Up/Down operations done for different aspects of client business

• Enabled monitoring of File Server, Job Server and Event Server for Scheduling jobs, etc. using SDK

• Deriving POC’s for getting new assignments from the prospective clients

Contact this candidate