SUMMARY

• 9 years of Business Objects 4.0/R3.1/R2/R 1/6.5/6.1/6.0/5.1 , CMC, Designer, Info view, Web - Intelligence XI/6.0/2.7,Supervisor, Auditor, Application Foundation Dashboard Manager, Application Foundation 6.0/2.5 & Dashboard Manager, Business Objects Reporting, Business Objects SDK, Web-I SDK, OLAP, OLTP, Broadcast Agent, Publisher.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Expertise in working Crystal Decisions, Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2,2008, Crystal Xcelsius 2008.
• Experience in Installation and configuration, Creation of repositories and security domain with user groups and security implementation.
• Expert in tuning the performance of SQL queries and ETL process.
• Expertise in Universe designing, developing and generating Complex Reports, Adhoc Reports, Dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked with Crystal Report 2008 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based reports, drilling reports, analysis reports, data reports along with LOV.
• Working Experience on creating dashboards using Crystal Xcelsius 2008/4.5/3.0 by importing data files to create the visualization utilizing QAAWS.
• Expertise creating Executive dashboards for the upper management showing summary metrics for the Key performance Indicators (KPI’s).
• Extensive knowledge in Business Objects Full Client & Thin Client environments.
• Experience in using various Data Providers like Universes, Free Hand SQL and Stored Procedures for retrieving data and creating Simple and Complex Reports.
• Creating, Developing, distributing, migrating and modifying Universes in Business Objects.
• Migrated Business Objects environment from Business Objects Enterprise 6.1 to XIR2 and also from XIR2 to XIR3
• Migration from BO3.1 to BI 4.0
• Tested business objects reports for data validation and compared results with TOAD.
• Analytical and problem solving skills in Business Objects with ability to assess user requirements.
• Experience with SQL SERVER 2000/2005 and Oracle 8i/9i/10g/PL/SQL as backend.
• Experience in gathering customer requirements and functional requirements and converting them to technical requirements.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

Operating Systems: Windows 95/ 98/ 2000/ 2003/ XP/ NT, DOS, Unix.

Programming Languages: C, C++, VB, Java and C #.

Web Technologies: HTML, XML, XSLT, DHTML, SOAP, UDDI, and XSD.

Script Languages: Java Script, VB Script, and AJAX.

DSS Tools: Business Objects XIR4.0/XIR3.1/R2/6.x/5.x (Supervisor, Designer, Business Objects, Web Intelligence 2.x/6.x/XI, Broadcast Agent, BO SDK, Webi SDK, Business Miner, Info view 1.0), Crystal Reports, Crystal Xcelsius, SQR, Desktop Intelligence, Web Intelligence Rich Client,Info View, Broadcast Agent, and CMC.

Packages: Microsoft Project, MS-Word, MS-Excel and MS-PowerPoint.

Databases: Oracle, MS SQL Server 2000/2005/2008 , Sybase, MS Access.

Version Control Tools: Microsoft Visual Source Safe, Clear Case, Clear Quest.

ETL Tools: Informatica1.7 to 7.1, Data Stage, AbInitio

Reporting Tools: Crystal Reports, SQL Reporting Services, Active Reports.

PROFESSIONAL EXPERIENCE

Confidential, Berkeley

Sr. Business Objects Developer

Responsibilities:

• Interacted with business analysts in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Analyzed the existing database and designed the Universes using Business Objects Designer Module for generating reports.
• Designed, and managed Universes in BO Designer for creating reports against BW.
• Created New Classes, Objects, Resolved Loops, and Traps etc in designing the Universes.
• Created cascading List of Values and defined custom hierarchies in Universe Designer.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Defined Hierarchies in Universe to provide the users with Drill down option in WebI reports and Predefined Conditions to use in BOXI R3.1.
• Defined Aliases and Contexts to resolve loops in the universes.
• Applied security features of Business Objects like Row Level, Report Level & Object Level security in the universe so as to make the sensitive data secure.
• Worked on the tickets and recognized by users for resolving priority tickets promptly.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts Using different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports in WebI.
• Automated document Scheduling, Publishing and Distribution for WebI clients, using the Central management Console (CMC).
• Involved in migration of current Universes from BO 3.1 to BI 4.0
• Worked on Information Design Tool (IDT) and Universe design Tool (UDT)
• Design and develop WEBI reports in BO 4.0 to evaluate new feature and functionality to support the future upgrade.
• Created parameterized Crystal reports and customized existing reports for presentations using Summary reports, Detail reports and Sub-reports.
• Developed complex Crystal reports with dynamic cascading parameters and Cross-tab reports.
• Designed, developed, maintained and tested Universes for supporting adhoc queries.
• Migrated Universes and reports from development to Unit testing and production environments.
• Worked with Crystal Reports for creating complicated reports including sub-reports, cross-tab reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Developed Crystal Reports to report on Campus Constituent Summary and All Parent Details using Crystal Reports 2008
• Designed, developed, and tested complex queries for Crystal Reports Distribution.

