Untitled Document

Over 8 Years experience in Information Technology Industry out of which nearly 7 + Years experience into design, migrate, create and modify Business Objects Universes and Reports. Have extensive working knowledge of all stages of Business Intelligence development in finance, retail, manufacturing, insurance and healthcare Industries. An effective communicator with client and team members, easily interfacing between the technical and non-technical users.

Professional Summary

• Expert in Business Objects BO 4.0/XI 3.1/ 3.0/R2/6.5.
• Experience with Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
• Installed and tested the BI4.0 application on sandbox.
• Worked with server team to provide them with list of specifications need to build the servers for BO4.0.
• Worked with Developers to consolidate the Business Objects repository before migrating to BO4.0.
• Expert in designing, developing, maintaining and optimizing the Universes using Designer module.
• Substantial experience in Business Objects Migration (5.1, 6.5 to XIR2/3.0/3.1/4.0).
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Knowledge about Business Objects Security Model and experience with Business Objects Security Implementation (Row level, Object level, Command level in both 6.5 and XIR 2).
• Expertise in working with all the modules of Business Objects (All Versions including XIR3) like Supervisor, Designer, BO User, Web Intelligence, Desktop Intelligence, CMC, CMS, BCA, BO SDK and Crystal Reports.
• Expert in implementing aggregates, linked universes, drill-through and dynamic modules.
• Experience in Training & Supporting end-user reporting needs using Business Objects.
• Experience with Data Integrator for ETL (Extraction, Transformation, and Loading) of data from multiple sources database systems to Data Warehouses.
• Extensive experience in developing static and dynamic dashboards using Xcelsius 4.5 via the web service connectors like QAAWS, Live Office, XML.
• Strong experience in T-SQL, Stored Procedures, Triggers and Packages.
• Expertise evaluating the performance of SQL statements and PL/SQL modules.
• Good knowledge and experience in data warehouse development life cycle, requirement analysis, dimensional modeling, and implementation of STAR, Snowflake schemas.
• Experience in performance tuning, identify and resolve performance bottlenecks at various levels like source, target, mappings, and session.
• Experience in writing system documents, technical documents, and user documentation and also writing training materials helpful for end users.
• Strong exposure to Software Project Development full life cycle and batch processing.
• Developed and deployed Data integrations solutions for the contract information group by using Xcelsius.
• Experience in creating Dashboards using metrics and analytics.
• Experience in Business Objects XIR3.2, XIR2, XI, 6.X, Business Objects Designer, Report
• Infoview, Web Intelligence, Desktop Intelligence, Instance Manager, Query Builder.
• Installed and configured all the three environments (DEV/QA/PROD) with Business Objects XIR2/XIR3.2 with Apache and Tomcat as web and app servers on windows and Unix servers.

Education

• B. Tech in Computers Engineering – J.N.T.U - INDIA

Technical Skills

Data Warehousing / OLAP / Business Intelligence Tools

Business Objects 5.1/6/6.1A/6.1B/6.51/XI R2/XI 3.0/ XI 3.1/4.0 - CMC, CCM, Auditor, Designer, Supervisor, Desktop Intelligence, Info View, Web Intelligence 2/2.5/2.6/2.7, Business view Manager, Java BO SDK’s, Microsoft .net frame work 3.0/3.5/higher, Enterprise Performance Manager, Import Wizard, Report Conversion Tool, Publishing wizard, Broadcast Agent Server, Query Builder, Xcelsius Dashboard 2008

Administration

Business Objects

Operating Systems

MAC OS X/Windows 95/98/NT/2000/XP/Unix AIX and DOS

RDBMS

Oracle 10.x/9.x/8.x/7.x/5.x, Teradata, SQL TOAD, MS Access 2000/2007

Programming

SQL, PL/SQL, Transact SQL

WEB/GUI

Apache, Tomcat, Web Sphere 5.1/6, IIS 4/5, Web Logic, site minder, Visual Basic

Version Control & Others

Microsoft Excel 2000, TOAD 9.1.0, SQL Navigator

Professional Experience:

