Sql Server Manager

Krishna Prasad

CERTIFICATIONS ACHIEVED:

Mobile: 630-***-****

Email: *******.****@*****.***

PROFESSIONAL SUMMARY:

* ***** ** ********** ** various Information Technology are as

involving Business Objects XIR3.0/R2/6.x Designer, Data Warehousing,

Desktop Intelligence, Web Intelligence, Central Management Console

(CMC), Infoview, Performance Management, Crystal reports, Xcelsius,

SAP Integration and SAP BW3.5

Experience in Installation, Implementation, Configuration,

Administration, Trouble shooting, Migrations, Testing, Supporting of

Business Objects Enterprise XIR3.0/R2/6.x and Crystal Enterprise.

AREAS OF EXPERTISE:

. Experience in Identification of Business and Data requirements and

converting them into conceptual and data models.

. Experience in Dimensional Data Modeling (Star and Snow Flake Schemas).

. Involved in the Administration to create users, permissions, managing

the folders using Central Management Console (CMC).

. Experience in Developing and implementing Live office connectivity to

BO Enterprise, Building Dashboards in Xcelsius 2008, Crystal Xcelisus

4.5, Reports (Query as Web Service), Performance Dashboards, Score

cards, Metrics.

. Experience in designing and developing the Universe (business view of

the database), and updating the existing Universes, developing

canned/ad-hoc reports, scheduling the processes and administering the

BO activities using Business Objects XI R2/R1/6.5 (Broadcast Agent,

Supervisor, Designer, Infoview, Reporter), Web Intelligence (Web I).

. Well qualified in creating Multifaceted Canned/Ad-Hoc reports using

Business Objects, Web Intelligence.

. Scheduled reports to run and refresh daily using Broadcast Agent.

. Involved in Up gradation to XI 3.0 from XIR1

. Involved in Migration from BO 6.5 to BO XIR2 using import wizard

Strong experience with reporting and financial analytics in a Data

Mart and Data Warehouse environment.

. Thorough and complete understanding of installing and configuring SAP

Integration Kit and also on SAP BW Queries (BEX Queries) using BOBJ XI

3.0, 3.1 Widgets.

. Worked on BO Designer Functionalities like Derived Tables, Linked

Universes, Aggregate Aware, Index aware, Contexts, Aliases, complex

joins, Customized LOV's and Cascading Prompts

. Extensive experience in Business Objects Full Client, Supervisor,

Designer, Broadcast Agent Publisher, Info View, Web Intelligence

Explorer, Web Intelligence Reporter, Business Query for Excel,

Application Foundation, ZABO, WebI, SDK.

. Expertise in retrieving data using Business Objects Universes,

personal data files, free hand SQL, Business Views etc.

. Expertise in creation of Web Intelligence Documents to create

Master/Detail, Breaks, Filters, Drill, Calculations based on Contexts,

2D and 3D Pie Charts, Bar Charts and Line Charts reports

. Used Numeric, Character, Logical and Aggregate Formulas to create

variables used in Designer and Report documents.

. Excellent skills in Performance Tuning SQL & PL/SQL

. Experience in ORACLE based client server application, also posses

experience in developing PL/SQL procedures, database triggers and

other components of database applications.

. Experience in working on various RDBMS Oracle, SQL Server

2008/2005/2000 and MS Access.

. Built Reporting application on Data Sources such as SQL Server and

Oracle Application.

. Good exposure in architecture design of Extract, Transform, Load

environment using Informatica Power Mart, Power Center 8.6/8.1

. Excellent team player, interfacing across business and technical

groups and ability to work independently and highly motivated.

Exceptional ability to quickly master new concepts and applications.

. Very much interested in taking challenging roles.

CERTIFICATION:

Implementing and Maintenance with Microsoft SQL Server 2005

Developing and Implementing Web Applications with Microsoft Visual

Basic. NET

EDUCATION:

Bachelor in Electronics and Communications Engineering - Anna

University

TECHNICAL SKILLS:

Operating System Windows 98/2000/2003/XP/Vista

Databases Oracle 8i/9i/10g, SQL Server

2000/2005/2008, DB2.

BI Tools Business Objects 5.1/6.5/XIR2,XI R3

WebIntelligenceXIR2,InfoView,CrystalRepo

