Sql Server Manager

SANDHYA V

PROFESSIONAL SUMMARY:

• Over *.* years of experience in Information technology with experience in complete life cycle of

Software products involving Analysis, Design, Development, Implementation, Testing and support for

various data warehousing applications including 7+ years experience in Business Objects.

• Hands on experience in gathering business requirements in Manufacturing, Financial Services,

Insurance and Retail, Energy by interacting with Business Users and translating them into technical

specifications.

• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact and

dimensional tables. Experience includes designing, implementing and integrating various Data warehouse

and Data Marts using Oracle 11g, 10g/9i, MS-SQL Server, DB2.

• Well versed in Business Objects (BOBJ) 4.0, XI R3 and XI R2 with experience in Universe

Designer, Information Designer, Dashboard Designer, Reporter, Infoview and Web Intelligence,WebI

Rich Client.

• Working experience in the new features of Business Objects 4.0 including BI Launch Pad,

Information Design Tool, Derived tables, Central Management Console, Live Office.

• Working knowledge in Crystal Reports XI / XI R2, 2008.

• Extensive experience in developing static and dynamic dashboards using Xcelsius 2008 via the web

service connectors like QAAWS, Live Office.

• Workable knowledge in generating the reports using Crystal Enterprise 4.0 using the BICS

connections and BW BEx Query, SQL Server, Oracle as data sources.

• Knowledge in building, extraction, transformation and loading (ETL) Worked with Modeler and

DBA for new customized views Involved in lot of data testing and sending the load issues to the ETL.

• Working experience using Universe Designer, WebI, DeskI, Publishing Wizard and Import Wizard,

LCM in XI R3.

• Experience in building Universes, Stored Procedures, Free Hand SQL methods and creating

Complex and Ad-Hoc Reports using Business Objects.

• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and

Dice, Drill Down, Filters, Ranking, Sections and Breaks.

• Extensive expertise in using Import Wizard for migrating the Universes and Reports between

different environments like Dev, QA and Production.

• Extensive expertise in using LCM (Life Cycle Manager) for migrating the Crystal Reports

between different environments like Dev, QA and Production.

• Proficient in designing universes by selecting and joining tables, resolving loops by using aliases

and contexts. Solid understanding and experience in administration activities like setting up of Repositories,

creating, managing users and user groups.

• Extensive experience in using Report Conversion Tool to convert Desktop Intelligence reports into

Web Intelligence reports

• Effectively administered and supervised the Business Objects environment by monitoring/granting

permissions and User management tasks such as adding Users, AD groups and setting up security on

Project folders, Universe folders, Connections etc. through CMC (Central Management Console).

• Trained and Educate End Users about the use of universe, features of Business Objects,

generation of reports, provided technical support and documentation.

• Good Understanding in Business Objects Framework (Architecture) and functionality.

• Expertise in Installation, Configuration, Up-gradation, Universe Design, Performance

Tuning/Optimization, User/Security using Business Objects versions: 4.0, XI R3, XI R2, 6.x.

• Experience in Integration of Infoview/ webI in the applications using BO SDK in Java environment

• Excellent experience in writing PL/SQL Stored Procedures, and Functions using Oracle 11g,10g /9i

/8i/7.3, SQL, PL/SQL, TOAD.

• Excellent experience in writing T-SQL, Stored Procedures, and Functions using SQL Server 2008/

2005.

• Strong knowledge of complete SDLC (Software Development Life Cycle) and software quality

management.

• An enthusiastic and project-oriented team player with solid communication skills, analytical skills,

documentation skills, problem solving skill and leadership skills and the ability to develop creative

solutions for challenging client needs.

• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest

technologies.

TECHNICAL SKILLS:

• Business Intelligence Tools: BI 4.0 and Business Objects(BOBJ) XI R3, XI R1/R2, 6.x. Enterprise

Suite – Central Management Console(CMC), Central Configuration Manager(CCM), Import Wizard, Life

Cycle Manager(LCM), Publishing Wizard, Repository Migration Wizard, Universe Design Tool (UDT),

Information Design Tool (IDT), Desktop Intelligence, Web Intelligence, WebI Rich Client, BI Launch Pad,

Infoview, Crystal Reports 2008, XI R1/R2, 10, 9, Xcelsius 2008, Dashboard Designer, Live Office, Query As A

Web Service, SQL Reporting Services 2008.

