Business Objects Consultant

Location:

Hyderabad, AP, 500085, India

Posted:

October 26, 2011

Contact this candidate

Resume:

SREENATH DEVINENI

*****************@*****.**.**

Mobile: +91-967*******.

Over six and half years of professional expertise specializing in Business Intelligence solutions and Technical Specialist for SAP Business Objects Enterprise suite of products and Oracle Business Intelligence.

Possess fair knowledge of banking / Financial Services businesses with relevant industrial exposure in planning, management and implementation

Experience in requirements gathering, business analysis, testing, and project coordination.

Expertise in deployment and configuration of Business Objects and Oracle BIEE on various platforms.

Hands on experience in SAP BI 4.0 and Crystal Reports Enterprise.

Experience in Migrating Business Objects 5.1 to BO XI R2 and BO XI R2 to BO XI 3.1

Excellent communication skills and technical documentation skills.

Conducted Internal Business Objects Enterprise and Oracle Business Intelligence Trainings.

Experience Summary

• Working as Consultant in Thomson Reuters International Pvt. Ltd, Hyderabad from 25th Jan 2010 to till date.

• Worked as Consultant in Oracle Financial Services Software Ltd (formerly i-flex Solutions Ltd) Bangalore from 20th Dec 2004 to 22nd Jan 2010.

Education

• Master of Science in Information Technology from Anna University, Chennai, India.

• Bachelor of Computer Applications (B.C.A) from Osmania University, Hyderabad, India.

Technical Skills

Operating Systems Microsoft Windows and UNIX

RDBMS Oracle 10g,DB2,SQL Server 2005

BI Tools Business Objects Enterprise Suite

• Business Objects Enterprise XI 4.0/XI 3.1/XI R2/6.x/5.x

• Universe Designer, Reporting and Analysis (Desktop Intelligence, Web Intelligence and Crystal Reports).

• Business Objects Dashboards (Xcelsius, Performance Manager)

Oracle Business Intelligence Enterprise Edition 10g (BI Server, BI Answers, BI Dashboards and BI Publisher,)

Web Technologies HTML, XML, JavaScript

Programming Java, PL/SQL

Technical Profile :

Role Duration Key Responsabilités

Consultant Feb 2010 to Till Date Responsible for development, deployment, maintenance and support of the BO and OBIEE tools.

Install, Configure, and Deploy Business Objects Enterprise XI 3.1 on a 6+ server cluster environment and 400 full client desktop applications

Configuring windows AD authentication in all BO Production Servers and SSO Implementations.

Responsible for supporting 400 power users and 4000 end users.

Provide daily support and troubleshooting for BO and OBIEE end user problems.

Tech Consultant May 2008 - Jan 2010 Business Intelligence architecture design and consulting

Designing & Implementing BI solutions on existing Warehouse infrastructure

Evaluation and recommendation on Business Objects Suite of products

Planning, design and implementation of BI roll-outs

Training on products for users and concept orientation for technical team

Developer / Team Leader Dec 2004 – April 2008 Involved in requirements gathering, business analysis, testing, and project coordination.

Interacting with the Business Users to know their requirements in developing and modifying Universes and Reports accordingly.

Involved in Business Objects Reporting, Universe designing and Migration

Experience in Migrating Business Objects from one version to another version.

Career Experience:

Projects in Thomson Reuters International Pvt. Ltd

11. Project : Business Analytic Solutions

Client : Thomson West, USA

Duration : Feb 2010 to till date

Technology : BO XI 3.1 SP3, OBIEE 10g, DB2, Oracle 10g

Role : Team Leader

Description:

Thomson has Business Objects had reporting tool for Tax and Accounting, Legal and Healthcare business and as and when Business needs a solution for the their reporting requirements new report requirement, change the existing universes

Responsibilities:

• Responsible for development, deployment, maintenance and support of the BO and OBIEE.

• Responsible for Environment stability of business Objects and Oracle Business Intelligence

• Involved in Business Objects environment building with BO XI3.1 SP3, SAP KIT and other middleware software’s.

• Configuring windows AD authentication in all BO Production Servers.

• Involved in BO XI R2 to XI 3.1 SP3 Migrations and DB2 to Oracle Migration.

