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]