Sql Server Data

Rakesh

******.*****@*****.***

BO Consultant

Cell: 956-***-****

PROFESSIONAL SUMMARY:

. 9 years of experience in IT industry and with strong background in

Analysis, Design and Development in the field of Database, Data Warehouse

and implementation of Business Objects for BI applications.

. 8 years of experience in Reporting tool SAP-Business Objects XI

4.0/3.1/XI R-2/6.5

. Involved in the full System Development Life Cycle (Analysis,

Development, Deployment, Testing And Documentation)

. Experienced in planning, organizing, rescheduling and managing Business

Objects.

. Expertise in Installation administration and migration of business

objects BO-XI R-2/BO-XI 3.1/4.0 .

. Expertise in Business objects upgrade and migration from BO-XI R-2 to BO

3.1/BO 4.0.

. Expertise in migrating the report and universe from Dev, Test and

Production environment using import wizard.

. Expertise in creating report in BOBJ-WEBI,BOBJ-DESKI and BOBJ-Rich client

. Expertise in backup and recovery of business object environment using

BIAR file.

. Expertise in Designing, Developing and managing the complex universes.

. Expertise in creating universe on SAP BW source.

. Expertise in dimensional modeling and data modeling experience.

. Expertise in understanding the ETL process and dataflow of data

warehouse

. Highly skilled in creating Adhoc/Canned Reports, Complex Reports using

predefined conditions.

. Worked on Business Objects functionalities like Queries, Slice and Dice,

Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and

Formulae.

. Worked on desktop and WEBI reports.

. Worked in creating hyperlinks and passing values between summary and

detail reports.

. Worked in creating views and metalized views for implementing the

different securities.

. Experience in deployment of Business Objects & Web Intelligence on

Various Sources Oracle, MS SQL Server 2005 /2008 and MS-Access.

. Extensive experience in interacting with users for requirement gathering,

analyzing and Software Design Specifications.

. Excellent Interpersonal Skills and self-starter, capable of working

independently.

. Excellent troubleshooting skills, Analytical, problem solving and

quantitative skills.

TECHNICAL SKILLS

BO Client Server Tools: Business Objects 4.0/3.1/XIR2/6.5/5.1

Reporter, Designer, Supervisor, and Web

Intelligence, Crystal 2008, Xcelsius

ETL: Informatica 7.1/8,BODS, SSIS.

Databases: Oracle 11g/10, MS SQL Server 2005/2008

Languages: JAVA,MICROSOFT.NET, ASP, COBOL, C, C++, XML, Visual Basic,

HTML

Data Warehousing: Star Schema, Snow Flake, Data Modeling

PROFESSIONAL EXPERIENCE

Newmont Mining Corporation, Greenwood Vlg, CO

Nov 2011-

Till Date

Business Objects Consultant

Responsibilities:

. Interacted with Business Users and Business Owners to know their

Business views in developing and modifying Universes and Reports

accordingly.

. Involved in gathering, analyzing, and documenting business

requirements, functional requirements and data specifications for

Business Objects Universes and Reports.

. Design and Development of Business Objects Universes, which suits

the standard, analytical and ad-hoc reporting requirements of the

Business Objects users.

. Involved in the gathering requirements of universe and report

design.

. Created the class and objects of the universe and according to the

user requirement.

. Did the analysis on SAP Bex quires and created universe on Bex

quires.

. Installed and deployed the business object 3.1 software in Dev,test

and production environments.

. apply the different levels of group and folder level security.

. apply the security for sub groups by breaking inheritance and

disabling the inheritance.

. involved in maintenance of Business objects servers and on call

support 24/7

. Involved the priority ticket environment and support eh user and

developer.

. Created reports on Bex-quries universes.

. Created the user objects and predefined conditions.

. Created Aliases and Contexts for resolving Loops and checked the

Integrity of the Universe.

. Created hyperlinks in summary reports to navigate to detail report

. Created the custom hierarchies for drill down and drill up.

. created the derived tables in the universe to avoid the creation of

views at database level

. Created different error messages and block the popup by using dummy

objects.

. Created the WEBI reports on universe.

. Created the desktop reports using desktop intelligence for Users.

. Exported the reports in to PDF & Excel formats.

. Designed and document the test cases for testing team.

Environment: Business Objects3.1/4.0, WEBI, Designer, Infoview, SQL,

PL/SQL, Oracle11, DB2 and Windows 2008,SAP BW.

People's United Bank, Bridgeport, CT

Feb 2010-Nov 2011

Business Objects Consultant

Responsibilities:

. Involved in gathering the user requirements and created the mockups

. Created Users and roles, granted privileges to role and roles to

users according to user level to access data to enforce object

level security.

. Implemented Row & Object level security for different user group

requirements.

. Created initial Classes & Objects, qualification for the Universes

in both on/off line modes.

. Defined Aliases and Contexts to resolve the join issues in the

Universe.

. Solved the issues during designing such as loops, Cartesian product

due to fan trap and chasm traps.

. Exported the universes to the Repository for making resources

available to the users.

. Created reports for various Portfolios using the Universes as the

main data Providers.

. Created the reports using Business Objects functionalities like

Queries, Slice and Dice, Drill down, @Functions, Cross Tab,

Master/Detail and Formulas etc.

. Built full client and WebI reports, according to end user

requirements.

. Created user Prompts, conditions, and filters for various reports

to specify the reporting parameters as per business requirements.

. Coding and testing of new reports and mocking up data as necessary.