rtsXI,

Xcelcius, Live Office, Broadcast Agent

Publisher, CMC, Supervisor, Designer,

Broadcast Agent Publisher, Business

Query, Import Wizard

ETL Tools Informatica Power Center 8x, SSIS

Languages SQL, VB, PL/SQL, T-SQL, XML, HTML, ASP,

ASP.NET

Web/App Servers IIS 5/6.0, Tomcat, Apache Server

Version Control Visual Source Safe

EXPERIENCE SUMMARY:

Sr. Business Objects Designer / Developer

Oct 2008 - Till Date

Next Era Energy - Cedar Rapids, IA

Next Era Energy is part of FPL Group which is a leading company in

Energy/Utility Sector.

Nuclear Asset Management Suite (NAMS) Fleet Application, NAMS will deal

with Material Management, Work Management, Action Tracking, Procurement and

interfaces with Financials and HR system.

WPI Work Management System developed in 3- tier architecture. It interfaces

with 7 different systems which also includes SAP. It deals with various

background jobs and user friendly reporting.

Nuclear Budgeting Application (NBA) Developed to allow the FPL to gather

and prioritize yearly budgets at DAEC Plant. Administrative screens and

Reports.

Team Track Action tracking system which will create corrective action

process, OTH, Training Requests, PCR and many Ad hoc Reports.

This is a Data warehouse project with SQL Server and Business Objects XIR3

as BI tools. The project about maintaining existing Universes, Reports, BO

Servers, Security and generating new BO Reports for all its new and

existing customers.

Responsibilities:

. Maintaining, 1800+ reports and 50+ Universes on BOXIR3.

. Gathering Business requirements from the users and convert it into

technical reporting specifications.

. Creating new Webi Reports and modifying existing Web Intelligence (Webi)

reports as per the end user requirements.

. Designed Universes by defining joins, cardinality between tables, linked

the existing Universes in Business Objects XI R3.

. Created Cardinalities, Contexts, Joins and Aliases for resolving Loops

and checked the integrity.

. Created Crystal Reports using command prompt and written the complex

queries including Sub Queries.

. Created sub reports and Cross tab reports in Crystal XI for daily

operational reports.

. Developed highly secured crystal report for compensation data using

business view manager.

. Designed and developed Crystal Reports, the Cross Tab Reports, Top N

Reports for highlighting significant data, summary reports with drill-

down capabilities.

. Creating custom SQL queries in the form of derived table in the universe

to meet the ad-hoc requirements.

. Creating, refreshing & scheduling Metrics, creating interactive

analytics, creating personal dashboards and adding compound analytics

through Dashboard Manager.

. Measuring and tracking Key Performance Indicators (KPIs) and representing

them in graphical Dashboards.

. Built interactive and advance visual dashboards to analyze from summary

level to detailed report.

. Using charts, alerters, selectors, applying formatting and adding

graphics & animations in Xcelsius for end user analysis.

. Designing new universes for new projects and modifying existing ones as

per the ad-hoc requirements.

. Have created Crystal Reports for ad-hoc requests on Mortgage Dept.

. Have used various reporting techniques like slice and dice, drill up,

drill down, drill through, setting alerter, setting hierarchies, sorting,

cascading prompts, and creating master-detail report.

. Managing Users, User Profiles, Folders, Categories, Security, User

rights, Group Level and Folder Level rights, Row Level, Object Level

security in CMC & Universe.

. Created Reports using grouping, sorting, Running totals, charts etc., and

exported reports into Excel, pdf, csv etc

. Have performed LDAP authentication for the end users.

. Configuring and tuning all the BO Servers (e.g. Input/Output FRS, CMS,

Webi/Deski Job Servers, Report Server, Cache Server etc.).

. Involved in the maintenance of Users, User Profiles, and Security in

CMC.

. Involved in designing the report specifications and layout

. Using custom Oracle SQL, Oracle PL/SQL as a data provider in BO

reporting.

. Improving the performance of reports by tuning SQL Queries, Universes by

using Aggregate Awareness, Short Cut Joins, tuning at Database level by

creating Indexes, Materliazed Views.

. Have designed Data Mart based on Star Schema for reporting purpose.

. Thorough understanding of Data Warehousing / Multi Dimensional Analysis

