DEEPTHI BOOSA

acgr5y@r.postjobfree.com

Mobile: 845-***-****

SUMMARY:

> Around 7 years of professional experience in Business designing and

development and SAP Business Objects Reporting Applications.

> Expertise in gathering, analyzing and documenting business

requirements, functional requirements, and data specifications for SAP

Business Objects Universes and Reports.

> Experience in designing SAP Business Objects universes, generating

complex reports in Web Intelligence and Desk Intelligence.

> Data Modeling experience in analyzing, designing and modeling data

warehouses and star schema data marts for various business verticals

like Health Care (Pharmacy), and Financial.

> Good at Database Design, conceptual, logical and physical Data

Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly

changing dimensions (SCDs).

> Good Knowledge on Business intelligence, OLAP, Dimensional modeling,

Star and Snowflake schema, extraction.

> Worked on migrating Business Objects from earlier versions to Version

XIR2. Extensively used the import wizard in moving reports and

universes from lover version of Bo to higher version like from 6.5 to

XI, XI R2 and XI 3.1.

> Good Experience in CMC, adding Users and Groups, Assigning Password

Security, Assigning Privileges to Documents and Universes.

> Designed, implemented and migrated complex Universes and Business

Objects Reports, Created classes, subclasses, objects, Cardinalities,

Conditions, Contexts, Joins, External Strategies, Prompts and Aliases

for resolving Loops and checked the Integrity of the Universes.

> An enthusiastic, project-oriented team player with leadership skills

and with an ability to develop creative solutions for challenging

client needs.

> Solid Experience in writing SQL queries, PL/SQL records & tables.

> Experience in resolving join path problems like Loops and Traps in the

universes using Aliases,

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

> Expertise in Development, Maintenance, Testing and Validation of the

data using Business objects Reports.

> Expertise in databases to include TERADATA, NETEZZA, Oracle 10g/9i, MS

SQL 2005/2000. Expertise in Universes for Customized Metrics and Goals

to Create Metric Analytics and Goal Analytics.

> Good Communication and Interpersonal skills. Technically sound, Result-

Oriented with strong Problem solving skills. Innovative & efficient

> Recommended standards of good practices of report development and

maintenance of universes.

> Flexible and versatile to adapt to any new environment with a strong

desire to keep pace with latest technologies.

> Modified the existing universes for performance tuning and maintained

common dimensions across all the universes with unique naming as a

part of clean up activity.

> Expertise in Universes for Customized Metrics and Goals to Create

Metric Analytics and Goal Analytics.

> Proficient in design, development, coding, implementation and Support.

> Excellent Written, Analytical communication and strong interpersonal

skills with ability to interact with end-users, managers and technical

personnel.

TECHNICAL SKILLS:

Business Objects 4.0, IDT, XI 3.1(R3.1)/R2, SIA, Central

OLAP Tools Management Console, Central Configuration Manager, Designer,

Desktop Intelligence, Web intelligence, Webi Rich client,

Report Conversion Tool.

RDBMS TERADATA, NETEZZA, Oracle 10g/9i, SQL Server 2000/2005.

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

Operating MS-DOS, Windows 2003/XP/NT/2000.

System

Microsoft Office tools namely Access, Excel, Outlook,

Software PowerPoint and Word, SAP related to Business Warehouse and

Skills very good knowledge on Business Objects.

PROFESSIONAL EXPERIENCE

Ford Motor Company

Nov

2013 - Jun 2014

Sr. SAP Business Objects Consultant

Ford Motor Company, a global automotive industry leader based in Dearborn,

Mich., manufactures or distributes automobiles across six continents. With

about 172,000 employees and 65 plants worldwide, the company's automotive

brands include Ford and Lincoln. The company provides financial services

through Ford Motor Credit Company.

Responsibilities:

> Analyze User requirements, compare between the old and the new

requirements, document the results, and communicate gaps and possible

issues to the relevant groups.

> Also, interacted with Business Users and Business Analysts to gather

the Business Requirements and translated them into Reporting

Requirements to be used as an Input in Designing Universes and

Reports.

> Maintaining a team of four people and directly interacting with USA

client through WebEx or calls.

> Validate Screen Technical specifications with technical designs

created by IT developers.

> Handled regular deployment issues across Dev, Prod and Test

environments.

> Created new Ad-hoc Reports using Desktop and Web Intelligence.

> Provide technical and analytical support of systems analysis and

design, development, implementation, production support, maintenance,

enhancement and troubleshooting.

