Manager Project

[pic]

[pic]

Balakrishna Minnamreddy

Mobile: *13-382- 1648

Email:abj8gp@r.postjobfree.com

CERTIFICATIONS: Business Objects Certified Professional - Enterprise XI R2

SAP Certified Associate - Enterprise XI R3.0

Business Objects Certified Professional - Web

Intelligence XI 3.0

SUMMARY:

. More than 9 years of IT experience with specialization in the field of

Data Warehousing and Business Intelligence.

. Expertise in designing and deploying Universes, Business Views, WEBi

Reports, Full Client and Crystal Reports.

. Extensively worked on dashboard development in Xcelsius 2008/4.5 using

query as web services, Live office and flash variables.

. Around 8 years of expertise on different versions of BusinessObjects

Enterprise product Suite.

. Extensive experience in installing Business Objects Enterprise Cluster on

Solaris boxes with WebSphere application tier.

. Extensively worked on server configurations and security.

. Extensively worked on Migrations BO 6.5 to BOXI 3.0 and BOXI R2 to BOXI

R3.1.

. Extensively worked on Central Configuration Manager and Central

Management Console.

. Experience in installing, Configure BO Auditor.

. Extensively worked on Business objects Publications.

. Extensively worked on different versions of Informatica Suite for ETL.

. Experience in diversified fields of Application development: Software

Analysis, Design and Development.

. Excellent analytical skills on Data drilling Slice/Dice.

. Worked on BusinessObjects XI 3.1, XI 3.0, XI R2,XI, 6.x, 5.x Desktop and

Enterprise Product Suite, WebIntelligence (2.x, 6.x), Performance

Management 6.x and Dashboard Manager.

. Experience in Crystal Reports (Designing, Sub-reporting, Olap, Adhoc

queries, Drilldown, Cross-tab etc.), Crystal Enterprise Server

(Publishing, Scheduling, Creating Users/Groups/Roles, Export/Import,

Mailing reports to respective target users in Intranet/Internet),

Client/Server and Web application development.

. Worked on Metric, created Corporate Dashboards using Application Builder

generated Speedometer added Alerts, rules and created Goals.

. Extensive database experience using Teradata, Oracle (10g,9i & 8.x), MS

SQL Server 2000 and MS Access.

. Good exposure in Finance domain, Manufacturing & Medical domains

. Sound knowledge of different phases of Data Warehousing projects.

. Conversant with Quality procedures while executing the projects.

. Excellent Business Analysis skills: ability to transform business users

input to software requirements and specifications.

. Excellent communication and written skills, problem solving skills and

possess the ability to work well with staff and clients at all levels.

. Six Sigma aware.

SKILLS:

BI Technologies: Business Objects XI 3.1,XI 3.0,XI R2/XI/6.x/5.x Suite

(Desktop/Enterprise Server products suite), WebIntelligence

XI 3.1,XI R2,6.x,2.1,WebI rich Client, Broadcast

Agent,Auditor, Performance Management 6.x, Dashboards,

Crystal reports & Crystal Enterprise XI (Web component

server, Automated process scheduler, File repository

server, Event server, Page server, Cache server, Job

server),Xcelsius 2008/4.5, Business Object Metadata

Manager.

ETL: Informatica 7.x / 6.x & 5.x

Languages: Java 2.0, Visual Basic 6.0, C and C++

RDBMS: Oracel 10g, 9i & 8.x, Teradata 12, V2R5, MS SQL Server 2000 &

MS Access

Tools & Utilities: Teradata SQL assistance, Erwin, Toad, MS

Project, VSS and Enterprise Quality Manager

Internet: IIS 4/5, JavaScript, HTML, DHTML, XML, WML

Software Engineering:Reuse Techniques (with Design Patterns), Software

Project

Management, Systems Analysis and

design, Object oriented

System Development, S/W Testing and

Maintenance, UML

(Rational Rose 2000).

Management Skills: Information Systems Audit and Control, MIS, Financial

and

Managerial Accounting

