Sr.SAP Business Objects Consultant

Business Objects administrator/architect with over 8 years of extensive experience in analysis, design, development, testing and architecture analysis of data warehouse and data mart systems; including installing, configuring, administering and supporting BusinessObjects Enterprise suite in high performance business systems. Proficient in an assortment of technologies, including VBA, Java, C#, Oracle 9i/10g, Weblogic application server, Tomcat application server, Apache Web Server, IIS, UML, Windows and Unix.

Technical skills include:

Business Objects: Client Tools, CMC, CCM, Infoview, Xcelsius, Crystal Reports Designer ETL Tools: Data Services, Infomatica power center Database: Oracle 9i/10g, SQL Server 2000, Teradata, IBM DB2, MS Access, Informix Application Server: Weblogic 9.x/10.x, Tomcat 5.x/6.x Web Server: Apache, IIS Programming Language: VBA, C, Java, C#, PL/SQL, HTML, XML Operating System: UNIX, Windows

Experience

Confidential, Austin, TX Sr. SAP Business Objects Architect May/2010 - Present Administer Business Objects Infrastructure including support for diverse internal clients. Enhance system performance through load balancing, performance tuning, capacity monitoring, Plan backup & recovery procedures, handle performance tuning and conduct regular system checks. Ensure technical and functional designs meet business requirements. Duties: Design & Construction:

• Design & Implement systems that meet the information delivery needs of business intelligence systems; perform technical and advisory functions in the development of business objects architecture and the creation of frameworks for reporting, dashboards, delivery, scheduling and object retention policies for complex information systems
• Work with the business management to ensure business objects are appropriately utilized for all required management and adhoc reporting, as well as data extracts for shared data agreements.
• Install, Configure and Support a federated high available & fault tolerant BusinessObjects XI3.1SP3 clustered infrastructures deployed on Windows 2008R2 & Solaris Spark 10 64 bit VMWares.
• Install and configure Apache webserver and Tomcat web application server that supports high available/fault tolerant Infoview and highly available CMC web applications.
• Work with Network Team to load balance and ensure high avaialabitly of BOE web applications by configuring DNS and Cisco content services switch.
• Oversee the Maintenance of BusinessObjects Enterprise & coordinate the continued development and enhancement of BusinessObjects Universes and upgrade of all BOE deployments from BOXI3.1 SP3 to BOXI3.1 SP5 with data warehouse managers/owners.
• Configure BusinessObjects File Repository Servers to connect to SAN
• Work with SAP engineers to troubleshoot product defects effectively and request hot fixes for critical product bugs.
• Provide highly advanced technical consultation to other information technology professionals concerning information delivery systems.
• Install, configure and manage BI4.0 parallel sandbox environment for regression testing.
• Attended most SAP presentations and internal trainings held during BI4.0 road map and rampup custom releases.

Configurations: Configure BusinessObjects XI Infoview web application and other BO Client tools for Single Sign On using Windows AD with Kerberos based Authentication:

• Create a Service Principal name using setspn command on Windows Domain Controller
• Create the configuration files(krb5.ini and bscLogin.conf) for Java authentication & authorization service.
• Set Java Web Application Server's java options to include the krb5 and auth modules
• Work with AD administrator to create service account and set it to trust for delegation
• Change windows local security policy of service account to act as part of operating system
• User service account to run business objects servers.
• Enable windowsAD plug-in in cmc.
• Ensure BusinessObjects Enterprise content security by creating custom access levels BO_DEVELOPER, BO_SUPER_USER & BO_BASIC_USER for Developer, Super User and Basic User roles in all dev, test, pre-prod and production environments.
• Assign top level security within cmc for developer group, super user group and basic user group using the custom access levels in all enterprise deployments.
• Configure single sign on functionality for opendoc to access reports and dashboards from third party applications.
• Configure destination job servers, report specific job servers & other job servers for SMTP, FTP, Business Objects Inbox and Unmanaged disk destinations.
• Configure server parameters of all processing servers, cache servers, i/o FRS servers & other BOE servers.
• Configure web services parameters for Qaaws using dswsbobje.
• Create server groups and add instances of processing servers as required to handle the load efficiently.
• Enable auditing features on each of the business objects servers in production to analyze or track the usage of reports and other actions.

Operations:

• Migrate BusinessObjects content from legacy Business Objects 6.5/Business Objects XIR2 systems using Import Wizard.
• Promote content from development to test to pre-production to production environments using life cycle manager and import wizard after testing and user signoff.
• Design and coordinate or build universes, classes and objects; Create cardinalities, contexts, joins and aliases.
• Setup row level or column level security on universe to restrict data access to certain users or user groups.
• Optimize web intelligence report performance on OLAP databases with Query Stripping enabled at query properties or document properties level.
• Create and maintain server backup routines and schedules by conferring with DBA's and system administrators.
• Review vendor patches and make recommendations; upgrade Business Objects Server deployments and Client tools by applying service pack or fix packs.
• Establish SLA's & adhere to the change management, incident management and problem management policies of the organization.
• Provide technical support, guidance and documentation to end users; provide immediate fixes remotely on critical issues.
• Managed over 4000 users and 50 enterprise user groups.
• Extensive use of the following Business objects applications:
• InfoView; CMC; CCM; Web intelligence; Desktop intelligence; Crystal reports; Business view manager; Universe designer; Import wizard; Publishing wizard; Query As a Web Service; Report Conversion tool; Xcelsius; Live office.
• Provide 24*7 on call support on critical issues and ensure the environment is highly available and fault tolerant, Continuously monitor, fine tune and investigate recommendations to improve the performance.
• Support customer reporting applications built with the standard web intelligence portal as well as customer portals built with SDK (ASP and JSP).

