We provide IT Staff Augmentation Services!

Business Objects Developer Resume

5.00/5 (Submit Your Rating)

Kansas City, MO

SUMMARY

  • Over 7 years of experience in the IT industry with extensive skills dedicated to business systems analysis, database development, and Reporting
  • Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll - Out / Go Live.
  • Experience in Business Objects Enterprise XI R3/XI R2/XI/6.x which include installation, creating and administering repositories, universe, customizing thin and full client reports.
  • Good knowledge on Business Objects Business Intelligence 4.0
  • Experience in designing, creating and managing the Universe using the Designer.
  • Experience in creating reports using Webi, Rich Client, Crystal Reports, Xcelsius.
  • Experience inBusiness ObjectsXI 3.1 (Central Management Console (CMC), Central management server (CMS), Central Configuration Manager (CCM), Designer, Desktop Intelligence, Web Intelligence, Import wizard, Report Conversion Tool.
  • Experienced in planning, organizing, rescheduling and managing Business Objects.
  • Hand full of experience in migrating of reports and Universes from 6.5 to XIR2 to XIR3 (3.x).
  • Highly skilled in creating ad-hoc/canned Reports, complex reports using predefined conditions.
  • Experienced in Business Objects functionalities like queries, drill down, @functions, custom sorts, cross tab, master detail and formulae.
  • Experienced in creating Metrics and Analytics to create Dashboards for better decision purpose.
  • Expertise in Webi, Crystal Reports on various Databases like Oracle, SQL Server, and DB2.
  • Expertise in hyper linking. Linking of one report to another report using OpenDoc.
  • Experience in formatting of Webi and Crystal reports to meet the Business requirements.
  • Good knowledge on Group Expert, Section Expert, Database Expert and the Summarizing of the fields in Crystal Reports.
  • Expertise in gathering the business requirement and building Universes in the Designer, retrieving data using Universe, Personal data files, free hand SQL methods and creating complex ad-hoc reports using data access and report design using Web Intelligence modules.
  • UsedBusiness ObjectsSDK to build scalable web applications that manage and distribute reports and documents and also provide functionality for administrative and client tasks.
  • Created Users, Groups and setting the rights on them using Central Management Console (CMC).
  • Scheduling of Webi Reports in CMC on Daily, Monthly, Weekly basis.
  • Debugging the Problems exists in the Webi Reports.
  • Understanding Administering the Users and Groups and Setting the Rights at the Folder Level, Object Level and Customized Rights.
  • Self-motivated, Result oriented team player and quick learner of new concepts and technologies. Excellent interpersonal, communication and documentation skills.

TECHNICAL SKILLS

BI Tools: SAP Business Objects Business Intelligence 4.0, Universe Design Tool, Dashboards, SAP Business Objects Enterprise XIR3/R2/6.5/6.0, Designer, Info view, Web Intelligence, Rich Client, Desktop Intelligence, CMC, CMS, Crystal Reports XI, XIR2, Business View Manager, Import Wizard, BO SDK.

Data Modeling: Star Schema, Snowflake Schema.

Databases: Oracle 11g/10g/9i/8i, SQL Server, Teradata, DB2

Languages: SQL, Java, PL-SQL, C, C++

Operating Systems: Windows 7/Vista/XP professional, UNIX.

Web and Others: MS- Office Suite, HP Quality Center, Dream weaver, Adobe Photoshop, Flash.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Business Objects Developer

Responsibilities:

  • Part of a team during deployment ofBusiness ObjectsXIR2 Enterprise Server.
  • Created Users/Groups/Sub-Groups & assigned profiles there by restricting un-authenticated access to resources.
  • Gathered Business requirements from users, interpreted Business rules and translated these rules into developing the reports.
  • Part of group meetings for report development with Business Managers and Users. Was part of developing and executing plans for the reporting team to achieve targets mutually agreed among user and Development team.
  • Created templates for standardizing reports using company logo, header and footer settings, color coding, fonts and maintained consistency in viewing cross-tabs, blocks in report.
  • Created WEBI reports using data from multiple data providers using merged dimensions functionality.
  • Extensively used calculations, variables, filters, conditions, breaks, sorting, drill down, slice and dice, Master/Detail, Cross Tab, Charts and alerts for creatingBusiness ObjectsReports.
  • Created Joins complex multicolumn joins with conditions, Context and Aliases for Resolving Loops and Checked the Integrity of the Universes.
  • Checked the integrity of the universe schema for any errors in objects, joins, conditions, loops and cardinalities of the universe.
  • Enhanced reports which included standardizing format of report content, redefining query filters and prompts, linking summary report to a set of detail reports.
  • Attended to user requestsin enhancing reports and fixing bugs, providing solutions for existing bugs and redefining newer concepts for better features.
  • Implemented reports in Production from Integration after user approval in test area.
  • Developed migration checklist to validatereports which are migrated from Integration to Production.
  • Used @Functions such as @Prompt- to restrict return values and to enter prompt, @Select- to reuse the select statement of another object, @Variable- to restrict the currently logged user .

Environment: Business Objects XI R3/R2 (CMC, CMS, Import Wizard, Designer, WebI, Info View), Oracle, Informatica, Windows, MS Office Suite.

Confidential, Morristown, NJ

Business Objects Consultant

Responsibilities:

  • Developed new Universes right from Data Modeling to developing reports.
  • Participated in requirement gathering, analysis and structured Business Intelligence platform based on user requirements.
  • Analysis of data requirements & translation of these requirements into dimensional data models using star schema and extended star schema data modeling techniques, with an emphasis on actual implementation in BW.
  • Interacted with business users to know their business needs to effectively develop and modify Crystal Reports.
  • Developed complex reports that involved multiple data providers, cross tabs, bar charts, pie charts, complex variables and calculation contexts.
  • Created Drill-through reports to provide users with more detailed information and query linking.
  • Created reports using WebI and Crystal Reports.
  • Pulled tables from database and defined cardinalities between them.
  • Created Classes, Objects and Filters as per the Requirement.
  • Resolving loops using contexts and aliases to remove cyclic dependencies and also resolved table linking problems like Chasm traps and Fan traps.
  • Extensively used @Prompts in Creating of the Filters to meet the User Requirements.
  • Customized the list of values (LOV’s) which helps the end users to select the values.
  • Created Derived Tables in Universe to make the Universe more efficient and to improve the performance of the reports.
  • Extensively worked on Developing of Web Intelligence reports. Hyper linking of WebI reports using Open Doc syntax.
  • Created complex reports and applied various formatting, suppress conditions, sorts, grouping, filters.
  • Excellent knowledge of Hyper linking of one Crystal Report to another Crystal or WebI reports through Parameter or the reports field.
  • Used group expert and section expert on reports.
  • Created Static and Dynamic Parameters at the report level.
  • Created dynamic cascading ALL prompt in Business View Manager.
  • Created new groups and users and applied privileges/restrictions using central management console (CMC).
  • Performed extensive testing and submitted the reports to business analyst for further assessment.

Environment: Crystal Reports XI Release 2,Crystal Reports 2008, Crystal Xcelsius, Business Objects XI R3/R2 (CMC, CMS, Import Wizard, Designer, WebI, Info View) SQL, Oracle 10g, Windows 2003 server, Excel, Access, SAP BW and R/3

Confidential, Shelton, CT

Business Objects Developer

Responsibilities:

  • Analyze the reporting requirements with the business users/architects and come up with the technical specifications foruniverse and BO reports.
  • As a part of universe designer team,involved in the creation of universeusing Business objects 6.5designer.
  • Designed Universe using Designer.
  • Modifyingthe existing universes, adding new objects, editing joins, mapping the existing objects with renamedtables.
  • At the universe level checked whether all the outer joins are created properly and also removed if there are anyvariableswhich are not used.
  • ImplementingObject-level and Row-level security using“Manage Restrictions”on the developed universe restricting the end-usersin accessing certain objects.
  • Created Joins, Aliases and Contexts for resolving Loops in the Universes andchecked the Integrityof the Universes.
  • CreatedCustom Hierarchiesfor using scope of Analysis and Drill Down options.
  • Using aggregate awareness, Index awareness and @functions.
  • Created the Reports usingBusiness Objects functionalitieslike Multiple Data Providers, Prompts, Cascaded Prompts, Slice and Dice and Drill Down.
  • Applied Alerter, Breaks and Rankson the reports.
  • Improved the performanceof the reports by removing any additional filters or alerter on the report. Turned the formula into a variable if it has any multiple uses.
  • Created Queries withLive Office and QueryAs AWeb Service by connecting to the Required Universes in order to get the data into Excel.
  • Developed the Reports usingBusiness objects 6.5 Full Client.
  • UsedImport Wizardfor the Migration process. Migrated users, universes, reports.
  • Created Revenue Dashboard, Sales figure Dashboard usingXcelsius.
  • Given the option for the end user in selecting the Multiple Values for the required Objects according to the end user requirement (In Creation of DASHBOARD).
  • Involved inDocumentationof the project which includes Requirement specifications, Design document and Project Planning.

Environment: Business Objects XIR2/6.5(Designer, Desktop Intelligence, Web Intelligence, CMC, CCM),Crystal Xcelsius XI R2, Informatica 8.1.1, Crystal Reports 2008, Windows,SQL Server 2005, Oracle 10g.

Confidential, Auburn Hills, MI

Business Objects Developer

Responsibilities:

  • Involved in requirement gathering and converting them to technical specifications.
  • Participated in requirement gathering and converted them to technical specifications for report generation and did proof of concept.
  • Created reports on multiple data bases like SQL server.
  • Created prompts, filter, alerts and complex calculations for business needs
  • Created templates for standard reports and Developed complex reports using multiple data providers
  • Test the SQL queries generated byreports to find correct data is retrieving or not
  • Developed universe from universe design specification document using designerwhich would be the data source for Dashboards and also all ad-hoc/canned reports
  • Modifying and enhancing universes as per business/reporting needs
  • Created derived tables in designer to accommodate complex functionalities and provide adhoc reporting.
  • Created Classes, Objects, Conditions, Prompts and defining Joins and Cardinality
  • Resolving loops, Fan traps and chasm traps by using contexts and aliases.
  • Creations of sections and breaks to get the sub totals on each level
  • Creating complex reports using features like slice and dice, Drill capabilities,
  • Creation of different types of reports such as Master/detail, Cross tab and chart (for trend analysis) depending up on user requirement.
  • Handled all types of errors in reports in universeand report level.
  • Used Business Objects common functionalities like Prompts, Breaks, Alerter, Sorts, Filters, Global Filters and Conditions
  • Created live office reports from already created webi, crystal reports.
  • Developed many Reports/Dash Boards with different AnalyticsViews (Drill-Down / Dynamic, Pivot Table, Chart, Tabular with global and local Filters) using BO XI R2
  • Created templates for standard reports.
  • Testing the Universe and reports for data accuracy and format specifications given by the client.
  • Created Cross-tab and Master Detail reports

Environment: Business Objects 6.5 and XI R2, Informatica 7x, Webi, Live Office, DB2, SQL server 2005, Oracle

Confidential, Clemmons, NC

Business Objects Developer

Responsibilities:

  • Actively involved in studying user requirements and creating requirement and functional documents.
  • Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, Expression Transformation.
  • Developed reusable transformations and mapplets using transformation developer and mapplet designer
  • Involved in versioning the whole process and retiring the old records using the built-in'sDD UPDATE, DD DELETE, and DD INSERT.
  • Worked on troubleshooting the mappings and performance enhancement.
  • Installation of BusinessObjects software, Assigning users required privileges/resources and assigning the functionality of each module as required.
  • Preparation of Report specifications through studying the user requirements and various sub-systems/existing applications that are in the scope of this project.

Environment: Business Objects 5.x, PL/SQL, UNIX Scripting, Windows NT, Oracle 8i, Informatica PowerCenter 6.x, Flat files, PLSQL

We'd love your feedback!