SUMMARY

• Around 7 years of IT experience in Designing, Developing, Testing and providing support for the effective implementation of applications, to suite the business needs of corporations.
• Experience with various tools of Business Objects XI 3.1,/XIR2/6.x /5.x,Business Objects Designer, Reporter, Supervisor,CMC,Info View Web - Intelligence XI,Desktop Intelligence,Crystal Reports9/11/2008, Auditor and Live Office.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, configuration testing, Migrating, Administrating, maintenance, security management and production supporting on various platforms like Windows NT/2000/XP/98.
• Experience in implementation of Business objects with multiple domains likeFinance, Pharmaceuticaland Insurance sectors.
• Expertise in using Import Wizard and Report Conversion Tool for migrating the Universes and Reports between different environments like Dev, QA and Production.
• Excellent knowledge in Implementation of Relational Database(OLTP)and Data warehousing systems(OLAP)andData Marts.
• Excellent in universe designing techniques, creatingwebireports with various functionalities like multiple data providers, merge dimensions, drill options, multiple tabs, filters, alerts etc.
• Expertise in Create Repository and maintained the Universe domain and Document domain.
• Experience inDesigning and Documenting Universe,ReportsRequirementsdefinition templates, Security strategies.
• Creates new universes to meet the requirements and modified the universes available in rapid decision
• Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflakeusing Erwin.
• Expertise inBusiness Objectsproducts like Import Wizard and Report Conversion Tool
• Strong Knowledge inResolvingloops and traps using aliases and contexts.
• Worked with various Relational DatabaseslikeOracle 10g/9i/8i,SQL Server 2000/2005, DB2and good exposure to Oracle 11g.
• Familiar in Creation of Dashboard, Score card andWebiReports. Implemented Security Features ofBusiness Objectslike Row Level, Object Level and Report Level to make the data secure.
• Experience increated reports using WEBI andDESKI.
• Worked with Crystal Report9/10/XI/2008 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV, Dynamic LOVs.
• Experience in creating Analytics and Dashboard usingCrystalXcelsius2008and Dashboard Builder.
• Good Communication and Interpersonal skills, technicallysound, Result-Oriented with strong Problem solving skills, Innovative & efficient,Capable of working as a Team Member or Individually with minimum supervision.

TECHNICAL SKILLS:

• Business Objects Suite 5.x/6.x/XIR2 XI 3.1
• CMC
• CCM
• Info view
• Web / Desktop / OLAP Intelligence
• Designer
• Supervisor
• Administrator
• Dashboard Builder
• Reports
• Import Wizard
• SDK
• WBBI
• DESKI
• Report Conversion Tool
• Broadcast Agent Scheduler
• Publisher and Auditor
• Crystal Reports 9/10/XI/2008
• Xcelsius
• Web Intelligence
• Performance Management
• Universe Builder
• Informatica Power Center 6.x 7.x 8.x
• TOAD
• SQL*Plus
• Windows NT/2000/XP
• UNIX
• Oracle 8i/9i/10g/11g
• MS SQL Server 2000/2005
• Flat File Systems
• MS Access
• SQL
• PL/SQL
• C
• C++
• Java
• HTML
• PHP
• UNIX..

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Business Objects Consultant

Responsibilities:

• Experience in development of Universes, modified existing universes, added new objects to existing Universes and working on the procedures for the development of reports.
• Designed complete universe with all required classes as per the client requirements.
• Extensively involved in Universe Design, troubleshooting of the universe/reports and implementing security.
• Actively engaged in design discussions for all Business Intelligence and database initiatives.
• Created WEBI reports using XIR3 info view and rich client.Tracking of data using data tracking options during report development.
• Implemented row level security in the universe to allow the data to be viewed only by authorized person.
• Created reports on multiple datasourceslike SQL server, oracle and SAP BI/BW
• Efficiently designed multiple analytical WEBI reports utilizing key WEBI features including but not limited to Drill Down, Alerts, Input Control and Open Doc.
• Created prompts, filter, alerts and complex calculations for business needs
• Created report hyper linking to access reports from other reports
• Test the SQL queries generated by reports to find correct data is retrieving or not
• Creations of sections and breaks to get the sub totals on each level
• Creationof different types of reports such as Master/detail, Crosstab and chart (for trend analysis) depending upon user requirement.
• Handled all types of errors in reports in universeand report level.
• Created Master-detail reports using calculations, Variables, Breaks, Sorting and Alerts for creating reports Drill down/up functionality related to the company's Accounting and financial planning design and implementation of reports.
• Create new and/or modify existing reports using rich client, deski
• Developed many Reports/Dash Boards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Tabular with global and local Filters) using BO XI 3.1.
• Created templates for standard reports.
• Created crystal reports with running totals, sub reports, cross tab, groups, sections using report wizard andblank report wizard.
• Testing the Universe and reports for data accuracy and format specifications given by the client.
• Created Cross-tab and Master Detail reports
• Used Business Objects common functionalities like Prompts, Breaks, Alerter, Sorts, Filters, Global Filters and Conditions.
• Created various MTD, YTD and daily reports.
• Performing object data lineage as a part of testing.

