PROFESSIONAL SUMMARY

• 9 Years of IT experience with strong background in various Business Intelligence tools like SAP Business Objects 6.5/XIR2/XIR3 and BI 4.1.
• Experience in Banking, Healthcare, Life insurance, Energy Retail domains
• Expertise in Business Objects BI 4.0/XI3/XIR2 - Administration, Designing and Development.
• Experience in SAP Business Objects XIR3/XIR2 Enterprise suite using Designer, Desktop Intelligence, Web Intelligence

reporting.

• Experience in creating reports with BI Launch Pad in SAP BI 4.1
• Extensively worked in SAP Business Objects XIR3/XIR2 Products like Desktop Intelligence, Web Intelligence, Designer, Import Wizard, LCM and CMC.
• Experience in SAP Business Objects XIR2,XIR3, BI4.1 User Administration
• Experience in Installation, Administration and Upgrading versions of Business Objects desktop and Server products.
• Experience in migrating Business Objects Reports and Universes from XIR2 to XI3.1, BI 4.0.
• Expertise in Server monitoring, maintenance and troubleshooting critical issues
• Expertise in SAP Business Objects XIR3/XIR2 scheduling activities for the reports.
• Expertise in creations various type of connections like oracle, sql, BICS connections
• Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Experience in all components of SAP BOXIR3.1 including RCT, QAAWS, LCM, Live Office.
• Experience in all kinds of projects like development, production support, migrations, Enhancement, administration.
• Develop a strong working relationship with the appropriate business users to understand the key business drivers and priorities.
• Have strong organizational, multi-tasking and time management skills to meet task deadlines
• Proficient in all phases of the Software development lifecycle, including requirements Definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Knowledge on SAP BW, Cognos, Xcelsius.
• Efficient in optimizing and writing SQL queries.
• Strong Knowledge in Data warehousing Concepts.
• Good Database knowledge in Oracle 9i.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Business Objects Dev/Admin

Responsibilities:

• Responsible for requirements gathering, analysis, design and documentation
• Worked on performance tuning and capacity management
• Good understanding on SAP BO architecture and capacity planning activities
• Worked on BODS ETL environment and industry best practices for Business Objects
• Business Objects administration and troubleshooting of Business Objects implementation in a shared environment
• Worked on nstallation, migration, configuration, maintenance, technical support ,Implement patches and other day-to-day
• Created Technical specification documents and UTP as the process standards.
• Done the data validation testing between BO and Bex Queries.
• Applied Alerters on reports in order to satisfy the conditions and for better visibility for the users.
• Created different types of variables as per as the report requirements.
• Developed the medium complex reports using Bex queries.
• Responsible for creating the reports On demand, Ad-hoc Reports, Summary Reports, Sub Reports, Cross-Tab using the features like sorting, Alerter, column hiding.
• Created WebI reports with multiple data providers and synchronized the data using Merge Dimensions.
• Created the Universe using UDT on top of BICS connections.
• Created hyperlinks Input controls for the better navigations to analyze the data in detail.
• Provide off-hours and weekend support in an on-call rotation 24x7
• Worked on coordination and planning of Business Objects related activities
• Work with IT and business users to resolve support and technical questions
• Done the performance tuning for the reports.
• Enabled Query Stripping for all the reports built on bex queries.

Environment: SAP BI/BW 7.4 on HANA, BODS 4.0, Crystal Reports,SAP BI 4.1, UDT, BI Launch Pad, Citrix Windows XP Professional.

Confidential

Role: Business Objects Developer Administrator

Responsibilities:

• Need to maintain around 200 servers up and running in all the time.
• Done the migrations from one environment to another environment.
• Responsible for creating the project step up, various universe connections, assigning security to each and every application of Business Objects.
• Some times need to educate the users for using applications.
• Responsible in accepting the tickets and to solve the issue in a specified interval of time.
• Need to raise SAP tickets if they are any unknown issues.
• Responsible to send the communication to the business users if there is any patching activity was going on BO or DB servers.
• Responsible to present the key information in power point presentations using live office for analyzing the SLA metrics of the business.
• Responsible to create the adhoc web intelligence reports as per as the user requirements.
• Extensively worked on 24/7 production support, go-live activities
• Installed XI3.1, and updated patches and upgrades
• Created of user and user roles, and scheduling jobs
• Worked on BOBJ Administration, security groups, users creation and trouble shootings
• Resolved connection issues which are created problem to access of Webi reports
• Scheduled monitored reporting jobs and distributed the reports.
• Did rerun failed jobs and identified the root cause for jobs fail
• Migrated Universes, Webi, Deski, Dashboard reports from DEV to Test to QA to Prod
• Resolved user login issues with Win AD, SAP authentication.
• Resolved various server issues and performance issues.
• Created Folders, User roles, Security and Privileges.

Environment: SAP BI 4.1, BO 3.1, BODS, Oracle 10,SQL Server 2005, SAP BW 7.2, Remedy Windows XP Professional.

Confidential

Role: Business Objects Developer

Responsibilities:

• Responsible for interacting with onsite project manager regarding the status of conversion of reports.
• objects to new objects, adding and removing the filters according to the client requirements.
• Done the changes on existing reports like replacing the old universe with the new universe, pointing the old
• Extensively used various techniques like Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alerters and sections to develop the WebI reports.
• Created Formulas to calculate the Percentages and Summaries based on the group levels.
• Implemented Row level security in the universe
• Maintained universes and troubleshooting of universe schema with Loops, Chasm and Fan traps, and Cardinality problems.
• Linked the Universes to share the common objects and filters.
• Designed Test cases on various reports for UAT.
• Done the validation testing between Reports Database
• Analysing the existing reports and developing the reports with new universes with proper objects, filters and
• Maintained the tracker which helps us to identity the status of reports and reports which has been done by each individual user.
• Analyzed new requirements, prepared functional requirements and project planning.
• Migrated the reports from XIR2 to XIR3.
• Trained Business Objects End users on BOE XI 3.1 New features and Web Intelligence Rich Client.
• Involved in Extraction, Transformation, Loading ETL processes using Informatica.
• Done the Monitoring on ETL Loads/ Batch Processes.

