Manager Developer

Kalyan gorantla

Accomplished Senior Business Objects Developer with over Eight years of

professional experience and demonstrated success designing and implementing

solutions that improve business functionality and productivity with diverse

technical background and proven ability to design, develop and implement

technology on an enterprise level. Approach all projects with passion,

diligence, integrity and exceptional aptitude.

Professional Summary:

> Extensive experience in Analysis, Design, Development, Implementation,

Deployment and maintenance of Business Intelligence applications.

> Experience in the documentation of system and business requirements

and specifications, step-by step technical and user manuals, design

and development of use and test-case scenarios and root-cause

analysis, developing test plans, conducting user acceptance testing,

training, and implementing new processes and technology.

> Expertise in Business Objects Products (Designer, Desktop

Intelligence, Web Intelligence and Rich Client, Supervisor, Info View

& CMC) and its deployment.

> Expertise in identification of Business and Data requirements and

converting them into conceptual and logical data models.

> Proficient in translating report requirements into detailed report

specifications, confirm report design with business users and creating

reports using Business Objects XIR3, XIR2, 6.5.x/5.x.

> Very good understanding of Data Warehousing Design Methodology, Data

Warehouse Concepts, Database design/architecture including both OLAP &

OLTP data and complete lifecycle of project from design to development

and implementation.

> Experience in designing the dashboard with Crystal Xcelsius (Live

Office and QAAWS) and Dashboard Manager for complex user requirements.

> Experience in creating Folders, user groups and setting user rights

and managing the security using CMC and Supervisor.

> Expertise in managing the Business Objects servers using Central

Management Console and Central Configuration Manager.

> Strong working knowledge in implementing the Best practices for

Business Objects Enterprise.

> Expert in mentoring/training/assisting business users on Business

Objects Products.

> Experience in Optimizing and tuning of universe and SQL to improve the

performance.

> Possess excellent communication, decision-making, Problem Solving,

Analytical, and Interpersonal skills with result oriented dedication

towards goals.

> Possess leadership qualities of leading the team, motivating and

inspiring the team by recognizing the work by appreciations.

Core Competencies Functional Areas

BI Project Life cycle development Pharmaceutical

Design and deploy complex BI solutions Insurance

Excellent skills in Universe & Report Design Health Care Services

Supply Chain

Excellent analytical & problem solving Brokerage

skills Financial

Excellent client relationship management Manufacturing

skills

Business Objects Migration Specialist

Technical Skills:

Business Objects Tools Business Objects XI 3.1,R1/R2,6.5.x/5.x,

Supervisor, CMC, Performance Management, Universe

Designer, Broad Cast Agent, Desktop Intelligence,

Web Intelligence and Rich Client, Xcelsius

4.5/2008, Live Office, Infoview, Report Conversion

Tool, Import Wizard

Third Party Tools:

Infoburst 2.6

Databases Oracle 10x, 9x, SQL Server 2000, 2005, 2008, DB2,

Microsoft Access 2010, Visual Foxpro 9.0, Teradata

Data warehousing Star-Schema Modeling, Snowflakes Modeling, FACT,

dimension tables

Operating Systems Windows NT, Windows 2003 Server

Development Tools Developer 2000, Forms 6.0

Prog Languages SQL, PL/SQL, JAVA, HTML, XHTML, C, C++, C #, COBOL

Modeling Tools: Erwin, Visio

ETL Tools Informatica 7.1, Pervasive 8.0

Professional Experience:

EMA, Livingston, NJ

Jun 10 - Till Date

Role: Sr. Business Objects Developer/Administrator

Environment: Business Objects XI 3.1; Oracle 10g; SQL Server 2008;

Microsoft Access

2010, Visual FoxPro 9.0; Pervasive 8.0; Web

Intelligence and Rich Client;

Dashboard Manager; Xcelsius 2008; Live Office; HP

3000; Windows 2003

Server.

EMA is focused on the provision of clinical excellence and emergency

services to hospitals and health systems. EMA is one of the largest ED

firms, and treats almost 1 million patients annually while serving over

twenty four hospital clients. The company is widely recognized for clinical

