PROFESSIONAL SUMMARY:

• 8 years of IT experience in Business Objects 4.0/XI3.1/XI3.0/XIR2/6.5.1/6/5.x - Business Objects Universe Designer Information Design Tool, Desktop Intelligence, Web Intelligence, Info view, Crystal Reports 10/XI/2008, Xcelsius, Query as a Web Service (QaaWS), OpenDocument, Report Conversion Tool, CMS, CMC
• Experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
• Experience in full life cycle gathering requirements, documentation, developing, designing, implementing, testing and deploying.
• 7+ years of experience in Designing/Enhancing Single source and Multi-Source Universe for Ad-hoc reports, Canned Reports, Complex Reports using both UDT and IDT tools.
• Expertise in Querying and Reporting modules. Worked on InfoView to create Web Intelligence over the Universe created. Worked on Combination Queries, created Webi reports over multiple queries.
• Worked extensively on various Business Objects functionalities like Queries, Slice and Dice, Cross Tab, Master Detail, Breaks, Alters, Filters, Sorts, Ranking, Prompts and Calculations.
• 4+ years of extensive experience in Crystal Reports, created complex reports using functionalities like Groups, Cascading parameters, Linked reports, Sub reports and conditional formatting. Expertise in performing tuning and optimization
• 2+ years of experience in Developing Xcelsius dashboards for presentations, live data dashboards with alerts, calculators, historical data comparisons and using crystal Xcelsius by various methods like excel as data source and using QAAWS and LIVE OFFICE.
• Good knowledge and experience with Central Configuration Management (CCM), change control and source control systems.
• Experience in working on Tableau dashboard with Webi, Crystal Reports and Xcelsius Dashboards.
• Ability to adapt to new technologies very quickly and different project environments
• An excellent team member with interpersonal and communication and presentation skills along with Time management

TECHNICAL SKILLS:

Data Warehousing / OLAP / BI Tools: Business Objects XI 4.0, 3.1, 3.0 (Central Management Console, Central Configuration Manager, Central Management Server, Desktop Intelligence, Information Design Tool, Upgrade Management Tool, Import Wizard, Web Intelligence Rich Client, Designer, Infoview, Performance Manager, Dashboard Manager), Business Objects Data Integrator, BusinesObjects 6.5 (Reporter, Designer, Supervisor), Crystal Xcelsius 4.5/2008, Crystal Reports XI R 2/10.0/9.0/8.0 , Crystal Reports 2011, Live office, Web Intelligence 4.0, Crystal Reports Enterprise 4.0 and Dashboard Designer 4.0, SAP Business Explorer, Congo s, Datastage, Tableau, Informatica, Business Objects, Web intelligence, LiveOffice, Desktop Intelligence, Import Wizard, BI Launch Pad, QaaWS, WEBI, SAP BI, FRS, UDT, jco, bics, Universe, PICK, UniData, Pick, Business intelligence, Job scheduling, Universe Designer, SAP BODS,SAP HANAODBC, Reinsurance, Data services, Xcelsius, EBP, SPRO, GDPS,CAPM,BRF.

Project Management: Teradata Oracle 11g/10g/9i/8i, Oracle EBS, MS SQL Server 2008/2005, MySQL 5.1,Facet DB, Oracle ERS, IBM DB2, MS Access, JIRA, MS Project, MS Access, MS Visio and MS Excel, VersionOne

Operating System: Windows XP/NT/2000/98/95, Windows 2003, UNIX

Version Control & Others: Microsoft Excel, TOAD, SQL Navigator, WinSQL

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Business Objects Developer/ Report Developer

Responsibilities:

• Worked as a lead and interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
• Worked on Agile methodology.
• Upgraded SAP BO XI 3.1 TO SAP BI BO 4.0 reports using Upgrade Management Tool.
• Built Single Source and Multi-Source Universes related to Policy for Auto, Home, Claims, Billing and EDW in Information Design Tool, Universe Design Tool in SAP BI BO 4.0.
• Worked on resolving loops in Universes using Aliases and Contexts. Resolved Chasm, Fan trap.
• Developed and created classes with Dimension, Detail and Measure objects and developed Custom hierarchies to support drill down reports.
• Created Derived tables in Universes to enhance capabilities and performance of Universe.
• Designed, Developed and Implemented Web Intelligence and Deski reports using functionalities like Queries, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Created Summary, Detail Webi Reports using features like Optional Prompts, Functions, Alerter to make reports accurate and easier for analysis.
• Used OpenDocument for linking Webi reports to other reports within BO or outside.
• Created and enhanced existing Crystal Reports by creating new Parameters, Formulae, Grouping, Selection criteria. Scheduled reports using Info View to run at specific times in a day/wee as desired by users.
• Used Xcelsius dashboards to pull data from required reports to Excel sheet by using Universe as data sources.
• Used Universe, Crystal Reports and Webi Reports as Data source of Xcelsius to build dashboards through Live Office to get live data.
• Implemented Data and Application level security in BO Environment using CMC.
• Integrated Tableau within Business Objects Webi report, Crystal Reports and Xcelsius Dashboards by using two features hyperlinking and iframes. Where drill down is done in both Webi report and Tableau Dashboard.
• Created Functional Requirement Document, BO/Universe Mapping documents, Report Mock-up samples to analyze business requirements.

Environment: Business Objects, Web intelligence, Live Office, Desktop Intelligence, Import Wizard, BI Launch Pad, QaaWS, WEBI,SAP BI,FRS,UDT, jco, bics, Universe, PICK, UniData, Pick, Business intelligence, Job scheduling, Universe Designer, SAP BODS,SAP HANA, ODBC, Reinsurance, Data services, Xcelsius, EBP, SPRO, GDPS, CAPM, BRF. Business Objects 4.0 (Universe Designer Tool, Information Design Tool, Web Intelligence, Desktop Intelligence, Infoview, CMC), Crystal Report 2011, Xcelsius 2011, Tableau, Informatica, SAP Query Builder, RDBMS (Oracle 11g/10g/9i), Sielbel, IBM DB2 Net Driver, Cognos, Datastage, IDE (Toad 10, SQL Plus), Defect Tracking Tool (VersionOne), SQuirrel

Confidential, Compton, CA

Business Objects Developer

Responsibilities:

• Worked as a Lead and Designed, developed Universes involving the required tables from Data mart.
• Also used Derived queries/tables, nested derived queries for best performance using Business Objects Universe Designer.
• Assigned @ BO Variable to implement User Level Security and created reports based onn on free hand SQL and Universe Objects
• Worked on Gathering Requirements, Understanding technical specifications as required by the Project guidelines, the Scope and simultaneously developing universes, Reports and Dashboards
• Worked with DBA to create aggregate tables and views to improve the performance of the query by cutting down the size of the result set
• Created/Modified new Business objects Deski/Webi Reports using Webi Intelligence Rich Client and Infoview
• Specified the Joins, checked the cardinalities and resolved loops by either using Aliases or Contexts
• Created complex reports involving table/section breaks, multiple data providers and derived tables
• Created complex reports like drill down, Slice and Dice, master/detail and headcount of the records
• Also worked in the Support team to resolve any BO Project related tickets/issues related to Universe, Webi reports and Dashboards
• Tested the aggregate awareness to ensure the query is pulling up the correct level of aggregation
• Used Import Wizard for migrating Project Deliverables between Dev, IST, UAT and Production Environments.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Using Universe and Webi Reports as Data Source of Xcesius to build the dashboards through Live Office to get the live data
• Successfully implemented export to Excel, PDF and .CSV feature in lower versions of Business Objects using macros to match the data in Webi report as well as Excel download and .CSV download.
• Also created Technical Design Documents to translate the Business Requirements Document into a technical description to ensure that it describes in detail the specifics of the functions from user’s perspective, provide implementation detail and will be used as blue print of implementation.
• Developed Business Objects Code Promotion documents for all the Developed/ Enhanced Universes and Reports to Migrate it to the next Level.
• Handled project for verifying Project Deliverables against both Technical and Functional Specifications.

Environment: Business Objects XI 3.1/XI 4.0 (Business Objects Designer, Web Intelligence, Desktop Intelligence, Infoview, CMC), Crystal Report2008, Xcelsius 2008 SAP Query Builder, RDBMS (Oracle 11g/10g/9i), Oracle ERS, Teradata, IDE (Toad 10, SQL Plus), Defect Tracking Tool (HP Application Lifecycle Management 11)

