SUMMARY

• 7+ Yrs of Experience in complete Software Analysis, Design, Development, Quality Assurance and Implementation.
• Extensive experience in Business Objects, Crystal Reports and Xcelsius.
• Good knowledge and experience in choosing and applying efficient software methodologies.
• Very Good problem solver and solution provider and ability to work in a fast - paced, fluid, complex environment.
• Interacted with business users to gather requirements.
• Excellent written and verbal language skills.
• Generated DeskI reports, WebI reports using Business Objects.
• Gained expertise in using Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports
• Experienced in developing Dashboards, Pixel Perfect Reports using SAP BO - Crystal Xcelsius.
• Experience linking Crystal Xcelsius to Business Objects Universe using LiveOffice and QaaWS (Query as a Web Service).
• Strong experience of designing, building, testing, documenting the Universe.
• Experience in creating Universes from wide variety of databases with measures and dimensions objects, joins, conditions, Filters, LOV, cardinality, Resolving join path problems like Loops and Traps in the universes using Aliases, Contexts, Aggregate Awareness in Business Objects Designer
• Created cascading list of values to enable cascading prompts in the reports using Designer.
• Strong experience in Installation, configuration, migration, maintenance, troubleshooting, scheduling, publishing, security and overall administration of the Business Objects Enterprise.
• Have experience in using Business objects administration tools(Central Management Console (CMC), Central Configuration Manager (CCM), Central Management Server (CMS), Import Wizard, Publishing Wizard, and Report Conversion Tool)
• Vast experience using Oracle 11g/10G/9i/8i, Microsoft SQL Server 2008/2005/2000 , DB2 databases.
• Have in-depth understanding of Data modeling concepts and expertise in designing the data warehouse using star/snow-flake schema and dimensional modeling, and creating Business Objects Repositories.

TECHNICAL SKILLS

Reporting Tools: Business Objects XIR4.0/XIR3.1/XI3.0/XIR2/XIR1, InfoviewWebI, WebI Rich Client, Liveoffice, QaaWS(Query as a web service), Crystal Reports 10/XI/2008, Xcelsius 2008/4.5, Designer, Import Wizard, CMC, CCM, Publishing Wizard and Report Conversion Tool.

Databases: Oracle 10g/9i/8i/8.0/7.x, Microsoft SQL Server 2008/2005/2000 , DB2.

Languages: SQL, PL/SQL, C, C++, HTML.

Operating Systems: UNIX, Linux, Windows 95/98/NT/2000/XP/7 and MS DOS.

Web Servers: Apache/Tomcat, IIS, Websphere.

Other Tools: Microsoft Office, TOAD, SQL Management Studio.

PROFESSIONAL EXPERIENCE

Confidential, Perrysburg, OH

Sr. Business Objects Consultant

Responsibilities:

• Involved in gathering the requirements from Business Users to capture the Candidate Objects. Analyzed these requirements and prepared Technical Specifications Document for Business Objects Universe and Reports.
• Worked with the team for Migrating BO versionBO XI 3.1 to BO XI 4.0. Worked on installation and configuration of BusinessObjectsXI Enterprise Suite (Desktop Intelligence, Central Management Server, Central Management Console, Auditor, and Dashboard Manager).
• Created mock -up reports for initial user presentation in the process of designing Technical Specifications.
• Designed and modified the Universes, which suits the standard, analytical reporting requirements of the business users using BO XI Designer application.
• Analyzed the existing database schema, retrieved the Fact and Dimension tables and created Joins as identified in the Universe design.
• Defined Cardinalities on tables manually in the universe and resolved the loops using Aliases and Contexts
• Created new Classes, Sub-classes and Objects as per the standards that were put in place during the Strategy process and identified Objects as Dimensions, Details or Measures.
• Created List of Values (LOV’s) and custom Hierarchies to support drilling functionality for in depth analysis in reports.
• Involved in the migration of Universes/Reports from Development to Test environment and finally into Production environment after UAT (User Acceptance Testing) using Import Wizard.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report.
• Created Templates to customize style and structure of the canned reports to maintain company standards.
• Reports were formatted according to the user requirements using different functionalities like Breaks, Sorts, Sections, Filters and Calculations.
• Prepared many critical WebI reports by using master detail and drill mode on tables and graphs as per the requirements of the end-user.
• DevelopedXcelsius 2008Dashboards on top of Qaaws and Live Office connections.
• Expertise in creating Linked reports using Open Document function to link Parent document to Target document.
• Automated the Business Unit Performance WebI reports refreshing every month.