• Responsible for new Universe Development, Report Development, Universe changes and troubleshooting issues.

• Involved in Oracle Business Intelligence (Siebel Analytics) enhancements as part CRM Monthly/Quarterly Releases.

10. Project : Business Objects Migration

Client : Thomson West, USA

Duration : June 2010 -Nov 2010

Technology : BO XI R2, BO XI 3.1 SP3, DB2, Oracle 10g

Role : Consultant

Description:

Thomson uses BO XI R2 as reporting tool for Tax& Accounting, Legal and healthcare divisions reporting needs. It has Universes and reports created accessing different data sources like DWH, SAP BW, MDB and Excel sources.

BO XI R3 platform will provide a better foundation to grow Thomson West Business Intelligence solutions like implementing Single Sign-on, Webi Rich Client and using additional features provided by the new tool.

Responsibilities:

• Involved in Installation of Business Objects environment building with BO XI3.1 SP3, LCM 1.0 SP3, SAP KIT and other middleware software’s.

• Involved in Security Migration and Aliasing Windows AD accounts, SAP Accounts with Enterprise Accounts.

• Involved in SSO Implementation

• Moving Users Personal folders to new environment.

• Involved in Universe and reports Migration and Troubleshooting reports issues

• Implemented LCM in BO XI 3.1 SP3 for deployment from one environment to another environment.

Projects in Oracle Financial Services Software Ltd

11. Project : GM DART – Oracle BI Server (Onsite)

Client : Deutsche Bank, UK

Duration : Sep 2008 to Jan 2010

Technology : Oracle Busines Intelligence EE 10gR3, Essbase 9.3, Cognos 8 BI, Oracle 10g R2

Role : BI Consultant

Description:

Deutsche Bank uses multiple OLTP systems to process business transactions and multiple OLAP databases to model the data and present it for reporting. Multiple BI Reporting systems are used to combine theses disparate sources together.

Deutsche Bank implementing a solution which produces Daily, Monthly and a combination of Daily & Monthly reporting and analysis. Deutsche Bank has standardized Cognos as the reporting tool of choice. Cognos sources data from various sources and does not possess some of the Deutsche Bank high level reporting requirements. The goal is to integrate various data sources used by cognos reporting into One Data virtualization environment using Oracle BI Server to enable metadata and security integration.

Responsibilities:

Implementing the BI Server to produce the Cognos Reports.

Integrating Hyperion Essbase cubes with Oracle BI EE.

Integrating BI Server with Cognos

Preparing the documentation

10. Project : Business Objects Practice

Client : NA

Duration : Aug 2007 to Oct 2008

Technology : Business Objects Product Suite and Oracle Business Intelligence Suite

Role : Product Specialist/Pre-Sales Consultant

Description:

As Product Specialist, for Business Objects and member of pre-sales team attached to Business Objects Practice Group, my role is to provide technical assistance to multiple projects under the Center for Business Intelligence SBU, work on RFP’s/RFI’s that use Business Objects product suite or Oracle Business Intelligence suite as part of the solution. Prepare estimates, costing for BI proposals for prospects and for new roll-outs with existing clients. Evaluate and suggest new product modules/features that could value-add the entire solution process. Maintain Business Objects deployments and internal projects.

Responsibilities:

Pre-sales product consulting for Business Objects

Prepare estimates/costing

Proposal preparation and responding for RFP’s/RFI’s

Proof-Of-Concepts study/implementation on Business Objects Suite

Evaluation and recommendation on Business Objects Suite of products

Conduct training on Business Objects products

9. Project : Payment Accelerators (off-shore)

Client : Citi Bank, Singapore

Duration : Feb 2008 to April 2008

Technology : Business Objects XIR2, Oracle 10g

Role : Team Leader

Description:

CMB Tech has 4 payment source systems (FTI/CS/DDE/PPM).Having a consolidated

and holistic view of the performance of the payment systems was a requirement. The scope of work for the current phase involves Review source for different source system, Review of Base Analytics, Requirements Definition and Design. Payment dashboard provides business and real-time analytics.

Responsibilities:

Involved in Requirement analysis.

Involved in Universe Design and Security

Involved in Report and Dashboard creation and testing

Coordinating the team

