PROFESSIONAL SUMMARY:

• Over 6+ years of experience in BusinessObjects versions 4.0/ XIR3/R2/R1/6.5, Universe Designer, Desktop Intelligence, Web Intelligence, Import Wizard, and InfoView.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Design, Development, Testing, Migration, Security management and Production support on various platforms.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables. Experience includes designing, implementing and integrating various Data warehouse and Data Marts using Oracle10g, MS-SQL Server 2005/2008, and DB2.
• Expertise in building Universes (Business view of the database), retrieving data using Universes, Personal data files, Stored procedures and Freehand SQL methods and creating complex ad hoc reports using the BusinessObjects and Web Intelligence Tools.
• Effectively administered and supervised the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports through CMC and Supervisor.
• Extensively worked on SAP Life Cycle Manager (LCM) in migrating documents to different environments.
• Expertise in system integration testing (SIT) and user acceptance testing (UAT).
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Expertise in designing the Dashboards using Xcelsius(Live Office, QAAWS) for complex user requirements.

Tools: BusinessObjects XI, Supervisor, Designer, BusinessObjects Reporter, Auditor, InfoView, WebI, Deski, Import Wizard, Broadcast Agent, Report Conversion, Crystal Xcelsius, Central Management Console (CMC), Central Configuration Manager (CCM), Dashboards
Database Methodologies: Oracle10g/9i/8.i/7.i, MSSQLServer2000/2005/2008, DB2
Languages: SQL, PL-SQL, C, C++ 
Server Environments: Web logic, Tomcat, Web Sphere 
Version Control Tools: VSS, Rational ClearCase and ClearQuest, MKS

Professional experience:

Client: Confidential, Tulsa OK Feb 11 – Present
Employer: Confidential, Tulsa, Oklahoma
Project: Integrated Reporting System
Role: BusinessObjects Lead DeveloperConfidential is a Fortune 200 company with its core business dealing in naturalgas exploration, production, processing, and transportations. This project involved creating new universes as well was increasing the efficiency of pre-existing ones for the Midstream Division. Another aspect of the project was to provide a training seminar to power users on how to use Web Intelligence to create ad-hoc reporting. Meeting with users was key during this project because it helped in understanding the business, which in turn allowed us to provide further suggestions on what the Crystal/WEBI reports and dashboards should include.
Responsibilities:

• Integral role in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire portal. Involved in Business Process Analysis, Gathering Requirements, Developed and Implemented Data Warehouse and BusinessObjects application.
• Designed and developed Universes containing over 100 tables and over 1,000 objects.
• Linked and modified multiple Universes from different data sources using Information Design Tool.
• Implemented derived tables using free hand SQL in universe whenever doing so was necessary.
• Resolved loops, chasm traps, and fan traps, using aliases, contexts, as well as by making sure the necessary universe parameter options were selected.
• Created advanced WEBI Reports which contained cascading prompts, conditional formatting, input controls, tracked changes, and multiple queries.
• Created Xcelsius Dashboard’s using Live Office whichcontained pie charts, bar graphs, ling graphs, and drill down functionality.
• Trained users on how to use Web Intelligence reporting by providing a formal training session, and in addition recorded a summarized video of the lesson and provided power point slides which were put on the departments share point site.

Environment: BusinessObjects XI 3.1/4.0, Designer, Information Design Tool, Web Intelligence, Desktop Intelligence, Crystal Reports 2008/2011, InfoView, Dashboard Manager, SQL, Oracle 10g, SQL Server 2008, Xcelsius 2008, MS Excel, MS Visio.

Client: Confidential, Hartford, Connecticut Jun 09 – Jan 11
Employer: Confidential, Yonkers, New York
Project: Integrated Reporting System
Role: BusinessObjects Developer
Confidential is a Fortune 100 company which provides health care insurance and related services. The main objective of the project is to create a collaboration site for interactions of different teams. This assignment involved creation of multiple Universes and then developing Crystal and Web Intelligence reports based of those Universes for the Claims Division. Developed a deployment modelusingXI R2/R3, which would provide better security and protect highly sensitive data. Worked on data analysis, requirement gathering and specification development of reports.
Responsibilities:

