Sql Server Manager

S UMA

P ROFESSIONAL SUMMARY

• Over *+ y ears of total experience in Information Technology Industry predominantly

o n B usiness Intelligence Reporting and Data warehousing - working with

B usiness Objects 4 .0/XI 3.1/3.0/XIR2/R1/6.x ( CMC, CMS, CCM, Info View,

L aunch Pad 4.0, Designer, IDT 4.0, Desktop Intelligence, Web Intelligence,

I mport Wizard, Xcelsius, Dashboard Design 4.0, QAaWS, Live Office and

C rystal Reports, E xplorer ) .

• Working experience in SAP BI 4.0(SAP BI Launch Pad, SAP Web Intelligence, SAP IDT,

S AP Dashboard Design).

• Worked on different phases and aspects like P lanning, D esigning, D eveloping,

D istributing a nd maintaining Universes with S AP BI/BW a s a d ata source .

• Hands on experiences with BW/BOBJ Integration .

• Technical proficiency in creating interactive d ashboards a nd s corecards u sing

X celsius 4.5/2008.

• Used L ive Office a nd Q aaWS ( Query as a Web Service) to feed live data i nto

X celsius.

• Created complex X celsius d ashboards b y using different data sources like Crystal

R eports a nd X ML f iles.

• Proficient in f ull-client ( DESK I ) a nd w eb-based ( WEBI ) reports d evelopment a nd

u niverse design, i nstallation a nd s erver administration, t roubleshooting,

s cheduling, p ublishing a nd s ecurity

• Experience in deployment o f reports using v arious data sources like O racle, M S

S QL S erver 2005 /2008 a nd M S-Access, DB2 .

• Efficient in optimizing and writing S QL queries.

• Excellent track record of proactive communication and collaboration with external and

i nternal customers t o analyze B I n eeds a nd f unctional requirements a nd deliver

t he following artifacts as needed : s ub-reports, parameter based reports,

g raphical reports, formula based, well-formatted reports, drilling reports,

a nalysis reports, data reports .

• E xpertise in functionalities like Queries, Slice and Dice, Drill down, @Functions,

C ustom sorts, Cross Tab, Master Detail, Formulas, Drilling methodology, Filters,

Ranking, Sections, Graphs and Breaks.

• Expertise in b ackup a nd recovery of business object environment using BIAR file .

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

s killed in creating A dhoc/Canned R eports, Complex Reports u sing predefined

c onditions.

• Very good experience in data cleansing using E TL Tools and data loading from flat files

• Excellent knowledge on data warehousing concepts – Star schema, Snow-flake

S chema and worked on both OLAP and OLTP databases

• Experience in creating R epositories, Folders, G roups, U sers, assigning p rivileges

t o u sers a nd maintaining the repository

• Extensively Used C MC ( Central Management Console) for user management, content

m anagement, and server management tasks and C CM ( Central Configuration

1 P a g e

M anager) to manage local and remote servers Analysis to design the Universes and

B usiness Objects Reports to support the user requirements.

• Hands on experience in writing, testing and implementation of t he PL/SQL triggers,

s tored procedures, functions, packages.

• Strong Integration skills between External Portals with S DK a nd X celsius

D ashboards .

• Excellent communication and interpersonal skills. Ability to work effectively in a team

a s well as individually.

• TECHNICAL SKILLS

• Reporting Tools : B usiness Objects 4.0/3.1/XIR2/6.5/5.1(Reporter, Designer, Supervisor,

Web Intelligence, Desktop

I ntelligence, Broadcast Agent Server, Central Management Console, BO SDK, Bex Query

Designer, Bex Analyzer, Query As A Web Service (QaaWS),Crystal Reports, Xcelsius)

• Dashboard & Performance Tools : B usiness Objects Dashboards and Performance

Manager,

Crystal Xcelsius 2008/4.5.

• Databases: O racle 10g/9i/8i/8.0/7.x, Microsoft SQL Server 2008/2005/2000, DB2,

Teradata and MS Access.

Languages: P L SQ L/ MS SQL, C#, Asp. Net, JavaScript, Shell Scripting.

•

• Operating Systems: Windows Servers 2003/2008, Vista, XP, UNIX.

EDUCATION

• Master of Computer Applications (MCA)

P ROFESSIONAL EXPERIENCE

Royal Bank of Scotland ( RBS ) - N ew York J une

2 012 – T ill Date

SAP Business Objects Consultant.

The RBS g roup is a large international banking and financial services company. The Group ( Royal Bank of

S cotland and NatWest ) p rovides a wide range of products and services to personal, commercial, and large

c orporate and institutional customers.

R esponsibilities

• Interacted with business users, business owners to know their business views in developing and modifying

universes and reports accordingly.

• Created Web Intelligence Ad-hoc and canned reports.

• Created two complex dashboards which uses live office to feed the data into xcelsius from the source webi reports

2 P a g e

• Created Web Intelligence reports using Multiple Data Providers, Prompts, break, filter, rank, alerters, Slice& Dice and

