SUMMARY:

• About 11 years in developing and Administering Business Objects 3.1, XIR 2, 4.1 and 4.2 applications.
• Proficient knowledge on SAP Business Intelligence Platform Architecture and new features.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, Security Management and Production supporting on various platforms like Linux, Unix, Windows NT/ 2000/2003/2008/ XP/Win7 and Win 8.1
• Hands on experience Installing, upgrading and patching BO applications on both Windows and Unix platforms.
• Expertise to Install Standalone servers to test various patches and major upgrades.
• Hands on expertise configuring and activation of Disaster Recovery servers.
• Technical hands - on experience troubleshooting tools like SAP Business Objects 4.2 (Webi Reports, Web Intelligence Rich Client, Universe Designer, BI Launchpad, Information Design tool, Crystal Reports Designer and Open Document.
• Extensively used CMC and Query Builder to troubleshoot various user, content and server related issues.
• Troubleshooting report issues, system slowness, Logging and Tracing configuration via BO Trace.ini and Server Properties.
• Modified ODBC and ODBC.ini, OLE connections for SQL DB servers, DB2 Cataloging and TNS Entries in TNSNAME.Ora file on all BO and client machines.
• Expert in tuning and optimizing the performance of SAP Business Intelligence Platform 4.1 and 4.2
• Design Dashboard and visualization with dimensional data connection by using Query as a Web Service (QAAWS), and Live Office.
• Expert in Universe Designing and Development using UDT and IDT.
• Designed and Created Crystal Report using the SQL Queries and Universe.
• Extensively used Business Objects Web intelligence reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Knowledge of Unix and Linux operating systems.
• Highly motivated and very hard working.
• Flexible in learning new systems, programs and procedures.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Business Intelligence and Admin Tools: SAP Business Intelligence Platform 4.1, 4.2 Xi3.1, Xir2, Information Design Tool, BI LaunchPad, CMC,, Auditing, Promotion Management, UMT, Monitoring, CCM, Reposcan, Web Intelligence, Business Objects Designer, Xcelsius Dashboard and Crystal Reports and Live Office.

ETL Tools: SAP BO Data Services 4.0, Xi3.2, Informatica Power Center 8.1.1, DTS, PL/SQL

RDBMS: Oracle 10g, DB2, Netezza, SQL Server 2012/8, Sybase.

Data Modeling: Star-Schema Modeling, Snowflakes Modeling

Languages: C, C++, Visual Basic, Java, PL/SQL, SQL.

Operating Systems: AIX, Linux, Window 2008, Windows 7, Windows 8.1.

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, Ohio

SAP business objects Administrator

Responsibilities:

• BO Servers Upgrade from 4.1 version to version BO BI 4.2.
• Migration of reports / universes/ users along with security settings from dev/stage to Prod Environment using Promotion Management tool following Change Management Process.
• Design and implement security by creating of user groups, granting access to BOE applications to users and adding security restrictions (application level, folder level and object level) based on user profile and user groups.
• Monitor/Handle BO services during windows servers’ maintenance.
• Configure/Optimize Servers settings. Apply trace logs on servers in case of troubleshooting complex incidents.
• Start /Stop, Enable/Disable, Clone, Add, remove BO , tomcat and Websphere Services on requirement.
• Taking LCMBIAR Back up of reports/universes in destination system before creating Promotion management jobs.
• Activating DR servers as a part of quarterly DR exercise.
• Provide support to L1 team with regards to various report related issues.

Enviornment: AIX 7.1, Windows 2008 R2, Citrix, Websphere, Tomcat. Web Intelligence, Crysta, Reports, Dashboard, IDT, UDT, CMC, Query Builder, Monitoring And Windows 7.

Confidential, Newark, New Jersey

SAP business objects Administrator

Responsibilities:

• Design & Manage administration architecture of SAP Business Objects
• Software Installation for new build / Patching for upgrades (BO 4.2).
• Reports and Universe Migrations via Promotion management tool.
• Configured Access level Security Settings on Business Objects CMC.
• Monitoring Business Objects related services and
• Scheduling and maintaining various Webi and crystal reports via Instance Manager.
• Troubleshoot Various issue reported by the developers with report related issues.
• Adhoc requests / Service related queries
• Incidents management with vendor (SAP)
• Assisting BI DEV/Support teams in critical support issues.
• Development & relevant engagement in POC's (Proof Of Concept) to create a Webservice link for external applications.
• Ability to debug Business Objects Suite tool related issues.
• Work on automation of server availability & schedule to reduce manual efforts
• Maintain Audit & CMS database for Business Objects system statistics analysis.
• Configured business objects web services to provide data to various downstream applications.

Confidential, Mason, OH

Sr. Business Objects Consultant

Responsibilities.

• Created and Modified Universes using Universe Design Tool and Information Design Tool in BI Platform 4.1.
• Created Dashboards using the Dashboard Designer 4.1 using various techniques.
• Created Static and Dynamic Dashboard and published them to the BI Platform.
• Modified and Tested Webi Reports based on the functional requirements.
• Modified existing BO Auditing Universe for Business Objects Server Performance Reporting (Distributed Installation).
• Created Webi Reports to Identify various metrics collected by the Business objects system Database (CMS).
• BO Servers Upgrade from version BO BI 4.0 to version BO BI 4.1
• Migration of reports / universes/ users along with security settings from one Dev/Pre-Prod to Prod Environment using Promotion Management tool following Change Management Process.
• Granting access to BOE applications to users and adding security restrictions (application level, folder level and object level) based on user profile and user groups. Create access levels (Super/Basic/Develop) based on project needs.
• Converted UNV universes to UNX using the IDT.
• Created Single Source Universes to MSU by modifying the underlying DF layer.
• Tested Queries and Promoted Universes to Production following the Change Management process.
• Monitoring day to day scheduled jobs and re-run in case of any failure.
• Regular BO repository Maintenance like Cleaning Orphaned Connection/Universe/Documents.
• Configure/Optimize Servers settings. Apply trace logs on servers in case of troubleshooting complex incidents.
• Work with SAP Support in case any issue is not resolved internally.
• Scheduling the reports on request of BI team.
• Start /Stop, Enable/Disable, Clone, Add, remove BO Services on requirement. Also require to fix tomcat Apache/Tomcat issues.
• Organizing the BO content (Delete, Move & edit).
• Taking BIAR Back up of reports/universes in destination system before creating Promotion management jobs.
• Restored corrupted reports in the File Repositories using the Backup created..
• Resolve all issues reported by Users and providing Production support for BI 4.1 Platform
• Modifying Universe Joins/Contexts as per the request to facilitate changes in the Databases.
• Currently in process of upgrading 4.1 SP 6 to 4.2 Sp3.
• Involved in installation of Tableau desktop, Tableau server, Worked on latest versions of Tableau 10.
• Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Worked on Tabcmd to schedule the report's and setup email reports using command lines.

Environment: Business Objects 4.1, Central Management Console, Promotion Management, Monitoring Upgrade Management Tool,, BI Launch Pad, IDT, Designer, Web Intelligence, Crystal Reports 2011, Dashboard Design 4.1, Live Office, Windows 2008 R2, XP,Win 8.1,Unix, Oracle 12C.

Confidential, Milford, OH

Business Objects Consultant

Responsibilities:

• Maintained and troubleshot BI reports, content, Security and applications for users/groups.
• Created Adhoc reports as per the functional requirements.
• Enabled Trace to detect point of failures and resolved issues based on various scenarios.
• Experience configuring and managing Apache Web Server with Apache Tomcat.
• Experience integrating SAP Business Objects with Microsoft Active Directory (AD)
• Experience with scheduling tools Scheduler and Publishing and troubleshooting.
• Experience with configured and implemented auditing (Auditing Data Store tables)
• Created Backup of the content on a weekly basis.
• Analyzed and Created Universes based on current reporting model used by Cognos.
• Analyzed Converted Cognos reports to Web Intelligence reports based on existing Cognos reports.
• Worked with the application development to integrate BOXI with the ColdFusion frontend.
• Created and modified Technical Specification Documents, Software solution documents.
• Modified and Tested Webi Reports based on the functional requirements.
• Converted Deski reports to WEBI using the report Conversion tool and resolved issues with the partially converted and Not converted reports.
• Created Unit Test Plan to test the report sets during different Phases.
• Performed Data validation using Toad and AQT as a part of developer integrated testing.
• Involved with requirement gathering sessions with the functional users for new changes that needed to be implemented.
• Designed, build and tested Business Objects Infrastructure and Security model.
• Exported the universes to the Repository for making resources available to the users.
• Created Complete backup of the Repository on a weekly basis of the Dev and DevTest environments.
• Created and Maintained users and groups as a BOXI administrator on the Dev and Devtest Environments.
• Conducted sessions on Business Objects Tools for other members of the team for awareness.

Environment: Business Objects 4.1, Xi3.1, Xir2 Central Management Console, Life Cycle Manager, Upgrade Management Tool, Report Conversion Tool, BI Launch Pad,, Designer, Desktop Intelligence, Info View, Web Intelligence, Crystal Reports 2011, Crystal Xcelsius 2008, Live Office, Windows server 2003, Windows 2008 R2, XP,Win 8.1,Unix, IBM DB2.

Confidential, San Antonio, TX

SAP Business Objects Admin/Developer

Responsibilities:

• Created Universes for report generation using UDT and IDT module in Business Objects.
• Designed and built new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Maintained knowledge of reporting processes and assisted end users with access and data issues.
• Created and maintained ODBC connections on all the clusters for respective environments and created documentation.
• Created LDAP groups to provide access to specific folders on the BO servers.
• Managed content promotions through the development, testing, and production phases
• Customized and redesigned complex key reports with related sub reports, charts and graphics.
• Designed and implemented summarized Universe for easier and faster Reporting.
• Developed and maintained Key management reports like Key performance reports and Key Indicator Reports.
• Involved with their Data requirements planning sessions to migrate database from Sybase to MS SQL server 2012.
• Created Solutions specifications documents based on the Requirements. Used IBM Doors 9.0 and SharePoint to publish the documents.
• Migrated AS-IS migration of Crystal reports to Webi using filtering, Prompting, and Drill up drill down features.
• Converted SQR Reports to Crystal Reports as a part of Re-platform as required by the new IT standards.
• Tested migrated databases with Mockup reports.
• Lead Code review sessions to finalize the releases from Dev to upper environments.
• Involved with the Data modelers to finalize the migrations in the Development Environment.
• Setup version control, Revision control suites (CICD) Clear case and SVN to migrate reports to various environments.
• Scheduled reports using Autosys as per the unique requirements from the client, and later scheduled them using the scheduler.
• Involved with the Java Developers to integrate ticketing system Remedy with the BO.
• Validated Data using the MS SQL server management studio and Sybase central on different environments.
• Presented report mockups to the business users and documented feedback for changed and implemented through the business analysts.
• Presented the solutions specifications based on the requirements to the Architecture review Board and to business stake holders.
• Provided data to QA team, to create Test cases for the Reports.
• Conducted the transfer of knowledge sessions, coaching and mentoring less experienced users.

Environment: Business Objects 4.1, Xi3.1 Central Management Console, Life Cycle Manager, Upgrade Management Tool, Report Conversion Tool, BI Launch Pad,, Designer, Desktop Intelligence, Info View, Web Intelligence, Crystal Reports 2011, Crystal Xcelsius 2008, Live Office, Windows 2003,XP,Win 8.1,Unix, MS SQL Server 2012, Sybase, ORACLE 11G, Cleare Case, Autosys, Remedy, IBM Doors 9.0.

Confidential, Newark, NJ.

SAP Business Objects Admistrator/Developer

Responsibilities:

• Involved in the Migration/Up-gradation team for BO 4.0/BO 4.1 on multiple servers in various environments.
• Implemented clustering in all environments for load balancing and fail over.
• Migrated universes, reports, instances, users, events, server groups from BO 3.1 to BO 4.1 using Upgrade Management Tool.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
• Ran and monitored batch reports through Autosys in SIT, QA and Prod environments.
• Set up various time out settings for scheduled reports Infoview and BI Launchpad for R4 in all the environments.
• Attended regular Standup and Status calls with the business, development and testing teams.
• Created folder structures in BO through CMC to house various Web Intelligence, Desktop Intelligence and Crystal reports and Universes.
• Created Active Directory user groups and added users to them.
• Processed new user request for BO by adding them to the required AD groups and creating Enterprise account for them.
• Gathered requirements from end users to create universes and reports.
• Build the Universes for end user report generation using Designer module.
• Detected Joins and checked the Cardinalities.
• Resolved Universe problems like Loops and Traps using Alias and context.
• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.
• Implemented cascading prompts in universe.
• Exported the universes to the Repository for making resources available to the users.
• Created Master/Detail, Cross Tab and various Charts reports and exported to Repository.
• Created reports using Desktop Intelligence functionalities like Sections, Breaks, Filters, Alerters, slice and dice, drill down functions and formulas etc.
• Created Templates in the report generation.
• Was responsible for database connections, SQL joins, cardinalities, loops, aliases, views, parsing of Objects and hierarchies
• Build the Operational reports on SAP BW system and Oracle as a data source.
• Designed new security and implemented the Active Directory Authentication in CMC.
• Created ad-hoc reports to the business users using Web Intelligence.
• Extensive hands on experience with 24/7 operations, troubleshooting production incidents under extreme pressure
• Conducted knowledge transfer to various users and team members.

Environment: Business Objects 4.0, 4.1, Crystal reports 2008, Xcelsius 2008 sp3.5, QAAWS, Windows XP, Oracle 13G, Teradata 13.0, SAP BW and SQL Server 2008 R2.