SUMMARY

• Over 7 years of professional experience in the field of Information Technology with emphasis on Business Intelligence, Business Analysis and Database applications using tools like Business Objects, Crystal Reports and Xcelsius.
• Experienced in Business Objects 4.0/ XIR3.1 Enterprise Suite including BI Launchpad, Infoview, Universe Designer, Information Design Tool, Web Intelligence Rich Client, Central Management Console (CMC), Central Configuration Manager (CCM), Central Management Server (CMS), and Import Wizard.
• Strong working knowledge of requirements gathering, creating functional and technical documents required for universe and report development.
• Proficient knowledge on SAP BI 4.0, 4.1 and new features.
• Worked on installation, configuration and maintenance of Business Objects Platform 4.0
• Upgrade experience with Business Objects 4.0 Service Packs.
• Effectively administered and supervised the Business Objects (SAP BI) environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Expert in designing, developing, maintaining and optimizing the Universes using Designer module.
• Substantial experience in Business Objects Migration.
• Experience in Training & Supporting end - user reporting needs using Business Objects.
• Experience with Data Stage for ETL (Extraction, Transformation, and Loading) from multiple sources database systems to Data Warehouses.
• Experience in writing system documents, technical documents, and user documentation and also writing training materials helpful for end users.
• Extensively worked in all Business Objects Universe functionalities and Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• • Good Experience in creating Corporate Dashboards, Metrics, Rules, Alerts, Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart and Goals using Xcelsius 2008.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals and teams at all levels..

TECHNICAL SKILLS

Reporting Tools: Business Objects 4.1/4.0/ XI R3.1/R2, Infoview, Webi, Webi Rich Client, Live fficeXcelsius, Designer, Import Wizard, CMC (Central Management Console), CCM (Central Configuration Manager), Apache Tomcat, Query Builder, Import Wizard, Promotion Management and Upgrade Management Tool.

Databases: Teradata, Oracle 11g/10g, Microsoft SQL Server 2008/2005, Sybase, Access, DB2.

Operating Systems: UNIX AIX, Linux, Windows 2000/XP/Vista/7

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Business Objects Administrator

Responsibilities:

• Maintained the infrastructure of Business Objects 4.0 SP6, SP8 and 3.1 SP5 on Unix AIX/Linux Operating System.
• Actively involved in upgrading SAP Business Objects 3.1 to 4.0 SP 6 and then to SP 8.
• Technical leader for Business Objects Platform 3.1 and 4.0 supervising complete offshore team
• Managing and leading BI platform administrators and other dotted line cross-functional resources on a variety of activities including but not limited to: periodic routine support and administrative activities, ad-hoc analysis, and problem troubleshooting.
• Presented strategic ideas to senior leaders in a confident and persuasive manner
• Primary technical leader and owner of complete enterprise BI/BO Platforms
• Documented support procedures and activities and communicated BI platform engagements to key stake holders
• Conducted daily 'health checks' of BO Application servers and services
• Enhanced performance by modifying the configuration of Business Objects.
• Optimized the Business Objects Servers as per the changing requirements
• Restarted the BO Services from UNIX when required.
• Provided daily monitoring and support for scheduled reports and publications
• Trouble-shoot and provide support for technical issues related to connectivity, database, and end-user systems as it relates to the BO Application Toolset (Designer, Webi, Launchpad, Dashboard, Rich Client, etc.)
• Managed user and content security when necessary
• Provided support for migrations through Import Wizard, Upgrade Management Tool and Promotion management.
• Conducted monthly usage assessment for Users and Content (Audit)
• Automated the cleanup process of BO 3.1 and 4.0 Servers.
• Implemented automated weekly restarts of BO Servers.
• Maintained the CMS and Audit database on MySQL and Oracle.
• Worked with WebSphere Team to maintain the Business Objects middleware Tier.
• Maintained the tomcat (Web Application Service) on BO Servers.
• Restarted the BO Services from UNIX when required.
• Implemented a complete Disaster Recovery activity.

Confidential, Wilmington, DE

Business Objects Admin/Developer

Responsibilities:

• Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Worked on Business Objects Enterprise XI 3.1.
• Created Ad hoc reports with Business Objects and deployed them in Web Intelligence.
• Created Complex prompts for users to restrict data in the reports as per client requirements.
• Migration of reports and universes from Dev to QA, UAT and Prod.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Involved Migration from Business Objects 6.5 version to BO XIR2.
• Used Import Wizard for the Migration process. Migrated users, universes, reports and Converting Deski Reports to WEBI using Report Conversion Tool.
• Created Universes on top of Oracle and Teradata.
• Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects and Applied Contexts and Alias Tables to remove Loops and Traps.
• In Designer module created Tables and relationships i.e. cardinalities and improved the performance.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Exported the universes to the Repository to make resources available to the users and created reports for various portfolios using the Universe.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Documented all the changes made to the Universes and Reports for future references.
• Provided end user training for basic and advanced reporting skills.
• Developed Test cases based on requirements and provided technical assistance/support to analysts, business community and troubleshooting for various problems pertaining to reporting, formatting, design of universes and other BO complexities and actively involved in 24X7 production support.