Drill up/down, Cross Tab, Master Detail and Formulae's etc

• Formatted webi reports and scheduled them to be bursted as pdf to the report to web server.

• Modified existing universes and implemented new universes according the reporting needs by

detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived

tables.

• Resolved Chasm, Fan traps and Loop problems using aliases and contexts in the universe and exported to repository.

• Created complex reports using cascading prompts.

• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.

• Improved the performance and reduced the coding with the use of @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.

• Created custom List of Values (LOVs) for better understanding of prompts by the end users.

• Created users in Central Management Console (CMC) and allocating rights to them.

• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console.

• Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console

(CMC)

• Deployed Business Objects Reports in a Secure Environment from One Server to Other Servers using Import Wizard.

• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using

Chart expert of Crystal Reports 2008.

• Modified existing crystal reports and created new reports with cross tabs and sub reports based on the client

requirements using Crystal Reports 2008.

• Tested reports before posting them to the repository (query optimization & performance).

• Involved in writing Stored Procedures and functions in Oracle PLSQL.

• Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related

problems.

Environment: B usiness Objects XI 3.1, Web Intelligence, D ESKI, BO Designer, C MC, Publishing Wizard,

I mport Wizard, Crystal Reports 2008, X celsius 2008, I nfo view, Windows, Toad, Oracle 10g, SQL Server 2008.

New York State Office of Information Technology Services ( NY ITS ) - N ew York

M ay 2011 – J une 2012

SAP Business Objects Consultant.

NY-ITS - Offi ce for the Telecom i s support services o f all the Government bodies in New York like 911,

3 11, Police Dept. Health Dept.

Responsibilities

• Worked with Business Managers, Architects and End users in documenting requirements,

p roviding estimates, creating High Level Design and Detail design specifications.

• Worked with the PM group to identify the priorities, to know the Business Critical and

complex universes and reports

• Installed and Configured Business Objects products on the Windows environment.

• Responsible for the Designing the universes by creating the joins, setting up the

cardinalities.

• Resolved complex looping issues by creating multiple contexts and aliases to remove

cyclic dependencies for the universes which were built from the underlying Databases.

3 P a g e

• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better

performance.

• Created objects like Dimensions, Details and Measures, which are logically grouped into

Classes as per business requirements.

• Created pre defined filters and cascading prompts in Universe level.

• Implemented ROW Level security and Object Level Security in the Universe to protect

client information from other client Agents.

• Developed .unx file using 3 layer architecture (.cns, .dfx, .blx) stored in Project with SAP

I DT 4.0 tool.

• Created Secured (.cnx) connection in SAP IDT(Information Design Tool)

• Designed Data Foundation (.dfx) using multiple data sources using IDT.

• Worked extensively with @Functions (@Select, @prompt, @Where) to filter the data.

• Developed Web Intelligence reports using multiple data providers, which were coming

f rom different databases. Created various kinds of graphs, Charts, Scatter plot. Analyzed

the data in charts using slice/dice, drill up/drill down.

• Wide usage of Drill mode and Slice and Dice techniques to modify the reports in

a ccordance with the user's analysis needs.

• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs,

Pie Charts etc by using Chart expert of Crystal Reports 2008

• Developed Xcelsius 2008 Dashboards on top of QaaWS and Live Office connections.

• Created Dashboards specifically for using different analytics like Speedometer,

I nteractive Charts with alerts and goals.

• Used dynamic visibility and Excel functions to control and manipulate the data.

• Involved in Debugging and testing SQL queries in Oracle and SQL Server.

• Provided training to end users to use various functionalities of Business Objects.

• Provided technical assistance/support to analysts, business community and responded to

i nquiries regarding errors, problems, or questions with programs/interfaces.

Environment: B usiness Objects XI 3.1/4.0, Crystal Reports 2008, Xcelsius 2008, Windows 2k3/2k, BO

D esigner, Web Intelligence, Publishing Wizard, Import Wizard, Launch Pad 4.0, IDT 4.0, Dashboard Design 4.0,

O racle 10g, SQL Server 2008 and Teradata.

Bank of New York Mellon - New York

M ay 2010 – Apr 2011

Business Objects Developer

Bank of New York Mellon i s one of the leading financial Organizations in the United States. P raeeo i s an

a pplication that is used by BNY / AIS to provide administrative services to the hedge fund industry.

Responsibilities

• Created prototypes of the reports for user presentation in the process of requirements

gathering.

• Installing, upgrading and troubleshooting the Business Objects Enterprise.

• Created new users in XI 3.0 using Central Management Console and set restrictions,

a ssign privileges based on their profiles.

• Interacted with Business community to gather and analyze the Business Requirements in

developing and modifying Universes and building the reports.

4 P a g e

• Resolved Chasm traps, Fan Traps & Loop problems by using contexts and aliases to

reduce the complexity of the universes.

• Extensively used the @functions, worked on back end functions, procedures, tables,

v iews required by the business objects universes

• Created Dynamic Filters and Dynamic Conditions in universe level as per Business rules.

