SUMMARY

• SAP Business Objects Consultant with 8+ years of IT experience in which about 5 years of solid experience in Data Warehousing, developing reporting solutions using BusinessObjects XIR3/XIR2/6.x.
• 1+ years experience on SAP integration with BusinessObjects product suite.
• Expert in Installation, Configuration, Administration and Security of BusinessObjects, Crystal Reports, Web Intelligence, Xcelsius and Integration Kit for SAP.
• Designing, Configuring and Managing Servers and Service properties in SIA, CCM and CMS.
• Strong understanding of DBMS, Data Warehousing and SAP BusinessObjects architecture.
• Extensive experience in development of OLAP and OLTP technologies.
• Knowledge of Data Warehouse Database modeling and approaches like Star Schema modeling, Snowflake modeling, Fact, Lookup and Dimensions tables.
• Experience in deployment of BusinessObjects and Web Intelligence from various Sources Oracle, TeraData, MS SQL Server, DB2, Sybase and Access.
• Full Life Cycle implementation in Business Intelligence projects using BusinessObjects, Crystal Reports, Xcelsius and SAP BW.
• Exposure with BusinessObjects Voyager analytical services, BW integration with Voyager, SAP Integration Kit, LCM and Federation concepts.
• Expertise in designing, developing and managing the BusinessObjects Universes.
• Good knowledge of Crystal Reports 2008 and Xcelsius 2008 for creating highly formatted Reports and Dashboards.
• Experience with Oracle/TeraData databases and Informatica PowerCenter tools.
• Exposure to SAP ERP (ECC), BW, Enterprise Portal, NetWeaver and ABAP.
• Experience with Production support, On-call rotation and Offshore Global Delivery model.
• Expertise in Training Users in BusinessObjects.
• Experience in interaction with the Business Analysts, identifying the needs and requirements of the System and involving in requirement study of the System.
• Excellent team player with ability to perform independently. Exceptional Communication, Analytical, Interpersonal and Presentation skills.

TECHNICAL EXPERTISE

BusinessObjects 6.x, XIR1, XIR2, XI3.1
Windows 2003 Server, UNIX, Linux, Solaris, IIS, Apache
Oracle, IBM DB2, SQL Server, MS Access, TeraData, Informatica, SAP BW, Data Integrator
Java, XML, PL/SQL, VB .NET, ABAP
Crystal Reports, Web Intelligence, Xcelsius, BusinessObjects Universe, InfoView, Voyager, BusinessObjects Explorer, Integration Kit for SAP Solutions, Live Office, SAP GUI, SAP Java Connector
Central Management Console (CMC), Central Configuration Manager (CCM), Server Intelligence Agent (SIA), File Repository Servers, Web Intelligence Servers, Crystal Reports Server, Desktop Intelligence Servers, Adaptive Servers, Event Servers, Program Job Servers, Destination Job Servers.

EDUCATION Master's in Computer Science.

PROJECT EXPERIENCE

Confidential, Bellevue, WA April 09 - Present
Sr. SAP BusinessObjects Consultant
Confidential USA is a cellular telecommunications provider and the United States based subsidiary of Confidential International AG, itself based in Bonn, Germany. Confidential USA is currently the fourth-largest wireless carrier in the U.S. market with 33.4 million customers as of the end of the third quarter of 2009 and annual revenue of US$21.9 billion for their 2008 fiscal year.
Responsibilities:

• Worked on BusinessObjects 3.1 / SAP BI integrationproject at T-mobile starting with planning, installations, integration, migration and development of BI layer.
• Laid out the detail Upgrade plan with study of BO 3.1 set up and the project plan for migration project for BO XIR2 to BO XIR3.
• Worked on BI reporting design based on SAP BI queries, multi providers, BEX queries, functions, filters, dimensions, OLAP cubes.
• Worked on performance, tuning for scheduled and preview of reports. Worked on Security setup, roles, user folder security and other administration tasks.
• Worked on WEBI server's memory consumption issues during WEBI services "starting" phase.
• Worked on architecture and planning of BusinessObjects 3.1 for DEV, QA and PROD environments.
• Designed, configured and managed servers and service properties in SIA, CCM and CMS.
• Worked with business users to define and understand data access and reporting needs and help business users for the reports requirements.
• Analyzing data and reporting requirements to recommend and design solutions through the creation of appropriate database structures, reports and query structures.
• Worked with Database design team to articulate the reporting needs using the DB tools and objects.
• Worked on proactive approach to develop the test scripts. Troubleshooting of the reports for the performance and better design by adding functions, parameters with subset of data.
• Worked on documentation, report design templates for user training and information.
• Responsible for overall BusinessObjects infrastructure maintenance, applying Patches, Service Packs, and Monthly HotFix (MHF) to upgrade the BO environment.
• Worked on 24/7 support model on rotation basis for BO environment performance and customer issues.
• Worked on Tomcat configurations and Web layer deployment of BusinessObjects InfoView and CMC.
• Worked on Administration tasks of BO such as security setup, creation of BO objects (folders, groups, scheduling of reports etc.)
• Interacting with the business team for the requirements gathering and other technical issues fixes in the environment.
• Worked on and release plans for the applications, actively involved in Data center moves and the disaster recovery failovers.
• Worked on bug fixes, guiding the team for the proactive approach and recommendations.

