Data Manager

Murali Krishna

Email: ******@*****.***

Sr. Business Objects Developer

Mobile: 224-

***-****

PROFESSIONAL SUMMARY:

. Over 7 years of IT experience in Analysis, Design, Development, and

Implementation of Business Intelligence tools like Business Objects

3.1/XIR2/6.x, Crystal Reports 2008/XI/10/9/8.5.

. Involved in Installation of Business Objects 3.1/XIR2/6.x.

. Extensively worked on CMC (Central Management Console) in maintaining

objects, Universes, Connections, Resources, Users, User Groups and

Categories in Business Objects.

. Expertise in creating Customized Objects and Cascading List of Values.

. Experience in building Universes, retrieving data using Universes and

Personal Data Files,

Stored Procedures and Free Hand SQL methods and creating Ad-Hoc

reports using Business Objects & Web Intelligence Tools.

. Exported Reports to schedule, monitor, and publish the reports.

. Experience in gathering business data requirements, creating

documentation for reporting requirements, and the presentation using

Rational Requisite Pro.

. Linked reports using Open Document syntax to link master report to a

detail report by creating hyperlink objects in the Universes and

Reports.

. Converted full client report (.rep) to Web Intelligence (.wid) using

Report Conversion Tool.

. Developed Reports, Sub Reports, custom prompts and formatted the same

with respect to the requirements. Added parameters, special fields,

formulae and used multiple data sources like data cubes to create the

reports in Crystal Reports.

. Experience in creating Metrics and Analytics to create Corporate Dash

boards.

. Experience in creating Dash boards, Metrics, Rules, Alerts and Goals

using Performance Manager XIR2 (EPM) for user analysis based on user

requirement.

. Experienced in Dimensional Data Modeling in Star and Snow Flake

schemas.

. Expertise in Physical and Logical Data Modeling.

. Supported Business objects in production environment 24 x 7 basis.

. Worked with Informatica Power Center to move data from heterogeneous

sources into Oracle/SQL Server Data Marts, Data cubes and Data

Warehouses.

. Expertise in using Database tools like TOAD and ERWIN (data modeler).

. Good Experience in Oracle 10G/9i/8i, SQL Server 2000 and Ms-Access.

. Knowledge on IMS database and Expert in writing SQL Queries, PL/SQL

procedures.

. Involved in supporting end users in resolving issues related to

Business Objects.

. Ability to work in-groups as well as independently and initiative to

learn new technologies, tools quickly, easily adapts to various

environments and very effective communication, interpersonal skills

and able to handle multiple tasks and projects simultaneously.

. Domains: Pharmaceutical, Finance, Supply Chain, Sales, HR, Healthcare,

AP and AR

TECHNICAL SKILLS:

BI Tools Business Objects 3.1/XIR2/6.5/6.0,WebI, Info View, Import

Wizard, Query Builder, CMC, CMS, CCM, Designer, Desk I, Web

I, Xcelsius.

Reporting Tools Crystal Reports 2008/XI/10/9.0.

ETL Tools Informatica 8.1/7.1/6.0 (Power Centre/Power Mart).

Languages C, C++, SQL, PL/SQL.

Data Modelling Tools Rational Requisite Pro, Erwin 3.x/4.x.

Database Oracle 10G/9i/8i, Teradata, Sysbase, DB2, MS SQL Server

2000/2005.

Operating Systems UNIX, AIX, Windows95 /98 /NT /XP/2000/2003/2008.

EDUCATION: Bachelor of Technology from JNT University, India.

PROFESSIONAL EXPERIENCE:

Advanced health Media, Chesapeake, VA

Apr '09 - Till date

Sr. Business Objects Analyst

Description: This Project design helps management to estimate the processes

for admission and discharge times and tracks delay in both the cases. This

is helpful for doctors who are busy, to find all the information about

wards and about patients. The Major partitions of the system are Billing,

Cash Posting Retro, Collections and Reconciliation. To support its

functionality, interfaces and exchanges data with different external

systems like Customer Interface, Sales Management, General Ledger, Broker

Commissions and Letter System. The project involved development of library

of reports using Business Objects.

Responsibilities:

. Interacted with the Users and Business Analysts for requirement

gathering and documented entire functional requirement life cycle

using Rational Unified Process, Requisite Pro.

. Migrated Universes, Connections, Full Client / Web I Reports from the

existing version XIR2 to 3.1 using Import Wizard.

. Extensively worked on CMC (Central Management Console) in maintaining

objects, Universes, Connections, Resources, Users, User Groups and

Categories in Business Objects XI.

. Involved in creating Tables and relationships.

. Used Designer Module to implement Universe, Joining the Tables, Create

Prompts and queries, parsing the Objects, apply Contexts and Alias

Tables to remove Loops and Traps.

. Involved in the design/development of Universes, Classes, Objects and

Conditioned Objects for Business Analysis and Report Generation.

. Used the functionality of linking universes so as to have the

flexibility to use the objects defined in one universe in another.

. Created Custom LOV's (List of Values) and Custom Hierarchies for

drilling down Reports.

. Used various @Functions like @Prompt (for user defined queries),

