SUMMARY:

• More than 8 years of strong professional IT experience with OLTP, OLAP, Data Warehousing and Business Intelligence experience using Business Objects 4.0/XIR3.1/XIR2, Crystal Reports, Xcelsius 2008.
• Hands on experience in administration and upgrading versions of SAP Business Objects with both client and server products.
• Strong experience in Business Objects (4.0,XI 3.1, XIR2) Full Client, Supervisor, Designer, Reporter, Web Intelligence, Info View, Import Wizard, Central Management Console, Central Configuration Manager, Application Foundation/Performance Manager (Dashboards, KPI’s),Live Office, Query As A Web Service (QaaWS).
• Good Experience in Business Objects Installation, Creating Repository, adding Users and Groups, Assigning Password Security, Assigning Privileges to Documents and Universes.
• Designed, implemented and migrated complex Universes and Business Objects Reports, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Well versed with creating universe, reports using Business Objects applications on Oracle,DB2& Teradata universes.
• Extensively used Import Wizard in moving reports and universes from one environment to other environment.
• Used UMT tool to migrate/promote objects from XI 3.1 to 4.0
• Strong knowledge of complete SDLCE (Software Development Life Cycle Engineering) and software quality management.
• Very good understanding with SAP source systems as well as SAP BW.
• Hands On experience in Oracle 11g/10g/9i, MS SQL Server 2000/2005, Teradata, DB2.
• Good Communication and Interpersonal skills. Technically sound, Result - Oriented with strong Problem solving skills. Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SKILLS:

• Architectured and lead the development of a shared Linux based platform around Business Objects supporting 8000+ users across 7 business lines with many more in the pipeline.
• Complex security setup for different Lines Of businesses
• 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)
• Erwin (database design)
• SQL Advanced Queries SQL Server Analytical Services
• SQL Server, Oracle 11, DB2

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

BO Administrator

Responsibilities:

• Installed, Managed and configured the BO 4.1 SP6 Environment using the CMC and CCM utilities.
• Designed and implemented the security in 4.1 as per business requirements for 2700 users.
• Set up best practices for all Business Objects development and administration
• Setup the AD Authentication on Windows servers.
• Created Custom Access level as per business requirements.
• Set up all procedures relating to security, life cycle development, administration, content management, and instance management
• Single Sign on to SAP using SNC, Kerberos
• Extensively worked with Upgrade Management tool, promotion Management tools, version Management.
• Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and prepare specification documents for Business Objects universes and reports.
• Assist in reviewing and analyzing existing system structures to provide solutions to enhance and improve system.
• Coordinating with other teams to improve the quality of work.
• 24/7 BOBJ Reporting support.
• Involved in unit testing of the reports on verifying the correctness of report data with the data from the back end.
• As per the Business requirement creating the reports to cater to Order, Orders History, Pending Orders at Tasks, Processes and Tasks subject areas of the application.
• Migrated universes/reports from Dev to Test and finally into Production environment after UAT(User Acceptance Testing)using Import Wizard & LCM.
• Provided the security access management by creating users/groups and folders.
• Extensively used LCM to migrate the reports from one environment to another environment.

Environment: Crystal Reports, BOBJ 4.1 SP6, CMC, Infoview/Launch pad, LCM, Oracle, Unix/Windows Server.

Confidential, Houston, TX

IT Development Analyst

Responsibilities:

• Installed, Managed and configured the BO 4.1 Environment using the CMC and CCM utilities.
• Designed and implemented the security in 4.1 as per business requirements for 3100 users.
• Set up best practices for all Business Objects development and administration
• Configured Windows AD and SAP BW SSO for Business Objects BI4.1
• Setup the AD Authentication on Windows servers.
• Created Custom Access level as per business requirements.
• Configured Web Intelligence Report Server, CMS Server, Webi Job servers, and additional servers to enhance performance
• Set up all procedures relating to security, life cycle development, administration, content management, and instance management
• Single Sign on to SAP using SNC, Kerberos
• Extensively worked with Upgrade Management tool, promotion Management tools, version Management.
• Gather, analyze and document business requirements, clarify business rules and data design requirements, functional requirements and prepare specification documents for Business Objects universes and reports.
• Created WebI reports, Crystal Reports based on user requirements.
• Assist in reviewing and analyzing existing system structures to provide solutions to enhance and improve system.
• Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
• Coordinating with other teams to improve the quality of work.
• 24/7 BOBJ Reporting support.
• Designed, developed, deployed and maintained Universes using Business Objects Designer tool(IDT).
• Created Aliases and Contexts for resolving Loops and Checked the Cardinality and Integrity of the Universe.
• Applied Row level and Object level securities to different groups to restrict the data.
• Created prompts in report to restrict data fetch and ease data load.
• Restricting the user access with help of Access Level privileges.
• Involved in unit testing of the reports on verifying the correctness of report data with the data from the back end.
• As per the Business requirement creating the reports to cater to Order, Orders History, Pending Orders at Tasks, Processes and Tasks subject areas of the application.
• Migrated universes/reports from Dev to Test and finally into Production environment after UAT(User Acceptance Testing)using Import Wizard & LCM.
• Provided the security access management by creating users/groups and folders.
• Analyze user needs and provide software solutions.
• Extensively used LCM to migrate the reports from one environment to another environment.

Environment: Crystal Reports, BOBJ 4.1, CMC, Infoview/Launch pad, LCM, Oracle, Unix/Windows Server.

Confidential, Rosemead, CA

Business Objects Developer

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing Reports.
• Involved in designing and Building of Universes, Classes and objects.
• Converted around 120 reports & 11 universes on top of Oracle, DB2& Teradata data sources.
• Migrates the objects from one environment to other environments.

Sr. Business Objects Admin/Production

Confidential

Responsibilities:

• Successfully performed different roles and responsibilities as: Business Objects Developer and Administrator.
• Installing the BO XI 3.1/4.1 on Windows Server
• Created the Cluster servers of 12 (2 Management & 10 Processing) in PROD
• LCM Installation & Version management
• Migration from BO 3.1 to 4.1
• 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
• Installing and configuring BI Mobile
• User security and maintenance of users (2 thousand users)
• Promoting the reports between the environments
• Installing the Service packs, Fix packs & On-demand fixes
• Implementing BOBJ Monitoring
• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing Reports.
• Installed and configured Business Objects XI 3.1 and Crystal reports 2008 on UNIX/Windows server and applied the latest Service Pack and Fix Pack.
• Upgraded the BOBJ XI 3.1 to BO 4.0 SP5 P6.
• Currently we are in the process of upgrading the BOBJ 4.0 SP5 P6 to 4.1 SP2 P1
• Deployment of web application servers Tomcat on UNIX Environment.
• Performed Server level settings to provide better performance to end users.
• Involved in designing and Building of Universes, Classes and objects.
• Resolved loops/Traps using Contexts and Aliases, Worked on Master and Component approach during the linking of universes.
• Performing regular Business Objects activities like taking environment Back-up’s, cleaning the temp files, removing log files to improve server performance.
• Continuously monitoring server usage, capacity and health of the production environment.
• Developed Unix Shell Scripts in order to run daily cycle reports.
• Scheduled and ran extraction, loading processes and monitored sessions using informatica work flow manager
• Created Web Intelligence reports/ Adhoc reports using Universe on top of SAP BW Data.
• Migrated universes/reports from Dev to Test and finally into Production environment after UAT(User Acceptance Testing)using Import Wizard & LCM.
• Worked with Multiple data providers including Personal Data files and Freehand SQL to create reports.
• Created dynamic LOV’s based on report requirements.
• Used Filters and Conditions to achieve report functionality.
• Oracle database Installation, Upgradation and Maintenance on UNIX Platform.
• Production Support activities and fixing the live data Issues.