• ETL Tools: Informatica Power Center 6.1, SQL Server Integration Services 2008

• Databases: Oracle 11g, 10g/9i/8i, SQL, PL/SQL, Teradata, MS SQL server 2008/2005, DB2.

• Operating Systems: Windows 2000/XP, Windows Server 2003/ 2008

• Languages: C/C++/C#, PL/SQL, Java

PROFESSIONAL EXPERIENCE:

FEDEX GROUND (MOON TOWNSHIP, PITTSBURGH, PA): Jan’2013 - Present

Senior Business Objects Developer/ Writer

FedEx Ground is a shipping company that is a subsidiary of the FedEx Corporation. It is headquartered in Moon

Township, Pennsylvania, a suburb of Pittsburgh. FedEx Ground specializes in cost-effective, small-package shipping,

offering dependable business-to-business delivery or convenient residential service through FedEx Home Delivery

and FedEx SmartPost. Originally conceived as a lower cost competitor to UPS, Roadway Package System (RPS) was

created to take advantage of new barcode, material handling and computer technologies.

Responsibilities:

• Analysed and understood the FedEx Ground databases and designed schemas.

• Interacted with multiple project owners to Gather and understand the Business requirements and to collect

the new report requirements and also enhancements to the existing business

requirements

• Provided the alternative solutions to the report requirements to achieve the requirements using Business

Objects

• Converted the business requirements into TDR (Technical Design Review), BOR (Business Objects Report)

and Testing Documents

• Worked on BI 4.0 tools like Web Intelligence 4.0, Information Design Tool (IDT), and BI Launch Pad

• Involved in migration of BO Objects like webI Reports, Universes, Connections from BO XI R3.1 to BI

4.0

• Involved in migrating universes and reports from DEV to TEST to QA to Production environments using

Import Wizard and migrated the Crystal reports using Life Cycle Manager

(LCM), WebI reports to different environments.

• Updating universes for the users to do ad-hoc reporting on Business Objects XI 3.1 Universe Designer.

• Resolved universe problems such as loops, chasm and fan traps using aliases and contexts by testing the

overall integrity of the structure using check integrity.

• Used @aggregate aware, @select, @prompt, @where functions, Database Delegation in Universe to

improve performance

2

• Created Complex WebI Reports (Used multiple data providers, Union, Intersection, Minus, Master/Detail,

cross tab, Charts, and Input Controls)

• Developing Web Intelligence reports by linking multiple data providers in a single report and made all

possible incompatible objects as compatible by merging the common objects

(used Merge Dimensions) and also used Force synchronization

• Developed Web Intelligence reports using Business Objects major functionality like Breaks, sections,

Group values, Grouping, Average, Running Functions (Running Sum,

Running Average etc.), Graphs, Charts, Sorts, List of values (LOV), Pre-

defined conditions, Calculations and Ranking

• Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008/ 4.0

• Developed couple of Summarised Dashboards using Xcelsius 2008 to share with the Management.

• Created Free-hand SQL Desktop Intelligence reports using SQL, PL/SQL, and Stored Procedures as a

Oracle as data source.

• Transformed Legacy reports into WebI, DeskI, and Crystal Reports connecting to various universes.

• Efficiently wrote SQL queries, views, derived tables for various reporting requirements.

• Created various prompts at universe level to schedule the reports efficiently and effectively.

• Using Schedule methods to schedule the reports in Business Objects InfoView Portal and created recurring

instances of the report to run on Daily/Weekly/Monthly basis based on the User

requirements and exported reports into various formats like PDF, EXCEL and also

to various destinations like Email, File Sharing, and Inbox.

• Implemented the security and created multiple User Groups, Users and assigned rights accordingly.

• Efficiently and Effectively Performed the role of one point contact for all BO concerns, issues or solutions.

• Provided recommendations to Business in opting the right solution for the universe, reports and dashboards.

• Extensively provided support in UAT and Production.

• Effectively Trained developers and business users on various technicalities.

• Documented the requirements, development work, and Support tickets effectively for future reference.

Environment: Business Objects XI R3.1/ BI4.0 Enterprise suite, Tomcat, Crystal XI R2/ 2008, Xcelsius 2008,

Oracle 11g, SQL Server 2005, IBM DB2 8.0, Windows 2008, and Windows VM Ware

GETITT APPLICATION (PROGRESS ENERGY, RALEIGH, NC) Mar’ 2012 – Dec’2012