Environment: Business Objects Enterprise BO XI R2/3.0/3.1, Crystal Reports 2008, Webi,XCelsius 2008, Live office, Informatica 7x/8x, SSIS, SSAS, SSRS, SQL Server 2005/2008, DB2, Oracle 10g. MS Access.

Confidential, New York, NY

Business Objects Consultant

Responsibilities:

• Interacted with Business Owners, Business Analyst and other team members in gathering the Business requirements.
• Created the Universe Data Flow Diagrams, mapping documents (CGICS to APS) and presented the Business.
• Attended the technical meetings to finalize the design for the development of the Universe(s) and reports.
• Created the database objects required for the Universe development.
• Created the Classes, Objects and measures in the universe as required by Business.
• Resolved the Join issues and the loops by creating the aliases, contexts and checked for the integrity of the Universe.
• Implemented the Aggregate Awareness, did the compatibility check for better performance
• Customized the List of Values (LOVs) as per the user requirement.
• Created custom hierarchy in the universe as per the report requirements.
• Efficiently tested designed multiple analytical WEBI reports utilizing key WEBI features including but not limited to Drill Down, Alerts and Input Control
• Altered the joins for great performance of the queries.
• Managed the access restrictions for the Users according to their group restrictions.
• Created complex Web Intelligence reports like the reconciliation, Process Monitors and the Dashboard reports.
• Using the OpenDoc function, created the hyperlink reports.
• Formatted the reports with the available functionalities like the Slice and Dice, Drill Down and Up
• Extensively used Sections, Breaks, Alerters on the reports.
• PeopleSoft integration with Business Objects through BO SDK for SSO
• Customized Webi through the BO API SDK.
• From the Central Management Console, assigned the security features against the Users and their groups.
• Prepared the unit test cases for validations of reports and adhoc reporting scenarios.
• Involved in the of the Users and helped them to resolve the adhoc reports issues.

Environment: Business Objects Enterprise XI 3.1 SP3 FP3.6, Oracle 10g/11g, PeopleSoft EPM, Ab Initio, HP Quality Center, BO SDK, STAT, MS Office Suite, TOAD/Sql developer

Confidential, San Diego, CA

Business Objects Developer

Responsibilities:

• Performed report requirement gathering.
• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features users expecting with reporting systems and also to successfully implement business logic.
• Involved in designing Universe and migrating existing Deski Reports to Webi.
• Efficiently designed multiple analytical WEBI reports utilizing key WEBI features including but not limited to Drill Down, Alerts, Input Control and Open Doc.
• Workedon Universe Development - Using aggregate aware, contexts for multi subject Universes, use of derived tables, complex measure using functions, Index awareness,complex logical counts, and averages, row level security and multiple contexts.
• Solved join path problems (Loops, Fan and Chasm Traps).
• Creating, maintaining and modifying the business critical reports using the BO6.5 User
• Extensively used calculations, Sorting, Ranking,Drilldown, Drill through, Slice and Dice, Formatting, Breaks, Sections, Filters, Changing Display and Prompts for creating Business Objects Reports.
• Created trend reports with charts and drill down on charts.
• Extensively tested the data output by querying the Oracle database using SQL * Plus and tuned the SQL queries.
• Created Crystal Reports usingCrystalreports 11.2 by using Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’srequests from Tables, Stored Procedures, and Views.
• Createdvarious Dashboards using Business Objects Xcelsiuswhere Live Office as a middleware between Xcelsius and BO Universe.
• Createddashboards using Microsoft excel as a data source.
• Involved in the documentation of the project which includes RequirementSpecifications, Design Document and Project Planning.

Environment: Business Objects XI R2, Windows, SQL Server, Web Intelligence,Crystal Reports XI, Crystal Xcelsius.

Confidential, Columbus, OH