Environment: Business Objects XI 4.0/XI 3.1, Web Intelligence, Designer, Universe Builder, Business View Manager, Desktop Intelligence, Crystal Reports 2008, Xcelsius 2008, Live Office, Import Wizard, Central Management Console, Info view, Data Services XI 3.2, SQL Server 2008, ORACLE 10g, Broadcasting Agent.

Confidential, Atlanta, GA

Sr. Business Objects Consultant

Responsibilities:

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Managed existing Universes, created Classes, Objects and applied Hierarchies based on Business logic
• Created Contexts and Aliases for resolving loops and checked the Integrity of the Universes
• Generate pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard
• Created complex reports using aggregate awareness functions for SQL enhancement
• Generated Ad-hoc reports using Business Objects free hand SQL Debugging production issue on the existing reports
• Cross checking the different reports to make sure all reports reflect the correct data
• Creating proper documentation as there were no documentation available before
• Generated reports for web users using Web Intelligence.
• Formatted the reports as per the business requirements.
• Involved in Importing/Exporting the Universes to repository to make it available to the users
• Used Web Intelligence for web based query and reporting.
• Scheduled the reports to be emailed to end users daily in PDF and TXT formats from Info view
• Trained the users in viewing/scheduling the reports using the Info view
• Creating customized dashboard model using Xcelsius 4.5 and 2008.
• Creating customized charts as per customer requirements using Xcelsius.
• Creating customized Xcelsius models using Excel / XML / Flash variables / Live Office / Qaaws.
• Creating complex models and publishing to Business Objects Enterprise.
• Exporting the models to different applications like PowerPoint / PDF / Word etc.
• Trouble shooting or customizing the models according to the Business requirements.
• Creating a Technical Escalations and passing on the bugs in the product to the product development team.
• Installation of the Crystal Report Server / Business Objects Enterprise.
• Installations of service pack and fix packs.
• Administrating the user privileges.
• Managing the reports at Centre Management Console.
• Managing the report at the InfoView.
• Managing Business View Manager with user rights.
• Creating Universe and creating crystal reports of a universe.
• Creating a Web-intelligence reports / Desktop-intelligence reports for the users.
• Migrating the reports from one server to another server using Import Wizard tool.
• Deploying all the reports to the users.
• Publishing the reports to the enterprise.
• Scheduling the reports with different destinations and different formats.
• Managing the Repository objects (Security).

Environment: Business Objects XI R3 (CMC, Designer), Web Intelligence XI R3 (Info view), NOAD-EQMSql Server 2008, PL/SQL, TOAD, ETL, Windows2000/ XP.

Confidential, Dallas, TX

Business Object Report Developer

Responsibilities:

• Involved in gathering and documenting Business Requirements and Technical Specifications.
• Involved in the designing and Building of Universes, Classes and Objects.
• Created Universes for report generation using Designer module in Business Objects. As a part of Universe development, created Classes, different kinds of Objects, define Cardinalities, Strategies.
• Resolved the loops using Aliases and Contexts. Check the Integrity of the Universes.
• Exported the universes to the Repository to making resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.
• Installed and configured Business Objects 5.1 products with Web Intelligence.
• Performed ad-hoc queries to fetch new data, and create reports in Business Objects 5.1 by connecting to Oracle.
• Built OLAP reports on data warehouses.
• Architected Universes using Business Objects Designer.
• Use the slice and dice feature, set variables, and set alerts and group values in a report.
• Built queries to retrieve data through a universe and set up query conditions.
• Created, managed and formatted standard reports, master/detail reports and cross tab reports using Report Manager.
• Created Charts and formatted them for data analysis in Drill Down/up mode.
• Worked extensively on Designer and Supervisor modules of Business Objects.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Involved in setting up Groups and Users for Business Objects deployment, organizing and changing User properties using Business Objects- Supervisor.
• Created, maintained and modified the business complex reports using the Business Objects Reporting Module.
• Created the reports using Universes as a main data provider and using the Powerful business objects functionality’s like @ functions, user response and formulas.
• Designed Business Objects repository for building a Business Objects solution.
• Created standard Templates to make reports have a same look.
• Use of Filters and Conditions, Slice and Dice.
• Designed reports for sales and marketing department for predicting future sales using Business Objects, VBA.
• Used Visual Basic Application (VBA) tool to access external data.
• Designed parameter based reports using VBScript.
• Involved in production Support and gave training to the users.
• Programmed Transact SQL procedures for business objects.
• Developed PL/SQL programs for printing business reports.

