Profile 
SAP BO expert with 7 years of professional experience which includes 2 years in SAP BI 7.1.
Designed, developedand implemented Business Intelligence and Data warehousing applications using SAP Business Objects XI3.1, Xcelsius 2008, SAP BI 7.1 Oracle 9i and SQL Server.

Professional Summary

• Experience in developing BI Reporting solution on relational and multidimensional data sources, SAP BI BO Integration leveraging SAP Datasouces.
• Involved in gathering, analyzing, and documenting requirements, functional and technical specifications for Business Objects Universes and Reports.
• Extensively worked in designing Business Objects Universes, creating complex reports using Web Intelligence and Deski.
• Experience in developing Xcelsius dashboards using live office, QaaWS and BICS.
• Designed and Developed universes using SAP BEx Queries, Multiprovider and relational sources.
• Hands on Experience onInformation Design tool and Interactive Analysis in SAP BO 4.0
• Good knowledge on new features like Business layer, Data foundation, BICS Connections, Security Profiles, Element linking in SAP BO 4.0.
• Knowledge and understanding on SAP HANA, and hands on experience on HANA studio.
• Experience on Prototyping the new technologies like Voyager and SAP BO Advanced Analysis.
• Experience in creating BEx Queries using calculated and restricted key figures, variables, structures, Exceptions and conditions.
• Experience in designing WAD Templates using Web Application Designer.
• Hands on Experience in designing Info Objects, Data Sources,DSO,Infocube, Multi Provider and familiar with creating Info package and loading data from PSA to Data Targets.
• Experience in ETL process using Informatica Power Center 6.1
• Good knowledge on Dimensional Modeling, Star and Snow flake schema, Extended Star schema.
• Good experience in SQL and PL/SQL.
• Disciplined and self-motivated team player with good verbal and written communication skills.
• Keen interest in learning new technologies.

Education

• B.E (Electrical & Electronics Engg)

Technical Skills

BI Tools : SAP Business Objects 4.0, XI 3.1/R2, Information Design Tool, Interactive Analysis, Web Intelligence and Universe Designer, DeskI, SAP BI 7.1, SAP BEx Query Designer and Web Application Designer, Xcelsius 2008, Live Office, CMC,Voyager, (Qaaws) Query As A Web Service and BO Dashboard Manager, HANA Information Modeler
ETL Tools :Informatica powercenter 6.1
Databases : Oracle 8i/9i, MS SQL Server 2005
Languages : Visual Basic 6.0, SQL and PL/SQL
Platforms : Windows 7/Vista/XP 

Project Details