. Experience in design of data models (3NF, Star Schema, Snow flake

schema) and implementation of enterprise data warehouse, data mart

and OLAP solution.

. Experience in design of BI process documents, technical

specification, templates, standards and best practices.

. Created the new Views and Aggregate tables for report performance.

. Extensive testing and migrating the reports or objects from

development to Production system.

. Automated the reports for refreshing the data every month and

quarter details.

. Responsible for giving Business Objects classes for the entire

staff that was using reports.

. Hide objects for different users to maintain data availability

based on Business requirements.

. Trained user community in basic and advanced Business Objects

reporting skills.

. Analyzed all tables and created various indexes to enhance query

performance and written hints in query for tuning the query

.

Environment: Business Objects3.1, Data Modeling (3NF/OLTP, Star Schema,

DWH/BI, etc.), WEBI, DESKI, Designer, Infoview, SQL, PL/SQL, SQL server

2008 Oracle 11,DB2 and Windows 2008.

FreePort McMoran Copper and Gold Inc. Phoenix, AZ

AuG 2008 - Feb 2010

Business Objects Consultant

Responsibilities:

. Involved in Full life cycle design and development of Business

Objects reporting Applications.

. Interacted with end users regularly for initial requirements

gathering.

. Presentation of the advanced features of Business Objects to end-

users to enable them to develop queries and reports easily.

. Involved in the development and implementation of ad-hoc reporting

system using Business Objects.

. Tasks involved were report development, modifying Universes to suit

the Business Requirements.

. Applied security features of Business Objects like row level,

report level & object level security in the universe so as to make

the sensitive data secure.

. Designed and created Universes using Designer module. Created

Contexts and Aliases for resolving Loops in the Universes.

. Generated number of reports on a daily, weekly and monthly basis

using Business Objects Report module.

. The reports were generated using Business Objects functionality

such as Slice and Dice, Drill Down,

Master/detail, Prompts and Formulas

. Extensively used Calculations, Variables, Breaks, Sorting, and

Alerts for creating Business Objects reports.

. Implemented various @Functions like @Prompt (for user defined

queries), @Where (For creating conditional filters), and @Select.

. Generated and published web reports in InfoView using Web

Intelligence and scheduled Business Objects Reports through Broad

Cast Agent.

. Worked along with the testing team to derive test cases for

efficient Data reporting.

.

Environment: Business Objects3.1, WEBI, DESKI,Designer, Infoview,

SQL,Oracle 10,DB2 and Windows 2003.

PLANTRONICS INC,SANTA CRUZ,CA April

2007 - Aug 2008

Business Objects Consultant

Responsibilities:

. Studied the existing business rules and understood the client's new

reporting requirements by interacting with the Business managers

and users.

. Involved in designing universes and objects by retrieving the data

from various data sources and defining the necessary connections.

. Created new reports from the scratch for new requirements and

modified some of the existing reports in three different Universes.

. Created new Attributes, Filters and Complex measure objects in the

Universe.

. Provided support to the Web Users and Full client users for any

specific or performance issues related to the reports.

. Resolved Loops, Fan traps and Chasm traps with Aliases and

Contexts.

. Creating Measure objects and hierarchies to enable drill down

functionality in the reports.

. Created custom LOV's and Hierarchies for easy user selection drill

down purposes.

. Exported the Universe/Reports to the Repository/Broadcast Agent for

automation.

. Worked on the SQL tuning and optimization of the Business Objects

reports

. Worked with multiple Data providers in a report and added slice and

dice capabilities.

. Extensively used various techniques Sectioning, Ranking, and

Filtering to develop the reports.

. Developed Cross-Tab and Drill Down reports.

. Used Broadcast Agent to schedule the reports.

. Formatted the Reports as per the Users requirements using all the

facilities in Business Objects, which allows the users to analyze

the data.

. Exported the reports in to PDF, Excel and Word formats.

. Worked with other team members in US through net meeting and

teleconferencing

. Extensive testing and migrating the reports or objects from Test to

Production system.

. Worked along with the testing team to derive test cases for

efficient Data reporting.

. Conducted the Unit testing and prepared the testing document and

creating the error log document.

. Performed the knowledge transfer to other team members. Provided

application and user on-call support

Environment: Business ObjectsXIr2, Oracle 9i, PL/SQL, and Windows NT

Zales Corporation, TX

Feb 2005 - Feb 2007

Business Objects Consultant

Responsibilities:

. Interacted with end-users and business analysts to identify and

develop business Requirements and transform it into technical

requirements and ultimately responsible for delivering the

solution.

. Created new classes & User Objects in designing the Universes

. Designed, developed and managed Universes in the Designer for

report generation.

. Analyzed and defined requirement analysis for Business Objects

Reporting.

. Defined Aliases and Contexts to resolve the join problems in the

Universes.

. Created reports using Business Objects suite functionality like

Slice and Dice, Drill down function and formulas.

. Created Hierarchies and predefined conditions using Business

Objects.

. Extensively used Calculations, Break points, Drill down, Slice and

Dice, Alerts for creating Business Objects reports.

. Created complex reports using user-defined functions, condition

objects and aggregate awareness functions for SQL enhancement.

. Formatted the reports as per the business requirements.

. Created User conditions, Filters to improve report generation &

readability of report and displayed the summary of data by creating

Charts.

. Created reports using Oracle/MS SQL Server databases and personal

data file providers.

Environment: Business Objects 6.5/XIr2, MS SQL Server, Oracle 8.1.3, Web

Intelligence, Windows 2000/NT, SQL, PL/SQL.

Contact this candidate