SUMMARY

• 8+ Years of experience in all the modules of Business Objects Suite likes Web Intelligence, Desktop Intelligence, InfoView, Web Intelligence rich Client, Designer, Central Management console, Crystal Reports, Xcelsius, Dashboard manager, Broadcast Agent, Supervisor, Business Views.
• Expertise in SDLC including Requirement gathering, Analysis, Design, Development, Testing, Implementations and support.
• Proven track record of successful implementation of BO Reporting Lifecycle (Requirement gathering through implementation and enhancement).
• Experienced in Enterprise Data Warehouse/Data Mart environment utilizing Data Modeling. Excellent Knowledge of Star Schema and Snow Flake Schema Data Models.
• Proficiency in Oracle and SQL server database. Experience in implementation of Materialized views and Views to support reporting requirements.
• Extensive Experience in Creating, Designing, Building and Maintaining the Universes.
• Proven abilities in creating complex reports, Ad - hoc Reports and Charts by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries and merged dimensions.
• Expertise in Reports and Universe administration in CMC.
• Experience in Design of Security Structure and User Group access for Reports/ Universes in different environments
• Domain Expertise in Banking/Finance, Insurance, Telecommunication, Healthcare.
• Experience in ETL and Source to Target mapping between Data Warehouse and target data mart universe databases.
• Experienced in Implementation of Security Features of Business Objects like Row Level, Object Level and Report Level security.
• Proficient in unit testing, system integration testing (SIT) and user acceptances test (UAT) for universe, reports and security management.
• Excellent experience in creating Sub Reports, On Demand Reports, Linked Reports, Mailing Labels, Cross Tab Reports and Graphical Reports.
• Good Experience in Business Object products like Import Wizard and Report Conversion Tool.
• Experience in developing and maintaining Dependent/Independent data marts
• Proficiency in Creation of Dashboard, Score card and WebI Reports.
• Extensive Experience in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Enthusiastic and project-oriented team player with excellent communication and leadership skills and highly adept Confidential Multitasking.

TECHNICAL SKILLS

• Business Objects 4.0/XI3.1/XIR2/6.5.1/6.0
• CMC
• Designer
• Desktop Intelligence
• Web Intelligence
• WebI Rich Client
• InfoView
• Crystal Reports 2008
• Xcelsius 2008
• Dimensional Data Modeling
• MS SQL Server 2005/2008
• Toad
• Oracle 10g/9i
• ER Diagrams
• WebLogic
• SharePoint
• MS Office Suite
• MS Visio
• ERP
• Informatica
• Unix
• MS Access
• Windows 2000/XP/ Vista/ Windows7.

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn, NY

Sr. Business Object Developer

Responsibilities:

• Developed several Universes.Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate them to Technical specifications for Designing Universes.
• Created new and modified existing Hierarchies in the universes to meet Drill Analysis of the user’s reporting needs.
• Involved in performance tuning and optimization on Business objects Universes by creating Derived tables to denormalize the data.
• Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
• Implementation of row level security in the universe.
• Implementation of Materialized Views to denormalize the data.
• Performed Testing of the universe to validate all the changes.
• Documentation of technical specification and the changes made to the Universes and Reports for future references.
• Created different types of reports such as Master/detail, Cross Tab and Charts.
• Created graphical representation of reports such as Bar charts, 3D charts and Pie charts etc.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
• Used Alerts to draw attention to a particular block of data by highlighting it.
• Developed reports by linking different data providers in a single report, and made all possible incompatible objects as compatible by merging the common objects.
• Trained end users to use various functionalities of Business Objects and provided technical support.
• Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
• Performed unit testing of the reports and generated test cases for testing teams.
• Involved in UAT and SIT testing of the reports. Analyzed and addressed all the JIRA tickets raised while testing of the reports in SIT and UAT.
• Generated several Templates in both DeskI/WebI.Worked on the style guide for the reports to implement a standard style across all the reports in coordination with portal style guide.
• Provided technical assistance and production support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Reported all the issues in the data structure and ETL coding to ensure the right data delivery from the reports.
• Worked with ETL team and Data Modeling Team to ensure effective implementation of all the applications.
• Involved in the testing of the logical implementation of Test data for the new applications.
• Used BO SDK to address the complex requirements of reporting and scheduling.
• Implemented scheduling of the reports based on triggers and events.
• Created user roles, folders and security of the reports in CMC.