@Where (For creating conditional filters), and @Select.

. Applied security features of Business Objects like report level &

object level security in the Universe so as to make the sensitive data

secure.

. Created and maintained complex DESKI, WEBI and Rich client reports.

. Worked on SQL performance tuning to fix slow running reports.

. Gathering the report requirements from the users and preparing the

specs and mock up reports.

. Created Web I reports with multiple data providers and synchronized

the data using merge dimension option in BO XIR2.

. Exported Reports to schedule, monitor, and publish the reports.

. Created reports using Business Objects functionalities such as Drill

down reporting, Slice/Dice, Master Detail reporting, sorting, etc.

. Developed knowledge portal Dashboards and linked to Web I, Canned,

Drill documents.

. Created Interactive Metric Trends (IMT) and Score Cards Using EPM

based on requirements.

. Converted full client report (.rep) to Web Intelligence (.wid) using

Report Conversion Tool.

. Supported end users during UAT phase. Worked on tracking fixing the

bugs during this phase

. Provided 24/7 support lead for Business Objects from installation to

production environment.

Environment: Business Objects 3.1/XIR2, Designer, Web Intelligence Rich

Client, Xcelsius 2008, Crystal 2008, Life Cycle Manager, Windows 2008/2003

Server, Oracle 10g,, Toad.

Cedarstone Bank, Lebanon, TN

Oct'07 - Mar'09

Sr Business Objects Lead

Description: Cedarstone bank provides full-service retail and commercial

banking operations regionally and nationally. This project is intended to

develop a customer data warehouse related to Mortgage, Credit cards and

Loans to understand customer behavior to marketing programs and identify

critical customers in support of improved decision making across the

organizations and development of reports for the management

Responsibilities:

. Involved in Installation of all Components of Business Objects XI R2.

. Extensively worked on CMC (Central Management Console) in maintaining

objects, Universes, Connections, Resources, Users, User Groups and

Categories in Business Objects XI.

. Imported Users/Groups, documents (Web I and Desk I), Universe,

Document, folders, categories and objects using Import Wizard.

. Managed the Servers using the Central Configuration Manager (CCM).

. Involved in the design/development of Universes, Classes, Objects and

Conditioned Objects for Business Analysis and Report Generation.

. Used the functionality of linking universes so as to have the

flexibility to use the objects defined in one universe in another.

. Created Shortcut Joins and Aggregate tables in Universe Designer to

improve the performance.

. Created the reports using Business Objects functionalities like

Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and

Formulae etc.

. Linked reports using Open Document syntax to link master report to a

detail report by creating hyperlink objects in the Universes and

Reports.

. Created Sub Reports and custom prompts in crystal Reports.

. Created Crystal reports using Business Views and Universes as data

providers.

. Worked closely with Data Modelers in designing various Data cubes,

Data marts, data warehouse schema techniques.

. Converting Logical data model into Physical Data Model and developed

Oracle table creation scripts using Erwin tool.

. Responsible for reviewing and analyzing reporting requirements and

translating them as per the requirement.

. Tuned the queries to improve the Performance of the existing Reports

for various functional areas.

. Developed Hierarchies to support drill down reports.

. Created new Universes specifically designed for creation of Dash

boards.

. Created various Analytics like Speedometer, Barometer and Interactive

Metric Trends (IMT).

. Developed Stored Procedures Using Oracle PL/SQL programming to improve

the performance of the Reports using complex queries.

. Involved in User Acceptance Test (Universes and Reports) throughout

the migration process.

. Developed Crystal Reports and formatted the same with respect to the

requirements. Added parameters, special fields, formulae and used

multiple data sources to create the reports.

. Created Sub Reports and custom prompts in crystal Reports.

. Created Stored Procedures to retrieve the data faster and generate the

reports quickly.

. Extensively work on scheduling and distributing the documents.

. Provided full support to the end user in production issues.

. Tested the reports and modified the relevant Objects in the Universe

as per the user specifications.

. Involved in supporting end users in resolving issues related to

Business Objects.

Environment: Business Objects XI R2 (CMS, CCM, CMC, Auditor, Web I, Desk

I), SQL Server2005,

SQL*PLUS, Windows 2003 Server, Xcelsius, UNIX, Crystal Reports XI/10/9.0.

Proctor & Gamble, Cincinnati, OH

Apr'06- Sept'07

Business Objects Developer

Description: The project aims at consolidating customer data received from

different source systems. And creating a central database to analyze the

business performance, trends over time and build forecasts in addition to

generating various standard, ad-hoc/canned reports. ETL process has been

carried out using Informatica 7.1 and Business Objects XIR2 for reporting

and analysis.

Responsibilities:

. Installation and upgradations of Business Objects XIR2 Enterprise

Server Products includes, Web Intelligence, Info View, Publisher and

Auditor.

. Migrated Universes, Connections, Full Client / Web I Reports from the

existing version 6.5 to XiR2 using Import Wizard

. Migration of Universe and documents between environments using Import

Wizard.

. Creation of Security, Universe and Document Domains. Users, groups and

row level security.

. Document the Universe design and Reports development.