Environment: Business Objects 4.0/XI 3.1, Oracle 10/11g, Crystal Reports 2008, Designer, Info View, SQL Developer.

Confidential, San Francisco, CA

Sr. Business Objects Developer

Responsibilities:

• Provided technical documents and updated with recent changes and test cases
• Generated WEBI reports with Universes created in Business objects Designer as the data providers with various functionalities that displayed data even in a graphical Format.
• Resolved issues like loops by creating aliases and contexts as required removing the cyclic dependencies.
• Extensively worked with the performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making the customized Query to the Report generated Query.
• Applied row level and object level securities to different groups to restrict the data in Supervisor module.
• Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.
• Developed Web Intelligence Reports with advanced features like drill down and drill filters.
• Created Web Intelligence documents and published them to corporate documents to share the resources between the user communities.
• Created New Universes and modified the existing Universes and used @functions like @select, @where and @prompt in the process of building the universes.
• Created different types of complex reports such as Master/Detail, Cross Tab and Charts.
• Created new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R3.1. (BOXI R3.1)
• Created Web I reports from multiple data providers and synchronized the data using merge dimensions option.
• Developed, tested and implemented new PL/SQL Packages, Functions and Stored Procedures, Triggers etc.
• Responsible for SQL tuning and optimization using Explain Plan and Indexes.
• Extensively worked with the performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making the customized Query to the Report generated Query
• Responsible for creating the Complex Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
• Migrated users/groups, Universes, Reports, connections to BO XI R3 using Import Wizard.
• Performed unit testing, system testing for universe, reports and security management.
• Trained the end users in working with the Business Objects user module, Dashboards and provided technical expertise.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

Environment: Business Objects Enterprises XI3.1 Suite (Central Management Server, Central Management Console, Import Wizard), Designer, Info-View, Reporter, Unit Test, Crystal Report, Web I, Xcelsius 2008, QAAWS, SQL server, SDK .

Confidential, Phoenix, AZ

Sr. Business Objects Developer

Responsibilities:

• Analyzed Business requirements, clarified Business rules, functional requirements and data specifications for Business Objects universes and reports.
• Extensively worked with some issues while upgrading from BO version XI R2.0 to BO XI R3.1.
• Worked on installation and configuration of Business Objects XI R3 Enterprise Suite (Desktop Intelligence, Web Intelligence, Central Management Server, and Central Management Console).
• Created universes for supporting the new External Customer Reporting requirements.
• Added the classes and objects in the universe as and when necessary for the new reports.
• Extensively used the Sections, Breaks, Hyperlink and Alignments of the objects in the reports to match the business reporting templates.
• Created Derived tables in the universe to come up with complex data set that was required for complex reports.
• 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.
• Created Complex and Multi-Dimensional reports using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
• Developed reports using combined queries with UNION functionality.
• Created local variables with complex logics in the reports for calculating the metrics in the Order Express reports.
• Created complex formulae in the Web I report to dynamically change the column that need to be displayed in the table depending on the prompt values.
• Used advanced functionalities like Optional prompts, Hyper-linking. Used one query data element as filter in another query to get the respective data.
• Tested the report data by comparing with the data from the report with the SQL outputs from the database to ensure the quality of reports generated.
• Designed Test cases for SIT of Universe and Throughput Variance Reports for end users.
• Ensured the quality and timely delivery of all the important complex canned reports.
• Involved in migration and testing of Objects to PROD environment from DEV through QA environment using Import Wizard.
• Involved in the poc of Designing dashboards using QWAAS & Live Office connections to generate dashboards for Live Data.
• Worked with Xcelsius Web-connectivity components such as Web-Service Component, Live Office Connector etc. to establish live connectivity to the dashboards with the database tables, views and BO universes.

