We provide IT Staff Augmentation Services!

Senior Bi/bo Developer Resume

0/5 (Submit Your Rating)

California, CA

SUMMARY

  • SAP BW/BI/BO Technical Consultant with 10 years of professional experience in IT covering analysis, design, development, testing and system maintenance of business applications and with 5+ years of experience in SAP BI - BO Integration projects.
  • Expertise in Creating Bex Queries using best practice methodology to be utilized by BOBJ.
  • Created 30+ Xcelsius Dashboards so for which includes using SAP BI as data source.
  • Experience in Business Objects XI, Central Management Console, Business Objects Designer, Desktop Intelligence, Info View, Web-Intelligence Security Viewer and Live Office.
  • Involved in 3 full life cycle implementations which includes 2 Net weaver 04s (BI 7.0) and 2 full life cycle implementation of BO XI 3.x and BI 4.0.
  • Separated users into different categories and created security matrix for assigning security for users and groups.
  • Good knowledge on Tableau dashboards and reports.
  • Used Analytical components, Basic Components and Container Components to design I-Pad compatible design studio dashboard.
  • Used components like Charts, Cross tabs reports, Filters, tab sets etc. for designing interactive dashboards.
  • Integrated data sources for the components either directly or by writing scripts.
  • Expertise in implementing Complete Life-Cycle using ASAP methodology that includes gathering requirements, analyzing the processes, performing AS-IS Analysis, Identifying and analyzing the Gaps, Implementation, Designing, Configuration, Customization, Unit/Integration Testing, Go-live and Post-go-live support along with other Post-Implementation.
  • Used Informatica Designer tool for ETL Processing and used various transformations like Expression, Aggregator, Sorter, Joiner, Lookup transformations.
  • Good knowledge in usingBODSfor ETL process betweenLegacy,BW and Hana systems.
  • Used different type of transformations like Platform, Integration and Data Quality set of Transformations for ETL processing.
  • Used SCD Type-2 Transformation for maintaining historical data.
  • Created dashboards directly over Universes using Query Browser in SAP BI 4.0
  • Extensively worked on Query building, filtering, free Characteristics, RRI-Jump queries, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.
  • Extensive experience in Business objects reporting, in the context of developing the Universe using the Universe Designer, IDT and the Analytics using, Xcelsius, Web and Crystal..
  • Effective skills to build reports in Business Objects. Expertise in Creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab sets, Canvas Containers.
  • Experienced in creating system and User documentation as per the business requirements.
  • Experience with INFOVIEW to create Web Intelligence, Desk Intelligence Reports over the Universe Created. Extensively Worked in Combination Queries. Created Web I reports over Multiple Queries.

TECHNICAL SKILLS

Business Intelligence: Business Objects BI4.1/XI 3.1/XIR2/6.x/5.x - Central Management Console, Central Configuration Manager, Central Management Server, Infoview, Web / Desktop Intelligence Reports, Design Studio, Dashboards Designer, Crystal Reports 2008/ XI/10/9, Live Office, Import Wizard, Report Conversion Tool and Services, Promotion Management, Broadcast Agent Scheduler.

Data Warehousing: Informatica Powercenter V7, Informatica PowerMart 7.1/6.2/5.1/4.7 , Repository Manager, Designer.

Dimensional Data Modeling: Dimensional Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT & Dimension Tables, Physical and Logical Data Modeling.

Databases: Oracle 11i/10g/9i, DB2 8.2/8.0, MS SQL Server 2005/2000

SAP BI/BW, ERP: SAP BI 7.3/7.0, SAP BW 3.5, SAP ECC 6.0/5.0, R/3

Environment: MS Windows 95 - 2000, MS- Windows NT/XP

PROFESSIONAL EXPERIENCE

Confidential, California, CA

Senior BI/BO Developer

Responsibilities:

  • Involved in business user meetings to gather requirements by analyzing the business processes.
  • Converting functional specs into technical specs and designing the objects as per the requirement.
  • Worked extensively on modules like IDT, UDT, Web Intelligence, and Launchpad.
  • Converting the relational connection webi reports to BICS.
  • Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Webi) by utilizing BICS Connection and Universes.
  • Extensive experience in working with data synchronization options like Merge Dimensions in BI 4.1 to fetch data from two different sources into a single target report.
  • Created Complex and highly formatted Webi reports by using functions, Variables, Sections, Breaks and Alerts.
  • Used Graphs, Alerts, Filters, Breaks, Sorting, Hyperlinks, Ranking and Prompts to customize reports based on user requirements.
  • Created interactive dashboards in web Intelligence using Pie Chart, Column and Stacked Column charts, Combined charts and so on.
  • Designed dashboards using Tableau software for analysis purpose.