Environment: BusinessObjects 3.1, SAP BI, Oracle, UNIX, Solaris, Windows, Java, J2EE, IIS, Tomcat, WebLogic.

Confidential, Ann Arbor, MI July 08 - Mar 09
Sr. SAP BusinessObjects Consultant
Responsibilities:

• Worked on SAP connectivity integration with the BusinessObjects product suite.
• Installed and Configured BusinessObjects Enterprise XI Release 3.1, Crystal Reports 2008, Xcelsius Enterprise 2008, Live Office XI Release 3.1, Integration Kit for SAP Solutions XI Release 3.1, SAP GUI, SAP Java Connector, and SAP Transports (part of the Integration Kit for SAP Solutions).
• Enabled SAP authentication on BusinessObjects Enterprise XI 3.1.
• Configured the publishing of Crystal Reports in combination with SAP BI.
• Worked on BI reporting design based on SAP BI queries, multi providers, BEX queries, functions, filters, dimensions, OLAP cubes.
• Worked on performance, tuning for scheduled and preview of reports. Worked on Security setup, roles, user folder security and other administration tasks.
• Worked on architecture and planning of BusinessObjects 3.1 for DEV, QA and PROD environments.
• Designed, configured and maintained the security framework for the BusinessObjects repository. Prepared and created the users and groups, assigned profiles and security options, administering user accounts and privileges for repository users.
• Defined and configured Single Sign On security.
• Worked with business users to define and understand data access and reporting needs and help business users for the reports requirements.
• Analyzing data and reporting requirements to recommend and design solutions through the creation of appropriate database structures, reports and query structures.
• Worked with Database design team to articulate the reporting needs using the DB tools and objects.
• Worked on proactive approach to develop the test scripts. Troubleshooting of the reports for the performance and better design by adding functions, parameters with subset of data.
• Worked on documentation, report design templates for user training and information.
• Tracking of Critical BO and Crystal Reports patches.
• Responsible for overall BusinessObjects infrastructure maintenance, applying Patches, SP, and MHF to upgrade the BO environment.
• Managed and controlled BusinessObjects products, Universes, Documents, Repository Domains, Stored procedures.
• Worked on Tomcat configurations and Web layer deployment of BusinessObjects InfoView and CMC.
• Enabled Auditing databases and produced Auditing reports to capture user metrics around overall usage, no. of actions, refresh times etc.
• Interacting with the business team for the requirements gathering and other technical issues fixes in the environment.
• Worked on and release plans for the applications, actively involved in Data center moves and the disaster recovery failovers.
• Worked on Migration scripts, implementation scripts for BusinessObjects products.

Environment: BusinessObjects 3.0/3.1, SAP BI, Oracle, DB2, Java, J2EE, IIS, Tomcat, WebLogic, UNIX, Windows

Confidential, Overland park, KS July 07 - June 08
BusinessObjects Consultant
Confidential is a telecommunications company and offers a comprehensive range of wireless and wireline communication services to consumers, businesses and government users.
Responsibilities:

• Installed and configured BusinessObjects Enterprise XIR2.
• Applying the patches in cluster environment for Business Object Server, Crystal Enterprise Server and Crystal Reports.
• Designed, configured and managed servers and service properties in SIA, CCM and CMS
• Mapping the database fields after developing the reports or after adjusting report as per the client requirement.
• Migrated the Crystal Reports 8.5 to Crystal Report 10 and published the reports in Crystal Enterprise server.
• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.
• Customized the InfoView page with Company Logo, User required information and redeployed the WAR files.
• Publishing the reports and maintenance of daily, monthly and yearly.
• Configured the SMTP settings to send the reports to users email after scheduling the reports in Crystal Enterprise Server and Business Object Server.
• Defined the security model in Enterprise XIR2
• Created slides for data flow and process flows using PowerPoint and Microsoft Visio
• Designed, defined, developed, tested and maintained the universe and reports
• Using Import Wizard deploying the reports from Dev system to Test and to Production.
• Gathered the Users Information and Security levels in BO 6.5 to implement the new Security in BO XIR2.
• Defined the report deployment strategy
• Configured the Single Sign On in .net environment
• Created reports in Web Intelligence XIR2
• Added/created complex objects to the universe to enhance the report functionality.
• Optimized the usage of user objects, conditions and universe level filters
• Maintained existing reports and Created standard template for all reports.
• Involved in documenting the changes to the universe and reports functionality.
• Identified issues with some of the reports with ambiguous data and resolved the issues
• Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence
• Created Hierarchies to facilitate drill down
• Resolved the performance issues with the drill down reports
• Created Crystal Reports against the transactional databases.
• Worked on bug fixes, guiding the team for the proactive approach and recommendations.

