SUMMARY:

• Strong knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, security management and production supporting. Migrating universes, reports, users, categories from old version to Business Objects XI environment.
• Migrated Reports, Universes etc. from DEV to QA and QA to Prod after documentation has been provided.
• Migrate stuff from older version to newer version and test it, make sure everything works fine.
• Experienced in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Extensively used TOAD to understand and verify data based on universe condition syntax.
• Strong experience using SQL, PL/SQL, TOAD.
• Expertise in gathering the business requirement and building Universes, free hand SQL methods and creating complex ad - hoc reports.
• Broad knowledge in optimizing/enhancing SQL sentences, reports and tables.
• Excellent technical, logical and problem solving capabilities.
• Pro-active team player, committed to providing quality deliverables with strong analytical skills.
• Created Free-hand SQL and Ad-hoc reports in Business Objects.
• Experienced with OpenDoc command and usage of Flash variables within Xcelsius
• Experienced in creating Drilldown Reports, Sub Reports, On-Demand Sub Reports, Label Reports, Chart Reports, Dashboards, and Scorecards.
• Also experienced in creating dynamic dashboards, Scorecards using Live Office, QaaWS, and BI Services.
• Converted Confidential Reports to WEBI using RCT.
• Worked with platform admin on upgrades and fix packs.
• Created Users, Groups, Access Restrictions, for info View Users.
• Strong Experience working as Enterprise admin as well as Developer.
• Excellent technical, logical and problem solving capabilities.
• Pro-active team player, committed to providing quality deliverables with strong analytical skills.
• Experience using Microsoft Excel, PowerPoint, PDFs interaction with Business Objects.

TECHNICAL SKILLS:

BI Tools: Business Objects XIR2/XIR3.0/XIR3.1/XIR4.0 (CMC, Import Wizard, Designer, Confidential, WEBI Rich/Thin Client, InfoView, RCT, UDT, IDT, UMT, BI Launchpad), SAP BW BEx Query, Crystal Xcelsius 2008, Live office, QaaWS, BI Services.

Databases: Oracle 9i/10g, SQL Server 2005, SQL Server 2008, DB2.

Languages: SQL

Operating Systems: 2003/XP/Win 7

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Business Intelligence/Business Objects Developer / Administrator

• Performed Enterprise Administration for Business Objects environment.
• Migrated all universes/reports from BO XI R2 to BO XI R3.1 using Import Wizard
• Migrated whole environment from XI R2 to XI R3.1 using Import Wizard
• Migrated XI R 3.1 Environment to XI R4.0 using upgrade Management tool.
• Used BI Launch Pad in XI R4.0 instead of InfoView.
• Used UDT in XI R4.0 to create Universes.
• Partnered in creation of BO XIR 3 users; user groups, folders, universe connections, securities, server and server groups in development environment.
• Assigned privileges to respective reports and universe to users and user groups.
• Converted Desktop Intelligence reports to Web Intelligence XI R3.1 reports using report conversion tool
• Configured reports on user profiles to burst at different destinations like FTP Server in PDF, Excel formats.
• Configured and fixed all issues encountered by universes/reports during migration.
• Modified variables and formulas from partially converted rich client reports to Web Intelligence XIR3 for exact same results.
• Interacted with user’s regularly, in order to generate the reports required and to resolve the existing issues.
• Responsible for creating patient, medical and pharmacy claims and outcomes reports.
• Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail, Slice & Dice and Drill Down, etc.
• Imported / Exported the Universes from / to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Addressed Chasm trap and Fan Trap using Multiple SQL statement features of Universe Designer tool.
• Created and worked on Row level security, Object level security using Designer and various predefined security settings depending upon users and group needs using CMC.
• Created several users and groups inside the CMC and implemented the access levels as per the best practices.
• Responsible for documentation of various stages in development including design, debug, maintenance etc.
• Involved in trouble shooting of various reporting errors.
• Created Business Objects reports, ad hoc queries with constant interaction with the end users.
• Created new user and put them in appropriate user groups and granting them access level.
• Dealing with the users having all different kinds of issues on XI R3.1 (new) environment with their access level as well as with their reports.

Environment: Windows 2003/7, Business Objects XI R2/3.1/4.0, SAP BW Oracle10g/11g

Business Intelligence/Business Objects Consultant

