• About five years of IT experience in business analysis, database design, development, reporting primarily using Business Objects product suite (XI R1\\ R2 \\R 3.1 ) and application development using C# , ASP.NET VB.NET , IIS 6.0.
• Expertise in Installation, Configuration , SSO and troubleshooting Crystal Reports, Business Objects and Migration from Business Objects 6.x/5.x to XI Release.
• Expertise in Business Objects administration tasks including configuration, deployment, user security, groups, associated privileges and performing backups of the application.
• Strong experience in design, implementation of Business Objects security model and maintenance of BOE user groups and content.
• Proficient in carrying out Administrative tasks using BOBJ tools like Infoview, CMC, CCM, CMS, Instance Manager, Import Wizard and Publishing Wizard and Business View Manager
• Hands on experience in creating dashboards/visualizations using Xcelsius 2008, Live office & QAAWS.
• Experience working with a variety of databases such as Oracle, SQL Server, MySQL and MS Access and proficient in creation of Tables, Views, Indexes, Stored Procedures, Functions, Triggers and Packages using SQL, PL/SQL and T-SQL.
• Expert in designing and implementing a Backup and recovery model for BOBJ application. Exposure to integration and customization of BOBJ application with SAP BW and websphere portal server.
• Proficient in developing Crystal Reports which included Standard, Cross-tab, Summary, Sub Reports and Charts using Parameters, Complex Functions and Shared Variables
• Experience in Designing/Developing Complex Universes using Star, Extended Star and Snow Flake Schemas and in developing canned and ad-hoc reports using Business Objects and WebI tools.
• Strong Knowledge of Infrastructure Processes – Incident, Change and Asset Management.
• Excellent ability in writing specifications, interviewing clients and gathering requirements to develop Crystal Reports as per the needs of the client and maintain documentation of the reports for future reference.

• Bachelor Degree in Computer Science Engineering.

Confidential, Schaumburg, IL
Role: Business Objects Support Administrator Duration: Oct 2010 - till date

Responsibilities:

• Primarily responsible for Planning, installation, configuration of the BOE 3.1 environment components. Configuration includes clustering, Single signon and service parameters tuning under the direction of BOE architect.
• Administered Servers, Server Groups, Universes and Connections using Central Management Console (CMC) and Central Management Server (CMS).
• Migrated Objects between environments using tools like publishing wizard & Import wizard for migration of reports, universes with BIAR files
• Carried out administrative tasks like Scheduling / Re-Scheduling reports using Schedule manager and managing instances using Instance Manager.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Developed project scope documents and detailed design documents for the project according to the requirements.
• Identified existing reports that are to be consolidated and developed new reports applying report consolidation processes to increase usability and maintainability.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Involved in the design and development of various data models and database objects such tables, views, indexes, stored procedures and triggers that are used for report generation using PL/SQL.
• Developed complex crystal reports involving Dynamic and Cascading Parameterized reports, Drill-through reports, Cross Tabs, Sub reports and Graphical reports that utilize crystal reports formulae, running totals, command objects and stored procedures.
• Generated drill down reports and worksheets with OLAP Intelligence Cubes using objects, members, filters and exception highlighting.
• Created Business Views with Business View Manager to develop crystal reports from multiple data sources.
• Involved in troubleshooting broken reports and fine- tuned complex reports to improve performance.
• Published Crystal reports to Business Objects Enterprise systems using Publishing Wizard.
• Developed Universes with alias tables and implemented various types of joins including equi-join, outer-join, theta-join, self-restricting join and defined cardinalities between facts and dimension tables.
• Resolved cyclic dependency problems like Loops, Fan traps and Chasm traps by creating aliases and contexts.
• Created canned/ad-hoc reports using Desktop Intelligence (DeskI) from multiple data providers.
• Created Web Intelligence (WebI) Reports from multiple data providers and synchronized data in these reports using the Merge Dimension feature in WebI.
• Created (Master/Detail, Cross tab, Chart templates) reports using Desktop Intelligence and Web Intelligence.
• Developed documentation to provide detailed instructions to users on how to schedule, run and review Crystal reports using Infoview.
• Provided on call support and timely assistance for clients with database related issues including data transforming and data loading.

Confidential, Saint Louis, MO
Role: Business Objects Support Administrator Duration: Aug-2009 – Sep 2010

Responsibilities:

• Participated in requirements gathering and developed the project scope document and detailed Technical Specification documents.
• Analyzed existing Oracle BI reports that are to be migrated and developed them in Crystal Reports.
• Developed Monthly Financial Statement reports, Key financial Indicator Graphs & Monthly Financial Support Schedules using Crystal Sub reports for the Accounting Department.
• Created reports such as Balance Sheet, Patient Activity, Income Statements, Cost per Case, Operating Cash flow Margin …etc Crosstab and Sub reports for the Finance Department.
• Developed reports and graphs with OLAP cubes using OLAP dimension slices, pages and OLAP grids for proving business analysis metrics.
• Performed gap analysis of existing Oracle BI reports and identified the changes that are to be made to these reports.
• Modified several Oracle BI reports such as Accounting Reports, Payroll Reports, Monthly / Quarterly / Annual Financial Reports …etc as per the user requirements.
• Administered the Oracle BI Enterprise Data mart application and carried out tasks such as creating dashboards, dashboard pages and grant user access permissions for each dashboard/page as per the user request.
• Migrated existing Crystal reports from Crystal Enterprise 10.0 to Business Objects XI R2 using Import Wizard and resolved issues related to report distribution and security.
• Carried out maintenance tasks such as upgrades and enhancements to Parameter Lists, Filters, Reports and Folders in OBIEE using the Oracle Catalog Manager.
• Carried out administrative tasks such as Adding / Deleting Users and Groups to the Data mart.
• Developed Stored Procedures and Views on Oracle 10g database using SQL Navigator which are utilized in several reports.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Developed several new data base tables and coordinated data load data operations.
• Created Business Views, generated dynamic cascading prompts with list of values (LOVs) using Business View Manager to develop crystal reports from multiple data sources.
• Created WebI reports using Breaks, Prompts, Slice/Dice, Alert, Custom Sort and Drill down features from multiple data providers.
• Published Crystal reports to Business Objects Enterprise using Publishing Wizard.
• Managed Servers, Groups & Connections using Central Management Console (CMC) and Central Management Server (CMS).
• Involved in migration of existing Crystal Reports, Users, profiles, documents and Groups from BO XI R2 to BO 3.1.
• Published and scheduled Crystal Reports, WebI and DeskI documents with document merging using BO 3.1.
• Conducted knowledge transfer sessions on Crystal Report scheduling in Infoview.
• Developed documentation to provide detailed instructions to users on how to embed, run and print Crystal reports deployed on to the Dashboard.

Confidential, Plano, TX
Role: Business Objects Consultant Duration: Aug 2008 – July 2009

Responsibilities:

• Performed gap analysis of existing canned reports and identified the changes that are to be made to these reports in accordance to the changes in the Meridium Application.
• Worked closely with Global Refining team, HR team and Subject Matter of Experts (SMEs) to identify new KPIs (Key performance Indicators) which will be used in developing new reports.
• Modified existing database objects to accommodate newly identified attributes as per the KPIs.
• Migrated existing Crystal reports from Crystal Enterprise 10.0 to Business Objects XI R2 using Import Wizard and resolved issues related to report distribution and security.
• Created Data Connections, Data Foundations, Business Elements and Business Views using Business View Manager.
• Used Business View Manager to create list of values (LOVs) for generating cascading dynamic prompts.
• Developed various complex crystal reports including Drill-down reports, Conditional reports, Cross-tabs reports, Parameterized reports, Summary reports, Charts and Sub reports using Business Views, dynamic prompts, command objects, running totals, stored procedures and views.
• Published Crystal reports to Business Objects Enterprise using Publishing Wizard.
• Created dashboards with Crystal Xcelsius using gauges, alerts, sliders, selectors and charts to present complex data in an easy to visualize format.
• Developed new universes utilizing asset management master tables from Meridium Application.
• Resolved Fan Traps, Chasm Traps and loops by setting cardinalities manually, using context and aliasing.
• Created canned/ad-hoc reports using Desktop Intelligence (DeskI) and Web Intelligence (WebI) Reports from multiple data providers through Infoview.
• Created reports using Business Objects features like Slice/Dice, @Functions, Drill Down, Prompts, Breaks, Custom Sorts, Conditions, Ranking, Filtering, Master/Detail, Cross tab etc and highlighted data with Alerter as per the business requirements.
• Converted existing DeskI reports to WebI reports using Report Conversion Tool.
• Developed detailed documentation for report users describing how to schedule, run and view Crystal reports using Infoview.
• Involved in providing support to client by troubleshooting broken reports with Crystal Reports 10.
• Mentored and trained junior developers and conducted knowledge transfer sessions.

Confidential, Bangalore, India
Role: Report Developer Duration: Aug 2007 – July 2008

Responsibilities:

• Involved in the full life cycle of the Business Objects reporting application development.
• Interacted with the client to gather requirements and perform technical requirement analysis.
• Developed various complex crystal reports to display the sales orders, deliveries, pending bills from customers, shipped orders and outstanding dues.
• Improved report performance for poorly performing reports by replacing in-report data filtering logic with stored procedures.
• Communicated with the database team to setup new schemas, configuring the database and performance tuning the database as per the reporting needs.
• Worked on SQL, PL/SQL for writing Stored Procedures, Packages, Functions and Database Triggers.
• Created reports using multiple data providers and synchronized them into one report by linking the common dimensions.
• Report submission, distribution and scheduling the full client reports and WebI reports using Broadcast Agent (BCA).
• Developed test plans for unit testing and participated in the creation of deployment plan for production release.
• Involved in on call support for troubleshooting crystal reports and database related issues.