. Used Designer Module to implement Universe, Joining the Tables, Create

Prompts and queries, parsing the Objects.

. Used the functionality of linking universes so as to have the

flexibility to use the objects defined in one universe in another.

. Implementing the Data base changes in the Universe like adding new

columns, renaming the existing columns, changing the owner of existing

tables in the data base.

. Designing the Universe, Created Contexts and Aliases for resolving

Loops in the Universes.

. Interacted with the users and the management to collect information

for their reporting needs.

. Designed, developed, tested and maintained SQL queries and customer

reports using the Actuate report environment.

. BW Queries, SAP BW cubes were used as the main data sources for

developing crystal report

. Extensive knowledge on BEx Query Designer, BEx Web Application

Designer, BEx Analyzer.

. Extensive knowledge on Info cubes, Info Areas, Info Objects, Key

Figures, Characteristics and Hierarchies.

. Training the users in ad-hoc report development, Production Support.

. Creation of documents both (full client and WebI), summary and detail

with the functionality of drill down to detailed document.

. Used the formatting options like cross tab representation, section

breaks, data sort options, calculations, font, colors etc.

. Linked reports using Open Document syntax to link master report to a

detail report by creating hyperlink objects in the Universes and

Reports.

. Installation of Business Objects server products on local machines as

client nodes to monitor the status of the documents scheduled and

administers the components from local machines.

Environment: Business Object 6.5/XI R2, Web Intelligence, Desk Top

Intelligence, Universe designer, Supervisor, Oracle 9i, Teradata, SQL*PLUS, TOAD, SAP BW, Windows 2003 Server, UNIX.

American Honda Motor co., Torrance, CA

Oct'04 - Mar'06

Business Objects Developer

Description: This site eliminates the hassle of manually filling out paper

and auto fills much of the required information. It not only provides the

servicing facilities for Vehicle owners but also provides an opportunity

for consumers to buy spares on line. This internet Site Provides Dealers

with one, easy-to-use system for ordering goods and services from the Head

Office and Facilitate, the Area Heads, Regional Heads, Zonal Heads and

Chief Marketing Officer with Valuable Reporting Data.

Responsibilities:

. Installation, upgradations and configuration of Business Objects XIR2

Enterprise Server Products includes, Web I, Info View, Publisher and

Auditor.

. Migrated Universes, Connections, Full Client / Web I Reports from the

existing version 6.5 to XiR2 using Import Wizard.

. Created, modified/maintained Universe.

. Used Designer Module to implement Universe, Joining the Tables, Create

Prompts and queries, parsing the Objects, apply Contexts and Alias

Tables to remove cyclic dependencies.

. Exported Reports to schedule, monitor, and publish the reports.

. Gathering the report requirements from the users and preparing the

specs and mock up reports.

. Creation of documents both (full client and Web I), summary and detail

with the functionality of drill down to detailed document.

. Reports were formatted according to the user requirements using

Business Objects functionalities like Breaks, Calculations, Slice and

Dice, Drill Down and Variables.

. Involved in User Acceptance Test (Universes and Reports) throughout

the migration process.

. Worked closely with Data Modelers in designing various data warehouse

schema techniques.

. Developed Stored Procedures Using Oracle PL/SQL programming to improve

the performance of the Reports using complex queries.

. Extensively Used MS Excel to generate Purchase Order Reports and

Manufacturing Reports .

. Created Sub Reports and custom prompts in crystal Reports.

Environment: Business Objects XIR2/6.5/6.0 (Designer, Supervisor,

Reporter), Info View, Broadcast Agent, Crystal Reports 9, Oracle 9i, MS Sql

server 2000, PL/SQL, MS Excel and Windows 2003.

Synergies & Durai, Hyderabad, India

Aug'02 - Jul'04

Crystal Report Developer

Description: The objective of the project was design and developing Data

marts for Production Management process and Quality Control process using

the ETL (Extraction, Transformation and loading) tool. The source for the

Data warehouse is from different OLTP Systems. This OLTP data is ported

into DSS database. Reports were generated using Crystal Reports. These

reports give an insight into business trends, performance and enables for

better forecasting decisions as well as provide business users with a

customer centric view of heterogeneous data. Various ad-hoc reports build

based on this data using OLAP tools for decision making to the top-level

management.

Responsibilities:

. Developed reports like blank report, cross tab reports, sub reports

in Crystal 9.0

. Interacted with end users to gather Requirements and created

technical, user documentation.

. Created Custom Functions and Converted reports from Crystal Reports

8.5 to 9.0

. Creating custom Prompts, sub reports and linking it with main

reports Crystal Reports 9.0

. Developed various reports, charts and graphs using Crystal

Reports 9.0

. Imported and Created Source Definitions using Source Analyzer.

. Imported and Created Target Definitions using Warehouse Designer.

. Created and Scheduled Sessions and Batch Process based on demand

using Informatica Server Manager and Maintain Informatica ETL jobs.

Environment: Oracle 8i, Crystal reports 8.5/9.0, Informatica 6.0, SQL,

PL/SQL and Win NT/2000.

Contact this candidate