Sr. Business Objects Developer Resume
CA
SUMMARY:
- 8+ years of experience in Business Intelligence/Business Objects (BI/BO) enterprise solutions that include Business Objects architecture, software deployment, infrastructure maintenance, business objects and system administration, BOE Security, Universe/Report/Dashboard development, documentation, Production Support and user training.
- Experience working with End Users and Business System Analysts in understanding their requirements, assisting in providing technical solutions and implementing them.
- Expertise in Business Objects XI4.0/3.1/3.0/XI R2/6.x/5.x(Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Dashboard Designer 4.0, Central Management Console and Business Objects Administration).
- Experience in full life cycle gathering requirements, documentation, developing, designing, implementing, testing and deploying BI Solutions.
- Extensive Experience in migration of Business Objects Universes and reports to newer versions.
- Extensive database architecture and design skills of working on high performance solutions in large corporate environments.
- Adept Designing/Developing the Business Objects Universes, Ad - hoc/ Canned Reports, Complex Reports using predefined conditions.
- Experience in creating reports and accessing queries using Business Objects Query Builder, Web application designer.
- Hands on experience in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, Physical and Logical data modeling.
- Proficient with various RDBMS technologies includingSAP, Oracle11g/10g/9i/8i, MS SQL 2005/2000/7/6.5, DB2, Teradata,IBMNetezza 5.x,MS Access.
- Knowledge of SAP Business Warehouse BW 3.x/BI 7.x, Business Explorer (BEx), SAP R/3 and ETL
- Successfully applied fix pack and Service Pack patches on the Enterprise servers.
- Installed, Troubleshoot, upgraded and maintained the various Business Objects.
- Provided 24X7 support to the users.
- Involved in review meetings with Project Managers, Developers and Business Associates during Project Planning, Coordination and implementing various QA methodologies.
- Working knowledge on Migration tools like Import Wizard, Publishing Wizard, Report Conversion tool.
- Solid Experience in writing Transact SQL, SQL Sybase, stored procedures, functions, packages, data base triggers, exception handlers, Cursors.
- Worked as a team player with proven problem solving skills as well as independently with excellent communication and Interpersonal skills.
TECHNICAL SKILLS:
Business Intelligence: Business Objects XI 4.0/3.1/XI R2/6.5 (Supervisor, Designer, Info view, Business Objects SDK, Xcelsius, Voyager, Web-I SDK, Broadcast Agent, Publisher, Designer, Supervisor, Auditor, Application Foundation Dashboard Manager, Report Writer, BO Set Analyzer, Application Foundation 6.0/2.5 & Dashboard Manager), Crystal Reports XIR2/2008, Life Cycle Manager, SAP Integration Kit, SAP Portal.
Business Analysis: Functional Requirements Gathering, User Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, Data Analysis, Requirements Analysis, Design.
Databases: Oracle 11g/10g/9i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, IBMNetezza 5.x,Sybase 12.x/11.x,SAP HANA.
PROFESSIONAL EXPERIENCE
Confidential, CA
Sr. Business Objects Developer
Responsibilities:
- Managing of all BO universes and standard reports in BO XI 4.0 which is used by nationwide users.
- Testing and successfully delivering reports timely, including performance tuning of BO full client and WebI reports.
- Developing of WebI reports involving complex calculations, tables from multiple data sources.
- Providing profitability reporting to business unit/channel, customer, vendor, category, product, region, etc.
- Modifying existing universes, testing objects in the universe, to ensure the correct mapping of the objects.
- Testing the universe structure to ensure the tables are properly updated.
- Promoting the tested content form Development to IT, QA and Production using Life-Cycle Manager.
- Providing key performance, security, and architecture assessments, documentation, and guidance for management, vendor management, and code reviews.
- Providing technical advice for improvements of BO service.
- Proactively monitoring and reporting continuous report failures, badly scheduled reports, long running reports and worst performing reports.
- Coordinated with the end users during BAT (Pilot Users) and UAT and fixed any bugs raised.
- Was involved in the cut-over and go live activities.
- Efficient in writing SQL queries in Oracle, Toad, SQL Developer.
Environment: Business Objects XI 4.0, XCelcius 2008, Crystal Reports 2008, Business Objects Explorer, Oracle 10g/9i, SQL/PLSQL, Windows AD, IE9, Designer, Infoview,Launch Pad, Web Intelligence, Windows 2008 R2/ 2003,Windows XP, Windows 7, Toad for DB2 5.0, Toad for oracle 9.
Confidential, San Jose,CA
Sr. Business Objects Developer
Responsibilities:
- Was part of the entire SDLC of the project.
- Involved extensively in gathering requirements from the business users through multiple JAD sessions.
- Was involved in LDM sessions to provide insights based on requirements to drive the modelling based on user requirements.
- Performed data validation using Data Flux.
- Created multiple documents including FRD, TDS and Test cases for the Unit testing
- Developed a comprehensive universe to meet all the reporting requirements.
- Prepared Source-to-target mapping document used for creating universe objects.
- Used multiple techniques and functions within the universe development. Used basic joins, shortcut joins etc. Used aliases and contexts to resolve loops and traps.
- Applied multiple securities Confidential Universe level, including Object level security and row level restrictions.
- Created multiple canned reports for the end users based on the requirement. Trained users create some ad-hoc repots.
- Used report based filters and created reports with drill down capability.
- Created reports from multiple data providers and then used merged dimensions to create reports.
- Created reports with multiple queries, sub-queries and combined queries using Union/intersection and minus functions.
- Performed administration activities, including creating of groups, folders and adding users in CMC.
- Assigned user security through CMC and also data level security using @variable(‘BOUSER’) function.
- Reviewed the test cases created by the QA team and fixed all the bugs raised.
- Performed performance tuning on long running reports. Checked the query plans and flow to avoid any full table scans where not necessary.
- Coordinated with the end users during BAT (Pilot Users) and UAT and fixed any bugs raised.
- Was involved in the cut-over and go live activities.
- Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BExAnalyser
- Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders
- Was involved in gathering visualization and data requirements for the dashboard tabs.
- Created a POC to provide an initial view to the business users.
- Created multiple tabs within the dashboard with multiple visualizations using direct query binding and QaaWs.
- Used multiple components including but not limited to charts, text boxes, image, scorecards, combo box, push buttons, toggle buttons etc.
- Integrated BOBJ 4.0 with SAP HANA1.0
- Created Universes on top ofHANA calculation viewsand developed the Webi reports and dashboards usingIDT(Information design tool).
- Extensively used dynamic visibility to change visualizations based on user selection
- Created Non-SSO and SSO links for the users to access the dashboard.
Environment: Business Objects XI 4.0/3.1, Info view(Launch Pad), Universe Designer(IDT), Crystal Reports, Publication Wizard, Import Wizard, Dashboard Manager,Xcelsius dashboards,SAP-BW 3.5, Teradata 13.0, Dashboards 4.0,SAP HANA1.00.69
Confidential, Atlanta, GA
Business Objects Developer
Responsibilities:
- Interacted with the End Users, Business Analysts and responsible for Involved in training sessions to impart knowledge on designed universes and published reports.
- Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
- Worked resolving the loops in universes using Aliases and Contexts.
- Upgraded Business Objects universes and reports from version XI 3.1 to 4.0.
- Involved in testing the reports while migrating from XI 3.1 to 4.0.
- CreatedWebIreports with multiple data providers and synchronized the data usingMerge Dimensions.
- Developed WebI Reports as per the business requirements.
- DevelopedWebI Reports(on demand,AdHoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-Down, Cross-Tab).
- Worked on various Business Object Reporting functionalities such as Slice and Dice, Master/detail, User Response function and different Formulas.
- Installed, Troubleshoot, upgraded and maintained the various Business Objects.
- Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
- Updating databases, systems and business intelligence tools.
- Created Dashboard using SAP Business ObjectsXcelcius Dashboard and MS Excel.
- Created graphs/charts for the reports, Created Master Detail and Cross Tab Reports.
- Responsible for writing the SQL queries for the data validation and testing the reports.
- Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.
Environment: Business Objects XI 4.0/3.1, Web Intelligence 2.x/6 and Info view, Universe Designer, Crystal Reports, Publication Wizard, Import Wizard,Xcelsius Dashboard, Dashboard Manager,SAP BW 3.5, IBM Netezza 5.x,Attensity 360,Lithum.
Confidential, FL
Business Objects Developer
Responsibilities
- Involved in interacting with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
- Was responsible to see the scalability and security provided in distributing important reports to higher managerial level.
- Analyze operational performance and make configuration adjustments as necessary.
- Resolved loops, Chasm and Fan Traps using Contexts and aliases in Universe Designer.
- Created Ad-hoc reports using BO functionalities like Master Detail, Formulas, Alerts, Slice and Dice, Drill Down and @ Functions.
- Updated the Universe as per the changes of the Database table structure and notified the users about changes made to the Universe.
- Responsible to support the issues with reports on the BO environments (Development, UAT, Test and Production).
- Develop and implement test scripts for evaluating service packs and future releases
- Created Dashboards using SAP Business objectsXcelciusDashboards.
- Evaluate and design web services access points for data access in multiple and dynamic user interfaces.
- Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects XI connected to Oracle data source.
- Set up groups and users for Business Objects deployment in CMC.
- Developed WebI Reports as per the business requirements
- Developed Report Mock-up samples before User interaction to analyze the business requirements.
- When the source tables are very huge, developed PL/SQL procedures using Oracle to load the data into fact tables and used them in the universe.
Environment: Business Objects XI 3.1, Web Intelligence 2.x/6 and Info view, Universe Designer, Crystal Reports, Publication Wizard, Import Wizard,Xcelsius Dashboard, Dashboard Manager, Data Mining, Unix shell script, Oracle 10g/9i.
Confidential - Myers Squibb, NJ
Business Objects Developer
Responsibilities
- Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
- Worked with End-To-End implementation with Data warehousing team and Implemented Star- Schema, Snow-Flake Schema.
- Linked two universes Sales and Patients using kernel approach.
- Created multiple universes and resolved Loops by creating table aliases and contexts to remove cyclic dependencies.
- Setup hierarchies in the Universe for providing drill down options in the reporting environment to accurately assess the effort Vs the results of clinical activities
- Created reports on development data to test the functionality of universes with a group of power users.
- Created graphs/charts for the reports, created Master Detail and Cross Tab Reports to provide a transformational approach to the way staff members and clinicians access and report on data.
- Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
- Scheduled reports to business users and owners using Broadcast Agent.
- Created Dashboards using Crystal X-Celsius for senior management for business decision making.
- Performed Server Management Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
- Created Users, User groups and assigned privileges to access and work with Universes and Reports.
- Worked on Crystal Reports reporting system including Crystal Server reports distribution infrastructure.
Environment: Business Objects XI 3.1, Designer, Web Intelligence and Info View, Windows XP, server 2003, Oracle 10g, Informatics Power Builder 8.6, Erwin Tool
Confidential, Westwood MA
BO Universe/Report Developer
Responsibilities
- Developed Complex, Logical and Physical Data Models, using Erwin Tool.
- Designed/Modified the Universes as per the requirements adding new classes and objects as required.
- Used derived tables to create the universe for best performance, and use context and alias tables to solve the loops and traps in the Universe.
- Migrated & upgraded Business Objects from 6.5.1 to XIR2.
- Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
- Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL.
- Worked on complex Crystal Reports that require running totals, sub-totals, sub-reports, prompts, cross-tab, multiple groups, hierarchical grouping and conditional display of groups, fields, and messages.
- Written free hand SQL queries using Oracle database and defined full client reports and webI.
- Created reports on web using Info View Portal and published the reports into info view for different groups and users.
- Extensively used calculations, variables, drill down, slice and dice, alerts in the creation of reports.
- Created users and user groups, restricted access of the users as needed using Central Management Console. Involved in managing users, groups, folders and published reports using central management console.
- Expertise in writing and implementation of the packages, triggers, functions, views, materialized views and indexes using SQL.
- Prepared ad hoc supporting documentation for senior financial management.
- Exported reports into various formats like PDF, HTML, EXCEL and WORD for end users.
Environment: Business Objects XIR2/6.5/6.1,Data Integrator, Dashboard Manager, XCelsius, Web I 6.1, DESKI, JSP, SQL, PL/SQL, Erwin, SQL*Loader, UNIX Shell Script, Windows 2000/NT, ORACLE, PL/SQL, SQL Enterprise Manager.
Confidential
ETL/Report Developer
Responsibilities
- Used Informatica Power Center for extraction, transformation and loading (ETL) of data in to data warehouse.
- Implemented logical and physical data modeling with STAR and SNOWFLAKE techniques in Data warehouse as well as in Data Marts.
- Worked on different data sources such as Oracle, SQL Server, XML, MS Access.
- Developed Complex WebI reports with data across different tabs for the daily, MTD, STD, YTD sales.
- Designed reports by using different functionalities like drill down, using calculations with variables, comparing with previous year data to get change % etc.
- Exported Reports to Excel based on User requirements.
- Worked with a Team to develop a complex universe and generated reports exclusively using Full client.
- Developed user friendly Universes using Business Objects Designer for various business needs.
- Created the reports using Universes as the main data provider.
- Worked on resolving some of the WebI issues which users had faced
- Created and modified Universe by using @functions, Short-cut joins, Hierarchies and wrote custom SQL in derived tables.
- Used Informatica Designer tools to design warehouse using source definition, target definition and transformations.
- Worked on adhoc reports according to user requirements like Deals, Tactical Initiatives, Strategic Initiatives using thin client.
- Documented all the changes made to the Universes and Reports for future references.
Environment: Business Objects 5.1.2, Informatica 5.1/6.x, Broadcast Agent Server (BCA), Oracle 8i & Windows 2000.