Environment: BusinessObjects XIR2, Web Intelligence, Desktop Intelligence, Crystal Reports, Windows XP/2003/2000, Oracle

Confidential, Chadds Ford, PA May 06 - June 07
BusinessObjects Consultant
Confidential is a specialty pharmaceutical company in pain management. The Company is engaged in the research, development, sales and marketing of branded and generic pharmaceutical products primarily to treat and manage pain.
Responsibilities:

• Installed and configured BusinessObjects Enterprise XIR2 Professional edition in test and production environments.
• Troubleshoot the issues during the installation process.
• Migrated BusinessObjects 6.5 version reports to BusinessObjects Enterprise XIR2.
• Migrated Crystal Reports to BO XIR2.
• Tested the BusinessObjects XIR2 migration to ensure the reports are functioning as per expectations.
• Created new security for the migrated reports and users.
• Scheduled the crystal reports to users by email
• Resolved issues that were raised during the scheduling
• Created a document for the migration of BusinessObjects 6.5 to BusinessObjects XIR2.
• Wrote a BusinessObjects best practices document.
• Utilized the capability of Aggregate Awareness to improve on query performance.
• Created Hierarchies on Region and Time classes and created customized LOVs.
• Resolved the Loops by using Aliases and Contexts.
• Created customized prompts, cascading prompts and GUI based prompts with VBA macros also developed the customized tool bars and functions to export to excel.
• Developed Statistical Process Control Charts -SPC Analysis and standard control charts, hazard plots, and automated reports.
• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.
• Generated ad hoc and canned reports for BusinessObjects.
• Created reports for various portfolios using universe as the main data provider.
• Created and tested reports using BusinessObjects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Created graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Developed Desktop Intelligence and Web Intelligence reports.

Environment: Oracle 9/10g, BusinessObjects 6.5, BusinessObjects Enterprise XIR2 Professional, BusinessObjects Designer, Web Intelligence, and Desktop Intelligence, Windows XP/2003.

Confidential Jan 05 - Apr 06
BusinessObjects Developer
Confidential is the first private sector biological products company in India and the first pharmaceuticals company in South India. BE is also the pioneer in preventive medicine.
Responsibilities:

• The project scope was to develop sales and financial reports using Crystal Reports with Oracle as a database.
• Interacted with Business Users to gather, analyze and record requirements/specifications.
• Worked on Administration/Installation of BusinessObjects, Web I, Info View on Windows Server and creation of Groups and Users.
• Designed universes with several classes and objects. Row level and Object level securities were implemented.
• Maintaining customers Issue log and responding to issues.
• Created complex universe for Dashboard manager specific for creating metrics for developing analytics which will be placed on dashboard.
• Detected Cardinalities and Loops. Resolved loops using aliases and contexts.
• Handled Embedded Functions like @Prompt, @Select and @Where in the Designer to handle user requests for report generators.
• Linked universes to share the common components using kernel approach.
• Created complex reports using BusinessObjects functionality like Slice and Dice, Drill Down, Drill Up and Ranking.
• Integrated reference data into dimensional schema via Informatica PowerCenter for consumption.
• Using Informatica Designer designed Mappings, which populated the Data.
• Aggregate awareness functions of BusinessObjects are used to route the query objects through most appropriate path while selecting from multiple contexts.
• Applied breaks on reports to get appropriate results and created cross tabs.
• Generated Pictorial views in the form of graphs, pie charts and cross tabs from existing reports and Chart wizard.
• Setting up and administering the Broadcast Agent. Worked with Broadcast Agent (BCA) to schedule reports on monthly and weekly basis.

Environment: BusinessObjects 6.x, Web Intelligence, Informatica PowerCenter, Crystal Reports, Oracle, PL/SQL, SQL*Plus, Windows.

Confidential June 01 - Dec 04
Oracle DBA
Confidential is a wholly owned subsidiary of Siemens Ltd., the regional company of Siemens AG in India. SISL provides IT services and solutions globally.
Responsibilities:

• Managed Oracle database servers for Siemens Financial Services.
• Designing/installation/configuration/adminitration/troubleshooting of production and development Oracle based systems on operating systems: UNIX/Linux/Windows.
• (SQL) performance tuning of Oracle systems, supporting Oracle developers.
• Allocating system storage and planning future storage requirements for the database system.
• Creating primary database storage structures (tablespaces) after application developers have designed an application.
• Creating primary objects (tables, views, indexes) once application developers have designed an application.
• Modifying the database structure, as necessary, from information given by application developers.
• Enrolling users and maintaining system security.
• Controlling and monitoring user access to the database.
• Monitoring and optimizing the performance of the database.
• Backup and recovery day-to-day related tasks (RMAN).

Environment: Oracle, UNIX, Linux, Windows