Tapan Panwar abmg7q@r.postjobfree.com ***-***-

****

PROFESSIONAL SUMMARY:

. About 8 years of technical experience in utilizing Business Objects, and

other major enterprise reporting tools with focus on development and

deployment of medium to large-scale Business Intelligence/Data

warehousing solutions

. Senior Business Objects Developer/Administrator/Architect with expertise

in BO Migration, Business Object Universe Development and Security,

PL/SQL methods, Canned/Ad-Hoc, WebI, and BO Reports

. Designed BOXI3 and BOXIR2 Architecture that involved Server Setup,

Clustering, Sizing and Capacity Planning, Performance Testing, and Load

Balancing to avoid bottlenecks and evenly distribute traffic for each

environment

. Installed, configured and administered Business Objects versions XI R3

and XIR2 on UNIX and Windows Platforms

. Administered Universe Security at both levels (CMS and Universe) via CMC

and Designer to apply restriction set to a user/group accessing a

universe, in terms of Object access, Row access, Query and SQL generation

controls, connection controls and table mapping

. Proficient in Universe designing, dimension and measure objects,

resolving loops and SQL traps, using functions with objects, using

hierarchies, aggregate awareness, derived tables, and linked universes

. Installed and configured IIS and Tomcat web applications on Apache web

server

. Set up BO Performance Management (EPM) system and target repository

. Designed the dashboard pages for each subject area and built secured

corporate dashboard system. Made trouble-shooting and maintained

dashboard system operations

. Provided Administrative Support on day-to-day basis to troubleshoot

issues internally and also with the help of Business Objects Tech support

. Strong ability to work with various business owners and project teams in

implementing analytical and technical solutions, and communicating

limitations and functionality of BI Applications

. Hands-on expertise using and setting up Business Objects

5.x/6.x/XIR2/XI3.0/XI3.1 (Reports, Designer, Infoview, Web Intelligence,

BCA, Supervisor, CMC, CMS, CCM, QAAWS, Live Office, Crystal Xcelsius, and

EPM), Crystal Reports XIR2/XI/10.0/9.0

. Excellent understanding of SQL, PL/SQL, Stored Procedures/Functions, Star

Schema and Snow-Flake modeling, Facts, Lookup, and Dimension Tables

. Experience assessing business rules, performing logical and physical data

modeling to document and maintain business rules and implement physical

database objects, developing and optimizing stored procedures to solve

complex problems

EDUCATION:

. Masters in Industrial & Systems Engineering

o University of Southern California, Los Angeles, CA

. Bachelors in Industrial & Production Engineering

o Visveswaraiah Technological University, Belgaum, KA

TECHNICAL SKILLS:

Business Intelligence Reporting Tools:

Business Objects version XI 3.1/3.0/XIR2/6.5.x/6.1.a/5.1.6 (CMC, CMS,

Designer, Reporter, and Supervisor), BCA Scheduler and Publisher, Auditor,

InfoView, Web Intelligence, Desktop Intelligence, Crystal Reports

XI/10.0/9.0, JMP-IN, SAS, EPM, Dashboard Manager, Crystal Xcelsius, Live

Office, QAAWS, BMC Analytics, BMC Dashboards for BSM

Databases: Oracle 8/8i/9i /10g (SQL, PL/SQL, Stored Procedures, Triggers),

SAP BW, SQL Server, DB2 and MS Access

Languages: SQL*Plus, PL/SQL, HTML, DHTML, C, C++, VB 5.0/6.0

ETL Tools: Informatica, Datastage, Data Integrator, Informix

Operating Systems: MS-DOS, UNIX, Linux, Windows NT/2003/2008 server

EXPERIENCE:

US Courts, Washington, DC

APR 2010 - JUN 2010

(Sr. Business Objects Administrator/Architect)

Administrative Office of US Courts is using Business Objects XI R2 SP4

deployed on Linux platform. The goal of this project was to first identify

risks and gaps in the Business Objects Architecture and then remediate

those risks and fill up gaps by implmenting Best Practices and install

various Business Objects applications like Data Quality, Data Insight,

System Monitoring, Metadata Manager, System Auditing, etc.

Responsibilities:

. Reviewed existing Business Objects deployment at US Courts to identify

risks and gaps.

. Documented existing System Architecture, and proposed sizing and future