O/S: Windows (NT, XP, 2000,3.11), UNIX, Solaris and DOS 6.22

WORK EXPERIENCE:

Client: CapitalOne, Richmond, Oct

2008-Present

Project: US Card DSS - Performance Analytics

Role: Sr. BusinessObjects Developer / Dashboard Developer

Project Description:

Capital one. COF, or Capital One Financial Corp. (NYSE: COF) is a U.S.

based bank holding company specializing in credit cards, home loans, auto

loans, banking, and savings products. A member of the Fortune 500, the

company helped pioneer the mass marketing of credit cards in the early

1990s, and it is now the fourth largest customer of the United States

Postal Service and has the 8th largest deposit portfolio in the United

States.

Recoveries Performance Analytics is a project to provide a dashboard

displaying key Recoveries metrics and identify issues for further

analysis, along with detailed reporting. Performance Analytics is a

methodology leveraging business intelligence tools for managing our

strategy and execution processes. Dashboard Builder, Xcelsius dashboard

visualization, customization, and alerts integrate with Web Intelligence

and Crystal Reports, Business Objects Universes and a Teradata platform

to deliver strategic and tactical business results and variances against

goals. In addition to automation of existing reporting, this solution

will provide faster visibility into risks and opportunities, guided

analysis into causal relationships, and new business value by empowering

associates to perform what-if analysis and impact business results mid-

flight.

Responsibility:

. Design and develop Complex reports in WebI, Business Objects full

client, Crystal reports.

. Develop Complex Dashboards using Xcelsius 2008/4.5. Used LiveOffice,

Query as web Service and flash variables.

. Creating Business Views and Universes. Creating LOV using business

view manager.

. Creating dynamic list of values in Business view manager and

scheduling them

. Scheduling the Business objects reports.

. Supporting Production issues.

. Resolving migration issues while Migrating Reports / Universes /

Dashboards from one environment to other environment.

. Supporting 2,000 + users for code migrations and providing technical

solutions for the issues.

. Providing the robust dashboards for senior level executives,

supporting over 130 functional areas across the enterprise.

. Interacted directly with Business users in gathering requirements and

also working closely with BSA to get the requirements.

. Close Interaction with DBAs for query tuning and database related

issues.

. Creating Complex sub-reports in Crystal reports.

. Tuning report queries to speedup the performance.

Environment: Business Object XI 3.1,BusinessObjects XI R2, Designer,Web

Intelligence, WebI rich client,Desktop Intelligence,Oracle 10g,Teradata

Sql Assitance,Toad, Central Management Server, Central Management Console,

Central Configuration Manager,Crystal designer 2008/XI R2,Business View

Manager, Xcelsius 2008/4.5 ( Query as web service, Live office, Flash

Variables)

. Database: Teradata, Oracle 9i, Sql Server

Client: JPMorgan Chase, Chicago, Jan 2008-

Oct 2008

Project: Wholesale Client Business Intelligence (WCBI)

Role: Sr. BusinessObjects Developer / Administrator

Project Description:

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services

firm with assets of $1.2 trillion and operations in more than 50 countries.

The firm is a leader in investment banking; financial services for

consumers and businesses, financial transaction processing, asset and

wealth management, and private equity. A component of the Dow Jones

Industrial Average, JPMorgan Chase & Co. has its corporate headquarters in

New York and its U.S. retail financial services and commercial banking

headquarters in Chicago. Under the JPMorgan, Chase and Bank One brands, the

firm serves millions of consumers in the United States and many of the

world's most prominent corporate, institutional and government clients.

JPMC-WCBI Team maintains Business Objects servers (Installation and

Upgrades), They support migrations. This team also supports Production

related issues.

Responsibility:

. Installing Business Objects on Solaris servers.

. Installing Updates and Patches to BO Servers.

. Creating Business objects Groups and User and assigning the access

rights.

. Creating Business objects, Crystal reports.

. Scheduling the Business objects reports.

. Supporting Production issues.

. Migrating Reports / Universes / Users /Groups/ Connections from BO 6.5