> Review all system work before applications are incorporated into

production.

> Create and maintain documentation on Universe and SAP Business Objects

deliverables.

> Implemented Data warehousing schemas like Star-Schema, Snow-Flake

Schema.

> Involved in the designing and Building of Universes, Classes and

objects

> Resolved loops and Traps using Contexts and Aliases while designing

Universes.

> Set up Universe level conditions to restrict data based on report

requirements.

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

and Developed Custom hierarchies to support drill down reports

> Created Derived tables in the Designer to enhance the capabilities and

performance of the universe

> Customized Universe level Prompts as per Functional Requirements.

> Check the integrity of the Universes, and export the universes to

Repository for making available to users.

> The project involved in the development of reports using Business

Objects Web Intelligence to cater Ad-hoc reporting needs.

> Created reports using Business Objects functionality's like Queries,

Drill Down, Cross Tab, Master Detail and Formulae's.

> Created the reports using Business Objects functionalities like

Combined Queries, Drill down, Cross tab, Master detail and Formulae.

> Created Standard Reports utilizing all the features on Web

Intelligence in BOE XI 3.1 like Optional Prompts, Functions, Alerters

etc.

> Created Breaks, Filters at Different Levels of the reports and applied

ranking in the Webi reports.

> Extensively worked with formatting the reports according to the user

requirements.

> Used Web intelligence to create, edit and set different options for

the corporate documents.

> Worked with multiple data providers and linked these data providers

based on the requirements.

> Involved in creation of hierarchies and linking Universes (Linked).

> Prepare technical specification documentation.

> Involved in performance tuning and optimization on Business objects

reports.

> Created Report Templates for consistency in the look and feel of the

reports.

> Exported Reports to the Repository for making resources available to

the users.

Environment: Business Objects XIR3.1 SP3, Info View, Universe Designer, Web

Intelligence, Desktop Intelligence, CMC, TERADATA and Oracle 10.

CSC

Apr 2012 - Nov 2012

Sr. SAP Business Objects Developer

CSC is a global IT services company. Our people do amazing things to help

businesses, government and communities solve their toughest challenges.

Learn more about the industries we serve, our solutions portfolio, where

we're located and what makes CSC different from other technology companies.

CSC is a global leader of next-generation information technology

(IT) services and solutions. Our mission is to enable superior returns on

clients' technology investments through best-in-class industry solutions,

domain expertise and global scale. CSC's Corporate Responsibility program

fosters our company's growth by promoting and increasing the value of CSC

to our shareholders, clients, communities and employees.

Responsibilities:

> Create, develop and maintain critical Universe from scrap and

analyze User requirements, compare between the old and the new

requirements, document the results, and communicate gaps and

possible issues to the relevant groups.

> Creating Universes with NETEZZA database with background of ORACLE

and DB2 universes, gathering and comparing the information as per

the required.

> Also, interacted with Business Users and Business Analysts to

gather the Business Requirements and translated them into Reporting

Requirements to be used as an Input in Designing.

> Prepare technical specification documentation.

> Validate Screen Technical specifications with technical designs

created by IT developers.

> Handled regular deployment issues across Dev, Prod and Test

environments.

> Created new Ad-hoc Reports using Desktop and Web Intelligence.

> Provide technical and analytical support of systems analysis and

design, development, implementation, production support,

maintenance, enhancement and troubleshooting.

> Created universes, classes, objects, Prompts, Predefined

conditions, by retrieving the data from data sources and defining

the necessary connections.

> Involved in the troubleshooting of universe schema with loops,

chasm and fan traps, and cardinality problems.

> Implemented the Object-Level Security and Row-level security in

Universe. Implementing the Table Mapping in Universe to restrict

certain data in a table to only one group of users.

> Designed and developed extensive Business Objects reports like

Simple, Complex, Cross Tab using multiple Queries, Prompts,

combination chart and tables.

> Created, maintained and modified the business critical reports

using the Web Intelligence.

> Created Standard Reports utilizing all the features on Web

Intelligence in BOE XI 3.1 like Optional Prompts, Functions,

Alerters etc.

> Created complex reports using Merged Dimension and multiple data

providers and synchronized the data providers by linking the common

objects to create the common report.

> Review all system work before applications are incorporated into

production.

> Create and maintain documentation on Universe and SAP Business

Objects deliverables.

> Worked with multiple data providers and linked these data providers

based on the requirements.

> Involved in performance tuning and optimization on Business objects

reports.

Environment: Business Objects XIR3.0 SP3, Info View, Universe Designer, Web

