We provide IT Staff Augmentation Services!

Bo 4.0 Consultant/administration Resume

Waukegan, IL

PROFESSIONAL SUMMARY:

  • 9+years’ experience in BO 4.0, BusinessObjects XI3.1/R2, IDT, BEx, SAP BW, Universe Design, WebI & Crystal Reports, Dashboard Design, Data Modeling and ETL
  • Full life cycle software development, Business Objects administration, design and implementation with focus on Data Warehousing, SAP BI, Defining Security Roles and Database Applications.
  • Implemented BO security and Row level security, created groups, folders and categories.
  • Extensively worked on Business Objects Universe Designer, Confidential, WebI, Rich Client, Xcelsius 2008, Live Office, QaaWS and Crystal Reports XI.
  • Expertise in migration (Universes, Reports, Security etc.) from BO 6.5 to BO XI R2 and BO XI R2 to XI 3.1
  • Experience in using free - hand SQL to validate data in complex reports by linking data from multiple data providers, stored procedures & functionalities like combined queries, performance tuning and providing operational support for OLAP applications.
  • Expertise in reporting with Business Explorer using BEx Analyzer, BEx Query Designer.
  • Expertise in Universe design and generating complex standard reports, dashboard KPIs, business views, LOVs along with UAT and Data Validations.
  • Developed test plans & performed unit level testing, system testing and integration testing.
  • Proactively created and maintained system, support, and process documentation; worked closely with users to ensure accuracy and completeness.
  • Extensively used Business Objects reporting functionalities such as Master, Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
  • Experienced in DataWarehouse, Life Cycle Management, ETL procedures from different sources using Informatica Power Center and DataStage.
  • In depth knowledge of developing database objects, views, stored procedures, user defined functions, cubes, logistics & ABAP.
  • In depth knowledge of Data Warehouse concepts including Dimensional and ER Modeling.
  • Conducted cross team presentations and meetings on best practices for building reports and consistency across BO developers.
  • Excellent communication skills with ability to effectively work individually as well as in a team with analytical problem solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, Waukegan, IL

BO 4.0 Consultant/Administration

Responsibilities:

  • Performed a key role as a defect resolver and develop high complexity HR reports.
  • Created Audit universe and reports for activity tracking and also to track daily data loads to the DWH.
  • Generated real-time reports that are attached to the shipments (Live Office, UNX and WebI reports)
  • Generated Dashboards using Dashboard Design on BO universe (Live office and direct query method)
  • Defined and configured security roles, row level security, user access to various universes, reports and applications.
  • Performed daily migrations from dev to test and prod environments and general administration through Confidential .
  • Preached standard practices, cleared cross linking of data sources and multi-source universes.
  • Helped ETL team in resolving long standing DWH issues with data mapping from Oracle source as with requirement gathering.
  • Optimized universes and reports for better performance through various levels by optimizing the SQL, Key figure aggregation and separating object definition to more general objects and implementing report specific logic at the report level.
  • Served as a key hyper care and defect resolving position after project go-live and currently serving in the same role.
  • Co-ordinated with DBA in applying patches and reinstallation of prod environment.
  • Trained team members on new features of BO 4.0 and optimization technics.

Environment: SAP BO4.0, Data Services, IDT, Confidential, Promotion Management, Dasahboard Design, Live Office, TOAD.

Confidential, Voorhees, NJ

Data Quality &SAP BI/BO 4.0 Consultant

Responsibilities:

  • Design and develop Data Quality and Data Governance reports, Data model design for the audit tables from SAP real time jobs
  • Involved in guiding offshore teams, creating standard template reports, setting standard practices for BI
  • Implement Data insight (data profiling), metadata management for EAM/CIS data quality
  • Defined security roles and integrated with SAP BW backend security
  • Developed complete data cycle from SAP ECC using standard and custom extractors to DSO, Infocubes and Multiproviders
  • Played the main role in BW- BO integration and was the key point of contact for any problems in this area
  • Developed Dashboards using Dashboard Design (SAP BW queries) and Information Steward for Data Quality
  • Guided other team members and conducted technical knowledge share sessions with offshore and onshore team members
  • Designed Infopackage Groups and scheduling based on time and events
  • Involved in monitoring and scheduling of Info package groups and Process chain
  • Involved in Converting InfoPackage Groups to Process Chains
  • Ensure that all periodic schedules like daily/weekly and monthly are successful
  • Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target
  • Involved in on going Knowledge Transfer activities including user documents preparation.