Confidential, Plano, TX Sr. Business Objects Administrator August/2009 - May/2010 Design, Install, Configure & Maintain a Business ObjectsXI3.1 enterprise environment that caters to reporting needs of the Matter Management Warehouse Application which is the core of HP Legal department work and is used by all attorneys, most support staff and potentially outside counsel. Duties:

• Conducted and facilitated JAD sessions and brain storming sessions with key business user groups within legal department in emphasizing the scope of the Matter Management Reporting Project in order to provide key initiatives in working with users in identifying and defining the project and system requirements.
• Involved in the Matter Management Data warehouse implementation to meet business/reporting needs and performed gap analysis between OfficeCheck and eCaseTrack legacy systems, data mapping, data validation and was involved in complete analysis of the data from the reporting perspective.
• Analyzed OfficeCheck crystal reports and the sql queries behind these reports by looking at the database expert and prepared requirement documents as specifications for mapping those fields into MMS data warehouse, New MMS universe development.
• Identified data sources and created data requirements, interface specifications and data mappings.
• Created database field level mapping document between OfficeCheck to TeamConnect(Matter Management Database) to Matter Management warehouse.
• Designed the security architecture and implemented it.
• Handled ETL jobs to load data into data warehouse.
• Publishing reports and monitor nightly schedules and ensure the scheduled report jobs are successful.
• Implement Single sign on to Business Objects using LDAP security plugin.
• Worked closely with the java application team to integrate & deploy custom java web applications developed thru Java SDK's.
• Used conditional formatting to pop up alerts messages and restrict particular information to be shown in specific reports.
• Implemented the single sign on with the MMS portal.
• Implement patches and upgrades to ensure business objects systems are up to the date with latest bug fixes and patches.
• Coordination and communication of planned upgrades, enhancements and maintenance outage windows in collaboration with other infrastructure teams including scheduling, coordination of testing and production readiness planning.
• Configuration of Business Object processing, job, destination server parameters and performance tuning to achieve a reliable system.
• Implemented Clustering to increase system availability and distribute work load along with increasing system performance.
• Performance monitoring and tuning of the environments to ensure smooth operation; Identify and resolve major performance issues and to drive best practices and maintain constant uptime.
• Assisting end users with reporting requirements gathering, designing and developing webi and deski reports along with resolving access related issues.
• Support and maintain Business Objects Servers and application suite along with administering security settings.
• Documentation of procedures, architecture and define standards for maintenance of the Business Objects portal.
• Export universe, reports and other contents to repository making it available to end users. Used Instance manager and infoview for creating instances and scheduling documents to destinations.
• Work with responsible team for configuring backup of the system repository and FRS.
• Responsible for migrating the Business Objects Universes/Reports across the servers/repositories.
• Creating new connections, access restrictions, check integrity, check cardinalities, resolve loop by adding aliases & contexts, speedup query time by applying aggregate awareness within designer.
• Change connection of free hand sql reports based on stored procedures after promoting report across environments.

Confidential, Carlsbad, CA Business Objects Administration/Technical Lead December/2008 - June/2009

• Design and analysis of projects using Business Objects XIR3, consult with end users to determine reporting needs. Design and build adhoc reports using business objects.

Confidential, Los Angeles, CA Sr. Business Objects Developer February/2008 - November/2009

• Analysis, Design, Develop and unit test highly complex Business Object reports; Migrate reports from legacy 6.5 system to Business Objects XIR3.1 and perform regression testing.

Confidential, New Brunswick, NJ Sr. Business Objects Developer January/2007 - January/2008

• Conversion of Operational data into Enterprise Data Warehouse to allow decision support system to maintain higher hierarchy, build business intelligence reports for business users to analyze the business; Enterprise data warehouse architecture consisted of staging data store, operational data store and data warehouse against business objects and crystal reports.

Confidential, Chicago, IL Sr. Business Analyst/Sr. Business Objects Developer September/2006 - December/2006

• Design and analysis of INSITE Management Information System which provides client and product profitability information, assets under management, net new money formation, Cost and revenue reporting ror management accounting purposes is designed to provide insight into key business perspectives such as clients and products to support decision-making.

Confidential, Woodbridge, NJ Business Objects Administrator June/2005 - August/2006

• Design, Develop and maintain the Business Objects environment in ICICI Prudential which helps the MIS analysts, Sales and Marketing teams to deal and transact with clients of Life Insurance, Group Policies, Investment etc. The operational data of different Insurance departments is loaded into a central Data warehouse and OLTP systems and farmed out to different regional data marts/Universe, the various corporate metrics/web reports & universes has been developed for different systems like agents management systems, employee claims management system(ORION), HR Department(PACE), application tracking system(ATS) & call tracking system(ATLAS) for call center.

Confidential, Houston, TX(Onsite/Offshore) Business Objects Developer September/2004 - May/2005

• Design and develop In-store as decision making system in HP Portal, The different reports present in the portal are In-store Dashboard reports, PAM reports and new account reports. The data set consists of country, retailer and entity level in EMEA region. The reports analyses the overall performance of sales, product distribution, shelf share, market share etc., of HP in EMEA.

Confidential Business Objects Developer April/2003 - Aug/2004

• The project is mainly developed for Investment and Sales departments of Barclay Warehouse System. The Warehouse involves investment and sales activity; data warehouse design is based on snow flake schema. The project involves development, testing and maintenance of universes, analyzing client requirement for new reports. Design and create business objects reports, support web intelligence server products and connectivity issues.

Education Bachelor of Engineering in Computer Science Actively participate in events and webinars organized by ASUG(Americas SAP User Group)