• 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.
• 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.
• Proficient in developing Crystal Reports which included Standard, Cross-tab, Summary, Sub Reports and Charts using Parameters, Complex Functions and Shared Variables
• 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.
• ETL design and implementation involving the extraction of data from a variety of legacy systems, integration, and cleansing of data before loading into data warehouses.
• Strong experience in using SAP Business Objects Data Services and Data Quality
• 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 Data services Developer Duration: Oct 2010 - till date

Responsibilities:

• Developed project scope documents and detailed design documents for the project according to the requirements.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Identified existing reports that are to be consolidated and developed WEBI/Crystal/DESKI reports applying report consolidation processes to increase usability and maintainability.
• Developed universes using derived tables and also used aggregate_awareness functions in it to improve the performance.
• Supported multiple universes by modifying existing contexts and alias tables.
• 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.
• Generated drill down reports and worksheets with OLAP Intelligence Cubes using objects, members, filters and exception highlighting.
• Involved in troubleshooting broken reports and fine- tuned complex reports to improve performance.
• Published Crystal reports to Business Objects Enterprise systems using Publishing Wizard.
• Integrated data from various sources utilizing Data Integrator Real and batch components.
• 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.
• Analyzing and existing ETL jobs Real Time and Batch Jobs and also be able to build new transformations
• 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.
• Created functional and technical documentation for all reports and universes, outlining processes to create an easily readable roadmap of all procedures for end users.
• 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.

Confidential, Saint Louis
Role: Business Objects Developer 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: Business Objects Developer Duration: Aug 2007 – July 2008

Responsibilities:

• Participated in requirements gathering and developed detailed Technical Specification documents.
• Designed numerous Crystal Reports including cross tab reports, drill-down reports, summary reports and parameterized reports from tables, views and stored procedures according to the business requirements.
• Used SQL, T-SQL to develop Views, Stored Procedures and Functions which in turn were used to create reports.
• Involved in integrating Crystal Reports into ASP pages and setting up Viewer for the management to view the reports.
• Communicated with the Front-end Development team and other programmers to guide them with integrating the Crystal Reports into an intranet web application.
• Developed dashboards from excel spreadsheets and exported them in various formats (HTML, PDF, SWF) to leadership using Crystal Xcelsius.
• Involved in installation of Live Office plug-in and used it to embed data directly from Business Objects Enterprise (BOE) into Microsoft PowerPoint and Word.
• Involved in performance testing of all the reports, which helped in analyzing and improving report response time before moving into production.
• Analyzed SQL statements by using SQL Trace and TKPROF utilities to monitor and tune SQL queries running against the Oracle Database.
• Created complex Business Objects WebI reports using features like Sections, Slice/Dice, Breaks, Alerts, Prompts, filters, drill down reports by using Multiple Data Providers.
• Developed detailed documentation to guide users on how to use the new features that are available in Crystal Reports 10.0.
• Provided on call support in dealing with reports created with Crystal reports 10.0, database objects and loading batch jobs.