We provide IT Staff Augmentation Services!

Sr. Sap Bo Developer/administrator Resume

0/5 (Submit Your Rating)

Glen Mills, PA

SUMMARY

  • 8 years of cross - functional expertise with Business Objects including creating and supporting Universes, Web Intelligence, Desktop Intelligence & Crystal Reports.
  • Expertise in Business Objects versions XI-R3/XI-R2/XI-R1/6.5/6.1 and tools such as Designer, Desktop Intelligence, Web Intelligence, Voyager, Xcelsius, Import Wizard, Publishing Wizard, Query as a Web Service, Report Conversion Tool, CMC and Live Office
  • Extensive experience in developing strategies and implementing Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouse using SQL Server Integration Services, and Business Objects Data Services.
  • Experience in designing and developing Universes, Full Client/Web-Intelligence reports, publishing and scheduling using CMC and event manager
  • Experience in creating Universes with measures and dimensional objects, Join conditions, Filters, LOV’s, cardinalities, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
  • Created customized aesthetical canned reports and complex ad-hoc reports using WebI for a target group from senior executives to analysts.
  • Strong expertise in creating reports using the Business objects functionalities like Prompts, Slice and Dice, Drill Mode, Filters and Alerts.
  • Expert in creating Dashboards, Scorecards using BO Dashboard Manager/Xcelsius 2008.
  • Expertise in scheduling the documents using Central Management Console.
  • Generated dashboards using Xcelsius 2008 and published the SWF files to BO Enterprise XI 3.0.
  • Responsible for the extraction of data from the flat files using SQL scripts and (or) the scripts of the ETL tool, validating data, and then loading the data into the SQL databases.
  • Experience in creating reports with Crystal Reports and dashboards with Crystal Xcelsius.
  • Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
  • Experience in importing data into HANA database, creating attribute views, analytic views and packages.
  • Extensive experience in creating reports with Charts (bar chart, Pie Chart, dual axis line chart…etc.), Cross-tabs and Sub reports and Drill down Reports Using Crystal Reports 9.0/10,XI, 2008
  • Experience with SAP HANA data modeling and creation of Attribute View, Analytic View, and Calculation View, Analytic privilege by using HANA Studio.
  • Experience with SAP HANA Replication Technologies. Triggered based (SLT) and ETL based (BODS 4.0).
  • Experience with Data extraction from flat files to HANA.
  • Sound knowledge and experience working with SAP HANA areas such as architecture, data provisioning, modeling, user management security and authorizations, Reporting and administration.
  • Involved in reviewing test procedures, defining test cases, reviewing and maintaining test scripts, analyzing bugs and User Acceptance Testing (UAT).
  • Strong analytical, problem-solving, organizational, communication, learning and team skills.
  • SAP BI/BW experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementation, Upgrade and Production Support across various Industries.
  • Implemented full life cycle projects in SAP BI/BW with different versions BW7.3, BI 7.0, and BW 3.X. Expertise using reporting tools like BEX Analyzer, Query designer.

TECHNICAL SKILLS

BO Tools: Business Objects, Web-Intelligence, Import Wizard, Crystal Reports 10, 11, Crystal Reports Explorer, Life Cycle Manager, Publishing Wizard, Report conversion tool, Designer, Planning, Metadata Manager, Xcelsius, Dashboards 4.0, Live Office, QaaWS, Dash Board Manager, Broadcast Agent, Auditor, Web Admin tool, Supervisor, Web Intelligence/Info view.

BO Versions: Business Objects versions XI 4.0/XI-R3/XI-R2/XI-R1/6.5/6.1

Operating Systems: Windows NT 4.0/2000/XP/7, AIX, UNIX, Linux

Databases: Oracle 11g, 10g/9i/8i, SQL, PL/SQL, SQL server, SAP BW NetWeaver, DB2, Sybase, SAP HANA 1.0

Web Application Servers: Web Logic 7.0, Apache Tomcat 4.0, 5.5.26, IPlanet 6.0

ETL Tools: SAP Business Objects Data Services

PROFESSIONAL EXPERIENCE

Confidential, Glen Mills PA

Sr. SAP BO Developer/Administrator

