SUMMARY:

• Above 11+ years of experience in IT industry especially in client/server business systems and Decision support Systems (DSS) analysis, design, development, Testing and implementation.
• Extensive experience in various SAP Business Intelligence tools like Business Objects suite including Business Objects 4.0, 3.0/XIR2/XI/v 6.5.1/6.0/5.1.7, Supervisor, Designer, Web Intelligence, CMC, CCM, ZABO, InfoView, DeskI, WebI, Performance Management, Dashboards, Crystal Reports XI/v10/8, Crystal Xcelsius 2008/4.5
• Worked on SAP Business Objects 4.0, Crystal Reports 2011 and Xcelsius 2008.
• Extensive experience in loading high volume data, designing, tuning, and leveraging large data warehouses and tuning Business Objects at system level & Application level.
• Using Query as a Web Service tool, generated various WSDLs using the web services, and successfully tested them in the Crystal Xcelsius 2008 & Dashboard Manager tool to develop the Dash boards based on the Business requirement.
• Implanted Business Objects with Info view and Broadcast Agent Server.
• Migrated repositories, universes and reports from lower version to higher version.
• Applied hot fixes and patches to Business Objects Server.
• Comprehensive experience in gathering and analyzing the requirements from end - users and trained users in Business Objects for Ad-hoc reporting.
• Expertise in working with various operational sources like DB2, SQL Server 2005/2000, Oracle 10g/9i/8i, Teradata V2R6/V2R5, Sybase, Flat Files into a staging area and database development experience with TOAD, Aqua Data Studio 4.7, Erwin.
• Experience in Evolving Strategies and developing Architecture for building a Data warehouse by using data modeling tool Erwin.
• Excellent experience in Oracle 7.x/8i/9i/10g, PL/SQL, and SQL.
• Expertise in building queries on different types of data providers such as Universes, Personal data files, Stored Procedures, Free-hand SQL
• Hands on experience in writing, testing and implementation of the triggers, Procedures, functions at Database level using PL/SQL.
• Excellent Writing, Verbal, Analytical, Communication, and Interpersonal skills. Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS:

Reporting Tools: Business Objects XI 3.1/R2/R1//6.5.1/6.1b/5.x (Designer, Reporter, Supervisor), Crystal Enterprise XI /10/9/8.5/8, Crystal Reports, Desktop Intelligence, Web Intelligence/ Infoview 2.x / e-Portfolio, Live Office, Query as a Web Service (QaaWS), Import Wizard, Publishing Wizard, Report Conversion tool, Auditor, Xcelsius 2008/4.5, Planning XI R2/10.x, Metadata Manager, Data Quality, Enterprise Performance Management, BO SDK

ETL: Data Integrator 11.0, SQL-Server 2005, Informatica 6.0

RDB: MS Oracle 10g/9i/8i, Teradata V2R6/V2R5, MS SQL Server 2005/2000, DB2Internet:J2EE, XML, Java Beans, Servlets, JSP, ASP, VB Script, JavaScript

Language: C++, C, VB, Java2, PERL, Shell Scripting

OS: Sun Solaris UNIX, Windows NT/2000.

Servers: Web Logic Application Server 6.1 / 5.1, Web Sphere 4.0.2, TOMCAT 3.2.1

Tools: Erwin 4.1, TOAD and SQL Navigator

WORK EXPERIENCE:

Confidential

Sr. SAP Business Objects Admin

Responsibilities:

• Involved in requirements gathering, analysis, design, architecture and documentation
• Installed BI 4.0 and updated patches and upgrades
• BOBJ Administration, security groups, adding users and trouble shootings issues
• Created of users/user groups and user roles, scheduling jobs and alerts
• Migrated Universes, Reports, Dashboards from XI 3.1 to BI 4.X
• Resolved production issues which were related to Universe, Webi, Deski, Dashboards, Crystal Reports
• Scheduled & monitored reporting jobs and distributed the reports
• Rescheduled failed jobs and identified the root cause for jobs fail
• Resolved various server, configuration issues and performance issues
• Resolved couple of migration issues from XI3 to BI 4.0
• Migrated/Reverse migrated Universes, Webi, Deski, Dashboard reports from QA to Prod
• Resolved various user login issues with LDAP, Windows AD
• Configured Monitoring services and created Watch list on the servers to receive alerts/emails
• Extensively worked on performance tuning, sizing and maintain system stability
• Created/Resolved Universe connections, Universes issues and added new tables, classes and objects
• Worked on Dashboard/Xcelsius 2008 by using QAAS and Live Office connections
• Analyze and work with stakeholders to prioritize application defects/enhancement and participate in
• Performance tuning and maintenance of the BOBJ environment and presentation layer tool sets
• Extensively working on 24/7 production support and go-live activities
• Involved in Unit, Integration Testing, post migration testing