Business Objects Lead

Progress Energy is a Utilities and Energy Company which generates and supplies electricity and natural gas to

businesses and industries in North Carolina, South Carolina and Florida.

GetITT Application is the internal ticketing system with-in the Progress Energy with four different ticketing

systems Service Request, Problem, Incident and Change Request.

Responsibilities:

• Analysed and understood the GetITT application Architecture, databases and designed schemas.

• Interacted with multiple application Users from Carolinas, and Florida to gather and understand the

Business requirements and to collect the new report requirements and also

enhancements to the existing business requirements

• Converted the business requirements into TDR (Technical Design Review), BOR (Business Objects Report)

and Testing Documents

• Worked on BI 4.0 tools like Web Intelligence 4.0, Information Design Tool (IDT), and BI Launch Pad

• Involved in migration of BO Objects like webI Reports, Universes, Connections from BO XI R3.1 to BI

4.0

• Involved in migrating universes and reports from DEV to TEST to QA to Production environments using

Import Wizard and migrated the Crystal reports using LifeCycle Manager

(LCM), WebI reports to different environments.

• Created universes for the users to do ad-hoc reporting on Business Objects XI 3.1 Universe Designer.

3

• Resolved universe problems such as loops, chasm and fan traps using aliases and contexts by testing the

overall integrity of the structure using check integrity.

• Used @aggregate aware, @select, @prompt, @where functions, Database Delegation in Universe to

improve performance

• Created Complex WebI Reports (Used multiple data providers, Union, Intersection, Minus, Master/Detail,

cross tab, Charts, and Input Controls)

• Developed Web Intelligence reports by linking multiple data providers in a single report and made all

possible incompatible objects as compatible by merging the common objects

(used Merge Dimensions) and also used Force synchronization

• Worked extensively with the major functionality of Business Objects Web Intelligence like Breaks, sections,

Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

• Developed web Intelligence reports using different kinds of Graphs, Charts, Display of Total, Average at

Break and Section levels at Body, Block, Report, and Current Page etc.

• Developed Cross Tab Reports, Sub Reports by using Crystal Reports 2008/ 4.0

• Created Free-hand SQL Desktop Intelligence reports using SQL, PL/SQL, and Stored Procedures as a

Oracle as data source.

• Transformed Legacy reports into WebI, DeskI, and Crystal Reports connecting to various universes.

• Efficiently wrote SQL queries, views, derived tables for various reporting requirements.

• Created various prompts at universe level to schedule the reports efficiently and effectively.

• Using Schedule methods to schedule the reports in Business Objects InfoView Portal and created recurring

instances of the report to run on Daily/Weekly/Monthly basis based on the User

requirements and exported reports into various formats like PDF, EXCEL and also

to various destinations like Email, File Sharing, and Inbox.

• Implemented the security and created multiple User Groups, Users and assigned rights accordingly.

• Integration of Infoview/ webI in the GetITT application using BO SDK in JAVA environment

• Extensively provided support in UAT and Production.

• Effectively Trained developers and business users on various technicalities.

• Documented the requirements, development work for future reference.

Environment: Business Objects XI R3.1/ BI4.0 Enterprise suite, Tomcat, Crystal XI R2/ 2008, Xcelsius 2008,

Oracle 10g, SQL Server 2005, IBM DB2 8.0, Windows 2008, and Windows VM Ware

BO UPGRADE (PROGRESS ENERGY, RALEIGH, NC) Jul’ 2011 – Feb’ 2012

Business Objects Lead

The main aim of this project is to upgrade BO environment from BOXI R2 to BOXI R3.1 to sync with SAP BO life

cycle updates. As part of this project, we have upgraded the environment and also migrated BO Objects like

Universes, Connections, Reports and QaaWS Connections, Schedules history, User’s Favorites and Inbox items

using Import Wizard and did some cleaning activity like removing the un-necessary reports.

Responsibilities:

• Interacted with multiple application Users to identify the reports that are needed to migrate from BOXI R2

-> BOXI R3.1

• Prepared Test documents as part of SIT, and UAT

• Implemented the project in 4 phases by dividing the project applications in Tiers

• Migrated the Projects from BOXI R2 Prod to BOXI R3.1 Dev environment using Import Wizard

• Modified the Opendocument syntax as per BOXI R3.1 standards

