BACKGROUND

• Expert in SAP BusinessObjects 4.0/XI 3.1/XIR2 and has over 9 years experience in all products in the BusinessObjects suite of tools. He has expert knowledge in Web Intelligence, Crystal Reports, Designer, Administration, and Crystal Enterprise Architecture. He has extensive experience implementing Business Objects on top of SAP systems. He is an expert migration consultant as well. He has over 5 years of migration experience and have migrated tens of thousands of reports from Business Objects version 5.x, 6.5, XI R2, XI 3.1, 4.0.

SKILLS

BUSINESSOBJECTS ADMINISTRATION

• Architectured and lead the development of a shared Linux based platform around Business Objects supporting 30,000 users across 7 business lines with many more in the pipeline.
• Complex security setup for different Lines Of businesses
• Integration of Business Objects with Sharepoint, Custom Portals
• Trouble shooting different issues faced by Lines of business providing them the solution. Guiding LOBs to use right tools for their requirement.
• SAP BW Integration with BO XI3.1/XI R2
• Connectivity to the different Reporting Databases Oracle,Sybase,MySQL,DB2,MS SQL server
• LDAP, Windows AD, SAP Authentication Integration.

DATABASE

• Advanced PL/SQL cursors, procedures, packages, union queries
• Advanced Microsoft Access queries, all action queries, referential integrity, ODBC, pass through Queries, SQL Union, select statements , all macros, form development, report Development formatting, cross tab, all aspects of reporting
• VBA functions, advanced expressions
• Erwin database design
• SQL Advanced Queries
• SQL Server Analytical Services
• SAP BW Cube design
• SQL Server, Oracle 11, DB2

BUSINESSOBJECTS ARCHITECTURE

• Experience with administration of XI 3.1, BI 4.0, including Server Intelligence Agent SIA , Central Management Servers CMS , Central Control Management, RAS,INFS, All server Processes, server creation, User creation, etc
• Clustering of CMS services as well as load balancing of Web Servers
• Sizing the Platform as per Business Requirements.
• Guiding the business to use right set of tools configuring in BusinessObjects Environment.

SAP INTEGRATION

• Experience with installation of SAP Integration Kit in XI R2 and 3.1
• Experienced with connecting Crystal Reports, Xcelsius, and Web Intelligence to SAP
• Experience with BW, SAP XI, and most ERP systems as a data source
• Experience with connecting to SAP info objects, SAP queries, and hierarchies
• Integration with custom portals using BO SDK
• Experience setting up SAP authentication within Business Objects 3.1, BI 4.0

Work Experience

Confidential

SAP BusinessObjects Administrator/Architect

• SAP Business Objects 4.0 Upgrade/Migration and Pilot Dashboard
• The AmeriHealth Caritas Family of Companies is the nation's leader in health care solutions for the underserved. The company is among the largest organizations of Medicaid managed care plans. AmeriHealth Caritas's core products include full-risk HMOs, management contracts, administrative services, pharmacy benefit management, care management services, and behavioral health care management services.
• BI 4.0 Upgrade Project involves setting up new architecture for AmeriHealth with advanced BI tools. Implementing Mobile solutions, executive dashboards and Upgrading the old content. Defining the new process standards for Production rollouts.

Responsibilities:

• Created sizing document for the BI 4.0 Servers Web tiers as per the business needs
• Defining and implementing the Business Intelligence architecture to support multiple LOBs
• Scaling of environment for different phases
• Installing the BI 4.0 on Windows 2008 R2 Servers
• Explorer sizing and implementing with BO Architecture
• APS and BI services sizing
• BI Services configuration with custom settings through out the multiple environments.
• Implementation of AD Authentication User Security setup as per the Business needs
• SSO Authentication with Windows AD servers
• Providing Recommendations best practices for future platform growth
• Deploying BI 4.0 to Tomcat Server
• Best practices for BI 4.0 Platform maintenance.
• Creating Metrics, Probes with thresholds on Monitoring
• Developed scripts to Start Platform on sequential mode
• Standardizing the existing process model with best practices
• Implementation of End-to-End SingleSignOn SSO for every BI tool.
• SSO implementation for BI Explorer.
• Upgrading the old content from BO 3.1 to BI 4.0 with very minimal business impact
• Cluster Servers configurations for high availability systems
• Disaster Recovery DR servers implementations
• Documentation on different levels of Server tracing client tool tracing.
• Extensive experience in BO security
• Tuning the environment for performance and to avoid issues
• Implementing Mobile solutions with highly secured protocols
• Integration of BI tools with SharePoint and Internal Portals
• BO Integration into Bloomberg terminals
• Creating LCM jobs for promotions and content backups
• Trouble shooting the issues facing by developers with dashboards, Reports universes.
• Audit reports creation to track day to day activates
• Mobile Server configurations to support iPhone and iPad

Environment: SAP BusinessObjects BI 4.0 SP5, BI 4.0 Explorer, SAP Lumira Visual Intelligence , Oracle 11.2, Sybase 15,MS SQL Server 2008, LCM, UMT, Monitoring, Windows 2008 R2, Tomcat 6.0, BO XI 3.1,Crystal 2008/2011.

Confidential

SAP BusinessObjects Administrator/Architect

• BSC BI
• BSC BI is to provide reporting, dash boarding functionalities for Bloomberg financial needs. To implement reporting from SAP modules HR Core sales module BSX BI systems will be used. High-level dashboards for different level of users. Reports from different LOB to analyze, access and share critical information about the sales.

Responsibilities:

• Created sizing document for the BI 4.0 Servers Web tiers as per the business needs
• Scaling of environment for different phases
• Installing the BI 4.0 on Solaris Servers
• APS and BI services sizing
• BI Services configuration with custom settings through out the multiple environments.
• Implementation of SAP Authentication User Security setup as per the Business needs
• SSO Authentication with SAP Systems
• Providing Recommendations best practices for future platform growth
• Deploying BI 4.0 to SAP NetWeaver 7.2
• Best practices for BI 4.0 Platform maintenance.
• Implementing SAP BusinessObjects Document viewers to NetWeaver Portal.
• PAR file deployments to support BI Launchpad in NewWeaver Portal.
• Creating Metrics, Probes with thresholds on Monitoring
• Developed shell scripts to Start Platform on sequential mode
• Setting up BEx Connections with SAP SSO
• Documentation on different levels of Server tracing client tool tracing.
• Extensive experience in BO security
• Tuning the environment for performance and to avoid issues
• BO Integration into Bloomberg terminals
• Creating LCM jobs for promotions and content backups
• Trouble shooting the issues facing by developers with dashboards, Reports universes.
• Audit reports creation to track day to day activates

Environment: SAP BusinessObjects BI 4.0 SP4 FP03 , Oracle 11.2, LCM, Monitoring, SAP BW 7.01, Solaris 10, SAP NetWeaver 7.2.

Confidential

SAP BusinessObjects Administrator/Architect

• Commerce Shared Services eCSS
• The BNYM Enterprise Business Objects service is a shared service platform that provides LOB client applications with advanced, enterprise-class reporting and business intelligence capabilities. By using the BNYM Enterprise Business Objects platform services, LOB application teams can add highly-formatted and sophisticated reports, interactive reporting capabilities like drill-down and slice-and-dice , scheduling and delivery options, and dashboards, scorecards, or other analytical tools into their business applications. More importantly, these capabilities can be added quickly without the need to develop all the underlying capabilities from scratch reducing the time to market. In addition to out-of-the-box capabilities we also provide value added services such as integration with the BNYM software stack and a Business Objects Center of Excellence.

Responsibilities:

• Installing the BO XI 3.1/4.0 on Linux Servers
• Lead the development of a shared Linux based platform around Business Objects supporting 30,000 users across 7 business lines with many more in the pipeline.
• Created the Cluster servers of 12 2 Management 10 Processing in PROD
• LCM Installation Version management
• Migration from BO 3.1 to 4.0
• Created the best practices for migrating to BI4.0 for the large scale systems with minimal impact.
• Sizing of BI4.0 with required services.
• LDAP Integration
• User security and maintenance of users 35 thousand users
• Promoting the reports between the environments
• Migration from BO XI r2 to BO XI 3.1
• Installing the Service packs, Fix packs On-demand fixes
• Involved in the implementing of HP Openview to monitor the platforms
• Implemented Complex clustering of BO servers
• Extensive experience in BO security
• Server group creating for each set of User Groups
• Guiding users in case of issues. Providing 24X7 support.
• Security Setup LDAP Integration in BI 4.0
• Configuring the Metrics, Probes with new Monitor tool in BI 4.0
• Extensive experience Publications Schedules
• Assessed security and rewrote on Business Objects XI and configured to LDAP security.
• Exploring Installing the new version of Business Objects BI 4.0
• Creating the Audit Reports with respect to LOB group
• Controlled the security in each every component of Webi Crystal Reports
• Configuring Deploying the QAAWS Services.
• Promotion of the contents with best practices.
• Backing up platforms with best practices. Performing Disaster Recovery DR tests on BO platforms.
• Good experience with the Query builder
• Configured the Live office QAAWS for the Xcelsius dashboards
• Installing Sybase Oracle drivers on BO server for different Reporting DB requirements
• BI security for different lines of businesses
• LDAP SSL Integration
• On-site Offshore co ordination maintain the team of 6 members
• BI 4.0 Installation on Lab machines and Creating best practices for BO Migration Implementing them.
• Universe conversion from BO 3.1 to BI 4.0 .unv to .unx using Information Design Tool IDT

Environment: Business Objects Edge Series 3.1 SP5 ,BI 4.0, LCM, Oracle 10g,Sybase 15,MS SQL Server 2005/2008, Crystal Designer 2008,Import Wizard, UMT, Tomcat , Weblogic Server 10, Red Hat Linux 4.5/5.4.

Confidential

Sr. SAP BusinessObjects Administrator

• Biologics Enterprise Business Intelligence
• Biologics Analytics Reporting is a project to develop reports on Finance, Billing and AR cubes in SAP BW using Business Objects. Tracking day to day clients, customers and business activity. Delivering the reports to the end users located across the global. High level dashboards to monitor the performance by quarterly. Reports from different databases to analyze, access and share critical information about the sales.

Responsibilities:

• Analyzing the architecture of Enterprise Portfolio Management.
• Configure SAP integration kit to interface with SAP BW and BEX Queries
• Implemented SSO Single Sign-On for info view with windows AD Groups.
• Developed over 100 Webi reports and 8 universes
• Designing migration and upgrade plans to move from older releases of Business Objects to XIR3.1.
• Managed and configured the XI 3.1 Environment using the CMC and CCM utilities.
• Configured Voyager Workspace, Created and Developed the Cubes in SSAS.
• Implemented SSO for Voyager Workspace in BO Xi R3.1.
• Performed the following tasks as part of the BO XI 3.1 Migration effort:
• Individually installed and implemented a high-availability, fault-tolerant environment using internal CMS clustering capabilities in Business Objects XI 3.1. Installed and configured the Tomcat / Apache web server. Directed migration of Reports and Universes from
• 6.5.1 to XI 3.1 using the Import Utility and conversion of .Rep full client reports to WEBI reports in XI 3.1 using the Report conversion tool.
• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides
• Designed and implemented the security in XI 3.1 as per business requirements for 3100 users.
• Decided on tools used in specific projects including Performance manager, Xcelsius, Crystal reports, Web Intelligence
• Interfaced with Business Objects vendors on technology, support and licensing issues. In constant contact with the Business Objects account manager at Smith nephew
• Spearheaded the Business Objects 6.5 to XI 3.1 migration project on 12 servers. Designed and implemented the roadmap for migrating Business Objects the deployment from 6.5 to XI 3.1 and successfully implemented integration with SAP BW
• Managed and configured the XI 3.1 Environment using the CMC and CCM utilities.
• Set up best practices for all Business Objects development and administration
• Responsible to approve UAT of Business Objects deliverables
• Analyzed Business Objects implementation and gave performance recommendations
• Decided on tools used in specific projects including Performance manager, Xcelsius, Crystal reports, Web Intelligence
• Installed and configured Business Objects R3.1.
• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides
• Development of complex reports and Sub-Reports using Crystal Reports against SAP BW
• Created training plan using Knowledge Accelerator and classroom training
• Created lifecycle procedures using best practices Dev, UAT, Production
• Maintained Business Objects on 6 servers with multiple CMS, Webi Job and report servers
• Configured Web Intelligence Report Server, CMS Server, Webi Job servers, and additional servers to enhance performance
• Deployed Business Objects XI 3.1 on 5 64-bit servers configuring Oracle 10G.
• Assessed security and rewrote on Business Objects XI and configured to LDAP security.

