We provide IT Staff Augmentation Services!

Sr.business Objects Developer Resume

VA

SUMMARY:

  • Over 6 years of experience in Information Technology with strong work experience as Business Objects Developer.
  • Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
  • Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) and its deployment.
  • Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
  • Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
  • Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
  • Excellent data - analysis skills and ability to translate specifications into a working Universe and/or Report.
  • Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
  • Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
  • Installation and configuration of Xcelsius, QaaWS Client Server Modules and designing complex reports and dashboards in monitoring business metrics.
  • Hands-on experience in developing Analytical Dashboards using Xcelsius with QaaWS and Live Office connectivity.
  • Experience in Migrating Business Objects from one version to another.
  • Experienced in & Supporting end-user reporting needs using Business Objects.
  • Strong database experience in using Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access.
  • Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
  • Exposure to Dimensional Data modeling- Star Schema modeling and Snowflake modeling.
  • Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
  • Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
  • Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

TECHNICAL SUMMARY:

Business Objects Tools: Business Objects XI 3.1/3.0, XI R1/R2,6.5, Web Intelligence XI 3.1/3.0/XI R2, Universe Designer XI 3.1/3.0,XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report Conversion Tool, Data Integrator 11.5/XI 3.0, Xcelsius 2008, Query as a Web Services(QaaWS), Live Office.

Databases: Oracle 10g/9i/8i/8.0, MS SQL Server 2008/2005, MS Access, Siebel, Sybase, Teradata, Informix.

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95, DOS, UNIX.

Windows Utility: MS-Word, MS-Excel and MS-PowerPoint.

Programming Languages: SQL, PL/SQL, JAVA, HTML, C, C++, C#, .NET

Dimensional Data Modeling Tools: Dimensional data modeling using Erwin modeling (Erwin 4.1/4.0/3.5.5/3.5.2 ), Physical & Logical Data Modeling, multidimensional modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques), Erwin, Visio.

Query Tools: TOAD, SQL*PLUS, SQL*Loader, SQLNavigator.

EXPERIENCE:

Sr.Business Objects developer

Confidential, VA

Responsibilities:

  • Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.
  • Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
  • Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts .
  • Participated in the complete development lifecycle: analysis, design, build and test reports
  • Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance .
  • Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
  • Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report . Extensively used Calculations, Variables, User Objects in the creation of reports.
  • Created User Prompts, Conditions and Filters to improve the quality of report generation.
  • Scheduled Reports using scheduler Infoview as well as CMC .
  • Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’ spanning across different subject areas has been re-created using Xcelsius.
  • Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
  • Providing support for the users on application usage and conducting walk through of salient features of the application .

Environment: Oracle 10G, Business Objects XIR2, Web Intelligence and Infoview XI R2, Desktop Intelligence, CMC, Import Wizard, Universe Designer, Java script, PL/SQL Developer, Windows 2003 advanced server.

Sr. Business Objects Developer

Confidential, VA

Responsibilities:

  • Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Working on the SQL tuning and optimization of the Business Objects reports.
  • Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
  • Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
  • Exported the ad-hoc ready universes to the for making semantic layer available to the users.
  • Extensively used the @functions and Aggregate Aware feature. Worked on back end views , tables required by the business objects universes.
  • Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
  • Created Xcelsius dashboard for executive view covering selected KPI for the business function
  • Created WSDLs using Query As a Web Service (QaaWS ) from different Data sources.
  • Migrated Xcelsius dashboards and deployed QaaW S to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
  • Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
  • Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc .
  • Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
  • Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
  • Set up groups and users for Business Objects deployment.
  • Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
  • Extensive testing and migrating the reports or objects from development to Production system.
  • Developed testing scripts and test cases. Extensively tested B usiness Objects reports, dashboards and other B usiness Objects Applications in new environment.
  • Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Environment: Business Objects XIR3.1, WebI, Xcelsius, Universe Designer, Oracle 8i/9i, PL/SQL, Windows XP/7.

Role: Business Objects Developer

Confidential, California

