We provide IT Staff Augmentation Services!

Business Objects Analyst Resume

NJ

SUMMARY:

  • Six Sigma certified with 10+ years of IT experience in using SAP Business Objects Enterprise Suite like SAP BIBO 4.2, BOXI3.1/XIR2 with different modules like Web Intelligence, Rich Client, Universe Designer, IDT, Xcelsius Dashboards, Upgrade Management Tool, Promotion Management Tool, Info view etc.
  • Experience in designing and developing the Universe and updating/modifying the existing Universes, developing canned/adhoc reports, scheduling the processes and administering the BO activities using SAP BIBO 4.1 and XI3.1
  • Experience working in all phases of SDLC from analysis, design, coding, unit testing, system testing and user acceptance testing
  • Involved in reports and universe migration from 3.1 to 4.1/4.2 using Upgrade Management Tool, and moved the data source from DB2 to Teradata and also performed User Acceptance testing
  • Expertise in developing Xcelsius Dashboards using Filters, Combo box, List View, List Box, List Builder, Line Chart, Column Chart, Pie Charts
  • Good experience in development and maintenance of the Universes on various data sources using Designer
  • Migrating the universe and reports from SIT to UAT to production environments through Import Wizard and PMT
  • Extensively worked in developing Web Intelligence and Desktop Intelligence Reports using Info View, Web Intelligence Rich Client and Desktop Intelligence components
  • In - depth knowledge of Schema's/Dimensional modeling and data warehouse methodology
  • Scheduling of Web Intelligence reports in Info View and Central Management Console
  • Interacted with the business users; created business design document and technical design document for the applications
  • Created, deployed the Business Intelligence Archive Resource File ( BIAR) on Business Objects Environments.
  • Used the tools like Analysis for Microsoft Excel and Analysis for Microsoft PowerPoint to develop the reports by having the data sources like infoCubes, analytical view and attribute views in SAP HANA/BW
  • Good experience in writing SQL queries to create Derived tables in the Universes and analyze the report SQL in the data base
  • Hands on experience in working with Drilldown, Calculations, Breaks, Section, Alerts, Ranking, and functions to create Webi reports
  • Hands on experience in developing the Webi reports on universes which are built upon SAP HANA database
  • Experience in writing custom SQL queries in order to meet the user requirements.
  • Facilitated accurate business results by applying complex formulas and variables, user response function, optional prompts and filters at report level
  • Taking backup process of Universes, Web Intelligence documents via copying the File Store folder, creating the BIAR files and shared connection universe files on the destination BO environments
  • Good working knowledge in Supply Chain Management, Banking and Health Care Domains
  • Knowledge and ability to work with Live Office, Query as a web service, Crystal Xcelsius, SAP BO Integration Kit, BIAR using import wizard
  • Good knowledge on SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
  • Good knowledge in bringing the data from different source systems to the target database using Informatica Power Center Designer
  • Developed dashboards using Tableau and SAP Lumira
  • Good team player with excellent communication, analytical, written and presentation skills with strong aptitude towards learning new technologies

TECHNICAL SKILLS:

Operating Systems: Windows 7/8, Windows NT/XP/Vista, Windows Server 2000/2003, Linux

BI Tools: SAP Business Objects XI R2/ 3.1/4.1, Tableau

BO Tools: Universe Design, Information Design Tool, Crystal Reports 2008, Crystal Reports 2013, Web Intelligence, Web-I Rich Client, Desktop Intelligence, BI Launch Pad, Bi-Widget, Publishing Wizard, Import Wizard, Live Office, Query as Web Service, Report Conversion Tool

Other Tools: HPQC, Remedy

MS Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook

Database: DB2, Teradata, MS SQL, Oracle 10g/11

Languages: C, C++, Core Java, SQL

Domain Experience: Supply Chain Management, Banking, Healthcare

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Business Objects Analyst

