Resume

SUJITHA NALLURI Email: acepdh@r.postjobfree.com

Mobile: +91-998*******

SUMMARY:

Having 3.9 year’s of Experience in SAP Business Objects 3.1 environment and SAP

BO 4.0, including End-to-End BO Implementation.

AREA OF EXPERTISE:

• Good experience in developing Reports for the different data sources like Oracle 9i/10g,

SQL Server 20005/2008.

• Experience in Business Objects Suite (XIR2/XI3.1/R4), Universe Designer, Web i - Rich

client, CMC and Import wizard, Universe Design Tool, BI launch pad.

• Knowledge on creating user profile, folders, mapping user groups.

• Experienced in developing, modifying and maintaining universes.

• Experienced in Creating new Classes and Objects in the Universe based on Functional

Specifications and Testing the Universe.

• Experience in creating Universes with Measures, Dimension objects, Join conditions,

Filters, LOV's, Cardinalities, Aliases, Contexts, Hierarchies, @functions, Aggregate

Awareness using SAP Business Objects Designer and Information Design tool.

• Experience in resolving join path problems like Loops and Traps in the universes using

Aliases, Contexts, and Aggregate Awareness in SAP Business Objects Designer.

• Experienced in creating Derived Tables according to end user requirements.

• Experience in creating universe on Bex and cubes.

• Experienced in Migrating reporting from BOXI r2 to BOXI r3

• Expertise in creating reports using SAP Business Objects Web I, Web I Rich Client and

Crystal reports using different Data Sources.

• Experienced in Developing Reports and Customizing reports using Alerts, Breaks, and

Filters and Sorts etc.

• Experienced in creating reports using Web Intelligence, schedule the reports as per the

business needs and supporting.

• Extensively used SAP Business Objects reporting functionalities such as Drilling

methodology, Filters, Ranking, Sections, Graphs and Breaks.

• Experienced in creating complex reports by linking data from multiple data providers,

functionalities like Combined Queries, Sub Queries.

• Expertise in building dashboards using Xcelsius 2008

• Experienced in Creating Crystal Reports XIR3/2008

• Experienced in Creating Charts with Value-based alerts and setting up Drill down in

charts using Crystal Xcelsius.

• Knowledge on Installation, Administration and upgrading versions of SAP Business

Objects in development and testing environments.

• Expertise in gathering, analyzing and documenting business requirements, functional

requirements, and data specifications for SAP Business Objects Universes and Reports.

• Trained users in SAP Business Objects tools such as Info view, Web I rich client.

• Knowledge in installation of SAP Integration with BO desktop and server products

• Experience in Creating Crystal Reports, Xcelsius on Live Office, Qaaws (Query as a

web service).

• Knowledge on BI widgets.