Confidential, West Des Moines, IA

Business Objects Developer

Responsibilities:

• Analyze the reporting requirements with the business users/architects and come up with the technical Specifications for universe and Business Objects reports.
• Utilized a thorough understanding of available technology, tools, and existing designs and worked on most complex problems where analysis of situations or data requires evaluation of intangible variance factors
• Improved the performance and reduced the coding with the use of @select, @prompt, @where.
• Improved the performance and reduced the coding with the use of @aggregate aware and tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Created Universes on top of SAP BW Info Providers for reporting with Web Intelligence.
• Used Query Designer in Business Explorer for applying Prompts and filters on top of Info providers.
• Administer and supervise the Business Objects environment by monitoring/granting permissions and rights to a vast Users located all over the world for viewing, creating and publishing reports and implement Row and object level restrictions.
• Created reports using free-hand SQL, Stored Procedure, PL/SQL.
• Resolved universe problems such as loops, chasm and fan traps using aliases and contexts by testing the overall integrity of the structure using check integrity.
• Modifying the existing universes, adding new objects, editing joins, mapping the existing objects with renamed tables.
• At the universe level checked whether all the outer joins are created properly and also removed if there are any variables which are not used.
• Implementing Object-level and Row-level security using Manage Restrictions on the developed universe restricting the end-users in accessing certain objects.
• Created Web Intelligence Reports using Webi reports Formulas, Grouping, Parameters and Static/Dynamic Cascading Prompts to handle the customer’s requests from Tables, Stored Procedures, and Views.
• Created Custom Hierarchies for using scope of Analysis and Drill Down options.
• Created the Reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice and Drill Down.
• Improved the performance of the reports by removing any additional filters or alerter on the report. Turned the formula into a variable if it has any multiple uses.
• Developed and executed the Reports using Business Objects XI 3.1
• Used Import Wizard for the Migration process. Migrated users, universes, reports

Environment: Business Objects XI 3.1, Designer, Web Intelligence Rich Client, Crystal Reports 2008, Infoview JIRA,Cognos, CMC, Teradata, MS SQL Server 2008, Oracle 11G, SQL.

Confidential, Overland Park, KS

Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications for Designing Universes and responsible for analysis on crystal reports migration.
• Used Query Designer in Business Explorer for applying Prompts and filters on top of Info providers.
• Scheduled the reports on daily, weekly and monthly basis by using Scheduler.
• Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
• Used Cascading prompts for geographical hierarchies.
• Used Teradata Utilities to increase the performance on the reports.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Developed Web Intelligence reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints and Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis) using Web intelligence Rich Client.
• Worked extensively with the major functionality of Business Objects like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Created Analytics and Dashboards using Performance Manager to enable executives track progress and compare current and historical performance against established targets.
• Created Dashboard, Sales figure Dashboard using Xcelsius 2008.
• Migrated Business Objects XI R2 content (users/user groups, Universes, reports) in to Business Objects XI 3.0 environment using the Import Wizard.
• Migrated Crystal Reports 8 to Crystal Reports XI and also responsible for testing and publishing reports.
• Involved in Business Objects Support, Problem Solving, Troubleshooting and developing End user Notes.

Environment: Business Objects XI 3.0/R2, Web Intelligence Rich Client, Xcelsius 2008, Crystal Reports, Infoview, Teradata 13.0, Teradata 13.10, SAP BW, TOAD, Windows 2003 Server.

Confidential, Bangor, ME

Business Objects Consultant

Responsibilities:

• Interacted with Business Users and Business Analysts to gather the requirements and business logics.
• Interacted with end users, regularly in order to generate the reports requirements, these reports were generated using Business Objects functionalities such as Slice and Dice, Master/Detail, User Responses, Formulas, etc.
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Created Universes and Reports based on requirement and Involved in Migrating Reports from BO 6.0 to BO 6.5
• Resolved loops in Universes using table aliases and contexts to remove cyclic dependencies.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Involved in creating reports on the web using Business Objects Web Intelligence 6.x.
• Created and managed users and their groups for different areas, repositories, and documents through Supervisor module.

Environment: Business Objects 5, Business Objects 6x, Central Management Server, Designer, Oracle 8i, Windows 2000.