Environment: Business Objects Enterprise XI 3.1, BOXIR2, Sql Server 2000, Web Intelligence, Designer Rich Client, Import Wizard, Informatica Windows 2003 Server.

Confidential

Role: Business Objects Developer

Responsibilities:

• Analysing the crystal reports and developing in to webi reports.
• Created the various types of reports like form reports in order to analysis the full history of the each ticket.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerters.
• Created the graphs in webi reports in order to know the number of tickets logged and solved in specified periods.
• Done the performance tuning for the reports in order to run the reports faster.
• Developed complex reports by using sub queries, external data sources and variables.
• Highly experienced in creating Cascading prompts by understanding the reporting requirements.
• Extensively used Business Objects functionality such as Slice and Dice, Drill Down, Master/detail, Prompts and Formulas, Calculations, Variables, Breaks, Sorting and Alerts for creating Business Objects reports.
• Performed Data Verification Testing by writing SQL statements on SQL front end tool to check the accuracy of the report.
• Created different types of reports like Master/Detail, Cross Tab and Chart using web intelligence.
• Used functionalities such as sub-reports, cross-tab reports with Drill down feature.
• Extensively used Calculations, Sorting, Rank, and Drill down, Drill through, Slice and Dice, Formatting, Breaks, Filters, Changing Displays and Prompts for creating Business Objects Reports.
• Publish, distribute and schedule Web Intelligence reports using Info view.
• Used Informatica to develop jobs for Extracting, Cleansing, Transforming and Loading data into data warehouse.

Environment: BOXIR2, Sql Server 2000, Web Intelligence, Informatica, Crystal Report XI, Clarify, Windows 2003 Server.

Confidential

Role: Business Objects Developer

Responsibilities:

• Involved in designing, developing testing the semantic layer for report generation.
• Scheduled the reports as per as the user's requirements.
• Publication has been used for some of the reports to split the data and sent to the users as per as the requirements.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerters.
• Created reports by using Web intelligence Rich client as per the requirements specifications.
• Done the performance tuning for the reports in order to run the reports faster.
• Developed complex reports by using sub queries, external data sources and variables
• Done the data validation testing among BO and Oracle.
• Solved the issues that are faced during UAT.
• Created Adhoc classes and objects and created the joins in the universe.
• Created the Unit test cases as per as process standards.
• Tested objects in the universe, to ensure the correct mapping of the objects.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Resolved table-joining problems like Chasm trap and Fan trap using context and Alias.
• Tested the universe structure to ensure the tables are properly updated.

Environment: BOXIR3.1, Oracle 9i, Web Intelligence Rich Client, Designer, HP Quality Center 9.2,BODS, Windows 2003 Server.

Confidential

Role: Business Objects Developer

Responsibilities:

• Involved in designing the universe creation like creating the classes and objects and resolving loops.
• Migrating the universes, reports and objects to different environments like development, testing, production.
• Solving the issues which were raised by users like data discrepancy.
• Created WebI reports as per the requirements specifications.
• Scheduling the reports to run daily, weekly and monthly and sent to the different users in different formats as per the user's requirements.
• Fully involved in administration activities like creating the new users, folders and groups, giving proper access to users for the specified folders, adding user to the specified group.
• Balanced the maintenance work and enhancement work so well that none of the enhancement works got delayed and always met the deadlines.
• Maintained over 175 corporate documents and 300 user accounts.
• Almost Single-handedly handled the Security part of Reports and accesses.
• Minimized the number of user complaints over a very short period of time.
• Added Row level Security to restrict data to the groups
• Created with Business Objects repositories and universes
• Providing user access to Reports, Universes between different Environments
• Migrated documents from a development to a production environment
• Resolve customer support issues by phone and done client support

Environment: Business Objects XIR2, Sagent Automation, Sql Server 2000, Windows 2003 Server.

Confidential

Role: Business Objects Developer

Responsibilities:

• Responsible for handling BO production issues
• Training the user on finding the New changed hierarchy from old hierarchy and helping them modifying the report filters.
• Solving any data issue related to New world hierarchy.
• Doing Impact analysis of effected Universes/ Reports for the old hierarchy changes.
• Working as a 24 X 5 BO production support member, mainly concentrating on Technical and functional support.
• Modifying existing BO Reports Adding new Filters and Conditions .
• Resolving Production issues pertaining to Integration Reporting BO Application modules implemented for GE Healthcare IT globally.Guiding, inducting and helping new team members in issue resolutions.
• Having good experience on Star Schemas, Snowflake Schemas, Fact tables, Dimension tables design
• Created Universes, Classes, Dimension and Measure Objects by retrieving the data from various data sources and defining the necessary connections.
• Detected/Resolved data Cardinalities and loops, checked integrity of Universes, created list of values. Resolved Chasm, Fan traps and Loop problems using aliases and contexts in the universe and exported to repository.
• Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc.
• Created complex reports using cascading prompts.
• Created variables, formulas and used contexts in, for all, for each .
• Created Web Intelligence reports using Multiple Data Providers, Prompts, break, filter, rank, alerter, Slice Dice and Drill up/down functionality.
• Tested reports before posting them to the repository query optimization performance .

Environment: Business Objects XIR2, Citrix Environment, Teradata, Cognos, MS Office, Window 2000.