Business Objects Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• DesignedUniverse and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies.
• Designing Universes, incorporating all the business intelligence requirements usingBusiness Objects XI R2.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Maintaining Universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
• Created the Aggregate tables and Aggregate awareness & Aggregate Objects and used in the reports.
• Involved in the troubleshooting of universe schema with Loops, chasm and fan traps and cardinality problems.
• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI, Deskiand Crystal Reports XI.
• Used functionalities such as sub-reports, cross-tab reports with Drill down feature ofCrystalreports to generate inventory, point of sales, account receivables & payables, cycle and monthly reconciliation reports for billing purposes.
• Created complexreports that could require multiple data providers. Drillable reports through hierarchies and by report link through hyperlinks using Open Document.
• Extensively used Calculations, Sorting, Rank, and Drill down, Drill thru, Slice and Dice, Formatting, Breaks, Filters, Changing Displays andCascadedPrompts for creating Business Objects Reports
• Reports were formatted to the users according to the user requirements using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions and Formulas.
• DevelopedCrystal Reportsand launched them from user interfaces.
• Publish, distribute and schedule Web Intelligence reports using Info view.
• Converting Deski Reports to WEBI using Report Conversion Tool.
• Worked extensively on databases to create views, stored procedures, and functions, to develop reports based on them for efficiency.

Environment: Business Objects XIR2\6.5.1(Designer, Desktop Intelligence, Web Intelligence, Crystal Xcelsius XI R2, Informatica 8.6.1, CMC, CCM, Crystal Reports 2008, Windows,Teradata.

Confidential, Austin, TX

Business ObjectsDeveloper

Responsibilities:

• Gathered, analyzed and documented Business requirements, clarified Business rules, functional requirements and data specificationsfor Business Objects universes and reports.
• Created reports in Web Intelligence for navigating through different levels of hierarchy using Drill up - Drill down functionalities in WebI.
• Defined Cascading List of Values in the universe, for better filtering of the data in the reports and thereby improving report performance.
• Created many complex canned reports with multiple data providers but showing all the data in one table by merging the common dimensions between the data providers.
• Responsible for Creating Complex and Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
• Developed canned reports using combined queries with UNION functionality.
• Created reports with Optional Prompts and prompts with some default value.
• Created local variables with complex logics in the reports for calculating the liquidity amounts.
• Created complex formulae in the WebI report to dynamically changing the column that need to be displayed in the table depending on the prompt values.
• Used functionalities like Sections, Breaks in the canned reports for sectionizing data in the report; this ensured the readability of the reports.
• Converted BO Desktop Intelligence Reports in XIR2 to Web Intelligence documents using Report Conversion Tool.
• Modified existing reports for adding Linked/On-Demand Sub reports, Crosstabs and Nested/Conditional Grouping.
• Created dashboards using different single value and multi value components in Xcelsius.
• Defined templates for the Standard and Adhoc reporting with standard formatting and required logos.
• Ensured the quality and timely delivery of all the important complex canned reports.

Environment: Business ObjectsXI R3/R2 (CCM, CMC, Info View, Desktop Intelligence, Web Intelligence, Crystal Reports, Xcelsius), Teradata, Oracle 10g/9i, PL/SQL and Windows

Confidential, Columbus, OH

Business Objects

Responsibilities:

• Involved in the development of reports by using Business Objects and Oracle 9i as database.
• Deployed reports on the web using Publishing Wizard and scheduled reports using web desktop and management console.
• Developed various Charts and Graphs like Bar Chart, Line Graphs, and Pie Charts by using Chart expert of Crystal reports.
• Developed and published webi reportsin Business Objects Enterprise XIR2 environment.
• Developed various database objects like Tables, Views and Stored procedure by using SQL *Plus, PL/SQL in Oracle.
• Created Universes, Classes and Objects for management based on the warehouse schema.
• Created ad-hoc reports using Full Client in Business Objects.
• Making changes and maintenance of existing universes.
• Modified the reports to suit the Business Objects standards and specifications.
• Reviewing the reports to look and feel and save the reports in PDF format.
• Attending user call to address the issues in Business Objects.
• Involved in designing the universe by creating the business object data model selecting/joining tables, indicating cardinalities, creating aliases to resolve loops, subdividing into contexts and creating the objects which are grouped into classes for convenience.
• Involved in production support by modifying and correcting production reports.
• Involved in creating reports on web using Business Objects Web Intelligence.
• Developed ad-hoc reports for various business units and internal technology organization.

Environment: Crystal Reports 10.0/9.0, Business objects XI R1/6.5 (Info View, CMC, CMS, Import Wizard Designer, DeskI, WebI) SQL, SQL Server 2005, Oracle 9i/8i, DB2, Excel, Access.