SUMMARY

• Over7years of Professional Experience in Data Warehousing as Business Intelligence Reporter using tools like Business Objects XI R3, XI R2, 6.x, 5.x, Crystal Reports, Crystal Xcelsius, Dashboards.
• Involved in gathering, analyzing and documenting Business requirements, functional requirements and data specifications for SAP Business Objects Universes and Reports.
• Experience in using Business Objects (BO) Tools like Business Objects XIR3/XIR2/6.x/5.x to build complex universes and reports on multiple databases and experience in development, testing and implementation.
• Experience using Oracle 8i/9i/10g, SQL Server 2000, 2005 and 2008. Experience in writing SQL Queries, PL/SQL, Stored Procedures, Functions, Triggers, Exception Handling, Cursor, Database Objects and Collections.
• Good experience in configuration of SAP Business Objects, Crystal reports and Xcelsius 2008 to connect SAP BI/BW.
• Sound knowledge in various data design models- Entity relationship(ER), Multi dimensional/star schema and extended star schema models.
• Experience in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
• Extensively used Business Objects reporting functionalities suchas Filters, Ranking, Alerts, Sections, Breaks, Sorts, Query prompts and Drill filters.
• Strong experience in Business Objects Administration/ CMC to create and manage the Users and Groups, applications, Security and rights to the Users.
• Experience in deploying the Business Objects XI3.1/XIR2 applications on the windows servers and also have strong knowledge in IIS5.0/6.0/7.0.
• Solid knowledge with Microsoft framework 2.0/3.0/3.5, visual studio 2005/2008 and design and development of enterprise wide applications using ASP.net, C#,HTML, XML.
• Trained Users in report development and running ad-hoc queries in business objects.
• Scheduled and published reports using the Business Objects Enterprise Server and provided access to different user groups through CMC.
• Involved in designing Universe, generating canned reports using different data providers like Universe, Stored Procedures and Free Hand SQL using Business Objects Reporter.
• Experience in conversion of Desktop Intelligence documents to Web Intelligence documents using the Report Conversion Tool.
• Expertise in handling various Business Objects Administrative tools such as Central Management Console (CMC), Info view, Import Wizard, Report Conversion Tool and Central Configuration Manager (CCM).
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying for the Metadata Management solutions.
• Tested the performance of Crystal Reports for reports based on Business Objects Universes.
• Experience in creating dashboards using Xcelsius.

SKILLS

• Databases: - SQL Server 2000/ 2005/2008, Oracle8i, 9i, 10g, 11g. Lotus Notes.
• Reporting Tools: - SAP Business Objects (XIR3.1/XIR2/XIR1/6.5/5.1), Designer, Crystal Reports 2008/XI/Enterprise10, BEx analyzer, Broadcaster. Xcelsius Data Visualization, Central Management Console, Central Configuration Manager, Desktop Intelligence, Web intelligence, Web Rich client, Live Office, Import Wizard, Report Conversion Tool and Services.
• Scripting Languages: - JavaScript, VBScript.
• Application Servers: - IIS 5.0/6.0/7.0 with .NET Framework.
• Application Languages: C#, ASP.NET, HTML
• Data Warehouse Tools: SAP BI 7.0, SAP BW 3.5.
• Front end Tools: Toad, SQL Management Studio.
• Operating Systems: Windows NT/95/98/2000/XP/Win 7, UNIX.

• Bachelor in Computer Science Engineering

EXPERIENCE

Client: Confidential, Tampa, FL Sep '10 - Till date
Title: Sr. SAP BO Developer/Admin

Responsibilities:

