SUMMARY OF EXPERIENCE:

• Over 6 years of experience working as Business Intelligence consultant focusing on Business Objects Tools, hands on experience with different versions of BO i.e. 4.0, XI 3.1/R2/R1/ 6.5
• Worked with Business Objects tools like Designer, Central Management Console (CMC), Business Objects Desktop Intelligence (Full Client), Web Intelligence Rich Client (WEBI) Reports and Information Design Tool.
• Involved in Installation and deployment of Business Objects on sand box
• Involved in security implementation using Central Management Console (CMC).
• Worked Extensively on Business Objects Xcelsius 2008,developed complicated Dashboards using components like gauges and maps
• Working experience in migrating BOBJ Environments from 6.5 to R1/R2/3.1
• Thorough knowledge on data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables.
• Prepared Technical specifications for the development of Universes and Reports
• Extensive experience in analysis to design the Universes and Business Objects Reports to support the user requirements.
• Created complex views to overcome loops and contexts
• Experience in creating Customized and ADHOC reports using Business Objects Full Client and Web Intelligence (WEBI) tool.
• Extensive experience in Performance Tuning Measures like using of Aggregate Tables, and Shortcut Joins.
• Trained User community in Business Objects XI 3.1 and (WEBI) Reports.
• Experience in working with different databases like Oracle 10g/9i/, SQL server 2005/2000/7.0, DB2, Teradata and MS Access.
• Experience in BO Query Builder. Migration of legacy data into SAP environment which involves leading in the execution and documentation of the data migration process.
• Created reports using Crystal Reports 2008
• Excellent Communication, Analytical and Technical skills.
• Ability to work with team as well as independently.

TECHNICAL SKILLS

BI Tools:Business Objects 4.0, XI 3.1(R3.1)/R2/R1/6.x,Crystal Reports 2008, Xcelsius 2008
Front-End:MS-Excel, MS-Power point,
Databases:Oracle 10g/9i, SQL Server 2005/2000/7.0, Teradata, IBM DB2 and MS Access
Programming:SQL, PL SQL, .Net, VB

EDUCATIONBachelors in Political Science

PROFESSIONAL EXPERIENCE

Confidential April- Till Date
St. Louis, Missouri
Role: Business Object Consultant

Responsibilities:

• Worked on end to end solutions for business and technical users, to provide them with ideal launch pad for Zero Based Budgeting environment.
• Gathered business requirements to ensure both business users as well as technical users a clear path for future updates.
• Worked with off-site DBA team to ensure accurate data modeling and retrieval.
• Documented report and universe changes for context.
• Created New Universes and objects based on business need and emulation
  of Cognos Contributor environment using the Business Objects Suite
• Created custom measures based on need and fluctuating calculations when applying percentages.
• Performed Data validation and Data Analysis, based on past reports and Cognos based data.
• Optimized Legacy Universes to speed data retrieval, using Derived tables and aggregations.
• Implemented database changes within toad to add columns and rows as needed
• Applied complex formulas to derive calculations to reduce load on Universe
• Created complex reports using Merge Dimensions, Union and custom measures.
• Formatted reports to specific user specifications

Environment:Business Objects 3.1/XI 2, Oracle 10 g, Teradata, TOAD

Confidential Sep 2011- March 2012
New York, NY
Role: Business Object Consultant
Responsibilities:

• Interacted with End Users regularly, in order to generate the reports required and to resolve the existing issues.
• Created Projects in Information design tool along with Classes & objects when designing universes.
• Defined Aliases & Contexts to resolve loops in the universes.
• Changed report data sources for multiple documents to feed data from different Universes into (already created/template) reports and dashboards.
• Generated various reports on Daily, Weekly & Monthly Basis.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drill Down, Filters, Ranking, Sections, Graphs, Breaks & Variables.
• Created custom List of Values (LOVs) for better understanding of prompts by the end users and created reports with element and document linking (OpenDoc Functionality) In Web Intelligence 4.0.
• Created interactive dashboards in Crystal Dashboard Design Tool (Xcelsius 2011) using universe quires as source to pull data from .unx Universes
• Created BI work spaces to provide consistent, up-to-date means for monitoring business areas.
• Involved in managing users, groups, folders and published reports using central management console.
• Created Users, Groups & assigned rights using CMC.
• Prioritize Security levels for Users & Users Groups.
• Migrated universe and reports from Development to Production environment using Lifecycle Manager in 4.0 environment.
• Documented all migration procedures as executed.
• Provided training to end users in report development and running ad-hoc queries in business objects

Environment:Business Objects 4.0/XI 3.1, Crystal Xcelsius 2008, Dashboard Design tool 4.0, Oracle 10 g

Confidential, Alexandria, VA Nov 10 – Aug11
Business Objects Consultant

Responsibilities:

• Converted business requirements in business/technical requirement documents.
• Involved in full development life cycle of universe development.
• Integrated Business Objects Reports and Dashboards to Third Party Portal using OpenDoc functionality.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
• Implemented Row Level, Object Level security for data restriction at Universe level.
• Developed Webi, Deski , Crystal , Webi Rich Client and Xcelsius Dashboards
• Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking and Merge Dimensions
• Assisted BO supervisor in giving connections to the database at site (DB2, and SAP).
• Organized data in the report Inserting Filters, Sorting, Ranking and Alerter.
• Experienced in developing complex reports using Business Objects Web Intelligent Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Web Intelligence reports.
• Deployed Business Objects Universes and Reports in a Secure Environment from One Server to Other Servers using Import Wizard.
• Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
• Created Pseudo dashboards one report having multiple hyperlinks to various reports using Open Document functionality from Dashboard to Webi Report.
• Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
• Written SQL queries have been used on the Universe and created as Derived Tables.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Created Views, Stored Procedures and validated data for the Performance.
• Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
• Developed Business Views on top of universes
• Created complex reports in Deski, using multiple Data providers.
• Converted Deski Reports to Webi using Report conversion tool for enhancements
• Created Derived Tables in Universe to meet specific requirements for Webi Reports and Dashboards.sed Open Doc functionality to drill down from Xcelsius dashboard to Webi Reports.