Responsibilities:

  • Designed a multi layered visualization space to accommodate various Key Performance indicators(KPI) and very user intuitive for the CFOs and CEOs of various member firm
  • Developed Xcelsius and webi dashboards based on BW and Information Design Tool (IDT) for integrating SAP and non-SAP data source as a part of FIGR 2.0 project.
  • Support, maintenance and regression testing of existing FIGR 1.0 dashboards as a part of BOBJ upgrade.
  • Designed a dynamic currency conversion feature within dashboard.
  • The default currency can be selected at the reporting portal and all dashboards can be displayed in the same currency with the option of changing.
  • Published the Xcelsius and webi dashboards into SAP BI mobile client for access
  • Setting up OLAP connections, transports for SAP BO and resolving any swapping issues related to OLAP connections.
  • Open document URLs and parameter passing among different Xcelsius dashboards and also Webi reports.
  • Converted Universes from .Unv to .Unx using IDT (Information Design Tool) and published connections and data foundations associated with new .Unx files to Repository.
  • Performance tuning and optimization of Webi and Xcelsius reports. Xcelsius reports which has flash size more than 1MB.
  • Confidential portal setup of FIGR 1.0 and FIGR 2.0 project reports (Xcelsius and Webi) including Glossary information for end users and export to excel functionality.
  • Developed Crystal Reports out of their Database, using Crystal Reports -2011 with sub reports, groups and parameters connecting to Universe.
  • Developing POCs using SAP HANA and experience with universe creation from Information design tool from HANA DB.
  • Experience with connectivity to HANA from SAP BOBJ 4.0 suits of products, used HANA Studio extensively to create views that can be consumed by BO universes.
  • Working with BOBJ administrators for capacity analysis, BO server setup and to resolve issues and review system performance.
  • Expertise in Business Objects Data services 4.0 ETL for Data Migration.
  • Scheduled Batch jobs using Data Services Management Console.
  • Upgraded Business Objects Data Services from XI 3.1 to XI 3.2.
  • Configured the Data services to connect to the SAP R/3.
  • Administering and maintaining BO Data Services management console and repository management.
  • Lead the cross team meeting where the BI Development, System Admin and the BO administrators discussed issues and resolution.
  • Used Crystal syntax language, Business views, cross-tabs, charts, demographic charts, multiple parameters, flash objects etc… within crystal reports.
  • Worked with SAP support team to track product bugs and fix packs
  • Working with User Acceptance Testing (UAT) teams to fix the UAT issues and performing sanity tests in Pre-Prod environment/Validation environments.

Environment: SAP BW, Webi, Dashboards 4.0, BO 3.1, 4.0 SP5, BEx, UDT, IDT, Live Office, Crystal reports 2011, QaaWS, Central Management Console, Launch pad, Windows 7.

Confidential, Austin, TX

Sr. Business Objects Consultant

Responsibilities:

  • Developed ETL Jobs to extract sales and marketing data from SQL Server data source and load into Data warehouse to support the Dashboard requirements.
  • Designed and developed Business Objects Universe to support the Dashboard and Ad-hoc reporting requirements.
  • Resolved technical and logical issues in the business objects application.
  • Created daily, weekly status reports using Xcelsius, Live Office and Qaaws.
  • Created object level and row level securities in designer using security restrictions option.
  • Participated in migration of the Universes, reports, Users, groups from environment to environment using Upgrade Management Tool.
  • Interacted with users and identified Business Requirements to decide on reporting approach needed.
  • Designed, Created and Maintained Universes for Users using Business Objects Designer module.
  • Created new Classes, Sub-classes and Objects as per the standards that were put in place during the Strategy process and identified Objects as Dimensions, Details or Measures.
  • Resolved Loops in Universes using Aliases and Contexts, defined Joins, checked the Cardinality between Tables.
  • Deployed Universes in the Repository by Exporting and Importing Universes between Universes Domain, and over different repositories.
  • Created Data Connections, Data Foundations, Business Elements, Business views using Business View Manager.
  • Imported marketing and sales data into HANA database, created packages, attribute views and analytic views.
  • Created Dashboards Xcelsius models for senior management for business decision making.
  • Created dashboard models using Xcelsius 2008 and published the SWF files to the repository.
  • Design and development of Web Intelligence (Info View) for interactive analysis, sourcing data from SAP BW using single sign-on.
  • Extensively used formula writing, selection coding, summary tables, conditional formatting, sub-reports, hyper linking, image management, charts, graphs, typical drawing elements, conditional coloring, and target highlighting concepts of Crystal Reports in crystal reports XI R2.
  • Expert usage of Crystal Syntax and Basic Syntax for coding record selection formulas & other formulas.
  • Created and modified perfectly formatted webi Reports on Customer Relations and Invoicing which are printed out and directly sent to company customer base.
  • Implemented the resultant changes in Universes, SQL stored procedures, Crystal and WebI reports.
  • Completed Regression Testing on all impacted reports coordinating with business users.
  • Built interactive dashboards using Crystal Xcelsius using Query as a Web Service (QAAWS)
  • Designed, developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008, 2011

Environment: Business Objects 4/ XI release 3.1 SP5/SP3/R2, HP Load Runner, SAP BW, Web-Intelligence, Crystal Reports XI R2, Teradata, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Windows 2008 server, HPSM, Site-scope.

Confidential, Cupertino CA

Sr. Business Objects Consultant/ETL Developer