• Involved in the entire SDLC of the project. Requirement & Analysis, Design, Development, QA, UAT and Implementation.
• Was part of the requirements workshop and assisted in requirement gathering from the users and creation of BRD. Prepared the Functional, Business and Technical requirement documents based on the BRD.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies. Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Established data and pulled data from OLAP and RDBMS databases (SAP, Oracle, MSSQL, Teradata).
• Experience in SAP BW-BO integration. Designing the universe on BEx, Infocubes, DSO and multiproviders.
• Created User Objects including Dimensions, Details and Measures.
• Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.
• Created reports on the web using Web Intelligence and distributed them to different users through info view portals.
• Used features such as functions, running totals, and parameters, conditional formats to develop highly formatted Crystal Reports.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Used Xcelsius for presenting dashboards to End users.
• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.
• Created Xcelsius dashboards using live office, QAAWS, XML data Providers.
• Worked on ad hoc reporting to the end user in SAP BI BEx and Business Objects with Xcelsius 2008 reports and BI widgets.
• Assist in ensuring all existing BO reports work appropriately during the upgrade of report database projects.
• Expertise in handling various Business Objects Administrative tools such as Central Management Console (CMC), Info view, Import Wizard, Report Conversion Tool and Central Configuration Manager (CCM).
• Scheduled and published reports using the Business Objects Enterprise Server and provided access to different user groups through CMC
• Was part of the Deployment of Business Objects XI 3.1/R2 on the Windows servers (IIS).
• Involved in performance tuning and optimization of reports that were running slowly. Did performance tuning at the report level, designer level and database level.
• Involved in creating Dashboards by using dashboard builder in Performance Management.
• Coordinated with the offshore teams in India and provided support and training for business users across the global.
• Trained user in using reports at custom level and use the analysis to take a right decision in right time.

Environment: Business Objects XI 3.1(Web Intelligence, Desktop intelligence),CMC, Infoview, SAP BI 7.0, BEx, Oracle 10g/11g, SQL Server 2008, Lotus Notes, Crystal Report XI R2/10, Windows server 2003, Toad.

Client: Confidential, St Louis, MO July '09 - Aug '10
Title: SAP BO/BI Consultant

Responsibilities:

• Interacted with the users to analyze the changes for improvement they needed in existing reports, and develop new reports to satisfy their needs and requirement.
• Designed, Developed and Maintained Universes by defining joins cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Defined and Created Hierarchies as per the business rule for the reports to be viewed at selected reporting level.
• Good experience in designing the universes from the SAP BI database and handling issues during the support.
• Generated SAP BO reports on RDBMS (Teradata, MSSQL) and OLAP (SAP BI/BW) databases.
• Creating Cardinalities, Contexts, Joins and Aliases for resolving Loops.
• Implemented security so that the users can access data pertaining only to their user profiles.
• Created reports using Web, Desktop Intelligence, Crystal Reports and Xcelsius.
• Used functionality\'s like @functions, Variables, user response and formulae.
• Developed Standard Reports, Charts, Drill Through Reports, Cross tab Reports, List Reports, and Summary Reports.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Organized data in the reports by using Filters, Sorting and Ranking.
• Scheduled the universes on daily wise, monthly wise and weekly by using Scheduler in B.O.XI R2.
• Created dashboards using Xcelsius 2008
• Used QAAWS, Live Office Connector to build the Xcelsius Dashboards. Developed and Tested dashboards using Xcelsius 2008 using Live Office as data source.
• Involved in Migration of BO from 6.5 to XI R2.
• Used Publishing Wizard, Import wizard in XI 3.1 environment in publishing and migrating reports.
• Created help documentation on Universes created, trained user on WebI and Desktop Intelligence.

Environment:
Business Objects XI R2, Designer, Web Intelligence XI, Desktop Intelligence, Xcelsius, Crystal Reports, Info view, BO Live office, Dashboards, Unix shell scripting, SQL Server 2008 , OLAP, Oracle 10g,RDBMS, PL/SQL, Windows 2003/XP, WebLogic, SQL, VSS, LDAP security model, SAP BI 7.0, BEx.

Client: Confidential, Auctions, IL. July'08 to June'09
Title: SAP BO Developer

Responsibilities:

• Studied the business processes & gathered requirements from Business Analysts and Business Users.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Designed and developed Universes by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Worked on creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase the performance of the universe.
• Created multiple universes and resolved Loops by creating table aliases and contexts.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice, Drill Down, @Functions, Cross Tabs, Master/Detail, and Formulae.
• Generate pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.
• Worked on Developing Standard & Multi-Dimensional WebI Reports using features like Drills, filters, Sort, Rank, Sections, Breaks, Alerts, merge Dimensions, sub queries and Multiple Data Providers.
• Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
• Created custom LOV's which help the end users while picking the values from the prompts.
• Designed Dashboards using Crystal Xcelsius Designer taking the source from Excel.
• Created the Dashboards Crystal (Xcelsius) with Drill Down option to one level for More Analysis.

