Summary

• Experienced in Migration from lower to higher versions of Business Objects.
• Involved in Scheduling and publishing reports in Business Objects Enterprise Environment.
• Hands on in BO Admin. Created and maintained user security groups in CMC.
• Used Import Wizard and Promotion management tool for promoting the reports and universes into different environments
• Designed and maintained security objects such as Users, User groups, permission and access rights through Supervisor/CMC.
• Created complex reports by linking data from multiple sources, using functionalities like Combined Queries, Slice and Dice, Drill Down, Master Detail, etc.
• Experience in developing canned / ad-hoc reports and fine tuning reports using variables calculation, multilevel breaks, sections, alerter etc.
• Involved in creating universes, designing and maintaining various reports using Business Objects 6.5 and XI R2/XI R3.1/4.1, Crystal Reports
• Expertise in Implementation and Support using Business Objects 6.x/XIR2, BOXI 3.1, 4.1 in Data Warehousing environment in various projects like Development, Production Support and Migration.
• Experience in Data warehousing technologies and methodologies, with in-depth Professional development experience in tools like Business Objects 4.1, BO XI R2, BOXI 3.1 Crystal Reports 10, Business Objects Designer, Information Design Tool IDT, Web Intelligence, Oracle 8i, 9i, 10/11g.
• Over 9 years of experience in IT industry with expertise in Data warehousing and Business Intelligence.
• Created and maintained universe using Information design tool IDT.
• Extensive experience in writing system specifications, translating Business User requirements to technical specifications.
• Worked in Project using Agile and Scrum Methodology.
• Worked in End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse DW concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models.
• Exposure to Data Modeling, Normalization, and Business process Analysis, Reengineering and Logical Physical database designs.
• Expertise in tuning the performance of reports using oracle hints,strong SQL and PL/SQL coding background
• Strong background in Data Warehousing, Software Development, Change Management and Scheduling
• Experienced in working with Business Managers, Analysts, End users and all the stake holders in documenting requirements, creating High and Detail Level design specification
• Expertise in business analysis, data analysis and end user training
• Team-Oriented and focused on delivering user needs in a timely and efficient manner and desire to excel.

Technical Skills

Professional Experience:

Confidential

Sr. Business Objects Developer

Responsibilities:

• Involved in functional requirements gathering, meeting different Business Groups and preparing the Technical Specifications.
• Involved in Migrating Business Objects system from version XIR2 to Business Objects XI 3.1, 4.1
• Migrated Users, Universes, Connections, Web Intelligence Reports from the version XIR2 to XI 3.1, 4.1.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Created and maintained universe using Information design tool IDT for business modules and reporting needs.
• Maintenance and enhancement to existing universe and on boarding new tables by creating contexts.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Master Detail etc.
• Generated reports by using Stored procedures and generated Parameterized, Drill down reports.
• Created report templates, developed Ad-hoc reports, complex reports from multiple data sources, raking reports.
• Involved in creating user roles, security access, server administration, password management using the Central Management Console CMC .
• Created Web Intelligennce reports and used hyper linking concept to link other WebI documents.
• Scheduling and monitoring of reports for daily and monthly data load process.
• Developed reports using these new functionalities Delegated Search, Smart Measures Database Delegated , Input Controls, Drop Down filters, Data Tracking and others.
• Generated reports using free-hand SQL as a data provider.
• Responsible for Migrating the Business Objects Universes/Reports across the servers / Repositories Development to Production Servers using EQM and LCM.
• Applied row level and object level securities to different groups and users using Designer.
• Designed and maintained security objects such as Users, User groups, permission and access rights through Supervisor/CMC.
• Improving performance of reports and queries by using Oracle database hints and restructuring queries.
• Involved in Unit testing, System testing and User Acceptance Testing of Reports throughout the migration process.
• Resolving user queries and data quality issues.
• Responsible for the quality of delivery and coding standards.

Environments: Business Objects XIR3,4.1 Universe designer, Web Intelligence, SQL,PL/SQL, Windows

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Involved in the designing and Building of Universes for new Components.
• Involved in creating Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.
• Modified the existing Universes according to the Specifications, which were from different data sources like Oracle/SQL Server/SAP BW.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc to develop the reports.
• Created reports using multiple data providers such as Universes and personal data files in generating reports. Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Validating and Verifying Universes and Reports created by the Off Shore team and making the necessary changes if needed.

Environments: Business Objects XIR2, Xcelsius 2008, SQL/ PLSQL, Windows.

Confidential

Sr. Business Objects Consultant

Responsibilities:

• Deployment of Reports via various methodologies Central Management Console CMC , Publishing Wizard, Infoview, Import Wizard.
• Tested resolved loops and contexts to ensure the correct results from the query.
• Developed PL/SQL stored procedures to process and store the information in the oracle database.
• Developed and modified various database objects like Views to improve performance of reports.
• Implemented various functionalities like Ranking, Filters, and Alert's to restrict the unwanted data and highlight the required data.
• Created graphical representation of reports such as Bar charts, Pie charts etc as per the end-user requirements.
• Created and tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.
• Involved in designing, developing and testing the universe for report generation.
• Responsible for requirements gathering and writing specifications.
• Involved in Migrating Business Objects system from version 6.5 to Business Objects XI R2.
• Involved in Writing Detailed Level Documentation for reports and Universe design
• Involved in creating user roles, security access, server administration, password management using the Central Management Console CMC .
• Responsible for Migrating the Business Objects Universes/Reports across the servers / Repositories Development to Production Servers .
• Attend sprint meeting every fortnight with business to gather the requirement monitor and plan the execution of enhancement / Support activities

Environments: BO 6.5, XIR2, SQL, Windows.

Confidential

Business Objects Developer

Responsibilities:

• Created Report templates, Summary Reports, Parameterized Reports and Cross-tab reports.
• Used Groups, formulas, running totals and summaries in the reports.
• Building Relationships between different tables according to requirements in database expert.
• Resolved the Performance issues/Data issues with Reports and Procedures.
• Worked with different universes and used linking of different universes.
• Implemented different level of hierarchies for drill down reports.
• Analyzed Data using Slice and Dice and Drill Mode etc and formatting Reports.
• Automated document Scheduling, Publishing and Distribution for Web I and Info view clients, using the Broadcast Agent.
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc.
• Used various Functions like Prompt, Where, and Select.
• Created customized existing reports using cross-tab reports, sub-reports and charts to present information
• Exported Reports into PDF and Excel from Enterprise and resolved formatting issues.

Environments: BO XIR2, Crystal Reports 10, SQL, PL/SQL, Windows and Solaris.

Confidential

SQL, Reports Developer

Responsibilities:

• Created Business requirements documents for the modifications required for the reports and Universe, which included testing strategy, Business Objects fix and Business requirements etc.
• Generated Deski reports.
• Prepared program documentation.
• Training users for ad hoc reporting.
• Performed unit and integration testing of reports.

Environments: BO 6.5, Crystal Reports, SQL, Window