SUMMARY

• 8+ years of strong Data Warehousing experience in SAP Business Objects 4.1/4.0/3.x, X1R3, XIR2/6.x/5.x (Information Design Tool, BI Launchpad, Desktop Intelligence, Business Objects Developer Suite, Web Intelligence).
• Expertise in planning, designing, developing, distributing and maintaining Universes.
• Using Designer developed SAP Business Object Universes on top of Star and Snowflake schema data models.
• Extensively used Web Intelligence, BI Launchpad for querying, reporting and analysis tasks.
• Created multiple reports using Analysis for Microsoft Excel
• Involved with a team in creating Dashboards using visual analytics, themes to meet corporate standards using XCelsius.
• Created multiple Crystal and Web Intelligence reports and transformed into a single dashboard using Xcelsius.
• Generated Xcelsius Dashboards using SAP Business Objects Live Office and Query as a Web Service (QaaS) as Data Sources.
• Used the Bex Query Designer and the Bex Analyzer to run and modify the existing Bex queries
• Used Broadcast Agent for scheduling and batch processing of Business Objects and Web intelligence
• Strong knowledge in building queries on different types of Data Providers Universes, Personal data files, Stored Procedures, Free - hand SQL and Web connect.
• Very good experience in both developing as well as testing of OLTP Business intelligence applications.
• Proficient in migration of Business Objects 3.1 to Business Objects4.0 and migration of the Content (User, Groups, Universes and Reports etc) using Import Wizard.
• Proficient in working on development environment in different RDBMS (Oracle, SQL Server, DB2
• Expert in working with databases - Oracle10g/9i/8.x, MS SQL Server, Sybase, MS Access.
• Excellent Performance tuning technique from Business Objects and Database perspective.
• Implemented row level and object level security using the Business objects tool.
• Expertise in Designing FACT Tables, Dimension Tables, Summary Tables.
• Experience in Import wizard & publisher for migrating reports & universes.
• Worked with complex scheduling features in CMC including calendars and event based scheduling.
• Strong experience in SAP Business Objects Administration/ CMC to create and manage the Users and Groups, applications, Security and rights to the Users.
• Strong knowledge in using aggregate awareness functions, developing complex reports using multiple data providers in Business Objects.
• Expertise in using functions like @aggregate aware, @prompt, @select and creating custom hierarchies.
• Experience in creating complex filters such as pre-defined conditions, report filters, prompts and drill filters.

TECHNICAL SKILLS

OLAP/DSS Tools: Business Objects BI 4.1/4.0/XI 3.1/R2/R1, SDK, Crystal Reports, Central Management Console, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Report Conversion Tool, Crystal Xcelsius 2008, Query As A Web Service (QaaWS), Deployment Tool, Data Integrator

RDBMS: Oracle 11g/10g/9.x/8.x/7.x/5.x, DB2/400, SQL Server 2000/2005, MS Access 2000

Languages: VB Script, HTML, JSP, PL/SQL, SQL, Shell Scripting

Utility Tools: Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader

Operating System: MS-DOS, Windows 2003/XP/NT/2000/98/95, Unix, HP- Unix, Sun Solaris

Web Technologies: VBScript, HTML 3.2/4.0, IIS 4.0/5.0

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr Business Objects Developer

Responsibilities:

• Installed the Business Objects 4.1 Client Tools (Information Design Tool, Web Intelligence, Xcelsius)
• Developed 150+ complex web intelligence reports for the financial project using BO 4.1 Web Intelligence tool based on the BICS connection and SAP Bex queries as the data source.
• Created the BICS connections to the multiproviders using the Information Design Tool.
• Published the web intelligence reports to the BI Launchpad and scheduled them within a specific period
• Created link between two web intelligence reports using the Opendocument functionality to drill down from one report to another.
• Worked with the Data services team and the BW team to implement the event based scheduling and scheduled the reports based on the dependency of the events.
• Worked extensively with the major functionality of SAP BO like Breaks, Sections, Ranks, Block Filters, Report Filters, Input Controls, Alerter, Variables, and Formulas.
• Created different types of charts and graphs for analysis of data and formatted their properties such as font, color etc.
• Synchronized various queries in Web Intelligence using Merge dimension according to the user specifications.
• Inserted free standing cells and used functions and prompts to change the title of the report dynamically according to the value selected in the LOV for easier analysis of data.
• Created filters such as Query prompt and sorted data in the WebI reports according the user specifications using sorts.
• Assist in ensuring all existing SAP BO reports work appropriately during the SAP patches upgrade.
• Developed reports using Analysis for Microsoft Excel and published them to the BI Launchpad.
• Created the material for power users for Web Intelligence and Analysis for Microsoft Excel.
• Interacted with Co Developers, Business Analysts and Business Users in gathering the requirements for the Report Requests.
• Linked the web intelligence report to different websites using the hyperlink option in the BI Launchpad.
• Provided support for the business users for the Web Intelligence reports developed.
• Created documentation for users to access and analyze data using SAP Business Objects.
• Created copies of the existing Bex queries and made minor changes in the existing Bex query such as restricting the fields and defining the type of the Bex variables
• Ran multiple Bex queries using Query Designer and Analyzer to compare the data between the Bex query output and the Web Intelligence.
• Changed the web intelligence ps in the BI Launchpad accordingly to create the document link on the existing WebI report
• Created different types of reports such as Master/Detail, Cross Tab using Bex query as a main data provider.
• Performed unit testing, system testing and user acceptance test (UAT) for the developed WebI reports.
• Interacted with the Business Users to resolve the existing issues and modified the reports as per their requirement.
• Created a sample dashboard with the SAP BW Netweaver connection to the Bex query.

Environment: Business Objects BI 4.1, SAP BW 7.3,ECC 6.0, Crystal Enterprise XI/X, Teradata, Web Intelligence,Crystal Reports, Dashboards, Advance Analysis Edition for office, Oracle 11g Toad, SQL Server2000, Oracle 9i, SQL, PL/SQL Windows 2000/XP

Confidential, Nashville, TN

Business Objects Developer

Responsibilities:

• Worked with the Business Objects 4.0 including BI Launchpad, Dashboards 4.0, Information Design Tool, and WEBI Rich Client.
• Installed SAP Business Objects 4.0 client tools (WEBI rich client, Information design tool, upgrade management tool).
• Installed Crystal Reports 9 and Crystal reports 2011.
• Used Crystal Management Console for scheduling the reports which are saved in different format like Excel and PDF Format and then e-mailed to the Users.
• Migrated crystal reports from Crystal Reports 9 to Crystal Reports 2011 and validated them.
• Published the migrated crystal reports to the BI Launchpad.
• Scheduling the migrated crystal reports using BI Launchpad and emailed to the end users.
• Migrated all the reports fromBOXIR2 toSAP BO3.1 and SAP BO 4.0 using Import Wizard tool.
• Developed the universes using the Information Design Tool of BO 4.0 and published them.
• Created universes based on multiple data sources in the Information Design Tool.
• Created and maintained Secured, Shared and Personal connections according to the Security level required.
• Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Created various classes and objects with different object qualifications such as measure, dimension and detail objects.
• Created complex reports using cascading prompts, variables and calculation context.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies.
• Worked with DBA for creating the aggregate tables to improve the performance of the SQL transactions and used Aggregate Awareness (@Aggregate Aware) in select statements to run a query against the aggregate tables in the database instead of base tables.
• Converted the universes from BO 3.1 to BO 4.0 and published them.
• Generated SAP Business Objects Reports involving complex Queries, SubQueries, Unions and Intersection.
• Created the Web Intelligence reports using the BI Launchpad and WEBI Rich Client using Universes as the data providers.
• Used various functionalities like Breaks, Sections, Sorts, Alerters, Variables, and Formulas in creation of Web Intelligence reports.
• Used @ functions like @aggregate aware, @prompt and implemented custom hierarchies for Multi-dimensional Analysis.
• Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements
• Created Complex Reports such as linking of Two Reports, Drill Down and Drill Up.
• Used the filters such as the Query filters, prompts and the report filters in the WEBI reports.
• Created reports involving complex queries, union, intersections and subqueries.
• Created different types of charts such as pie chart for easier analysis of the data.
• Generated complex Dashboards using the crystal Xcelsius.
• Provided support for the IT team members for using the BI Launchpad and Universe development in the Information Design Tool.
• Implemented the row-level and the object-level security as per the user requirement.
• Created Users and Groups and assigned access levels to BO content as well as applications.

Environment: Business Objects 4.0, BW 7.3, Web Rich Client, Crystal Reports, Xcelsius 2008, Advance Analysis for Office, Oracle 10g, SQL Server 2005. Toad, SQL Server2000, Oracle 9i, SQL, PL/SQL Windows 2000/XP

Confidential, Pleasanton, CA

Business Objects Developer

Responsibilities:

• Interacted with Business Users to gather the Requirements and Business logics.
• Translated Business Logics to Technical Specification Document.
• Was Responsible for preparing the User Requirement Specifications, Design Documents, Technical Specifications and getting Sign-Off from the Stake holders.
• Created Universes by defining connections and retrieving data from database.
• Created New Classes and User Objects in designing the universes.
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Designed aggregated tables on the most frequently queried data for Monthly & Yearly based reports.
• Extensively used Calculations, Variables for creating Business Objects reports.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Changed the universe parameter settings to optimize the performance of universe.
• Tuned Universes for Report level performance.
• Tuned SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Created Reports using Web Intelligence Rich Client, used multiple sources to create reports, Combined Queries,
• Analyzed the needs of the client and created summarized reporting tables and developed complex reports.
• Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO

Environment: Business Objects XI R3 SP3,Rational Rose, Oracle 11g, Oracle Warehouse Builder.

Confidential, VA

Business Objects Developer

Responsibilities:

• Configured Web Intelligence using Configuration tool.
• Responsible for setting up the Users/Groups, database connections, assigning privileges to the users using Supervisor.
• Assigned Broadcast Agent to various groups using WebI Admin Console.
• Defined categories of documents for different level of groups.
• Involved in gathering functional requirements from the business users.
• Design and Development of Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Generation of Xcelsius Dashboards using SAP Business Objects Live Office and Query as a Web Service as Data Sources.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Created derived tables to reduce the complexity of the universes and also created prompts to force the users to restrict the data in the process of building the universes.
• Involved in the troubleshooting of universe schema with Loops, Chasm and Fan traps and Cardinality problems by creating Aliases and Contexts as required.
• Exported and Imported Universes to and from CMS.
• Created custom List of Values (LOVs) for better understanding of prompts by the end user.
• Created Adhoc and Canned reports and fine tuning them for faster execution.
• Created custom Hierarchies to support drill down functionality for in depth analysis.
• Extensively used Calculations, Variables, Breaks, Slice and Dice and Alerts for creating Business Objects reports.
• Linked Universes to share the common components using Kernel and Component approach.
• Generated complex reports using the various data Providers like Universes, Personal Data Files and Free Hand SQL.
• Created some of the reports using Crystal reports and created Xcelsius dashboards.
• Used Crystal Reports for sales tracking and billing purposes.
• Involved in day-to-day Business Objects Server maintenance.
• Optimized systems with load balancing with distributing components on different servers.
• Created users/groups and defined privileges using Central Management Console. Migrating Business Objects 6.5 version reports to new version XIR2 and X1R3.
• Converted the existing full client reports to WebI reports using Report Conversion Tool.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment.
• Actively involved in giving demos to the users and prospective users about the functionality available in Business Objects.

Environment: Business Objects XIR2/XI R3, Web Rich Client, Crystal Xcelsius 2008, UDT, Oracle 10g, SQL Server 2005, Toad and Web logic 9.2.

Confidential

BO Consultant

Responsibilities:

• Gathering system requirements from Business Owners and Business Users.
• Interacted with Business Users to understand their specific Business needs for reporting for their daily business.
• Organized and conducted meetings with users both one to one and in groups are Risk Management, Loan Admin and Accounting.
• Understanding the banking domain with capital market.
• Understanding existing system and documented all the reports and Universes.
• Defined Business Views for crystal reports development.
• Created reports for different departments like Risk Management, Loan Admin and Accounting.
• Designed crystal reports with dynamic content & Custom UI.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Scheduled crystal reports and Implemented dynamic cascading prompts.
• Installed and configured BCA for publishing the reports through emails and worked on BCA console.
• Created Analytics on top of Metrics for the Performance Manager.
• Involved in creating dashboards for management and able to perform drill down action to view more details on the report.
• Maintained Supervisor for administrative privileges with user accounts and access.
• Worked with team closely with Functional Architect, DBA and Analysts.
• Understanding Investors of all types have the opportunity to participate in financial strategies that can strengthen the general economy as well create financial security.
• Provided guidelines of Job scheduling process integrating Web Administrator and job scheduling process with job dependencies.
• Worked and maintained three systems: Development, UAT (QA) and Mock (Production).

Environment: Business Objects XI R2,Crystal Report, Import Wizard, Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Toad, SQL Server2000, Oracle 9i, SQL, PL/SQL Windows 2000/XP