We provide IT Staff Augmentation Services!

Sr. Business Objects Reports Resume

2.00/5 (Submit Your Rating)

PROFILE:

  • 7 years of total IT experience.
  • 7 years of Business Intelligence Business Objects experience.
  • 3 years of Crystal Reports experience.
  • 2years of Data Modeling.
  • 3years of Xcelsius Dashboard design
  • 3 years ofData Warehousing ETL experience

Professional Summary

  • IT Experienceyears of IT experience in implementing Enterprise Data Warehouse applications and Business Intelligence applications.
  • Business Objects: Experience in Business Objects (XI3.1, XIR2) which includes Full Client, Universe Designer, WebI, WebI Rich Client, Info View, Xcelsius., Import Wizard, Central Configuration Manager.
  • Crystal Reports: Experience with Crystal Reports 2008/XIR2/10/9 for creating complicated reports including sub-reports, parameter based reports, formula based, graphical reports, well-formatted reports, data reports, drilling reports, analysis reports, along with LOV. Created Crystal Reports to handle the customer’s requests from Tables, Stored Procedures and Views and used Java coding for automatic update, export of html files.
  • ETL: Experience in loading huge amounts of data into data warehouse using ETL tools Informatica and Abinitio. Developed Jobs using the components like Source Qualifier, Expression, Look up (connected and unconnected), aggregate, Update Strategy, Joiner, Filter and Router and writing the scripts for loading the data from heterogeneous sources systems to Enterprise data warehouse
  • Database: Experience with Oracle 11g, Sybase, DB2, Teradata and I had very good Experience in working with SQL, T-SQL, PL/SQL scripts, views, indexes, stored procedures and other components of database applications. • Hands on experience on writing Teradata ETL scripts using BTEQ.
    • Extensively worked with BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files
  • Data Modeling: 2 years experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals like Financial and Insurance. Good at Database Design, conceptual, logical and physical Data Modeling, Star Schema, Snowflake; FACT and Dimensions tables, slowly changing dimensions (SCDs).
  • Well-versed and strong experience in developing reporting applications using Cognos 8 BI (8.3, 8.2, 8.1.2), Framework Manager, Query Studio, Report Studio and Cognos Connection. Experience in Analysis Studio, Event Studio & Metric Studio.
  • Expertise in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
  • Experience in creating dashboards using dashboard manager and Crystal Xcelsius.
  • Experience in Query as a Web Service(QAAWS) to connect to the Business Objects Universes
  • Used Query as Web Service(QAAWS) for generating reports in applications like Crystal reports 2008 and for creating dashboards in Xcelsius 2008
  • Extensively worked on migrating Business Objects from earlier versions to Version XIR2.
  • Analyze migration strategies for Business Objects Universes and reports across multiple Business Objects Repositories (Development, QA and Production).
  • Experience in Extraction, transformation, and load (ETL) functionality like Move and integrate data in real time and at any interval.

EDUCATION:Bachelor of Engineering in Computer Science

Professional Experience:

Confidential ,NJ Mar’09 to tilldate 
Sr. Business Objects Reports Developer 
Responsibilities:

  • Coordinating with Business Analyst about Report development requirements for the user needs to view their business flow on daily basis.
  • Prepared the Business requirement documents based on the User comments on their specifications and developed the mapping documents for designing the Universe and reports.
  • Responsible for defining the scope of the project and doing gap analysis for the user requirements
  • Created Technical Specifications Documents based on requirements from stakeholders.
  • Created complex Reports, Cross Tab and Master Detail reports by using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerters and other features.
  • Responsible for developing thick/thin client canned reports using Business Objects and Web Intelligence.
  • Worked with Crystal Report XI for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV and scheduled them by using Macro related SDK’s.
  • Customized Webi withWebi SDKand integrated with java portal.
  • Within organization generated sub reports in Crystal reports XI as per ad hoc purpose.
  • Exclusively worked on PL/SQL while developing the code for views and stored procedures.
  • Extensively used Crystal Xcelsius for creating Dashboards, Scorecards and reports.
  • Used Query as a Web Service (QAAWS) to retrieve data for Crystal Xcelsius from Previously developed Business Objects Universes
  • Extensively used Business objects explorer for reporting dashboarding analytics.
  • Tested the developed reports in business objects using written test cases and different test case scenarios.
  • Solved many Universe problems Loops, Fan and Chasm Traps.
  • Solved issues reported from end users and managed the universes based on the changes
  • Worked on Administration of Business Objects applications and Implemented access restrictions for the users in Central Management Console (CMC).
  • Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process.
  • Worked on Data Modeling using Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
  • Experience in Extraction, transformation, and load (ETL) functionality like Move and integrate data in real time and at any interval.
  • Extensively used Erwin for Data modeling like physical and logical data modeling
  • Conducted and attended weekly status meetings and gave weekly status report about the project progress
  • Conducted Training classes to end user for better understanding of developed reports
  • Created classes and objects as per the Business reporting specifications in the universe.
  • Performed System Integration Testing, Unit Testing and Data Quality Testing