Environment: Business Objects Enterprises XI3.1 Suite (Desktop Intelligence, Central Management Server, Central Management Console, Import Wizard), Supervisor, Xcelsius, Designer, Reporter, Unit Test, Crystal Report, Web I, Sybase 12.5,SDK, Embarcadero DB artisan, UNIX.

Confidential, NY

Sr. Business Objects Developer

Responsibilities:

• System study, interaction with users, management and designing, coding, testing & implementation of the system.
• Involved in gathering user requirements.
• Created the Logical and Physical Model using classic Star-Schema.
• Defined categories of documents for different level of groups.
• Defined Complex Security set up for end users.
• Configured user rights and security.
• Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to BO XI r2 Universe designing and establishing BO environment.
• Designing, creating, enhancing, testing BO universe, reports.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports using Business Objects Full Client application.
• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Created the full client and Webi reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Used aggregate awareness in universes and Created Reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.,
• Identified the CTQ (Critical to quality) KPI’s and Metrics as a part of the requirements gathering.
• Worked with the end users to create extensive use cases for the dashboards.
• Tuned the reports for better performance using SQL.
• Designed templates for Webi documents and customized Webi Front Page.
• Involved in Business Objects 6.5 Broadcast Agent and Supervisor.
• Mentored other IT staff & Conducted Corporate for end users on Business Objects XI.
• Involved in server side components of Zero Administration Business Objects (ZABO) applications.
• Developed functions and procedures and change control documents for BO.
• Linked Webi reports for different hierarchies.
• Mentored other IT staff & Conducted Corporate for end users on Business Objects XI.
• Trained the user community in making use of universe to create and publish reports.

Environment: Business Objects XIr2/6.5, Web Intelligence, Informatica, ZABO, Desktop Intelligence, Unit Test, CMC, Broadcast Agent Server, TOAD, Oracle 10g, Xcelsius, WEBI SDK.

Confidential, Tempe, AZ

Business Objects/Crystal Report Developer

Responsibilities:

• Created Report templates, Summary Reports, Parameterized Reports and Cross-tab reports.
• Used Groups, formulas, running totals and summaries in the reports.
• Building Relationships between different tables according to requirements in database expert.
• Used cursors, Unions, Joins extensively in Stored Procedures.
• Resolved the Performance issues/Data issues with Reports and Procedures.
• Worked with different universes and used linking of different universes.
• Implemented different level of hierarchies for drill down reports.
• Involved in the complete Data Warehouse design process.
• Analyzed Data using Slice and Dice and Drill Mode etc and formatting Reports.
• Automated document Scheduling, Publishing and Distribution for Web I and Info view clients, using the Broadcast Agent for Web-Part Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc.
• Used various Functions like @Prompt, @Where, and @Select.
• Created customized existing reports using cross-tab reports, sub-reports and charts to present information
• Exported Reports into PDF and Excel from Enterprise and resolved formatting issues.
• Used Configuration Manager to configure the server settings and to start/stop the services.

Environment: Business Objects 6.1(Supervisor, Designer, Reporter), Web Intelligence, Xcelsius, Broadcast Agent, 3Tier BO, Oracle 9i/8i, MS SQL Server 2000, Windows NT, Unit Test, Windows 2000, Unix and Sun Solaris.

Confidential

Business Objects/Crystal Report Developer

Responsibilities:

• Created Report templates, Summary Reports, Parameterized Reports and Cross-tab reports.
• Used Groups, formulas, running totals and summaries in the reports.
• Building Relationships between different tables according to requirements in database expert.
• Used cursors, Unions, Joins extensively in Stored Procedures.
• Resolved the Performance issues/Data issues with Reports and Procedures.
• Worked with different universes and used linking of different universes.
• Implemented different level of hierarchies for drill down reports.
• Involved in the complete Data Warehouse design process.
• Analyzed Data using Slice and Dice and Drill Mode etc and formatting Reports.
• Automated document Scheduling, Publishing and Distribution for Web I and Info view clients, using the Broadcast Agent for Web-Part Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc.
• Used various Functions like @Prompt, @Where, and @Select.
• Created customized existing reports using cross-tab reports, sub-reports and charts to present information
• Exported Reports into PDF and Excel from Enterprise and resolved formatting issues.
• Used Configuration Manager to configure the server settings and to start/stop the services.

Environment: Business Objects 6.1, Web Intelligence, Xcelsius, Oracle 9i/8i, MS SQL Server 2000.