Client : Confidential,
Period : Apr `11- Dec ‘11
Role : SAP BO/BI Consultant
Environment : Business Objects XI 3.1SP3, Xcelsius 2008, live office, SAP BI 7.1 BEx Query Designer
Responsibilities:

• Involved in study of System Landscape, Requirement analysis and documentation.
• Designed the overall SAP BI-BO implementation strategy by defining interfaces and tools.
• Analyzed the Operating Expenses by function categories for Bottling Investment group.
• Created and enhanced OLAP universes using BEx queries, and developing webi reports.
• Created Interactive and dynamic dashboards using multiple filters, Alerts, charts, list view, and Gauges.
• Created URL component in Xcelsius using opendocument functionality to drill to detail webi report.
• Created BEx queries with structures, variables, restricted and calculated key figures.
• Defined the deployment process and responsible for overall BO delivery.
• Resolved Live office issues with Xcelsius dashboards and Web Intelligence reports.
• Involved in deployment of Xcelsius (SWF) files and webi reports using Import Wizard.

Client : Confidential 
Period : Jul 10- Mar 11
Role : SAP BO/BI Consultant
Environment : Business Objects XI 3.1SP3 (Web intelligence, Designer), Xcelsius, live office, SAP BI 7.1 BEx Query Designer
Responsibilities:

• Developed the methodology for building dashboards and web intelligence reports.
• Analyzed the Planning, Costing and Inventory KPIs from the Value Tree Matrix and mapping them to dashboards.
• Developed OLAP universes connecting to SAP BEx Queries.
• Created dynamic dashboards based on user input using combo box and filter components.
• Dashboards using multiple charts, dynamic visibility, and Alert features were designed to support complex requirement scenario.
• Resolved connectivity issues with Xcelsius dashboards and Web Intelligence reports.
• Worked with MDX expressions in Universe for creating calculated measures.
• Created web intelligence reports using the variables, breaks, calculation contexts.
• Used new reporting functionalities like Query stripping and Input Controls.

Client : Confidential, 
Period : May 08- June 10
Role : SAP BO/BI Consultant
Environment : SAP BI 7.1, Business Objects XI 3.1 (Web intelligence, Designer, Voyager, Xcelsius),
BEx Query Designer and Web Application Designer
Description: 
FPS MI Module: Fuel Pricing Services (FPS) MI provides information on Shell and competitor retail fuels pricing in thirty-seven countries across Shells global markets. This information is used to monitor the impact of Shell and competitor fuel pricing and assists the Global Pricing Group in setting and managing a pricing strategy to achieve Shell’s objectives for volume and revenue in a competitive market. 
Credit MI Module: Credit MI provides strategic high-level information on the status of Shell debtors globally, allowing Shell to measure and manage its exposure – especially important in the current economic environment. Global PMR reporting will provide Credit with the capability to pull automated reports (with actual data) providing cross-border, cross-business, down to customer account level MI.
HSSE MI Module: The HSSE MI - Global PMR project will deliver a single global version of high quality MI to DS HSSE stakeholders in support of Group, DS, COB metrics and external information needs, like the annual report. This would allow flexible reporting of Performance improvements towards HSSE Global Initiatives, such as Goal Zero and the Life Saving Rules, with a consistent user interface, and the ability to deliver reports to appropriate user categories and enable Global DS HSSE Strategic MI Analysis and Reporting System.

Responsibilities:

• Developed web intelligence reports on SAP OLAP universes. Created dynamic reports by populating the data using calculations as per the user prompt selection.
• Created linked reports using hyperlinks by passing prompts with Open Document functionality.
• Creating conditions and prompts in OLAP universe using MDX.
• Developed BEx Queries with calculated and restricted key figures, cell definitions and variables.
• Designed WAD templates with Analysis, Filters and Chart web items using multiple data providers.
• Developed dynamic content in WAD templates using path replacement of variables and filters.
• Involved in RRI configuration of reports to set jump targets.
• Involved in solving UAT issues and change requests.
• Created Universe queries using Qaaws (Query as a web service) and used the web services in Xcelsius for generating dashboards.
• Developed POC (Proof of Concept) on implementing hyper linking of web intelligence reports with BI variables as parameters and got accepted by User.
• Performance tuning of WebI reports and OLAP universes using optimization techniques.
• Testing of reports by validating the data with BI Info cubes and BEx Queries.
• Created Voyager workspace using BEx Queries.
• Created technical specification documents for report requirements.

Client : Confidential
Period : June 07- Feb 08
Role : Business Objects Consultant
Environment : Business Objects XI R2 (Enterprise Performance Manager, Designer, Web intelligence, Infoview), SQL Server, Remote Desktop using Citrix, Visual Source Safe. 
Responsibilities:

• Created Analytics like IMT, Speedometer etc and linking of Analytics to the webi reports.
• Created metrics using calendars and aggregate functions for building analytics.
• Created universes for developing analytics and webi reports.
• Creation of @prompts in universe to add calendars in performance management.
• Created prompts, variables at report level using BO functions.
• Created unit test cases to verify and validate the report data by running SQL queries.
• Worked on creating stored procedure for Business Objects Reporting.
• Used SQL and PL/SQL scripts to test reports create the reports.
• Responsible for analysis of customer requirement.
• Interaction with the client for requirement understanding.

Client : Confidential
Period : Apr 07- May 07
Role : Business Objects Developer
Environment : Business Objects XI (Designer, Desktop Intelligence), Oracle 9i
Responsibilities:

• Responsible for creating Reports as per Business Rules.
• Created tabular reports using grouping and sections.
• Created reports using the functionalities like Prompts, Filters, and Formulae etc.
• Created variables for the reports involving complex calculations.

Client : Confidential
Period : Mar 06 to Mar 07
Role : Business Objects Developer
Environment : Business Objects 6.5.1 and Oracle 9i

Responsibilities:

• Involved in modification of universes based on user requirements.
• Created reports using Full Client and Thin Client.
• Developed complex reports using features like prompts, drill capabilities, Master Detail, and cross tab reports with multiple breaks.
• Created the filters at the report level to filter the data.
• Involved in end user training on Business Objects.

Client :Confidential
Period : Apr 05 – Feb 06
Role : Application Developer
Environment : Business Objects 6.1, Infoirmatica, Oracle 9i.

Responsibilities:

• Involved understanding client requirements, designing and implementing the same by providing the reports to management, on the corporate portal, for decision-making.
• Involved in the development of Universe. Created classes and objects, filters and custom hierarchies for drill down features.
• Design and development of complete full client and webI reports using multiple data providers.
• Involved creation of reports with drill down capability, charts for depicting data and prompts for user inputs.
• Created test cases for validating the report output.
  

Client : Confidential
Period : Aug 04 – Mar 05
Role : ETL Developer.
Environment : Informatica Power Center 6.1, Oracle 8i, Windows 2000 Server.

Responsibilities:

• Extracted data from various sources like Oracle, SQL Server and text files to load the extracts into target warehouse.
• Worked on Source Analyzer, warehouse designer, mapping designer, and transformation Developer.
• Involved in creation of mappings using Transformations such as Source Qualifier, Expression, Aggregator, Joiner, and Lookup Transformations.
• Created workflows.

Training 

• SAP Business Objects Integration Workshop Organized by SAP.
• SAP Technology Basics training Organized by Business Objects.
• Business Objects Enterprise Performance Manager training.