SUMMARY:

• Having 7 + Years of IT experience, professional experience as a software developer in designing and development and administrating of Data warehouse and Business Objects Reporting Applications.
• Experience in Business Objects(BOBJ) BI4.0,XI 3.x,XIR2, XI, 6.X, 5.X, Business Objects Designer, Reporter, Info View, Web - Intelligence (WEBI), Crystal Reports, Dashboard manager.
• Expertise in working with all the modules of Business Objects like Supervisor, Designer, Web Intelligence, Desktop Intelligence, CMC, CMS, BCA, BO SDK and Crystal Reports.
• Experience in building Universes, retrieving data using Universes and Personal Data Files, Stored Procedures and Free Hand SQL methods and creating Ad-Hoc reports using Business Objects & Web Intelligence Tools.
• Experience in Designing and Documenting Universe and Reports Requirements definition templates, Security strategies and Migration strategies
• Experience in installation, administration and upgrading versions of BO both Desktop and server products on Windows and UNIX.
• Experience in upgrade and migration of BOXIR3 to BI4.0
• Experience in Business Analysis, Reporting using Crystal Reports 2008, Business Objects Enterprise, MS Access, Oracle, SQL, PL/SQL, MS SQL Server2000/2005, DB2, and Teradata.
• Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Experience in migrating Business objects XI R2 to XIR3.
• Proficient at designing, implementing and distributing Business Object universes. Personal data files, Free hand SQL methods and creating complex ad-hoc Reports.
• Extensive follow up with business objects Admin team on different migrations to different Environments like DEV/UAT/PROD.
• Experience in administration of Business Objects and Dataware house
• Experienced in & Supporting end-user reporting needs using BO.
• Good experience in extraction, transformation and loading (ETL)process using Informatica.
• Working experience in transforming data from various data sources to a Data warehouse using Informatica as the ETL tool and interacting with the Business Analysts in identifying the needs and the requirements of the system.
• Strong exposure to Software Project Development full life cycle(SDLC).

TECHNICAL SKILLS:

• Business Objects Suite BI4.0/XIR3/XIR2,6.x, Designer, DesktopIntelligence, Web Intelligence, Infoview, CMC, Crystal Reports, Dashboard manager, XCelsius Report Conversion Tool.
• Informatica 6.0/ 7.x/ 8.0/ 8.6
• ERWin 4.0, Toad, SQL Assistance
• SQL/SQL*Plus
• Windows 2000, 2003, 2008
• Windows XP, Unix, Solaris
• Oracle 7i, 8, 9i, 10g
• SQL Server, DB2, Teradata

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr.Business Objects Administrator

Responsibilities:

• Partnered with software and architectural teams to plan and build out new systems, understand scalability and constraints of software, and manage disaster recovery and business continuity planning.
• Acting as systems/software engineer for system architecture planning, technical design, software development and test, and software, hardware, and interface integration
• Worked with Developers to consolidate the BusinessObjectsXIR3 repository before migrating toBI4.0.
• Worked with DBAs to create new databases for our new environment.
• Worked with server team to provide them with list of specifications need to build the servers.
• Installed and tested the BI4.0 application on sandbox before moving to live systems and resolved issues accordingly.
• Installed configured the BI4.0 in clustered environment and done sizing according to SAP standards.
• Configured the Windows AD and Single Sign on(SSO) for new environment.
• Worked on customizations of BI Launchpad page.
• Helped the developers in report conversion from Deski to Webi.
• Co-ordinated with SAP support team to resolve issues after upgrade.
• Installed and Configured Crystal Reports2011, SAP Business Objects Explorer.
• Experience in working with APOS tools in XIR3 environment.
• Extensively worked with security issues and user maintenance in BOXiR3 and BI4.0 environments.
• Created operational reports from audit database to support the application.
• Installed and Configured Dashboard Designer(Xcelsius)
• Migrated the XIR3 repository to BI4.0 environment using Upgrade management tool and resolved many issues while/after migration.
• Experience with Life Cycle Manger(LCM) in promoting the content between Dev/QA/Prod environments.
• Redesigned the security in new BI4.0 environment.
• Resolving day to day issues that come through tickets.

Technology Used: Business Objects (BOBJ) BI4.0, XIR3, Crystal Reports, Dashboard manager, Web Intelligence XIR3, Xcelsius, Explorer, APOS, Oracle 9i, MS SQL Server, SQL Navigator. Windows 2008.

Confidential, Franklin, TN

Sr.Business Objects Administrator

Responsibilities:

• Expertise in Resolving the Daily issues in the Daily doc Production Environment.
• BOBJ Upgrade from XIR2 to XIR3 and also responsible for applying service pack and fix pack to BO installation.
• Extensively worked on cluster configuration of BO servers.
• Involved in migration from Business Objects XIR2 to XI R3 and deployed WAR files.
• Migrated the crystal reports 8.5 to crystal reports10.
• Created 25 different accounts using the Central Management Console and assigned the access rights based on their profile.
• Set the Row Level Restrictions to the 25 different departmental accounts based on their profile.
• Set the User Access rights (Control & permissions) using the Central Management Console.
• Developed Universes in XI R3 and set up row level security for different groups in Designer.
• Used the Report Conversion Tool to convert Deski Reports to Webi on the BO XI R3 platform.
• Created reports using Desktop Intelligence and Web Intelligence in BO XIR3 environment.
• Evaluated the possible use of aggregated tables and worked with DBA to create aggregated tables.
• Involved in the troubleshooting of universe schema with loops, chasm and fan traps, and cardinality problems.
• Implemented Java SDKs and customized the info view logon page.
• Administrating and resolving the issues of tomcat server.
• Implemented and configured Single sign on Tomcat.
• Tested business objects reports for data validation and compared results with TOAD.
• Implemented Java SDK and Java scripts in order to monitor the performance of BO enterprise.
• Tuning the repository for its better performance.
• Experience in writing Complex SQL and Database Tuning.
• Worked on VMware and resolved issues related to server performance.
• Resolving day to day tickets that comes through service desk related to Business Objects.

