Summary:

• Over 6 years experience in Business Analysis, Designing and Reporting using Business Objects XI3.x/XIR2/6.5/5.1.8, Crystal Reports, Web Intelligence, InfoView, Desktop Intelligence, on Windows and Solaris (UNIX) Environments.
• Defined security models with object level security, row level data security, and role based security etc in Business Objects Universes and Central Management Console (CMC).
• Experience in developing dashboards using Xcelsius.
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design.
• Prepared Technical specifications for the development of Universes and Reports.
• Extensive experience in analysis to design the Universes and Business Objects Reports to support the user requirements.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs, Breaks, Functions and Formulae using various sources such as SQL Server, Oracle and MS Access .
• Created complex views to overcome loops and contexts.
• Experience in creating Customized and ADHOC reports using Business Objects Full Client and Web Intelligence (WEBI) tool.
• Extensive experience in Performance Tuning Measures like using of Aggregate Tables, and Shortcut Joins.
• Involved in Installation and Configuration of Business objects.
• Design, development and coding with SQL Server 2000/2005/2008, ORACLE 10g/9i.
• Team player with good Technical, Analytical and Communication skills.
• Ready to learn and adopt new concepts. Good team player and capability to work independently.

Data Warehousing

Business Objects XI 3.1(R3.1)/R2/R1/6.x,Crystal Reports 2008, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence Rich client, Crystal Xcelsius 2008, Deployment Tool , SAP BI, Crystal Report Explorer, Dashboard manager, Scorecards

Front-End

MS-Excel, MS-Power point

Installations

Apache Tomcat Server, Windows 2000

Databases

Oracle 10g/9i, SQL Server 2005/2000, and MS Access

Programming

SQL, PL SQL

Education

• Bachelors of Science.

Experience:

Confidential,NY Nov 2010 – Till date
Business Objects Developer

MF (Mutual Fund) cluster provides Maintenance and production support for 22 applications, that are specialized in providing investment/redemption in various mutual funds, managed accounts in the TRAK program, money market funds, omnibus accounting within Surpass, and investment/surrender in variousannuity, life products.

Responsibilities

• Involved in Requirements gathering and raw data analysis for business users and for report development.
• Involved in designing and developing business objects WEB I reports against multiple data domains like Trading, Deposit and Surrender.
• Involved in Designing and development of Universes, Classes and Objects.
• Used different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports.
• Created Master Detail and Cross Tab reports.
• Formatted the reports as per the business requirements.
• Used Alerter in various reports according to user requirement.
• Created User groups, Users, Database Connections, Managed user privileges, import/export of universes in production environment.
• Scheduled daily/monthly reports.
• Developing and modifying Web Intelligence reports.

Environment
Business Objects XI 3.1 (Web Intelligence Rich Client, Central Configuration Management, Central Management Console, Designer, InfoView, Publishing Wizard, Import Wizard), Oracle 11g/10g.

Confidential,IL Nov 09 – Oct 10
Business Objects Developer

Beam Global deployed Business Objects for analytical and reporting purposes for their sales forecasting and business needs. The project was to audit their current deployment and performance and to create complex reports. Interacted with users to know their Business views while gathering the report requirements and provided several Report Mock-Ups to finalize requirements.

Responsibilities

• Created universes (classes and objects).
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC).
• Developed Webi, Deski Reports, and Xcelsius Dashboards.
• Used Reporting functionalities report Inserting Filters, Sorting, Ranking and Alerter.
• Experienced in developing complex reports using Business Objects webi Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Created Web intelligence reports in Advanced and Interactive mode using all the functionalities.
• Created complex reports in Deski, using multiple Data providers.
• Converted Deski Reports to Webi using Report conversion tool for enhancements and Created Derived Tables in Universe to meet specific requirements for Webi Reports.

Environment
BOXIr3, Xcelsius 2008, SQL Server 2005

Confidential,CA Jan 09 – Oct 09
Business Objects Developer

Sony Pictures Entertainment (SPE) is a subsidiary of Sony Corporation of America (SCA), a subsidiary of Tokyo-based Sony Corporation. SPE\'s global operations encompass motion picture production and distribution.The Project included creating reports to monitor the sales of the various products as per the Region and by pulling the historic data from the EDW (Enterprise Data Warehouse), which was on Oracle database.