Confidential

Lead SAP Business Objects Admin

Responsibilities:

• Worked on Sizing and preparing plan for system requirements analyzing functional and reporting requirements and number of users.
• Installed and configured Business Object Enterprise XI 3.1 in clustered environments for development, Test and production including installation of BO Tools and Integration Kit. Creating Initial configurations in CMS and CCM.
• Installed the Integration Kit for SAP Business Objects environment to extract the data from different databases.
• Installation of IIS, ISAPI on Application Servers and Configuring the BOE Servers for Single Sign-On (SSO) as per Standards. Creation and Maintenance of User Groups in LDAP, mapping of LDAP groups in CMC.
• Business Objects Enterprise environment setup, server installations, implementation, upgrades, Configured Report Servers, testing.
• Deploying and configuration of Web Components on Web Sphere using deploy tool.
• Integrating Business Objects with LDAP for Authentication, implemented Single Sign-On (SSO)
• Maintenance, Support and Administration of Business Object XI R3 environment.
• Migrating the reporting structure - universes, reports, users and roles from Business objects 6.5 to XI R3 environment.
• Monitored unused logins (from when people don’t log out correctly), clear queue.
• Implementing and Configuring Business Objects Enterprise by Horizontal Scaling CMS, Processing and Application Servers (Clustered environment).
• Worked extensively on modules CMC, Designer, Web Intelligence, Auditor, Publisher and Info system to understand exceptional features users expecting with reporting system and also to successfully implement business logic. Created object level security in Designer for users.

ENVIRONMENT: SAP Business Objects XI R3.1 (Universe and Webi), Crystal Reports 2008, MS SQL 2005, Toad, Data Integrator, MS Access

Confidential

Lead SAP Business Objects Admin/Developer

Responsibilities:

• Installed & Configured Business Objects 3.1 on Windows server 2003
• Involved in Migration and upgrade of Business Objects Universes and reports from earlier versions to XIR3.1
• Involved in Trouble Shooting and resolving issues with in Business Objects Enterprise.
• Configured Business Objects Enterprise XI 3.1 InfoView with .NET and Active Directory authentication (including single sign-on using Kerberos in a Windows Server 2003 environment
• Configured the Authentication options in the Central Management Console
• Installation & Configuration of Crystal 2008 Enterprise Suite of Products.
• Defined the CMC Security Skeleton of the Business Objects Enterprise XI 3.1 right from theScratch.
• Created/Administered users/user groups/Security in Supervisor/CMC.
• Installed SAP Integration kits for Crystal Reports
• Delivered the Best Practices and Recommend settings documentation of Business Objects Enterprise XI 3.1 to the customer.
• Implemented Migration process for Business Objects XI R2 to XI 3.1
• Defined server statistics & load balancing test across enterprise environment.
• Implemented 3-Tier Business Objects with Cluster environment.
• Installed and set the Central Management Server, Processing Servers & Report Application Server.
• Actively involved in gathering Server Sizing requirements for software/hardware.
• Monitored / tuned Business Objects environment based on performance and usage levels
• Customized info view page and added new frame works. scheduling reports, and viewing report on demand with high performance
• Provided End user support and guidance to use reports

Environment: SAP Business Objects Enterprise XI 3.1/XI R2, XCelsius 2008, Designer, Web Intelligence, Import

Confidential

Sr. SAP Business Objects Admin

Responsibilities:

• Designed architecture & set up for development, production & test repositories.
• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Defined server statistics & load balancing test across enterprise environment.
• Instrumental in fitting the Business Objects Architecture into the System.
• Installed & Configured Business Objects on IBM AIX UNIX Platform.
• Maintained around 2000 users by creating user level securities and permissions.
• Implemented Best Practices for Using Business Objects Suite of Products.
• Installed & Configuration of Business Objects XI r2 with CMS on AIX Platform
• Actively involved in gathering server sizing requirements for software/hardware.
• Implemented Migration process for Business Objects 6.5.1 and Crystal reports 10/9 to XI r3, such as readiness assessment and deployment plan, Migration and system Upgrades, Co Existence Planning, Deployment services and delivery.
• Installed B0 Xi r2. EPM suite and configured repository.
• Installed and set the Central Management Server, Processing Servers & Report Application Server.
• Set up development, Test & Production environments and documented.

Environment: SAP Business Objects Enterprise XI 3.1/XI R2, XCelsius 2008, Designer, Web Intelligence, Import Wizard, Crystal Reports 2008, SQL, PL/SQL, Oracle 9i /10g, SQL Server 2005,XML, Java SDK,AIX, Windows XP

Confidential

Sr. SAP BO Admin

Responsibilities:

• Installed & Configuration of Business Objects 3.0 with CMS on IBM AIX 5.3 UNIX platform.
• Installation & Configuration of Crystal 2008 Enterprise Suite of Products.
• Defined the CMC Security Skeleton of the Business Objects Enterprise XI 3.1 right from the Scratch.
• Created/Administered users/user groups/Security in Supervisor/CMC.
• Delivered the Best Practices and Recommend settings documentation of Business Objects Enterprise XI 3.1 to the customer.
• Implemented Migration process for Business Objects XI R2 to XI 3.1
• Using Query As A Web Service tool, Generated various WSDLs using the web services, and successfully tested them in the Crystal XCelsius 2008 & Dashboard Manager tool to develop the Dash boards based on the Business requirement
• Worked on Business views and Universes to Business Objects XI R2
• Defined Business Views and business components with data connections.
• Defined server statistics & load balancing test across enterprise environment.
• Implemented 3-Tier Business Objects with Cluster environment.
• Installed and set the Central Management Server, Processing Servers & Report Application Server.
• Actively involved in gathering Server Sizing requirements for software/hardware.
• Facilitated meetings across Departments for implementing a standard Architecture for deploying Business Objects XI r2 across the entire Organization.
• Uses of Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias to remove cyclic dependencies.
• Created reports using WebI-Infoview including Alerts, Breaks, Sections, Filters and Drill Analysis.
• Monitored / tuned Business Objects environment based on performance and usage levels
• Troubleshooting complex client business intelligence issues in development, test and production environments
• Customized info view page and added new frame works.
• Migrated and customized a crystal report system via Java RAS SDK for managing report reports, scheduling reports, and viewing report on demand with high performance
• Provided End user support and guidance to use reports

Environment: SAP Business Objects Enterprise XI 3.1/XI R2, XCelsius 2008, Designer, Web Intelligence, Import Wizard, Crystal Reports 2008, SQL, PL/SQL, Oracle 9i /10g, SQL Server 2005,XML, Java SDK,AIX, Windows XP

Confidential

SAP BO Admin

Responsibilities:

• Created/Administered users/user groups/Security in Supervisor/CMC
• Migrated Objects from development to test to production environments.
• Implemented Publishing wizard & Import wizard for migration of reports.
• Implemented single sing-on & security layer with row level restrictions.
• Involved in documenting the changes to the universe and reports functionality.
• Implemented insightful and engaging Dashboards in Xcelsius
• Generated the Business Objects Reports using the universe as the main Data providers and writing the complex queries including Sub queries, Unions, and Intersect.
• Implemented web intelligence in distributed (clustered) Environment.
• Customized webi with Webi SDK and integrated with java portal.

Environment: Business Objects Enterprise XI R2/6.5, XCelsius 2008, Designer, Web Intelligence, Import Wizard, Crystal Reports 2008, SQL, PL/SQL, DB2,Oracle 9i /10g, Teradata V2R6,XML, Webi SDK,AIX

Confidential

BO Admin

Responsibilities:

• Installed & Configuration of Business Objects XIR2 with CMS on IBM AIX 5.3 UNIX platform.
• Involved in requirement gathering and data analysis for reporting from different business users for Forecasting Reports Phase 1.
• Involved in writing the High-level and Detail-level documentation of the project.
• Involved in deployment the reports to production and debugging of reports
• Installation & Configuration of BO XI R2 Enterprise Suite of Products.
• Installed & deployed Crystal Integration Pack.
• Installed Central Management Server, Processing Servers & Report Application Server.
• Implemented LDAP Security layer at OS level.
• Implemented Application Foundation and customized Web Intelligence
• Implemented Dash Board Manager & Performance Manager
• Designed Scorecards & Dash Board formats with Metrics, Rules & sets
• Developed and maintained Business Objects Universes
• Defined security filters to implement Row level and Colum level security.
• Customized info view page and added new frame works.
• Migrated and customized a crystal report system via Java RAS SDK for managing report reports, scheduling reports, and viewing report on demand with high performance

Environment: BOXIR2, Crystal Enterprise XIR2, Web Intelligence, Java SDK, DB2, Oracle 10g, SQL, PL/SQL, TOAD, Windows 2003, IIS 6.0

Confidential

Business Objects Developer/Admin

Responsibilities:

• Involved in installation of Business Objects Server components on Windows AIX servers, applied fixes/service packs and involved in tuning and monitoring the server performance.
• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Defined server statistics & load balancing test across enterprise environment.
• Implemented Import wizard & publisher for migrating reports & universes.
• Implemented single sing-on & security layer with row level restrictions.
• Developed Speedometers, Signal lights, map, chart, using crystal Xcelsius for forecasting the business performance.
• Exported the Business Objects reports to WebI to be viewed by all users on the Intranet using WebI SDK with JSP plug-in.
• Designed Universes & developed standard CAN reports & crystal reports.
• Linking the Universes to share common objects. Updating and maintaining Universes based on changing user requirements and data source changes.
• Exported the Universes to the Repository to make resources available to the users.
• Involved in designing, creating, enhancing and testing Universe, webi reports.
• Involved in creating Parameters and Record Selection Formulas to allow the users to filter the Data.
• Modify report content and export reports in multiple formats based on user input
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports.

Environment: Business Objects XI R2, Webi, Crystal Reports, Data Integrator XI R2, Oracle 10g, Java, JSP, HTML, TOAD, AIX Unix

Confidential

BO Reports Developer

Responsibilities:

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Created Business Objects Repository while building Business Objects solution
• Created and tested classes and objects to organize the universe.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Created the joins strategies while designing the universes.
• Changed the universe parameter settings to optimize the performance of universe.
• Worked on Business Objects Administration like CMC and CMS maintenance & security issues
• Exported the universes to the Repository to making resources available to the users.

Environment: Business Objects 6.5.0/5.1.7, WEBI, Designer, Supervisor, Broadcast Agent, ZABO, Oracle 8i/9i, PL/SQL, Windows NT

Confidential

BO Reports Developer

Responsibilities:

• Business Object Universe, Business Objects Reports and Business Objects repository has been extensively used, new universe were designed and developed to support the user Requirements.
• Installation, Configuration and management of all the components of Business objects
• Extensive Analysis has been done to Design the Universes and assigned them to respective domains.
• SQL queries and VBA scripts have been written to enhance the report performance.
• Created Multi-dimensional report using Business Objects. Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, @functions, Cross Tab, Master Detail and Formula’s etc
• Installed & Configuration of Business Objects on IBM AIX 3.3 UNIX platform.
• Data retrieval, Multidimensional analysis.
• Experience in developing reports that achieve strategic goals in user view.
• Exported the reports to Broadcast Agent Server for scheduling reports
• Schedule the publishing/printing reports Designed a no. of Reports for organization purpose (DSS) based on historical and online data.

Environment: Business Objects 5.1.7, Broadcast Agent, Web Intelligence 6.0, Info View, Oracle 8.1.7, SQL Server 2000, VBA, Windows 2000, Unix

Confidential

Oracle Developer

Responsibilities:

• Creating Users, Granting Roles, Privileges
• Controlling User Privileges and Roles
• Tuning application and writing efficient codes.
• Developing screens and report using Forms4.5/Reports2.5
• Designing and developing Packages and procedures in PL/SQL.
• User acceptance testing,, Database and application tuning

Environment: Oracle 8i, SQL, PL/SQL, Forms 4.5, and Reports 2.5, HTML