Environment: Business Objects Edge Series 3.1 SP2 ,BO 5.0/XIR2/6.5, Oracle 10g, Crystal Designer 2008,Import Wizard, Tomcat , Window Server 2003/2008.

Confidential

Sr. SAP BusinessObjects Administrator

• GMM is developed with the vision of streamline process with appropriate coordination among other client acceptance actives like DDAR Deloitte Radar Application , Conflict Check, Business Intelligence, Independence Team etc and enhanced communication to/from the recommending partners, other client acceptance functions, approvers and risk management. Workflow with notifications and alerts for processes within the system hand-offs to processes external to the system, Visibility of all DCA activities, Integration with R-track and DPS, Creation of big PDF files from within the Deloitte Client Acceptance Summary, Uploading of any form of documents from external systems.
• Firm policy requires completion of Form GEN201 aka Deloitte Client Acceptance prior to the acceptance of an accounting and auditing engagement for a prospective client. Today, it takes as long as several months to complete this form, causing delay in delivering Attest service. In addition, as Deloitte continue to enhance and modify our risk management programs, there is a business need to automate our client acceptance process.

Responsibilities:

• Migrated Crystal 10 platform to Business Objects XI
• Completed Business Objects sizing analysis for 580 users
• Installed Business Objects XI on 4 servers and configured servers for fault tolerance
• Configured web server to fix memory leakage issues
• Created backup procedures for the Business Objects environment
• Developed Crystal Reports on the Business Objects XI R3 environment
• Rewrote SDK on new environment
• Set up AD authentication
• Migrated all content to new platform
• Troubleshoot platform, Had issues with migrating Authentication
• Installed Business Objects Data Integrator and set up repository and job server
• Installed and configured 4 SAP rapid marts to achieve business intelligence from SAP ERP systems
• Used Multiple Data Providers like Universes, Free Hand SQL and Flat files
• Linked different data sources to display in a block for data comparisons
• Documented and created different Canned and Ad hoc reports for Delinquency Reports, Reports by Period, Demographic reports and other Comparative reports in Full Client and Web Intelligence
• Improved report response time by tuning BO queries.
• Created and Configured multiple Job servers and Webi Report severs
• Configured Multiple clusters on the Production and QA servers
• Developed and designed all reporting and dashboard needs for financial project
• Environment: Business Objects Edge Series 3.0 XI R3 , BO XI R2, Performance Manager, Dash Board Manager, XCELSIUS 2008, WEBI, DESKI,IIS 6.0,WACS, SQL Server 2005, Windows2003.

Confidential

Sr. Business Objects Administrator

• Cosentino is the wholly-owned US subsidiary of the UCB Group, one of the largest enterprises in Belgium, a leading global biopharmaceutical company dedicated to the research, development and commercialization of innovative pharmaceutical and biotechnology products

Responsibilities:

