Professional Summary

• Over 7+ years of IT experience in analysis, design, development and implementation of Business Intelligence and Data warehousing applications using SAP Business Objects, Xcelsius (Dashboard design) , SAP BI 7.1, Oracle 9i , SQL Server and Informatica.
• 6 years of extensive experience in Business Objects 3.1/XI R2/6.5, Universe Designer, Web Intelligence, Desktop Intelligence, Central Management Console, Import wizard, Performance Manager, Info View, Xcelsius 2008, liveoffice, QaaWS and Voyager.
• 2+ years of experience in SAP BI 7.1, BEx Query Designer, DWH Workbench and WAD.
• Extensive 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 business requirements, functional requirements and data specifications for Business Objects Universes, Dashboards and Webi reports.
• Expertise in designing Business Objects Universes, creating complex reports using Web Intelligence, Webi Rich client and Deski.
• Extensively worked on designing and developing universes using SAP BEx Queries, Multiprovider and relational data sources.
• Worked on Central Management Console (CMC), Created Users and Groups and setting the rights, importing sap roles and enabled SAP authentication.
• Experience in developing Xcelsius dashboards using live office, QaaWS and BICS connections.
• Experience onInformation Design tool, Interactive Analysis and BI Launch pad in SAP BO 4.0
• Have good hands on experience in new features like Business layer, Data foundation, BICS Connections, Security Profiles, and 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.
• Strong experience in creating BEx Queries using calculated and restricted key figures, variables, structures, Exceptions and conditions.
• Worked on creating WAD Templates, dynamic charts using Web Application Designer.
• Experience in designing Info Objects, Data Sources, DSO, Infocube, Multi Provider and creating Info package and loading data from PSA to Data Targets.
• Experience in ETL process using Informatica Power Center 6.1.
• Have good hands on experience in ETL application using Data services BODS.
• Good knowledge in data warehouse design techniques, dimensional modeling, Star and Snow flake schema, and Extended Star schema.
• Good experience in SQL and PL/SQL.
• Disciplined and self-motivated team player with good verbal and written communication skills.
• Quick learner and Keen interest in learning new technologies.

Technical Skills

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

Project Details

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 Gauge and used functions like SUMIF,COUNT and CONCATENATE.
• 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.
• Scheduled the web intelligence reports and created live office connection to latest instance of report.
• 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.

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.

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

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.

Confidential,USA
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.

Confidential,UK.
Period : Apr 07- May 07
Role : Business Objects Developer
Environment : Business Objects XI R2,Universe 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.

Confidential, US
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.

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.
  

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.

Education

• B.E (Electrical & Electronics Engineering)

Training

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