• Refreshed/ Scheduled the reports in BOXI R3.1 Dev to make sure the reports are running as expected

• Migrated the reports from BOXI R3.1 Dev to BOXI R3.1 Test environment using Import Wizard

• Provided support to Business Users in UAT to test the reports in BOXI R3.1 Test

• Migrated the approved reports from BOXI R3.1 Test to BOXI R3.1 Prod environment using LCM

4

• Tested all the BO Applications like Designer, Desktop Intelligence, Crystal Reports, Infoview, Import

Wizard in the BOXI R3.1 environment to make sure they work as expected

• Migrated Schedule history, Users Favorite and Inbox documents

• Prepared and reviewed the documentation.

• Providing End User training for basic and advanced reporting skills.

Environment: BO XI R2 Enterprise suite, BOXI R3.1 Enterprise suite, Tomcat, Crystal XI R2/ 2008, Oracle 10g,

SQL Server 2005, IBM DB2 8.0, Windows 2003, Windows 2008, and Windows VM Ware

ISR-INTEGRATED SALES REPORITNG (KRAFT FOODS, USA) Aug’ 2010 – Jun’ 2011

BO/ Xcelsius Developer

Kraft Foods is largest food and beverage Production Company with interests in the manufacturing, marketing and

distribution of grain-based snack foods and beverages. The company's core businesses are in beverage, cheese, dairy

foods, snack foods, confectionery, and convenience foods.

Integrated Sales Reporting (ISR) is basically Sales Reporting for entire Kraft. This application provides all

kinds of Sales information about each product. It also details Sales performance of each Sales Center, each Sales

person by region wise.

Responsibilities:

• Interacted with the Business Users to analyze the business process and gathered the requirements made

necessary changes to schema objects to fulfill their reporting and business needs

• Involved in the Design and implementation of Universes for Data Mart

• Used Linked Universes concept to establish relationships between universes.

• Responsible for the design and creation of Business analysis reports which extensively used Calculations,

Variables, Breaks, Sorting, Drill Down, Slice and Dice, Alerts, Ranking, Prompts, Master/Detail, Cross Tab

and Charts

• Responsible for the design and creation of the summary tables for faster retrieval of data

• Involved in the creation of stored procedures for performance tuning

• Responsible for publishing the pre-defined reports to the repository and assigning the various users and User

Groups the corresponding permissions on the accessibility of those reports

• Importing and Exporting of Universes into repository

• Created links in BO reports to link summary and detail reports using Open document syntax.

• Conducted periodic user training for business users on slicing and dicing of power cubes, drill down

techniques for extensive usage of the reports.

• Worked extensively with the major functionality of Business Objects Web Intelligence like Breaks, sections,

Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

• Developed web Intelligence reports using different kinds of Graphs, Charts, Display of Total, Average at

Break and Section levels at Body, Block, Report, and Current Page etc.

• Used functionalities such as sub-reports, cross-tab reports with Drill down feature of Crystal reports to

generate inventory, account receivables and payables, cycle and monthly reconciliation reports for billing

purposes.

• Worked extensively with functions of Crystal reports like Running totals, Highlight Expert.

• Created critical visualization using Business Objects Xcelsius 2008 for the Business Dashboard.

• Used Xcelsius 2008 as a Data Visualization Tool to transform some Microsoft Excel spreadsheet data into

visual analytics, Dynamic charts such as Pie-Charts, Bar Graphs, Scorecards that can be shared via

PowerPoint and PDF files.

• Integration of Infoview/ webI in the ISR application using BO SDK in JAVA environment

• Created Free-hand SQL Desktop Intelligence reports using T-SQL, and Stored Procedures as a SQL Server

data source.

• Involved in migrating universes and reports from DEV to TEST to QA to Production environments using

Import Wizard.

5

Environment: Business Objects XI R3.1 Enterprise suite, Tomcat, Xcelsius 2008, SQL Server 2005, Windows 2008,

and Windows VM Ware

VOICE (KRAFT FOODS, USA) NOV’ 2009 – JUL’ 2010

BO/ Crystal Reports Developer/ Xcelsius Developer

Voice is one of the critical applications in Kraft Foods. The aim of this project is to report the Customer feedback/

complaints about a Product by Sales Center and by Region.

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data

specifications about the system for Business Objects Universes and Reports.

• Build the new universes as per the user requirements by identifying the required tables from Data mart and by

