MR.SRINIVAS MEDARAMETLA SAP BO

Administrator [615-***-****]

Professional Summary

. Over 10 Years experience in Information Technology Industry out of

which nearly 9 + Years' experience into, design, development, upgrade,

create and modify Business Objects Universes and Reports. Have

extensive working knowledge of all stages(2 full life cycle

implementation projects of SAP BO Admin) end to end activities and BO

development in banking, retail, manufacturing, Media, insurance

domains.

. Over 5+ years of experience in SAP Business Objects

Administration/Architecture.

. Over 4 years of experience in BO Development using Business

Intelligence (BI) tools like BO-XIR4.1, BO-XIR2/R3 BO-6.5.1,

using CMC,Universe Design,Infoview, Web intelligence, Desktop

Intelligence, Crystal Reports.

. 2 years Exp Onsite Experience with the UK clients (British Telecom)

and South Africa (Mulitchoice) using SAP BO 3.1.

. Expert in Business Objects BO Administrator 4.1/4.0/XI 3.1/

3.0/R2/6.5.

. Designing, Configuring and Managing Servers and Service properties in

SIA, CCM and CMS.

. Expertise in Business Objects XI R4.1 installation, migration,

configuration, Administration, security maintenance, technical support

and troubleshooting of Business Objects implementation in shared and

dedicated environments.

. Expertise in Upgrade issues / procedures from XIR3 to XI4.0 with

products like Lifecycle Management, Promotion Management, Upgrade

Management

. Expertise in Business Objects XIR4.0 / 4.1 - Report Conversion Tool,

Webi Rich client, Crystal Reports Designer, Business View Manager,

Upgrade Management, LCMBIAR concepts, Promotion Management, Lifecycle

Management, Business View manager, Query Builder, web

intelligence,CMC,CCM.

. Security Administration in XI4 - Including Access Levels, User-Group

Management, Folder security, row and data security, object level

security

. Promoting Code and Migration between the three environments by using

manual or GUI methods - between DEV/UAT/ PROD for both XIR2,XIr3 and

XI4x

. Working knowledge of configuring the SAP integration Kit and Windows

AD SSO.

. Installing Business Objects Enterprise Server in a Linux hosted

environment for DEV/UAT/PROD environments.

. Good knowledge of Unix/Linux and scripting.

. Work Experience on Development of Business Intelligence Reports

applications using Business Objects (SAP BO 4.1 and SAP BO XI R2/R3).

. Strong understanding of relational and in-memory databases like Oracle

11G, SAP HANA, Vertical, Teradata, SQL Server and SAP multi-

dimensional systems

. Provided 24X7 supports to the users and make sure the environment is

Highly Available.

. Troubleshooter the environment related issues by looking the Business

Objects logs and Event logs and also worked with SAP Technical support

to resolve multiple issues.

. Involved in the site to site VPN implementation of the data exchange

between the servers.

. Worked with Developers to consolidate the Business Objects repository

before migrating to BO4.1.

. Experience with Installing and Administration of entire hardware, and

software products like Tomcat, and Apache (Clustered and Standalone

environments).

. Good understanding of IIS and Tomcat, web servers as it relates to the

Business Objects infrastructure.

. Good understanding of Web Infrastructure (Web Servers, Application

Servers, BigIP and Firewalls)

. Worked on configuration of SAP business Object Mobile server and

installation.

Worked on trouble shooting server errors and utilizing management

console for monitoring, requesting start and stop servers as required

from infrastructure team.

. Worked with all the dependent server teams 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.

. Experience in building and retrieving data using Universes, Personal

data files, and creating complex ad-hoc Reports using the Business

Objects suite applications.

. 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.

. Good knowledge and experience in data warehouse development life

cycle, requirement analysis, dimensional modeling, and implementation

of STAR, Snowflake schemas.

. Participated in all phases of Software Development Life Cycle SDLC

