Professional Summary

• 9 years of experience in Business Objects.
• Well versed in Business Objects (XI R2, 6x and backwards) with experience in Supervisor, Designer, Reporter, BCA Server (Publisher and Scheduler), Web Intelligence 2.5/2.6.1/6.0/XI R2, Info view, Application Foundation, Dashboards, Auditor and Schema Design.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
• Good knowledge in the migration of BO environment from 6x version to XI R2 version.
• Hands on knowledge of Business Objects XI 3.0 vesrion.
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Worked on Web Intelligence (Webi), Desktop Intelligence (Desk I) to develop and publish reports.
• Good knowledge and experience in using Teradata,DB2, Oracle 10g/9i, MS SQL Server 2000/2005, MS Access, TOAD,PL/SQL Developer, Query analyzer.
• Experience in developing SQL, PL/SQL procedures, database triggers and other components of database applications.
• Experienced in SQL and Performance and Tuning
• Created complex reports with multiple data providers/multiple universes/multiple data bases (Teradata, Oracle, SQL server, DB2).
• Excellent understanding of Online Transaction Processing (OLTP),Data Modeling, Star Schema, Snowflake . Fact, Lookup and Dimensions Tables
• Exposed to Data Warehouse assignments in various domains like Mortgage, Medical services, Sales, Insurance, Financial & Bank, Data warehouses.
• Excellent interpersonal, communication and presentation skills.

OLAP Tools:

Business Objects XI R3/R2/6.x/5.x/4.x, Web Intelligence 6.x/2.x, Infoview, Broadcast Agent, Application Foundation

Reporting Tools:

Business Objects, Crystal Reports, Excel 2000/XP

Database(s):

ORACLE 10g/9i/8i, MS SQL Server 2000, MS Access

Front End Tools:

TOAD, SQL* PLUS, PL/SQL Developer.

Programming Languages:

C, C++, SQL, PL/SQL

Operating System:

Windows 95/98/2000 /NT/XP, UNIX

Office suite:

MS word, excel, PowerPoint

Project Mgmt Tools:

Clear Quest, Req Pro, Documentum , Mercury, Peregrine

EXPERIENCE

Confidential,CHICAGO, IL Jan 09-Till date
Sr. Business Objects/ Crystal Reports Consultant.
Confidential,is the premier association of health information management (HIM) professionals.
Developed reports on “Personify” a .NET based application which is replacing legacy system IMIS. Converted all the existing Cognos and Access reports to Business Objects reports.

Role:

• Interacted with Business Annalist to know their Business views to create universe, Reports accordingly.
• Responsible for Maintaining the Environments Dev, Test like promoting the Business Objects contents across environments using Import Wizard, creating the BIAR File backups on regular basis etc.,
• Reports are developed for Publications, Financial, Membership, Certification Departments.
• Created universe, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Resolved loops using contexts to remove the cyclic dependencies.
• Created Measure class for measures, and created separate class for conditional objects.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
• Extensively used Designer to design various universes for different business groups.
• Created complex reports using cascading prompts, decode objects using both full client and thin client reporter.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Created custom hierarchies which help the end user to drill down to lower levels.
• Extensively used breaks for white spaces and sections for better navigability.
• Created template documents with header, footer and company logo.
• Created Crystal reports depend upon end user needs.
• Worked extensively with @functions like @select, @prompt, @where and @aggregate aware to write flexible SQL queries.
• Changed List of Values (LOV) in the universe prompts
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerters, inserted Calculations, Filters, Sorts, and Query Prompts.
• Created standard full client reports and Improved report response time by tuning BO queries.
• Used mainframes reports and files to compare values with BO reports.
• Tested reports and involved in trouble shooting.
• Exported the Universes and reports to the Repository to make available resources to the users.

Environment: Business Objects XI-R2, Crystal Report XI R2, MS Access, SQL Server 2005, IMIS, Personify, SQL Server Mgt Studio, Windows XP.

Sr. Business Objects/ Crystal Xcelsius Consultant.

• Created user/user groups through Central Management Server(CMS) and involved in giving privileges to these groups.
• Using CMS maintained all the universe, webi, Deski, dash boards across different environments and given security privileges to different users in different departments.
• Migrated the whole project from Business Objects 6.5 to Business Objects XI R2.
• Using Import Wizard migrated the reports and universes across DEV, UAT and FIT.
• Thorough understanding of different functional components of logistics department
• Involved in design and development of universes and reports for different KPIs like OTD, OTS, TU, OAD Etc.,
• Interacted with Business Analysts, Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements

for developing universes and reports.

• Interacted with the Data Warehouse team and suggested ideas to improve the model of

the Data Mart, which can help in tuning the SQL and improve the performance of
generating reports.

• Created object level and row level securities in Designer using security restrictions

option.

• Involved in the troubleshooting of Universe schema with loops, chasm traps, fan

traps and cardinality problems and checked Integrity of the Universes.

• Set up Universe level conditions to restrict data based on report requirements.
• Extensively used Business Objects to design and develop various Tabular, cross tab

and Chart reports to be used by various User Groups.

• Created complex reports using cascading prompts.
• Worked on performance tuning of queries for faster execution of reports on

Oracle10g.

• Created reports using Derived tables.
• Worked extensively with @functions like @select, @prompt, @where and aggregate aware to write flexible SQL queries
• Created complex reports using cascading prompts, decode objects using both full client

and thin client reporter.

• Created different types of reports, like Master/Detail, Cross Tab and Chart (for

trend analysis). Used filters, conditions, calculations etc.

• Created reports using combined queries like Union, Intersection, minus.
• Created Xcelsius Dashboards for logistics department using different chart types and tables on national, regional level.
• Involved in data mapping session from the SAP BW extractors.
• Created Oracle tables, views for the SAP BW extractors.
• Created a Prototype universe for the SAP BW extractors.
• Involved in testing of data from the SAP system with the legacy data.
• Coordinated with DBA and Business objects designer group in solving various technical issues
• Train and educate end users about the use of universe and generation of reports.

Environment: Business Objects XI-R2 /3.0 suite, 6.1a, webi XI, Crystal Xcelsuis 4.5/2008, MS Access, Oracle 10g, SAP BW, Ab Initio, Windows XP.

Role:

• Used Import Wizard in migrating the Webi and Crystal Reports into one Crystal Enterprise repository.
• Created Corporate dash board through Dash board Manager, created Metrics and used different analytics in displaying the Business requirement of the company.
• Thorough understanding of different functional components of financial warehouse
• Involved in design and development of universes for different component models like CAM, CAX, TAX, TRD, SLR, Settlement.
• Has Experience in Financial Data created reports based of EPM/FMS data like EPM Attestation and Balances reports
• Worked on Creating Reports on Budgeting/Scheduling/Forecasting using BOXIR1/BOXIr2/Src tool
• Worked as a Business Analyst in gathering Analyzing and Creating Business Specs for creating Report specs
• Created many adhoc/Canned reports based of different Component using Business objects XIR2. WebI was used as the main tool.
• Also Created reports using Crystal XI by using universe or Business view as the data source
• Used Import Wizard in migrating the Webi and Crystal Reports into one Crystal Enterprise repository.
• Used different functionalities of WEBI like Breaks, Sorts, Filters, Merged dimensions, Sections in creating complex reports
• Created Customer Hierarchies and used scope of analysis for drill down of data purpose
• Created Classes, Objects in universe for Oracle and using Business Objects XiR2 and exported to the repository
• Tested the Universes and Reports in different environments for the data representation and the performance issues.
• Has worked on End user computing and G/L data. Involved in creation of P&L Report.
• Used Requisite Pro software in Creation of Report spec and also Defect tracking.
• Used CVs for Version of Crystal report and EBI for versioning Webi/Deski Reports.
• Fine tuned universes and created new classes/objects to incorporate additional functionalities for report generation
• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports
• Created tables to extract model year related cost details from database
• Generated complex reports involving numerous prompts and linking several data providers
• Created complex variables, breaks, sorts, filter and conditions for various reports
• Extensively used extended syntax and complex formula to calculate cost at differing hierarchies
• Designed and created several classes and linked them to existing universes using complex join conditions
• Integrated and upgraded existing reports with added functionalities for comparison and cost-time trend analysis
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of comparison reports.
• Experience in Performance Tuning and Optimization of SQL statements
• Used several complex control structures to enhance the functionalities of existing reports
• Coordinated with DBA and Business objects designer group in solving various technical issues

Environment: Business Objects XIR1/XIR2, Oracle 10G/9i Web intelligence 2.x/6.x, Crystal Reports XI, intellimatch, SRC, Toad, Informatica, Erwin 4.0, VBA Macros, Req pro, EBI, CVS