Environment: SAP BI 4.1 (IDT, UDT, BI Launchpad, Webi Rich Client), SAP BI 7.3, Oracle 11g, SQL Server 2012, SQL Developer, Windows XP.

Confidential, Savannah, GA

Senior BI/BO Developer

Responsibilities:

  • Involved in business user meetings to gather requirements by analyzing the business processes.
  • Analyze the Requirement Documents for Universes & BO Reports. Converted the Functional specs to technical specs.
  • Worked extensively on modules like IDT, Web Intelligence, Launchpad, and Promotion Management.
  • Designed and developed Multi-Source Universes using Information Design Tool (IDT) on Relational Tables and BW sources.
  • Created Dynamic Data Providers by making the connection as dynamic in IDT.
  • Implemented Custom Functions at enterprise level to replicate client’s local application functions which are used for calculation and extract data.
  • Created custom navigation path at Business layer level which are used for various drill operations at report level.
  • Created derived tables and implemented complex calculations in data foundation.
  • Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Webi) by utilizing BICS Connection and Universes.
  • Created Dashboards using SAP Lumira 1.19 and Design Studio 1.3.
  • Wrote scripts for loading data into components and making the design studio dashboard as an interactive dashboard.
  • Extensive experience in working with data synchronization options like Merge Dimensions in BI 4.1 to fetch data from two different sources into a single target report.
  • Created Complex and highly formatted Webi reports by using functions, Variables, Sections, Breaks and Alerts.
  • Used Alerts, Filters, Breaks, Sorting, Hyperlinks, Ranking and Prompts to customize reports based on user requirements.
  • Worked with CMC for Content and user management activities, Server performance tuning, security assignments and promotion management.
  • Involved in server management and server performance activities across the enterprise.
  • Trained many users on Business Objects 4.1 suite.

Environment: SAP BI 4.0, 4.1 (IDT, BI Launchpad, Webi Rich Client, Promotion Management), Design Studio 1.3, SAP Lumira, BODS 4.2, SAP BI 7.3, Oracle 11g, SQL Server 2012, SQL Developer, Windows XP.

Confidential, Orlando, FL

Sr. Business-Objects Consultant/ETL Quality Analyst/Administrator

Responsibilities:

  • Involved in the business user meetings to gather requirements by analyzing the business processes.
  • Analyze the Requirement Documents, Data Models, Mappings, ETL, and Universes & BO Reports.
  • Worked extensively on modules CMC, Designer, Web Intelligence, Launchpad, Crystal, Crystal Xcelsius, Auditor, Infoview, Import Wizard, Metadata Manager, SAP Business Objects Explorer, BO Mobile, Widgets and Report Conversion Tool.
  • Designed and developed Universes using Information Design Tool (IDT) on Relational Tables.
  • Worked with SAP BO Design Studio and created dashboards using SAP BI as source.
  • Worked with Tableau and created with a dashboard.
  • Used different components like Charts, reports, buttons, Grids, tab set, filters etc. and designed an interactive dashboard.
  • Used different kinds of design studio filters like Dimension filter, Drop down filter and Background filters in the dashboard and integrated the source data to the dashboard components.
  • Created Pre-Canned and Ad-hoc reports using Business Objects Web Intelligence (Webi) by utilizing BICS Connection and Universes.
  • Worked on BO Explorer in order to analyze the required business information.
  • Designed, developed and managed Universes in Business Objects Designer for generating reports against SAP BW.
  • Extensive experience in working on IDT (Information Design Tool). Created BICS Connection using IDT in SAP BI 4.0.
  • Created Xcelsius dashboards directly over Bex queries using BICS Connectivity in SAP BI 4.0
  • Extensive experience in working with data synchronization options like Merge Dimensions in BI 4.0 to fetch data from two Universes.
  • Designed Complex Web I reports including Combined Queries and Drill Down reports.
  • Created Universes over BEx queries and Info cubes of SAP BI using Universe Designer. Created Xcelsius Dynamic Dashboards over SAP BI data.
  • Created Webi reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
  • Created Xcelsius dashboards over SAP BI query (BEx). Designed Xcelsius Dashboard with Filters, Label based menus, Flash Variable connections, SWF loader, Tabsets, According menus, List Builder, List Views, Sliders, Fish Eye menu, Play Selectors, Grids Etc.
  • Used Alerts, Filters, Breaks, Sorting, Ranking and Prompts to customize reports based on user requirements.
  • Designed Xcelsius Dashboard with Filters, Label based menus, Flash Variable connections, SWF loader, Tab sets, According menus, List Builder, List Views, Sliders, Fish Eye menu, Play Selectors, Grids Etc.
  • Worked on BEx Query Designer and built queries using Restricted Key Figures (RKF’s), Calculated Key Figures (CKF’s), Free Characteristics, Structures, Variables, Formulas, Navigational Attributes, Filters, Conditions, and Exceptions to meet the business requirements.