(Requirement Analysis, Design, Development, Testing and Documentation.

. Installed and tested the BI4.0 application on sandbox.

. Good knowledge on SAP HANA, .Net and Core Java.

. Strong database experience in using Oracle 11i/10g/9i/8i, MS SQL

Server 2008/2005, MS Access.

. Experience in Training & Supporting end-user reporting needs using

Business Objects.

. Strong experience in T-SQL, Stored Procedures, Triggers and Packages.

. Experience in writing system documents, technical documents, and user

documentation and also writing training materials helpful for end

users.

. Good Interpersonal Communication skills, Commitment, Result oriented

and hard working.

. An excellent team player with highly favorable interpersonal,

multitasking, communication skills.

Awards and Achievements

. Worked as an Onsite Coordinator and BO Project Lead.

. Achievements: Appreciated by Client for delivering support BO

Admin tasks\complex reports.

Experience Details

Organization Designation Duration

Tech Mahindra Bo Administrator August/2010-

Americas INC Till Date

Nihilent Software Engineer October/2009

Technologies --August/201

0

Tech Mahindra Project Lead October/2008

Americas INC --July/2009

Sierra Atlantic Senior Consultant July/2006--O

Software ltd ctober/2008

Evoke Software Engineer January/2005

Technologies --June/2006

Skills

OLAP Business Objects Tools Business Objects BI 4.1,

Business Objects XI 3.1/3.0, XI R1/R2,6.5, Web

Intelligence XI 3.1/3.0/XI R2, Universe Designer XI

3.1/3.0,XI R2, Desktop Intelligence, Info View, CMC,

Import wizard, upgrade management tool,Report

Conversion Tool, Data Integrator 11.5/XI 3.0, Xcelsius

2008, Query as a Web Services(QaaWS), Live Office.\BO

Admin

SERVERS Windows 2008,Linux,unix server,web application server,

Apache, Tomcat, Java Scripting

ETL Informatica 7.x\8.0

Operating Windows Server 2003/2008/NT, Windows Vista/

Systems XP/ME/98/95, DOS, UNIX, LINUX, AIX 4.5

RDBMS Oracle 11g/10/9i/8i/8.0, MS SQL Server 2008/2005, MS

Access, Siebel, Sybase, Teradata

Languages SQL, PL/SQL, JAVA, HTML, C, C++, .NET,Pearl

Web Technologies HTMLDHTML, CORE JAVA

Certifications

(1Z0-007) Introduction to Oracle9i: SQL

(1Z0-101) Developer PL/SQL Program Units(OCA CERTIFIED

Work Experience

Project Profile#1 BO Administrator Jan 2013 to Till Date

Project Domain Manufacturing

Solution OLAP Reporting

Project Name: NNA

Client Nissan North America, Franklin,TN,USA

Role BO Administrator

Organization Tech Mahindra Americas INC

Duration Jan 2013 to Till Date

Team Size Project : 3

Environment Database : Oracle 10g/9i/8i/8.0, MS SQL Server

(with skill 2008/2005

versions)

Tools : Business Objects BI 4.1\ XI 3.1/3.0,

XI R1/R2,6.5, Web Intelligence XI

3.1/3.0/XI R2, Universe Designer XI

3.1/3.0,XI R2, Desktop Intelligence,

InfoView, CMC, Import wizard, Report

Conversion Tool, DataData Integrator

11.5/XI 3.0, Xcelsius 2008, Query as a

Web Services(QaaWS), Live Office.,CCM

O/s : Windows Server 2008/2000/NT, Windows

Vista/ XP/ME/98/95, DOS, UNIX/Web

application servers,Tulsi,Unix Servers

Project Description:

Nissan North America is comprised of a number of affiliates/divisions such

as Manufacturing,

Sales and Marketing, Financing, Nissan Canada, and Engineering. The

project is to provide production

Support Maintenance and enhancement services for Regional data warehouse,

Global Data Warehouse and

Planning process. It captures relevant scenarios of data required for

accurate forecasting, budgeting,

Reporting and analysis. Actual data, monthly Forecasts, Annual Budget, and

reporting to the parent company

NML at Japan.

Roles & Responsibilities:

. Creating additional users and groups in multiple business objects

environments.

. Assigning rights in multiple business objects environments.

. Creating /restoring content backups.

. Daily monitoring servers/systems and respond quickly to alerts.

. Monitor and resolve the day to day issues reported within the

purview.

. Installation and upgrading BO server with new version of software

(Business Objects).

. Contribute to coordination and planning of Business

Objects/Database/Infrastructure related activities/outages.

. Implement patches and other day-to-day Business Objects

administration tasks including creating folders/reports/users and

migrating reports/folders/users from Dev to QA to Production

. Work with IT and business users to resolve support and technical

questions.

Monitoring in Windows 2008 server administration.

. Monitoring with IBM AIX 5.2/5.3 Operating Systems.

. Resolve Business Objects software related issues on end user

computers.

. Respond to and resolve assigned Level 3 tickets on Business Objects

issues in BI 4.0/4.1 production, test and development environments

within defined SLA's.

. Technical problem resolution for all technology related issues with

the BO environments, including trouble shooting server errors and

utilizing management console for monitoring, requesting start and

stop servers as required from infrastructure team.

. Resolve customer complaints with software and respond to suggestions

for software modifications or enhancements.

. Migration of report, universe and folders from one server to another

or one environment to another using promotion management.

. Design and implement security by creating of user groups, granting

access to BOE applications to users and adding security restrictions

(application level, folder level and object level) based on user

profile and user groups.

. Create access levels (interactive, adhoc, power) based on project

needs. Adhere to IT Control Policies throughout design, development

and testing and incorporate Corporate Architectural Standards into

application design specifications.

. Employ best practices for design, development, unit testing and test

plan development.

Project Profile#1 : Planview (NAIT CARDS) Bo Administrator August

2010-Dec 2012

Project Domain Banking

Solution OLAP Reporting

Project Name: Planview (NAIT CARDS)

Client CITI BANK, USA.

Role BO Administrator

Organization Tech Mahindra

Duration Aug 2010 to Dec 2012

Environment Database : Oracle 10g/9i/8i/8.0, MS SQL Server

(with skill 2008/2005

versions)

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

O/s : MAC OS X/Windows 95/98/NT/2000/XP/Unix

AIX and DOS

Project Description:

Citi Group is an American multinational financial services

corporation headquartered in Manhattan, New York City, United States. Citi

is organized into different segments Investment banking Debt and equity

markets (including prime brokerage),Lending Private equity Hedge funds,Real estate,Structured products, Private Bank . Consumer finance

lending: residential and commercial real estate; auto, student and

personal loans; and consumer branch lending Retail partner cards Certain

international consumer lending (including Western Europe retail banking

and cards) .

Roles & Responsibilities:

. Interacting with client and gather the requirements of the project,

implementing and testing them on different BO environments.

. Designing the Business Objects infrastructure setup based on the

project requirements.

. Installed Business Objects Explorer 4.0 and configuring with Business

Objects 4.0.

. Validating the universes, web Intelligence reports, and creating Web

Intelligence reports

. Working on tickets and issues from developers and users.

. Monitoring server activities of BO 3.1, 4.0 on a daily basis and take

necessary actions.

. Provide on call support for high priority issues

. Migrate report objects, universes and users with in the environments

using life cycle manager and import wizard.

. Setting up the security for the different BO environment i,e Dev QA

and Prod

. Integrating and configuring users in SAP BW with Business Objects

environment.

. Fixing Issues related to migrations on Business Objects environments

like QA, DEV and PROD.

. Manage the team activities and training them for better results in the

project.

. Presenting the team achievements to management and onsite process

partners.

. Conducting PID meeting in the team and contributing for process

improvements in the team

Project Profile#2 : Mind pack Rewrite Software Engineer

October/2009--August/2010

Client Software Engineer--MNET Johannesburg, South Africa

Organization Nihilent Technologies pvt ltd

Location Offshore: PUNE Onsite: South Africa

Duration Offshore: Onsite:

April/2010--August/2010 October/2009--April/2010

Team Size Project : 20 Module : 10

Environment Languages: PL/SQL, forms 10G,

(with skill Reports

versions) 10G,.NET,Business

Objects 6.0 BO XI R2

Softwares: Nil

Database : : DB2, Oracle 10G, SQL

Server 2000.

Tools : Oracle Forms

10G/PLSQL/.NET/Shell

Scripts

O/s : : HP-UNIX, Windows

XP/2000/98/95/NT.

Project Description:

M-Net (Electronic Media Network) is a subscription-funded television

channel in South Africa, established in 1986 by a consortium of newspaper

companies, including Naspers. Net was incorporated as an independent

entity in 1996, under the joint leadership of co-directors Jan D'Arcy and

Anne Taylor .MNET is only one of biggest channel in the South Africa it

is combined with the sister companies like Multichoice and DSTVS and Mnet

has its own broad cast channels.

Roles & Responsibilities:

. Extensive Use of Free Hand SQL in generating the Reports by

using Derived table.

. Developed views to generate the Reports

. Performing Unit Testing after the Generation of Reports to check

whether we are getting the Desired Results as Expected.

. Effectively handling client change requests at the time of

Construction of Reports.

. Migrated the reports from Business Objects 5.0 to XI R2.

. Integrating and configuring users in SAP BW with Business

Objects environment.

. Fixing Issues related to migrations on Business Objects

environments like QA, DEV and PROD.

. Manage the team activities and training them for better results

in the project.

. Presenting the team achievements to management and onsite

process partners.

. Conducting PID meeting in the team and contributing for process

improvements in the team

. Designing modifications necessary to solve issues.

. Created daily, weekly and quarterly reports for the management

team and field operation Managers using Business Objects

reports.

Project Profile#3 : ANF RMS Implementation Phase2 Project

Lead October/2008--July/2009

Project Domain Retail and Consumer Non Durable

Sub Domain Consumer Durables

Solution Oracle Retail

Client Project Lead--Abercrombie & Fitch(ANF)

Organization Tech Mahindra

Location Offshore: DLF Cyber City - Hyd Onsite: Nil

Duration Offshore: Onsite: Nil

October/2008--July/2009

Team Size Project : 10 Module : 5

Environment Languages: PL/SQL, forms 10G,

(with skill Reports 10G,business

versions) objects XiR2

Softwares: Nil

Database : DB2, Oracle 10G, SQL

Server 2000

Tools : Oracle 10G, PL/SQL,

Oracle Developer Suite/

(Forms 10g),,Pro

*C,SQL, Enterprise, Unix

Scripting, R

O/s : HP-UNIX, Windows

XP/2000/98/95/NT.

Project Description:

Abercrombie Fitch is an American clothing retailer, Marketed as a

lifestyle brand, the company encompasses five brands Abercrombie Fitch was

established in 1892 The company launched four brands in a period of ten

years and has begun to expand on an international basis Across various

world markets.

Roles & Responsibilities:

. Prepare new Multi leg packages in PL/SQL Registering the new

developed forms into RMS Application

. Implementation of the forms for transfer modules

. Preparing test plans for transfer module Tuned the SQL scripts.

. Study the existing system Coordination with the on shore team.

Interacted with end user for solution providing.

. Done coding in PL/SQL Developer, TOAD on Oracle 10G.

. Execute the project to a logical and successful end. Meeting the

clients expectation and goals. Co-ordinate the testing.

Designing of related screens.

. Developed and created classes with Dimension, Detail & Measure

Objects and specified the hierarchies

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

highlighted data with alerts.

. Created reports based on Hierarchical and Cascading Prompt along

with various Time Intervals like YTD, MTD, Monthly, Weekly, Daily,

Adhoc etc.

. To create reports using Business objects functionalities like

combined queries scope of analysis, Slice and Dice, Drill up, Drill

down, Drill by, Drill through, and @functions.

Project Profile#4: Phoenix Application Technical Consultant

July/2006-October 2008

Project Domain Insurance

Sub Domain Claims

Solution Claims

Client Technical Consultant--British Telecom

Organization Sierra Atlantic Software ltd

Location Offshore: HYDERABAD Onsite: United Kingdom

Duration Offshore: Onsite:

July/2006--October/2008 July/2006--August/2006

Team Size Project : 2 Module : 0

Environment Languages: Business objects

(with skill XIR3\R2, Informatica

versions) 7.x\8.1

Database : Oracle 9i.

Tools : SQL Navigator 4.2, Toad,

Test Director 7.6.

O/s : Windows Server

2003/2000/NT,

Project Description:

The Legal Aid Phoenix System (PHOENIX) enables the Legal Aid

department to administer legal aid in Northern Ireland. The system

provides the functionality to process solicitors' claims for fees for

legal advice and as4istance provided under the Green Form Scheme. The

Green Form scheme is aimed at making limited Legal Advice & Assistance

(LAA) readily available to assisted persons, i.e. persons of moderate

means. Solicitor Firms submit batches of Green Forms - maximum of ten per

batch), representing claims for payment under the scheme.

Roles & Responsibilities:

. Involved in Designing and Coding of Criminal Legal Aid, Civil

Legal Aid developed

. New functionality for the criminal Module in Phoenix. Solving

the Customer Related problems.

. Involved in Maintenance of the Project. Developed a Shell

Script for the Giro Update Processing..

. Developed a crone job for Civil, Criminal, Abwor, Green form.

. Developed and created classes with Dimension, Detail & Measure

Objects and specified the hierarchies.

. Created Condition in Universe.

. Created the reports using Business Objects functionalities like

Combined Queries, Drill Down, @Functions, Simple, Master Detail

and etc.

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

highlighted data with alerts.

. Scheduling the reports to the specific users and user groups.

. Involved in resolving issues during the maintenance phase of the

project

. Scheduling the reports in the Prod environment.

. Extraction, Transformation and Loading (ETL) of data by using

Informatica Power Center.

. Created mappings using the transformations such as the Source

qualifier, Aggregator, Expression, Router, Filter, Sequence

Generator, and Update Strategy.

. Create access levels (interactive, adhoc, power) based on

project needs. Adhere to IT Control Policies throughout design,

development and testing and incorporate Corporate Architectural

Standards into application design specifications.

. Involved in production Support.

Project Profile#5 : Order Results Software Engineer

January/2005--June/2006

Client Corporate Service Company(USA)

Organization Evoke Technologies

Location Offshore: HYDERABAD Onsite: Nil

Duration Offshore: Onsite: Nil

January/2005--June/2006

Team Size Project : 3 Module : 0

Environment Languages: PL/SQL,forms 6i,

(with skill Reports 6i, business

versions) objects XIR2

Softwares: Nil

Database : Oracle 8i.

Tools : SQL Navigator 4.2,

Benthic, Test Director

7.6.

O/s : Windows XP

Project Description:

Corporate Domains, Inc a wholly owned subsidiary or csc becomes an

ICANN accredited register managing domain name for many companies. CSC

completes another major acquisition by purchasing Lexis N Exist document

solutions, resulting in even more depth to lead the industry in uniform

commercial, code (UCC)The system comprises of various form modules are

Order Results, Online Ordering, Filing preparation.

Contribution:

. Extensive Use of Free Hand SQL in generating the Reports by using

Derived table.

. Developed views to generate the Reports

. Performing Unit Testing after the Generation of Reports to check

whether we are getting the Desired Results as Expected.

. Effectively handling client change requests at the time of

Construction of Reports.

. Identifying opportunities for code reusability.

. Designing modifications necessary to solve issues.

. Created daily, weekly and quarterly reports for the management team

and field operation Managers using Business Objects reports.

Education

Degree Specialization University Year of passing

Post-graduation M.SC Computers Osmania 2004

University

Passport & Visa Details

Passport No. F7130318 Valid Till: 08 Mar 2016

H1B visa Valid Till: 06 May 2017

Canada Work Permit Valid Till : 20 June 2014

Personal Details

Particular Details

Name MEDARAMETLA SRINIVAS

MSAT GID 290275

Email ID abgkj9@r.postjobfree.com

Client email id abgkj9@r.postjobfree.com

Personal Email id abgkj9@r.postjobfree.com

Client Location Nissan North America, Franklin,TN 37067

Contact Number - Home 615-***-****

Contact Number - Mobile 615-***-****

Contact Number - Office 615-***-****

Page 1

Contact this candidate