PROFESSIONAL SUMMARY

• 8 years of experience in Information Technology industry with expertise in Administration and Developing Business Objects Enterprise 4.0/XI R3.1 /XI R2 Designer, CMC, Web Intelligence, Desktop Intelligence, Xcelsius, Scheduler, Import wizard, Report conversion tool
• Strong knowledge in all phases of Software Development Life Cycle SDLC such as Developing, Testing, Migrating, Administrating, Security Management and Production supporting.
• Extensive experience with Universe design, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL methods, Web Intelligence, Desktop Intelligence, creating ad-hoc reports and archiving reports along with performing User
• Experience in Installing Business Objects 4.0 Server, migration XI 3.1 to Business Objects 4.0 repository, Webi reports, users/groups, access rights, and converting Deski to Webi .
• Experience in Installation and Configuration of repositories and security domain with user groups and security implementation.
• Extensively involved with creating new reports and supporting the existing reporting system using Web Intelligence and Desktop Intelligence and Creating Sub reports.
• Expertise in creating XCelsius Dashboards by using Selectors, Filter Rows, According Menu, Check Boxes, List Builder, List view, Single Values, Maps, Charts, Dynamic Visibility, Alerts, Passing parameters.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Experience in multiple RDBMS Applications with Netezza 6, Oracle 11g, 10g, 9i, 8i , MS SQL Server 2008/2005/2000, MS Access and very efficient in tuning the SQL queries and using several tools utilities.
• Worked on SAP BO ADMIN CMC and CMS, Tomcat server configurations.
• Experience in generating complex queries by linking data from multiple data providers using free hand SQL, PL/SQL, Stored Procedures, Triggers, Functions, views and triggers using T-SQL Script.
• Good Knowledge of installation, configuration of MS SQL Server 2005, 2000 and 2008.
• Acted as a liaison between the business users, vendors and offshore teams.
• Provided 24X7 supports to the users.
• Unique ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts. A strong team member with good communication skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

SAP Business Intelligence Administrator

• University of Illinois is cutting edge for research and discovery which is top nations best University providing different courses to around 77,000 people a year. Champaign Campus has Data access center for Information technology.
• Upgradation Project From SAP BO 3.1 SP5 to SAP BO 4.1 SP4 on Clustered Environment
• Upgradation on three environments DEV, QA and Production.
• Installing the Business Objects 4.1 SP04 on the clustered server and setting up the environment.
• Installed SAP BO 4.1 on server and after checking Tomcat server health upgraded Repositories from SAP BO 3.1 to SAP BO 4.1.
• New SAP BO 4.1 CMC is configured for APS server and there sizing as per SAP Best Practices Guide.
• Upgraded the QA and Dev and using upgrade management tools and Tested all Access levels
• Tested all Permissions at Top Level, Folder level and application level.
• Preferences have been set default for all users at the Web intelligence Launchpad.
• Helped Users to download Rich client from Launchpad and explained new features on login page.
• Up gradation of Converted Unv universes to Unx universes.
• Converted Deski Reports to Webi repots using Report Conversion tool.
• Prepared Instruction Documents to use Promotion Management tool for Developers.
• Document all Upgradation and configuration Procedures.
• SIA and Tomcat servers turned off on SAP BO 3.1 environment so that no activity will be triggered.
• Worked on security of universes and folders at CMC level.
• Worked on users and groups for windows AD.
• Constantly Monitored SAP BO Server issues.

Environment: SAP Business Objects 4.1 SP4, 3.1, Universe Design Tool UDT , Upgradation management tool,

Lead SAP BO Developer/Admin

Confidential