• Built Universes for end user report generation using Designer module.
• Creating complex reports on WebI Rich client and WebI thin client using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Developed dashboards using Crystal Xcelsius 2008 using QaaWS, Live Office and Spread sheet in a form of chart, dial, dynamic dashboards etc., refresh QaaWs every time when end user run the report, Use Triggers in M/D.
• Detected Joins and checked the Cardinalities.
• Resolved Universe problems like Loops, chasm trap fan trap using Alias and context.
• Developed and created classes with Dimension, Detail & Measure objects.
• Developed Custom hierarchies to support drill down reports.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Implemented cascading prompts in universe.
• Check the integrity of the Universes, and export the universes to Repository for making available to users.
• Optimized and enhanced some of the existing reports to reduce processing time.
• Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formula.
• Dynamic visibility using radio button, connectivity between two components.

Environment: Windows XP, Business Objects XI 3.1, Oracle 10g, Crystal Xcelsius 2008.

Business Intelligence/Business Objects Consultant

• Designed application by integrating product knowledge with client requirements.
• Created complex reports on WebI Rich client and WebI thin client using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Developed dashboards using Crystal Xcelsius using QaaWS, Live Office and Spread sheet in a form of chart, dial, dynamic dashboards etc., refresh QaaWs every time when end user run the report, Use Triggers in M/D.
• Documented the design.
• Created templates for standardizing reports using company logo, header and footer settings, color coding, fonts and maintained consistency in viewing cross-tabs, blocks in report.
• Created user defined objects to manipulate the data by using database specific functions to fulfill the reporting requirements.
• Synchronized reports using data from multiple data providers in Web Intelligence by merged dimensions functionality.
• Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, master/detail, cross tab, charts and alerts for creating Business Objects reports.
• Suggested modifications in Universe in existing objects or creating newer objects which are necessitated from Reporters perspective.
• Created Users/Groups/Sub-Groups & assigned profiles there by restricting un-authenticated access to resources.
• Implemented row & object level security for different user group requirements.
• Developed issue log and prioritized the issues.
• Involved in resolving problems like ‘Chasm Trap’ and ‘Fan Trap’.
• Checked the integrity of the Universe schema for any errors in objects, joins, conditions, loops and cardinalities of the Universe.
• Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
• Used @Functions such as @Prompt- to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user etc.
• Distributed documents inside and outside of the business using CMC and administration for scheduling the reports (like REP, PDF, EXCEL, TEXT and HTML format).

Environment: Windows XP, Business Objects XI 3.0/3.1, Oracle 10g, Crystal Xcelsius 2008.

Business Intelligence/Business Objects Consultant

• Created several Webi reports, Confidential reports and Dashboard reports for graphical presentation.
• Coordinated 1st level support team members.
• Analyzed user requirements. Find solutions to technical issues; extend technical assistance.
• Improved support process and procedures.
• Optimized and enhanced some of the existing reports to reduce processing time.
• Administrated Business Objects and using Supervisor and Info view setting user privileges.
• Developed reports using filters, prompts, sorts, groups, subtotals, free hand SQL and multiple data providers.
• Worked extensively  to overcome the problems with database when integrating with Business Objects
• Exporting the reports to Broadcast Agent Server. Schedule and monitor the reports
• Creating aliases, contexts and short cuts joins by resolving loops, cardinalities and integrity checks of the universe.
• Set up Aggregate Awareness to enhance the performance of SQL transactions.
• Tuned the reports for better performance using SQL.
• Conducted Business Objects and Web Intelligence training session to train the users.
• Interacted with Latin America Support team members and database administrators to coordinate updates and upgrades in repository and databases.
• Elaborated Service Level Agreements among support team leaders.
• Reported directly to the Confidential Managers, users or support teams.

Environment: Windows XP, Business Objects XI R2, Oracle 9i.

Business Intelligence/Business Objects Consultant

• Gathered requirements from end users to create universes and reports.
• Built the Universes for end user report generation using Designer module.
• Detected Joins and checked the Cardinalities.
• Resolved Universe problems like Loops, chasm trap fan trap using Alias and context.
• Developed and created classes with Dimension, Detail & Measure objects.
• Developed Custom hierarchies to support drill down reports.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Implemented cascading prompts in universe.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects.
• Generated List of Values (LOV’s) from lookup tables.
• Check the integrity of the Universes, and export the universes to Repository for making available to users.
• Migrated business objects 6.5 to Business Objects X IR2 using Import Wizard.
• Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formulae.
• Creating complex full client and Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis.
• Generated pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard.
• Created users, user groups and assign user privileges, defined General Supervisor and created repository through Supervisor.
• Involved in data modeling of the data warehousing system by creating facts and look-up tables using business objects.

Environment: Windows 2003/XP, Business Objects XI R2, SQL Server2005.