SUMMARY

• Overall 8+ years of SAP Business Objects BI 4.2,4.1/XIR3/XIR2, Universe Designer, IDT, Info View, BI Launch pad, Web Intelligence, Desktop Intelligence, Webi Rich Client, Import Wizard, Report Conversion Tool, Publication and CMC).
• Experienced in Install Configure Business Objects 4.2 on Windows 2012 Server.
• Proficient in Business Objects Reporting flavours in SAP Business Objects XI R2/R3/BI 4.2,4.1, (Universe Design, Web Intelligence, Publication, SAP Lumira and Xcelsius) for both SAP and Non - SAP sources.
• Proficient with integrating Business Objects with SAP BW.
• Proficient with OLAP universes including Creating Universe, configuring Single Sign On(SSO) authentication etc.
• Experience in Business Objects Administration.
• Proficient in LDAP, Windows AD Configuration.
• Experience in Migration Business Objects XIR3.1 to Business objects XI 4.2.
• Experience in creating users and user groups, restricted access of the users as needed using Central Management Console (CMC). Involved in managing users, groups, folders and published reports using Central Management Console.
• Extensively used Calculations, Cross - tab, Summary, Variables, Prompts and Sorted inputs, Sections, Alerts, Filters, Sorts, Query Prompts and Drill filters. Drill down/Drill up, OLAP, OLTP, Slice and Dice for creating Business objects reports.
• Experience in dealing with various databases like Oracle, Sybase, SQL Server.
• Dealt with various LOOPS and TRAPS using Aliases and Contexts
• Scheduled and distributed Web Intelligence using Central Management Console (CMC).
• Excellent skills in performing Integration Testing & User Acceptance Testing, Document preparation, User training and End User Support.
• Have good communication skills, interpersonal relations, hardworking and result oriented as an individual and in a team.
• Life Cycle Implementation End to End in Business Objects.
• Business Requirement Analytical skills.
• Client interaction.
• Conversation of functional document to technical.
• Documentation and Training.
• Webi Reports, Universe, SAP Lumira and Xcelsius Dashboard designing and CMC.
• Color coding like Alerter, report features like Outline, break, sections, tracking, local/global filter, static/dynamic filter, hyperlink, slice and dice, formula, variable, drill synchronization from multiple data provider, Graphs etc.
• Universe/IDT, retrieving the data from various data source. Defining Connections, Schema Designing, Class and object design as per user requirement. Use joins, Cardinalities Checking, Resolving Loops by applying Context and alias, Checking Integrity of universe. Define Cascading Lov’s and use @ Functions as per requirements. Set the user/row/object level securities and restriction in universe, Linked with other universes. Use hierarchies for Drill down purpose.
• Tuning/optimization on performance issue.
• Working experience in Full Client and Thin Client.
• Modelling, Design and Development, Reporting, Performance Tuning and Transportation of objects and Extraction of data.
• Technically good in modelling - Designed and developed Info objects, Info Cubes, Multi provider, DSO Objects, and Transformations.
• Involved in changing the Existing data model of an Info cube, DSO, Open hub destination and Infospoke by adding new Characteristics and Key figures.
• Working experience in development and production support project.
• Good Knowledge in new technologies of DESIGN STUDIO, HANA, QlikView, Tableau etc.

TECHNICAL SKILLS

OLAP Tools: SAP Business objects ( BO XIR2, BO XIR3), SAP BOBI 4.2, Webi, Deski and Xcelsius 2008, SAP Dashboards, SAP Lumira Discovery, SAP Design Studio, Crystal Reports,BEX Queries, SAP BW/ERP,SAP BO Integration Kit.

ETL Tools: IBM Data staging, Informatica

Operating Systems: Ms-Windows, Unix, WIN NT, windows 2012

Data Bases: Oracle 10g, SQLServer, SYBASE, MySQL

Languages: SQL/PLSQL, UNIX, ABAP

Workflow tools: MS-Excel, MS-PowerPoint, MS-Word