• Created AD- HOC COBM Universe for the New application using SAP BO 4.0
• Used different prompts, filters to created single, multi or list of values as per requirement.
• Created Connection with DB2 to retrieve the tables.
• Created different classes, list of values and setting the parameters at universe level.
• Lead the offshore team like assigning the work and coordinating the tasks to meet the dead lines.
• Worked with Business users to understand and help them in understanding Ad-Hoc universe to create there Webi reports.
• Created Jobs in Promotion management to move from Dev to UAT and to PROD
• Scheduled the reports as per Business Need.
• Worked on Servers Health check like Adaptive server processing Sizing and checking servers health
• Worked on different display clean ups at CMC level by running SAP served clean up tools
• Worked on creating users and Groups and migrating authentications to all servers.

Environment: SAP Business Objects 4.0 SP8, DB2, Main Frames.

Confidential

SAP BO Admin Consultant

• Created universe using SAP BO 4.0 Information Design Tool/Universe Design Tool for different projects
• Converted unv universe to unx universes
• Created contexts and Aliases to resolve complex loops and traps in the universe
• Creation of connections, shortcut connections, contexts and aliases.
• Worked on creating Different filter conditions and compound reports as business requirements.
• Worked on different kind of manufacturing reports like calculation of TAT, material cost, and operation costs and KPI reports.
• Created prompts and derived tables to make universe and WebI reports to resolve complex report issues.
• Worked on Ranking, filters, conditions, Filters input services and web publisher.
• Worked on MySQL 5.1 database in creation of new tables to load the data into Datawarehouse.
• Created User groups and user id in the CMC
• Given access to users for particular folders by assigning advanced rights and hierarchy level user securities
• Worked on different KPI dashboards by using Xcelsius dashboard builder by using different radio buttons, charts, maps and dynamic visibility.
• Worked on QWAAS to publish reports on to web based link which is available to users in company web site called iteleplan.
• Used Promotion Management tool to migrate the universes and reports between different environments
• Upgraded the SAP BO 4.0 sp2 to SAP BO 4.1 SP6 by downloading and installing the new server
• Resolved various server issues by creating different Adaptive processing servers and sizing them by following SAP Best practices.
• Servers Maintenance after the upgrades at patch level and version level.
• Checking Tomcat and SIA servers and maintaining them.

Environment: SAP BO Information design tool, universe design tool, web intelligence,

SAP BO Data Services 4.1 Designer, SAP BO Management Console, SAP BO CMS, Data services Repository Manager, Data Services Version Management, MySQL 5.1, SQL Server.

Confidential

Sr. SAP BO Admin Consultant

• Installing the Business Objects 4.0 SP06 on the server and setting up the environment.
• Business Transformation project with a upgrade from Oracle R11i to R12.0.1
• Created a BIAR File of SAP BO 3.1 using Upgrade Management Tool to store current repository.
• On the Sandbox Server Installed SAP BO 4.0 SP6 and created ODBC Connections with the existing SQL Server2008.
• Used Upgrademanagent tool to test upgraded reports and universes in the New Environment.
• Before Installation of SAP BO 4.0 SP6 Ran Repository Diagnostic tool on SAP 3.1 server to check any inconsistencies before upgrade.
• Cleared all inconsistencies and stopped all servers except CMS, IRS and ORS on SAP BO 3.1 environment.
• Installed SAP BO 4.0 on actual server and after checking Tomcat server health upgraded Repositories from SAP BO 3.1 to SAP BO 4.0
• New SAP BO 4.0 CMC is configured for APS server and there sizing as per SAP Best Practices Guide.
• Up gradation of Converted Unv universes to Unx universes.
• SIA and Tomcat servers turned off on SAP BOO 3.1 environment so that no activity will be triggered.
• Worked on security of universes and folders at CMC level.
• Worked on users and groups for windows AD.
• Constantly Monitored SAP BO Server issues.
• Managed Business Objects Administrator responsibilities, creating user groups, access rights, assigning rights and folder access, automation of reports, broadcasting reports and publications.
• Worked on BODS Data cleansing for up gradation of BODS 4.1.
• Installation of BODS 4.1 and up gradation of repositories.
• Worked on Pre installation data backups and Post installation checkpoints
• Worked on Installation of Business objects in Three Clustered Environments for DEV, QA and PROD.