Responsibilities

• Gathering day-to-day requirements from Business Users, analyzing and documenting the potential data requirements.
• Involved in designing and Building of Universes, Classes and Objects for warehouse management system and migrating the project from XI r2 to XI r3.
• Created the reports using the Universes as the main Data Providers.
• Used aggregate aware functions and created the objects, which are grouped into classes based on Business Functionality.
• Created reports on web using InfoView, and distributed the reports to different users using Broadcast Agent.
• Responsible for creating the complex reports (On demand, Adhoc Reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical reports etc).
• Used prompts, Global filters, drill downs, customized views and charts.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts). Worked extensively with the major functionalities of Business Objects like Alerter, Group By, query prompt, drill filter, indexes, and Breaks, Sorts, Ranking, Calculation using the Slice and Dice panel.
• Created different types of reports like Master/Detail, Cross Tab and Chart (for analysis), used filters, conditions, and calculations and Defined standards for tables, charts etc.
• Enhanced the existing reports using sub queries to improve the performance.
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Created template documents with header, footer and company logo.
• Created user groups and managed access privileges using Central Management Console.
• Wrote SQL statements for testing of BO queries using TOAD.
• Involved in various discussions with the end users to analyze Meta data.

Environment:
Business Objects XI r3/r2 (CMC, Info View, Desktop Intelligence, Web Intelligence), Oracle 10g/9i, PL/SQL and Windows.

Confidential,MN Jan 08 – Dec 08
Business Objects Developer

Responsibilities

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build new Universes as per the user requirements by identifying the required tables and by defined the Universe connections.
• Converted business requirements in to technical requirements with BO technical team.
• Created customized Web Intelligence reports from various different sources of data.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Involved in creation of Filters, @prompts and setup Hierarchies for Multi dimensional Analysis.
• Created complex reports and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Minus.
• Exported the Universe to the Repository to make resources available to the users for Ad-hoc report needs.
• Publishing new Report to the users from the central data warehouse.
• Developed critical reports (like drill down) for analysis of parts benefits and head count.
• Created complicated reports including sub-reports, formula base and well – formatted reports according to user requirements.
• Used Open Document function which was embedded in few of the reports to open lookup reports.

Environment
Business Objects XIR2, Web Intelligence, Designer, Oracle 9i, Windows 2003, Info view, Sql Sever 2005

Confidential,NY Feb 06 – Dec 07
Business Objects Developer

Thomson Reuters is the world’s leading source of intelligent information for business and professionals. It combines industry expertise with innovative technology to deliver critical information to leading decision makers in the financial, legal, tax, accounting, scientific, healthcare and media markets powered by the world’s most trusted news organization.

Responsibilities

• Involved in migrating the project from 6.5 to XIr2.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.

• Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.

• Provided production support by monitoring the processes running daily.
• Deployed the development and QA domains to reduce the server loads and to increase the performance.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.

Environment
Business Objects XI r2/6.5 (CMC, Info View, Web Intelligence, Desktop Intelligence), DB2, Oracle 8i, TOAD, UNIX

Confidential,NY June 05– Jan 06
Business Objects Consultant

Hop Lun is one of the leading distributors of women’s fashion lingerie to the European Union. They have established a diverse customer base within this market, and by providing customer and tailored support to their core customers, both parties have been mutually rewarded. To improve overall service and to be closer to key customers, Hop Lun operates representative offices in London, Paris, Madrid, New York, Toronto and Mexico. The Hop Lun subsidiary offices are responsible for selling and distributing Hop Lun’s own unique brands to select department stores and boutiques around the world.

Responsibilities

• Created Business Objects WEBI reports, Queries with constant interaction with the end users.
• Created/Modified Universes and linked with the existing Universes with MS SQL Server 2000 backend and exported to repository.
• Created Users and implemented security features.
• Created Slice and Dice, Drill down and Cross Tab reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Various ad hoc reports were created using User module in Business Objects according to the given requirements.
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Implemented row and object level security in business objects supervisor module.
• Worked with Dimension modeling using Star Schema (ROLAP).
• Managed the scheduling options stored in the repository and also involved in changing the document descriptions.
• Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
• Trained end users in understanding the reports.

Environment
Business Objects 6.5, Oracle 9i