We provide IT Staff Augmentation Services!

Business Objects Developer Resume

Desmoines, IA

SUMMARY

  • Over 8 years of experiencein the field of information technology with the emphasis ondata warehousing, BI, BW, Mobile BI, OLAP, ETL, SAP Business Objects universe design and reporting module.
  • Over eightyears of experience in information technology using business intelligence tools, Business Objects (BOBJ)Tools in various versions - BI4(BOBJ 4)BO XI 3.1/R2/R1/ 6.5.1/ 5.1, SAP BW on Windows and UNIX environments.
  • Three years of experience in analysis, design and development of various data warehousing projects using SAP Business Objects data services 4.0/XI3.2/3.1, and data integrator XIR 2/11.7/11.5.
  • Worked on various development platforms like Windows NT 4.0/2000/2003 Server/ XP/98/95, UNIX andRDBMS like Oracle, SQL Server, Informix, MS Access, Teradata, Netezza, DB2 UDB and Sybase.
  • Expertise in creating InfoObjects, InfoSources, PSA, ODS /DSO, DTP, Transformations, InfoCubes, Multiproviders.
  • Expertise in Report Generation - Worked extensively in BEX Analyzer in building Queries and saving in Workbooks (Excel work Sheets) and created Custom Queries using Conditions, Exceptions, Variables & Structures and created aggregates for frequently used queries.
  • Good experience in extracting data from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, Generic Data Sources, BI Content Data Sources, Full and Delta Extraction Management.
  • Experience on Integrating SAP BW with Business Objects on HANA, ECC, HCM (HR) FI/CO, SD / MM / SRM / CRM, Analyzing, designing, building and deploying BOBJ / Bex reporting solutions over SAP BW 3.5 / BI 7.0.
  • Extensive experience and solid understanding ofdata warehousing, data marts,star,snow flake schemamodeling,dimensional modeling,entity-relationship modeling,OLTPandOLAP concepts.
  • Proficient in utilizing the crystal reports and Xcelsius 2008 Query as a Web service.
  • Proficient in creating reports using business objects functionalities such as queries, master/detail and formula, slice and dice, drilling, cross tab and charts.
  • Work experience in advanced Xcelsius concepts like, whatif analysis, dynamic visibility, narratives, interactive charts, hierarchies and experience in connecting Xcelsius/ QaaWS, live office.
  • Experienced in developing complex reports using business objectsWebi Rich ClientandCrystal reports enterprisehaving parameter/formula fields and selection formulas, grouping and sub reports.
  • Proficient in designing and building universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts and checking integrity of universes.
  • Extensive experience in Oracle development using dynamic SQL, PL/SQL, Views, Indexes, Triggers, Stored Procedures, Nested Tables and Oracle Objects etc.
  • Extensively involved in managing repositories, connections, creating and managing users/groups, assigning resources to users and importing/exporting users.

TECHNICAL SKILLS

Business Intelligence: Business Objects 4.1/4.0/3.1/3.0/ XI R1/R2/6.5.1/6.1b/5.0x - Central Management Console, Central Configuration Manager, Platform InfoView, Web / Desktop / OLAP Intelligence, SDK,Data Integrator, Set Analysis, Designer, Supervisor, Administrator, Application Foundation, Enterprise Performance / Information Manager, Dashboard Manager, ScoreCards.

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.5/8.1/7.1/6.2/5.1 , Informatica Developer 9.x/8.x, Power Exchange 9.1, 8.6.1, 8.1., Informatica Data Analyzer, Power Analyzer, MQ Series, SQL*Loader, SQL Server DTS Package, Power Exchange (Power Connect), Metadata Manager, Informatica Data Quality, Informatica Data Explorer, SSIS, Data stage, SAP BW 7.3, Abinitio etc.

Reporting & Analysis Tools: Crystal Reports XI/10/9/8/7/6, Crystal Enterprise XI/10/9/8, Crystal Reports 2008,Business Objects XI, Crystal Management Console, Crystal Migration Wizard, Crystal Import Wizard, BO Web intelligence, BO Dashboard Builder, Xcelsius 2008

RDBMS: Oracle 11g/10g/9i/8i, MS Access 2003, SQL Server 2000/2005.