to BOXI 3.0 using import wizard.

Environment: BusinessObjects XI 3.0, Designer,Web Intelligence, Desktop

Intelligence,Oracle 10g,Toad, Central Management Server, Central Management

Console, Central Configuration Manager, Solaris, Crystal designer XI R2

. Database: Oracle 9i, Sql Server

Client: JPMorgan Chase, TX, May 2005- Dec

2007

Project: CIT DAC - DAC Services/ BASEL Credit Tech

Role: Sr. BusinessObjects Developer / Administrator

Project Description:

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services

firm with assets of $1.2 trillion and operations in more than 50 countries.

The firm is a leader in investment banking; financial services for

consumers and businesses, financial transaction processing, asset and

wealth management, and private equity. A component of the Dow Jones

Industrial Average, JPMorgan Chase & Co. has its corporate headquarters in

New York and its U.S. retail financial services and commercial banking

headquarters in Chicago. Under the JPMorgan, Chase and Bank One brands, the

firm serves millions of consumers in the United States and many of the

world's most prominent corporate, institutional and government clients.

JPMC - IB has a program called Credit Infrastructure Transformation to

consolidate most of the existing Credit Infrastructure applications into a

robust, scalable strategic infrastructure. Primary objective of this

program is to capture and provide most accurate risk information timely to

various people in GCRM group. CIT program has 2 major areas called

Traditional Credit Products (TCP) and Data Acquisition & Control (DAC).

DAC is envisaged to collect Trades & Collateral data from various systems

with in credit environment. TCP infrastructure is to reduce the

overlapping TCP application scope, enhance existing TCP applications and

build new applications to address TCP data requirements.

Supply Management Control application is developed to report various feed

statistics and feed exceptions. This system also makes reconciliations and

trade level data available to users. This application is used by Operations

to manage various feeds that TCP and DAC support.

Responsibility:

. Involved in providing the complete Business Objects XiR2 reporting

solution and during the course of action have build Universe using

Designer, Business views using Business View Manager, Analytical reports

using Desktop Intelligence, Crystal reporter and Webi.

. Involved in designing and developing complex drill down & drill through

XiR2 Crystal reports which answers all business questions with less

number of clicks simulating the informative application.

. Designed Trend reports using Crystal reports,Desktop Intelligence and

Webi.

. Involved in the migration of objects from Business Objects 6.5 to XI

. Migrated the repositories with documents, universes, users and security

profiles.

. Created Repository and User Groups, assigning privileges to the users and

maintaining the security of the Repository.

. Administered user security and job scheduling.

. Created the Object packages and scheduled a set of reports as part of a

package in CMC.

. Designed role based reporting for key performance metrics

. Migrated objects from one environment to another using the Import Wizard

. Created a set of Dynamic cascading prompts and scheduled the list of

values for the same.

. Worked under the CMC Web Console.

. Worked with the Publishing wizard and changed the scheduling option,

moved the objects between the folders, also finalized the objects to be

added publishing with CMC.

. Build Oracle aggregates to improve the performance of the reports

Environment: BusinessObjects XI R2, Designer,Crystal Designer XI,Web

Intelligence, Desktop Intelligence,Crystal Reports XI R2,Oracle

9i,Toad,Sharepoint,Windows XP

. Extensively worked on Business Objects 6.5 Designer, Reporter,

Supervisor and WebI.

. Database: Oracle 9i Tools: EQM (Enterprise Quality Manager)

Client:3M, MN

Aug 2004 - May 2005

Project : 3M-ESC

Role : Sr. BusinessObjects Developer

Project Description:

3M is a $16 billion diversified Technology Company with leading positions

in consumer and office; display and graphics; electronics and

telecommunications; health care; industrial; safety, security and

protection services; transportation and other businesses. Headquartered in

St. Paul, Minnesota, the company has operations in more than 60 countries

and serves customers in nearly 200 countries. 3M is one of the 30 stocks

that make up the Dow Jones Industrial Average and also is a component of