• Experience in SAP bo bi platform 4.0 suite such as IDT(Information Design Tool, BICS

connection for SAP Bex,Web I,BI launch pad,dash board designer tool, Crystal report

tool, UMT and LCM

• Have an eye for Detail and flair for learning.

SKILL SET:

Business Intelligence : Business Objects R2/XI R3/R4, Central Management Console,

Central Configuration Manager, Web / Desktop / OLAP

Intelligence, Designer, Enterprise Performance / Information

Manager, Xcelsius, Crystal Reports for Enterprise,

Crystal Xcelsius 2008/2011, Dashboard Design Tool, Import

Wizard, Publisher, UMT, LCM

Data Modeling : Star-Schema and Snowflakes Modeling, FACT and Dimension

Tables.

RDBMS : Oracle 10g/11g

Programing : Sql, pl/sql

Environments : Win NT/XP/2003/2000, MS DOS.

Industry Application : Retail, Manufacturing and Logistics.

EDUCATIONAL QUALIFICATION:

• B.TECH in Computer Science engineering from J.N.T.U.A(2005-09) with 70.5%

EMPLOYMENT:

• Working as a SAP BO Consultant for ‘Cognizant’ Hyderabad since Feb 2012 – Till date.

• Worked as SAP BO Developer for ‘Head Strong’ Hyderabad since Aug 2010 – Jan 2012.

PROFESSIONAL EXPERIENCE:

Project 1:

Client : HR Automation Process

Date : Feb 2012 to Till Date

Role : Business Objects Developer

Environment: Business Objects XI R3/R4 (CCM, CMC, Designer, Web Intelligence, Desktop

Intelligence, Import Wizard, Dashboards, Widgets), Crystal Reports, Xcelsius, Information Design

Tool, Dashboard Design Tool, BI launch pad,UMT,LCM, Windows XP.

Description:

It is for the HR, to automate the recruitment process it is to analyze the attrition percent

of the employees. The business analysis phase captured the requirements for the different types

of recruitment process. The total data will be generating in the form of reports through Webi,

Xcelsius, Dashboard Design Tool, Crystal Report 2008/2011, and Xcelsius.

Roles &Responsibilities:

• Attended Business meetings and assisted Business Analysts in gathering

requirements.

• Designed universes and applied row level and objects level restrictions to different

groups and users as required.

• Used joins concept by taking different tables from different data sources in the

Universe.

• Interacted with Oracle App’s team members to understand the BRD’s and convert

them to tangible Technical spec’s to be used in report specifications.

• Coordinating with onsite team to update the business requirements. Work hand-hand

during the entire product development.

• Created Classes (Sub classes), Objects, Prompts and Predefined conditions and

user defined objects and custom Hierarchies for drill down purposes.

• Used @Functions like @Prompt (for user defined queries), @Where (for creating

conditional filters), and @Select to create duplicate objects in the process of building

the Universes.

• Tested Universe and Reports, which includes

Database connectivity.

Resolved loops and contexts to ensure the correct results from the query.

Objects in the universe, to ensure the correct mapping of the objects.

Aggregate awareness to ensure the query is pulling correct level of

aggregation.

Verified the data by running the SQL against the database.

• Designed and Developed Web I Reports using the features like Master/Detail,

Charts, Cross Tabs, Slice and Dice, Drill Down and Formulae to analyze the data.

• Created user Prompts, Conditions and Filters for various reports to specify the

reporting parameters.

• Created Universes Using Information Design Tool.

• Converting XIR3 Universes Into R4 Universes.

• Created BICS connection for SAP BEX Query and created web i reports on Bex

Query

• Performed Unit Testing of the reports.

Project 2:

: AstraZeneca, UK.

Client

: Oct 2010 – Jan 2012

Duration

: SAP BO Developer

Position

Team Size : 6 Members

Environment: Business Objects R2/XIR3, Business Objects Info view (Web i), Crystal reports XI,

Xcelsius, Designer, Import Wizard SQL server, Oracle, Toad, Windows NT.

Project Description:

AstraZeneca is a British multinational pharmaceutical and biologics company

headquartered in London, United Kingdom. it is the world's seventh-largest pharmaceutical

company measured by revenues and has operations in over 100 countries, It has a portfolio of

products for major disease areas including cancer, cardiovascular, gastrointestinal, infection,

neuroscience, respiratory and inflammation. AstraZeneca has 10th-largest of any company with a

primary listing on the London Stock Exchange. It has secondary listings on the New York Stock

Exchange and the OMX exchange.

Roles & Responsibilities:

• Attended Business meetings and assisted Business Analysts in gathering requirements

• Interacted with Oracle App’s team members to understand the BRD’s and convert them to

tangible Technical spec’s to be used in report specifications

• Documented requirements and performed Gap analysis to identify the gaps

• Involved in Creating and maintaining Universes by using Universe Designer.

• Created Classes and Objects in Universes, According to Functional specifications.

• Created reports by taking data from different data source.

• Involved in the modifying and Building of Universes, Classes and objects.

• Created objects and defined them accordingly into measures, dimensions and detail.

• Used joins concept by taking different tables from different data sources in the Universe.

• Set up Universe level conditions to restrict data based on Functional specifications.

• Involved in creating Aliases and contexts in Universe Designer.

• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill

Down and Formulae’s.

• Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.

• Created Web-I reports as per the Functional specifications.

• Used the formatting options like cross tab, sections, breaks, data sort.

• Created reports with different charts, Prompt filters as per Functional specifications.

• Published the reports and universes to live repository.

• Created Report level conditions to restrict data, based on report requirements.

• Used @select, @where, @variable, @prompt and @aggregated awareness functions in

universe development.

• Implemented Row & Object level security for different user groups as per the Functional

Specifications.

• Created various dashboards using Crystal reports, XCelsius.

• Performed unit testing of the reports.

PERSONAL DETAILS:

Name : Sujitha N

Gender : Female

Nationality : Indian

Languages : English, Telugu

Marital Status : Married

Signature

Sujitha N

Contact this candidate