Resume of Business Objects Admin/Developer




Title
Business Objects Admin/Developer

Primary Skills
Business Objects XI,6.5and 5,Crystal report, Sql, Oracle db, sql server, C++,C, CRM

Location
US-GA-Alpharetta (will consider relocating)

Posted
Jan-18-08

RESUME DETAILS
Experience and Skills Set:

1. Over 6 Years of experience in IT industry with 5 plus years in Business Intelligence Reporting, Data modeling, Design, Development, Implementation and Testing of Database/ Data Warehouse/Client/Server/ Legacy applications for Banking, Pharmaceutical, and Telecom industries.
2. Complete project life cycle (SDLC) experience in various projects.
3. Expertise in all modules of Business objects suite (BO Reporter, Supervisor, Designer, WebI, Info view, and Broadcast Agent).
4. Experience in designing and developing the “Universe” (business view of the database), designing canned/ad-hoc reports, scheduling the processes using Broadcast Agent and administering the BO activities.
5. Exceptional experience in dealing with various databases like Oracle, Teradata, SQL Server, MS Access, and Flat files.
6. Efficient in Optimizing, Debugging and testing SQL queries, views and Stored
procedures written in Oracle and SQL Server.
7. Proficient in business process documentation and end-user training/knowledge transfer.
• Proven ability to complete multiple assignments simultaneously and maintain high standards at client organizations.
8. Willing to learn and master new concepts and technologies.
9. Outstanding ability to communicate and work within a diverse team and independently.
10. Good communication skills, strong decision making skills, organizational skills,
excellent analytical and problem solving skills.

Technical Experience:


Business Intelligence Reporting Tools Business Objects version 5.1.6, 6.1.a, 6.5.1 and XI(Designer, Reporter, Supervisor), BCA Scheduler and Publisher, Auditor, Business Miner, Business Query and Document Agent Server, Web Intelligence and Info View, Crystal Reports 2.5.
RDBMS/Databases Oracle 7.x/8i/9.i (SQL, PL/SQL, Stored Procedures, Triggers), SQL SERVER, DB2 and MS Access.
Languages SQL*Plus, PL/SQL, UNIX Shell Scripts, HTML, DHTML, C, C++, VB 5.0/6.0, Java.
Web And Application Servers IIS, Apache, Tomcat, Websphere 5.1
Operating Systems MS-DOS, UNIX (Sun Solaris, LINUX), Windows NT2K/98/95
Data Modeling Erwin 3.5.2, 4.0
Tools TOAD, Erwin, Rapid SQL,UNICA

Client: Cox Communications, GA (July 2007 -- Present)

Description: Design Universe and build web intelligence reports for Campaign Management. Corporate reports are exclusively designed for higher management and Site reports are designed for site users.

Role: Senior Business Objects Developer (Business Objects XI)

Responsibilities:
• Design and maintain Universe
• Design Web Intelligence reports
• Created Complex reports.
• Train users to use the tool and create Ad-hoc business objects reports (With my own documentation)
• Conduct gap analysis for the business requirements
• Test UNICA application.
• Designed security model for users to access the reports
• Involved in the complete Data Warehouse design process.


Client: Mirant Corp, GA (September 2006 -- June 2007)

Description: Administrate Business Objects and Crystal Enterprise. Develop reporting solution to work effectively against Oracle db.

Role: Business Objects Architect/Senior Business Intelligence Admin (Business Objects XI, Crystal 9 and Business Objects 6.5)

Responsibilities:

• Installation and Configuration of Business Objects XI along with performance manager.
• Design Universe
• Maintained multiple Universes.
• Administrating Business Objects and Crystal Enterprise
• Design complex Crystal, Web Intelligence and Desktop Intelligence Reports
• Train users to use the tool and create Ad-hoc business objects reports (With my own documentation)
• Plan the implementation of migration to Business Objects XI.
• Develop Dashboards for the higher management of the company.
• Designed security model for users to access the report
• Set up LDAP and NT authentication for Crystal and Business Objects users.
• Involved in the complete Data Warehouse design process.