defining the universe connections.

• Created new Universes on Business Objects XI 3.1.

• Created Derived Tables in the universes. Resolved Chasm traps, Fan Traps & Loop problems to reduce the

complexity of the universes.

• Applied User and Group Restrictions in selected objects in universe level.

• Extensively used Calculations, Variables, Break Points, Drill and complex queries for creating reports.

• Built reports using multiple data providers, external data providers and used merge dimension functionality.

Synchronized queries from multiple data providers by linking the common dimensions using merge

dimensions option in WebI.

• Some of the reports are created using free hand SQL and universe objects.

• Worked on cross-tab and master detail reports and represented the same using charts/ bar charts/ pie charts.

• Created complex reports using cascading and user objects like measure objects by using @aggregate aware

function to create the summarized reports.

• Used WebI Chart for diagrammatical representation of data such as Confidential interval chart, Box Plot chart,

Water fall chart.

• Created both full client and WebI Reports in XI 3.1 based on the business requirements and Modified required

Reports by adding new columns based on the result set.

• Created numerous reports in Business Objects, Created some reports by hard coding the query (SQL) in the

tool, Enhanced the existing reports, Designed and developed Web Intelligence reports.

• Created Executive Summary Dashboards using Xcelsius 2008 which contains Complaints and Product

information (CEO Briefing book).

• Created critical visualization using Business Objects Xcelsius 2008 for the Business Dashboard.

• Created hyperlinks on the dashboard as well on the standard templates reports and linked them to different

secondary reports.

• Used functionalities such as sub-reports, cross-tab reports with Drill down feature of Crystal reports to

generate inventory, account receivables and payables, cycle and monthly reconciliation reports for billing

purposes.

• Worked extensively with functions of Crystal reports like Running totals, Highlight Expert.

• Interacted with customer support regularly in order to generate the reports required and to resolve the existing

issues.

• Involved in migrating universes and reports from DEV to TEST to QA to Production environments using

Import Wizard.

Environment: Business Objects XI R3.1 Enterprise suite, Tomcat, Xcelsius 2008, SQL Server 2005, Windows 2008,

and Windows VM Ware

EMC2 (EMC2, HOPKINTON, MA) Dec’ 2008 – Oct’ 2009

Crystal report writer/ Business Objects Developer

6

EMC is a leading provider of IT storage hardware solutions to promote data backup and recovery and accelerate the

journey to cloud computing. My role involved working in Financial Business Analysis for providing a better solution

in terms of their business forecast for the current and upcoming projects. The role involved working in all modules of

BO for price comparison among different items produced by EMC2.

Responsibilities:

• Designed and developed Crystal Reports, which included standard reports, cross-tab, and summary reports

using Crystal Reports XI R2, WebI, and Desktop Intelligence.

• Created Crystal reports using Universe, SQL Server as Data source.

• Created workarounds in Crystal Reports for issues such as, subreport within a subreport, passing parameters

from main report to subreport, not allowing the use of multi-value or date range parameters.

• Developed Crystal reports for standard reporting purposes using COMMAND object, Sub reports, dynamic

prompts with LOV’s built of Business View Manager.

• Worked extensively with the major functionality of Business Objects Web Intelligence like Breaks, sections,

Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

• Developed web Intelligence reports using different kinds of Graphs, Charts, Display of Total, Average at

Break and Section levels at Body, Block, Report, and Current Page etc.

• Worked extensively with functions of Crystal reports like Running totals, Highlight Expert.

• Modify the existing reports by adding new logic and deleting existing logics the line of user requirement.

• Developed various charts and graphs like Bar chart (side by side, stacked), Line graphs, Pie charts etc by

using chart expert utility of Crystal reports.

• Improved the performance of universe with the use of @functions (@aggregate aware, @select, @prompt,

@where)

• Responsible for creating the complex Crystal reports (On demand, AdHoc Reports, Frequency reports,

Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging report etc.)

• Worked extensively with the major functionality of Business Objects like Breaks, sections, Group values,

sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.

• Scheduling reports on weekly and monthly bases.

• Generated Reports based on time like Year, Quarter, Month, Week based on Geographic and comparative

reports, label reports, letter reports.

• Involved in Migration from BO 6.5 to BO XIR2.

Environment: Business Objects XI R2 Enterprise suite, Tomcat, Crystal XI R2, SQL Server 2005, and Windows 2003