Environment: BOXIr3, Crystal Reports 2008, Xcelsius 2008, SAP BW, SAP CRM, SQL Server 2005 and Sun Solaris

Confidential, New York, NY Aug 09 – Oct 10
Business Objects AnalystResponsibilities:

• Gathering day-to-day requirements from Business Users, analyzing and documenting the potential data requirements
• Involved in designing and Building of Universes, Classes and Objects for warehouse management system.
• Created the reports using the Universes as the main Data Providers.
• Used aggregate aware functions and created the objects, which are grouped into classes based on Business Functionality.
• Involved with SAP BW team to generate SNC setting for SAP BW integration with BO XIR 3.1.
• Created reports on web using InfoView, and distributed the reports to different users using Broadcast Agent.
• Responsible for creating the complex Crystal reports (On demand, Adhoc Reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical reports etc).
• Used prompts, Global filters, drill downs, customized views and charts.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts). Worked extensively with the major functionalities of Business Objects like Alerter, Group By, query prompt, drill filter, indexes, and Breaks, Sorts, Ranking, Calculation using the Slice and Dice panel.
• Created different types of reports like Master/Detail, Cross Tab and Chart (for analysis), used filters, conditions, and calculations and Defined standards for tables, charts etc.
• Enhanced the existing reports using sub queries to improve the performance.
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Created template documents with header, footer and company logo.
• Created user groups and managed access privileges using Central Management Console. Created User Id’s and implemented security features.
• Wrote SQL statements for testing of BO queries using TOAD.
• Involved in various discussions with the end users to analyze Meta data.

Environment: Business Objects XI r3/r2 (CCM, CMC, Info View, Desktop Intelligence, Web Intelligence, Crystal Reports, Xcelsius), Oracle 10g/9i, PL/SQL and Windows

Confidential, New York, NY May 08 – Jul 09 Business Objects Developer/AdminResponsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Gathered Customer, User and Owner requirements; analyzed and documented them.
• Created Data Flow Diagrams (DFD) to define the data element flow to the most level.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Designed, developed, tested and maintained highly complex reports.
• Scheduled and monitored reports using Broadcast Agent Console.
• Created, refined and delivered functional test materials collaborated with test cases, set up test plans, schedules and scenarios.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.
• Used Central Management Console (CMC) to create repository, creating and managing the users, giving access permission for Business Objects Reports.
• Provided production support by monitoring the processes running daily.
• Deployed the development and QA domains to reduce the server loads and to increase the performance.
• Trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting

Environment: Business Objects XI r2/6.5 (CMC, Info View, Web Intelligence, Desktop Intelligence), Xcelsius 2008, DB2, Oracle 8i, TOAD, UNIX

Confidential. Atlanta, GA Aug 07 – Mar 08
Business Objects DeveloperResponsibilities:

• Designed universe for standard reporting and ad hoc reporting requirements.
• Created Contexts and alias for resolving loops in the universes.
• Worked with different universes and used linking of different universes.
• Implemented different level of hierarchies for drill down reports.
• Analyzed Data using Slice and Dice and Drill Mode etc and formatting Reports.
• Automated document Scheduling, Publishing and Distribution for Web I and Info view clients, using the Broadcast Agent for Web-Part Reports
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc.
• Used various Functions like @Prompt, @Where, and @Select.
• Created customized functions/hierarchies for reports using Crystal Reports.
• Worked with ranks, alerts, prompts, variables and calculation contexts in designing reports.

Environment: Business Objects 6.0, Supervisor, Designer, Broadcast Agent, Web Intelligence 2.x/6.0, MS SQL Server 2000, Oracle 9i, Windows 2000 and UNIX

Confidential, Edison, New Jersey Feb 07 – Aug 07
Business Objects Developer Responsibilities:

• Designed and developed Universes according to the requirements and specifications.
• Maintained and modified existing universes.
• Created Classes and Objects and defined join relations and defined the cardinalities between tables.
• Analyzed reports using Slice and Dice, Scope of Analysis and Drill function.
• Created Master Detail and Cross Tab reports.
• Used BO to create reports containing complex charts to present the end users with a better graphical representation of the data.
• Used Ranking for showing the extreme ranges of data like maximum and minimum data representation.
• Developed Hierarchies to support drill down reports which allows the users to analyze the data.
• Created complex reports using user defined functions, conditions objects and aggregate awareness functions for SQL enhancement.
• Formatted the reports as per the business requirements.
• Generated reports for web users using Web Intelligence and Info View.
• By using Web Intelligence created thin client reports and published them as corporate documents.
• Scheduled the reports on Daily, Weekly and monthly basis using Broad Cast Agent.

Environment: Business Objects 6.0, Supervisor, Designer, Web Intelligence, Broadcast Agent, MS SQL Server 7.0, Oracle8i, Windows XP/2000 and Unix

Confidential, San Antonio, TX Jan 06 – Jan 07
Role: Business Objects Developer

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in the designing and Building of Universes, Classes and objects
• Worked on Master and Component approach during the linking of universes.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• The project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Created reports using Desktop Intelligence(DESKI)
• Created reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's.
• Migrated reports from Development/Testing environment to Production Environment.
• Created dynamic LOV's based on report requirements.
• Coordinating with DBA and general supervisor for resolving technical issues

Environment: Business Objects 6.0, Designer, Web Intelligence, MS SQL Server 7.0, Oracle8i, Windows XP/2000