SUMMARY

• Around 6+ years of experience implementing Business Intelligence solutions in the SAP Business Objects Suite including: WEBI, Crystal Reports, Lumira, Explorer & Analysis for Office.
• Expert Web Intelligence (WEBI) Report Developer.
• Experienced with the SAP BO 4.2 version SPS03.
• Experienced with the SAP HANA & Business Objects Integration.
• Developed WEBI reports directly on SAP HANA views using HANA direct access.
• Worked through Business Objects versions 4.2, 4.0, XI R3.
• Experienced in SAP HANA Data Modeling, Data Provisioning, and Reports development.
• Extensively worked in SAP HANA Studio in the development of technical artifacts like attribute views, analytical views, calculation views & stored procedures.
• Designed complex Universes in IDT based on SAP HANA Tables and Views.
• Designed the Dashboards using Query Browser on Universes using Dashboard Design with universes built on HANA views.
• Developed data exploration dashboards using BO Explorer based on Information Spaces created on HANA
• Designed and deployed BO explorer 4.1 and WEBI reports on mobiles IPAD, IPHONE and Set automatic scheduling in Business Objects Explorer to load data from various sources.
• Created several Finance WEBI reports like GL, Taxes, Revenue, etc.
• Experienced with BW objects like: Info object, Info cube, DSO objects, Data source, Info packages, data Transfer Process and Multi providers.
• Created complex WEBI reports using Combined Queries, Drill down, Cross tab, Master detail and Formula.
• Experience in installing and configuring the SAP Data Services.
• Worked on attribute structures, Hierarchy Levels and Developed hierarchies to support drill down reports.
• Completely utilized various features in the Business Objects Web Intelligence and Crystal Reports such as Pre - defined Filters, Prompts, Cross-Tab, Report Linking, Sub-Queries/ Sub-Reports, Slice & Dice, Hierarchies, Drill Down, Charts/ Graphs, Report layout/ format features etc.
• Experience in installing and configuring the BOBJ systems, creating/developing UNV connections, Universes, BOBJ Reports, Dashboards using relational databases.
• Involved in Installation and configuration of Business Objects 4.2 and in Up-gradation of BO XI3.x/lower systems to SAP BOBJ 4.2.
• Good Experience in RDBMS Concepts, Database Management Systems, and Expert in writing SQL Queries and tuning SQL (DDL and DML) queries to improve the database performance and availability.
• Expertise in PL/SQL and associated programming languages.
• Expertise in Project management by handling different teams involved in the project and experience in preparing functional and technical specifications, preparing universe and report prototypes, proposing designs, and performed release management.
• Worked on various Reports and configured Microsoft Report Builder
• Experience in gathering business data requirements, creating documentation for reports and dashboards.
• Expertise in coordinating the UAT sessions & Demos.
• Experience in handling Onsite and Offshore models.

TECHNICAL SKILLS

BI and OLAP Tools: Business Objects 4.2/4.1/R3.1/ R3.0/ R2/ R1 6.5, Universe Designer, Desktop Intelligence, Web Intelligence, Info view, Crystal Reports 2008/XI, Analysis for OLAP, Xcelsius 2008, Query as a Web Service, Live Office, Design Studio, Dashboards 4.0, CMC, CMSTableau, Qlik View

Databases: SAP HANA, MS SQL Server 2000,2005,2008, Tara Data

Data Warehouse: SAP BI 7.3/7.0 and SAP BW 3.5/3.1C

Languages: C, C++, ABAP/4, SQL, PL/SQL.

Web Technologies: HTML, XML

Operating systems: Windows XP/ 2000/2003/2008.

PROFESSIONAL EXPERIENCE

Confidential, NJ

SAP BOBJ/HANA Lead Developer

Responsibilities:

• Worked in the Design and Development of WEBI reports in SAP Business Objects with SAP HANA as the backend system.
• Worked closely with the Business Analysts to understand their requirement and Implement the same in the Design of the WEBI reports.
• The design of the reports includes the right selection of prompts for different kinds of reports.
• Worked closely with the SAP HANA team to understand the data models that have to be leveraged to build the repots.
• Participated in the backend SAP HANA activities like preparation of data, designing and implementing HANA analytical models, data provisioning into HANA tables, Data provisioning using Flat Files.
• Designing complex universes in IDT based on SAP HANA Tables, HANA models (Attribute Views, Analytical Views and Calculations Views) for Sales and Inventory scenarios.
• Integrated BOBJ 4.2 with SAP HANA 1.0 (SP10)
• Using the direct SAP HANA access, WEBI reports are developed on HANA views.
• Used Information Design Tool for Creation of Data Foundation, Universe for HANA reporting.
• Experienced in creating Attribute Views, Analytical Views, and Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios.
• Experienced in creating Reports for Enterprise with HANA.
• Experience in Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.2
• Experience in Designing Information Space based on SAP Experience in HANA Information Model using BO Explorer 4.2
• Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
• Working on HANA and BOBJ streamline project, Developed new WEBI reports for new requirements in BOBJ and Rerouting WEBI reports to correct Queries and rebuilding the reports.
• Experienced with BI activities like developing and enhancing PCM Jobs using Enterprise Scheduling Software (UC4)
• Worked on a project where in created various reports showing functionalities in BO like Hyperlinks, Input controls, Data Tracking, Ranking, Alerters, Drill etc.
• Used the formatting options like cross tab representation, section, breaks, data sort options, calculations, font, colors etc

Environment: SAP HANA, SAP Business objects 4.2/4.1, BI Launch pad, BI Explorer space, Web-I Rich Client, BO Dashboards, CMC,CCM,IDT,UDT.