Responsibilities:

  • Design and development of new Universes for sales reporting and enhancements to existing universes.
  • Created and maintained complex web intelligence reports for the sales team, analysts and senior management.
  • Assisted senior reporting analysts to troubleshoot report/data issues and introducing new functions/capabilities for sophisticated reporting.
  • Provided recommendations to Business in opting the right solution for the universe, reports and dashboards
  • Interacted with end users in gathering requirements for various projects: Migration project, Universes, Reports and Dashboards
  • Designed, Developed, Tested and Deployed Executive Budget dashboards in Xcelsius using QAAWS
  • Active involvement in planning, executing, monitoring and controlling project phases.
  • Created Desktop Intelligence reports and Web Intelligence reports across various functional areas.
  • Developed interactive reports as per the requirements using Crystal Reports 2008 edition.
  • Used alerts, sub-reports, cascading parameters, parameter passing between reports, running totals and other features of Crystal reports tool for effective and emphasized reports.
  • Created Dashboards with Xcelsius using Excel spreadsheets constructed from managed Crystal Reports or Web Intelligence data.
  • Created open hub destinations to move the BW data to other systems
  • Performed tuned Business Objects Data Services Real time and Batch jobs, complex transformations in Data Flows to improve efficiency.
  • Trained small development team on all capabilities within the BODS toolset and the best practices associated with BODS to handle high volumes of data.
  • Data profiling was performed using profiler in Data Services.
  • Use SAP Landscape Transformation (SLT) for real time replication and loading data in to MS-SQL from ECC6 using BO Data services.
  • Created the complex WebI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
  • Developed Analytical Reports, Attractive Dashboard Reports, Webi Reports, Deski reports and Drilldown reports.
  • Created Xcelsius dashboards models using Live office, QAAWS, XML data Provider
  • Created various dashboard reports to measure the performance of several marketing programs.
  • Worked with BIAR and lcmbiarfiles for the deployment of BOE Universe Designer, Web Intelligence reports, BOE Dashboard Builder, Xcelsius and QaaWS.
  • Worked as SAP Business Objects Platform support to work on day to day issues and also involved in communicating with other application teams to maintain platform stability
  • Participated in business requirements Analysis, Report Designing and development of Technical Specifications, Testing and Implementation
  • Created Data Connections, Data Foundations, Business Elements, Business views using Business View Manager.
  • Created Dashboards Xcelsius for senior management for business decision making.
  • Created new Universes for Reporting and Dashboard from scratch to build reports in DeskI, WebI and modified the existing Universes to improve the performance in Business Objects XI 3.1

Environment: Business Objects XI release 3.1 SP3/R2, Desktop/WebI-Intelligence, SAP BW, BEx, Data Services 3.1, Crystal Reports 2008, Teradata, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Windows 2003 server, HPSM, Site-scope.

Confidential, Memphis TN

Business Objects Developer/Administrator

Responsibilities:

  • Created new Universes for Reporting and Dashboard from scratch to build reports in DeskI, WebI and modified the existing Universes to improve the performance in Business Objects XI 3.1.
  • 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 LOVs, linking Universes, hierarchies, @Prompts in the universe.
  • Resolved loops and traps using aliases and contexts. Created complex joins like outer joins and equi-join 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.
  • Extensively used calculations, variables, breaks, sorting, drill down, slice and alerts for creating Business Objects reports
  • Designed Universes by defining joins, cardinality between tables, linked the existing Universes using Business Objects XI R2.
  • Involved in complete Business Objects Data Services installation and configuration.
  • Created the data stores to communicate source and target with BODS
  • Created linked, unlinked, parameterized and on-demand sub-reports for various business needs.
  • Fine-tuned the existing universes to enhance the performance in reporting.
  • Created reports scheduled for different file-based/ schedule-based events, distributed in email, PDF and HTML format.
  • Extensively tested the universe, reports, dashboards with the business users
  • Efficiently tuned reports with performance issues with excellent SQL skills, Aggregate Tables
  • Effectively Maintained and Deployed universes, reports, dashboards to various environments
  • Experience in developing Dashboards, Pixel Perfect Reports using SAP BO - Crystal Xcelsius, WEBI.
  • Created mock-up Dashboards for initial user presentation in the process of designing Technical Specifications.
  • Developed ETL Jobs to extract data from different sources and load into Data warehouse to support the Dashboard requirements.
  • Decided on tools used in specific projects including Performance manager, Xcelsius, Crystal reports, Web Intelligence.

Environment: SAP BW, Business Objects XI release R2/3.1, Data Services, Web/Deski-Intelligence, Crystal Reports 2008, Data Integrator 11.7, Oracle 9i/10g, PL/SQL, Xcelsius 2008, Windows 2003 server, UNIX.

Confidential, Memphis, TN

Business Objects Consultant