Environment: SAP Business Objects 4.0, 3.1, Universe Design Tool UDT , Lifecycle Management Tool LCM , Web Intelligence, Xcelsius, Data Services 4.0, Netezza 6, Oracle 11g, Toad for Data Analyst, Toad for Oracle, MS Access.

Confidential

SAP Business Objects Developer

• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements.
• Involved in documenting the changes to the universe and reports functionality.
• Designing, developing and deploying Universes using Universe Designer. Defined Objects and Classes in the Universe.
• Customized LOV's in universes for quicker performance of reports.
• Changed the universe parameter settings to optimize the performance of the universe.
• Linked the universes to share the common components between the universes.
• Created the reports using Business Objects functionalities like queries, functions, slice and dice, cross tab, drill down, formulae and master detail.
• Worked on analyzing the client Requirements.
• Worked on preparing the Dashboard specification Documents.
• Worked on conceptual design of the dashboard.
• Worked on Data connectivity to the data bases by using different methods like WSDLs, XML Buttons.
• Worked on performance tuning of the Dashboard.
• Worked on in Resolving the Data Connectivity Error.
• Developed Xcelsius dashboards for Profit, Sales, Revenue and Orders Analysis over weekly, monthly and yearly periods.
• Used OpenDoc functionality to drill down from Xcelsius dashboard to Webi Reports.
• Created and modified existing universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Extensively involved in creating database packages, procedures, functions, cursors and triggers using PL/SQL.
• Worked with Web Intelligence, Desktop Intelligence, Info View and CMC.
• Developed various conventional interactive reports for day-to-day operations and business controls using SAP Crystal Reports and Webi.
• Created contexts and aliases to resolve chasm and fan traps in universes.
• Provided end user support and problem resolution for various issues related to Business Objects.
• Optimize SQL queries for better performance.

Environment: SAP Crystal Reports XI, Business Objects XI r2/65, Web Intelligence, Xcelsius, Oracle SQL Developer, Oracle 10g, PL/SQL, Java, Business View Manager, Informatica 6.2

Confidential

SAP Business Objects Developer

• Development of the Advance Clinical Systems using webi Reports
• Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Developed complex reports that involved multiple data providers, cross tabs, bar charts, pie charts, complex variables and calculation contexts.
• Worked on Query Panel, prompts, report layout and Re-formatting.
• Worked on Xcelsius for interactive Dashboards for analysis of Monthly, Quarterly and Yearly data.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Involved in optimizing the universe developing time and SQL tuning to increase the query performance.
• Involved in creation of filters, prompts and setup hierarchies for Multidimensional Analysis.
• Involved in troubleshooting the visualizations for various problems faced during data connectivity.
• Applied sections, breaks, calculation, report filters and query filters and displayed the information in different blocks.
• Data validation has been done for various sources to target mappings.
• Design the technical documentation for Source to Target Mappings.
• Created Business Objects Repository while building Business Objects solution and Created and tested classes and objects to organize the Universe.
• Published and scheduled Business Objects Reports to users using broadcast agent to run the reports automatically.
• Performed Unit Testing, System Testing and Performance testing for each report
• Use HP Open View Service Center client 6.2 Tool for tracking/open Incidents, RM, RFCs and work on them on priority and timely delivery

Environment: Business Objects 3.1/XI R2, Web Intelligence, Xcelsius, Crystal Reports XI, T-SQL, SQL SERVER 2008, HP Open View Service Center 6.2, Informatica 7.1.

Confidential

BO Developer