enhancements.

. Conducted interviews with various teams to understand Business

requirements and propose solutions accordingly.

. Installed BO XI R2 SP4 on Linux Servers and Metadata Manager, Data

Quality, and Data Insight on Windows Servers.

. Documented and implemented Business Objects Best Practices on

Architecture Configuration, Security Model, Auditing, Montoring, Content

Migration, Patch Testing & Deployment, Backup and Recovery, etc.

. Provided guidelines on better administration and maintenance of the

current production, QA and development Business Objects systems.

. Recommended changes to bring the system in line with BO recommended

settings such as SPs, Memory Configurations, Repository Changes, File

System Changes, etc.

. Documented future upgrade options to BOXI 3.1 SP2 with LCM for migration

and Group/Security Model.

. Installed and Configured Business Objects Monitoring probes using IBM

Tivoli, defined system thresholds and set up alerts and notifications.

Environment: Business Objects XIR2, Data Integrator, Infomix, Linux Red Hat

server, Windows 2003 server, Metadata Manager, Data Quality, Data Insight,

IBM Tivoli

Symantec Corporation: Mountain View, CA SEPT

2007 - MAR 2010

(Sr. IT Infrastructure Specialist/Business Objects Administrator/Architect)

Symantec is currently using Business Objects XI Release 2 and XI Release

3.1 SP2. The goal of this project was to provide Enterprise Business

Intelligence Department and its Customers with ongoing BO Admin support. My

role at Symantec also included the maintenance and enrichment of BO

infrastructure. I fulfilled that by troubleshooting some crucial issues

that were affecting BO performance and also recommended infrastructure

enhancements to meet the current and future reporting needs.

Responsibilities:

. Contributed to the success and on time delivery of several in house

projects like Atlantis, Renaissance, Partner net, ePayment, etc.

. Provided Admin support for BO related issues in all the BO environments.

. Proposed and carried out various Infrastructure and performance

enhancements in the existing BO XIR2 environment.

. Recommended addition of UAT environment to the existing Business Objects

Dev, QA, and Production infrastructure.

. Installed, set up, and configured BO XI R2 on Windows Servers.

. Administered Universe Security at both levels (CMS and Universe) via CMC

and Designer to apply restriction set to a user/group accessing a

universe, in terms of Object access, Row access, Query and SQL generation

controls, connection controls and table mapping.

. Installation and configuration set up of BO XI 3.1 SP2 on Dev, QA, and

Production Windows 2008 servers.

. Supported XI 3.1 Production infrastructure, defined and implemented

security structure.

. Provided detailed documentation on the steps necessary for installation

and configuration of BO XI 3.1 SP2

. Successful Integration and configuration of BO XI 3.1 with SAP BW

(Business Warehouse).

. Configured WAS and IIS on Business Objects servers for IBM WebSphere

server.

. Good knowledge of Business Objects Java SDK and used them for several

custom applications.

. Requested and contributed to the implementation of Sitescope alerts for

Business Objects services.

. Deployed latest Service Packs and Fix Packs for BO XIR2 in all

environments.

. Implemented Automated BO Account creation and access grants processes

with the use of SDK.

. Troubleshoot various Live office issues that adversely affected customer

deliverables.

. Set up Monitoring for several critical BO server and application

components.

. Customization of Infoview Logon page, Disk space analysis and clean up on

FRS.

. Migration of Crystal Xcelsius Dashboards and troubleshooting dashboard

related issues.

. Managed and configured user security, pods, and dashboard templates using

BMC Dashboards Admin console.

. Implemented Single Sign On with Active Directory authentication for BO XI

R2 and BO XI 3.1 systems.

. Designed Reports and Metrics based on Audit database to understand the

usage patterns and analyze load on BO servers in a better way.

. Ensured integration with other technologies utilized in the enterprise

and continuity across Enterprise wide applications.

Environment: Business Objects XIR2, BO XI 3.1, Crystal Xcelsius, Live

Office, Oracle 10g, Windows 2003 server Windows 2008 server, AD server,

Java deployment, BMC Analytics and Dashboards, SAP BW, QAAWS

Expedia Inc: Bellevue, WA MAY

2007 - AUG 2007

(Sr. Business Objects Administrator/Architect)

The BI project consists of a new implementation of Business Objects