Environment: SAP BO 4.0, BEx, SAP BW, IDT, Confidential, SAP Data Services, SAP Information Management, LCM.

Confidential, Rochester, NY

SAP BI/BO 4.0Architect

Responsibilities:

  • Configuration and Installation of BO 4.0, assign security roles and rights
  • Windows AD SSO configuration with SAP alias for direct access
  • Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer rules for BI data flow and 3.x data flow
  • Creation and maintenance of BI objects (InfoCubes, DSO objects, Infoset, Multi Providers)
  • Scheduling and periodic monitoring of extractions through Info Packages and Process Chains
  • Involved in documentation for the mapping, technical specifications, data validations and test cases
  • Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections
  • Involved in migration and deployment of the universes and reports across multiple domains
  • Involved in the development of ODS, Generic DataSources and InfoObjects
  • Preparation of Technical Specifications

Environment: BO 4.0,BEx, SAP BW, Analysis Office, Confidential, IDT, Rich Client, Dashboard Design

Confidential, Hopkins, MN

SAP BI Developer

Responsibilities:

  • Gathered requirements to create “Mean Absolute Percentage Error” reports on forecast reports for Supply and Demand.
  • Created WebI reports and customized the “Activity” universe to track various reports usage by End Users.
  • Analyzed usage of reports at the front end and backend to derive conclusions on usage of standard and adhoc reports and reports saved to personal favorites.
  • Demonstrated how the activity universe tracks front end usage data as compared to the backend tracking and presented the analysis to senior management.
  • Created BEx queries using BEx Query designer, defined filters, key figures, functions and Unit of Measure needs as per end user requirements.
  • Designed Universes from OLAP sources, refreshed Universes after BEx query modifications and later customized objects to create WebI reports matching the given requirements and business needs.
  • Modified dashboards in Xcelsius using BEx queries to give an overall picture of the recent trends in forecast demand & supply and various other analyses.
  • Provided support to product testing, Interacted with Analysts to fix defects and provide scope of possible improvement in WebI reports and Xcelsius Dashboards.

Environment: Business Objects XI3.1(Designer, WebI, Rich Client), XCelsius 2008, BEx Query Designer, SAP BW, Remedy

Confidential, Cleveland, OH

Sr. BusinessObjects Developer

Responsibilities:

  • Interacted with project manager & business users to understand the business needs, modify Universe and gather report specifications.
  • Designed Universes from multiple data sources to create several reports with additional variables and report level filters.
  • Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables, joins etc.
  • Defined Alias and Contexts to resolve loops, traps and also tested them to ensure retrieval of correct results.
  • Created sample dashboards to explain the team about available features and possible ways to display data.
  • Designed several dashboards in Xcelsiusfrom multiple data sources with additional variables and filters.
  • Provided feedback to users and senior management about the future developments possible in the dashboard application developed.
  • Created various user defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
  • Improved the performance and reduced coding with the use of @functions (@aggregate aware, @select, @prompt, @where).
  • Updated Universes & reports continuously to rolling user requirements & data sources in an agile environment.
  • Created and modified existing Hierarchies in the Universes to meet user’s Drill Analysis reporting needs.
  • Extensively used free-hand SQL to validate the results generated in complex reports.
  • Designed ETL task using Informatica to extract data from Oracle Database.
  • Created several types of Crystal Reports using sub-reports, Cross-Tab Reports, Graphs, Complex Formulas, and Conditional Formatting.
  • Involved in performance tuning & optimization on BO Universe Design by creating Aggregate tables.
  • Created Users & Groups, Folders, Categories, Events in the Confidential .
  • Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
  • Conducted info-sessions with end users on recurring basis to educate and communicate all existing and new functionalities of Business Objects and Xcelsius.