Environment: Business Objects XI3.1, BO data integrator,Business objects explorer XI 3.1,Crystal Reports XI, Xcelsius 2008, Oracle10g,, Sybase 11.0, Ab Initio,Teradata v12, Erwin, SQL, PL/SQL, BO SDK, Microsoft Visio, UNIX, Windows 2003 Server.

Confidential, AZ Apr ’08 to Feb ‘09
Business Objects/Crystal Reports Developer
Responsibilities:

  • Created functional requirement specifications through end-user meetings and analysis of business requirements.
  • Coordinating with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications.
  • Assessing the impact of changes in business requirements, evolving the strategy, and
    providing alternative solutions design to address ongoing changes.
  • Designed Universe and Report Requirements, definition templates, Security strategies, Migration strategies and Report Distribution strategies.
  • Created weekly status reports and attended weekly status meetings
  • Installed and configured Business Objects XI R2 on Windows platform.
  • Created users and set their access rights using Central management console.
  • Extensively worked on star /snowflake schema in data modeling for creating Data marts using Erwin.
  • Development of mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Expression, Look up (connected and unconnected), aggregate, Update Strategy, Joiner, Filter and Router.
  • Responsible for designing and developing Universes from OLAP database using Business Objects Designer.
  • Solved many Universe problems (Loops, Fan and Chasm Traps).
  • Creating, maintaining and modifying the business critical reports using the Desktop Intelligence.
  • Generating the Standards and templates for the reports, interfaces and the universes.
  • Gathered PRM/Channel requirements based on that developed some reports.
  • Responsible for developing thick/thin client canned reports using Desktop Intelligence and Web Intelligence (Infoview).
  • Scheduled and distributed the reports to the end users using Broadcast agent (BCA).
  • Involved in Performance tuning of reports using derived tables and index awareness.
  • Worked with SQL, T-SQL, PL/SQL scripts, views, indexes, stored procedures and other components of database applications.
  • Worked on SQL and Scripts (Basic & Crystal) for solving the problems in Crystal Reports.
  • Extensively worked on metric oriented measures in universes
  • Created list reports, cross tab reports, chart reports and reports with lot of conditional formatting using Report Studio in Cognos BI.
  • Created Query Prompts, calculations, Conditions & Filters, Prompt Pages using Report Studio.
  • Created various prompts like value prompt, search prompt, and date etc
  • Created Cascading List of Values for Crystal Reports using Business View Manager.
  • Used Business objects explorer to view and drill down the reports as well as dashboards.
  • Used Business objects advanced analytics to run ad hoc OLAP analyses, and create OLAP workspaces for private usage or sharing with other.
  • Extensively worked on test cases and test case scenarios to test the developed reports.
  • Extensively worked on partner reports design development and maintenance.
  • Created Business Views in Crystal Reports XI, connecting to multiple databases for operational reporting requirements, creation of elements in the metadata layer which points to the heterogeneous database.
  • Created Sub reports and On-demand sub reports in Crystal Reports XI.
  • Worked with Crystal reports XI for creating complicated reports including sub reports,graphical reports ,parameter based reports,formula based,well-formated reports,drilling reports,analysis reports,data reports along with LOV and schedule them by using Macro related & Java SDK’s.
  • Created complex WEBI Reports such as Cross Tab and Master Detail Reports using Sybase and Sql Server 2005.
  • Created Dashboards and Scorecards using Crystal Xcelsius .
  • Extensively worked on creating Ad-hoc and canned reports.
  • Trained business users and solved issues reported.
  • Maintained & Modified Universes using BO Designer and exported to the CMS Repository.

Environment: Business Objects XIR3/R2/6.5,Cognos 8,w Crystal Reports XI R2, Crystal Xcelsius 2008, Sybase 12,Business objects Explorer XI R3, MS Sql Server 2005, SQL and PL SQL , Informatica, TOAD 9.0, Erwin, Windows 2003,Unix