Environment: Xcelsius 2008, Crystal Reports 2008, BOBJ 3.1,4.0,CMC,Infoview/Launch pad, Import wizard, LCM, Oracle, DB2, Teradata and Unix/Windows Server.

Confidential, Irvine, CA

Business Objects Admin/Analyst/Developer

Responsibilities:

• Interacted with functional/end users to gather requirements of core reporting system to understand exceptional features with reporting system and also to successfully implement business logic.
• Designed functional specification documents (FSD) based on requirement.
• Acted as a Liaison between End users and developers.
• Worked extensively on modules Central Management Console, Designer, Web Intelligence, Auditor, Publisher and Infoview.
• Responsible for defining the scope of the project, doing gap analysis and documenting them textually or within models.
• Migrated & upgraded Business Objects from XIR2 to XI 3.1.
• Designed universes using different database, defining the necessary connections and exported them to repository.
• Managed user profiles using Supervisor and Set object-level security and row level security restrictions, as per the client requirement.
• Designed and Documented Universe and Report Requirements Definition templates, Security strategies, Migration strategies and Report Distribution strategies for Crystal and full client environments.
• Created standard and Adhoc reports using Business Objects functionalities like Slice and Dice, Templates, Drill Down, @Functions, Cross Tab, Master Detail and Formula’s, Breaks and Custom Sorts in reporting.
• Developed Crystal Reports and launched them from user interfaces.
• Worked with Business Objects XIR2 and Crystal Enterprise for Scheduling, and deploying reports accordingly to run on daily/weekly/monthly basis.
• Responsible for creating the reports (On demand, Adhoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical, etc).
• Coordinated and resolved Data Quality issues for smooth migration to production/maintenance of Reports and Universes to different environment within the organization.
• Involved in Migration of Business Objects from 6.5 to XI R2.
• Extensively worked with security issues and user maintenance in Business Objects 6.5/XI/XIR2.
• Involved in creation of custom List of Values (LOVs) for better understanding of prompts by the end users and Created complex reports by linking data from multiple data providers from different Sources.

Environment: Business Objects 6.5/XIR2 (SP2/SP3/SP4), Crystal Reports XI, Performance Management, Live Office, Linux, Windows XP, SQL server2000/2005, Teradata V4,Oracle 10g.

Confidential, Irvine, CA

Business Objects Admin/Developer

Responsibilities:

• Designed a questionnaire that helps in requirements elicitation from end-users which helps in Universe and Reports Design.
• Coordinating with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications.
• Involved in different phrases of the project like analyzing requirements, planning, execution and maintenance.
• Worked with installing, administration in both desktop and server products of Business Objects XIR2 on UNIX environment.
• Troubleshooting Business Objects XIR3 installation and migration issues on UNIX Environment.
• Created users, groups and access rights using Central Management Console.
• Built classes and objects in universes using SQL Server 2005 database.
• Implemented complex new Universes, Linked with existing Universes from Data marts.
• Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert those in to user interfaces like excel files, PowerPoint representations for better understanding.
• Developed various Reports for Area wise, Regional, National, and Response Analysis using Crystal Reports/Business Objects XIR2.
• Extensively used report conversion tool for converting desktop reports to web intelligence reports.
• Business users to use Web Intelligence to create Adhoc reports as well as view existing published reports.
• Tested Business Objects full Client reports in the Business Objects XI R2/ Crystal XI/9 environment.
• Created, maintained and modified the business critical reports using the Desktop Intelligence.
• Developed thick/thin client canned reports using Business Objects and Web Intelligence.
• Scheduled and monitored reports using Broadcast Agent Server.
• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process.

Environment: Business Objects 6.5/XIR2, Crystal Reports 9, Sybase 11.1/12, Performance Management, Oracle 9I, UNIX, DB2, SQL and PL/SQL.