ERP: SAP BW 7.0, SAP R/3 ECC 6.0

Web Application Servers: Tomcat 5.5& 7.5

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/BO Consultant

Responsibilities:

• Interacted with Business Users/Clients for gather the requirements, Business logics and subsequently translate it into Functional specifications for universe and report development.
• Extensively used calculations, variables, Alters, Filters, Conditions, Breaks, Sorting, Drill down, Slice and Dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Set the user/row/object level securities and restriction in universe, Linked with other universes. Use hierarchies for Drill down purpose.
• Develop BW queries using BEX query designer
• Creation of BI Queries (BEx) and Universes
• Designed report documentation and get approval from Business Managers for the reports layout and developed Business Objects reports as per the Business requirements.
• Creating jobs for promotions.
• Involved Creating and testing the test cases.
• Worked extensively with major functionality of BO like Sections, Breaks, Alerter, Filters, Sorts, Drill filters, Prompts, linked reports different types of report layouts.

Confidential

SAP BO Consultant-Administrator

Environment: SAP Business Objects Enterprise 3.1,4.1,4.2, Business Objects Designer, Webi Rich Client, Desktop Intelligence, Web Intelligence, Information design tool(IDT),Upgrade Management Tool(UMT), SAP LUMIRA, Report Conversion Tool(RCT),QAAWS, Windows XP/2003/2000, Tomcat Server, SYBASE & Oracle 11g

Responsibilities:

• Installation and testing of BI4.2 SP6 application.
• Migration of Reports, Universe, Folders, Categories and Connections from development to Production by using BIAR file.
• Assigning user security and providing report access rights to users.
• House Keeping activities on application and servers.
• Tracing and Troubleshooting the BOE.
• Splitting the Adaptive Processing Server SAP BI Platform 4.x
• Monitoring BO servers running with optimal performance.
• Monitoring all the related CMS, Audit and Reporting Database services.
• Monitoring the size of the below Business objects Installation Folders etc..,Logging, Data and FileStore.
• Working on security Management Model for BOXIR3.
• Worked on RCT for the conversion of Deski to Webi Reports.
• Created data visualization application for business users using Lumira.
• Involved in creating story boards using SAP Lumira Discovery.
• Creating and publishing stories in Lumira server BI launch pad.
• MIS reports preparing to sales.
• Collated, analyzed and documented company’s monthly, quarterly and half yearly performance sales details.
• Developed and Created Various Report using SAP BI 4.x for various department across the organization utilizing Business explorer, Webi, MS Excel and SAP Lumira.
• Scheduling the reports to different business users in at different intervals of time.
• Making Adhoc changes in Universes and reports according to user requirement.
• Created reports in Lumira to handle huge volume of data in real time for analysis. Developed dashboard reports using SAP Lumira to include all the required KPI's.
• In house installation and configuration of BOXI R3 and server and testing, load balancing.
• Modifying the existing Universes, adding new objects, editing joins, mapping the existing objects.
• Monitoring reports, system and event trigger files (ETL).
• Experience on modify the universe as per users requirement.
• Created custom hierarchies for using scope of Analysis and drill down options.
• Migrated several reports and universes from SAP BO 3.1 to SAP BI 4.2 using Upgrade Management Tool (UMT) and converted DeskI to WebI reports using Report Conversion tool(RCT).
• Install and configured SAP BI 4.2 Sp6 Client tools in users system, provided appropriate rights and configured ODBC connection in users systems.
• Generated Ad-hoc reports using Web-Intelligence and Web-Rich Client reporting tools.
• Implemented Row-level and Object-level security using Designer tool.
• Configured SMTP on server to allow users to schedule report and send them to other resources.
• Expert at using Information Design Tool IDT and Universe Design Tool UDT.
• Expert in converting UNV format universes to UNX using Information Design Tool.
• Providing development and production technical support for the project.
• Auditing the user’s roles and access on Quarterly basis.
• Scheduling and Publishing reports onto webi to different destinations via file location and FTP.
• Improved the Performance of the reports by removing any additional filters or alerter on the report.
• Importing the groups and users from Windows Active Directory into Business Objects and granting the users and groups with appropriate rights through CMC.
• Implemented LDAP Configuration of SAP Business Objects Enterprise to get Single Sign On(SSO) for the Business Users.
• Development and Scheduling of webi reports/Publications based on the requirement and monitoring the daily scheduled jobs