the Standard & Poor's 500 Index.

Enterprise Shipping Component (ESC) is a struts based web application

developed for 3M MES. It receives customer orders from the Corporate Order

Management System (COMS), routes the order, plans the shipment, and

generates picking documentation.

Presently, ESC provides capability to generate 20 JSP based reports which

obtain data directly from online transaction database. ESC is interested in

moving their reporting system to the 3M Global Reporting Platform that uses

Business Objects as a reporting tool. The new ESC Global reporting Data

Mart is that it should be able to leverage the data available in the

Operation database to provide the best BI solution for ESC business users.

ESC data mart should be a shipment centric data warehouse enabling business

user community to create a Global reporting environment to address the 3M's

shipment reporting needs. The existing ESC reporting capabilities should be

retained in the new ESC reporting environment. The business user community

can create their own Business critical report through the Global Reporting

Environment without any technical support. Leverage the data from external

systems (COMS, iMES) by integrating with the Business Objects Universe

created by those applications

Responsibility:

. Interacted with the Business Users to analyze the business

process/gathered the requirements and made necessary changes to schema

objects to fulfill their reporting and business needs.

. Involved in Requirements/business process and transformed them into

functional & technical details

. Successfully executed the upgradation subproject by migrating from

Business Objects 5.1.9 to Business Objects 6.5 to support the client

initiate to understand the implication during the migration process.

. Requirement analyses and then implementing the Logical and Physical Data

Model for the database.

. Involved in Use case and Report Specification design for BO Reporting

. Designing the Business Object Universes.

. Responsible for creating the complex reports (On demand, AdHoc Reports,

Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic

grouping, Cross-Tab, graphical, aging reports involving

parameters,formulae, running totals and created reports against Views &

Base tables)

. Designed, developed, maintained, and tested Universes for supporting

Adhoc queries and canned reports according to the business requirements.

. Designed Universes by defining joins, cardinality between tables, linked

the existing Universes.

. Designed hierarchies in universe for reports and created user objects

with calculations in Universe.

. Organized data in the report inserting Filters, Sorting, Ranking and

highlighting data.

. Created reports in table, cross table, 2-D, 3-D Column, Line, Area and

Pie charts.

. Created a Corporate Dashboard using Application Builder and using

analytics in Dashboards and finally generated speedometer, which shows

the Average Production.

. Created a goal, which shows the average of product sale of the year.

. Unit Testing of Reports.

. Getting the User Acceptance Testing done, getting Integration Testing

done

Environment: BusinessObjects (BO 5.1.7 / 5.1.9, BO 6.5), Designer,

Supervisor

Client: Motorola,Basing Stoke, UK

Mar 2004 to Aug 2004

Project: PCS EMEA

Role: Sr BusinessObjects Developer / ETL Developer

Project Description:

Motorola, Inc. is a global leader in wireless, broadband and automotive

communications technologies and embedded electronic products. This project

supports the operations involved in the personal communications .One view

is the data warehouse, which has been built by Motorola by merging all the

databases all over the world. There are 13 Systems which will take care of

all the operations. Most of the systems are in production. ROAM is dealing

with the orders. SPS4 is the system which takes care of Sales operations. M-

claims deals with claims. There are another system like DC-FCS, YANTRA

which will takes care of shipping and flexing.

Motorola, Inc. is a global leader in wireless, broadband and automotive

communications technologies and embedded electronic products. This project

supports the operations involved in the personal communications .One view

is the data warehouse, which has been built by Motorola by merging all the

databases all over the world. There are 13 Systems which will take care of

all the operations. Most of the systems are in production. ROAM is dealing

with the orders. SPS4 is the system which takes care of Sales operations. M-

claims deals with claims. There are another system like DC-FCS, YANTRA

which will takes care of shipping and flexing.

Responsibility:

. Managed the team from onsite and co-ordinate with the client during the

new requirements phase and UAT.

. Involved in Analysis, Development, Testing, and Maintenance and resolved

problems during implementation.