Intelligence, Desktop Intelligence, CMC, NETEZZA, DB2 and

Oracle 10.

Department Of Workforce Development (State of Wisconsin)

Jan 2011 - Mar 2012

Sr. SAP Business Objects Consultant

Workforce development is an American economic development approach that

attempts to enhance a region's economic stability and prosperity by

focusing on people rather than businesses. It is essentially a human

resources strategy. Workforce development has evolved from a problem-

focused approach, addressing issues such as low-skilled workers or the need

for more employees in a particular industry, to a holistic approach

considering participants' many barriers and the overall needs of the

region. Today workforce development often is seen as a solution to issues

of social equity. One example is New York's Workforce Development Institute

(WDI) which sponsors programs for disadvantaged workers and funds the NYS

Apollo Alliance to bring social activists, businesses, organized labor, and

educator's together to address energy and environmental justice concerns.

Responsibilities:

> Analyze User requirements, compare between the old and the new

requirements, document the results, and communicate gaps and

possible issues to the relevant groups.

> Interacted with Business Users and Business Analysts to gather the

Business Requirements and translated them into Reporting

Requirements to be used as an Input in Designing Universes and

Reports.

> As a part of Universe development, created Classes, different kinds

of objects, cardinalities, Strategies, resolving loops using

Aliases and Contexts.

> Implemented Default & Custom Hierarchies, conditions on Lov,

Derived tables and @functions.

> Troubleshooting support tickets for operational issues

> Building improvements in Monitoring

> Managing security

> Working through a root/cause analysis and following up on action

items

> Applying patches and upgrades as necessary

> Managing Promotions of reports through the Development, Test,

Production process

> Performing as a member on projects where Business Objects

infrastructure expertise is required.

> Created new Universes in XIR3 right from scratch.

> Converting more than 400 reports from Desktop Intelligence to Web

Intelligence in BOXIR3.

> Create new Ad-hoc Reports using Desktop and Web Intelligence.

> Involved in Training and Educating regarding the Business Objects

XIR3 Capabilities, Navigation specific information and importance

of moving to Web Intelligence from Desktop Intelligence.

> Work on hierarchies, Global filters and Universe filters.

> Involved in support for fixing the bugs reported from System and

UAT test.

> Interacted with the users to analyze the changes for improvement

they needed in existing reports, and developed the reports to

satisfy their needs and requirements.

> Involved in performance tuning and optimization on Business objects

reports.

> Created Report Templates for consistency in the look and feel of

the reports.

> Exported Reports to the Repository for making resources available

to the users.

> Publish and schedule Business object Reports to users using

Publication.

> Tuning the queries to improve the performance of the report refresh

time.

> Work closely with DBAs to create aggregate tables to support

Universes and dashboard.

Environment: Business Objects XIR3.1 SP3, Info View, Universe Designer, Web

Intelligence, Desktop Intelligence, CMC, Oracle 10.

ST. Jude Medical

August 2010 - January 2011

Business Analyst and Sr. SAP Business Objects Developer

St. Jude Medical develops medical technology and services that focus on

putting more control into the hands of those who treat cardiac,

neurological and chronic pain patients worldwide. The company is dedicated

to advancing the practice of medicine by reducing risk wherever possible

and contributing to successful outcomes for every patient. The St. Jude

Medical product portfolio includes implantable cardioverter defibrillators

(ICDs), cardiac resynchronization therapy (CRT) devices, pacemakers,

electrophysiology catheters, mapping and visualization systems, vascular

closure devices, heart valve replacement and repair products, spinal cord

stimulation and deep brain stimulation devices.

Responsibilities:

> Analyze User requirements, compare between the old and the new

requirements, document the results, and communicate gaps and

possible issues to the relevant groups.

> Also, interacted with Business Users and Business Analysts to

gather the Business Requirements and translated them into Reporting

Requirements to be used as an Input in Designing Universes and

Reports.

> Prepare technical specification documentation.

> Validate Screen Technical specifications with technical designs

created by IT developers.

> Handled regular deployment issues across Dev, Prod and Test

environments.

> Created new Ad-hoc Reports using Desktop and Web Intelligence.

> Provide technical and analytical support of systems analysis and

design, development, implementation, production support,

maintenance, enhancement and troubleshooting.

> Review all system work before applications are incorporated into

production.

> Create and maintain documentation on Universe and SAP Business

Objects deliverables.

> Worked with multiple data providers and linked these data providers

based on the requirements.

> Developed queries, Stored Procedures Using SQL programming to