Responsibilities:

  • Developed Data Lineage tool 'STAR' to help the BSA's, Analysts, Data Stewards in reverse engineer the Production fields and tables in both source to target and target to source.
  • Developed Multi Source Universes using the Information Design Tool with multiple data sources and mapping the data models in the Data Foundation Layer of the tool.
  • Developed the universes on linked databases connections in Oracle database.
  • Worked on the Migration of the Business Object reports from 3.1 to 4.2 using Upgrade Management Tool. Migrated all the universes and resolved join path issues and Involved in the regression testing of SAP BI4.2 suite after migration.
  • Prepared detailed documentation of all the Reports and Universes which were migrated and converted to SAP BIBO 4.2
  • Involved in writing the user requirement specifications and report specification documents for the project Instant Card Printing (EMV-ICP) for both Credit and Debit Card
  • Changed the data source from DB2 to Teradata and recreated the reports and universes as per the customer requirements.
  • Created the complex WebI reports on commercial banking sector as per the business requirements.
  • Performed peer reviews before publishing the reports into public folders and moving them to Production environment using Promotion Management Tool
  • Performed Scheduling of the reports to the end users BI Inbox and E-Mails and publishing the reports into public folder
  • Created the SAP Xcelsius Dashboards as per the user requirements using the dashboard designer
  • Performed the UAT on all the Webi Reports after the Migration
  • Resolved report issues that surfaced during the UAT phase, recreated the Webi reports from Deski reports
  • Coordinated the User Acceptance Testing for all the SAP Business Objects reports after migration
  • Worked for Front End production support and resolved tickets for query modifications, testing, migrating to production and assisted users for trouble shooting problems with reports.

Confidential, IL

Lead Green Belt

Responsibilities:

  • Participated in project planning sessions with project managers, business analysts and Team members to analyze business requirements and outline the proposed solution
  • Designed and developed extensive Business Objects reports like Simple, Complex, Cross Tab using multiple Queries, Prompts, combination chart and tables
  • Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts
  • Extensively used Drilldown, Calculations, Variables, Breaks, Section, Alerts, Ranking, and Functions for creating Webi reports
  • Implemented the Object-Level Security and Row-level security in Universe. Implemented the Table Mapping in Universe to restrict certain data in a table to only one group of users
  • Worked on Hierarchy Levels and Developed hierarchies to support drill down reports
  • Developed Executive Dashboards for Higher Management (Vice Presidents and Directors).
  • Created Dashboards using Filters, Combo box, List View, List Box, List Builder, Line Chart, Column Chart, Pie Chart, and Spreadsheet Table
  • Resolved join path problems at universe level and resolved the object level issues while designing the universe
  • Involved in doing all the administration, configuration and monitoring tasks in Central Management Console
  • Involved in creation of BIAR files which includes Universes, Web Intelligence reports on Development environment
  • Developed reports by using by Analysis for Microsoft Excel and Analysis for Microsoft Power Point.
  • Created Webi reports based on universes which are built upon SAP HANA data source.
  • Involved in Scheduling of Web Intelligence reports in Info View and Central Management Console
  • Involved in monitoring the status of all the Scheduled Instances through Instance Manager in Central Management Console
  • Developed user-friendly Graphical representation of Dashboard reports like charts and trend analytics which provides an instant access to all critical information and reports on all the departmental operations for the Business users
  • Sending the status mails to the clients and teams about the reports development issues and data base related issues
  • Involved in production support for all the customers through activities and tickets requests system
  • Involved in creating users and user groups using Central Management Console (CMC) and assigning the privileges to the users to access the business objects applications
  • Co-ordination with Development and production teams for moving the application into Production
  • Trained the end users in working with the Business Objects user module and provided technical expertise

Confidential

Business Objects Consultant

