Business Objects Developer Resume
Baltimore, MD
SUMMARY
- Over 7+ years of Experience in Business Objects 4.0/XI 3.1/XI R2/XI R1/6.5/5.1 (Designer, Info view, DeskI/WebI, Business Objects Reporting, Broadcast Agent/ Scheduler, CMC, CCM, and Crystal Reports, Xcelsius (dashboard)).
- Experience in developing, designing and Modifying Business Objects Universes and Reports
- Over 3 Years of Experience in Oracle 11g/10g/9i/8i, PL/SQL, SQL Server 2000/2005.
- Expert in planning, designing, developing, modifying, updating, maintaining and distributing Universes and Reports.
- Proficient in using Business Objects Modules Designer, Deski/Desktop Intelligence, Webi/Web Intelligence Rich Client, Import wizard, Report conversion tool, Central Management Console (CMC), Central Configuration Manager (CCM)
- Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures and free hand SQL.
- Excellent understanding of data architecture, relationship modeling and effective aggregation of data.
- Experience in Desktop Intelligence and Web Intelligence, creating complex reports.
- Experience in Optimization and Performance tuning of new and existing Business Objects universes, reports.
- Extensively worked on developing Dashboards, Analytics, and Metrics using Performance Management.
- Worked on developing reports using Crystal Reports XI R2 using Business Views and Universes as data providers.
- Diversified experience in implementation of Business Objects report management with in Finance, pharmaceuticals, banking, Sales, Marketing and Supply Chain Management sectors.
- Excellent Technical, Interpersonal and solid communication skills with the ability to interact with end - users and managers and Experience in requirement gathering and Training End-users.
- An enthusiastic, project-oriented team player with leadership skills and with an ability to develop creative solutions for challenging client needs.
- Hands on experience on BO administration, Teradata and sap business explorer.
- Worked extensively on sap BW.
TECHNICAL SKILLS
Tools: Business Objects (XI 3.1/XIR2/XI/6.5/5.5), Designer, Deski/Webi (SDK), CMC, CCM, Crystal Reports, Xcelsius, Business Objects Data Services, BW, VB
Internet Technologies: Web Intelligence, Info view
Database: MS SQL Server 2000/2005, MS Access, Oracle10g/ 9i/ 8i, Teradata. Access
Languages: SQL, PL/SQL
Operating Systems: Windows 95/98/2000/XP/NT, MS DOS
Utilities: MS Word, MS Excel, MS PowerPoint
PROFESSIONAL EXPERIENCE
Confidential, Bartlesville OK
SAP Business Objects Developer
Responsibilities:
- Involved in Gathering requirements from Business Users.
- Involved in Planning and Finalizing design of the reports and Plan iteration according to the requirement.
- Gave estimates to implement projects based on requirement.
- Added tasks and updated capacity in rally.
- Daily standups to update the progress of iteration tasks and conduct retrospective for the release.
- Interacted with End users and Business Analysts to gather and document the Requirements and translated them in to Technical specifications to Design Universe.
- Created Universe design and updated structure of the universe to accommodate table changes.
- Created various User defined objects including Dimensional, Detail, and Measure objects and tested them ensuring correct mapping of data.
- Improved the performance and reduced the complexity with the use of @functions (@aggregate aware, @select, @prompt, @where).
- Created Hierarchies in the universes to meet Drill Analysis of the reporting needs.
- Worked on performance tuning and optimization of Business objects Universes by building Aggregate tables.
- Tested aggregate awareness to ensure that the query is pulling correct level of aggregation.
- Created Alias tables and Contexts to resolve loops and tested them to ensure correct results.
- Exported the universe to the Repository to make resources available to the users.
- Created and maintained Universes based on changing user requirements and based on changes in data source.
- Made new classes, objects and structural changes to Universes in Designer, including adding new objects, updating tables and joins.
- Created Derived Table in the universe to in corporate complex business logic.
- Provided technical assistance/support to analysts, business community.
- Trained Power and end users to use various functionalities of Business Objects and provided technical support.
- Created the complex reports based on the data to show the sales of the various products as per the Geographical location.
- Created reports using the Universes, Stored Procedures and Free Hand SQL as the data providers.
- Created an Xcelsius Dashboard for loss gain metrics Trend analysis.
- Created web services to design a dashboard by publishing blocks of data to host systems.
- Mapping live data into the excel spreadsheet and creating triggers to update data in dashboards.
- Used charts, data selectors, labels, list builders and other components in dashboards.
- Experienced in Importing/Exporting the Universes to repository.
- Formatted reports as per the user requirements in Business Objects which allowed user to analyze the data.
- Created crystal reports to in corporate complex queries and formulae for loss gain, using stored procedure and also universe.
- Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and formulas and developed Hierarchies to support drill down reports.
- Used Web Intelligence for web based query and reporting.
- Published reports using Info View.
- Involved in various discussions with the end users to analyze Meta Data.
Environment: Business Objects XI 3.1 /4.1, Xcelsius 2008, Webi Rich client, Designer, Info view, CMC, Oracle11g, PL/SQL, SQL Tools, Windows 2007, Crystal Report 2008, Visual studio, Rally, ER Modeler.
Confidential, Baltimore MD
Business Objects Developer
Responsibilities:
- Gathered requirements from Business Users.
- Analyzed object, connections and Universes and involved in troubleshooting issues.
- Extensively involved in production support.
- Created freehand SQL reports and worked on ad hoc reporting.
- Created MACROS, ADDINS and installing an addin by using an interace.
- Implemented events for documents.
- Used Desktop Intelligence Query Panel to create a query technique data provider.
- Created Classes, Objects and Hierarchies for multi dimensional analysis of database using Business Objects.
- Worked on CMC granted access to users for various universes and reports. And also created users in business objects to be able to access the same.
- Worked closely with the migrations team for migrations of changes that were request and planned.
- Created service tickets on HP Service Manager and worked on them to resolve issues.
- Worked on HP Project and Portfolio Management, created and worked on AWR application work request and PPM production release request.
- Created complex reports using user-defined functions, condition objects and aggregate awareness functions.
- User training on business objects deski reporting and info view - webi reporting.
- Created reports using drill up and drill down functionalities.
- Created several types of Crystal Reports using sub-reports, Cross-Tab Reports, Graphs, Complex Formulas, and Conditional Formatting.
- Crystal Reports XI R2 using Business Views and Universes as data providers.
- Extracted data in the reports by using Ranking, Filters, Sorting and highlighted data with Alerters.
- Created reports for trades and forecasting.
- Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
- Scheduled reports on daily/weekly/monthly basis using CMC.
- Ran SQL queries against the database to check integrity of the data.
- Created documentation for Universes. Developed Ad Hoc reports.
- Exported universes to the repository for making resources available to users
- Filtered reports by creating and applying complex conditions and sorts, User Objects, LOV’s, Combined Queries, Free Hand SQL and Semantically dynamic calculations using context method.
- Worked with @functions - @Aggregate, Aware, @Prompt, @Script, @Where, @Variable and @Select to specifying the sql.
- Used PL sql developer and sql developer for basic sql tuning.
- Used different user interface to grant access to users for an application universe.
Environment: Business Objects XI R3 / 3.1 /4.0(Deski, Webi SDK), Designer, Infoview, CMC, Oracle10g, PL/SQL, SQLTools Windows XP.Crystal Report XI, HP PPM, HP SM, BOSECURE.
Confidential, FT Lauderdale, FL
Business Objects Developer
Responsibilities:
- Gathered requirements from Business Users.
- Involved in creation of universes, Classes, Objects and Hierarchies for multi dimensional analysis of database using Business Objects for technical and sales & marketing departments.
- Worked extensively with @functions including @Aggregate, Aware, @Prompt, @Script, @Where, @Variable and @Select to provide more flexible methods for specifying the SQL for an object
- Created complex reports using user defined functions, condition objects and aggregate awareness functions for SQL enhancement
- Exported universes to the repository for making resources available to users
- Created master detail reports using drill up and drill down functionalities.
- Built Powerful Queries by creating and applying complex conditions and sorts, User Objects, LOV’s, Combined Queries, Free Hand SQL and Semantically dynamic calculations using context method.
- Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerters. Scheduled reports on daily/weekly/monthly basis using CMC.
- Used SQL against the database to check retrieved data integrity.
- Was actively involved in planning, documentation. Developed Ad Hoc reports.
- Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
- Developed weekly and monthly Company Turnover Reports as per the requirements.
- Setup Application Foundation operational metrics and analytics for marketing decision analysts.
Environment: Business Objects XI 3.1, Crystal Report XI, Xcelsius 4.5, MS SQL Server 2005, Oracle 10g, Windows Server 2003/2000, Windows XP.
Confidential, Houston, TX
Business Objects Developer
Responsibilities:
- Conducted meetings and interacted with business users to understand the business needs, modified Universe and gather report specifications.
- Designed multiple Universes from multiple data sources to create several reports with additional variables and report level filters.
- Created various user-defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data.
- Improved the performance using @functions (@aggregate aware, @select, @prompt, @where).
- Created and modified existing Hierarchies in the Universes to meet Drill Analysis.
- Involved in performance tuning & optimization of BO Universe Design by creating Aggregate tables.
- Tested aggregate awareness to ensure the query returns correct level of aggregation.
- Defined Alias and Contexts to resolve loops, traps and also tested them to ensure retrieval of correct results.
- Created User Defined Functions and Materialized Views.
- Updated Universes & reports continuously to rolling user requirements & data sources in an agile environment.
- Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables, joins etc.
- Created several types of Crystal Reports using sub-reports, Cross-Tab Reports, Graphs, Complex Formulas, and Conditional Formatting. Developed dashboards using Crystal Xcelsius.
- 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.
Environment: Business Objects XIR2.1 (Designer, WebI, DeskI, Rich Client, CMC), Xcelsius, Crystal Reports XI, Oracle 10g and TOAD
Confidential, Chicago, IL
BO Developer
Responsibilities:
- Involved ingatheringandanalyzingbusiness requirements.
- Designed and developeduniversein thedesigner,connectionto thedatabase, classesandobjects, joinsandpredefinedconditions.
- Definedcardinalitiesand resolvedloopsandtrapsby creatingaliasesandcontexts.
- Created variables, formulae, grouping objects, and inserting prompts at report level
- Resolved the performance issues in report generation and tuned the universe for better performance
- Performed manual testing on reports & universes before testing.
- Used thedrill down/up, slice and dicefeatures toanalyze data, set variables, alertsandgroup valuesin the reports.
- Migratedthe data fromBO 6.5 to BO XI R2usingImport Wizard.
- CreatedStandard reports, Complex chartsandDrill Down Reportsusing BO XIR2
- Participated in data modeling usingMS Visio 2003.
- Created corporatedashboardsto monitor the key metrics usingPerformance ManagerandCrystal XCelsius 4.5.
Environment: Business Objects XI R2 / 6.5, Designer, Desk I, Web I, Supervisor, Oracle 9i, XCelsius 4.5, TOAD 8.5, MS Visio 2003
Confidential
Business Objects Consultant
Responsibilities:
- Creation of the Universe with Classes, Objects and Condition objects
- Resolved loops by creating aliases and contexts.
- Developed Hierarchies to support drill down reports
- Developed complex queries using different data providers in the same report
- Created User groups and users IDs for PROD, DEV, TEST environments.
- Used BCA (Broad Cast Agent) to process BO reports in off-peak times, so that peak time processing power is increased.
- Scheduled reports to various users in various formats according to their requirement.
- Mapping Data Items from Source Systems to the Target System.
- Plan, coordinate and execute Business Objects deployment for End users
Environment: Oracle 8i, Business Objects 5.5, SQL, Windows XP.