Senior Sap Business Objects Consultant Resume
Wichita, KS
SUMMARY
- Over 8+ Business Objects 4.0/R3.1/R2/R 1/6.5/6.1/6.0/5.1 ,CMC, Designer, Info view, Web - Intelligence XI/6.0/2.7,Supervisor, xcelsius dashboard,Auditor, Application Foundation Dashboard Manager, Application Foundation 6.0/2.5 & Dashboard Manager, Business Objects Reporting, Business Objects SDK, Web-I SDK, OLAP, OLTP, Broadcast Agent, Publisher.
- Expertise in SAP Business Objects 4.0/XI3.1 installation/configuration/implementation and support in a Windows 2008 environment, SQL Server 2008
- Expertise in upgradation the Business Objects XI 3.1 to 4.0,4.1
- Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
- Expertise in working Crystal Decisions, Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2,2008,2011 Crystal Xcelsius 2008.
- Worked with Crystal Report for creating complicated reports using Web Elements also including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
- Expertise in Universe designing, developing and generating Complex Reports, Adhoc Reports, Dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy test.
- Proficiency in Scheduling, Publishing and Distribution of Business Objects reports using Infoview, CMC and Broadcast Agent server.
- Strong experience in SAP BI/BW 7.0 - Business Objects 3.1/4.0, SAP BW-BO
- Extensive experiences in developing Stored Procedures, Views, Functions, Triggers, XML and complex queries on SQL Server 2000/2005/2008 and Oracle 8i/9i/10g/11i.
- Expert in tuning the performance of SQL queries and ETL process and Involved in performance tuning of Business Objects using TOAD.
- Extensively worked on Data Warehousing Design Methodology, Data Warehouse Concepts.
- Experience in creating reports involving formatting options such as Charting, Mapping, Grouping, Sorting, Alerting, Filter, Drill down, Field highlighting.
- Expertise in creating Hyperlink of one report to another report through parameter fields and open doc.
- Proficient knowledge on BOXI Architecture and new features.
- Proficient in building, implementing, testing and maintaining Business Object Universe.
- Worked on BO XIR2 administration - User/group security, application security, data row level security, scheduling and distribution strategies.
- Demonstrated understanding of Dimensional Modeling (Star Schema and Snowflake) and other Data -Warehousing Concepts.
- Working experience in SSRS for reportsExperience in gathering customer requirements and functional requirements and converting them to technical requirements.
- An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
- Diversified domain experience in Finance, Insurance and Banking.
TECHNICAL SKILLS
Reporting Tools: Crystal Reports 2008/XIR 2/10.0/9.0/8.0 , BI360, Business Objects XI 3.1/R2/6.5/5.x/4.x, Universe Designer, Xcelsius 2008/4.5.
Business Intelligence Tools: Desktop Intelligence, Web-Intelligence, Info View, CMC, Performance Management, Report Conversion tool and Import Wizard, SSIS.
Databases: SQL Server 2005/2000/2008/2008 R2, Teradata, Oracle 9i/10G, MS Access 2007/2003/2000/97.
Operating Systems: WINDOWS7/Vista/XP/ 2003/2000/98/95 , Windows NT/ 2000/2003/2008 UNIX, MS-DOS.
Languages: C, C++, PL/SQL, T-SQL, VB.Net, C#.
Web Servers: IIS 7.0/6.0/5.1.
PROFESSIONAL EXPERIENCE
Confidential, Wichita KS
Senior SAP Business objects Consultant
Responsibilities:
- Pork CPS SAP Business objects 4.1 and Crystal Reports
- Developed .unx file using 3 layer architecture (.cns, .dfx, .blx) stored in Project with IDT tool
- Created Secured (.cnx) connection in IDT(Information Design Tool)
- Designed Data Foundation (.dfx) using multiple data sources using IDT
- Inserted calculated columns in tables at Data foundation level
- Defined Business rules (Joins, Alias & Contexts) in Data Foundation
- Published Data Foundation and Secured connection to Repository
- Created Business Layer using Data foundation and defined @functions @aggregate aware, @select, @prompt, @where in the creation of dimensions, measures and conditions
- Configured Parameters and LOV in Data foundation
- Customized Business layer by assigning row level and column level security using security editor
- Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT
- Implement Aggregate awareness, hierarchy functionalities are developed in Business Layer(.blx)
- Created the Classes, objects, detail objects, measures and filters in universe by using Universe Design Tool (UDT).
- Designed snowflake, star and multiple star schemas in universe
- Determined the fallback locale in linked universes, created the contexts and defined derived tables.
- Involved in the implementation of Business Objects 4.1
- Developed the complex webi reports and crystal reports
- Testing, maintaining and supporting the universes, webi reports and crystal reports.
- Updated the universes with derived tables, alias tables and contexts .
- Solved the traps and loops in universes.
- DESKI to WEBI conversion SAP Business Objects 3.1
- Converted the reports from DESKI to WEBI using the report conversion tool.
- Manually converted the Deski reports to webi reports which cannot be completely converted by the report conversion tool.
- Used the different data sources Universes, Custom SQL and Excel.
- Completely converted the partially conveted reports by the report conversion tool.
- Solved the ranking issue in conversion by manually ranking objects.
- Updated the contexts and solved the structural error in the cross tab.
- Converted the complex reports with 30 tabs with different data analysis crosstabs and graphs.
- Developed, tested and implemented new PL/SQL Packages, Functions and Stored Procedures, Triggers etc.
- Updated the universe for some of the Custom SQL in report by creating the derived tables.
Environment: Business Objects XI R2/XI 3.1, 4.0, BO Designer, Web Intelligence, Desktop Intelligence, Crystal Reports 2011, Oracle 11g, SQL, PL/SQL, Windows XP/2007.
Confidential, Deerfireld IL
Senior SAP Business objects Consultant and Report developer
Responsibilities:
- Involved in Customer meetings to understand the Business of the Project.
- Sugested the kind of report required for the Business and gathered the user requirements.
- Created Report Definition Document (RDD) for the project
- Worked from scratch in understanding the data and asked database people to create views which will be feasible at the reporting end
- Designed the universe structure by understanding and analzing the data with the help of Entity Relationship(ER) diagram
- Defined joins,cardinality and context, checked for traps and loops
- Created Derived tables at universe to reduce the complexity of data retrival at Report level
- Modified the universe in a way it pass through the Walgreens standards in Universe Validation at the migration
- Generated webi reports with the designed universe to meet the business requirements
- Planned, developed, tested and executed the upgrade project complex Business Objects implementation from v3.1 to v4.1.
- Performed report testing and compared the results with the sample data provider by the customer
- Exported the reports to info view to publish it to the end user and schedule report according to the end user requirements
- Designed Data Foundation (.dfx) using multiple data sources using IDT and Inserted calculated columns in tables at Data foundation level
- Defined Business rules (Joins, Alias & Contexts) in Data Foundation and published Data Foundation and Secured connection to Repository
- Developed WEBI reports on SAP BW Bex Queries using BICS.
- Involved in full life cycle of the project Dev,QA,Pre-prod and Prod
- Worked on Excelsius 2008 and developed a mock up dashboard for end user to look and feel about dashboard
- Developed 3 dashboards using different chart, selector, and connectivity components and interlinked to each other so that the user can navigate from one dashboard to the other.
- Designed and developed various Metrics, Analytics like speedometer, Interactive Charts, Alerters and Goals for creating Dashboards using Dashboard Manager.
- Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
- Created BEX queries with a SAP BW (Business Warehouse) system and Implemeted HANA on BW and executed bex queries
- Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT
- Developed a Dashboard Report which meets all the end user requirement
- Created Business Layer using Data foundation and defined @functions @aggregate aware, @select, @prompt, @where in the creation of dimensions, measures and conditions
- Worked on the relative URL’s to open the dashboard in respective environments from InfoView
- Worked on the export functionality which opens the webi report from dashboard along with the displayed data.
- Worked with BO Admin on the open doc URL by using Trusted logon token which will help to open from InfoView with single user ID
- Used multi-dimensional analysis (Slice & Dice and Drill Functions) to organize the data along a combination of Dimensions and Drill-down Hierarchies giving the ability to the end-users to view the data from heterogeneous viewpoints.
- Designed, developed and modified various Reports, Sub-Reports and Standard Reports using Crystal Reports 2010
- Developed the effective Drill-down Reports, cross tab Reports, Parameterized Reports and Sub reports using Crystal Reports 2010
- Extensively involved in using of formulas fields, parameter fields, Group selection, record selection and Crystal syntax in Crystal reports.
- Experience working with Crystal Xcelsius to display summary-level business data in a rich and intuitive format.
- Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
- Updated data for crystal Xcelsius visualizations by using export setting commands. Complex data was retrieved from excel files, Flash files using Flashvars property as well as dynamically from external XML data sources
- Performed data analysis test and retrieved the data which is required for end user
- Prepared instructions Document and trained the end user how to generate the report on demand
Environment: Business Objects XI R2/XI 3.1, 4.1, BO Designer, Web Intelligence, Desktop Intelligence, SAP BW, SQL, PL/SQL, Hana, Windows XP/2007.
Confidential, Nashville
Senior SAP Business objects Consultant and Crystal Report developer
Responsibilities:
- Extremely worked in developing Universes, Stored Procedures,Webi Reports and Crystal Reports.
- Designed, developed, tested and supported reports in Web Intelligence and Crystal Reports 2008.
- Extensively used T-SQL and PL/SQL statements to write complex queries and wrote new stored procedures, views, custom functions.
- Worked closely with Business Analysts to produce reports based on the requirements.
- Designed, developed, tested and supported reports in Web Intelligence and Crystal Reports.
- Created reports that include Grouping, Sorting, selection criteria, Running Totals, Alerting, Drill-down and Parameter prompt.
- Run reports and performed independent validation and verification against data and ticket information.
- Involved in development of Metrics Annuity Reporting universe.
- Used derived tables using SQL, materialized views for best performance and used contexts and alias tables to solve the traps and loops in the universe.
- Changed the universe parameter settings to optimize the performance of universe.
- Designed reports to set up a scheduling system for reports to be delivered automatically to inbox to users.
- Part of the planning, implementing and executing the upgradation team from the Business Objects XI 3.1 to 4.0.
- Converted Business Objects Deski Reports to Web Intelligence reports using Report Conversion Tool and published them to repositories.
- Resolved issues like loops by creating aliases and contexts as required removing the cyclic dependencies.
- Extensively worked with the performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making the customized Query to the Report generated Query.
- Applied row level and object level securities to different groups to restrict the data in Supervisor module.
- Responsible for optimization of Report queries, designed complex formulated metric objects with aggregate awareness; defined contexts for different aggregate fact tables; defined cascading prompts, created predefined filters, created user defined objects and built custom dynamic LOVS.
- Worked in conjunction with database developers to develop PL/SQL code for Reports.
- Conducted user training sessions, prepared training material and tips. Trained users on how to use the Info view and using WEBI for building Ad hoc Reports.
- Worked with business users and technology group in gathering requirements for developing reports and data analysis.
Environment: Crystal Reports XI/ 2008, Business Objects XI R2/XI 3.1,4.0 Infoburst, BO Designer, Toad, SQL Developer,PL/SQL, Web Intelligence, Desktop Intelligence, DB2, Oracle 9i/11i/10g, Windows XP/2007.
Confidential
Senior SAP Business objects Consultant
Responsibilities:
- Gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes, WEBI Reports and Informatica mappings.
- Promoted and worked with client team members to formalize and institute standards for data modeling, change processing and version control.
- Created new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R3.1. (BOXI R3.1)
- Created Web I reports from multiple data providers and synchronized the data using merge dimensions option.
- Responsible for SQL tuning and optimization using Explain Plan and Indexes.
- Extensively worked with the performance issues at Query Level and Report level by Creating Prompts, Creating derived tables and also making the customized Query to the Report generated Query
- Developed the Bex queries and used them for the webi reporting purpose.
- Responsible for creating the Complex Crystal Reports (on demand, AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Aging Reports).
- Migrated users/groups, Universes, Reports, connections to BO XI R3 using Import Wizard.
- Performed unit testing, system testing for universe, reports and security management.
- Trained the end users in working with the Business Objects user module, Dashboards and provided technical expertise.
- Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
- Used derived tables using SQL, materialized views for best performance and used contexts and alias tables to solve the traps and loops in the universe.
- Extensively used Business Objects (WebI) reporting functionalities such as Sub-reports, Combined queries, Calculation Contexts, Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
- Provided support, maintenance and enhancements for existing Business Objects universe and WEBI reports.
- Worked with Crystal 4.0 for creating complicated reports including sub-reports, parameter based reports, summary reports, formula based reports, drilling reports, and data reports along with LOV.
- Involved in development of Volume, Efficiency/Effectiveness, Customer Experience dashboards for different business areas such as Sales Delivery, Contact Center, Annuitization & Pension etc.
- Developed Universe user documentation guide for the end users references.
- Provided training for end users for generating their own report and involved in production support.
Environment: Business Objects XI3.1/4.0, Universe Designer, Web Intelligence, Crystal 4.0, Upgrade Management tool, Information Design Tool, CMC, Oracle 10g, MS access, Informatica 9.0.1/8.6, SAP BW, PL/SQL, QaaWS and Xcelsius Dashboards.
Confidential
SAP Business objects Consultant and Crystal report developer
Responsibilities:
- Analyzed Business requirements, clarified Business rules, functional requirements and data specifications for Business Objects universes and reports.
- Extensively worked with some issues while upgrading from BO version XI R2.0 to BO XI R3.1.
- Worked on installation and configuration of Business Objects XI R3 Enterprise Suite (Desktop Intelligence, Web Intelligence, Central Management Server, and Central Management Console).
- Created universes for supporting the new External Customer Reporting requirements.
- Added the classes and objects in the universe as and when necessary for the new reports.
- Extensively used the Sections, Breaks, Hyperlink and Alignments of the objects in the reports to match the business reporting templates.
- Created Derived tables in the universe to come up with complex data set that was required for complex reports.
- Created many complex canned reports with multiple data providers but showing all the data in one table by merging the common dimensions between the data providers.
- Created Complex and Multi-Dimensional reports using Master/Detail, Cross Tab, Slice and Dice, and Sub Queries.
- Developed reports using combined queries with UNION functionality.
- Created local variables with complex logics in the reports for calculating the metrics in the Order Express reports.
- Created complex formulae in the Web I report to dynamically change the column that need to be displayed in the table depending on the prompt values.
- Used advanced functionalities like Optional prompts, Hyper-linking. Used one query data element as filter in another query to get the respective data.
- Tested the report data by comparing with the data from the report with the SQL outputs from the database to ensure the quality of reports generated.
- Ensured the quality and timely delivery of all the important complex canned reports.
- Involved in migration and testing of Objects to PROD environment from DEV through QA environment using Import Wizard.
- Involved in the poc of Designing dashboards using QWAAS & Live Office connections to generate dashboards for Live Data.
- Worked with Xcelsius Web-connectivity components such as Web-Service Component, Live Office Connector etc. to establish live connectivity to the dashboards with the database tables, views and BO universes.
Environment: Crystal Reports XI/2008, QWASS, Business Objects XI R2 (CMC, Designer), SQL Server 2000/SQL Server 2005, PL/SQL, Oracle 9i, MS Access, Windows 2003.
Confidential, Nampa, Idaho
BO Developer
Responsibilities:
- Interacted with Business Owners to know their Business views in creating/modifying Reports accordingly
- Wrote many SQL scripts to handle different database batch processes required forSystem Test.
- Developed reports using Crystal Reports 10 Various Report Formats developed include parameterized Reports, Sub Reports, Cross Tab Reports, Standard Reports and also developed reports in MS Access and Excel.
- Involved in database testing of the application to check for insert and update operations using SQL queries.
- Assisted clients to provide reporting solution and develop/maintain universes against their SAP R/3 warehouse using WebI, Crystal Reports and Designer.
- Analyzed the reporting requirements with the business users and come up with the technical specifications.
- Developed various canned Reports that involved use of Prompts, Customized LOVs, Multiple data providers, Master/Detail, Alerts, Cross tab, filters and variables.
- Supported and lead developers in creating reports using Universe, Stored Procedures and Excel files as Data Sources.
- Extensively worked on Data Warehousing Design Methodology, Data Warehouse Concepts.
- Gained experience in designing, implementing, distributing and maintaining Universes.
- Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
- Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.
- Scheduled various reports on Daily, Weekly, Monthly and Yearly basis.
- Created the Reports for various financial groups using the Universe as a main data provider.
- Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources.
- Working experience in SSRS for reports
- Created Charts to display summary data using universe as main data provider.
- Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Crystal Reports reports.
- Examined and transformed the business logic behind the existing Crystal Reports into Business Objects environment.
Environment: Crystal reports 10 and Crystal enterprise 10, SQL* Loader, ERWIN, Business Objects XI/6.1, MS Access, Oracle 9i, SQL, PL/SQL and Windows 2000, UNIX.
Confidential
BI Developer
Responsibilities:
- Worked closely with Business Analysts to produce reports based on the requirements.
- Converted high-level design specifications to detailed functional and technical specifications.
- Built and performed user acceptance testing on modified reports.
- Created reports that include Grouping, Sorting, selection criteria, Running Totals, Alerting, Drill-down and Parameter prompt.
- Run reports and performed independent validation and verification (IV&V) against data and ticket information.
- Migrated Business Objects Universes, User groups, and reports from Version 5x to 6x.
- Made the Reports user friendly by implementing user prompts, conditions and filters.
- Used Version Control for checking in all versions of the objects used in creating the Joins in the Universe to keep track of the changes in the development, test and production environment.
- Trained end users in basic and advanced ad hoc reporting skill.
Environment: Crystal reports 8.5/ 9/10, Business Objects 5.x, 6.x, MS SQL Server, T-SQL, PL/SQL, Access, Excel, Windows NT.