Environment: SAP BI 4.0,(IDT Tool, BI Launchpad, Designer,) BO XI 3.1 (CMC, Designer, Webi, Webi Rich client, Infoview, Import Wizard), Xcelsius,Tableau, Design Studio, SAP BI 7.3/7.0, SAP BW 3.5, SAP ECC 6.0/5.0, R/3, Oracle 10g, Toad, SQL Developer, Windows XP.

Confidential, Buffalo, NY

Sr. Business Objects Analyst/Developer

Responsibilities:

  • Working as a Business Analyst in taking decisions for the new Applications and gathering requirements from end users. Involved in the prototyping, effort estimate, User Licenses and worked with SAP to get training for the users.
  • Requirement analysis and preparing the design document.
  • Inserting tables, specifying the joins and checking the cardinalities.
  • Creating Alias & Context for resolving loops and traps. Creating classes, objects and specifying the hierarchies and creating per-defined filter conditions.
  • Perform the Integrity check for Universe and exporting to the development servers.
  • Developed reports using BO functionality’s like Multiple Data providers, Drill Down, @Function, Cross Tab, Alerter, Filters, Ranking, Formulae etc.
  • Analyzed and collected the user requirements/specifications for BOE Infrastructure enhancement. Documentation of entire BOE XI 3.1 SP2 up-gradation process.
  • Created the Custom Access Levels and implemented the security on Folders, Universes, Connections and Applications in Test and Production environment for user-groups in CMC.
  • Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
  • Designed cascading prompts, customized lov’s, linking Universes, hierarchies, @Prompts in the universe.
  • Resolved loops and traps using aliases and contexts. Created complex joins like outer joins and equi-join & theta joins and checked the integrity of the Universes.
  • Created Webi Reports by using multiple data providers, merge functions, variables, sections, breaks & filters in Webi and Deski.
  • Involved in Up-gradation of the System from XI 3.1 to BI 4.0 using Upgrade Management Tool.
  • Migrating the Universes, Reports & Connections from Development environment to Test and then to Production environment using Promotion management in BI 4.0.
  • Involved in taking back up of the system by using one of the technique called .BIAR and then upgraded the system.

Environment: SAP BI4.0,(IDT Tool, BI Launchpad, Designer, SAP Explorer, Exploration Views, BI workspace, BI Module) BO XI 3.1 (CMC, Designer, Deski, Webi, Webi Rich client, Infoview, Auditor, Import Wizard), SAP Explorer, Crystal Reports 2008, Teradata 12, Oracle 10g, PL/SQL, Windows XP.

Confidential, Cincinnati, OH

Business Objects Developer/Administrator

Responsibilities:

  • Worked extensively on modules like CMC, CMS, Designer, Web Intelligence, Desktop Intelligence, Crystal, Crystal Xcelsius, Auditor, Infoview, Import Wizard and Report Conversion Tool.
  • Migrated the Users, Groups, Universes, Personal Folders, Connections, Reports (Deski & Webi) from XIr2 to XI3.1 using Import Wizard.
  • Experienced in installation, configuration and setting up the security from the scratch in the new environment (BO XI3.1).
  • Created new Universes from scratch to build reports in Deski, Webi and crystal and modified the existing Universes for performance in Business Objects XI 3.1.
  • Used aggregate awareness, short-cut join, @ functions, Derived Tables at Universe Level for Query performance Enhancement.
  • Designed cascading prompts in the universe to filter the names based on business units and implemented the Object level and row level securities in the Universe.
  • Resolved loops and traps using aliases and contexts. Created complex joins like outer joins and equi-join & theta joins and checked the integrity of the Universes.
  • Implemented new security procedures at Universe for different groups by creating multiple connections to avoid spool space issues in Database.
  • Created Complex Reports by using multiple data providers, merge functions, variables, sections, breaks & filters in Webi/Webi rich client and Deski.
  • Developed Deski & Webi/Webi Rich client reports by using advanced functionalities like Optional prompts, Data tracking, Custom Sql at Report level and calculation contexts.
  • Experience in creating Dashboards for the Top level management to review the Auditing of BO Applications through connected model using Dashboard manager.
  • Responsible for creating the reports (On demand, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab, graphical)
  • Created canned and Adhoc Reports for Business Users Reporting.
  • Created various kinds of Reports for Sales and Finance departments like Actual, Planning, Forecast, Fixed Income, Estimates.
  • Trained Business users in creating Adhoc reports and educated how to implement the best standards when creating the reports.

