Sr. BUSINESS OBJECTS DEVELOPER

• More than 6 years of experience in developing Business Intelligence solutions for clients. Known to be a top end consultant who meets the client requirements for cost and delivery.
• Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions and confident, accurate decision making coupled with excellent communication and interpersonal skills.
• Extensive knowledge in Business Objects XI/6.x Enterprise Applications. This includes experience with Designer, Web Intelligence Rich Client, InfoView, Desktop Intelligence, Opendoc, Crystal Reports, Business View Manager… etc. Extensive experience creating Ad-Hoc Reports as per client requirements & in designing Xcelsius dashboards using Live Office & Query as a web service.
• Creating primary database storage structures (table spaces) after application developers have designed an application.
• Extensive experience in building Universes and retrieving data using Universes, Personal data files, stored procedures, Free hand SQL and creating complex ad-hoc Reports using Business Objects reporting tools.
• Involved in training end users, business users and customers on how to create modify and interpret Deski reports, WEBI reports and Crystal reports.
• Have expertise in creating complex master detail reports by linking data from multiple sources. Also have expertise in functionalities of BO like Slice and Dice, Drill Down, Master Detail etc.
• Excellent exposure creating reports/dashboards with Web Intelligence, Desktop Intelligence, Info View and Dashboard Manager Tools.
• Experienced in Extracting data from different source systems like text files and different rdbms.
• Very good understanding of Dimensional modeling with Star Schema and Snowflake Schemas.
• Strong skills in interfacing Business objects with Databases like Oracle, Sybase, SQL Server and MS Access.
• Assist and manage the design, prototyping, development, testing, and production support of multiple universes.
• Excellent technical, logical, code debugging and problem solving capabilities.
• Good knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling, Data mining and Web reporting features of data warehouses.
• Data modeling experience using ERwin.

EDUCATION

Bachelor Of Commerce from Confidential University
Postgraduate Diploma in Computer Applications

TECHNICAL SKILLS

Business Objects: Business Objects XI 3.1/3.0/XIR1/XIR2/6i/5i, CMC, CCM, Xcelsius, Client tools of Webi/Deski, QaAWS, Opendoc, LiveOffice, Import Wizard, Publishing Wizard, Crystal Reports, Infoview
Database: Oracle 9i/10g, MS SQL Server 2000/2005/2008,  MS Access, Sybase, DB2
Programming Language: C, Java, PL/SQL, HTML, XML, VBA
Operating System: Unix, Windows

PROFESSIONAL EXPERIENCE

Confidential, Morrisville NC Feb’10 -- Present
Business Objects Universe/Reports Developer

Responsibilities:

• System study, interaction with users & management, performance of analysis, designing, coding, testing & implementation of the system. Involved in implementation of SDLC Life Cycle
• Installing the product layout, database, migration of the repository data with security details and configuring the CMS clustering.
• Support code deployments and migrate content from XIR2 to XIR3.1 SP3 FP3.4
• Facilitate with tech Support to Formulate a Strategy for Implementing good User support
• Interacted with Business Users, Business Owners to understand their Business views in developing and modifying Universes and Reports accordingly.
• Trained the user community in making use of universe to create and publish ad-hoc reports.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops/Ambiguities and checked the Integrity of the Universes.
• Automated documents Scheduling, Publishing and Distribution for WebI and DeskI reports for Info view clients.
• Set up groups and users for Business Objects deployment. Managed user profiles using CMC
• Involved in the designing and Building of Universes, Classes and objects.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Exported universes to Repository in order to make resources available to the users
• Created reports using the Universes and Free hand SQL as Data providers
• Creating the reports using Business Objects functionalities such as Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae etc.
• Built full client and WebI reports. Provided OLAP functionality and worked extensively with data warehousing
• Extensively used Filters and Conditions
• Used Merged Dimensions functionality within Web Intelligence and Desktop Intelligence for data parsing and preparation.
• Used Opendoc functionality to integrate highly interactive dashboards, Webi & Deski reports into custom Business Applications.
• Worked on Universes Query Panel, Prompts and Report Layout and re-formatting
• Use of Designer to implement Universe, Links between Tables, create dimensions, measures, detail objects, filters and prompts, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies

Environment: SAP Business Objects XIr3.1, DeskI, WebI, Designer, CCM,CMC, Infoview, Import wizard and Data Integrator 11.5/11.7,Oracle 10g, SQL Developer.

Confidential, Houston, TX March’08 -- Jan’10 
Business Objects Reports Developer

Responsibilities:

• Involved in the designing and Building of Universes, Classes and Objects.
• Created Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.
• Exported the Universes to the Repository to make resources available to the users.
• Created several ad-hoc reports for various Portfolios using the Universes as the main Data Providers to validate the data.
• Interaction with end users regularly in order to generate the reports, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Created Universes by retrieving the data from various data sources, defining the connections necessary. Generating various numbers of reports on a daily, weekly and monthly basis.
• Use of Reporter, Designer and Supervisor modules, Query Panel and Data Provider; handling of ODBC issues.
• Used Designer to implement Universe, Relationships between Tables, create dimensions, detail objects, measures, filters and prompts, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Developed procedure and functions using PL/SQL and used SQL*Plus to execute PL/SQL programs, procedures, functions and packages.
• Developed various SQL, PL/SQL blocks to optimize the query performance using SQL* Plus.
• Actively involved in gathering end user requirements, User/System Documentation, User training and testing developed reports for final deployment.

Environment: Business Objects XIr2 (BO Reporter, Designer, CCM, CMC, 
Web Intelligence, Info View, Import Wizard, BO SDK, Oracle9, PL/SQL, 
SQL* Plus, Ms-Office, Windows 2000,

Confidential, Manchester, NH April’06 -- Feb’08
Reports Developer

Responsibilities:

• Interacted with the Users and Business Analysts to gather requirements. Involved in Installation and Configuration of all Components of Business Objects Enterprise.
• Involved in setting privileges to different User Groups Coordinating with Business Objects Administrator.
• Designed new Universes and also modified the existing Universes based on the report requirements.
• Use of Designer Module to build Universe by joining the Tables, Create Prompts, queries, parsing objects, apply Contexts and Alias Tables to remove ambiguities.
• Used Stored Procedures as Data provider to retrieve data from tables and complex queries.
• Tuned the queries to improve the Performance of the existing reports for various functional areas.
• Analyzed reports using Slice and Dice, Drill Down, Cross Tab, and Master Detail. Creating the reports from Excel files using Business Objects through Personal data files.
• Converted the reports to Text File format as per the User requirement Using Business Objects 5.1 Version.
• Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the reports using complex queries.
• Generated the Business Objects Reports using the universe as the main Data providers and writing the complex queries including Sub queries, Unions, Intersect and Aliases.
• Created User Objects including Dimensions, Details and Measures.
• Created reports on web using Info View Portal’s Web Intelligence and distributed the reports to different users.
• Created Dashboards and Scorecards using framework of application Foundation. Used Broadcast Agent for scheduling and distributing the documents.

Environment: Business Objects6.5, Business Objects 6.5, Webi 6.5,SQLServer, MS Excel, SQL, PLSQL, Windows NT/2000.

Confidential, St. Louis, Mo Aug’05 -- March’06 
Data Warehouse Developer

Responsibilities:

• Installation of Business objects 5.1 and installation of Web Intelligence server version 2.6. Involved in Creating Repository, Creating Users and User Groups.
• Designing and developing Universe for reports generation. Created over 80 Classes and more than 300 objects using equi-joins, theta joins, outer joins and short-cut joins based on user requirement.
• Resolved the loops, cardinalities by contexts and aliases and checked the Integrity of the Universe.
• Exporting the universe to the Repository to make resources available to the users.
• Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
• Created user objects including Dimensions, Details and Measures. Formatting the Reports to the Users requirements using all the requirements in Business objects like Slice and Dice, Drill Down, and Formulas etc.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way. Used the Doc Agent server to Schedule and Monitoring the Reports. Involved in production Support and gave training to the users.
• Extensively involved in writing PL/SQL stored procedures, database triggers. Also carried out performance tuning and optimization of critical queries using Explain Plans, Analyze etc.

Environment: Business Objects5.1, Business Objects Supervisor, Designer, Broadcast Agent, Web Intelligence, Oracle8.