• Conducted user interviews and reviewed existing reporting / analytical solutions to understand the client's specific reporting needs.
• Preparing the Project Plan and update the status of the Project to the client with progress and Achievements.
• Motivating and inspiring the team members to complete the tasks.
• Documenting the Work and achievements of every Project team member for recognition and rewards.
• Responsible for leading the Business Intelligence team of 5 people.
• Performed the Migration from Business objects 6.5.2 to Business Objects XI R2 using the Import Wizard.
• Setup the Security at the Folder level and at the User level in the Central Management Console.
• Maintaining the Servers using Central Configuration Manager.
• Creating Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
• Designing Corporate Dashboards with automated rules and Dimensioned Analytics.
• Aggregate awareness to encompass the aggregate logic using summary tables.
• Converting all the Full Client Documents to the WEBI Documents during the Migration.
• Prepared user documentation for hands on training of end user community.

Environment: Business Objects XI R2/ 6.5.2, Performance Management XI R2 SQL Serer 2000/2005 Crystal Xcelsius v4.5, Windows 2003 Enterprise

Confidential

Sr. Business Objects Developer

• Confidential is an integrated web based ERP solution, which automates all the activities involved in the construction projects of the entire Enterprise. This tool deals with every aspect of the Life Cycle of Construction Process. It automates various operations like Planning Scheduling, Execution Control, Resource Management, Inventory Management, Quality Control, HR and Finance Management. The major Modules of this software package include Admin, Human Resources, Finance, Contracts, Planning, Projects, Asset, Stores, Purchase, Logistic, EOHS, Legal, Audit and Training modules. This software solution is especially helpful when multiple projects
• Need to be managed in different locations.

Responsibilities:

• Gathered business requirements from the users and prepared functional and technical design documents.
• Involved in requirement gathering from Business users, Responsible for understanding end user requirement and convert into functional requirement and involved in Designing reports using Business Objects XI/R2 WEBI.
• Involved in Designing Sales dash Board using Xcelsius and QASS
• Involved in doing the gap analysis by checking the Existing reports and Requirements based on BRD
• Involved in Writing the Project Scope Summary , Current Business Over view , Current Business Environment, Current business process, Proposed business overview and Proposed Business Process documents
• Created Master/Detail, Cross Tab and Chart templates using the Business Objects and Web Intelligence tools.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Involved in Designing AD Hoc reports and Canned Reports
• Responsible for facilitating the definition of the business requirements and business processes throughout the implementation
• Maintained and tested universes for supporting ad hoc queries and reports according to the business requirements.
• Evaluated the possible use of aggregate tables and worked with DBA team to create these tables
• Analyze all the data sources and develop requirements for data conversion.
• Created thin client reports using web intelligence Webi in order to view the reports from intranet.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users
• Involved in performance tuning of reports, unit testing and documenting the processes.
• Involved in scheduling the Atlantis reports and process them for Business users.
• Responsible for delivery of Business Objects Reports environment on time
• Identifying the risks and issues from team meetings and coordinating with Project manager.
• Responsible for end user training to work on reports.

Environment: Business Objects XI R2 Enterprise, WEBI, DESKI, Xcelsius 2008, QASS, Live Office, TOAD, VBA, Oracle 9i, ActiveX, Microsoft Visio, Access 2000, Windows XP

Confidential

Business objects Developer

• Vendor In is a network where trading partners come together to create, manage, and share vital information. Connect with customers and suppliers to form their own trading partner network. Companies can register they can share their complete information and they can invite their vendors and the can exchange their information through this site.

Responsibilities:

• Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts for creating Business Objects reports.
• Involved in requirement gathering from Business users, Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
• Designed, developed, maintained and tested universes for supporting ad hoc queries and reports according to the business requirements.
• Extensively used Designer, Business Objects Dash Board Manger and Desktop Intelligence .
• Find out aggregated objects and create summary tables to improve the query performance.
• Designed hierarchies in universe for various reports and created user objects with calculations in universe
• Extensively Used Dash Board Manager to develop KPI Dash Board Reports for the Entitlement Executives and managers.
• Extensively used Performance Manger to design Score cards and uploaded them on to the Entitlement internal website .
• Responsible for the Designing classes and objects by using the Business Object Designer
• Scheduled and monitored reports using Broadcast Agent BCA .
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Use Web Intelligence SDK to customized the Web Intelligence user interface to make more interactive and easy to you interface.
• Worked extensively with SQL Plus, TOAD for writing user defined queries, stored procedures, views, tables, Indexes and constraints
• Analyze all the data sources and develop requirements for data conversion.
• Supported DW team on analysis and providing of data for DW purposes. Experience in Creation of Aggregate, Expression, Filter, Join, Lookup and Rank