Environment:
Business Objects XI R2, Designer, Web Intelligence XI, Data Integrator XI, Desktop Intelligence, Crystal Reports, Xcelsius, Live Office, SQL Server 2005, Oracle 9i, Sybase PL/SQL.

Client: Confidential, IL Jan'07 to June'08
Role: SAP Business Objects Developer

Responsibilities:

• Participated in requirements gathering, analysis and structured Business Intelligence platform based on user requirements.
• Extensive Analysis has been done to Design the Universes and assigned them to respective domains.
• Designed Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects like Dimensions, Details and Measures which are grouped into Classes and checked the integrity of the universe.
• Created Hierarchies, complex objects using various functions, Aggregate objects in the universe.
• Created complex reports by linking data from multiple data providers.
• Created custom Hierarchies which help the end users to drill down to lower levels in the reports.
• Created Alert using Business objects to highlight columns based on business criteria
• Inserted drill filters in the Web-I reports, which help the end users to run a report, based on multiple selection criteria.
• Created Crystal reports using the Universes as the main Data Providers.
• Created Various Cross Tab and Master/Detail Reports to view the data in an analyzed way.
• Created template to customize style and structure of the canned reports to maintain company standards.
• Developed Xcelsius Dashboard integrated with web services and XML Data Connection.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Created Queries with Live Office and Query as a Web Service (QAAWS) by connecting to the Required Universes in order to get the data into Excel. Involved in Reconciliation process of WEBI reports against Legacy reports and documented the data defects and reports defects.
• Worked with Data Modelers and ETL team to resolve data issues.
• Migrated Business Objects WebI reports, Crystal reports, Dashboards, Analytics, Voyager workspaces, Universes from Dev to QA to Prod using Import wizard.
• 24x7 support of the production environment.

Environment:
Business Objects XIR2 (Designer & Reporter), Web Intelligence, Crystal Report, Infoview, Xcelsius, Live Office, Toad, Oracle 10g, SQL Server, WebLogic.

Client: Confidential, India Jan'06 to Dec'07
Role: BOBJ Developer

Responsibilities:

• Interacting with report users and Business Analysts to understand and document the requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Coordinating with Warehouse team and other data Provides to ensure data is loaded in time, thus ensuring report refreshes are happening in time
• Developed Business Object Universes using Designer and Business Objects for the reporting solution for Operational reporting system.
• Potential usage of alias, context, and shortcut join concepts to overcome the loops.
• Created reports that limit the reports to display information for particular measures by designing complex Filters.
• Created reports like, Reports by Category, Reports by Plan, and Reports by Time (Year, Quarter, and Month Date).
• Created complex reports like Master Detail and Cross Tab reports to view and analyze the data.
• Developed Adhoc reports using Business Objects.
• Formatted Reports as per the user requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Involved in Importing/Exporting the Universes to repository to make available to the end user.
  Used Web Intelligence for web based query and reporting and published reports.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, @Functions and Formulas, Filters & Alerts for creating Complex reports.
• Used the Broadcast Agent for Scheduling and monitoring the reports. Validation of the data by creating different test reports on warehouse tables and on base tables.
• Was responsible for supervising and training offshore team on Universe design and creating reports using Desktop Intelligence and Web Intelligence.
• Was responsible for giving Business Objects classes for the entire staff that was using reports.

Environment:
Visual Studio : Business Objects Designer 6.5.1, Business Objects Reporter 6.5.1, Web Intelligence 6.5.1, TOAD, ZABO, Broadcast Agent, Dashboard Manager, Oracle 9i, SQL, PL/SQL, SQL*PLUS.

Client: Confidential, India Jul'04 to Dec'05
Role: BOBJ Developer

Responsibilities:

• Managed resources, granted permissions to both BO Reporters and WebI users and managed the connections, the Universes and repository domains.
• Created new Ad-hoc Reports using Desktop and Web Intelligence.
• Built WebI and Crystal reports, according to end user requirements.
• Did multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.
• Used complex calculations, created variables, Breaks, Alerts, Conditions, Sorting and Ranking.
• Created several tables, views, synonyms, constraints, indexes, stored procedures and functions. Enforced business rules using declarative and non-declarative integrity constraints.
• Resolved previous reporting issues, which were troubling the users.

Environment:
Business Objects 6.5(Desktop Intelligence, Web Intelligence), Crystal Reports 8.0, SQL Server 2000, Windows NT.