Client: Cingular Wireless, GA (April 2006 -- September 2006)
Description: Project involves the design, development and maintenance of Business Objects Universes to enable business analysts to improve the performance of the IVR system.

Role: Business Objects Architect/Business Objects Developer/Admin (Business Objects XI and Business Objects 6.5)

Responsibilities:

• Responsible for Maintenance & Support of IVR (Interactive Voice Response) System reports and Universe.
• Colleting Requirements from the IVR team, Analyzing, Documenting, Building, exporting Universe to Repository, building OLAP and Crystal reports in Info view and testing reports.
• Responsible for the data quality in IVR reports.
• Scheduling the reports through CMC, Monitoring and Converting Reports to PDF.
• Installed and configured Oracle & Business Objects Products for IVR report users.
• Created different types of reports like Master/Detail, Cross Tab and Chart Using WEBI XI and Crystal Reports XI. Used Slice and Dice and Drill down. As a part of report development created the reports using universes as a main data provider and using the Powerful business objects functionality's like @ functions, user response and formulae's.
• Used Prompts in reports to create more interactive reports for the Users.
• Established user groups and users and assigned privileges.
• Production Support and gave training to the Users on how to generate the reports using WEBI XI and Crystals Reports XI.
• Train users to use the tool and create Ad-hoc business objects reports (With my own documentation)
• Involved in the complete Data Warehouse design process.




Client: Bank Atlantic, Fort Lauderdale, FL (May 2005 -- Feb 2006)

Description: Project involves the design, development and maintenance of Business Objects Universes and Reports to enable various portfolio analysts to analyze the markets, execute trades and to buy/sell stocks, bonds, loans and credit derivatives.

Role: Business Objects Architect/Developer (Business Objects 6.5 and Business Objects 5.1)

Responsibilities:

• Worked with the business analyst team to interview the business users and capture simple, moderate and complex business requirements. Collaborated with business technicians to research existing business and system processes.
• Responsible for analyzing business requirements and developing queries and reports using BO full client and info view to provide Web-enabled data analysis solutions to business clients.
• Worked extensively on modules Supervisor, Designer, Web Intelligence, Business Objects and BCA.
• Extensively used designer to design various universes for different business groups.
• Created Objects, Predefined Conditions, Joins in the Universe.
• Applied aggregate awareness to speed up query time.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity of the Universe.
• Created reports using Business Objects using functionalities like slice and dice, drill down, @functions, cross tab, master/detail tables, formulas and etc.
a. Designed reports with complex variables, multiple breaks, and sorts to meet the user requirements.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
• Created complex reports using cascading prompts, decode objects and etc.
• Extensively used breaks for white spaces and sections for better navigability.
• Successfully completed many reporting applications using Business Objects Suite.
• Involved in migration and deployment of the universes and reports across multiple repositories.
• Involved in a huge migration effort that included conversion of Access reports to BO Created and maintained Enhancement, Bug tracking and Bug fix documents.
• Used WEBI infoview to open and display documents, traverse a category hierarchy, create, rename and delete categories, get the details of a category, add and remove documents to and from a category.
a. Trained the power users/end users in Business Objects.



Shell Petroleum, Houston, TX. (Nov 2003 -- March 2005) Praveen

Description: Build Cost Management and Time Keeping reports against SAP R/3 application.

Role: Business Objects Developer/Admin (Business Objects 6.5 and Business Objects 5.1)

Responsibilities:

• Assisted clients to provide reporting solution and develop/maintain universes against their Simon Data Warehouse and SAP R/3 using Webi, Business Objects and Designer.
• Working on a very complex report with 10 sections in one report and 6 tables in each section using Webi 6.1a.
• Installed and configured Business Objects 6.1a client/server products Designer, Supervisor, Broad Cast Agent, Web Intelligence (Webi), InfoView Portal, Application Foundation and Set Analyzer
• Created number of variables to link each report from Summary level to Transaction Detail
• Updated existing Universes as per business requirement and changes made to the database.
• Assisted clients to upgrade from v5.1.6 to 6.1a
• Provided support to the user's group and maintaining Universes and reports.
• Enhanced and made necessary changes to the existing reports with current version of Business Objects (V6.1a).



Client: National Penn Bank, BOYERTOWN, PA. (Feb 2003 -- Sep 2003)

Description: This project was mainly related to “Home equity loans”, “Penn Securities”, “Personal & Business Loans”, “Cash Management”. Data existed from different customers has to be executed in various formats for the Business Analysis.

Role: Team Lead/Business Analyst/Developer

Responsibilities

• Gathered the Report Requirements from the users and created the Universes and Reports.
• Defined Cardinalities and checked the Integrity of the Universes.
• Designed the Universes, created Contexts and Aliases for resolving Loops in the Universes.
• Extensively used Decode statements, and Designer Functions like @Aggregate Aware (), @Prompt, @Date, @Select, @Where etc.
• Created Documents both (full client and Web I), summary and detail with the functionality of Drill down to detailed document.
• Extensively used Calculations, Variables, Breaks, Sorting, Drill Down, Slice and Dice, Alerts for creating Business Objects Reports.
• Created Objects to Drill Down from Count (measure) to dimension objects
• Provided Object level security using table mapping and used derived tables and defined the prompts at table level.
• Scheduled Business Objects Reports through Broadcast Agent and monitored scheduled reports through BCA console.
• Documented the Universe design and Reports development. Trained the end users in ad-hoc Report Development and participated in Production Support.
• Web Intelligence was used for web-based query and reporting.


Client: Snap-On, Inc, USA. (Dec 2001 -- Jan 2003)

Description: This is a rapid development project team, which delivered a comprehensive data warehousing and OLAP Financial reporting. Project is a warehouse and reporting solution that provides the primary customer interface for a newly created Operational and a manufacturing system, and was developed under tremendous schedule pressure, at half the cost/report of comparable projects, by a multidisciplinary team of thirty people. The very large-scale data warehouse allows the customer to provide reporting and Forecasting via direct linkages to operational (e.g. manufacturing systems) providing far more accuracy and timeliness of information than previously available. Reporting team is responsible for developing complex reports for business analysts. As a part of the project, the Business Object's Universe, queries and reports were created for various user groups.

Role: Business Objects Developer

Responsibilities:

• Used Business Objects designer to create Universes, classes, and objects.
• Formatted reports using Slice and Dice, Drill Down, @Functions and formulas depending on user requirements for both end-users and executive committee members.
• Created various adhoc and canned reports using Business objects.
• Generated reports with Universes created in Business objects Designer as the data providers with various functionalities that displayed data even in a graphical Format.
• Maintaining the existing BO applications and providing User Support includes; resolving Data/Repository access problems, helping them in creating ad-hoc reports using the available BO functionality.
• Requirements gathering and analyzing potential data sources.
• Defined reporting requirements to developers.
• Exported reports to Document Agent server.
• Used document agent server to schedule and monitor reports. Performed various levels of scan and repair repository in order to obtain maximum efficiency and optimized level.
• Created Multi-Dimensional Cubes and Reports as per the User Requirements.
• Reporter Operations such as Sum and Average, Intersection, etc.
• Drilling down, Slice and Dice, Filter Change Displays.
• Employee Charts (Converting Reports to Excel spreadsheets).
• Customized data by adding calculations, summaries and functions.
• Documented the entire work done.

Certifications
See above

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


View all resumes in US-GA-Alpharetta »
View all resumes in US-GA »

View other Business Objects Admin/Developer resumes, Programmer / Developer resumes