Confidential,
OK Dec 11 – Till Date
Role: Sr. Business Objects Administrator
Project: Upgrade and Transition (Production support)
Project Description:
ConocoPhillips Company is an American multinational energy corporation with its headquarters located in the Energy Corridor district of Houston, Texas in the United States. It is also one of the Fortune 500 companies and 22nd on Forbes Global 2000.ConocoPhillips is the fifth largest private sector energy corporation in the world and is one of the six super major vertically integrated oil companies. The company has announced plans to reposition its upstream and downstream businesses into two stand-alone, publicly traded corporations during the second quarter of 2012.

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Involved in full life cycle of Business Objects XIR2/R3.
• Cloned all the public folders to the new PSX 66 downstream and renaming all the folders and report names.
• BO Upgrade from XIR2 to XIR3 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Ensured all the environments are in synchronization and checked supported environments and hardware requirements from the Products Availability Report (PAR) document for the new installation.
• Identify the servers for 3.1 Installation, Decluster the server without Apache Tomcat installation. Test CMS and CCM of independent servers, Performed Parallel installation BOXIR2 and BOXIR3 on a Clustered environment.
• Uninstalled BOXI R2 from the server to install and Removed Registry Entries with keywords such as Business Objects, business objects, busobj, bobj, Crystal Decisions, Designer, Desktop Intelligence, Web Intelligence etc before the installation.
• Installed Microsoft .net framework prior to the installation of BOXIR3.1 for successful installation of all the BO components.
• Transferred CMC data between old (XIR2) and new version either through CMC/BIAR File/Import Wizard.
• Apart from promoting info objects,used Life Cycle Manager to create,copy,Edit and scheduled a job.
• Maintained & managed different versions of the same document using Life Cycle Manager.
• Verified the remaining Business Objects installation works without any issues.
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• Created repository and security domain with user groups and security implementation.
• Extensively worked with security issues and user maintenance in XIR2/XIR3.1.
• Evaluated the possible use of aggregate tables and worked with DBA to create the aggregate tables.
• All the Scheduled report jobs were built and maintained through Info view. Output destinations include email and user BO Inbox in various formats such as PDF & Excel. Prior to the installation of BOXIR3.1.
• Involved in the Single Sign-On (SSO) application team for the Operations Updates project and used the

BO SDK to accomplish this task.

• Migrated Universes, Reports, Securities from the Development to Production environment after System Integration Testing(SIT) and then followed by Business Acceptance Testing(BAT). Used Import Wizard for the Migration process across the environments.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Used different Web services like Live Office, QAAWS to make a live connectivity between the Crystal Xcelsius Dashboards and BO Enterprise 3.1.
• Importing the groups and users from windows Active Directory into Business Objects and granting the users and groups with appropriate rights trough Central Management Console.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to vast users.

Environment: Business Objects XI R2/3.1, Business View Manager, Life cycle Manager XI 3.1, Crystal XIR2/2011 Web I 11.5, Info View, Universe Designer, Oracle 9i/10g, Windows Server2003.
Confidential,
Indianapolis, IN Feb 11 – Nov 11
Role: Sr. Business Objects Administrator
Project: FSCM and Account Receivables
Project Description:
Founded by Eli Lilly in 1876, and is now the 10th largest pharmaceutical company in the world. We have steadfastly remained independent, but not isolated. Across the globe, Lilly has developed productive alliances and partnerships that advance capacity to develop innovative medicines at lower costs. Lilly is consistently ranked as one of the best companies in the world to work for, and generations of Lilly employees have sustained a culture that values excellence, integrity, and respect for people.

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Expertise in Resolving the Daily issues in the Daily doc Production Environment.
• Extensively worked with servers and server configurations and on distributed servers.
• Developed Universes in XI R3 and set up row level security for different groups in Designer.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, parsing of objects and hierarchies.
• Created repository and security domain with user groups and security implementation multilevel hierarchies are set up enabling the drill down functionality and created Derived Tables.
• In a multi-server environment, implemented load balancing efficiently across multiple machines greatly enhances scalability and end-user response time.
• Designed universes by retrieving data from database, defining the necessary connections and exported them to specific universe domains.
• Created cascading list of values edited the list of values (LOV’s) for few objects.
• Scheduling and publishing reports onto WEBI to different destinations
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode were used for Multidimensional Formatting.
• Tuned Report Performance by creating objects and rewriting the SQL for the report variables at the universe level.
• Migrated Universes, Reports, Securities from the Development to Production environment after UAT. Used Import Wizard for the Migration process from XIR2 to XI 3.1.
• Implemented java SDK’s to improve the performance.
• Expertise in using Import Wizard for taking backup’s of the universes to BIAR file and migrating the Universes and Reports between different environments like Dev, QA and Production.
• Worked with installations and up gradations in the versions within the project and worked on CCM.
• Installed and Configured BO Software on client machines and created User groups and users for PROD, DEV and TEST environments.
• Providing user support and training in using Report Designer for creating Ad-Hoc reports.
• Strong technical, communication, time management and interpersonal skills.