Confidential,is one of the largest electric utilities firm in the United States, delivering electricity to more than 5 million customers in 11 states. Data ware houses was developed using Informatica as the ETL Tool. Business Objects was used for reporting purposes to identify trends and to facilitate information sharing.

Responsibilities:

• Involved in Full project life cycle (requirement gathering to implementation phase).
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and Detailed Design documents.
• Created derived tables at the universe level to reduce the complexity of universe building.
• Specified the standards for universes, Classes, Aliases, Simple and complex objects.
• Created filter objects, and formatted objects and measures within the universe for faster report generation.
• Created Measure class for measures, and created separate class for conditional objects.
• Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
• Extensively used Designer to design various universes for different business groups.
• Created complex reports using cascading prompts, decode objects using both full client and thin client reporter.
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Created custom hierarchies which help the end user to drill down to lower levels.
• Extensively used breaks for white spaces and sections for better navigability.
• Created template documents with header, footer and company logo.
• Used Broadcast agent for report bursting for different business groups.
• Extensively used Web Intelligence Info view, reporter and explorer for querying, reporting and analysis tasks.
• Used schedule manage to schedule reports on timely basis
• Created reports prototypes using Web Intelligence XI for user presentation.
• Created object level and row level securities in designer using security restrictions option.

Environment: Business objects 6.5.1/XI r2, Web Intelligence 6.5/XI r2, Broadcast Agent, DB2, Informatica Power center 7i, Window 2000 Server.

Confidential,is the second largest hamburger restaurant chain with $11 billion in
annual sales and more than 11,100 restaurants worldwide. Data Ware House was
developed using Informatica as the ETL tool and reports developed by Business
Objects for the sales and analysis purpose.

Responsibilities:

• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Design and Development of Business Objects Universes, which suits the standard,

analytical and ad-hoc reporting requirements of the Business Objects users

• Involved in the designing and Building of Universes, Classes and objects
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Worked on the Master, Kernel and Component approach during the linking of universes.
• Created and tested classes and objects to organize the universe.
• Exported the universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the various data Providers like Free

Hand SQL, Stored Procedures, VB procedures.

• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc
• Created reports using Info View and ZABO for distribution to users
• Created Schedulers to monitor Broadcast Agent.
• Built full client and WEBI reports.
• Set up groups and users for Business Objects deployment. Managed user profiles using Supervisor
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler

Environment: Business Objects 6.5.1/XI, Web I 6.5, Designer, Supervisor, Broadcast Agent, ZABO, Info view, SQL Server 2000, Query Analyzer and Windows NT.

Confidential,a Fortune 300 company based in Reston, VA, is a leading provider of fully integrated, wireless communications services. The project scope is to design and build reports for decision support for personal and phone usage data. Application provides revenue information and tracking system for their customers call time in minutes for billing as part of the contract. Reports were made to facilitate the end user to extract the true up and customers’ liability as well as give detail customer information, Service usages, Billing information, and account details.

Responsibilities:

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Specified the Joins, checked the cardinalities and resolved loops by either using Alias or Contexts.
• Created and set up BO’s Universes for each reporting group and established a BO environment.
• Created different types of reports in different departments, such as Master/Detail, Cross Tab and Chart (for trend analysis) in sales, Marketing Production departments.
• Applied slice-and-dice and drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Worked closely with executive sponsors and user decision makers to develop the transformation logic to be used in Reports.
• Worked extensively in administration and supervisor modes to install, configure and maintain Business Objects.
• Extensively worked on Broadcast Agent server and customized scheduling and publishing reports.

Environment: Business Objects 6i, Oracle 8i/9i, Web Intelligence 6, Unix.

Confidential,India Oct’99 – Nov’02

• Involved in migration from Business Objects 5.1.4 to Business Objects 5.1.7.
• Good knowledge in using Normalization techniques.
• Created predefined conditions for users allowing them to construct complex reports using the predefined conditions
• Set up aggregate awareness for objects
• Linked universes using both Kernel and Master approaches
• Generated reports using Web Intelligence through Infoview
• Created dashboards and scorecards integrating reports using Business Objects dashboard manager

Environment: Business Objects 5x, Web intelligence 2.7, Infoview, Application
Foundation, Oracle 8i, MS Access 2000, C, SQL, PL/SQL, UNIX, and Windows 98.

Education: Bachelor of Engineering in Mechanical Engineering.