Environment: Business Objects XI 3.1/XIR2 (CMC, Designer, Deski, Webi, Webi Rich client, Infoview, Auditor, Import Wizard), Crystal Reports 2008, Teradata 12, Oracle 10g, PL/SQL, Windows XP.

Confidential, Austin, TX

Software Engineer/BO Developer

Responsibilities:

  • Document all design and development efforts in accordance with Software Development Life Cycle standards
  • Performance monitored Production WI servers, and improved Performance by using various deployment techniques.
  • Created Data Mart using multiple Data Sources like Oracle and Sql Server.
  • Developed an OLTP (Online Transactional Processing) complex universe and 2 other simple universes on oracle database and finally merged all the 3 universes into a single Universe according to the user requirement.
  • Part of Report development created metadata reports by extensively using multiple data provider’s @functions and inner query concepts to generate Thin client Reports.
  • Created different Categories in the repository and published full client reports corporate documents to their respective categories.
  • Migrated BO 6x repository to BO XI repository using Import Wizard.
  • Migrated universes and reports to PROD and DEV environments from BO 6x to BOXI version to their respective folders using Repository Migration Wizard.
  • Created and customized application dashboards using Application Foundation to meet the requirements of higher level analysis.
  • Developed dashboards and scoreboards for detailed analysis.
  • Responsible for User Support and Training for Full Client and Webi and resolving Trouble Tickets/Cases reported by user.
  • Applied Open document functionality in Webi to link the Reports according to the User requirements.
  • Created different type of Crystal reports including: Cross-tab, Conditional, Drill-down, Top N, Summary, OLAP, Sub reports, Drill-down and Parameter prompts
  • Moving the report objects from Dev Stage to Prod Environments.
  • Detected Cardinalities and Loops. Resolved the Loops, checked the integrity of the Universes and created List of values, finally exported to Repository.
  • Involved in performance tuning of Business Objects Report which are running significantly slower.
  • Extensive use of Advanced functions in universes, reports Confidential .g.: hierarchies, @prompts, conditional hiding, sorting,etc
  • Deployment of reports to different environments depending on Project phase like Testing, Development and Production.
  • Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.

Environment: Business Objects XI 3.1/Xir2 (Designer, Deski, Webi, Webi Rich client, Infoview, Crystal Reports 2008, Oracle 10g, Windows XP.

Confidential

Software Engineer / Business Objects Developer

Responsibilities:

  • Converting high-level design specifications to detailed functional and technical specifications.
  • Created Data Mart using multiple Data Sources with Oracle and Sql Server.
  • Developed an OLTP (Online Transactional Processing) complex universe and 2 other simple universes on oracle database and finally merged all the 3 universes into a single Universe according to the user requirement.
  • Developed complex universe and generated reports exclusively using Full client.
  • Worked on Adhoc reports according to user requirements like Deals, Tactical Initiatives, Strategic Initiatives using thin client.
  • Part of Report development created metadata reports by extensively using multiple data provider’s @functions and inner query concepts to generate Thin client Reports.
  • Created different Categories in the repository and published full client reports corporate documents to their respective categories.
  • Developed dashboards and scoreboards for detailed analysis.
  • Re-pointing reports from old Universe to New Universe. Fixing synchronization issues.
  • Deployment of reports to different environments depending on Project phase like Testing, Development and Production.
  • Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
  • Used stored procedures, Free Hand SQL and excel files as data provider for creating reports.
  • Tested reports before posting them to the repository (query optimization & performance).

Environment: Business Objects 5.1.7, Designer, Supervisor, Thick-client, Thin-client, BCA Scheduler, SQL Server 2000, Oracle 8i, PL/SQL, windows 2000.

We'd love your feedback!