concepts like Star Schema, Snow Flake Schema, OLAP.

. Used FlashCopy 1 to copy entire volume of data set from Dev to Test as a

Back up.

. Working on Extract, Transform & Load Process like creating DTS packages,

Writing MS SQL, Procedures, Scheduling Jobs, using various

Transformations using SQL Server Integration Service.

. Have implemented Full SDLC, documentation & standards.

. Have written VB Macros (BO SDK) for documentation and ad-hoc

requirements.

. Trained end users in creating Webi reports and designing Universe.

Environment: BOXIR3, SQL Server 2008, Crystal Reports, Oracle 10g, SSIS,

Desktop Intelligence, Web Intelligence, Designer, InfoView, Xcelsius,

Dashboard Builder.

Business Objects XI R2 Developer

May 2007 - Sep 2008

Verizon Business - Cedar Rapids, IA

Billing System Version is one of the nation's leading Communication service

providers and also plays a major role in local telephone industry. Involved

in customer support application, billing, services, new features, company

information and payment information was provided to each customer.

Responsibilities:

. Leading the team of 6 people in Business Objects.

. Involved in Data Analysis in consideration with Business Logic.

. Have designed around 15 Universes and created 100+ Webi reports on

BOXIR2.

. Have created more than 25 complex reports.

. Have done complete Migration of reports, universes, folders, and users,

user rights from one repository of Business Objects XIR2 to another

repository of Business Objects XIR2.

. Have created Universes that involved more than 30 Dimension tables and 8

fact tables and linking two universes.

. Have worked on other BO modules like Performance Manager, Dashboard

Manager, Crystal Xcelsius 4.5, and Crystal Reports XI.

. Have created around 50 Crystal Reports on Complex REPO, Mark to Market

for RBS NL Business Unit.

. Created Metrics, analytics, tracked KPIs in the Dashboards.

. Created dashboards through Xcelsius and shared them to the team via

Excel, PDF and the Web.

. Created and scheduled reports / dashboards.

. Extensively used BO & WebI reporting Scope of Analysis technique such as

Slice and Dice, Sorting, Hierarchies, Drill Through, Drill Down, Drill

up, Filter, Calculation, Report Layout, Prompts, Tabular, Cross-Tabular,

Bar-Chart reports, Aggregates, formatting.

. Have implemented Aggregate Awareness, Short Cut join in universe designer

to improve query performance.

. Have created and scheduled (Report Bursting) many reports / dashboards

through Web Intelligence and CMC as per the User requirements.

. Have used Oracle SQL, PL/SQL as a data provider.

. Have published BO reports through Publishing Wizard, Infoview, and CMC.

. Performed Windows AD authentication using Kerberos.

. Have designed Data Mart based on Star Schema for reporting purpose.

. Was involved in the security set up of BO environment, users, folders,

reports, universes through CMC.

. Backing up CMS, File Repository Servers, and Documents weekly and

ensuring that recovery of the repositories is possible.

. Involved in Data Integration, Data Quality, and Data Cleansing using

Informatica for moving data from source to target databases.

. Involved in the Extraction, Transformation and Load process (ETL) for a

Data Warehouse from their legacy systems using Informatica.

. Worked on different Data sources ranging from flat files, Oracle, SQL

server databases.

. Created Reusable Transformations and Mapplets, used them in Mappings to

develop the business logic for transforming source data into target.

. Created and Monitored Workflows to run Session tasks using Informatica

8x.

. Involved in Full Development Life Cycle starting from requirements

gathering & impact analysis to proper functional and technical testing of

the reports and user sign offs and maintaining technical design

documents, traceability Matrix and assisting users in developing new

reports. .

Environment: Windows 2003 Server, Business Objects XIR2, Crystal Reports,

Informatica, Oracle 9i/10g, Web Intelligence, Designer, InfoView, Xcelsius,

Dashboard Builder.

BO 6.5 / XIR2 Developer

Feb 2006 -

Apr 2007

HSBC Technology Services - Chicago,IL

VISION Consumer lending origination system to originate Real Estate &

Consumer loans. This application has the following sub-systems such as Lead

Management, Application Generation, Payment Calculation, Underwriting, and

Loan Close.

Responsibilities:

. Analysis and Design of Universe in Marketing Intelligence.