Environment: Business Objects XI3.1(Designer, WebI, DeskI, Rich Client, Confidential ), XCelsius 2008, QaaWS, Informatica 8.1, Oracle 10g, Unix.

Confidential, Houston, TX

Sr. Business Objects Developer

Responsibilities:

  • Interacted with Business users to gather requirements, analyzed database & discussed with subject matter experts to get knowledge of table structure and the linkage between the tables.
  • Designed, Developed, Maintained and Implemented Universes by creating Joins between Tables, Prompts and created Contexts and Alias to remove cyclic dependencies.
  • Created Customized Hierarchies in universe for various reports and created user variables with calculations beyond those provided by the base universe objects.
  • Extensively used formulas, Filters, variables, prompts, Alerts based on Universes.
  • Developed Web I reports using advanced features like Hyperlinks.
  • Converted some existed Desk I reports to Web I Reports using Report conversion tool.
  • Worked with ETL team in Extracting, Transforming and Loading the data from source files to Oracle 10g using Informatica tool.
  • Developed mapping to implement Type 2 Slowly Changing Dimensions.
  • Involved in designing and updating the data model using Erwin 7.1.
  • Created interactive dashboards, scorecards and business presentations by importing data from excel sheets using XCelsius 2008.
  • Developed flexible queries using navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information. Created custom queries using variables and structures.
  • Developed and supported front-end enterprise reporting, Dashboards, query views/elements through Business Explorer (BEx) QueryDesigner & Analyzer.
  • Generated queries in BExQuery Designer with filters, free characteristics, formulas, selections (restricting), reusable objects like calculated (CKF)/restricted (RKF) key figures, structures, hierarchies, conditions in BEx Analyzer/Report Designer.
  • Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
  • Validation of data by doing query balancing using free hand SQL before moving to Production Environment.
  • Involved in Report performance tuning and universe optimization to minimize the execution time.
  • Provided support to QA testing team to clarify changes and resolved testing issues or bugs.
  • Actively participated in various team meetings& Involved in Unit testing and documentation.
  • Involved in production support and trained business users about the various features in WebI.

Environment: BO XI R2, Confidential, Designer, Web I, Performance Manager, XCelsius2008, QaaWS, Live Office, SAP BW, Import Wizard, Crystal Reports, SQL\PL-SQL, Unix.

Confidential, Chicago IL

Business Objects Administrator

Responsibilities:

  • Interacted with Business users to gather requirements, analyzed database & discussed with subject matter experts to get knowledge of table structure and the linkage between the tables.
  • Installed and configured BO XI3.1 applications (Tomcat apache, QaaWS and Xcelsius) on Windows Cluster with LDAP authentication.
  • Involved in the Business Objects upgrade project from XI R2 to XI 3.1, migrating Universes, users, reports and security groups.
  • Analyzed object compatibility, connections and Universes and involved in troubleshooting issues encountered while migrating.
  • Created, modified/maintained Projects Universe by inserting tables, joins, self joins, views and derived tables.
  • Optimized the usage of user objects, conditions, measure objects and Universe level filters.
  • Enhanced report performances by making changes to the existing Universe design.
  • Extensively worked in resolving timeout issues with WebI and DeskI products.
  • Defined the Universe/report deployment across multiple Universe domains and multiple document domains.
  • Added/created complex objects to the Universe to enhance the report functionality and validated report data by creating ad hoc reports.
  • Involved in Migration (Universe, Reports, Users & Groups, Folders, Categories) from BO XI R2 to XI 3.1.
  • Created reports using free-hand SQL (custom SQL), built hierarchies and facilitated drill down in the reports.
  • Designed and created web templates by Cascading Style Sheet (CSS), Java SDK, Web Application Designer, integrated Web Items, ad-hoc query designer linked with SAP Enterprise Portal, BEx Broadcaster, and migrated 3.x web templates.
  • Created and documented business procedures with respect to Business Objects administration.
  • Documented changes to the Universe, reports functionality and deviations from the original specifications.
  • Involved in preparation of users guide and fine-tuning the specification.
  • Defined production support strategy for the reporting issues.
  • Trained the business users with report generation using WebI XI 3.1.