Server

AAPD-RESERVATION (3M, USA) Feb’ 2008 – Dec’ 2008

Crystal report writer/ Business Objects Developer

The 3M Company formerly known as the Minnesota Mining and Manufacturing Company and they produce more

than 55,000 products, including: adhesives, laminates, dental products, electronic materials, medical products, car care

products.The Company maintains a market leading position by working closely with its customers – industry-leading

manufacturers and distributors and offers these customers the best product performance and reliability and the very

latest in technology.

Responsibilities:

• Identified the reporting requirements and prepare the requirements specifications document. This involved

interviewing the business users and understanding the current reporting system.

• Good experience in designing Universes, incorporating all the business requirements.

• Created hierarchies in Universe design to support drill down functionality in reports.

• Implement Data Level Security, based on the Divisions and Markets.

• Created Classes, Subclasses, Objects and conditional Objects.

7

• Maintaining Universes and Object Oriented Universe Design Techniques, working knowledge of Linked

Universes.

• Experienced in creating the Aggregate tables and Aggregate awareness implementation & Aggregate

Objects Creation and using in the reporting.

• Created variables, @prompt (Interactive objects), formulas etc..

• Published and scheduled Business Objects reports to users using scheduler.

• Used functionalities such as sub-reports, cross-tab reports with Drill down feature of Crystal reports to

generate inventory, account receivables and payables, cycle and monthly reconciliation reports for billing

purposes.

• Worked extensively with functions of Crystal reports like Running totals, Highlight Expert.

• Modify the existing reports by adding new logic and deleting existing logics the line of user requirement.

• Extensively used Calculations, Sorting, Rank, and Drill down, Drill thru, Slice and Dice, Formatting,

Breaks, Filters, Changing Displays and Prompts for creating Business Objects Reports.

• Created Cross-tab reports for multidimensional analysis, and drill-down reports for detailed analysis, also

created reports with Charts using Business Objects desktop intelligence and Web Intelligence .

• Created dashboards using Performance Management.

• Publish, distribute and schedule Web Intelligence reports using Info view.

• Used Import Wizard for the Migration process. Migrated users, universes, reports and Converting Deski

Reports to WEBI using Report Conversion Tool.

Environment: Business Objects XI R2 Enterprise suite, Tomcat, Crystal XI R2, Oracle 8i and Windows 2003 Server

FEDEX FIM – SALSA PROJECT (FEDEX FREIGHT, MEMPHIS, TN, USA) Mar’ 2007 – Jan’ 2008

Business Objects Developer

Responsibilities:

• Created and setup BO's Universes for each reporting group and established a BO environment.

• Created several Classes, Objects, Conditions, and Measure objects

• Involved in making the user resources more flexible as per the business requirement by exporting Universes

and BO reports.

• Installed and set the Central Management Server, Processing Servers & Report Application Server .

• Communicated effectively for requirements and reports testing with the end users.

• Used Business Objects functionalities such as applying breaks on reports, Slice and Dice to create the cross-

tab and Master Detail reports.

• Created complex reports using multiple queries and involved in tuning the reports in order to increase the

accessing speed.

• Set up of Users, Groups, User Ids, Single sign-on, Report viewing privileges for Users are done in Crystal

Enterprise

• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt

and Drill filters.

• Generated BO Reports using the universes as the main Data providers and writing complex queries

including Sub queries, Union and Intersect.

• Developed various Reports Using Universes, Free hand SQL's as per user requirement.

• Created Master Detail and Cross Tab reports to analyze data effectively .

• Involved in creating reports on the using Web Intelligence.

• Scheduled and monitor Reports as per the terms and conditions

Environment: Business Objects XI R2 Enterprise suite, Tomcat, SQL Server 2005, and Windows 2003 Server

FINANCIAL DATA MART (GEFS, USA) Jan’ 2006 – Feb’ 2007

Business Objects Developer

Responsibilities:

8

Analyzed the existing database and designed the Universes using Business Objects Designer Module.

Involved in creating Users, User Groups and assigned privileges to the users using CMC.

Created Classes and Objects taking the information from the database. Also created measured objects.

Linked Universes to share the Universes which had common dimension tables, classes and objects.

Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps

in the Universe.

Responsible for creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views

to increase the performance of the universe.

Created Complex reports using User defined functions like @prompt, variable

Contact this candidate