XIR2. Expedia Inc was running with Business Objects 6.5 and the goal of

this project was to upgrade Business Objects, set up the Architecture,

installation and configuration of BO XIR2 environment, migration,

implementation of best practices and standardization strategy. Act on

behalf of Expedia Inc in conjunction with the consulting company that takes

ownership of development in Business Objects.

Responsibilities:

. Actively involved in the BO XIR2 Architecture planning and deployment.

. Actively involved in Capacity Planning, Performance Testing and Load

Balancing on BOXIR2 servers for each environment.

. Enhancing individuals, team and client knowledge of Business Intelligence

projects through the application of best practices, and prototyping for

Universes and Reports.

. Designed BOXIR2 clustered server environment to avoid bottlenecks and

evenly distribute traffic.

. Installed, configured and administered Business Objects software version

XIR2.

. Migration of all Reports and Universes from BO 6.5 to the BO XIR2

Development, Testing, and Production CMS databases using BIAR file into

the Infoview/WEBI format.

. Maintained the current security framework for the CMS.

. Created standard default profiles for groups, average user and super-

user.

. Tested and enabled WEBI for users ad-hoc querying.

. Prepared the Business Objects groups and privileges within the repository

for the WEBI environment

. Integrated and maintained Business Objects with SAP Business Warehouse

data source.

. Participated in dimensional data analysis to match KPIs and back end data

elements to define the future dashboard elements, such as measures,

metrics, sliced metrics and calendars etc.

. Set up BO Performance Management (EPM) system and target repository (PM

REPO).

. Created metrics universes, configured them into EPM system and

constructed various metrics, calendars and analytics.

. Designed the dashboard pages for each subject area and built secured

corporate dashboard system. Made trouble-shooting and maintained

dashboard system operations.

. Enhanced individuals, team and client knowledge of Business Intelligence

projects through the application of best practices.

. Working with web technologies (HTML), application server environments

(JSP & ASP) and web servers (IIS and Apache).

. Lead project in functional/technical capacity, adding value to the

project and with the final deliverables on the assigned projects.

. As a BO Lead Architect, designed, built and supported data and technical

architecture components on behalf of the customers.

. Documentation and presented recommendations based on findings after

reviewing them with client.

Environment: Business Objects 6.5.2 and BO XIR2 (Supervisor, Designer,

Business Objects, CMS, CCM, and CMC), EPM, Dashboard Manager, Full Client,

WEBI, Broadcast Agent, HTML, Windows 2003/NT, SAP BW, MS SQL Server, DB2.

Oakwood Worldwide: Los Angeles, CA

JAN 2006 - APR 2007

(Business Objects Administrator)

The system was built with an objective to help top-level management in

decision making. The data from different departments is collected and

integrated into a data warehouse and is sent to data marts that are built

based on subject areas. Also, used Business Objects Web Intelligence as one

of its internal reporting standards to create and distribute reports to the

company's employees.

Responsibilities:

. Installed, configured and administered Business Objects/Crystal

Enterprise server.

. Deployed Reports on web by using components of Crystal Enterprise. Worked

with the Crystal Enterprise Administrator for determining the rights and

authorizations of report users.

. Created and managed users and groups.

. Assigned profiles and security options.

. Administered user accounts and privileges for repository users.

. Imported and exported universes to and from the repository.

. Defined a Broadcast Agent for a group.

. Maintain/administer/troubleshoot Crystal Enterprise Systems.

. Used Crystal Publishing Wizard for publishing and scheduling the reports

on Crystal Enterprise Systems and published several reports for on-demand

as well as recurrent viewing.

. Managed and controlled Business Objects products, Universes, Documents,

Repository Domains, Stored procedures.

. Performed Business Objects Environment management including sizing,

performance tuning and security administration.

. Created and managed Universes in the Designer.

. Analyzed various Reports by pulling the OLAP data from Data Warehouse

like Sales of Product, By Region wise, Reports Based on time like Year,

Quarter, Month, Week, Geographic Reports and Comparative Reports.

. Exported the Universes to the Repository to make resources available to

the users.

. Created new Classes and user Objects in designing the Universes.

. Published reports using Infoview, and trained end users for ad hoc

reporting.

. Planned coordinated and executed Business Objects XI deployments for end-

users and documented the entire project.