excellence, as well as the ability to increase patient volume and improve

and sustain patient satisfaction. The EMARS application provides the

flexibility to the users to access the reports. Head quartered in

Livingston, NJ.

Responsibilities:

> Gathering and analyzing the requirements.

> Managing the Business Objects Servers using Central Management Console

and Central configuration Manager.

> Setup the Security at the Folder level using Central Management

Console.

> Extensively worked on the maintenance of complex universes.

> Created File based events to trigger the scheduled WEBI reports.

Scheduled the Daily, Weekly and Monthly reports.

> Designed simple to complex Reports using Web Intelligence and Rich

Client.

> Designed the Dashboards using Xcelsius and Dashboard Manager for the

different Hospital clients.

> Converted few reports from DESKI to WEBI by using Report Conversion

Tool.

> Involved in the design and development of ETL process to load data for

different Hospital Clients to reporting database using Pervasive.

John Hancock, Boston, MA

Oct 08 - Apr 10

Role: Sr. Business Objects Developer/Administrator/Team

Lead

Environment: Business Objects XI 3.1/R2; Oracle 10g; DB2; Teradata;

Informatica;

Infoburst 2.6; Xcelsius 2008; Live Office; Web

Intelligence and Rich Client;

Auditor; Report Conversion Tool; SAP Integration

Kit; IBM MAINFRAMES;

Windows 2003 server.

John Hancock Financial Network offers different products such as Life

Insurance, Mutual Funds, Long-Term Care, 401k Plans and Fixed Products. BCS

is Brokerage Compensation System that pays the commission that was

calculated in the other system, to direct and career brokers. Deals are set-

up in BCS to direct the payment of commission and compensation.BCS receives

the feed from IBM MAINFRAMES.Informatica is used to load the data to

oracle.

Responsibilities:

> Gathering and analyzing the requirements.

> Involved in understanding the end user requirements and business

processes in creating and designing Universes, Queries and Reports.

> Designed Universes using SAP BI Queries and Infocubes as Datasources.

> Integrating Business Objects with SAP using SAP Integration Kit.

> Installation and Configuration of Business Objects SAP Integration

Kit.

> Maintained the universe by creating the classes, objects, Joins,

aliases and contexts.

> Optimizing the Universe to improve the performance.

> Designed the Xcelsius Sales Dashboard using SAP BW data.

> Created reports which involve complex Financial calculations, linking

data from multiple data providers.

> Used Business Objects functionalities like Breaks, Sorts, Alerters,

Filters, Data Tracking, Quick Display, Optional Prompts and

Conditions.

> Tuning the SQL to improve the performance of the reports.

> Write SQL queries for data level and Business Logic testing.

> Enhanced the Existing reports using Sub queries.

> Installed the Infoburst on the server to create the reports and email

them to the relevant Users in PDF format for the Sales Agents.

> Provided Training to Business Users about the Business Objects

Reports.

> Documenting the production and development environment changes made on

the WEB servers.

> Extensive universe testing and conducted UAT in multiple sessions with

the end users.

> Experience in testing and fixing any problems in Universes, Reports,

Objects, Conditions and Lov's(List of Values).

> Performed the migration from Business objects XIR2 to XI 3.1 using

Import Wizard.

> Migrated the security, Universes and Reports from XIR2 to XI3.1.

> Designing the security using CMC.

> Add more groups and change the profile of users via CMC.

> Managing the Business Objects servers using CMC and CCM.

> Setup the security at the Folder Level in the CMC.

> Row level security is implemented with different connections for

different user groups.

> Implemented the CMS clustering for load balancing.

> Implemented the Best practices for Business Objects Environment.

> Leading the team by motivating the team to complete the tasks on time

with appreciations.

Risk Enterprise Management Ltd, Cranbury, NJ Oct 07

- Sep 08

Role: Sr. Business Objects Developer

Environment: Business Objects XI R2; Oracle 10i; Web Intelligence;

OLTP;

Windows 2003 Enterprise

REM is world class provider of claims, managed care and risk management

solutions to the property and casualty insurance industry. REM offers a

variety of services to corporate risk mangers, insurers, self-insured's,