Responsibilities:

  • Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports.
  • Designed Universes, incorporating all the business requirements.
  • Implemented object level security universe to in corporate security for sensitive information.
  • Worked in migration of universe and reports between environments .
  • Designed universes, solved loops by creating aliases, contexts and resolved traps.
  • Created complex variables, breaks, sorts, filter and conditions for various reports.
  • Created complex reports involving m aster/detail and cross-tab and Combined queries and sub-queries
  • Linked multiple data-providers and Used calculation contexts/extended contexts
  • Coordinated with DBA and Business objects designer group in solving various technical issues.
  • Created multiple contexts for catering different functional areas in a single user query.
  • Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts..
  • Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
  • Extensively used scheduler for report scheduling and deployment
  • Generated various report templates for standardizing the reports throughout the organization.
  • Involved in end user and documenting the procedures.
  • Involved in developing the financial reports for the Financial services Dept and successfully published the highly formatted reports and met with the end user requirements
  • Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I XI R2.
  • Scheduled pre-canned reports through Scheduler for distribution and printing.

Environment: Business Objects XI3.1, Web Intelligence, Xcelsius 2008 Oracle 9i

Business Objects developer

Confidential, CA

Responsibilities:

  • Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
  • Designed several universes and used various methods to optimize queries on database, universe and reporting level.
  • Worked towards optimal development of universes by removing loops through the use of aliases and contexts.
  • Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
  • Created and tested classes and objects to organize the universe.
  • Exported the universes to the Repository to make resources available to the users.
  • Created reports for various Portfolios using the Universes as the main data Providers.
  • Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
  • Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
  • Extensively worked with Ranks, alerters, filters, prompts, variables and calculation contexts in designing reports.
  • Created Business Objects Repository while building Business Objects solution.
  • Published and scheduled Business Objects Reports to users using Scheduler.
  • Created Derived tables, Developed Stored Procedures, Packages and Triggers database using PL/SQL.

Environment: Business Objects XIR2, Web Intelligence, Universe Designer, Oracle 8i/9i, Windows NT.

Business Objects developer

Confidential, Denver, CO

Responsibilities:

  • Information gathering - interacted with the end user to understand the requirement and business logic
  • Analyzed the existing OLTP system and designed and managed universes based on the Business Requirements
  • Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
  • Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically
  • Customized the list of values (LOV’s) which helps the end users to select the values.
  • Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance
  • Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
  • Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
  • Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
  • Working on the SQL tuning and optimization of the Business Objects reports.
  • Scheduling reports from the Broadcast Agent Server to only requested users.
  • Worked extensively on Web Intelligence for any new requests and performance issues.
  • Involved in installing Web Intelligence, creating users, user groups and categories
  • Generated reports for web users using Web Intelligence and Info View.
  • Created Web Intelligence documents and published them to corporate documents.
  • Worked with Installation and configuration of Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.
  • Migrating Business Objects 6.5.1 version reports to new version XIR2.
  • Converted the existing full client reports to WebI reports using Report Conversion Tool.
  • Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment using Import Wizard.
  • Created reports using Desktop Intelligence and Web Intelligence in BO XI R2 environment.
  • Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web XI R2.
  • Extensive testing and migrating the reports or objects from development to Production system

Environment: Business Objects 6.5.1 (Supervisor, Designer, Reporter), Web Intelligence 2.x/6.x, BCA, BOXI R2 (CMS, CCM, CMC,), Oracle 10g, PL/SQL, SQL Server 2000, Windows 2000, UNIX, Crystal Reports XI/9.0, Crystal Xcelsius, PeopleSoft FMS 8.9.

Business Objects Developer

Confidential

Responsibilities:

  • Analysis of Business Objects environment, Universes, Reports.
  • Add more groups and change the profile of users via supervisor.
  • Developed Universe using Designer module in Business Objects.
  • Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
  • Specified the Joins and checked the cardinalities.
  • Implemented User Objects in Reports.
  • Created Condition in Universe.
  • Ad-hoc reports were used for Business Objects user modules for various portfolios using the Universes as the main Data providers.
  • Resolved loops by creating Aliases and Context.
  • Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.

Environment: : Business Objects 6.5, Web Intelligence, Oracle .

Hire Now