8. Project : GTAP BO XIR2 Migration (off-shore)

Client : HSBC-HK

Duration : Aug 2007 to Jan 2008

Technology : Business Objects 6.5,Business Objects Enterprise XIR2,Oracle 10g

Role : Team Leader

Description:

HSBC is one of the largest banking and financial services organizations in the world. HSBC GTAP was using Business Objects 6.X as a part of the Flex cube product. HSBC intend to migrate Business Objects from version 6.X to version XIR2.The scope of the project is to upgrade existing BO v6.5 into BO XIR2 without user intervention and provide the multilingual support. These involved studying the existing 6.x source Repository and identify the universe & document domains and designing the security metrics for XIR2 based on the existing security setup. Security was applied to all the repository objects like groups, users, universes, documents, categories which were migrated successfully using the Import wizard tool.

Responsibilities:

Involved in the preparation of Migration Approach, Installation and testing document for Business User.

Involved in the preparation of Logical Content plan for designing the security metrics for BO XIR2

Created the new security design using Central Management Console for XIR2 system based on the logical plan created.

Involved in Design and documentation of high level and low-level design.

Requirement management, involving the change management, impact analysis and configuration in different phases of the project.

7. Project : FLEXCUBE Reporting (on-site)

Client : Tachong Bank, Taipei

Duration : Jan 2007 to Jul 2007

Technology : Business Objects 6.5, Oracle 10g.

Role : Team Member

Description:

As part of the regulatory requirements, all banks in Taiwan have to submit statutory reports to the Central Bank of China and JCIC.

FLEXCUBE is the Core Banking software being implemented at Tachong Commercial Bank (TCB), the regulatory reports will be generated from Flexcube. Flexcube itself has two systems mainly FLEXCUBE Corporate (FCC) and FLEXCUBE Retail (FCR) dealing with corporate and retail banking respectively. The regulatory reports require various kinds of data like transactional, Day end position, Month end position and Historical data.

FLEXCUBE Reporting System (FRS) provides an integrated reporting solution to generate Regulatory reports required by the bank The FRS system uses data extracted from FCC and FCR. The extracts will be written according to the requirements of the reports that will be generated.

Responsibilities:

Working with Business users for requirements gathering, business analysis.

Also doing the analysis and documentation of detailed requirements.

Requirement collection on Accounting, Credit, Deposits, FX, JCIC and Treasury modules.

Extraction programming as part of loading data into FRS (Data warehouse system).

Development of Regulatory reports and transactional reports across FCR, FCC and FRS Modules.

Involve in the development and implementation of reporting system using Business Objects Reporter and Oracle10g.

Creating reports using Freehand SQL as main data provider.

Preparing test cases for reports and also involved in testing of reports

Involved in doing the performance tuning of Reports.

Actively involve in Production support.

6. Project : FLEXCUBE Reports Migration (on-site)

Client : CITI Bank, Singapore

Duration : Sep 2006 to Dec 2006

Technology : Business Objects 5.1, Business Objects XI R2, Oracle 10g R2.

Role : Team Member

Description:

This project involved 16 countries migration of FLEXCUBE universe and 3000 Reports for various subject areas such as Account Balance, Account Transaction, Advice, Foreign Exchange, GL etc from BO 5.1.8 to BO XIR2.

Responsibilities:

Migrating Existing Business Objects v5 Reports into BO XIr2 Reports.

Converting Free Hand SQL based Reports to Universe based reports.

Optimizing the queries used in Free Hand SQL before migrating them to universe based Reports.

Preparing test cases for reports and also involved in testing of reports

5. Project : i-Space Reporting (on-site)

Client : UBS Bank, Singapore.

Duration : Jul 2006 to Oct 2006

Technology : Business Objects 6.5, Sybase 12

Role : BO Consultant

Description:

UBS i-SPACE (Integrated Securities processing and Custody Engine) is a Re-engineering Project to consolidate the three primary securities processing and settlement systems in Hong Kong and Singapore, namely, WISPA PB (World-wide Integrated Settlement Processing Application), WISPA DEPOT and WEM. WISPA-PB is the multi-instrument, multi-currency and multi-branch securities settlement application for Wealth Management. WISPA Depot is the WM safekeeping and custody application used to maintain client’s position. In the new WISPA application, the screens were implemented using Java and the reports were designed using Business Objects (BO).

