We provide IT Staff Augmentation Services!

Sap Resume

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.

Hire Now