Confidential

SAP BW/BO Consultant

Environment: SAP Business Objects Enterprise XIR2,XIR3.1,4.2, Business Objects Designer, Webi Rich Client, Desktop Intelligence, Windows XP/2003/2000, Tomcat Server, Solaris, Oracle 11g, SAP BW 7.0,SAP ECC 6.0

Responsibilities:

• Interacted with Business Users/Clients for gather the requirements, Business logics and subsequently translate it into Functional specifications for universe and report development.
• Extensively used calculations, variables, Alters, Filters, Conditions, Breaks, Sorting, Drill down, Slice and Dice, Master/Detail, Cross Tab, Charts and alerts for creating Business Objects Reports.
• Set the user/row/object level securities and restriction in universe, Linked with other universes. Use hierarchies for Drill down purpose.
• Creation of BI Queries (BEx) and Universes
• Designed report documentation and get approval from Business Managers for the reports layout and developed Business Objects reports as per the Business requirements.
• Migrated Universe, reports and users from the BOXI R2 version to XI R3.1, 4.1 using the import wizard.
• Worked extensively with major functionality of BO like Breaks, Alerter, Filters, Sorts, Drill filters, Prompts, linked reports, joins contexts, loops, maps, different types of report layouts.
• Monitoring BO server running with optimal performance.
• Experience on Central Management Console (CMC) to create folders, users and groups, events, customize the access levels and managed the access privileges and scheduled the reports.
• Experience on modify the universe as per users requirement.
• Worked extensively in upgrading Universes and reports from BOXI 3.1 to BOXI 4.0.
• Migrated several reports and universes from SAP BO 3.1 to SAP BI 4.1 using Upgrade Management Tool (UMT) and converted DeskI to WebI reports using Report Conversion tool.
• Install and configured BO 3.1 Client tools in users system, provided appropriate rights and configured ODBC connection in users systems.
• Generated Ad-hoc reports using Web-Intelligence and Web-Rich Client reporting tools.
• Implemented Row-level and Object-level security using Designer tool.
• Monitoring and scheduling the reports on a daily, weekly and monthly basis, scheduled reports based on file events.
• Troubleshooting on Uinx and windows servers using trace commands.
• Deployment of Universes and Webi Intelligent reports and Desktop Intelligence reports.
• Development and Scheduling of webi reports/Publications based on the requirement and monitoring the daily scheduled jobs
• Extensively used the multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Designing Universes, retrieving the data from various data source. Defining Connections, Schema Designing, Class and object design as per user requirement. Use joins, Cardinalities Checking, Resolving Loops by applying Context and alias, Checking Integrity of universe. Define Cascading LOV’s and use @ Functions as per requirements. Set the user/row/object level securities and restriction in universe, Linked with other universes. Use hierarchies for Drill down purpose
• Configured the SMTP settings to send the reports to users email after scheduling the reports in Crystal Enterprise Server and Business Object Server.
• Implemented Custom Access Levels to use of efficiently the security methods.
• Implemented Back procedure using Import Wizard to BIAR files and also Schema backups from Database.
• Responsible to enhance the universes on Prod and support to enhance the application and gathering the requirements based on the changes.
• Changing existing design and meeting the end user requirements.
• Testing the reports and report performance in development and production environments and migrating the reports to production once UAT has done.
• Experience in Project design document, Technical Document.
• Handling day to day issues on BO Universes or Reports in service management tool by following client process and achieving SLA.
• Created complex webi reports with multiple queries, custom sql, using complex functions, merging dimensions at report level, drill down, drill up, drill across, complex filters etc
• Experience in SAP BO Admin CMC Creating user and Group ids, Authentication rules.