Technology Used: Business Objects (BOBJ) XI R2/XIR3, Performance Management, Dashboard manager, Web Intelligence XIR3, Xcelsius, Oracle 9i,MS SQL Server, SQL Navigator. Windows 2008.

Confidential, Jersey City, NJ

Sr.Business Objects Administrator

Responsibilities:

• Gathered business requirements from the users and prepared functional and technical design Documents.
• Created Repository with multiple universe and document domains for Development and Test Environment and distributed the BO Main key among the enterprise.
• Extensively worked with servers and server configurations and on distributed servers.
• Designed universes by retrieving data from database, defining the necessary connections and exported them to specific universe domains.
• Created repository and security domain with user groups and security implementation.
• Extensively worked with security issues and user maintenance in BO 6.5 and XI/XIR2.
• Responsible for self debugging of the errors encountered in Deski, Web Intelligence (Webi).
• Extensively created distributed servers to increase the performance and reduce the burden on servers.
• Synchronized reports using multiple data providers using Business Objects.
• Scheduling and publishing reports onto WEBI.
• Tuning the reports for its better performance.
• Migrated the users, reports and universes from the Development to Production environment.
• Involved in the Single Sign-On (SSO) application team for the Operations Updates project and used the BO SDK to accomplish this task.
• Developed a Content Management Plan which shows the level of access that can be assigned to the groups and users
• Worked on stored procedures and implemented them in Deski.
• Worked with installations and up gradations in the versions with in the project.
• Configured web logic server to BO while installation.
• Row level security is implemented in the supervisor to restrict the data to the respective divisions.
• Designed Dimensional data model and developed universe on this.

Technology Used: Business Objects 6.5/ XIR2, Web Intelligence, Desktop Intelligence, Crystal reports2008, Oracle, MS SQL server 2005,Teradata, Windows 2003,solaris.

Confidential, Boyertown, PA

Business Objects Administrator

Responsibilities:

• Involved in requirements gathering from the business users to build the reporting application by working closely with architects and business analysts to understand system and business requirements.
• Created reports using free-hand SQL, Stored Procedure, PL/SQL, Universe
• Created Custom Drill Hierarchies in the universe for doing multidimensional analysis.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail
• Configured Publisher with BCA and to test the implementation on Development and Test environments and map the same to the existing production environment.
• Generating and scheduling standard and Ad-hoc reports using BO and Crystal Reports
• Migrated reports from business objects 6.5 to business objects XIR2 and fixed the issues during the migration and after migration.
• Exported the Universes to the Central Management Server and fixed the errors caused during the export.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to a vast user base comprising of users located all over the world for viewing, creating and publishing reports and implement Row and object level restrictions.
• Worked with the Publisher, Broadcast Agent, Scheduler, and server groups.
• Upgraded and migrated various BOBJ versions(6.5.1/XIR2) and server components.(Apache and Tomcat).
• Involved design user interface screen and passing multiple parameter values to the crystal reports and displayed the reports in crystal reports based on environment.
• Provided the technical support to the Production Team and fixed the errors while transferring the universe and reports from the New Development Server to the Production Server.
• Providing user support and in using Report Designer for creating Adhoc reports
• Involved in ETL process using Informatica for moving data from different sources to target database.
• Extraction, Transformation and Loading of the data warehouse using informatica power center 7.1.1.

Technology Used: Business Objects 6.5/XIR2, Web Intelligence 6.X, BCA 6.5, Crystal reports, OracleWin2003 Server, Unix, Informatica.

Confidential, Chicago, IL

Business Objects Consultant

Responsibilities:

• Interacted with functional experts to gather the requirements for on going modifications of the system.
• Designed Universes, incorporating all the business requirements.
• Worked with the Data Modeler for enhancing the design for ease of reporting.
• Worked with ETL team for setting up the event based trigger to write to BO server and scheduled reports based on the flag.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Created Contexts and Aliases for resolving Loops and checked the Integrity of the universes.
• Worked on SQL Tuning and optimization of the reports.
• Reports were formatted to the users according to the user requirements using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions and Formulas
• Proposed due to aggregate table for faster performance and used aggregate aware function to query between base and aggregate tables.
• Created reports using dashboard manager
• Perform an initial study of the current reporting application, to finalize the data elements required for reporting.
• Installed and Configured BO Software on client machines and created User groups and users for PROD, DEV and TEST environments.
• Installed & configured three environments (Dev/QA/Prod) with Business Objects XI /6.5.2 with Apache and Tomcat. as web and app servers on windows servers
• Administer and supervise the BO environment by monitoring/granting permissions and rights to a vast user base comprising of users, creating and publishing reports and implement Row and object level restrictions.
• Row level security is implemented in the supervisor to restrict the data to the respective divisions.
• Worked with the Publisher, Broadcast Agent, Scheduler, and server groups.
• Used supervisor module for disabling / enabling access to documents and access to universes.
• Strong technical, communication, time management and interpersonal skills.

Technology Used: MS SQL Server 2005/2000, Business Objects 6.5/XI,Windows XP, WebI 6.5,Desktop Intelligence, Broadcast Agent, Informatica Power Center 7,Oracle 10g/9i