Responsibilities:

  • Designed the BO Universe based on centralized database GDW (Global Data Warehouse) and ECDW Data Base.
  • Reports are developed and migrated to SIT to UAT server for each module using Import Wizard and resolved all SIT and UAT issues.
  • Universe level and Report level performance issues are resolved.
  • Resolved the loops using Contexts and/or Aliases in the universe and checked the integrity of the universe.
  • Created/checked Joins and detected Cardinalities.
  • Created/Classified classes and different objects as per the user requirement.
  • Universe is designed based on existing Data Model and tested the efficiency whether it meets requirement or not.
  • Involved in full life cycle of Business Objects reporting applications.
  • Created the user groups and users, set up the privileges to them according to their requirement.
  • PIT reports are developed to report at any time based on user requirement.
  • Default Prompt is created for PIT reports to display the current FY and Month as default value for given prompt.
  • Analyze FRD provided by the user for their requirement.
  • Planning of the Security Content of the Users at Object Level.
  • Understanding data modeling whether it will meet the reporting requirement or not.
  • Attending the daily status calls with client for requirement.

Confidential

Sr. Business Objects Developer

Responsibilities:

  • Delivered status mails to the clients and teams about the reports development issues and Data base related issues
  • Performed Scheduling of the reports to the end users Inbox and E-Mails and publishing the reports into public folder
  • Trained the end users in working with the Business Objects user module and provided technical expertise
  • Coordinated with project manager, business analyst and team members, to analyze business requirements and proposed the outline solution
  • Documented all the reports and universe which were migrated and converted to SAP BIBO 4.1
  • Created analytical and operational Webi reports with multiple Data providers
  • Performed troubleshooting at report and universe level for new requirements
  • Performed tuning of reports and UAT reports testing at report level, ensured consistency of the reports
  • Designed, Developed and Maintained Universe using designer tool
  • Evaluated joins and cardinalities of the existed universe to new local universe with limited classes and objects
  • Updated weekly and monthly business reports as the end users requirement
  • Generated reports using reporting functionalities like Alerter, Break / Section, Drill and chart
  • Designed Business Objects Universe as per the technical specifications and ad-hoc requirements from the client
  • Created classes and objects as per the Business requirements, applied conditions in the where clause of measured objects
  • Resolved join path problems at universe level and resolved the object level issues while designing the universe
  • Designed web intelligence reports by using the functionalities in the business objects
  • Managed to work with optional prompts, block filters and customized breaks at report level for specific requirements
  • Developed reports using multiple queries for different end users, as per the special requirement of the project
  • Exported the existing universes and related reports to the CMS repository to the specified folders

Confidential

Business Objects Developer

Responsibilities:

  • Involved in Design, Development and Maintenance of the Universes
  • Involved in troubleshooting and resolving join path problems like Loops, Chasm Traps and Fan traps by creating Alias, Context
  • Involved in applying Row Level and Object Level Access Restrictions in the Universe for to restrict the data, classes and objects to end users in the Info View and Web Intelligence Rich Client components
  • Involved in doing all the administration, configuration and monitoring tasks in Central Management Console
  • Involved in Scheduling of Web Intelligence reports in Info View and Central Management Console
  • Involved in monitoring the status of all the Scheduled Instances through Instance Manager in Central Management Console
  • Developed and maintained a user-friendly Graphical representation of Dashboard reports like charts and trend analytics which provides an instant access to all critical information and reports on all the departmental operations for the Business users
  • Involved in creation of BIAR files which includes Universes, Web Intelligence reports on Development environment
  • Sending the status mails to the clients and teams about the reports development issues and data base related issues
  • Involved in production support for all the customers through activities and tickets requests system
  • Co-ordination with Development and production teams for moving the application into Production

Confidential

Business Objects Developer

Responsibilities:

  • Gathered the requirements from users and designed the reports as per the business requirements
  • Designed universes, Created contexts, joins, and aliases for resolving loops, solving chasm traps and fan traps
  • Restricted data using the prompts & filters
  • Creating the users & groups and assigning the access levels
  • Created the Deski reports like horizontal table and vertical table as per the client requirements
  • Validating the data with the existing Oracle database by writing SQL in the backend
  • Created custom hierarchies at universe level for better results
  • Exported the universe to the CMS repository to make resources available to the users
  • Scheduled the reports on daily, weekly, monthly, quarterly, yearly as per the user requirements
  • Exported the existing universes and related reports to CMS repository to the specified folders
  • Worked on change requests and send them for lead review before publishing to Public folders.
  • Created folders and categories

Hire Now