Data Modeling Tools: Erwin r7.1/7.2, ER Studio V8.0., HANA Studio and Oracle Designer

Programming Languages: SQL, PL/SQL, T-SQL, C, C++, .Net, HTML, XML.

Application Server: Tomcat 4.1

GUI: Visual Basic 6.0, Visual C ++ 6.0

Operating Systems: WINDOWS XP/NT/00/98/95, UNIX

Web Server: Apache 2.0, IIS 6.0

Others: TOAD, SOAP, SQL NavigatorTeradata SQL Assistant, SQL Loader

PROFESSIONAL EXPERIENCE

Business Objects Developer

Confidential, DesMoines, IA

Responsibilities:

  • Created the Universe Requirements documents to document the business elements that have to be added to the universe
  • Created a data foundation layer based on the servicing data using information design tool in BO 4.1 SP5.
  • Created many business layers based on the data foundation to meet the user requirements.
  • Experienced in creating shared projects in BO 4.1
  • Created various graphs using various chart functionalities.
  • Various other forms of dashboard development also performed including Data from SAP BW through Bex Queries, Data from Universe using QAAWS, Data from Webi reports, Crystal Reports using Live Office etc.
  • Defined row level security at universe level as per user entitlements, enabling IT to create one report and make it available to global users based on their rights.
  • Improved the performance and reduced the coding with the use of (@functions (@aggregate aware, @select, @prompt and @where).
  • Created new and modified existing hierarchies in the universes to meet drill analysis of the user’s reporting needs.
  • Involved in performance tuning and optimization on business objects universes by creating aggregate tables.
  • Analyzed various Data Warehouse Models like slowly changing models, Conceptual Models, Logical Models. Also Designed and developed Data Integrator scripts for data transformation.
  • Created information spaces in business objects explorer and performed indexing on them.
  • Expertise in BW Performance Tuning: Performed tuning measures of Queries by maintaining Aggregates, Roll up, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Also, used variety of techniques to boost the performance of BEx Query.
  • Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
  • Defined alias and contexts to resolve loops and also tested them to ensure that correct results were retrieved.
  • Performed integrity testing of the universes (universe structure checking, object parsing, joins parsing, conditions parsing, cardinalities checking, loops checking and contexts checking) after any modifications to them in terms of structure, classes, and objects.
  • Exported the universe to the repository to make resources available to the users.

Environment: Business Objects 4.1 SP5, Teradata 13.10, BEx Query Designer, SAP BI/BW 7.0,Business Explorer,Teradata SQL Assistant, DMT

Informatica/BO Production Support

Confidential, Plano, TX

Responsibilities:

  • Customers of CRDW Reporting are Trade Customers and Delivery Organization in all the regions.
  • CRDW Reporting manages tickets via the OVSC AMS, OVSC EMEA, OVSC APJ workflow tools.
  • CRDW Reporting Team exists to capture, manipulate, collate and make available data in a standardized and automated fashion to facilitate the delivery of Trade customer and delivery organization reports.
  • Reloading the data for missing incidents into CDRW DB from OVSC/SM sources.
  • Monitoring the critical workflow until they succeeded.
  • Executing the workflows and reschedule the workflows through Cronjobs.
  • Deletion of old cache files which causes space issues.
  • Identifying the failed instances of reports in Instance manager and rerunning the reports through
  • Creation of LDAP and Enterprise users to access the BO Infoview and providing the access to Customer folders.
  • Scheduling of operational (Team based) and customer (customer based) reports based on the User requirement.
  • Enabling/disabling the BO mailer to Start/stop the delivery of reports to email recipients.

Environment: Informatica Powercenter 9.5/8.6, UNIX, ORACLE 10g, SQL Server 2005, TOAD

Business Objects Developer

Confidential, DesMoines, IA

Responsibilities:

  • Analyzed the business requirements and created business requirements document and Mockup reports using Microsoft excel.
  • Involved and analyzed creation of SAP BOBJ 4.0/XI 3.1 Web Intelligence Reports with different functionalities like cascading prompts, drill down, linking reports, charts and graphs, ranking, scope of analysis and alerts.
  • Created complex reports in Web Intelligence using advanced functionalities like report level prompts, scope of analysis and ranking.
  • Created various graphs using various chart functionalities.
  • Defined row level security at universe level as per user entitlements, enabling IT to create one report and make it available to global users based on their rights.
  • Created the universe using the information design tool.
  • Improved the performance and reduced the coding with the use of (@functions (@aggregate aware, @select, @prompt and @where).
  • Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and use case modeling.
  • Created new and modified existing hierarchies in the universes to meet drill analysis of the user’s reporting needs.
  • Involved in performance tuning and optimization on business objects universes by creating aggregate tables.
  • Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
  • Defined alias and contexts to resolve loops and also tested them to ensure that correct results were retrieved.
  • Performed integrity testing of the universes (universe structure checking, object parsing, joins parsing, conditions parsing, cardinalities checking, loops checking and contexts checking) after any modifications to them in terms of structure, classes, and objects.
  • Exported the universe to the repository to make resources available to the users.

Environment: Business Objects 4.1, Teradata 13.10, Teradata SQL Assistant.

Business Intelligence Analyst

Confidential,Topeka, KS

Responsibilities:

  • Involved majorly in financial analysis for KPI and KDP report which is done on a weekly and monthly basis.
  • Played a key role in reporting decisions for various key executive reports.
  • Designed executive dashboards for various trends for productions figures across various channels.
  • Migrated BO from XI3.1 to BO 4.0installed and configured BODS XI 4.0 SP1 in development andproduction server.
  • Involved in dashboard design for various reporting strategies across different sales units.
  • Designed and developed reports for financial analysis and pending analysis at the regional level of the organization.
  • Created the reports using the universe as the main data provider and writing the complex queries including sub-queries, unions, and intersects.
  • Analyzed the business requirements in using the pivot table, vlookup and hookup functions in excel.
  • Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts / pie charts of the same.
  • Created document on usage of info view for offsite users with no full-client business objects installed on their machines.
  • Developed executive dash boards in Infoview and SAP BO Xcelsius 2008.
  • Extensively used new features of business objects 4.0 in creating universe using multiple data providers.
  • Modified BW queries in the Crystal reports using BW query designer with Crystal XI R2 professional tool.
  • Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the premigration of BW on HANA implementation. Optimized BW cubes for HANA purpose
  • Developed reports from SAP Infocube by using BEx Analyzer, applied filters, variables, parameters/prompts
  • Defined aliases and contexts to resolve loops in the universes.
  • Created user conditions and Filters to improve report generation and readability of report and displayed the summary of data by creating charts.
  • Designed and developed ETL routines in BODS, modified or created new data services jobs to meet project requirements.
  • Created connections with different databases like DB2, SQL server and Teradata
  • Extensively worked on the central management console in version 4.0.
  • Involved in training portal administrators about XCelsius Model and how to configure XCelsius with different methods to connect to universe (Using Live Office, QAAWS).
  • Created customer fact sheet dashboard for business needs and automated the dashboard using live office.

Environment: SAP BO Data Services 4.0/BO 4.0/XI3.2/3.1/3.0 (Designer, Data Services Repository Manager, Data Services Server Manager, Management Console), SAP BO Data Integrator XIR2/11.7/11.5,Business Objects 4.0/XI 3.1(Designer, WEBI), SAP BW 7.1,WEBI Rich Client, DB2 LUW,Teradata 13.10, Teradata SQL Assistant, Oracle 11g, TOAD, MS Excel 2007.

BO Developer

Confidential, Atlanta, GA

Responsibilities:

  • Build business objects universes and wrotereports.
  • Documented user requirements, translated functional requirements into technical requirements and developed implementation plan and schedules.
  • Developed report mock-up samples before user interaction to analyze the business requirements.
  • Worked with the team closely with functional architect, DBA and analysts to get a clear understanding on the by Torntv V9.0">application.
  • Tuned and enhanced universes with SQL queries for the report performance.
  • Streamlined SQL generation from Universes by implementing Aggregate Aware functions and @Variables.
  • Created complex reports by using multiple data providers to combine three reports as a single report in Deski, WebI.
  • Worked with BEx Query Designer and OLAP Universe Designer, to create WEBI reports.
  • Responsible for creating the Deski and Webi reports (On demand, Audit Reports, Ad-hoc Reports, Summary Reports, Sub Reports, dynamic grouping, Cross-Tab and graphical, etc.).
  • Created Webi reports using all the BO functions like Drill Down, Prompts, Dimensional and measured variables to show accurate results.
  • Developed dashboards using Crystal-Xcelsius with data source as Live Office.
  • Migrated BO from XI3.2 to BO 4.0installed and configured BODS XI 4.0 SP1 in development andproduction server.
  • Troubleshooting and rectifying Universe, Webi Rich Client andlive office errors.

Environment: Business objects 4.0, Crystal Reports 2011, Webi Rich Client, Deski, Business Objects XIR3, SSRS, DB2 LUW, SQL Server 2005/2008, Oracle 11g, Facets4.81, Facets interfaces (IFOX), Facets extensions.

Business Objects Developer

Confidential, DesMoines, IA

Responsibilities:

  • Participated in gathering functional requirements and data specifications for business objects universes.
  • Responsible for creating reports for data services group using business objects WebI and Crystal Reports.
  • Worked with multiple data providers in a report and added slice and dice capabilities.
  • Use of designer module to implement universe, Joining the Tables, create prompts and queries, Parsing the Objects, appliedcontexts and alias tables to remove cyclic dependencies.
  • Dealt with multiple star schemas within one universe design experience with advanced functions in designer (customizing LOV's, creating contexts and predefined filters) Experienced in interpreting data models
  • Maintained the repository (i.e., security, universe and document domains).
  • Generated the business objects reports using the universe as the main data providers and wrote the complex queries including sub queries, unions, intersect and aliases.
  • Linked different universes, which are from multidimensional data sources.
  • Created conditional objects and used universe level security restrictions.
  • Created the reports from various universes using business objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.

Environment: Business Objects XI R3 (Designer, WEBI), Live Office, Crystal Reports XI, Crystal Xcelsius 2008, Oracle 9i, DB2 LUWandWindows XP

Reports Developer

Confidential,Chicago,IL

Responsibilities:

  • Interacting with business users and business analysts to understand and document the requirements and built universes for end user reports generation using business object XIR3.1 designer.
  • Designed the management universe by objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and created the objects, which are grouped into classes for convenience and business intelligence reporting.
  • Created derived tables at the universe level to match the business requirements.
  • Worked extensively on custom LOV’s in defining and maintaining them over the business objects universe.
  • Worked extensively with the major functionality of business objects like Breaks, Alerter, Filters, Sorts, Query Prompts and Drill filters.
  • Used the Slice and Dice feature, set variables, alerts and group values in the reports.
  • Created, managed and formatted standard reports, master/detail reports and cross tab reports using report manager.
  • Used SQL loader to load flat files into oracle database and used PL/SQLStored Procedures and Functions to a format data for the end-user report requirements.
  • Created complex reports and exported them to the corporate repository.

Environment: Business Objects XI 3.1 (Designer, Desktop Intelligence, Web Intelligence, Webi Rich Client, Central Management Server, Central Management Console, CCM) Crystal Reports 2008, Crystal Xcelsius 2008, Live Office, SQL Server 2005, DB2 LUWand Oracle 10g.

Server Analyst/Programmer

Confidential, Rochester, MN

Responsibilities:

  • Acted as a liaison between client area and technical organization by planning, conducting, and directing the analysis of complex business problems to be solved with automated systems.
  • Provided technical assistance in identifying, evaluating, and developing systems and procedures that are effective and meet business requirements.
  • Developed complex reports that involved multiple data providers, master/detail charts, cross tab charts, complex variables and calculation contexts.
  • Worked on developing database objects when required such as Stored Procedures, Views, Packages, and Functions.
  • Used various Xcelsius components like Charts, Maps, Single Value and Selectors.
  • Used dashboard manager to build dashboards and deploy them across the organization to monitor business performance
  • Checked the integrity of the universes and exported the universes to repository making it available to users.
  • Converted Deski reports to Webi using report conversion tools for enhancements.
  • Used the Slice and Dice feature, set variables, alerts and group values in the reports.
  • Provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Object XI R3, Web Intelligence (WEB I), Webi Rich Client, Deski,Info View, Import Wizard, Report Migration Tool,UML, MS Visio, MS Office, MS Project, Crystal Xcelsius 2008, Xcelsius Designer, Live Office, Sql Server 2005/2008, DB2 LUW, Crystal reports XI.

Hire Now