Environment: Business Objects XI 3.1/ XIR2 (Designer, WebI, DeskI, Rich Client, Confidential ), Crystal Reports XI, SQL Server 2005/2008, SQL Server Reporting Services, Teradata, DataStage

Confidential, Northfield, Illinois

Business Objects Developer

Responsibilities:

  • Installed and configured BO XIR2 applications and Designed Universe, reports and dashboards.
  • Involved in the Business Objects upgrade project from 6.5 to XIR2, migrating Universes, users, reports and security groups.
  • Analyzed object compatibility, connections and Universes and involved in troubleshooting issues encountered while migrating.
  • Designed and implemented reports and dashboards with a variety of visualization techniques.
  • Set up hierarchies in the Universe for providing drill down options in the reporting environment.
  • Performed analysis on extremely complex problems where analysis of situations or data requires evaluation of intangible variance factors.
  • Created complex sub queries, Unions and Intersect for the detailed and cross tab reports to view the data in an organized manner.
  • Participated, contributed and provided guidance on Business Objects development and functionality.
  • Provided Object level Securities using table mapping and used derived tables to define at the prompt level.
  • Defined the loading strategy for including Aggregate tables.
  • Involved in Dimensional Modeling to re-design the existing star schema and identified new facts and dimensions for the existing architecture.

Environment: Business Objects XIR2/6.5 (Designer, WebI, DeskI, Confidential /Supervisor), XCelsius 4.5, Oracle 9i, TOAD, Erwin, Linux

Confidential, Mt Laurel, NJ

Business Objects Developer

Responsibilities:

  • Involved in requirement gathering, resourced financial & marketing data and created oracle data model.
  • Involved in design, update and testing Universes for supporting adhoc queries and canned reports according to periodically changing business requirements.
  • Involved in resolving the loops, using contexts and checked the cardinalities, Integrity of the Universes.
  • Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulae etc.
  • Developed Xcelsius dashboards giving the top5 results and sorting features.
  • Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
  • Scheduled Reports to different groups and in various formats like pdf, excel and rep on a timely fashion.
  • Published reports to users to their e-mail addresses by using Broadcast Agent Publisher.
  • Involved in modifying and debugging Stored Procedures using PL-SQL to enhance reporting capabilities.
  • Trained the users in Business Objects and in using the newly developed Universe and in Report writing by using Query Panel and Slice & Dice etc.

Environment: Business Objects 6.5, Web I, Desk I, Crystal Xcelsius, Oracle 9i and PL/SQL

Confidential, CA

Business Objects Developer

Responsibilities:

  • Analyzed the reporting requirements with the business users and came up with the technical specifications.
  • Involved in resolving table-linking problems like Chasm Traps and Fan Traps using Alias and Context.
  • Maintained Universes and Object Oriented Universe Design Techniques
  • Implemented Row level security in the supervisor to restrict the data to the respective divisions.
  • Created different types of reports like cross Tab, Charts and Master Detail using multi data sources.
  • Created Web Based reports using Web Intelligence and Scheduled through BCA.
  • Created the complex WebI reports such as Cross Tab and Master Detail Reports.
  • Maintained and modified the reports based on the CR’s (Change Request).
  • Involved in the users in using this robust system.

Environment: Business Objects 6.5(Supervisor, WebI, BCA), Informatica 6, DB2.

Confidential

Database & Report Developer

Responsibilities:

  • Extracted Data from different sources of databases using Informatica.
  • Cleansed source data & transformed data with (according to) business rules and built applets.
  • Utilized pre-built transformations as well as customizable transformations.
  • Developed SQL queries and stored procedures for display and modification of Oracle DB.
  • Involved in performance tuning and optimization on Business objects reports.
  • Created report templates for consistency in the look and feel of the reports.
  • Published and scheduled Business Object reports to users using Broadcast Agent.
  • Identified possible enhancements & gaps in requirements, provided feedback to concerned module leaders.
  • Performed smoke testing for builds & patches and identified further testing actions.
  • Performed functional, regression, database, user acceptance and system load testing.
  • Created dimensions, materialized views etc
  • Mapping data items from source systems to the target system.

Environment: Oracle 8i, Business Objects 5.5, SQL, Windows XP

Hire Now