improve the performance of the Reports using complex queries.

> Created financial reports, charts using Universes as the main data

provider. Reports such as Quarterly variance, Regional, Actual vs.

Forecast, Balance sheets etc were developed.

> Developed Summary/Detail/Drill Down reports and some of the reports

include Inventory Details, Pending Charges, Storage Charges,

Customer Invoices, Print Tickets and G/L Postings and were

generated daily, weekly and monthly basis.

> Developed Scorecards report and also Deski reports with free hand

sql.

> Involved in performance tuning and optimization on Business objects

reports.

> Created Report Templates for consistency in the look and feel of

the reports.

> Exported Reports to the Repository for making resources available

to the users.

Environment: Business Objects XIR3, Info View, Universe Designer, Web

Intelligence, Desktop Intelligence, CMC, SQL Server 2005, and Xcelsius 2008

SP3.

S V Tech

June 2009 - August 2010

SAP BO Consultant

SV Tech Inc. is a fully integrated technology and operations firm,

ensuring businesses to operate more productively and

Profitably through a full spectrum of IT services, including

specialized staffing, project implementation services and products.

It is a leading developer of innovative software products, custom

solutions, and professional services. Following established standards

and proven quality control methodologies, our staff brings a unique

perspective to each project. Our history of successful engagements

gives us unique insight into telecommunications network management

systems that perform beyond expectations.

Responsibilities:

> Created, designed and developed Business Objects applications

using BOXI.

> Developed User Interface Screens using Data List and Grid view

based on requirements.

> Have known, how to created WSDLs using Query as a Web Service

(Qaaws) from different Data sources.

> Got to know the designing, developing, deploying and maintaining

universes used Business Objects designer.

> Created Universe for Ad-hoc and Canned Reporting purpose based on

DDL.

> Writing specifications and developing SQL Stored Procedures.

> Developing test cases and performing unit and integration

testing.

> Implemented how to do Custom Error handlers, Custom Exceptions,

Custom Error Pages.

> Create and maintain documentation on Universe and SAP Business Objects

deliverables.

> Worked with multiple data providers and linked these data providers

based on the requirements.

> Involved in creation of hierarchies and linking Universes (Linked).

Environment: Business Objects, Info View, Universe Designer, Web

Intelligence, Desktop Intelligence, CMC, Oracle.

ICICI Bank Ltd

May 2006 - April 2008

Business Objects Developer

ICICI Bank was originally promoted in 1994 by ICICI Limited, an Indian

financial institution, and was its wholly-owned subsidiary. ICICI's

shareholding in ICICI Bank was reduced to 46% through a public offering of

shares in India in fiscal 1998, an equity offering in the form of ADRs

listed on the NYSE in fiscal 2000, ICICI Bank's acquisition of Bank of

Madura Limited in an all-stock amalgamation in fiscal 2001, and secondary

market sales by ICICI to institutional investors in fiscal 2001 and fiscal

2002. ICICI was formed in 1955 at the initiative of the World Bank, the

Government of India and representatives of Indian industry. The principal

objective was to create a development financial institution for providing

medium-term and long-term project financing to Indian businesses.

Responsibilities:

> Learned and Created and maintained universes on OLAP (Online

Transaction Analytical Processing) databases.

> As a part of Universe development, created Classes, different kinds of

objects, cardinalities, Strategies, resolving loops using Aliases and

Contexts.

> Implemented Default & Custom Hierarchies, conditions on Lov, Derived

tables and @functions.

> Created Reports using Drill down, Cross tab and Charts (column, line,

pie). Used the drill functionality, ranking, sorting, complex alerter

and variables in full client reports.

> Experience in creating reports by using various templates according to

the needs of users.

> Used Desktop Intelligence, Web Intelligence for Ad hoc reporting.

Customized the Info view to have the start page as the "my documents"

page and set the default option of viewing the reports based on the

user profile.

> Created financial reports, charts using Universes as the main data

provider. Reports such as Quarterly variance, Regional, Actual vs.

Forecast, Balance sheets etc. were developed.

> Developed Summary/Detail/Drill Down reports and some of the reports

include Inventory Details, Pending Charges, Storage Charges, Customer

Invoices, Print Tickets and G/L Postings and were generated daily,

weekly and monthly basis.

> Created reports on with predefined filters and able to select for

particular Regions, Masters (companies), Divisions and Employee.

Environment: Business Objects, Info View, Universe Designer, Desktop

Intelligence, SQL Server.

Contact this candidate