Professional Summary

• A dynamic IT professional with 9 years of rich experience in developing SAP Business Objects 4.1, Xir3.1, Xi3, Xi2 and Data Warehouse applications.
• Expertise in IDE Tools like BI Launch Pad, Information Designer Tool,Universe Designer, Import Wizard, Web Intelligence Rich Client, Infoview, Deski Report Designer, Dashboards, SSRS.
• Expertise in Universe and Report designing Web Intelligence Dashboards, Migrating Universe and reports, user administration, access group restrictions, scheduling reports and other CMC activities.
• Design and implement of Xcelsius Engage 2008 Dashboard and visualization with dimensional data connection by using 'Query as a Web Service QAAWS , and Live Office
• Have exposure to constructing stored procedures, triggers, cursors, tables, user functions, views, indexes, SQL queries, and relational database models on Databases like SQL Server 2005, 2008, Oracle.
• Good basic knowledge of Unix Shell Scripting.
• Involved in Migration of business objects from one version to another version.
• Developed front-end queries and reports using BEX Analyzer, BEX browser.
• Experience in building Universes from SAP BW and Non-SAP Data Sources.
• Worked with Business Objects Explorer on BOBI 4.0 for mobility.
• Ability to work independently with minimal guidance as well as within a team environment.
• Results oriented, with an ability to work with aggressive timelines and deliverables and to see any assignment to successful completion within the established project schedule.
• Willingness to learn new technology and design constantly.

Technical Skills

Professional Experience

Confidential

Senior Business Intelligence Developer

Responsibilities:

• Creating the Complex Web Intelligence Reports.
• Creating the Universes and managing the universes with derived tables and contexts.
• Creating the Webi Reports with Input and Output Contexts, Sorting, Ranking, Breaks, Sections, Cross Tabs, Combined Queries, Custom SQL Reporting.
• Migrating and Testing the Business Objects from XI 3.1 to XI 4.1
• Working with CMC in managing the users, Universes, Reports and Universe Connections.
• Created various Dashboards using Business Objects Xcelsius where Query as a web service as a middleware between Xcelsius and BO.
• Involved in the data consolidation by gathering the relevant information from various source systems to resolve the conflicts and finally created a common structure representing the target model
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Experience in Unit Testing and Test cases.
• Providing the Training to the Super Users.
• Creating the Technical Specification Documents after gathering the Requirements from the Clients.
• Preparing the Unit Test Cases for the Reports

Environment: BI Launch Pad, Information Design Tool, Upgrade Management Tool, Webi Rich Client, Business Objects XI 4.1, 3.1, Oracle10G, 11g, Microsoft SQL Server 2008, Crystal Reports 9.

Confidential

Objects Developer

Responsibilities:

• Involved in Design, development of Universe.
• Worked with SAP Business Objects Explorer on BOBI 4.0 for mobility.
• Developed front-end queries and reports using BEx Analyzer, BEx browser.
• Develop Business Objects solution out of the ERPs like SAP R/3, ECC, SAP BW/BI environment
• Designed and deployed Xcelsius Dashboard 4.0 solutions on Dashboard Builder along with Webi reports
• Well versed with Joins, Cardinalities, loops in the universe designing and good exposure to resolve Chasm traps and Fan traps.
• Linking of universes and hands on predefined filters, prompts, custom hierarchy, cascading LOV, aggregate awareness
• Build Universes from SAP BW and Non-SAP Data Sources.
• Created custom Hierarchies, which help the end user to drill down to lower levels.
• Developed the complex reports like jumping one report to another Reports, Drilldown, aging reports, Trend analysis reports

Environment: Universe Designer, WebI Rich Client., Query Builder Business Objects XI 4.0, 3.1., BODI 12.0.0, Oracle10G, 11g, SQL Server 2005, Crystal Reports 9.

Confidential

Sr. BO Developer

Responsibilities:

• Created Derived tables in the Designer to enhance the capabilities and performance of the universe
• Customized Universe level Prompts as per Functional Requirements.
• Check the integrity of the Universes, and export the universes to Repository for making available to users
• Created, maintained and modified the business critical reports using the Web Intelligence.
• Created complex reports using Merged Dimension and multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Creating Universes with Derived Tables and Created Web Intelligence reports with prompts / custom SQL
• Integrating BOBJ installation and different connectivity to different reporting tools.
• Performing Server Management Tasks, using Central Configuration Manager CCM and Central Management Console CMC .
• Creating server groups and performing various debugging methods for trouble shooting
• Created and Managed Users and Groups and setting the rights on them using Central Management Console CMC .
• Setting up and working with Life Cycle Management setup and troubleshooting
• Business Objects connectivity, Live experience in BOBJ Maintenance and Security and resolved Authentication issues.
• Set up many new projects and implemented end to end security and suggested many optimum ways

Environment:Business Objects Xi4.1, Xir2, Crystal Reports Xir2, Universe Designer, Desktop Intelligence, Web Intelligence, CMC, MS-SQL Server 2005 Oracle9i and Windows 2008 Client Server

Confidential

Business Objects Developer

Responsibilities:

• As a part of Universe development, created classes, different kinds of objects, cardinalities, strategies, resolved the loops using aliases and contexts
• Installed the Repository, created users and assigned profiles
• Tested the Universe model for integrity and user acceptance
• Designed and implemented summarized Universe for easier and faster Reporting
• Checked the integrity of the Universes
• Analyzed the requirement for Reports and performing feasibility study
• Generated reports master/detail, cross tab, chart with Business Objects Reporter
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks
• Implemented Best Practices using BODI for Data Warehousing, ELT Extract, Load and Transform and Data Integration Purposes
• Publishing reports online for web users and creating access to reports online via Info View using Webi
• Migrating universes from the test domain to production domain
• Conduct the transfer of knowledge sessions by training, coaching and mentoring less experienced staff members

Environment:Business Objects Xi4.1, Xir2, Crystal Reports Xir2, Universe Designer, Desktop Intelligence, Web Intelligence, CMC, Ms-SQL Server 2005 Oracle9i and Windows 2008 Client Server

Confidential

Senior BI Developer

Responsibilities:

• Creating the Universes using the Information Design Tool.
• Creating the Webi Reports with Input and Output Contexts, Sorting, Ranking, Breaks, Sections, Cross Tabs, Combined Queries, Custom SQL Reporting using the BI Launch Pad.
• Migrating and Testing the Business Objects from XI 3.0 to XI 3.1
• Providing the Support for the Existing Crystal Reports.

Environment:Universe Designer, Web Intelligence, Desktop intelligence, Query Builder Business Objects XI 3.1.

Confidential

Business Objects Developer

Responsibilities:

• Created web intelligent report base on report summary and detail report and creating universe from a non-Sap system.
• Used Live Office and QAAWS Query as a Web Service to feed live data into Xcelsius 2008/2010 both Dashboards Scorecards
• Testing, System Refresh object from Development box QA Production
• Creating Data lineage base on KPI/ Matrix, communicate with offshore for daily updates
• Used Advance Analysis for office to create a report on top of BEX queries or Cube
• Scheduled reports on Daily, Monthly, Weekly basis and Debugging the Problems
• Maintain, create Xcelsius dashboard 4.0 Reports on top of SAP BEX queries
• Design and develop reports using WEBI Rich Client and populate into Dashboard using QaaWS as per client requirement.
• Excellent performance tuning to enable smooth running of WEBI reports

Environment:Business Objects XI 3.1, Oracle 9i, Windows XP, BODI 11.7.2

Confidential

Business Objects Developer

Responsibilities:

• Created various Dashboards using Business Objects Xcelsius where Query as a web service as a middleware between Xcelsius and BO.
• Universe Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Dealing with DESKI and WEBI reports. Rectifying all the issues related with scheduling, connection, Server failures, and Database connectivity problems.
• Setting rights and privileges on objects, folders, connections depending upon the requirement. Creating and maintaining different User groups as per the business need.
• Develop mapping to load data from staging to Dimensions and Fact.
• Create the source and target mapping which list the transformation rules

Environment: Business Objects XI R2, Oracle 9i, Windows XP, BODI