• Improved the performance and reduced the coding with the use of @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.

• Created custom List of Values (LOVs) for better understanding of prompts by the end

users.

• Defined Customized Hierarchies in Universe level.

• Applied User and Group Restrictions in selected objects in universe level based on User

a nd Group.

• Designed and Developed WEBI reports, created charts and graphs for quick analysis.

• Created Report Level Variables, Objects and Formula to create new columns based on the

result set.

• Preparation of Critical, Master Detail, Sub Reports, Cross Tab and Summary reports using

Crystal Reports, features includes functions, running totals, parameters and conditional

f ormats.

• Created Dashboards using Crystal Xcelsius for senior management for business decision

making.

• Developed Dashboards and Scoreboards for detailed analysis using Xcelsius.

• Provided user support and training in using Report Designer for creating Adhoc reports.

• Involved in writing Stored Procedures and functions in Oracle PLSQL.

E nvironment: B usiness Objects XI R3.1, CMC, Designer, Info view, Crystal Reports, Xcelsius, Toad, SQL,

P L/SQL, Oracle 10g,WebLogic 10.3g, SQL Server, Windows NT .

Thomson Financial, Rockville- MD S ep

2 009 – M ay 2010

SAP Business Objects Developer.

T homson Financial Research (TFR) a cquires produces and develops electronic information for several

f lagship data collections sold by Thomson Financial businesses and third-party distributors.

R esponsibilities

• 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

B usiness 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

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

5 P a g e

• 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,

D rill 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

c reating conditional filters), and @Select.

• Generated and published web reports in Info View using Web Intelligence and scheduled

B usiness Objects Reports through Broad Cast Agent.

• Worked along with the testing team to derive test cases for efficient Data reporting.

Environment: B usiness Objects XI 3.1/R2, WEBI, DESKI, Designer, Info view, Xcelsius,

crystal reports, SQL, Oracle10,Tera data and Windows 2003.

ADT Security Systems, IL J an 2008 –

A ug 2009

SAP Business Objects Developer.

ADT is by far the largest home security alarm service in the U.S. and also does a big

business in providing service to business and government.

R esponsibilities

• 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,

a nalytical and ad-hoc reporting requirements of the Business Objects users

• Upgraded Business Objects universes and reports from version 6.5.1 to version XI R2.

• Involved in the designing and Building of Universes, Classes, Objects and Condition

Objects from the analysis database.

• Created cascading prompts and also customized the prompts by adding ‘ALL’ to the

p rompts which would be easier for the end user in the process of selection criteria.

• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and

cardinality problems.

• Worked on the Master, Kernel and Component approach during the linking of universes.

• Created and tested classes and objects to organize the universe.

• Created prototypes of the canned reports for end user presentation and acceptance.

• Updated the Universe as per the changes of the Database table structure and notified the

users about changes made to the Universe.

• Exported the universes to the Repository to make resources available to the users

• Created the reports using Business Objects functionalities like Queries, Slice and Dice,

D rill Down, @Functions, Cross tab, Master-Detail and Formulas etc.

• Created reports for various Portfolios using the various data Providers like Free Hand SQL,

Stored Procedures, and VB procedures.

6 P a g e

• Created the reports using Business Objects functionality's like Queries, Slice and Dice,

D rill Down, Cross Tab, Master Detail and Formulae's etc

• Created Schedulers to monitor Broadcast Agent

• Built full client and WEBI reports.

• Set up groups and users for Business Objects deployment in CMC. Managed user profiles

using Supervisor

• Designed, developed and tested the reports based upon data generated by enterprise

t ransaction, financial, and customer information systems using Business Objects XI

connected to Oracle data source

• Developed dashboards using Xcelsius.

• When the source tables are very huge, developed PL/SQL procedures using Oracle to load

the data into fact tables and used them in the universe.

• Published and scheduled Business Objects Reports to users using Scheduling method

w hen working in 6.5.

Environment : Business Objects XI R2/ 6.5.1 (Supervisor, Designer, and Reporter) Web I,

BCA, Xcelsius, crystal reports, Oracle 9i, MS SQL Server 2000, Toad 7.4, PL/SQL and Excel,

Windows 2012 Server.

WIPRO TECHNOLOGIES, Bangalore –INDIA J ul 2005

– O ct 2007

SQL Developer / Report Designer

The system has been made for the Hewlett-Packard, to automate their Sales Monitoring

System. It helps the manager to do Sales analysis, Commodity analysis and Salesmen

Performance analysis.

Responsibilities

• Requirement study, review of specifications.

• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for

t rend analysis).

• Using - filters, conditions, calculations, etc.

• Creation of schema object like triggers, views and synonyms.

• Extensive coding using PL/SQL.

• Analysis of input/output flow.

• Report Generation using Reports2.5.

• System Documentation.

E nvironment : M icrosoft SQL SERVER 2000, Business Objects 6.5.1 (Designer, Reports, Supervisor), Web

I ntelligence, PL/SQL, MS Access 2000, Windows 2000 Server .

7 P a g e

Contact this candidate