. Designed Business Object Universe on top of views which will be pointing

to different tables depending upon the load status thus allowing the

users to access report at any point of time (by ensuring data mart

availability "24 hours").

. Developed reports in Business objects Client (5.1.6) and Webi.

. Implemented different types of security features supported by business

objects like row level security, report level security, object level

security.

. Managed the report & universe migration across different environments

(Dev, QA, Prod).

. Automated the report schedule process using the Broadcast Agent's File

watcher option.

. Created Tables, Views (simple/complex), and Indexes for better query

performance.

. Developed sub queries, used groups functions for aggregating data. Used

joins to retrieve rows from multiple tables.

. Maintained the Universes to meet the changing reporting needs.

. Created Master/Detail, Cross Tab and Chart templates using the

BusinessObjects and WebIntelligence tools.

. Organized data in the Report Inserting Filters, Sorting, Ranking and

highlighting data.

. Resolved the loops using aliases and contexts. Tested the integrity of

the Universes and exported the Universes to Repository for making it

available to users.

Environment: BusinessObjects 5.1.6, WebIntelligence 2.7, Supervisor,

Broadcast Agent, Oracle8i, Toad,Documentum,Windows XP

. Analysis of the specifications. ETL Development

. Developed Mappings in Informatica to load the data in to data marts.

. Developed mapplets/Lookup/StoredProcedure transformations to solve the

slowly changing dimensions and building the CUBE.

. Involved in importing Source/Target Tables from the respective

databases and created Reusable Transformations, Mapplets and Mappings

using Designer

. Scheduled Sessions and Batches to update the target data using

Informatica Server Manager.

. Preparing mapping documents

Environment: BusinessObjects 5.1.6,Designer,Supervisor, Informatica 5.x,

Oracle 8i,Windows 2000

Client: GE Power Systems Feb 2003 - Mar 2004

Project: EPGAS SAM & CE

Role: Sr BusinessObjects Developer / ETL Developer

GE Power Systems is the world leader in the design and manufacture of steam

and gas turbine-generators, power delivery equipment and systems, air

quality control systems, nuclear energy fuels and services, and a variety

of industrial and utility controlled devices.

Main objective of the project is to build a data mart for all the

transactions taking place related to gas turbines. The data mart helps end

users to analyze the sales and margin related to gas turbines based on

which they can develop the cost estimates for new turbines. The users are

given reports based on their requirements and adhoc query capability. The

users of the Application are GE employees from Sales, Marketing and

Operations department .

Responsibility:

. As a team member, was responsible for Analysis of the specifications

provided by the clients

. Design and Development.

. Creation of reports like, Reports by Customer, Reports by Period,

Demographic reports and Comparative reports Using Business Objects.

Working with database connections, SQL joins, cardinalities, loops,

aliases, aggregate conditions, parsing of objects and hierarchies.

. Creation of different types of reports, such as Master/Detail, Cross

Tab and Chart (for trend analysis). Use of filters, conditions,

calculations, etc.

. Drill down, slice and dice and change displays.

. Worked on Informatica tool and developed complex mappings using

different transformations.

. Developed mapplets/Lookup/StoredProcedure transformations to solve the

slowly changing dimensions and building the CUBE.

. Scheduled Sessions and Batches to update the target data using

Informatica Server Manager.

Environment: BusinessObjects 5.1.6,Designer,Supervisor, Informatica 5.x,

Oracle 8i,Windows 2000

Client: Chubbs Insurance JUN 2002 - Feb 2003

Project: Chubbs Insurance Model

Role: Team member in BI group

Project Description:

Chubs MR Services is a insurance provider. The company issues policy for

its clients throughout the world.The company has number of subsidiaries

which conduct their business in non-life insurance which also covers

property insurance.The company generates reports of all the transactions

that have taken place from a day to day basis.

Each of these subsidiary company maintains its own policies based on the

local market.The reports related to the revenue of the parent company are

generated based on data from its branch offices.

Responsibility:

. Analysis of the specifications.

. Developed Repositories for Business Objects set up.

