SUMMARY

• 6+ years of IT experience, quick learner, easily adapts to various environments and very effective communication and interpersonal skills.
• 5+ yearsof experience in Business Objects XI 4.0/XI R3/R2/6.X, Business Objects IDT, Universe Designer, Reporter, Central Management Console, BI Launchpad, Info View and Web - Intelligence Rich Client.
• Strong knowledge in overall BO XIR2/3.0/3.1/4.0application architecture and ableto Design, Deploy, Support the application architecture.
• Good Understanding of Process Flows within the Enterprise Architecture for different user request.
• Experience in installation, administration and upgrading versions of BO both desktop and server products on both Windows and UNIX environments.
• Experience working with Single Sign On (SSO) for Business Objects Enterprise.
• Involved in designing Universe and creating reportsweb intelligenceand Desktop Intelligence report.
• Experienced in migration of Business Objects 6.5.1Enterpriseto XI R2/3.1.4.0.
• Well versed in Business Objects with experience in Supervisor, Designer, Reporter, BCA (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0, Info view, Dashboards, Auditor and Schema Design.
• Good knowledge and experience in using Querying and Reporting modules of Business Objects Enterprise XIand Crystal Reports.
• Experience with linking to various data sources (QaaWS, Live Office, ODBC, etc) for dashboards and designer Universe.
• Have a strong experience on Microsoft Access®,Microsoft Excel® and Microsoft Word®.
• Involved in working on Pivot Tables and also V- Lookup in order to link different Excel Documents.
• Worked on Power Point while making Schema Design for the Universe.
• Basic knowledge of Physical Data Modeling andRelational Data Modeling.
• Designed Data Models OLTP/OLAP data models, ETL and Data Warehousing
• Used Voyager to bring data from OLAP data sources.
• In-depth knowledge in creation of Dashboards using Crystal Xcelsiusand Dashboard manager.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.Solid knowledge of SQL.
• Basic knowledge of PL/SQL and T-SQL.
• Good knowledge and experience in using,MS SQL Server 2000/2005.Teradata13.0 SQL Assistant 2010, Teradata 12 and v2r6,MS Access 2008/2010, Oracle 11g.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Business Objects Consultant

Responsibilities:

• Developed Universes for the Legal Department using IDT, and by using contexts, aliases, bridge tables and other required steps so to make surethat there are no loops or traps (Fan Trap or Chasm Trap) in the universe.
• Make use of Index Awareness, Defining Hierarchies, Cascading LOV and @Functions
• Based on the user requirement successfully implemented Row Level Security and Object Level Security (Column Level).
• Make use of Index Awareness and Aggregate Awareness for tuning up the report performance.
• Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the Reports and Universes
• Gathered functional requirements and designed Technical specifications from the Business Analyst and also interacted with the users also in case of any other confusion along with the BA.
• Created reports using on Business Object 4.0SP4 using BI Launch Pad, figured out numerous Bugs while making reports and reported that to SAP and finally installed and worked on Business Object 4.0 SP7, which cleared most of the bug issues.
• Involved in creating reports using multiple queries and then using Merged Dimension in order to Sync the data coming in reports.
• Used Cross Table and Vertical Tables in reports along with drills down in some reports and also Alerts for some conditional formatting.
• Worked on the Design Document for the reports, which involves detailed information of reports and the universe and migration steps involved in migrating the elements.
• Made User Requirement Document (URD) that includes the basics of making reports and developing universe for Ad hoc purposes.
• Involved in taking the backup every week of all the reports and universe using Promotion Management in CMC, in the form of BIAR file.
• Oracle 11 gwas used as the DB for reporting purposes,
• Used TOAD Oracle 10.6 for the Unit Testing of my reports and did DATA SETUP in the Dev Environment as per the report requirements.
• Manually performed System Testing, Regression Testing and Functional Testing. Generated Test data for identifying valid data, Invalid data, Partial data, and Bad data using TOAD Oracle 10.6
• Done Migration of reports and universes from DEV - QA STAGING ENVIROMENT PROD using Promotion Management in BI 4.0.
• Experienced Scheduling the BO Reports based on Events and Calendar.
• Created User level security, Folder level security and Group level security in Central Management Console (CMC).

Confidential, California CA

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Webi Reports.
• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Used the Functionality of Sections and Breaks in most of the reports.
• Created Reports that required Folding and Unfolding.
• Use of Input Controls was also used in every report.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Implemented Row level and Object Level security as per the user requirement.
• Data connections to the dashboards were accomplished through BI Web Services.
• Created Interactive Dashboard using Dashboard Designer4.0.
• Created templates to generate different styles of reports, which are not, belong to Business Objects standard documents.
• Tuned the reports for better performance using SQL.
• Created various 3D pie charts, Pie charts, Bar Charts, Line Charts.
• Scheduling of different WEBI Reports and showing the reports in different format e.g. Microsoft Excel, PDF and Web Intelligence as per the Mockup Requirement.
• Regression Testing of the reports in Dev and Test environment and Scheduling of reports in info view.
• Check the integrity of the Universes and export the universes to Repository for making available to users.
• Regularly took back of reports and Universe using Import Wizard and creating BIAR files.
• Interacted with Business Objects technical team to get the resolution of problems / bugs in Business Objects.
• Involved in making PAD (Physical Application Document), and also SRD (System Required Document) while working with Data Analyst.
• Involved in Business Objects Support, Problem Solving, Trouble shooting and developing End user Notes.
• Understand the business needs and implement the same into a functional database design.
• Worked closely with business analysts to understand the business needs for decision support data
• Created Complex Reports in Business Objects XI R3.1 and 4.0
• Involved in making Xcelsius Dashboard Reports on the basis of some WEBI Reports, by using the report’s highly Aggregated Data
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using xcelsius 2008.
• Created Complex Reports in Business Objects XI R3.1 and 4.0.
• Worked along with the Admin on various SAP Tickets, regarding bugs in BO 4.0 Webi.
• Also involved in migrations of universe and reports using Life Cycle Management tool across Dev, QA and Prod Environment.
• Involved in making Xcelsius Dashboard Reports on the basis of some WEBI Reports, by using the report’s highly Aggregated Data
• Scheduling of different WEBI Reports and showing the reports in different format e.g. Microsoft Excel, PDF and Web Intelligence as per the Mockup Requirement.
• Worked on BO Dashboard and WEbi SP4 and later on upgraded to SP5.
• Involved in transferring the data between Flat Files into Database Tables
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Created new Universes and fine-tuned existing ones by resolving join problems, Created universe on top of views build in composite coming from multiple data sources.
• Created Multiple Custom Hierarchies for several groups to provide drill across functionality.
• Converted reports from desktop Intelligence to web intelligence using Report conversion tool and manual conversion method.
• Extensively Designed & Deployed System Reports, Custom Reports, User Report, Ad Hoc Queries by incorporating the functionalities of Sort and Drill Down.
• Designed and Developed WebI Reports using the features like Master/Detail, Charts, Cross Tabs, Slice and Dice, Drill Down, @Functions and Formulae to analyze the data.
• Created Web Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
• Developed SQL programs on SQL Assistant to perform Unit test on WebI Reports.
• Resolved tickets to support production environment, Modified and tweaked report content and distributed reports in multiple formats such as Excel and PDF
• Created Xcelsius Dashboard using Query as a Web services(QaaWS) and XML as a source.
• Worked extensively on Teradata 13.0 SQL Assistant 2010,as it’s the database client for SCE, and involved in doing Unit Testing of different report before migrating it to QA environment.

Confidential, New York City

Business Objects Developer

Responsibilities:

• Involved in production support, dealt with daily issues faced by users and resolved them
• Created several WebI reports and DeskI reports for finance department
• Designed Universe by creating the SAP BusinessObjects data model selecting and providing joins between the tables, indicating cardinalities
• Created reports using SAP BusinessObjects functionalities i.e. slice and dice, drill down, cross tab, alerter and formulas etc
• Scheduled daily, weekly and monthly reports using events, creating calendars
• Involved in migrating from XI R2 to XI R3.1 also tested the reports after migration
• Created detailed WebIreports and linked them to Xcelsius with the help of OpenDoc
• Used context operators like In, For Each, For All in WebI reports in order to meet the business requirements, Created WebIntelligence reports ad-hoc and canned reports
• Migrated universes and reports from Dev/QA to production using Import Wizard
• Created report designing documents for further reference
• Tuning the queries to improve the performance of the report refresh time
• Created complex variables and calculation to meet the user requirements
• Worked with off-shore team and coordinated with them as onsite coordinator
• Worked extensively on MSAccess Database.
• Interacted with customer support regularly, to resolve the existing issues and generated the required reports
• Involved in creating reports such as schedule of investments, statement of assets and liabilities, statement of operations, statements of changes in net assets, financial highlights and other reports.

Confidential, New York City

Business Objects & Webi Reports Developer

Responsibilities:

• Involved in the creation of various report formats including master/detail reports, sub reports and cross tab reports and published them.
• Created dashboards with live streaming of data using Web Service connection (WSDL) in Xcelsius.
• OpenDoc command and usage of Flash variables within Xcelsius
• Used Teradata 12 as our Database Client, and did extensive Testing, with the QA Testers.
• Created detailed Web Intelligence reports and linked them to open in Xcelsius with the help of Open Document function
• Developed reports with multiple parameter fields and multiple grouping for various hierarchy levels
• Involved in setting up users and assigning privileges to these users to meet security requirements
• Created universes from multiple data sources which were coming from different databases
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes
• Resolved issues like loops by creating aliases and contexts as required removing the cyclic dependencies
• Exported the universes to dev, test and prod domains to make resources available to the users
• Created repository using supervisor, created users and groups, assigned rights to users and groups
• Created universes, classes and objects for management systems
• Resolving loops using aliases and contexts and check integrity of the universe and exported them to the Repository to make resources available to the users and groups lm
• Updated and maintained Universes based on changing user requirements and data source changes
• Developed and deployed complex reports. Used multiple data providers, union, intersection, minus and master/detail, cross tab, charts
• Created templates for standardizing the structure of our corporate documents
• Worked extensively with the major functionalities of SAP BusinessObjects like breaks, alerter, filters, sorts, query prompt and drill filters
• Created Report level variables by using used variable editor
• Analyzed the reports using the drill through, slice and dice, Created reports on web using WebIntelligence

Confidential

Business Objects Developer

Responsibilities:

• Analyzed functional and technical requirements and prepared deliverables including Software Requirement Specifications, User Interface Specifications, screen mock-ups, report mockups
• Involved in Production support iss ues while coordinating with the on site team.
• Worked on BO 6.5 AND XI R2. Also worked on Dashboard in late 2008.
• Did extensive unit testing of the reports before sending the reports in QA environment.
• Designed universes based on user requirements as well as functional and technical
• Identified the basic tables and the logical relationship between the tables to create the most balanced and scalable universe
• Performed Integrity Checks to Universes to detect loops, cardinalities and joins
• Created Aliases and Shortcut Joins in order to resolve the loops in the newly developed Universes
• Created Classes, Objects, and Filters in the Universes as per the request submitted by the Report Developers and Business Users
• Extensively used @functions (@select, @prompt, @where in the creation of filters, prompts, and conditions
• Schedued the report and delivered in the format of PDF, EXCEL
• Converted all Desktop Intelligence Reports to Web Intelligence Reports using Report Conversion Tool.
• Used Filters, Sections, Breaks, Sorts, Query Prompts and Drill filters functionalities in making the reports easy for analysis
• Created Drill-Through Reports to provide users with more detailed information and query linking
• Involved in writing detailed level documentation for reports.