Responsibilities:

Responsible for design, development and maintenance of Universe.

Creating webi reports as per Existing application.

Creating Stored Procedures for reports.

Integrating webi reports with iSpace Application.

Prepared test cases for reports and also involved in testing of reports.

4. Project : Karnataka School Quality Assessment Organization (KSQAO) (off-shore)

Client : Educational Department, Government of Karnataka.

Duration : May 2006 to Jul 2006

Technology : Business Objects XI Release 2, MS SQL Server 2000.

Role : Team Leader

Description:

Karnataka School Quality Assessment Organization - Performance Analysis is being developed

for the Education Department of the Government of Karnataka. The Education Department has initiated an annual exercise to assess the learning levels at all the Government Schools across the state. This exercise was launched for the first time in the country to understand quality in education. This assessment was to address the quality concerns of children in Std. II, V and VII of government and aided schools in the state of Karnataka.

Responsibilities:

Requirement collection from the users.

Responsible for design, development and maintenance of Universe.

Responsible for creation of reports.

Involved in data modeling.

Involved in installation of Business objects XI Release 2.

3. Project : CTI Reporting Functionality (off-shore)

Client : CITI Bank, Singapore

Duration : Jan 2006 to April 2006

Technology : Business Objects XI Rel1, SQL Server 2000

Role : Team Member

Description:

The project is an offshore development for Problem Management Group (PMG) Citibank Technology Infrastructure Division. Generated the reports which showing the problem status in various areas called ASPC, LATAM, EMEA along with Service status.

Responsibilities:

Analyses the Excel input sheets to design the Database

Building the Universe based on the PMG Requirement.

Develop the Web Intelligence Documents which describing problem status with service offered status.

2. Project : Index Integration System(IIS) (off-shore)

Client : Standard and poor’s (S&P)

Duration : April 2005 to Dec 2005

Technology : Web Logic 8.1 SP4 application server, Oracle 10g Release 2, Oracle Top Link 10.1.2 for object-to-relational persistence, Flux Scheduler 7.0.9 or higher, Business Objects XI Rel1 and Crystal Reports XI Rel1.

Role : Team Member

Description:

Standard & Poor's as one of the world's preeminent providers of credit ratings, and for such globally recognized financial-market indices as the S&P 500®.it also provide a wide range of other products and services designed to help individuals and institutions around the world make better-informed financial decisions with greater confidence.

The S&P Index Integration System (IIS) architecture uses Flux from FluxCorp for its scheduling requirements. Flux is 100% Java based scheduler which readily integrates into J2EE architecture with support for JMS, job persistence and job scheduling based on work flow model.

The IIS architecture relies on Business Objects XI for report generation based on report template. Crystal XI documents created using Crystal Reports XI (thick client) would be referred as report templates within IIS for which report files would be created

Responsibilities:

Requirement collection from the users.

Created universes using Designer and maintaining repository.

Created web intelligence Reports and Crystal Reports using universe as main data source.

Managing the User accounts and access rights by using CMC.

Administration of Business Objects XI and crystal reports XI.

Involved in installation of Business objects integration crystal pack XI.

1. Project : UBS Strategic Cash Reconciliation (SCR) New Enhancements (off-shore)

Client : UBS – London.

Duration : Dec 2004 to Mar 2005

Technology : Business Objects 6.1.3, Oracle 9i

Role : Developer

Description:

The Strategic Cash Reconciliation (SCR) project has been set up to replace the Bank’s cash reconciliation system, CORONA, with a new third-party application, TLM.

Three separate instances of CORONA, all resident on the Zurich mainframe, currently perform cash reconciliations for UBS Investment Bank business in London, Stamford and Asia/Pacific, with associated applications, Global Fails, VDM and Lotus Notes, providing additional reporting and manual matching functions. All of these systems will be replaced by one global instance of TLM.

TLM will process the same (non-redundant) inputs and outputs as the system it replaces.

The SCR project implementation of TLM will be phased, with rollouts to Asia Pacific, London and finally, Stamford. CORONA, Global Fails, VDM and the Lotus Notes manual matching applications will be decommissioned as a part of the project.