Confidential, Tampa, FL

Business Objects Admin/Developer

Responsibilities:

• Worked on Business Objects tool 4.0 components Universe, WEBI, Crystal Reports and Dashboards.
• Used Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects and Applied Contexts and Alias Tables to remove Loops and Traps.
• Created new/modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.
• Administered, maintained and supported BO environment on various platforms like Windows 2000/XP/98.
• In UNIX environments, used shell scripts to configure Business Objects services on the available hardware.
• Managing the User rights on Business Objects Applications like Desktop Intelligence, Web Intelligence, Designer, Dashboards etc and Folder Security for different groups of Users.
• Worked extensively on distribution, maintenance, and optimization of universes for Business Objects and Web
• Scheduled the reports according to the user requirements based on the Oracle database connectivity.
• Creation of Folders in CMC and implementing security on various objects of CMC (folders, Applications, Universe and Connections).
• Involved in performance tuning of Business Objects and WEBI reports and published reports to WebI.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
• Exported the universes to the Repository to make resources available to the users and created reports for various portfolios using the Universe as the main data Provider.
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Created linked reports for Web Intelligence reports using open document functionality.
• Created Ad hoc reports with Business Objects and finally deployed them in Web Intelligence.
• Managed new user controlling access levels and assigning and maintaining report level and user level security in CMC and row level and object level security in universe to in corporate security for sensitive information.
• Created graphical representation of reports such as Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart using Xcelsius 2008.
• Documented all the changes made to the Universes and Reports for future references.
• Provided end user training for basic and advanced reporting skills.

Confidential, Long Island, NY

Business Objects Developer

Responsibilities:

• Requirements gathering from different level of users (SME, senior level managers etc, creating functional/technical specifications for the requirements, developing prototypes
• Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to comply with their needs and requirements.
• Analyzed the existing database schema, retrieved the Fact and Dimension tables and created Joins as identified in the Universe design.
• Involved in the migration of Universes/Reports from Development to Test environment and finally into production environment after UAT (User Acceptance Testing) using Import Wizard.
• Created complex reports using the multiple data providers and Implemented merging dimension concept by linking the common objects to create the common report.
• Prepared many critical WebI reports by using master detail and drill mode on tables and graphs as per the requirements of the end-user.
• Tested the universes and reports after migration and fixed migration issues related to universes and reports.
• Created classes, objects and conditions as per requirement of the reports and generated various numbers of reports on a daily, weekly and monthly basis using Business Objects report module.
• Analyzed Universes and Reports for the legacy applications and developed new universes for maintenance and safety modules.
• Involved in Database design and implementation of general report scheduling and distribution system.
• Solid experience in creating application schema as tables, view and indexes and SQL tuning of reports to increase performance.
• Used Query as a Web Service tool (QaaWS), Live Office and generated various WSDLs using the BI web services, and successfully tested them in the Crystal Xcelsius 2008 tool to develop the Dashboards based on the Business requirement.
• Developed complex interactive and dynamic dashboards with Xcelsius and implemented prompts, drill down capability and Applied alerts.
• Involved in Pre and Post Implementation and Validation procedures when promoting Business Objects universes and reports to production.
• Interacted with the end users and provided Production Support.
• Trained Power Users/End User to use the tool and create Ad-hoc business object reports.
• Automated the Business Unit Performance Web I reports refreshing every month.
• Documenting the entire effort. The Documents generate during the process were Requirements Specification, Design Document, Project Unit testing documents, and System testing documents.

Confidential, Chesapeake City - MD

Business Objects Developer

Responsibilities:

• Interacted with Business Users in gathering, analyzing, and documenting business requirements, functional requirements and data specifications.
• Created Universes and Business Views for canned reports based on the relational data model and Implemented row level and object level security within the universe.
• Created Users, User groups using and assigned privileges to access and work with Universes and reports.
• Designed and developed Universes based on the specifications, created classes and objects.
• Defined joins and set the cardinalities between the tables and resolved loops by creating aliases and contexts.
• Created custom LOV’s (list of values) which help the end users while picking the values from the prompts.
• Linked the Universes to share the common components between them.
• Applied security features of Business Objects like row level, report level & object level security in the universes so as to make the sensitive data secure.
• Used business objects functions like @prompt, @select, @where, @variable.
• Organized data in the reports by using Filters, Sorting, and Ranking.
• Web Intelligence Reports were created and deployed through Info View.
• Extensive Analysis has been done to Design the Universes and assigned them to respective domains.
• Created custom Hierarchies which help the end users to drill down to lower levels in the reports.
• Created Alerters using Business objects to highlight columns based on business criteria.
• Inserted drill filters in the Web Intelligence reports, which help the end users to run a report based on multiple selection criteria.
• Extensively worked on complex reports using multiple data providers and reports including graphical reports, formula based reports, sub-reports, well-formatted reports and Hyper linking reports according to user requirements.
• Extensive reporting was done using Business Objects Functionalities like Dice, Slice, Drill Down, Cross Tab, Master Details etc.,
• Conducted Training to the end users in order to let them understand the functionality.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast agent console.