Confidential, Houston TX

SAP BW/BOBJ Consultant

Responsibilities:

• Worked on SAP Business Objects 4.1 (Universe Designer/IDT, Xcelsius, WEBI Rich Client, Import Wizard, CMC, Info view etc.) and SAP BW Environments.
• Designed new OLAP Universes on Cubes, Queries and Multiproviders using SAP best practices.
• Enhanced Universes by exporting, copying existing Universes and cleaned up parameters.
• Based on requirement seamless universes are developed and modified existing ones using Information Design Tool to create multiple reports
• Integrated BEx Reports with BO using direct BICS connectivity.
• Used SAP BW when needed to run Reports and then validate data with respect to SAP Business Objects.
• Analyzed Reports issues in WebI and SAP BW and provided solution to Users.
• Created Prompts, Filters drill down into charts and tables for WebI reports.
• Extensive experience working on WEBI reports. Created queries, adding objects, user defined filters, prompts, sorting & filtering data and exporting reports to CMS.
• Created User Groups, assigned Folder level Security, and maintained BOBJ environment based on project Requirements.
• Worked on Analysis for OLAP in creating workspaces, performing simple and dynamic calculation and exporting Analysis Views.
• Used Import Wizard to help Migrate Project Deliverables between Dev, QA and Production Environments.
• Predominantly worked in InfoView, working with objects, connecting to databases, creating Crystal Reports, Web Intelligence documents over universe Had Performed Various BOBJ Admin Duties Ranging from Creating Users, Roles, Scaling Servers, Scheduling Jobs etc.
• Trained end users in accessing BEx Reports using Netweaver portal and Web Intelligence reports using BO Infoview.
• Worked on transitioning the development activities to offshore team by creating detail design documentation and also managing the offshore resources effectively.
• Created WebI queries and turned them into Tables and different graphical views.
• Worked on Checking the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Creating Adhoc Reports by accessing the Universe
• Worked on Dashboards using Filters, List View, table, Line, Column and Pie charts (combination bar graphs, combination bar and line graphs, and line graphs will be used to display metrics.)

Environment: SAP BW, SAP business Objects 4.1/4.0, Central Management Console, Central Configuration Manager, Crystal Reports, Dashboards, MS SQL Server 2008

Confidential, Atlanta GA

SAP BO/BI Consultant

Responsibilities:

• s: (offshore and primary role for Explorer on-site and Quality Assurance testing)
• Coordinated and led the weekly meeting with offshore team to insure that development best practice is followed.
• Lead the BI team for functional specifications, functional design, technical design and built The Information Spaces and Exploration Views, WEBI tables and queries in the new SAP Business Objects Explorer 4.0 and WEBI applications.
• Designed and deployed more than 100 BO explorer 4.0 and WEBI reports on mobiles IPAD and IPHONE and the WEB for more than 200 users.
• Analyzed and identified the root cause issues within the Information Spaces, WEBI reports, and Dashboard trackers during UAT testing. I also assisted with user’s setup for the mobile BI applications.
• Worked on Creating, enhancing, and testing of universes and reports
• Worked on Defining BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops inUniversesusing Table aliases and contexts.
• Worked on Using Designer to create Dimensional, Detail and Measure objects
• Worked on Enabling dynamic report linking by passing Variables (prompts) between reports, Developing complex queries and reports using different data providers in the same report
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Designed and Develop BO Explorer tracker for CAT equipment in the Explorer environment.
• Aautomatic scheduling in Business Objects Explorer to load data from various sources.
• Lead the Unit testing, Integration testing, System testing, Acceptance testing and user prior to the final system deployment and Support SAP rollout projects.
• Set and participated in Power users, key users and users .

Environment: Tara data source, Mobile Applications, SAP Business Objects 4.0,Explorer, WEBI Rich Client, Universe Design Tool, Dashboards.

Confidential, Arbul Hills MI

SAP BO/BW Consultant

Responsibilities:

• Build Xcelsius Dashboards using SAP BICS Connector uses SAP BW Queries to get data from SAP BW.
• Used Open Docs to allow users to move from the Dashboard to its related detailed WEBI report. And also from WEBI reports to another reports using hyperlinks achieved through using OPEN Docs.
• Worked on production support for solving issues related to Universe, WEBI reports & Dashboards.
• Provided User Support, and Support for Soft Project hand over to Production Environment.
• Used Bex Queries all through the Project to build OLAP Universes, and WEBI Reports & Xcelsius Dashboards.
• Worked on Bex Analyzer to test the above mentioned Xcelsius Dashboards, WEBI Reports & Universe, to verify & test the Consistency of data all throughout the SAP BW & SAP BOBJ Platform.
• Used Info view excessively to test WEBI reports.
• Created Cross Tab Reports, Pie and Bar Charts, Parameter Reports, Running totals, Sub Totals embedded linked and unlinked sub-reports to separate and organize key information and to promote reusability in data reporting.
• Maintained high level of customer satisfaction with Custom Reporting services from both internal and external customers.
• Analyzed the existing Crystal reports and tuned for faster execution. Troubleshoot existing reports to eliminate data discrepancies and respond to end-user inquiries.
• Worked on Performance Enhancements for Xcelsius Projects built by other teams, by looking into various aspects like Architecture, Design, Server Scalability and Environment Load Handling.
• Provided User, Project Support, and Guidance all through the project.
• Served as POC for BO Testing against Deliverables based on requirements and project Specifications.
• Involved in testing the queries in HP Quality Center.
• Worked on the end users in working with the Business Objects user module and provided technical expertise.

Environment: SAP BI, Business Objects, Crystal Reports, Xcelsius 2008, Oracle 10g.