Environment: Business Objects XIR2, Infoview, Crystal Reports XI, Performance Management, Xcelsius 4.5, Toad, SQL, PL/SQL, Oracle 9i, MS SQL Server 2005.

Confidential

Senior Software Engineer

Responsibilities:

• Migrated and upgraded Business Objects XI R2 reports to Business Objects Enterprise XI R3.1.
• Used Import wizard to import existing user accounts, groups, categories, universes, reports, connections and universe restrictions to BO XI R3.1 environment.
• Designed new Universes using different data sources.
• Created Classes and Objects for management system based on the warehouse schema in Universe.
• Implemented Cardinality settings, Joins, Conditions and Global Filters in Universe.
• Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods.
• Created Dashboard Templates with Visualization for different group’s usage for their Best Practices, using Xcelsius 2008. Designed Visualizations for Operational and Financial groups.
• Exported universes to the Repository for making resources available to the users from various groups.
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports
• Involved in scheduling of documents monthly, weekly and daily through Broadcast agent console.
• Created various complex reports using Crystal Reports.
• Creating dashboards using Crystal Xcelsius and performance management.
• Connecting to the different databases like SQL Server / Oracle / Sybase etc.
• Creating different kinds of reports like Standard reports, mailing label reports, Cross Tab reports.
• Creating complex formulas.
• Creating sub-reports.
• Creating different kinds of charts.
• Creating dynamic cascading parameter
• Creating static / dynamic- parameters
• Publishing the developed report to the repository.
• Formatting the reports with conditional formatting or non-conditional formatting.
• Writing commands at the crystal reports level.
• Trouble shooting of various issues faced by customers.
• Creating different complex report as per the customer requirements.
• Inserting summaries’ and running totals using default crystal option.
• Creating manual running total formulas.
• Applying Row Level / Column Level security through crystal reports.
• Exporting the reports to various formats like PDF, Excel and Data Definition etc.
• Creating data connection to the database.
• Creating a dynamic data connection to the database.
• Creating a data foundation.
• Creating a business element.
• Creating a business view.
• Creating a list of values for the report (Dynamic parameter)
• Setting up of user right business views.
• Applying row level security and column level security using BVM.
• Creating filters at data foundation and business element level.

Environment: Business Objects XI R2, Broadcast Agent, Infoview, Crystal Reports XI, Xcelsius 4.5, Performance Management, Dashboards, Toad, SQL, PL/SQL, Oracle 8i, Windows 2000, MS SQL Server 2000.

Confidential

Technical Associate

Responsibilities:

• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries, Sub Queries.
• Applied row level and object level securities on different groups and users.
• Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
• Use the slice and dice feature, set variables, and set alerts and group values in a report.
• Built queries to retrieve data through a universe and set up query conditions.
• Created Cross-tab and Master Detail reports in Business Objects.
• Creating complex reports using features like slice and dice, Drill capabilities, Functions and Cross Tab tables with multiple breaks.
• Used alerts to highlight critical data based on business conditions.
• Created various MTD, YTD and daily reports.
• Extensively used Calculations, Sorting, Rank, Drill, Slice and Dice.
• Created classes and objects and logically grouped them together and defined business names for the classes and objects.

Environment: Crystal Report / Business Objects Enterprise, SQL Server 2000/2005, Oracle 9i/10g, MS Access 2000 / 2003, Windows XP / Windows 2003 Server.