Environment: Business Objects XI R2 Enterprise, Dash Board Manager, Performance Manager , QASS,TOAD,VBA, SQL Server 2005,ActiveX, Microsoft Visio, Access 2000, Windows XP

Confidential

Business objects Developer

• Involved in Designing and developing a tool for the Endovascular Planning process that will collect data from multiple global sources and organize it in a manner that will enable the Global Supply Chain to prepare S OP documentation, standard reports for tracking day to day business operations, and dynamic queries to assist in making business decisions. Data generated by the application could be used to update product mix in QAD, as well as providing reporting for Marketing, Manufacturing, and R D.

Responsibilities:

• Involved in the collecting requirements, Interacted with prospective clients to gather their analytical requirements, which are very important to customer.
• Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
• Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.
• Involved in migrating Business Objects 6.1 version to 6.5
• Extensively used Designer, Dashboard Manager, Performance Manager and Desktop intelligence.
• Created Build Plan Dash Board reports Using Dash Board Manager
• Created sales Analytic, Revenue Fore Cast scorecards Using Performance Manager
• Find out aggregated objects and create summary tables to improve the query performance.
• Designed hierarchies in universe for various reports and created user objects with calculations in universe
• Responsible for the Designing classes and objects by using the Business Object Designer
• Scheduled and monitored reports using Broadcast Agent BCA .
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Developed Reports with Analytics Alerts.
• Use Web Intelligence SDK to customized the Web Intelligence user interface to make more interactive and easy to you interface.
• Used various data sources namely Oracle 9i/8i,Sqlserver
• Worked extensively with SQL Plus, TOAD for writing user defined queries, stored procedures, views, tables, Indexes and constraints
• Analyze all the data sources and develop requirements for data conversion.
• Designed and developed the workflows/sessions using Workflow Manager and Designed monitored the workflows using workflow monitor.

Environment: Business Objects 6.5, XCELSIUS 4.5,Oracle 9i,QAD,I2-DemandPlanner,SSIS,TOAD,VBA,ActiveX,Microsoft Visio, Access 2000,SqlServer 2000,TSQL Visual Source Safe 6.0,0,Windows XP.

Confidential

Involved in Requirement analysis, Design and development phase of the project. Involved in developing intranet Application for Data code request the business purpose of this application is to Request New data code, Request new description for an existing data code and request for Status rules update on existing data code. Users of freightliner and Engineering department use this application to modify and create data codes on IMS.

Responsibilities:

• The project involved development of library of reports using Business Objects BO to cater the Engineering ad-hoc reporting needs. It required extensive interaction with the users and the management in the collection of information for their reporting needs. Created the reports using BO functionalities such as drill down reporting, slice and dice, master-detail reporting, sorting etc.
• Involved in the design and development of Universes, Classes, Objects and Conditioned Objects for Business Analysis and Report Generation
• Used different functionalities of Universe such as Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Exported reports to the Broadcast Agent BCA and used BCA server to schedule, monitor and publish the reports
• Involved in BO Administration - authenticate users, provide privileges, and make resources available to users through repository
• Involved in creation of stored procedures and VBA procedures to retrieve the data faster and generate the reports quickly.
• Involved in writing TSQL Scripts
• Involved in training users in Business Objects
• Provided complete documentation and presentation at the end of the contract to help users in developing various reports using different functionalities and methods used in creation of reports.

Environment: Business Objects 5.1, Web Intelligence 2.5,Broadcast Agent, DB2,,SQL Server 2000,TSQL,IBM Web sphere, Web Logic Windows2000 and MS visual Interdev Win NT 4.0/2000.