. Maintained Meta data in the repository.

. Documented all meta data dictionary

. Developed Complex Security set up for end users with Supervisor.

. Defined categories of documents for different level of groups.

. Installed the BO&WEB Intelligence on cluster environment.

. Developed several Oracle stored procedures and functions for reports.

. Installed BCA server on distributed environment.

. Created Universes to retrieve data from Data Warehouse. Developed

classes/objects within Universes for reporting needs for

analysts/management.

. Used Calculations, Variables, Breaks, Sorting, Drill Down, Slice/Dice,

and alerts for creating BusinessObjects reports.

. Created Reports in formats including graphs, charts, table and cross-tab.

. Created graphical representation of reports such as Bar charts, Pie

charts, etc as per the End User requirements.

. Tested Reports for query optimization and performance.

. Scheduled/distributed the reports using BCA (BroadcastAgent).

. Created user groups and managed access privileges using BusinessObjects

Supervisor.

. Applied security features of BusinessObjects like row level, report

level, and object level security in the Universe so as to make the

sensitive data secure.

. Testing - unit testing & integration testing.

Environment: BusinessObjects 5.1.6, WEBi 2.7, Designer,Supervisor,Oracle

8i, Windows XP

Client: Medic Sep 2001 - May 2002

Project: Medic

Role: Team member in BI group

Project Description:

Medic Computer Systems is one of the top five healthcare IT companies in

North America and a division of Misys plc. It provides real time

surveillance healthcare information and market research to its global

pharmaceutical and healthcare companies. With 25 years experience in the

industry, Misys currently serves more than 92,000 physicians in 18,000

practice locations, 1,250 hospitals, 600 home care providers and hundreds

of commercial laboratories, clinics, managed services and other related

organizations.

Responsibility:

. Involved in creation of Data mart and Extracted data from DB2,

SQLServer 6.5 and Oracle Using Informatica Power Mart.

. Developed mapplets/Lookup/StoredProcedure transformations to solve the

slowly changing dimensions and building the CUBE.

. Involved in importing Source/Target Tables from the respective

databases and created Reusable Transformations, Mapplets and Mappings

using Designer

. Scheduled Sessions and Batches to update the target data using

Informatica Server Manager.

. Creation of reports like, Reports by Customer, Reports by Period,

Demographic reports and Comparative reports Using Business Objects.

Working with database connections, SQL joins, cardinalities, loops,

aliases, aggregate conditions, parsing of objects and hierarchies.

. Creation of different types of reports, such as Master/Detail, Cross

Tab and Chart (for trend analysis). Use of filters, conditions,

calculations, etc.

. Drill down, slice and dice and change displays. Created Mix reports

and Top ten reports.

Environment: BusinessObjects 5.1.6, WEBi 2.7,

Designer,Supervisor,Informatica 5.x, Oracle 8i, SQLServer 6.5 and DB2,

Windows XP

Client: Sun Microsystems Aug 2000 - Sep 2001

Project: Source Cast 2.6.0 / Source Cast 2.0.3

Role: Developer

Project Description:

SourceCast is a Web-based software development platform that enables your

organization to collabora-tively build enterprise-level software, whether

your team is scattered around the block or around the globe.Specifically

designed for collaborative development on the Internet, SourceCast combines

software develop-ment applications, communications features, and your

choice of third-party resources into an intuitive solution. SourceCast user

and system administration features unite applications for concurrent

versioning of source code, issue tracking, document and file

management,discussion forums, and mailing list management.

Responsibility:

. Coding Server Pages using JSP and Servlets.

. Developed Java files using core language functionality.

. Performed Unit/Module Testing.

. Involved in Code Reviews.

Database: Oracle 8i ; Tools: Issue Zilla ; Language :Java2.0 ;Internet

Technologies: HTML, Servelets, EJB ; Web Server: Tomcat, Application

Server: Websphere

EDUCATION:

Bachelor of Engineering in Computer Science and Engineering from University

of MADRAS in April 2000.

Contact this candidate