. Created Drill-Through reports to provide users with more detailed

information and query linking.

. Involved in creating the Reports on the web using the Web Intelligence.

. Exported the Reports to the Broadcast Agent Server.

. Handled Data Extraction and Data Cleansing using BO Data Integrator.

. Involved in massive Data Cleansing prior to Data Staging from Flat Files.

Environment: Business Objects XI Designer, CMC, Crystal Reports 10.0,

Broadcast Agent server, Data Integrator, Dashboard Manager, .Net

deployment, SQL, Oracle and Win NT.

Federal Trade Commission (FTC): Washington DC OCT

2005 - DEC 2005

(Business Objects Administrator/Developer)

As a technical lead responsible for migration of Business Objects from

version 5.1.6 to version 6.1.3. The functional requirements of the Upgrade

project undertaken were to migrate/upgrade of repository, universes and

reports from Business Objects version 5.1.6 to Business Objects version

6.1.3 as well as, conversion of Full Client Reports into WEBI Reports. The

system is used at FTC by over 300 end users and reports are generated

throughout the agency. The data for the universes comes from various

databases like Oracle, MS SQL SERVER and other generic ODBC sources. Also

responsible for client interaction and liaison with Business Objects

support.

Responsibilities:

. Developed project plan, defined the scope of the project, designed and

implemented Upgrade/Migration Strategy for redeployment of Business

Objects WEBI 6.1.3.

. Installed, configured and administered Business Objects software.

. Upgraded all FTC Universes from Business Objects 5.1.6 to Business

Objects 6.1.3.

. Upgraded all FTC Reports in the repository into the Infoview/WEBI format.

. Created a standard default profile for an average user and super-user.

. Upgraded user reports/ad-hoc reports not in the repository. These reports

were provided by the FTC in 5.1.6 version.

. Created Test strategy plan and worked with end users to test the upgraded

universes and reports. These universes and reports were tested

successfully at FTC's Development and AT environments.

. Verified that report(s) have proper security access and privileges as per

FTC defined user policies.

. Tested and enabled full HTML editor for users to use WEBI for ad-hoc

querying.

. Prepared the Business Objects groups and privileges within the repository

for the WEBI environment

. Provided detailed documentation on the steps necessary for migration of

universes and reports from development to test environment to production

environment.

Environment: Business Objects 5.1.6 and 6.1.3 (Supervisor, Designer,

Business Objects), Full Client, WEBI, Broadcast Agent, HTML, Windows

2000/NT, Oracle 9i, Erwin, SQL and SQL*Plus, SQL Navigator, MS SQL Server,

MS Access, Tomcat 4.1

Mercator Healthcare Ltd: Mumbai, India JUL 2002 -

AUG 2005

(Business Objects Developer/Reporter)

The project was based on creating various universes to meet the end users

need for auditing, broadcasting. Business Objects is being used for end-to-

end reporting and global reporting is integrated through Webi.

Responsibilities:

. Identified source of data and tables for Extracting Information and

Suggested summary tables.

. Handled administration of Data Security mechanisms with Supervisor

. Assisted and trained end-users for writing Reports and performed Ad-Hoc

Queries

. Checking integrity of universes and resolving connections, loops and trap

issues

. Managing users and groups as a BO Supervisor with multiple

repositories/domains.

. Providing end-user support for client-server issues and for document

migration processes Gathered the Report Requirements from the users and

created the Universes and Reports.

. Defined Cardinalities and checked the Integrity of the Universes.

. Designed the Universes, created Contexts and Aliases for resolving Loops

in the Universes.

. Extensively used Decode statements, and Designer Functions like

@Aggregate Aware, @Prompt, @Date, @Select, @Where etc.

. Created Documents both (full client and WebI), summary and detail with

the functionality of Drill down to detailed document.

. Extensively used Calculations, Variables, Breaks, Sorting, Drill Down,

Slice and Dice, Alerts for creating Business Objects Reports.

. Created Objects to Drill Down from Count (measure) to dimension objects

. Provided Object level security using table mapping and used derived

tables and defined the prompts at table level.

. Recommending design changes to database/warehouse tables to improve query

performance

Environment: Business Objects 6.5, Web Intelligence, Broadcast Agent, MS

SQL Server and Windows NT[pic]

Contact this candidate