wholesalers, brokers and reinsurer's. REM process the claims management

services such as worker compensation, General Liability, Automobile

Liability, Products Liability and Personal Property. Head quartered in

Cranbury, New Jersey.

Responsibilities:

> Sr. Business Objects universe designer and report developer.

> Analyzed the existing OLTP system, which is a Claims Management

application with back-end Oracle.

> Gathering and analyzing the requirements

> Created universes, classes, objects, and predefined conditions in

Designer.

> Created Joins, aliases and Contexts.

> Resolved loops by creating Aliases and Context.

> Optimizing the Universe to improve the performance.

> Row level security is implemented with different connections for

different user groups.

> Created Web Intelligence and Business Objects full client reports.

> Experience in creating various types of Reports like Cross tab

Reports, Drill through Reports.

> Created User Prompts, Conditions and Filters to improve the report

generation.

> Tuning the SQL to improve the performance of the reports.

> Created Objects with Hints at the Universe to improve the performance

of the Reports.

> Provided Training to Business Users about the Business Objects

Reports.

> Conducting periodic training for business users on reporting

techniques.

> Extensive universe testing and conducted UAT in multiple sessions with

the end users.

Office Max, Naperville, IL Jun 07

- Sep 07

Role: Sr. Business Objects Developer

Environment: Business Objects XI R2; Oracle 10i; Dashboard Manager;

Windows 2003 Enterprise

The OfficeMax inventory management leadership team is responsible for

proactively identifying and managing the forecasting, inventorying,

purchasing, and replenishment of the OfficeMax stores and Boise Cascade

distribution centers .The supply planning team within the inventory

management department is responsible for managing the flow of purchase

orders between the company order management systems and the related

vendors. The supply planning team must identify which purchase orders to

prioritize in light of existing inventories needed to fulfill future

demand. Back-end data is Oracle. Business Objects is the client's choice of

BI reporting. The project involved a complete cycle of Study, Design,

Development, Training and Implementation.

Responsibilities:

> Sr. Business Objects universe Developer and report developer.

> Analysis of the requirements and lots of interaction with the end

users to get to the report templates approved.

> Designed a universe to support all identified enterprise reporting

data and possible ad-hoc reporting with all subject areas of the

warehouse.

> Developed and created classes with Dimension, Detail & Measure Objects

and specified the hierarchies.

> Specified the Joins and checked the cardinalities.

> Extensive use of contexts and aliases to resolve the loops as well as

to add functionality to design a functionally foolproof ad-hoc and

enterprise reporting universe.

> Created reports in XIR2 Web Intelligence with the lot of hyperlinks to

provide guided analysis.

> Created reports which involve complex calculations, linking data from

multiple data providers, using free hand SQL, stored procedures.

> Created User Prompts, Conditions and Filters to improve the report

generation.

> Created Refresh on open and Scheduled Reports.

> Designed the Supply chain Corporate Dashboards.

> Provided Training to Business Users about the Business Objects

Reports.

> Responsible for conducting UAT sessions with the end users.

> Tuning the SQL to improve the performance of the reports.

CNA Insurance, Chicago, IL May 06 -

May 07

Role: Sr. Business Objects Developer

Environment: Business Objects XI; Web Intelligence; Oracle 9i;

Dashboard Manager;

Windows 2003 server

CNA Insurance is Property and Casualty system used to process claims that

include standard

lines, Global and specialty lines. CNA does the Claim setup, Payment

processing, Litigation

support and Vendor maintenance. CNA process the Auto, General Liability,

Property and

Worker's Compensation Claims.

Responsibilities:

> BO universe and report developer.

> Gather and analyze the requirements. Analysis of the requirements and

lots of interaction with the end users to get to the report templates

approved.

> Installing and Configuring of BO Suite of products in Development,

Production and QA environments.

> Design and develop three universes.

> Performance optimization through implementing aggregate awareness.

> Created multiple complex objects in the universe to facilitate easy

reporting.

> Created Web Intelligence and Business Objects full client reports.

> Designing Corporate Dashboards with automated rules and Dimensional

Analytics.

> UAT with large group of users across the country.

