Business Objects
Senior Developer - Designer - Analyst

Professional Summary

• 5+ years of experience in Business Objects XI 3.1/6.x, Business Objects Designer, Info View Web-Intelligence, Central Management Console, Desktop Intelligence, Supervisor, Application Foundation, Dashboard Manager, Crystal Reports, Java,Performance Manager and Broadcast Agent.
• Extensive experience covers areas of software engineering such as relational database management systems and Software engineering principles.
• Proficient in using Oracle 10G/9i/8i, DB2, MS SQL Server, SQL, PL/SQL, Sybase MS Office.
• Excellent in writing/customizing Visual Basic macros.
• Excellent communication and technical documentation skills.
• Expert in Web intelligence Enterprises.
• Good Experience in different web technologies.
• Full project management and development life cycle experience
• Excellent understanding of ETL processes and data conversion methods.
• Very good understanding of Data Warehouse Architecture and Designing.
• Strong presentation and interpersonal skills

BO client/server Tools

Business Object suite XI 3.1/6.x, Web Intelligence, Central Management Console, Designer, Desktop Intelligence, Application Foundation, Dashboard Manager, Performance manager, Crystal Reports, Supervisor and Broadcast Agent.

Operating Systems

UNIX, Linux (Red hat), Windows 9.X/NT/2k/XP

Databases

Oracle 10G/9i/8i, DB2, MS SQL Server 2000, MS Access 2003, Sybase

Languages

C/C++, Java, J2EE, PASCAL, COBOL, FORTRAN, SQL, PL/SQL , Visual Basic

Scripting Languages

UNIX Shell Scripting, PERL,CGI

Tools & Servers

MS Access Reports, MS FrontPage 2000, Adobe Dreamweaver, Adobe Fireworks, Tomcat Server, Apache server, Toad, SQL plus, MS Office

Web Technologies

HTML, DHTML, XML, VBScript, CSS, JavaScript

Data Modeling

Star-Schema Modeling, Snowflakes Modeling, Fact and
Dimension Tables.

Client Projects:

Confidential, Princeton, NJ Apr 2007 - Current

Confidential, is committed towards innovative specialist research in imaging agents for diagnostic medicine. Reports are created to view the sales and financial information.

• Interacted with Business Users, to know their Business views in developing and modifying Universes and Reports accordingly.
• Converted BO 6.5 Full Client reports to Web-Intelligence XI 3.1 and resolved all migration related issues.
• Built Business Objects universes from scratch by identifying the required tables in database and by defining the universe connections to the database.
• Used Derived tables to create Universe for best performance, and used context and alias tables to solve the loops in Universe.
• Created classes and complex objects using Decode and Case statements and various date and character functions in Universe.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Tested the classes, objects, predefined conditions and table joins by using Check Integrity function.
• Created row level security in XI 3.1 Universes.
• Exported Universes to the Repository to make resources available to the users for ad-hoc reporting needs.
• Refreshed Universe structure when the database tables get updated with new columns.
• Created many WEBIXI 3.1 reports for the Finance department.
• Generated WEBIXI 3.1 reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Generated DESKI 3.1 andWEBIXI 3.1 reports involving complex queries, sub queries, Unions and Intersection.
• Created complex WEBIXI 3.1 reports using multiple data providers and synchronized the data providers by linking the common objects.
• Created Filters and prompts to improve WEBIXI 3.1 report generation.
• Developed DESKI 3.1 andWEBIXI 3.1 reports with complex functionalities like drill down, master/detail, crosstab, Alerters, Ranking and Grouped Variables.
• Created various report level objects using complexformulas containing date, character, numeric and dataprovider functions.
• Created WEBIXI 3.1 graphical reports according to user requirements.
• Created DESKI 3.1 andWEBIXI 3.1 reports using free hand SQL.
• Scheduled WEBIXI 3.1 reports to be distributed to user Web-Intelligence inboxes on a daily, weekly and monthly basis.
• Created Analytics using Application Foundation.
• Created Metrics and conditions for use in Analytics.
• Updated Metric Universes as per requirements.
• Added and defined Metric parameters in Dashboard Manager.
• Scheduled Metrics to be refreshed daily.
• Created security commands using Apps Security and restricted tabs in Dashboard as per user requirement.
• Created Dashboards in Application Foundation with multiple tabs and sub-tabs.
• Purged and refreshed Metrics on a monthly basis.
• Rebooted Business Objects server on monthly basis and conducted server maintenance.
• Created document and universe domains in Supervisor.
• Provided security access management by creating users/groups and folders
• Provide end user support and problem resolution for various issues related to Business Objects reports.
• Responsible for installing Business Objects in user computers.
• Worked in a team of 3 BO developers and were responsible for closing 100 Business Objects tickets, consistently every month.

Environment: Business Objects XI 3.1/6.5.1, Designer, Web Intelligence, Supervisor, Broadcast Agent, Central Management Console, Desktop Intelligence, Application Foundation, Dashboard Manager, Performance Manager Oracle 8i/10G, PL/SQL, Windows XP.

Confidential, San Jose, CA May 06-Dec 06

Confidential, is the leading supplier of networking equipment & network management for the Internet. Products include routers, hubs, Ethernet and other networking equipment. The application aims at automating deals. Reports are created to view the Potential Bookings and financial information. Several adhoc reports were created to extract the financial information and information concerning the markets worldwide.

• Interacted with Business Users, to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in the designing and building of Universes, Classes and Objects.
• Created reports with drill functionality, breaks, sorts, sections, crosstab, filters and prompts.
• Created reports with objects having complex formulas.
• Created filters to aid in creation of analytical reports.
• Created objects having complex formulas in the universe.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Cross Tab, Master Detail, Formula etc.
• Built Full Client and WebI reports, according to end user requirements.
• Created and tested classes and objects in the Universe.
• Was responsible for conducting multiple training sessions in order to train users to use the new enhanced universe and create reports using that universe.

Environment: Business Objects 6.5.1, Designer, Supervisor, Broadcast Agent, Web Intelligence, Oracle 8i, PL/SQL, Windows NT.

Confidential, Indianapolis, IN Sep 05-Apr 06

Confidential, and Company is a leading, innovation-driven corporation committed to developing a growing portfolio of pharmaceutical products that help people live longer, healthier and more active lives. The application aimed at collecting results for the various experimental studies that were performed on animals for use in the making of new pharmaceutical products. Reports were made to facilitate the end user to extract detailed as well as summarized information on the various experimental studies. Reports were also made to track the status of the various tests.

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in the designing and building of Universes, Classes and Objects.
• Created and edited derived tables.
• Created filters to aid in creation of analytical reports.
• Created objects having complex formulas in the universe.
• Created the reports using Business Objects functionality's like Queries, Slice and Dice, Cross Tab, Master Detail and Formula etc.
• Built Full Client and WebI reports, according to end user requirements.
• Led a team of six people in developing and testing the various reports.
• Created and tested classes and objects to organize the Universe.
• Resolved 200 complicated defects in existing reports.
• Created prompts for the reports.
• Scheduled Business Objects Reports using Broadcast Agent.

Environment: Business Objects 6.5.1, Designer, Supervisor, Broadcast Agent, Web Intelligence, Oracle 8i/9i, PL/SQL, Windows NT/Unix.

Education:

MS (Masters in Computer Science)
BE (Bachelors in Computer Science and Engineering)