Sap Business Objects Consultant Resume
Southborough, MA
Professional Summary
- Seven years of extensive experience in development, administration, deployment, and configuring Business ObjectsSuite in a large development, test and production environment and managing operations, delivering and supporting quality, high-performance business systems.
- Extensive experience in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and QA engineers.
- Good Experience in Performing Gap analysis, prepared project plan and solution documents and coordinated with multiple IT teams (Development, QA, Vendors) both internal and external, to ensure delivery of product within tight deadlines.
- Gathered business requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME's).
- Experience in building Universes (UNX & UNV), retrieving data using Universes and Personal data files ,and Free Hand SQL methods and creating Ad-Hoc reports using Business Objects & Web Intelligence Tools.
- Expertise in creating Customized objects @prompts and Cascading LOV.
- Expertise in Creating Contexts and Aliases to avoid loops at the Universes.
- Administering Business Objects Enterprise Framework for large-scale deployments.
- Installation/configuration/upgrades/performancetuning/loadbalancing/capacityplanning/troubleshooting of servers including XIR2 through XI 4.0 SP2/SP4/FP.
- Expertise in Administrative activities of Business Intelligence tools such as Business Objects XI 4.0/XI 3.1/XIR2
- Strong knowledge on BI Client tools such as Dashboards 4.0 SP2,X-Celsius 2008, Live Office, Query Web Services, Rich Clients of DeskI and WebI, Business View Manager, Data Import and Data Migration Wizards..
- Expertise in installing different versions of Oracle on AIX, Solaris and setting up the databases for various environments such as Sand Box,development,Pre-Production & production.
- Having Very good experience in Crystal reports 2008, Dashboards(X-Celsius) 4.0,2008 SP2 and Live Office.
- Extensive experience in building Universes, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods and creating complex ad-hoc Reports using the Business Objects and Web Intelligence modules.
- Having a Very good experience of Creating Security Frame Work and Access Levels.
- Having a Very good experience in Data Migration from Lower Version to Higher Version in Business Objects.
- Coordinate with network administrators, analysts, developers, DBA's, etc. to resolve issues in supported applications.
- Creating primary database storage structures (table spaces) after application developers have designed an application.
- Coordination and communication of planned upgrades, enhancements and maintenance outage windows in collaboration with the infrastructure teams. This includes scheduling, coordination of testing and production readiness planning.
- Performance monitoring and tuning of the environments to ensure smooth operation, to identify and resolve manage performance issues and to drive best practices and maintain constant uptime.
- Import and export (refresh) of the databases from production to staging & development environments as per the application development needs.
- Excellent technical, logical, code debugging and problem solving capabilities.
- Very good understanding the Dimensional modeling with Star Schema and snowflake schemas.
- Assist and manage the design, prototyping, development, testing, and production support of multiple universes.
- Research documentation, forums, technical support, and other resources for best practices, tuning enhancements, technical issues/resolutions, etc.
Education:
- Bachelors in Computer Science & Engineering
Technical Skills:
BO ( Client & Server) Business Objects XI 4.0/XI3.1//XIR2 , Information design tool 4.0, Web Intelligence 4.0/3/1 , Dashboards 4.0,X-Celsius 2008, Live Office 4.0, Query Web Services, Upgrade Management Tool, Import Wizard.
Data modeling Tool Star Schema, Snowflakes Modeling, Erwin 4.0,
Database(s) ORACLE, Teradata, DB2, MS SQL Server 20005/8, SQL *Plus
Web servers Apache1.x/2.2.x
Application Servers Tomcat4.x/5.x/6.x,Weblogic6.x/8.x/9.x/10.x,IBM Web Sphere.
GUI/ Development Tools Designer and SQL Navigator, TOAD
Programming Languages C, C++, JAVA/J2EE, XML, PL/SQL, HTML
ETL Tools Data Stage (6.x, 7.x), Informatica,
Operating System UNIX (Solaris, AIX) Windows 95/98/2000/NT/XP,WIN2008
Management Tools: MS Project, MS Visio, Word, Excel, PowerPoint
Experience:
Confidential, Southborough, MA June'11 - Till date
Business Objects Developer / Admin 4.0
Confidential, a Financial Times Global 500, Fortune 500 and S & P 500 company, develops, delivers and supports information infrastructure hardware,software and Services EMC is headquartered in Hopkinton, MA.EMC IT Department is developing a Business Objects Business Intelligence 4.0 Project for EMC Business Users and Groups.
Roles & Responsibilities:
- Developed Twelve large Universes (UNX) Using Information Design Tool 4.0SP2 with Single & Multi Source data sources .
- Converted Universe (UNV) to Universe(UNX) using the IDT Tool 4.0 SP2
- Extensively worked with new designer tool IDT 4.0 using Projects/Shared Projects, Data Foundation, Business Layer and Security Profiles.
- Created Complex Webi Reports using new functionalities of Webi Intelligence 4.0
- Designed Webi Report based on BEX Queries & OLAP Cubes
- Created Security Groups, ACL, Users & Groups.
- Working Extensively with SAP Customer Support for the BO 4.0 Issues & Bugs
- Involved in Weekly Meetings with SAP to review the Users Issues, SAP Tickets & Product Bugs.
- Extensively worked and designed Dashboard Using QAAWS & with the Universe Query
- Installation of Business Objects XI 4.0 SP2 in all phases of environment i.e Sandbox, Development, Testing and Production.
- Installation of XI 4.0 SP2 Patches and upgrades to ensure the SAP Portal and Business Objects systems are up to date with latest bug fixes.
- Installation of Business Objects Client Tools XI 4.0 SP2 and corresponding Patches.
- Designed the Designed Dashboards with Drill Down and Multiple Components and gadgets.
- Involved in working with new XI 4.0 Tools ( BI Workspaces, Modules. Dashboard, Crystal Reports, BI Mobile, Explorer)
- Involved in Working with the Windows AD Team for SSO Setup for BO 4.0.
- Installed and Setup the BI Mobile 4.0 & Explorer.
Environment :
Business Objects XI 4.0 SP2/SP4, FP(1.x/2.x), BO 4.0 Client Tools, Information Design Tool 4.0, Webi Intelligence 4.0.Upgrade Management Tool,SQL Server 2008. Windows 2008, Red Hat Linux , Tomcat 6.x, Apache 2.x ,Mobile & Explorer 4.0,Dashboards 4.0 SP2.
Confidential, June'10 - June'11
Business Objects Developer/Admin
Confidential, is a US-based subsidiary of A. P. Moller Maersk Group which manages a fleet of US flag vessels and provides U.S. government agencies and their contractors with transportation and logistics services. Headquartered in Norfolk,VA. it manages the world\'s largest fleet of US-flag vessels. Beginning with a relatively small number of vessels focused on handling commercial and US Government-subsidised cargos, MLL\'s fleet of vessels engaged in commercial liner services.
Roles & Responsibilities:
- Prepared Business Requirement Document and then converted Business Requirements into Functional Requirements Specification.
- Wrote the Requirements and Functional Specification documents.
- Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to Make best improvements
- Interviewed business users to gather requirements and analyzed the feasibility of their Needs by coordinating with the project manager and technical lead.
- Actively Involved in Installation of Business Objects XI 3.1 SP3 and Life Cycle Management (LCM) in all phases of environment i.e Sandbox, Development, Pre-Production and Production.
- Actively Supported with Database Team, Application Team and Network Team for Installing SAP Business Objects Supported Components and Requirements.
- Preparing the project plan and system architecture design and implementation with complete documentation with reporting applications proposing recommendations to client.
- Implement patches and upgrades to ensure the SAP Portal and Business Objects systems are up to date with latest bug fixes and security patches.
- Coordination and communication of planned upgrades, enhancements and maintenance outage window in collaboration with the infrastructure teams. This includes scheduling, coordination of testing and production readiness planning.
- Configuring the server setting to communicate with client tools such as live office, X-Celsius and query web server.
- Performing troubleshooting amd tuning CMS and server tuning parameters for Business Objects XI R3 environments.
- Meetings and Communications with SAP Team every Bi-weekly on Issues and Upgrades.
- Co-ordinated and Supported with SAP Team for the Technical Integrity Check on BO XI 3.1 SP3 Infrastructure and Performance of the Current environment for End- User.
- Co-ordinated and Monitored with SPT Testing Team for Average Performance and Refresh Time of Reports in Pre-Production Environment
- Involved in data Migration from Business Objects XI R 2 SP3 to XI R 3.1 SP3 and 6.5 SP3 to XI R 3.1 SP3
- Involved in SQL Queries and report performance
- Testing the Performance of Reports in BO XI 3.1 SP3 after Migration
- Created a High Level Security Frame Work and Access Levels according to Client Specifications.
- Manage objects, reports, universes and database connections within Business Objects, Report Job Scheduling
- Auditing of the application usage of reports and security through the repository or auditing features
- Involved in Designing Universes.
- Designed and developed dashboards Xcelsius 2008 .
- Maintaining procedures and perform tests for Business Contingency Planning/Disaster Recovery.
Environment :
Business Objects 6.5,XI R2,XI R 3.1 SP3,CMS,CCM,INFOVIEW, BEA WEBLOGIC 10.X, Apache 2.X, Tomcat 6.x, Oracle 9i/11G, DB2 ,SQL,SQLServer,Solaris Sparc 10, IBM AIX, Windows Server 2003,LCM,Crystal reports 2008, Xcelsius 2008.
Confidential, Newark, NJ Aug 09 - May'10
Business Objects Administrator/developer
One of the largest health insurance companies in NJ had been utilizing Business Objects full client reporting tool extensively to increase customer satisfaction and sales. To give users easier access to critical information, dashboards were created using Dashboard Manager. Dashboard contained analytics and WebI reports that presented the key performance indicators to help users understand how efficiently company is performing in customer satisfaction and sales.
Responsibilities:
- Install and administer SAP Portal and Business Objects XI development, test and production environments.
- Support the following Business Intelligence components such as Crystal , WEBI , Designer , DESKI ,Import Wizard , Query Builder , Instance Manager , BO in cluster mode.
- Assist in development and implementation of Business Objects backup and recovery plans.
- Plan, Administer and Maintain Business Objects folder hierarchy and security.
- Perform troubleshooting / tuning CMS and server tuning parameters for Business Objects XI R2 / R3 environments.
- Performance monitoring and tuning of the environments to ensure smooth operation, to identify and resolve manage performance issues and to drive best practices and maintain constant uptime.
- Plan and test patches and new releases to all Business Intelligence tools
- Develop support procedures for Business Objects version XIR2 / XIR3 infrastructure
- Support the setup, implementation and integration of the Business Objects and Windows platforms.
- Preparing the project plan and system architecture design and implementation with complete documentation with reporting applications proposing recommendations to client.
- Support code deployments and migrate content between environments
- Manage objects, reports, universes and database connections within Business Objects, Report Job Scheduling
- Auditing of the application usage of reports and security through the repository or auditing features
- Configuring the server setting to communicate with client tools such as live office, X-Celsius and query web server.
- Installing and configuring the application servers, web servers for the same.
Environment:BOBJ6.5.1/XIR2/XI3.1, Business Objects Designer, Central Management Console, Infoview, Web Intelligence 6.5.1, Webi SDK, SQL, PL/SQL, Oracle 10g, Unix (Solaris 10 Sparc, Aix 5.3,) Windows XP,, Weblogic10, Tomcat/5.X, Apache2.X
Confidential, Dallas, TX Sep 07 - Jul 09
Business Objects Admin/developer
The Intelligent Data Design Implementation (IDDI) project will implement a new GBD Data (Group Benefit Division) to provide access to Case, Premium and Employer data. The project will be laying a framework for the way GBD develops and maintains its data warehouse going forward, and also provide the enabling processes and support structures needed to ensure the ongoing successful maintenance of a quality data warehouse.
Responsibilities:
- Install and administer SAP Portal and Business Objects XI development, test and production environments.
- Implement patches and upgrades to ensure the SAP Portal and Business Objects systems are up to date with latest bug fixes and security patches.
- Coordination and communication of planned upgrades, enhancements and maintenance outage windows in collaboration with the infrastructure teams. This includes scheduling, coordination of testing and production readiness planning.
- Performance monitoring and tuning of the environments to ensure smooth operation, to identify and resolve manage performance issues and to drive best practices and maintain constant uptime.
- Gathering report requirements from end users and designing Web Intelligence reports
- Assisting end users with writing reports and performing ad hoc queries.
- Defining and maintaining Business Objects Universes.
- Supporting and maintaining the Business Objects servers and application suite and Administering security settings
- Maintaining procedures and perform tests for Business Contingency Planning/Disaster Recovery.
- Document infrastructure deployments, support policies and procedures
- Provide 24 x 5 on site support and on-call support during weekends.
- Coordinate internal Business Objects support operations to distribute and assign internal support calls.
- Execute change management tickets on-time and correctly and follow-up on escalated issues.
- Documenting infrastructure architecture and define standards for installing and maintaining Business Objects
- Actively involved in gathering end user requirements, User/System Documentation, User training and testing developed reports for final deployment.
- Exported universes to the Repository to make resources available to the users.
- Used Instance manager and Infoview for creating Instances and scheduling documents as per user requirements.
- Responsible for migrating User, groups, connections from Business objects 6.5.1 to XI R2
- Responsible for Migrating the Business Objects Universes/Reports across the Servers/Repositories (Development to Production Servers).
Environment:Business Objects6.5.1/XI/XIR1/XIR2, Business Objects Designer, Central Management Console, Central Configuration Manager, Infoview, Web Intelligence 6.5.1, Webi SDK, SQL, PL/SQL, Oracle 10g, Windows 203/Windows XP,Weblogic9, Tomcat, Apache Web Server.
Confidential, Princeton, NJ Aug 05 - Sep 07
Business Objects Developer/Admin
Responsibilities:
- Involved in extensive designing and functional specifications of all modules of business objects.
- Installed Business Objects, Created repository, Created User groups, Users, Database Connections, Managed User Privileges, Import/export of universes in production environment.
- Involved in migration from Business Objects 6.1b to 6.5.1 and testing of reports on the new versions.
- Applied aggregrate awareness to speed up query time.
- Created plant cost and model cost trend reports involving multiple data providers.
- Created restrictions on Objects and classes based on universes privileges.
- Defined cardinalities, checked integrity, resolved loop by creating aliases and contexts to remove the cyclic dependencies.
- Created different types of reports, like Master/Detail, Cross Tab, Slice and Dice and Chart (for trend analysis). Used filters, conditions, calculations, Drill Down, @ Functions, etc.
- Extensively used breaks for white spaces and sections for better navigability.
- Created detail and summary reports used to Fold/Unfold sections corresponding to breaks in current blocks.
- Created prompts in report to restrict data fetch and ease data load.
- Extensively used Web Intelligence, InfoView, reporter and explorer for querying, reporting and analysis tasks.