SUMMARY:

• Over 9+ years of SAP Business Objects BI 4.2,4.1,4.0/XIR3/XIR2, Universe Designer, Info View, BI Launch pad, Web Intelligence, Desktop Intelligence, Webi Rich Client, Import Wizard, Report Conversion Tool, CMC, Xcelsius, LCM, Crystal Reports).
• Experienced in Install Configure Business Objects 4.0 on Windows 2008 Server.
• Proficient in Business Objects Reporting flavors in SAP Business Objects XI R2/R3/BI 4.2,4.1, 4.0 (Universe Design, Web Intelligent, Crystal Reports, 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, SAP Authentication Integration.
• Experience in Integrating Business Objects with SAP BI and migration to Business objects XI 4.0.
• 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, Form 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.
• Extensive experience in creating reports with Charts(bar chart, Pie chart...etc.), cross tabs and sub reports.
• Excellent knowledge and experience in BO data integrator and BO report design.
• Comprehensive experience in developing stored procedures and database triggers.
• Exceptional experience in dealing with various databases like Oracle, DB2, Teradata SQL Server.
• Worked with Crystal Report 2008 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Dealt with various LOOPS and TRAPS using Aliases and Contexts.
• Scheduled and distributed Web Intelligence, Crystal reports 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.

TECHNICAL SKILLS:

ERP: BI 7.0,SAP BW 3.5,SAP BOXI 3.1,4.0,4.1,4.2ECC 6.0,R/3 4.7

Reporting Tools: BEx Query Designer, BEx Analyzer, Web Application Designer, SAP BO BI 4.1/4.0, BO XI 3.X, Web Intelligence, Design Studio, SAP Lumira 1.30, Crystal Reports 2013, Xcelsius / Dashboards, Desktop Intelligence, Live Office, QaaWS, CMC, Infoview, BI Launchpad, CCM, IDT & UDT

Data Warehousing: SAP BOBJ, SAP BW 7.0, 7.4, SAP IP, HANA (3.0B, 3.5B, SAP Netweaver 2004s/BI7.0)

Information Delivery: SAP Bex, Crystal Reports 2008, Web Intelligence Designer, and Universe designer, Business Objects Explorer, Xcelsius and Voyager

Teradata, Oracle, SQL, DB2 and MS: Access

Operating Systems: Microsoft Windows XP/Server 2003/2008/Linux, Unix

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. BO consultant/ SAP Lumira Developer

Responsibilities:

• Gathered user requirements and Involved in developing use cases with users and technical team.
• Involved in weekly meeting with users on BI 4.2 development
• Created Business Objects Repository while building Business Objects solution and Created and tested classes and objects to organize the Universe.
• Worked on Suppressing, Grand totals, Running totals, Filters, Bar Graphs, Line Graphs, Static and Dynamic Parameters, Multiple parameters, Time totals.
• Worked with Java scripts and Cascading Style Sheets for redesigning the SAP Design Studio components color and font size as per the client's design team specifications.
• Created data visualization application for business users using Lumira.
• Involved in creating story boards using SAP Lumira.
• Expertise in working on design studio to create dashboards, for viewing on mobile devices SAP LUMIRA
• Creating and publishing stories in Lumira server, cloud and BI launch pad
• Adopt and follow SAP's roadmap on various products like Design Studio, Predictive Analytics & SAP Lumira.
• 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
• Designed and created the Business Objects Universes.
• Created contexts and aliases for resolving loops in the Universes.
• Implemented security features of Business Objects like row level, object level and report level security.
• Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Executes full life cycle implementations of complex reports, BO projects, and ad-hoc analysis & reporting solutions.
• Created complex Reports that leverage the full feature set of Business Objects to deliver information to meet user requirements with a focus on ease of use and intuitive navigation.
• Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements
• Changed the universe parameter settings to optimize the performance of universe.
• Worked with business users and technology group in gathering requirements for developing reports and data analysis.

Environment: SAP BI 4.2/4.1/4.0, XI3.1 SP6, Designer, Desktop Intelligence, Xcelsius 2008 SP3, Dashboard, SAP Lumira 1.30, Oracle 11g/10g, Teradata v13.0, SAP BW/BI 7.0, SQL Server 2005, and Windows 7.

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Involved in Full life cycle design and development of Business Objects Enterprise Applications.
• Gathered report requirements from business end users/clients, Business Analyst and SME’s in retrieving business information from data warehouse and resolved any SQL query issues.
• 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.
• Developed and Created Various Report using SAP BI 4.x for various department across the organization utilizing Business explorer, Webi, Xcelsius, Crystal Report, MS Excel and SAP Lumira
• 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.
• Worked with Java for Report Integration with Single sign on method
• Created parameterized Crystal reports and customized existing reports for presentations using Summary reports, Detail reports, Cross-Tab reports and Sub-reports.
• Scheduling/ Publishing the reports on daily and weekly basis to the users Inbox.
• Created alerts, breaks, filters and ranks in the report using Webi
• Worked with SAP HANA group in using HANA modeler.
• Integrated HANA with Business Objects using BO Data Services (BODS).
• Provided extensive support for the users on application usage and trained users in the Functionality of the software.
• Efficiently worked as a BO support for solving various BO user report, administration issues etc.
• Worked extensively in upgrading Universes and reports from BOXI 3.1 to BOXI 4.0.
• Identified the Metrics and sub metrics, Key performance indicators (KPI’s) for Dashboard development.
• Exported the reports and dashboards into centralized database to access them for daily business analysis.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with dashboard manager.
• Managed Users, Groups and their access privileges on the documents.
• Created Stored Procedures while generating the reports in CMC.

Environment: SAP Business Objects XI 4.1/4.0/3.1 SP6, SAP Business Objects Data Services4.1, Crystal Reports 2013, Designer, Desktop Intelligence, Xcelsius 2008 SP3,SAP HANA, Dashboard, SAP Lumira, Oracle 11g/10g, SAP BW/BI 7.0, SQL Server 2005, Teradata, Windows 7.

Confidential, Memphis, TN

BO Developer

Responsibilities:

• Worked on SAP BOBJ XI 3.1 SP5 report migration from SAP BI 4.0
• Gathering requirement for the converting the SAP BI query and design universe, designing Web-I report
• Design and developed Web-I query and Web-I Reports from standard and custom universe
• Enhanced the standard universe for the Web-I reporting
• SAP BI COPA, FICO and SD reports from query designer were converted into SAP BO report using Web-I
• Web-I Reporting design and scheduling for designed and developed with Customer and Material Hierarchy
• Web-I reporting design and developed for profitability analysis, and financial analysis
• Generated Web-I Reports using the Universe as the main Data provider and also using the personal data files provided by the users
• Designed Universes for Financial billing system, Sales Order processing and Sales analysis by location, Sales Analysis by country reports
• Performance tuning is done on Web-I reports that developed using Info View Web-I.
• Created Dashboard for profit analysis using Xcelsius.
• Backup plan for execution created for the client development and production system
• Business user Training and Best practice developed for the client BOBJ XI 3.1/4.1 and BI Universe, Java Info View.
• Involved in Full Life Cycle implementation of SAP BI for FI/CO and SD modules
• Extensively worked on Financial Accounting Consolidation(AP,AR) and Profit center Accounting(PCA)
• Created monthly and Quarterly Breakdowns, Profit & Loss Reports
• Extracted data from SAP ECC using BC, Generic extractors and also from Flat Files
• Created Data Sources via RSO2 in ECC 6.0 for master and transactional data
• Created Delivery, Billing DSO objects and used DSO objects to update Custom Info Cubes
• Involved in Customizing and configuring Info Objects and applied Transformation
• Actively and regularly involved in Load Monitoring of daily, weekly, and monthly, data loads using Process Chains
• Data modeling and managing master data and transactional data efficiently
• Involved in support role of maintaining BI system and troubleshoot the user problems and Debugging Extractors / Handling issues
• Worked on BEX Analyzer and BEX Browser for creating queries with conditions, exceptions, calculated key figures, variables and conversion to WAD template.

Environment: SAP BW7.3, ECC 6.0, BO XI 3.1/4.1, BEx Analyzer, Crystal Reports, Live Office, Xcelsius, Design Studio, WebI Reports, Oracle 10g, Teradata 8.5, MySQL, Windows 2007.

Confidential, Houston, TX

BO Consultant

Responsibilities:

• Used BEX Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI Info Providers to Generate Reports
• SAP BOBJ integration implementation in Development App Server with BI 7.0
• Administration and security design for the BI BO users and super users
• Configured SSO authentication for users and super user in development and Production App server
• Design and developed query based and Info Provider based Universe and Web-I Reports
• Reporting designed and developed using BI query designer
• SAP BI Customer Hierarchy and Material Hierarchy developed using Flat file from legacy system
• Worked with Business objects R 3.1 SP5 and up gradation to BOBJ 4.0
• Web-I Reporting design and scheduling for designed and developed with Customer and Material Hierarchy
• Web-I reporting design and developed with customer and Material hierarchy
• Actual and Plan reports developed using web-I and QAAWS
• Generated Web-I Reports using the Universe as the main Data provider and also using the personal data files provided by the users. Designed Universes for Financial billing system, Order processing and Supply chain planning
• Build the New universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections
• Developed dashboards using Xcelsius 2008 and published in intranet portal
• Live office connection and Query as a Web Service implementation completed in Development Server and Production server completed
• Xcelsius 2008 installed in client system as well as Develop and Production App server
• Universe Query and Web-I Query used to develop excel file data to create custom Xcelsius dashboard
• Performance testing developed in all the application servers
• Backup plan for execution created for the client development and production system
• Involved in Full Life Cycle Implementation followed by an up-gradation of clients present SAP BW 3.5 to BI 7.0 Net Weaver 2004s and Performance analysis in CRM and SD modules.
• Analysis of Reporting Requirements and Translation of these requirements into Multi-Dimensional Data Models using Star-Schema and Extended Star-Schema Data Modeling Techniques, with an emphasis on actual implementation in BI and SDLC.
• Developed DSO objects to load Sales Order Data from the Data Source. Loaded Transactional Data into PSA and updated Data from PSA to DSO and Activated DSO Data for Reporting and Analysis
• Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology
• Extensively documented BI Reporting and Data Requirements
• Extensively involved in Data Extraction from Non-SAP and SAP Systems
• Handled Performance Tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes
• Responsible for customizing and activating the Business Content Objects and loading the data into DSO and Info Cubes
• Uploaded Master Data and Transactional Data to BI System.

Environment: SAP BW 7.0, ECC 6.0, BI 4.0, 3.0, BEx Analyzer, Crystal Reports, Live Office, Xcelsius, WebI Reports, Oracle 11g.

Confidential, Cleveland, OH

BO Administrator

Responsibilities:

• Installed and Configured Business Objects BOXI 3.1, BI4.0 Completed Suite On Windows/ Linux/Unix Servers.
• Configured Windows AD and SAP BW SSO for Business Objects BI4.0
• Migrated BOXI 3.1 Application to BI 4 using Upgrade Management tool.
• Configured Clustered for Test and Production Servers.
• Installed and Configured SAP Integration Kit on Windows 2003.
• Integrated Business Objects with SAP BW/BI with Portal Integration kit.
• Setup the AD Authentication on Windows servers.
• Created Custom Access level as per business requirements.
• Create Probes to Monitor BI4 Services.
• Installed Configured Mobile in BOXI 3.1 and BI4.0
• Configured Adaptive Processing Service, Adaptive Job Services, DSL bridge Service etc.
• Extensively worked with Upgrade Management tool, promotion Management tools, version Management.
• Migrated universe, reports, Dashboards from BOXI3.1 and BI4.0
• Converted Deski reports to Webi Reports using Report conversion Tool.
• Maintained Users and Groups Security by creating AD groups and attaching it the folders on the Enterprise.
• Tested and implemented SMTP email and FTP scheduling feature in Business Objects.
• Responsible to make sure Email, FTP, Business Objects Inbox and Unmanaged Disk options of scheduling are always up and running.
• Designed universe based on Data Federator concept which connects data from multiple data sources.
• Created reports based on the Data federator Universe according the Business Requirements.
• Having significant knowledge working with SAP BW Info Cubes, Multi Cubes, and Info Objects.
• Involved in creation of Universe using BW cubes and created reports using the BW Universe.
• Created Reports using SAP BI cubes and customized reports as per business requirements.
• Created classes and objects and logically grouped them together and defined business names for the classes and objects
• Configured Voyager connections in CMC and developed voyager workspaces in Info view using cube as data source.
• Created Webi Reports Using SAP BI cubes and saved in R/3 Portal.
• Supported Business Objects Complete suite 24/7 and worked extensively with Remedy Ticketing Tool.

Environment: Business Objects XI 3.1,4.0, Web Intelligence BOXI R2, XI R3, XI 4.0, Oracle 10g, SQL Server 2005, Windows, UNIX, Crystal Reports, Data Integrator, Data Federator QaaWS, Crystal XCelsius, Live Office,Data Federator, Life Cycle Manager, BMC Remedy.

Confidential, Houston, TX

BO Administrator

Responsibilities:

• Installed and Configured Business Objects XIR2 SP4 complete suit on UNIX AIX.5.3
• Designed multi server architecture for Business Objects XI R2 Enterprise for more than 10000 users.
• Clustered Test and Production Servers.
• Configured the environments for development Test and production.
• Installed and Configured Xcelcius Live Office on UNIX AIX 5.3 Servers.
• Installed and Configured SAP Integration Kit on UNIX AIX 5.3
• Integrated Business Objects with SAP BW/BI with Portal Integration kit to publish the reports onto the Enterprise using BW/R3 portal.
• Deployed Business Objects with Tomcat/Apache on UNIX AIX 5.3 servers.
• Setup the LDAP Authentication on UNIX AIX 5.3servers.
• Configured Java Info view Single Sign on (SSO) authentication using Site Minder.
• Maintained Users and Groups Security by creating LDAP groups and attaching it the folders on the Enterprise.
• Tested and implemented SMTP email and FTP scheduling feature in Business Objects
• Responsible to make sure Email, FTP, and Unmanaged Disk options of scheduling are always up and running.
• Performed Performance tuning for all the servers in CMC.
• Configured Voyager connections in CMC and developed voyager workspaces in Info view using cube as data source.
• Migrated Universes and reports from XIR2 Windows to XIR2 UNIX using Import Wizard tool
• Maintain the repositories for different environments like DEV, QA and PROD
• Regularly synchronized the QA, DEV environments with Production reports.
• Responsible to support the issues with reports on the crystal enterprise environments ( Development, UAT, Test and Production )
• Involved in Setting up Performance on Tomcat.
• Strong knowledge with Data Warehouse Concepts.
• Created views SQL Scripts and store Procedure using oracle PL/SQL to feed the data base tables.
• Create ETL batch jobs, Work Flows, Data Flows and Data Stores Using Data Integrator.
• Created reusable object using Data Integrator for the Reports which they run on Daily Schedule.
• Developed dashboards and scoreboards for detailed analysis.
• Involved in creation of BOXI R3 Universe and Reports based on the requirements
• Having significant knowledge working with Info Cubes, Multi Cubes, and Info Objects.
• Involved in creation of Universe using BW cubes and created reports using the BW Universe.
• Created classes and objects and logically grouped them together and defined business names for the classes and objects
• Configured Voyager connections in CMC and developed voyager workspaces in Info view using cube as data source.
• Created Reports by accessing OLAP Cubes through the Voyager Connection.
• Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection
• Designed the Universe using data federator and connects to the multiple Sybase and Oracle.
• Created Webi Reports Using SAP BI cubes and saved in R/3 Portal.
• Used Crystal Xcelsius to convert report type data in Excel spreadsheets to more interactive Dashboard type reports.
• Designed and edit queries in QaaWS to create more interactive reports as per business requirements.
• Created reports using both DeskI and Web Intelligence based on the business requirements
• Used the Publishing wizard to export different document types as objects to different folders in CMC.

Environment: Business Objects 6.5.1 (Supervisor, Designer, Reporter), Web Intelligence BOXI R2, environment lo MSSQL server analysis 2000/2005, Sybase, Oracle 10g, PL/SQL, SQL Server 2005, UNIX AIX,SDK, Crystal Reports XI/9.0, Data Integrator, QaaWS, Crystal XCelsius, Live Office, SAP BW, Data Federator, SAP R3.

Confidential, Kansas City, MO

BO Developer

Responsibilities:

• Requirements gathering with project stakeholders and creating dataflow diagrams, functional specifications, technical specifications, security requirements and other related project management documents.
• Participated in project planning sessions with project managers, business analysts and team members to evaluate business requirements and outline the proposed solution
• Created Technical Specifications Documents based on requirements from stakeholders.
• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process.
• Created complex reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerter's and other features.
• Extensively used Crystal Xcelsius for creating Dashboards, Scorecards and reports.
• Imported/ Exported the Universes from/to repository to make them accessible to end-users.
• Worked with SAP BW Team to make sure that they are getting correct data from R/3 into BW cubes.
• Created OLAP Universes, WebI reports and Xcelsius dashboards using SAP BW cubes in GL, FI CO, MM and SD modules.
• Created Daily totals, ROI, Summary balance sheet, Inventory levels, Distribution summary dashboards using Xcelsius.
• Extensively used BEx Query Designer to build queries on BW InfoProviders and executed them using BEx Analyzer and Advanced Analysis.
• Created reports with Calculated Key Figures, Restricted Key Figures and Filters.
• Worked with Exceptions and Conditions as part of the BEx Query Reporting and have created various types of Variables.
• Migrated reports, Universe from Dev to Test and Production.
• Created Webi reports using advanced features like Formulas, Groups, Sub Reports, Hyperlinks, Alerts, Cross Tabs, Charts and Parameters.

Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0, T-SQL, Oracle PL/SQL, Info View, CMC Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0, T-SQL, Oracle PL/SQL, Info View, CMC

Confidential, Grand Rapids, MI

BO Developer

Responsibilities:

• As a Senior Report Developer, is responsible for developing complex reports in WebI after gathering the entire requirement from business users.
• Apart from development also involved in fixing report issues as part of Production Support.
• Created users using BO Supervisor. Assigned and maintained their privileges.
• Maintained repository by implementing Universe, Security and document domains successfully using best practices
• Gathered requirements by talking with different end users in HR department across different departments
• Conducted meetings with management and user community to understand there requirements and convert Business requirements into technical specifications.
• Designed Test cases for UAT of Reports for end users.
• Prepared user documentation for hand on training for en user community.
• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Use of Analyzer and Explorer to view reports from different prospect (Slice and Dice and Drill down).
• Resolved many production support issues that came up with the reports created by analysts.
• Created custom Audit Reports to effectively monitor and administer the User activity and Report/Universe usage.
• Understood the business in detail and helped, advised team in resolving many issues with the data.
• Scheduled the report instances for 120 users to run after the ETL load is complete and reports will be ready by beginning of every month in a shared folder.

Environment: Business Objects XI 3.1/ R2 (CMC, Designer, Web Intelligence, Crystal Reports XI, Crystal Xcelsius 2008, Info View), SQL Server Reporting Services, Teradata, Oracle 10g, Toad, Mercury Quality Center 9.0

Confidential, Houston, TX

BO Developer

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application.
• Involved in Installation and Configuration of all Components of Business Objects.
• Created users and groups and applied row level and objects level securities using Supervisor.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Used Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, and InfoView) to perform various tasks specific to every component.
• Created various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Used various functions like @Aggregate aware, @prompt, @select in designing the universe.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes using BO Xir2
• Used supervisor module for disabling / enabling access to documents and access to universes.
• Created standard full client reports and WebI reports.
• Created reports prototypes using Web Intelligence for user presentation.
• Extensively used Alerts and Filters in reports
• Coordinated and resolved Data Quality issues for smooth migration to production/maintenance of Reports to different environment within the organization.

Environment: Business Objects 6.5, Web Intelligence, Dashboard Manager, Performance Manager, Oracle 8i, SQL, MS Office, Windows 2000.