Responsibilities:

  • Built static Dashboards using Crystal Xcelsius with the data in Excel files
  • Updated the static models with live data connecting via the Web Service connectors like QAAWS, Live Office
  • Built dynamic dashboards with live data connecting to CX Drill-Down Universe using QAAWS and Live Office
  • Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008
  • Generated dashboards using Xcelsius 2008 and published the SWF files to BO Enterprise XI 3.0
  • Created a Sales Quota Performance Universe, created classes, objects, measure objects, conditions, joins and exported to Enterprise repository in BO XI 3.0
  • Created reports in WebI, DeskI in Business Objects XI 3.0
  • Installed Crystal Xcelsius, Query as Web Service, Live Office Add in (Client) and created dashboards
  • Used QAAWS, Live Office Connector to build the Xcelsius Dashboards. Developed and Tested dashboards using Crystal Xcelsius 2008 using Live Office as data source.
  • Created, modified and scheduled Desktop Intelligence and Web Intelligence Reports based on Specific time, events, and calendars and in various formats for Customer Service, Sales, Invoices, Marketing, Customer Retention, User feedback, Web Traffic Analytics etc.
  • Worked on troubleshooting of different database connectivity, performance tuning.
  • Created advanced queries using Query as a web service. Applied Query as a web service to create Xcelsius dashboards from BO universe.
  • Experience in the development of reports for financial needs of the business using Business Objects Reports.
  • Created Web Intelligence documents for user reporting needs, to retrieve data by building queries using Business Objects universes and to use Web Intelligence to enhance documents for easier analysis.
  • Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
  • Designed interfaces to bring legacy Siebel and oracle historical CRM data into SAP BW system (Interface conversion) for each application for last two years of business data.
  • Worked on functions of BEX Query Designer in the state-of-the-art BEX Web Application Designer, excel-based application design with the new BEX Analyzer.
  • Experience in Scheduling the Reports using Business Objects Enterprise.
  • Extensively tested the universe, reports, dashboards with the business users
  • Efficiently tuned reports with performance issues with excellent SQL skills, Aggregate Tables
  • Effectively Maintained and Deployed universes, reports, dashboards to various environments
  • Deployed dashboards in Infoview portal and also embedded as PowerPoint. Defined and implemented end user security in dashboard and in Universe.

Environment: Business Objects XI R3.1, Xcelsius 2008, QaaWS, Oracle 10g, MS-Office, SAP BW, BEx, CMC, QaaWS.

Confidential

Business Objects Consultant

Responsibilities:

  • Responsible for setting up the Database connections, assigning privileges.
  • Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
  • Worked in creation of multiple universe and document domains for development, test and production Environments.
  • Good experience in creating and maintaining Secured, Shared and Personal connections.
  • Involved in designing and developing of Universe for reports generation.
  • Checked the integrity function for existence of loops and resolved them by using aliases and contexts.
  • Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.
  • Manipulated the data by creating user defined objects using advanced database functions
  • Created Universes and Reports using Teradata/SQL server/Oracle databases in BOXIR2.
  • As a Business Object Architect and Business Analyst My Contribution for this project is to convert BRD (Business Requirement Document) to FRS (Functional Requirement Specification), Universe Design in XI R2, Testing and validating Mock Up reports.
  • Tested the universe on a regular basis after the development work and exported the Universe to the repository.
  • Created Complex reports using multiple data providers and synchronized the data in Web Intelligence using Merge Dimensions functionality.
  • Coordinating decisions on functional use, code decisions, reporting analysis, data conversion, policies, and standards within the application area of the department.
  • Developing training documents & delivering end user training sessions in support of Production rollout.

Environment: Business Objects XI 3.1/Xir2/6.5 (Designer, DeskI, WebI, Info view, Auditor, CMC, and Import Wizard), Oracle 10g, PL/SQL, and Windows XP

Confidential

Business Objects Developer

Responsibilities:

  • Developed various Charts, Graphs and drill down reports used Toad to verify if the data pulled by the report is correct compared to the database data and also to verify if the joins used in designing the universe are correct.
  • Created several new objects and classes in the Universe based on the report creation requirements.
  • Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting User Needs and Requirements from both technical and strategic views of an organization.
  • Conducted Study to Build Universe’s Classes and Objects involving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
  • Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc., and also Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.
  • Designed complex reports based on discussions with user groups and created various objects using built-in @functions (like @prompt, @select, @where, and @aggregate), complex SQL queries and joins. Thus Considering best business Practices using Business Objects Desktop Intelligence.
  • Built static Dashboards using Crystal Xcelsius with the data in Excel files with live data connecting via the Web Service connectors like QAAWS, Live Office
  • Built dynamic dashboards with live data connecting to CX Drill-Down Universe using QAAWS and Live Office
  • Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008.

Environment: Business Objects with Desktop Intelligence, Crystal Reports, SQL Server 2000, SQL, MS Access.

We'd love your feedback!