Environment: Business Objects XI R2, Web I 11.5, Info View, Universe Designer, Oracle10g, Data Integrator XI, Windows Server2003.
Confidential,
Windsor, CT July 10 – Jan 11
Role: Sr.Business Objects Administrator
Project: BOXIR2 to BOXIR3.1

Project Description:
The Hartford is a leading provider of investment products, life insurance and group benefits; automobile and homeowners products; and business property and casualty insurance. The company’s international operations are in Japan, the United Kingdom, Canada, Brazil and Ireland.

Responsibilities

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Identified the reporting requirements and prepare the requirements specifications document. This involved interviewing the business users and understanding the current reporting system.
• Documenting the entire effort. The documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.
• Involved in creating the Sales and Distribution, Financial Reporting, Costing, and Forecasting Universes
• Responsible for Created user-groups in CMC and implemented the security model on the groups created.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Good experience in designing Universes, incorporating all the business requirements.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Implement Data Level Security, based on the Divisions and Markets.
• Created Classes, Subclasses, Objects and conditional Objects.
• Maintaining Universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
• Experienced in creating the Aggregate tables and Aggregate awareness implementation & Aggregate Objects Creation and using in the reporting.
• Used functionalities such as sub-reports, cross-tab reports with Drill down feature of Crystal reports to generate inventory, account receivables & payables, cycle and monthly reconciliation reports for billing purposes.
• Extensively used Calculations, Sorting, Rank, and Drill down, Drill thru, Slice and Dice, Formatting, Breaks, Filters, Changing Displays and Prompts for creating Business Objects Reports.
• Publish, distribute and schedule Web Intelligence reports using Info view.
• Involved Migration from Business Objects 6.5 version to BO XIR2.
• Used Import Wizard for the Migration process. Migrated users, universes, reports and Converting Deski Reports to WEBI using Report Conversion Tool.

Environment: Business Objects XIR2, WebI, Infoview, Oracle10g, SQL Server 2007, PL/SQL, Windows 2003 Server.

Confidential,
Cupertino, CA Mar 09 – Apr 10
Role: Business Objects Consultant
Project: I Chat

Project Description:
At present apple care use live person tool for chat reporting. But Live person’s tool has many limitations like, reporting and data management, lack of integration to any other AC system (iLog, iDesk, Genesys, GBI, Agent Master), lack of support from IS&T, and limited ability to customize the customer experience. So to overcome these limitations apple care will use Genesys chat reporting.

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application by working closely with architects and business analysts to understand system and business requirements.
• Perform an initial study of the current reporting application, to finalize the data elements required for reporting.
• Designing Universes, incorporating all the business requirements.
• As a BI Developer, Created Universes for report generation using Designer module in Business Objects.
• Universe construction and exporting the Universe/Reports to the Repository for automation.
• Created Classes, Objects, cardinalities, Strategies, resolved loops using Aliases and contexts and checked the Integrity of the Universes.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
• Working knowledge in implementing Aggregate awareness in universe objects and making compatibility through Aggregate navigation
• Analysis and requirement gathering for creating WEBI reports on infoview by building Universes from data warehouse.
• Created WebI reports using one or multiple data providers, merged dimensions, Union queries as per the requirement.
• Migrated Universes, Reports, Securities from the Development to Production environment after UAT. Used Import Wizard for the Migration process from XIR2 to XI 3.1.
• Developed various Reports to test the newly added objects in the universe and created regression reports for all the modified universes using Business Objects XI 3.1.
• Involved in administration and developing multiple reports in Crystal XI, Web Intelligence.
• Worked on Administration of BOXIR2 and BOXI CMC Security setup.
• Involved in Creating Repository, Creating Users and User Groups.
• Provided user support and training in using Report Designer for creating Ad-Hoc reports.
• Run report Timing Scripts to capture performance benchmark to verify that the Business objects reports (SQLs) against the refreshed database perform to expectations before/after patch installation, Oracle upgrades, environment refreshes, changes to the tables the universes are based on or when a specific request is made to capture the timings to ensure the consistent performance of the databases used by the reports.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), @Select, @Aggregate Aware and @Variable.
• Extensive experience in developing static and dynamic dashboards using Xcelsius 4.5 via the web service connectors like QAAWS, Live Office, XML.
• As a Universe developer had a good experience working with the offshore team.
• Tested the generated reports based on User Acceptance Test criteria.
• Designed Industry standard Business requirement document for the report development and involved in the requirements gathering process for the reporting environment.
• Strong technical, communication, time management and interpersonal skills.
• Worked with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support.
• Importing the users from Active Directory group into Business Objects and providing the users and groups