> Extensive universe documentation and system documentation.

Health Care Service Corporation, Bangalore, India

Jul 04 - Mar 06

Role: Business Objects Developer/Team Lead

Environment: Business Objects XI R2 / 6.5.x; SQL Server 2000/2005;

Crystal Reports

XI; Data Stage; Dashboard Manager; Infoview;

Windows 2003 Enterprise

HCSC is healthcare Insurance company .It is a best service provider to its

customer for a lesser cost. The application maintains membership data of

three states -Illinois, Texas and New Mexico, which account for a total of

2 million members being processed.

The project involves building and hosting an enterprise data warehouse and

business objects reporting system. The data feeds come from various sources

which also involves third party market competition data providers. Business

Objects is the client's choice of BI reporting. The entire application is

hosted on the servers in the data center in Chicago, IL.

In phase - I designing a fully functional ad-hoc reporting oriented

universe and around 50 Web Intelligence and Business Objects reports using

this universe is part of this initiative.

In phase - II migrating BO 6.5.2 to BO XI Release 2, migrating SQL 2000 to

SQL 2005, adding more facts and dimensions to the data warehouse are part

of the deliverables.

Responsibilities:

> Conducted user interviews and reviewed existing reporting / analytical

solutions to understand the client's specific reporting needs.

> Documented Reporting requirements.

> Configuration and maintenance of server components.

> Designed a universe to support all identified enterprise reporting

data and possible ad-hoc reporting with all subject areas of the

warehouse.

> Row level security is implemented with different connections for

different user groups.

> Implemented aggregate awareness to utilize the summary/aggregate

tables.

> Designed custom hierarchies according to dimensional hierarchies while

considering the client's reporting needs.

> Extensive use of contexts and aliases to resolve the loops as well as

to add functionality to design a functionally foolproof ad-hoc and

enterprise reporting universe.

> Extensive universe testing and conducted UAT in multiple sessions

> Designed ~ 50 enterprise reports using Web Intelligence. Some of them

are refresh on open & some are scheduled

> Designing Crystal Reports using different data providers like

Universes, Business views and from other Data sources.

> Developed Insurance Reports using Crystal Reports XI.

> Involved in scheduling the Monthly and Weekly reports.

> Extensive usage of drill down option.

> Prepared user documentation for hands on training of end user

community.

> Conducted training sessions for state level user groups with emphasis

on the Web Intelligence tool.

> Assisted the administrators in the process of migration from 6.5.2

environment to the XIR2 environment.

> Converted all Full Client documents to Web Intelligence documents as

part of the migration process. Report conversion is followed by

extensive testing to make sure the formulas and formatting are intact.

> Leading the team of 7 by motivating the team to complete the tasks on

time with appreciations.

Tube Investments of India, Chennai, India May 02 - Jun 04

Role: Business Objects Developer/Administrator

Environment: Business Objects 5.1.6; Broadcast Agent; Web Intelligence;

Oracle; DB2;

Windows NT

Tube Investments of India is a group company of Murugappa group, one of the

premier industrial houses in southern India. They manufacture various tubes

and automotive body parts. They have the Global material services for their

customers. GMS acts as a distribution center by sourcing the materials from

the suppliers (internal and external) and shipping it to customers of Vijay

electricals.

Responsibilities:

> Analysis of Business Objects environment, Universes, Reports.

> Designing the security using supervisor.

> Setup and maintain the repository architecture necessary for

centralized administration.

> Created users and groups and assigned them appropriate security

profiles.

> Implemented the Group centric and Row level security.

> Developed Universe using Designer module in Business Objects.

> Developed and created classes with Dimension, Detail & Measure Objects

and specified the hierarchies.

> Specified the Joins and checked the cardinalities.

> Implemented User Objects in Reports.

> Created Condition in Universe.

> Ad-hoc reports were used for Business Objects user modules for various

portfolios using the Universes as the main Data providers.

> Resolved loops by creating Aliases and Context.

> Organized data in reports by using filters, sorting, ranking and

highlighted data with alerts

Academic Qualifications:

Bachelor of Engineering in Computer Science and Engineering, Madras

University, India.

Contact this candidate