• Involved in Requirement gathering, Analysis, Design, Development, Testing and Deployment of entire portal. Involved in Business Process Analysis, Gathering Requirements, Developed and Implemented Data Warehouse and BusinessObjects application.
• Involved in migrating the Universes and reports from BO 6.5 to BOXIR2/R3.
• Designed and Developed Universes using BusinessObjects 6.5/XIR2/R3.
• Implicated in the design of Universes, Classes, Objects, and Hierarchies for Multidimensional Analysis of the database using BusinessObjects 6.0 for production, technical, and sales department of the company
• Created cross-tab and master detail reports also represented the same as line charts/bar charts /pie charts.
• Created Joins, Contexts, and Aliases, for resolving loops, and checked the integrity of the Universes.
• Involved in 2 complete life cycle implementations of BW, including data modeling, transformation, loading (full/delta load) monitoring and modeling of Infocubes, ODS and Multi-providers.

Environment: BusinessObjects XI 3.1, Crystal Reports 2008, Designer, Web Intelligence, Desktop Intelligence, InfoView, Dashboard Manager, SQL, SQL Server 2005, Xcelsius 2008, MS Excel, MS Visio.

Confidential, Orlando, FL Feb 08 – Apr 09
Project: Integrated Reporting System
Role: BusinessObjects DeveloperIntegrated Reporting System is built to see an integrated view of customer and portfolio versus a system view, to aggregate user exposures across source systems, to view the customer in the context of the company relationship, to understand key portfolio segments, risk profiles and trends and to facilitateimproved client and user management, user monitoring and exception management.
Responsibilities:

• Involved in planning, development and creation of various reports based on Integrated Credit Reporting System
• Key person for administrating Universe and Supervisory Module.
• Creation of Universe in the Designer, connection to the Database, class and objects, joins, resolve loops using context and alias, custom hierarchies, and predefined filters.
• Key person for creation of user administration and new reports with formatting or standard templates, applying sorts, cumulative, calculations, breaks, and ranking to data and Opening, modifying, saving and sharing existing reports.
• Manipulating data through various presentation styles such as; charts, cross tabs, slice and dice, alerts, prompts, nested loops, and filter.
• Layout designing for various Reports in Business Object and Integration of reports. Coding, Reviewing, Formatting, Testing, Bug fixing & Integration with different classes.

Environment: BusinessObjects XI, XI R2, Crystal Reports 2008, Web Intelligence R2, SQL, Toad, Windows 2000/NT, MS SQL Server 2005

Confidential, Denver, CO Oct 07 – Jan 08
Role: BusinessObjects DeveloperConfidential is the nation’s fourth largest retirement plan and record keeper, and they offer annuity and life insurance products for individuals and businesses.This project involved creating a Universe and Crystal/WEBI reports which would track and compare profiles of customers who had either fixed, indexed or variable annuities.Responsibilities:

• Involved in several phases of Software Development Life Cycle (SDLC) which includes design, development and testing of the application.
• Installed BusinessObjects, created Repository and User Groups.
• Designed the Universe by creating the BusinessObjects data model, selecting/joining tables, Indicating cardinalities, created aliases to resolve the loops, used aggregate aware function and created the objects which are grouped into classes based on business functionality.
• Presented data in reports as per the User requirements using various BusinessObjects functionalities.
• Exported the Universe/Reports to the Repository/Broad cast Agent for automation.
• Involved in designing and developing of universes for report generation from warehouse databases using BusinessObjects.

Environment: BusinessObjects XI, Designer, Desktop Intelligence, Web Intelligence, CMC, Import Wizard, Crystal Reports XI, SQL, SQL Server 2005, Windows 2003 Server, MS Visio, MS Excel

Confidential, New York, NY Jan 07 – Sept 07
Role: BusinessObjects DeveloperResponsibilities:

• Developed BusinessObjects reports in DeskI and Web Intelligence.
• Created multiple Universes in Designer in secure connection as well as shared connection.
• Involved in system integration testing and user acceptance testing.
• Created Dashboards using Dashboard Manager.
• Periodical scheduling for reports to run automatically. Implementation and periodic maintenance, activity optimization of queries used in BusinessObjects and Web Intelligence.
• User Training on ad-hoc reporting and demonstrations for various universes at sites

Environment: BusinessObjects XI 6.5, Designer, Reporter, Supervisor, WebI, Windows 2003 Server, SQL, SQL Server 2005, MS Visio, MS Excel.

Education:Bachelor of Science