Environment: Business Objects XI R2/3.1, Web I 11.5, Crystal Reports2008/XI/10, Crystal Xcelsius2008, Info View, Universe Designer, Teradata, MAC OS X, Windows Server2003.
Confidential,
Carry, NC Nov 06 – Feb 09
Role: Business Objects Administrator
Project: Financial and Sales Reporting Systems

Project Description:
ABPII distinguishes itself by offering personalized attention to our customers’ needs and Requirements. The job involved working on several projects aimed at automating all Financial and Sales management tasks. Responsibilities included: working with end users and business analysts in understanding business requirements, defining business objects and managing development process for the project life cycle.

Responsibilities:

• Gathering the Functional and Business requirements.
• Responsible for creating use case diagrams and work flow charts.
• Administrating, maintenance, security management and production supporting on various platforms like Windows NT/2000/XP/98.
• In UNIX environments, used shell scripts to install and configure each of the system services on the available hardware.
• Managing the User rights on Business Objects Applications like Desktop Intelligence, Web Intelligence, Designer, Dashboards etc and Folder Security for different groups of Users.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web Intelligence deployments.
• Extensively worked in all phases of the project such as developing, configuration testing, Migrating,
• Generated and Published web reports in Info View using Web Intelligence.
• Scheduled the reports according to the user requirements based on the Oracle database connectivity.
• Performed a migration prototype from Business Objects 6.5/XIR2
• Migrated reports from business objects 6.5 to business objects XIR2 and fixed the issues during the migration and after migration.
• Migrated users, categories, groups, reports, folders, Universes, security models from Business Objects 6.5 version to Business Objects XI R2.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Involved in performance tuning of Business Objects Full Client and WEBI reports and published reports to WebI.

Environment: Business Objects 6.5/XIR2, BO (Designer, Supervisor, CMC, CCM), TOAD, MS SQL Server 2005, Unix.

Confidential,
Chennai, India July 04 – Aug 06
Role: Business Objects Developer
Project: Sales, Marketing and Finance Reporting Systems

Project Description:
Ranbaxy Laboratories Limited is India\'s largest pharmaceutical company. Incorporated in 1961, Ranbaxy exports its products to 125 countries with ground operations in 46 and manufacturing facilities in seven Countries.

Responsibilities:

• Analyze the reporting requirements with the business users/architects and come up with the technical Specifications for universe and BO reports.
• Development of user interface windows for sales order processing, invoicing, customer billing & Inventory.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to a vast Users located all over the world for viewing, creating and publishing reports and implement Row and object level restrictions.
• Created reports using free-hand SQL, Stored Procedure, PL/SQL, and Universe.
• Resolved universe problems such as loops, chasm and fan traps using aliases and contexts by testing the overall integrity of the structure using check integrity.
• Modifying the existing universes, adding new objects, editing joins, mapping the existing objects with renamed tables.
• At the universe level checked whether all the outer joins are created properly and also removed if there are any variables which are not used.
• Implementing Object-level and Row-level security using Manage Restrictions on the developed universe restricting the end-users in accessing certain objects.
• Created Crystal Reports using Crystal reports Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.
• Created Custom Hierarchies for using scope of Analysis and Drill Down options.
• Created the Reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice and Drill Down.
• Improved the performance of the reports by removing any additional filters or alerter on the report. Turned the formula into a variable if it has any multiple uses.
• Developed the Reports using Business objects 6.5 Full Client.
• Used Import Wizard for the Migration process. Migrated users, universes, reports

Environment: Business Objects 6.5, Designer, Supervisor, Crystal Reports, SQL Server 2005, Oracle 8i, PL/SQL.
Confidential,
India Nov 03 – May 04
Role: Business Objects Developer
Project: Sales, Marketing and Finance Reporting Systems

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirements Specification document.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL,SQL *Plus, SQL*Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Developed functional specifications.
• Created several full client reports using Business Objects 5.1
• Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
• Optimize SQL queries for better performance.
• Created Dynamic generalized procedures for truncating current and old partition data.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.

Environment: Business Objects 5.1, Oracle 8i, PL/SQL, Windows 98.