• Design and Development of Business Objects Universes, which suits the standard, analytical and ad-hoc reporting requirements.
• Involved in documenting the changes to the universe and reports functionality.
• Creating Different kind of connections like local connections, secured connections, RDBMS connections and shortcut connections.
• Inserting tables into universe, setting data types for columns, inserting column filters, setting table keys.
• Setting cardinality and joins between tables.
• Creating contexts to resolve loops and creating alias tables.
• Designing, developing and deploying Universes using Universe Designer. Defined Objects and Classes in the Universe.
• Customized LOV's in universes for quicker performance of reports.
• Changed the universe parameter settings to optimize the performance of the universe.
• Linked the universes to share the common components between the universes.
• Created the reports using Business Objects functionalities like queries, functions, slice and dice, cross tab, drill down, formulae and master detail.
• Developed Xcelsius dashboards for Profit, Sales, Revenue and Orders Analysis over weekly, monthly and yearly periods.
• Used OpenDoc functionality to drill down from Xcelsius dashboard to Webi Reports.
• Created and modified existing universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Extensively involved in creating database packages, procedures, functions, cursors and triggers using PL/SQL.
• Worked with Web Intelligence, Desktop Intelligence, Info View and CMC.
• Developed various conventional interactive reports for day-to-day operations and business controls using SAP Crystal Reports and Webi.
• Created contexts and aliases to resolve chasm and fan traps in universes.
• Provided end user support and problem resolution for various issues related to Business Objects.

Environment: Business objects XI R2, Crystal Reports, SQL Server 2000, DB2, SQL, Remedy, Windows NT, Oracle 9i, MS OFFICE, Informatica, Toad, HTML, Apache Tomcat, ERWIN, PVCS, and Manual Testing

Confidential

Report Developer

• Created Different Complex Deski/Webi reports and universes.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart for trend analysis . Use of filters, conditions, calculations, etc.
• Creation of reports like, reports by product, reports by customer, reports by period and comparative reports.
• Created various features in the reports like sections, Breaks, Ranking data, answering prompts.
• Enhanced Reports by creating different variable for calculations using SQL.
• Created various static and ad-hoc reports using drill down/up, slice and dice, breaks, filters and alerts.
• Expertise in creating queries and reports using WebI and created prompts, BI services, linking, Drilldowns, Merging dimensions, Purging data, Data Tracking.
• Created Hyperlinks for the Webi reports, linking current reports to other documents in CMC.
• Worked with Multiple error handling issues on reports like multi value, SQL Syntax issues and handling them through checking granularity of data.
• Implemented security features of Business Objects like row level, object level and report level security.
• Remedy Ticket Support for Business Objects and Crystal reports for Production Environment.
• Written PL/SQL programs on Oracle Database. Performed performance tuning.
• Designed set analytics, Process Analytics Performance Analytics.
• Edited reports in interactive view format.
• Written PL/SQL stored procedures, functions, database triggers Packages.
• Scheduled crystal reports and Implemented dynamic cascading prompts.
• Installed and configuring Business Objects suite of Products.
• Designed Test cases for UAT of Reports for end users.
• Tuning of SQL queries for better performance.
• Written VBA Macros for certain business validations and data verifications.
• Scheduled reports to run and refresh daily using Broadcast Agent Server.

Environment: Teradata, Business Objects XIR2 Designer, Reports, , WEBI, DESKI Crystal Reports XIR2, Rapid SQL, Ervin.

Confidential

Programmer/Analyst Intern

• Extensively involved in Coding PL/SQL, Packages, Procedures, Functions and Database Objects according to Business rules.
• Extensively coded Forms, Reports using Developer.
• Performed tuning the application includes Packages, Procedures, Functions, Triggers and Database Objects
• Created Database Objects indexes to boost the performance of the Application.
• Extensively involved in coding of Triggers, Packages in the Application Level at each and every Transaction.
• Database Triggers, Cursors were used for the Data Validation at every Transaction level.

Environment: Oracle 7.x, SQL, PL/SQL, Developer/2000 Forms 4.5, Reports 2.5 , Sun Solaris, Windows NT