. Have created more than 15 complex reports based upon 2 or more data

providers.

. Have created around 3 complex Universes that involved more than 18

Dimension tables and 6 fact tables and linking two universes.

. Performing Administrative activities through CMC

. Have done complete Migration of reports, universes, folders, users,

user rights from Business Objects 6x to Business Objects Xi.

. Have done complete Migration of reports, universes, folders, users,

user rights from one repository of Business Objects XIR2 to another

repository of Business Objects XIR2.

. Have published BO reports through BO publishing wizard, Infoview, CMC.

. Backing up CMS, File Repository Servers, and Documents weekly and

ensuring that recovery of the repositories is possible.

. Tested and resolved loops, FAN Trap, CHASM Trap through contexts and

Aliases to ensure the correct results from the query.

. Have implemented Aggregate Awareness, Short Cut join to improve query

performance.

. Have significantly worked on faster retrieval of data by improving

query performance both at the report level and at the universe level.

. Have worked on Data Warehousing, Data marts based on Star and Snow

Flake Schemas.

. Wide usage of Drill mode and Slice and Dice techniques to modify the

reports in accordance with the user's analysis needs.

. Have worked on BO 6.5 Supervisor for the security set up, access

rights of BO Users, Folders, and documents.

. Used Stored Procedures as data providers for Business Objects Reports

and also worked on Crystal Reports.

. Was actively involved in planning, documentation and administrative

tasks.

. Developed 12 reports over a 3 week deadline.

Environment: Windows XP, Business Objects 6.5 / XIR2, Crystal

Reports, Informatica, Oracle 9i, SQL Server 2000/2005.

Business Objects 6.5 Designer Mar

2005 - Jan 2006

Omegacube Technologies - Chicago, IL

PowerERP is a product with ERP needs within one system, including sales and

distribution, manufacturing, inventory control, financial management,

without requiring complicated interfaces to third party software. Get a

competitive advantage with real-time, end-to-end visibility and control

over business processes that you can share with customers & suppliers.

Responsibilities:

. Developing all the business related customized Webi/Deski reports from

the system and the workflow system that are customized as per the

user's requirements.

. Responsible for designing the Universe, created Contexts and Aliases

for resolving

. Loops in the Universes to improve performance.

. Linking the Universes to share common objects. Updating and

maintaining Universes based on changing user requirements and data

source change.

. Updated Universes by adding new objects to support new additions to

the Reports.

. Created different types of reports like Master/Detail, Cross Tab and

Chart.

. Wide usage of Drill mode and Slice and Dice techniques to modify the

reports in accordance with the user's analysis needs.

. Resolving FAN trap, CHASM trap, solving lops by creating Contexts and

Aliases in the Universe.

. Used templates for Business Objects Reports.

. Migration of Universes and Reports from one Repository to other by

using Import Wizard.

. Optimizing the existing Universe and Creating of new universe for the

private bank reports, created oracle views and inserted in universe

. Extensive use of Oracle Procedure while creating reports, modifying

existing procedures as per the report specifications.

. Have written Free-Hand Oracle SQL queries for complex ad-hoc

requirements.

. Modify existing reports and create new reports as per the user

requirements

. Refreshing the reports weekly, monthly and Qtly and send to different

users

. Used Broadcast Agent to distribute the reports to different users.

. Involved in working with different database environments and moving of

the universes and reports between PROD, DEV and TEST

. Involved in giving training to End-users

Environment: Windows XP, Business Objects 6.5, Oracle 9i, ASP.NET

Business Objects 5.1 Developer

Dec 2002 - Feb 2005

160by2 Media - India

SMSCountry Networks Pvt Ltd - India

Responsibilities:

. Involved in Integration of data into Data warehouse.

. Created around 6 Universes using Business Objects Designer.

. Creating new Deski reports and modifying the existing per the user

requirements.

. Created various classes and objects

. Measure objects and dimension objects were created keeping in view of

the end-user requirement

. Created user prompts, conditions and filters

. Assigned privileges to users.

. Generated reports using Business Objects in the existing OLAP System

Environment: Business Objects 5.1, Designer 5.1, Supervisor 5.1, Oracle 8i,

SQL Server 2000, ASP, VB Script, Windows NT.

Contact this candidate