Environment: Business Objects 4.0 / XI 3.1 suite (Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, Designer, Info View, CMC, BO SDK), Crystal Reports XI, Xcelcius2008, Oracle 10g/11g, Toad, SharePoint, ETL (Informatica), Erwin, Unix, Mainframe, DB2, FoxPro, Windows NT, MS Office.

Confidential, Warren, NJ

Sr. Business Object Developer

Responsibilities:

• Involved in gathering, analyzing, documenting business requirements, functional requirements and data specifications for Business Object universes and reports.
• Used WebI rich client and Desktop Intelligence to create & analyze reports (thin & thick client reports) and used InfoView to publish reports to various groups.
• Created and modified the existing Universes by adding new classes with Dimension, Detail & Measure Object, prompts, and hierarchies based on the business requirement and tested them to ensure correct mapping of data.
• Created the reports using Business Object functionalities like Combined Queries, Slice and Dice Drill Down, Cross Tab, Master Detail, cascading prompts, Alerter etc.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables by defined hierarchies such as business and geography and using conditions Confidential the designer level.
• Used Prompts, Conditions to restrict the data returned by Query and Filters to restrict the unwanted data to be displayed on the report. Used Alerts to draw attention to a particular block of data by highlighting it.
• Implemented Security Features of Business Objects like Row Level, Object Level and Report Level.
• Generated the SQL queries for testing the reports.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Defined Aliases and Contexts to resolve loops in the universes.
• Exported universes and reports to the Repository to make resources available to the business objects users.
• Created Dash Boards for senior for senior executives for executives for business decision making.
• Scheduled reports through CMC andInfoView on a daily, weekly, monthly basis. Also, scheduled reports based on events.
• Trained and lead a team of 4 from offshore for reporting and documentation.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Trained end users to use various functionalities of Business Objects and provided technical support
• Involved in creating repositories and setting up of groups and users for Business Object users.
• Involved in testing and migrating Desktop Intelligence and Web Intelligence reports from one environment to another.
• Prepared Business/Technical Requirements, Development standards documents and detailed design documents

Environment: Business Objects XI 3.1 SP2 (Web Intelligence, Web Intelligence Rich Client, Desktop Intelligence, Designer, Info View), Crystal Reports XI, Xcelcius2008, Oracle10g/11i, SharePoint, ETL (Datastage 7.5), Windows NT, MS Office.

Confidential, Northbrook IL

Report Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the different insurance services for generating Business Objects Universes and Reports.
• Created complex reports using multiple data providers for processing insurance claims for customers.
• Created Desktop Intelligence, Web Intelligence Reports, Crystal Reports and deployed through Info View.
• Created custom reports like Gross Margin, Account Query, Income Statement, Bad Debt and Payment Reports in response to user needs.
• Designed, developed and managed Universes in Business Objects Designer for generating the revenue generation reports for sales.
• Exported the Universes from repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Extensive analysis to design the Universes and assign them to respective domains.
• Created Reports using command prompt, and written complex queries including Sub Queries.
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
• Created Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
• Scheduled reports on a daily/weekly/monthly basis using Broadcast Agent Server.
• Automated Reports scheduling using Central Management Console.

Environment: Business Object XI 3.1 /6.5, Crystal Reports 10/9.0, Crystal Enterprise 10/9.0, SAP 3.5, Sap R/3 4.6c, Windows NT, SQL server 2000

Confidential, Dallas, TX

Business Object Developer