Confidential, VA Jan’07 to Mar ’08
Business objects/Crystal Reports Developer
Responsibilities:

  • Participated in project planning sessions with project manager, business analysts and team members to analyze business requirements and outline the proposed solutions.
  • Extensively worked with Project documentations like System Specification, Technical SpecificationUniverse, Migration Strategies, Analysis and planning.
  • Extensively used Central Management Console (CMC) in setting up security in BOXIR2 and also managed security configuration for various reports and universe in both development and production environment.
  • Created Custom Hierarchies for using scope of Analysis and Drill Down options.
  • Implemented the Object-level, Row-level and Data-level security on the developed Universes.
  • Creating, maintaining and modifying the business critical reports using the Web Intelligence.
  • Extensively worked in different environments of Kaiser like BOXI DEV, BOXI PROD, BOXI UAT, and CE 10 PROD for different tasks like Report development, Publishing & Scheduling, Migration, and Documenting.
  • Designed and Documented Universe and Report Requirement definition templates, Security strategiesMigration strategies and Report Distribution strategies.
  • Worked along with production support team to fulfill the end user requirements and in finding the best solutions for the User tickets.
  • Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
  • Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
  • Worked on Implementing business plans and Migration strategies for BOXI Migration.
  • Involved in Dash Board Design and Maintenance using Xcelsius.
  • Created dashboards which are connected to live data sources using Query as a Web Service (QAAWS)
  • Worked along with UAT support team in creating and testing of different test cases against the Crystal and Bo reports.
  • Involved in finding out solutions for different problems like overlapping, truncations, multi valued, folder access issues, hard coded restrictions, data visibility.
  • Solved different issues like database issues, Connection issuesaccess issues of CE 10 and BOXI in the production environment.
  • Published all CE 10 reports after Migration in to the BOXI using Epublisher.
  • Extensively worked with BOXI Instance manager in monitoring of report status and user interaction.
  • Troubleshooting BO XI installation and migration issues.
  • Configuring BO servers starting and stopping manually to best Publish the reports using EPublisher to BOXI using the naming conventions in crystal Management Console.
  • Worked on metadata and created universes and reports.
  • Reports by Customer, Integrated clinical data with BOXI environment.
  • Used Complex EXCEL formulae V lookup & H lookup to generate complex Dashboards.
  • Trained end users in understanding the reports.

Environment:Business Objects XIR2, Crystal Reports10,Voyager,BO Advanced analytics, Business Objects explorer XI Performance Management, Live Office, Crystal Xcelsius, Teradata ,Informatica, SQL and PL SQL,Unix(Solaris).Sybase 11. MS Excel .

Confidential Oct ‘05 to Dec ‘06
Business Objects/Crystal Reports Developer 
Responsibilities:

  • Analyze the reporting requirements with the business users and come up with the technical specifications for the BO Reports.
  • Created functional requirement specifications through end-user meetings and analysis of business requirement documents.
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions
  • Generating the Standards and templates for the reports, interfaces and the universes.
  • Creating, maintaining and modifying the universes using Business Objects designer.
  • Solved many Universe problems. (Loops, Fan and Chasm Traps).
  • Develop reports based on the subject area, using Universes as the main Data providers.
  • Developed Performance Management Dashboards to set goals, measure and monitor
  • KPI’s for balance scorecard initiative.
  • Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
  • Created reports using crystal reports 10.
  • Developed Crystal Xcelsius Auditing dashboard using audit tables for monitoring the load on servers.
  • Created List of Values (LOV’s) and custom Hierarchies to support drilling functionality for in depth analysis in reports.
  • Used aggregate tables and materialized views to increase the performance of universe.
  • Used @Aggregate Aware function that allows an object to take advantage of tables containing summarydata in the database Performed both Unit and System integration testing of the Data marts.
  • Extensively used Triggers, Procedures, Functions at Database level and form level using PL/SQL.

Environment: Business Objects 6.5/XIR2, crystal reports 10/XI, Crystal Reports 4.5, Oracle 9i, PL/SQL, Sql Server, MS SQL Server, TOAD.

Confidential Jul ’03 to Aug ‘05
Business Objects Developer
Responsibilities:

  • Analyze the reporting requirements with the business users and come up with the technical specifications. This includes the documents for getting the data from the mainframe side and also the technical specifications for the BO Reports
  • Generating the Standards and templates for the reports, interfaces and the universes
  • Creating, maintaining and modifying the universes using Business Objects designer for LMS
  • Creating, maintaining and modifying the business critical reports using the Business Objects Reporting Module
  • Created Custom Drill Hierarchies in the universe for doing multidimensional analysis.
  • Develop reports based on the subject area, using Universes as the main Data providers.
  • Implement Data Level Security, based on the Divisions and Markets.
  • Creating the reports using Business Objects functionalities like Multiple Data ProvidersPrompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
  • Created trend reports with charts and drill down on charts.
  • Documenting the entire effort. The documents generated during the process were Requirements Specifications, Design Document, Project Planning, Change History, Unit testing documents, and System testing documents.
  • Providing user support and training in using Report Designer for creating Adhoc reports

Environment: Oracle 8i, Business Objects 5.1/4.1, Web Intelligence 2.5.

We'd love your feedback!