Responsibilities:

• Created Simple and Complex Reports using Universe and other data providers based on the requirements and exported to enterprise repository in order to make reports accessible through Info view.
• Used Business Objects Developer Suite (Desktop Intelligence, Web Intelligence Designer, and InfoView) to perform various tasks specific to every component.
• Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers.
• Created Universes for various functional areas of high level reports group. Created the joins strategies while designing the universes.
• Created reports like Residential and Business Customers reports, Service charge validation Reports, Billing reports etc
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Created different universes which contain the information about the customer like customer name, address, phone number, plan used, minutes used, minutes remaining, rollover minutes etc.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Worked on Business Objects Administration like CMC and CMS maintenance & security issues
• Exported the universes to the Repository making resources available to the users.
• Created reports according to different cell phone plans like individual plan, family plan, and family time plan.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Involved in requirements gathering from the business users to build the reporting application.

Environment: Business Objects 6.1B, Designer, Desktop Intelligence, Web Intelligence oracle 8/9i, DB2, Crystal Reports, Windows 2000

Confidential, Louisville, KY

Business Object Developer

Responsibilities:

• Created universes, universe objects, classes, applied filters, pre-defined and complex conditions.
• Worked extensively on CMC, Designer, Web Intelligence and Info view
• Created fully functional Full client and thin client reports by making use of Business Objects functionalities.
• Used Personal data files, free-hand SQL, Combine Queries and aggregate awareness in universes.
• Created reports using BO functionalities like, Drill Down, Cross Tab, Alerter and Formulae.
• Created Dashboards using Dashboard Builder and Dashboard universes with metrics.
• Implemented object level security in universes to in corporate security for sensitive information.
• Implemented various levels of user profile rules - Folder level or view only access.
• Used WebI to create & analyze reports and used InfoView to publish reports to various groups.
• Created standard, summary reports in Crystal reports and also using PL/SQL, crystal sub reports, and reports with prompts, multiple groups, parameter fields and crosstab reports.
• Migrated Crystal reports to the server and scheduled using InfoView.
• Developed reports using WEBI, DESKI as well as Crystal Reports.
• Designed Data model for Data Warehouse using snowflake schema, star schema.
• Generated complex reports involving numerous prompts, open document functions and data through multiple data providers.
• Extensively used extended syntaxes and complex formulae.
• Formatted Reports as per User requirements using functionalities in BO, which allows the users to analyze data.
• Edited Joins, resolved loops using aliases and contexts in the universe and exported to repository.
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible through Infoview.
• Responsible for support issues with reports on Business Objects Enterprise environments (Development, Test, Integration and Production).
• Involved in writing detail level documentation and migration of reports as well as universes to production.

Environment: Business Objects (6.5/XI R2), Web Intelligence, Broadcast Agent, Oracle 8i, SQL Server 2000, MS Office, Windows NT/2000, Crystal Reports XI.

Confidential

Jr. Business Object Developer

Responsibilities:

• Created universes, universe objects, classes, applied filters, pre-defined and complex conditions.
• Worked extensively on CMC, Designer, Web Intelligence and Info view
• Created fully functional Full client and thin client reports by making use of Business Objects functionalities.
• Created reports using BO functionalities like, Drill Down, Cross Tab, Alerter and Formulae.
• Used WebI to create & analyze reports and used InfoView to publish reports to various groups
• Designed Data model for Data Warehouse using snowflake schema, star schema
• Generated complex reports involving numerous prompts, open document functions and data through multiple data providers
• Edited Joins, resolved loops using aliases and contexts in the universe and exported to repository
• Responsible for support issues with reports on Business Objects Enterprise environments (Development, Test, Integration and Production)
• Involved in writing detail level documentation and migration of reports as well as universes to production
• Interacted with the end users for requirements, training and production support.

Environment: Business Objects 5.1.5, Informatica, Web Intelligence, SQL Server 2000, MSOffice, Windows2000